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
180767POLYGON((8.48247528076172 46.5297241210938,8.46983623504644 46.5382194519044,8.46059989929211 46.53715133667,8.44848728179943 46.5404586791993,8.43597412109375 46.5452995300294,8.43041515350353 46.5504951477052,8.42448329925537 46.566291809082,8.4093189239502 46.5890388488771,8.41244983673101 46.6042404174804,8.41861534118658 46.610897064209,8.42429447174067 46.6300239562989,8.42172431945806 46.6366920471192,8.42266082763678 46.6522445678712,8.41813087463385 46.6558952331543,8.40981864929205 46.6556434631347,8.40981864929205 46.6556434631347,8.40729618072521 46.6687088012695,8.40063285827637 46.6733207702638,8.39874935150146 46.6769752502443,8.39774322509777 46.6852760314942,8.3989086151123 46.6945114135742,8.40287494659424 46.6953201293946,8.42307758331299 46.6907081604005,8.43628215789801 46.6894721984864,8.44452476501471 46.6904678344727,8.4523086547851 46.6944122314454,8.45353031158447 46.7014389038087,8.4520311355592 46.7123947143555,8.44728755950939 46.7182884216309,8.44819545745855 46.7335472106934,8.43963527679449 46.7410354614258,8.44149112701416 46.7499656677247,8.43960475921637 46.7554664611817,8.44412231445312 46.7579193115236,8.44739723205561 46.7660369873047,8.44739723205561 46.7660369873047,8.4590883255006 46.7711601257325,8.47711944580078 46.7708053588867,8.48960304260254 46.7750663757324,8.48875427246094 46.7827911376953,8.47850894927979 46.7926826477051,8.48040771484375 46.8001136779786,8.47781753540039 46.8007850646972,8.47232437133795 46.7987098693848,8.4674272537232 46.8015022277833,8.47616577148438 46.8034591674805,8.481598854065 46.8073348999025,8.48213768005377 46.8112983703613,8.47823047637939 46.8167419433594,8.48176956176752 46.8218078613282,8.48314762115484 46.8307266235352,8.48729610443121 46.8377380371094,8.50021457672113 46.8423347473146,8.50556468963634 46.8465614318847,8.50530433654791 46.8478698730469,8.49621009826672 46.8546943664551,8.4788551330567 46.8587265014648,8.47092914581293 46.8575363159179,8.47092914581293 46.8575363159179,8.46815109252935 46.8619918823243,8.46986103057867 46.8697242736817,8.46727466583263 46.8779640197754,8.47402763366699 46.8820114135742,8.47724723815912 46.8862380981446,8.46954631805414 46.8974723815919,8.45883178710938 46.8996696472169,8.45798873901367 46.9016647338868,8.46199798583996 46.9061164855957,8.47860240936285 46.9104232788086,8.48577404022217 46.9201507568359,8.49559783935541 46.9202919006348,8.50058841705317 46.917407989502,8.50447654724132 46.917163848877,8.51888561248785 46.9244117736816,8.54155731201183 46.9285125732422,8.54436111450195 46.9349784851075,8.54413986206049 46.9405899047852,8.55391025543219 46.9427604675293,8.55297374725347 46.9638633728027,8.55793476104736 46.9679565429689,8.56030178070068 46.9748420715333,8.56490802764904 46.976360321045,8.57109546661377 46.9815902709962,8.57144451141357 46.9894371032715,8.57144451141357 46.9894371032715,8.58971405029303 46.9937286376953,8.60087871551519 46.9928398132325,8.60972785949707 46.9888420104982,8.61251163482677 46.9725494384765,8.61256599426264 46.9565353393555,8.61441993713385 46.9546432495117,8.66486167907721 46.9463195800782,8.69034671783459 46.9487266540528,8.69759559631359 46.9387702941895,8.69612216949463 46.9308624267579,8.69692420959473 46.9272994995118,8.70691967010504 46.9208221435548,8.71805763244623 46.9227447509767,8.72707462310797 46.9300270080567,8.73624992370617 46.9348602294922,8.74372577667236 46.935516357422,8.76603507995605 46.9432182312013,8.77107429504389 46.9426879882813,8.77786254882824 46.9351348876954,8.78511714935297 46.9337844848634,8.79656887054438 46.936595916748,8.80360794067383 46.9426231384278,8.81046199798595 46.9422149658203,8.825439453125 46.9360160827636,8.8259038925172 46.9283752441407,8.82356357574463 46.9240760803223,8.8316583633424 46.9130439758301,8.83885192871099 46.9121131896973,8.84342765808117 46.9165229797364,8.84674072265619 46.9163398742677,8.84543895721447 46.8956260681152,8.8494920730592 46.8916015625001,8.8571662902832 46.894115447998,8.85838222503662 46.8986892700196,8.87275791168213 46.8986930847168,8.88100528717047 46.9055595397949,8.89095973968517 46.9067649841309,8.89808368682867 46.9111404418945,8.90634441375732 46.9124183654785,8.93120479583752 46.9229507446288,8.93120479583752 46.9229507446288,8.94070243835461 46.9074592590332,8.9486141204834 46.9031524658203,8.95276546478266 46.8898086547852,8.95192432403576 46.8818283081055,8.94921493530285 46.8787956237792,8.93823719024653 46.8757286071778,8.92739963531506 46.8694686889649,8.91319561004633 46.8643760681153,8.90328311920166 46.8633499145508,8.8936185836792 46.8544654846192,8.88262271881098 46.8518714904786,8.86875820159918 46.8458137512207,8.8725957870484 46.8390693664552,8.87681007385254 46.835620880127,8.87795829772961 46.8318176269531,8.87779903411877 46.8259391784669,8.87352371215832 46.8208198547363,8.87185668945318 46.8121261596681,8.87185668945318 46.8121261596681,8.85727977752697 46.8099174499513,8.85222911834717 46.8051414489747,8.84638214111328 46.8025054931641,8.8436489105224 46.79838180542,8.83336830139166 46.7989692687989,8.82666110992437 46.7960319519043,8.82786560058588 46.7771644592285,8.8323717117309 46.770923614502,8.82996940612793 46.7689781188965,8.82158184051519 46.7689170837403,8.81779384613037 46.7667999267578,8.81286144256586 46.7590751647949,8.8097648620606 46.7488822937013,8.81074810028088 46.743019104004,8.80847930908203 46.7410278320312,8.78223705291754 46.7328147888184,8.77395820617676 46.7398338317872,8.76783275604259 46.7477455139161,8.76377773284912 46.7483100891114,8.75265407562267 46.7427940368653,8.74676704406744 46.7372131347656,8.74542427062994 46.7319335937501,8.74781513214117 46.725357055664,8.74435043334967 46.7213897705078,8.72787189483643 46.7120895385743,8.71826457977289 46.7094993591309,8.71549034118652 46.7054290771485,8.7103013992309 46.7047042846681,8.70232677459722 46.70707321167,8.69320678710932 46.7067756652832,8.68800354003918 46.6996154785156,8.67892456054688 46.6983528137208,8.67575645446789 46.6962661743165,8.67514419555675 46.6766586303712,8.67962265014648 46.6715507507325,8.67969894409185 46.6685562133789,8.67070388793951 46.6620140075684,8.6620016098023 46.6590118408203,8.65869426727301 46.6556549072266,8.65806579589855 46.6535911560059,8.65995788574224 46.6514434814454,8.65906429290771 46.6475372314453,8.65347576141357 46.6395225524903,8.66022682189953 46.6316299438477,8.66709327697765 46.6269035339355,8.67877292633057 46.6229629516602,8.67918777465815 46.6037712097168,8.68402862548839 46.5948448181152,8.68037319183361 46.5841789245605,8.68037319183361 46.5841789245605,8.67307567596436 46.5833053588867,8.66390419006348 46.5788192749025,8.65763187408447 46.5737342834473,8.64150047302246 46.5693588256836,8.63519859313965 46.5707054138185,8.63077926635742 46.5795593261719,8.62483119964605 46.5824089050293,8.61893939971918 46.5829277038575,8.61059570312511 46.5791473388672,8.59435462951666 46.5783958435058,8.58515834808355 46.5817604064942,8.57733726501476 46.5870246887207,8.56904602050776 46.5852432250977,8.55427837371826 46.5855941772461,8.54267978668219 46.589324951172,8.53681945800781 46.5884552001953,8.53166389465343 46.5860214233399,8.52833366394054 46.5814437866212,8.52473068237305 46.5795860290527,8.52336120605474 46.5688056945802,8.51755905151373 46.5615348815919,8.52299308776867 46.5474967956542,8.52309036254888 46.5428657531739,8.5045251846314 46.5368843078614,8.4874267578125 46.5349159240723,8.48247528076172 46.5297241210938))0.0010POINT(8.637479886141723 46.77665691375732)
12967POLYGON((16.2775058746338 40.1998748779298,16.2970943450928 40.2019920349121,16.3003425598146 40.201156616211,16.3088722229004 40.2017173767091,16.3106460571289 40.2034339904786,16.3118438720704 40.2076263427734,16.3140754699708 40.210620880127,16.3179054260255 40.2124710083009,16.3334846496583 40.2147865295411,16.3370418548583 40.214641571045,16.3490390777588 40.2086410522462,16.3509159088135 40.2088356018066,16.3509159088135 40.2088356018066,16.3494281768799 40.2063941955567,16.36039352417 40.1882133483887,16.3771686553956 40.1800422668457,16.38138961792 40.1770896911622,16.38138961792 40.1770896911622,16.3780612945557 40.1767120361328,16.3698806762696 40.1716232299805,16.3673324584962 40.167579650879,16.367525100708 40.1626777648926,16.3750782012941 40.1540031433107,16.3786296844482 40.1526184082032,16.38436126709 40.1526107788087,16.38436126709 40.1526107788087,16.3751258850099 40.1474227905275,16.3751258850099 40.1474227905275,16.3738212585449 40.1481399536133,16.3689250946045 40.1467819213867,16.3625736236572 40.1425170898437,16.3594036102295 40.1378173828125,16.3582458496095 40.1352615356446,16.3589973449707 40.1348037719727,16.3589973449707 40.1348037719727,16.3513355255128 40.1243019104003,16.3513355255128 40.1243019104003,16.3484516143799 40.1236763000489,16.3429279327393 40.1203727722169,16.3409309387208 40.1154098510743,16.3204555511474 40.1058654785157,16.3161697387695 40.1062126159668,16.3151435852051 40.1070785522461,16.3153381347657 40.1083068847657,16.3071975708008 40.110034942627,16.282476425171 40.1089324951173,16.2776165008545 40.110050201416,16.2752285003663 40.0939636230469,16.272008895874 40.091236114502,16.267339706421 40.0918617248536,16.2583560943605 40.0989227294922,16.2542362213135 40.1070785522461,16.2542362213135 40.1070785522461,16.2674694061279 40.110050201416,16.2852973937989 40.1196174621583,16.2629566192626 40.1382713317871,16.2478866577148 40.1433563232422,16.2418327331542 40.1436882019044,16.2410697937011 40.1552734375001,16.2459983825685 40.1603317260743,16.2494335174561 40.1779098510743,16.2471866607666 40.1811828613282,16.2471866607666 40.1811828613282,16.2505016326904 40.1823768615723,16.2575950622559 40.1829414367676,16.2709465026856 40.1910591125488,16.2775058746338 40.1998748779298))0.0006POINT(16.319273399584258 40.154709035700044)
52719POLYGON((-0.0698567926883698 46.189151763916,-0.0959727540612221 46.1805839538574,-0.0959727540612221 46.1805839538574,-0.0984734818338779 46.1871833801271,-0.0984734818338779 46.1871833801271,-0.094755582511425 46.1893577575684,-0.102682814002037 46.2118072509766,-0.102682814002037 46.2118072509766,-0.07843878865242 46.2236671447754,-0.07843878865242 46.2236671447754,-0.0614186339080334 46.218116760254,-0.0520987771451473 46.2064895629883,-0.051582433283329 46.196517944336,-0.051582433283329 46.196517944336,-0.0698567926883698 46.189151763916))0.0006POINT(-0.08088788070848196 46.20018822806227)
37295POLYGON((1.07769703865057 49.0987968444824,1.07531464099878 49.1013565063477,1.08497619628918 49.1112327575684,1.08497619628918 49.1112327575684,1.1100177764892 49.0992546081544,1.13098931312572 49.099193572998,1.13962185382843 49.0952720642091,1.13962185382843 49.0952720642091,1.12045121192943 49.0842361450195,1.12045121192943 49.0842361450195,1.10639536380774 49.07918548584,1.10639536380774 49.07918548584,1.09619808197033 49.0865707397462,1.09551584720617 49.0932159423829,1.07769703865057 49.0987968444824))0.0006POINT(1.106330139296452 49.09416007995612)
1408636POLYGON((-2.83117198944086 42.3843193054199,-2.83204698562616 42.3797645568848,-2.83608293533314 42.3782768249512,-2.8415760993957 42.3777961730958,-2.84861397743214 42.380210876465,-2.85222911834711 42.3831977844238,-2.85085010528559 42.3853912353516,-2.85414791107172 42.3876838684083,-2.85645890235895 42.3863716125489,-2.86310505867004 42.3865699768068,-2.86956405639648 42.3820838928223,-2.87723493576044 42.3912887573242,-2.88184809684753 42.3942184448243,-2.88548111915588 42.3996963500977,-2.88036394119263 42.4068069458008,-2.85730004310608 42.4172286987304,-2.85059189796448 42.4120674133301,-2.85735893249506 42.4071769714357,-2.85460805892933 42.404842376709,-2.85415005683893 42.402671813965,-2.83465194702148 42.3911705017091,-2.83117198944086 42.3843193054199))0.0006POINT(-2.8556874366033203 42.39232544671926)
41101POLYGON((5.87243890762329 49.4716682434082,5.8561573028565 49.4525909423829,5.8561573028565 49.4525909423829,5.85998106002819 49.4503974914551,5.85114479064941 49.4422950744629,5.85114479064941 49.4422950744629,5.82950115203863 49.4567985534668,5.80468034744263 49.4598121643068,5.80163192749023 49.4626159667969,5.80163192749023 49.4626159667969,5.78569698333746 49.468002319336,5.78558921813976 49.4711074829102,5.78558921813976 49.4711074829102,5.78923892974865 49.4758071899414,5.78923892974865 49.4758071899414,5.82444429397583 49.4910888671876,5.82444429397583 49.4910888671876,5.83930683135998 49.4899787902832,5.85035181045538 49.4830207824708,5.86023569107067 49.4812850952148,5.87243890762329 49.4716682434082))0.0006POINT(5.825930285453849 49.46759872436528)
61198POLYGON((7.56191921234142 46.2791976928712,7.5539917945863 46.2840805053712,7.5416898727417 46.2806816101074,7.53340482711792 46.277042388916,7.53340482711792 46.277042388916,7.53775596618652 46.2722969055176,7.54464721679688 46.2714920043946,7.55138921737677 46.2682723999024,7.55151414871222 46.2722396850587,7.55350494384771 46.2752952575685,7.55743598937983 46.2780685424806,7.56191921234142 46.2791976928712))0.0006POINT(7.547332546927745 46.275973580100384)
70315POLYGON((10.1024656295776 51.257106781006,10.0991840362549 51.2552490234376,10.0970096588136 51.256332397461,10.0938053131105 51.253890991211,10.0934019088746 51.2524414062499,10.0900068283082 51.2520790100098,10.0861272811889 51.2498855590821,10.0860929489136 51.2457466125489,10.0787439346313 51.2467384338379,10.0747117996216 51.2456169128419,10.0702495574952 51.2460594177246,10.0703096389771 51.2439308166505,10.0703096389771 51.2439308166505,10.0789947509766 51.2427825927734,10.0789947509766 51.2427825927734,10.0839843750001 51.2443084716797,10.0951509475709 51.2426033020021,10.0966806411743 51.2398109436035,10.098180770874 51.2403640747071,10.0985870361328 51.2364807128906,10.1031160354614 51.2364959716797,10.1028280258179 51.2350273132324,10.1028280258179 51.2350273132324,10.1068267822266 51.2349433898927,10.1092624664306 51.2333297729493,10.1102180480958 51.2339019775392,10.1080532073975 51.2373466491699,10.1104764938354 51.2373123168946,10.1114492416383 51.2341384887695,10.1123361587524 51.2343215942382,10.1125268936157 51.2371749877931,10.1161727905274 51.236457824707,10.1189680099488 51.2382316589355,10.1236038208008 51.2391548156739,10.1262321472169 51.2367057800292,10.1261587142945 51.2351570129396,10.1311063766479 51.2329978942872,10.1317968368531 51.234447479248,10.1285047531129 51.235767364502,10.1247320175171 51.2397232055664,10.1285629272462 51.2409248352051,10.1285629272462 51.2409248352051,10.124291419983 51.2444458007812,10.1194982528686 51.2416877746582,10.1174564361573 51.2424812316895,10.1154222488404 51.2406044006348,10.1085348129273 51.2431335449219,10.1105089187622 51.246982574463,10.1086168289185 51.2469940185547,10.1083898544313 51.2484054565431,10.1112871170044 51.2482719421387,10.1108407974243 51.2501983642578,10.1138191223145 51.2505493164062,10.1118783950807 51.2529792785645,10.1080265045167 51.2540473937989,10.1137237548829 51.255126953125,10.1137237548829 51.255126953125,10.1122074127198 51.257164001465,10.1071252822877 51.2551765441896,10.1024656295776 51.257106781006))0.0006POINT(10.105638390880564 51.24357676101946)
20695POLYGON((7.4261612892152 48.6759948730468,7.42836427688604 48.686897277832,7.42836427688604 48.686897277832,7.39877223968512 48.6904602050782,7.39607906341558 48.6933784484864,7.39607906341558 48.6933784484864,7.38867950439459 48.6788444519044,7.38867950439459 48.6788444519044,7.39637851715099 48.6743087768555,7.39637851715099 48.6743087768555,7.4261612892152 48.6759948730468))0.0006POINT(7.4043936252594715 48.683331298828165)
70569POLYGON((11.0178298950196 51.2717857360841,11.0184202194214 51.2682647705079,11.004412651062 51.2669258117676,10.9997386932373 51.2641639709474,10.9991245269776 51.2624855041504,10.9961471557617 51.2603111267091,10.9961471557617 51.2603111267091,10.9846010208131 51.2668647766113,10.9846010208131 51.2668647766113,10.9859161376954 51.2692527770997,10.9875926971436 51.2691078186036,10.9926462173462 51.28031539917,10.9926939010621 51.2826347351075,10.9888067245484 51.2833213806153,10.9878406524658 51.291160583496,10.9882297515869 51.2980499267578,10.9882297515869 51.2980499267578,10.9905605316162 51.2932472229004,10.9957609176636 51.2897605895996,10.9962463378907 51.288185119629,10.9978103637696 51.2882385253907,10.9979009628296 51.2912902832032,11.0015335083008 51.2915153503418,11.0022525787355 51.2882499694824,11.0042819976807 51.2882843017579,11.0036172866821 51.283878326416,11.0097780227662 51.280559539795,11.0102663040162 51.2792968750001,11.0137310028077 51.2786140441896,11.0145158767701 51.2727432250977,11.0178298950196 51.2717857360841))0.0006POINT(10.99837446212773 51.27912445068364)