NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

hello, i am kumar completely new to open street map database, i am working with data bases as of my first task is i need to create a node table which includes node id, lat and long values , so i did this step.... and now i want create a new table with information of street id and node id.

here my question is what is street id?? can any one help me please

best regards

asked 01 Oct '15, 14:33

kumar45's gravatar image

kumar45
11223
accept rate: 0%

edited 01 Oct '15, 18:35

aseerel4c26's gravatar image

aseerel4c26 ♦
32.6k18248554


The other answer is perfect.

On a topic I mistook it for when first read the title. At least few {so far} streets carry a NPLG:USRN tags which are street referance numbers used in the UK based on the National Property and Land Gazetter system. Although not common to the public they are used with streetworks applications and permits like digging to lay pipes and cables. Some sites realsed details of these to the public so some were annotated to streets on OSM were applicable. Similar things are happening for UPRN in addressing at a few places too. UPRN being for properties from flats to factory sites can somtiemes been seen on labels like on bins when your surveying. UARN's I don't think have been added to OSM yet [Universal Address Referance Number]. Some OSM data users compile address lists so these come in useful.

permanent link

answered 01 Oct '15, 20:59

Govanus's gravatar image

Govanus
1543711
accept rate: 3%

We do not have street IDs, we have way IDs. A way can represent a part of a street, a whole street, or another linear or polygonal feature, and consists of a sequence of nodes that describe the geometry as well of a set of tags that describe its properties.

Even though OSM data can be represented in many formats, the Wiki page on OSM XML should give you a good idea of how data is organised in OSM.

permanent link

answered 01 Oct '15, 15:00

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273
accept rate: 23%

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:

×205
×165
×142
×134
×55

question asked: 01 Oct '15, 14:33

question was seen: 5,419 times

last updated: 01 Oct '15, 20:59

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum