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
17487POLYGON((7.75283193588251 44.7317657470704,7.73552322387701 44.7384605407715,7.72713518142706 44.7376365661621,7.72713518142706 44.7376365661621,7.70645523071289 44.7371635437012,7.6941299438476 44.7383651733399,7.69282913208013 44.74174118042,7.68957185745234 44.7427406311036,7.68645620346064 44.7420768737794,7.68645620346064 44.7420768737794,7.68563318252569 44.7389335632325,7.67875003814697 44.7289733886719,7.64512920379644 44.7137603759766,7.63975620269787 44.7132530212402,7.63607788085943 44.7155952453614,7.62551116943359 44.716552734375,7.62551116943359 44.716552734375,7.62458610534674 44.7077980041505,7.62458610534674 44.7077980041505,7.62293195724487 44.7035293579103,7.62524890899658 44.7003593444825,7.63044309616089 44.696029663086,7.63503122329723 44.6885948181152,7.63503122329723 44.6885948181152,7.64066314697271 44.6875648498536,7.65780210495001 44.6897010803224,7.66720008850103 44.6868896484376,7.66803884506231 44.6849555969239,7.68190717697149 44.6826744079589,7.69304990768433 44.6827201843262,7.69790887832636 44.6784744262696,7.69790887832636 44.6784744262696,7.71369791030884 44.6810417175294,7.71802520751953 44.682315826416,7.71856880188 44.6840438842774,7.72467708587646 44.6866073608398,7.7370371818543 44.6897010803224,7.75687694549566 44.6922073364258,7.75687694549566 44.6922073364258,7.75733995437633 44.6955032348634,7.75733995437633 44.6955032348634,7.76260185241699 44.7068328857422,7.76240682601929 44.7156600952149,7.7603387832641 44.7211303710938,7.76676511764538 44.7249221801757,7.76676511764538 44.7249221801757,7.75283193588251 44.7317657470704))0.0006POINT(7.693403223286535 44.708479176396956)
51119POLYGON((2.38766527175903 49.9216117858887,2.38525938987743 49.9215202331544,2.38525938987743 49.9215202331544,2.36141586303717 49.9278030395508,2.35615587234491 49.927791595459,2.35427570343018 49.9246292114258,2.35427570343018 49.9246292114258,2.36306214332581 49.9207763671875,2.35187649726879 49.9053840637206,2.33466148376465 49.8975486755372,2.3308789730072 49.8911666870117,2.3308789730072 49.8911666870117,2.34314417839045 49.8803367614747,2.34314417839045 49.8803367614747,2.3532657623291 49.8792037963867,2.3623964786529 49.8827743530273,2.3623964786529 49.8827743530273,2.38215494155889 49.884922027588,2.38215494155889 49.884922027588,2.37851405143743 49.8904647827148,2.38984608650208 49.9161186218262,2.38984608650208 49.9161186218262,2.38766527175903 49.9216117858887))0.0006POINT(2.3628422021865974 49.90334181352098)
34574POLYGON((3.71182441711437 49.0955276489258,3.72533965110784 49.0975494384766,3.73237371444714 49.0933799743653,3.73237371444714 49.0933799743653,3.72340154647839 49.0597229003907,3.72340154647839 49.0597229003907,3.71393346786499 49.0607528686523,3.70983242988586 49.0590248107911,3.70968985557568 49.0526123046876,3.70058059692394 49.0507316589355,3.70058059692394 49.0507316589355,3.67367029190063 49.0474967956543,3.67367029190063 49.0474967956543,3.67732191085827 49.0746841430664,3.68344783782965 49.0877609252931,3.68344783782965 49.0877609252931,3.69897031784069 49.0896415710449,3.71182441711437 49.0955276489258))0.0006POINT(3.704344707376894 49.07105748793661)
18755POLYGON((14.5063819885254 37.7485847473145,14.499725341797 37.7444152832031,14.4910097122193 37.7426872253419,14.4825410842896 37.7444686889648,14.4770002365112 37.7496795654297,14.4667882919312 37.7506980895997,14.4603061676025 37.7476959228516,14.4469871520997 37.7300491333009,14.4457912445068 37.7231483459472,14.4489431381227 37.7142486572267,14.4588270187378 37.7092742919923,14.4581146240236 37.7026367187499,14.4561786651611 37.7021865844727,14.4307308197022 37.7085838317872,14.4157428741455 37.7089233398439,14.4050483703613 37.7084846496582,14.3967008590698 37.706829071045,14.3871297836304 37.7022895812989,14.3871297836304 37.7022895812989,14.3947477340698 37.6930732727051,14.3974514007569 37.6870574951172,14.4123039245605 37.6688537597657,14.4154872894288 37.6619682312012,14.4151239395142 37.6601104736328,14.4151239395142 37.6601104736328,14.4163637161255 37.6570777893067,14.4153795242309 37.6525382995607,14.4162282943726 37.6454582214357,14.4217977523804 37.6391410827637,14.4271440505983 37.6381759643554,14.4534292221069 37.6533317565917,14.4543638229371 37.6557273864747,14.4599876403808 37.6601600646974,14.4669256210327 37.6602821350098,14.4669256210327 37.6602821350098,14.4705266952516 37.6672019958497,14.4746265411376 37.6791801452637,14.4906749725342 37.6909065246581,14.4906749725342 37.6909065246581,14.4867601394653 37.6924400329589,14.4818725585938 37.6971282958984,14.4830007553101 37.6996841430665,14.4863929748536 37.7012252807618,14.4897899627685 37.7054290771485,14.4934101104737 37.7169456481934,14.4962968826294 37.7210578918457,14.5033693313599 37.7274627685547,14.5117282867432 37.7383193969727,14.5120162963867 37.7445945739747,14.5063819885254 37.7485847473145))0.0006POINT(14.453897982227584 37.69740824796719)
71691POLYGON((15.5118846893312 48.3230018615724,15.5134019851686 48.316951751709,15.5152940750123 48.3143882751465,15.533616065979 48.3097686767579,15.5325784683229 48.3071060180665,15.5265388488771 48.2998542785645,15.5265388488771 48.2998542785645,15.5259456634522 48.2875442504883,15.5259456634522 48.2875442504883,15.5092220306398 48.2905921936036,15.5027513504028 48.2890625,15.5001754760742 48.2865180969239,15.4995508193971 48.2845840454103,15.5035657882691 48.2778587341309,15.503643989563 48.2755813598633,15.4870967864991 48.268970489502,15.4859447479249 48.2657279968262,15.4879512786865 48.2618484497071,15.4879512786865 48.2618484497071,15.4629955291749 48.2586936950684,15.4572200775146 48.2570495605469,15.4574670791626 48.255199432373,15.4630813598633 48.2490768432618,15.4629325866699 48.2459106445312,15.4584264755249 48.2401962280273,15.4415559768677 48.2239761352539,15.4415559768677 48.2239761352539,15.4253406524659 48.2137031555177,15.4253406524659 48.2137031555177,15.4021558761598 48.2243309020997,15.3838863372803 48.2249908447266,15.3838863372803 48.2249908447266,15.3867750167847 48.2400283813477,15.3847332000732 48.241325378418,15.3768177032471 48.2427101135255,15.3768177032471 48.2427101135255,15.3928718566894 48.2474632263185,15.400806427002 48.2533645629883,15.4021568298341 48.2554512023926,15.402756690979 48.2592430114747,15.3981113433839 48.2674751281739,15.3991727828979 48.2690582275391,15.4361724853516 48.2689628601075,15.4421606063843 48.2700881958009,15.4464988708496 48.2723464965821,15.4490985870361 48.275650024414,15.4494981765748 48.2776489257813,15.4481468200685 48.2900390625001,15.4504108428955 48.2996368408204,15.4574022293091 48.3099250793457,15.466989517212 48.3185424804689,15.466989517212 48.3185424804689,15.5118846893312 48.3230018615724))0.0006POINT(15.457304422672022 48.26893491011403)
12488MULTIPOLYGON(((13.9752254486084 42.1069374084474,13.9775018692018 42.103443145752,13.9775018692018 42.103443145752,13.9692296981812 42.1005172729493,13.9690027236938 42.0973358154298,13.9747266769409 42.0932846069337,13.9787225723267 42.087059020996,13.9801292419434 42.0827369689943,13.9764127731324 42.0812606811524,13.969976425171 42.0767250061035,13.9667406082154 42.0724334716797,13.9544820785522 42.0441436767578,13.9692649841309 42.0324440002441,13.9780912399293 42.0217933654785,13.9780912399293 42.0217933654785,13.9664125442505 42.0110397338868,13.9664125442505 42.0110397338868,13.9509935379028 42.0195388793945,13.9345502853394 42.0202636718751,13.9319562911988 42.0184898376464,13.9255285263062 42.0174598693848,13.9255285263062 42.0174598693848,13.9209423065186 42.0319633483887,13.9161195755005 42.0363502502442,13.9023017883301 42.0458374023439,13.89115524292 42.0450592041017,13.89115524292 42.0450592041017,13.883505821228 42.0429801940919,13.8781042099 42.0444450378418,13.8765506744385 42.0452117919922,13.8758039474487 42.0474433898927,13.8769350051879 42.0490684509277,13.8769350051879 42.0490684509277,13.8822193145752 42.054386138916,13.8870258331299 42.054542541504,13.8928909301758 42.0584373474122,13.8928909301758 42.0584373474122,13.8953914642335 42.0613708496094,13.8957672119141 42.0646781921387,13.8927669525148 42.0669860839845,13.8922939300538 42.0789184570312,13.8938140869141 42.0810661315918,13.8984394073486 42.0828857421875,13.8989763259888 42.0870056152345,13.8952913284302 42.092872619629,13.9043598175049 42.0921669006348,13.9104099273683 42.0905189514161,13.9204092025758 42.0986480712892,13.9263763427736 42.1059722900391,13.9431533813478 42.1109580993653,13.9590015411378 42.1238784790038,13.9601173400879 42.1268386840821,13.9601173400879 42.1268386840821,13.9629049301148 42.1257095336915,13.9752254486084 42.1069374084474)),((13.891749382019 42.0595626831056,13.8865404129029 42.0581703186035,13.8631782531738 42.0568771362306,13.8686561584474 42.0655212402344,13.8686561584474 42.0655212402344,13.891749382019 42.0595626831056)))0.0006POINT(13.927620800155443 42.065940127416184)
59105POLYGON((8.26750755310059 47.492645263672,8.26259517669683 47.4930839538575,8.25869846344006 47.4950485229493,8.25729656219482 47.4964332580566,8.25687789917004 47.4998092651368,8.25579643249506 47.5007705688477,8.24716091156012 47.4980697631836,8.24716091156012 47.4980697631836,8.24901771545422 47.494556427002,8.25300788879406 47.4919662475586,8.25252628326422 47.4895248413087,8.2539176940918 47.4877548217773,8.26176929473883 47.48583984375,8.26671123504644 47.4831199645997,8.26671123504644 47.4831199645997,8.26712703704834 47.4859428405762,8.26992607116694 47.4889373779297,8.26992607116694 47.4889373779297,8.26963996887201 47.4911499023437,8.26750755310059 47.492645263672))0.0006POINT(8.259651284468836 47.49183052464539)
49553POLYGON((3.33673572540278 49.5554199218751,3.33468222618109 49.5455589294434,3.31468987464916 49.530918121338,3.31468987464916 49.530918121338,3.33963298797613 49.5276947021484,3.33963298797613 49.5276947021484,3.35948991775518 49.5359687805176,3.35948991775518 49.5359687805176,3.36621546745312 49.5399131774903,3.36621546745312 49.5399131774903,3.36552476882929 49.5495948791504,3.33673572540278 49.5554199218751))0.0006POINT(3.345181746916395 49.53814211758704)
62602POLYGON((7.43747091293341 52.9822425842286,7.43653249740612 52.9912986755371,7.43653249740612 52.9912986755371,7.45803976058966 52.9951400756837,7.4660148620606 52.9978027343751,7.46187782287592 53.0018043518066,7.45971250534052 53.000759124756,7.45923519134527 53.0061912536621,7.45923519134527 53.0061912536621,7.52459335327154 53.0433616638184,7.52459335327154 53.0433616638184,7.54512405395508 53.0336761474611,7.54512405395508 53.0336761474611,7.53845214843761 53.0320014953614,7.53892421722412 53.03084564209,7.54119539260864 53.0299491882325,7.5373797416687 53.0261878967285,7.5354404449464 53.0262603759767,7.53373289108276 53.0234565734864,7.53590488433838 53.0216789245606,7.53902959823614 53.0215873718263,7.5398006439209 53.0183219909669,7.54640436172491 53.0181465148927,7.54632472991943 53.0116348266602,7.55940914154064 53.012062072754,7.56498336791992 53.0058364868165,7.56498336791992 53.0058364868165,7.58673524856579 52.981460571289,7.58673524856579 52.981460571289,7.56243896484381 52.9733200073242,7.56645536422735 52.9614944458008,7.56522274017334 52.9580574035646,7.56522274017334 52.9580574035646,7.56430959701544 52.9565391540528,7.54739379882818 52.9567756652832,7.54714488983149 52.9548263549805,7.53471708297729 52.9561462402344,7.53364324569702 52.9519271850586,7.52917861938482 52.951873779297,7.52866888046265 52.9510078430177,7.51604890823364 52.9508209228516,7.50785112380993 52.9530944824219,7.50013875961304 52.9521408081055,7.47554349899286 52.9606475830079,7.47554349899286 52.9606475830079,7.47507572174072 52.9723587036133,7.47389984130859 52.978500366211,7.46554136276251 52.9886054992675,7.45278787612915 52.983024597168,7.43747091293341 52.9822425842286))0.0006POINT(7.5182928163178415 52.991906068763)
32051POLYGON((0.181687563657874 47.1153564453126,0.165649548172951 47.1066513061523,0.161916881799812 47.1001091003418,0.161916881799812 47.1001091003418,0.134945988655204 47.1083717346192,0.134143635630664 47.1152687072755,0.140682861208916 47.1245956420898,0.140682861208916 47.1245956420898,0.143102854490394 47.1511383056641,0.143102854490394 47.1511383056641,0.152887269854546 47.1551551818849,0.152887269854546 47.1551551818849,0.163066357374305 47.1441917419434,0.177615493536052 47.1432113647462,0.179961875081119 47.1402626037599,0.193386599421501 47.143856048584,0.193386599421501 47.143856048584,0.188583344221172 47.1276168823242,0.17994536459446 47.1193962097169,0.181501641869488 47.116138458252,0.181501641869488 47.116138458252,0.181687563657874 47.1153564453126))0.0006POINT(0.1644073994387198 47.128681546165865)