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
36915POLYGON((5.50695037841808 46.6665420532227,5.51060724258423 46.6536331176757,5.51060724258423 46.6536331176757,5.4968986511231 46.6505546569824,5.4968986511231 46.6505546569824,5.48204183578497 46.6592445373536,5.48204183578497 46.6592445373536,5.47979879379284 46.6622772216797,5.47979879379284 46.6622772216797,5.49259710311895 46.6674385070802,5.50695037841808 46.6665420532227))0.0006POINT(5.493824052810732 46.65853996276857)
18965POLYGON((14.5389852523805 36.9094467163087,14.5333786010742 36.9064941406251,14.5277738571168 36.8980102539063,14.5217275619507 36.8938751220704,14.5151681900026 36.8912811279297,14.5052576065065 36.8999366760253,14.496150970459 36.9041442871094,14.4908428192139 36.897243499756,14.5076141357422 36.8879318237305,14.5048084259033 36.8863716125489,14.5026721954346 36.8868484497071,14.4735412597657 36.8834152221681,14.4527311325073 36.8749809265137,14.4443006515504 36.8770713806152,14.4398612976075 36.8770828247071,14.4398612976075 36.8770828247071,14.4368066787721 36.8837509155274,14.4331922531128 36.8854217529297,14.4304161071777 36.889862060547,14.4276380538941 36.889862060547,14.4262504577637 36.8912506103515,14.4276399612427 36.8931999206544,14.4229202270508 36.9026412963868,14.4126386642457 36.9151420593263,14.4115285873414 36.9179191589355,14.4081897735597 36.9181900024414,14.3993062973023 36.9343070983887,14.387360572815 36.9506072998047,14.387360572815 36.9506072998047,14.3951473236085 36.9548645019532,14.404459953308 36.9690818786622,14.426103591919 36.9785652160645,14.4411659240723 36.979305267334,14.4401788711548 36.9865531921387,14.4539728164674 36.9872665405274,14.476266860962 36.9722175598144,14.4856147766114 36.9771347045898,14.5003557205201 36.9924926757814,14.5039539337159 37.0043869018555,14.5041532516481 37.0067253112794,14.5003576278687 37.0170707702637,14.5001144409181 37.0365180969238,14.5144348144531 37.0441551208496,14.5258474349975 37.0460166931153,14.5365953445435 37.0520973205568,14.537359237671 37.0541000366212,14.5425968170167 37.0544624328613,14.544605255127 37.0534706115722,14.544605255127 37.0534706115722,14.5449771881105 37.0476112365723,14.5572080612184 37.0367317199707,14.5601787567139 37.036247253418,14.5601787567139 37.036247253418,14.5633659362792 37.0352249145509,14.5844697952271 37.0000648498535,14.5913839340211 36.9912071228028,14.5934286117554 36.9745292663574,14.598014831543 36.9677162170411,14.5929737091065 36.9628639221193,14.5775489807129 36.9549751281739,14.5620012283326 36.9518013000489,14.5480213165284 36.9510459899902,14.535135269165 36.9425964355469,14.5319795608521 36.938835144043,14.530484199524 36.9264335632325,14.541808128357 36.9214820861816,14.5437498092651 36.9217414855957,14.5452642440797 36.9200820922852,14.5420665740967 36.912166595459,14.5389852523805 36.9094467163087))0.0006POINT(14.49692828413374 36.9525150354358)
1401360POLYGON((-3.62024307250971 41.2110595703125,-3.62152099609375 41.2162590026855,-3.62542510032654 41.2191390991212,-3.62588596343994 41.2223052978516,-3.62430906295776 41.2307929992676,-3.61758708953857 41.2407264709473,-3.60438895225514 41.2418785095215,-3.60076498985279 41.2437896728517,-3.59274005889881 41.2403984069825,-3.57474589347834 41.2229957580566,-3.55557203292841 41.218532562256,-3.54868507385248 41.2193870544434,-3.53461289405817 41.2159385681152,-3.53240489959711 41.2141189575195,-3.52906107902521 41.2136611938478,-3.52735900878901 41.2111358642579,-3.52869892120361 41.2059020996094,-3.5353860855102 41.2024040222168,-3.53724098205561 41.2061614990235,-3.54149389266968 41.2067832946777,-3.55684399604797 41.1997985839844,-3.57628011703491 41.2089614868164,-3.58228397369385 41.2053031921387,-3.58926892280579 41.2060356140137,-3.59382510185242 41.208839416504,-3.60237908363337 41.2063522338868,-3.6073539257049 41.2064361572265,-3.61105799674982 41.2071189880371,-3.6138379573822 41.2098693847656,-3.62024307250971 41.2110595703125))0.0006POINT(-3.5796985215153816 41.21593396417029)
1396964POLYGON((-2.28448891639704 39.7988128662109,-2.28601098060602 39.7961425781249,-2.29128098487854 39.7950057983398,-2.29118990898132 39.7924728393556,-2.31534194946283 39.7902030944824,-2.32781505584711 39.7840423583985,-2.3549439907074 39.785312652588,-2.38150691986078 39.7795791625977,-2.39663791656483 39.7905464172363,-2.38965702056879 39.7941398620605,-2.38271307945246 39.8053321838379,-2.37291288375854 39.8114662170411,-2.35996890068054 39.8291358947754,-2.35721206665033 39.8302116394043,-2.3575439453125 39.83353805542,-2.35029888153076 39.8433990478517,-2.3399019241333 39.848861694336,-2.31949400901794 39.8499145507814,-2.30842399597162 39.8475799560547,-2.289969921112 39.8485527038574,-2.28176093101501 39.8443031311035,-2.27413892745966 39.8421363830567,-2.27210402488708 39.8401412963868,-2.27651000022882 39.8302383422853,-2.28352308273315 39.8256416320801,-2.28502893447876 39.821102142334,-2.27898907661432 39.8087348937989,-2.27982807159424 39.8066673278809,-2.28510403633112 39.8036689758302,-2.28448891639704 39.7988128662109))0.0006POINT(-2.3198034598909243 39.81644426543141)
24145POLYGON((3.20501923561102 45.0983505249025,3.19535803794872 45.109432220459,3.19117951393122 45.1220092773439,3.19422793388378 45.1245269775391,3.19422793388378 45.1245269775391,3.22027325630188 45.1173896789551,3.22577977180481 45.1299858093262,3.233564376831 45.1330490112306,3.233564376831 45.1330490112306,3.24071550369268 45.130558013916,3.24071550369268 45.130558013916,3.244946718216 45.1207962036133,3.23371648788452 45.1146278381348,3.22944164276134 45.104820251465,3.22944164276134 45.104820251465,3.23363614082348 45.0953941345216,3.22851538658148 45.0897216796876,3.22851538658148 45.0897216796876,3.21168947219843 45.0939331054688,3.21168947219843 45.0939331054688,3.20501923561102 45.0983505249025))0.0006POINT(3.221310889720953 45.11306018829352)
68656POLYGON((11.7138710021973 51.3900260925294,11.7103929519653 51.3939247131348,11.703462600708 51.404998779297,11.7160263061523 51.4090003967285,11.7117443084717 51.4159278869629,11.7194890975953 51.4179687500001,11.7197484970094 51.4191322326661,11.7161264419556 51.4253997802736,11.7161264419556 51.4253997802736,11.7426557540894 51.4298133850098,11.7423486709595 51.4315567016602,11.7397832870483 51.4338417053223,11.7398691177368 51.4423217773438,11.7521677017212 51.4420967102052,11.751989364624 51.4453353881836,11.7592792510987 51.4453468322755,11.7658700942994 51.4444236755371,11.7666997909546 51.4399642944336,11.7720651626586 51.4406394958496,11.7676830291748 51.4498558044434,11.7738676071167 51.4532165527344,11.7715272903443 51.4597091674805,11.7789907455445 51.4618797302247,11.7804384231567 51.4631500244142,11.7797565460205 51.4650382995605,11.7739200592042 51.4644432067871,11.7722282409669 51.4657936096191,11.7686948776245 51.4663505554199,11.7690935134889 51.4675445556642,11.7654209136962 51.4691429138184,11.7644720077515 51.468162536621,11.7623023986817 51.4684028625489,11.748643875122 51.4789505004883,11.7470560073854 51.4777603149414,11.7444400787353 51.4775009155275,11.7430181503297 51.4787216186523,11.7440500259399 51.4817085266114,11.7399072647095 51.4857177734374,11.7399072647095 51.4857177734374,11.7460222244264 51.4885139465332,11.7494058609009 51.4889221191407,11.7528266906739 51.4875259399415,11.7578649520875 51.4873199462891,11.7602834701539 51.4893188476564,11.7632083892823 51.4897918701172,11.767201423645 51.4872016906738,11.7748746871949 51.4863967895508,11.7704706192017 51.4897117614747,11.7738866806031 51.4886779785157,11.7742481231689 51.4897804260255,11.7738008499146 51.4918174743653,11.7746019363404 51.4921340942383,11.7723655700684 51.4977722167969,11.7788782119752 51.497657775879,11.7821283340455 51.4947967529297,11.7854118347169 51.4941558837891,11.7835769653321 51.4919624328613,11.7842235565186 51.4903450012208,11.7909927368164 51.4901657104492,11.7949771881103 51.4847679138184,11.799168586731 51.4851799011232,11.8112297058107 51.4826164245605,11.8161516189576 51.4748420715333,11.8228244781494 51.4703826904297,11.8218383789062 51.4666709899903,11.8301458358766 51.4664878845216,11.8365783691406 51.4677467346191,11.8361320495606 51.4697189331055,11.8463411331178 51.4695510864258,11.8476667404175 51.4739608764649,11.849907875061 51.4742240905762,11.851487159729 51.4774551391603,11.8534412384034 51.4777488708497,11.8535499572755 51.4794998168946,11.8560733795166 51.4795417785645,11.8553762435913 51.483268737793,11.8651685714723 51.4844665527344,11.8651685714723 51.4844665527344,11.8682498931885 51.479061126709,11.8740921020507 51.4778060913087,11.8717823028565 51.4771766662599,11.8719148635864 51.474880218506,11.8827733993531 51.4737167358398,11.8835964202881 51.4723472595215,11.8862419128418 51.472640991211,11.8877687454224 51.4673881530762,11.886981010437 51.4646682739258,11.8883180618286 51.4631500244142,11.9120950698853 51.4652786254884,11.9170083999635 51.462989807129,11.9166526794434 51.4617233276367,11.9179000854493 51.4606132507325,11.92324924469 51.4603118896486,11.9237375259399 51.4565353393554,11.9259243011474 51.456916809082,11.9305181503295 51.4518127441406,11.9291267395019 51.4505882263184,11.9214868545532 51.4498977661133,11.9159727096558 51.4471473693848,11.914644241333 51.4456253051759,11.9147777557374 51.4429397583009,11.9207153320313 51.4393882751465,11.930516242981 51.4388008117676,11.930516242981 51.4388008117676,11.928376197815 51.4361724853516,11.9269676208497 51.4320755004884,11.9135837554933 51.4125747680665,11.9141168594361 51.410717010498,11.9129657745362 51.4102439880372,11.9075832366944 51.4022369384766,11.906849861145 51.3970718383789,11.9047651290894 51.3975639343262,11.9047651290894 51.3975639343262,11.9082326889038 51.4135665893556,11.9078722000123 51.4158935546876,11.9065847396851 51.4170951843263,11.909372329712 51.420223236084,11.9070129394532 51.4211959838868,11.9036655426027 51.4190406799318,11.9036407470704 51.4210548400879,11.899136543274 51.4210624694825,11.8982238769532 51.4227752685546,11.8856401443483 51.4221420288087,11.8731212615967 51.4227104187012,11.8544054031372 51.4181327819824,11.8534154891969 51.4211502075196,11.8516817092897 51.4209365844727,11.8519802093506 51.4198265075684,11.8479871749879 51.4191055297853,11.8473014831542 51.4207420349122,11.8444108963014 51.4203262329102,11.8414325714112 51.42626953125,11.8340969085694 51.4239883422852,11.8320693969727 51.4220504760742,11.8111839294434 51.4189262390137,11.8115463256836 51.4129943847657,11.8085832595826 51.4130172729493,11.8080387115479 51.4110641479493,11.8005714416503 51.4111099243165,11.8003444671631 51.4101867675781,11.7979259490968 51.4101562500001,11.7962083816528 51.4084205627441,11.7861108779908 51.4085350036622,11.7843732833862 51.406078338623,11.7792882919312 51.4047927856446,11.7817821502686 51.4013748168946,11.7544326782227 51.3954696655275,11.7528743743898 51.3974189758301,11.7413854598999 51.3959388732911,11.7138710021973 51.3900260925294))0.0006POINT(11.82192685940125 51.449232549475354)
1401002POLYGON((-6.59000587463379 40.6078681945801,-6.60883378982544 40.6171493530274,-6.61342716217041 40.6245269775391,-6.61462783813477 40.6310119628906,-6.61862611770624 40.6358451843263,-6.6251368522644 40.6355895996094,-6.62770986557001 40.6304893493653,-6.63590097427368 40.6246032714844,-6.65211296081537 40.6247215270997,-6.65347814559937 40.6259384155274,-6.6442408561706 40.6381912231446,-6.64350700378418 40.641414642334,-6.64460277557367 40.6435470581056,-6.65431499481201 40.6440696716309,-6.65802717208862 40.6457786560058,-6.66864299774164 40.658718109131,-6.66902399063105 40.6712226867676,-6.6588110923766 40.6847496032715,-6.65593481063837 40.6834449768067,-6.64501285552979 40.6836280822754,-6.64181089401245 40.6858367919922,-6.63235998153681 40.6878280639648,-6.6288428306579 40.691246032715,-6.62246799468994 40.6906623840332,-6.61718320846546 40.6952934265137,-6.61497688293457 40.6954154968262,-6.60711812973017 40.6894683837891,-6.60921001434326 40.6868171691895,-6.60903692245483 40.682731628418,-6.60500288009644 40.6798706054688,-6.58903312683105 40.6741561889648,-6.57432794570917 40.6752052307129,-6.57250022888178 40.6686706542969,-6.57947492599487 40.6626243591309,-6.58179521560663 40.6562767028809,-6.58854293823242 40.6566352844239,-6.5798869132995 40.6511306762696,-6.58796882629395 40.6474952697753,-6.59007501602161 40.6437568664551,-6.59328603744501 40.643440246582,-6.59296512603754 40.6418800354004,-6.57774686813354 40.6323127746583,-6.57638216018671 40.6258087158204,-6.58081007003784 40.6192932128907,-6.58489418029779 40.6181030273438,-6.59000587463379 40.6078681945801))0.0006POINT(-6.615992832183807 40.654543728298634)
54203POLYGON((5.79585027694702 45.8297996520996,5.80110931396484 45.8457946777344,5.80110931396484 45.8457946777344,5.80752515792847 45.8606414794922,5.80752515792847 45.8606414794922,5.81515407562267 45.8772010803224,5.81515407562267 45.8772010803224,5.77687406539917 45.8819770812989,5.75985479354864 45.8888893127441,5.75985479354864 45.8888893127441,5.75814342498785 45.8840866088867,5.75814342498785 45.8840866088867,5.75719881057751 45.8814506530761,5.75719881057751 45.8814506530761,5.76939678192144 45.8659057617187,5.76406955719006 45.8345108032227,5.76406955719006 45.8345108032227,5.76315927505505 45.825080871582,5.76315927505505 45.825080871582,5.76664924621582 45.8242530822754,5.76664924621582 45.8242530822754,5.77514266967779 45.8222084045411,5.78606033325201 45.8263359069824,5.78693437576294 45.8232231140138,5.78693437576294 45.8232231140138,5.79585027694702 45.8297996520996))0.0006POINT(5.778516807556205 45.85265960693362)
46932POLYGON((3.36172342300415 50.3982162475587,3.36002898216248 50.3949775695802,3.36799502372753 50.3915634155274,3.36060261726385 50.378932952881,3.37182164192211 50.3562583923341,3.37260341644298 50.3462028503418,3.36833739280712 50.3441581726075,3.36833739280712 50.3441581726075,3.34297132492077 50.3503646850587,3.34297132492077 50.3503646850587,3.34876322746288 50.3600540161133,3.34685397148132 50.3702011108399,3.35228586196911 50.376148223877,3.35321903228771 50.39315032959,3.35321903228771 50.39315032959,3.34754633903498 50.4055290222168,3.34754633903498 50.4055290222168,3.35015702247614 50.4011917114257,3.36172342300415 50.3982162475587))0.0006POINT(3.356499075889651 50.3755639394125)
58429POLYGON((8.01032066345209 50.7454795837403,8.00022983551031 50.7550811767579,7.98402786254883 50.7609901428224,7.98402786254883 50.7609901428224,7.9820666313172 50.7581481933594,7.97275257110596 50.7579460144044,7.9710483551026 50.7562026977539,7.97118043899542 50.7539596557618,7.9703569412232 50.7539596557618,7.97005748748779 50.7552947998047,7.96901750564581 50.7551078796386,7.96937513351446 50.7537460327149,7.96687936782843 50.7529296875,7.96874141693127 50.7497367858888,7.97235298156744 50.7472496032716,7.97154617309582 50.7458992004396,7.9682822227478 50.7459106445312,7.96529245376587 50.7463493347168,7.96384763717651 50.7476119995117,7.96489143371582 50.74955368042,7.96200227737427 50.7536125183105,7.95822334289551 50.7523880004883,7.9574813842774 50.7545394897462,7.95322751998907 50.7581100463867,7.94613218307495 50.7567863464357,7.94211387634277 50.7575950622559,7.94334030151362 50.7587852478027,7.9364213943482 50.7609634399414,7.93350839614874 50.763599395752,7.92792510986339 50.7634239196778,7.92374420166027 50.7615013122559,7.91720819473278 50.7618789672851,7.91720819473278 50.7618789672851,7.9171466827392 50.7565841674805,7.92580938339239 50.7546958923341,7.92854881286621 50.749282836914,7.93077850341803 50.7487373352051,7.93085384368896 50.7471199035645,7.94004154205322 50.7423439025879,7.94104576110851 50.7382621765138,7.93985891342169 50.7366256713868,7.94200325012207 50.7345199584962,7.94200325012207 50.7345199584962,7.94358205795288 50.7339248657227,7.94144248962414 50.7331008911133,7.94305896759039 50.7310409545898,7.9451904296875 50.7317543029786,7.95105600357061 50.7311096191407,7.9546947479248 50.7270736694337,7.95617866516119 50.7274322509766,7.95552873611462 50.7245254516602,7.95552873611462 50.7245254516602,7.95663166046148 50.7243270874023,7.95699977874756 50.7209587097167,7.95850372314447 50.7206840515137,7.95880889892584 50.7226371765138,7.95749187469482 50.7241554260255,7.96107625961315 50.7232170104982,7.9651336669923 50.7275695800781,7.96841669082642 50.7275238037111,7.97373533248896 50.7261848449708,7.97483634948742 50.7244453430176,7.97231721878057 50.7227783203124,7.9751343727113 50.7215614318848,7.9751343727113 50.7215614318848,7.97862815856945 50.7230415344239,7.98835992813122 50.724147796631,7.98949098587042 50.7241172790528,7.98931837081909 50.7232017517091,7.99212217330933 50.7231025695801,7.99347257614141 50.7218132019044,7.99347257614141 50.7218132019044,7.99655199050898 50.7208938598633,8.00764751434326 50.7232742309571,8.00764751434326 50.7232742309571,8.00731086730963 50.7253303527833,8.00137901306152 50.7259216308594,8.00119781494152 50.7274589538574,8.00864410400402 50.7279777526857,8.01831340789795 50.7315330505372,8.02051544189453 50.7338676452637,8.02763271331793 50.7334098815918,8.02763271331793 50.7334098815918,8.02381992340088 50.7351226806642,8.0191707611084 50.7395401000978,8.01032066345209 50.7454795837403))0.0006POINT(7.96759683384619 50.73969699635227)