Use Geography fields when possible

6aika / issue-reporting

Reference Open311 API server implementation

MIT License

7 stars 4 forks source link

Use Geography fields when possible #16

Closed akx closed 8 years ago

akx commented 8 years ago

Based on initial EXPLAIN investigations, looks like the distance query is not and actually can not be optimized using PostGIS when the geometry field is in SRID 4326 (i.e. WGS84).

If there was a geometry field that was in a local planar projection that already had its units in meters, then one could use ST_Distance, naturally.

However it's impossible to choose a local planar projection that would fit all use cases and locations, I think...

akx commented 8 years ago

So yeah, it was discussed on Slack that we'll use the geography fields where possible for optimization.

akx commented 8 years ago

Geography fields are in use via #54, closing.