[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] What is SRID 999155
From: Paul Norman <penorman () mac ! com>
Date: 2020-10-02 22:29:04
Message-ID: cd19d317-7d06-25c1-55c8-df3d51432b01 () mac ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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 <gdt@lexort.com <mailto:gdt@lexort.com>> ezt írta
> (időpont: 2020. okt. 2., P, 13:22):
>
>
> Simon G Greener <simon@spatialdbadvisor.com
> <mailto:simon@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
> <http://reference.org>.
>
> I find no trace of it.
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
[Attachment #5 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>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
<a class="moz-txt-link-freetext" \
href="https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/libpgcommon/lwgeom \
_transform.h">https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/libpgcommon/lwgeom_transform.h</a>
and the proj4 text is in
<a class="moz-txt-link-freetext" \
href="https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/libpgcommon/lwgeom \
_transform.c">https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/libpgcommon/lwgeom_transform.c</a>.</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 2020-10-02 6:17 a.m., Imre Samu
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAJnEWwm88aW41Ze06H5nH3QRRsWVUD1jbf_59TVf32C0CkUMzg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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"
moz-do-not-send="true">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" \
moz-do-not-send="true">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"
moz-do-not-send="true">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"
moz-do-not-send="true">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"
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank" \
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" \
wrap="">_______________________________________________ postgis-users mailing list
<a class="moz-txt-link-abbreviated" \
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a> <a \
class="moz-txt-link-freetext" \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
</body>
</html>
[Attachment #6 (text/plain)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic