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
61921POLYGON((9.50936603546148 53.5049057006837,9.50995922088634 53.5079917907715,9.51694774627691 53.5096397399903,9.52027702331549 53.5090904235841,9.52072334289551 53.5113487243653,9.52524757385248 53.5140113830567,9.5255584716798 53.5169868469238,9.52342319488531 53.5207901000977,9.52524852752697 53.5221061706543,9.52524852752697 53.5221061706543,9.5399045944215 53.5242309570314,9.55109882354736 53.5272521972657,9.55868721008301 53.5270233154297,9.56627082824707 53.5288352966309,9.57691764831549 53.5292282104493,9.57691764831549 53.5292282104493,9.57724761962902 53.5268020629883,9.58183765411377 53.5213012695312,9.5933656692506 53.517765045166,9.5933656692506 53.517765045166,9.59468746185308 53.5165328979492,9.59091567993164 53.51375579834,9.59194183349604 53.5115280151367,9.60342407226562 53.5092811584474,9.61488056182867 53.5108146667482,9.61488056182867 53.5108146667482,9.61597347259521 53.5092811584474,9.61373138427734 53.5077209472656,9.61357307434082 53.5037002563477,9.61249446868908 53.5018157958984,9.60778999328625 53.4997100830078,9.60540199279785 53.5016708374024,9.60350131988531 53.500846862793,9.60483932495117 53.4997634887696,9.60223388671886 53.4984588623047,9.59128952026362 53.5030021667482,9.59013080596935 53.4992637634277,9.58850479125982 53.498462677002,9.58850479125982 53.498462677002,9.58718585968023 53.5017318725587,9.58414745330822 53.5050086975098,9.58003139495855 53.5014801025391,9.57401657104498 53.4993400573732,9.57252597808832 53.4972610473633,9.56916522979748 53.4959259033203,9.56398868560791 53.4955787658691,9.56476497650152 53.4946823120118,9.56181335449213 53.4947280883788,9.55762958526617 53.492748260498,9.55635070800781 53.4910278320313,9.55368995666504 53.4905319213867,9.55368995666504 53.4905319213867,9.54988098144537 53.4905471801758,9.54796886444086 53.4893226623535,9.54704666137695 53.4873695373536,9.53949451446533 53.4852333068849,9.53708076477051 53.4862136840821,9.53305053710938 53.4910621643066,9.53681468963629 53.4917755126954,9.5371236801148 53.4929466247559,9.53614139556885 53.4939842224122,9.53850841522222 53.4967079162599,9.53516769409191 53.4973602294923,9.53197765350342 53.5000190734863,9.53000545501709 53.4989738464357,9.52321529388439 53.5016059875489,9.52079772949213 53.5034675598145,9.51762962341314 53.5042266845704,9.51759338378906 53.5050697326661,9.51497077941895 53.5053939819337,9.51450538635265 53.5030364990235,9.50924205780024 53.5029945373536,9.50936603546148 53.5049057006837))0.0006POINT(9.560604545805226 53.50501643286814)
28247POLYGON((4.93495035171514 47.3260536193849,4.92235565185558 47.3356819152833,4.92340183258057 47.3423271179199,4.91997718811035 47.3447341918945,4.91507291793835 47.3450317382814,4.90975093841564 47.3395652770997,4.90008878707886 47.3401718139649,4.90008878707886 47.3401718139649,4.89032030105591 47.3283729553223,4.89032030105591 47.3283729553223,4.90355634689342 47.291904449463,4.89720487594604 47.2758445739747,4.89720487594604 47.2758445739747,4.90493488311779 47.2789039611818,4.91231632232666 47.2944526672363,4.91231632232666 47.2944526672363,4.91514205932623 47.3009414672853,4.91259622573858 47.3104934692384,4.92484140396124 47.3144989013673,4.93495035171514 47.3260536193849))0.0006POINT(4.909812651182517 47.31620105944189)
27894POLYGON((0.624763309955597 48.723445892334,0.618744194507713 48.7307777404786,0.618744194507713 48.7307777404786,0.636983394622746 48.741325378418,0.64626985788351 48.7529182434083,0.64626985788351 48.7529182434083,0.687699973583278 48.7407531738282,0.711766719818115 48.7426033020021,0.715012133121547 48.7452316284179,0.715012133121547 48.7452316284179,0.728735804557743 48.7309417724609,0.728735804557743 48.7309417724609,0.715588867664337 48.7264556884766,0.697835564613399 48.7327270507813,0.674652814865226 48.7196884155273,0.674652814865226 48.7196884155273,0.654293000698203 48.7303314208986,0.624763309955597 48.723445892334))0.0006POINT(0.6762212024015973 48.73510338278381)
1388654POLYGON((-2.96349811553949 38.005443572998,-2.95873308181763 38.0103569030763,-2.94734096527088 38.0128631591797,-2.9363489151001 38.0100402832032,-2.93301510810846 38.0079574584962,-2.92795300483698 38.0001907348632,-2.91182994842524 37.9861755371094,-2.88661408424372 37.9815673828126,-2.88605999946594 37.978816986084,-2.87674999237055 37.9836387634278,-2.87183094024653 37.9828567504883,-2.86111307144154 38.0154266357423,-2.85882210731495 38.0092048645021,-2.85123896598816 38.007926940918,-2.84864592552179 38.0056953430176,-2.84983301162714 38.0041007995605,-2.84811711311329 38.0020713806153,-2.82889890670771 37.9942932128906,-2.82501602172852 37.9889259338379,-2.81628394126892 37.9879913330078,-2.81443095207214 37.98641204834,-2.81424188613892 37.9797325134277,-2.8185019493103 37.9749450683594,-2.81910800933832 37.9693946838379,-2.81488704681396 37.9681739807129,-2.81544089317322 37.9656143188478,-2.81880688667297 37.9623298645019,-2.81850600242609 37.9549369812012,-2.82443189620972 37.9523239135742,-2.8324139118194 37.9454879760742,-2.84060502052307 37.9577445983886,-2.84423995018 37.9560356140136,-2.84997391700739 37.9515304565431,-2.85217189788818 37.9453048706055,-2.86032891273493 37.9350471496581,-2.86827111244202 37.929542541504,-2.87612104415894 37.9313468933106,-2.88933300971979 37.9379463195801,-2.89809393882746 37.9395751953125,-2.90502691268915 37.9369506835938,-2.91071605682362 37.9372596740723,-2.91640400886536 37.9393577575684,-2.91932392120356 37.9439888000489,-2.9225668907165 37.9441108703614,-2.92678093910212 37.9408607482911,-2.93927597999573 37.9425964355469,-2.94324803352356 37.9416084289551,-2.95372796058655 37.9281005859375,-2.95567393302917 37.9281311035156,-2.9602530002594 37.9177207946777,-2.97119498252869 37.9235305786133,-2.97722506523127 37.9225769042969,-2.98077607154846 37.9174194335938,-2.98483991622925 37.9154205322266,-2.98984503746021 37.9156532287598,-2.99784302711487 37.9188385009766,-2.99877500534058 37.9256858825685,-2.99720406532288 37.9269943237305,-3.00032210350037 37.9291191101075,-3.00760602951044 37.9283256530763,-3.00892591476435 37.931480407715,-3.01721096038813 37.9345741271973,-3.02485704421997 37.9371109008789,-3.03010392189026 37.9364089965821,-3.0360341072082 37.9379463195801,-3.04120302200312 37.9428939819337,-3.04371500015253 37.9563026428223,-3.0393431186676 37.9571151733398,-3.03539395332336 37.9553222656251,-3.02224707603449 37.9605293273926,-3.02252292633051 37.9646301269532,-3.02548408508295 37.9664306640624,-3.02258300781244 37.9718551635743,-3.01115298271174 37.9789962768556,-3.00866794586182 37.9777259826661,-3.00615501403797 37.9904632568359,-3.00179195404041 37.9947242736818,-2.99920797348022 37.9947509765626,-2.99184799194336 37.9988441467286,-2.98777294158924 37.9965286254884,-2.98266792297358 38.002555847168,-2.96922993659962 38.0003814697265,-2.96349811553949 38.005443572998))0.0006POINT(-2.928592673162097 37.96257060911599)
1404120POLYGON((0.782320976257438 41.8586654663087,0.782595992088318 41.8547744750977,0.768751025200004 41.851791381836,0.768675029277915 41.8568534851075,0.761756002902985 41.8596305847168,0.763803005218563 41.86185836792,0.760640978813228 41.8675270080567,0.767202973365897 41.8742103576661,0.763364970684052 41.8833312988282,0.764728009700775 41.8870391845703,0.759585976600704 41.8879470825195,0.759416997432766 41.8897819519043,0.754171013832206 41.8893051147461,0.748301982879752 41.8954734802246,0.74390101432806 41.8966636657715,0.738879978656882 41.8959274291993,0.735664010047969 41.900074005127,0.731873989105168 41.8979454040527,0.7204470038414 41.898307800293,0.719874024391174 41.8967895507813,0.710593998432159 41.8982315063476,0.701591014862117 41.908863067627,0.689099013805446 41.9154930114746,0.669551014900321 41.9223327636719,0.674093008041382 41.9237327575684,0.682156980037689 41.9299888610839,0.684207975864524 41.9381752014161,0.706632971763668 41.9451141357423,0.713320016861076 41.9449806213379,0.719169974327087 41.9402046203614,0.725628972053585 41.9393196105958,0.732892990112305 41.9310951232911,0.742897987365723 41.9302139282227,0.746327996254024 41.9328002929688,0.745425999164581 41.9373512268067,0.755690991878566 41.9425086975098,0.769006013870353 41.9551734924316,0.783327996730861 41.959285736084,0.795666992664451 41.9588508605957,0.81180602312088 41.9664649963379,0.830731987953186 41.9730186462403,0.833406984806174 41.9765930175782,0.840296983718929 41.9806060791017,0.840286016464233 41.9663772583008,0.843110024929047 41.9659843444825,0.847079992294368 41.9531936645508,0.850214004516715 41.9511413574219,0.849888026714439 41.9423294067383,0.859256982803458 41.9405097961426,0.856593012809867 41.929702758789,0.859872996807155 41.9257316589356,0.859354972839412 41.922145843506,0.86299699544918 41.9219436645508,0.864641010761318 41.9190330505372,0.856389999389762 41.9137916564941,0.854286015033779 41.9108543395997,0.855177998542842 41.9088363647462,0.858307003975028 41.9073524475098,0.880688011646384 41.9093055725098,0.879001021385307 41.9025382995605,0.871165990829581 41.8959846496583,0.868358016014213 41.8969650268555,0.866007983684597 41.8947753906251,0.856741011142731 41.8943824768066,0.845287978649139 41.8975524902344,0.824730992317313 41.8937721252441,0.818615972995815 41.8886451721191,0.820762991905326 41.8846397399902,0.819761991500968 41.8816032409668,0.801285028457642 41.8776397705078,0.799158990383205 41.8747215270996,0.793161988258419 41.8766212463379,0.795884013176078 41.8694610595703,0.783819973468781 41.8669242858887,0.782320976257438 41.8586654663087))0.0006POINT(0.7878562953021682 41.91133452750542)
67408MULTIPOLYGON(((8.52771186828613 48.4608230590821,8.53140258789068 48.4601707458497,8.53519630432129 48.4576377868653,8.5361499786377 48.4557762145997,8.5326356887818 48.451042175293,8.5364494323731 48.4449501037598,8.5453023910523 48.4450073242189,8.5453023910523 48.4450073242189,8.55480289459229 48.4457778930663,8.56032657623291 48.4500122070312,8.56177139282232 48.4490509033203,8.56538009643555 48.4494285583497,8.56622791290289 48.4522590637208,8.57109451293945 48.45365524292,8.57065296173107 48.4552574157715,8.57191181182867 48.4556770324708,8.57312870025635 48.4545021057129,8.57549381256115 48.455593109131,8.57565689086914 48.4569358825683,8.57844066619884 48.4573364257813,8.57802867889416 48.4585342407228,8.57802867889416 48.4585342407228,8.56878089904791 48.4585456848145,8.55262851715099 48.4711952209474,8.54398822784418 48.4711227416993,8.54398822784418 48.4711227416993,8.54006862640381 48.4696960449219,8.53637313842773 48.4711036682129,8.52872943878168 48.4687728881837,8.52508449554449 48.4662628173829,8.52771186828613 48.4608230590821)),((8.54793453216558 48.4373359680176,8.52845382690441 48.4273147583008,8.53202533721924 48.4275665283204,8.52978897094738 48.4253768920898,8.53059577941895 48.42045211792,8.52909183502203 48.4178619384766,8.53466129302984 48.4154510498046,8.53351211547852 48.414119720459,8.53230094909674 48.4146652221681,8.5311279296875 48.4129333496095,8.5362377166748 48.4118385314942,8.5342435836792 48.4093551635742,8.53455352783203 48.4063682556153,8.53925704956055 48.4045944213867,8.53944301605219 48.405689239502,8.54423999786377 48.4065399169922,8.54600524902344 48.4052848815918,8.54600524902344 48.4052848815918,8.55242824554438 48.4032402038575,8.55599975585943 48.3996963500977,8.56523609161383 48.4004249572755,8.56523609161383 48.4004249572755,8.56561374664318 48.4018249511719,8.56884002685541 48.4032402038575,8.57035923004162 48.4023742675782,8.57200145721436 48.4028701782226,8.57407569885254 48.4043922424317,8.57407569885254 48.4043922424317,8.57203865051275 48.4107398986818,8.57261753082281 48.4115791320801,8.5709486007691 48.4121093750001,8.57917499542242 48.4200477600098,8.5721931457519 48.423038482666,8.57074260711676 48.4262428283691,8.57510948181152 48.4289550781251,8.57511997222912 48.4310951232911,8.56101894378662 48.4332427978516,8.55589866638184 48.4321708679199,8.55517005920404 48.4345245361328,8.55243110656744 48.4343872070312,8.54793453216558 48.4373359680176)))0.0006POINT(8.553362202381114 48.43166886185727)
71377POLYGON((13.6253032684327 46.5433425903321,13.6334285736084 46.5476875305175,13.6391620635987 46.5489273071288,13.6742248535157 46.5451698303224,13.6814918518067 46.5454177856446,13.6832361221313 46.5467948913574,13.6843252182006 46.5505371093751,13.6843023300172 46.5671195983888,13.6843023300172 46.5671195983888,13.69215965271 46.5697174072265,13.6942510604858 46.5713272094727,13.6947078704835 46.5864410400392,13.6947078704835 46.5864410400392,13.7074403762818 46.5881652832032,13.7074403762818 46.5881652832032,13.72838306427 46.5862464904785,13.7371549606324 46.5835647583008,13.7399387359619 46.5795707702637,13.743772506714 46.5631141662599,13.7459907531739 46.560661315918,13.7511024475098 46.5585670471191,13.761329650879 46.556999206543,13.7696399688722 46.5573272705078,13.7910051345826 46.5650024414062,13.7910051345826 46.5650024414062,13.7999515533448 46.5256462097169,13.7990493774414 46.5201606750489,13.7944850921631 46.5082588195801,13.7944850921631 46.5082588195801,13.7898674011231 46.5098457336426,13.783242225647 46.5142135620117,13.7787981033326 46.5201072692872,13.7669477462769 46.5167808532714,13.7496585845947 46.5187835693359,13.7396192550659 46.5189437866212,13.7307033538818 46.5209197998047,13.7236375808716 46.5243682861328,13.7140836715699 46.5238876342775,13.7137241363527 46.523220062256,13.7137241363527 46.523220062256,13.713360786438 46.523265838623,13.7131948471069 46.5232887268066,13.7131948471069 46.5232887268066,13.7114057540894 46.5235252380371,13.7114057540894 46.5235252380371,13.7097597122193 46.5233001708985,13.7069358825685 46.5229187011719,13.7017698287965 46.5233802795411,13.6990547180176 46.5236206054688,13.6927375793458 46.5235290527345,13.6870279312135 46.5234489440919,13.6870279312135 46.5234489440919,13.6771640777587 46.523536682129,13.6631278991699 46.5285339355469,13.6631278991699 46.5285339355469,13.6619968414307 46.5290412902832,13.654670715332 46.5323371887208,13.654670715332 46.5323371887208,13.6354026794435 46.5407066345215,13.6262369155884 46.5432586669922,13.6253032684327 46.5433425903321))0.0006POINT(13.713584280014082 46.54073117574059)
44311POLYGON((0.479815751314163 43.3325881958008,0.472977310419196 43.3324813842774,0.472977310419196 43.3324813842774,0.461133569479045 43.3365631103515,0.461133569479045 43.3365631103515,0.469943314790783 43.3647956848145,0.469943314790783 43.3647956848145,0.485090970993042 43.3696403503419,0.485090970993042 43.3696403503419,0.489554822444916 43.3603553771973,0.501698076725063 43.3554077148439,0.501698076725063 43.3554077148439,0.488789528608436 43.3419761657716,0.48146149516117 43.3392257690431,0.479815751314163 43.3325881958008))0.0006POINT(0.4800934344530674 43.34942299979081)
14768POLYGON((12.800045967102 42.1584815979005,12.7978706359864 42.1559181213379,12.7880411148072 42.1532402038575,12.752652168274 42.1474685668946,12.7449951171874 42.1504364013672,12.7449951171874 42.1504364013672,12.7442922592164 42.1463813781739,12.7511568069459 42.1442222595215,12.755160331726 42.1419067382813,12.755160331726 42.1419067382813,12.7565698623658 42.1379547119142,12.7649297714234 42.1314353942871,12.7744503021241 42.1242065429689,12.7861166000367 42.1181678771973,12.7861166000367 42.1181678771973,12.78790473938 42.1192550659181,12.7996912002564 42.1198234558105,12.8065271377564 42.1183586120606,12.8170471191407 42.1191711425781,12.8331470489501 42.1283836364746,12.8402280807495 42.1350364685058,12.8492269515992 42.1393852233888,12.8492269515992 42.1393852233888,12.8507966995239 42.1416244506836,12.8504648208619 42.1442985534669,12.8468151092529 42.145938873291,12.800045967102 42.1584815979005))0.0006POINT(12.793601109431368 42.13734582754285)
14625POLYGON((13.1683979034424 42.6535224914551,13.1692895889283 42.6434860229492,13.1748170852662 42.6392402648926,13.1766319274903 42.6276664733888,13.1824417114258 42.6081809997559,13.1922826766968 42.5884895324708,13.1922826766968 42.5884895324708,13.2039604187013 42.5869178771973,13.2133808135987 42.5834312438966,13.2277135848998 42.5838012695312,13.2349452972412 42.5766716003419,13.2468614578248 42.5736694335938,13.2544260025026 42.5806884765624,13.2547292709351 42.5829315185548,13.26247215271 42.5840644836426,13.2802762985229 42.5842285156251,13.285210609436 42.5832405090333,13.2921695709229 42.5715103149415,13.294207572937 42.5705032348633,13.2982273101807 42.572078704834,13.2982273101807 42.572078704834,13.3128623962403 42.5749778747559,13.320894241333 42.5780372619629,13.3240146636963 42.5807151794434,13.328543663025 42.580852508545,13.3361988067628 42.5793418884278,13.3404235839845 42.5762863159181,13.3437356948852 42.5758743286134,13.3811941146851 42.5818862915039,13.3848543167114 42.5854873657227,13.3838386535646 42.5861015319825,13.384469985962 42.5866584777833,13.3949241638183 42.592227935791,13.3949241638183 42.592227935791,13.3919506072998 42.5942764282227,13.3899221420289 42.6026115417481,13.3912687301635 42.60945892334,13.3928213119507 42.6111907958986,13.3961296081543 42.619327545166,13.3956022262574 42.6226768493653,13.3956022262574 42.6226768493653,13.4076852798462 42.6301918029785,13.4106550216675 42.6400146484375,13.409197807312 42.6438293457031,13.409197807312 42.6438293457031,13.3943643569947 42.6469688415527,13.3827257156372 42.6507797241212,13.3776712417602 42.6508331298829,13.3776712417602 42.6508331298829,13.3702239990234 42.6506996154786,13.3581008911133 42.6649703979493,13.3505935668945 42.6696815490723,13.3495073318483 42.6743469238281,13.3518056869507 42.683376312256,13.3518056869507 42.683376312256,13.3492937088013 42.6860771179199,13.3333597183228 42.6931457519532,13.3105497360231 42.6952133178712,13.3013067245485 42.6948051452638,13.2968730926515 42.6936073303223,13.2819576263428 42.6828727722168,13.2770500183105 42.6811523437501,13.269986152649 42.6806602478028,13.263882637024 42.6727752685548,13.2657432556153 42.6620330810547,13.2620906829834 42.6585845947266,13.25830078125 42.6585464477539,13.2501935958862 42.660499572754,13.2491016387941 42.6625709533693,13.2514209747316 42.6654434204102,13.2489490509033 42.6678924560547,13.2434539794922 42.6671981811524,13.2347784042358 42.6624450683594,13.2275075912477 42.6567687988282,13.2052450180054 42.644874572754,13.1741132736207 42.6495399475098,13.1683979034424 42.6535224914551))0.0006POINT(13.304519603126964 42.62616082241664)