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.
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.
| Spaltenname | Datentyp | Mögliche Werte | Beschreibung |
|---|---|---|---|
| id_ort | int(10) unsigned | beliebig | Fremdschlüssel, der auf die Tabelle `orte` verweist. |
| geodaten | geometryDieser 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:
| beliebig | Die simplifizierten Geodaten. |
| epsilon | float(5,4) | beliebig | Die Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone. |
| mittelpunkt | pointDieser 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:
| beliebig | Der geometrische Mittelpunkt des vereinfachten Polygons. |
Ausschnitt
| id_ort | geodaten | epsilon | mittelpunkt |
|---|---|---|---|
| 58622 | POLYGON((8.21990776062023 51.843074798584,8.21820640563976 51.8465881347656,8.21345615386969 51.8494873046875,8.2144708633424 51.8529777526855,8.21049880981457 51.8523178100586,8.20753002166748 51.8535461425782,8.20820140838634 51.8548278808594,8.20558834075933 51.8563652038575,8.20643424987793 51.8578948974609,8.20504283905029 51.8582992553712,8.20573425292969 51.8592262268068,8.1998786926269 51.8596076965333,8.20019245147711 51.8608741760254,8.19853496551514 51.8626136779786,8.18954181671154 51.8633766174317,8.18484115600586 51.862361907959,8.18465995788569 51.8650169372559,8.18232727050787 51.8654670715333,8.18281841278088 51.8667259216309,8.18120288848871 51.8667221069337,8.18241405487066 51.8691864013672,8.18114471435547 51.8695564270021,8.18302059173584 51.8726806640626,8.18080139160162 51.8728637695314,8.18130016326916 51.8747825622559,8.17535495758068 51.8745803833009,8.1760835647583 51.876594543457,8.17421913146984 51.8787651062012,8.17610168457043 51.8803329467775,8.17558860778814 51.8826713562013,8.17146015167248 51.8846511840821,8.17316722869873 51.8857650756837,8.17169666290283 51.8865394592285,8.17272663116461 51.8880729675292,8.17153930664057 51.8887062072754,8.16835021972656 51.8868675231935,8.1648674011231 51.8892631530762,8.15914726257324 51.8907699584962,8.1590251922608 51.8922882080079,8.16048717498785 51.8927154541017,8.15781211853027 51.8969192504884,8.16245269775391 51.8983879089355,8.16192054748535 51.8997459411621,8.15075111389172 51.8978691101075,8.15049457550043 51.898609161377,8.15049457550043 51.898609161377,8.1366367340089 51.8934478759767,8.12749958038336 51.8957214355469,8.12634181976318 51.8931274414062,8.12540817260748 51.8931922912599,8.12540817260748 51.8931922912599,8.12362194061279 51.8903884887696,8.12380218505865 51.8887062072754,8.12726497650141 51.8851737976075,8.12981128692633 51.8841667175294,8.1311235427857 51.882022857666,8.13337993621832 51.8732643127442,8.13172721862799 51.8704299926757,8.1346483230592 51.8661117553712,8.13559055328369 51.8618202209473,8.14014244079596 51.8541412353516,8.13909912109386 51.8520050048829,8.13125610351574 51.8519897460938,8.13098239898682 51.8510437011719,8.12565517425543 51.8502349853516,8.12528800964367 51.8483581542969,8.11791324615484 51.8476676940918,8.11789321899414 51.8461036682128,8.11102008819574 51.8458213806153,8.11060523986816 51.8445892333985,8.10367488861084 51.8437461853028,8.10259246826178 51.84139251709,8.10008907318121 51.8403778076172,8.09296607971203 51.8387336730957,8.09263420104986 51.8398170471191,8.08362674713146 51.8392715454102,8.08441448211681 51.8364868164062,8.08343505859369 51.8363227844239,8.08472728729254 51.8344230651857,8.08376407623297 51.8342247009278,8.08535575866699 51.8305130004884,8.08617401123053 51.8306999206543,8.08390808105474 51.8263053894043,8.08446311950689 51.8235206604004,8.08723735809332 51.8237838745118,8.0883722305299 51.8210067749025,8.09369373321533 51.818702697754,8.09463119506836 51.8166160583497,8.09559440612787 51.8168067932129,8.09651565551758 51.8153114318848,8.09449958801281 51.8148880004884,8.09449958801281 51.8148880004884,8.09822082519537 51.8134346008302,8.09898853301996 51.8102760314941,8.10102462768566 51.8102111816406,8.09851932525629 51.8065071105958,8.10101699829113 51.8037300109864,8.10514640808105 51.8041648864746,8.10748958587646 51.7996292114259,8.11106491088873 51.7988624572754,8.11217308044428 51.7997436523438,8.11277770996105 51.7987289428711,8.11255931854248 51.7940254211427,8.10955905914318 51.7920036315918,8.11056137084972 51.7883987426759,8.10784244537365 51.7876510620117,8.10899639129644 51.785026550293,8.1100959777832 51.7853736877442,8.1119203567506 51.7825355529786,8.11557960510254 51.7795219421388,8.11353874206543 51.7780227661133,8.11345767974854 51.7751655578613,8.11622047424322 51.7750930786133,8.11718463897705 51.7707977294922,8.12235927581787 51.7700576782228,8.12395668029785 51.7683525085449,8.13472747802729 51.7659759521485,8.13338088989263 51.7650947570801,8.13743591308594 51.762420654297,8.13743591308594 51.762420654297,8.13995075225841 51.7637138366699,8.15120029449463 51.7635498046876,8.16852855682384 51.7603149414064,8.1782426834107 51.7594566345216,8.17972850799566 51.7581901550293,8.18110370635992 51.7616729736329,8.18369865417475 51.7636871337891,8.18683815002453 51.7609939575195,8.1894092559815 51.7608108520508,8.1903982162475 51.761287689209,8.1901741027832 51.7620811462403,8.18815135955816 51.7620124816895,8.18801784515387 51.7634735107422,8.19338226318365 51.7658081054688,8.19292831420904 51.7612991333009,8.19579792022711 51.761058807373,8.19622039794922 51.7624626159669,8.20448017120356 51.7657890319825,8.20761871337891 51.7688484191896,8.20662498474121 51.7713127136232,8.21916961669928 51.7780532836915,8.23635864257824 51.7784271240235,8.25283813476562 51.7761421203613,8.25283813476562 51.7761421203613,8.25505638122559 51.7820701599121,8.25185012817388 51.7826461791993,8.25313949584961 51.7876853942872,8.2556409835816 51.7878684997559,8.25659084320063 51.7905883789063,8.25944614410412 51.7906723022462,8.25944614410412 51.7906723022462,8.25987148284912 51.7951087951661,8.25869464874268 51.796600341797,8.25745868682873 51.8029212951661,8.25323677062983 51.8025550842286,8.25116920471191 51.8046836853028,8.24026393890387 51.8094177246094,8.2346305847168 51.8216743469239,8.23328590393072 51.8227310180665,8.23085021972668 51.8235130310059,8.22354125976568 51.8230018615724,8.2196741104126 51.8239631652833,8.21931648254395 51.8227691650391,8.21439933776867 51.8222770690918,8.20483589172363 51.8244438171387,8.1999568939209 51.8278579711915,8.20010471344 51.828826904297,8.20453929901129 51.8305130004884,8.20517158508295 51.8353462219239,8.2072925567627 51.8344879150391,8.20896434783947 51.8367805480957,8.21552181243902 51.8349266052247,8.21882152557379 51.8363418579102,8.21814727783203 51.8376159667968,8.2169589996339 51.8375625610353,8.21673583984386 51.8391075134277,8.21790313720697 51.8424949645996,8.21990776062023 51.843074798584)) | 0.0006 | POINT(8.163558922245043 51.82833482990159) |
| 30261 | POLYGON((-3.11498737335205 48.7644958496093,-3.13009238243097 48.7514381408691,-3.14476132392883 48.7479934692383,-3.14718008041376 48.7381973266602,-3.14718008041376 48.7381973266602,-3.18047595024109 48.7404022216797,-3.18741130828857 48.7450485229492,-3.18741130828857 48.7450485229492,-3.18994307518 48.7575187683107,-3.18211007118219 48.7661361694337,-3.18211007118219 48.7661361694337,-3.16184830665577 48.780128479004,-3.13749384880055 48.7839317321778,-3.13749384880055 48.7839317321778,-3.12780117988586 48.7852058410645,-3.12129664421082 48.7765541076661,-3.11633300781244 48.7756614685058,-3.11724281311029 48.7753143310548,-3.11600542068481 48.7693786621094,-3.11600542068481 48.7693786621094,-3.11498737335205 48.7644958496093)) | 0.0006 | POINT(-3.147259175777394 48.76300487518315) |
| 54889 | POLYGON((4.9527897834779 44.7716789245606,4.96031904220587 44.7762374877929,4.98435354232788 44.7797622680665,4.99184989929205 44.7843475341797,5.00018072128307 44.7810821533204,5.00018072128307 44.7810821533204,5.00563859939587 44.7724380493164,5.00306510925293 44.7569732666015,5.00306510925293 44.7569732666015,4.98006725311279 44.7316665649414,4.98006725311279 44.7316665649414,4.97949743270874 44.7316322326661,4.97949743270874 44.7316322326661,4.94455671310436 44.7412567138672,4.94455671310436 44.7412567138672,4.95175075531006 44.7581329345703,4.9527897834779 44.7716789245606)) | 0.0006 | POINT(4.978839755058338 44.75798869132998) |
| 65201 | POLYGON((10.3968496322632 49.4291229248047,10.4030361175538 49.4324188232423,10.4227781295777 49.4294128417969,10.4227781295777 49.4294128417969,10.4236793518066 49.4350891113282,10.4220771789552 49.4367179870607,10.4194555282593 49.4368057250978,10.4186124801637 49.4380378723146,10.4212455749512 49.4389839172364,10.4193086624146 49.4423446655275,10.4231948852539 49.4448127746582,10.4197978973389 49.4464378356935,10.4235343933106 49.4484214782715,10.4269857406616 49.4468841552735,10.4308757781983 49.4474639892579,10.4296855926514 49.4496307373047,10.4356441497803 49.4516296386719,10.4409952163696 49.4500923156738,10.448392868042 49.4522399902345,10.4478673934937 49.4535255432128,10.4486389160157 49.4544792175292,10.4531230926514 49.4551315307618,10.4542379379272 49.4583587646486,10.4513912200928 49.4619407653809,10.4513912200928 49.4619407653809,10.4469194412233 49.4621696472168,10.4379291534424 49.466464996338,10.4308891296386 49.466911315918,10.4276838302612 49.4687614440919,10.4265632629395 49.4704818725587,10.4253635406494 49.4696960449219,10.4241056442261 49.4708671569825,10.4215812683105 49.469955444336,10.4163141250611 49.4741706848145,10.4129343032837 49.4727630615234,10.4104375839233 49.4794998168946,10.4064188003539 49.4798202514648,10.4063158035278 49.4830780029297,10.4031372070312 49.4878501892091,10.4022550582885 49.4901924133301,10.4047632217407 49.4934120178223,10.3852491378785 49.4931068420411,10.3780508041382 49.4943580627441,10.3780508041382 49.4943580627441,10.3794555664064 49.490348815918,10.3726797103882 49.4886932373048,10.3742218017578 49.4851799011232,10.3717079162598 49.4854545593262,10.3698463439943 49.4845619201661,10.3701267242432 49.4831771850587,10.3677778244019 49.4836425781251,10.3671379089357 49.4803199768067,10.363021850586 49.4807472229005,10.3636932373047 49.4777908325196,10.3565855026246 49.4770965576172,10.3574314117432 49.4756774902344,10.3574314117432 49.4756774902344,10.3662815093995 49.4766540527345,10.3674440383911 49.4717750549317,10.3634948730469 49.469856262207,10.3687658309938 49.4692344665527,10.3822517395019 49.4651908874512,10.3836040496827 49.4597663879396,10.3856925964355 49.4580230712891,10.3907670974732 49.4594039916992,10.3918228149415 49.4503555297853,10.3963308334351 49.43949508667,10.3949298858643 49.4366416931153,10.3968496322632 49.4291229248047)) | 0.0006 | POINT(10.405338848338436 49.463882614584556) |
| 34630 | POLYGON((3.48679137229931 48.8573074340821,3.48518753051763 48.8519096374513,3.48518753051763 48.8519096374513,3.49128460884089 48.8351364135742,3.48524141311646 48.8255043029785,3.48720169067377 48.8151893615723,3.48720169067377 48.8151893615723,3.50653362274176 48.8201713562012,3.5157265663147 48.8173904418945,3.5157265663147 48.8173904418945,3.51817345619207 48.8237724304199,3.53690958023083 48.8285102844238,3.53690958023083 48.8285102844238,3.52286458015442 48.8460731506348,3.50969886779785 48.8513832092285,3.50609588623053 48.8578491210938,3.4963693618775 48.8598136901855,3.48679137229931 48.8573074340821)) | 0.0006 | POINT(3.5043002296896857 48.83547120935779) |
| 40551 | POLYGON((2.15178489685059 46.1195449829103,2.15366029739391 46.1071014404297,2.16794824600214 46.1014823913575,2.16794824600214 46.1014823913575,2.17520928382879 46.0929527282716,2.17986822128296 46.0921478271484,2.17986822128296 46.0921478271484,2.18241262435907 46.1020812988281,2.19254636764538 46.109302520752,2.18587636947632 46.1216735839843,2.17899823188793 46.1261100769044,2.17899823188793 46.1261100769044,2.15974879264837 46.1280326843263,2.15178489685059 46.1195449829103)) | 0.0006 | POINT(2.1734513869652687 46.109243833101765) |
| 36264 | POLYGON((6.0739159584046 47.8172035217286,6.06402635574352 47.8180007934571,6.05602169036871 47.8136787414551,6.0460200309754 47.8148498535156,6.0460200309754 47.8148498535156,6.04558563232433 47.8145027160646,6.04558563232433 47.8145027160646,6.04161691665661 47.8047332763672,6.0345888137818 47.8001251220704,6.01671457290649 47.8050422668457,6.01347970962524 47.8024597167969,6.01347970962524 47.8024597167969,6.0450868606568 47.7810554504395,6.04421854019165 47.7777900695801,6.02058267593389 47.7724113464355,6.01598310470581 47.7664604187013,6.01598310470581 47.7664604187013,6.03029489517212 47.7625389099121,6.06810617446905 47.773536682129,6.08841562271118 47.7889518737794,6.08841562271118 47.7889518737794,6.07123470306402 47.8115348815918,6.0739159584046 47.8172035217286)) | 0.0006 | POINT(6.044789834456054 47.79600455544217) |
| 72861 | POLYGON((11.3584442138672 47.1569786071778,11.3426713943481 47.1581192016603,11.3368015289308 47.1574211120607,11.2999410629274 47.1383323669435,11.2999410629274 47.1383323669435,11.3004121780396 47.1356201171874,11.3020467758178 47.1335906982422,11.30690574646 47.1315193176269,11.3293161392212 47.1304359436035,11.3373470306396 47.1286201477052,11.3703689575195 47.1043815612794,11.3703689575195 47.1043815612794,11.3800868988037 47.1221542358399,11.3800868988037 47.1221542358399,11.3584442138672 47.1569786071778)) | 0.0006 | POINT(11.33676706041611 47.13300296238498) |
| 1390954 | POLYGON((-1.58742702007288 39.0270195007324,-1.57958197593689 39.0178337097169,-1.57165503501892 39.0146293640137,-1.54300594329834 39.0080490112305,-1.51564300060267 38.9911308288575,-1.51120102405548 38.9865531921388,-1.49413299560541 38.9890174865724,-1.49914395809162 38.9840278625489,-1.49630701541901 38.9812240600587,-1.49495303630823 38.9698181152344,-1.50311899185181 38.9559364318848,-1.49773097038263 38.9438285827638,-1.49483895301813 38.9299812316895,-1.48164105415333 38.9094352722169,-1.4925400018692 38.9105796813965,-1.49648702144617 38.9136352539063,-1.50712394714355 38.9173889160157,-1.53361201286316 38.9187698364257,-1.55050504207611 38.9088363647462,-1.55196297168732 38.9040412902832,-1.5646669864654 38.9024658203126,-1.57139098644257 38.8989639282227,-1.59755301475519 38.9166984558106,-1.61383295059204 38.921127319336,-1.61567902565002 38.9264640808107,-1.61449801921844 38.9373893737793,-1.60875296592712 38.9497108459474,-1.61651802062988 38.9552040100098,-1.62193500995636 38.9542846679688,-1.63436996936792 38.9714050292968,-1.6361500024795 38.9773292541504,-1.63541400432587 38.9819984436035,-1.62753701210022 38.983283996582,-1.61967194080347 39.0001411437988,-1.60836994647974 39.0147132873536,-1.58742702007288 39.0270195007324)) | 0.0006 | POINT(-1.559684337888417 38.95636901855474) |
| 50571 | POLYGON((2.43653059005743 49.5564575195312,2.43614339828491 49.5439109802247,2.43614339828491 49.5439109802247,2.44630217552196 49.5419425964356,2.45482158660894 49.5460357666016,2.47038507461554 49.5476303100587,2.4762659072876 49.5533561706544,2.4762659072876 49.5533561706544,2.483244895935 49.5585594177247,2.483244895935 49.5585594177247,2.45993399620062 49.5629272460938,2.44022250175487 49.5726432800294,2.44022250175487 49.5726432800294,2.43653059005743 49.5564575195312)) | 0.0006 | POINT(2.456902063809942 49.554764087383646) |