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.
SpaltennameDatentypMögliche WerteBeschreibung
id_ortint(10) unsignedbeliebigFremdschlü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"
beliebigDie simplifizierten Geodaten.
epsilonfloat(5,4)beliebigDie 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"
beliebigDer geometrische Mittelpunkt des vereinfachten Polygons.
Ausschnitt
id_ortgeodatenepsilonmittelpunkt
68151POLYGON((6.74393081665045 50.2090911865236,6.7453169822694 50.2093505859375,6.74714660644526 50.2117614746095,6.74925374984747 50.2119216918946,6.75205612182617 50.2103996276855,6.75901508331305 50.2108078002931,6.76243019104015 50.2089920043945,6.76301813125616 50.2058219909668,6.75855159759533 50.2016105651855,6.75388956069946 50.1996955871582,6.75514507293707 50.1983757019043,6.75329113006603 50.1969795227052,6.75223588943481 50.1927757263185,6.75098562240606 50.1926155090333,6.75225448608398 50.1907768249512,6.75521183013916 50.191349029541,6.75708866119379 50.1905097961427,6.75708866119379 50.1905097961427,6.76040220260626 50.1915473937988,6.76591539382946 50.1913948059083,6.76907825469976 50.189552307129,6.77465629577642 50.1899948120118,6.77710103988653 50.1888847351075,6.7780122756958 50.186939239502,6.78423500061035 50.1850700378419,6.78621864318853 50.1819725036621,6.78633356094366 50.1785011291505,6.78527545928955 50.17631149292,6.78677034378063 50.174430847168,6.78689527511591 50.1726608276368,6.79249334335333 50.1697883605957,6.79249334335333 50.1697883605957,6.79808282852173 50.1698799133302,6.80183553695679 50.1687049865723,6.80295085906982 50.1668205261232,6.80490303039556 50.1664352416992,6.80486297607428 50.1637229919434,6.81514215469372 50.159954071045,6.81889486312872 50.1612815856934,6.82064962387096 50.1607170104982,6.82192182540899 50.1623878479004,6.82392215728765 50.1624526977539,6.82365369796764 50.1615791320801,6.8274712562561 50.1629829406739,6.82674789428722 50.163803100586,6.82274341583263 50.1640815734863,6.82309675216686 50.1649475097657,6.82182312011724 50.165096282959,6.82274007797247 50.1657485961915,6.81970787048351 50.1656036376954,6.82058954238892 50.167064666748,6.81876182556164 50.1698188781739,6.8222918510437 50.171859741211,6.8222918510437 50.171859741211,6.82488727569574 50.1714935302736,6.82707738876354 50.1734466552736,6.82769727706921 50.1721496582031,6.82977342605597 50.1725044250489,6.82910203933716 50.1739234924318,6.83146905899048 50.1746940612792,6.83130455017096 50.1757240295411,6.83369827270508 50.176155090332,6.83347320556646 50.1774253845215,6.84432649612432 50.1801948547364,6.84340000152594 50.1814727783203,6.84578752517706 50.1823844909668,6.84413862228394 50.183521270752,6.85792112350475 50.1867294311524,6.85792112350475 50.1867294311524,6.86339950561518 50.188461303711,6.87181663513195 50.1890258789063,6.86878681182861 50.1902885437013,6.86771774291998 50.1917877197266,6.87597417831421 50.197551727295,6.87545967102056 50.200050354004,6.87545967102056 50.200050354004,6.87243795394897 50.2046661376954,6.87243795394897 50.2046661376954,6.87048768997198 50.2048377990722,6.86881399154663 50.2087135314941,6.86274909973156 50.209815979004,6.8633446693421 50.2117385864259,6.86167764663696 50.2124214172364,6.86098623275757 50.2148323059083,6.86689567565918 50.2172088623047,6.86681270599371 50.2181091308594,6.86908054351807 50.2194671630859,6.86400938034069 50.2215042114259,6.86738348007202 50.2232704162598,6.86651659011841 50.224681854248,6.86989593505865 50.2251052856446,6.86989593505865 50.2251052856446,6.85961961746216 50.2268981933594,6.85437965393061 50.2300109863282,6.85876893997192 50.2329940795898,6.84987306594854 50.2347030639648,6.84553956985485 50.2369804382325,6.83949518203741 50.237216949463,6.8375611305238 50.2386054992676,6.8351731300354 50.2433052062989,6.83607721328741 50.2437858581543,6.83554697036743 50.2444610595703,6.83321857452398 50.2447738647462,6.83335924148565 50.2462196350097,6.83335924148565 50.2462196350097,6.82936906814581 50.2440567016602,6.82538557052624 50.2398376464843,6.82185029983526 50.2417602539062,6.82185029983526 50.2417602539062,6.81838130950933 50.2419281005859,6.81543111801147 50.2397804260254,6.81020689010631 50.2379722595216,6.81013917922974 50.2354316711426,6.80514574050909 50.2351608276368,6.79727840423578 50.2374267578126,6.78947162628174 50.2410430908203,6.78688192367559 50.2380752563478,6.78246355056768 50.2371025085449,6.77980947494513 50.2376289367677,6.77499103546148 50.2415428161622,6.77499103546148 50.2415428161622,6.7698335647583 50.2383766174318,6.77753734588617 50.2363395690918,6.77555227279663 50.2323112487793,6.78186035156244 50.2276611328125,6.78132963180542 50.2261428833008,6.77990722656261 50.2257118225098,6.78320932388317 50.223731994629,6.77941703796392 50.2210769653321,6.77661228179937 50.2203178405762,6.76907682418823 50.2213249206544,6.76907682418823 50.2213249206544,6.76998710632319 50.2201118469238,6.76826429367065 50.2177505493164,6.76425886154175 50.2172660827637,6.76488304138184 50.2152099609376,6.75768709182739 50.2130355834962,6.74971103668213 50.2139358520508,6.74814176559448 50.2165412902833,6.74468088150036 50.2127532958984,6.74393081665045 50.2090911865236))0.0006POINT(6.810139553887539 50.20312886919295)
65143POLYGON((11.9734058380128 49.7077255249023,11.967282295227 49.7066612243652,11.9649171829224 49.7091636657715,11.9592266082764 49.7077713012696,11.9578227996826 49.7158508300782,11.9498691558837 49.7171707153321,11.9507274627685 49.7266693115235,11.9476375579835 49.7323226928711,11.9445753097534 49.7357368469239,11.9309263229371 49.7333831787111,11.92453956604 49.7305564880372,11.924903869629 49.7329902648926,11.9186601638793 49.7358932495118,11.916229248047 49.7381896972657,11.9177064895629 49.7397651672364,11.9172039031982 49.7401504516602,11.9172039031982 49.7401504516602,11.9208889007569 49.7445220947266,11.9206171035768 49.7498435974122,11.9185962677002 49.7528915405273,11.9173297882081 49.7597999572755,11.9097223281861 49.7594795227051,11.9103851318359 49.7654304504395,11.9115648269654 49.7658843994141,11.9086713790895 49.7690238952637,11.9093360900879 49.7726974487306,11.910532951355 49.7741928100587,11.9086332321168 49.7752418518068,11.9108638763427 49.7759704589843,11.913034439087 49.7784156799316,11.9212827682495 49.7782058715821,11.9401359558107 49.7822341918946,11.9395132064819 49.7841758728028,11.937047958374 49.7849197387696,11.9390954971314 49.788745880127,11.9407014846802 49.788974761963,11.9415893554689 49.7907638549805,11.9404897689819 49.7911643981934,11.9391717910767 49.7949256896974,11.9407348632813 49.8006629943847,11.9446859359741 49.8048782348633,11.9374895095826 49.809642791748,11.9349451065065 49.810115814209,11.9217386245728 49.8055839538575,11.9217386245728 49.8055839538575,11.9254999160767 49.8072090148926,11.9290285110474 49.8108100891113,11.9352979660035 49.8121528625488,11.94379901886 49.8063392639161,11.9512538909913 49.8055076599122,11.9706840515138 49.8124465942383,11.9706840515138 49.8124465942383,11.9738731384278 49.8143920898438,11.9791717529298 49.8148727416992,11.9815769195557 49.8179664611818,11.9815769195557 49.8179664611818,11.9845762252809 49.8209304809571,11.9921712875366 49.8231735229493,11.9935760498047 49.8214073181153,11.9941215515138 49.8175315856934,12.0050468444824 49.8164672851562,12.0050897598267 49.8151817321777,12.0114974975587 49.8124580383302,12.0178709030152 49.8069229125977,12.0253686904907 49.7922706604003,12.0222196578979 49.7920532226562,12.0227088928223 49.7929801940919,12.0114707946778 49.7954177856445,12.0092382431031 49.7929458618163,12.0045499801636 49.7910728454591,12.0051975250244 49.7886886596681,12.0115242004394 49.7848434448243,12.0176429748535 49.7866516113281,12.0200929641725 49.7894248962402,12.0275583267212 49.7886047363281,12.0280075073242 49.7874374389648,12.0309581756592 49.7881927490234,12.0420436859132 49.7861061096192,12.0420436859132 49.7861061096192,12.0458574295045 49.7832756042482,12.0493021011353 49.7832260131836,12.0512237548829 49.7816352844238,12.0480270385743 49.7812004089357,12.0472230911255 49.7782516479492,12.0440206527709 49.7763519287109,12.0448961257936 49.7750701904297,12.0470371246338 49.7746925354005,12.0468215942383 49.7740173339845,12.0468215942383 49.7740173339845,12.042573928833 49.7745895385743,12.0415964126587 49.7757263183595,12.0343589782716 49.7749366760254,12.0340433120728 49.7733192443848,12.0371856689453 49.7716674804688,12.0342330932618 49.7710304260254,12.0325517654419 49.7667083740235,12.0287208557129 49.7668037414551,12.0270633697511 49.7688407897949,12.0257234573364 49.768222808838,12.0224647521973 49.7701644897462,12.0228414535522 49.7719306945801,12.0171175003052 49.7701988220215,12.0173749923707 49.7678375244141,12.0212535858155 49.7635650634765,12.0199337005616 49.7578887939453,12.0270519256592 49.7550659179688,12.0285358428956 49.7549743652345,12.0295639038086 49.7562828063965,12.0301065444947 49.7550354003906,12.0269870758057 49.7499923706056,12.0252389907837 49.7500495910645,12.0268907546998 49.7491722106933,12.0180234909058 49.7445793151857,12.0186815261841 49.743434906006,12.0109605789184 49.7434310913087,12.010127067566 49.7394714355469,12.007664680481 49.7393417358398,12.0092830657958 49.7351837158203,12.0092830657958 49.7351837158203,12.0072078704834 49.7380447387695,12.0053329467773 49.7384643554688,12.0027751922609 49.7383728027345,12.0017957687378 49.7368202209473,11.9862689971925 49.7388877868652,11.9836807250977 49.7373847961426,11.9798498153687 49.7405471801758,11.975763320923 49.7399711608888,11.9780006408691 49.7355499267578,11.9804668426513 49.73539352417,11.9819259643555 49.7340774536133,11.9819869995118 49.7320137023926,11.9850044250488 49.7263870239258,11.980996131897 49.728286743164,11.9778671264648 49.7325897216797,11.9762001037599 49.7320899963379,11.9800500869752 49.7277755737305,11.9790601730346 49.7244873046875,11.9807348251343 49.7230072021484,11.9793424606324 49.7179298400879,11.9805030822754 49.7168807983398,11.983458518982 49.7177619934082,11.9819183349609 49.7132987976075,11.9803829193116 49.7121124267578,11.9763517379762 49.7114562988282,11.9768733978271 49.7094879150391,11.9734058380128 49.7077255249023))0.0006POINT(11.983123174206998 49.76557619818327)
63343POLYGON((13.1399908065796 53.4615669250489,13.1373891830445 53.4589843750001,13.1371154785157 53.4571800231934,13.142110824585 53.4540786743165,13.1410865783691 53.4515762329103,13.1416006088257 53.450855255127,13.1593341827393 53.4441871643067,13.1593341827393 53.4441871643067,13.1573200225831 53.4400291442872,13.15207862854 53.4395217895508,13.1433591842651 53.4352951049805,13.1329803466797 53.4359855651856,13.1308794021607 53.4366035461427,13.130763053894 53.4376792907715,13.1283903121949 53.4390487670898,13.1204996109009 53.4413414001465,13.1084251403808 53.4307708740236,13.1092948913575 53.4281730651856,13.1019201278687 53.4254226684571,13.1009635925294 53.4288406372071,13.1009635925294 53.4288406372071,13.0963096618653 53.429328918457,13.0961408615113 53.42724609375,13.0918140411377 53.4228019714356,13.0885000228882 53.4212379455566,13.0859861373902 53.4212341308595,13.0824937820436 53.4227828979493,13.0836658477784 53.4235038757324,13.0826330184937 53.4243812561036,13.0829133987427 53.4273529052736,13.0842180252076 53.4298171997071,13.0906867980956 53.435085296631,13.090295791626 53.4358558654786,13.0843772888185 53.4335441589357,13.082426071167 53.4308319091796,13.0765504837037 53.4279632568359,13.0757694244384 53.426197052002,13.0742588043213 53.4258613586426,13.073447227478 53.4266510009766,13.0693035125733 53.4253082275391,13.0675382614137 53.4265213012696,13.0616722106935 53.4263572692871,13.058485031128 53.4292755126954,13.0614824295045 53.4303283691407,13.0627307891846 53.4323692321778,13.0691165924072 53.4375495910646,13.0692138671876 53.4398384094239,13.0706872940064 53.4407081604004,13.0699090957642 53.4415016174317,13.0706357955932 53.4480476379396,13.0693979263307 53.4492874145509,13.072714805603 53.4537162780762,13.0779743194581 53.456813812256,13.0850715637208 53.4586257934571,13.0897617340088 53.4620246887207,13.0888557434082 53.4630088806152,13.093147277832 53.4647407531738,13.0928745269776 53.466251373291,13.089518547058 53.4691352844238,13.0919818878173 53.4702911376954,13.0919818878173 53.4702911376954,13.0949840545654 53.4678001403809,13.0999269485474 53.4680252075195,13.1010694503785 53.4692497253419,13.0989484786988 53.469825744629,13.1010656356811 53.4747810363771,13.1072502136232 53.4741096496583,13.1079502105714 53.4752388000488,13.1147050857545 53.4780387878417,13.1158456802368 53.4778976440431,13.1161394119263 53.4760704040528,13.116328239441 53.4734230041505,13.1154985427858 53.4724082946778,13.1215076446534 53.4710655212403,13.1244821548462 53.4686470031739,13.1242589950562 53.4745521545411,13.1212129592897 53.4782485961915,13.1243677139283 53.4798164367676,13.1301593780518 53.4768600463867,13.1333789825439 53.4737434387208,13.1313896179199 53.4722480773926,13.1316375732422 53.4695892333984,13.1363153457642 53.4636802673341,13.1399908065796 53.4615669250489))0.0006POINT(13.10290076933715 53.4485440541463)
28874POLYGON((3.29823851585388 47.3886451721191,3.28389024734491 47.3925895690919,3.26702928543097 47.3848953247071,3.25675249099743 47.3839912414551,3.25675249099743 47.3839912414551,3.25741672515875 47.3760223388672,3.25741672515875 47.3760223388672,3.2506365776062 47.3629493713379,3.26754403114319 47.3552322387696,3.28394150733959 47.3421936035156,3.29406714439392 47.3410530090333,3.29406714439392 47.3410530090333,3.30865240097046 47.3647193908692,3.30865240097046 47.3647193908692,3.31379818916315 47.374626159668,3.29823851585388 47.3886451721191))0.0006POINT(3.2799237251282007 47.368846893310575)
32503POLYGON((1.24727618694311 46.7677192687989,1.25661826133734 46.7670059204102,1.26180052757269 46.7611236572266,1.27638328075403 46.7591705322266,1.27638328075403 46.7591705322266,1.28057289123535 46.7655029296876,1.28963792324072 46.7685546875001,1.29424238204962 46.7784423828125,1.29797029495245 46.7807922363282,1.30794191360485 46.7796974182129,1.31519567966467 46.7842063903809,1.31492638587952 46.7979393005371,1.30348742008221 46.8131332397461,1.31766891479498 46.8266258239747,1.31766891479498 46.8266258239747,1.29551005363476 46.8336296081543,1.28537797927856 46.8452796936035,1.28537797927856 46.8452796936035,1.26382613182074 46.8542671203614,1.24879145622259 46.8559837341309,1.20422589778894 46.8506584167481,1.20422589778894 46.8506584167481,1.19707179069519 46.8463134765625,1.19884538650518 46.8261337280274,1.19884538650518 46.8261337280274,1.20481860637676 46.820499420166,1.20365178585052 46.7998924255371,1.22018170356762 46.7869567871093,1.23956108093267 46.7829132080079,1.24727618694311 46.7677192687989))0.0006POINT(1.2623477722036816 46.805527917270034)
23901POLYGON((3.45080614089966 46.1940650939941,3.44312882423407 46.205177307129,3.44195842742931 46.2144393920898,3.44195842742931 46.2144393920898,3.42110061645513 46.2128639221192,3.42110061645513 46.2128639221192,3.42138314247137 46.2125015258789,3.42138314247137 46.2125015258789,3.41696834564215 46.2067909240724,3.41861939430243 46.1903152465821,3.41235518455505 46.181468963623,3.41312217712408 46.1748542785645,3.41312217712408 46.1748542785645,3.42674326896679 46.1778755187988,3.43348264694225 46.1826210021972,3.43348264694225 46.1826210021972,3.45080614089966 46.1940650939941))0.0006POINT(3.426919698715277 46.19689083099366)
36789POLYGON((5.43903779983532 46.5934333801271,5.45984792709351 46.5851669311523,5.45984792709351 46.5851669311523,5.47257041931164 46.5755882263184,5.47367858886724 46.5692138671876,5.47367858886724 46.5692138671876,5.46852207183838 46.5681343078613,5.46852207183838 46.5681343078613,5.42618513107311 46.5918159484864,5.42330503463745 46.5946311950684,5.42570590972912 46.5974807739258,5.43903779983532 46.5934333801271))0.0006POINT(5.453718315471355 46.5816345214844)
35124POLYGON((8.92980003356939 41.9341583251953,8.93740367889416 41.9310722351075,8.95022010803223 41.930980682373,8.95022010803223 41.930980682373,8.95065402984625 41.9210739135743,8.95065402984625 41.9210739135743,8.89405536651617 41.9195022583008,8.87577438354498 41.9156837463378,8.84670448303228 41.9042472839355,8.83754348754883 41.9118156433107,8.83754348754883 41.9118156433107,8.86369228363031 41.9262580871583,8.86369228363031 41.9262580871583,8.87511825561523 41.9320716857911,8.89312076568598 41.9306526184083,8.90396595001221 41.9369049072267,8.91660785675055 41.9332656860352,8.92980003356939 41.9341583251953))0.0006POINT(8.898633564219777 41.924577376421816)
57967POLYGON((7.18530941009527 49.7416152954103,7.17878484725964 49.7409210205078,7.17340230941772 49.7368087768556,7.17080497741705 49.7330131530762,7.16543006896984 49.7306022644044,7.16543006896984 49.7306022644044,7.17104291915888 49.7232475280762,7.17181539535534 49.7181549072267,7.17415809631353 49.7182235717773,7.18183946609503 49.714828491211,7.18511676788336 49.7156372070314,7.18768453598017 49.7134628295898,7.1891565322876 49.7142601013183,7.19912338256836 49.7113265991211,7.19912338256836 49.7113265991211,7.20864486694336 49.709758758545,7.21483659744268 49.710433959961,7.21508693695074 49.7090187072754,7.21602010726934 49.7091789245605,7.21897554397594 49.7118301391603,7.21787738800055 49.7148704528809,7.21220064163208 49.7180366516114,7.21745681762695 49.7208862304688,7.21745681762695 49.7208862304688,7.2192521095277 49.7225379943848,7.21064186096203 49.7271423339843,7.2101140022279 49.729549407959,7.20401620864862 49.7313461303711,7.20292425155645 49.7354736328126,7.20442771911632 49.7382469177247,7.20137214660645 49.7408332824707,7.19803380966198 49.7424812316896,7.19420051574713 49.7386512756349,7.19434356689459 49.736988067627,7.18530941009527 49.7416152954103))0.0006POINT(7.196356002022287 49.72418179231537)
13061POLYGON((16.1015472412109 39.6906585693361,16.0945396423341 39.6945152282715,16.0855007171631 39.6958808898927,16.0787582397462 39.6982688903809,16.0728988647462 39.7025108337403,16.0726661682129 39.7115325927735,16.0659751892089 39.7268066406251,16.0666446685792 39.7362289428712,16.0627365112305 39.7462120056153,16.0563220977784 39.7543258666993,16.0579166412353 39.7600746154786,16.0579166412353 39.7600746154786,16.0685005187988 39.7635231018067,16.0756797790528 39.7575187683105,16.0822353363037 39.7481956481934,16.1008224487305 39.7353324890137,16.1053142547607 39.7346267700196,16.1084880828858 39.7330284118653,16.13187789917 39.7177276611329,16.13187789917 39.7177276611329,16.116605758667 39.7125244140626,16.1012458801269 39.7032928466797,16.1003379821777 39.7010841369629,16.1015472412109 39.6906585693361))0.0006POINT(16.08680036793586 39.72615963479753)