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
50343	POLYGON((1.74037909507757 49.4056816101074,1.74557363986975 49.4090347290039,1.74557363986975 49.4090347290039,1.75575423240673 49.4101943969727,1.76715433597576 49.42142868042,1.78030800819408 49.426929473877,1.78030800819408 49.426929473877,1.75092136859888 49.4310951232911,1.73991847038275 49.4493026733398,1.73991847038275 49.4493026733398,1.73338913917547 49.4412155151368,1.73338913917547 49.4412155151368,1.72820758819591 49.4411430358887,1.7260781526565 49.4380645751954,1.72200953960419 49.4214897155761,1.71393752098089 49.4092254638672,1.71393752098089 49.4092254638672,1.71757435798651 49.4036979675294,1.73088502883911 49.4069061279297,1.74037909507757 49.4056816101074))	0.0006	POINT(1.7402745924498444 49.42374299701894)
66179	POLYGON((10.9457178115845 50.3864669799806,10.949954032898 50.383472442627,10.9484405517579 50.3817520141602,10.9596815109253 50.3753089904786,10.961787223816 50.3775863647461,10.9633045196534 50.3759155273438,10.962730407715 50.371925354004,10.9566612243653 50.368480682373,10.9590826034547 50.36722946167,10.9616193771363 50.3677253723144,10.9629526138307 50.365894317627,10.9825010299683 50.3517951965333,10.9826440811157 50.3505783081055,10.9857807159424 50.3473205566407,10.9857807159424 50.3473205566407,10.9876308441163 50.3419647216797,10.9848985671998 50.3387832641603,10.9875278472901 50.3347320556641,10.9873352050782 50.3256454467775,10.9913120269776 50.3242073059083,11.0014944076538 50.3235778808594,10.9996852874757 50.3212738037109,11.0002689361573 50.3192901611329,10.9992694854736 50.3178443908692,11.0001478195191 50.3145217895508,11.0023250579835 50.3131523132325,10.9991445541383 50.3113327026368,11.0020189285278 50.309455871582,11.0018510818481 50.3029518127442,11.0009689331055 50.3018836975099,10.9991722106934 50.3020477294922,10.999077796936 50.2997245788575,10.999077796936 50.2997245788575,10.9908084869386 50.2988433837891,10.9936399459839 50.2969398498536,10.9888648986816 50.2956466674805,10.990975379944 50.2932891845703,10.9895944595337 50.2928733825684,10.9899511337281 50.2920341491699,10.9899511337281 50.2920341491699,10.9854698181153 50.2905883789062,10.9721240997316 50.2902755737305,10.9645566940307 50.2919425964357,10.9601192474366 50.2977294921876,10.9601192474366 50.2977294921876,10.9603729248047 50.3006782531739,10.9660091400146 50.3024368286133,10.9661521911621 50.3070068359375,10.9650993347169 50.3084411621095,10.9673290252686 50.3108711242677,10.9652509689332 50.31103515625,10.9656105041504 50.3133087158203,10.9640712738037 50.3138999938966,10.966835975647 50.3192863464355,10.9652862548828 50.3203201293945,10.9657449722291 50.3211975097657,10.9480857849122 50.3292045593262,10.9496240615844 50.3298301696777,10.9482564926147 50.3309593200684,10.9498538970947 50.3318977355957,10.9488077163697 50.3327026367189,10.9543247222901 50.336280822754,10.9520540237427 50.3399696350098,10.9466447830201 50.3417701721193,10.9436502456666 50.3447608947754,10.9417572021486 50.3452911376954,10.9409103393555 50.3464736938477,10.9413852691651 50.3476943969727,10.9348363876344 50.3496093750001,10.9330615997314 50.3523330688478,10.9305238723755 50.3531608581544,10.9312829971315 50.3546600341796,10.9283542633057 50.3557891845704,10.9256324768068 50.3596572875977,10.9254264831544 50.361801147461,10.9262523651124 50.3629035949708,10.9235906600953 50.3687171936035,10.9149627685547 50.3698654174806,10.9146032333375 50.3705596923829,10.9162406921387 50.3712196350098,10.9144906997682 50.3737716674805,10.9162731170655 50.3749084472656,10.9141616821289 50.3795585632324,10.9112958908082 50.3800888061523,10.904839515686 50.3787345886232,10.8990669250489 50.3815612792969,10.9100732803345 50.386688232422,10.9100732803345 50.386688232422,10.9119186401368 50.3852615356446,10.9190149307252 50.3889045715332,10.9328260421753 50.3924255371093,10.9376344680787 50.3919067382812,10.9429979324342 50.3873138427734,10.9457178115845 50.3864669799806))	0.0006	POINT(10.959145925378339 50.339292669809005)
26060	POLYGON((2.00434970855707 48.7208213806153,1.98868012428289 48.7290000915528,1.98868012428289 48.7290000915528,1.97153007984156 48.7209472656251,1.97153007984156 48.7209472656251,1.97086274623882 48.7175598144532,1.99303662776953 48.7089614868165,1.99936890602118 48.6998023986816,2.0195200443269 48.6969833374023,2.0195200443269 48.6969833374023,2.02082085609436 48.6964530944825,2.02082085609436 48.6964530944825,2.02342605590826 48.7031936645508,2.00290107727051 48.7140998840332,2.00434970855707 48.7208213806153))	0.0006	POINT(1.9996462379183424 48.710800443376854)
47693	POLYGON((2.04350686073309 50.3468208312989,2.05858540534973 50.3591537475587,2.06109642982483 50.3652534484863,2.06109642982483 50.3652534484863,2.04128289222723 50.3678932189943,2.02903652191168 50.3579750061036,2.02903652191168 50.3579750061036,2.03684186935419 50.3460845947266,2.03684186935419 50.3460845947266,2.04350686073309 50.3468208312989))	0.0006	POINT(2.0441472000546055 50.3569437662761)
15319	POLYGON((9.67784595489513 45.647445678711,9.6752347946167 45.6469383239747,9.67141628265392 45.6430282592774,9.66820430755627 45.6362686157227,9.6689338684082 45.6307106018067,9.6689338684082 45.6307106018067,9.64580535888672 45.6285934448243,9.64580535888672 45.6285934448243,9.64331912994385 45.6333084106446,9.63547706603998 45.6409759521486,9.63287258148199 45.6422309875489,9.63068962097168 45.6420974731446,9.63068962097168 45.6420974731446,9.6324510574342 45.6526184082032,9.6324510574342 45.6526184082032,9.63493824005138 45.6591415405273,9.63493824005138 45.6591415405273,9.63859367370617 45.6612815856935,9.64279460906982 45.6660118103028,9.65978240966803 45.6565513610841,9.65978240966803 45.6565513610841,9.67784595489513 45.647445678711))	0.0006	POINT(9.649093310038298 45.64556739443832)
39131	POLYGON((4.12704515457159 44.1197776794435,4.11424350738537 44.1341094970704,4.11494112014776 44.1409988403321,4.10408878326422 44.1466712951661,4.09919834136957 44.1562614440918,4.09919834136957 44.1562614440918,4.11035490036022 44.1634674072266,4.11035490036022 44.1634674072266,4.11762666702282 44.1682662963868,4.11762666702282 44.1682662963868,4.12537479400635 44.1641883850098,4.12537479400635 44.1641883850098,4.13100671768188 44.158763885498,4.14027166366577 44.1593627929689,4.15567445755005 44.1426391601562,4.15567445755005 44.1426391601562,4.1600914001466 44.1367225646973,4.14857816696167 44.1187057495118,4.14857816696167 44.1187057495118,4.14241600036615 44.1142349243164,4.13867664337164 44.1159362792969,4.13867664337164 44.1159362792969,4.12704515457159 44.1197776794435))	0.0006	POINT(4.128412376750635 44.14407140558421)
12544	MULTIPOLYGON(((13.8556098937988 42.3998146057129,13.8498945236207 42.4001502990722,13.8383998870851 42.3968124389648,13.8312864303588 42.4011306762696,13.8248357772828 42.4087791442871,13.8248357772828 42.4087791442871,13.8239583969116 42.4004783630372,13.8207311630249 42.3951072692872,13.8166112899781 42.3847961425781,13.8157768249512 42.3780975341798,13.8101882934571 42.3734931945801,13.8101882934571 42.3734931945801,13.8137159347535 42.3692588806152,13.8137159347535 42.3692588806152,13.8257169723512 42.3811645507814,13.8412132263185 42.383228302002,13.8529615402222 42.3744430541993,13.8530979156495 42.3677139282227,13.8572082519531 42.3632888793945,13.8650598526001 42.3656082153321,13.863624572754 42.3690681457519,13.8681144714357 42.3720512390137,13.8763360977173 42.3754806518555,13.8795785903931 42.3754425048829,13.8802156448364 42.3785362243653,13.8781633377076 42.3847503662111,13.8758516311646 42.3875885009766,13.8696432113648 42.391788482666,13.8613252639771 42.394172668457,13.8556098937988 42.3998146057129)),((13.8366079330444 42.3649101257324,13.8358697891235 42.3745880126954,13.8304586410522 42.3742637634277,13.8302974700928 42.3662147521973,13.8302974700928 42.3662147521973,13.8366079330444 42.3649101257324)))	0.0006	POINT(13.844307169938071 42.38304688861102)
50156	POLYGON((3.84854626655579 49.881103515625,3.83898520469671 49.8965873718263,3.83770179748547 49.9065132141114,3.83770179748547 49.9065132141114,3.84566402435297 49.9110412597656,3.8669481277467 49.9110336303711,3.8669481277467 49.9110336303711,3.87141942977917 49.9048500061035,3.87041449546825 49.890796661377,3.87700581550598 49.8851356506349,3.87700581550598 49.8851356506349,3.87537312507635 49.8847961425782,3.87537312507635 49.8847961425782,3.84854626655579 49.881103515625))	0.0006	POINT(3.8606990117293765 49.8968720069299)
48852	POLYGON((0.233463346958274 47.9444961547853,0.21976821124565 47.9413833618165,0.217097595334167 47.9353218078613,0.221107915043888 47.9296264648439,0.216921031475124 47.9279594421387,0.216921031475124 47.9279594421387,0.21955797076231 47.9223861694337,0.21955797076231 47.9223861694337,0.225698217749652 47.9179458618165,0.232845902442989 47.8957099914551,0.237689092755431 47.8952751159668,0.237689092755431 47.8952751159668,0.249506905674991 47.8940925598145,0.249506905674991 47.8940925598145,0.262255966663417 47.8997688293458,0.272060543298778 47.9111900329591,0.268653482198715 47.9279403686523,0.268653482198715 47.9279403686523,0.242912277579308 47.9370193481446,0.233463346958274 47.9444961547853))	0.0006	POINT(0.2374666811604876 47.918303640265265)
66814	POLYGON((9.74501514434826 49.1951599121095,9.7487297058106 49.1995239257814,9.74882316589367 49.2033958435059,9.7506732940675 49.203540802002,9.75139045715338 49.2060050964355,9.75078868865972 49.2078132629396,9.75411128997803 49.2113876342773,9.74878787994385 49.2119636535645,9.74742507934576 49.2183418273927,9.74854469299328 49.2187995910645,9.74792480468761 49.2206726074219,9.74570655822765 49.2220077514649,9.73299694061279 49.2241096496582,9.73334503173828 49.2272491455078,9.74368000030529 49.2259902954102,9.74601459503174 49.2233848571778,9.74845600128185 49.2244720458985,9.7524089813233 49.2237434387207,9.75631713867199 49.2250022888185,9.76498889923101 49.2246284484864,9.76562786102295 49.2268524169922,9.76283454895025 49.2353096008302,9.76439762115473 49.2417869567872,9.76249885559093 49.2437362670899,9.75832271575933 49.2446250915528,9.75767421722406 49.2456474304199,9.75767421722406 49.2456474304199,9.76621341705328 49.2488517761232,9.77073955535883 49.2439422607422,9.77520942687994 49.2500610351564,9.77853584289545 49.2508735656739,9.78050422668457 49.2534141540528,9.78197956085211 49.2521553039551,9.78821277618408 49.2553443908693,9.79121208190912 49.2551040649414,9.80745697021496 49.257911682129,9.81212043762207 49.2575874328614,9.81514263153088 49.2586975097656,9.81514263153088 49.2586975097656,9.8160285949707 49.2572250366211,9.82057762146007 49.2582244873047,9.8213472366333 49.2572212219239,9.81752300262451 49.2545890808105,9.82053947448742 49.2521972656251,9.81687068939209 49.252140045166,9.81569480895996 49.2497940063477,9.81853199005127 49.2483444213868,9.81707096099854 49.247688293457,9.81869983673096 49.2413749694825,9.82529163360607 49.2376708984376,9.8262510299682 49.2338829040528,9.82937431335444 49.2325248718262,9.83008098602295 49.2310905456544,9.82709026336676 49.2278785705568,9.82997417449957 49.2220039367676,9.83430099487305 49.219913482666,9.83593177795422 49.2172088623047,9.83866310119629 49.2192840576172,9.84056854248053 49.2175483703614,9.84056854248053 49.2175483703614,9.83738517761225 49.2163619995117,9.83921813964849 49.2118759155274,9.83737087249767 49.2103881835939,9.83076477050781 49.2096023559571,9.82799911499023 49.2080039978028,9.82939338684088 49.2035140991212,9.82370758056641 49.1998023986818,9.82503700256359 49.1979637145996,9.82340621948237 49.1958427429199,9.82299709320074 49.190773010254,9.82469558715832 49.1860961914063,9.82215404510504 49.1853370666505,9.82199382781994 49.1821250915527,9.82368278503418 49.1802368164063,9.82368278503418 49.1802368164063,9.82296276092541 49.1785469055176,9.81593132019049 49.1780738830568,9.81585121154791 49.1749610900879,9.80838584899897 49.1770133972168,9.80797004699707 49.1763458251953,9.81030750274658 49.1683158874512,9.80751895904541 49.1676712036134,9.80458545684814 49.1646575927734,9.80440902709967 49.1616973876954,9.80677032470703 49.1605682373047,9.80335426330566 49.1606369018556,9.80273151397711 49.1581420898439,9.81049060821533 49.1583862304688,9.80906772613525 49.1562728881835,9.80906772613525 49.1562728881835,9.80605220794683 49.1542320251466,9.80604171752924 49.149211883545,9.80395603179937 49.1474189758301,9.80653953552246 49.147029876709,9.8064231872558 49.1456260681153,9.79967975616461 49.1434974670411,9.79566764831543 49.1431999206542,9.79427528381353 49.1446418762208,9.7871294021607 49.1438484191895,9.78256797790533 49.144458770752,9.78013420104992 49.148609161377,9.78059768676763 49.1506538391113,9.78059768676763 49.1506538391113,9.78280162811279 49.1545867919922,9.78644943237305 49.1536598205568,9.78628158569336 49.157569885254,9.78888988494873 49.1602058410645,9.78831481933599 49.162925720215,9.77932929992676 49.1603050231934,9.77790832519526 49.1681327819825,9.76985740661615 49.1707420349122,9.76594161987316 49.1738624572755,9.76648712158203 49.1768074035645,9.76494979858404 49.1777343750001,9.7606201171875 49.1773185729982,9.75943470001226 49.1794891357423,9.74770164489757 49.1804161071777,9.73640155792248 49.1835060119629,9.7375755310058 49.1865119934082,9.74052715301519 49.1881675720216,9.74399375915533 49.1885147094727,9.74393463134777 49.1896324157715,9.74558925628668 49.1900482177734,9.74377727508551 49.1918144226075,9.74612712860102 49.1942253112794,9.74501514434826 49.1951599121095))	0.0006	POINT(9.790112449646031 49.20219018554689)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point