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.
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.
| Spaltenname | Datentyp | Mögliche Werte | Beschreibung |
|---|---|---|---|
| id_ort | int(10) unsigned | beliebig | Fremdschlüssel, der auf die Tabelle `orte` verweist. |
| geodaten | geometryDieser 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:
| beliebig | Die simplifizierten Geodaten. |
| epsilon | float(5,4) | beliebig | Die Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone. |
| mittelpunkt | pointDieser 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:
| beliebig | Der geometrische Mittelpunkt des vereinfachten Polygons. |
Ausschnitt
| id_ort | geodaten | epsilon | mittelpunkt |
|---|---|---|---|
| 1403414 | POLYGON((1.86754000186926 42.401008605957,1.86887598037714 42.4182357788086,1.86315703392034 42.4280242919922,1.84946000576031 42.4325561523438,1.85299003124237 42.4357566833497,1.8500590324403 42.4404792785645,1.85119605064398 42.4430541992188,1.86972796916973 42.4317321777344,1.87718105316168 42.4311447143554,1.89919698238378 42.4248275756837,1.89968705177307 42.4202346801759,1.90312397480017 42.4108581542969,1.91237998008739 42.407112121582,1.91069805622107 42.4013061523438,1.90216195583344 42.3987083435059,1.89771103858942 42.3981590270997,1.89267396926886 42.4000854492188,1.89422202110296 42.4001541137696,1.89257597923284 42.4018020629883,1.87723600864416 42.402286529541,1.86754000186926 42.401008605957)) | 0.0006 | POINT(1.8815927088261133 42.4163763046265) |
| 63741 | POLYGON((9.06926155090332 50.2436294555665,9.06583309173595 50.2400703430177,9.06618690490723 50.2381172180176,9.06445693969738 50.2365493774415,9.06886672973627 50.2335090637207,9.06900310516369 50.2313346862794,9.07424831390392 50.2309150695802,9.0758848190307 50.2264442443848,9.07634353637695 50.2237854003907,9.07278728485119 50.2226524353028,9.07564544677734 50.220890045166,9.07718658447266 50.2167778015137,9.07737636566162 50.212802886963,9.07348155975342 50.2108192443848,9.07348155975342 50.2108192443848,9.0677480697633 50.2098274230957,9.06574249267578 50.206169128418,9.06195545196539 50.2066421508788,9.06087207794184 50.2104530334473,9.06277942657465 50.2109184265138,9.06138801574707 50.2137641906739,9.05768013000494 50.2144203186035,9.04891872406006 50.2115364074707,9.04616737365723 50.2075424194337,9.04149532318115 50.2058181762696,9.03886795043957 50.2068824768068,9.03481674194342 50.2027816772462,9.01887226104748 50.2064437866212,9.0166330337525 50.2080917358399,9.01268196105968 50.2088661193848,9.01268196105968 50.2088661193848,9.01465034484858 50.211395263672,9.01465225219738 50.2144432067872,9.01744556427002 50.2166061401367,9.01744556427002 50.2166061401367,9.02062511444092 50.2198600769044,9.02338886260992 50.2207298278809,9.03264904022217 50.2269592285157,9.03034877777111 50.2309913635254,9.02578258514404 50.2321090698243,9.02578258514404 50.2321090698243,9.02485752105719 50.2334403991699,9.02639675140375 50.2362403869629,9.03490352630621 50.2388229370118,9.03520011901855 50.2423820495607,9.03891849517828 50.2437591552735,9.0376062393189 50.2467041015624,9.03899478912365 50.24808883667,9.04578685760498 50.2471771240235,9.05849742889416 50.2496337890626,9.06208515167236 50.2479591369629,9.05768489837641 50.2454490661622,9.05885124206543 50.2444648742677,9.06351184844982 50.245330810547,9.06372070312506 50.2440032958986,9.06926155090332 50.2436294555665)) | 0.0006 | POINT(9.04834783727476 50.224971008300805) |
| 66362 | POLYGON((11.372826576233 47.7244567871094,11.3737173080445 47.7244682312013,11.3726701736451 47.7231483459474,11.3786067962647 47.72367477417,11.3829021453857 47.7202796936036,11.3839712142945 47.7205047607422,11.3806152343751 47.7239341735841,11.3926248550416 47.721809387207,11.3872489929199 47.7210388183594,11.387580871582 47.7199440002441,11.3941049575806 47.7201995849611,11.398765563965 47.7187805175782,11.4013719558715 47.7167625427246,11.4047975540162 47.7166290283203,11.4033374786378 47.7119064331055,11.4055070877076 47.7117614746094,11.4066333770753 47.7136230468751,11.4084386825563 47.7133293151855,11.4089317321778 47.7140617370605,11.4193086624145 47.7141876220703,11.4209060668945 47.7131652832031,11.4236135482788 47.7147026062012,11.4300394058229 47.7140998840333,11.4335432052613 47.716091156006,11.4353713989259 47.7158851623536,11.4344654083253 47.7145347595215,11.4425897598267 47.7130279541016,11.448236465454 47.7098388671876,11.4451389312745 47.7062759399415,11.447437286377 47.7048530578614,11.4473104476929 47.7037353515626,11.4492053985596 47.7015342712403,11.4588050842285 47.7006645202638,11.4613475799561 47.6973342895507,11.4653320312501 47.6975631713867,11.473165512085 47.7001075744628,11.4734106063843 47.7018432617188,11.4722337722779 47.7028732299804,11.4728899002076 47.7057952880859,11.4825544357301 47.7045745849611,11.4825544357301 47.7045745849611,11.4826555252075 47.7015686035156,11.4807596206666 47.7001113891602,11.4819707870483 47.6989822387696,11.4817752838136 47.6962509155273,11.4785652160646 47.6942100524902,11.4729700088502 47.6944274902345,11.4759826660157 47.6971817016602,11.4717388153077 47.6981010437012,11.4668893814086 47.6930809020996,11.4708642959596 47.6918449401857,11.4732551574706 47.6898078918456,11.4716186523439 47.6884841918946,11.4730768203736 47.6861686706544,11.4756259918213 47.6851577758789,11.4756679534912 47.6832504272461,11.4741077423096 47.6826934814453,11.4759321212769 47.6823692321777,11.4753227233888 47.6799964904786,11.4774255752563 47.6812858581543,11.4784994125366 47.6803970336914,11.477032661438 47.6792182922364,11.4766988754273 47.6765823364258,11.4783487319946 47.6745491027831,11.4762277603151 47.6745796203613,11.4718656539918 47.6705055236818,11.4690494537354 47.6707649230957,11.4694452285767 47.6678733825683,11.4710302352906 47.6659126281739,11.4709501266479 47.6631813049317,11.4741058349611 47.6612663269044,11.4816617965698 47.6619338989258,11.4816617965698 47.6619338989258,11.4788036346437 47.6593704223634,11.4794893264771 47.6577110290528,11.477554321289 47.6539916992189,11.4785661697388 47.6533813476563,11.4785661697388 47.6533813476563,11.4706697463989 47.6528854370118,11.467882156372 47.6518211364747,11.4681234359742 47.6512527465821,11.4648475646974 47.6510391235352,11.4569044113159 47.6529541015625,11.4526100158693 47.6522979736329,11.449571609497 47.6541137695313,11.438726425171 47.6524887084962,11.4305629730226 47.6539611816407,11.4305629730226 47.6539611816407,11.4308166503906 47.658546447754,11.4297580718994 47.6602935791017,11.4296140670776 47.6638603210449,11.4242343902588 47.6622886657716,11.4213838577272 47.6625823974611,11.4198818206788 47.6651153564453,11.420129776001 47.6670875549318,11.420509338379 47.6685562133789,11.4274778366089 47.6701049804688,11.4339427947999 47.6694335937501,11.4275150299073 47.6739578247071,11.4259910583496 47.6772041320802,11.4280414581299 47.679515838623,11.4270782470703 47.6826400756837,11.4256601333619 47.684009552002,11.425407409668 47.685874938965,11.4266557693482 47.6865844726563,11.4239501953124 47.6881980895997,11.4230337142944 47.6911430358886,11.4210729598998 47.6911735534668,11.4216947555543 47.6924552917482,11.4172058105469 47.695369720459,11.4157457351685 47.6983299255372,11.4113492965699 47.6986770629882,11.4024543762208 47.6970596313477,11.3945322036744 47.6916046142579,11.3934173583986 47.6912956237794,11.3925647735596 47.6925468444825,11.3885383605958 47.6921844482421,11.3830499649048 47.6889228820801,11.380048751831 47.6885681152343,11.3779373168946 47.6896286010743,11.3763971328736 47.6883125305176,11.373239517212 47.688102722168,11.3734245300294 47.6873092651368,11.3714323043823 47.6860237121582,11.3608770370484 47.6850357055665,11.3609676361083 47.6841545104981,11.359414100647 47.6839294433595,11.3565301895142 47.6841430664064,11.3544769287111 47.6855354309083,11.3513698577881 47.6850624084473,11.3510704040527 47.6819496154786,11.3561363220216 47.6817207336426,11.3611059188843 47.6761016845704,11.3534622192383 47.6750030517579,11.3534622192383 47.6750030517579,11.3479623794556 47.6747665405274,11.3479623794556 47.6747665405274,11.3465242385865 47.6778182983399,11.3464393615723 47.689968109131,11.3452081680297 47.6896095275878,11.3440799713134 47.6936988830567,11.3440799713134 47.6936988830567,11.3550596237183 47.6974678039551,11.3547945022584 47.7000045776367,11.3562860488892 47.7007331848145,11.3640222549439 47.7019767761232,11.3713531494141 47.7062721252441,11.3714513778688 47.7078170776368,11.3672885894776 47.7115364074708,11.3676710128785 47.7152900695801,11.3653697967529 47.7186851501465,11.372826576233 47.7244567871094)) | 0.0006 | POINT(11.423178458055947 47.68915343126715) |
| 1403890 | POLYGON((0.81056600809103 41.5185852050782,0.818104982376212 41.4899330139161,0.815006017684937 41.4838409423829,0.819155991077423 41.4748115539551,0.819396972656307 41.4665031433105,0.822335004806519 41.464126586914,0.818076014518795 41.4609184265138,0.816163003444785 41.4501342773438,0.811348021030369 41.4515075683595,0.797173976898193 41.4459228515626,0.798041999340057 41.4476890563965,0.79355001449585 41.4568328857423,0.783490002155361 41.4680519104004,0.780062019825039 41.4653091430664,0.771220982074794 41.4670867919922,0.75460600852972 41.4638290405274,0.741321027278957 41.4651107788086,0.736468970775718 41.4685821533204,0.727869987487793 41.4683113098145,0.726271986961422 41.4702987670899,0.692216992378349 41.4769897460938,0.697853028774318 41.4899673461915,0.695708990097046 41.4996299743653,0.700060009956303 41.5051498413086,0.704994022846336 41.5187339782716,0.709870994091091 41.5254821777345,0.726279020309562 41.518856048584,0.73095798492443 41.520622253418,0.74101597070694 41.5296325683594,0.744855999946594 41.5282936096193,0.746536016464347 41.529354095459,0.747466027736778 41.5336456298829,0.750365018844548 41.5315170288086,0.758441984653473 41.5381584167481,0.760878026485557 41.532844543457,0.760532021522522 41.5283393859863,0.762301027774811 41.5278282165528,0.764270007610321 41.5216789245605,0.766875028610286 41.5209426879884,0.769128978252525 41.5255050659181,0.778414011001587 41.5228271484376,0.780686020851192 41.5202751159669,0.789532005787009 41.5166244506836,0.803593993186951 41.5206604003907,0.81056600809103 41.5185852050782)) | 0.0006 | POINT(0.7646150494164126 41.49615781957458) |
| 66991 | POLYGON((8.23673725128174 48.8139343261719,8.22636985778814 48.8194541931153,8.22155380249029 48.8259773254396,8.21957015991211 48.8246765136719,8.21564102172857 48.8265228271484,8.21355056762707 48.8254890441895,8.21222972869884 48.8309516906739,8.20306205749517 48.8291320800782,8.20256042480474 48.8322448730469,8.20109081268316 48.8342018127443,8.2004566192627 48.8329124450684,8.1967506408692 48.8334655761719,8.18763542175299 48.8399810791017,8.17975616455072 48.8434257507324,8.17864418029779 48.8424301147462,8.1701450347901 48.8422775268556,8.16789627075195 48.8414306640625,8.16589641571039 48.8458786010743,8.16282081603998 48.8468933105468,8.15840148925781 48.846649169922,8.15840148925781 48.846649169922,8.15838146209722 48.8473510742188,8.15307807922375 48.8487510681152,8.14854049682629 48.8473052978516,8.14833259582514 48.8451156616212,8.15198898315424 48.8430862426757,8.15148544311523 48.8410949707032,8.15326213836681 48.837631225586,8.14684295654303 48.8356437683106,8.14915084838867 48.8341369628906,8.14844512939464 48.8318252563476,8.14177322387701 48.8305702209474,8.13575553894049 48.8323936462403,8.13472557067871 48.8353691101074,8.12607860565186 48.834358215332,8.12708282470714 48.8372306823732,8.12360000610352 48.8426628112793,8.12648105621344 48.8464775085449,8.13077068328869 48.8471183776856,8.12999820709223 48.8489799499512,8.11565399169916 48.8526153564453,8.11565399169916 48.8526153564453,8.11988925933832 48.861614227295,8.12135314941418 48.8647384643555,8.12144660949707 48.8649406433105,8.12144660949707 48.8649406433105,8.13036537170422 48.8805198669435,8.14083480834967 48.89501953125,8.15348815917969 48.9099121093751,8.16385459899914 48.9199829101562,8.16385459899914 48.9199829101562,8.16538333892828 48.9194374084474,8.16508960723883 48.9153175354004,8.16654300689703 48.9109497070314,8.1636581420899 48.9087638854982,8.17964458465576 48.9027633666993,8.18869209289556 48.8950614929199,8.1849737167359 48.8932113647462,8.18727684021007 48.8906936645508,8.1848258972168 48.8900146484375,8.18470382690435 48.8874282836915,8.18873310089117 48.8867645263671,8.19071865081793 48.8886260986329,8.19482612609875 48.8897628784181,8.21064281463629 48.8865432739259,8.21064281463629 48.8865432739259,8.21088027954113 48.8829574584961,8.21258831024181 48.8826255798341,8.22251605987555 48.886775970459,8.22637748718273 48.8859024047852,8.22837924957287 48.8845405578614,8.22650051116943 48.8818283081055,8.22934436798101 48.8750038146974,8.23332405090338 48.8739051818848,8.23599910736078 48.8700637817383,8.23599910736078 48.8700637817383,8.23502254486095 48.8620719909668,8.23768138885498 48.8626670837402,8.23978614807135 48.8657951354981,8.24393558502203 48.864528656006,8.24674224853516 48.8654861450196,8.24674224853516 48.8654861450196,8.25028133392345 48.8659172058105,8.25028133392345 48.8659172058105,8.2529182434082 48.8625869750977,8.26162719726562 48.8597412109375,8.26575374603266 48.8566017150879,8.26575374603266 48.8566017150879,8.26105213165289 48.8532867431641,8.26090812683117 48.8517112731935,8.25865650177002 48.8490638732911,8.25814056396479 48.8460845947267,8.25426483154303 48.8438110351564,8.25235843658453 48.8469924926758,8.24799919128418 48.8466339111329,8.24745559692388 48.8483581542969,8.23798751831066 48.8496627807618,8.2367668151856 48.848072052002,8.23489189147949 48.8447303771973,8.24118614196777 48.8409881591796,8.23965167999273 48.8394012451173,8.23396968841558 48.8405380249024,8.23425674438477 48.8378982543946,8.2460699081422 48.8332862854004,8.2448034286499 48.8306350708009,8.2483053207398 48.8291664123536,8.24531841278082 48.8265800476074,8.24961853027344 48.8234901428224,8.24133205413813 48.8185348510742,8.23673725128174 48.8139343261719)) | 0.0006 | POINT(8.196629060517798 48.85712327869662) |
| 30026 | POLYGON((3.23215532302868 48.3398056030274,3.21561694145208 48.3513069152832,3.21561694145208 48.3513069152832,3.20337915420538 48.3455505371094,3.17921543121344 48.3243293762208,3.17921543121344 48.3243293762208,3.18861389160156 48.3229751586914,3.1995854377746 48.316749572754,3.19512867927551 48.3080749511718,3.19512867927551 48.3080749511718,3.22171878814703 48.3161888122559,3.22858500480663 48.328727722168,3.22518491745006 48.3349952697754,3.23215532302868 48.3398056030274)) | 0.0006 | POINT(3.2060880477612304 48.32864732008717) |
| 37830 | POLYGON((1.21178543567652 49.1106567382814,1.21705067157751 49.1105194091797,1.23569321632385 49.1226501464845,1.2380269765855 49.1257400512696,1.23133695125586 49.131046295166,1.23133695125586 49.131046295166,1.20547389984142 49.1212310791016,1.20547389984142 49.1212310791016,1.19932723045355 49.107666015625,1.19932723045355 49.107666015625,1.21178543567652 49.1106567382814)) | 0.0006 | POINT(1.2174832463265042 49.11894531250005) |
| 15626 | POLYGON((9.27463912963879 45.8029708862305,9.25935459136963 45.79345703125,9.25935459136963 45.79345703125,9.25489234924322 45.7937278747559,9.25489234924322 45.7937278747559,9.24862194061285 45.8016052246095,9.25578975677496 45.8118438720704,9.25578975677496 45.8118438720704,9.25623893737793 45.8173751831055,9.25862026214605 45.8231315612793,9.26397037506104 45.829719543457,9.27395820617681 45.8376312255861,9.27395820617681 45.8376312255861,9.29159927368175 45.8357276916504,9.29159927368175 45.8357276916504,9.28788852691662 45.8334159851074,9.28249740600586 45.8231582641603,9.26557445526129 45.8117370605468,9.265293121338 45.8110237121583,9.26695919036865 45.8095321655274,9.27525043487543 45.8050422668458,9.27525043487543 45.8050422668458,9.27504920959473 45.8042144775391,9.27504920959473 45.8042144775391,9.27463912963879 45.8029708862305)) | 0.0006 | POINT(9.268420457840007 45.81362326939905) |
| 1389496 | POLYGON((-0.273894995450974 41.5906066894531,-0.279154986143055 41.5950546264649,-0.283423990011158 41.5953788757325,-0.286260992288533 41.5984115600586,-0.288439989089909 41.5982093811036,-0.302262991666794 41.6079368591309,-0.305909991264343 41.6137504577636,-0.30522799491871 41.6162643432618,-0.30839899182314 41.6197357177736,-0.306979000568333 41.6209449768068,-0.312548995018005 41.6241188049316,-0.327123999595642 41.6242790222168,-0.336172014474869 41.6301612854003,-0.329317003488541 41.6430015563965,-0.328139990568161 41.6525421142579,-0.308068007230702 41.6896209716797,-0.304423987865334 41.6871223449708,-0.296573996543827 41.6877670288087,-0.289265006780624 41.6864395141602,-0.256417989730835 41.6652374267579,-0.256711989641133 41.662883758545,-0.253042995929718 41.6604728698732,-0.24584099650383 41.6606597900391,-0.238444998860246 41.6561164855957,-0.234482005238533 41.6561279296876,-0.228929996490479 41.6528625488282,-0.228319004177933 41.6505737304688,-0.222691997885704 41.650806427002,-0.221322000026646 41.6533241271973,-0.219411998987198 41.6535758972169,-0.211218997836056 41.651180267334,-0.20824900269497 41.6548805236817,-0.202778995037022 41.6528129577638,-0.20146599411953 41.6551017761232,-0.197668999433461 41.6565704345703,-0.193841993808746 41.6539611816406,-0.183480992913246 41.6520080566406,-0.178391993045807 41.6602325439453,-0.179947003722191 41.6633834838868,-0.179686993360519 41.674030303955,-0.183082997798863 41.6770973205566,-0.179819002747479 41.6962890625,-0.1718759983778 41.7075500488281,-0.155763000249863 41.7134475708008,-0.152720004320145 41.7131996154786,-0.133614003658295 41.7177124023438,-0.122100003063622 41.7241783142091,-0.095827996730804 41.7464447021484,-0.094022996723652 41.7451095581055,-0.103387996554375 41.7299385070801,-0.109111003577709 41.7157096862794,-0.101787999272346 41.6762237548828,-0.098575003445092 41.6688842773438,-0.093402996659222 41.6650543212891,-0.109413996338787 41.6545257568359,-0.124223999679032 41.6414871215821,-0.137388005852699 41.6250648498535,-0.148386999964714 41.6007270812989,-0.156405001878682 41.5899925231934,-0.184309005737248 41.5985832214356,-0.205696001648846 41.6022796630859,-0.227764993905964 41.5864830017089,-0.239502996206227 41.572566986084,-0.245928004383984 41.5737571716309,-0.264447987079507 41.5890502929687,-0.273894995450974 41.5906066894531)) | 0.0006 | POINT(-0.2177306440013756 41.65091546865613) |
| 34681 | POLYGON((4.10325527191168 48.9816856384277,4.11192035675049 48.974796295166,4.1164107322694 48.9752235412598,4.1164107322694 48.9752235412598,4.13196706771851 48.9825668334961,4.13373756408686 48.99169921875,4.13373756408686 48.99169921875,4.13704776763922 49.0012168884278,4.14586925506597 49.004566192627,4.16277790069591 49.0210494995117,4.16277790069591 49.0210494995117,4.16029119491577 49.0278739929199,4.16029119491577 49.0278739929199,4.11992406845098 49.0298652648927,4.10202836990362 49.0243492126466,4.10202836990362 49.0243492126466,4.10373878479015 49.0044593811036,4.10301256179815 49.0011558532715,4.09803676605225 49.0004730224609,4.09803676605225 49.0004730224609,4.10607862472546 48.9878654479981,4.10325527191168 48.9816856384277)) | 0.0006 | POINT(4.124256134033248 49.00235784621468) |