0

I have several KML files and each KML is being parsed, turned into a geometry with PostGIS' ST_GeomFromKML() and saved to a database. This database is parsed and uses ST_AsPng() to process each geometry at a specific zoom level and saves the PNGs locally. The problem is that each zoom level has to be done individually and each zoom level takes a long time. It takes specially long since its querying the database.

Any idea on how to speed this process up?

As of now, to generate the PNG tiles I'm using Java with multiple threads doing queries for ST_asPng().

Improve this question
3
  • Have you thought about using GeoTools to render the tiles directly with out using PostGIS - or even easier using GeoServer to do all the hard work automatically
    – Ian Turton
    Commented Aug 3, 2021 at 8:03
  • @IanTurton Would I be able to extract all the Polygons directly from the KML file using GeoTools?
    – steepcurve
    Commented Aug 5, 2021 at 4:34
  • of course, and style them and draw directly to a PNG
    – Ian Turton
    Commented Aug 5, 2021 at 7:12

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.