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
57222POLYGON((7.34473943710321 50.4766883850098,7.33816432952892 50.4823150634766,7.33816432952892 50.4823150634766,7.34114599227905 50.484775543213,7.35713863372803 50.4919319152832,7.35747289657604 50.494743347168,7.35885238647467 50.4956436157227,7.36804437637335 50.4958419799805,7.37024688720714 50.4947853088379,7.37487125396723 50.4948806762695,7.37443923950195 50.4964904785157,7.37638807296759 50.4988136291504,7.3832740783692 50.5003585815431,7.3832740783692 50.5003585815431,7.38690185546875 50.4976119995118,7.38649129867554 50.4961433410645,7.39031934738165 50.4939842224121,7.39633893966675 50.4945449829102,7.39633893966675 50.4945449829102,7.3943772315979 50.4924011230469,7.39110040664679 50.4917907714843,7.39024686813366 50.4889030456543,7.38720798492437 50.4879035949707,7.38748025894176 50.4867744445801,7.38243436813366 50.4832725524903,7.37983894348156 50.4802742004395,7.37857580184937 50.4797439575196,7.3759617805481 50.4819068908692,7.36671447753906 50.4760284423828,7.36814355850214 50.4696350097657,7.36501312255865 50.4687576293945,7.36114740371704 50.470859527588,7.35505819320684 50.4658355712892,7.35505819320684 50.4658355712892,7.34945535659796 50.4697227478028,7.34713220596325 50.4742927551271,7.34473943710321 50.4766883850098))0.0006POINT(7.371043125788414 50.486130820380346)
48437POLYGON((-0.978909850120544 47.6849670410156,-0.986026883125248 47.6971397399903,-0.977770030498448 47.7201080322266,-0.977770030498448 47.7201080322266,-0.997775256633759 47.725254058838,-0.997775256633759 47.725254058838,-1.00506889820099 47.7206535339357,-1.01002907752979 47.7210769653321,-1.04076993465424 47.7321128845216,-1.04076993465424 47.7321128845216,-1.04721617698669 47.732738494873,-1.04721617698669 47.732738494873,-1.0561213493346 47.7246055603028,-1.0563817024231 47.7178573608399,-1.06357121467585 47.7089920043945,-1.06357121467585 47.7089920043945,-1.05632221698761 47.6935882568359,-1.05632221698761 47.6935882568359,-1.03769123554224 47.691879272461,-1.02174699306482 47.6838417053224,-1.00864458084101 47.6879692077637,-1.00060820579523 47.6843948364258,-1.00060820579523 47.6843948364258,-0.978909850120544 47.6849670410156))0.0006POINT(-1.0229863757672175 47.70975510970411)
42484POLYGON((6.28442144393932 49.2578811645509,6.27980184555054 49.2626342773438,6.27980184555054 49.2626342773438,6.26322698593151 49.2537879943849,6.24257040023815 49.2505493164062,6.23618698120123 49.2410125732422,6.22805976867676 49.2365226745605,6.22805976867676 49.2365226745605,6.24277162551886 49.2270431518555,6.26287031173712 49.2294311523438,6.26287031173712 49.2294311523438,6.27941322326666 49.2201385498048,6.27941322326666 49.2201385498048,6.29014158248901 49.2296371459962,6.29014158248901 49.2296371459962,6.28774404525768 49.242919921875,6.28048610687262 49.2517623901368,6.28442144393932 49.2578811645509))0.0006POINT(6.26576359131762 49.2400990654441)
53457POLYGON((6.99393129348766 43.8834877014161,6.99267864227306 43.8753776550294,6.99267864227306 43.8753776550294,7.00598287582403 43.8728981018067,7.02046918869024 43.8576889038086,7.0296134948731 43.8586311340333,7.03292226791388 43.8562812805176,7.03292226791388 43.8562812805176,7.04940366745006 43.8551406860353,7.04940366745006 43.8551406860353,7.05347776412964 43.8649902343751,7.04979896545416 43.8672103881836,7.04979896545416 43.8672103881836,7.01811313629156 43.8726959228517,7.01089763641363 43.8770790100098,7.00809001922619 43.8835716247559,6.99393129348766 43.8834877014161))0.0006POINT(7.024386405944898 43.86744141578681)
59876POLYGON((7.13333988189703 46.6296195983887,7.13590812683111 46.6199378967286,7.13778781890863 46.6163101196289,7.13725805282593 46.6126327514648,7.13725805282593 46.6126327514648,7.1325101852417 46.6123199462891,7.1225957870484 46.6094398498536,7.12110900878912 46.6099891662598,7.1189661026001 46.6133270263672,7.1189661026001 46.6133270263672,7.11869812011713 46.6145477294922,7.12377309799206 46.6185035705566,7.12448215484619 46.6235923767089,7.12813806533825 46.6259384155275,7.12775993347179 46.6292343139648,7.13333988189703 46.6296195983887))0.0006POINT(7.127903366088898 46.617423502604176)
1388442POLYGON((-3.38072109222412 36.9238014221191,-3.38367104530334 36.9297409057618,-3.38486003875727 36.9430160522462,-3.39273905754089 36.9618644714357,-3.39339995384216 36.9743766784668,-3.3963840007782 36.9822006225587,-3.39198303222656 37.0025329589844,-3.39528298377991 37.0084991455079,-3.40619301795954 37.0160789489747,-3.39030098915089 37.0097694396974,-3.38234901428217 37.0112075805665,-3.3768310546875 37.0070343017578,-3.37211108207697 36.9955101013184,-3.36831092834473 36.9929428100586,-3.37815690040588 36.9844665527345,-3.37997388839722 36.9768981933593,-3.37987995147694 36.9647674560547,-3.38127088546742 36.9641838073732,-3.38203907012934 36.9603691101075,-3.37865209579456 36.9591636657715,-3.3774049282074 36.9527664184571,-3.36429095268244 36.9535713195801,-3.36031198501587 36.9433288574218,-3.35801410675043 36.9442901611328,-3.35780692100525 36.9429931640625,-3.35642790794373 36.9436111450196,-3.34987807273859 36.9404907226563,-3.35145711898798 36.9371223449706,-3.36904096603388 36.9252166748047,-3.37447905540461 36.9190902709962,-3.3680698871612 36.9127006530763,-3.38000607490534 36.9174041748047,-3.38072109222412 36.9238014221191))0.0006POINT(-3.376946814358197 36.96253156661992)
43008POLYGON((6.63487148284918 48.32234954834,6.6374425888061 48.3099212646486,6.6374425888061 48.3099212646486,6.65479183197033 48.3151588439942,6.66024780273443 48.3095436096191,6.6750483512879 48.3099670410157,6.6750483512879 48.3099670410157,6.67315053939825 48.3137283325196,6.67315053939825 48.3137283325196,6.66691160202032 48.3259277343751,6.65957403182995 48.3301429748535,6.65957403182995 48.3301429748535,6.64776992797857 48.3354148864747,6.63487148284918 48.32234954834))0.0006POINT(6.658078743861325 48.31814721914445)
46910POLYGON((3.36521577835094 50.317970275879,3.35598325729376 50.3191528320314,3.34334969520575 50.315185546875,3.34334969520575 50.315185546875,3.34670042991644 50.306941986084,3.34670042991644 50.306941986084,3.3500292301178 50.301742553711,3.3500292301178 50.301742553711,3.35803079605097 50.305305480957,3.36734795570385 50.304557800293,3.36734795570385 50.304557800293,3.37252593040478 50.3109436035157,3.37252593040478 50.3109436035157,3.36521577835094 50.317970275879))0.0006POINT(3.3568566395686847 50.30932088998652)
1406854POLYGON((-5.48191785812372 38.9146919250488,-5.48415422439575 38.9149589538575,-5.48889398574829 38.9245758056641,-5.49282598495478 38.9403343200684,-5.49697923660278 38.9462089538575,-5.50995779037476 38.9788932800294,-5.52086210250854 38.9889068603517,-5.51360511779785 38.9903030395508,-5.51030683517456 38.9923744201661,-5.50754022598261 38.9973907470703,-5.49892711639404 38.9957618713379,-5.48956918716431 38.9972610473633,-5.48404693603516 38.9994049072267,-5.47508096694946 38.9956321716309,-5.46741580963135 38.9952735900879,-5.45345783233643 39.0020446777344,-5.44999599456787 39.006118774414,-5.43222379684443 39.0086975097657,-5.42261505126947 39.0042953491212,-5.41916179656977 39.0046081542969,-5.40990209579468 39.0202941894531,-5.40026092529297 39.0125045776368,-5.39074087142944 39.0090065002442,-5.38368511199945 39.0044746398927,-5.3590521812439 38.9991722106934,-5.32905197143549 38.9959297180176,-5.29625082015991 38.9873542785645,-5.29141902923584 38.9885368347168,-5.28369283676142 38.9870071411134,-5.27029085159302 38.9816818237306,-5.25529909133911 38.9781150817872,-5.23971891403198 38.9781913757324,-5.23259210586542 38.9736518859863,-5.22574090957636 38.9708175659181,-5.22178220748901 38.9708938598633,-5.21709203720093 38.9666595458984,-5.20358800888056 38.9613914489746,-5.20275402069086 38.9560966491699,-5.20488691329945 38.9504470825195,-5.20349693298334 38.9476509094239,-5.20623207092285 38.9402313232422,-5.20231819152832 38.9363861083985,-5.20154094696045 38.9325523376466,-5.20378112792969 38.9292869567872,-5.21600198745722 38.9250259399415,-5.22014808654785 38.9296417236328,-5.23012781143183 38.930793762207,-5.2394590377807 38.9292526245117,-5.24299621582031 38.9266090393067,-5.24763202667231 38.9262123107911,-5.25131511688227 38.9280891418458,-5.25693511962885 38.9271621704101,-5.25994586944574 38.9223899841309,-5.26373386383051 38.9200096130371,-5.2675790786742 38.9201431274414,-5.26894903182983 38.9215393066407,-5.27059221267695 38.9314537048339,-5.27222776412964 38.9350013732911,-5.2755331993103 38.9358825683595,-5.28263282775879 38.9303359985352,-5.28266191482544 38.9254798889161,-5.28523111343378 38.9228248596193,-5.2878270149231 38.9224891662597,-5.29920387268066 38.9251823425293,-5.31678104400629 38.9347000122071,-5.32344722747803 38.9346580505372,-5.33465385437012 38.927448272705,-5.33770322799677 38.9124603271486,-5.34915781021118 38.9041748046876,-5.36581897735596 38.9013977050782,-5.38308620452875 38.9070472717285,-5.39815998077393 38.8989448547364,-5.40621709823608 38.90193939209,-5.4083948135376 38.9097633361816,-5.4189977645874 38.9187240600587,-5.44391584396362 38.92733001709,-5.46218776702881 38.9354057312013,-5.46816587448114 38.9291458129883,-5.47118091583246 38.9216461181641,-5.48191785812372 38.9146919250488))0.0006POINT(-5.343586197382264 38.95286550401135)
66574POLYGON((11.8787527084351 49.5680809020997,11.8846073150636 49.5668830871582,11.8917112350463 49.5675697326661,11.8938150405884 49.5647277832032,11.8959445953369 49.5642585754395,11.8952350616456 49.5627021789551,11.8966417312623 49.5630378723145,11.9010972976684 49.5609245300293,11.9056625366212 49.5616912841797,11.9071683883666 49.5606651306153,11.9080810546875 49.5611495971681,11.907250404358 49.5630035400391,11.9096117019654 49.5628585815431,11.9100685119629 49.5619163513184,11.9126291275026 49.562442779541,11.9125356674195 49.5663032531738,11.9081907272339 49.5709724426271,11.9140357971193 49.5725746154785,11.9164247512817 49.5747680664062,11.9069194793701 49.5785484313965,11.9167938232423 49.5820846557618,11.9264736175538 49.5840072631837,11.9191637039185 49.5859184265137,11.9114484786988 49.5899200439454,11.9073896408081 49.5931091308594,11.9153966903687 49.5980033874512,11.9125928878785 49.6005401611328,11.9160890579224 49.602367401123,11.9181280136108 49.6046562194824,11.917594909668 49.6058311462403,11.921971321106 49.6082153320313,11.9329175949096 49.6041984558107,11.9351367950441 49.6067237854004,11.9357843399048 49.6057090759278,11.9414262771607 49.6063842773439,11.9493589401245 49.605438232422,11.9539012908936 49.6064033508301,11.9538297653199 49.6117782592773,11.9527273178101 49.6137886047363,11.9683656692505 49.6143417358399,11.9683656692505 49.6143417358399,11.9719371795654 49.613395690918,11.9735822677612 49.610179901123,11.9829559326173 49.6101684570314,11.982783317566 49.609504699707,11.9847993850709 49.6093330383302,11.9854097366332 49.6106834411622,11.9916276931763 49.607147216797,11.9931793212891 49.6032028198242,11.9870901107789 49.5988197326661,11.9827280044556 49.596996307373,11.9857387542725 49.5923309326172,11.9849967956542 49.5916023254396,11.988356590271 49.587501525879,11.9876022338867 49.5850563049317,11.9775285720826 49.5837554931641,11.9793853759765 49.5815925598145,11.9835529327393 49.5812110900879,11.9832134246826 49.5796432495118,11.9846067428588 49.5777244567871,11.989351272583 49.5772209167481,11.990740776062 49.576530456543,11.9912424087524 49.5748672485352,11.9958705902101 49.5741844177247,11.9977464675904 49.5753097534179,11.9977464675904 49.5753097534179,11.9965143203736 49.5735206604004,11.9928827285767 49.5719909667969,11.9899644851686 49.5720291137696,11.9876279830934 49.5689849853517,11.9890432357789 49.5682296752931,11.9893970489502 49.5640411376954,11.9934167861939 49.5616226196289,11.99049949646 49.5590133666993,11.9916038513184 49.5571556091309,11.9874515533447 49.5522270202637,11.9862804412842 49.5522193908692,11.984754562378 49.5502166748047,11.9758567810058 49.5511245727539,11.9776868820192 49.5500450134277,11.9787979125976 49.5442733764648,11.9763021469116 49.5440483093262,11.9760503768921 49.5421676635742,11.9848766326904 49.5422973632814,11.9853620529174 49.5410232543945,11.9819145202638 49.5368385314943,11.9841070175172 49.5353317260743,11.9829425811768 49.5330810546876,11.981466293335 49.5308685302734,11.9782152175903 49.531219482422,11.9772081375122 49.5286216735841,11.9788589477539 49.5254669189454,11.9816884994507 49.5264129638672,11.981427192688 49.5251274108887,11.984401702881 49.5240058898926,11.9856309890747 49.5230941772461,11.9853639602662 49.5223617553712,11.9880466461182 49.52197265625,11.9882507324219 49.5249671936036,11.9905605316163 49.5276832580568,11.9916772842407 49.5266952514648,11.9919786453248 49.5221748352052,11.9936361312867 49.5208129882812,11.9969902038575 49.5206871032715,11.9963808059693 49.5188102722168,11.9952840805054 49.5188255310059,11.994592666626 49.5173721313477,11.9954929351807 49.5170783996582,11.9964542388916 49.5181198120117,11.9986152648926 49.5173988342286,11.9955215454102 49.5157012939454,11.9983263015748 49.5152320861817,11.9978170394899 49.5142211914064,11.999568939209 49.5116806030274,12.0041952133179 49.5120239257812,12.004041671753 49.5132942199707,12.0098800659181 49.509994506836,12.0098800659181 49.509994506836,12.0071115493774 49.5093955993653,12.0041980743409 49.5072555541992,11.9913921356201 49.5086746215821,11.9892530441285 49.5074348449708,11.9867706298829 49.5080337524414,11.9800634384156 49.5074043273926,11.9738807678223 49.5036163330078,11.9734992980958 49.5051231384278,11.9700002670288 49.5041236877441,11.9687213897706 49.5020637512208,11.9671716690065 49.5015258789062,11.9658184051514 49.5024604797364,11.9646100997925 49.5018005371094,11.9629898071289 49.5034675598146,11.9599199295044 49.5029411315918,11.9579658508301 49.5059089660645,11.9556398391725 49.5062179565431,11.9568204879761 49.5073280334473,11.9554204940796 49.5091133117676,11.9526405334473 49.5061836242676,11.9505453109741 49.5063552856446,11.9500627517701 49.508888244629,11.9467878341676 49.508186340332,11.9414634704591 49.5094223022462,11.9379663467408 49.5075340270996,11.9360694885254 49.5078811645508,11.9352741241456 49.5062370300293,11.933741569519 49.5058135986329,11.9311246871949 49.5056152343751,11.9262180328369 49.5074043273926,11.924958229065 49.5059242248536,11.9234580993652 49.5065841674805,11.9221897125245 49.5053024291993,11.9209499359132 49.4989128112794,11.9197340011598 49.498893737793,11.917597770691 49.4930076599121,11.9146976470948 49.4906883239747,11.9115505218506 49.4898071289064,11.9115524291993 49.4912757873536,11.8991394042969 49.4952011108398,11.8986101150514 49.4969444274903,11.9006214141847 49.4986457824708,11.898383140564 49.5000762939454,11.895920753479 49.4994697570802,11.8923950195312 49.5003204345704,11.8903913497925 49.4991722106934,11.8766365051271 49.502010345459,11.8766365051271 49.502010345459,11.8725852966309 49.5080680847169,11.8709325790406 49.5087471008301,11.8725042343141 49.5119819641114,11.8781261444092 49.5157318115235,11.8788347244263 49.5183792114258,11.8833904266357 49.5181121826172,11.8867568969727 49.5160217285156,11.8880033493043 49.5203781127929,11.8895473480225 49.5207176208496,11.8901023864747 49.5227279663086,11.8868026733399 49.5237846374512,11.8830022811891 49.52250289917,11.8831634521485 49.5246009826661,11.8831634521485 49.5246009826661,11.8841085433961 49.5262298583985,11.8806686401368 49.5316276550294,11.8820285797119 49.5322303771973,11.8827867507934 49.5340461730957,11.8811902999879 49.5357284545899,11.8831920623779 49.536117553711,11.8825712203979 49.5366401672364,11.8954935073853 49.5336380004883,11.8949203491211 49.5324745178224,11.8974370956421 49.5315437316894,11.8977346420288 49.5299224853515,11.9141368865967 49.5310859680176,11.9157943725587 49.5324668884278,11.91490650177 49.5337562561036,11.9210777282716 49.534538269043,11.918402671814 49.543025970459,11.9176654815674 49.5438270568848,11.9130153656006 49.5436935424805,11.9116687774659 49.5491333007814,11.9132909774781 49.5495414733887,11.9134664535523 49.550537109375,11.9038276672364 49.5510063171387,11.8992509841919 49.5543479919434,11.8952112197877 49.5519332885743,11.8914327621459 49.5554122924805,11.8839664459229 49.556209564209,11.8788309097291 49.5594062805176,11.8725776672364 49.5604667663575,11.8744964599609 49.5644302368165,11.8787527084351 49.5680809020997))0.0006POINT(11.943686252575768 49.54384948876487)