Hi ! If you need just read small region, you can try to use my library for that: http://forum.openstreetmap.org/viewtopic.php?id=27038 It works with local files only. No need to setup PostgreSQL/PostGIS.
WBR, Alex. On 10 November 2014 02:46, Pulkit Bhuwalka <[email protected]> wrote: > > Hello, > > My goal is to create my own local database of OSM data and use it for fast > querying (no writes) - so that I can ask things like "give me all the roads > within a small bounding box" etc. > > I got a sense from the component overview > <http://wiki.openstreetmap.org/wiki/Component_overview> that data should > be imported into a PostGIS data for quick querying. So as of now, I have > managed to > > 1. Download bulk data from OSM using API (This is a small region) > 2. Setup Postgres with PostGIS extension. > 3. Import data into PostGIS database using osm2pgsql > > I am not sure about the next step. What api should I use to query the > database? I suppose there exists some data access API which Mapnik and > other services use for drawing. > > Also, I don't quite understand the DB structure and the data encoding > within it. There are a few tables created by PostGIS (spatial_ref_sys etc.) > and a few tables created by OSM (planet_osm_*). I am unsure about the > relation between these tables. > > I recently also stumbled upon the Overpass API > <http://wiki.openstreetmap.org/wiki/Overpass_API> which seems to do > something similar. My requirements are actually pretty simple. I need some > simple querying to experiment with some rendering of my own. > > Any help is really appreciated. Thanks a lot for your help and OSM! > > Best, > Pulkit > > > _______________________________________________ > dev mailing list > [email protected] > https://lists.openstreetmap.org/listinfo/dev > >
_______________________________________________ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev
