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
49896POLYGON((3.1576778888703 49.9117164611816,3.15306711196905 49.9142646789551,3.15306711196905 49.9142646789551,3.15988588333136 49.9194221496583,3.15560078620922 49.9285163879395,3.16907620429993 49.9385223388672,3.16907620429993 49.9385223388672,3.17173767089849 49.9394454956055,3.17173767089849 49.9394454956055,3.17749667167664 49.9265937805176,3.1905517578125 49.916187286377,3.17094111442566 49.9135932922363,3.17094111442566 49.9135932922363,3.1576778888703 49.9117164611816))0.0006POINT(3.166989014698945 49.92416059053863)
1403152POLYGON((2.00766110420227 42.0736618041993,2.00304198265087 42.0693168640137,1.99653494358063 42.0692329406738,1.99223196506506 42.0670547485352,1.97567594051361 42.0668907165528,1.96851897239696 42.0614242553712,1.96742105484009 42.0625152587891,1.96308100223547 42.0615768432618,1.95035004615789 42.0665664672852,1.94974195957184 42.0699081420898,1.95759105682379 42.0782165527344,1.94610905647278 42.0836296081544,1.9467079639436 42.0890045166016,1.93694400787359 42.0880889892579,1.9281170368194 42.0900688171387,1.92349100112926 42.0891876220703,1.91847598552698 42.0902862548829,1.9084600210191 42.0959854125978,1.91344904899597 42.1010818481446,1.91648697853094 42.1019134521486,1.92069602012634 42.110824584961,1.93490695953381 42.1144523620605,1.93743002414703 42.124195098877,1.93423199653631 42.1280059814454,1.94377899169928 42.1300888061524,1.97703897953033 42.128231048584,1.97706794738781 42.1244430541992,1.97941398620611 42.1227378845215,1.98421597480774 42.1230659484863,1.9858729839325 42.1212310791016,1.98959696292877 42.1135139465332,1.98915898799902 42.1100883483887,1.99147701263439 42.1077423095704,2.00576710700994 42.1059226989747,2.00716710090637 42.1043510437012,2.00477600097656 42.0960807800294,2.00782990455639 42.0909843444824,2.00802397727978 42.0850105285646,2.009691953659 42.0830268859863,2.00766110420227 42.0736618041993))0.0006POINT(1.9655957435950664 42.0948617397211)
27381POLYGON((-1.47266054153442 49.2684936523438,-1.47060167789459 49.2739524841309,-1.46113014221191 49.2758178710939,-1.46231293678284 49.2821731567383,-1.468591928482 49.2871360778809,-1.468591928482 49.2871360778809,-1.47806143760675 49.2852287292481,-1.49173927307129 49.2753829956055,-1.50050342082972 49.2763061523438,-1.50050342082972 49.2763061523438,-1.50336718559265 49.266384124756,-1.513667345047 49.2548332214355,-1.52678501605988 49.2499046325684,-1.52678501605988 49.2499046325684,-1.53128182888031 49.2397041320802,-1.53128182888031 49.2397041320802,-1.52626395225525 49.2400360107422,-1.51480579376221 49.2335586547852,-1.503628373146 49.2189140319825,-1.48964309692377 49.2161674499512,-1.48964309692377 49.2161674499512,-1.45914030075062 49.2190208435059,-1.45914030075062 49.2190208435059,-1.45832431316376 49.2325019836426,-1.45832431316376 49.2325019836426,-1.48097312450403 49.2536163330079,-1.47266054153442 49.2684936523438))0.0006POINT(-1.4902981382149636 49.252687454223675)
18888POLYGON((13.5427560806275 37.839900970459,13.5434074401856 37.8374061584473,13.5426692962647 37.8252563476564,13.545862197876 37.8217735290527,13.553560256958 37.8173522949219,13.5423307418823 37.8037681579591,13.5423831939698 37.794116973877,13.5351753234863 37.7916679382324,13.5288963317872 37.7922286987306,13.5268974304199 37.7934188842775,13.5132923126222 37.7933578491212,13.4911546707154 37.7878417968751,13.4911546707154 37.7878417968751,13.4746198654174 37.7902145385742,13.4672870635987 37.7960395812988,13.4577541351318 37.7995834350586,13.4523220062257 37.8002777099611,13.4523220062257 37.8002777099611,13.4530601501466 37.8065528869629,13.4627914428711 37.8245124816895,13.4619045257568 37.8264083862306,13.4619045257568 37.8264083862306,13.4625787734985 37.8292388916017,13.4639320373536 37.8303031921388,13.4738407135009 37.8252410888673,13.4836912155152 37.8375015258789,13.4941568374634 37.8425254821778,13.5004024505616 37.842212677002,13.5020313262941 37.840347290039,13.5005378723146 37.8371696472169,13.5062904357911 37.8325691223146,13.526951789856 37.8271522521973,13.5373210906982 37.8320159912109,13.5366563796997 37.8377685546876,13.5366563796997 37.8377685546876,13.5427560806275 37.839900970459))0.0006POINT(13.501958656311068 37.817372022356366)
68070POLYGON((6.50701856613165 49.7126388549804,6.51298046112072 49.7111282348633,6.52030563354492 49.7124214172363,6.52030563354492 49.7124214172363,6.52167463302618 49.7095413208009,6.52148866653454 49.7077445983888,6.5141854286195 49.7023773193359,6.51208639144909 49.6989059448242,6.51201009750372 49.6928520202638,6.51008653640753 49.6914405822754,6.51191663742065 49.689151763916,6.51191663742065 49.689151763916,6.51016473770153 49.6888465881349,6.50800895690924 49.6903762817383,6.49503326416016 49.6838188171387,6.48841285705566 49.685432434082,6.48841285705566 49.685432434082,6.4868426322937 49.6874198913574,6.48624229431158 49.6917419433594,6.47933053970343 49.6964263916015,6.47933053970343 49.6964263916015,6.49619817733765 49.7096786499024,6.50248956680304 49.7127189636232,6.50701856613165 49.7126388549804))0.0006POINT(6.504193119380832 49.698178001072115)
46582POLYGON((3.55865001678478 50.1712226867677,3.54429554939281 50.1756248474122,3.54414701461792 50.1826210021973,3.54414701461792 50.1826210021973,3.55292940139771 50.1838722229004,3.55292940139771 50.1838722229004,3.55865001678478 50.1712226867677))0.0006POINT(3.5495163997014756 50.179972330729214)
21335POLYGON((0.549465537071342 44.7265510559081,0.542586088180599 44.7353706359863,0.555045545101223 44.7388725280762,0.549887299537716 44.7482070922852,0.549887299537716 44.7482070922852,0.552547097206229 44.7498245239258,0.552547097206229 44.7498245239258,0.561771750450191 44.7513427734376,0.566003859043178 44.7575340270997,0.575128912925834 44.7599296569824,0.579694509506226 44.758716583252,0.58491557836544 44.7490005493164,0.593955516815186 44.7465782165527,0.593955516815186 44.7465782165527,0.602683007717246 44.7351570129395,0.579481780529079 44.7260589599611,0.579481780529079 44.7260589599611,0.558772802353019 44.7196693420411,0.549465537071342 44.7265510559081))0.0006POINT(0.5682117210494843 44.7429712083605)
73616POLYGON((16.7737407684327 45.3628044128419,16.7669906616212 45.3530158996583,16.761360168457 45.340160369873,16.761360168457 45.340160369873,16.7492065429688 45.3482894897461,16.7482318878174 45.3515739440919,16.7497425079346 45.3576774597169,16.7486572265626 45.3595161437989,16.7382698059083 45.3622970581055,16.7327671051025 45.3624954223634,16.721700668335 45.3609428405762,16.7164745330811 45.3592872619629,16.7127780914307 45.3557243347169,16.713939666748 45.3525352478027,16.7134399414062 45.3487434387207,16.7095184326172 45.3464050292969,16.703592300415 45.3474769592286,16.7021598815919 45.3504371643066,16.696008682251 45.3547897338867,16.687843322754 45.3517723083496,16.681848526001 45.3522796630859,16.666244506836 45.3632278442383,16.666316986084 45.3654632568359,16.6706504821777 45.3710670471191,16.6705741882325 45.3752326965331,16.6682739257812 45.3776054382325,16.66042137146 45.3810806274414,16.6578388214111 45.387004852295,16.6543350219727 45.3901557922363,16.6476268768311 45.3917999267578,16.6333618164062 45.3909187316895,16.6179370880127 45.3926734924317,16.6138210296631 45.3962478637696,16.6122798919677 45.4047050476075,16.609359741211 45.4070281982422,16.6061038970947 45.4065856933595,16.5988578796388 45.4022102355958,16.5932197570801 45.4021263122558,16.5886096954346 45.4056663513184,16.5867557525635 45.4136543273926,16.5839920043946 45.4180603027343,16.5793323516847 45.4211654663086,16.574396133423 45.422191619873,16.5692348480225 45.420768737793,16.561061859131 45.4146690368653,16.5420436859132 45.4046936035157,16.5321922302246 45.4018020629884,16.5185546875 45.4024963378907,16.5061378479005 45.4112319946289,16.4918384552001 45.4144248962403,16.4865589141846 45.4135742187501,16.4672622680665 45.4056091308595,16.4511032104493 45.4030075073242,16.4419136047363 45.4031028747559,16.420524597168 45.4066009521486,16.4152584075927 45.4056663513184,16.4109535217286 45.4029846191406,16.4045677185059 45.39652633667,16.4017486572265 45.3883552551271,16.4027137756348 45.3834037780763,16.407039642334 45.3791999816896,16.420352935791 45.3743133544922,16.4287548065187 45.3730125427246,16.437177658081 45.3750915527345,16.4414539337159 45.3744621276857,16.4434776306152 45.3730468749999,16.4442787170411 45.3711891174318,16.4417877197267 45.3643455505372,16.4395408630372 45.3620185852052,16.4302711486816 45.3568954467773,16.4072647094728 45.3529052734376,16.4007511138917 45.3484954833984,16.3895168304443 45.3449783325196,16.3763771057129 45.3392257690431,16.3763771057129 45.3392257690431,16.3752384185792 45.3447990417481,16.378526687622 45.3500976562501,16.3784599304199 45.3536148071289,16.3752708435059 45.357822418213,16.3674602508545 45.3622970581055,16.3646030426025 45.3664054870607,16.3654441833496 45.3690605163575,16.3706989288331 45.3743362426759,16.3687076568604 45.3853836059571,16.3765850067139 45.3963127136231,16.3750324249268 45.3983612060548,16.3731536865234 45.3989753723145,16.3674983978272 45.3969116210938,16.3533973693847 45.3970375061035,16.3505153656006 45.3980865478516,16.3489971160889 45.4002380371094,16.3489894866944 45.4125862121583,16.3460617065429 45.422218322754,16.3471012115479 45.4265098571778,16.3505115509033 45.4299240112305,16.3517417907715 45.4330444335938,16.3505764007569 45.4405212402345,16.3508548736573 45.4458961486817,16.3481731414795 45.4478378295898,16.3388481140137 45.4492721557618,16.3348598480225 45.4512214660645,16.3217868804932 45.4625625610352,16.3192596435547 45.4660377502441,16.3173351287842 45.4715576171876,16.3131332397461 45.4741554260254,16.3087253570556 45.4736518859863,16.301296234131 45.4696006774903,16.2967872619629 45.4683227539063,16.2853260040283 45.4691200256348,16.2628803253174 45.4663848876954,16.2580242156983 45.467098236084,16.2567977905273 45.4684028625489,16.2561206817627 45.4723968505861,16.2567653656006 45.4814949035645,16.2589111328125 45.4897918701172,16.2589111328125 45.4897918701172,16.2619953155517 45.4930648803711,16.2609996795654 45.5001525878907,16.2646827697755 45.5027236938478,16.2680511474609 45.507797241211,16.2685642242432 45.5107612609864,16.2662696838379 45.5125923156738,16.2533187866212 45.5167198181153,16.2366008758545 45.5176658630372,16.2321605682373 45.519645690918,16.2290153503419 45.5247154235841,16.228858947754 45.5277557373047,16.2307491302491 45.5359191894532,16.2330360412599 45.539478302002,16.2392292022706 45.5456275939941,16.2443408966065 45.5489807128907,16.2526416778564 45.5525970458985,16.2698802947999 45.5553817749023,16.2730655670165 45.5566635131837,16.2742977142333 45.5607604980469,16.2734184265137 45.5639381408691,16.2692489624023 45.5696907043458,16.2687530517579 45.5721244812012,16.2695293426513 45.5745162963867,16.2742919921876 45.5771217346192,16.2858772277831 45.5783920288087,16.2858772277831 45.5783920288087,16.2952194213868 45.5727005004884,16.2991466522217 45.5725784301758,16.3092956542969 45.5747108459474,16.3171157836914 45.5721473693848,16.3250827789308 45.5644912719728,16.329429626465 45.5542068481446,16.3296012878418 45.5487861633302,16.3272991180421 45.5417747497559,16.3279342651367 45.5374221801759,16.3295192718506 45.5355262756348,16.3349151611329 45.5328330993652,16.337537765503 45.5304298400879,16.3432121276856 45.5202484130861,16.3471679687501 45.5168380737306,16.3788967132569 45.5085029602052,16.3842945098877 45.5036544799806,16.3832550048828 45.5016174316406,16.3830890655519 45.4975433349611,16.386116027832 45.4951324462891,16.3927288055421 45.4947357177734,16.3967800140381 45.4959907531738,16.3980064392091 45.4973678588868,16.4034862518311 45.5123329162599,16.4095478057862 45.5201568603516,16.4087524414063 45.5216903686523,16.4066276550292 45.5222740173341,16.3952503204346 45.5211639404297,16.3875885009767 45.5230522155761,16.3850574493408 45.5252456665038,16.3845825195312 45.5272102355958,16.3857021331787 45.5305938720703,16.3881378173829 45.5329322814943,16.3930644989014 45.534465789795,16.4052391052247 45.5345802307129,16.4099349975587 45.538688659668,16.4138412475586 45.5393257141113,16.4166221618653 45.5385475158691,16.4217052459718 45.5341072082521,16.4394149780274 45.5309906005859,16.4394149780274 45.5309906005859,16.4422245025636 45.527515411377,16.4644947052003 45.5190315246583,16.4644947052003 45.5190315246583,16.4665412902832 45.5154838562012,16.4700927734375 45.5143280029298,16.4740085601807 45.5154151916505,16.4768505096435 45.5189170837402,16.480640411377 45.52095413208,16.4856662750245 45.5221939086913,16.4975299835206 45.5221481323243,16.514898300171 45.5191497802734,16.5175132751465 45.5178451538086,16.5209655761718 45.5128860473633,16.5226993560792 45.502643585205,16.5246353149414 45.5003547668456,16.5285129547119 45.4982414245607,16.5329074859619 45.4983139038087,16.5396652221679 45.5030517578126,16.5441207885743 45.5031776428224,16.54758644104 45.500846862793,16.5530700683594 45.4914436340332,16.5558471679689 45.4894294738771,16.5694541931153 45.4850540161133,16.5890960693359 45.4805145263672,16.6015129089357 45.4801902770996,16.6087837219239 45.4787750244141,16.6264114379884 45.4702186584472,16.6418571472168 45.4636573791504,16.6479797363282 45.462028503418,16.6564025878906 45.4612922668457,16.6637592315674 45.4618530273438,16.673807144165 45.4664459228517,16.673807144165 45.4664459228517,16.6786098480226 45.4581947326661,16.6800365447998 45.4495544433594,16.6843891143799 45.4450187683107,16.6830806732178 45.436206817627,16.6845703125001 45.430835723877,16.6897735595703 45.4249725341797,16.6977710723878 45.4198226928711,16.7015113830566 45.4150085449218,16.7054023742676 45.4130897521973,16.7098369598389 45.4123611450195,16.7212047576904 45.4159126281738,16.7314796447754 45.4156455993653,16.7379779815674 45.4170417785645,16.7379779815674 45.4170417785645,16.7399101257325 45.4049606323242,16.7420482635498 45.3985824584962,16.7448787689209 45.3955154418946,16.75154876709 45.3912010192872,16.7530403137207 45.3887367248536,16.7532215118409 45.3842811584473,16.7509441375732 45.3773231506349,16.7516365051271 45.3730201721192,16.7630329132081 45.365032196045,16.7737407684327 45.3628044128419))0.0006POINT(16.476149102219022 45.44957867790671)
49428POLYGON((3.50766110420233 49.0254821777344,3.49711036682129 49.024600982666,3.49711036682129 49.024600982666,3.49170470237738 49.0370750427247,3.50091052055359 49.0556793212891,3.50091052055359 49.0556793212891,3.53617930412298 49.0541496276855,3.53617930412298 49.0541496276855,3.54248094558727 49.048412322998,3.54248094558727 49.048412322998,3.52338814735418 49.0433731079102,3.50766110420233 49.0254821777344))0.0006POINT(3.516010566191287 49.04287407614968)
1398584POLYGON((-4.70551681518555 40.4388008117677,-4.7194309234618 40.4351348876953,-4.73960113525379 40.4332847595216,-4.74027776718134 40.4321136474609,-4.7691388130188 40.4335517883301,-4.78243780136103 40.432228088379,-4.78580379486078 40.434238433838,-4.78484201431269 40.4361534118652,-4.78997898101795 40.4418220520021,-4.79037618637085 40.4518966674804,-4.78711223602295 40.4560546875001,-4.78648281097406 40.4638824462892,-4.78975582122803 40.4685630798341,-4.78701210021967 40.4691543579102,-4.7870922088623 40.4735145568849,-4.78951692581177 40.4751243591309,-4.77456998825068 40.4880561828613,-4.73649501800531 40.4975700378417,-4.7263569831847 40.4975509643555,-4.71961307525635 40.5001029968262,-4.71989393234253 40.4963150024415,-4.71596193313587 40.486915588379,-4.71695804595947 40.4852409362793,-4.71182489395142 40.4819755554199,-4.70546388626093 40.4693412780761,-4.71062707901001 40.4622459411622,-4.70492410659784 40.4531059265138,-4.70707321166987 40.442985534668,-4.70715808868408 40.4393081665038,-4.70551681518555 40.4388008117677))0.0006POINT(-4.747975744050083 40.46124938438683)