[OSM-newbies] SQL to extract bounding box from OSM Database
Matthew Wechsler
maw269 at gmail.com
Tue Mar 6 20:09:43 GMT 2012
I have a full OSM planet database import that I use for rendering Mapnik
tiles. I would like to use a bounding box to extract a geographic region
from the database to be used in rendering on a different server. Does
anyone know the SQL statement I could use to extract the BB info from all
the tables into a different DB?
I have tried to use osm2pgsql to go the other way and use the BB to import
data into another DB but have lately been running into memory issues on the
import (even though I'm using --slim mode). I am using Windows so I am only
able to use the old osm2pgsql binary that has been created a few years ago.
Thanks,
Matt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/newbies/attachments/20120306/3c2dfba2/attachment.html>
More information about the newbies
mailing list