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
1403502POLYGON((2.54566502571112 42.1164627075195,2.54783010482799 42.1247749328613,2.55111908912659 42.1228332519532,2.55538105964672 42.1256484985352,2.5614910125733 42.1245880126954,2.56852006912237 42.1258659362794,2.57313990592968 42.1251983642579,2.57774806022638 42.119972229004,2.59393000602734 42.1167335510254,2.60547900199896 42.1108665466309,2.60907292366039 42.1072044372559,2.61552309989941 42.1064567565918,2.61137199401867 42.1009674072267,2.61384510993963 42.0985717773438,2.61709308624262 42.0996360778809,2.6198029518128 42.0955505371094,2.63142395019543 42.0893516540528,2.63119006156927 42.0854759216309,2.63379502296448 42.0835113525391,2.63124895095825 42.0793533325196,2.63788604736334 42.0710830688477,2.63627195358276 42.0648727416993,2.63883399963385 42.0609283447265,2.6374819278717 42.0589179992677,2.63915109634394 42.0586433410645,2.63921689987194 42.0550498962403,2.63100004196173 42.048210144043,2.63226795196539 42.0441131591798,2.63009309768688 42.0381050109864,2.63703107833874 42.0380439758301,2.64202904701233 42.0338096618652,2.64355397224426 42.0292167663574,2.65869593620306 42.0209503173829,2.66139698028564 42.0165672302247,2.65840506553644 42.01713180542,2.65831089019781 42.0187911987305,2.65276408195507 42.0192642211915,2.64335608482367 42.0163650512695,2.636873960495 42.0165023803711,2.63615798950195 42.0137481689454,2.63187789916998 42.0135154724122,2.62554192543035 42.0228309631349,2.62128210067755 42.0251617431641,2.61468195915228 42.024242401123,2.60439610481268 42.0331497192383,2.6018888950349 42.0382766723633,2.59851598739624 42.0405769348146,2.59901690483105 42.0438079833984,2.60197997093212 42.0456275939941,2.59592390060425 42.0500984191896,2.59678101539618 42.0568084716797,2.6005420684815 42.0590362548828,2.60027503967285 42.0634155273437,2.59056591987616 42.0619392395021,2.58117198944103 42.0672302246093,2.57812190055841 42.070613861084,2.57496094703674 42.0711898803712,2.5664050579071 42.086612701416,2.56234788894653 42.0869331359864,2.5541410446167 42.0948066711426,2.55169606208807 42.1013984680176,2.55276393890387 42.1047668457032,2.54566502571112 42.1164627075195))0.0006POINT(2.60887624371441 42.06711898311495)
57475POLYGON((7.51716327667242 49.5835227966309,7.51921319961548 49.5850715637208,7.51821708679211 49.5821723937989,7.52056074142462 49.5801620483399,7.51890230178833 49.5794296264649,7.52058219909668 49.57763671875,7.51928663253796 49.5773086547852,7.51725530624395 49.5721778869629,7.52070665359497 49.5707015991212,7.51765394210815 49.5661201477051,7.51564931869513 49.5658607482911,7.51750612258923 49.5616149902344,7.52214431762707 49.5578117370607,7.52214431762707 49.5578117370607,7.52124452590948 49.5566787719727,7.52565050125122 49.5552940368653,7.52565050125122 49.5552940368653,7.51832962036144 49.5541839599609,7.50952196121222 49.5582542419434,7.50952196121222 49.5582542419434,7.50861358642578 49.5603981018066,7.50847053527832 49.5659866333008,7.50952386856079 49.5675163269044,7.50827455520636 49.5693397521973,7.50932168960583 49.5771636962892,7.51022577285761 49.5788726806641,7.51716327667242 49.5835227966309))0.0006POINT(7.516589788290218 49.56825535114)
50015POLYGON((3.39056611061096 49.4367752075196,3.38264513015758 49.4354438781738,3.38264513015758 49.4354438781738,3.35543775558472 49.4372596740724,3.35543775558472 49.4372596740724,3.34702944755549 49.441204071045,3.34702944755549 49.441204071045,3.34523820877081 49.4556884765626,3.34523820877081 49.4556884765626,3.36907291412354 49.4551429748536,3.37646675109875 49.4631996154786,3.37646675109875 49.4631996154786,3.3792941570282 49.4632644653321,3.3792941570282 49.4632644653321,3.38570880889904 49.4580650329591,3.38994073867809 49.4451828002931,3.38994073867809 49.4451828002931,3.39056611061096 49.4367752075196))0.0006POINT(3.370438365375342 49.448968775132215)
22946POLYGON((0.368404805660248 44.0899887084961,0.359314024448395 44.0893363952637,0.350191712379456 44.0966110229493,0.309423387050686 44.0999031066895,0.309423387050686 44.0999031066895,0.302619785070533 44.1042289733887,0.301648318767604 44.1107444763184,0.291204005479926 44.1211318969727,0.28304156661045 44.1182250976562,0.280145257711411 44.1207580566407,0.280145257711411 44.1207580566407,0.291106760501805 44.1328811645507,0.291106760501805 44.1328811645507,0.299837917089405 44.147819519043,0.287891983985901 44.1619987487793,0.28856161236763 44.1715621948243,0.28856161236763 44.1715621948243,0.311030566692466 44.1655654907227,0.32443159818655 44.1695251464844,0.329560935497398 44.1753959655762,0.343336850404853 44.1783676147462,0.343336850404853 44.1783676147462,0.345155090093613 44.1715965270997,0.398134857416153 44.1496925354004,0.398134857416153 44.1496925354004,0.39144158363348 44.1445541381836,0.389262497425136 44.1307334899902,0.395042419433707 44.1211090087891,0.414524793624935 44.110538482666,0.414524793624935 44.110538482666,0.377925008535385 44.0975914001465,0.378390878438893 44.0942611694337,0.378390878438893 44.0942611694337,0.370211720466671 44.0960388183595,0.368404805660248 44.0899887084961))0.0006POINT(0.3378077745437957 44.13023892570948)
34055POLYGON((3.85263061523443 48.3738327026368,3.86760544776928 48.3704605102539,3.88265872001648 48.3726692199707,3.8919358253479 48.3702621459961,3.89661049842834 48.3640518188477,3.89326024055492 48.3504371643067,3.89859819412243 48.3444595336915,3.89498591423035 48.3384056091309,3.89498591423035 48.3384056091309,3.87863326072704 48.3297462463379,3.87340211868286 48.3299903869629,3.83695030212408 48.3550605773927,3.83263492584234 48.3570594787598,3.82804512977611 48.3553581237794,3.82804512977611 48.3553581237794,3.83895826339722 48.3658523559571,3.84007239341747 48.3722038269044,3.84850168228155 48.3757247924806,3.85263061523443 48.3738327026368))0.0006POINT(3.8654730319977366 48.35662990146219)
61917POLYGON((9.55250167846685 53.4310989379883,9.55180168151867 53.4303550720214,9.55314254760737 53.4288330078126,9.54749202728266 53.4265403747558,9.52750110626226 53.4123573303223,9.51707935333263 53.4067573547363,9.51478290557873 53.4019241333008,9.51338481903088 53.4017028808594,9.51315498352056 53.399341583252,9.51315498352056 53.399341583252,9.51035213470459 53.3984756469727,9.50982379913341 53.3968849182129,9.5119199752807 53.3965301513672,9.51129245758051 53.3957633972169,9.50724506378174 53.3949928283692,9.50454521179194 53.3965148925781,9.50578975677496 53.3977851867676,9.50616741180431 53.4021644592285,9.51182746887213 53.4053001403809,9.50951671600347 53.4071617126465,9.51204872131359 53.4078483581542,9.50626754760742 53.4083251953124,9.49444007873541 53.4156227111818,9.48301029205334 53.4174308776855,9.47342109680176 53.4150772094727,9.45877742767345 53.4185714721681,9.45124435424816 53.4277992248536,9.44587516784674 53.4295501708984,9.4472160339356 53.4307403564454,9.43499755859375 53.4358863830566,9.43365383148193 53.4344177246095,9.43178081512463 53.434326171875,9.43598842620855 53.437614440918,9.43842124938965 53.4405860900879,9.43799018859869 53.4415740966797,9.43799018859869 53.4415740966797,9.44089508056635 53.4444389343263,9.44769859313959 53.4479370117189,9.45209980010986 53.4524230957031,9.4562978744508 53.4536361694337,9.45996856689447 53.4559669494629,9.46383380889898 53.4567260742189,9.4654159545899 53.4560127258301,9.46636390686035 53.4569740295411,9.47120666503901 53.456199645996,9.47437953948986 53.458366394043,9.47839450836187 53.4580841064454,9.48587322235113 53.4602279663086,9.49618816375738 53.4596023559571,9.50399875640881 53.4611396789551,9.50193977355968 53.4622840881348,9.50439548492443 53.4648895263672,9.50590229034424 53.4648857116699,9.50526809692377 53.467601776123,9.50783061981207 53.4675140380859,9.50636482238764 53.4693031311035,9.50698375701904 53.4697570800781,9.50158023834229 53.4729957580567,9.50269794464117 53.4755058288575,9.50198554992676 53.4773063659668,9.49990844726568 53.4763374328613,9.49785995483398 53.4778213500977,9.49214839935314 53.4779014587402,9.4911088943482 53.4827041625976,9.49145984649664 53.4923667907715,9.49075698852533 53.4949531555177,9.48110294342052 53.499813079834,9.48110294342052 53.499813079834,9.48614788055431 53.5030670166017,9.49516487121582 53.5046882629396,9.50936603546148 53.5049057006837,9.50936603546148 53.5049057006837,9.50924205780024 53.5029945373536,9.51450538635265 53.5030364990235,9.51497077941895 53.5053939819337,9.51759338378906 53.5050697326661,9.51762962341314 53.5042266845704,9.52079772949213 53.5034675598145,9.52321529388439 53.5016059875489,9.53000545501709 53.4989738464357,9.53197765350342 53.5000190734863,9.53516769409191 53.4973602294923,9.53850841522222 53.4967079162599,9.53614139556885 53.4939842224122,9.5371236801148 53.4929466247559,9.53681468963629 53.4917755126954,9.53305053710938 53.4910621643066,9.53708076477051 53.4862136840821,9.53949451446533 53.4852333068849,9.54704666137695 53.4873695373536,9.54796886444086 53.4893226623535,9.54988098144537 53.4905471801758,9.55368995666504 53.4905319213867,9.55368995666504 53.4905319213867,9.55319118499767 53.4889640808105,9.54877662658697 53.4864196777344,9.54593658447277 53.485969543457,9.54332542419434 53.4833869934082,9.53857135772711 53.481517791748,9.53433609008795 53.4783172607421,9.53036212921148 53.478485107422,9.52928733825695 53.4773635864257,9.53034973144526 53.4768867492675,9.5275449752807 53.4760932922364,9.52623367309565 53.4727706909181,9.54102516174328 53.4668807983398,9.54934215545654 53.4646339416505,9.55016326904308 53.4626159667969,9.54767036437994 53.4606361389161,9.5516300201416 53.4577407836914,9.56116676330566 53.4572486877441,9.57627105712902 53.4596176147462,9.5819263458252 53.4620780944824,9.5819263458252 53.4620780944824,9.5845251083374 53.4616737365723,9.59352397918713 53.4554481506348,9.58649349212652 53.4498710632324,9.58557224273687 53.4481735229493,9.58670902252203 53.4442901611329,9.55935859680187 53.4420890808106,9.55886650085461 53.4398040771484,9.54925918579107 53.4392814636232,9.5497732162475 53.4357147216797,9.55250167846685 53.4310989379883))0.0006POINT(9.512824136067245 53.45788822329143)
46133POLYGON((1.63551127910614 43.9333305358887,1.63106977939606 43.9346809387207,1.62511634826666 43.9439773559571,1.60758554935455 43.9497108459473,1.58959805965435 43.9450531005859,1.57999384403229 43.9455223083496,1.57752013206493 43.9388122558594,1.57752013206493 43.9388122558594,1.56595242023474 43.9440879821778,1.53873598575598 43.9473457336427,1.53956294059765 43.9539718627929,1.5352675914765 43.9596672058105,1.5352675914765 43.9596672058105,1.54837357997894 43.9568519592286,1.55229127407074 43.9630355834962,1.55229127407074 43.9630355834962,1.56641566753393 43.9653091430665,1.58931815624243 43.9604072570801,1.62271916866302 43.9607048034669,1.62271916866302 43.9607048034669,1.64187419414526 43.9606132507324,1.64811813831335 43.9553146362304,1.63551127910614 43.9333305358887))0.0006POINT(1.5855828306892141 43.951846209439395)
14078MULTIPOLYGON(((10.896050453186 44.7432289123536,10.8917579650879 44.7382164001465,10.8917579650879 44.7382164001465,10.8890609741212 44.7410774230957,10.8898038864136 44.7421989440918,10.896050453186 44.7432289123536)),((10.8934574127198 44.7359466552736,10.8975639343262 44.7313880920411,10.8962182998657 44.7291870117188,10.892240524292 44.7298278808595,10.892240524292 44.7298278808595,10.8934574127198 44.7359466552736)),((10.782977104187 44.6287078857422,10.795446395874 44.6454849243165,10.7959213256836 44.651065826416,10.7973937988281 44.6534271240234,10.8056383132935 44.6561813354493,10.8162965774537 44.657470703125,10.8162965774537 44.657470703125,10.8286304473878 44.6607704162598,10.8334074020386 44.6610908508302,10.8380432128906 44.6609344482422,10.8445472717286 44.6588172912599,10.8515701293945 44.6591491699219,10.8544883728028 44.6667556762695,10.8657970428468 44.681007385254,10.8696393966675 44.6941299438477,10.8737258911133 44.6991310119629,10.8791923522949 44.6976280212403,10.8852891921997 44.7096481323243,10.8866367340088 44.7134437561035,10.886031150818 44.7146377563477,10.886031150818 44.7146377563477,10.8923883438111 44.7269821166993,10.8923883438111 44.7269821166993,10.8970556259156 44.7258682250978,10.9009485244752 44.7209815979005,10.9051103591919 44.7192916870118,10.909966468811 44.7179946899415,10.9189214706421 44.7177619934083,10.9227352142335 44.7185325622558,10.9288330078125 44.7158813476563,10.9310159683228 44.7139892578126,10.9290609359742 44.7098579406739,10.9485435485839 44.7055168151857,10.9580020904542 44.7146186828614,10.9669322967529 44.7203559875489,10.9669322967529 44.7203559875489,10.9803686141968 44.7101745605469,10.9973945617676 44.7015800476074,11.0018148422242 44.7014923095703,11.0066013336182 44.7052078247071,11.0066013336182 44.7052078247071,11.0114622116088 44.7021522521973,11.0089025497436 44.7002639770509,11.0036725997925 44.6993598937989,10.9973106384278 44.6887664794922,11.0097513198853 44.6853981018066,11.0097513198853 44.6853981018066,10.9933576583862 44.6678581237793,10.9934129714966 44.6634063720704,10.9934129714966 44.6634063720704,10.9845895767212 44.6522102355957,10.9869298934938 44.6352615356446,10.9848337173462 44.6292953491212,10.9892416000366 44.6233444213868,10.9912786483765 44.6234283447267,10.9970655441285 44.6269226074219,10.9970655441285 44.6269226074219,10.9970245361329 44.6250038146973,10.9996662139893 44.6186752319337,11.0084638595581 44.6125755310059,11.0119533538818 44.6071357727052,11.0046586990356 44.5988006591798,10.9990758895875 44.6002883911133,10.9929866790773 44.5960731506349,10.9894580841066 44.5736770629882,10.9900283813476 44.571949005127,10.9900283813476 44.571949005127,10.9857912063599 44.5702934265138,10.979829788208 44.5731086730958,10.9745044708252 44.5801773071289,10.9724330902099 44.5811271667481,10.9722871780396 44.5801429748536,10.9722871780396 44.5801429748536,10.9677438735961 44.5784034729004,10.9589490890503 44.5808715820314,10.9475793838501 44.5708122253419,10.93563079834 44.5644226074219,10.9280881881715 44.567050933838,10.9279718399048 44.5690116882324,10.9110307693481 44.5813293457031,10.899495124817 44.5920639038087,10.8950052261353 44.5944862365723,10.8950052261353 44.5944862365723,10.8823652267456 44.5956230163575,10.8653459548951 44.6011543273926,10.8538904190063 44.6037902832032,10.8524618148805 44.603271484375,10.8504428863527 44.5990600585938,10.8486013412476 44.5980072021485,10.8316526412964 44.6003303527832,10.8255929946901 44.6113815307618,10.8277263641357 44.6190757751465,10.8100137710571 44.6209678649903,10.8090066909791 44.6185798645021,10.7997179031373 44.6222457885743,10.7854328155517 44.6257553100586,10.7854328155517 44.6257553100586,10.782977104187 44.6287078857422)))0.0006POINT(10.919992864876932 44.647414977966754)
41498POLYGON((6.05305337905889 48.7326240539551,6.05509090423595 48.728141784668,6.05509090423595 48.728141784668,6.07075881958008 48.7204132080079,6.07577991485601 48.7208976745607,6.07577991485601 48.7208976745607,6.09200572967541 48.7277336120607,6.09644317626959 48.733268737793,6.09644317626959 48.733268737793,6.08098030090332 48.7463264465332,6.10481595993048 48.7589645385742,6.11459922790539 48.7609329223633,6.11459922790539 48.7609329223633,6.09517049789429 48.7616119384767,6.08468484878546 48.7682456970215,6.07531023025513 48.7699813842775,6.07531023025513 48.7699813842775,6.06763648986816 48.7756347656251,6.06763648986816 48.7756347656251,6.03888511657726 48.7690238952637,6.01880216598516 48.779857635498,6.01880216598516 48.779857635498,6.01365327835083 48.7748947143555,5.99723148345947 48.7704010009767,5.99723148345947 48.7704010009767,5.99082040786749 48.7659263610839,5.99408435821533 48.760166168213,5.99076557159435 48.7547607421876,5.99076557159435 48.7547607421876,6.00820302963257 48.7474441528321,6.00820302963257 48.7474441528321,6.02435731887823 48.7556419372559,6.04438972473145 48.7567253112794,6.04207181930548 48.7470817565918,6.04906749725353 48.7421874999999,6.05305337905889 48.7326240539551))0.0006POINT(6.0508149555751745 48.75343453543532)
22129POLYGON((-0.00152733025606722 44.781925201416,0.0239574443550055 44.7767753601074,0.0239574443550055 44.7767753601074,0.0269260574132772 44.7749366760255,0.0269260574132772 44.7749366760255,0.0197859574110453 44.7664642333986,0.0205197185277939 44.750228881836,0.0205197185277939 44.750228881836,0.0185600854456425 44.7437896728517,0.000349193374916013 44.7441558837892,0.000349193374916013 44.7441558837892,-0.00580929731950164 44.7621688842773,-0.00580929731950164 44.7621688842773,-0.000157243659373307 44.7719001770021,-0.00152733025606722 44.781925201416))0.0006POINT(0.012039121546016374 44.762900761195645)