|
Hi, I am trying to create a database with cities and their streets. Could you write down the best way to do that? Unfortunately a lot of the questions are quite confusing. (I already have my country's osm data.) Thanks! |
|
I suspect, given that you seem to be rather stuck early on, that your best approach is to use an "off the shelf" solution in the form of an osm2pgsql schema database and import your country data in to that. That will provide you with the geometries of all the streets and administrative borders (if available in your country) which you can then use however you wish. See https://switch2osm.org/serving-tiles/ (while these are instructions for a tile server, you can naturally use the data in the DB any way you see fit). Okay, I have it in my database, I used osm2pgsql and opened my database in pgAndmin4. But I just cannot find the connection between the cities and the streets. I have my tables, planet_osm_line, planet_osm_nodes, etc. I can see that a street contains nodes, and from the nodes I will get the coordinates. As a result I would need just a csv file or something like that.
(24 May '17, 15:15)
mutantChipmunk1
|
I think you need to clarify this: do you want a listing of all street names by each city? By city do you mean large cities or any centre of population? Do you just want streets in urban areas or are rural roads OK too?
Yes, you are right. So i will try to specify my project. Actually I would like to keep all data from the roads file. If a street or road is in a city I would want to connect them somehow in my database. Here is my proplem, I cant seem to find the relation between the streets/roads and the cities in the downloaded file. And I will be needing the GPS coordinates of the element in the roads file, I already know that I need the points of the roads to do so. (I would like to visualize a streetmap.) Thank you for your help!