SRIDs above 999000 are reserved by PostGIS. The main use I've seen for them is with _ST_BestSRID as part of area or length calculations. Most of them are equivalent to EPSG codes that are normally in spatial_ref_sys. For example, 999000 is equivalent to EPSG:3395, but the latter may not be present on a system. You can see what they are in https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/libpgcommon/lwgeom_transform.h and the proj4 text is in https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/libpgcommon/lwgeom_transform.c.

On 2020-10-02 6:17 a.m., Imre Samu wrote:
>> PostGIS references SRID 999155.
> That feels like a bug.  File and line number?

As I see the "not public"  _ST_BestSRID  return this.

select _ST_BestSRID(ST_Point(147,-60));
 _st_bestsrid
--------------
       999155
(1 row)

( via https://github.com/postgis/postgis/search?q=999155 )

Imre



Greg Troxel <[email protected] <mailto:[email protected]>> ezt írta (időpont: 2020. okt. 2., P, 13:22):


    Simon G Greener <[email protected]
    <mailto:[email protected]>> writes:

    >
    > PostGIS references SRID 999155.

    That feels like a bug.  File and line number?

    > What is it? It is not listed on reference.org
    <http://reference.org>.

    I find no trace of it.
    _______________________________________________
    postgis-users mailing list
    [email protected] <mailto:[email protected]>
    https://lists.osgeo.org/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users

Reply via email to