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
40321POLYGON((1.57635819911968 45.3670921325684,1.5739883184433 45.3678398132324,1.5739883184433 45.3678398132324,1.56519222259533 45.3556747436525,1.5234245061875 45.3555908203126,1.51514112949377 45.3471984863282,1.51514112949377 45.3471984863282,1.51820969581604 45.3408355712891,1.51204943656933 45.3314590454101,1.52797448635096 45.3139533996583,1.52797448635096 45.3139533996583,1.53732025623322 45.3206672668458,1.55571734905249 45.3117408752441,1.56015455722815 45.3059883117677,1.56015455722815 45.3059883117677,1.57128167152405 45.3234672546387,1.57998168468481 45.3217239379884,1.59330093860626 45.3250808715821,1.59330093860626 45.3250808715821,1.58487546443939 45.3547096252442,1.57635819911968 45.3670921325684))0.0006POINT(1.5532764673233357 45.33515415191657)
27481POLYGON((-0.987030744552555 49.0422668457031,-1.00074911117548 49.0255241394042,-1.00074911117548 49.0255241394042,-1.03985118865967 49.0246543884278,-1.03985118865967 49.0246543884278,-1.05819022655481 49.0217666625978,-1.05819022655481 49.0217666625978,-1.05646061897278 49.02836227417,-1.04304945468903 49.038818359375,-1.04735612869257 49.0483779907227,-1.04735612869257 49.0483779907227,-1.05560731887817 49.0547523498535,-1.05560731887817 49.0547523498535,-1.05916476249689 49.0578460693359,-1.05916476249689 49.0578460693359,-1.045445561409 49.0628662109375,-1.0416065454483 49.0693321228028,-1.05205178260798 49.0890121459962,-1.05205178260798 49.0890121459962,-1.04385900497431 49.0915298461915,-1.04288339614868 49.0972976684571,-1.04288339614868 49.0972976684571,-1.03387904167164 49.0961074829102,-1.02882170677179 49.0911903381348,-1.02882170677179 49.0911903381348,-1.03237891197205 49.0888099670411,-1.02672207355499 49.0834007263184,-1.01259183883667 49.0800476074219,-1.00159680843348 49.0689964294435,-0.992040693759861 49.066967010498,-0.992040693759861 49.066967010498,-0.998674094676971 49.0591735839845,-0.996079504489899 49.049861907959,-0.987030744552555 49.0422668457031))0.0006POINT(-1.03250929803556 49.061040936094386)
1399946POLYGON((-4.6783680915832 42.4138526916505,-4.6913161277771 42.4176902770997,-4.70326995849609 42.4156837463379,-4.70767116546631 42.4143676757812,-4.71681690216059 42.4057121276855,-4.72269916534424 42.4035148620606,-4.72869777679438 42.4051094055175,-4.73420190811152 42.4192276000977,-4.72559785842896 42.4237251281739,-4.73390579223633 42.427028656006,-4.73425006866449 42.4324493408204,-4.71966123580933 42.4408645629884,-4.71967315673828 42.4510917663574,-4.72333288192749 42.4541816711426,-4.72246217727661 42.4672241210938,-4.72415304183954 42.4712524414063,-4.72226810455311 42.4699211120607,-4.70103597640991 42.4737663269044,-4.69886398315424 42.4644699096681,-4.70011997222895 42.4641799926758,-4.69159078598022 42.4586601257325,-4.69004106521606 42.4543418884277,-4.68389177322382 42.4486694335939,-4.67712783813471 42.4344139099122,-4.67935705184931 42.4276695251465,-4.6845440864563 42.4226150512695,-4.68030691146845 42.4210052490236,-4.6783680915832 42.4138526916505))0.0006POINT(-4.707230550271465 42.43713661476423)
34697POLYGON((4.23867130279541 48.9633560180665,4.26420927047729 48.9458045959473,4.25914907455444 48.9364395141602,4.27210283279419 48.9213027954102,4.27115917205811 48.9178771972656,4.26645374298101 48.9163093566895,4.26138782501232 48.9172973632812,4.24248123168957 48.9290313720704,4.23210334777843 48.9277114868165,4.23210334777843 48.9277114868165,4.23142957687372 48.9332656860353,4.22372102737438 48.9351806640626,4.22372102737438 48.9351806640626,4.23084974288952 48.9398994445801,4.21866750717174 48.9542808532715,4.23134469985968 48.9596633911133,4.23134469985968 48.9596633911133,4.23867130279541 48.9633560180665))0.0006POINT(4.2429940840777824 48.93646913416251)
39260POLYGON((3.81083273887634 44.1285552978516,3.79699516296381 44.1273880004883,3.79699516296381 44.1273880004883,3.79528927803045 44.1206779479981,3.7828352451325 44.1100387573242,3.75188875198364 44.09379196167,3.75188875198364 44.09379196167,3.74752140045166 44.0779190063478,3.74752140045166 44.0779190063478,3.75417423248291 44.074001312256,3.75417423248291 44.074001312256,3.76823759078974 44.0753440856935,3.77924585342419 44.0814781188964,3.79635500907909 44.0754241943361,3.80112338066112 44.0753593444825,3.80523037910467 44.0770950317383,3.80191254615778 44.0835266113281,3.80686902999878 44.0931663513184,3.81046056747437 44.0954284667969,3.82281470298773 44.09037399292,3.82281470298773 44.09037399292,3.81899499893188 44.0965690612793,3.82159852981573 44.1030311584472,3.81083273887634 44.1285552978516))0.0006POINT(3.7889466804007017 44.093158390211066)
61192POLYGON((7.0028018951416 46.2276763916017,7.00765323638927 46.2233123779298,7.00765323638927 46.2233123779298,7.00232696533214 46.2192115783693,7.00068283081066 46.2166023254395,7.00010585784918 46.2124557495118,6.99739885330206 46.2088279724122,6.99739885330206 46.2088279724122,6.9895977973938 46.2030601501465,6.9891471862793 46.195686340332,6.98723697662359 46.1930351257325,6.98008918762207 46.1902160644531,6.97283220291149 46.1840400695801,6.96681594848633 46.1824417114258,6.9607720375061 46.1760787963867,6.95266103744518 46.1752090454102,6.95266103744518 46.1752090454102,6.95334911346447 46.1804046630861,6.95262908935547 46.1838912963867,6.95058822631836 46.189582824707,6.94619798660278 46.1965332031251,6.94645023345959 46.1983680725098,6.94894313812256 46.2005004882812,6.94894313812256 46.2005004882812,6.94881677627569 46.2086906433107,6.94881677627569 46.2086906433107,6.95609092712414 46.2098045349122,6.96177387237555 46.2153396606445,6.96177387237555 46.2153396606445,6.9683690071106 46.2182960510254,6.97487592697149 46.2237434387208,6.98595285415661 46.2231216430665,6.99251079559326 46.2259216308594,6.99926614761358 46.2263412475587,7.0028018951416 46.2276763916017))0.0006POINT(6.973917147692566 46.2041256848504)
58928POLYGON((6.5748810768128 50.6405448913575,6.57387208938604 50.6437797546387,6.5757265090943 50.644817352295,6.57047176361095 50.6486587524415,6.57032346725458 50.6504173278809,6.57224130630505 50.6510429382325,6.57190656661999 50.6526603698732,6.56949329376215 50.6532096862794,6.5666527748109 50.6563110351563,6.5666527748109 50.6563110351563,6.58196258544916 50.6635551452636,6.58130455017101 50.6666679382324,6.58455419540411 50.6691665649415,6.58904266357422 50.6685600280762,6.58807468414318 50.6699600219727,6.59342861175537 50.6693496704103,6.59402799606323 50.6704864501954,6.60140800476074 50.6732215881349,6.60126781463634 50.6777725219727,6.59925127029419 50.677375793457,6.59532165527338 50.6857032775879,6.59216260910028 50.688705444336,6.59372043609625 50.6892433166505,6.59248113632214 50.6904907226564,6.59653472900396 50.6927375793456,6.59230470657349 50.6968383789062,6.59230470657349 50.6968383789062,6.59197521209717 50.699520111084,6.5853528976441 50.6994514465332,6.59017944335938 50.7086105346681,6.59426116943365 50.7099838256837,6.60379886627197 50.7108459472657,6.61277532577515 50.7141990661622,6.61143016815186 50.7163696289063,6.62235879898077 50.722438812256,6.61956453323364 50.7245826721191,6.6298298835755 50.7321128845215,6.64077091217041 50.727108001709,6.66380023956305 50.7208061218262,6.67808532714855 50.7145233154298,6.70045280456549 50.7313880920411,6.69341945648199 50.7354621887206,6.70020532608032 50.7406959533692,6.69595241546642 50.7442665100098,6.69721460342413 50.7448043823243,6.69529247283947 50.7469596862793,6.69988441467279 50.7495040893555,6.69382238388062 50.7538299560548,6.69382238388062 50.7538299560548,6.69670391082764 50.7557640075684,6.6992588043214 50.7535209655763,6.70443630218506 50.7546463012695,6.70462942123419 50.7522735595704,6.71577501296991 50.7537117004396,6.72322988510143 50.7467193603516,6.7087984085083 50.7361221313476,6.71303844451916 50.7321624755859,6.71824312210089 50.7325744628907,6.72764921188366 50.7300148010254,6.73571920394903 50.7302780151367,6.74599075317388 50.7285842895508,6.74816989898682 50.7293777465821,6.76637220382696 50.7225761413575,6.76636695861822 50.7206954956055,6.77643156051641 50.7187042236329,6.77643156051641 50.7187042236329,6.77057552337641 50.7051544189454,6.76334905624401 50.6941070556642,6.76334905624401 50.6941070556642,6.75577354431158 50.6960639953614,6.75635337829596 50.6972541809083,6.74720191955566 50.6994247436524,6.73245620727545 50.7007408142089,6.73036813735973 50.6963844299316,6.72761631011969 50.6979598999025,6.71019744873047 50.6838035583496,6.71136283874517 50.6809768676759,6.72270154953009 50.6752662658692,6.72575807571423 50.6769180297852,6.72595548629755 50.6781578063965,6.73279762268072 50.6770095825195,6.72532463073742 50.6706352233887,6.72811269760138 50.6695556640624,6.72166299819946 50.6597023010255,6.72006988525391 50.652702331543,6.71610832214361 50.6534805297853,6.71293735504156 50.6500358581543,6.71184349060059 50.6457023620606,6.71230220794683 50.643367767334,6.71230220794683 50.643367767334,6.70532894134533 50.6426963806153,6.70362281799322 50.6446838378907,6.69937801361095 50.6461753845216,6.68480634689342 50.6460647583009,6.68229913711548 50.6406745910645,6.6681365966798 50.6305847167969,6.65780782699596 50.6366386413575,6.64910459518433 50.6334304809571,6.64714431762695 50.6348686218262,6.64327096939087 50.6330451965332,6.63606595993053 50.6333198547364,6.63382816314709 50.6343421936036,6.62805128097534 50.6328926086426,6.63075351715094 50.6379241943359,6.62470722198492 50.6410369873047,6.62372303009033 50.642417907715,6.62828254699713 50.6446189880372,6.62406158447277 50.6462402343751,6.62582826614391 50.6475410461426,6.62224197387701 50.6500892639161,6.62680482864374 50.6521797180176,6.62582111358643 50.6529464721681,6.61338376998913 50.6506500244142,6.61468887329102 50.6493835449219,6.60804510116583 50.6458702087402,6.59359836578381 50.6412239074708,6.58474063873297 50.6432762145997,6.5748810768128 50.6405448913575))0.0006POINT(6.6610672942594 50.68494738065281)
1400382POLYGON((-5.68451690673828 41.0707397460938,-5.68844413757319 41.0657691955566,-5.68981218338013 41.0672225952148,-5.69643497467035 41.066219329834,-5.69941616058344 41.0640335083008,-5.70120096206665 41.0654335021973,-5.70492219924915 41.0651016235351,-5.70712423324579 41.0659675598144,-5.70653104782104 41.0694885253906,-5.70898103713989 41.0685920715333,-5.71039485931391 41.0653533935547,-5.71305179595947 41.0662956237794,-5.71248722076416 41.0647087097169,-5.71893882751465 41.0650672912598,-5.72388505935663 41.0666618347169,-5.72759723663324 41.0623321533204,-5.72961521148676 41.063087463379,-5.72850894927979 41.0654106140137,-5.7301459312439 41.0661010742188,-5.73676013946528 41.0652160644532,-5.73815917968744 41.0765304565431,-5.73362398147577 41.0788459777833,-5.73537588119507 41.0814781188965,-5.72684288024902 41.0921707153321,-5.7254319190979 41.0954551696778,-5.72653293609619 41.0973510742188,-5.72463178634638 41.0979957580568,-5.7243862152099 41.1012725830079,-5.72927522659302 41.107162475586,-5.72617816925043 41.1074180603027,-5.72724390029907 41.1116256713868,-5.72129583358765 41.1108856201171,-5.71592378616333 41.114601135254,-5.71265077590942 41.1126365661622,-5.70656776428217 41.1118621826172,-5.70169305801386 41.1088409423828,-5.70106410980219 41.1100196838378,-5.68980693817133 41.1102447509766,-5.68771886825562 41.1081314086915,-5.68513488769526 41.1098747253418,-5.6866512298584 41.111400604248,-5.6833119392395 41.113063812256,-5.67908620834345 41.1101989746094,-5.67926788330078 41.1073226928711,-5.67732906341553 41.1073684692383,-5.68195819854736 41.1040878295899,-5.68081808090199 41.099494934082,-5.68305206298822 41.0990447998048,-5.68291711807245 41.0963287353517,-5.68590497970575 41.0928344726563,-5.68439579010004 41.0908737182617,-5.68642902374262 41.0832061767579,-5.68439388275146 41.0829467773438,-5.68571615219116 41.0779724121094,-5.68743515014643 41.0772171020508,-5.68597984313953 41.0762443542482,-5.68653011322021 41.0730781555176,-5.68485212326044 41.072551727295,-5.68621110916132 41.0714111328125,-5.68451690673828 41.0707397460938))0.0006POINT(-5.70424656140599 41.08660765825695)
54694POLYGON((4.69585084915161 44.7105941772462,4.71409797668468 44.7122383117675,4.71409797668468 44.7122383117675,4.72509956359869 44.7267303466797,4.72509956359869 44.7267303466797,4.709954738617 44.7479629516603,4.7052516937257 44.748722076416,4.69349813461304 44.7432098388673,4.69349813461304 44.7432098388673,4.69060230255127 44.720012664795,4.69585084915161 44.7105941772462))0.0006POINT(4.70670509338384 44.72916488647465)
52077POLYGON((-0.570848643779641 45.5413208007812,-0.541422247886658 45.5431213378907,-0.541422247886658 45.5431213378907,-0.546787142753601 45.5375518798829,-0.543318748474007 45.5280342102051,-0.543318748474007 45.5280342102051,-0.560248494148254 45.5114822387696,-0.565125286579132 45.5117568969727,-0.565125286579132 45.5117568969727,-0.560842394828796 45.5349159240723,-0.560842394828796 45.5349159240723,-0.570455312728882 45.5354118347169,-0.570848643779641 45.5413208007812))0.0006POINT(-0.5558130790789637 45.53011862436936)