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 |
---|---|---|---|
68432 | POLYGON((7.99103164672852 50.5794181823732,7.99165630340582 50.5754165649415,8.00061511993408 50.5743484497071,8.00003623962397 50.5734024047853,8.00267219543457 50.5719299316406,8.00345230102539 50.5694847106935,8.00492095947271 50.5689239501954,8.00460147857672 50.5680809020997,8.00826644897467 50.566722869873,8.00826644897467 50.566722869873,8.00864791870123 50.5645599365235,8.00686645507818 50.5637817382813,8.00611686706554 50.5608787536622,8.00301265716558 50.5602531433106,8.00055313110346 50.5557518005372,7.99656343460089 50.5545120239259,7.99911308288574 50.5538749694824,8.00065612792963 50.5511703491211,8.00300121307367 50.5506439208985,8.00323963165278 50.5493621826173,8.00584602355951 50.5479164123536,8.00584602355951 50.5479164123536,7.99986791610729 50.5446624755859,7.9984707832337 50.5454063415528,7.99641656875605 50.5445709228517,7.99641656875605 50.5445709228517,7.9931726455689 50.5438194274902,7.98622179031383 50.547737121582,7.97890996932995 50.5503730773926,7.97854423522949 50.551914215088,7.97583007812511 50.5519371032716,7.97531127929688 50.5502853393555,7.97275924682617 50.5504455566407,7.97275543212902 50.549201965332,7.96811294555675 50.5496139526367,7.96671056747448 50.5462799072266,7.96307325363165 50.5445709228517,7.9719753265382 50.5382652282715,7.96713590621948 50.5355415344239,7.96713590621948 50.5355415344239,7.96585226058971 50.5352516174316,7.96585226058971 50.5352516174316,7.96001815795904 50.5331687927247,7.95900058746344 50.5361099243164,7.94876003265381 50.5375747680663,7.94645881652838 50.5367774963379,7.94517183303833 50.5383605957031,7.94232749938971 50.5381889343263,7.94023847579967 50.5425453186036,7.9384498596192 50.5424423217774,7.9384498596192 50.5424423217774,7.9395637512207 50.5442924499513,7.94242525100714 50.5444107055665,7.94955110549921 50.5482139587402,7.94886827468866 50.5490837097169,7.9536304473877 50.5503768920898,7.9539999961853 50.5516357421876,7.94830036163341 50.5558662414551,7.9484977722168 50.557689666748,7.94068193435663 50.563388824463,7.9323663711549 50.5650138854981,7.9323663711549 50.5650138854981,7.93006753921514 50.5676918029786,7.92941570281982 50.5712165832521,7.92357921600347 50.5754585266113,7.92357921600347 50.5754585266113,7.93134212493908 50.5772438049317,7.93513536453241 50.5792350769044,7.93327617645269 50.5798797607423,7.93349456787121 50.5813064575195,7.93882465362549 50.5815773010254,7.93999671936047 50.5823860168458,7.93899774551386 50.5856513977051,7.9373860359193 50.5856437683106,7.93771362304682 50.5868911743165,7.93771362304682 50.5868911743165,7.93840456008917 50.5886192321777,7.94079494476318 50.5887336730958,7.94113063812256 50.5906028747559,7.94478321075445 50.5905418395996,7.94478321075445 50.5905418395996,7.94847536087042 50.5855979919434,7.94847536087042 50.5855979919434,7.95666360855103 50.5790824890137,7.95908498764044 50.5790176391602,7.95916175842285 50.577606201172,7.96278238296509 50.5752372741699,7.96817541122442 50.5738067626953,7.96910285949707 50.5754852294923,7.97512817382812 50.5754356384277,7.97653627395636 50.5799942016602,7.97653627395636 50.5799942016602,7.98173999786377 50.5792007446289,7.98865699768078 50.5825729370118,7.99135494232183 50.5813102722169,7.99010324478155 50.5798606872559,7.99103164672852 50.5794181823732)) | 0.0006 | POINT(7.967260728279785 50.562169591585814) |
23170 | POLYGON((-0.740468978881836 42.9488716125489,-0.720809519290924 42.9582061767578,-0.72442102432251 42.9754943847657,-0.736028730869293 42.9940681457521,-0.736028730869293 42.9940681457521,-0.708826541900578 42.9795455932617,-0.694787204265538 42.978786468506,-0.688085854053497 42.983497619629,-0.682829558849335 42.9968795776367,-0.672215521335602 43.0039672851562,-0.662779748439789 43.0050888061523,-0.639558851718846 42.9937782287598,-0.612125217914581 42.9883041381836,-0.612125217914581 42.9883041381836,-0.614334583282471 42.9846000671387,-0.614334583282471 42.9846000671387,-0.609731078147888 42.9616889953613,-0.615164339542332 42.9525032043458,-0.615164339542332 42.9525032043458,-0.627744376659336 42.9480934143068,-0.65134060382843 42.9470138549805,-0.665517210960274 42.9558944702148,-0.68323540687561 42.9606361389161,-0.692964971065464 42.946159362793,-0.706846892833653 42.9480285644532,-0.730891346931458 42.9386901855468,-0.732284545898438 42.9430618286134,-0.732284545898438 42.9430618286134,-0.733271777629795 42.946159362793,-0.740468978881836 42.9488716125489)) | 0.0006 | POINT(-0.6778000449311928 42.96901913346921) |
13281 | POLYGON((16.3221988677979 38.4006576538087,16.329652786255 38.3941192626953,16.3298377990723 38.3904342651367,16.3325214385987 38.3882408142089,16.3451824188233 38.383129119873,16.3485279083253 38.384464263916,16.3497428894044 38.3839645385742,16.3529796600342 38.3690490722657,16.3528861999512 38.3639831542969,16.3502120971681 38.3599166870117,16.3502120971681 38.3599166870117,16.3460597991943 38.3544349670411,16.3392391204835 38.3514595031738,16.3355388641357 38.34867477417,16.3316307067872 38.3364715576172,16.3243007659912 38.3304328918458,16.3203678131103 38.3254318237305,16.3209171295167 38.3191986083985,16.3137874603271 38.3166275024414,16.2980461120607 38.3156700134278,16.2980461120607 38.3156700134278,16.283582687378 38.3368644714356,16.2811374664307 38.3473358154297,16.2832145690917 38.3495903015137,16.2832145690917 38.3495903015137,16.2886638641357 38.3470993041993,16.2916812896729 38.3473472595215,16.2888774871827 38.3519477844239,16.2948226928711 38.3614463806153,16.2996273040773 38.3729934692383,16.3001995086671 38.3830718994141,16.2986698150635 38.3849906921386,16.2993125915528 38.3922996520996,16.3097953796387 38.4040527343751,16.3221988677979 38.4006576538087)) | 0.0006 | POINT(16.317490802091758 38.35942874235268) |
12751 | POLYGON((18.3596115112306 39.9981994628906,18.3724231719972 40.0047607421876,18.3804702758789 40.0105895996094,18.3831272125245 40.0204086303712,18.3816356658936 40.0243759155274,18.3816356658936 40.0243759155274,18.3897857666015 40.0238494873048,18.3959083557129 40.021942138672,18.4028053283693 40.014274597168,18.4010257720948 40.0090904235841,18.4010257720948 40.0090904235841,18.3990497589111 40.0060424804688,18.3993568420411 40.0051498413087,18.4179172515869 39.9945907592774,18.4179172515869 39.9945907592774,18.4154167175294 39.9918060302736,18.4129161834717 39.981803894043,18.4090270996095 39.9781951904297,18.4081935882569 39.9757614135743,18.4081935882569 39.9757614135743,18.3992938995362 39.9779396057129,18.3914203643799 39.982307434082,18.3873786926271 39.993839263916,18.3811111450196 39.9964904785157,18.3782768249512 39.9966354370117,18.3737316131592 39.9963912963868,18.3687458038331 39.9945068359374,18.3637390136719 39.9953536987305,18.3596115112306 39.9981994628906)) | 0.0006 | POINT(18.392183576311435 39.999932970319534) |
57653 | POLYGON((6.41261863708502 50.1303939819336,6.41451549530041 50.1307678222656,6.41032171249401 50.1284294128419,6.41403532028204 50.1214790344238,6.41768360137939 50.1197586059571,6.41768360137939 50.1197586059571,6.42604446411127 50.1154937744141,6.42604446411127 50.1154937744141,6.43195915222179 50.12020111084,6.43195915222179 50.12020111084,6.43443202972418 50.1229972839357,6.43282079696667 50.1251678466798,6.4336261749267 50.1265563964844,6.44124984741222 50.1302223205568,6.44213771820063 50.1333656311035,6.44323444366449 50.1333351135254,6.43929576873785 50.1385383605958,6.44127511978149 50.1392860412598,6.43948268890381 50.1406059265137,6.43948268890381 50.1406059265137,6.43732309341431 50.1428909301759,6.42817306518555 50.1414871215821,6.42624330520636 50.1394462585449,6.41622209548956 50.134090423584,6.41622209548956 50.134090423584,6.41508007049566 50.1315994262696,6.41261863708502 50.1303939819336)) | 0.0006 | POINT(6.428044869349586 50.12985625633832) |
33269 | POLYGON((4.3835272789002 49.9013137817383,4.38828372955328 49.90283203125,4.38958978652965 49.9196090698242,4.38114452362055 49.9355773925782,4.38066625595098 49.9389801025391,4.38384294509899 49.9416503906251,4.39925003051769 49.9430465698242,4.40238809585577 49.9457855224609,4.39917421340954 49.9484024047852,4.39917421340954 49.9484024047852,4.41921043395996 49.9464454650879,4.43303489685064 49.9416236877441,4.44580364227289 49.9371681213379,4.44580364227289 49.9371681213379,4.45523786544805 49.9292488098145,4.4513921737672 49.919807434082,4.4513921737672 49.919807434082,4.42464208602905 49.9081611633301,4.39975070953381 49.9019813537598,4.3835272789002 49.9013137817383)) | 0.0006 | POINT(4.4122794050919945 49.92984269794666) |
41469 | POLYGON((5.9724431037904 48.4555015563965,5.97997474670416 48.4625320434571,5.97915363311779 48.4685745239258,5.97915363311779 48.4685745239258,5.99953269958502 48.4608421325684,6.00580120086681 48.4523582458496,6.00580120086681 48.4523582458496,5.98579025268566 48.4543457031251,5.98151731491083 48.4525108337403,5.9724431037904 48.4555015563965)) | 0.0006 | POINT(5.9876853095161415 48.4586219787598) |
70123 | POLYGON((9.39185905456543 53.9419059753417,9.39303588867188 53.9375495910645,9.39480495452887 53.9362258911134,9.39480495452887 53.9362258911134,9.41929340362549 53.9420661926271,9.41929340362549 53.9420661926271,9.41770458221436 53.9434890747071,9.41919231414806 53.9467430114747,9.42360305786144 53.9493865966798,9.43195343017578 53.950439453125,9.43358802795416 53.9527091979981,9.43266677856451 53.9542617797852,9.43266677856451 53.9542617797852,9.42556762695318 53.9543380737306,9.42658329010021 53.9532775878906,9.41557979583746 53.9511222839355,9.41297626495356 53.9559707641602,9.41297626495356 53.9559707641602,9.4115047454834 53.9557228088379,9.41328907012945 53.9513931274414,9.41212272644049 53.9511299133301,9.41466426849371 53.9469299316407,9.39185905456543 53.9419059753417)) | 0.0006 | POINT(9.41589684919881 53.94832663102588) |
1403784 | POLYGON((3.10258507728588 42.0642280578614,3.09521007537836 42.0620079040527,3.09117603302008 42.0618820190429,3.07867288589478 42.0703163146974,3.08207297325134 42.0727806091309,3.08109498023998 42.0767059326173,3.07653689384472 42.0764236450195,3.07107901573187 42.08402633667,3.07640004158026 42.0867309570313,3.0780069828034 42.0892372131349,3.08949899673462 42.0907402038575,3.10130906105042 42.1018371582032,3.10810089111339 42.1028175354004,3.12724590301525 42.108310699463,3.12985491752636 42.1076736450195,3.13210701942438 42.0983352661133,3.13278889656067 42.0847434997559,3.13129806518555 42.0828247070314,3.10651898384106 42.0821266174317,3.10193800926214 42.0802307128906,3.09955191612255 42.0752716064453,3.10069108009338 42.0647621154786,3.10258507728588 42.0642280578614)) | 0.0006 | POINT(3.099715395407293 42.08290967074311) |
73374 | POLYGON((16.1297912597656 46.6072311401368,16.1451263427735 46.607250213623,16.1451263427735 46.607250213623,16.1656341552734 46.6179389953613,16.1656532287598 46.6214942932128,16.1707649230958 46.6214981079102,16.1707859039308 46.6250534057617,16.1758975982667 46.625057220459,16.1759548187256 46.6357269287109,16.1912899017335 46.6357421875,16.191328048706 46.6428527832032,16.2015533447266 46.6428642272949,16.2015724182128 46.6464195251465,16.2117958068848 46.6464309692383,16.2118167877198 46.64998626709,16.2169284820558 46.6499900817872,16.2220973968506 46.6606636047363,16.2220973968506 46.6606636047363,16.21187210083 46.6606521606446,16.2118911743165 46.6642074584962,16.2016677856445 46.6641960144044,16.1914806365968 46.6712951660157,16.1914997100831 46.6748504638672,16.1812763214112 46.6748428344727,16.1812953948975 46.6783981323243,16.1762962341309 46.6997261047363,16.1660747528077 46.6997146606446,16.166130065918 46.7103805541993,16.1610183715821 46.7103767395019,16.1610183715821 46.7103767395019,16.1558685302736 46.7032585144044,16.1507568359374 46.703254699707,16.1456050872803 46.6961364746095,16.0944805145264 46.6960830688477,16.0944805145264 46.6960830688477,16.0944232940674 46.685417175293,16.0892925262451 46.681854248047,16.0943679809571 46.6747512817384,16.0943489074708 46.6711959838867,16.0994606018067 46.671199798584,16.0994415283203 46.6676445007325,16.1044960021972 46.6569824218751,16.1198310852051 46.6569976806641,16.1197967529298 46.6498870849609,16.1146831512451 46.6498832702638,16.1146450042724 46.6427726745606,16.0992698669434 46.6356430053712,16.0941009521484 46.6249732971191,16.0941009521484 46.6249732971191,16.0991554260253 46.6143112182618,16.0991554260253 46.6143112182618,16.1042289733887 46.6072044372559,16.1195869445801 46.6107788085938,16.1298103332521 46.6107902526857,16.1297912597656 46.6072311401368)) | 0.0006 | POINT(16.150780042012563 46.65499107925983) |