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 |
|---|---|---|---|
| 18487 | POLYGON((8.45680618286133 40.1776390075684,8.45802402496349 40.1769294738771,8.47505855560308 40.1800498962402,8.48074913024902 40.1855735778809,8.48055076599121 40.1868782043457,8.47870540618902 40.1871147155762,8.47823619842535 40.1885414123536,8.48004055023199 40.1905860900879,8.49315738677973 40.1992225646974,8.49315738677973 40.1992225646974,8.49515438079845 40.1960945129395,8.50096130371094 40.1973190307617,8.52204227447515 40.2050743103028,8.53635787963867 40.2043304443359,8.55962467193609 40.2075119018556,8.56504154205334 40.2093620300294,8.56566238403332 40.2153015136719,8.56566238403332 40.2153015136719,8.57601737976086 40.2092742919921,8.59145259857183 40.196258544922,8.59606266021734 40.1895637512207,8.59776020050043 40.1806488037111,8.61620521545404 40.1757392883301,8.61620521545404 40.1757392883301,8.61584186553966 40.1734237670898,8.61769390106213 40.1615180969238,8.61639308929449 40.1569633483887,8.60580444335949 40.1445236206055,8.59180831909191 40.140926361084,8.58629322052013 40.1405830383301,8.58284568786627 40.1419486999512,8.57468223571789 40.1426734924316,8.55856895446777 40.1402435302734,8.55211925506603 40.1338424682618,8.55082988739014 40.1283035278321,8.56311988830578 40.1261825561523,8.56311988830578 40.1261825561523,8.54357910156256 40.1196327209473,8.54376125335699 40.1185111999512,8.54660224914551 40.1169548034669,8.55512142181396 40.1053123474122,8.55513000488281 40.1022682189942,8.550355911255 40.0985641479493,8.5451450347901 40.0972175598144,8.53437900543213 40.0916366577148,8.52395343780512 40.0795402526855,8.52103805542004 40.0736694335937,8.51954174041748 40.0645637512208,8.51954174041748 40.0645637512208,8.51712036132824 40.0638961791993,8.50503063201899 40.065486907959,8.50100040435791 40.0667839050294,8.49056339263922 40.0731430053711,8.48597240447998 40.0749511718751,8.48597240447998 40.0749511718751,8.4898595809936 40.0787506103516,8.48958015441895 40.08402633667,8.48847007751476 40.0868072509767,8.49069213867188 40.0859718322753,8.49291706085205 40.0870819091797,8.49013900756847 40.0923614501953,8.48597240447998 40.0948600769044,8.48624992370605 40.0995826721192,8.49013900756847 40.1006889343262,8.4912509918214 40.1023597717286,8.49069213867188 40.1040267944336,8.48902893066412 40.1051406860351,8.48541641235352 40.1045837402344,8.48541641235352 40.1070823669435,8.48708438873291 40.1112518310547,8.48569202423101 40.111530303955,8.48458194732666 40.1181945800782,8.47541809082031 40.1273612976074,8.47208309173595 40.1293106079103,8.46708011627197 40.1393051147461,8.46319198608404 40.1443099975587,8.4637508392334 40.14652633667,8.45847225189215 40.1518058776855,8.45930576324469 40.1526374816895,8.45847225189215 40.154582977295,8.45985984802257 40.1562499999999,8.45902824401861 40.1584739685059,8.46041870117193 40.159580230713,8.45958423614508 40.1606941223146,8.46041870117193 40.1629219055176,8.4595823287965 40.1673622131349,8.46153068542486 40.1693000793458,8.46153068542486 40.1726417541504,8.46013832092297 40.1745834350586,8.45569419860834 40.1759719848633,8.45680618286133 40.1776390075684)) | 0.0006 | POINT(8.514670753479045 40.13929066128202) |
| 38509 | POLYGON((0.643400251865501 49.5790176391602,0.660485148429984 49.5733604431152,0.660485148429984 49.5733604431152,0.64621859788906 49.5715293884278,0.633822143077964 49.5585365295411,0.633822143077964 49.5585365295411,0.626566290855465 49.5666046142578,0.607635736465397 49.5691108703613,0.607635736465397 49.5691108703613,0.614896714687461 49.580348968506,0.628468632698059 49.582878112793,0.628468632698059 49.582878112793,0.634393811226005 49.5782279968263,0.643400251865501 49.5790176391602)) | 0.0006 | POINT(0.6327922298358692 49.57257696298455) |
| 14934 | POLYGON((9.03188800811762 44.573528289795,9.02519989013678 44.5693550109864,9.02332019805908 44.562126159668,9.02660369873041 44.5571365356445,9.02988815307623 44.5545997619629,9.03140830993658 44.5502319335938,9.02604293823248 44.5435447692872,9.02010059356689 44.5398025512696,9.01918888092035 44.5369224548341,9.01918888092035 44.5369224548341,9.01856231689464 44.5362548828126,9.01410484313971 44.5372009277345,9.0060071945191 44.5480880737306,8.99292564392096 44.5506439208984,8.98423862457287 44.5483703613281,8.98686504364014 44.5410118103027,8.98483276367182 44.5372734069825,8.97792243957525 44.5300521850586,8.97792243957525 44.5300521850586,8.96079063415527 44.5379295349121,8.96079063415527 44.5379295349121,8.95422267913824 44.553409576416,8.95422267913824 44.553409576416,8.95775318145752 44.5695533752443,8.96471214294445 44.5702934265138,8.97942829132074 44.5792236328125,8.99189472198486 44.5836181640625,8.99898529052734 44.5830116271973,8.99898529052734 44.5830116271973,9.00339317321783 44.5759468078614,9.01175308227545 44.5718154907227,9.01573181152338 44.5714912414551,9.03188800811762 44.573528289795)) | 0.0006 | POINT(8.99840232729914 44.55480504035954) |
| 67168 | POLYGON((9.05029106140142 48.8536682128907,9.04858112335211 48.8497581481934,9.05255699157715 48.8480758666992,9.05464553833013 48.8433799743652,9.06018543243414 48.8422355651855,9.06036949157715 48.8410797119141,9.06590557098394 48.8414306640625,9.06572341918951 48.8420829772949,9.08161067962652 48.8416938781738,9.08187484741211 48.8401222229003,9.0881462097168 48.8400115966798,9.08836841583252 48.838478088379,9.09028911590582 48.8385009765624,9.09100341796881 48.8368911743165,9.09100341796881 48.8368911743165,9.09412670135504 48.8381919860841,9.09938335418701 48.8293418884278,9.10158824920666 48.8294258117677,9.1029624938966 48.8280677795411,9.10811614990234 48.8293342590333,9.10867881774908 48.8249244689941,9.11135101318359 48.8253364562989,9.11207389831543 48.8219566345216,9.13067436218273 48.8270416259767,9.13808441162115 48.8280525207521,9.13903427124035 48.8311119079591,9.13796710968018 48.8356399536132,9.13899612426769 48.8373107910157,9.13190269470215 48.8429260253906,9.13476181030279 48.8454322814943,9.13825702667248 48.8437423706055,9.14257526397705 48.845287322998,9.13863468170166 48.851676940918,9.13416671752935 48.8530082702637,9.13368701934826 48.8574829101563,9.13368701934826 48.8574829101563,9.13179874420166 48.8625602722169,9.12697887420666 48.8618545532227,9.12456893920898 48.8670234680175,9.12131595611578 48.8668289184571,9.12113666534418 48.8683471679688,9.12113666534418 48.8683471679688,9.10547637939459 48.8690605163575,9.09005165100098 48.8654403686523,9.090163230896 48.8644065856934,9.08806419372564 48.8648490905762,9.0862455368042 48.863151550293,9.08247375488293 48.8625373840333,9.08317470550543 48.8613929748536,9.08034896850586 48.8610725402833,9.08161354064941 48.8602409362794,9.06693935394293 48.8599548339844,9.06673526763916 48.8585662841797,9.06452846527111 48.8580513000488,9.05445003509521 48.8586425781251,9.05445003509521 48.8586425781251,9.048984527588 48.856788635254,9.05052471160883 48.8554344177246,9.04942989349377 48.8551330566406,9.05029106140142 48.8536682128907)) | 0.0006 | POINT(9.09613311896894 48.84822716147216) |
| 19181 | POLYGON((10.0011262893677 44.2639541625977,9.99651527404797 44.2676239013672,9.99463081359858 44.2709999084473,9.99645614624023 44.2759246826173,9.9923028945924 44.2778091430665,9.9796314239502 44.2783393859863,9.97861003875744 44.2824554443359,9.97912406921387 44.2945137023927,9.98248100280773 44.3093757629396,9.97675037384045 44.3114852905274,9.96793270111084 44.3196525573732,9.96805095672613 44.3237571716309,9.97245121002209 44.3381080627442,9.97649955749517 44.3409347534181,9.96859359741211 44.3490409851075,9.96859359741211 44.3490409851075,9.97336673736578 44.3523864746095,9.99134922027599 44.3741645812989,9.995924949646 44.3768234252931,10.0007562637329 44.3774566650391,10.010018348694 44.3818473815919,10.0175046920778 44.3879051208497,10.0175046920778 44.3879051208497,10.0227184295655 44.3838882446288,10.043384552002 44.3750114440919,10.0541982650757 44.3739852905273,10.0541982650757 44.3739852905273,10.0592060089112 44.3719139099122,10.0791120529176 44.3576583862305,10.0791120529176 44.3576583862305,10.0741109848022 44.350440979004,10.0707979202272 44.3476448059083,10.0690402984619 44.3407287597657,10.0700683593751 44.3365402221681,10.0637464523315 44.3254356384277,10.0576992034912 44.3218460083009,10.0542201995851 44.3215446472169,10.0535402297974 44.3206596374511,10.0542650222778 44.3114547729492,10.0560169219972 44.3064155578613,10.0581302642823 44.3039817810059,10.0580301284791 44.3026313781739,10.0464220046997 44.2934494018556,10.0356349945069 44.2893981933594,10.0089759826661 44.267433166504,10.0011262893677 44.2639541625977)) | 0.0006 | POINT(10.020640076531361 44.32944912380648) |
| 40299 | POLYGON((1.62467896938335 45.1757507324219,1.62952983379375 45.1757545471191,1.63515043258673 45.1812553405761,1.653160572052 45.1773567199708,1.65945243835449 45.1825752258302,1.65945243835449 45.1825752258302,1.66755115985876 45.171371459961,1.67994654178619 45.169418334961,1.67994654178619 45.169418334961,1.67645931243896 45.1640014648437,1.67645931243896 45.1640014648437,1.6571056842804 45.1562614440919,1.65314781665813 45.1467399597167,1.65511178970348 45.1402168273927,1.65511178970348 45.1402168273927,1.65151596069347 45.1357879638672,1.64748561382299 45.1351432800293,1.64674198627483 45.1380081176759,1.64674198627483 45.1380081176759,1.64712369441992 45.1448402404785,1.63189899921423 45.1533699035646,1.61265480518335 45.1549339294433,1.61265480518335 45.1549339294433,1.59802615642559 45.1606941223145,1.59802615642559 45.1606941223145,1.59508013725281 45.1634483337403,1.59892964363104 45.1733932495117,1.61745667457581 45.1712493896484,1.62467896938335 45.1757507324219)) | 0.0006 | POINT(1.6416643304484702 45.16005066462929) |
| 66977 | POLYGON((9.99793624877924 47.6794395446778,9.99409484863287 47.6816406250001,9.99755477905268 47.6828956604005,9.9971170425415 47.6841430664064,10.0014925003052 47.6857452392578,10.0029573440552 47.6895904541016,10.0037603378296 47.6891593933106,10.0030460357666 47.6901016235352,10.0010070800782 47.687629699707,9.99604320526123 47.6850204467774,9.99633598327642 47.6889724731445,9.99216175079351 47.6832580566406,9.99275875091558 47.6782264709473,9.98903369903564 47.6781921386719,9.9866247177124 47.6797332763673,9.98113822937023 47.6810836791993,9.97721290588385 47.6836624145508,9.98334980010992 47.686092376709,9.98492622375488 47.6918487548828,9.99802303314209 47.6958465576172,10.0004606246949 47.69828414917,10.0021324157714 47.6975555419922,10.0039625167848 47.6982116699219,10.0040426254273 47.6995315551758,10.0000381469727 47.7032623291016,9.99859714508068 47.707576751709,9.99347591400146 47.7084083557129,9.99316310882574 47.7116317749025,9.98782062530529 47.7145118713379,9.98695373535151 47.7185058593749,9.98488616943359 47.7187919616699,9.97971057891846 47.7247619628907,9.98362159729004 47.7289772033692,9.98377799987799 47.730640411377,9.9857635498048 47.7331390380861,9.98904514312756 47.733943939209,9.99272537231457 47.7375221252441,9.99064636230469 47.7388954162598,9.99513244628918 47.7405700683594,9.99528694152838 47.7424316406251,9.99909305572515 47.742790222168,9.99913311004644 47.7441482543946,10.0018491744996 47.7443656921387,10.0030479431153 47.7456741333008,10.0009651184083 47.7487411499024,9.99746036529552 47.7474632263184,9.99311637878424 47.7474632263184,9.99318408966059 47.7487106323242,9.98500728607189 47.7520790100098,9.98500728607189 47.7520790100098,9.98262882232666 47.7526435852051,9.97666835784912 47.7517700195313,9.97256565094 47.7490730285646,9.97523117065424 47.7478103637696,9.9719705581665 47.7486381530762,9.97006607055675 47.7473258972169,9.97050380706798 47.7450370788575,9.96830081939692 47.744197845459,9.95960807800304 47.7447128295899,9.96044158935541 47.7464790344238,9.95814418792719 47.7469520568848,9.95480823516857 47.7498664855958,9.94780158996588 47.7484016418457,9.94308567047131 47.7507057189941,9.94168949127203 47.7527465820313,9.93816661834728 47.7520446777345,9.93816661834728 47.7520446777345,9.93915843963617 47.7502899169922,9.93811321258551 47.7484970092773,9.93229484558111 47.7480545043946,9.92940807342541 47.7499504089355,9.92528247833246 47.7471694946289,9.9221658706665 47.7479476928711,9.92126846313477 47.7469291687012,9.92125701904303 47.7442321777345,9.91867733001709 47.7424201965333,9.91870975494379 47.7383918762208,9.89627552032482 47.739429473877,9.8915309906007 47.7341270446778,9.88809871673595 47.7326889038086,9.88488960266119 47.7293281555176,9.88037109375 47.7285461425782,9.87762451171886 47.7266082763672,9.87762451171886 47.7266082763672,9.87687873840338 47.7244567871094,9.87160301208502 47.7214164733888,9.87053871154785 47.71821975708,9.87413311004639 47.7193908691407,9.87589359283453 47.7180786132814,9.87715244293213 47.7165145874024,9.87583541870129 47.7142410278321,9.87808990478516 47.7128715515138,9.87796497344982 47.7111244201661,9.88434600830072 47.71199798584,9.88555049896246 47.7039260864258,9.88800334930431 47.7026443481446,9.88668441772472 47.7016029357911,9.88792037963867 47.7007141113282,9.88709163665777 47.6999168395996,9.88372993469244 47.6994209289551,9.88421344757086 47.6969261169434,9.89059352874767 47.697681427002,9.89229393005382 47.6990470886231,9.89645099639904 47.6987457275391,9.89723682403559 47.6975822448732,9.89506912231457 47.6930503845214,9.89672565460205 47.6914710998536,9.89323043823242 47.6888618469238,9.88954925537109 47.6894989013673,9.88971233367931 47.6870613098145,9.88661193847668 47.6859397888185,9.88806247711182 47.6848526000977,9.8903799057008 47.6858177185059,9.89247131347662 47.6791152954102,9.89093971252441 47.6781463623047,9.88310241699224 47.6770515441895,9.8811092376709 47.6747016906739,9.87912082672125 47.6740722656249,9.87912082672125 47.6740722656249,9.88038063049311 47.673412322998,9.88105106353765 47.6708564758301,9.8848934173584 47.6689109802247,9.8859214782716 47.6664619445801,9.89127445220947 47.6649475097656,9.89327716827393 47.6632308959961,9.90370178222662 47.6614303588868,9.90662097930908 47.6620483398437,9.91630363464367 47.6610221862793,9.9225254058839 47.6578559875489,9.9225254058839 47.6578559875489,9.92709350585938 47.6550407409669,9.93262577056879 47.6539535522462,9.93262577056879 47.6539535522462,9.9376735687257 47.655689239502,9.9406414031983 47.6578712463379,9.94506454467785 47.6547927856446,9.95155048370373 47.6561737060547,9.95706462860119 47.6539764404297,9.95889759063721 47.6523017883301,9.96244239807129 47.6540451049804,9.96799373626715 47.653549194336,9.96799373626715 47.653549194336,9.97074604034424 47.6536254882814,9.97541904449463 47.6569480895997,9.97772312164312 47.6617202758789,9.97536087036138 47.6637496948243,9.97602272033697 47.665325164795,9.98065948486322 47.6670417785645,9.9898681640625 47.6751594543457,9.99598789215088 47.6773262023926,9.99793624877924 47.6794395446778)) | 0.0006 | POINT(9.943784128824916 47.70525784810385) |
| 24050 | POLYGON((2.54259657859802 45.184814453125,2.54735970497131 45.1846885681152,2.55042934417725 45.1908874511718,2.56186890602118 45.1968154907227,2.58083057403576 45.1969757080079,2.58862566947937 45.2054710388185,2.58862566947937 45.2054710388185,2.59719848632812 45.2036476135254,2.59719848632812 45.2036476135254,2.61277985572821 45.1975440979004,2.62506842613232 45.1768646240235,2.62506842613232 45.1768646240235,2.58365035057068 45.1621131896973,2.58365035057068 45.1621131896973,2.58068513870251 45.1654891967775,2.58068513870251 45.1654891967775,2.54106903076172 45.1816673278809,2.54259657859802 45.184814453125)) | 0.0006 | POINT(2.5816111845129086 45.18591555427106) |
| 69956 | POLYGON((9.62207508087158 54.5979766845703,9.61894321441656 54.5953903198243,9.61808776855463 54.593391418457,9.61841201782227 54.5919189453126,9.62131214141846 54.5914840698242,9.61980724334722 54.5902252197266,9.62307262420666 54.5907859802246,9.62401390075684 54.590145111084,9.62360668182379 54.5888595581055,9.62195587158203 54.5872230529785,9.62017154693615 54.5875701904297,9.61934471130382 54.5857048034669,9.61347579956055 54.5854873657228,9.61117839813238 54.582992553711,9.61117839813238 54.582992553711,9.61121940612793 54.5839805603027,9.60875129699718 54.5852470397949,9.60940742492676 54.585636138916,9.60866832733154 54.5862503051759,9.60154819488525 54.5860137939454,9.60104179382336 54.5851211547853,9.60244369506842 54.5845909118653,9.59705257415783 54.5808181762695,9.59264755249023 54.5801239013672,9.58991050720221 54.5780563354493,9.57408905029297 54.5765228271486,9.55788993835455 54.5732192993165,9.55566883087158 54.5737762451172,9.55089378356928 54.5709915161134,9.54764747619635 54.570384979248,9.53316402435314 54.5699882507324,9.53039646148682 54.5687446594239,9.52778053283691 54.5655479431153,9.52778053283691 54.5655479431153,9.52720260620112 54.5644645690917,9.52720260620112 54.5644645690917,9.52667617797852 54.5652160644532,9.53039646148682 54.5694198608399,9.52966594696045 54.5702934265137,9.53065872192383 54.5714950561524,9.54147529602051 54.5727882385254,9.54547119140625 54.5723609924317,9.54900074005127 54.5733757019044,9.55020332336437 54.5760993957519,9.54943656921387 54.5781898498535,9.54016113281256 54.5817909240724,9.54016113281256 54.5817909240724,9.53964710235596 54.5833244323732,9.54078578948986 54.5821838378907,9.54566097259527 54.5839233398438,9.54734420776373 54.5833168029786,9.5572509765625 54.5888671875001,9.56444358825678 54.5900611877441,9.5651330947876 54.5910530090333,9.56442832946772 54.5921897888184,9.56871604919439 54.5926170349122,9.56658458709722 54.5981903076172,9.57046604156494 54.5988655090333,9.57131958007824 54.6001129150391,9.57301139831537 54.5998191833497,9.57301139831537 54.5998191833497,9.57556819915771 54.5988578796387,9.57674407958984 54.5959510803223,9.57997798919678 54.5965118408204,9.58056259155285 54.5951957702637,9.58967590332031 54.5962944030763,9.59259700775152 54.5948905944825,9.59309768676763 54.5967864990234,9.5973739624024 54.5948600769044,9.60237407684326 54.596736907959,9.60264301300055 54.5986671447754,9.60109901428234 54.6015014648439,9.60404396057129 54.6026268005371,9.6093893051148 54.5998649597169,9.61417675018311 54.6001129150391,9.62207508087158 54.5979766845703)) | 0.0006 | POINT(9.578259671529159 54.58543548583987) |
| 40204 | POLYGON((2.47139906883251 42.7163124084473,2.47153139114386 42.7205467224122,2.47153139114386 42.7205467224122,2.44727349281305 42.7401695251465,2.42549419403088 42.7443885803224,2.42549419403088 42.7443885803224,2.40798163414007 42.7474250793458,2.40798163414007 42.7474250793458,2.40559005737305 42.7271690368653,2.39339780807506 42.7233238220215,2.39239621162415 42.7199668884278,2.36247491836559 42.7040557861329,2.36247491836559 42.7040557861329,2.36944580078125 42.6963920593262,2.37709116935736 42.693874359131,2.37642574310297 42.6877136230469,2.37642574310297 42.6877136230469,2.40881514549267 42.6833915710449,2.40881514549267 42.6833915710449,2.41514611244207 42.6803703308105,2.41514611244207 42.6803703308105,2.4183132648468 42.6939086914063,2.42987084388744 42.7048416137696,2.45988893508917 42.7215423583985,2.47139906883251 42.7163124084473)) | 0.0006 | POINT(2.4125168720881693 42.7113868395488) |