I have a Postgres database with a field bounds that contains an RGEO Multipolygon datatype and bounds_geojson which is simply the geojson equivalent of the bounds field. I downloaded Windshaft and played around with their tutorial to get an idea of how to convert my Postgres data into map tile layers that I can use with Leaflet. I got the tutorial running but am now running into problems trying to figure out exactly what kind of SQL query to make with Windshaft to get the data from Postgres out. I researched the ST_AsRaster function that the tutorials utilize but was unable to figure out how to tweak the query to match my needs. The SRID of the bounds field is 4326. I have already been able to send the geojson data directly to leaflet and add them as svg layers, but I want them as tiles instead (as I have some very large shapefiles). Any help would be appreciated, even just directing me to a resource on how to build the necessary SQL queries. I spent hours going through the Windshaft and Mapnik node documentation but was unable to find what I am looking for, much of it was over my head and I just need a good starting place. Thank you!
أكثر...
أكثر...