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
70818	POLYGON((11.8190650939941 50.6322937011719,11.8203649520875 50.6302452087403,11.8209762573243 50.6318397521974,11.8250179290771 50.631175994873,11.8260488510132 50.6301002502442,11.8237895965577 50.6297569274903,11.8226051330567 50.6278800964355,11.8255023956298 50.6272888183594,11.8255023956298 50.6272888183594,11.8299856185914 50.6282463073732,11.8322315216064 50.6256370544434,11.8336563110351 50.6259727478027,11.8337593078613 50.6236305236818,11.8307495117189 50.6217689514161,11.8332080841065 50.6206588745118,11.838815689087 50.6208839416504,11.8385496139526 50.6184921264648,11.8323421478271 50.6177253723146,11.8314361572266 50.6190223693848,11.8293724060058 50.6186141967775,11.830418586731 50.6170845031739,11.8298025131227 50.6153182983399,11.8380756378175 50.6078605651855,11.8406000137329 50.6090927124023,11.8421487808228 50.6073722839356,11.8449077606201 50.6084022521974,11.8457841873168 50.6078948974611,11.8428182601929 50.606086730957,11.8413963317871 50.6038360595704,11.8446769714355 50.6043281555176,11.8457708358765 50.6035156250001,11.8429765701294 50.6012420654298,11.8515462875367 50.5939331054688,11.8536653518677 50.5933799743652,11.8539781570436 50.5914840698243,11.8512010574341 50.5898170471192,11.8522062301637 50.5879058837892,11.8522062301637 50.5879058837892,11.8572826385498 50.5865135192871,11.8608493804932 50.5890998840333,11.8650522232056 50.5843887329102,11.8678970336915 50.5874252319337,11.8655891418458 50.5892333984376,11.8664999008179 50.5908889770508,11.8685913085938 50.5889282226562,11.8686800003051 50.5909881591797,11.8713598251344 50.5922241210938,11.8725557327271 50.5910873413087,11.8748292922974 50.591480255127,11.8738298416137 50.5925827026368,11.8798294067383 50.5956344604493,11.8798294067383 50.5956344604493,11.8806390762329 50.59672164917,11.8778886795044 50.5979232788087,11.8746490478517 50.5964164733886,11.8740043640136 50.5970726013184,11.8776645660401 50.600383758545,11.8740663528442 50.600643157959,11.8719558715821 50.6043586730958,11.8734693527222 50.6048545837402,11.8718099594116 50.607105255127,11.872748374939 50.6087150573731,11.8756532669068 50.608455657959,11.8772468566894 50.610206604004,11.8782606124878 50.6086120605469,11.8815574645997 50.6096267700196,11.879753112793 50.6136589050294,11.881986618042 50.613166809082,11.881986618042 50.613166809082,11.8829078674318 50.6151237487793,11.8768253326416 50.6179962158204,11.8659934997558 50.6195640563965,11.8647022247315 50.6218376159668,11.8585081100465 50.6185035705568,11.8541679382324 50.6210174560547,11.8509635925293 50.6207504272461,11.8470840454102 50.6265373229982,11.8445119857788 50.6256484985353,11.843457221985 50.6278190612794,11.8403224945068 50.6265525817871,11.8374891281129 50.6283950805664,11.834969520569 50.6278648376466,11.8381967544556 50.6304016113282,11.8374624252319 50.6329193115236,11.839168548584 50.6336822509767,11.8348274230958 50.6337890625001,11.8348274230958 50.6337890625001,11.8336410522462 50.6338653564454,11.8315143585206 50.6371994018555,11.8298120498658 50.6370506286621,11.8284606933595 50.6387939453126,11.8273172378541 50.6383934020996,11.8288726806642 50.6363487243653,11.8277015686035 50.6359748840333,11.8284282684327 50.6341590881349,11.8266944885253 50.6339073181153,11.8249607086182 50.635627746582,11.8181552886963 50.6341590881349,11.8190650939941 50.6322937011719))	0.0006	POINT(11.849460387716519 50.61387603136961)
54837	POLYGON((4.80998659133917 45.2664756774903,4.8088464736939 45.2588500976562,4.8088464736939 45.2588500976562,4.80038690567022 45.2591018676758,4.79952096939093 45.2528190612793,4.79372310638433 45.2481956481935,4.79372310638433 45.2481956481935,4.77424383163452 45.2494850158693,4.75635147094721 45.2441062927247,4.75635147094721 45.2441062927247,4.75898694992077 45.2585449218751,4.75898694992077 45.2585449218751,4.75878095626842 45.2685928344727,4.75878095626842 45.2685928344727,4.78449058532715 45.2692642211915,4.78449058532715 45.2692642211915,4.79658842086798 45.2650985717773,4.80998659133917 45.2664756774903))	0.0006	POINT(4.782534459058021 45.25812283684233)
22227	POLYGON((-0.932786583900338 44.9025230407715,-0.962872624397278 44.9263801574708,-0.980671226978302 44.951499938965,-0.980671226978302 44.951499938965,-1.02430069446558 44.9452323913575,-1.04596209526062 44.9368553161622,-1.07295680046076 44.9072952270508,-1.07295680046076 44.9072952270508,-1.03763437271118 44.8727149963379,-1.03763437271118 44.8727149963379,-1.01657962799061 44.8876419067383,-0.99692660570139 44.8891105651855,-0.980466663837319 44.8816146850587,-0.965641796588841 44.8826599121093,-0.93700897693634 44.8963623046876,-0.932786583900338 44.9025230407715))	0.0006	POINT(-1.0030046979585867 44.907426706949906)
26961	POLYGON((-1.0509814023971 48.7082748413086,-1.08707344532013 48.7157897949219,-1.08707344532013 48.7157897949219,-1.08921718597412 48.7164001464845,-1.08921718597412 48.7164001464845,-1.08006167411799 48.7044372558594,-1.08221971988672 48.69775390625,-1.08221971988672 48.69775390625,-1.08061635494226 48.6930809020996,-1.08061635494226 48.6930809020996,-1.06164050102234 48.6906585693361,-1.04172599315632 48.6831130981445,-1.04172599315632 48.6831130981445,-1.04335117340082 48.7035827636719,-1.0509814023971 48.7082748413086))	0.0006	POINT(-1.071267153535525 48.70137350899836)
63026	POLYGON((13.7975606918336 54.0485496520996,13.7964038848877 54.0461997985841,13.798306465149 54.0461044311525,13.8023777008057 54.0416107177734,13.8022470474243 54.0350646972656,13.807041168213 54.0332794189454,13.806529045105 54.0313339233399,13.810832977295 54.0312004089355,13.810832977295 54.0312004089355,13.8091669082642 54.0304183959962,13.8086109161377 54.0281944274903,13.8063888549806 54.0270843505859,13.8013877868652 54.0184707641601,13.7863893508911 54.0173606872559,13.7802791595459 54.0176391601563,13.7786111831664 54.0190277099611,13.7691659927369 54.0190277099611,13.7674999237061 54.0212516784667,13.7674999237061 54.0229148864747,13.7641677856446 54.0245819091796,13.7630558013916 54.0262489318848,13.7636117935181 54.0309715270996,13.7674999237061 54.0334739685059,13.7686100006104 54.0362510681153,13.7702779769898 54.0362663269044,13.7725000381469 54.0412483215333,13.7769451141358 54.0415267944337,13.7769451141358 54.0406951904297,13.7786111831664 54.0404167175294,13.779167175293 54.0387611389161,13.7819452285767 54.0387496948242,13.7830553054811 54.0395851135254,13.7830553054811 54.0412483215333,13.7813892364503 54.0423622131349,13.7813892364503 54.0437507629394,13.7852773666382 54.0468063354493,13.7902784347534 54.0487518310548,13.7908344268798 54.0498390197755,13.7908344268798 54.0498390197755,13.7975606918336 54.0485496520996))	0.0006	POINT(13.786066226470203 54.034802754720076)
68062	POLYGON((6.70902156829834 49.6282424926758,6.71602773666382 49.6303062438966,6.71895933151245 49.6349639892579,6.71802473068249 49.6369590759278,6.71802473068249 49.6369590759278,6.70963954925543 49.639144897461,6.70759296417231 49.6423835754395,6.70443916320812 49.6416435241699,6.70443916320812 49.6416435241699,6.69511175155634 49.6383361816407,6.69284820556641 49.6360931396485,6.68766450881958 49.6335792541503,6.6837329864502 49.6335182189942,6.6837329864502 49.6335182189942,6.69062709808361 49.6262283325196,6.69426202774059 49.6284675598145,6.70034360885631 49.6299438476563,6.70424747467035 49.630210876465,6.70902156829834 49.6282424926758))	0.0006	POINT(6.702152199215398 49.63456344604496)
34415	POLYGON((5.07306671142572 48.3495330810547,5.05296325683599 48.3512878417969,5.03236865997309 48.3484001159669,5.00643301010126 48.3516159057617,4.99734401702881 48.3483657836914,4.99734401702881 48.3483657836914,4.98063564300543 48.3384971618652,4.98063564300543 48.3384971618652,4.98322153091436 48.3351135253907,4.98322153091436 48.3351135253907,4.99328804016119 48.3357467651367,5.01224231719976 48.3312301635743,5.04594659805292 48.3121681213378,5.04594659805292 48.3121681213378,5.05046606063843 48.3159675598146,5.05046606063843 48.3159675598146,5.06009006500256 48.3350067138672,5.0692396163941 48.343189239502,5.07433366775513 48.3429679870606,5.07433366775513 48.3429679870606,5.07306671142572 48.3495330810547))	0.0006	POINT(5.028179335594191 48.33660850524903)
1398626	MULTIPOLYGON(((-5.0642848014831 40.2830390930176,-5.06121683120722 40.284236907959,-5.05259323120112 40.2814598083497,-5.0487961769104 40.2838325500489,-5.03184080123901 40.2794380187988,-5.02432203292841 40.2753448486329,-5.02229404449452 40.2719955444337,-5.02062606811518 40.2720527648926,-5.02045679092407 40.2746925354004,-5.01678085327148 40.270477294922,-5.01240921020508 40.2690238952638,-5.00120687484736 40.268424987793,-5.00157403945923 40.2649154663087,-4.99760913848877 40.261604309082,-5.00306701660151 40.2625389099122,-5.00590705871576 40.2607421875001,-5.01551103591908 40.2452049255372,-5.02013778686518 40.2418556213379,-5.01831197738647 40.2389221191407,-5.02733087539673 40.2370910644532,-5.03142595291132 40.2293434143068,-5.03225803375244 40.2214622497559,-5.02502202987671 40.2084846496582,-5.01965713500977 40.2055130004883,-5.02075481414795 40.2028999328613,-5.01786804199213 40.2026023864747,-5.01683092117304 40.1969223022461,-5.01184177398682 40.195526123047,-4.99865913391108 40.1986007690429,-4.99092578887939 40.1960945129395,-4.98753213882446 40.189323425293,-4.989098072052 40.1798133850097,-4.98850107192993 40.1617240905762,-4.99110412597656 40.1636238098145,-4.99670600891113 40.1636924743653,-5.01129198074335 40.1597976684571,-5.01319122314447 40.166862487793,-5.02444505691523 40.1768913269044,-5.03484678268421 40.1940689086914,-5.0468487739563 40.2025489807129,-5.05385494232178 40.213966369629,-5.04581880569452 40.2237396240236,-5.05329704284662 40.2339591979982,-5.05612277984613 40.247013092041,-5.05343580245966 40.2494506835938,-5.05288219451904 40.2537002563478,-5.0549168586731 40.2564735412599,-5.05405378341675 40.2648315429688,-5.05738306045532 40.2684135437012,-5.05696010589588 40.2726440429688,-5.06255722045898 40.2776794433594,-5.0642848014831 40.2830390930176)),((-4.97357702255249 40.2079849243164,-4.97544622421259 40.2147979736329,-4.97382783889765 40.2234230041504,-4.97028589248657 40.2220840454102,-4.95280790328974 40.2260818481445,-4.94524097442627 40.2232475280763,-4.9519572257995 40.2185516357422,-4.96283388137812 40.2175102233887,-4.97113609313965 40.2128906250001,-4.97357702255249 40.2079849243164)),((-4.97389221191401 40.1560211181642,-4.96973180770868 40.1697120666504,-4.97318077087397 40.1760025024415,-4.96873188018799 40.1777267456055,-4.96281099319458 40.1671562194825,-4.95826196670532 40.1554908752442,-4.9626469612121 40.1581115722657,-4.96534490585321 40.1578979492188,-4.97389221191401 40.1560211181642)),((-4.94572877883911 40.1326484680177,-4.94860696792597 40.1331253051759,-4.95341396331787 40.1534385681153,-4.94702482223511 40.1587600708008,-4.93723392486572 40.1612319946289,-4.930260181427 40.1674385070801,-4.92456722259516 40.1699905395507,-4.92361402511591 40.1649627685547,-4.91795301437378 40.1553039550781,-4.92236709594727 40.1415519714356,-4.9254531860351 40.1382598876954,-4.92534399032593 40.136043548584,-4.94572877883911 40.1326484680177)))	0.0006	POINT(-5.00529301864137 40.216165112885726)
62636	POLYGON((7.41805076599132 52.9522972106934,7.41326379776007 52.9513359069825,7.40598297119141 52.9515190124512,7.40426015853888 52.9484176635743,7.40109300613398 52.9478912353515,7.38298273086559 52.9475746154786,7.38298273086559 52.9475746154786,7.38809823989868 52.9454612731935,7.38710927963263 52.929500579834,7.39265346527105 52.9293289184571,7.3974289894104 52.9218788146973,7.39528799057013 52.9213981628419,7.40018844604492 52.9141349792481,7.40018844604492 52.9141349792481,7.40441036224365 52.9138832092285,7.39866876602173 52.8994483947754,7.40723896026611 52.8914108276368,7.41465854644781 52.8872871398927,7.41639471054083 52.8881301879884,7.4168376922608 52.8870162963868,7.4168376922608 52.8870162963868,7.41973114013672 52.8870162963868,7.42796373367321 52.8936500549316,7.43195819854748 52.8990211486816,7.43356847763067 52.8982582092285,7.43983936309814 52.9034080505371,7.43192481994623 52.9279365539552,7.43439149856567 52.9295196533204,7.43439149856567 52.9295196533204,7.42940759658813 52.9322547912598,7.43060302734375 52.9361457824708,7.42963266372692 52.9370193481445,7.43234205245966 52.9415168762207,7.42603540420538 52.9479980468751,7.41970586776728 52.9505996704102,7.41805076599132 52.9522972106934))	0.0006	POINT(7.413317516871892 52.92258584158765)
1401972	POLYGON((-4.33556509017933 41.700782775879,-4.34561586379999 41.699779510498,-4.34569120407099 41.6988182067871,-4.33754110336298 41.6917686462402,-4.33072900772083 41.6900825500488,-4.32628011703486 41.6811294555665,-4.31974315643305 41.6763610839845,-4.32203388214111 41.6732330322266,-4.33436393737793 41.6752700805663,-4.34146595001209 41.6730537414552,-4.34944105148304 41.6660690307618,-4.35565090179443 41.6660232543946,-4.36070394515991 41.6624870300294,-4.3637809753418 41.6643066406251,-4.36797189712524 41.6641921997071,-4.37199020385742 41.6610908508301,-4.37820816040039 41.6614418029785,-4.38099288940424 41.6597747802736,-4.38732385635376 41.6654777526855,-4.39842176437378 41.6648330688477,-4.39719486236572 41.6681289672852,-4.40123891830439 41.6700515747071,-4.40254688262939 41.6761322021485,-4.41513395309443 41.688102722168,-4.40705299377441 41.6949577331544,-4.40791416168207 41.69633102417,-4.41675519943232 41.6984214782716,-4.41969680786133 41.6977462768556,-4.4234619140625 41.7001304626466,-4.42200422286982 41.7037239074708,-4.4048027992248 41.7086563110352,-4.39827108383179 41.7160949707031,-4.39744377136225 41.7189331054689,-4.34390020370483 41.7201385498047,-4.33752298355103 41.718059539795,-4.34434413909906 41.7120285034181,-4.34351491928101 41.7108383178712,-4.34659576416004 41.711109161377,-4.34134101867676 41.7057685852051,-4.34164619445795 41.7036209106446,-4.33691883087158 41.7028732299806,-4.33556509017933 41.700782775879))	0.0006	POINT(-4.368361380042065 41.68823958606261)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point