[OSM-dev] Fastest way to extract a bounding box

[marqqs at gmx.eu]

> What I would like to know is if there's a significantly faster way to do 
> that.

"That depends..." ;-)

Which option do you need? Do you need relations? Do you need relations which have relations as members which have ways which have nodes inside the box?

Example: There is a bus line which crosses the bbox. This and other bus lines have the same operator which is represented by a relations. Do you need this information? Do you need the bus line?

What is to be done with ways which have some nodes inside the bbox and some nodes outside of it? Shall these ways be included? Or excluded? If included, what to do with the nodes? What do do with the noderefs, if some of the nodes are not included because they are outside the bbox?

Sorry to bother you with these Questions... but there are a lot of ways to extract a bounding box, and the time you need depends on the option you want use.

Markus

-------- Original-Nachricht --------
> Datum: Wed, 01 Jun 2011 18:22:12 +0200
> Von: Benjamin Meier <b.meierr at googlemail.com>
> An: dev at openstreetmap.org
> Betreff: [OSM-dev] Fastest way to extract a bounding box

> Hi,
> 
> I'm looking for the fastest way to extract a bounding box from osm-data.
> The intention is to get a section (a square of about 5km * 5km)
> around a user's current position in a few seconds.
> 
> The input-data shall be of the size "germany", "central-europe" or even
> the whole planet.
> 
> Up to now I made some experiments with unsatisfying results.
> 
> I extracted such a bounding-box from "germany.osm.pbf" with osmosis in
> about
> 110 seconds. After that I installed a Postgis/Postgresql-DB, filled it 
> with the
> pbf-file (as described in the wiki: 
> http://wiki.openstreetmap.org/wiki/Osmosis_PostGIS_Setup)
> and extracted the bounding-box with osmosis from the DB in about 53
> seconds.
> 
> The hardware is a core2duo e7400 with 2GB RAM.
> 
> What I would like to know is if there's a significantly faster way to do 
> that.
> 
> Thanks,
> Benjamin
> 
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev