Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

It never seems worth the effort in my testing, as you have to come up with your own loop to do the truncating, and the benefit is marginal. In this case he’d have 1.2gb file, I doubt that fixes the problem.


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)


Thats cool, I should try AsGeobuf as a soft upgrade to one of the older tile GeoJSON site :)




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: