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
67414	POLYGON((9.43456554412847 48.6684570312501,9.43327522277843 48.6691017150879,9.43174934387218 48.6674957275391,9.42184066772467 48.6722640991212,9.42184066772467 48.6722640991212,9.42229652404785 48.6731224060059,9.41837692260748 48.6728973388673,9.41804695129389 48.6761589050293,9.41568565368652 48.6760787963868,9.41558361053461 48.6782112121582,9.41322994232178 48.6784324645996,9.41430187225342 48.6802673339844,9.41304302215582 48.6813087463379,9.4096822738648 48.6803359985353,9.40849590301525 48.6822586059571,9.40660476684582 48.6819458007812,9.40611362457281 48.683032989502,9.40491104125988 48.6828193664551,9.4039163589477 48.6855354309083,9.39794540405273 48.6840705871583,9.39746189117432 48.6856498718262,9.39063167572027 48.6849327087402,9.38920116424566 48.6881217956543,9.39017486572266 48.6889152526855,9.39017486572266 48.6889152526855,9.39201736450195 48.6879158020019,9.39431095123297 48.6886138916016,9.39326477050781 48.6892242431641,9.39428806304937 48.6902046203613,9.39028072357189 48.6902275085449,9.38949966430664 48.6917037963867,9.39268302917486 48.692699432373,9.39166545867926 48.6944160461426,9.39680290222168 48.6961288452149,9.39442157745373 48.6999015808107,9.3965215682984 48.7007331848145,9.3965215682984 48.7007331848145,9.4023227691651 48.7040519714356,9.40514087676996 48.7047386169434,9.40772533416759 48.7036056518556,9.40883255004888 48.7043342590332,9.40866565704351 48.7069511413575,9.41257286071789 48.7084350585938,9.41257286071789 48.7084350585938,9.41605281829845 48.7077789306641,9.43279552459717 48.6990547180176,9.44767761230474 48.7000770568849,9.44767761230474 48.7000770568849,9.44697093963629 48.6975708007812,9.44161128997814 48.6941642761232,9.44353675842291 48.6943283081055,9.44305801391613 48.6919746398926,9.44517993927013 48.6899528503419,9.44406414031982 48.6894226074219,9.44657421112066 48.6864128112793,9.44838714599609 48.6867294311523,9.45077037811285 48.6845550537111,9.45077037811285 48.6845550537111,9.44999885559088 48.6838111877442,9.44422721862804 48.6837921142579,9.44555377960216 48.6827087402344,9.44305324554449 48.6821899414063,9.44364643096935 48.6811065673829,9.43971443176275 48.6801795959473,9.43948936462414 48.6793670654297,9.44105243682861 48.678882598877,9.43818664550793 48.6754989624024,9.43950176239014 48.6743850708008,9.43846511840832 48.6733131408692,9.43648624420177 48.6747550964355,9.43851661682129 48.6716156005859,9.43613243103027 48.6707038879396,9.43456554412847 48.6684570312501))	0.0006	POINT(9.419839051034767 48.686730702718116)
28319	POLYGON((4.88416910171509 47.1550254821777,4.87880039215094 47.164234161377,4.87880039215094 47.164234161377,4.87687015533447 47.1721115112305,4.87687015533447 47.1721115112305,4.8709659576416 47.17435836792,4.8709659576416 47.17435836792,4.86280679702759 47.1706161499024,4.86280679702759 47.1706161499024,4.86673307418823 47.1650238037109,4.85324573516857 47.1652412414552,4.85107851028442 47.1625022888184,4.85107851028442 47.1625022888184,4.86462593078625 47.1545143127442,4.86462593078625 47.1545143127442,4.87204551696777 47.1507186889648,4.88416910171509 47.1550254821777))	0.0006	POINT(4.8679055571556376 47.16454267501834)
44580	POLYGON((0.560631453990936 42.8065414428711,0.560721814632416 42.807300567627,0.560721814632416 42.807300567627,0.555889368057251 42.8202323913575,0.555889368057251 42.8202323913575,0.543668031692448 42.8237152099609,0.532136559486389 42.8333625793457,0.532136559486389 42.8333625793457,0.523911476135254 42.8361968994141,0.523911476135254 42.8361968994141,0.522892951965389 42.8337097167969,0.522892951965389 42.8337097167969,0.532126545906181 42.8186378479004,0.542174041271323 42.8122291564942,0.542174041271323 42.8122291564942,0.560631453990936 42.8065414428711))	0.0006	POINT(0.5407918969790407 42.822330474853544)
1402596	POLYGON((-5.39652109146112 41.9324455261232,-5.39282178878778 41.9302635192872,-5.39343118667603 41.927864074707,-5.39069604873657 41.9269485473633,-5.39053201675409 41.923225402832,-5.39287900924683 41.922119140625,-5.3935289382934 41.9178924560547,-5.386314868927 41.9074707031251,-5.3890500068664 41.8996849060059,-5.40180206298822 41.8912506103516,-5.41301679611206 41.8888740539551,-5.4409031867981 41.8995056152344,-5.44677400588989 41.908073425293,-5.44507789611811 41.9116363525391,-5.44714307785034 41.9142494201661,-5.44487810134888 41.9152450561523,-5.42141580581659 41.9127426147461,-5.40878486633301 41.9183120727539,-5.40904998779291 41.9211883544922,-5.40469884872431 41.9225044250489,-5.40274095535278 41.9269027709961,-5.39892578125 41.9284248352052,-5.39652109146112 41.9324455261232))	0.0006	POINT(-5.409590287642019 41.91576472195715)
62651	POLYGON((8.92070770263683 52.6780509948732,8.9206361770631 52.6811141967773,8.92366504669195 52.6855049133302,8.9267110824585 52.6878509521485,8.92783927917486 52.6873359680176,8.92706394195551 52.6862182617188,8.93164253234875 52.6848144531251,8.9316978454591 52.6832504272462,8.93331146240246 52.6827926635742,8.94236278533947 52.6838073730469,8.94252204895031 52.6826324462891,8.9461812973023 52.6825370788574,8.94652175903326 52.6791152954103,8.95687484741222 52.6779975891114,8.96368789672857 52.6786842346191,8.96868324279779 52.6766891479492,8.96856880187994 52.6817512512207,8.97007465362543 52.6853141784669,8.96637248992931 52.68754196167,8.96752357482904 52.6892890930177,8.97490024566662 52.6913642883301,8.97418117523193 52.6924972534179,8.97634696960461 52.6932182312012,8.97554588317877 52.694995880127,8.98375797271729 52.6957435607911,8.98375797271729 52.6957435607911,8.9892578125 52.7023200988769,8.98534774780273 52.7079200744629,8.98249912261969 52.7081260681153,8.98093414306646 52.7127876281739,8.978014945984 52.7142372131348,8.97688102722174 52.7136573791504,8.97510814666754 52.7156410217286,8.97119903564459 52.7160835266113,8.966875076294 52.7142066955566,8.95930290222168 52.7126502990723,8.95932102203369 52.7145805358887,8.95662975311291 52.7150955200196,8.95666599273682 52.716495513916,8.95944690704346 52.7166328430176,8.95883464813232 52.718563079834,8.95402526855474 52.7218666076661,8.95132923126226 52.7214546203613,8.94892692565912 52.7185478210449,8.94892692565912 52.7185478210449,8.94479846954351 52.7139282226563,8.93880939483637 52.7156372070312,8.93426895141602 52.7150192260742,8.93489551544195 52.7140502929687,8.92756748199469 52.7068214416504,8.92939567565924 52.704948425293,8.92225074768072 52.70267868042,8.92236518859863 52.6973304748536,8.92401504516607 52.69588470459,8.92311668396002 52.6932373046876,8.92449855804455 52.6918258666993,8.91760826110851 52.6865997314453,8.92083454132091 52.6853637695313,8.9194393157959 52.6835784912109,8.91582870483404 52.6849136352539,8.91238975524908 52.6822776794435,8.91238975524908 52.6822776794435,8.91720485687262 52.6766815185547,8.91935157775885 52.6783294677736,8.92070770263683 52.6780509948732))	0.0006	POINT(8.947995215654421 52.69713521003725)
66375	MULTIPOLYGON(((9.78208827972406 50.3423309326172,9.78838634490972 50.3423957824707,9.78838634490972 50.3423957824707,9.79739093780523 50.3467369079589,9.7994146347047 50.3496360778809,9.79644680023193 50.3531303405762,9.80068397521973 50.3607025146486,9.79437541961681 50.3640213012695,9.79046154022222 50.3698539733887,9.79228878021246 50.3708801269531,9.79228878021246 50.3708801269531,9.78852081298834 50.3716125488282,9.78938770294195 50.3691902160646,9.78487873077404 50.3668670654296,9.77854251861572 50.3663711547852,9.77854824066168 50.3650360107422,9.77352237701427 50.3625602722169,9.77507019042969 50.3589057922364,9.77487277984631 50.3571128845215,9.77339649200445 50.3561782836913,9.76916313171387 50.357032775879,9.76988410949713 50.3558959960938,9.76824474334728 50.3536987304687,9.76269054412853 50.3536262512207,9.76204586029064 50.3525886535645,9.7647438049317 50.3509330749511,9.76314449310308 50.3497772216797,9.76387023925781 50.349235534668,9.77886486053472 50.3425636291504,9.78208827972406 50.3423309326172)),((9.77875709533691 50.3468360900879,9.7812299728393 50.3488502502441,9.77338123321539 50.3452911376954,9.77422046661371 50.3447113037111,9.77875709533691 50.3468360900879)))	0.0006	POINT(9.780710441464054 50.35687609196606)
55407	POLYGON((6.05198240280157 46.0841522216797,6.05372285842901 46.0802841186523,6.05372285842901 46.0802841186523,6.06333827972406 46.079013824463,6.06499719619762 46.0723114013672,6.06359148025518 46.0654449462891,6.05112314224249 46.0507392883301,6.05112314224249 46.0507392883301,6.07745504379272 46.0564002990723,6.08374261856079 46.0614128112794,6.08374261856079 46.0614128112794,6.08063077926641 46.0714797973634,6.08372592926031 46.07426071167,6.09366035461431 46.0747756958008,6.09366035461431 46.0747756958008,6.09304141998297 46.078037261963,6.07579994201654 46.08256149292,6.07026147842413 46.087272644043,6.05198240280157 46.0841522216797))	0.0006	POINT(6.071628994411928 46.07140880160866)
31436	POLYGON((2.86431646347052 47.2834968566896,2.86499762535101 47.2703895568848,2.87010335922247 47.2648124694825,2.86786866188061 47.2484817504884,2.86786866188061 47.2484817504884,2.88112235069286 47.2517013549805,2.88698220253002 47.256736755371,2.90083074569702 47.2546730041504,2.90083074569702 47.2546730041504,2.91468715667719 47.2551612854004,2.92781805992121 47.2645225524902,2.92781805992121 47.2645225524902,2.92342710495006 47.2739448547364,2.90343642234814 47.283561706543,2.89072823524481 47.2938499450684,2.89072823524481 47.2938499450684,2.87681317329412 47.2916564941406,2.87326765060425 47.285800933838,2.86431646347052 47.2834968566896))	0.0006	POINT(2.8907580508126633 47.268906487358976)
1398600	POLYGON((-5.31572818756098 40.1070404052734,-5.33586597442627 40.1158218383788,-5.33691883087158 40.1242408752442,-5.34190607070911 40.1259956359864,-5.34584712982178 40.1296539306641,-5.3457670211792 40.1334762573243,-5.3567271232605 40.148380279541,-5.35705804824823 40.1528472900391,-5.36007785797113 40.1543159484863,-5.3600640296936 40.1569061279297,-5.36686706542969 40.1604499816895,-5.36788606643671 40.1641120910646,-5.36465215682978 40.1744575500489,-5.36455917358398 40.1819267272949,-5.36644601821899 40.1834831237793,-5.36636590957642 40.1960449218751,-5.36814117431635 40.1991310119629,-5.36400890350336 40.2032775878907,-5.3694019317627 40.2110252380372,-5.36956119537354 40.2183189392091,-5.36261415481562 40.2230110168458,-5.35816812515259 40.2282524108886,-5.35827302932739 40.2319526672364,-5.34310007095337 40.2640571594239,-5.33903217315674 40.2623672485352,-5.32323312759399 40.2607498168946,-5.31557321548456 40.2640342712403,-5.30802679061878 40.2589340209961,-5.29970979690552 40.2564239501953,-5.29807376861567 40.2469291687013,-5.29349088668823 40.2431373596191,-5.28303623199463 40.2416877746583,-5.27375316619873 40.2484169006349,-5.26991081237793 40.2491950988771,-5.26901721954346 40.2516555786133,-5.25633811950678 40.2507858276368,-5.24615478515625 40.2450218200685,-5.24095010757446 40.2482910156251,-5.19054698944086 40.1767044067383,-5.19396686553955 40.1731834411621,-5.18831777572626 40.1650619506836,-5.19382381439209 40.1563186645508,-5.19248104095459 40.1415557861329,-5.19421386718744 40.1377639770508,-5.19371223449707 40.1309814453126,-5.19107294082642 40.1200675964357,-5.17946290969849 40.0978546142579,-5.18178987503052 40.0877151489258,-5.18496704101551 40.0879859924317,-5.1921648979187 40.0835266113282,-5.2020058631897 40.0828552246094,-5.20663499832153 40.0856285095215,-5.20760583877558 40.0895576477052,-5.21161317825317 40.0926589965821,-5.21030902862549 40.1053237915038,-5.2128272056579 40.1069450378417,-5.24924278259277 40.1087341308595,-5.26061916351318 40.1079483032228,-5.26708221435547 40.1110916137695,-5.27063798904419 40.1097145080567,-5.29673099517817 40.1101112365723,-5.30149888992304 40.1074218749999,-5.31572818756098 40.1070404052734))	0.0006	POINT(-5.286058610485424 40.16923418352685)
72750	POLYGON((14.811821937561 47.2270011901856,14.7887096405029 47.2298164367676,14.7813224792482 47.231517791748,14.7748908996581 47.2355728149413,14.7534589767457 47.2523651123047,14.7534589767457 47.2523651123047,14.760579109192 47.2961006164552,14.7792434692383 47.3312377929688,14.7792434692383 47.3312377929688,14.7904844284059 47.3335876464845,14.7982416152955 47.3338737487794,14.8079328536988 47.3315887451172,14.8140916824341 47.3274879455567,14.816635131836 47.3241996765137,14.8174076080322 47.3205795288087,14.8170080184937 47.3173637390137,14.8152894973756 47.3140144348146,14.8155431747438 47.3115310668945,14.8174686431885 47.3066825866699,14.8222723007202 47.3003997802736,14.8237991333007 47.2920036315919,14.8265199661255 47.289119720459,14.837794303894 47.2824592590332,14.842824935913 47.2777862548828,14.8492059707641 47.2689056396486,14.854133605957 47.2598915100097,14.854133605957 47.2598915100097,14.8477058410646 47.2604866027832,14.8432331085206 47.2623291015625,14.8273534774781 47.2810363769532,14.8243045806885 47.2827835083008,14.8214616775513 47.2820358276368,14.8156843185424 47.2746810913086,14.8047189712526 47.2639503479004,14.8030319213867 47.2604522705079,14.8055992126464 47.2544670104981,14.8160114288331 47.2440605163574,14.8200836181641 47.2366600036621,14.8188743591309 47.2322425842285,14.811821937561 47.2270011901856))	0.0006	POINT(14.811578921782694 47.281378623766805)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point