[postgis-users] Geography/geometry

Darafei "Komяpa" Praliaskouski me at komzpa.net
Mon Jan 21 13:20:33 PST 2019

If someone is willing, there is an old Geography Overlays patch that needs
lots of love: https://github.com/postgis/postgis/pull/191

On Tue, Jan 22, 2019 at 12:13 AM Paul Ramsey <pramsey at cleverelephant.ca>

> > On Jan 21, 2019, at 1:00 PM, Simon Greener <simon at spatialdbadvisor.com>
> wrote:
> >
> > When a geography is casted to geometry for use in the aggregate form of
> ST_Union (or other commands such as ST_Within) is the processing done
> assuming the data is projected even when geodetic?
> All processing of geometry make cartesian assumptions. Processing of
> geography using geography native functions (no casting required) makes
> spherical assumptions. When you case from geography::geometry you are
> telling the database “please process this data using cartesian
> assumptions”. Do we support spherical processing for all (or even many)
> kinds of operations? No we do not. That’s hard. Could we in the future?
> Sure, it might happen.
> ATB,
> P
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

Darafei Praliaskouski
Support me: http://patreon.com/komzpa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190122/b2ba09cd/attachment.html>

More information about the postgis-users mailing list