Datenbank-Dokumentation

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

Beschreibung
Enthält mit dem Douglas-Peucker-Algorithmus simplifizierte Varianten der Polygondaten aus der Tabelle `Orte`, sowie (für bestimmte `Kategorien`) Hexagone, die dem jeweiligen Polygon möglichst gut entsprechen.

Spalten
Der Name von Spalten, die Teil des Primärschlüssels sind wird fett dargestellt, die Namen von Fremdschlüsseln unterstrichen. Kursivierte Werte im Feld Datentyp bedeuten, dass der Wert optional (nullable) ist.
SpaltennameDatentypMögliche WerteBeschreibung
id_ortint(10) unsignedbeliebigFremdschlüssel, der auf die Tabelle `orte` verweist.
geodaten

geometry

Dieser Datentyp speichert geometrische Daten in MySQL-Datenbanken. Die einfachste Möglichkeit diese manuell einzutragen, ist die Verwendung der GeomFromText-Funktion. Diese erlaubt die Eingabe der Daten im WKT-Format.
Alle geographischen Koordinaten in VerbaAlpina werden in der Reihenfolge <Längengrad>, <Breitengrad> angegeben. Die Eingabe eines Punktes mit den Koordinaten Breitengrad 48.135876 und Längengrad 11.583720 könnte somit folgendermaßen über die phpMyAdmin-Oberfläche angegeben werden:

  • Auswahl von "GeomFromText" in der Spalte "Funktion"
  • Eingabe von 
    POINT(11.583720 48.135876)
    in der Spalte "Wert"
beliebigDie simplifizierten Geodaten.
epsilonfloat(5,4)beliebigDie Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone.
mittelpunkt

point

Dieser Datentyp speichert geometrische Daten in MySQL-Datenbanken. Die einfachste Möglichkeit diese manuell einzutragen, ist die Verwendung der GeomFromText-Funktion. Diese erlaubt die Eingabe der Daten im WKT-Format.
Alle geographischen Koordinaten in VerbaAlpina werden in der Reihenfolge <Längengrad>, <Breitengrad> angegeben. Die Eingabe eines Punktes mit den Koordinaten Breitengrad 48.135876 und Längengrad 11.583720 könnte somit folgendermaßen über die phpMyAdmin-Oberfläche angegeben werden:

  • Auswahl von "GeomFromText" in der Spalte "Funktion"
  • Eingabe von 
    POINT(11.583720 48.135876)
    in der Spalte "Wert"
beliebigDer geometrische Mittelpunkt des vereinfachten Polygons.
Ausschnitt
id_ortgeodatenepsilonmittelpunkt
67055POLYGON((8.29924297332764 48.3487663269044,8.29140472412115 48.3577041625977,8.28757286071783 48.3582725524903,8.28442668914801 48.3604164123536,8.27511024475109 48.3628540039062,8.26922702789301 48.3589668273926,8.26635646820068 48.3641891479492,8.26021289825439 48.3667488098145,8.25411605834967 48.3623123168946,8.25327396392822 48.3629226684571,8.25138378143311 48.3648376464844,8.25337219238276 48.3691787719727,8.2517604827882 48.3695678710938,8.25928688049328 48.3759078979493,8.26111030578613 48.3759002685547,8.26401329040522 48.3792762756349,8.25979804992681 48.3805046081543,8.25515460968029 48.3803482055665,8.25446701049805 48.3827095031739,8.25079154968273 48.3824386596681,8.25028610229492 48.3841094970704,8.24749851226807 48.3853378295898,8.2478923797608 48.3870544433594,8.24656581878668 48.3891716003419,8.24763584136974 48.3951377868652,8.24134159088146 48.3967361450196,8.23300647735601 48.4014053344727,8.23300647735601 48.4014053344727,8.22942638397217 48.400260925293,8.21791458129888 48.4014625549316,8.21791458129888 48.4014625549316,8.21406459808344 48.3985595703126,8.20954513549816 48.3923835754395,8.20389842987061 48.3895149230958,8.20279788970959 48.3862075805665,8.18728923797607 48.3766021728516,8.18823623657221 48.3739852905274,8.18271827697754 48.3653221130372,8.17582511901861 48.3643608093262,8.17216300964361 48.3616104125978,8.17299461364757 48.3591651916504,8.17227268219 48.3544692993164,8.16940593719488 48.3526039123535,8.16990661621099 48.3511657714845,8.16990661621099 48.3511657714845,8.17424297332775 48.3459396362305,8.17441272735601 48.3432273864747,8.17816162109381 48.34183883667,8.18086624145508 48.3345832824708,8.18188858032238 48.3337936401368,8.18417644500744 48.3342018127442,8.18691253662115 48.3319740295411,8.1870489120484 48.3293609619141,8.19021606445324 48.3274230957032,8.19139289855968 48.3236236572266,8.18928050994879 48.3206558227538,8.18913459777826 48.31689453125,8.19044208526617 48.3157501220703,8.19164276123047 48.3120269775392,8.19509315490723 48.3106231689454,8.19561290740978 48.3044433593749,8.19865989685064 48.3032951354981,8.20075798034674 48.2999458312989,8.20457077026373 48.2965545654297,8.20457077026373 48.2965545654297,8.20465278625488 48.2999839782715,8.21088123321539 48.2996826171874,8.21401119232189 48.3031005859376,8.22324752807623 48.304542541504,8.22087001800548 48.313045501709,8.22465229034435 48.3143577575684,8.23065280914318 48.3193206787109,8.2346401214599 48.3243865966797,8.23465061187756 48.327938079834,8.23970031738281 48.3313446044921,8.24258613586426 48.3363609313966,8.24890041351324 48.3392868041993,8.2563562393189 48.3451423645021,8.26875019073481 48.3491058349609,8.27276515960705 48.3517875671388,8.27850246429455 48.3490600585939,8.27702522277843 48.3429603576661,8.28250980377203 48.3386459350586,8.2921514511109 48.3417510986329,8.29587268829346 48.3415031433107,8.29986667633062 48.3442001342774,8.29835224151611 48.3466720581055,8.29924297332764 48.3487663269044))0.0006POINT(8.228118129160263 48.35139509179128)
1401918POLYGON((-5.03179311752319 42.1736106872559,-5.05756998062134 42.1789512634277,-5.06213998794556 42.185775756836,-5.07764720916742 42.1863670349121,-5.07434701919556 42.1895446777344,-5.07221603393549 42.1961822509766,-5.06987094879145 42.1963539123536,-5.07212018966669 42.198787689209,-5.07062292098993 42.200798034668,-5.06422996520996 42.2023696899415,-5.06587076187134 42.2058906555176,-5.06240892410273 42.209312438965,-5.06104421615601 42.208324432373,-5.0537052154541 42.211727142334,-5.04785919189453 42.2190284729004,-5.04115581512451 42.2192535400391,-5.03893613815302 42.2172966003418,-5.03358697891235 42.2163810729981,-5.02479600906372 42.2172775268556,-5.02028083801264 42.2055969238282,-5.01284694671631 42.1946144104004,-5.01445388793945 42.1933937072753,-5.01229095458984 42.189739227295,-5.01940393447876 42.1787910461426,-5.03179311752319 42.1736106872559))0.0006POINT(-5.048383216063162 42.199807008107534)
47609POLYGON((1.65159738063818 50.5706481933594,1.64766788482677 50.5726356506348,1.64766788482677 50.5726356506348,1.63781476020819 50.5471496582031,1.63419079780584 50.544677734375,1.62520253658306 50.5482940673828,1.62520253658306 50.5482940673828,1.64590692520136 50.5322914123536,1.66630935668945 50.5277214050294,1.67769336700451 50.5350341796876,1.67769336700451 50.5350341796876,1.65932464599609 50.5557250976562,1.65878808498394 50.5658073425294,1.65159738063818 50.5706481933594))0.0006POINT(1.6503891944885944 50.55045758760897)
63200POLYGON((11.3662366867065 53.7647666931152,11.3654298782349 53.7638702392578,11.3637590408326 53.7644844055177,11.3614511489868 53.7635688781738,11.3568830490112 53.7687568664551,11.3514251708986 53.7711830139161,11.3426914215088 53.767360687256,11.3390550613403 53.7635688781738,11.334927558899 53.7610435485841,11.3273649215698 53.7596588134765,11.3208599090577 53.7612533569337,11.3208599090577 53.7612533569337,11.313696861267 53.764976501465,11.3033962249756 53.7647018432618,11.2988386154175 53.7634201049806,11.290382385254 53.763698577881,11.2960824966431 53.750373840332,11.2960824966431 53.750373840332,11.296525001526 53.7496604919434,11.2994699478149 53.7498931884767,11.3021135330201 53.7461318969727,11.3023948669434 53.7416381835938,11.3047084808349 53.7356033325196,11.3079414367676 53.729362487793,11.3088970184326 53.7294273376464,11.3090906143189 53.7267608642579,11.3134517669679 53.7218055725098,11.3123960494996 53.7204208374023,11.3073720932008 53.7190437316895,11.3073720932008 53.7190437316895,11.3095893859864 53.7079238891603,11.3118448257446 53.7029838562012,11.320276260376 53.7012214660645,11.319125175476 53.7004127502443,11.3277654647828 53.6993217468262,11.3277654647828 53.6993217468262,11.3315019607545 53.7070770263672,11.3348226547242 53.7080993652345,11.3393917083741 53.7125778198242,11.3429212570192 53.711826324463,11.3426427841188 53.7138671875001,11.3442850112915 53.7157783508301,11.3469867706299 53.7168579101563,11.3470754623413 53.7214393615723,11.3434104919434 53.7238082885742,11.3414688110352 53.727596282959,11.3426399230957 53.7294120788575,11.344651222229 53.7299804687501,11.3528280258179 53.7281723022462,11.3602495193481 53.7334213256837,11.3602495193481 53.7334213256837,11.3582696914673 53.7352409362794,11.361993789673 53.7380905151368,11.3649225234985 53.7375335693359,11.3669061660768 53.7465858459472,11.3690586090089 53.7458610534668,11.3690586090089 53.7458610534668,11.3721380233765 53.7489738464356,11.3703031539917 53.7497329711913,11.3707962036133 53.7516517639161,11.3657112121582 53.75590133667,11.3629283905029 53.7608337402344,11.3648014068604 53.7612152099609,11.3643960952759 53.7622184753419,11.3673486709595 53.76273727417,11.3678045272828 53.7642974853516,11.3662366867065 53.7647666931152))0.0006POINT(11.336501280466756 53.739520622022255)
51678POLYGON((-0.402476698160058 45.6051635742187,-0.409974575042725 45.5934600830079,-0.409974575042725 45.5934600830079,-0.413852751255035 45.5774345397949,-0.413852751255035 45.5774345397949,-0.403108924627304 45.5790863037109,-0.403108924627304 45.5790863037109,-0.388804405927658 45.5787696838379,-0.37611395120615 45.5967292785645,-0.37611395120615 45.5967292785645,-0.387531250715256 45.6035041809083,-0.402476698160058 45.6051635742187))0.0006POINT(-0.3986284326423091 45.58916889537466)
50482POLYGON((2.61277723312384 49.4100379943847,2.61179566383362 49.4196586608887,2.600992679596 49.4269065856934,2.60327267646801 49.4368171691895,2.60327267646801 49.4368171691895,2.60443925857555 49.4392471313477,2.59680914878851 49.4402923583984,2.59680914878851 49.4402923583984,2.57684421539312 49.4427337646486,2.567220211029 49.4315719604493,2.56250882148743 49.4329910278321,2.56250882148743 49.4329910278321,2.55119276046764 49.4299926757812,2.55119276046764 49.4299926757812,2.55912661552429 49.4272384643555,2.55079150199902 49.4206886291505,2.55079150199902 49.4206886291505,2.55833911895746 49.4113960266113,2.57127189636236 49.4050979614258,2.57127189636236 49.4050979614258,2.5930757522583 49.3999252319337,2.5930757522583 49.3999252319337,2.6072838306427 49.4042320251465,2.61277723312384 49.4100379943847))0.0006POINT(2.580724519232093 49.42367968351949)
69216MULTIPOLYGON(((9.37189865112316 54.2029113769531,9.37108516693115 54.2000732421875,9.36878204345697 54.2008628845216,9.36168766021734 54.200366973877,9.35953044891357 54.1996726989747,9.35912609100336 54.198169708252,9.35572052001959 54.1977806091309,9.35481739044189 54.1994857788085,9.34643077850347 54.1963653564454,9.34821224212646 54.1950340270996,9.34217643737804 54.1899414062499,9.34076881408703 54.1910133361816,9.33098506927502 54.1886863708497,9.31213378906244 54.1886787414552,9.31213378906244 54.1886787414552,9.29258537292492 54.1900367736816,9.29258537292492 54.1900367736816,9.30446720123297 54.1967430114746,9.31184577941895 54.2068901062012,9.31423091888428 54.222110748291,9.32038974761963 54.2227516174317,9.31801319122314 54.2250366210937,9.31785488128662 54.2268867492676,9.31944465637201 54.2287063598633,9.32495212554926 54.2280044555665,9.32572174072266 54.2290077209473,9.32154941558838 54.2313385009765,9.32159423828131 54.2325248718263,9.32500934600841 54.2348823547363,9.33213329315191 54.2367630004883,9.3331499099732 54.2354431152344,9.33659839630133 54.2360610961915,9.3387393951416 54.2379570007324,9.3387393951416 54.2379570007324,9.34229469299328 54.2351417541504,9.34992122650146 54.2325973510743,9.35467815399176 54.2272262573243,9.35459613800043 54.225700378418,9.3566198348999 54.2256546020508,9.3562803268432 54.2234420776368,9.36109352111822 54.2210884094239,9.36109352111822 54.2210884094239,9.35906887054443 54.2194442749024,9.35844707489019 54.2174453735352,9.36182975769054 54.2112236022949,9.36383724212646 54.2082977294922,9.36965370178223 54.204418182373,9.37053966522228 54.2027626037598,9.37189865112316 54.2029113769531)),((9.43320465087902 54.2369537353516,9.43585872650158 54.2306900024415,9.4347705841065 54.2263259887696,9.4347705841065 54.2263259887696,9.42632293701178 54.2264137268067,9.42640304565435 54.2275199890137,9.42210865020763 54.227035522461,9.42145347595215 54.22562789917,9.41765403747564 54.2261962890624,9.4160242080689 54.2276191711425,9.41802692413336 54.2278251647949,9.41839027404797 54.2310333251954,9.41684818267834 54.2326393127441,9.41684818267834 54.2326393127441,9.42221641540527 54.2325325012208,9.42968177795404 54.2343826293945,9.43320465087902 54.2369537353516)))0.0006POINT(9.345409188086126 54.2147136105158)
16736POLYGON((13.8903551101685 42.8921508789062,13.8898229598999 42.8952445983888,13.8750171661377 42.8985023498536,13.8720788955688 42.901165008545,13.8676452636718 42.9118309020997,13.8688650131226 42.9201812744142,13.8676280975342 42.9254913330079,13.8599739074707 42.9271659851074,13.8499917984009 42.9368553161622,13.8499917984009 42.9368553161622,13.850474357605 42.9380226135253,13.8465747833252 42.9433174133302,13.8497219085693 42.9553146362305,13.843897819519 42.9573249816895,13.8348226547241 42.9581718444825,13.8348226547241 42.9581718444825,13.8379659652711 42.9637870788574,13.8502225875854 42.9639282226562,13.8613052368165 42.9620933532715,13.880970954895 42.9634704589845,13.880970954895 42.9634704589845,13.8812494277954 42.9620819091797,13.8843059539795 42.9593048095703,13.8887500762939 42.9593048095703,13.8898620605469 42.9584732055665,13.8901376724244 42.9576377868653,13.8881940841675 42.9584732055665,13.885136604309 42.9581947326661,13.8856935501098 42.9562492370606,13.8876399993896 42.9551391601562,13.8887500762939 42.9529151916504,13.8912496566774 42.9551391601562,13.8901376724244 42.9520835876466,13.8881940841675 42.9498596191407,13.8870840072631 42.9498596191407,13.8893060684205 42.9426383972168,13.8990287780761 42.9248619079589,13.9045829772949 42.9168052673341,13.9123620986938 42.8995819091798,13.9154157638549 42.8956108093262,13.9154157638549 42.8956108093262,13.9054412841797 42.8956260681153,13.8903551101685 42.8921508789062))0.0006POINT(13.876929941631493 42.938761120750826)
16767POLYGON((13.6081943511963 43.0433464050293,13.5942687988282 43.0397796630859,13.5942687988282 43.0397796630859,13.5893058776855 43.0331916809083,13.5921449661256 43.0274124145508,13.6021165847778 43.0130577087403,13.6021165847778 43.0130577087403,13.6117877960205 43.0190200805664,13.6117877960205 43.0190200805664,13.6230945587159 43.0242919921876,13.6320524215699 43.0338020324707,13.6320524215699 43.0338020324707,13.6258821487428 43.0385627746582,13.6237821578979 43.0418395996095,13.6177530288697 43.0468521118164,13.6081943511963 43.0433464050293))0.0006POINT(13.610707219441766 43.03112106323245)
54373POLYGON((5.08136892318737 46.4242210388185,5.08452606201172 46.4301376342773,5.08452606201172 46.4301376342773,5.08953905105602 46.4426651000978,5.08724975585943 46.449245452881,5.08724975585943 46.449245452881,5.09158897399908 46.4505920410157,5.11151313781738 46.4417724609375,5.11964082717896 46.4450454711915,5.1280598640443 46.4423942565917,5.1280598640443 46.4423942565917,5.13092613220221 46.4323768615723,5.13092613220221 46.4323768615723,5.12951278686529 46.4225311279297,5.11716175079351 46.4127273559571,5.11716175079351 46.4127273559571,5.10513257980358 46.4158782958985,5.08916139602661 46.4123802185059,5.08916139602661 46.4123802185059,5.08991432189941 46.4218406677246,5.08136892318737 46.4242210388185))0.0006POINT(5.1046190261841335 46.43115348815922)