4 ms·

Reduce the precision, 15 decimal places are useful for picometers, not a web map. Try 5-6.

• Demiurge 7y ago
  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.
  • durkie 7y ago
    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)
    • Demiurge 7y ago
      Thats cool, I should try AsGeobuf as a soft upgrade to one of the older tile GeoJSON site :)