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
1405932	POLYGON((-0.291949987411499 38.7722320556642,-0.283500999212208 38.7828826904297,-0.286680996417942 38.7925262451172,-0.285625010728836 38.8057441711427,-0.282364010810852 38.8073272705079,-0.280362993478718 38.8048934936523,-0.276093989610558 38.8057022094727,-0.274758994579315 38.8042030334474,-0.264586985111237 38.8082160949708,-0.252609997987747 38.8094940185547,-0.248795002698841 38.8059997558595,-0.240404993295613 38.8064842224122,-0.235660001635495 38.8050231933594,-0.226124003529492 38.8003654479982,-0.213210999965554 38.7910804748535,-0.211459994316101 38.7925720214844,-0.210710003972054 38.7899703979493,-0.21297599375248 38.7902832031251,-0.208921000361443 38.78125,-0.210805997252464 38.7753829956055,-0.206974998116493 38.7753562927247,-0.199796006083488 38.770851135254,-0.212551996111756 38.7735252380371,-0.214985996484756 38.7749748229981,-0.220516994595528 38.7749328613282,-0.229849994182587 38.7788009643555,-0.241125002503338 38.7769775390626,-0.244642004370689 38.7755432128906,-0.255544990301132 38.7752838134767,-0.280880004167557 38.7642822265625,-0.286985993385201 38.7662544250489,-0.291949987411499 38.7722320556642))	0.0006	POINT(-0.2448856753687411 38.78833598475308)
71385	POLYGON((13.5393333435059 46.5540237426759,13.5787391662599 46.565887451172,13.5866708755494 46.566520690918,13.6124439239503 46.5648384094239,13.6411638259889 46.5725097656251,13.6411638259889 46.5725097656251,13.6525020599365 46.565788269043,13.6572742462159 46.5640907287597,13.6843023300172 46.5671195983888,13.6843023300172 46.5671195983888,13.6843252182006 46.5505371093751,13.6832361221313 46.5467948913574,13.6814918518067 46.5454177856446,13.6742248535157 46.5451698303224,13.6391620635987 46.5489273071288,13.6334285736084 46.5476875305175,13.6253032684327 46.5433425903321,13.6253032684327 46.5433425903321,13.6169061660767 46.5440979003907,13.6097831726075 46.5462875366211,13.6064014434814 46.5473289489746,13.6064014434814 46.5473289489746,13.5936107635499 46.5476303100586,13.5912656784058 46.5450859069825,13.5912656784058 46.5450859069825,13.5898399353027 46.5441932678224,13.5869379043579 46.5423736572266,13.5849475860596 46.5411262512208,13.5812282562256 46.5405998229982,13.5772829055786 46.5400428771974,13.5772829055786 46.5400428771974,13.5693588256836 46.5460433959962,13.5693588256836 46.5460433959962,13.5689802169801 46.5469245910644,13.5686292648317 46.5477409362793,13.5686292648317 46.5477409362793,13.5636434555054 46.5530014038087,13.5592098236084 46.5537300109864,13.5592098236084 46.5537300109864,13.5555143356323 46.553783416748,13.5550642013551 46.5537910461425,13.5550642013551 46.5537910461425,13.5541162490844 46.5538787841796,13.5541162490844 46.5538787841796,13.5521259307862 46.5541496276857,13.5460748672486 46.5549774169923,13.5460748672486 46.5549774169923,13.5446310043336 46.554412841797,13.5446310043336 46.554412841797,13.5445079803466 46.5543632507324,13.5434875488282 46.5539627075196,13.5434875488282 46.5539627075196,13.5416822433472 46.5539894104004,13.5393333435059 46.5540237426759))	0.0006	POINT(13.593304202241765 46.552002600903826)
26608	POLYGON((-0.698228597640991 49.0580215454103,-0.695436179637909 49.0595817565919,-0.695436179637909 49.0595817565919,-0.670839548110905 49.0727844238281,-0.670839548110905 49.0727844238281,-0.671549856662637 49.0845565795898,-0.671549856662637 49.0845565795898,-0.67067760229105 49.0871391296387,-0.67067760229105 49.0871391296387,-0.692497253417855 49.0819778442383,-0.692497253417855 49.0819778442383,-0.711837768554631 49.0667457580566,-0.711837768554631 49.0667457580566,-0.71093487739563 49.0654220581056,-0.71093487739563 49.0654220581056,-0.698228597640991 49.0580215454103))	0.0006	POINT(-0.6897183179854818 49.07296244303389)
1398550	POLYGON((-4.82856702804554 40.4191207885742,-4.83597183227539 40.4236145019532,-4.836510181427 40.4273529052734,-4.84187316894531 40.4294853210449,-4.85857915878296 40.4257049560548,-4.87053489685059 40.4267463684083,-4.87543106079102 40.4382858276368,-4.87321615219111 40.4417610168458,-4.87489080429077 40.444751739502,-4.87750720977778 40.4446754455567,-4.87822103500366 40.4469795227052,-4.8810081481933 40.4476013183594,-4.87590980529779 40.4482955932617,-4.86527109146118 40.4528732299805,-4.86246490478516 40.4516410827637,-4.85423517227173 40.4542198181153,-4.83554077148426 40.4541244506837,-4.83212280273438 40.455493927002,-4.83021688461298 40.4599914550782,-4.82444190979004 40.4601440429688,-4.82013177871698 40.4572944641114,-4.80957794189447 40.4542350769044,-4.80828094482422 40.4516181945801,-4.80424404144287 40.451499938965,-4.80106019973755 40.4444618225098,-4.79849576950068 40.4437866210938,-4.79936218261713 40.4408912658693,-4.79345703124994 40.4387397766114,-4.79072904586792 40.4336471557617,-4.79250001907349 40.4315757751464,-4.79621696472168 40.4339599609374,-4.80782508850092 40.4346504211426,-4.80758094787598 40.4281692504883,-4.81394910812372 40.4265213012695,-4.8177552223205 40.4207496643066,-4.82413721084589 40.4187774658204,-4.82856702804554 40.4191207885742))	0.0006	POINT(-4.83327270878683 40.440651151869076)
53619	MULTIPOLYGON(((5.39983797073364 43.2746238708497,5.39566469192505 43.2648887634278,5.39577960968018 43.247787475586,5.38949680328381 43.2346076965333,5.38051748275757 43.2266883850098,5.38097095489513 43.2095832824708,5.38097095489513 43.2095832824708,5.37597322463989 43.2098617553712,5.3743047714234 43.2081947326661,5.37152910232544 43.2081947326661,5.37069511413586 43.2073593139649,5.36236000061041 43.2068061828613,5.36069393157959 43.2084732055665,5.35458278656006 43.2081947326661,5.35180521011353 43.2104148864746,5.34763908386242 43.2112503051757,5.34736108779907 43.2120819091797,5.34124994277954 43.2120819091797,5.34041595458996 43.2131958007812,5.33902788162243 43.2129173278809,5.3359718322755 43.214584350586,5.33652782440197 43.21541595459,5.33985996246344 43.214584350586,5.34180402755743 43.2170829772949,5.34513902664196 43.2168045043945,5.34458303451549 43.2223625183107,5.34625101089472 43.2245826721192,5.34625101089472 43.2265281677247,5.34791707992554 43.227638244629,5.34819507598888 43.2306938171387,5.35236120223999 43.2337493896486,5.35569286346441 43.233470916748,5.36097192764288 43.238193511963,5.36097192764288 43.2393074035645,5.36236000061041 43.2401390075685,5.3615279197694 43.2429161071778,5.36347198486334 43.2465286254884,5.36513805389416 43.245418548584,5.36930704116833 43.2462501525878,5.37013912200933 43.2445831298829,5.37319517135626 43.2456932067871,5.37319517135626 43.247917175293,5.37486076354986 43.2481956481934,5.37569522857672 43.2534713745117,5.37486076354986 43.2579154968262,5.37736082077032 43.2576370239258,5.37874889373779 43.2548599243165,5.3815269470216 43.2551383972169,5.38041687011724 43.2615280151368,5.37902688980114 43.2604179382324,5.37513923645025 43.260971069336,5.37375116348272 43.2620849609376,5.37291717529297 43.2662506103516,5.36875104904186 43.2685585021974,5.36875104904186 43.2685585021974,5.37203025817882 43.2696113586426,5.37381601333624 43.2791938781739,5.37381601333624 43.2791938781739,5.38873672485357 43.2831497192384,5.38873672485357 43.2831497192384,5.39983797073364 43.2746238708497)),((5.32624912261963 43.2151374816896,5.32791805267334 43.2148628234864,5.32819604873669 43.2131958007812,5.32930612564087 43.2126388549805,5.3393058776856 43.2126388549805,5.34069395065308 43.2095832824708,5.33874988555908 43.2073593139649,5.33708381652826 43.2084732055665,5.33319377899176 43.2087516784669,5.32874917984009 43.2109718322753,5.3276391029359 43.2126388549805,5.32541704177862 43.2131958007812,5.32513904571528 43.2148628234864,5.32624912261963 43.2151374816896)),((5.3559708595277 43.2018051147462,5.3587498664856 43.200138092041,5.36347198486334 43.200138092041,5.36625003814692 43.1976394653321,5.36819410324108 43.1973609924317,5.36875104904186 43.1956939697266,5.37097311019897 43.1951370239258,5.37125110626232 43.1934738159181,5.3615279197694 43.1965293884277,5.35986185073853 43.1987495422364,5.35652780532848 43.1990280151368,5.35458278656006 43.2009735107422,5.3559708595277 43.2018051147462)),((5.38347101211554 43.1906929016114,5.38541603088385 43.1898612976074,5.38597202301031 43.1881942749023,5.39097213745117 43.1868057250978,5.39125013351452 43.1856956481934,5.38847208023071 43.1848602294922,5.38291501998907 43.1873626708986,5.38097095489513 43.1898612976074,5.38347101211554 43.1906929016114)),((5.38097095489513 43.1806945800782,5.38263988494884 43.1795845031739,5.38458395004278 43.1798629760743,5.38486194610596 43.1790275573731,5.38680601119989 43.1793060302735,5.3895840644837 43.1776390075684,5.3962512016297 43.1765289306642,5.39875078201288 43.1743049621583,5.39875078201288 43.173194885254,5.3979167938233 43.1723594665528,5.38597202301031 43.1720848083496,5.38458395004278 43.1729164123536,5.38458395004278 43.1740264892579,5.3815269470216 43.1740264892579,5.38013887405407 43.1754150390625,5.37736082077032 43.1751403808594,5.37208318710333 43.1770820617676,5.37180519103998 43.1798629760743,5.38097095489513 43.1806945800782)))	0.0006	POINT(5.366344955860599 43.232430283891645)
37313	POLYGON((0.886200785636902 48.7654876708984,0.882474899292049 48.7623901367189,0.882474899292049 48.7623901367189,0.862513542175293 48.7646331787111,0.853362560272217 48.7723693847656,0.833744108677024 48.7678680419922,0.833744108677024 48.7678680419922,0.825812458992061 48.7723579406739,0.823301136493683 48.7823066711427,0.805702269077358 48.7948150634767,0.801958024501801 48.8012619018556,0.801958024501801 48.8012619018556,0.797026634216365 48.8109588623047,0.801555633544979 48.8208236694336,0.801555633544979 48.8208236694336,0.801822602748871 48.8209533691406,0.801822602748871 48.8209533691406,0.836285710334892 48.8237609863282,0.836285710334892 48.8237609863282,0.837984502315578 48.8172950744629,0.847440779209194 48.8152770996094,0.851237595081386 48.809425354004,0.868915319442863 48.8091659545898,0.868915319442863 48.8091659545898,0.871368765830994 48.8061256408693,0.860476016998291 48.7944145202637,0.861742973327637 48.7910804748536,0.880531013011989 48.7750701904297,0.886200785636902 48.7654876708984))	0.0006	POINT(0.839936201061568 48.79585947309227)
47359	POLYGON((2.40600705146795 50.5587310791017,2.39682078361523 50.5528373718262,2.39237880706793 50.5531730651855,2.39237880706793 50.5531730651855,2.38892173767096 50.5513076782226,2.39455151557917 50.5435523986818,2.39455151557917 50.5435523986818,2.41403222084057 50.544761657715,2.42575240135199 50.5385246276856,2.43573808670044 50.5372848510743,2.43573808670044 50.5372848510743,2.43573951721197 50.5384063720704,2.43573951721197 50.5384063720704,2.41950011253357 50.5469741821289,2.41663694381725 50.5594367980957,2.40600705146795 50.5587310791017))	0.0006	POINT(2.4122991402944365 50.546493784586644)
36911	POLYGON((5.53446722030651 46.6667480468751,5.5343017578125 46.6702194213868,5.5463891029359 46.6812744140626,5.54441833496094 46.6844711303712,5.54441833496094 46.6844711303712,5.53936147689819 46.6997909545898,5.53936147689819 46.6997909545898,5.53543949127197 46.698528289795,5.53276014328014 46.7008743286133,5.53276014328014 46.7008743286133,5.52695751190186 46.705623626709,5.51045513153088 46.7010498046876,5.51045513153088 46.7010498046876,5.50639390945435 46.6953277587891,5.48261165618896 46.6949272155761,5.48261165618896 46.6949272155761,5.48294496536266 46.6893310546875,5.48294496536266 46.6893310546875,5.51135301589966 46.6765708923341,5.51135301589966 46.6765708923341,5.52283811569214 46.6707954406739,5.52496480941778 46.6641731262208,5.52496480941778 46.6641731262208,5.53446722030651 46.6667480468751))	0.0006	POINT(5.520196790280594 46.68743017445444)
53524	POLYGON((5.62385225296026 43.6661491394044,5.60694360733032 43.6586875915527,5.60694360733032 43.6586875915527,5.61075496673584 43.6525268554688,5.60671710968018 43.6463470458984,5.60270166397089 43.6122512817383,5.60579109191906 43.6022567749023,5.61395168304455 43.5942993164062,5.61395168304455 43.5942993164062,5.62829399108887 43.5864295959473,5.63230943679815 43.5802803039551,5.64121484756481 43.5781669616699,5.64784860610962 43.5697593688965,5.66931486129761 43.564640045166,5.66931486129761 43.564640045166,5.65691947937012 43.5752792358399,5.68757677078247 43.584213256836,5.68960714340221 43.5873756408692,5.68088388442999 43.61088180542,5.70060062408442 43.6425247192383,5.70994424819958 43.6416549682618,5.71897315979004 43.6498374938966,5.71897315979004 43.6498374938966,5.71958112716675 43.6568984985352,5.70043563842785 43.6813964843751,5.68282127380371 43.6928253173829,5.68282127380371 43.6928253173829,5.67311286926281 43.6935081481935,5.65715408325207 43.6854438781739,5.64142227172852 43.671989440918,5.62385225296026 43.6661491394044))	0.0006	POINT(5.65669104258223 43.62819709777835)
1388048	POLYGON((-5.29900598526001 38.3792762756347,-5.31250286102295 38.38045501709,-5.32722377777094 38.3915138244629,-5.33167505264277 38.3928680419923,-5.35332679748529 38.3882904052736,-5.38278198242188 38.3925094604493,-5.39312982559204 38.4010696411134,-5.40389585494989 38.4350357055665,-5.44764423370361 38.4828567504883,-5.44564580917358 38.4935417175293,-5.44697713851917 38.4986839294434,-5.45041418075562 38.4982452392578,-5.4486517906189 38.5020904541016,-5.44469976425171 38.5049400329591,-5.43452310562134 38.5044059753418,-5.4276909828186 38.5146560668945,-5.41883420944214 38.5125503540039,-5.41584777832026 38.5206642150879,-5.41030979156488 38.5199623107911,-5.41023015975946 38.5241165161134,-5.41341876983643 38.5240859985353,-5.4159049987793 38.5302276611329,-5.40349483489985 38.5360870361329,-5.40705108642572 38.543327331543,-5.39960002899164 38.5466156005861,-5.39658308029175 38.5462913513184,-5.39038801193237 38.5400657653808,-5.38455581665033 38.5392303466797,-5.37098121643055 38.5237464904786,-5.35185194015503 38.506561279297,-5.3491740226745 38.494010925293,-5.34389114379883 38.4842224121095,-5.33472204208368 38.4721717834473,-5.32569217681885 38.4551162719727,-5.3204779624939 38.4493980407715,-5.31899213790894 38.4294319152831,-5.30846691131592 38.4093589782716,-5.30495882034302 38.3973884582519,-5.30485916137695 38.3880462646485,-5.29900598526001 38.3792762756347))	0.0006	POINT(-5.3807711601257076 38.475720919095615)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point