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
58116	POLYGON((7.04422187805176 49.9804573059083,7.04824113845825 49.9793548583984,7.04672479629528 49.9750595092775,7.05077981948858 49.9732627868653,7.04689311981201 49.9687232971191,7.04822063446045 49.9679450988769,7.04728698730474 49.9663848876953,7.04840421676641 49.9642753601075,7.05194187164318 49.9632453918458,7.05247974395752 49.9616050720216,7.05620098114008 49.9599723815918,7.06464529037487 49.961929321289,7.06655263900768 49.9602737426758,7.0713000297547 49.9620475769043,7.0713000297547 49.9620475769043,7.07784223556524 49.9638290405275,7.08387517929077 49.9670944213867,7.08387517929077 49.9670944213867,7.08110475540173 49.9687271118165,7.07204866409307 49.9674835205078,7.07157039642334 49.9698448181152,7.06807613372814 49.9745140075684,7.06817626953125 49.9760322570801,7.06197309494019 49.9793281555177,7.06321525573736 49.9803047180177,7.05980491638189 49.9820671081543,7.05483531951916 49.990665435791,7.05571508407598 49.9918823242187,7.05698347091669 50.0020561218263,7.06042051315313 50.0043754577636,7.06042051315313 50.0043754577636,7.05819559097296 50.0042190551759,7.05894565582281 50.0060157775879,7.05646324157709 50.0046005249025,7.05411720275879 50.0051498413087,7.05433320999151 50.0065956115723,7.04954528808599 50.0065231323243,7.05017805099487 50.0078125000001,7.0462727546693 50.0071334838867,7.0462727546693 50.0071334838867,7.04674053192144 50.0053138732911,7.04467010498058 50.0068740844727,7.04321765899664 50.0064773559571,7.04245948791504 50.0026969909668,7.03904724121099 50.0002441406251,7.03902149200445 49.9983062744142,7.0425791740418 49.9947395324708,7.04071187973028 49.994483947754,7.04133415222174 49.9932327270508,7.03908538818365 49.9930305480958,7.03529500961304 49.9932746887208,7.03274345397955 49.9951286315919,7.03398990631115 49.9968795776367,7.03312540054321 49.9980201721193,7.02644300460827 49.9971542358399,7.02003240585333 50.0041961669922,7.01509571075439 50.0051879882814,7.01002883911144 50.0049171447755,7.01002883911144 50.0049171447755,7.00793313980097 50.0032043457032,7.00793313980097 50.0032043457032,7.00739765167248 50.0004234313965,7.0111608505249 49.997142791748,7.02404832839966 49.9930114746095,7.02404832839966 49.9930114746095,7.02515411376959 49.9930076599122,7.02684879302979 49.9910888671876,7.02728033065802 49.9852027893067,7.03597259521484 49.9847755432129,7.04027557373058 49.983238220215,7.04422187805176 49.9804573059083))	0.0006	POINT(7.046330806187265 49.98819754464288)
55229	POLYGON((4.94959115982056 45.052864074707,4.95011329650879 45.0390396118165,4.95011329650879 45.0390396118165,4.96324062347412 45.0413589477538,4.99242210388189 45.0324554443359,4.99242210388189 45.0324554443359,4.99507665634167 45.0602569580078,4.99507665634167 45.0602569580078,4.97906780242931 45.0599899291993,4.97906780242931 45.0599899291993,4.94959115982056 45.052864074707))	0.0006	POINT(4.9746191501618 45.04777069091798)
45936	POLYGON((1.31383895874023 43.9006462097169,1.30638802051544 43.8975067138673,1.29341173171997 43.8972625732422,1.29341173171997 43.8972625732422,1.29358124732971 43.8907546997071,1.30031800270086 43.8864784240723,1.30031800270086 43.8864784240723,1.30078244209284 43.8779792785645,1.30078244209284 43.8779792785645,1.31918776035309 43.8716201782227,1.31918776035309 43.8716201782227,1.34929001331341 43.871925354004,1.34929001331341 43.871925354004,1.35618829727173 43.8760719299316,1.35591530799871 43.8825302124024,1.36518418788921 43.8895721435547,1.36518418788921 43.8895721435547,1.36258542537701 43.8925247192384,1.36258542537701 43.8925247192384,1.35625326633453 43.8975944519044,1.34653413295752 43.8974914550782,1.32592391967785 43.9062690734864,1.31383895874023 43.9006462097169))	0.0006	POINT(1.3289155580781136 43.887435913086)
1403508	POLYGON((2.5826370716095 42.1899948120118,2.58100509643566 42.1915321350098,2.58204007148748 42.1951828002931,2.5805699825288 42.1985473632813,2.58516907691967 42.2008438110352,2.58711099624634 42.2041854858398,2.58697390556335 42.2070198059083,2.58299899101257 42.2089157104493,2.58210611343395 42.2177085876465,2.5786120891571 42.2199859619142,2.58456301689154 42.2270050048829,2.58791995048523 42.229362487793,2.59308910369879 42.2302970886231,2.59901690483105 42.2218627929689,2.6019549369812 42.2233200073243,2.60339093208324 42.2211990356445,2.60611200332642 42.2217102050782,2.60675311088562 42.220314025879,2.6012580394746 42.2184448242189,2.61069989204407 42.2143135070801,2.61034011840832 42.2103958129883,2.6017639636994 42.2046394348146,2.60466694831848 42.1938209533691,2.60238599777222 42.1908721923828,2.59383511543274 42.1894645690919,2.59226894378668 42.1943206787109,2.5826370716095 42.1899948120118))	0.0006	POINT(2.5934323989428467 42.20943304208614)
1390350	POLYGON((-1.25956904888142 41.4015007019043,-1.28712999820709 41.3955268859864,-1.29279398918146 41.3926086425781,-1.29736602306366 41.3874359130861,-1.30686104297638 41.3833427429199,-1.3169230222702 41.3747558593751,-1.33118402957905 41.3754577636719,-1.33480501174915 41.3745727539063,-1.33707094192499 41.37109375,-1.34948003292084 41.3688049316406,-1.35658895969385 41.3851470947267,-1.36355900764465 41.3862266540527,-1.36214995384211 41.3941497802734,-1.3668520450592 41.39990234375,-1.36980795860285 41.3993415832521,-1.37551295757288 41.402717590332,-1.36776101589203 41.4098587036133,-1.3674830198288 41.4128723144531,-1.36533403396606 41.412208557129,-1.35005497932428 41.419792175293,-1.35015499591822 41.4356727600098,-1.34607100486755 41.4462242126465,-1.33676695823664 41.4580421447754,-1.30566203594208 41.4616584777833,-1.30260801315302 41.4607772827149,-1.30168902873993 41.455638885498,-1.29314696788782 41.4494590759278,-1.29077398777008 41.4385375976564,-1.27896904945374 41.4201812744141,-1.26905202865601 41.4141960144044,-1.26200902462 41.4023818969727,-1.25956904888142 41.4015007019043))	0.0006	POINT(-1.3256512957234208 41.409357624669255)
12677	POLYGON((15.4824895858765 41.3326683044434,15.4800748825073 41.33060836792,15.4698886871338 41.3269462585449,15.4565362930298 41.3258857727052,15.4371347427369 41.3228073120117,15.421244621277 41.3191108703613,15.421244621277 41.3191108703613,15.4166736602783 41.3149528503419,15.4166736602783 41.3149528503419,15.42174243927 41.3089408874513,15.4379405975342 41.3021316528321,15.4543523788452 41.286548614502,15.4508104324341 41.2819595336915,15.4472913742066 41.2800559997559,15.4472913742066 41.2800559997559,15.4505758285522 41.2773742675782,15.4534950256349 41.2712326049806,15.4783802032471 41.2685890197754,15.4869432449341 41.2691993713379,15.4931612014772 41.263011932373,15.4931612014772 41.263011932373,15.5091619491577 41.2727813720704,15.5127630233765 41.2709922790528,15.5171489715576 41.2706375122071,15.5169897079468 41.2747802734375,15.5143527984619 41.282730102539,15.5197172164917 41.2861824035645,15.5211095809936 41.2917213439942,15.5313243865967 41.2948303222657,15.5261116027833 41.2988090515138,15.5235013961791 41.3052024841309,15.5240297317505 41.3071670532227,15.5229148864747 41.3141708374025,15.5199241638184 41.3195953369141,15.5195865631104 41.3236961364746,15.5282163619996 41.3271446228027,15.5401172637939 41.3299789428712,15.5610370635986 41.3393173217774,15.5654468536377 41.3392715454102,15.5654468536377 41.3392715454102,15.5651779174806 41.3399391174317,15.5597486495972 41.3397598266601,15.55224609375 41.3370208740235,15.5486946105956 41.3384704589844,15.5430021286011 41.3450813293458,15.5405254364015 41.3445701599122,15.5379209518433 41.3419151306153,15.5357513427735 41.3411712646485,15.5316066741943 41.341609954834,15.5183601379394 41.3394393920898,15.5136642456056 41.339542388916,15.5133113861084 41.3417739868165,15.5069484710694 41.3399658203125,15.5028915405273 41.3376312255861,15.4824895858765 41.3326683044434))	0.0006	POINT(15.500478815149409 41.311394938716205)
17945	POLYGON((7.79830789566051 45.4131546020508,7.81455421447754 45.4171142578125,7.81455421447754 45.4171142578125,7.81186819076544 45.4198417663575,7.80065917968756 45.4266510009766,7.79362392425548 45.4340553283692,7.7947821617127 45.4354095458984,7.7947821617127 45.4354095458984,7.78953599929815 45.4386596679687,7.78953599929815 45.4386596679687,7.78771686553949 45.4357261657715,7.78771686553949 45.4357261657715,7.78925609588623 45.4328269958497,7.78692388534546 45.4266052246095,7.78763914108276 45.4206123352052,7.78927612304699 45.417953491211,7.78927612304699 45.417953491211,7.79830789566051 45.4131546020508))	0.0006	POINT(7.795294649460777 45.427263147690745)
19685	POLYGON((12.6203489303589 43.4175262451172,12.6240196228027 43.413013458252,12.6361722946167 43.4051246643068,12.6539154052735 43.386646270752,12.6531801223754 43.3820037841797,12.6559734344483 43.3803138732911,12.6559734344483 43.3803138732911,12.6866893768311 43.4000091552735,12.6898241043091 43.3945083618165,12.6930150985718 43.39306640625,12.7109441757203 43.3956451416017,12.7360610961914 43.394443511963,12.7451810836793 43.3906784057618,12.7477560043336 43.3914108276368,12.7477560043336 43.3914108276368,12.7584190368653 43.3966407775879,12.7753763198853 43.4029235839845,12.7806100845337 43.4151611328125,12.7756938934326 43.4212341308595,12.7722826004029 43.423984527588,12.7691888809205 43.4248085021973,12.7664985656738 43.4280700683595,12.7657260894776 43.4339790344238,12.767249107361 43.4463424682618,12.7773771286011 43.4514656066896,12.772135734558 43.4582862854004,12.7683868408204 43.4608039855958,12.7683868408204 43.4608039855958,12.758599281311 43.4597053527832,12.7560300827027 43.4602966308595,12.7522153854371 43.4642066955568,12.7355604171753 43.465301513672,12.7331581115723 43.4637145996094,12.7318086624146 43.4611473083497,12.7257518768311 43.4548950195313,12.7234859466553 43.4538841247559,12.7234859466553 43.4538841247559,12.7162094116211 43.4470405578614,12.7162094116211 43.4470405578614,12.7098007202149 43.4256324768067,12.6844882965088 43.4299087524415,12.6828622817993 43.4326629638673,12.679102897644 43.4350242614747,12.6641206741334 43.4377784729004,12.6446466445924 43.4346618652344,12.6382579803467 43.4324493408204,12.6267080307006 43.4219818115236,12.6203489303589 43.4175262451172))	0.0006	POINT(12.716524327054971 43.42599649632237)
24304	POLYGON((4.19629430770868 45.0312805175781,4.18196725845348 45.029354095459,4.16377878189093 45.0340499877931,4.14133977890026 45.0478057861329,4.13516569137585 45.05717086792,4.13516569137585 45.05717086792,4.12368345260626 45.0471839904785,4.12368345260626 45.0471839904785,4.11265373229992 45.0290794372559,4.11867427825933 45.0202674865724,4.11867427825933 45.0202674865724,4.13226175308228 45.0235252380371,4.15239524841309 45.0140609741212,4.15737438201916 45.0080566406251,4.15737438201916 45.0080566406251,4.16632986068731 45.0083694458008,4.16808032989508 45.0022277832032,4.18089437484753 44.9989471435547,4.1885604858399 45.000774383545,4.1885604858399 45.000774383545,4.20409679412853 45.0049667358398,4.20409679412853 45.0049667358398,4.20184087753296 45.0151863098145,4.21063089370728 45.0230216979981,4.19629430770868 45.0312805175781))	0.0006	POINT(4.160982390244869 45.022239526112934)
71681	POLYGON((16.3181648254395 48.1028861999513,16.3096580505372 48.0925407409669,16.3096580505372 48.0925407409669,16.2874794006348 48.0959739685059,16.2847118377686 48.0944442749023,16.2775001525878 48.0870933532716,16.2673988342285 48.0865669250488,16.2673988342285 48.0865669250488,16.2628269195557 48.0972442626954,16.2628269195557 48.0972442626954,16.2581443786622 48.1061630249024,16.2581443786622 48.1061630249024,16.3181648254395 48.1028861999513))	0.0006	POINT(16.28032604853316 48.09545230865485)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point