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 |
|---|---|---|---|
| 69986 | POLYGON((9.24571418762213 54.7592239379883,9.24139308929443 54.7610321044922,9.22893714904791 54.7602882385255,9.22776126861578 54.7689743041993,9.21522903442388 54.7681198120117,9.20912361145025 54.7662162780763,9.20912361145025 54.7662162780763,9.20315265655512 54.7655372619629,9.19574165344244 54.7612342834473,9.19574356079102 54.7591247558594,9.19948768615723 54.7584991455079,9.19684696197515 54.747459411621,9.19684696197515 54.747459411621,9.19540405273432 54.7358207702637,9.19540405273432 54.7358207702637,9.23756408691401 54.7404937744141,9.24167823791504 54.7393226623536,9.24167823791504 54.7393226623536,9.25995063781738 54.740982055664,9.27067661285406 54.7400283813476,9.27757263183605 54.7383003234864,9.27757263183605 54.7383003234864,9.2776308059693 54.7492218017578,9.27268981933594 54.759147644043,9.2647275924682 54.7554244995118,9.25967502594006 54.7541389465333,9.2486400604248 54.7552680969239,9.24712467193598 54.7561492919922,9.24571418762213 54.7592239379883)) | 0.0006 | POINT(9.233324663979689 54.75239740099227) |
| 60556 | POLYGON((9.30036640167242 47.4330787658691,9.30162620544434 47.4352111816407,9.3062601089477 47.4370307922364,9.30648708343512 47.4386444091798,9.30416488647467 47.4398384094239,9.30317115783703 47.4433364868164,9.29289340972895 47.4484214782715,9.29131221771252 47.4498672485352,9.2903985977174 47.4527969360353,9.28600788116455 47.4561424255372,9.28087520599365 47.4563865661621,9.27744007110601 47.4522476196288,9.27367782592785 47.4499244689941,9.26437377929693 47.4517631530761,9.26437377929693 47.4517631530761,9.262848854065 47.4495544433595,9.26327323913569 47.4474258422853,9.26213264465338 47.4448699951172,9.26499271392828 47.4408493041992,9.2642183303833 47.4372978210449,9.27194976806641 47.4342193603516,9.27679061889648 47.4304542541504,9.28501987457281 47.4312591552734,9.28914928436279 47.4285163879395,9.29216575622564 47.4308624267579,9.29521369934076 47.4304885864259,9.29854679107672 47.4317245483399,9.29854679107672 47.4317245483399,9.30036640167242 47.4330787658691)) | 0.0006 | POINT(9.28458132062643 47.44163213457382) |
| 31176 | POLYGON((-2.92567396163935 47.9094543457031,-2.91578626632679 47.9103393554689,-2.91201686859125 47.907958984375,-2.88966536521912 47.9162673950196,-2.86422610282898 47.9171180725099,-2.86422610282898 47.9171180725099,-2.86249208450312 47.907512664795,-2.84800314903254 47.8951683044435,-2.84800314903254 47.8951683044435,-2.84347128868103 47.8858299255372,-2.85685086250305 47.8687362670899,-2.85685086250305 47.8687362670899,-2.88471174240112 47.8546218872071,-2.8997659683227 47.8560333251953,-2.90393471717834 47.85408782959,-2.90798091888428 47.8338317871094,-2.91451549530024 47.8248748779297,-2.91451549530024 47.8248748779297,-2.92218112945551 47.8449287414551,-2.90707874298096 47.8823242187501,-2.91139984130854 47.888469696045,-2.92631220817566 47.8903160095215,-2.92631220817566 47.8903160095215,-2.91876292228699 47.9017791748048,-2.92567396163935 47.9094543457031)) | 0.0006 | POINT(-2.8926973938941676 47.881077766418535) |
| 28493 | POLYGON((4.50809431076055 47.8799476623536,4.50434970855713 47.8814239501953,4.50434970855713 47.8814239501953,4.51005697250372 47.8863754272461,4.5096435546875 47.8963088989258,4.5096435546875 47.8963088989258,4.52140092849731 47.898838043213,4.52370643615728 47.9045448303224,4.52370643615728 47.9045448303224,4.52988004684448 47.8939476013184,4.52988004684448 47.8939476013184,4.53572797775274 47.8897514343262,4.53572797775274 47.8897514343262,4.51785516738892 47.8782882690431,4.50809431076055 47.8799476623536)) | 0.0006 | POINT(4.51885877336777 47.891100202287994) |
| 37515 | POLYGON((0.880174696445522 49.2243461608887,0.886565327644348 49.2151336669922,0.886648595333099 49.2053680419922,0.886648595333099 49.2053680419922,0.882343113422337 49.20458984375,0.882343113422337 49.20458984375,0.882855474948883 49.2105178833008,0.866757214069366 49.2160873413087,0.866757214069366 49.2160873413087,0.867586314678135 49.2192878723146,0.880174696445522 49.2243461608887)) | 0.0006 | POINT(0.8788679659366492 49.212137603759814) |
| 67076 | POLYGON((7.85346937179577 48.4166107177734,7.85045242309565 48.4114189147949,7.85222291946423 48.4084205627442,7.85489320755016 48.408016204834,7.85473203659052 48.4062500000001,7.85619735717773 48.4048881530762,7.85425186157221 48.4038887023927,7.85443925857555 48.3991699218751,7.84754419326788 48.3960189819336,7.84131050109863 48.396614074707,7.83208894729614 48.3935317993164,7.83208894729614 48.3935317993164,7.82979059219366 48.3965339660645,7.82274913787853 48.3988113403321,7.82361030578619 48.4006042480469,7.82032823562616 48.4013252258301,7.82441663742071 48.4073524475097,7.82745552063 48.4073829650879,7.83025455474859 48.408592224121,7.82416152954102 48.4137535095215,7.81831932067871 48.4167785644532,7.81407642364502 48.414047241211,7.8092823028565 48.4132461547852,7.79802370071417 48.4147262573242,7.79654407501221 48.4158248901368,7.79733753204351 48.4176063537599,7.79677104949963 48.4188079833985,7.79169654846191 48.4220848083496,7.75423192977917 48.4337844848633,7.75229644775402 48.4326095581056,7.75229644775402 48.4326095581056,7.76166963577265 48.4484977722169,7.76503753662121 48.4566116333009,7.76653528213512 48.465160369873,7.76694822311413 48.4871292114259,7.76820087432867 48.4896621704102,7.77146959304821 48.4924621582032,7.79153060913086 48.4999809265137,7.79153060913086 48.4999809265137,7.82430219650263 48.4954528808594,7.83659696578974 48.4954071044922,7.8458423614502 48.4914283752443,7.8458423614502 48.4914283752443,7.84158325195307 48.4876098632812,7.8393635749818 48.4804039001464,7.83593750000006 48.4767112731934,7.83531236648565 48.4745292663574,7.83588743209839 48.4731674194337,7.83975076675415 48.4714355468751,7.84201097488415 48.4646339416504,7.84681940078741 48.4592323303222,7.84808969497692 48.4560127258301,7.84777355194092 48.4533615112306,7.85018062591553 48.4498825073243,7.85018062591553 48.4498825073243,7.85166883468634 48.4478759765624,7.85141849517828 48.4448089599611,7.85338306427002 48.4421844482422,7.8567905426026 48.4399375915528,7.86006307601929 48.4329261779785,7.85947799682617 48.4294853210449,7.85676717758173 48.4291152954102,7.85686922073364 48.4282264709473,7.85277652740484 48.4241676330566,7.85366964340221 48.420150756836,7.85058927536011 48.4178810119629,7.85346937179577 48.4166107177734)) | 0.0006 | POINT(7.826048533121782 48.43744948416049) |
| 62643 | POLYGON((7.28226804733282 53.3966522216798,7.28028678894049 53.3959617614747,7.27943086624151 53.3942947387696,7.28321933746344 53.3890037536621,7.27887868881226 53.3872528076172,7.28618860244751 53.381534576416,7.28104305267334 53.3778381347656,7.28991889953619 53.3751640319825,7.29254674911499 53.3760528564454,7.29861736297602 53.3755264282227,7.29785346984863 53.373420715332,7.30338430404669 53.372859954834,7.30479907989502 53.3703689575195,7.31175470352179 53.366756439209,7.31228256225592 53.3640327453613,7.30733108520513 53.3611869812012,7.30393648147583 53.3574104309083,7.3077063560487 53.3529129028321,7.3073201179505 53.3501586914062,7.3073201179505 53.3501586914062,7.30483293533325 53.3500061035156,7.30260038375854 53.3251266479493,7.29928636550903 53.3206939697266,7.29928636550903 53.3206939697266,7.26313209533686 53.3256759643556,7.24957656860363 53.3248863220215,7.24840784072876 53.3203659057618,7.24506044387823 53.3182983398437,7.24506044387823 53.3182983398437,7.24472284317028 53.3182945251465,7.24472284317028 53.3182945251465,7.24472284317028 53.3193054199219,7.24694490432739 53.320972442627,7.24916696548473 53.3298606872559,7.23972320556646 53.3312492370606,7.20972204208374 53.3326377868653,7.20583391189575 53.3337516784669,7.18861103057873 53.3343048095704,7.1852760314942 53.3351402282716,7.18583202362066 53.3362503051758,7.18305587768566 53.3370819091797,7.18472290039062 53.3387489318849,7.18416595458984 53.339584350586,7.18138790130627 53.3384704589845,7.18083381652838 53.3368072509766,7.17749977111816 53.3340263366699,7.15305614471447 53.3354148864746,7.06083297729492 53.3345832824708,7.05194520950312 53.3381958007812,7.03972196578974 53.3376388549805,7.03527688980103 53.3359718322754,7.02472305297863 53.3365287780762,7.01583385467529 53.3415260314941,7.011386871338 53.3459739685059,7.01083421707165 53.3479156494141,7.00805521011358 53.3490295410156,7.00750112533569 53.3506927490236,7.00472307205212 53.3526382446289,7.00416707992565 53.3554153442383,7.00250101089483 53.3562507629395,7.00194501876837 53.3579177856446,6.99992179870611 53.3590278625488,6.99992179870611 53.3590278625488,6.99944686889648 53.3598861694336,7.0040335655213 53.3673973083497,7.0128746032716 53.3786354064943,7.01585006713867 53.3765945434571,7.01969242095959 53.3698768615724,7.03323650360113 53.3612365722656,7.03810071945185 53.3523750305176,7.04231500625622 53.3525199890138,7.04988241195684 53.3563041687013,7.05069255828857 53.3549880981446,7.05766820907604 53.3531723022462,7.07323741912842 53.3608970642091,7.07948589324951 53.3630065917969,7.0885844230653 53.3688316345215,7.09600496292109 53.3833045959473,7.0996727943421 53.3864669799805,7.11915588378912 53.3896560668945,7.14098978042608 53.397560119629,7.14098978042608 53.397560119629,7.14297437667858 53.3926658630372,7.1532940864563 53.3933258056641,7.15249586105358 53.3905677795411,7.15501165390015 53.3907279968262,7.1554861068725 53.3884544372559,7.15937280654913 53.3882026672363,7.15978002548218 53.3869972229005,7.16300058364862 53.3869972229005,7.16254329681391 53.3884582519532,7.16806077957153 53.3891296386719,7.16859531402594 53.3878326416016,7.17988967895508 53.3873291015626,7.18498373031628 53.3880233764649,7.18465280532843 53.389217376709,7.18722486495983 53.3894309997559,7.18672704696661 53.3905792236328,7.19225406646734 53.3906822204589,7.1912460327149 53.3929634094238,7.19599437713634 53.3936882019044,7.19861221313482 53.390495300293,7.19842147827154 53.3894271850587,7.20371294021606 53.3899040222169,7.20328140258783 53.3930473327637,7.20006895065319 53.3981437683105,7.20779228210455 53.3989257812501,7.20971536636364 53.4019813537598,7.21175289154047 53.402515411377,7.21418285369873 53.400619506836,7.21679973602289 53.4012565612794,7.21847534179688 53.3997802734375,7.22278261184698 53.4017639160157,7.22341012954723 53.4011077880859,7.22039127349854 53.3983116149902,7.22138404846191 53.3971138000489,7.22449302673351 53.3976020812988,7.22490835189819 53.3966751098634,7.22342157363892 53.3964309692383,7.22421789169312 53.3952369689943,7.22667455673229 53.395393371582,7.22738218307506 53.3919563293458,7.2383217811585 53.393913269043,7.23735904693598 53.395076751709,7.23885154724121 53.3953552246093,7.24005460739136 53.3941726684571,7.25036668777477 53.4000320434571,7.24440622329723 53.4036903381348,7.247950077057 53.4048156738282,7.24990606307995 53.4036102294922,7.25289964675903 53.404857635498,7.25383090972906 53.4040718078613,7.25842380523687 53.4060935974122,7.26004886627192 53.4048767089845,7.26758003234863 53.4086990356445,7.2753272056579 53.406322479248,7.2753272056579 53.406322479248,7.28226804733282 53.3966522216798)) | 0.0006 | POINT(7.1829245142693425 53.370264707690616) |
| 30003 | POLYGON((3.26439905166632 48.2196655273438,3.2508819103241 48.2198944091798,3.24355363845831 48.2161827087403,3.24355363845831 48.2161827087403,3.23297214508062 48.2346572875977,3.23297214508062 48.2346572875977,3.24721193313599 48.2441329956056,3.24721193313599 48.2441329956056,3.2532052993775 48.2354621887208,3.26144528388983 48.2321968078614,3.26439905166632 48.2196655273438)) | 0.0006 | POINT(3.247740697860759 48.2297164916993) |
| 52971 | POLYGON((0.321871548891181 46.1305236816407,0.313767313957214 46.1486244201661,0.299647241830883 46.1621093749999,0.290101796388683 46.1613616943359,0.290101796388683 46.1613616943359,0.282428115606308 46.1469154357911,0.285044729709625 46.130714416504,0.285044729709625 46.130714416504,0.312602490186805 46.122386932373,0.312602490186805 46.122386932373,0.319618821144104 46.1251754760742,0.321871548891181 46.1305236816407)) | 0.0006 | POINT(0.3011664612727196 46.140206770463436) |
| 65307 | POLYGON((9.23779582977306 49.9347991943361,9.23606395721447 49.9343948364258,9.23408794403082 49.9358024597169,9.22010326385498 49.9358825683594,9.20534038543707 49.9307289123536,9.19069957733166 49.9288330078126,9.19039344787603 49.9273109436035,9.18086528778076 49.9261016845703,9.17455482482916 49.9274406433106,9.16869354248058 49.9316635131836,9.16652202606201 49.9271049499513,9.16201019287121 49.9234619140625,9.14420986175543 49.9206161499024,9.14420986175543 49.9206161499024,9.14420127868664 49.9160346984864,9.14609718322754 49.9159851074219,9.14637374877935 49.9141349792482,9.14391803741461 49.9142227172853,9.14311504364019 49.9033317565918,9.14727497100824 49.898136138916,9.15314769744867 49.894416809082,9.15314769744867 49.894416809082,9.15914726257324 49.8911247253418,9.15914726257324 49.8911247253418,9.15726852416998 49.8930282592775,9.16036510467541 49.8943519592285,9.16685199737555 49.891025543213,9.17830276489269 49.8969726562501,9.18601799011225 49.8909950256348,9.19348144531261 49.8921089172364,9.19348144531261 49.8921089172364,9.19121265411377 49.8965797424318,9.1916131973266 49.8987274169922,9.18853569030762 49.9027214050293,9.19062137603771 49.9028892517091,9.19172382354731 49.9048385620118,9.19081687927246 49.9084281921386,9.1876049041748 49.9107017517091,9.19120979309093 49.911849975586,9.19429111480707 49.9102668762208,9.19607925415033 49.9111137390137,9.19633197784424 49.91410446167,9.21544837951672 49.9177780151368,9.2227087020874 49.9219627380372,9.23042964935314 49.9214286804199,9.2339124679566 49.922519683838,9.23312759399414 49.9211235046387,9.22837352752691 49.9191093444824,9.22239112854004 49.9181976318361,9.22074604034424 49.914608001709,9.23192214965832 49.9083595275879,9.23391819000256 49.9082221984864,9.24182415008539 49.9121856689453,9.24570941925049 49.9154624938966,9.2425909042359 49.917449951172,9.24475288391119 49.9179077148438,9.24364280700684 49.9187660217285,9.24474811553949 49.9196777343751,9.2479124069215 49.9196243286133,9.2479124069215 49.9196243286133,9.24989891052257 49.9214553833009,9.247223854065 49.9240722656251,9.24719142913824 49.9268684387208,9.24719142913824 49.9268684387208,9.2474889755249 49.9288063049318,9.24416732788086 49.9321441650392,9.23959445953375 49.9326782226563,9.23779582977306 49.9347991943361)) | 0.0006 | POINT(9.200772498970641 49.91443878857059) |