thibautg 4 hours ago | parent | next [-]

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...

	▲	pramsey an hour ago \| parent [-]
		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.

▲

Zambyte 4 hours ago | parent | prev [-]

Also https://github.com/timescale/timescaledb

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

	▲	pramsey an hour ago \| parent [-]
		MobilityDB might also be of interest, for people handling trajectories.