<div dir="ltr">Hi all,<div><br></div><div>SRIDs over 999000 are reserved built in values as defined in [1]. They reference different UTM grid zones.</div><div><br></div><div>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...).</div><div><br></div><div>1 - <a href="https://github.com/postgis/postgis/blob/372095d9ae9090400e81167097ed0d9d836c0a7a/libpgcommon/lwgeom_transform.h#L64">https://github.com/postgis/postgis/blob/372095d9ae9090400e81167097ed0d9d836c0a7a/libpgcommon/lwgeom_transform.h#L64</a></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Oct 2, 2020 at 3:17 PM Imre Samu <<a href="mailto:pella.samu@gmail.com">pella.samu@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>>> PostGIS references SRID 999155.<br>> That feels like a bug. File and line number?<br></div><div><br></div><div>As I see the "not public" _ST_BestSRID return this.</div><div><br></div><div>select _ST_BestSRID(ST_Point(147,-60));<br></div><div> _st_bestsrid <br>--------------<br> 999155<br>(1 row)<br><br></div><div>( via <a href="https://github.com/postgis/postgis/search?q=999155" target="_blank">https://github.com/postgis/postgis/search?q=999155</a> )</div><div><br></div><div>Imre<br></div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Greg Troxel <<a href="mailto:gdt@lexort.com" target="_blank">gdt@lexort.com</a>> ezt írta (időpont: 2020. okt. 2., P, 13:22):<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br>
Simon G Greener <<a href="mailto:simon@spatialdbadvisor.com" target="_blank">simon@spatialdbadvisor.com</a>> writes:<br>
<br>
><br>
> PostGIS references SRID 999155.<br>
<br>
That feels like a bug. File and line number?<br>
<br>
> What is it? It is not listed on <a href="http://reference.org" rel="noreferrer" target="_blank">reference.org</a>.<br>
<br>
I find no trace of it.<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature">Raúl Marín Rodríguez<br><a href="http://carto.com" target="_blank">carto.com</a></div>