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
64461POLYGON((11.0653533935548 49.1297149658204,11.0677471160889 49.1293067932129,11.0704898834229 49.1236534118653,11.0719747543336 49.1240043640137,11.072582244873 49.1232109069824,11.073079109192 49.1223793029786,11.0711917877197 49.1212539672852,11.0798740386964 49.1221923828125,11.0812273025513 49.1184349060059,11.0833530426025 49.1174430847169,11.0775032043457 49.11185836792,11.082242012024 49.1094512939454,11.0803394317627 49.1073036193849,11.08189868927 49.1070518493653,11.0817775726318 49.1061515808107,11.0869998931885 49.106330871582,11.0869398117066 49.1047668457031,11.0897722244263 49.1056251525878,11.0896873474121 49.104305267334,11.0934228897096 49.1028175354004,11.0934228897096 49.1028175354004,11.0911378860474 49.1008071899414,11.0898418426514 49.1011924743653,11.0889196395875 49.0997009277344,11.0866260528564 49.100399017334,11.086096763611 49.0974311828613,11.0843143463134 49.0977020263673,11.0817031860352 49.0964088439942,11.081036567688 49.0946426391603,11.0834579467775 49.0943717956542,11.0818033218383 49.0889282226564,11.0779275894166 49.0900726318361,11.0767803192138 49.0880737304688,11.0659666061403 49.093147277832,11.0637664794922 49.0912590026856,11.0629959106446 49.0921173095704,11.0610923767089 49.0909843444824,11.0589179992676 49.0935783386232,11.0564422607422 49.092716217041,11.0555448532104 49.0944595336915,11.0481462478637 49.0918769836427,11.0481462478637 49.0918769836427,11.0446643829346 49.096435546875,11.0465059280396 49.0969924926758,11.0451555252075 49.098690032959,11.0413455963136 49.0985679626464,11.0334844589235 49.0961647033692,11.029468536377 49.0934143066407,11.0271110534669 49.093318939209,11.0279998779296 49.0918731689454,11.0267629623414 49.0915298461915,11.023621559143 49.0910873413086,11.0224361419678 49.0928802490235,11.0205802917481 49.0922431945802,11.0214405059815 49.090690612793,11.0182676315308 49.0911216735841,11.0199365615845 49.0896987915038,11.0190553665162 49.089225769043,11.0171546936036 49.0908088684082,11.0133256912232 49.0900344848634,11.0077695846558 49.0905113220216,11.0035524368286 49.089225769043,11.0003347396851 49.0932693481446,10.996114730835 49.0944480895997,10.9863824844361 49.0924034118653,10.9815235137939 49.0885581970215,10.9771528244019 49.0827865600587,10.9771528244019 49.0827865600587,10.9741516113282 49.0839309692384,10.9770889282227 49.087417602539,10.9772834777833 49.089153289795,10.9744291305543 49.0884895324707,10.9738082885743 49.0894622802736,10.9670114517212 49.0876312255859,10.9658136367799 49.0884284973146,10.9690542221069 49.0906982421875,10.9648141860962 49.0898437500001,10.9615745544434 49.0904502868653,10.963327407837 49.0890579223633,10.9562463760377 49.0903739929199,10.9552717208862 49.0898895263671,10.9570264816285 49.0889320373536,10.9569311141968 49.0874938964844,10.9551229476929 49.0874824523927,10.9539661407471 49.0853729248047,10.9405632019043 49.084255218506,10.9350156784058 49.0855903625489,10.937484741211 49.0859680175782,10.9374094009399 49.0883331298829,10.9385328292847 49.0898513793946,10.9223661422731 49.0938072204589,10.9204778671265 49.0924644470214,10.9191150665284 49.0932807922363,10.9172706604003 49.0921707153321,10.9182157516479 49.0906372070314,10.9158248901368 49.0881385803223,10.9063081741334 49.0833435058594,10.905369758606 49.0858192443848,10.8997592926026 49.0862274169923,10.9001235961915 49.0889778137208,10.8973560333253 49.0888061523438,10.8957824707032 49.0923118591309,10.8901996612549 49.094654083252,10.8886890411378 49.094108581543,10.8866167068481 49.0970306396485,10.8866167068481 49.0970306396485,10.8872900009156 49.0989875793457,10.8853988647462 49.1006431579591,10.8813753128052 49.0993881225587,10.8812942504884 49.0978126525878,10.8783168792725 49.0971221923829,10.8768186569213 49.0982055664063,10.8759593963623 49.102237701416,10.8779697418213 49.105281829834,10.8779697418213 49.105281829834,10.887830734253 49.1048965454102,10.8882589340211 49.1036071777345,10.8899936676025 49.1030082702637,10.899730682373 49.1026763916015,10.8999547958375 49.1048812866212,10.9070491790771 49.1063041687012,10.9065170288086 49.108139038086,10.9042654037476 49.1076736450195,10.9025926589967 49.1106986999512,10.9009199142457 49.1106338500978,10.9010791778564 49.1116333007812,10.9031543731689 49.11238861084,10.9027299880982 49.1141090393067,10.904112815857 49.1139526367188,10.9041547775269 49.1157226562501,10.9023227691652 49.1161346435547,10.9035787582399 49.1205444335939,10.9067974090577 49.1220092773438,10.9118719100952 49.122413635254,10.9192743301393 49.1194534301757,10.9187173843383 49.1184120178222,10.9221973419189 49.1184082031251,10.9202928543092 49.1199645996094,10.922462463379 49.1220512390137,10.9206228256226 49.1248817443849,10.9224796295167 49.1271667480469,10.9154014587402 49.1296577453613,10.905795097351 49.1299018859863,10.9062376022339 49.1320037841798,10.9062376022339 49.1320037841798,10.9077816009521 49.1346435546876,10.9129066467285 49.1311874389649,10.9163236618042 49.131706237793,10.9146003723144 49.1384582519532,10.9146003723144 49.1384582519532,10.9198055267333 49.1364898681641,10.9217433929443 49.1338920593262,10.9246091842652 49.135498046875,10.9285583496094 49.1326065063478,10.9377851486207 49.1312484741212,10.9403619766236 49.1372375488281,10.9404258728028 49.139762878418,10.9430446624757 49.1412200927734,10.9426164627076 49.1424522399902,10.9393939971924 49.1438789367676,10.9374694824219 49.1463165283204,10.938572883606 49.1485061645508,10.9600038528444 49.1499023437501,10.9658908843994 49.1517601013185,10.9658908843994 49.1517601013185,10.968270301819 49.1496810913087,10.9777421951295 49.1534996032714,10.9807815551758 49.1529388427735,10.9850330352784 49.1570739746094,10.9883527755738 49.1558113098145,10.9954671859742 49.1554908752442,10.9971361160279 49.155086517334,10.9978313446045 49.1533393859863,10.9963493347169 49.1532554626466,10.9972381591798 49.1517486572266,10.9951667785645 49.1516609191895,10.9978313446045 49.1493453979493,10.9966373443604 49.1492538452148,10.9971370697022 49.1472244262696,10.9931917190553 49.1462287902833,10.9952383041382 49.1444549560547,11.00053024292 49.1452140808106,11.0000629425049 49.144386291504,11.0008153915406 49.1436195373535,11.0043783187866 49.1434173583985,11.01318359375 49.1450309753419,11.015284538269 49.1427001953126,11.0192098617554 49.1430892944337,11.0192155838013 49.1411094665527,11.0177059173584 49.1384010314943,11.0198421478272 49.13818359375,11.0213108062745 49.1395797729493,11.0231914520264 49.1398048400879,11.0248918533325 49.137321472168,11.0235691070557 49.1367340087891,11.0285882949829 49.1369018554688,11.0300760269166 49.1350135803223,11.0358753204346 49.1350860595704,11.0378856658936 49.133430480957,11.0361022949219 49.1309089660645,11.0376129150391 49.1310997009278,11.0391569137573 49.1294746398925,11.0433959960939 49.1297607421874,11.0463857650757 49.1275062561036,11.0490713119507 49.1274032592774,11.0485515594482 49.126350402832,11.0513858795167 49.1249160766602,11.0573472976685 49.1248321533203,11.0587387084961 49.1266632080079,11.0540752410888 49.127540588379,11.0574436187744 49.1296195983888,11.059871673584 49.1274642944335,11.0653533935548 49.1297149658204))0.0006POINT(10.985082239474917 49.11303509406326)
17650POLYGON((7.7672691345216 44.8164138793946,7.75004816055298 44.816562652588,7.75004816055298 44.816562652588,7.75324106216436 44.8128471374512,7.76201009750366 44.8096694946289,7.75905513763433 44.7753639221193,7.75366020202637 44.7684364318848,7.73417806625366 44.750732421875,7.73297214508062 44.7450561523438,7.72999620437628 44.7424278259277,7.72608709335327 44.7429046630859,7.72608709335327 44.7429046630859,7.72713518142706 44.7376365661621,7.72713518142706 44.7376365661621,7.73552322387701 44.7384605407715,7.75283193588251 44.7317657470704,7.75283193588251 44.7317657470704,7.76768684387207 44.7402877807618,7.77371501922619 44.7522735595704,7.78771018981945 44.7556457519531,7.79402923583996 44.758472442627,7.78973817825317 44.7639198303224,7.79672384262085 44.7682991027833,7.80625200271606 44.7699928283693,7.81045007705683 44.76957321167,7.81513690948498 44.7653617858887,7.82587003707897 44.7651290893556,7.83226013183594 44.7667274475098,7.83812189102173 44.7631149291992,7.83812189102173 44.7631149291992,7.8401188850404 44.7689857482911,7.83801698684692 44.7732086181641,7.83727788925171 44.7817726135254,7.83727788925171 44.7817726135254,7.84099721908569 44.7861633300781,7.84099721908569 44.7861633300781,7.83338308334351 44.7868309020996,7.81857299804693 44.7954330444337,7.78998517990112 44.8028564453126,7.78570890426636 44.7999305725099,7.78141784667974 44.8019027709962,7.7672691345216 44.8164138793946))0.0006POINT(7.784382447963836 44.77034340835203)
47725POLYGON((2.15339636802685 50.4157295227052,2.14399242401134 50.4159774780274,2.13773822784435 50.407039642334,2.14421057701117 50.3948364257813,2.14421057701117 50.3948364257813,2.1549956798554 50.3949012756348,2.1549956798554 50.3949012756348,2.16427350044256 50.4037284851075,2.16427350044256 50.4037284851075,2.15339636802685 50.4157295227052))0.0006POINT(2.1513429482778665 50.40285322401264)
1401750POLYGON((-2.67614698410034 41.3924102783203,-2.64605998992914 41.3933143615723,-2.64053797721851 41.3858184814454,-2.63317608833307 41.3890914916993,-2.62119889259333 41.3899002075196,-2.60792589187616 41.3875236511232,-2.60016489028925 41.388874053955,-2.5976738929748 41.3915786743165,-2.59398388862604 41.3865547180177,-2.58826398849482 41.3852272033693,-2.58781504631042 41.3786621093751,-2.57134795188904 41.3786468505861,-2.56432104110718 41.3760070800781,-2.57726693153376 41.3343849182129,-2.58044409751892 41.3348236083984,-2.61545610427856 41.3234214782716,-2.62196993827814 41.3187904357911,-2.64809298515314 41.3335533142091,-2.65342593193049 41.3396301269531,-2.68747401237488 41.3452758789064,-2.69422101974482 41.3491592407227,-2.69312191009521 41.3618202209473,-2.69521903991699 41.3685264587402,-2.69268393516541 41.3760795593263,-2.67614698410034 41.3924102783203))0.0006POINT(-2.6286663512388513 41.367044766744044)
24887POLYGON((3.59879946708674 45.8615570068359,3.59524440765381 45.8557968139648,3.59743380546581 45.8496971130372,3.59743380546581 45.8496971130372,3.60001254081732 45.8439102172853,3.60001254081732 45.8439102172853,3.61323213577271 45.8404083251953,3.63188338279724 45.839973449707,3.64204716682445 45.8331794738771,3.64204716682445 45.8331794738771,3.6558029651643 45.8362159729005,3.68283367156994 45.849895477295,3.6898655891419 45.8619384765625,3.6898655891419 45.8619384765625,3.68973016738897 45.8748092651368,3.67314529418957 45.8775367736817,3.67726969718933 45.8973693847656,3.67726969718933 45.8973693847656,3.68458843231195 45.9092864990235,3.69464421272284 45.9169578552246,3.69401788711542 45.9307327270509,3.69401788711542 45.9307327270509,3.66504788398748 45.9191818237305,3.64653825759888 45.8987579345703,3.63871073722834 45.8944320678712,3.63647842407232 45.8842697143555,3.64111661911016 45.8750686645508,3.64111661911016 45.8750686645508,3.63361072540289 45.8703460693359,3.60895013809198 45.8691940307617,3.59879946708674 45.8615570068359))0.0006POINT(3.6477588971456254 45.872747039794966)
72106POLYGON((13.836935043335 48.2591743469238,13.8317966461183 48.2662315368652,13.8317966461183 48.2662315368652,13.863458633423 48.276653289795,13.863458633423 48.276653289795,13.887140274048 48.2800674438477,13.887140274048 48.2800674438477,13.899850845337 48.2553825378418,13.899850845337 48.2553825378418,13.8892974853516 48.2519111633301,13.8892974853516 48.2519111633301,13.8604097366334 48.2502784729004,13.8604097366334 48.2502784729004,13.836935043335 48.2591743469238))0.0006POINT(13.869295560396742 48.2630940950834)
46890POLYGON((2.98172473907482 50.562084197998,3.00588822364801 50.5484619140625,3.00783109664917 50.5416679382324,3.00783109664917 50.5416679382324,3.01440596580517 50.5323219299316,3.01440596580517 50.5323219299316,3.03930640220648 50.5182418823243,3.03930640220648 50.5182418823243,3.04934000968927 50.5284614562989,3.06311464309687 50.5310516357423,3.06311464309687 50.5310516357423,3.06890869140631 50.5563850402832,3.06890869140631 50.5563850402832,3.05492258071911 50.5600166320801,3.04083991050726 50.5690269470215,3.04256176948553 50.5720672607423,3.04256176948553 50.5720672607423,3.0398988723756 50.5729026794435,3.0398988723756 50.5729026794435,3.028463125229 50.5626640319824,3.02139163017284 50.5672073364258,3.02139163017284 50.5672073364258,3.01293325424194 50.5554237365723,2.98535919189459 50.5644798278809,2.98172473907482 50.562084197998))0.0006POINT(3.031429549058331 50.55142958958947)
63501POLYGON((12.1412925720215 53.4577369689942,12.1338720321655 53.457836151123,12.1312952041626 53.45658493042,12.1311159133912 53.4542045593262,12.121729850769 53.4561195373535,12.1098299026489 53.4478530883789,12.1055030822755 53.448097229004,12.0890140533448 53.4539031982421,12.0901689529419 53.4608154296875,12.0764055252075 53.4621734619141,12.0757780075073 53.4580993652343,12.0743732452394 53.4575576782227,12.0736351013184 53.4558982849122,12.0741920471192 53.4525184631348,12.0712985992432 53.4486808776855,12.061363220215 53.443244934082,12.0610265731812 53.4418106079102,12.0670166015626 53.4375457763672,12.0642528533936 53.4364395141602,12.0593948364258 53.4323310852051,12.0593948364258 53.4323310852051,12.0654535293579 53.4325485229492,12.0778827667236 53.4291114807129,12.0754041671753 53.4246101379396,12.0930185317994 53.4206619262696,12.0948810577393 53.4243164062501,12.1065864562989 53.4291610717773,12.1092739105225 53.4285774230958,12.1100120544434 53.4294204711915,12.1100120544434 53.4294204711915,12.1097888946534 53.4302978515625,12.1121473312379 53.4301872253418,12.1124725341798 53.4283752441406,12.1146793365479 53.4269866943361,12.1190013885498 53.4307518005371,12.1275072097778 53.4267387390137,12.1294364929199 53.4223442077636,12.1323862075806 53.4207420349122,12.1381235122681 53.420036315918,12.1385612487793 53.4220962524414,12.1407709121704 53.4220237731934,12.1415786743165 53.4210968017578,12.1467514038087 53.4201812744141,12.1445360183716 53.418483734131,12.1716251373292 53.4134559631348,12.1716251373292 53.4134559631348,12.1730947494508 53.4145126342774,12.1719951629639 53.4164505004883,12.1815605163575 53.4183082580568,12.1892395019531 53.41609954834,12.1892395019531 53.41609954834,12.1909952163696 53.4187088012696,12.1910829544067 53.4209899902344,12.1898174285889 53.4229049682618,12.1898088455201 53.4285430908203,12.1894407272338 53.4295425415039,12.1855430603028 53.4291648864747,12.1851062774658 53.4318885803223,12.1864614486695 53.4346466064453,12.1840066909791 53.4389305114746,12.1842393875123 53.4410667419434,12.1842393875123 53.4410667419434,12.159236907959 53.4419822692871,12.148889541626 53.4474716186523,12.1439867019654 53.4472389221192,12.1404504776001 53.4485092163087,12.1357421875001 53.4478149414062,12.1358022689819 53.4494323730469,12.1370525360109 53.4506568908692,12.135555267334 53.4557189941407,12.1413927078248 53.4559745788574,12.1420516967775 53.4566764831542,12.1412925720215 53.4577369689942))0.0006POINT(12.128493057356987 53.435934225718185)
28992POLYGON((3.53540754318249 46.9487876892091,3.52538895607006 46.9488182067871,3.51776647567755 46.9532814025879,3.49860692024237 46.9502868652344,3.480887889862 46.9567832946778,3.45552086830139 46.9582252502442,3.45146584510809 46.9561080932618,3.45146584510809 46.9561080932618,3.43773412704462 46.9654350280762,3.44205713272089 46.9777984619141,3.44205713272089 46.9777984619141,3.45483541488647 46.9721221923829,3.48495531082153 46.9762763977051,3.48966431617748 46.9777069091797,3.49611473083502 46.9910736083984,3.49611473083502 46.9910736083984,3.51797699928284 46.9834861755372,3.52370595932007 46.9746017456056,3.53346538543713 46.9758186340333,3.54689455032354 46.9717407226564,3.54689455032354 46.9717407226564,3.54669690132147 46.9587211608886,3.53540754318249 46.9487876892091))0.0006POINT(3.494348981163752 46.96789966930048)
43279POLYGON((7.07254886627209 48.2906837463379,7.06331968307506 48.2844505310059,7.06331968307506 48.2844505310059,7.09206008911144 48.2770004272461,7.09926223754888 48.2719039916993,7.09926223754888 48.2719039916993,7.1040673255921 48.2712135314941,7.104241847992 48.2744979858398,7.09981584548956 48.2835235595703,7.07254886627209 48.2906837463379))0.0006POINT(7.088655312856119 48.27884758843318)