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.
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 | geometryDieser 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:
| beliebig | Die simplifizierten Geodaten. |
epsilon | float(5,4) | beliebig | Die Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone. |
mittelpunkt | pointDieser 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:
| beliebig | Der geometrische Mittelpunkt des vereinfachten Polygons. |
Ausschnitt
id_ort | geodaten | epsilon | mittelpunkt |
---|---|---|---|
54824 | POLYGON((4.56711578369146 45.181770324707,4.57451581954967 45.1773147583009,4.57469606399536 45.1669921875001,4.59059810638433 45.1598777770997,4.59070348739635 45.1564254760742,4.57726287841803 45.1465377807618,4.55819892883306 45.1442489624024,4.54279327392589 45.1310729980469,4.54279327392589 45.1310729980469,4.52974748611462 45.1313591003419,4.52583169937139 45.1398506164552,4.52583169937139 45.1398506164552,4.51321792602539 45.1528663635254,4.51321792602539 45.1528663635254,4.52269554138195 45.1685791015624,4.5361385345459 45.1722373962403,4.5361385345459 45.1722373962403,4.55523824691778 45.1755027770997,4.56711578369146 45.181770324707)) | 0.0006 | POINT(4.548707511689987 45.15559238857699) |
13717 | POLYGON((14.5366249084474 40.9379806518555,14.5347890853883 40.9408226013185,14.5236320495607 40.9365463256835,14.5094690322877 40.9446258544922,14.5063047409057 40.9516220092773,14.5064640045165 40.9557304382324,14.511022567749 40.95613861084,14.511022567749 40.95613861084,14.5131788253784 40.9538307189941,14.5341243743897 40.9440269470216,14.5385179519654 40.9443244934082,14.5385179519654 40.9443244934082,14.5362491607666 40.9407539367676,14.5362491607666 40.9407539367676,14.5366249084474 40.9379806518555)) | 0.0006 | POINT(14.524011884416883 40.94625854492191) |
24876 | POLYGON((3.53006386756903 45.7919502258302,3.5307714939118 45.7985916137695,3.52021646499634 45.8056373596192,3.51912593841547 45.8156394958496,3.51352238655102 45.8210029602051,3.51352238655102 45.8210029602051,3.50208854675304 45.8156700134277,3.48814392089849 45.7984771728516,3.47109484672541 45.7920227050782,3.47109484672541 45.7920227050782,3.47695159912121 45.788990020752,3.47695159912121 45.788990020752,3.49528169631969 45.7933425903321,3.49921607971191 45.7913970947266,3.50424075126648 45.7749481201172,3.50424075126648 45.7749481201172,3.51421403884893 45.7860260009766,3.53006386756903 45.7919502258302)) | 0.0006 | POINT(3.501808306750172 45.79709759880518) |
70028 | POLYGON((10.1416549682617 53.7772178649903,10.145998954773 53.7801742553712,10.143674850464 53.7825393676757,10.1469841003419 53.7840766906739,10.1496582031249 53.7873649597169,10.1517772674561 53.7879371643068,10.1517772674561 53.7879371643068,10.1550579071045 53.7912864685059,10.1572227478027 53.7919311523438,10.1570377349854 53.7942466735841,10.1522254943847 53.8002166748047,10.1527462005616 53.8015213012696,10.1476287841797 53.8056755065919,10.1384754180908 53.8076248168946,10.1362018585205 53.8108520507813,10.1362018585205 53.8108520507813,10.1333799362183 53.8125076293945,10.1305980682373 53.8183479309082,10.1277713775634 53.8204307556152,10.1186780929565 53.8221130371094,10.1161260604858 53.8205413818359,10.1155824661256 53.81840133667,10.1137695312501 53.8174591064453,10.1137695312501 53.8174591064453,10.1125621795655 53.8148689270019,10.1133975982667 53.8096885681153,10.1121664047242 53.8048439025879,10.1131420135499 53.8026351928711,10.1131420135499 53.8026351928711,10.1165676116944 53.7979583740236,10.1157989501954 53.7939224243165,10.1167707443237 53.7921104431153,10.1158447265626 53.7886848449708,10.1184654235839 53.7822303771974,10.1132144927979 53.7774085998536,10.1169996261597 53.774715423584,10.1169996261597 53.774715423584,10.1233615875245 53.7721748352051,10.1325883865358 53.7714385986329,10.1325883865358 53.7714385986329,10.1365709304811 53.7757644653321,10.1416549682617 53.7772178649903)) | 0.0006 | POINT(10.130589741032342 53.79648655216873) |
62676 | MULTIPOLYGON(((8.90434741973877 52.7483367919923,8.90396499633795 52.7527618408203,8.90753269195562 52.7537574768068,8.9079523086549 52.7548789978028,8.90970993041998 52.755054473877,8.90956115722656 52.752166748047,8.91358661651623 52.7531471252442,8.91507530212408 52.7554244995118,8.91766738891602 52.7544898986817,8.91764068603521 52.7552490234374,8.91955089569092 52.7554664611817,8.91943454742426 52.7563095092774,8.92227363586437 52.7557678222657,8.92521381378185 52.7564926147462,8.92164516448986 52.7572402954102,8.92461681365978 52.7577362060547,8.92430973052984 52.7590370178223,8.92558097839361 52.7600936889649,8.92811584472662 52.7599334716797,8.93588733673107 52.7627105712891,8.93498325347906 52.7638854980469,8.93617439270025 52.7646446228028,8.94108772277832 52.7654418945313,8.94574546813965 52.7645950317382,8.94585990905773 52.7624549865723,8.94962787628185 52.7623863220216,8.95115852355957 52.7646179199219,8.95164585113537 52.7686462402344,8.97370910644537 52.7699737548828,8.96852397918701 52.7754554748536,8.97177505493158 52.7755737304688,8.97504711151123 52.7776412963868,8.97341156005859 52.7799835205079,8.97646331787109 52.7839698791504,8.98077011108398 52.7856864929199,8.97927665710449 52.7875862121582,8.98470306396484 52.7885437011719,8.98507404327398 52.789421081543,8.99114608764654 52.7897033691407,8.99450111389166 52.7971115112305,8.99932098388683 52.7967376708985,8.99968910217291 52.7976875305175,9.00626087188726 52.7989311218262,9.00630378723145 52.7976455688477,9.0077161788941 52.7976875305175,9.00771522521978 52.7988777160645,9.02011013031 52.8003845214844,9.01996803283703 52.8026924133301,9.0141344070434 52.802318572998,9.01340961456299 52.8049087524415,9.01712131500244 52.8062095642091,9.01866817474371 52.8047447204589,9.01924324035645 52.8066596984863,9.04101657867437 52.8065452575684,9.03799533844 52.8050079345704,9.03916263580328 52.8010826110841,9.03617191314692 52.8004341125489,9.036777496338 52.7996139526368,9.0404052734375 52.8003082275391,9.04237842559809 52.7980384826661,9.04188537597656 52.7967796325684,9.04647731781006 52.7947425842286,9.04907321929937 52.7974891662597,9.0547342300415 52.7953987121581,9.0547342300415 52.7953987121581,9.06053352355963 52.7968139648439,9.06053352355963 52.7968139648439,9.06155204772955 52.7969894409181,9.06008148193365 52.8011627197267,9.06742858886713 52.8038558959962,9.06613254547119 52.8072586059571,9.055009841919 52.8074684143066,9.04555606842041 52.8111419677734,9.03994464874268 52.8148078918458,9.03816223144537 52.8143882751465,9.03622531890869 52.8168830871583,9.03993320465099 52.8178825378419,9.04741954803478 52.8177108764649,9.04436874389654 52.8156967163087,9.04817676544195 52.8149681091309,9.05313014984131 52.8155403137208,9.05261325836182 52.8168563842773,9.05799865722662 52.8173789978027,9.05940818786621 52.8206062316895,9.05319786071783 52.8207931518555,9.0575647354126 52.8220748901368,9.06047821044928 52.8242607116699,9.05988788604748 52.8268966674805,9.04758644104015 52.8306274414062,9.04811382293701 52.833724975586,9.04212951660156 52.8360290527344,9.04221153259272 52.8366966247559,9.03451156616222 52.8387489318848,9.03591823577892 52.8415832519532,9.03591823577892 52.8415832519532,9.02404594421398 52.8451194763185,9.01473522186279 52.8490638732911,9.01698589324951 52.8506011962892,9.00026798248302 52.8576507568361,9.0017404556275 52.8593673706056,8.99525547027594 52.8622016906738,8.99070072174078 52.8655166625977,8.99070072174078 52.8655166625977,8.98953437805176 52.8662033081056,8.98953437805176 52.8662033081056,8.98623943328852 52.8648071289063,8.98250961303711 52.8646621704102,8.98289585113531 52.8568840026856,8.98006820678717 52.8570289611816,8.97364616394049 52.8528137207032,8.96934127807617 52.8527221679688,8.96518707275385 52.8452606201173,8.96022796630854 52.8439102172853,8.95905685424805 52.8404235839844,8.95671844482428 52.8410415649415,8.95611095428461 52.8397140502931,8.96019744873058 52.8370666503906,8.95125198364263 52.8329620361329,8.93873214721691 52.8334579467773,8.93957233428949 52.8242950439453,8.93786716461187 52.8191642761231,8.9346981048584 52.8168296813965,8.9140415191651 52.8145751953125,8.91383266448986 52.8125305175781,8.91176795959478 52.8117485046388,8.90935039520275 52.8141899108887,8.90907287597668 52.8161468505859,8.90198707580566 52.8163070678711,8.90196895599371 52.8147315979004,8.89350223541254 52.8140907287597,8.8868141174317 52.8151321411132,8.8868141174317 52.8151321411132,8.88584995269787 52.8094024658204,8.88584995269787 52.8094024658204,8.88577079772961 52.8074951171876,8.88876914978033 52.8067398071288,8.89073753356945 52.8034934997559,8.88837337493896 52.8035736083985,8.88702011108404 52.8023834228516,8.89026451110846 52.8009719848634,8.89122200012218 52.797981262207,8.89429092407238 52.7936706542969,8.89072799682617 52.7912445068361,8.89305305480963 52.789894104004,8.89614009857178 52.7902908325196,8.89672565460211 52.7892761230469,8.89601898193359 52.7871017456054,8.89334392547619 52.7867927551271,8.89733028411865 52.7782402038574,8.89137840270996 52.7775497436525,8.89128017425543 52.7736892700196,8.88642978668224 52.7648353576661,8.88551616668713 52.760799407959,8.88934326171875 52.7577323913575,8.88545608520513 52.7567749023437,8.88545608520513 52.7567749023437,8.89021968841547 52.7537651062013,8.89281558990484 52.7500686645509,8.89219856262201 52.7492790222168,8.88949203491217 52.7492942810059,8.8910312652589 52.7481079101563,8.8910312652589 52.7481079101563,8.89272975921631 52.7482833862305,8.89509582519537 52.7453155517579,8.90434741973877 52.7483367919923)),((8.8992738723756 52.7611007690431,8.89970874786371 52.7588233947754,8.89808559417725 52.760929107666,8.89568328857428 52.7606010437012,8.89477157592773 52.7626800537109,8.8987922668457 52.7635917663574,8.8992738723756 52.7611007690431))) | 0.0006 | POINT(8.967755766927155 52.799594455504234) |
42711 | POLYGON((6.10008668899542 49.4497566223145,6.10081338882446 49.4528884887695,6.10081338882446 49.4528884887695,6.10076999664301 49.4536361694336,6.10071754455572 49.4545440673829,6.10000848770142 49.4667778015137,6.10754203796398 49.4715499877929,6.12215852737427 49.4745025634766,6.12922096252441 49.4902839660646,6.12960338592541 49.491138458252,6.13907718658459 49.4889907836915,6.14461183547985 49.487735748291,6.14461183547985 49.487735748291,6.15235090255737 49.4842529296876,6.16575145721441 49.4868621826172,6.16575145721441 49.4868621826172,6.1737642288208 49.4842491149902,6.17653703689587 49.4790763854982,6.17653703689587 49.4790763854982,6.15774250030518 49.4740295410156,6.15741682052624 49.4640083312989,6.14957809448248 49.4486770629883,6.14957809448248 49.4486770629883,6.14023494720459 49.4375495910645,6.14023494720459 49.4375495910645,6.12768220901489 49.4425354003907,6.12321758270269 49.448299407959,6.109453201294 49.4522514343262,6.10008668899542 49.4497566223145)) | 0.0006 | POINT(6.13520949227474 49.46701376778742) |
1405340 | POLYGON((-2.49058008193964 42.5853500366212,-2.49425411224365 42.6012153625488,-2.49930191040033 42.6115493774415,-2.50003099441528 42.6164665222168,-2.4830219745636 42.6121520996093,-2.47985410690302 42.6153564453126,-2.4768071174621 42.6119804382325,-2.47360301017761 42.6142654418945,-2.47430706024164 42.6161117553712,-2.47147393226624 42.6177520751953,-2.45348501205439 42.6172332763672,-2.44386005401611 42.6157493591309,-2.44147801399231 42.6142807006836,-2.44180011749268 42.6108512878419,-2.43968200683594 42.6142883300781,-2.4381279945373 42.6146659851075,-2.43604493141174 42.6107406616212,-2.43342399597168 42.6088981628419,-2.43807792663574 42.6083221435548,-2.43817090988153 42.6067924499512,-2.43708395957941 42.6055488586427,-2.43668508529657 42.6011047363281,-2.43400001525879 42.5963935852052,-2.43463206291193 42.5929183959961,-2.43352603912348 42.5908088684083,-2.44374394416803 42.5746765136719,-2.45319104194641 42.5671043395996,-2.4599618911742 42.5788421630859,-2.46215391159058 42.5873794555664,-2.4724609851836 42.5893554687501,-2.4836630821228 42.589153289795,-2.48887705802912 42.5877380371093,-2.49058008193964 42.5853500366212)) | 0.0006 | POINT(-2.4589801356196075 42.60265767574314) |
69206 | POLYGON((9.22257423400879 54.3226280212402,9.22435283660889 54.3222045898438,9.22645759582525 54.3232498168946,9.22740077972423 54.324607849121,9.22729396820068 54.3271636962891,9.22729396820068 54.3271636962891,9.23292922973633 54.3272743225098,9.2326288223266 54.3218231201172,9.23748111724859 54.3192825317383,9.24375057220465 54.3186836242676,9.24517154693615 54.3157768249512,9.23943901062012 54.3122367858887,9.23490715026855 54.3106994628906,9.23398303985601 54.3050613403321,9.23533821105957 54.3028488159181,9.23367595672607 54.2977828979492,9.23519611358637 54.296730041504,9.23709297180176 54.2922592163087,9.23583221435558 54.2917785644532,9.23691558837896 54.2857360839844,9.23989486694347 54.2862243652345,9.24218940734858 54.2785720825196,9.23589801788336 54.2812004089357,9.23592567443848 54.2797393798829,9.23592567443848 54.2797393798829,9.2265033721925 54.2771263122559,9.21865558624268 54.2788543701172,9.2053689956665 54.2782402038575,9.2053689956665 54.2782402038575,9.20108985900885 54.2857933044433,9.19931030273443 54.2964248657227,9.20218467712414 54.3064880371093,9.20578765869146 54.3102340698243,9.20578765869146 54.3102340698243,9.2079372406007 54.3092308044435,9.22625350952148 54.3114738464356,9.22604179382336 54.3155059814453,9.22276687622082 54.3192329406738,9.22200393676769 54.3216590881347,9.22257423400879 54.3226280212402)) | 0.0006 | POINT(9.226528436709712 54.303825769669004) |
1403266 | POLYGON((2.02224302291864 41.7077178955078,2.02879095077515 41.7109260559083,2.03272700309759 41.7165603637696,2.03838610649115 41.717010498047,2.04851508140575 41.7108840942384,2.06466007232666 41.7119026184083,2.06612801551819 41.7140769958496,2.07703590393078 41.7099227905275,2.08466601371765 41.7108535766602,2.08708500862122 41.7078590393067,2.08412194252014 41.7021446228028,2.08606600761425 41.6952629089355,2.09053993225109 41.6942901611329,2.09656405448908 41.6881256103516,2.09680509567272 41.6816139221193,2.09990906715399 41.6815567016601,2.1064760684967 41.6781845092773,2.11293506622326 41.6692199707031,2.11258101463324 41.6667404174805,2.10451793670666 41.6646804809571,2.10282206535345 41.661304473877,2.09591388702398 41.6589546203613,2.09088611602783 41.6596145629884,2.08828592300426 41.6611785888672,2.08865690231323 41.6636009216309,2.08591103553783 41.6663970947266,2.08001708984386 41.6664047241212,2.07131791114807 41.6634216308595,2.06625604629528 41.659812927246,2.04966807365429 41.6566543579102,2.04069995880127 41.6529426574708,2.03543901443487 41.655975341797,2.02861595153814 41.6546821594239,2.02597188949596 41.6564903259277,2.0208420753479 41.6567687988281,2.01899790763855 41.655445098877,2.01457405090338 41.6569061279298,2.01453304290777 41.6585235595703,2.01208496093756 41.6562232971192,2.01050806045538 41.6581840515138,2.01094102859497 41.6657638549805,2.00460004806513 41.6757812500001,2.00615906715393 41.6781005859376,2.01053500175487 41.6783218383788,2.01307201385504 41.6805000305177,2.00949096679688 41.6863517761231,2.00953006744385 41.6924209594728,2.01303791999823 41.6920852661133,2.02034497261047 41.6967620849611,2.02205610275274 41.6989936828614,2.0201370716095 41.7053413391113,2.02224302291864 41.7077178955078)) | 0.0006 | POINT(2.053385482114949 41.67979296515975) |
52076 | POLYGON((-0.520005583763123 45.5739173889161,-0.539556741714478 45.5643348693848,-0.539310812950077 45.5510368347169,-0.539310812950077 45.5510368347169,-0.526582479476929 45.5473823547364,-0.517263472080231 45.5357666015625,-0.508362054824772 45.5351524353028,-0.500169515609741 45.5270690917969,-0.500169515609741 45.5270690917969,-0.477316349744797 45.5384979248047,-0.477316349744797 45.5384979248047,-0.484462052583581 45.5456695556641,-0.477471321821213 45.5567169189453,-0.477471321821213 45.5567169189453,-0.504913151264077 45.5635795593262,-0.515415012836456 45.5751953125001,-0.520005583763123 45.5739173889161)) | 0.0006 | POINT(-0.5065685342997064 45.54922747612004) |