Hacker News new | ask | show | jobs
by michaeljhg 37 days ago
Also https://postgis.net/
2 comments
thibautg 37 days ago
And 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-postg...

link
pramsey 37 days ago
At 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.
link
steve-chavez 37 days ago
Many 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/f1d0e8ea2266077d...

[2]: PostGIS has https://postgis.net/docs/AsTopoJSON.html but it doesn't take a record.

link
Zambyte 37 days ago
Also https://github.com/timescale/timescaledb

I've found it very useful for storing geospatial data over time.

link
pramsey 37 days ago
MobilityDB might also be of interest, for people handling trajectories.
link