|
I finally managed to import the data from an OSM file to a PostgreSQL database :).
showing 5 of 6
show 1 more comments
|
|
Take the data as raw .osm file or .pbf file and try Osmconvert. There is recentry introduced option to export all elements with tag colums that you can define how you need it as CSV file (comma separated value. try osmconvert --help on a command line and read more instructions in detail. At least you should add columns for the tags "highway" and "name". If you got your csv file like you need, you can load it in any spreadsheet program like libreoffice calc or similar. Sort the whole table for the column "name" and delete all doublettes. Thus you get all road names of your area. |
What tool did you use to produce the PostgreSQL database?
I used osm2pgsql
Alexandru: How do you define that all your OSM objects in your database really belong to the city you want?
Do you have a boundary polygon that you used to do a clipping with osmosis or similar?
Or is it enough to describe the elements you want to process via a boundingbox?
I downloaded the OSM file only for a city from here: http://downloads.cloudmade.com/. My question was about generating a list with some details, so please, let's focus on my question and stop answering me with other qwestions :)
stephan75 asked the right question as currently you would get addresses not only for your city but also for surrounding area.
Ok, that would not be a problem :). So, anyone cand help me? :D