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
1404728POLYGON((-3.59346294403076 40.6548042297363,-3.5970520973205 40.6580200195314,-3.6015949249267 40.6697616577148,-3.60129404067993 40.6733016967775,-3.60485601425165 40.6797332763672,-3.60074496269215 40.6962738037109,-3.60206007957458 40.6966285705567,-3.60336089134211 40.7109375,-3.60702109336853 40.7150535583496,-3.60808110237116 40.7143898010255,-3.6056489944458 40.7205200195313,-3.59509706497187 40.7254371643067,-3.59171891212463 40.7289695739746,-3.5934851169585 40.7507057189941,-3.58733010292042 40.7482261657715,-3.58265709877003 40.7505912780762,-3.5766589641571 40.7500267028809,-3.57203388214106 40.7439765930177,-3.56180095672607 40.7438468933105,-3.55563998222351 40.7380867004394,-3.54748797416687 40.7345542907715,-3.54409003257746 40.7346153259278,-3.53932595252985 40.7328300476075,-3.53066611289972 40.7340469360352,-3.52576589584345 40.7327575683594,-3.52818393707275 40.713665008545,-3.53207397460938 40.7114143371582,-3.54400300979614 40.6922149658203,-3.54695892333984 40.6917228698732,-3.55320596694946 40.687126159668,-3.55531191825861 40.6827850341797,-3.55343198776245 40.6802787780763,-3.55518507957458 40.6689643859864,-3.55449390411366 40.6668663024903,-3.550230026245 40.6649169921876,-3.55632400512695 40.6623840332032,-3.55577492713928 40.6503295898438,-3.56669211387629 40.6503677368165,-3.56814789772034 40.6435432434082,-3.57777094840998 40.645809173584,-3.58416390419001 40.6451225280762,-3.58466291427607 40.6535339355469,-3.58933305740356 40.6558837890626,-3.59346294403076 40.6548042297363))0.0006POINT(-3.571741481159971 40.69779125479768)
13650POLYGON((14.292239189148 41.0508422851562,14.2920761108398 41.0517730712891,14.2920761108398 41.0517730712891,14.2886600494384 41.0530052185059,14.287733078003 41.0582313537598,14.2791681289673 41.0634574890138,14.2750520706177 41.0634994506837,14.275019645691 41.0444869995118,14.275019645691 41.0444869995118,14.2791385650635 41.0443954467774,14.2791385650635 41.0443954467774,14.2834196090699 41.0445213317872,14.2838039398193 41.0508117675781,14.292239189148 41.0508422851562))0.0006POINT(14.283272669865557 41.051206148587795)
23043POLYGON((-1.53558564186096 43.460807800293,-1.54009032249445 43.447364807129,-1.54009032249445 43.447364807129,-1.54304337501526 43.4471664428712,-1.54304337501526 43.4471664428712,-1.55633068084717 43.4483032226564,-1.5770839452743 43.4631958007814,-1.5770839452743 43.4631958007814,-1.57541596889496 43.4645843505859,-1.57569396495819 43.4659729003907,-1.57347202301025 43.4673614501954,-1.56986105442041 43.4723625183106,-1.56680500507343 43.4787483215333,-1.5665270090102 43.4798622131349,-1.56763899326324 43.4809722900391,-1.56986105442041 43.4813041687012,-1.56903386116022 43.4829177856445,-1.57014000415796 43.4840278625489,-1.56041705608368 43.4840278625489,-1.55347204208368 43.4906959533692,-1.55347204208368 43.4923629760743,-1.55485999584198 43.4926376342773,-1.55569398403162 43.4940261840821,-1.55263805389404 43.4945831298829,-1.55124998092646 43.493480682373,-1.54891240596771 43.4937515258789,-1.54891240596771 43.4937515258789,-1.53544223308563 43.485164642334,-1.53558564186096 43.460807800293))0.0006POINT(-1.5582810980932724 43.4748986107963)
1389082POLYGON((-5.67953300476074 37.951873779297,-5.67968988418573 37.9562263488769,-5.67074680328369 37.9565811157227,-5.66278314590448 37.9594726562501,-5.66063022613525 37.9622344970703,-5.66604709625244 37.9757728576661,-5.67163991928095 37.9787178039552,-5.67276096343988 37.9835586547853,-5.66994190216064 37.9889907836914,-5.67054605484009 37.9943466186524,-5.66553688049311 37.9978408813478,-5.66584205627436 38.0062675476075,-5.65879487991333 38.0116348266601,-5.6492772102356 38.0089225769043,-5.63575077056885 38.0089836120606,-5.62945079803455 38.0143432617188,-5.61506700515741 38.0207633972169,-5.60259819030756 38.0144233703613,-5.60338020324701 38.00883102417,-5.60059309005737 38.0001869201661,-5.59942102432251 37.9866714477539,-5.58909702301025 37.9867362976074,-5.57625389099121 37.9812240600587,-5.60129880905146 37.9637794494629,-5.61672687530518 37.9501724243165,-5.62978410720825 37.9455642700196,-5.65257692337036 37.9431076049806,-5.65847110748285 37.9472007751466,-5.674232006073 37.9540977478028,-5.67953300476074 37.951873779297))0.0006POINT(-5.642361098322349 37.98132850383897)
44275POLYGON((0.137459442019576 43.4339904785157,0.166064128279743 43.4423789978027,0.166064128279743 43.4423789978027,0.173403263092155 43.4360885620118,0.173403263092155 43.4360885620118,0.173636168241558 43.4341125488282,0.173636168241558 43.4341125488282,0.156431779265517 43.4235458374023,0.147514343261832 43.4242897033692,0.142631784081402 43.4328231811524,0.138111382722968 43.4330558776856,0.138111382722968 43.4330558776856,0.137459442019576 43.4339904785157))0.0006POINT(0.15720560277509793 43.43382676442468)
60443POLYGON((7.9197359085083 47.2002716064454,7.91790819168097 47.2023315429689,7.91190385818481 47.2030982971191,7.91190385818481 47.2030982971191,7.90114593505859 47.2005844116212,7.89197921752941 47.2049064636232,7.89567279815668 47.2080154418946,7.90159511566173 47.2085876464844,7.90613508224482 47.2109107971191,7.90675783157354 47.2134666442872,7.90611696243286 47.216480255127,7.90228986740124 47.2192573547363,7.89379119873058 47.222885131836,7.88544321060186 47.223258972168,7.87948513031017 47.225040435791,7.87774085998535 47.2259063720703,7.87527990341192 47.2293014526367,7.87194299697882 47.2311477661134,7.87019491195679 47.2304992675782,7.86979389190674 47.2275352478028,7.8646621704101 47.2263412475587,7.85934591293341 47.2213363647462,7.85981178283691 47.2201538085938,7.86381483078003 47.2181930541993,7.86450386047358 47.2123603820802,7.86939716339111 47.2084426879884,7.86939716339111 47.2084426879884,7.87639093399059 47.2069473266603,7.8817081451416 47.2027397155762,7.89123392105097 47.203685760498,7.89030694961554 47.1996459960938,7.89175176620495 47.1972007751465,7.89915704727173 47.1951637268067,7.90305089950562 47.1912689208986,7.91713190078735 47.1910781860353,7.91922092437738 47.1900711059571,7.91961193084728 47.1882972717286,7.91961193084728 47.1882972717286,7.92222595214855 47.1867523193359,7.93009805679333 47.1854782104493,7.93411684036255 47.1882286071777,7.93579578399658 47.1924247741699,7.93313694000256 47.1940345764161,7.92805480957037 47.192726135254,7.92175102233892 47.1971130371094,7.9197359085083 47.2002716064454))0.0006POINT(7.8969356748793205 47.2069557189942)
63613POLYGON((9.24386501312256 50.6451263427736,9.23827648162842 50.6392974853516,9.2366619110108 50.6304321289064,9.24012756347662 50.6231117248535,9.24002265930181 50.620174407959,9.24354553222656 50.6164436340331,9.24354553222656 50.6164436340331,9.25140190124523 50.608798980713,9.26031208038336 50.607147216797,9.25800037384039 50.6004829406738,9.25181674957281 50.595890045166,9.24158191680914 50.5911445617676,9.23987674713129 50.5888404846191,9.23197174072271 50.5858306884765,9.22963714599615 50.5817260742188,9.23307418823237 50.5774726867677,9.24088478088379 50.57763671875,9.24313545227045 50.5764312744142,9.2455911636352 50.5771141052247,9.25192642211925 50.5737724304199,9.25031471252447 50.5690116882324,9.24873256683355 50.5674209594727,9.25716686248785 50.5632019042969,9.25354766845714 50.5606422424317,9.24616241455078 50.5626220703125,9.24243450164795 50.5604476928712,9.23925971984869 50.5598030090332,9.23728942871099 50.5548057556153,9.23286247253424 50.5492591857911,9.23921298980719 50.5431442260742,9.2383708953858 50.5387725830078,9.24246883392345 50.5349845886232,9.24246883392345 50.5349845886232,9.25896263122564 50.5386085510255,9.26618194580072 50.5390090942383,9.26487636566162 50.5403289794922,9.26946830749517 50.5413208007813,9.2701797485351 50.5448837280273,9.27951335906988 50.5476455688478,9.28424930572515 50.553997039795,9.28716850280762 50.5563468933107,9.2887945175172 50.555202484131,9.29039478302002 50.5561103820802,9.28793048858648 50.5580215454102,9.28916835784918 50.5598678588868,9.29800510406506 50.5595741271974,9.30159091949469 50.5618515014648,9.29934787750256 50.5633850097656,9.30456829071056 50.5658607482911,9.30747318267828 50.570526123047,9.31040477752691 50.5730667114258,9.31354331970221 50.5718650817871,9.32472515106207 50.5711441040038,9.34508705139166 50.5722770690919,9.34783744812017 50.5741729736329,9.3478164672851 50.5750312805177,9.34431457519537 50.5749397277833,9.34393310546881 50.5772209167481,9.34924411773687 50.5813446044922,9.35186004638672 50.5812797546387,9.35498046875006 50.5854759216309,9.35366725921642 50.587703704834,9.34653472900391 50.5892257690431,9.34161472320562 50.588104248047,9.34081268310547 50.5890884399414,9.34419631958013 50.5900306701661,9.34419631958013 50.5900306701661,9.34324550628662 50.5918731689454,9.33762550354004 50.5893783569337,9.33176708221441 50.5890426635743,9.33056449890148 50.5913696289062,9.33225440979004 50.5916213989258,9.33134841918945 50.5939407348633,9.32887935638439 50.5948524475099,9.32833385467535 50.5968704223634,9.32965278625494 50.5978584289551,9.32650947570801 50.5991744995117,9.32296562194819 50.6040344238282,9.32845401763922 50.6118545532227,9.32863140106201 50.6143875122071,9.32390499115002 50.6172981262208,9.31982040405285 50.6165924072266,9.31528186798107 50.6204338073732,9.3055591583252 50.6233062744141,9.30426979064947 50.6245498657226,9.30475234985363 50.6249961853028,9.29913616180426 50.6267356872558,9.2994060516358 50.6305465698243,9.29677677154541 50.6326599121094,9.29241085052496 50.6335144042968,9.28666400909435 50.6331634521484,9.28564071655279 50.6354141235351,9.28564071655279 50.6354141235351,9.28106307983404 50.6340980529786,9.27429294586187 50.6289596557617,9.26778984069836 50.6303749084473,9.2573060989381 50.6351661682129,9.25609683990473 50.6391220092774,9.24582481384283 50.6432952880859,9.24386501312256 50.6451263427736))0.0006POINT(9.287778372716465 50.58837231722747)
47893POLYGON((-1.36395096778864 47.4517059326172,-1.36718118190765 47.4543190002442,-1.38691854476929 47.4554328918457,-1.39952421188349 47.4609794616699,-1.40267419815063 47.4674301147462,-1.40021216869343 47.477424621582,-1.40021216869343 47.477424621582,-1.3909722566604 47.4790725708008,-1.38420987129211 47.4919662475586,-1.37653815746302 47.4952583312988,-1.37722277641291 47.5089797973633,-1.36444306373591 47.5190048217773,-1.36444306373591 47.5190048217773,-1.35684132575983 47.5103225708008,-1.35873687267303 47.5001182556153,-1.3507661819458 47.4958457946777,-1.3504363298415 47.4855804443361,-1.34105980396265 47.4847564697266,-1.32771944999689 47.4895095825196,-1.32771944999689 47.4895095825196,-1.31744503974915 47.4742774963378,-1.32910537719727 47.4632606506348,-1.32910537719727 47.4632606506348,-1.34314620494843 47.4662322998047,-1.3527107238769 47.4648323059083,-1.3566842079162 47.4628524780274,-1.35249936580658 47.4570045471192,-1.35472941398621 47.4540252685547,-1.36395096778864 47.4517059326172))0.0006POINT(-1.361685991287194 47.47926398686002)
28323POLYGON((4.88419914245605 47.2068252563477,4.88116741180426 47.1945610046387,4.88116741180426 47.1945610046387,4.88014984130865 47.1847190856935,4.88768672943115 47.1762847900391,4.88768672943115 47.1762847900391,4.9097056388855 47.1756172180176,4.9097056388855 47.1756172180176,4.92013597488409 47.1881141662599,4.92013597488409 47.1881141662599,4.92095088958746 47.1898498535156,4.92095088958746 47.1898498535156,4.91175699234003 47.1917190551758,4.91015100479126 47.1948623657227,4.90593004226685 47.1931953430176,4.89718627929699 47.1954994201661,4.8900456428529 47.2077293395997,4.8900456428529 47.2077293395997,4.88419914245605 47.2068252563477))0.0006POINT(4.900486548741696 47.19061851501469)
47213POLYGON((2.3669331073761 50.4772148132324,2.36916375160223 50.4833145141602,2.36569905281073 50.4858436584473,2.34495687484741 50.4882698059081,2.34495687484741 50.4882698059081,2.34334588050842 50.5006942749024,2.34334588050842 50.5006942749024,2.35793113708496 50.5036239624023,2.36386013031006 50.5089035034181,2.36386013031006 50.5089035034181,2.36619782447826 50.499870300293,2.38569426536554 50.5006408691407,2.38569426536554 50.5006408691407,2.39048409461986 50.4967689514161,2.39048409461986 50.4967689514161,2.38393783569347 50.4923744201661,2.38413119316107 50.4800033569336,2.38413119316107 50.4800033569336,2.3669331073761 50.4772148132324))0.0006POINT(2.3686004214816925 50.49404462178553)