OVERVIEW OF AVAILABLE TABLES in PostGIS DB 'osm':

POLYGON

LINESTRING

POINT

non-geometric

country

railroad

stations

province

sea

roads

nodes


water

[roads_0..6]



builtup




airports




forest




industrial




park




Note that this data is a simplified version of the data set of the Netherlands as donated by AND Automotive Navigation Data to the Open Street Map project. This generous donation allows OpenStreetMap to import the Navigation Shape format description in the OpenStreetMap Wiki and import the digital maps in the OpenStreetMap, and the digital map to be edited by the OpenStreetMap community under the Creative Commons-Attribution-ShareAlike 2.0 license. Creative Commons License This work is therefore in turn licensed under a Creative Commons Attribution-ShareAlike 2.0 License.
For a better understanding of the data and it's attributes, we've included PDF of the metadata description of the original AND data set.

UP  

TABLE

provinces

Column

format

values

description

id

serial

..

Primary Key

nd_14

integer

1..12

province code (see table)

nd_9

varchar

..

name

remarks

NOTE: only serves as LUT, has no geometry component!

  1. Zeeland

  2. Noord-Brabant

  3. Limburg

  4. Zuid-Holland

  5. Utrecht

  6. Gelderland

  7. Overijssel

  8. Drenthe

  9. Groningen

  10. Flevoland

  11. Friesland

  12. Noord-Holland

UP  

TABLE

country

Column

format

values

description

gid

serial

..

Primary Key

the_geom

ogc:polygon

..

epsg:28992

remarks


UP  

TABLE

sea

Column

format

values

description

gid

serial

..

Primary Key

the_geom

ogc:polygon

..

epsg:28992

remarks


UP  

TABLE

water

Column

format

values

description

gid

serial

..

Primary Key

nd_4

integer

91

Inner seas and huge lakes with major geographical

referential impact



92

Very big river/lake and/or country separating river/lake



94

Province/department separating river/lake



97

Other river/lake

nd_9

varchar

..

name

nd_14

integer

1..12

province code (see table Province)

the_geom

ogc:polygon

..

epsg:28992

remarks


UP  

TABLE

builtup

Column

format

values

description

gid

serial

..

Primary Key

nd_4

integer

95

Capital or Metropolis



98

Other city cities having population more than 5000



103

Small cities having population less than 5000

nd_9

varchar

..

name

nd_14

integer

1..12

province code (see table Province)

the_geom

ogc:polygon

..

epsg:28992

remarks

these are built up AREAS, in polygon form. Note there’s also locality/town info in the node tables!

UP  

TABLE

airports

Column

format

values

description

gid

serial

..

Primary Key

nd_4

integer

99

Airports (National and International)

nd_9

varchar

..

name

nd_14

integer

1..12

province code (see table Province)

the_geom

ogc:polygon

..

epsg:28992

remarks

these are airport AREAS, in polygon form. Note there’s also airport info in the node tables!

UP  

TABLE

forest

Column

format

values

description

gid

serial

..

Primary Key

nd_4

integer

96

Forest, Woodland

nd_9

varchar

..

name

nd_14

integer

1..12

province code (see table Province)

the_geom

ogc:polygon

..

epsg:28992

remarks


UP  

TABLE

industrial

Column

format

values

description

gid

serial

..

Primary Key

nd_4

integer

109

Industrial area

nd_9

varchar

..

name

nd_14

integer

1..12

province code (see table Province)

the_geom

ogc:polygon

..

epsg:28992

remarks


UP  

TABLE

park

Column

format

values

description

gid

serial

..

Primary Key

nd_4

integer

109

City park, garden

nd_9

varchar

..

name

nd_14

integer

1..12

province code (see table Province)

the_geom

ogc:polygon

..

epsg:28992

remarks

note that the AND category “102: Regional, national park” is not present in the dataset for NL. Instances such as the “Veluwe” national park are listed as “forest”.

UP  

TABLE

railroad

Column

format

values

description

gid

serial

..

Primary Key

rd_3

integer

..

segment length in hectometers

rd_7

integer

10

All railways

rd_17

integer

0..2

Tunnel flag

rd_20

integer

0..3

Relative height to a crossing feature

1 is below 2 is below 3 etc.

fnode

integer

..

From node ID of link

tnode

integer

..

To node ID of link

the_geom

ogc:linestring

..

epsg:28992

remarks


UP  

TABLE

roads

Column

format

values

description

gid

serial

..

Primary Key

rd_1

integer

..

AND ID of roads

rd_3

integer

..

Road length in hectometers

rd_4

integer

0..2

Permitted Traffic Flow:

0: Traffic allowed in both directions

1: Traffic allowed from RD_ID_FROM to RD_ID_TO

2: Traffic allowed from RD_ID_TO to RD_ID_FROM

rd_5

integer

1..7,

50,59

Road classification:

1: Motor way

2: Federal highway dual carriage way (motor way characteristics)

3: Federal highway

4: Regional road

5: Local road

6: Other road

7: Ferry (cars and cargo)

50: Link to airports, railway stations

59: Virtual connection. Used to connect features in the data that are not linked by any other defined features in the database

rd_7

integer

0..6

Connection level. The connection level of a road expresses the importance of that road. The general classification is as follows:

0: E-roads in Europe

1: Important national roads in such a way that all type 10 to 13 locations are connected.

2: Secondary roads in such a way that all type 10 to 14 locations are connected.

3: Through roads in such a way that all type 10 to 15 locations are connected.

4: Local connector roads in such a way that all type 10 to 16 and 20 to 26 locations are connected

5: Other roads

6: All other roads (streets)

rd_9

char(1)

C

Slow road flag (road within city limits

rd_10

char(60)

..

Road (street) name

rd_11

char(12)

..

National road number

rd_12

char(12)

..

National road number

rd_13

char(12)

..

National road number

rd_14

char(12)

..

International road number

rd_15

char(12)

..

International road number

rd_17

integer

0..2

Tunnel flag

rd_18

integer

0..1

Toll flag

rd_19

integer

..

Ferry journey time in minutes

rd_20

integer

0..3,9

Relative height to a crossing feature

1 is below 2 is below 3 etc.

9 if relative height is unknown.

rd_21

integer

0,-1

-1 Only passengers (ferries) – Also used for

pedestrian streets/ virtual connections

rd_23

char(60)

..

Other Attributes:

Sr#1: Slip road segment

Rb#1: Roundabout segment

Lb#1: Lay-by segment

4wd#1: Four wheel drive road segment

Unsealed#1: Unsealed road segments

Fc#[0-4]: Functional road class 0 to 4

Lh#1: Long haul

Stub#1: Stub link

hn#: Housenumber range

L : left, direction from FNODE_

to TNODE_

R: right, direction from FNODE_

to TNODE_

E: even

O: odd

M: mixed

e.g. hn#LE2-12#RO1-11

rd_24

integer

1..12

province code (see table Province)

rd_25

integer

..

City code of link (link to ND_ID)

rd_26

integer

..

Municipality code of link (table should be available in _m.dbf file – NOTE: missing!)

fnode

integer

..

From node ID of link

tnode

integer

..

To node ID of link

the_geom

ogc:linestring

..

epsg:28992

remarks

sub-copyies of this table grouped by rd_7 are available as roads_0..roads_6

UP  

TABLE

roads_0

Column

format

values

description

..

..

..

[all other columns equal to table roads]

rd_7

integer

0

Connection level 0: E-roads in Europe.

remarks

This is a sub_copy of roads using

SELECT * FROM roads WHERE rd_7 = 0

TABLE

roads_1

Column

format

values

description

..

..

..

[all other columns equal to table roads]

rd_7

integer

1

Connection level 1: Important national roads in such a way that all type 10 to 13 locations are connected.

remarks

This is a sub_copy of roads using

SELECT * FROM roads WHERE rd_7 = 1

TABLE

roads_2

Column

format

values

description

..

..

..

[all other columns equal to table roads]

rd_7

integer

2

Connection level 2: Secondary roads in such a way that all type 10 to 14 locations are connected.

remarks

This is a sub_copy of roads using

SELECT * FROM roads WHERE rd_7 = 2

TABLE

roads_3

Column

format

values

description

..

..

..

[all other columns equal to table roads]

rd_7

integer

3

Connection level 3: Through roads in such a way that all type 10 to 15 locations are connected.

remarks

This is a sub_copy of roads using

SELECT * FROM roads WHERE rd_7 = 3

TABLE

roads_4

Column

format

values

description

..

..

..

[all other columns equal to table roads]

rd_7

integer

4

Connection level 4: Local connector roads in such a way that all type 10 to 16 and 20 to 26 locations are connected

remarks

This is a sub_copy of roads using

SELECT * FROM roads WHERE rd_7 = 4

TABLE

roads_5

Column

format

values

description

..

..

..

[all other columns equal to table roads]

rd_7

integer

5

Connection level 5: Other roads

remarks

This is a sub_copy of roads using

SELECT * FROM roads WHERE rd_7 = 5

TABLE

roads_6

Column

format

values

description

..

..

..

[all other columns equal to table roads]

rd_7

integer

6

Connection level 6: All other roads (streets)

remarks

This is a sub_copy of roads using

SELECT * FROM roads WHERE rd_7 = 6

UP  

TABLE

stations

Column

format

values

description

gid

serial

..

Primary Key

nd_4

integer

30

Railway station

nd_9

varchar

..

name

nd_10

varchar

..

Name prefix, e.g. “Den”

nd_14

integer

1..12

province code (see table Province)

the_geom

ogc:point

..

epsg:28992

remarks


UP  

TABLE

nodes

Column

format

values

description

gid

serial

..

Primary Key

nd_4

integer

1..4, 9..17, 19..27, 30, 40..42, 80..85


Node type:

1 Junction (exit)

2 Intersection

3 Border node

4 Directional information

9 Level dead end, location other than a type 3 or 10-27 where a level may terminate

10 Capital City

11 Large city > 500,000

12 Medium city > 100,000

13 Small city > 50,000

14 Town > 20,000 (*)

15 Village > 5,000 (*)

16 Small village > 1,000 (*)

17 Tiny village < 1,000 (*)

19 Postal code point

20 Postal code area

21 Numbered town district (e.g. Dublin 4)

22 Town district > 100,000

23 Town district > 50,000

24 Town district > 20,000

25 Town district > 5,000

26 Town district > 1,000

27 Town district < 1,000

30 Station **)

40 Airport; no information available

41 Big international airport (>10,000 flights per year)

42 Medium international airport (400-10,000 fl/yr)

80 Rest area with at least parking and petrol station.

81 Rest area with parking only

82 Rest area with only parking and petrol station

83 Rest area with parking, petrol station and restaurant

84 Rest area with parking, petrol station, restaurant and hotel

85 Rest area with parking, restaurant and hotel

nd_6

integer

0..6

Connection level. The connection level of a node equals the level of the road on which it is situated (see roads table)

nd_8

varchar

..

Postal code

nd_9

varchar

..

Name

nd_10

varchar

..

nd_9 prefix, e.g. “Den”

nd_13

varchar

..

Official code belonging to Name. eg. Exit number , Community code, IATA airport code, etc.

nd_14

integer

1..12

province code (see table Province)

nd_21

varchar

..

Name of conurbation to which suburb or town district belongs

nd_22

varchar

..

nd_21 prefix, e.g. “Den”

the_geom

ogc:point

..

epsg:28992

remarks

*) A town or village is upgraded (one or two types) if it is a national or regional centre. A village of type 17 is upgraded to type 16 if it has an own postal code. A village (type 16 or 17) is upgraded (one type) if it is important from a tourist point of view.

**) Same as in table “stations”. Used to connect roads & railways via station & road nodes.