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
69293POLYGON((10.5915803909302 53.6258239746094,10.5894784927369 53.6253318786621,10.5878114700318 53.6232757568359,10.5891523361207 53.6211547851564,10.5883474349976 53.6188812255861,10.5853824615479 53.6177864074708,10.5815153121949 53.6185455322266,10.5815153121949 53.6185455322266,10.5812454223634 53.6114463806153,10.5812454223634 53.6114463806153,10.5918550491334 53.612606048584,10.6016845703126 53.6094093322755,10.6049985885621 53.6117973327637,10.6109828948976 53.6117401123047,10.6124658584595 53.6128158569336,10.6170463562011 53.6135482788085,10.6205921173097 53.611701965332,10.6266822814942 53.6120719909669,10.6276445388795 53.6155128479005,10.6399431228639 53.61474609375,10.6399431228639 53.61474609375,10.6411466598511 53.6225166320801,10.6447420120239 53.626636505127,10.6447420120239 53.626636505127,10.6363134384156 53.6285705566407,10.6291913986207 53.627498626709,10.6216373443604 53.6288986206055,10.6218509674073 53.6296997070313,10.6122331619263 53.6280441284179,10.6040315628052 53.6308021545411,10.6013669967653 53.6287460327149,10.5992374420167 53.6296195983888,10.5992374420167 53.6296195983888,10.5980701446534 53.6283988952637,10.5955333709718 53.6293716430665,10.5915803909302 53.6258239746094))0.0006POINT(10.608584186009072 53.62079980032789)
69495POLYGON((8.86080932617199 54.7342338562012,8.86025905609125 54.7336158752443,8.8629236221314 54.732089996338,8.85586166381836 54.7273864746095,8.85129165649414 54.7256546020508,8.85021305084223 54.7238807678224,8.84675121307379 54.722770690918,8.84063243865972 54.7178230285645,8.84338951110846 54.7163085937501,8.84160232543951 54.7152061462402,8.84529113769531 54.7136497497559,8.84872150421154 54.7107582092285,8.84872150421154 54.7107582092285,8.85015201568615 54.7094573974611,8.85112380981451 54.7035789489747,8.85530090332043 54.6973609924318,8.84743976593012 54.6886558532715,8.84139156341547 54.6875915527344,8.8342924118042 54.6931877136232,8.8289852142334 54.6945724487305,8.82455635070806 54.6936912536622,8.82283306121826 54.6918106079102,8.82283306121826 54.6918106079102,8.81199359893799 54.6861076354982,8.77019500732428 54.6840286254883,8.75408935546875 54.6819305419922,8.75235176086437 54.6823730468751,8.75305461883551 54.6833152770996,8.75305461883551 54.6833152770996,8.75416660308844 54.6840286254883,8.7502765655517 54.6904182434083,8.75194454193115 54.6995849609374,8.74694538116455 54.7031936645509,8.74694538116455 54.7051391601562,8.74472332000744 54.7081947326661,8.74194431304937 54.7084732055665,8.74083423614502 54.7098617553712,8.73750019073492 54.7109718322754,8.73416805267345 54.710693359375,8.73305606842052 54.7115287780762,8.73361206054699 54.7123603820801,8.73194313049328 54.7129173278809,8.72916698455811 54.7123603820801,8.72749900817865 54.7134704589845,8.72305488586426 54.7134704589845,8.72138881683361 54.7143058776856,8.72194480896007 54.7159729003907,8.71860980987555 54.7156944274903,8.71583366394054 54.7179183959961,8.71249961853033 54.7168045043945,8.71138763427734 54.7179183959961,8.71083354949945 54.7223625183107,8.70916557312023 54.7223625183107,8.70750045776373 54.7240295410156,8.694167137146 54.7248611450196,8.69305515289307 54.7254180908204,8.69305515289307 54.7281951904296,8.69194507598888 54.729305267334,8.68749809265137 54.7298622131348,8.68861007690435 54.7323608398439,8.69472312927246 54.7306938171387,8.70194530487066 54.7346534729004,8.70194530487066 54.7346534729004,8.71111583709722 54.7356910705568,8.71545124053949 54.7377166748048,8.71458625793468 54.7384643554689,8.72328948974621 54.7413253784181,8.7395868301391 54.7505645751953,8.74720287323009 54.7525215148925,8.75455951690668 54.7528991699219,8.75959491729742 54.7508239746094,8.76213836669928 54.7482032775879,8.76113414764416 54.7435455322266,8.75679588317877 54.7411079406738,8.76012802124023 54.7378044128419,8.76160717010498 54.7334823608399,8.76442050933838 54.7322006225585,8.76360321044922 54.7298011779786,8.76645469665527 54.7249298095704,8.78083801269537 54.7251625061036,8.78599166870112 54.7223396301271,8.78678703308117 54.7257003784181,8.79040241241449 54.7291336059571,8.79040241241449 54.7291336059571,8.79712581634516 54.7258567810059,8.82247734069819 54.7173614501953,8.83195209503185 54.715763092041,8.84371376037609 54.7219047546387,8.85416603088385 54.7331428527833,8.86183547973638 54.7353897094727,8.86080932617199 54.7342338562012))0.0006POINT(8.771570724911195 54.71792149013945)
64269POLYGON((12.9944486618043 52.5126838684083,12.9912166595459 52.5129203796386,13.004867553711 52.5183601379395,13.0131673812866 52.5201148986818,13.0119504928589 52.5215721130372,13.0133800506592 52.5228614807129,13.0115308761597 52.5232887268067,13.0143976211548 52.5315322875977,13.017827987671 52.5342864990235,13.0188140869141 52.5373992919923,13.0149087905883 52.5390625000001,13.0153064727783 52.5414199829103,13.0186796188355 52.5457687377931,13.0149002075195 52.5460205078125,13.0154256820678 52.5472221374513,13.0124702453614 52.5474205017091,13.0153303146362 52.5526161193848,13.0095319747925 52.5524101257324,13.0079298019409 52.554370880127,13.0085487365723 52.5570030212402,13.0120010375978 52.5582809448242,13.0120010375978 52.5582809448242,13.0135755538942 52.558708190918,13.0105543136596 52.5638008117677,13.0058937072754 52.5638961791993,13.0050172805787 52.5651283264161,13.0033931732177 52.5643348693848,12.9995679855347 52.5680236816407,12.9995679855347 52.5680236816407,12.9984569549561 52.5690155029297,12.9986753463746 52.5708045959473,12.9966793060304 52.5707740783691,12.9951181411743 52.5692558288575,12.9892740249634 52.5692367553712,12.9887638092042 52.5675811767578,12.9856882095338 52.5677680969239,12.9810829162598 52.5696525573731,12.9730997085572 52.5678939819337,12.9662637710571 52.5684394836426,12.9653902053834 52.5654487609864,12.9554738998414 52.5658149719238,12.9447660446166 52.5641441345215,12.944227218628 52.5612602233887,12.937494277954 52.5585746765137,12.9347343444824 52.5585975646973,12.9331474304199 52.5615196228028,12.9238433837892 52.5600204467774,12.9181108474731 52.5651779174805,12.9214096069335 52.5678253173829,12.9099588394166 52.5780067443848,12.9045438766479 52.5759086608887,12.9024648666383 52.5770721435548,12.9024648666383 52.5770721435548,12.9016466140748 52.5719985961914,12.9056205749512 52.5720291137696,12.9045114517212 52.5643043518067,12.9024238586427 52.5639152526856,12.8974514007569 52.5659027099609,12.8935012817383 52.5621643066407,12.8882579803467 52.5604705810548,12.8899145126342 52.5685424804688,12.8863401412965 52.5688018798829,12.8845777511597 52.5587158203126,12.878755569458 52.5572204589845,12.8754663467407 52.5550384521484,12.8760995864868 52.5536308288575,12.8718166351318 52.5524711608887,12.8782949447631 52.540756225586,12.8782949447631 52.540756225586,12.8779878616334 52.5383071899415,12.8875494003296 52.5396919250489,12.8873653411866 52.5406570434571,12.8920488357545 52.5415992736817,12.8934831619264 52.5377845764161,12.9027891159057 52.5346755981446,12.9036111831666 52.5268859863282,12.9135723114014 52.5269546508789,12.9070558547974 52.522361755371,12.9054765701295 52.5127220153808,12.9046039581299 52.5126647949219,12.9048099517823 52.5060577392579,12.9177742004395 52.5061225891114,12.9290132522583 52.5037269592286,12.9338884353639 52.5009117126465,12.9393444061279 52.5030975341796,12.9407567977906 52.5060195922852,12.9432353973389 52.5071105957031,12.945390701294 52.5074272155762,12.9493341445923 52.5045776367189,12.9493341445923 52.5045776367189,12.9534282684326 52.5026016235352,12.9546813964844 52.5044746398927,12.9598722457886 52.5061073303223,12.969084739685 52.5060424804688,12.9955968856811 52.5100059509278,12.9944486618043 52.5126838684083))0.0006POINT(12.95190946679369 52.54509012322678)
16727POLYGON((13.7021350860595 43.0503273010255,13.7014560699463 43.0499420166016,13.7014560699463 43.0499420166016,13.7084531784057 43.0482215881349,13.712685585022 43.044261932373,13.7142276763916 43.0321578979492,13.7141170501709 43.0245513916016,13.7141170501709 43.0245513916016,13.726227760315 43.0240478515626,13.7739582061768 43.0307502746582,13.7890100479127 43.0361976623536,13.7890100479127 43.0361976623536,13.782494544983 43.0458984375,13.7806377410888 43.0547676086426,13.7976903915405 43.0605468750001,13.797703742981 43.0630607604981,13.797703742981 43.0630607604981,13.7879953384399 43.0678024291993,13.7860822677612 43.0807304382324,13.7860822677612 43.0807304382324,13.7775583267212 43.0775032043457,13.7775583267212 43.0775032043457,13.7440423965455 43.0671043395997,13.7440423965455 43.0671043395997,13.724021911621 43.0618209838868,13.7021350860595 43.0503273010255))0.0006POINT(13.753218688964857 43.05275131225591)
73583POLYGON((17.2154788970947 43.4353713989257,17.2043895721436 43.4350166320801,17.1868419647217 43.4368705749512,17.1838779449463 43.4397239685059,17.1804084777833 43.4493293762208,17.1804084777833 43.4493293762208,17.1639575958253 43.4477882385254,17.1611881256104 43.4459075927734,17.1581249237062 43.4410057067871,17.1530838012695 43.4364242553712,17.1475028991699 43.4351081848145,17.1405239105225 43.4351005554199,17.1375923156739 43.4361724853516,17.1367073059083 43.4390144348145,17.1433982849122 43.4477996826172,17.1441173553467 43.450107574463,17.1433601379395 43.4517631530762,17.1212577819825 43.4560356140138,17.1212577819825 43.4560356140138,17.1113796234132 43.4360466003418,17.1068916320801 43.4309158325196,17.1068916320801 43.4309158325196,17.1059474945068 43.4234962463379,17.1076335906982 43.4161338806153,17.1076335906982 43.4161338806153,17.1124229431153 43.4148178100586,17.1181182861329 43.411548614502,17.1200351715088 43.4090118408204,17.1218338012695 43.4029922485352,17.1252937316896 43.3998756408692,17.1325492858886 43.397144317627,17.1385498046876 43.3933448791504,17.1488685607911 43.3917198181153,17.164701461792 43.3850708007812,17.1773662567139 43.3786239624024,17.1903553009033 43.3681869506837,17.1903553009033 43.3681869506837,17.1933917999268 43.3778228759766,17.1942291259767 43.3843917846681,17.1942291259767 43.3843917846681,17.2053794860841 43.4051704406738,17.2056102752687 43.4245414733888,17.2154788970947 43.4353713989257))0.0006POINT(17.152455829438754 43.42081878298809)
59440POLYGON((7.73172283172613 47.1151504516602,7.73171710968023 47.1162986755371,7.73171710968023 47.1162986755371,7.73556995391851 47.1172904968262,7.73985195159923 47.1220245361329,7.73985195159923 47.1220245361329,7.74893808364862 47.1213417053223,7.75251483917242 47.1195259094238,7.75643587112432 47.1198196411133,7.75767183303827 47.1184921264648,7.76148891448975 47.1173362731934,7.76213788986206 47.1129951477052,7.76355504989635 47.111083984375,7.76355504989635 47.111083984375,7.76307201385492 47.1091194152833,7.75807905197155 47.102352142334,7.74410104751593 47.1020622253419,7.74410104751593 47.1020622253419,7.74393415451055 47.1057777404785,7.74213123321528 47.1074333190919,7.72958087921143 47.1078567504883,7.72953701019298 47.1094665527345,7.73222684860241 47.112663269043,7.73172283172613 47.1151504516602))0.0006POINT(7.74623877069229 47.11302433843202)
49337POLYGON((-1.29543054103851 46.4746704101564,-1.29651749134064 46.4712409973145,-1.31161737442017 46.4700660705566,-1.32166898250568 46.4710769653321,-1.34385943412775 46.478630065918,-1.35759532451624 46.4740943908691,-1.36201620101929 46.4606666564943,-1.36964237689966 46.4571456909181,-1.36964237689966 46.4571456909181,-1.37975633144373 46.4565086364746,-1.39784884452808 46.4732437133789,-1.39864861965179 46.4836387634277,-1.39081680774683 46.4925689697266,-1.39946734905243 46.5050964355469,-1.41356813907623 46.5077743530273,-1.42107975482929 46.5044097900391,-1.42107975482929 46.5044097900391,-1.42973506450653 46.5088539123536,-1.42973506450653 46.5088539123536,-1.44649970531464 46.5260391235351,-1.45523416995997 46.5293083190919,-1.45523416995997 46.5293083190919,-1.46254181861877 46.5419387817383,-1.45938801765442 46.5446052551271,-1.44488716125483 46.5423011779786,-1.44574010372162 46.5524215698242,-1.44097447395325 46.5534553527832,-1.42343902587891 46.5469665527345,-1.39016556739807 46.5405540466309,-1.39016556739807 46.5405540466309,-1.38309836387634 46.5165748596193,-1.33180534839624 46.4941673278809,-1.30686187744141 46.4926376342775,-1.29344618320454 46.4821243286134,-1.29344618320454 46.4821243286134,-1.29543054103851 46.4746704101564))0.0006POINT(-1.386647244862112 46.50214789254332)
32189POLYGON((0.52110326290142 47.3532905578614,0.529947936534882 47.3457031250001,0.537785291671867 47.3236351013184,0.537785291671867 47.3236351013184,0.557163178920803 47.3219070434571,0.557163178920803 47.3219070434571,0.567963719368038 47.3337707519532,0.580976784229279 47.3392868041993,0.593487620353699 47.3542785644532,0.590573251247463 47.3645782470704,0.590573251247463 47.3645782470704,0.58367490768444 47.3682250976563,0.566460072994232 47.3648834228515,0.566460072994232 47.3648834228515,0.52110326290142 47.3532905578614))0.0006POINT(0.5629369871957491 47.346040180751295)
53926POLYGON((6.27181911468506 43.1209716796876,6.28558206558239 43.1393585205078,6.29206371307384 43.1808433532715,6.32010698318487 43.1852493286133,6.32364177703857 43.1876716613771,6.32453441619884 43.1982574462892,6.32453441619884 43.1982574462892,6.34671306610107 43.2048988342285,6.36473798751837 43.2166290283203,6.38812685012823 43.2195625305176,6.398027420044 43.2271385192872,6.43498611450207 43.2202491760254,6.44452905654913 43.2211074829102,6.44452905654913 43.2211074829102,6.45113468170177 43.2076263427734,6.45113468170177 43.2076263427734,6.41666889190685 43.1978187561035,6.41725444793701 43.1873397827149,6.40085268020636 43.1702003479004,6.39672613143927 43.1684226989747,6.37350511550909 43.1644439697266,6.35095310211193 43.1339797973634,6.35108089447027 43.1304664611818,6.36347198486334 43.1259117126465,6.36347198486334 43.1259117126465,6.36402893066412 43.1240272521973,6.36708307266241 43.1243057250977,6.3662509918214 43.1206932067872,6.36375093460094 43.1195831298829,6.36180591583252 43.1223602294923,6.36069393157953 43.1223602294923,6.35958385467541 43.1209716796876,6.35902786254888 43.1168060302736,6.35930585861206 43.1151390075684,6.36319398880016 43.1123619079589,6.36347198486334 43.1104164123536,6.35985994338995 43.1098594665528,6.35791587829596 43.1081962585449,6.35930585861206 43.1073608398438,6.36041593551641 43.1045837402345,6.36736106872559 43.1034736633301,6.36708307266241 43.0968055725098,6.36541700363159 43.0934715270996,6.3662509918214 43.092082977295,6.36875104904186 43.0929183959962,6.3706951141358 43.0915260314943,6.36875104904186 43.0890274047852,6.36486005783081 43.0898628234863,6.36458206176769 43.0859718322754,6.36124992370605 43.0873603820802,6.35958385467541 43.0893058776855,6.35097122192388 43.0887489318848,6.34958314895636 43.0876388549806,6.34569501876842 43.0893058776855,6.34513902664196 43.0904159545899,6.34152889251715 43.0881958007814,6.33902883529669 43.0898628234863,6.33569383621216 43.0898628234863,6.33513784408569 43.0906944274903,6.33152818679815 43.0895843505859,6.33208417892462 43.092082977295,6.33013820648205 43.092082977295,6.32986211776733 43.0931930541992,6.32763814926159 43.0923614501954,6.32402706146252 43.0931930541992,6.32291793823242 43.0915260314943,6.32152700424206 43.0915260314943,6.32124900817871 43.0931930541992,6.32513999938976 43.0954170227051,6.32541513442999 43.10013961792,6.32152700424206 43.0998611450195,6.31874895095831 43.1015281677246,6.31847286224371 43.1031951904297,6.31958293914789 43.1029167175294,6.31986093521124 43.1040267944337,6.31763887405396 43.1043052673341,6.31652688980097 43.106803894043,6.31319522857677 43.106803894043,6.31319522857677 43.1079177856445,6.3068060874939 43.1081962585449,6.30263996124279 43.1076393127441,6.30152797698986 43.1062507629394,6.29791784286505 43.105972290039,6.29736185073858 43.10652923584,6.29874992370611 43.1076393127441,6.29874992370611 43.1093063354493,6.29541683197033 43.1098594665528,6.29513883590698 43.1079177856445,6.29347276687633 43.1076393127441,6.29180479049694 43.1090278625489,6.29152679443359 43.1073608398438,6.28986120223999 43.1062507629394,6.28847312927252 43.1073608398438,6.28819513320917 43.1090278625489,6.28625106811523 43.1101379394532,6.28625106811523 43.1115264892578,6.28847312927252 43.1129150390626,6.28736114501959 43.1154174804688,6.28319406509399 43.1151390075684,6.28236007690441 43.1165275573732,6.27930593490606 43.1159706115724,6.27735996246349 43.1181945800781,6.27763795852667 43.1195831298829,6.27652788162231 43.1209716796876,6.27181911468506 43.1209716796876))0.0006POINT(6.338518133530308 43.122698343717154)
51145POLYGON((2.30471277236938 50.1999244689941,2.30927443504345 50.1978149414064,2.30927443504345 50.1978149414064,2.30216073989868 50.1861267089844,2.30570936203009 50.1741676330566,2.30570936203009 50.1741676330566,2.29671120643616 50.1726417541504,2.29179048538208 50.1675491333007,2.27764940261847 50.1699180603028,2.27400207519543 50.167823791504,2.27400207519543 50.167823791504,2.26298213005077 50.1747360229493,2.27100253105169 50.182945251465,2.27125620841986 50.1896209716798,2.27125620841986 50.1896209716798,2.30471277236938 50.1999244689941))0.0006POINT(2.2884995619456587 50.18084640502936)