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
55351POLYGON((6.57120752334606 45.9910507202148,6.58585119247437 46.0008354187013,6.58557033538813 46.0149803161621,6.5935783386231 46.0238761901857,6.59185886383068 46.0343971252443,6.59702491760265 46.0403633117676,6.59702491760265 46.0403633117676,6.5984230041505 46.0435256958008,6.60770082473766 46.0444564819336,6.60770082473766 46.0444564819336,6.61686944961548 46.0431289672852,6.62921905517589 46.0162849426271,6.66494846344006 46.0031738281251,6.68468379974371 46.0061912536621,6.69458246231085 46.0046806335449,6.71062135696417 45.9960250854492,6.7226552963258 45.9846305847167,6.7226552963258 45.9846305847167,6.72270441055298 45.984401702881,6.72270441055298 45.984401702881,6.70581769943249 45.9800186157227,6.69231748580938 45.972110748291,6.69231748580938 45.972110748291,6.6919088363648 45.9825897216798,6.67766952514648 45.9856491088868,6.66264104843151 45.9858131408691,6.66021156311029 45.9794273376466,6.65533971786505 45.9784927368164,6.61694860458374 45.9843521118163,6.60038900375378 45.9763259887696,6.57647371292114 45.9817428588867,6.57647371292114 45.9817428588867,6.56962251663208 45.9851608276367,6.57120752334606 45.9910507202148))0.0006POINT(6.6425974441297715 46.00095124678181)
19155POLYGON((10.6250629425049 44.1213188171388,10.6297006607056 44.118507385254,10.6297006607056 44.118507385254,10.6266832351685 44.1173858642579,10.6179828643799 44.1191673278809,10.6102838516236 44.1172676086426,10.6077022552491 44.1128463745118,10.6079130172729 44.1104888916016,10.6095266342163 44.1078186035157,10.6090545654297 44.1023864746094,10.6017122268677 44.0913963317871,10.5987205505372 44.0888748168945,10.5934982299804 44.0879020690919,10.5913619995118 44.0745849609375,10.5814304351807 44.0657615661622,10.5763216018677 44.0577545166016,10.563645362854 44.0427284240724,10.5567197799684 44.0319442749025,10.5498514175414 44.0250129699708,10.5404672622682 44.0186424255372,10.5404672622682 44.0186424255372,10.5356330871582 44.0208168029786,10.5287094116211 44.0200080871583,10.5045118331909 44.0229225158691,10.5000276565552 44.0259170532227,10.4937458038331 44.0331878662109,10.4937458038331 44.0331878662109,10.4920673370361 44.0379028320312,10.4920673370361 44.0379028320312,10.499942779541 44.0428848266602,10.5012969970704 44.0485496520996,10.5144424438477 44.0637702941895,10.5294246673584 44.0734825134277,10.532431602478 44.0777282714845,10.5387811660766 44.0952682495118,10.5445613861085 44.1066246032716,10.5709047317506 44.1195716857911,10.5759229660035 44.1212310791017,10.5844955444337 44.1212196350098,10.5844955444337 44.1212196350098,10.594108581543 44.1163711547852,10.6012716293336 44.115821838379,10.6060905456544 44.1156425476074,10.6108455657959 44.1195640563965,10.6108455657959 44.1195640563965,10.6250629425049 44.1213188171388))0.0006POINT(10.566848373413125 44.07909554375548)
1398108POLYGON((-3.97628498077387 40.0013847351075,-3.98064494132996 40.0014724731446,-3.98137593269348 39.9969863891601,-3.99536800384521 39.9932022094727,-3.9968221187591 39.9869613647462,-4.00357484817505 39.9849052429199,-4.01168012619019 39.985824584961,-4.0143637657165 39.9804420471193,-4.02109909057612 39.9844551086427,-4.02203607559204 39.9867782592774,-4.01975679397577 39.9878005981446,-4.02670097351074 39.9948387145996,-4.02392292022705 39.9970626831055,-4.02665805816639 39.9996871948242,-4.0236930847168 40.0027580261232,-4.02634620666504 40.0047607421876,-4.02724409103394 40.0036926269531,-4.02949810028076 40.0047149658204,-4.02952480316162 40.0093154907227,-4.03551197051996 40.0089797973634,-4.03598022460926 40.012767791748,-4.03182315826416 40.0144424438477,-4.0306191444397 40.0123443603516,-4.02752876281733 40.0132560729982,-4.03188180923462 40.0276832580567,-4.03530979156488 40.0287895202637,-4.03946018218994 40.0328178405762,-4.02288103103638 40.0370712280273,-4.02600812911987 40.0377464294434,-4.02686786651611 40.0411071777344,-4.02176713943476 40.0448684692382,-4.01763486862177 40.0429916381836,-4.01180505752558 40.0426139831544,-4.00528192520142 40.0375213623047,-4.00092887878412 40.040382385254,-3.99455904960632 40.0399398803711,-3.97965288162231 40.0419578552246,-3.97957801818848 40.0432281494141,-3.97637104988092 40.0427970886231,-3.97201108932495 40.047691345215,-3.95782995223999 40.0421409606934,-3.95652198791504 40.034954071045,-3.96034193038929 40.034049987793,-3.954509973526 40.0209236145019,-3.9769139289856 40.0134506225586,-3.97493505477905 40.0094833374024,-3.97628498077387 40.0013847351075))0.0006POINT(-4.006980647211466 40.016370524530856)
1406634POLYGON((-0.602047026157322 39.2296333312988,-0.636605978011971 39.2378273010254,-0.6626740097999 39.2517166137696,-0.690137982368469 39.262622833252,-0.687469005584717 39.2666511535645,-0.675863981246948 39.2618598937988,-0.662599027156773 39.2655143737794,-0.644550979137421 39.2663040161133,-0.609498023986816 39.2742843627931,-0.591674983501377 39.2751960754395,-0.56647002696991 39.2793655395508,-0.564459979534092 39.2751617431641,-0.560568988323098 39.2726631164552,-0.564368009567261 39.2673759460449,-0.561945974826756 39.2647743225098,-0.56314700841898 39.26322555542,-0.562045991420689 39.2608680725098,-0.556573987007027 39.2605895996094,-0.551038026809636 39.2640953063964,-0.547635018825531 39.2643203735353,-0.540288984775486 39.2596435546875,-0.556756019592285 39.2536392211915,-0.560391008853799 39.2477264404298,-0.565729022026062 39.2448348999024,-0.572161018848419 39.2434310913086,-0.602047026157322 39.2296333312988))0.0006POINT(-0.5942680025100298 39.260532989501996)
48089POLYGON((-2.01767301559443 47.2804069519044,-2.02176356315607 47.2746810913086,-2.01784634590149 47.2609939575195,-2.0229856967926 47.2550239562989,-2.0153350830077 47.2424850463867,-2.0193789005279 47.2150306701661,-2.00546956062317 47.2055664062501,-2.00576543807983 47.1986503601075,-2.0022354125976 47.1961326599122,-1.99735844135279 47.1972007751465,-1.99735844135279 47.1972007751465,-1.99717330932617 47.1973457336426,-1.99717330932617 47.1973457336426,-1.99364399909973 47.2052268981934,-1.99364399909973 47.2052268981934,-1.97256672382349 47.2296447753907,-1.96227550506586 47.2534217834473,-1.95046365261072 47.2691421508788,-2.00651907920837 47.2868766784669,-2.01049351692194 47.2845764160157,-2.01049351692194 47.2845764160157,-2.01767301559443 47.2804069519044))0.0006POINT(-2.0008388814471667 47.23508362543019)
1406954MULTIPOLYGON(((-6.30984401702881 38.7989730834962,-6.319580078125 38.8009147644044,-6.33188104629511 38.7998046875,-6.30910778045649 38.8240928649902,-6.30781316757202 38.8302078247071,-6.29596614837641 38.8437690734863,-6.2855339050293 38.8348655700684,-6.27691888809204 38.8323402404786,-6.26215696334839 38.8344573974609,-6.25184202194214 38.8312339782715,-6.24427509307861 38.8319931030273,-6.22870397567738 38.8414154052735,-6.22223615646357 38.8377304077148,-6.21396684646601 38.8372459411621,-6.19616508483881 38.8319244384767,-6.18821287155146 38.8171157836914,-6.18209600448608 38.8170394897462,-6.18381404876703 38.8103981018066,-6.19742298126221 38.7864494323732,-6.19627904891956 38.785587310791,-6.19808197021484 38.7806053161621,-6.20664215087891 38.781063079834,-6.22033309936523 38.7865791320801,-6.23396205902094 38.7942352294922,-6.23736906051636 38.7980422973633,-6.26109790801996 38.7983894348145,-6.29126882553101 38.8013725280761,-6.30975723266602 38.805606842041,-6.30984401702881 38.7989730834962)),((-6.2969918251037 38.7531776428223,-6.29455804824829 38.7660217285156,-6.30997419357294 38.7736930847169,-6.31767702102661 38.7606468200684,-6.32611179351807 38.7616577148438,-6.34703493118286 38.7706565856933,-6.35732889175415 38.7715301513672,-6.35701704025263 38.7781410217285,-6.34325981140137 38.7898483276367,-6.30177307128906 38.7805480957031,-6.27828693389893 38.7773437500001,-6.26924800872797 38.7736854553224,-6.26876497268677 38.7678985595703,-6.27075910568237 38.7654457092286,-6.2969918251037 38.7531776428223)))0.0006POINT(-6.2627055395953 38.803565881390966)
33401POLYGON((4.53089380264288 49.6052131652832,4.54622364044189 49.6003608703614,4.54622364044189 49.6003608703614,4.5516028404237 49.5921325683594,4.55024194717407 49.5864334106445,4.55024194717407 49.5864334106445,4.53061151504517 49.585548400879,4.52098941802984 49.5990829467774,4.52098941802984 49.5990829467774,4.53089380264288 49.6052131652832))0.0006POINT(4.53866868548926 49.59496095445425)
17450POLYGON((7.37374591827398 44.3781471252442,7.37779283523571 44.3852043151856,7.38774013519298 44.3904457092286,7.38978815078741 44.3930625915528,7.38978815078741 44.3930625915528,7.41918516159063 44.3942489624023,7.42289209365845 44.3971557617188,7.43345880508429 44.4004135131837,7.46431303024292 44.4047584533693,7.47340393066418 44.4068298339844,7.47712087631231 44.4093246459961,7.47864389419567 44.4121475219727,7.48506307601929 44.4162750244142,7.48506307601929 44.4162750244142,7.48645305633556 44.4154434204102,7.48814487457287 44.4122314453126,7.4900422096253 44.4065475463868,7.48420000076305 44.3990173339844,7.47870492935181 44.3954582214355,7.46203279495234 44.3907356262208,7.45088100433361 44.3720359802246,7.44749307632452 44.3692817687989,7.43225288391125 44.363380432129,7.43242883682251 44.3605346679688,7.43242883682251 44.3605346679688,7.42744588851929 44.3590621948243,7.41991806030285 44.3588523864746,7.41498899459845 44.3609046936035,7.40682888031017 44.360912322998,7.40682888031017 44.360912322998,7.39923286437994 44.3613433837892,7.39413785934448 44.3632583618165,7.38532209396368 44.3678703308106,7.38097715377808 44.3728637695312,7.37374591827398 44.3781471252442))0.0006POINT(7.434668891570205 44.385545057409004)
20793POLYGON((7.56759834289551 48.8013610839844,7.55003261566168 48.7993202209473,7.54650068283087 48.8011932373047,7.54650068283087 48.8011932373047,7.54256486892712 48.8125152587892,7.54256486892712 48.8125152587892,7.54254341125483 48.8272895812989,7.54254341125483 48.8272895812989,7.54498767852789 48.8257446289062,7.54498767852789 48.8257446289062,7.54752635955805 48.8196678161622,7.56984663009655 48.814868927002,7.56984663009655 48.814868927002,7.57374572753918 48.8094062805177,7.56759834289551 48.8013610839844))0.0006POINT(7.552270684923495 48.813784190586674)
16410POLYGON((9.04762363433832 45.2731895446777,9.03479003906261 45.2743492126465,9.03479003906261 45.2743492126465,9.03481960296631 45.2686958312989,9.03951930999767 45.2571525573732,9.0424308776856 45.2536582946778,9.0424308776856 45.2536582946778,9.05538558959961 45.2504310607911,9.05538558959961 45.2504310607911,9.06095504760748 45.2573776245118,9.06095504760748 45.2573776245118,9.06247138977062 45.2648391723634,9.06113719940191 45.2674942016602,9.05373287200928 45.2680473327636,9.04823303222656 45.2717514038087,9.04762363433832 45.2731895446777))0.0006POINT(9.048977343241416 45.26285349528)