Hello,

I am using OSM for my project, I have downloaded data from http://download.geofabrik.de/ in the OSM file and imported the data in POSTGIS, In the planet_osm_roads, I am not able to see any key realted to lanes.

Can you please help me get the information about the number of lanes from OSM?

asked 15 May, 18:54

gautamshahi's gravatar image

gautamshahi
11112
accept rate: 0%


By default osm2pgsql will not create a "lanes" column. You can either provide a modified .style file that contains the "lanes" attribute when running osm2pgsl (with the -S option), or you can run osm2pgsql with the --hstore option which will result in a "tags" column that has all tags that don't have extra columns to themselves. You will then be able to access the lanes tag with the syntax tags->'lanes' in your SQL query.

Of course, less than 10% of all highway objects in OSM have a lane tag so you won't find it everywhere.

permanent link

answered 15 May, 21:07

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
71.3k846451113
accept rate: 24%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×551
×213
×122

question asked: 15 May, 18:54

question was seen: 322 times

last updated: 15 May, 21:07

powered by OSQA