6 ms·
Also https://postgis.net/ https://postgis.net/
by michaeljhg 4mo ago
Also https://postgis.net/ https://postgis.net/
- thibautg 4mo agoAnd with PostgREST [0], you can automatically convert any PostGIS table (with geometry or geography column) to GeoJSON by using an "Accept: application/geo+json" header in the request. [0] https://docs.postgrest.org/en/v14/how-tos/working-with-postgresql-data-types.html#postgis https://docs.postgrest.org/en/v14/how-tos/working-with-postg...
- pramsey 4mo agoAt the SQL level, the ST_AsGeoJSON(record) variant will convert a tuple that includes a geometry and any combination of other columns into a GeoJSON output.
- steve-chavez 4mo agoMany thanks for your work pramsey. We use that exact function [1], do you have any plans for a similar function for TopoJSON? One that also has a record parameter? [2]. [1]: https://github.com/PostgREST/postgrest/blob/f1d0e8ea2266077d2b57144927dea08bd8f74579/src/PostgREST/Query/SqlFragment.hs#L224 https://github.com/PostgREST/postgrest/blob/f1d0e8ea2266077d... [2]: PostGIS has https://postgis.net/docs/AsTopoJSON.html https://postgis.net/docs/AsTopoJSON.html but it doesn't take a record.
- Zambyte 4mo agoAlso https://github.com/timescale/timescaledb https://github.com/timescale/timescaledb I've found it very useful for storing geospatial data over time.
- pramsey 4mo agoMobilityDB might also be of interest, for people handling trajectories.