Skip to main content

All Questions

Filter by
Sorted by
Tagged with
2 votes
2 answers
1k views

PostGIS SQL syntax for bounding box

I have the following query: SELECT row_to_json(fc) FROM ( SELECT ST_AsGeoJSON(lg.geometry)::json As geometry, ( select row_to_json(t) from ( ...
knutole's user avatar
  • 815
1 vote
2 answers
2k views

Drawing bus routes on OpenStreetMap with mapnik [closed]

I have successfully set up PostgreSQL with PostGIS and MapNik to serve map tiles. The database is populated with data from OpenStreetMap project. I can see that bus routes are in the data-set, but I ...
sposnjak's user avatar
  • 119