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.

Spaltenname	Datentyp	Mögliche Werte	Beschreibung
id_ort	int(10) unsigned	beliebig	Fremdschlü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"	beliebig	Die simplifizierten Geodaten.
epsilon	float(5,4)	beliebig	Die 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"	beliebig	Der geometrische Mittelpunkt des vereinfachten Polygons.

Ausschnitt

id_ort	geodaten	epsilon	mittelpunkt
15102	POLYGON((8.04969406127935 44.0128211975097,8.04804992675787 44.0079498291015,8.04995632171637 44.0041885375977,8.04870033264166 44.0018043518066,8.02948570251471 44.0003242492676,8.01483535766613 43.995777130127,8.00718688964844 43.9895362854005,8.00718688964844 43.9895362854005,8.01796054840094 43.9803237915039,8.01796054840094 43.9803237915039,8.03431034088135 43.9827003479004,8.03431034088135 43.9827003479004,8.05439662933361 43.9822311401367,8.05439662933361 43.9822311401367,8.05965709686274 43.9847106933594,8.07996368408214 43.9847793579102,8.07996368408214 43.9847793579102,8.08002758026134 43.9887237548828,8.08169460296625 43.9914016723633,8.08839988708496 43.995632171631,8.097412109375 44.0039749145508,8.09351825714111 44.0049591064453,8.09263515472418 44.0064582824708,8.09174346923834 44.0134277343751,8.09241867065435 44.0181121826172,8.09241867065435 44.0181121826172,8.07174682617199 44.0183143615724,8.07174682617199 44.0183143615724,8.06427669525158 44.0190010070801,8.04969406127935 44.0128211975097))	0.0006	POINT(8.05882943909749 43.998039640229365)
35353	POLYGON((9.2716846466065 42.3405151367189,9.25912094116217 42.3281745910645,9.25912094116217 42.3281745910645,9.25526905059814 42.3222618103028,9.25740814208979 42.3089904785157,9.24661731719982 42.2906303405763,9.24661731719982 42.2906303405763,9.27447700500488 42.3022232055664,9.27447700500488 42.3022232055664,9.27967643737787 42.3134384155275,9.27749538421637 42.3192558288575,9.27749538421637 42.3192558288575,9.27547740936285 42.3310165405273,9.2812557220459 42.3351554870605,9.2812557220459 42.3351554870605,9.2716846466065 42.3405151367189))	0.0006	POINT(9.267829895019561 42.31780675252284)
1389882	POLYGON((-0.943261027336121 40.7752761840821,-0.940343976020813 40.7788009643556,-0.949073016643467 40.7796859741212,-0.952251970767861 40.7830123901367,-0.955139994621277 40.7967185974122,-0.961088001728001 40.797508239746,-0.950190007686615 40.7992591857911,-0.946609020233097 40.7973022460939,-0.943095028400364 40.7979278564453,-0.934669017791748 40.8051338195801,-0.935923993587494 40.8093185424806,-0.931141018867493 40.8141174316406,-0.917663991451263 40.8060836791992,-0.914892971515656 40.8113021850586,-0.90913999080658 40.816276550293,-0.873444020748082 40.826171875,-0.871914982795658 40.8243522644043,-0.856437027454376 40.8229751586915,-0.847981989383698 40.8285026550292,-0.843050003051758 40.8240776062013,-0.829382002353668 40.8185310363771,-0.818639993667546 40.8163375854493,-0.819792985916138 40.8151206970216,-0.815895974636078 40.8132247924805,-0.826215982437134 40.7912788391114,-0.831052005290928 40.7719230651856,-0.837320029735565 40.7749023437501,-0.85639899969101 40.7792587280273,-0.851078987121525 40.7840003967286,-0.871712028980141 40.7906494140625,-0.880609989166203 40.7955360412598,-0.882202982902527 40.7987442016602,-0.894940972328186 40.8011283874512,-0.920499026775303 40.7744712829591,-0.932188987731877 40.7769355773926,-0.943261027336121 40.7752761840821))	0.0006	POINT(-0.8927211999892929 40.7998813084194)
65767	POLYGON((10.3239145278931 48.4798316955566,10.3297843933107 48.4835548400879,10.330493927002 48.481746673584,10.335150718689 48.484676361084,10.3348197937012 48.4864730834961,10.3526449203491 48.4897422790527,10.3536701202393 48.4926147460938,10.3521375656128 48.4983863830566,10.3533630371093 48.5003128051759,10.3580722808838 48.4998512268066,10.357403755188 48.4972610473634,10.3608121871949 48.497714996338,10.3617925643921 48.4948921203613,10.3646068572998 48.4951286315918,10.3657503128052 48.4928359985353,10.3731822967529 48.4957962036133,10.3762845993043 48.4943428039551,10.3735418319703 48.492847442627,10.374303817749 48.4913177490236,10.3763475418092 48.4908905029297,10.3766288757325 48.4917984008789,10.3807249069214 48.4931335449219,10.3875589370728 48.4919166564942,10.3875589370728 48.4919166564942,10.3872528076172 48.4898681640625,10.383563041687 48.4884223937988,10.3799581527711 48.4856147766113,10.3799905776978 48.4835815429688,10.3808565139771 48.4832496643068,10.3824501037597 48.48445892334,10.385293006897 48.4833717346192,10.3920688629151 48.4835319519044,10.3921775817871 48.4826164245606,10.3896379470826 48.4822807312013,10.3912153244019 48.4810447692872,10.3936834335328 48.4812622070312,10.3967351913453 48.4830856323243,10.4054298400879 48.4845237731934,10.4067163467408 48.4837532043458,10.4141416549683 48.483425140381,10.4167413711548 48.4819717407228,10.4190511703492 48.4824523925781,10.4196968078613 48.4807014465333,10.4196968078613 48.4807014465333,10.4179611206055 48.4803161621094,10.4201316833497 48.4765968322754,10.4145078659058 48.4754333496094,10.4058341979981 48.4755554199219,10.4063062667847 48.4718818664551,10.4082746505738 48.4719429016114,10.4059572219849 48.4703559875488,10.4012660980225 48.4700088500976,10.3889970779419 48.4662475585938,10.3889970779419 48.4662475585938,10.3850259780885 48.4703330993652,10.3833103179933 48.469711303711,10.3815202713012 48.4717063903809,10.3776149749756 48.4708824157715,10.3744735717774 48.4724197387696,10.3677101135255 48.473373413086,10.3672513961793 48.4729385375977,10.3719663619995 48.4692955017091,10.368712425232 48.4678077697753,10.364450454712 48.4685363769531,10.3583736419678 48.466194152832,10.3575572967529 48.4677238464356,10.3545188903809 48.4666213989258,10.3522825241088 48.4682464599611,10.3514471054077 48.4673919677734,10.3472166061402 48.47123336792,10.3453807830811 48.4702224731445,10.3433923721314 48.4705352783204,10.3408069610597 48.4670333862305,10.3372163772584 48.4654655456544,10.3345241546631 48.4676246643066,10.3336925506592 48.4672966003418,10.3348741531373 48.4662780761719,10.3308429718018 48.4631271362306,10.3239803314209 48.461524963379,10.3239803314209 48.461524963379,10.321575164795 48.4611320495605,10.3181514739991 48.4656143188476,10.3136568069458 48.467342376709,10.3156213760375 48.4698371887208,10.3212804794313 48.4716262817383,10.32426071167 48.4737777709962,10.3248329162599 48.4763336181641,10.3239145278931 48.4798316955566))	0.0006	POINT(10.368811958137638 48.478898848610385)
57815	POLYGON((7.94853496551519 49.6091384887695,7.9512176513673 49.6071586608887,7.9512176513673 49.6071586608887,7.95912218093883 49.60750579834,7.96704339981073 49.6091041564942,7.97385454177851 49.6089248657227,7.97675895690912 49.6079635620117,7.97675895690912 49.6079635620117,7.97378063201916 49.6024589538575,7.97378063201916 49.6024589538575,7.97104644775402 49.6025695800782,7.96954011917126 49.6012039184571,7.97403335571283 49.598731994629,7.97118473052984 49.5983886718749,7.96847677230841 49.5964355468751,7.96847677230841 49.5964355468751,7.96464776992804 49.5952606201172,7.9585390090943 49.5950355529786,7.95882654190075 49.5940513610841,7.95401144027721 49.59423828125,7.95344924926752 49.5933532714844,7.9450831413269 49.5913200378419,7.93827819824213 49.5883407592773,7.93516111373913 49.5883674621583,7.93516969680792 49.5913009643556,7.93339061737055 49.5911712646484,7.93206977844238 49.5928153991699,7.93067502975464 49.5927391052247,7.92920923233038 49.5950202941896,7.93687152862543 49.5974006652832,7.93550300598145 49.5982131958008,7.94002103805542 49.5985260009767,7.94105243682873 49.6019477844238,7.94258785247814 49.6019859313965,7.94290971755993 49.6039886474609,7.94290971755993 49.6039886474609,7.94352436065685 49.6057052612305,7.94352436065685 49.6057052612305,7.94731330871582 49.6071243286134,7.94853496551519 49.6091384887695))	0.0006	POINT(7.95280912594922 49.59977438510998)
48699	POLYGON((-0.650101900100651 48.3049736022949,-0.644378304481506 48.3141479492189,-0.635508835315704 48.3173027038575,-0.632428586483002 48.3237380981445,-0.623432874679565 48.3266639709472,-0.619235873222351 48.3327980041504,-0.619235873222351 48.3327980041504,-0.631614387035313 48.3473625183106,-0.631614387035313 48.3473625183106,-0.66237419843668 48.3265190124512,-0.66237419843668 48.3265190124512,-0.661649763584137 48.3232879638673,-0.674900114536229 48.313835144043,-0.670016288757324 48.3018913269043,-0.670016288757324 48.3018913269043,-0.650101900100651 48.3049736022949))	0.0006	POINT(-0.6459254582722754 48.32273941040042)
64884	POLYGON((10.0555629730226 50.3194580078126,10.0566511154174 50.3200492858887,10.0566511154174 50.3200492858887,10.050347328186 50.3280601501465,10.0422477722168 50.3349075317383,10.0440950393678 50.3362731933594,10.0423250198365 50.3410987854004,10.046880722046 50.3440132141114,10.0495672225952 50.3438606262208,10.052396774292 50.3420562744142,10.0529527664185 50.34273147583,10.0501623153687 50.3448829650879,10.0568714141846 50.3461570739747,10.058617591858 50.3473243713379,10.0494232177735 50.3457145690919,10.0462713241577 50.3473587036134,10.04421043396 50.3467826843262,10.0477724075317 50.3448524475098,10.0404758453369 50.3433036804199,10.0381994247438 50.3474426269531,10.0388221740723 50.3485145568848,10.0415401458741 50.3480606079102,10.0417613983155 50.3499145507812,10.0396919250488 50.3501014709473,10.0404214859009 50.3531379699708,10.0379734039307 50.356143951416,10.0346212387084 50.3566856384277,10.0346212387084 50.3566856384277,10.0363998413086 50.3531036376954,10.0352182388307 50.3516960144042,10.0332336425782 50.3519134521485,10.0326347351074 50.3498687744142,10.0307092666626 50.3498420715332,10.0268650054931 50.3517608642579,10.0257520675659 50.3505592346191,10.0268192291261 50.3479194641113,10.0221138000489 50.3446426391602,10.0193624496459 50.3496589660645,10.0121698379516 50.3544082641603,10.0097646713257 50.3571510314942,10.0127353668214 50.3609046936035,10.0154056549073 50.3610801696777,10.0176458358764 50.3607368469239,10.0182123184205 50.3576622009277,10.0236301422119 50.3545989990236,10.0252237319947 50.3568840026855,10.0233726501465 50.3577575683594,10.0240545272828 50.3584518432618,10.0309867858887 50.3586502075196,10.0339975357056 50.3571357727051,10.0339975357056 50.3571357727051,10.0359363555909 50.3573837280273,10.0301465988159 50.3611221313478,10.0303201675415 50.3619766235352,10.0264701843262 50.363006591797,10.0273694992066 50.3644943237305,10.0261945724487 50.3652458190917,10.0231046676636 50.3647575378419,10.0233955383301 50.3665657043458,10.0221328735352 50.3676147460939,10.0239038467408 50.370590209961,10.0234422683716 50.3716773986818,10.0234422683716 50.3716773986818,10.0155324935914 50.369239807129,10.0085401535035 50.3693733215333,9.99588871002203 50.3657913208008,9.99560451507574 50.3647193908691,9.99073219299322 50.3652305603028,9.97646331787104 50.3556098937989,9.96808528900146 50.3576660156251,9.96657085418713 50.3560409545898,9.96371936798101 50.3594360351562,9.96014595031738 50.3607597351075,9.95813846588146 50.3591766357423,9.95634365081793 50.3599510192871,9.95741271972656 50.361125946045,9.95196628570562 50.3638610839844,9.95196628570562 50.3638610839844,9.95252609252924 50.3616180419922,9.94800853729254 50.3606872558594,9.94728946685802 50.3584060668946,9.94356155395502 50.3584518432618,9.93950176239025 50.3568840026855,9.93895339965832 50.3532905578613,9.92742061614985 50.3510475158692,9.92823982238781 50.349594116211,9.9346075057984 50.346305847168,9.93339920043951 50.3450660705566,9.93339920043951 50.3450660705566,9.9345207214356 50.3441734313965,9.93438529968267 50.3426055908204,9.93681621551525 50.3415184020997,9.93694114685053 50.3405227661134,9.93520450592047 50.339900970459,9.93737411499029 50.3372383117676,9.9436025619508 50.3347854614259,9.94622802734381 50.3350868225099,9.94610595703136 50.335880279541,9.94936943054199 50.3381347656251,9.9537115097047 50.3370742797853,9.95772838592529 50.335018157959,9.95675849914556 50.3337593078614,9.9585857391358 50.3313026428223,9.96267700195318 50.3312606811523,9.96240615844738 50.3291168212891,9.96064090728771 50.3274459838867,9.96086692810064 50.3260879516602,9.96992397308361 50.3256072998048,9.97115516662609 50.3223037719727,9.97055530548096 50.3194198608398,9.97411727905273 50.3163146972656,9.97714996337896 50.3165817260743,9.98716640472412 50.3129539489747,9.99086380004877 50.3180274963379,9.99643707275396 50.3224334716797,9.99891567230236 50.323299407959,9.99927425384527 50.3239669799805,9.99647617340099 50.3253402709961,10.0020112991333 50.325653076172,10.0036735534668 50.3266296386719,10.0009994506837 50.3295516967774,10.005226135254 50.3313522338868,10.0093603134156 50.3271598815918,10.0132379531861 50.3258895874023,10.0142059326173 50.3260650634766,10.0143041610718 50.3274612426758,10.0127859115601 50.3302154541017,10.0156002044678 50.3299026489258,10.0156002044678 50.3299026489258,10.0163879394531 50.3312110900879,10.0199422836303 50.3328285217285,10.0192584991455 50.3337326049805,10.0196819305421 50.3362731933594,10.0209846496583 50.3367919921875,10.0261478424072 50.3321533203124,10.0282897949219 50.3288230895996,10.0291681289673 50.3281250000001,10.0307664871215 50.3285789489747,10.0319452285768 50.3273544311525,10.0289392471313 50.3257408142091,10.0298013687134 50.3238601684571,10.0320873260499 50.3243217468262,10.034336090088 50.3286132812501,10.0332469940187 50.3292999267578,10.0345849990845 50.3304672241211,10.0394916534424 50.3274993896485,10.0422039031984 50.3290138244629,10.0441684722901 50.3324661254883,10.0555629730226 50.3194580078126))	0.0006	POINT(10.004700757361778 50.34397037609204)
40249	POLYGON((1.74073374271399 44.9605827331542,1.72239911556255 44.968147277832,1.71345174312597 44.9677925109864,1.71345174312597 44.9677925109864,1.73137331008923 44.9790916442871,1.73840022087103 44.9915695190429,1.73840022087103 44.9915695190429,1.74575316905981 44.9958686828613,1.78430032730103 44.9974212646485,1.78430032730103 44.9974212646485,1.78101241588604 44.9834632873535,1.78101241588604 44.9834632873535,1.7781950235368 44.9805793762208,1.7635568380357 44.9821548461915,1.75498223304754 44.9786186218262,1.74073374271399 44.9605827331542))	0.0006	POINT(1.7514215230942505 44.98170242309572)
41610	POLYGON((5.37220287322992 48.6973762512208,5.37757015228277 48.7033004760742,5.37661886215221 48.7101821899414,5.36515092849743 48.728973388672,5.36515092849743 48.728973388672,5.3440928459168 48.734977722168,5.3440928459168 48.734977722168,5.33581686019909 48.7117462158204,5.33581686019909 48.7117462158204,5.33802270889282 48.7066535949707,5.33802270889282 48.7066535949707,5.35196781158447 48.7062530517579,5.36205530166626 48.6960220336913,5.36205530166626 48.6960220336913,5.37220287322992 48.6973762512208))	0.0006	POINT(5.35490264211387 48.71241841997422)
54917	POLYGON((5.39621210098272 44.715446472168,5.42963027954113 44.7278785705566,5.42963027954113 44.7278785705566,5.4243106842041 44.7334327697754,5.41604518890381 44.7301635742188,5.39733839035046 44.728832244873,5.3942108154298 44.7263069152833,5.39580488204962 44.7162666320801,5.39580488204962 44.7162666320801,5.39621210098272 44.715446472168))	0.0006	POINT(5.408776389228042 44.7247191535102)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point