News for hackers. Stuff that matters.
Re:How to Make Maps Using Leaflet.js, PostGIS and Chicago Op... by durkie on Tuesday April 30, 2019 @08:43AM (#19787382)
for what it's worth, ST_AsGeoJSON lets you specify decimal precision as an optional argument, so you at least don't have to write a truncating loop.

Another good option with many polygon geometries is Base64 encoding the output of ST_AsGeobuf -- it is many times smaller than GeoJSON and still pretty easy to handle from Javascript. (Needs libprotobuf-c on the PostGIS side and geobuf.js+pbf.js on the JS side)

Re:How to Make Maps Using Leaflet.js, PostGIS and Chicago Op... by Demiurge on Tuesday April 30, 2019 @09:24AM (#19787654)
Thats cool, I should try AsGeobuf as a soft upgrade to one of the older tile GeoJSON site :)