PostGIS -> Raster Web Map Tiles (XYZ) Recommendations?

[Ryan Hodges]

Hi all,

I have a PostGIS table with (potentially) hundreds of thousands of features. I'd like to find a tool that would allow me to query a subset of those features (say 10k or so) and render those to web map tiles and serve them via them as a XYZ end point (or really .../z/x/y) to pull them into an OpenLayers front end. Ideally something light-weight with few dependencies -- some cartography options would be nice (like mapnik support) but we're not looking to do anything fancy.

Anything coming to mind?

P.S.: I'm all good on HVAC service recommendations, though I appreciate everyone's interest in maintaining healthy indoor air quality!

[Anthony Lukach]

DevelopmentSeed has tipg (https://developmentseed.org/tipg/) which is part of the greater eoAPI suite (https://eoapi.dev/):

tipg, pronounced T[ee]pg, is a Python package that helps create lightweight OGC Features and Tiles API with a PostGIS Database backend.

That may do the trick for your needs?

--
You received this message because you are subscribed to the Google Groups "PDX-OSGEO" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pdx-osgeo+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/pdx-osgeo/2bfab192-5bf9-4fdb-a90c-5f926802a06en%40googlegroups.com.

[Nicholas Romano]

You could also consider martin (https://github.com/maplibre/martin), I found it easy to use in the past.

To view this discussion visit https://groups.google.com/d/msgid/pdx-osgeo/CAJ2BtD7peF40M-L--QuisNJLSxRY4GjuhObQQnoM-%3Dm4_hb4zA%40mail.gmail.com.

[rjsh...@gmail.com]

I was also going to say, we've had good luck with Martin: https://martin.maplibre.org/

You can create a "view" of your PostGIS table, then use Martin to render the tiles on-the-fly as Mapbox Vector Tiles. MVT is available for OpenLayers: https://openlayers.org/en/latest/examples/mapbox-vector-tiles-advanced.html

Best,

RJ Sheperd

rjsh...@gmail.com

To view this discussion visit https://groups.google.com/d/msgid/pdx-osgeo/CADb4NPJndzSoi8fpaCzb%2B1wN624SGVciw2%2B2aDr30CXByq6XCA%40mail.gmail.com.