I'll first start by saying that I'm new to the GIS world. I apologize if this has been posted before but I tried searching a lot and couldn't find the answer. Maybe I'm searching the wrong terms. I am playing around with visualizing some traffic information. I've been using GEOFABRIK to download large data sets for OSM (which I believe is the suggested way of doing it). So I'll download an entire state in the US (like Michigan) in the .osm.pbf format. Next, I use a standard osm2pgsql command to import all the data into a postgres gis db.
All this seems to go fine. Imports run well. I am now trying to run some select statements to check on the data that has been loaded. It seems to me that many of the smaller side streets are missing from this data but are present in the OSM main site. For example, the way/road with Way: Ontario Road (21447015) (http://www.openstreetmap.org/way/21447015) But a query of:
results in 0 rows. I feel like I'm just missing something. Does anyone have any guidance? I seem to be missing a lot of these side roads (which seem to exist on the OSM site). Thanks in advance! asked 29 Mar '16, 15:33 sbryfcz SomeoneElse ♦ |
The "roads" table is a misnomer and should really be called "stuff we likely draw on lower zoom levels".
https://github.com/openstreetmap/osm2pgsql/blob/master/tagtransform.cpp#L38-L54 determines what gets stored in the roads table - residential roads aren't! You will find them in answered 29 Mar '16, 15:44 Frederik Ramm ♦ 1
Thanks a ton. Changed that 1 table name and everything worked perfect.
(31 Mar '16, 22:45)
sbryfcz
|