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
32737	POLYGON((1.16610336303722 47.9662704467773,1.18032491207128 47.9662590026856,1.1914963722229 47.9719657897949,1.1914963722229 47.9719657897949,1.20000255107891 47.975700378418,1.2004766464234 47.9791069030763,1.19355273246765 47.9840087890624,1.18772947788244 48.0005989074708,1.17414486408234 48.0052108764648,1.17414486408234 48.0052108764648,1.16956007480633 48.006690979004,1.16956007480633 48.006690979004,1.15684795379644 48.0057983398438,1.15684795379644 48.0057983398438,1.14570879936218 47.9906349182129,1.15343546867365 47.9817085266114,1.17139673233032 47.9752388000489,1.16610336303722 47.9662704467773))	0.0006	POINT(1.1754605419495923 47.9881681554458)
34923	POLYGON((3.80201196670532 49.2068367004395,3.78739309310924 49.2046852111816,3.78739309310924 49.2046852111816,3.78674173355108 49.2105789184571,3.78674173355108 49.2105789184571,3.81016278266918 49.219108581543,3.82114052772528 49.2310523986817,3.82114052772528 49.2310523986817,3.82664418220514 49.2335433959961,3.82664418220514 49.2335433959961,3.8272078037262 49.2232971191407,3.83630752563477 49.2147560119629,3.83630752563477 49.2147560119629,3.80201196670532 49.2068367004395))	0.0006	POINT(3.811987436734748 49.218344174898604)
1397856	POLYGON((-4.21025800704956 39.9809761047364,-4.20723581314087 39.9730453491212,-4.21010303497314 39.9649963378906,-4.21781778335571 39.9654922485353,-4.21087408065796 39.9561309814454,-4.2247757911681 39.9545783996582,-4.24229192733759 39.9579811096191,-4.24801015853876 39.9671707153321,-4.24872589111322 39.9718017578126,-4.25907278060907 39.9773216247559,-4.26135015487665 39.9800796508789,-4.26615381240839 39.9917411804199,-4.26249217987061 39.9964447021484,-4.26444292068481 39.9974136352539,-4.24272918701166 40.0053367614746,-4.2301459312439 40.005973815918,-4.22517776489252 39.9987373352051,-4.21405076980591 39.9915847778321,-4.21025800704956 39.9809761047364))	0.0006	POINT(-4.235872666041024 39.97982258266877)
64629	POLYGON((12.1986656188965 49.8163833618165,12.1907386779786 49.8171768188477,12.1843013763428 49.8211708068848,12.1853713989257 49.8227310180664,12.1906929016114 49.8217582702637,12.1939516067505 49.8226547241212,12.1936750411987 49.8246650695802,12.1879205703735 49.8291091918946,12.1911840438843 49.8324432373047,12.1936950683594 49.8334312438966,12.1884469985961 49.8352928161622,12.1863660812379 49.8378334045411,12.1820850372315 49.8387336730958,12.1809015274048 49.841091156006,12.1820936203003 49.8413352966309,12.181941986084 49.8421821594239,12.178547859192 49.8426094055177,12.1810035705567 49.8431663513185,12.1792535781861 49.8436622619629,12.1798276901246 49.8461456298829,12.1749591827393 49.8469924926758,12.1764135360718 49.8523139953614,12.1751680374147 49.8529205322266,12.1746101379395 49.8556098937988,12.1693506240846 49.855712890625,12.1693506240846 49.855712890625,12.1703653335571 49.8639869689941,12.1703653335571 49.8639869689941,12.1717424392701 49.864730834961,12.1799345016479 49.8649063110352,12.180015563965 49.866024017334,12.181435585022 49.8660278320312,12.1827707290649 49.8640098571777,12.1860008239747 49.8647994995118,12.1841201782227 49.8663406372071,12.1819858551025 49.8666152954102,12.1820898056031 49.8675842285156,12.1833000183106 49.8679542541505,12.1824874877931 49.8697738647462,12.1836471557617 49.8702697753907,12.1801805496216 49.8702850341797,12.1792039871215 49.8718223571777,12.1826734542847 49.8714981079103,12.183629989624 49.8717536926271,12.1840419769287 49.8735771179199,12.1885786056519 49.8734817504883,12.1894330978395 49.8744125366211,12.1878938674927 49.8749847412109,12.1882591247559 49.8758697509767,12.1905937194825 49.8749465942384,12.1917390823365 49.8765945434571,12.2005500793457 49.8760948181153,12.2017488479614 49.8749580383301,12.2041997909547 49.8753547668458,12.2065238952637 49.8768692016601,12.2068490982056 49.8785629272462,12.2178001403809 49.881404876709,12.2183742523193 49.8803253173828,12.2212390899659 49.8802108764649,12.2216596603395 49.8810577392578,12.2193613052368 49.8818130493165,12.2189769744874 49.8831329345704,12.2287817001344 49.8819847106934,12.2329397201539 49.8852424621583,12.23002243042 49.8858375549317,12.2319841384889 49.8873100280762,12.2339820861816 49.8863258361816,12.234127998352 49.884593963623,12.2374277114869 49.8853263854982,12.2457742691041 49.8851051330568,12.2471036911011 49.8843116760254,12.2512760162354 49.8865547180176,12.2512760162354 49.8865547180176,12.2513151168823 49.8849792480469,12.2541513442994 49.8852157592775,12.2529125213623 49.8878784179689,12.2548828125001 49.8884162902832,12.2530727386475 49.8899459838868,12.2535820007324 49.8912887573243,12.2577066421509 49.892276763916,12.2594470977783 49.891025543213,12.2638473510743 49.8904991149902,12.2638473510743 49.8904991149902,12.2650089263916 49.8895378112794,12.2631072998047 49.8878288269042,12.2634649276734 49.8869590759278,12.2650842666627 49.8874397277833,12.2667789459229 49.8895454406738,12.2684879302979 49.8875579833984,12.2619819641113 49.8852920532227,12.2628469467163 49.8845748901368,12.2644729614259 49.8852157592775,12.263505935669 49.8835678100586,12.2659301757812 49.8835945129396,12.2654275894166 49.8820419311523,12.2630128860474 49.880786895752,12.2685613632202 49.8805541992188,12.2694101333619 49.8760528564454,12.2730026245118 49.8760414123535,12.2743797302246 49.8734016418457,12.2785673141479 49.8695831298829,12.2704105377198 49.8703918457031,12.2702550888062 49.8688278198243,12.2721872329711 49.862289428711,12.2810440063477 49.8619804382325,12.2793922424317 49.8614883422852,12.2803611755372 49.8605461120607,12.2796421051025 49.8581161499025,12.2838239669801 49.8590049743653,12.2801713943482 49.8562660217286,12.2774438858033 49.8559112548828,12.2820892333984 49.8532028198243,12.2807846069336 49.8521957397462,12.282982826233 49.8518028259277,12.2801761627198 49.8508186340333,12.2807016372681 49.8496246337891,12.2775974273682 49.8496017456055,12.2794399261475 49.8489952087403,12.2772970199585 49.8475074768067,12.2742338180543 49.8474731445314,12.2741384506226 49.8490257263184,12.2703084945679 49.8485984802246,12.2709207534791 49.8508300781251,12.2682619094848 49.8504295349122,12.2695760726929 49.8487167358399,12.2682085037232 49.84672164917,12.2663383483886 49.8466262817383,12.2665281295776 49.8483505249024,12.2640457153321 49.8497123718262,12.2625818252564 49.8488960266114,12.2584600448608 49.8499603271486,12.2585554122925 49.8475646972657,12.257441520691 49.8453178405762,12.2565555572509 49.8452606201172,12.2565841674805 49.8440475463868,12.2580308914185 49.8433341979982,12.2595281600953 49.8450012207032,12.2609252929688 49.8449325561524,12.2616710662842 49.8446006774902,12.2612237930298 49.8430442810059,12.2639217376709 49.8433380126953,12.2643938064576 49.8441390991212,12.2658033370972 49.8425559997559,12.2591209411621 49.8408660888672,12.2514333724976 49.8402519226075,12.2509489059449 49.8395271301271,12.2519454956054 49.8390922546387,12.2504072189332 49.8378982543946,12.2505302429199 49.8353576660157,12.2483873367311 49.8338165283203,12.2483873367311 49.8338165283203,12.2360973358154 49.8318977355958,12.2355136871338 49.8310737609864,12.237442970276 49.829387664795,12.2366847991943 49.8276634216309,12.2293167114258 49.8266677856446,12.2277345657349 49.825569152832,12.228307723999 49.824863433838,12.221121788025 49.8237838745118,12.2181396484376 49.82084274292,12.2143335342408 49.8231048583984,12.2114210128784 49.8218612670899,12.2092914581299 49.8164062499999,12.2059535980225 49.8171653747559,12.2043924331666 49.8166847229003,12.2034397125245 49.8143920898438,12.2019586563111 49.8151473999024,12.2017154693604 49.8161125183105,12.2037687301636 49.8179092407228,12.2031946182251 49.8184661865236,12.2039251327515 49.8194694519044,12.2036752700807 49.8203582763673,12.2018823623658 49.8203849792481,12.19983959198 49.8188858032226,12.1986656188965 49.8163833618165))	0.0006	POINT(12.229719134582897 49.856525179983564)
28065	POLYGON((4.6181983947755 47.0934219360353,4.61744070053106 47.1143150329591,4.61744070053106 47.1143150329591,4.60779714584345 47.113826751709,4.60779714584345 47.113826751709,4.59406375885015 47.1133346557617,4.59406375885015 47.1133346557617,4.58991336822521 47.1072235107422,4.59068298339855 47.0971069335938,4.59929990768433 47.0937461853028,4.59929990768433 47.0937461853028,4.61401319503796 47.091480255127,4.6181983947755 47.0934219360353))	0.0006	POINT(4.604167580604599 47.104973157246945)
20347	POLYGON((11.6975660324097 45.6641502380372,11.6937818527222 45.6650199890137,11.6911144256593 45.6698722839357,11.6883573532106 45.6793327331543,11.6873188018799 45.6882133483888,11.6873188018799 45.6882133483888,11.6863889694214 45.701774597168,11.6863889694214 45.701774597168,11.6732778549194 45.6959457397462,11.6732778549194 45.6959457397462,11.666428565979 45.6656074523926,11.666428565979 45.6656074523926,11.6630344390869 45.6560783386231,11.6630344390869 45.6560783386231,11.657190322876 45.6412811279297,11.657190322876 45.6412811279297,11.6776828765869 45.6410446166992,11.6776828765869 45.6410446166992,11.6808557510377 45.6416511535646,11.688858985901 45.6487998962402,11.6884040832519 45.6521682739258,11.6930332183838 45.6579742431642,11.7028665542603 45.6617469787598,11.7028665542603 45.6617469787598,11.6975660324097 45.6641502380372))	0.0006	POINT(11.681264519691496 45.66593138376876)
17760	MULTIPOLYGON(((8.79041862487804 45.4629211425781,8.78828811645502 45.462589263916,8.78350353240961 45.4650115966797,8.78593254089361 45.4669342041016,8.78923988342285 45.4651603698731,8.78923988342285 45.4651603698731,8.79041862487804 45.4629211425781)),((8.74604988098156 45.4114112854004,8.73710632324219 45.4114608764649,8.72158527374268 45.4136924743653,8.70450973510754 45.4084548950196,8.69564437866211 45.4026222229004,8.69671821594238 45.4000053405763,8.69671821594238 45.4000053405763,8.68989372253429 45.3989143371582,8.68574810028082 45.4025344848633,8.68195343017572 45.4085426330567,8.68195343017572 45.4085426330567,8.67490863800055 45.4096755981445,8.66995525360119 45.41654586792,8.67293643951422 45.4236297607422,8.6933383941651 45.4269638061525,8.69248390197748 45.4311447143555,8.69303989410395 45.4358749389649,8.6994886398316 45.4429016113281,8.70449447631842 45.4437294006348,8.70449447631842 45.4437294006348,8.7301931381225 45.4480171203614,8.72806835174566 45.4525756835937,8.72869873046875 45.4539413452148,8.73871612548834 45.4601821899415,8.74765014648443 45.4617385864257,8.75645732879639 45.4601173400878,8.76095199584967 45.4561805725098,8.77103137969976 45.4549446105958,8.78715610504156 45.4545936584473,8.78937816619884 45.455421447754,8.79399585723888 45.4607353210449,8.79399585723888 45.4607353210449,8.80104160308838 45.456756591797,8.80104160308838 45.456756591797,8.80671215057384 45.450023651123,8.81161117553711 45.445930480957,8.81304931640625 45.4399108886719,8.80990028381353 45.4376525878907,8.80870723724371 45.4353981018067,8.81104564666754 45.4334983825684,8.81104564666754 45.4334983825684,8.80950832366955 45.432415008545,8.79502391815191 45.4297332763672,8.77577304840099 45.4281692504882,8.76368236541748 45.4249229431153,8.75967597961426 45.4234695434571,8.7529869079591 45.4189529418946,8.7552223205567 45.4116592407227,8.74604988098156 45.4114112854004)))	0.0006	POINT(8.74504907747778 45.432989738414605)
28175	POLYGON((5.39134120941173 47.0897560119628,5.39780998229992 47.0946502685547,5.40058755874645 47.1075630187989,5.40058755874645 47.1075630187989,5.39248323440557 47.1119194030762,5.38843297958374 47.1253242492676,5.37166547775269 47.1380462646486,5.37166547775269 47.1380462646486,5.36661577224737 47.129467010498,5.34960794448858 47.1259307861328,5.34960794448858 47.1259307861328,5.35480737686157 47.1162605285644,5.36589908599854 47.1092414855957,5.37011623382574 47.1073341369629,5.37938976287847 47.1100082397462,5.38838291168213 47.1072311401367,5.38438749313354 47.0974235534668,5.38438749313354 47.0974235534668,5.39134120941173 47.0897560119628))	0.0006	POINT(5.378209749857629 47.11328442891441)
19098	POLYGON((11.626534461975 42.7989196777344,11.631018638611 42.7974319458008,11.6353979110718 42.7997703552246,11.6422958374025 42.8006744384766,11.6625356674194 42.7890663146972,11.6785430908204 42.7902755737306,11.6950197219849 42.7964172363281,11.6982374191285 42.7990722656249,11.7267055511475 42.7940559387207,11.7389974594117 42.7908096313477,11.7469730377197 42.7867431640625,11.7469730377197 42.7867431640625,11.7525787353517 42.7836341857911,11.7585611343384 42.7831497192383,11.7629804611206 42.7805786132812,11.7629804611206 42.7805786132812,11.7430562973022 42.7755851745605,11.7410583496094 42.7738037109376,11.7409038543701 42.7719802856446,11.7424716949463 42.7684593200683,11.7421398162842 42.765079498291,11.7320365905763 42.7604522705079,11.7296161651611 42.7601318359376,11.7261533737182 42.7628059387207,11.7201719284058 42.7643623352051,11.7154808044435 42.7635536193848,11.7057638168336 42.7576065063477,11.707739830017 42.7524909973145,11.7036247253419 42.7463607788087,11.6890010833741 42.7455062866211,11.6736927032471 42.7511787414551,11.6623764038085 42.7445335388184,11.6509704589844 42.7351913452148,11.627935409546 42.7245292663575,11.6171741485597 42.7157897949219,11.6171741485597 42.7157897949219,11.6171951293945 42.7191848754883,11.6136074066163 42.7247695922852,11.60746383667 42.7439880371094,11.6054840087892 42.7550544738771,11.5997352600098 42.7642440795899,11.5937280654907 42.7699356079102,11.5937280654907 42.7699356079102,11.607961654663 42.7774124145508,11.6235160827638 42.7940559387207,11.626534461975 42.7989196777344))	0.0006	POINT(11.682606527540454 42.767370944552965)
54261	POLYGON((5.17196130752575 46.0845756530761,5.16816806793219 46.0783424377441,5.15882396697998 46.0803565979005,5.14462471008312 46.077735900879,5.14006328582775 46.0689659118652,5.11591911315929 46.0687713623047,5.11591911315929 46.0687713623047,5.1089968681336 46.0647735595704,5.10704755783092 46.0520706176758,5.10704755783092 46.0520706176758,5.11005687713629 46.0492324829102,5.10809469223017 46.0318031311035,5.11488342285156 46.0267295837403,5.12460041046148 46.0248565673829,5.12460041046148 46.0248565673829,5.1315336227417 46.0198974609376,5.13590526580811 46.0215873718263,5.14376878738403 46.0302581787111,5.16115951538092 46.0367317199707,5.16547727584845 46.050132751465,5.17434978485113 46.0533332824707,5.18265676498424 46.0500907897949,5.18265676498424 46.0500907897949,5.18796730041504 46.0528450012208,5.18796730041504 46.0528450012208,5.17651939392096 46.0640106201172,5.17819976806641 46.0812644958497,5.17819976806641 46.0812644958497,5.17196130752575 46.0845756530761))	0.0006	POINT(5.146684595516802 46.0535094397409)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point