Getting street names

Question

Hi everyone.

How can I get street names from planet_osm_line? I use this query to get:

select planet_osm_line.name fromn planet_osm_line where (highway='living_street' or highway='motorway' or highway='primary' or highway='proposed' or highway='raceway' or highway='residential' or highway='road' or highway='secondary' or highway='tertiary' or highway='track' or highway='trunk' or highway='unclassified' or route='road') and LENGTH(Name)>5 group by planet_osm_line.name;

So I got really few names - about 1-2 thousands, but streets rows are about 400 000, that's are more real (where are other names?)

Answer 1

Your query misses some street types that might well have names (e.g. service, cycleway). Other types in your query (motorway, trunk) often don't have names at all, just "ref" numbers. Also, there are places where even residential roads aren't named in OSM because they have been traced from aerial imagery and those who did the tracing lacked the local knowledge to add names.

What is the exact query that you executed (the one quoted in your question is not valid SQL), and on what data set? The number of all rows in planet_osm_lines matching your criteria is about 17.5 million on a current (March 2012) planet database.

Getting street names

Follow this question

Related questions