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
68241POLYGON((6.60903215408325 50.3259735107422,6.615318775177 50.3192138671875,6.61833429336559 50.3174591064453,6.62259435653698 50.3168182373047,6.62062311172497 50.3149604797364,6.62438535690313 50.3131866455079,6.62540531158453 50.3088340759277,6.63109731674206 50.3049697875977,6.63261842727667 50.3049507141114,6.63261842727667 50.3049507141114,6.63496208190918 50.3031349182129,6.63496208190918 50.3031349182129,6.63611459732061 50.3064002990723,6.64404058456421 50.3102798461914,6.64455604553234 50.3120651245118,6.65191841125494 50.3157997131349,6.65299081802368 50.3176536560059,6.65299081802368 50.3176536560059,6.64590358734131 50.3194885253907,6.64526081085205 50.3230361938477,6.64741086959839 50.3249626159669,6.64676761627203 50.327320098877,6.64121484756481 50.3299789428712,6.63634777069103 50.3395385742189,6.63634777069103 50.3395385742189,6.62538909912115 50.3384132385254,6.62571907043457 50.3364601135254,6.62339448928833 50.3366508483887,6.61700391769409 50.3342552185059,6.61700391769409 50.3342552185059,6.61420679092407 50.327564239502,6.60903215408325 50.3259735107422))0.0006POINT(6.63246882346373 50.32028715072144)
35459POLYGON((9.22899150848394 42.2406158447266,9.21646022796637 42.235939025879,9.19301509857183 42.2365455627441,9.17565059661871 42.2419052124025,9.1237468719483 42.2389450073242,9.1237468719483 42.2389450073242,9.12821578979492 42.2447891235353,9.1494197845459 42.2573547363282,9.16717815399176 42.2549896240235,9.17287826538086 42.2497825622559,9.17730712890625 42.2504806518556,9.17730712890625 42.2504806518556,9.17890167236334 42.2436256408691,9.18734550476069 42.2405281066895,9.20116329193115 42.242588043213,9.22899150848394 42.2406158447266))0.0006POINT(9.173421859741238 42.244500986735076)
30711POLYGON((-1.48994743823999 48.4893760681152,-1.48715257644653 48.482219696045,-1.48715257644653 48.482219696045,-1.48640072345734 48.4721641540528,-1.49306380748749 48.4670562744141,-1.49826514720917 48.4441223144531,-1.49826514720917 48.4441223144531,-1.48411238193512 48.4465065002441,-1.4689507484436 48.4373741149903,-1.46388649940491 48.438014984131,-1.46037149429321 48.4441413879396,-1.46037149429321 48.4441413879396,-1.46884083747864 48.4526252746583,-1.46291184425354 48.4582443237305,-1.46998357772827 48.4747848510742,-1.46613359451294 48.4879760742188,-1.46613359451294 48.4879760742188,-1.47467052936554 48.4858779907227,-1.48586177825928 48.4907379150392,-1.48994743823999 48.4893760681152))0.0006POINT(-1.477498725840917 48.46472007349922)
14891POLYGON((8.79381847381592 44.4988822937012,8.79770374298096 44.5010719299318,8.79823398590094 44.5117111206055,8.79614734649658 44.5188674926758,8.79615783691418 44.522819519043,8.80012989044184 44.5311088562012,8.80916118621832 44.5362434387207,8.82025241851801 44.5391349792481,8.82478237152094 44.5391883850099,8.82936382293707 44.5433692932129,8.82936382293707 44.5433692932129,8.83025074005138 44.5367012023926,8.8330602645874 44.5315093994142,8.84084320068354 44.5242767333984,8.87067604064941 44.5130577087403,8.88471508026129 44.5113639831544,8.89196395874029 44.5066299438477,8.89554405212402 44.5055236816407,8.89554405212402 44.5055236816407,8.89716053009039 44.5050392150879,8.89767456054682 44.5037078857422,8.89211273193371 44.4984016418458,8.88760280609131 44.4918975830078,8.88864517211914 44.4776458740235,8.88604164123547 44.4735717773438,8.88277339935297 44.475425720215,8.87503337860119 44.4769935607911,8.86462497711187 44.4783096313476,8.86095333099371 44.4774208068849,8.85575294494623 44.4916687011719,8.8546018600465 44.4921531677246,8.85034179687511 44.492904663086,8.84178924560541 44.4900665283204,8.83260726928711 44.4921112060547,8.82839298248297 44.494915008545,8.82650756835949 44.4987869262696,8.82115077972423 44.4999885559082,8.81893634796148 44.4997863769532,8.81219768524176 44.4950218200684,8.81153297424316 44.4924774169922,8.80527687072754 44.4928855895997,8.7971916198731 44.4961357116699,8.79381847381592 44.4988822937012))0.0006POINT(8.843490827651282 44.50494448343917)
51544POLYGON((2.59522318840027 49.9609756469726,2.6008713245393 49.9563255310059,2.59685230255138 49.9504280090332,2.59990763664257 49.9442749023438,2.59203100204468 49.940574645996,2.59203100204468 49.940574645996,2.58806252479559 49.9407691955567,2.58806252479559 49.9407691955567,2.58238029479992 49.9564704895021,2.58473730087292 49.9593772888184,2.58473730087292 49.9593772888184,2.59522318840027 49.9609756469726))0.0006POINT(2.591354218396347 49.94999243996362)
61930POLYGON((9.61863899230963 53.3677330017091,9.61844348907471 53.3669967651367,9.61572265625006 53.3670654296876,9.60864353179937 53.3700981140137,9.60256576538086 53.3689384460449,9.59580039978033 53.3646926879883,9.59588050842285 53.3622665405274,9.58365917205811 53.3582115173341,9.5748805999757 53.3469810485841,9.57000350952154 53.3432159423829,9.56599235534668 53.3411560058595,9.56145572662348 53.3412094116211,9.56118583679194 53.340461730957,9.56501483917236 53.3398094177246,9.56270408630382 53.3375892639161,9.56270408630382 53.3375892639161,9.56175422668463 53.3370399475099,9.55974102020275 53.3377990722656,9.56051254272467 53.3396759033203,9.55607318878174 53.3428688049316,9.5512580871582 53.3439903259277,9.5512580871582 53.3439903259277,9.5549106597901 53.3452682495118,9.55517482757568 53.3483238220216,9.56093692779541 53.3535385131837,9.56538486480719 53.3548851013184,9.57044506073009 53.3550300598145,9.56935214996344 53.3598136901855,9.57327556610119 53.3697204589844,9.57016277313238 53.3712234497071,9.56884860992443 53.3701095581055,9.56518745422369 53.3726692199708,9.54742336273199 53.3731155395508,9.54465579986584 53.3714981079103,9.5309238433839 53.3732490539551,9.5152502059936 53.3821907043458,9.51699447631842 53.3858909606935,9.51190662384045 53.3859252929688,9.51190662384045 53.3859252929688,9.50989723205572 53.3941230773926,9.51598453521734 53.3951721191406,9.5178537368775 53.3970146179199,9.51315498352056 53.399341583252,9.51315498352056 53.399341583252,9.51338481903088 53.4017028808594,9.51478290557873 53.4019241333008,9.51707935333263 53.4067573547363,9.52750110626226 53.4123573303223,9.54749202728266 53.4265403747558,9.55314254760737 53.4288330078126,9.55180168151867 53.4303550720214,9.55250167846685 53.4310989379883,9.55250167846685 53.4310989379883,9.55406188964844 53.4294395446777,9.55346298217785 53.4265251159669,9.56367778778082 53.4216766357421,9.57349205017096 53.4259796142579,9.57497406005854 53.4233131408691,9.57310962677008 53.4226951599122,9.57389259338379 53.4218292236329,9.57039833068859 53.4204978942871,9.56791782379162 53.4182739257812,9.56837177276623 53.4174346923829,9.56837177276623 53.4174346923829,9.56959247589111 53.4159240722657,9.56601047515881 53.4131736755372,9.56856632232666 53.4082679748535,9.56360626220709 53.4041862487794,9.57076072692871 53.3989372253418,9.57750701904297 53.3959693908693,9.58301258087164 53.3877487182617,9.58851432800293 53.3898391723633,9.58727550506592 53.3912544250488,9.59597778320312 53.3955383300781,9.59854125976568 53.3936882019044,9.60314178466803 53.3937492370605,9.61198711395269 53.3980026245118,9.62378215789801 53.3901863098145,9.62378215789801 53.3901863098145,9.62162685394298 53.3889389038087,9.62268161773676 53.3865737915038,9.61949539184582 53.3857536315918,9.62053298950195 53.3834686279298,9.61648845672607 53.3790512084962,9.61749839782715 53.372917175293,9.62019729614263 53.3731269836425,9.62073612213146 53.3720359802246,9.61824607849121 53.3700790405274,9.61863899230963 53.3677330017091))0.0006POINT(9.569183609702423 53.383376294916346)
47897POLYGON((-1.17834615707397 47.548023223877,-1.15435206890101 47.5426826477051,-1.15342271327972 47.5392875671388,-1.16837275028223 47.5302658081055,-1.16664409637451 47.5234565734864,-1.15423405170435 47.5093231201172,-1.14058458805079 47.5046920776367,-1.14058458805079 47.5046920776367,-1.14354348182667 47.5051078796387,-1.14354348182667 47.5051078796387,-1.16324388980865 47.5093650817871,-1.18900322914118 47.5095672607422,-1.20743405818939 47.5155372619629,-1.22698271274567 47.5258255004884,-1.22957098484034 47.5361633300781,-1.25182509422302 47.544158935547,-1.25182509422302 47.544158935547,-1.23793184757227 47.5482597351075,-1.21265339851374 47.5456275939941,-1.19871795177454 47.5492286682128,-1.17834615707397 47.548023223877))0.0006POINT(-1.1856408119201265 47.52702655792239)
66403MULTIPOLYGON(((9.78218078613281 50.3418006896973,9.78208827972406 50.3423309326172,9.78208827972406 50.3423309326172,9.78838634490972 50.3423957824707,9.78838634490972 50.3423957824707,9.79028129577637 50.3416976928711,9.79028129577637 50.3416976928711,9.78218078613281 50.3418006896973)),((9.75117206573486 50.2785797119141,9.75301742553705 50.2790870666504,9.75301742553705 50.2790870666504,9.75491809844982 50.2805137634278,9.75746631622314 50.2800903320312,9.75990772247309 50.2837867736818,9.75858306884771 50.2850189208986,9.75952720642101 50.2865982055664,9.75952720642101 50.2865982055664,9.75946521759039 50.2887229919435,9.76218032836908 50.2884521484376,9.7639474868775 50.2895050048829,9.76575374603271 50.2880516052246,9.76934719085693 50.2890548706055,9.76878833770758 50.2898178100586,9.77094268798834 50.291244506836,9.77205657958984 50.2909889221193,9.77298450469976 50.2890853881836,9.7764940261842 50.2888908386232,9.7774543762207 50.2906723022462,9.78210544586193 50.2905502319337,9.7849378585816 50.2917823791505,9.78521537780767 50.2882804870606,9.78865051269531 50.2869644165039,9.79408740997314 50.2916297912598,9.79478836059565 50.293529510498,9.79759788513189 50.293270111084,9.79668140411388 50.2953910827638,9.80053424835199 50.2951240539551,9.80160617828369 50.2967071533203,9.80522632598883 50.296989440918,9.80669021606445 50.298698425293,9.80694675445557 50.3013000488281,9.81305599212646 50.3052711486817,9.81305599212646 50.3052711486817,9.80422210693371 50.3136215209962,9.81483078002924 50.316562652588,9.81831169128412 50.314884185791,9.81795692443853 50.3160781860353,9.81994152069086 50.316837310791,9.82431507110601 50.3146400451661,9.82558631896978 50.3161964416505,9.83106231689459 50.3144912719727,9.83205795288086 50.3156394958497,9.84338283538818 50.3136978149414,9.84626197814941 50.309783935547,9.84626197814941 50.309783935547,9.84509181976318 50.3131141662599,9.84532260894775 50.3156623840332,9.85037040710449 50.3175086975099,9.85263538360596 50.3193664550781,9.84719371795666 50.317569732666,9.84566211700445 50.3185501098634,9.84871482849127 50.3254623413087,9.84814834594738 50.328815460205,9.84814834594738 50.328815460205,9.8481178283692 50.3309631347657,9.84671878814703 50.33256149292,9.84671878814703 50.33256149292,9.84549045562744 50.3320655822754,9.84549045562744 50.3320655822754,9.84709358215338 50.3308410644531,9.84740161895758 50.3238601684571,9.84402847290039 50.3238143920898,9.83829212188732 50.321990966797,9.83515930175781 50.3189506530762,9.82971286773687 50.3194580078126,9.82307720184332 50.3215980529785,9.82142925262463 50.3257446289063,9.81869697570806 50.3251686096193,9.8162698745727 50.3228874206544,9.80426406860357 50.3193511962892,9.79880428314215 50.3188858032227,9.79352569580089 50.3213005065919,9.7889518737793 50.3208160400391,9.77902126312267 50.3241004943848,9.77651596069336 50.3261528015137,9.77761936187744 50.3275108337402,9.77516460418701 50.3290061950683,9.77497482299805 50.3304100036622,9.77221488952637 50.3334617614747,9.76771163940424 50.3337364196778,9.76747322082514 50.3346176147462,9.76243782043463 50.3357009887696,9.76017093658459 50.3305206298829,9.7571525573731 50.3284873962402,9.74803829193121 50.3253669738771,9.74803829193121 50.3253669738771,9.74889755249023 50.3251533508302,9.74689960479748 50.3217124938966,9.74419975280767 50.3210411071777,9.74442768096935 50.3176002502441,9.74584579467773 50.3172645568848,9.74653530120855 50.3147392272949,9.74767971038824 50.314380645752,9.74588108062756 50.3104095458984,9.74363803863525 50.309700012207,9.74355411529552 50.3078994750978,9.73957538604736 50.3063163757324,9.73840045928955 50.3042755126954,9.73913002014166 50.3025894165038,9.73584842681885 50.3013458251954,9.73517036437994 50.2995262145997,9.73034286499023 50.2978515625,9.73003196716309 50.2962493896486,9.727705001831 50.2950630187988,9.727705001831 50.2950630187988,9.7312355041505 50.291316986084,9.72826385498053 50.2883911132813,9.72908496856689 50.2871551513672,9.73617649078363 50.2871742248536,9.74075508117687 50.2828140258789,9.75117206573486 50.2785797119141)),((9.83176803588879 50.3053703308105,9.83204650878918 50.3045539855958,9.82680606842041 50.3035888671875,9.82750988006597 50.3014945983888,9.82627201080328 50.3006706237794,9.82558917999268 50.3012580871583,9.82339286804205 50.2986526489258,9.81996250152588 50.3007850646973,9.8186082839967 50.3040962219239,9.81358432769787 50.3056678771973,9.81358432769787 50.3056678771973,9.81366157531738 50.307071685791,9.81541252136242 50.3074874877931,9.81676292419445 50.3053817749024,9.81909179687511 50.3066291809083,9.81846714019781 50.3080368041993,9.81626224517834 50.3079681396484,9.81814861297613 50.3087005615234,9.81764507293713 50.3094825744629,9.82442665100103 50.3108177185059,9.83087825775158 50.3096389770507,9.83022880554205 50.3078804016113,9.83176803588879 50.3053703308105)))0.0006POINT(9.82058911941698 50.30561066329434)
25144POLYGON((2.33659124374401 48.8396949768068,2.34455919265747 48.8539924621583,2.34455919265747 48.8539924621583,2.36432075500488 48.8461685180664,2.36432075500488 48.8461685180664,2.36595773696905 48.8449096679688,2.36595773696905 48.8449096679688,2.3515734672547 48.8368339538575,2.34204530715948 48.8383026123048,2.34204530715948 48.8383026123048,2.33659124374401 48.8396949768068))0.0006POINT(2.352193069458047 48.84432754516609)
29124POLYGON((4.81391572952271 46.6981582641602,4.8051905632019 46.6900825500489,4.79601526260382 46.6877059936524,4.7914986610412 46.6817054748536,4.77825403213507 46.6776771545411,4.77825403213507 46.6776771545411,4.77215003967285 46.6831054687501,4.75280666351318 46.6855010986328,4.73989820480358 46.6906776428224,4.74320507049561 46.7039909362794,4.74320507049561 46.7039909362794,4.76524829864508 46.7143630981446,4.76524829864508 46.7143630981446,4.77355003356945 46.7139663696289,4.77355003356945 46.7139663696289,4.77798271179199 46.7153739929199,4.7791686058045 46.7087974548341,4.7877659797669 46.7007141113282,4.80149984359747 46.7035064697266,4.81391572952271 46.6981582641602))0.0006POINT(4.775705638684764 46.69817492836407)