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 |
|---|---|---|---|
| 65345 | POLYGON((11.719153404236 47.7390823364259,11.7196483612061 47.7348442077637,11.7186698913575 47.7309074401856,11.7214975357057 47.7254791259766,11.7200031280519 47.7234992980958,11.7270526885987 47.7220878601074,11.7263402938843 47.7189559936523,11.7289133071901 47.7175483703614,11.7286939620972 47.7158164978028,11.7266616821288 47.7134132385255,11.7364416122437 47.7071418762208,11.7381029129029 47.7073364257813,11.7402505874634 47.7058868408204,11.7381753921509 47.6988906860352,11.7381753921509 47.6988906860352,11.7378492355347 47.6973991394044,11.7357234954835 47.6973838806153,11.7336473464965 47.6960487365724,11.7361898422241 47.6935005187989,11.7389488220214 47.6927070617676,11.7389488220214 47.6927070617676,11.7418165206909 47.6957054138185,11.7481050491334 47.6964416503906,11.7499732971193 47.6978950500489,11.7535114288331 47.6985206604005,11.7586030960084 47.6978912353517,11.7601041793823 47.6959877014161,11.7631044387818 47.6964302062989,11.7683572769166 47.6947250366211,11.769874572754 47.6952362060546,11.7758283615113 47.689968109131,11.7849588394166 47.68900680542,11.7847938537598 47.6904602050782,11.7884063720704 47.6910972595216,11.7891397476197 47.6952896118164,11.7862968444824 47.6939811706544,11.7862749099731 47.6951866149902,11.7935819625855 47.6992034912111,11.797890663147 47.7009811401367,11.8005609512329 47.7007102966309,11.808388710022 47.7023315429688,11.8118925094605 47.7019004821778,11.8118925094605 47.7019004821778,11.8131942749025 47.7028656005859,11.8126869201661 47.7036781311036,11.8086576461793 47.7044906616212,11.8086528778076 47.7056541442871,11.811185836792 47.7068595886231,11.8116922378541 47.7086868286133,11.8114490509033 47.7114944458008,11.8098630905153 47.7141304016114,11.8055276870728 47.7154197692871,11.80632686615 47.7180938720704,11.8050460815429 47.7205162048339,11.8031148910522 47.7205200195313,11.8001661300659 47.7228775024415,11.7945556640624 47.7243270874024,11.7935018539429 47.7263069152833,11.7959613800049 47.7271232604981,11.7959613800049 47.7271232604981,11.7957420349122 47.7294349670411,11.7957420349122 47.7294349670411,11.7913093566895 47.7288131713867,11.7862882614136 47.7322731018067,11.7850036621095 47.7303352355958,11.7818460464478 47.7295188903809,11.7784671783448 47.7302742004395,11.7778816223145 47.7294235229492,11.7707586288452 47.7293167114258,11.7681188583375 47.7280883789062,11.7600879669189 47.7268981933593,11.7611837387085 47.7256469726563,11.7553033828735 47.7244567871094,11.7546901702881 47.7252960205079,11.7534265518188 47.7240943908693,11.7532634735109 47.7218132019044,11.7515411376954 47.7220001220703,11.7482919692993 47.7202529907227,11.7465963363648 47.7228889465333,11.7433786392212 47.7252807617188,11.7398672103882 47.7314529418946,11.7376537322999 47.7331428527832,11.7359943389894 47.7386817932129,11.7364854812623 47.7456665039063,11.7353677749634 47.7481575012208,11.7282314300538 47.7454986572266,11.7263135910035 47.743522644043,11.7216682434082 47.7424583435059,11.719153404236 47.7390823364259)) | 0.0006 | POINT(11.765801028771877 47.71448486501522) |
| 24232 | POLYGON((3.43212461471569 45.1661338806153,3.41363811492926 45.1672019958496,3.41363811492926 45.1672019958496,3.40664219856268 45.1591072082521,3.39769363403332 45.1588935852052,3.39215183258057 45.1472015380861,3.39215183258057 45.1472015380861,3.40624451637274 45.148193359375,3.41965842247009 45.1451454162598,3.41965842247009 45.1451454162598,3.42143034934998 45.1557006835938,3.42143034934998 45.1557006835938,3.4200258255006 45.158462524414,3.43212461471569 45.1661338806153)) | 0.0006 | POINT(3.4120375559880642 45.155483832726176) |
| 43998 | POLYGON((0.833099782466888 43.587100982666,0.801385045051575 43.5936203002931,0.802813291549739 43.6028938293458,0.79654103517538 43.6120452880859,0.79654103517538 43.6120452880859,0.810118615627289 43.6211318969728,0.810118615627289 43.6211318969728,0.819610416889248 43.6220893859864,0.826706647872868 43.6267585754396,0.826706647872868 43.6267585754396,0.85556489229208 43.6161880493163,0.857804954051971 43.6096153259277,0.857804954051971 43.6096153259277,0.84595209360134 43.5999946594239,0.843757390976009 43.5934677124025,0.833099782466888 43.587100982666)) | 0.0006 | POINT(0.8256350278854597 43.61029713948574) |
| 42817 | POLYGON((6.36123609542847 48.1864891052246,6.37558460235596 48.1770935058594,6.37558460235596 48.1770935058594,6.37484741210938 48.1647224426271,6.38694286346436 48.1620864868165,6.3886866569519 48.15926361084,6.3886866569519 48.15926361084,6.37015104293829 48.1491470336915,6.36264181137091 48.1533813476562,6.3598513603211 48.1596641540528,6.3598513603211 48.1596641540528,6.35341405868536 48.1759338378906,6.35846948623663 48.1855506896973,6.35846948623663 48.1855506896973,6.36123609542847 48.1864891052246)) | 0.0006 | POINT(6.3696012496948535 48.16820744105753) |
| 29789 | POLYGON((3.72153115272522 47.676685333252,3.74664139747631 47.6872100830079,3.75901412963867 47.6976623535157,3.77821588516241 47.7014503479004,3.77821588516241 47.7014503479004,3.7868003845216 47.7094154357911,3.78590178489685 47.7126884460449,3.77318072319042 47.7082366943359,3.75968742370611 47.7112159729004,3.75968742370611 47.7112159729004,3.74281620979303 47.7035293579102,3.73372054100031 47.7063140869141,3.6828351020813 47.7074737548828,3.66081762313848 47.6987991333008,3.66081762313848 47.6987991333008,3.65952420234686 47.6901741027833,3.65952420234686 47.6901741027833,3.67884969711309 47.6845893859864,3.68775033950811 47.6760406494141,3.68775033950811 47.6760406494141,3.69522953033447 47.6680488586427,3.72153115272522 47.676685333252)) | 0.0006 | POINT(3.723738647642629 47.69605781918484) |
| 47069 | POLYGON((2.4886350631715 50.2907218933105,2.48763608932489 50.2883453369141,2.48763608932489 50.2883453369141,2.47856187820446 50.2849235534669,2.45695924758905 50.284336090088,2.45695924758905 50.284336090088,2.45735788345348 50.2968254089355,2.45735788345348 50.2968254089355,2.47434329986572 50.2998199462891,2.47434329986572 50.2998199462891,2.4886350631715 50.2907218933105)) | 0.0006 | POINT(2.4719789981842237 50.29142990112308) |
| 21938 | POLYGON((-0.536136090755463 44.92582321167,-0.519537448883 44.9570655822754,-0.517378807067757 44.988193511963,-0.517378807067757 44.988193511963,-0.508271217346078 44.9875602722169,-0.508271217346078 44.9875602722169,-0.50116240978241 44.982738494873,-0.494815826416016 44.9658927917482,-0.477966815233231 44.9531745910645,-0.472043007612228 44.9401206970216,-0.463820189237595 44.9364204406738,-0.463820189237595 44.9364204406738,-0.466449797153473 44.919647216797,-0.466449797153473 44.919647216797,-0.474503815174046 44.9222984313965,-0.484064817428589 44.9157104492188,-0.484064817428589 44.9157104492188,-0.501665532588845 44.9180755615235,-0.501665532588845 44.9180755615235,-0.536136090755463 44.92582321167)) | 0.0006 | POINT(-0.49260348081584554 44.94622782657027) |
| 59264 | POLYGON((7.96048212051397 47.2567672729492,7.95706987380976 47.2631492614746,7.95213890075695 47.268196105957,7.94902420043957 47.2744369506837,7.94951105117798 47.2775115966798,7.94951105117798 47.2775115966798,7.94680023193365 47.2792320251465,7.94144916534418 47.2781829833985,7.94144916534418 47.2781829833985,7.93480587005627 47.2751426696777,7.92361116409296 47.2680320739747,7.91384315490728 47.2699546813966,7.91384315490728 47.2699546813966,7.90562009811413 47.266960144043,7.8937139511109 47.2641906738281,7.89081716537481 47.2608146667482,7.89479589462292 47.2510795593263,7.89163923263544 47.2481956481935,7.88769102096569 47.2478904724121,7.88769102096569 47.2478904724121,7.89096307754517 47.245590209961,7.89096307754517 47.245590209961,7.90999889373779 47.2470397949219,7.92514610290533 47.2396774291993,7.92514610290533 47.2396774291993,7.932610988617 47.2400054931641,7.94315719604492 47.2450141906738,7.95228290557873 47.2524185180664,7.96048212051397 47.2567672729492)) | 0.0006 | POINT(7.923420565468965 47.25993892124726) |
| 62411 | POLYGON((9.71109390258789 52.9550476074219,9.7089786529541 52.9543037414551,9.70405960083008 52.9490852355958,9.70954513549799 52.9475555419922,9.70924568176281 52.9453239440918,9.70809078216547 52.9443168640138,9.70902061462397 52.9424667358399,9.71645069122314 52.941722869873,9.7154216766358 52.9394454956056,9.71293544769293 52.9395942687988,9.7131023406983 52.937931060791,9.7141256332398 52.9368705749513,9.71714401245129 52.9370155334473,9.72026634216303 52.9346160888672,9.71181392669683 52.9341697692872,9.70465564727783 52.9315567016602,9.70503902435297 52.9290428161622,9.70646572113043 52.929141998291,9.70366001129156 52.9262886047363,9.70777225494385 52.9242935180664,9.71446800231939 52.9233856201172,9.71210765838629 52.9214439392091,9.71491718292236 52.920726776123,9.71811771392822 52.914649963379,9.7153253555299 52.9152908325195,9.70082092285168 52.9128723144532,9.70080280303955 52.9115486145019,9.69907665252686 52.911434173584,9.70001602172852 52.90340423584,9.69936656951916 52.9009399414064,9.70103645324713 52.8992919921875,9.6955938339234 52.8950233459473,9.68955707550049 52.8939323425294,9.68720912933355 52.8947181701661,9.6901216506958 52.8879280090332,9.68934917449951 52.8829956054689,9.68192958831798 52.8808288574219,9.68114471435553 52.8764724731446,9.6783237457276 52.875904083252,9.67488574981689 52.87260055542,9.66859436035168 52.87215423584,9.66838359832764 52.8712959289552,9.66634941101074 52.8707313537597,9.66634941101074 52.8707313537597,9.66160202026373 52.871971130371,9.66113090515131 52.874912261963,9.65816307067877 52.8757438659668,9.65791988372797 52.8771858215333,9.65402889251715 52.8762664794922,9.65001964569092 52.8777046203614,9.64844322204596 52.8761024475098,9.64395523071289 52.8796310424805,9.63637161254888 52.8825836181641,9.63091754913336 52.8812599182129,9.62939071655285 52.8789978027345,9.61887359619141 52.8785247802734,9.61715888977062 52.8764419555665,9.61329746246349 52.8765716552734,9.60970783233648 52.8780136108399,9.60833168029791 52.8760795593261,9.60526943206781 52.8763275146486,9.60229682922358 52.8792037963868,9.59344291687012 52.8827056884766,9.59624004364014 52.8854484558105,9.59286022186285 52.886058807373,9.59315872192394 52.8876609802247,9.59510326385498 52.8879737854004,9.59451484680176 52.8891677856445,9.59610176086431 52.8891410827637,9.59575366973877 52.889991760254,9.5974063873291 52.8899765014649,9.60061550140387 52.8923110961915,9.60495758056641 52.8923454284668,9.60637760162359 52.893581390381,9.6041889190675 52.8944969177247,9.60293388366711 52.8967247009277,9.60037803649908 52.8970489501954,9.59963417053217 52.9022369384766,9.6003618240357 52.9043426513673,9.59849262237555 52.904727935791,9.60134315490717 52.905158996582,9.60506629943853 52.9127159118652,9.6083488464356 52.9141731262208,9.60453796386713 52.9165115356446,9.60706806182867 52.9179649353028,9.5977897644043 52.9209403991699,9.59978961944586 52.9215850830078,9.59805297851557 52.9265060424806,9.59186649322515 52.9263877868653,9.58998870849621 52.9286193847656,9.58998870849621 52.9286193847656,9.59528732299799 52.9320373535157,9.59778881072998 52.9374313354492,9.59783554077148 52.9396362304689,9.60254573822027 52.9409713745118,9.60382366180431 52.9423751831055,9.60389900207525 52.9551811218263,9.60749626159679 52.9556159973144,9.60816860198975 52.954387664795,9.6138849258424 52.9555473327637,9.61377525329596 52.9565734863282,9.61664962768549 52.957145690918,9.6183843612672 52.953929901123,9.62149333953863 52.9534187316895,9.62881946563726 52.9547767639161,9.62762355804443 52.9552803039551,9.62731075286871 52.9572410583497,9.63208675384527 52.96004486084,9.64055156707769 52.9607620239258,9.64610481262213 52.9626007080078,9.66266250610352 52.97021484375,9.66266250610352 52.97021484375,9.6630649566651 52.9672279357911,9.68523597717297 52.9628486633302,9.70022010803228 52.956226348877,9.71109390258789 52.9550476074219)) | 0.0006 | POINT(9.649333481166705 52.91435155453891) |
| 31579 | POLYGON((2.24774503707886 47.4917335510254,2.23499488830566 47.4963569641114,2.23499488830566 47.4963569641114,2.2455554008485 47.5151519775392,2.26576614379883 47.5151176452637,2.29688167572033 47.5265274047852,2.29688167572033 47.5265274047852,2.32161831855774 47.5220718383789,2.35207200050354 47.5235862731934,2.35639548301702 47.5298500061036,2.3664603233338 47.528419494629,2.38110876083374 47.5316848754883,2.3951141834259 47.5461235046388,2.3951141834259 47.5461235046388,2.41468071937561 47.5306854248047,2.41468071937561 47.5306854248047,2.39118814468395 47.5172882080078,2.37192583084118 47.514575958252,2.36250996589672 47.50638961792,2.35821747779858 47.4965248107911,2.36392331123363 47.4657249450684,2.36392331123363 47.4657249450684,2.34740781784069 47.460376739502,2.34740781784069 47.460376739502,2.3423871994018 47.4595565795898,2.31228637695318 47.4726943969727,2.27508091926586 47.4847030639648,2.25532674789429 47.4871101379395,2.24774503707886 47.4917335510254)) | 0.0006 | POINT(2.332558904375401 47.50528744288857) |