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.

Spaltenname	Datentyp	Mögliche Werte	Beschreibung
id_ort	int(10) unsigned	beliebig	Fremdschlü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"	beliebig	Die simplifizierten Geodaten.
epsilon	float(5,4)	beliebig	Die 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"	beliebig	Der geometrische Mittelpunkt des vereinfachten Polygons.

Ausschnitt

id_ort	geodaten	epsilon	mittelpunkt
1388200	POLYGON((-3.24829411506653 37.3410797119141,-3.24406695365894 37.3362312316895,-3.23655891418451 37.3362808227539,-3.23291897773743 37.3308258056641,-3.24255800247192 37.3271484375,-3.24756097793579 37.3274383544923,-3.25053501129145 37.3257637023926,-3.26620197296131 37.3229064941406,-3.27270889282227 37.3275184631349,-3.274580001831 37.3269805908204,-3.28537797927856 37.3408508300781,-3.28895211219788 37.3393325805664,-3.30232810974121 37.3393516540528,-3.31281399726868 37.3441848754883,-3.31707000732416 37.3441886901855,-3.31592607498169 37.3511772155763,-3.32154798507685 37.3566322326661,-3.32502198219288 37.3658752441407,-3.33544206619263 37.3626251220703,-3.34981393814087 37.3619728088379,-3.34383988380432 37.3839988708497,-3.3408269882201 37.3872604370118,-3.33905410766602 37.3875923156739,-3.33549404144287 37.3819046020508,-3.32449102401733 37.3813858032228,-3.32262396812439 37.3888816833497,-3.31729507446278 37.3923950195313,-3.28956508636475 37.3964500427246,-3.28453993797297 37.3996696472168,-3.27882099151611 37.3931579589844,-3.26130104064941 37.3938369750976,-3.25814008712763 37.3975486755372,-3.24983096122742 37.3962135314943,-3.2393369674682 37.3794250488282,-3.23432803153986 37.3624725341797,-3.26142001152033 37.356689453125,-3.25559711456293 37.3472061157227,-3.24829411506653 37.3410797119141))	0.0006	POINT(-3.2866698213525396 37.360390637372035)
1406104	POLYGON((-0.461380988359338 39.8359756469728,-0.464352995157242 39.8394088745118,-0.460752010345402 39.8416557312012,-0.462347000837326 39.8453369140626,-0.465135008096695 39.8467292785646,-0.470934987068119 39.8564949035646,-0.472445994615555 39.8561058044435,-0.472822010517007 39.8624305725097,-0.477180004119873 39.8656692504883,-0.476626008748951 39.8692512512208,-0.48030498623848 39.8716468811035,-0.477427989244404 39.8744735717774,-0.479782998561802 39.8766250610353,-0.47722598910326 39.8787422180176,-0.444110006093922 39.8810424804688,-0.44189000129694 39.8765983581543,-0.434372991323471 39.8702850341798,-0.434302985668126 39.8612518310547,-0.428768992423954 39.8566322326661,-0.423902988433724 39.8492584228516,-0.419445008039474 39.8384895324708,-0.428593009710312 39.8300361633301,-0.425713002681732 39.8211441040039,-0.437970012426376 39.8204727172852,-0.440091997384968 39.824993133545,-0.444840997457447 39.8254127502443,-0.446485012769699 39.8264961242676,-0.44233700633049 39.8327980041504,-0.445719003677368 39.8395614624024,-0.452726989984455 39.8377952575685,-0.454210996627808 39.8359184265136,-0.461380988359338 39.8359756469728))	0.0006	POINT(-0.45303870881753944 39.849959096601)
69618	POLYGON((9.70590782165539 53.6727676391602,9.69995975494385 53.6794395446778,9.70017910003668 53.6814994812013,9.70278644561773 53.6845893859864,9.70174026489258 53.6879768371583,9.70368766784668 53.6897583007813,9.70323753356945 53.6913757324218,9.70456790924072 53.6931266784669,9.70349407196051 53.6955566406251,9.70604801177979 53.6966667175293,9.70484066009516 53.6975860595704,9.7051763534547 53.6997718811036,9.70224285125744 53.7002372741699,9.70224285125744 53.7002372741699,9.70226192474371 53.6991691589356,9.69948291778564 53.6996536254883,9.69644069671625 53.6979522705079,9.69158744812017 53.6991691589356,9.69176578521729 53.7001953125,9.6898832321167 53.6996536254883,9.68879318237305 53.7020797729492,9.68677997589117 53.7028694152833,9.67689037322992 53.6981315612794,9.67426109313976 53.6994514465333,9.66732215881359 53.6972923278809,9.66594886779797 53.6954498291016,9.65866279602056 53.6964454650879,9.65866279602056 53.6964454650879,9.65630245208746 53.6948280334473,9.65450286865229 53.695499420166,9.64808177948009 53.6932373046876,9.64465999603277 53.6901664733887,9.64250469207769 53.6912498474122,9.64023303985601 53.6889953613282,9.62437725067144 53.697608947754,9.61857986450195 53.6982612609864,9.61857891082764 53.6960945129395,9.61229419708246 53.6939392089844,9.61229419708246 53.6939392089844,9.64247894287121 53.6778869628906,9.64247894287121 53.6778869628906,9.64489841461187 53.678020477295,9.64622592926031 53.6766738891603,9.65028381347668 53.6757926940919,9.6615743637085 53.6765174865723,9.66644287109381 53.6759643554688,9.66820621490484 53.6763381958008,9.6712408065797 53.679126739502,9.67661666870123 53.6781539916993,9.682191848755 53.6786041259766,9.69000244140625 53.6760940551759,9.69232177734375 53.6709518432618,9.69548797607433 53.6707496643067,9.69548797607433 53.6707496643067,9.69957351684582 53.6715927124023,9.7014856338501 53.6729278564453,9.70590782165539 53.6727676391602))	0.0006	POINT(9.674897534506709 53.68879284177509)
68679	POLYGON((11.5150527954102 51.8099822998047,11.5146703720094 51.8091125488282,11.5113973617554 51.8100852966309,11.5084972381592 51.8062591552735,11.5138158798218 51.8059005737306,11.512812614441 51.8018951416017,11.5287399291992 51.7997360229493,11.5271759033203 51.7985801696778,11.5280475616456 51.7979583740234,11.5327863693237 51.799015045166,11.5491275787353 51.7984924316407,11.5491847991944 51.8003463745118,11.5491847991944 51.8003463745118,11.5541210174561 51.7998161315918,11.5579586029054 51.7855491638184,11.5599718093873 51.7861099243165,11.5684337615968 51.7728157043458,11.5743494033813 51.7702903747559,11.5809240341187 51.7742042541503,11.5828685760499 51.7724075317383,11.5841054916383 51.7731971740724,11.5892143249513 51.7648544311524,11.5958309173584 51.749984741211,11.595775604248 51.748275756836,11.595775604248 51.748275756836,11.5842390060424 51.7495346069336,11.577922821045 51.7484741210938,11.5689468383789 51.7520217895508,11.5670871734619 51.7561492919923,11.5645313262941 51.7559661865236,11.5594549179078 51.7589874267579,11.5501079559327 51.756633758545,11.5500040054322 51.7596664428711,11.5473146438599 51.7593650817871,11.5460777282716 51.761688232422,11.5413274765015 51.7612915039064,11.5376749038696 51.7689781188965,11.5303049087525 51.7688179016114,11.528648376465 51.7718734741211,11.5256452560426 51.7718086242676,11.5265655517578 51.7747077941895,11.5194005966187 51.7889289855957,11.5169219970704 51.7890129089356,11.5170078277588 51.7915573120118,11.4896297454835 51.7928161621094,11.4910516738892 51.7961883544923,11.4818468093873 51.7965774536134,11.4881086349487 51.8063125610353,11.4895305633544 51.8163414001466,11.4895305633544 51.8163414001466,11.4993391036988 51.814811706543,11.5150527954102 51.8099822998047))	0.0006	POINT(11.540549857943711 51.78173222261321)
38911	POLYGON((2.13814306259161 43.0840721130372,2.13880252838146 43.0900611877441,2.14579415321361 43.0928230285645,2.14579415321361 43.0928230285645,2.15299415588379 43.1048622131349,2.16595506668102 43.1067085266114,2.16595506668102 43.1067085266114,2.16230988502514 43.1117439270021,2.16230988502514 43.1117439270021,2.14085006713867 43.119140625,2.14085006713867 43.119140625,2.13212537765509 43.1195907592774,2.12539625167847 43.1236648559571,2.10822153091436 43.121768951416,2.10822153091436 43.121768951416,2.10627102851868 43.1176719665528,2.10627102851868 43.1176719665528,2.11632537841797 43.0936737060547,2.12234210968018 43.0886306762695,2.12234210968018 43.0886306762695,2.13814306259161 43.0840721130372))	0.0006	POINT(2.135363721847585 43.10664501190191)
28175	POLYGON((5.39134120941173 47.0897560119628,5.39780998229992 47.0946502685547,5.40058755874645 47.1075630187989,5.40058755874645 47.1075630187989,5.39248323440557 47.1119194030762,5.38843297958374 47.1253242492676,5.37166547775269 47.1380462646486,5.37166547775269 47.1380462646486,5.36661577224737 47.129467010498,5.34960794448858 47.1259307861328,5.34960794448858 47.1259307861328,5.35480737686157 47.1162605285644,5.36589908599854 47.1092414855957,5.37011623382574 47.1073341369629,5.37938976287847 47.1100082397462,5.38838291168213 47.1072311401367,5.38438749313354 47.0974235534668,5.38438749313354 47.0974235534668,5.39134120941173 47.0897560119628))	0.0006	POINT(5.378209749857629 47.11328442891441)
1407848	POLYGON((-7.37327194213867 42.6989898681641,-7.38202905654907 42.6983566284181,-7.38513278961182 42.699977874756,-7.39296579360956 42.7106399536133,-7.40409278869623 42.7089881896973,-7.41626405715937 42.7005424499513,-7.42572402954102 42.700023651123,-7.4579992294311 42.7082328796387,-7.46547698974604 42.7077980041505,-7.47156476974482 42.7153816223146,-7.48141098022455 42.7166595458986,-7.49294090270996 42.7158584594728,-7.4940619468689 42.7131233215333,-7.51216506958008 42.7066917419434,-7.51987981796259 42.7112579345704,-7.52686786651611 42.7191734313965,-7.5371470451355 42.7220001220704,-7.54394102096552 42.7260589599609,-7.51398181915283 42.7476921081543,-7.51244115829462 42.7506866455078,-7.51321077346802 42.756088256836,-7.51144981384277 42.7603950500489,-7.50939607620239 42.7604064941406,-7.50927114486689 42.7667388916016,-7.52632617950434 42.7656974792481,-7.53238582611078 42.7716979980469,-7.52361822128296 42.7794876098633,-7.52182388305658 42.7884292602539,-7.51919603347778 42.7887725830078,-7.51355981826782 42.7864036560059,-7.50685882568354 42.8004684448242,-7.5035638809203 42.8019180297853,-7.48795604705805 42.8168334960938,-7.47420406341547 42.8264045715333,-7.4713249206543 42.8253402709962,-7.46471786499018 42.83056640625,-7.46320676803589 42.8343696594239,-7.45895195007319 42.8349075317384,-7.45617389678955 42.842872619629,-7.45410919189447 42.8442611694337,-7.43320178985596 42.8388366699219,-7.42504119873041 42.8347206115723,-7.41935920715326 42.8348045349122,-7.41156387329102 42.8318405151368,-7.40400218963623 42.8374977111818,-7.3861927986145 42.8377113342285,-7.38221120834351 42.8300247192383,-7.37751388549805 42.8300132751466,-7.37357997894287 42.8382072448731,-7.36904907226557 42.8428535461425,-7.3624968528747 42.8404769897461,-7.3545560836792 42.8429031372071,-7.35974979400623 42.8282356262208,-7.33172607421875 42.8152923583984,-7.33099222183228 42.8018341064454,-7.32707881927485 42.7953186035156,-7.32794713973999 42.7773056030275,-7.32890892028809 42.7733993530274,-7.34609079360962 42.7667579650879,-7.34751796722412 42.7681007385254,-7.35093879699707 42.7668724060059,-7.36820983886713 42.7521858215333,-7.37563800811768 42.7567024230957,-7.39254713058472 42.7551422119141,-7.39224195480347 42.7497863769532,-7.3881049156189 42.7481269836426,-7.38828516006464 42.7449798583985,-7.38113498687744 42.7433547973634,-7.3793511390686 42.7357063293457,-7.38139295578003 42.7326316833496,-7.37962722778315 42.7292327880861,-7.38248014450068 42.7184448242188,-7.38219118118286 42.7172775268555,-7.37629699707026 42.7164840698242,-7.37243413925165 42.7075386047364,-7.37327194213867 42.6989898681641))	0.0006	POINT(-7.43093758265175 42.769343922932975)
55347	POLYGON((6.880036354065 46.055248260498,6.88059902191173 46.0531425476074,6.88543987274181 46.0489730834962,6.89334583282482 46.0459213256837,6.89933919906616 46.0481719970704,6.90229797363287 46.050350189209,6.90953445434582 46.0519981384277,6.92208909988409 46.0627975463867,6.92778491973883 46.0634422302246,6.92944288253784 46.0671958923341,6.93343114852911 46.0663566589356,6.93907117843639 46.0666618347168,6.94196510314941 46.0635223388672,6.94060611724854 46.0585823059083,6.9412260055542 46.0565872192384,6.9474511146546 46.0518074035645,6.95209217071545 46.0508308410645,6.95209217071545 46.0508308410645,6.95588397979748 46.0472068786621,6.95865488052374 46.0416679382324,6.96515130996704 46.0333442687989,6.96515130996704 46.0333442687989,6.96222639083862 46.0316352844239,6.96290397644049 46.0305328369141,6.94680881500256 46.0234336853028,6.93059730529791 46.0059547424318,6.90666389465332 46.0018043518066,6.87228393554688 45.9883079528809,6.86240816116333 45.989315032959,6.85464334487915 45.9936828613282,6.85533523559582 46.0072364807129,6.85533523559582 46.0072364807129,6.84616756439209 46.018409729004,6.84616756439209 46.018409729004,6.85163211822521 46.0240058898926,6.85191059112555 46.0340728759767,6.86125850677496 46.0458908081055,6.880036354065 46.055248260498))	0.0006	POINT(6.91051429026841 46.03751115541205)
13730	POLYGON((14.575140953064 40.9101104736329,14.5743627548218 40.9103965759278,14.5743627548218 40.9103965759278,14.5660800933838 40.9095268249513,14.5660800933838 40.9095268249513,14.5555095672608 40.9010543823243,14.5555095672608 40.9010543823243,14.5549354553224 40.8931961059571,14.5549354553224 40.8931961059571,14.5583028793335 40.8901748657228,14.5583028793335 40.8901748657228,14.5603313446046 40.8889770507813,14.5603313446046 40.8889770507813,14.5685501098634 40.8931846618652,14.5685501098634 40.8931846618652,14.5733871459961 40.8976707458497,14.5757856369019 40.9015617370605,14.5773611068725 40.905746459961,14.5764360427857 40.9093475341797,14.575140953064 40.9101104736329))	0.0006	POINT(14.566013436568465 40.89986620451282)
49105	POLYGON((-0.959953784942627 46.411190032959,-0.973124265670776 46.4137687683107,-0.978015899658146 46.4084510803222,-0.978015899658146 46.4084510803222,-0.98213225603098 46.3885917663575,-0.980283677577916 46.371810913086,-0.978288710117283 46.3687438964844,-0.96451336145401 46.3654022216798,-0.96451336145401 46.3654022216798,-0.958076894283295 46.3709373474121,-0.958601057529449 46.3808631896973,-0.946725189685822 46.3863410949707,-0.956089854240304 46.3936729431153,-0.959953784942627 46.411190032959))	0.0006	POINT(-0.9675641701771357 46.38720204279977)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point