[postgis-users] What is SRID 999155

rmrodriguez at carto.com rmrodriguez at carto.com
Fri Oct 2 07:20:07 PDT 2020


Hi all,

SRIDs over 999000 are reserved built in values as defined in [1]. They
reference different UTM grid zones.

As far as I know they are only generated by the _ST_BestSRID function,
which in turn is used to improve precision when doing operations over
geographies (buffer, intersections...).

1 -
https://github.com/postgis/postgis/blob/372095d9ae9090400e81167097ed0d9d836c0a7a/libpgcommon/lwgeom_transform.h#L64

On Fri, Oct 2, 2020 at 3:17 PM Imre Samu <pella.samu at gmail.com> 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 <gdt at lexort.com> ezt írta (időpont: 2020. okt. 2., P, 13:22):
>
>>
>> Simon G Greener <simon at spatialdbadvisor.com> writes:
>>
>> >
>> > PostGIS references SRID 999155.
>>
>> That feels like a bug.  File and line number?
>>
>> > What is it? It is not listed on reference.org.
>>
>> I find no trace of it.
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users



-- 
Raúl Marín Rodríguez
carto.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20201002/907c422e/attachment.html>


More information about the postgis-users mailing list