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 |
---|---|---|---|
68998 | POLYGON((13.5748281478883 50.7718925476074,13.5821571350098 50.7729873657227,13.5940303802491 50.7764167785646,13.5983438491822 50.7737884521485,13.5983438491822 50.7737884521485,13.6044483184816 50.7701225280763,13.6108751296997 50.7583236694337,13.6160326004028 50.7541389465333,13.6182937622071 50.747829437256,13.6383962631226 50.7402725219728,13.6454544067382 50.7355041503907,13.6502828598023 50.7336616516114,13.6521739959717 50.7303581237793,13.6521739959717 50.7303581237793,13.6426343917848 50.7293395996094,13.636815071106 50.7253875732423,13.6290626525879 50.7229194641113,13.625036239624 50.7228469848633,13.6269130706787 50.7159156799317,13.6245708465577 50.7153053283691,13.6245708465577 50.7153053283691,13.6201009750366 50.7139549255371,13.6111297607422 50.7135276794433,13.602252960205 50.7100601196289,13.5893325805665 50.7129135131836,13.5795526504517 50.7125778198243,13.5733833312989 50.7134666442872,13.5686492919922 50.7125053405762,13.5598649978638 50.7146835327149,13.55632686615 50.7145462036134,13.5452165603639 50.7113113403321,13.5402927398682 50.7081565856935,13.5402927398682 50.7081565856935,13.5371961593628 50.709831237793,13.5254583358764 50.7112197875977,13.5252962112427 50.7157249450684,13.5263042449952 50.7177085876466,13.5250730514527 50.7197189331054,13.5262241363526 50.7234725952149,13.5248289108276 50.7257957458496,13.5252838134765 50.7275657653809,13.5236434936524 50.7289505004883,13.5238590240479 50.7263717651368,13.5045251846313 50.7240104675292,13.5017118453979 50.7223892211913,13.496711730957 50.721405029297,13.4847469329835 50.7244033813477,13.4818706512452 50.7226943969727,13.47975730896 50.7200317382813,13.47975730896 50.7200317382813,13.4775123596191 50.721305847168,13.4793224334717 50.7232131958008,13.4769744873048 50.7257766723634,13.4763746261597 50.7308158874512,13.4811172485352 50.7295494079589,13.4803495407104 50.7317504882812,13.4679851531984 50.7392272949219,13.4624118804932 50.7457695007324,13.4624118804932 50.7457695007324,13.4649009704591 50.7491912841797,13.4653062820436 50.7531166076661,13.4687213897705 50.7590370178223,13.4759216308594 50.764633178711,13.4825115203857 50.7673263549805,13.4850749969483 50.7672233581544,13.4850749969483 50.7672233581544,13.4877443313599 50.7665519714355,13.5015888214112 50.7551002502441,13.5051670074463 50.7562065124513,13.5098199844361 50.7554893493652,13.5113286972045 50.756217956543,13.5288305282594 50.7491874694824,13.5402231216431 50.7506256103515,13.5442180633545 50.747901916504,13.5435371398926 50.7468185424805,13.5483007431031 50.7450027465821,13.5495309829711 50.7429695129395,13.5511350631714 50.7423324584962,13.5568685531617 50.742748260498,13.5597887039185 50.7442207336427,13.5600357055664 50.751220703125,13.5622291564941 50.7511177062988,13.564793586731 50.7473754882812,13.5685558319092 50.7467346191407,13.5794172286988 50.7525901794435,13.5768537521362 50.7565460205078,13.5776386260986 50.7581214904786,13.5725650787354 50.7638549804688,13.574197769165 50.7647132873536,13.5716533660889 50.7659606933594,13.5740947723389 50.7676696777344,13.5748281478883 50.7718925476074)) | 0.0006 | POINT(13.548749116750894 50.73815226292874) |
33502 | POLYGON((4.96290302276623 49.6536178588868,4.94904088974005 49.6586227416993,4.93071508407598 49.6510772705078,4.9297184944154 49.6444587707519,4.9297184944154 49.6444587707519,4.93543338775635 49.6374473571777,4.93543338775635 49.6374473571777,4.95546102523815 49.6428947448732,4.95546102523815 49.6428947448732,4.96023893356329 49.6451301574708,4.96023893356329 49.6451301574708,4.96290302276623 49.6536178588868)) | 0.0006 | POINT(4.945851152593513 49.6457436301492) |
43083 | POLYGON((5.85428476333624 48.2798690795898,5.85152006149298 48.2773895263672,5.8334379196167 48.2789840698243,5.82719087600719 48.2744178771973,5.82719087600719 48.2744178771973,5.82634401321411 48.2807579040527,5.8117733001709 48.2892875671386,5.8117733001709 48.2892875671386,5.81736898422247 48.2947807312013,5.82675170898443 48.2971534729004,5.84311199188244 48.2905387878419,5.85758113861084 48.2931442260743,5.85758113861084 48.2931442260743,5.85428476333624 48.2798690795898)) | 0.0006 | POINT(5.834300774794402 48.28562868558447) |
21608 | POLYGON((0.50539439916605 45.0543479919434,0.522863686084804 45.0650978088378,0.523334503173942 45.0685310363769,0.514278411865234 45.0766525268555,0.513977706432456 45.0865669250489,0.513977706432456 45.0865669250489,0.480762183666229 45.0865669250489,0.477858930826301 45.0801696777344,0.483456283807811 45.063720703125,0.483456283807811 45.063720703125,0.495719105005378 45.053295135498,0.495719105005378 45.053295135498,0.50539439916605 45.0543479919434)) | 0.0006 | POINT(0.500899858772821 45.06987762451172) |
42261 | POLYGON((6.84462070465099 48.8556327819824,6.83008813858032 48.8545074462892,6.81705284118664 48.8451347351074,6.81705284118664 48.8451347351074,6.79821825027466 48.8566017150879,6.79821825027466 48.8566017150879,6.82299232482916 48.8754959106446,6.82299232482916 48.8754959106446,6.84650945663464 48.8697433471681,6.84650945663464 48.8697433471681,6.84462070465099 48.8556327819824)) | 0.0006 | POINT(6.82442545890815 48.86040916442876) |
64953 | POLYGON((12.2210741043091 49.0650367736816,12.2262897491455 49.0607986450196,12.2299928665161 49.0594558715821,12.2325668334962 49.0545120239258,12.2343692779542 49.054386138916,12.2311782836914 49.052806854248,12.2307891845703 49.0484466552736,12.2371044158936 49.0493659973144,12.2445545196533 49.0445556640625,12.2478075027467 49.0444297790527,12.248589515686 49.0433311462403,12.2551126480103 49.0431900024414,12.2551126480103 49.0431900024414,12.2545957565308 49.0491943359376,12.2545957565308 49.0491943359376,12.2592716217041 49.0510444641114,12.2578325271606 49.0528945922851,12.2595386505128 49.0550155639648,12.2600660324097 49.0578422546387,12.2644891738892 49.0612373352051,12.2609643936157 49.0621910095215,12.2618370056153 49.0635986328125,12.2601184844971 49.0656509399415,12.2582101821901 49.0723037719728,12.2582101821901 49.0723037719728,12.2529726028444 49.0713691711426,12.2480754852294 49.0718841552735,12.2486562728883 49.0754585266114,12.2454042434692 49.0756416320802,12.2432928085328 49.0770988464356,12.2393665313722 49.0753059387206,12.2372312545777 49.0753479003907,12.2355012893677 49.0786590576172,12.2251348495484 49.0752296447754,12.2251348495484 49.0752296447754,12.2281532287599 49.0738525390626,12.2243843078613 49.0749244689941,12.2230291366578 49.0745697021485,12.2235250473022 49.0734901428223,12.2212285995483 49.0736160278321,12.2145414352418 49.0711822509767,12.2164602279663 49.0685234069825,12.2188529968261 49.0684356689454,12.2218923568726 49.0653266906739,12.2210741043091 49.0650367736816)) | 0.0006 | POINT(12.240843382748727 49.062980044971845) |
43849 | POLYGON((2.34818792343145 44.4173889160157,2.34801268577581 44.4107856750489,2.33715176582342 44.4041328430176,2.32357215881353 44.4077224731446,2.3143146038056 44.4068641662599,2.31462240219116 44.4001159667969,2.30798768997187 44.3953819274903,2.301677942276 44.3786354064943,2.301677942276 44.3786354064943,2.31590294837952 44.3772773742677,2.33159780502319 44.3842391967775,2.34736061096191 44.3769340515136,2.34736061096191 44.3769340515136,2.35481476783747 44.400188446045,2.35240197181707 44.4069328308105,2.36224460601812 44.4138793945312,2.36224460601812 44.4138793945312,2.35909628868114 44.4168395996095,2.35909628868114 44.4168395996095,2.34818792343145 44.4173889160157)) | 0.0006 | POINT(2.3362802957233915 44.399137195788) |
67866 | POLYGON((8.30872154235846 49.5019493103028,8.30112171173107 49.5025291442872,8.29914093017572 49.5011138916015,8.26866912841797 49.4955101013184,8.26866912841797 49.4955101013184,8.27093029022222 49.496509552002,8.27057456970221 49.4982147216798,8.27057456970221 49.4982147216798,8.27611923217785 49.4990158081054,8.27398204803472 49.5036888122558,8.26577091217052 49.5028419494629,8.26445007324219 49.5056686401368,8.26409244537354 49.5077133178712,8.27140712738043 49.5085258483887,8.27063751220709 49.515251159668,8.26744079589855 49.5263023376465,8.26598548889172 49.5284423828125,8.25788497924805 49.5286865234376,8.25637149810797 49.5335464477538,8.25637149810797 49.5335464477538,8.28883838653564 49.5374794006348,8.28886890411383 49.5347366333008,8.31249904632568 49.5348777770997,8.31201744079601 49.5332679748535,8.31201744079601 49.5332679748535,8.3105583190918 49.5290679931641,8.31511116027838 49.5275611877441,8.31479644775385 49.5247650146484,8.30935955047607 49.5230293273926,8.30828857421886 49.5207595825195,8.30967235565197 49.5186080932618,8.31315040588379 49.5175247192382,8.31334972381592 49.5067977905275,8.30865955352783 49.5063209533693,8.30872154235846 49.5019493103028)) | 0.0006 | POINT(8.287238317377474 49.515613107120316) |
21648 | POLYGON((0.174861952662525 45.2614364624025,0.183468997478599 45.2600135803224,0.204415708780289 45.2636032104492,0.204415708780289 45.2636032104492,0.215921103954429 45.2570152282715,0.232717692852134 45.2403945922852,0.232717692852134 45.2403945922852,0.231225222349224 45.2252502441406,0.231225222349224 45.2252502441406,0.20185482501995 45.2363395690919,0.187794923782349 45.2349586486817,0.174738436937446 45.2392082214357,0.174738436937446 45.2392082214357,0.170186191797313 45.2449760437012,0.172293275594711 45.2517127990723,0.172293275594711 45.2517127990723,0.176695838570538 45.2559623718262,0.174861952662525 45.2614364624025)) | 0.0006 | POINT(0.19656261801725353 45.246531767003724) |
1406968 | POLYGON((-6.18424701690668 38.9287300109864,-6.19559288024897 38.9343032836915,-6.20783901214594 38.9459953308105,-6.21210479736328 38.9477844238281,-6.21668577194214 38.9562149047852,-6.21329021453846 38.9665794372559,-6.1983118057251 38.9750366210937,-6.19251203536976 38.9810523986816,-6.18137788772572 38.9829139709474,-6.1685848236084 38.9882698059083,-6.1606831550597 38.9880981445313,-6.15165090560913 38.9903030395508,-6.15534782409662 38.9841423034668,-6.15382099151606 38.9791412353516,-6.1547389030456 38.9751243591308,-6.1591911315918 38.9698524475098,-6.16439819335938 38.9541244506837,-6.16069889068604 38.9427833557129,-6.16942405700684 38.9359207153321,-6.17561912536621 38.9349021911621,-6.1828179359436 38.9313354492189,-6.18424701690668 38.9287300109864)) | 0.0006 | POINT(-6.178997017088353 38.961552756173305) |