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 |
---|---|---|---|
64391 | POLYGON((13.7901258468628 52.7770805358886,13.7867631912231 52.7739601135254,13.7892446517944 52.7697677612305,13.7814960479736 52.7701416015625,13.7810897827148 52.7718811035156,13.7798309326172 52.772518157959,13.7766971588136 52.7722854614258,13.7733163833618 52.7702980041504,13.7618455886841 52.7705116271973,13.7466011047364 52.7673835754395,13.7494726181031 52.7647628784181,13.7473678588867 52.7630424499512,13.7473678588867 52.7630424499512,13.7594404220581 52.7522315979005,13.7635478973389 52.7436981201172,13.7635478973389 52.7436981201172,13.7849712371827 52.7468261718751,13.7926921844482 52.7493438720703,13.7943477630616 52.7474632263185,13.7933645248414 52.7463989257813,13.7996349334717 52.7443504333497,13.8248291015626 52.7512664794922,13.8283576965333 52.7532196044922,13.8547973632813 52.7580184936524,13.8547973632813 52.7580184936524,13.8614587783814 52.7588119506837,13.8625240325928 52.7603416442871,13.8631362915039 52.7733764648438,13.8712215423583 52.7731323242189,13.874005317688 52.7750091552735,13.8764953613281 52.779266357422,13.8671045303344 52.7809066772462,13.867211341858 52.7823257446288,13.8632564544678 52.7824363708496,13.863525390625 52.7875671386719,13.863525390625 52.7875671386719,13.8630475997925 52.7908744812012,13.863362312317 52.7924957275391,13.8648633956909 52.793685913086,13.8650121688843 52.7956542968751,13.8599395751954 52.7977027893066,13.8593788146973 52.800895690918,13.8526363372803 52.8071212768554,13.8526363372803 52.8071212768554,13.8025264739991 52.8040237426759,13.8060274124146 52.7971687316895,13.7979192733765 52.7961578369141,13.7971315383912 52.791130065918,13.8036317825319 52.7864875793457,13.8060512542725 52.7866821289064,13.8082485198976 52.7854881286621,13.8007316589356 52.7850189208984,13.8008794784545 52.7836112976074,13.7943143844604 52.7831497192383,13.7942771911622 52.7840499877929,13.7960739135743 52.7846603393555,13.795587539673 52.7861137390137,13.7980785369874 52.787078857422,13.7981472015382 52.7880058288574,13.7856273651123 52.786922454834,13.7839498519897 52.7841072082521,13.7842292785645 52.7798500061036,13.7881879806518 52.7789878845214,13.7901258468628 52.7770805358886)) | 0.0006 | POINT(13.812404905046764 52.77597136724565) |
65634 | POLYGON((10.1846103668212 49.7092933654786,10.1786994934083 49.709400177002,10.1787338256837 49.7084465026856,10.1699256896974 49.7082328796387,10.1700839996339 49.7073631286622,10.1683607101441 49.7078857421875,10.1681108474731 49.7038192749025,10.1648797988892 49.7076797485351,10.1637029647828 49.7073440551758,10.1628875732422 49.7088432312012,10.1605739593506 49.708423614502,10.1610660552979 49.7113380432129,10.1575174331665 49.7109870910646,10.1520547866822 49.708641052246,10.1483840942383 49.7097511291504,10.148931503296 49.7107086181642,10.1471490859986 49.711582183838,10.1458797454835 49.7106246948243,10.1411838531494 49.713436126709,10.1411838531494 49.713436126709,10.1372966766358 49.7100486755372,10.1318645477294 49.7020988464355,10.1304578781127 49.6920547485352,10.131205558777 49.6886634826661,10.131205558777 49.6886634826661,10.1335916519166 49.6866455078126,10.1401586532593 49.6837539672852,10.1401586532593 49.6837539672852,10.1463384628297 49.6862907409668,10.1453866958619 49.6892662048341,10.1511974334717 49.6911125183106,10.1567173004152 49.6891746520997,10.1571283340454 49.6879615783691,10.1636743545532 49.6897201538087,10.1668729782106 49.6883964538575,10.1702575683593 49.6883354187012,10.1709995269776 49.6872673034669,10.1698942184449 49.6847076416016,10.1698942184449 49.6847076416016,10.1733922958375 49.6841316223144,10.1735572814943 49.6802825927734,10.1762762069703 49.6801300048829,10.1771755218506 49.6783142089843,10.1785621643066 49.6783447265625,10.1785621643066 49.6783447265625,10.1811065673829 49.67924118042,10.1811065673829 49.67924118042,10.181860923767 49.6805152893066,10.1838827133179 49.6808357238771,10.1835975646973 49.6840896606445,10.1862421035767 49.6847724914551,10.1859722137452 49.685661315918,10.1877985000611 49.6863059997559,10.1877985000611 49.6863059997559,10.1888647079468 49.6865234375,10.1912202835083 49.6911010742188,10.1907348632812 49.6932678222657,10.1926631927491 49.6932373046875,10.1933746337891 49.6989517211914,10.1913213729859 49.6990623474121,10.1911897659302 49.6980285644532,10.1857223510742 49.6984367370605,10.1866941452028 49.700309753418,10.1857748031617 49.7009925842286,10.1852416992188 49.7040138244629,10.1836986541749 49.7044143676759,10.1830091476441 49.7058792114258,10.1846103668212 49.7092933654786)) | 0.0006 | POINT(10.167531654016345 49.695382018587495) |
63566 | POLYGON((8.90084838867193 50.2759094238281,8.90460491180414 50.2769622802735,8.91144275665289 50.2765769958496,8.91889095306396 50.2747459411622,8.92304420471203 50.2681159973146,8.92585754394543 50.2683906555176,8.92642402648931 50.2665786743164,8.92334651947033 50.2658157348633,8.92633152008057 50.2647056579591,8.9269170761109 50.2631683349609,8.93611431121826 50.2622489929199,8.93892097473139 50.2648429870606,8.94420814514172 50.2658767700196,8.94769763946539 50.2647743225098,8.95264434814453 50.2620582580566,8.95311450958246 50.2584457397462,8.95678710937511 50.2556076049806,8.96152114868164 50.2550506591798,8.96173477172852 50.2528305053711,8.96173477172852 50.2528305053711,8.96555805206299 50.2552413940431,8.96019744873058 50.2624931335449,8.96152305603022 50.2657508850098,8.96674537658703 50.2627449035645,8.97067642211914 50.2631721496583,8.97219085693365 50.2658386230469,8.97894096374512 50.2650642395021,8.97808742523205 50.2669448852539,8.97874450683588 50.2693939208984,8.97459220886236 50.2770233154296,8.97356128692627 50.2781410217285,8.97197151184082 50.2777976989747,8.97088527679438 50.280544281006,8.97672748565685 50.2818450927734,8.98412609100353 50.2815132141113,8.98881912231445 50.2796859741212,9.00309467315674 50.2830047607422,9.00737094879145 50.2854537963867,9.00737094879145 50.2854537963867,9.0026063919068 50.2908630371094,9.0079278945924 50.2962608337402,9.00384998321528 50.2985839843749,9.00512886047363 50.3016510009766,9.0070009231568 50.3020057678223,9.0070009231568 50.3020057678223,8.99994182586681 50.3026275634766,8.99611473083496 50.3049774169922,8.98919010162359 50.306209564209,8.99270153045666 50.3119812011719,8.99148178100586 50.3123245239258,8.98974609375011 50.3107910156249,8.98327636718761 50.3131332397461,8.96843242645269 50.3153839111328,8.96843242645269 50.3153839111328,8.9622049331665 50.3119812011719,8.96032524108898 50.3127212524414,8.95795536041271 50.3104209899903,8.95252704620356 50.3139648437501,8.94459152221685 50.3108177185059,8.93493556976324 50.3045120239258,8.92945098876959 50.3046531677246,8.92892646789556 50.3027038574219,8.92205429077148 50.2993774414062,8.92081832885754 50.3001976013183,8.91810894012463 50.299285888672,8.91054344177257 50.3032302856446,8.90983295440674 50.3047065734864,8.89912319183361 50.2985725402833,8.90744686126709 50.296314239502,8.90616416931164 50.294361114502,8.90775012969971 50.2923316955568,8.90101718902594 50.2895660400392,8.90101718902594 50.2895660400392,8.90338706970215 50.2867813110352,8.90418624877935 50.280590057373,8.90084838867193 50.2759094238281)) | 0.0006 | POINT(8.954514249165893 50.284979756673195) |
34715 | POLYGON((4.25568580627441 49.0570678710939,4.282301902771 49.0449676513672,4.282301902771 49.0449676513672,4.2790088653565 49.0384674072266,4.24759721755987 49.0199851989746,4.22791147232061 49.0178413391114,4.22354602813726 49.0078201293946,4.22354602813726 49.0078201293946,4.21227216720587 49.0085754394532,4.21335744857782 49.0140762329102,4.21335744857782 49.0140762329102,4.21291160583502 49.0207443237305,4.22448539733887 49.036075592041,4.2396183013916 49.050048828125,4.24965381622314 49.0514717102051,4.25568580627441 49.0570678710939)) | 0.0006 | POINT(4.239170360565202 49.02893371582035) |
39944 | POLYGON((3.34213185310375 44.6502532958985,3.35307884216314 44.6442031860353,3.35459709167486 44.6309661865235,3.35459709167486 44.6309661865235,3.35432052612305 44.6210556030274,3.33612799644482 44.6226692199708,3.32885575294495 44.6142272949219,3.32885575294495 44.6142272949219,3.30659794807428 44.621250152588,3.3082852363587 44.6278533935547,3.32175707817072 44.6380424499511,3.32175707817072 44.6380424499511,3.32546830177313 44.6475105285645,3.33912706375128 44.647632598877,3.34213185310375 44.6502532958985)) | 0.0006 | POINT(3.333968400955229 44.632064274379225) |
67096 | POLYGON((7.74623012542725 48.2392387390137,7.74487161636358 48.2387275695802,7.74487161636358 48.2387275695802,7.74429702758795 48.2374458312988,7.73914909362793 48.2360763549805,7.7384090423584 48.2382164001465,7.73426771163935 48.2369041442872,7.73064613342285 48.2447662353516,7.72775220870983 48.2458877563476,7.72628164291393 48.2479438781738,7.72338151931774 48.2494430541993,7.7223358154298 48.2521781921387,7.71936607360846 48.2530059814453,7.71978712081903 48.2537536621094,7.71713066101086 48.2547111511232,7.71779537200928 48.2555618286134,7.71181106567383 48.2598838806153,7.70309448242182 48.2604980468751,7.69873809814453 48.2586860656739,7.69718074798584 48.2567443847657,7.69221162796032 48.255958557129,7.68229961395269 48.2570533752441,7.68229961395269 48.2570533752441,7.70817470550548 48.2701911926271,7.70365619659424 48.2735748291016,7.70803546905518 48.282585144043,7.72131967544556 48.2865104675294,7.72131967544556 48.2865104675294,7.72001457214367 48.2852821350097,7.72191953659069 48.2840156555176,7.72641801834112 48.2845535278321,7.72833728790289 48.2827911376954,7.74167490005505 48.2795639038087,7.74824905395508 48.2789001464844,7.74816656112671 48.2743644714357,7.75111198425287 48.271110534668,7.75249195098877 48.2676429748536,7.75249195098877 48.2676429748536,7.75077390670771 48.2665596008302,7.74932527542114 48.2630767822266,7.74650192260737 48.2617645263672,7.74927234649664 48.259449005127,7.745765209198 48.2566452026368,7.7490057945252 48.2553138732911,7.74721717834467 48.2533340454101,7.74966955184931 48.2521286010743,7.74664115905767 48.2496757507324,7.74806022644037 48.2471923828126,7.74393033981323 48.2454147338868,7.74623012542725 48.2392387390137)) | 0.0006 | POINT(7.729464336317438 48.25947469594531) |
55312 | POLYGON((6.10741472244268 45.7985649108887,6.12663316726685 45.8003044128419,6.1390781402589 45.8054924011232,6.14830732345592 45.8041877746583,6.16029119491571 45.8098182678223,6.1819224357605 45.8039054870606,6.1819224357605 45.8039054870606,6.17350721359253 45.7796821594239,6.17350721359253 45.7796821594239,6.13910627365124 45.7867279052736,6.13910627365124 45.7867279052736,6.10589122772222 45.796901702881,6.10589122772222 45.796901702881,6.10741472244268 45.7985649108887)) | 0.0006 | POINT(6.144813757676388 45.796369405893266) |
32724 | POLYGON((1.60764861106884 47.2754287719726,1.61458563804638 47.2952575683595,1.61458563804638 47.2952575683595,1.60917055606853 47.2989196777344,1.60548841953278 47.2980041503906,1.60548841953278 47.2980041503906,1.59581601619726 47.2963829040527,1.5712424516679 47.2987289428711,1.54711580276501 47.2947463989258,1.52874886989599 47.283042907715,1.52874886989599 47.283042907715,1.51392912864691 47.2749137878419,1.51866221427929 47.2553558349611,1.51866221427929 47.2553558349611,1.52395260334015 47.2553405761719,1.52395260334015 47.2553405761719,1.56308114528662 47.2614326477051,1.59288537502289 47.2577018737794,1.59288537502289 47.2577018737794,1.59313559532177 47.2744178771973,1.60764861106884 47.2754287719726)) | 0.0006 | POINT(1.5684892773628896 47.27821884155278) |
23249 | POLYGON((-0.770464181900024 43.2387542724609,-0.727230250835419 43.2551536560059,-0.70356822013855 43.2585067749025,-0.696938693523407 43.2677192687989,-0.696938693523407 43.2677192687989,-0.702428519725743 43.270118713379,-0.702428519725743 43.270118713379,-0.710862338542938 43.2719078063965,-0.718505263328552 43.2688789367676,-0.722749769687653 43.2697257995605,-0.722229063510895 43.2729225158693,-0.722229063510895 43.2729225158693,-0.726458191871643 43.2737121582032,-0.72890841960907 43.2649116516114,-0.732837021350861 43.263542175293,-0.743337988853398 43.2685089111328,-0.743337988853398 43.2685089111328,-0.755338788032532 43.2514419555665,-0.759680867195129 43.2507667541504,-0.759680867195129 43.2507667541504,-0.770227074623108 43.2462463378907,-0.770227074623108 43.2462463378907,-0.770464181900024 43.2387542724609)) | 0.0006 | POINT(-0.7312094027345727 43.26223182678229) |
18817 | POLYGON((15.341570854187 38.2156944274903,15.3411884307861 38.2123985290527,15.3505592346191 38.188850402832,15.3553485870362 38.1853828430176,15.3553485870362 38.1853828430176,15.3573751449586 38.1819076538087,15.3648529052735 38.1749801635743,15.3855257034302 38.1680946350099,15.3887748718262 38.164836883545,15.3887748718262 38.164836883545,15.3934497833252 38.1575393676757,15.3985013961793 38.1521072387696,15.4015827178955 38.1502838134767,15.4094572067261 38.1502647399902,15.4134807586671 38.1472434997559,15.422239303589 38.1381912231446,15.4248695373536 38.1335296630859,15.4413623809815 38.1172218322754,15.4440984725952 38.1154785156251,15.4440984725952 38.1154785156251,15.4348087310791 38.1087799072266,15.4240512847902 38.0986251831055,15.4228000640869 38.0953063964845,15.4173984527589 38.0875663757325,15.4087476730347 38.0801963806152,15.4087476730347 38.0801963806152,15.4042558670045 38.078239440918,15.3939094543458 38.076904296875,15.3918285369873 38.078639984131,15.3914690017701 38.0814971923828,15.3914690017701 38.0814971923828,15.3995409011842 38.0834465026855,15.4005985260011 38.0850639343262,15.3924226760865 38.085189819336,15.3934421539307 38.0901374816895,15.4017047882081 38.0976219177246,15.4064960479737 38.0999603271484,15.4031991958619 38.112247467041,15.3996534347535 38.1167373657227,15.3968620300292 38.1175041198731,15.3831996917725 38.1333580017091,15.3755741119385 38.1438446044922,15.3662033081056 38.1617736816406,15.3569955825806 38.1698226928712,15.3529872894288 38.1714591979981,15.3474617004394 38.1788177490235,15.3458375930786 38.1833114624023,15.3462362289429 38.1900711059571,15.3322486877441 38.2054023742676,15.3296756744384 38.2095375061035,15.3284435272216 38.2145843505859,15.3284435272216 38.2145843505859,15.3315267562866 38.2140274047852,15.336527824402 38.2148628234863,15.3370838165284 38.2156944274903,15.341570854187 38.2156944274903)) | 0.0006 | POINT(15.383714727921962 38.14320387406785) |