[OSM-talk-nl] 'foute' polygonen in postgis

Sat Apr 19 20:24:13 BST 2008

Mm, ik had me voorgenomen om te reageren op een thread van ik meen 
Martijn en Martijn :-) over hoe om te gaan met 'foute' polygonen in 
osm/postgis. Alleen kan ik het mailtje zo even gauw niet terug vinden.

Het ging om het fixen van foute polygonen.
Omdat er bij mijn(!) weten geen mogelijkheid is om dit soort dingen 
automatisch te doen, dacht ik even te kijken of het eenvoudig met de 
hand is te doen.

De volgende query

select osm_id, boundary, name, 'natural', waterway, 
'http://www.openstreetmap.org/?zoom=16&lat=' || 
Y(Transform(ST_Centroid(way), 4326)) || '&lon=' || 
X(Transform(ST_Centroid(way), 4326)) as url
from planet_osm_polygon where not isvalid(way)

en een beetje plakken in een texteditor geeft het volgende resultaat 
voor de polygonen. Door de x en y van de centroid van de geomety in de 
osm url te plakken, kun je even snel op de kaart kijken, EN in een keer 
de data met josm ophalen.
Bij de eerste (Zuider Voorhaven) kon ik de 'zelfversnijding' nog wel 
vinden, maar bij andere niet.
Ik weet niet of dit de manier is, maar op zich zou je zo met wat 
handwerk wel de huidige fouten eruit kunnen vissen...

Waar vind ik trouwens in josm die osm_id terug. Klopt het dat die niet 
in de attributen terecht komen (in josm)?

Is er iemand die een beetje handig is met josm ;-)
Ik weet ook niet of de rendering hiervan dan meteen instort. Vandaar ook 
dat ik er nog geen heb aangepast.

Groet Richard Duivenvoorde

Hier het plak en knip resultaat:

ERROR                     osm_id  boudary name natual waterway    url

Self-intersection          6285567    ""    "Zuider Voorhaven" 
"natural"    "river" 
"http://www.openstreetmap.org/?zoom=16&lat=51.6749431687765&lon=4.38306821579024"

Self-intersection          19880774    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.2337263190066&lon=4.4796387889929"

Self-intersection          6346628    "administrative"    "Amstelveen" 
   "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.2893237166558&lon=4.85151980433692"

Hole lies outside shell   1669    ""    "Gooimeer"    "natural"    "" 

"http://www.openstreetmap.org/?zoom=16&lat=52.3153001710252&lon=5.20366576880434"

Self-intersection          16689815    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.7346634361231&lon=6.06209252344352"

Self-intersection          6321528    ""    "Nationaal Park De Meinweg" 
    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.1584587291095&lon=6.12947451832452"

Ring Self-intersection     16634784    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.7927346088327&lon=6.25808850244141"

Self-intersection          6295689    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.5757636310598&lon=6.69908371036832"

Self-intersection          6286427    ""    "Grevelingenmeer" 
"natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.7646331858133&lon=3.87701471786698"

Self-intersection          8033492    ""    "Grevelingenmeer" 
"natural"    "river" 
"http://www.openstreetmap.org/?zoom=16&lat=51.7419891034252&lon=3.89908262044033"

Hole lies outside shell   2030    ""    "Deltageul"    "natural"    "" 

"http://www.openstreetmap.org/?zoom=16&lat=51.8312550294404&lon=4.07474997705028"

Self-intersection          6287873    ""    "Brittanniëhaven" 
"natural"    "canal" 
"http://www.openstreetmap.org/?zoom=16&lat=51.8958212703664&lon=4.23528063225716"

Ring Self-intersection     6287119    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.841560381416&lon=4.31914483997721"

Self-intersection          19785088    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.3001319581023&lon=4.34544345747915"

Self-intersection          4327158    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.3425119495056&lon=4.35280120140598"

Self-intersection          6290388    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.0612956443162&lon=4.36592025276919"

Self-intersection          21109124    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.1661906231312&lon=4.3682863865411"

Hole lies outside shell   351    ""    "Étangs d'Ixelles - Vijvers van 
Elsene"    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.8316226552459&lon=4.36798174457292"

Self-intersection          21109372    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.1646289086344&lon=4.37738556946385"

Hole lies outside shell   2070    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.9739049229902&lon=4.27819826005774"

Self-intersection          21583231    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.3475832673845&lon=4.42617816786223"

Self-intersection          6283758    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.3785865538047&lon=4.42761620651383"

Self-intersection          18946158    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.1672905222284&lon=4.43324619659805"

Self-intersection          19880633    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.228191845978&lon=4.48831665386695"

Self-intersection          19734461    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.2005315787506&lon=4.49317959927205"

Self-intersection          6291711    ""    "Meerburgerwatering" 
"natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.1364965463938&lon=4.50624806176603"

Self-intersection          19844652    ""    "Fascinatio"    "natural" 
   "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.9180831568962&lon=4.54510924048969"

Self-intersection          16605487    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.1393925044539&lon=4.57620837604766"

Ring Self-intersection     21555882    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.8548912364557&lon=4.67257306146194"

Self-intersection          1486    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.028726862613&lon=4.65672069528255"

Self-intersection          22323226    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.9125063719715&lon=4.69443902722115"

Self-intersection          21998126    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.9556096061247&lon=4.69689070864726"

Ring Self-intersection     6286060    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.7591045270272&lon=4.82942569008123"

Hole lies outside shell   1670    ""    "Jachthaven"    "natural"    "" 

"http://www.openstreetmap.org/?zoom=16&lat=52.3377438688945&lon=4.88308425907989"

Hole lies outside shell   2086    ""    "Grecht"    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.1015477796696&lon=4.86779228078237"

Self-intersection          12115224    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.084277365342&lon=4.90319674601783"

Self-intersection          20371006    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.0807968315577&lon=4.90563999957938"

Self-intersection          6286853    ""    "Boven Merwede"    "natural" 
    "river" 
"http://www.openstreetmap.org/?zoom=16&lat=51.825955150211&lon=4.95368465912784"

Self-intersection          12720259    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.3505133345946&lon=4.93055070551862"

Hole lies outside shell   2166    ""    "Het IJ"    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.4080771482947&lon=4.9625410893901"

Self-intersection          19077553    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.1697082350871&lon=4.99153957496968"

Self-intersection          6296563    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.7639242833866&lon=5.07659206802265"

Ring Self-intersection     21397434    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.4772085519089&lon=5.45573805773818"

Hole lies outside shell   1996    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.5112900119834&lon=5.46284069325626"

Hole lies outside shell   1994    ""    "Zuid-Willemsvaart"    "natural" 
    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.174609455169&lon=6.5402043447039"

Self-intersection          18891491    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.4992108861553&lon=5.52130673016943"

Self-intersection          18912202    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.4993973284145&lon=5.55010297131683"

Self-intersection          18639659    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.4931041536883&lon=5.54736764459605"

Self-intersection          22701864    ""    "Spielplatz"    "natural" 
   "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.826575800681&lon=6.06868761616238"

Self-intersection          15089955    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.7018879629558&lon=6.07526568926768"

Self-intersection          19875526    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.7769108563901&lon=6.08265552760636"

Self-intersection          18455441    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.8505152375615&lon=6.09336390053085"

Self-intersection          19025203    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.789504496564&lon=6.09357982686961"

Self-intersection          9230471    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=51.6644040582116&lon=6.38016135481265"

Self-intersection          6327749    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.5295423549146&lon=6.38978365257901"

Self-intersection          6327943    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.6526237699888&lon=6.53571945536784"

Self-intersection          1863    ""    "Patersweldemeer"    "natural" 
    "" 
"http://www.openstreetmap.org/?zoom=16&lat=53.1679964160326&lon=6.56920371346113"

Self-intersection          6295796    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.6228933380416&lon=6.70407804610196"

Self-intersection          6295983    ""    "Coevorden-Vecht Kanaal" 
"natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.6470931331089&lon=6.73339962541546"

Hole lies outside shell   2751    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.6299027957243&lon=6.7436780975428"

Self-intersection          6325550    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=52.1873013010722&lon=6.94650348100578"

Self-intersection          15241539    ""    "Poppelsdorfer Schloß" 
"natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.7250760036328&lon=7.09206152074424"

Self-intersection          15241876    ""    "Universität Bonn" 
"natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.7340332762361&lon=7.10317331104173"

Self-intersection          10367110    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.6291945699195&lon=7.11340297958361"

Self-intersection          12701199    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.8211150956093&lon=7.17444757129563"

Hole lies outside shell   2886    ""    ""    "natural"    "" 
"http://www.openstreetmap.org/?zoom=16&lat=50.7069097416229&lon=7.42832799959136"