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 |
---|---|---|---|
180396 | MULTIPOLYGON(((8.50325298309355 53.4925384521487,8.50418090820324 53.4933433532717,8.50418090820324 53.4933433532717,8.517499923706 53.5027046203616,8.52083206176786 53.5009727478029,8.55360984802246 53.5073623657228,8.56083297729515 53.5104179382327,8.56249904632597 53.5134735107424,8.57083415985102 53.5181961059572,8.569721221924 53.5195846557619,8.57527828216581 53.5304183959963,8.57416629791288 53.5354156494143,8.57694435119646 53.5393066406253,8.56805515289335 53.5437507629397,8.56527709960955 53.550273895264,8.56906604766868 53.5515289306643,8.56477260589628 53.556694030762,8.56437778472923 53.5598258972171,8.56898117065447 53.5632667541507,8.57736015319853 53.5784111022951,8.57399749755871 53.5789680480959,8.56951236724854 53.582717895508,8.56428527832048 53.5834197998049,8.56327819824247 53.5812644958498,8.54788303375256 53.5836982727052,8.54069137573271 53.592842102051,8.54238414764433 53.5958328247072,8.53735637664818 53.5973281860354,8.52694416046148 53.5929489135743,8.52583217620872 53.5937500000002,8.52805423736584 53.5954170227053,8.52527809143083 53.59680557251,8.52361202240002 53.6020851135256,8.52138805389433 53.6034736633304,8.52138805389433 53.606456756592,8.52417087554954 53.6066932678225,8.52615928649925 53.6038398742678,8.52739238739031 53.6059722900392,8.53247261047358 53.6049308776857,8.533651351929 53.6076164245608,8.53948402404814 53.6062889099123,8.53948402404814 53.6062889099123,8.55482769012468 53.6031455993655,8.55876922607439 53.6039085388186,8.56286430358915 53.6015167236331,8.58609008789085 53.5967102050784,8.58555698394798 53.5957679748537,8.59228324890154 53.5929336547854,8.6014003753665 53.5955619812013,8.61270999908476 53.6029243469241,8.62329673767118 53.6053352355959,8.64021396636957 53.604503631592,8.64566707611112 53.6016998291018,8.6466398239138 53.603340148926,8.65063285827631 53.6025657653811,8.63795566558855 53.5950660705569,8.64271545410173 53.5925598144534,8.62826347351103 53.5832252502444,8.62943553924578 53.5823173522952,8.62712574005155 53.5791206359864,8.62514400482195 53.5791816711427,8.62417793273954 53.5770530700685,8.61759662628185 53.5776901245118,8.61680316925077 53.5743713378909,8.62339019775402 53.5697326660158,8.63086032867443 53.555690765381,8.63633441925066 53.5536880493166,8.64635467529297 53.555545806885,8.64382457733183 53.5489997863771,8.64522647857683 53.5404739379886,8.64205169677763 53.5416831970218,8.64152145385765 53.5363998413088,8.63865566253679 53.5349540710451,8.63977527618425 53.5252876281741,8.64427280426042 53.5223922729494,8.64590263366716 53.5188026428225,8.64915847778343 53.5195770263674,8.65213394165056 53.5160179138185,8.64823246002214 53.5143051147464,8.65055561065702 53.5107803344728,8.64194393157959 53.5079536437991,8.64194393157959 53.5079536437991,8.64138221740717 53.507694244385,8.64138221740717 53.507694244385,8.63663768768305 53.505439758301,8.63786220550548 53.5032196044924,8.63215446472185 53.5016670227054,8.63144111633329 53.4936599731448,8.62302875518822 53.4935340881349,8.61953258514404 53.4892883300784,8.60613155365013 53.4859390258792,8.60590457916277 53.4842338562014,8.59717369079618 53.4860763549808,8.59117412567144 53.4847145080568,8.58301353454613 53.4866027832034,8.57730674743675 53.4854545593265,8.57495403289818 53.4861717224124,8.57376003265409 53.4886436462405,8.57212924957292 53.486999511719,8.57060813903831 53.4881439208987,8.53819751739508 53.4803619384768,8.52971363067644 53.4803428649904,8.51863384246826 53.4744453430177,8.51554489135737 53.4767990112306,8.51160430908232 53.4766654968265,8.50578975677513 53.4711799621584,8.49265193939232 53.4724197387697,8.49265384674095 53.4751243591311,8.50325298309355 53.4925384521487)),((8.64723300933866 53.6100273132326,8.65353488922148 53.6100502014162,8.65410518646257 53.6083602905276,8.66088390350359 53.6070861816408,8.65771675109869 53.6029853820802,8.64376926422125 53.6054725646974,8.64506244659435 53.6081275939943,8.64262771606462 53.609214782715,8.64723300933866 53.6100273132326))) | 0.0010 | POINT(8.58384976570067 53.546708027678044) |
53042 | POLYGON((0.875651121139583 46.6319313049318,0.888045310974178 46.6350059509278,0.895517647266502 46.631820678711,0.895517647266502 46.631820678711,0.907628059387264 46.6467170715332,0.915637850761414 46.6506729125977,0.907339811325016 46.6664352416992,0.907339811325016 46.6664352416992,0.911236584186611 46.6760292053224,0.902261495590153 46.6776657104492,0.902261495590153 46.6776657104492,0.892566025257111 46.6766052246094,0.884007990360374 46.6799507141114,0.879393935203552 46.6858406066895,0.869937121868134 46.6850051879883,0.865585207939148 46.6908340454101,0.86572253704071 46.7043304443361,0.86572253704071 46.7043304443361,0.846723675727901 46.7086334228516,0.832709431648368 46.7057571411133,0.8174205422402 46.7134552001954,0.79929488897335 46.7089576721192,0.784297287464199 46.7228546142579,0.781939744949398 46.7295837402344,0.781939744949398 46.7295837402344,0.759009420871848 46.7125816345215,0.759009420871848 46.7125816345215,0.751269161701316 46.6961555480958,0.733642160892487 46.6837272644043,0.734452903270778 46.6802940368652,0.734452903270778 46.6802940368652,0.769786596298218 46.6695556640626,0.763943254947719 46.6570091247559,0.772617757320461 46.64900970459,0.772617757320461 46.64900970459,0.789686739444733 46.655788421631,0.809171736240501 46.653045654297,0.829104363918361 46.6550903320313,0.849934935569763 46.641414642334,0.85786205530178 46.6456871032716,0.872392594814357 46.6443634033204,0.876272022724265 46.642147064209,0.875651121139583 46.6319313049318)) | 0.0006 | POINT(0.8359743640536814 46.675373259044875) |
1406070 | POLYGON((-0.492168009281102 40.0526275634767,-0.499437987804413 40.0493431091308,-0.500757992267552 40.0431022644043,-0.504622995853424 40.0421791076661,-0.505456984043064 40.0376358032227,-0.503830015659332 40.033088684082,-0.506460011005345 40.0303611755372,-0.507961988449097 40.0328826904297,-0.514697015285492 40.0287818908691,-0.517858028411865 40.0301551818848,-0.516698002815247 40.0343551635743,-0.518181979656106 40.035125732422,-0.531041026115417 40.0340843200683,-0.53432697057724 40.0355529785156,-0.534901022911015 40.0398101806641,-0.538594007492065 40.0436859130861,-0.536583006381989 40.0487251281739,-0.543301999568882 40.0499572753907,-0.557770013809147 40.0485343933107,-0.582955002784615 40.0582962036133,-0.578227996826115 40.0606994628906,-0.573500990867558 40.0769615173341,-0.561505973339081 40.0976371765137,-0.532765984535217 40.1028289794923,-0.513063013553619 40.1104393005371,-0.509374976158142 40.109920501709,-0.504445016384125 40.1042213439943,-0.50934499502182 40.0991668701173,-0.528874993324223 40.0894737243653,-0.524230003356877 40.0888366699219,-0.524953007698002 40.0869674682618,-0.513477981090489 40.0832824707032,-0.502341985702458 40.0757751464844,-0.503233015537262 40.0635871887208,-0.492168009281102 40.0526275634767)) | 0.0006 | POINT(-0.5243218821637471 40.06053184060494) |
57019 | POLYGON((7.5850191116333 50.0349845886231,7.58665323257446 50.0343246459962,7.5984349250794 50.0352821350098,7.5984349250794 50.0352821350098,7.59764337539673 50.0274467468261,7.59557008743286 50.0275192260743,7.59678030014049 50.0246505737306,7.59914255142218 50.0230560302735,7.59801054000854 50.0209999084473,7.59852886199951 50.0189247131348,7.59416961669933 50.0175437927246,7.59416961669933 50.0175437927246,7.58995771408081 50.0155792236328,7.58043527603155 50.0145797729492,7.58043527603155 50.0145797729492,7.56988716125488 50.0163383483888,7.57054662704479 50.0178756713867,7.57303047180187 50.0190658569337,7.57303047180187 50.0190658569337,7.57493495941162 50.0185470581056,7.57667112350464 50.020534515381,7.57758903503418 50.0199279785156,7.58235025405889 50.0206718444825,7.58279848098755 50.0240592956543,7.5816731452943 50.0255355834962,7.58967542648327 50.0281448364258,7.58998155593872 50.0295295715333,7.58702707290649 50.029842376709,7.58332586288464 50.0331954956055,7.58332586288464 50.0331954956055,7.5836124420166 50.0344429016114,7.5850191116333 50.0349845886231)) | 0.0006 | POINT(7.586220818181238 50.024266765963674) |
1390326 | POLYGON((-1.20041596889496 41.8403549194337,-1.19777703285212 41.8408088684083,-1.19713199138636 41.8354835510254,-1.19513297080994 41.8359222412109,-1.19384300708759 41.8325424194337,-1.19628798961639 41.8295288085939,-1.21307396888733 41.8217391967775,-1.2141699790954 41.8234062194824,-1.20241200923908 41.8313674926758,-1.19881403446186 41.8348007202149,-1.20041596889496 41.8403549194337)) | 0.0006 | POINT(-1.2009058952331029 41.83259544372565) |
50100 | POLYGON((3.98077034950262 49.9304885864258,3.97658061981213 49.9210090637208,3.98299074172985 49.9121170043946,3.98101258277887 49.9090881347657,3.98101258277887 49.9090881347657,3.99079704284668 49.9079132080079,3.99079704284668 49.9079132080079,3.99696016311646 49.9136390686035,3.99955487251293 49.9239311218262,3.99955487251293 49.9239311218262,3.98077034950262 49.9304885864258)) | 0.0006 | POINT(3.988003087043802 49.915911865234435) |
1398628 | POLYGON((-4.45361995697021 40.3329772949219,-4.45541095733637 40.3199234008789,-4.46469402313227 40.3186683654785,-4.48543882369995 40.3211097717286,-4.49080181121826 40.3204612731934,-4.49765110015863 40.3166618347169,-4.50427818298334 40.3151092529298,-4.51287317275995 40.3205909729004,-4.51543521881104 40.328826904297,-4.52087688446039 40.3358421325684,-4.5266637802124 40.3382377624512,-4.52630805969233 40.3449172973633,-4.51478481292719 40.3476715087891,-4.50136995315546 40.3549003601074,-4.49854183197021 40.3612174987793,-4.49061489105225 40.3675727844239,-4.48600912094116 40.3701324462891,-4.48043394088745 40.3710517883301,-4.47348880767822 40.3690757751465,-4.47403907775873 40.3624114990236,-4.47171401977528 40.3584594726563,-4.47382211685181 40.3482017517091,-4.47070407867432 40.3428344726563,-4.46631193161011 40.3401794433594,-4.46052598953247 40.3403434753419,-4.45361995697021 40.3329772949219)) | 0.0006 | POINT(-4.488656501769992 40.341895141601604) |
1408792 | POLYGON((-2.6765410900116 42.1420135498047,-2.68991494178766 42.1394844055176,-2.70041298866261 42.1353416442872,-2.70712709426874 42.1385841369629,-2.71183609962463 42.1355934143068,-2.71536898612976 42.1354331970215,-2.723788022995 42.1360664367676,-2.72570490837097 42.1378173828125,-2.73790907859797 42.1301803588867,-2.74094104766846 42.1314926147462,-2.74648308753967 42.1406211853027,-2.74709892272949 42.1501960754395,-2.75415992736811 42.1611442565919,-2.75737500190723 42.1625213623047,-2.75943088531494 42.1693344116211,-2.76456809043879 42.1749992370606,-2.76324200630188 42.1797523498536,-2.76817393302917 42.1889419555664,-2.74044609069819 42.1847915649415,-2.73390293121338 42.1857147216797,-2.71194505691528 42.1832733154297,-2.68054604530329 42.1833801269531,-2.66439604759211 42.1804351806641,-2.67176389694214 42.1722869873048,-2.67289209365845 42.16455078125,-2.68338608741755 42.1530723571778,-2.67666196823114 42.1469535827637,-2.6765410900116 42.1420135498047)) | 0.0006 | POINT(-2.719482086322896 42.157184318259944) |
31245 | POLYGON((-2.37981843948359 47.5798988342286,-2.37733364105225 47.5666236877441,-2.37208962440491 47.5606155395508,-2.35244655609131 47.5568008422852,-2.33747410774231 47.5590133666993,-2.30280089378357 47.5526390075685,-2.30280089378357 47.5526390075685,-2.30952835083002 47.5440406799318,-2.30059242248529 47.5324134826661,-2.3062469959259 47.5236320495607,-2.3062469959259 47.5236320495607,-2.30912518501276 47.5182838439943,-2.30912518501276 47.5182838439943,-2.33085370063776 47.5106163024903,-2.34933590888977 47.5152626037599,-2.35845780372614 47.5076866149902,-2.35845780372614 47.5076866149902,-2.37729907035828 47.5235557556153,-2.38615918159485 47.5465583801269,-2.39804291725153 47.5531158447267,-2.40793418884277 47.5551109313966,-2.41154551506037 47.5526084899903,-2.41154551506037 47.5526084899903,-2.41960215568542 47.5581893920899,-2.41960215568542 47.5581893920899,-2.40560340881342 47.5724983215331,-2.40560340881342 47.5724983215331,-2.39203190803522 47.5729026794434,-2.3844113349914 47.5803565979004,-2.37981843948359 47.5798988342286)) | 0.0006 | POINT(-2.3614522506450486 47.54579175751791) |
44458 | POLYGON((1.00377547740931 43.2946739196778,1.00252318382263 43.2931327819825,1.00252318382263 43.2931327819825,0.975909769535178 43.2925453186036,0.975909769535178 43.2925453186036,0.966788113117275 43.3000411987305,0.977616846561432 43.310962677002,0.985848784446716 43.3141288757325,0.985848784446716 43.3141288757325,0.993821263313293 43.3067207336425,0.993661105632782 43.3003463745117,1.00377547740931 43.2946739196778)) | 0.0006 | POINT(0.9876569346948308 43.30112353238197) |