User:Hansm/Boundary statistics

From OpenStreetMap Wiki
Jump to: navigation, search

Here are some statistics about the usage of relation tag "type=boundary". All relate to the planet.osm dump from 2009-07-13.

Boundaries that osm2pgsql converts as pg POLYGON

Except "boundary=yahoo".

relation way admin_level boundary name
Osm element relation.svg 57537 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Cornwall
Osm element relation.svg 62269 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 2 administrative Isle of Man
Mf way.png 28489604 national_park Dartmoor National Park
Osm element relation.svg 87944 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Swansea
Osm element relation.svg 134324 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Powys
Osm element relation.svg 10187 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Herefordshire
Osm element relation.svg 151283 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 4 administrative West Midlands
Osm element relation.svg 57511 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Shropshire
Osm element relation.svg 82631 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative South Gloucestershire
Osm element relation.svg 57581 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Worcestershire
Osm element relation.svg 57515 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Staffordshire
Osm element relation.svg 153487 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Cheshire East
Osm element relation.svg 149122 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 8 administrative Pendle
Osm element relation.svg 151012 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 4 administrative Yorkshire and the Humber
Osm element relation.svg 150871 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 8 administrative Richmondshire
Osm element relation.svg 151164 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 4 administrative North East England
Osm element relation.svg 88066 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Northumberland
Mf way.png 31787677 national_park New Forest National Park
Osm element relation.svg 151279 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 4 administrative East Midlands
Osm element relation.svg 108100 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 8 administrative Derbyshire Dales
Osm element relation.svg 88077 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Derbyshire
Osm element relation.svg 118323 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 8 administrative Bradford
Osm element relation.svg 88079 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative West Yorkshire
Osm element relation.svg 154376 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Tyne and Wear
Osm element relation.svg 142282 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Newcastle upon Tyne
Osm element relation.svg 127238 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 8 administrative Winchester
Osm element relation.svg 76228 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Hampshire
Osm element relation.svg 76155 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Oxfordshire
Osm element relation.svg 63375 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Northamptonshire
Osm element relation.svg 58414 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 10 administrative Morton Pinkney
Osm element relation.svg 77270 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 8 administrative Bassetlaw
Osm element relation.svg 135523 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 8 administrative Selby
Osm element relation.svg 150966 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 8 administrative Hambleton
Osm element relation.svg 114677 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 8 administrative Chichester
Osm element relation.svg 113757 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative West Sussex
Osm element relation.svg 88082 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Bedfordshire
Osm element relation.svg 158396 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Bedford
Osm element relation.svg 57398 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Rutland
Osm element relation.svg 145223 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 8 administrative Veulette-sur-Mer
Osm element relation.svg 92650 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative East Sussex
Osm element relation.svg 62162 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Essex
Osm element relation.svg 76488 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 8 administrative Castle Point
Osm element relation.svg 53337 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 8 administrative St Edmundsbury
Osm element relation.svg 57397 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 6 administrative Norfolk
Osm element relation.svg 53332 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx) 8 administrative Mid Suffolk District
(45 rows)

All administrative boundaries are derived from relations with tag "type=boundary". The only boundary POLYGONs derived from ways are national_parks.

Furthermore, there are 1164 boundaries in talbe planet_osm_line and 1135 in table planet_osm_roads. Both seem to be more or less the same. Both tables contain roughly half of the rows derived from ways and the other half derived from relations. Boundary relations seem to be widely used in the UK and in France.

Relations with "type=boundary" in relation clusters

In the actual OSM DB (not what osm2pgsql has generated from it), there are 26928 relations with "type=boundary". 259 of them are part of a relation cluster, i.e. a relation that contains some of this relations. With high probability, this means that they don't enclose an area. 157 relation clusters contain sub-relations tagged as "type=boundary".

"type" tags used in this relation clusters:

type count remark
address 127 relation names look Russian
boundary 19 mainly used in France, Germany, Austria, Switzerland
multipolygon 3 Osm element relation.svg 17775 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx), Osm element relation.svg 56392 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx), Osm element relation.svg 162784 (view, XML, Potlatch2, iD, JOSM, history, analyze, manage, gpx)
state 3
county 2
country 1
null 1
nation 1

Super relations containing relations with "type=boundary"

Osm element relation.svg 7374, Osm element relation.svg 7424, Osm element relation.svg 7435, Osm element relation.svg 7885, Osm element relation.svg 7886, Osm element relation.svg 7887, Osm element relation.svg 11980, Osm element relation.svg 16163, Osm element relation.svg 16438, Osm element relation.svg 17775, Osm element relation.svg 22956, Osm element relation.svg 23169, Osm element relation.svg 26880, Osm element relation.svg 28245, Osm element relation.svg 29956, Osm element relation.svg 51684, Osm element relation.svg 51701, Osm element relation.svg 51908, Osm element relation.svg 54422, Osm element relation.svg 56392, Osm element relation.svg 78655, Osm element relation.svg 78967, Osm element relation.svg 79842, Osm element relation.svg 79843, Osm element relation.svg 79844, Osm element relation.svg 79845, Osm element relation.svg 79846, Osm element relation.svg 79847, Osm element relation.svg 79848, Osm element relation.svg 79849, Osm element relation.svg 79852, Osm element relation.svg 79853, Osm element relation.svg 79854, Osm element relation.svg 79855, Osm element relation.svg 79856, Osm element relation.svg 79857, Osm element relation.svg 79858, Osm element relation.svg 79859, Osm element relation.svg 79860, Osm element relation.svg 79895, Osm element relation.svg 79897, Osm element relation.svg 79898, Osm element relation.svg 79900, Osm element relation.svg 79902, Osm element relation.svg 79904, Osm element relation.svg 79906, Osm element relation.svg 79907, Osm element relation.svg 79908, Osm element relation.svg 79909, Osm element relation.svg 79910, Osm element relation.svg 79912, Osm element relation.svg 79913, Osm element relation.svg 79914, Osm element relation.svg 79916, Osm element relation.svg 79917, Osm element relation.svg 79918, Osm element relation.svg 79919, Osm element relation.svg 79920, Osm element relation.svg 79921, Osm element relation.svg 79922, Osm element relation.svg 79924, Osm element relation.svg 79925, Osm element relation.svg 79926, Osm element relation.svg 79927, Osm element relation.svg 79929, Osm element relation.svg 79930, Osm element relation.svg 79931, Osm element relation.svg 79932, Osm element relation.svg 79933, Osm element relation.svg 79934, Osm element relation.svg 79935, Osm element relation.svg 79937, Osm element relation.svg 79940, Osm element relation.svg 79941, Osm element relation.svg 79942, Osm element relation.svg 79943, Osm element relation.svg 79944, Osm element relation.svg 79945, Osm element relation.svg 79946, Osm element relation.svg 79947, Osm element relation.svg 79948, Osm element relation.svg 79949, Osm element relation.svg 79952, Osm element relation.svg 79953, Osm element relation.svg 79954, Osm element relation.svg 79956, Osm element relation.svg 79958, Osm element relation.svg 79959, Osm element relation.svg 79960, Osm element relation.svg 79962, Osm element relation.svg 79963, Osm element relation.svg 79964, Osm element relation.svg 79965, Osm element relation.svg 79966, Osm element relation.svg 79967, Osm element relation.svg 79968, Osm element relation.svg 79969, Osm element relation.svg 79970, Osm element relation.svg 79971, Osm element relation.svg 79972, Osm element relation.svg 79973, Osm element relation.svg 79974, Osm element relation.svg 79976, Osm element relation.svg 79978, Osm element relation.svg 79983, Osm element relation.svg 79984, Osm element relation.svg 79985, Osm element relation.svg 79986, Osm element relation.svg 79987, Osm element relation.svg 79988, Osm element relation.svg 79989, Osm element relation.svg 79990, Osm element relation.svg 79991, Osm element relation.svg 79992, Osm element relation.svg 79993, Osm element relation.svg 79995, Osm element relation.svg 79996, Osm element relation.svg 79997, Osm element relation.svg 79998, Osm element relation.svg 79999, Osm element relation.svg 80000, Osm element relation.svg 80001, Osm element relation.svg 80002, Osm element relation.svg 80003, Osm element relation.svg 80004, Osm element relation.svg 80007, Osm element relation.svg 80008, Osm element relation.svg 80010, Osm element relation.svg 80011, Osm element relation.svg 80012, Osm element relation.svg 80013, Osm element relation.svg 80014, Osm element relation.svg 80015, Osm element relation.svg 80016, Osm element relation.svg 80017, Osm element relation.svg 80018, Osm element relation.svg 80019, Osm element relation.svg 80020, Osm element relation.svg 80022, Osm element relation.svg 80025, Osm element relation.svg 80026, Osm element relation.svg 80028, Osm element relation.svg 80029, Osm element relation.svg 80030, Osm element relation.svg 80031, Osm element relation.svg 80033, Osm element relation.svg 80035, Osm element relation.svg 80096, Osm element relation.svg 80488, Osm element relation.svg 82728, Osm element relation.svg 82743, Osm element relation.svg 82765, Osm element relation.svg 82767, Osm element relation.svg 102879, Osm element relation.svg 135579, Osm element relation.svg 161349, Osm element relation.svg 162784

Sub-relations with "type=boundary"

Osm element relation.svg 7426, Osm element relation.svg 7723, Osm element relation.svg 7885, Osm element relation.svg 7886, Osm element relation.svg 16354, Osm element relation.svg 16483, Osm element relation.svg 17511, Osm element relation.svg 17529, Osm element relation.svg 17560, Osm element relation.svg 17567, Osm element relation.svg 17580, Osm element relation.svg 17601, Osm element relation.svg 17605, Osm element relation.svg 17623, Osm element relation.svg 17632, Osm element relation.svg 17633, Osm element relation.svg 17641, Osm element relation.svg 17644, Osm element relation.svg 17645, Osm element relation.svg 17655, Osm element relation.svg 22233, Osm element relation.svg 22733, Osm element relation.svg 22735, Osm element relation.svg 26221, Osm element relation.svg 26222, Osm element relation.svg 26907, Osm element relation.svg 26923, Osm element relation.svg 28245, Osm element relation.svg 28322, Osm element relation.svg 29713, Osm element relation.svg 29714, Osm element relation.svg 29715, Osm element relation.svg 29716, Osm element relation.svg 29724, Osm element relation.svg 29726, Osm element relation.svg 29731, Osm element relation.svg 29736, Osm element relation.svg 29750, Osm element relation.svg 29773, Osm element relation.svg 29784, Osm element relation.svg 29787, Osm element relation.svg 29788, Osm element relation.svg 29925, Osm element relation.svg 29939, Osm element relation.svg 29948, Osm element relation.svg 31257, Osm element relation.svg 47393, Osm element relation.svg 47442, Osm element relation.svg 47505, Osm element relation.svg 47626, Osm element relation.svg 47773, Osm element relation.svg 47803, Osm element relation.svg 47812, Osm element relation.svg 51239, Osm element relation.svg 51250, Osm element relation.svg 51322, Osm element relation.svg 51326, Osm element relation.svg 51333, Osm element relation.svg 51334, Osm element relation.svg 51339, Osm element relation.svg 51410, Osm element relation.svg 51419, Osm element relation.svg 51440, Osm element relation.svg 51441, Osm element relation.svg 51442, Osm element relation.svg 51443, Osm element relation.svg 51444, Osm element relation.svg 51781, Osm element relation.svg 51793, Osm element relation.svg 51800, Osm element relation.svg 51806, Osm element relation.svg 51814, Osm element relation.svg 51821, Osm element relation.svg 51827, Osm element relation.svg 51831, Osm element relation.svg 51841, Osm element relation.svg 51848, Osm element relation.svg 51902, Osm element relation.svg 51903, Osm element relation.svg 51905, Osm element relation.svg 51906, Osm element relation.svg 51907, Osm element relation.svg 51909, Osm element relation.svg 53957, Osm element relation.svg 59065, Osm element relation.svg 59092, Osm element relation.svg 59137, Osm element relation.svg 59148, Osm element relation.svg 59149, Osm element relation.svg 59161, Osm element relation.svg 59162, Osm element relation.svg 59167, Osm element relation.svg 59178, Osm element relation.svg 59188, Osm element relation.svg 59189, Osm element relation.svg 59190, Osm element relation.svg 59195, Osm element relation.svg 59199, Osm element relation.svg 59202, Osm element relation.svg 59208, Osm element relation.svg 59209, Osm element relation.svg 59246, Osm element relation.svg 59249, Osm element relation.svg 59250, Osm element relation.svg 59252, Osm element relation.svg 59257, Osm element relation.svg 59273, Osm element relation.svg 59275, Osm element relation.svg 59415, Osm element relation.svg 59417, Osm element relation.svg 59418, Osm element relation.svg 59419, Osm element relation.svg 59504, Osm element relation.svg 59506, Osm element relation.svg 59752, Osm element relation.svg 59755, Osm element relation.svg 62145, Osm element relation.svg 65595, Osm element relation.svg 65598, Osm element relation.svg 65606, Osm element relation.svg 66113, Osm element relation.svg 69554, Osm element relation.svg 70542, Osm element relation.svg 70549, Osm element relation.svg 70561, Osm element relation.svg 70563, Osm element relation.svg 70565, Osm element relation.svg 70568, Osm element relation.svg 70569, Osm element relation.svg 70575, Osm element relation.svg 70577, Osm element relation.svg 70580, Osm element relation.svg 70586, Osm element relation.svg 70589, Osm element relation.svg 70591, Osm element relation.svg 70595, Osm element relation.svg 70602, Osm element relation.svg 70604, Osm element relation.svg 70605, Osm element relation.svg 70610, Osm element relation.svg 70614, Osm element relation.svg 70616, Osm element relation.svg 70618, Osm element relation.svg 70620, Osm element relation.svg 70626, Osm element relation.svg 70637, Osm element relation.svg 70638, Osm element relation.svg 70639, Osm element relation.svg 70649, Osm element relation.svg 70656, Osm element relation.svg 70660, Osm element relation.svg 70662, Osm element relation.svg 70665, Osm element relation.svg 70668, Osm element relation.svg 70669, Osm element relation.svg 70671, Osm element relation.svg 70676, Osm element relation.svg 70677, Osm element relation.svg 70679, Osm element relation.svg 70680, Osm element relation.svg 70684, Osm element relation.svg 70690, Osm element relation.svg 70691, Osm element relation.svg 70701, Osm element relation.svg 70703, Osm element relation.svg 70707, Osm element relation.svg 70716, Osm element relation.svg 70719, Osm element relation.svg 70721, Osm element relation.svg 70725, Osm element relation.svg 70727, Osm element relation.svg 70728, Osm element relation.svg 70732, Osm element relation.svg 70737, Osm element relation.svg 70746, Osm element relation.svg 70747, Osm element relation.svg 70748, Osm element relation.svg 70749, Osm element relation.svg 70751, Osm element relation.svg 70752, Osm element relation.svg 70754, Osm element relation.svg 70768, Osm element relation.svg 70772, Osm element relation.svg 70790, Osm element relation.svg 70795, Osm element relation.svg 70798, Osm element relation.svg 70799, Osm element relation.svg 70801, Osm element relation.svg 70809, Osm element relation.svg 70810, Osm element relation.svg 70812, Osm element relation.svg 70814, Osm element relation.svg 71093, Osm element relation.svg 71094, Osm element relation.svg 71097, Osm element relation.svg 71100, Osm element relation.svg 71101, Osm element relation.svg 71105, Osm element relation.svg 71112, Osm element relation.svg 71114, Osm element relation.svg 71116, Osm element relation.svg 71117, Osm element relation.svg 71118, Osm element relation.svg 71119, Osm element relation.svg 71121, Osm element relation.svg 71124, Osm element relation.svg 71125, Osm element relation.svg 71128, Osm element relation.svg 71130, Osm element relation.svg 71132, Osm element relation.svg 71133, Osm element relation.svg 71134, Osm element relation.svg 71135, Osm element relation.svg 71138, Osm element relation.svg 71145, Osm element relation.svg 71147, Osm element relation.svg 71149, Osm element relation.svg 75767, Osm element relation.svg 82622, Osm element relation.svg 82629, Osm element relation.svg 82675, Osm element relation.svg 82682, Osm element relation.svg 82722, Osm element relation.svg 82729, Osm element relation.svg 82751, Osm element relation.svg 82766, Osm element relation.svg 82773, Osm element relation.svg 82775, Osm element relation.svg 82779, Osm element relation.svg 89489, Osm element relation.svg 90124, Osm element relation.svg 90162, Osm element relation.svg 90333, Osm element relation.svg 90340, Osm element relation.svg 90341, Osm element relation.svg 90348, Osm element relation.svg 90352, Osm element relation.svg 102647, Osm element relation.svg 102666, Osm element relation.svg 102877, Osm element relation.svg 102882, Osm element relation.svg 102885, Osm element relation.svg 102896, Osm element relation.svg 102898, Osm element relation.svg 103060, Osm element relation.svg 126410, Osm element relation.svg 130921, Osm element relation.svg 131862, Osm element relation.svg 161349, Osm element relation.svg 163244

Relations with "admin-level" tag set

In the actual OSM DB (not what osm2pgsql has generated from it), there are 47825 relations with "admin-level" tag set.

"boundary" values used together with "admin-level":

boundary count
administrative 47497
historic 20
national_park 1
maritime 1
typos 35
obvious nonsense 3

"type" values used together with "admin-level":

type count
boundary 26679
multipolygon 21050
municipality 29
county 12
amt 10
typos 7
commune 6
border 4
state 1
collection 1
boundary_incomplete 1

Conclusion

Although osm2pgsql tries to generate PostGIS POLYGONS from boundaries, in fact the result is very poor. 45 polygons in relation to 26928 relations with "type=boundary" or 47825 relations with "admin-level" tag set, osm2pgsql's success rate is very close to 0.

Among administrative boundaries, the usage of "type=boundary" and "type=mulitpolygon" is about half-half.

There are only 259 relations with "type=boundary" that are part of a relation cluster. I don't understand the usage in relation clusters with "type=address", but this is the vaste majority. Only 29 are used in clusters with type values that look like administrative units. Mostly, this are high level units (with admin_level <= 4).

An alternate importer tries to fix several issues related to polygons in OSM data for GIS analysis, see osm2postgresql.