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
58293	POLYGON((7.93292331695568 49.7666244506835,7.93457126617437 49.7680244445802,7.93457126617437 49.7680244445802,7.93266201019293 49.7678642272949,7.93074083328258 49.7692070007324,7.93034601211554 49.7703399658204,7.93298673629761 49.7739562988282,7.92884588241577 49.776237487793,7.92884588241577 49.776237487793,7.92792606353765 49.7769355773926,7.92915105819696 49.7793388366699,7.92671632766724 49.7801513671876,7.92020320892334 49.7766799926759,7.91760730743403 49.7799530029298,7.90982580184942 49.7778396606446,7.90712881088251 49.7814064025878,7.90477848052979 49.7804069519044,7.90375232696533 49.7818870544434,7.90131998062145 49.782642364502,7.90071058273321 49.784122467041,7.90071058273321 49.784122467041,7.89531087875361 49.7865028381349,7.8936657905578 49.7889251708986,7.88706207275396 49.788070678711,7.88683080673218 49.787181854248,7.87700366973877 49.7889442443848,7.87083196640015 49.78763961792,7.87083196640015 49.78763961792,7.86879634857189 49.7839736938476,7.85955905914307 49.7785530090332,7.85939311981195 49.7752685546875,7.85509490966808 49.7723274230958,7.85509490966808 49.7723274230958,7.85990762710583 49.7657508850099,7.85990762710583 49.7657508850099,7.86194849014277 49.7657890319824,7.86794710159302 49.7570877075195,7.87005043029779 49.7559967041016,7.87005043029779 49.7559967041016,7.87396287918091 49.7571105957031,7.88733530044561 49.7580413818359,7.89589405059814 49.760597229004,7.89786195754999 49.7619743347168,7.89786195754999 49.7619743347168,7.90039110183727 49.7647705078125,7.9018287658692 49.7644042968751,7.90375471115118 49.7655296325685,7.90514993667597 49.7646713256837,7.90870428085339 49.7675437927246,7.91160964965826 49.7642059326172,7.91160964965826 49.7642059326172,7.91552400588995 49.7625045776368,7.9206161499024 49.7639350891114,7.9206161499024 49.7639350891114,7.93292331695568 49.7666244506835))	0.0006	POINT(7.899228360917859 49.77242837128819)
56625	POLYGON((4.62863016128546 46.0150909423828,4.61440753936779 46.0158882141114,4.61258506774897 46.018985748291,4.61258506774897 46.018985748291,4.62324428558361 46.0257606506348,4.6324224472047 46.0243911743165,4.67362356185913 46.0327072143555,4.67627048492437 46.0355339050294,4.67627048492437 46.0355339050294,4.68295478820806 46.0333709716796,4.68295478820806 46.0333709716796,4.6814951896668 46.0266571044923,4.67075824737549 46.015438079834,4.67075824737549 46.015438079834,4.62863016128546 46.0150909423828))	0.0006	POINT(4.652782882962947 46.024796622140094)
65559	POLYGON((10.9215507507325 48.0343170166017,10.9229068756105 48.0393104553223,10.9239597320557 48.0386047363281,10.9235944747925 48.0444564819337,10.9210720062256 48.0441589355469,10.9215450286865 48.0461730957032,10.9170446395875 48.0466766357422,10.9168596267701 48.0493774414064,10.9055852890015 48.0499877929689,10.9054927825927 48.0521430969239,10.9079408645629 48.0522079467774,10.9077768325806 48.0538482666016,10.9123601913453 48.0539474487305,10.9117736816407 48.059211730957,10.9117736816407 48.059211730957,10.9160461425781 48.0626182556153,10.9293022155762 48.0651092529297,10.9299688339233 48.0636596679688,10.9335660934449 48.0640144348146,10.9354486465455 48.0580024719239,10.9457111358643 48.0590286254883,10.9465188980104 48.0568237304689,10.946660041809 48.048366546631,10.9517736434937 48.0490188598634,10.9532556533813 48.0462036132812,10.9639863967897 48.0440025329589,10.9695568084718 48.0404624938965,10.9695568084718 48.0404624938965,10.9678716659547 48.0389747619629,10.9676933288574 48.0369338989258,10.9703855514527 48.0325622558594,10.9753856658936 48.0313110351562,10.9751319885254 48.0285682678223,10.9751319885254 48.0285682678223,10.9718990325928 48.0282325744629,10.9718990325928 48.0282325744629,10.9697990417481 48.0287170410157,10.9709091186525 48.0302810668946,10.9677906036377 48.030460357666,10.9660243988037 48.0274009704589,10.9642143249512 48.0271949768068,10.9632740020753 48.0259513854981,10.9614725112915 48.0267753601075,10.9573755264283 48.0256500244141,10.9572448730469 48.021713256836,10.9538803100587 48.0215225219727,10.9487247467041 48.0237846374511,10.9463672637941 48.0257225036621,10.9471874237061 48.0262641906738,10.9460620880127 48.0272903442384,10.9432392120362 48.0287742614746,10.9417877197265 48.0282135009767,10.9387350082397 48.0295066833496,10.9375915527343 48.0316543579103,10.9360723495483 48.0322799682617,10.9323444366455 48.0317001342773,10.929768562317 48.0332336425781,10.9215507507325 48.0343170166017))	0.0006	POINT(10.943471072012958 48.03962948447783)
16382	POLYGON((9.17467594146729 45.2490692138671,9.18562889099115 45.2479171752929,9.1925134658814 45.2492294311525,9.19458293914795 45.251350402832,9.20024299621582 45.2524681091309,9.2052373886109 45.2514686584473,9.2052373886109 45.2514686584473,9.21283531188971 45.2528686523439,9.21363353729248 45.2517204284669,9.21373939514172 45.2458992004396,9.20822143554688 45.2420997619628,9.21007919311529 45.2383728027345,9.21007919311529 45.2383728027345,9.21559715270996 45.229549407959,9.21011829376226 45.2250938415528,9.2108039855957 45.2213478088379,9.2108039855957 45.2213478088379,9.21047687530518 45.2191162109374,9.20893383026129 45.2185707092286,9.20420074462891 45.2229804992677,9.18943786621099 45.2294425964356,9.16473960876471 45.2331275939943,9.15993690490734 45.2329444885253,9.15993690490734 45.2329444885253,9.15996837615978 45.2387580871583,9.1699485778808 45.2470779418946,9.1699485778808 45.2470779418946,9.17467594146729 45.2490692138671))	0.0006	POINT(9.195242917096206 45.238580915663015)
30254	POLYGON((-3.32885360717773 48.6539077758789,-3.33915233612061 48.6534767150879,-3.33915233612061 48.6534767150879,-3.33587217330927 48.6705513000489,-3.32988882064814 48.6794090270997,-3.33749508857716 48.6881790161134,-3.33774828910828 48.6950874328614,-3.32320141792297 48.698097229004,-3.32320141792297 48.698097229004,-3.31515097618103 48.6894760131837,-3.30538773536682 48.6874046325684,-3.29461073875427 48.6945419311523,-3.29589796066278 48.7048683166505,-3.29589796066278 48.7048683166505,-3.27177882194519 48.7097167968751,-3.27177882194519 48.7097167968751,-3.24952483177185 48.694664001465,-3.24952483177185 48.694664001465,-3.25122570991516 48.6889533996583,-3.2452020645141 48.6847381591798,-3.2452020645141 48.6847381591798,-3.27442622184748 48.6781234741211,-3.28651905059814 48.6719627380371,-3.28651905059814 48.6719627380371,-3.30821299552917 48.6572341918946,-3.32885360717773 48.6539077758789))	0.0006	POINT(-3.2976570129394327 48.68471664428717)
47884	POLYGON((-1.0661580562591 47.3973121643067,-1.04995977878571 47.42484664917,-1.04995977878571 47.42484664917,-1.06445574760437 47.4250869750977,-1.08535647392273 47.4338912963868,-1.10448062419891 47.4374542236329,-1.11400806903839 47.435749053955,-1.11400806903839 47.435749053955,-1.16381072998047 47.4098968505859,-1.16381072998047 47.4098968505859,-1.16728913784016 47.3726882934571,-1.15814530849457 47.3701133728028,-1.1439266204834 47.3736228942871,-1.1439266204834 47.3736228942871,-1.12953424453735 47.3766212463378,-1.11789917945856 47.3875465393066,-1.10028970241541 47.3940200805665,-1.0661580562591 47.3973121643067))	0.0006	POINT(-1.1139422865474764 47.4048802992877)
42717	POLYGON((6.34123611450201 49.335651397705,6.33660459518438 49.3270530700685,6.34743404388433 49.3170280456543,6.34743404388433 49.3170280456543,6.34739637374889 49.3164443969728,6.34739637374889 49.3164443969728,6.32854700088507 49.3175926208496,6.32029056549084 49.3101272583008,6.32029056549084 49.3101272583008,6.31858253479015 49.3126678466796,6.31858253479015 49.3126678466796,6.30597400665289 49.3315200805665,6.30597400665289 49.3315200805665,6.3036346435548 49.3377647399902,6.31609439849865 49.3433265686035,6.31609439849865 49.3433265686035,6.34123611450201 49.335651397705))	0.0006	POINT(6.32634788751611 49.32376813888552)
64385	POLYGON((13.7473678588867 52.7630424499512,13.7594404220581 52.7522315979005,13.7635478973389 52.7436981201172,13.7635478973389 52.7436981201172,13.7536344528199 52.7409820556641,13.7371368408204 52.7345352172852,13.7314929962159 52.7337837219238,13.7368421554567 52.7296524047853,13.7405939102174 52.7282295227052,13.7453956604004 52.7282180786133,13.7471990585328 52.7297744750977,13.7484893798828 52.728931427002,13.7454795837402 52.7269172668456,13.7512493133544 52.7241210937501,13.7594223022462 52.7164764404298,13.7594223022462 52.7164764404298,13.7543268203736 52.71346282959,13.7543268203736 52.71346282959,13.7314319610596 52.7024459838867,13.7229747772218 52.6994132995607,13.7073917388917 52.6961555480958,13.6875858306885 52.6936721801758,13.6814155578613 52.6950149536133,13.6739015579224 52.6982994079591,13.6692066192627 52.6975860595704,13.6692066192627 52.6975860595704,13.6678447723389 52.6991004943848,13.6678447723389 52.6991004943848,13.6769056320191 52.7049064636231,13.6859149932862 52.7092781066895,13.6881351470948 52.7123603820801,13.6861190795898 52.7152481079102,13.6840248107911 52.7247352600098,13.6841650009155 52.7337684631349,13.68639087677 52.7412719726564,13.6861133575439 52.7440338134766,13.6826095581056 52.7524833679199,13.683575630188 52.7546005249024,13.6847724914551 52.7543258666992,13.6847724914551 52.7543258666992,13.6983299255372 52.7534942626954,13.6995439529418 52.7563591003418,13.704571723938 52.760051727295,13.7363567352296 52.7691497802736,13.7423400878906 52.769702911377,13.7428312301636 52.7673759460449,13.7473678588867 52.7630424499512))	0.0006	POINT(13.715547665305797 52.72877261949625)
20497	POLYGON((7.37205314636236 48.5985107421876,7.36265468597412 48.6011276245118,7.37156534194952 48.6167373657227,7.40566396713268 48.6218299865723,7.41269254684454 48.6265335083008,7.41269254684454 48.6265335083008,7.4146676063537 48.6380195617676,7.4146676063537 48.6380195617676,7.39913654327404 48.6376037597657,7.37809610366833 48.6277122497559,7.34827375411987 48.6215972900392,7.34827375411987 48.6215972900392,7.33779907226574 48.6060523986818,7.3155779838562 48.5971946716309,7.31513214111339 48.590301513672,7.31513214111339 48.590301513672,7.3226380348205 48.585823059082,7.3472986221314 48.5897598266603,7.3594212532044 48.5841636657714,7.37359046936035 48.5826148986818,7.37359046936035 48.5826148986818,7.37205314636236 48.5985107421876))	0.0006	POINT(7.366696085248715 48.60879280453643)
66008	POLYGON((11.2599477767944 48.9206314086915,11.2591791152954 48.9186134338379,11.2530117034912 48.9178199768066,11.2501525878907 48.9182777404786,11.250524520874 48.9202194213868,11.2477035522462 48.9204978942872,11.2455234527588 48.9189414978027,11.2397642135621 48.9189414978027,11.2369270324708 48.9226379394531,11.2345628738404 48.9224319458007,11.2306060791016 48.9207191467286,11.2321481704712 48.918254852295,11.2322998046875 48.9154624938964,11.2264032363892 48.913730621338,11.216609954834 48.9087486267091,11.2097005844117 48.9097557067871,11.2096576690674 48.9115104675293,11.2061376571655 48.9115257263184,11.2060327529907 48.9096336364747,11.1990337371826 48.9090614318848,11.1987047195435 48.9080200195313,11.1922101974488 48.9088554382324,11.1913080215454 48.9117355346681,11.191430091858 48.9174270629884,11.1890020370483 48.9175148010255,11.1893711090089 48.9193801879882,11.1832714080811 48.9219589233399,11.1832714080811 48.9219589233399,11.18483543396 48.9268493652344,11.1722536087037 48.9300270080566,11.1739673614502 48.9324874877931,11.1735095977784 48.9359169006348,11.1692800521852 48.9356803894042,11.1682405471802 48.9388999938966,11.1645908355714 48.9386520385742,11.1636543273927 48.9423217773438,11.161626815796 48.9420242309571,11.161304473877 48.9429473876954,11.151068687439 48.9413223266602,11.1460218429566 48.9420890808106,11.1450672149659 48.9436683654786,11.1472015380859 48.9438667297364,11.1498851776123 48.9487075805665,11.1415901184082 48.9502754211426,11.1433744430543 48.9522438049318,11.1444168090821 48.951831817627,11.1445140838623 48.9536628723145,11.1366767883301 48.9539947509766,11.1273164749146 48.9510955810547,11.1230211257935 48.9514541625977,11.1251106262208 48.9653930664062,11.1251106262208 48.9653930664062,11.1340475082397 48.9655799865724,11.1362199783326 48.9645957946778,11.1423749923706 48.9651832580567,11.1423749923706 48.9651832580567,11.1515178680421 48.9639778137207,11.1604461669922 48.9640655517578,11.1681375503541 48.9601821899415,11.1711120605469 48.9605293273926,11.172221183777 48.9623107910156,11.1772899627685 48.9641571044923,11.1929988861084 48.9625930786133,11.1944065093994 48.9631996154785,11.1956777572632 48.9661674499513,11.2026271820069 48.9660568237306,11.2062358856202 48.9650764465332,11.2163610458375 48.9671249389648,11.2175168991089 48.9684371948242,11.221173286438 48.9682540893555,11.2211666107177 48.9696846008301,11.2255878448487 48.9702033996581,11.2263221740723 48.9690742492676,11.2275104522706 48.9699745178224,11.2356834411622 48.9693031311035,11.2367763519288 48.9675407409667,11.2410097122192 48.9678535461426,11.2470617294312 48.970043182373,11.2529058456421 48.9662284851074,11.2541856765747 48.9671707153321,11.2600650787354 48.9664154052735,11.2605552673341 48.9680557250977,11.2605552673341 48.9680557250977,11.2730836868286 48.9681129455566,11.2765550613404 48.9628753662109,11.272575378418 48.9617614746094,11.2733068466187 48.9607009887696,11.2775459289552 48.9618492126465,11.280390739441 48.9586563110353,11.2736110687255 48.9583587646485,11.2737150192262 48.9565429687501,11.2758979797363 48.9551925659181,11.2759065628052 48.9539566040039,11.2805976867677 48.953067779541,11.2815122604371 48.953800201416,11.2839851379395 48.9520530700685,11.2860460281372 48.9528121948242,11.2887411117554 48.9514007568361,11.2931489944459 48.9528808593751,11.2934560775758 48.9499549865724,11.2934560775758 48.9499549865724,11.285816192627 48.9504241943361,11.284372329712 48.9464492797853,11.2871046066284 48.9465103149414,11.2871685028076 48.945411682129,11.280101776123 48.9407119750978,11.2691850662233 48.9422836303711,11.2656965255738 48.9457244873047,11.2622241973878 48.9464683532715,11.2616262435913 48.9475135803222,11.2629642486573 48.9482955932618,11.2614183425903 48.9505500793458,11.2544384002686 48.9498291015626,11.2529602050782 48.9480209350586,11.2537202835084 48.9466781616211,11.2583761215209 48.9466743469239,11.2586898803712 48.9457626342773,11.2616167068481 48.9460678100587,11.2636222839357 48.9451065063478,11.2611398696899 48.9447784423828,11.2569990158081 48.9424171447754,11.2571992874146 48.9409523010254,11.2596702575684 48.9386596679688,11.2567510604859 48.9370193481446,11.2553482055663 48.9379501342774,11.2543535232544 48.9368782043457,11.2547798156739 48.9335098266602,11.2567281723022 48.9320869445801,11.251612663269 48.9296646118165,11.2506656646729 48.9240760803223,11.253649711609 48.9237403869629,11.2534818649293 48.9219360351563,11.2599477767944 48.9206314086915))	0.0006	POINT(11.222327817570118 48.94457146615694)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point