Datenbank-Dokumentation

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.

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.
SpaltennameDatentypMögliche WerteBeschreibung
id_ortint(10) unsignedbeliebigFremdschlüssel, der auf die Tabelle `orte` verweist.
geodaten

geometry

Dieser 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:

  • Auswahl von "GeomFromText" in der Spalte "Funktion"
  • Eingabe von 
    POINT(11.583720 48.135876)
    in der Spalte "Wert"
beliebigDie simplifizierten Geodaten.
epsilonfloat(5,4)beliebigDie Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone.
mittelpunkt

point

Dieser 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:

  • Auswahl von "GeomFromText" in der Spalte "Funktion"
  • Eingabe von 
    POINT(11.583720 48.135876)
    in der Spalte "Wert"
beliebigDer geometrische Mittelpunkt des vereinfachten Polygons.
Ausschnitt
id_ortgeodatenepsilonmittelpunkt
13243MULTIPOLYGON(((16.0004634857178 38.0095558166504,16.0093173980713 38.0145416259766,16.0119647979736 38.0141220092773,16.0198726654053 38.0159645080566,16.0251693725587 38.020866394043,16.0251693725587 38.020866394043,16.0244369506837 38.0303840637208,16.0291404724122 38.0424232482911,16.0453624725343 38.0517616271974,16.0493869781494 38.0550498962402,16.0493869781494 38.0550498962402,16.038845062256 38.0536117553711,16.0329742431641 38.0518455505371,16.0241527557374 38.0509605407716,16.0194873809815 38.051513671875,16.0081386566163 38.0583343505861,16.0023212432862 38.0655746459962,16.0015449523926 38.0703315734863,16.0015449523926 38.0703315734863,15.9986181259156 38.0782432556153,15.9841938018799 38.0900115966798,15.9748020172119 38.0955009460449,15.9658861160278 38.0972061157227,15.9595947265626 38.1011352539062,15.9447793960571 38.1222076416017,15.9417839050294 38.1297264099122,15.9209756851196 38.14457321167,15.9120206832885 38.1484718322755,15.9052858352662 38.1576194763185,15.9052858352662 38.1576194763185,15.9015035629272 38.1511001586914,15.9015035629272 38.1511001586914,15.9088306427003 38.1387023925781,15.9224748611451 38.1322822570801,15.9238643646241 38.1304473876954,15.9241285324097 38.1280975341797,15.9225988388061 38.1233444213868,15.9156942367555 38.121639251709,15.9160900115966 38.1166725158691,15.9244270324708 38.1037101745605,15.9307336807251 38.1031494140626,15.9338264465332 38.1002197265626,15.938648223877 38.0861396789551,15.9368648529054 38.085075378418,15.9454412460328 38.0753784179688,15.9511814117432 38.0645751953126,15.9505958557129 38.0564346313478,15.9530439376831 38.0523567199706,15.9530439376831 38.0523567199706,15.9550189971924 38.0482215881348,15.9571514129639 38.0475730895997,15.9723558425903 38.0499420166017,15.9939470291138 38.0459823608398,15.9965248107911 38.0424575805665,15.9939289093018 38.0208206176758,15.9962673187256 38.0124435424805,16.0004634857178 38.0095558166504)),((16.1429157257081 38.0442733764648,16.136770248413 38.0417060852051,16.1322288513184 38.0419921875,16.1275196075439 38.0446968078614,16.1259422302247 38.0466995239259,16.129508972168 38.0557174682617,16.1405372619628 38.0596733093262,16.1492595672608 38.0579833984374,16.1492595672608 38.0579833984374,16.1484718322754 38.0576400756836,16.1470832824707 38.0526390075684,16.145139694214 38.0512504577637,16.1429157257081 38.0442733764648)))0.0006POINT(15.979105762287501 38.076596129898554)
60973POLYGON((8.86441802978521 46.1060638427734,8.87149429321289 46.1049385070802,8.87149429321289 46.1049385070802,8.87539386749273 46.1167259216309,8.88307571411127 46.1251831054688,8.88652992248535 46.1310272216796,8.8904209136964 46.1336097717285,8.89510154724132 46.1425514221193,8.89510154724132 46.1425514221193,8.88367462158209 46.1411323547364,8.87412452697754 46.134449005127,8.87086486816412 46.1340560913087,8.86685466766352 46.1361045837402,8.8636293411256 46.1400604248047,8.86310577392589 46.1433563232422,8.86166667938244 46.1445579528809,8.8537216186524 46.143970489502,8.85004425048828 46.1461029052734,8.85004425048828 46.1461029052734,8.84082889556896 46.1460685729981,8.83318424224865 46.1419982910157,8.83318424224865 46.1419982910157,8.83508682250977 46.1338882446288,8.83708000183111 46.1308174133301,8.84229755401606 46.1264495849609,8.84254264831543 46.1199035644532,8.84418773651123 46.115406036377,8.84695339202881 46.1126937866212,8.85976219177252 46.1100692749023,8.86106872558594 46.1083869934083,8.86050033569342 46.1056938171388,8.86050033569342 46.1056938171388,8.86441802978521 46.1060638427734))0.0006POINT(8.861498057842297 46.12864220142369)
16424POLYGON((8.80134391784668 45.2828865051271,8.79383277893066 45.2949333190917,8.79383277893066 45.2949333190917,8.79444980621344 45.3007850646973,8.79269790649414 45.3057518005372,8.78871345520025 45.3112144470215,8.78871345520025 45.3112144470215,8.7979364395141 45.3160400390625,8.79043483734142 45.321849822998,8.78845596313488 45.3265113830567,8.78993415832531 45.3372192382812,8.79492664337164 45.335720062256,8.80772876739513 45.3351936340332,8.81268501281738 45.3413391113282,8.81161022186285 45.3463058471681,8.81161022186285 45.3463058471681,8.81476497650152 45.3456344604492,8.82804489135748 45.3464889526368,8.85116672515863 45.3512802124025,8.85946655273443 45.3551788330078,8.86749553680426 45.3556480407715,8.86749553680426 45.3556480407715,8.86536884307856 45.3538246154786,8.86507987976074 45.3520965576172,8.86713981628418 45.3440628051758,8.88689136505138 45.3414535522462,8.89806365966791 45.3386764526368,8.91081714630127 45.3338127136232,8.9121084213258 45.3319854736329,8.90732955932617 45.3273200988771,8.92063236236572 45.3214645385743,8.92063236236572 45.3214645385743,8.93451213836681 45.3204383850099,8.93451213836681 45.3204383850099,8.94305038452154 45.3169593811036,8.94493961334234 45.3145561218263,8.94567298889166 45.2924041748047,8.95121002197271 45.2878341674805,8.95996475219727 45.2839355468751,8.95996475219727 45.2839355468751,8.97565746307379 45.2737846374512,8.98399925231945 45.2659339904786,8.98399925231945 45.2659339904786,8.9837694168092 45.2654876708984,8.9837694168092 45.2654876708984,8.96865558624273 45.2614059448243,8.96865558624273 45.2614059448243,8.95806598663324 45.2696914672852,8.95414257049566 45.2710494995117,8.95162963867199 45.2707672119142,8.94391536712652 45.2749061584472,8.93742084503185 45.2815551757812,8.93854236602789 45.2826347351075,8.93169212341314 45.2858276367189,8.92597866058355 45.286506652832,8.91835308074945 45.2781944274902,8.9196453094483 45.2749099731446,8.89532947540283 45.2724494934082,8.88048362731934 45.2830924987794,8.86746120452892 45.2804679870605,8.83662891387939 45.2786636352539,8.81838035583502 45.2813034057617,8.8042783737182 45.2784233093262,8.8042783737182 45.2784233093262,8.80134391784668 45.2828865051271))0.0006POINT(8.882968172431033 45.306141436100035)
38877POLYGON((1.70664572715759 43.2860374450684,1.70127546787268 43.2816963195802,1.70127546787268 43.2816963195802,1.73493623733526 43.2730102539064,1.73493623733526 43.2730102539064,1.74782717227947 43.2837944030763,1.74782717227947 43.2837944030763,1.73419463634485 43.2910957336426,1.73419463634485 43.2910957336426,1.72176086902618 43.2908401489258,1.7190506458283 43.2847709655763,1.71485412120825 43.2835350036622,1.70664572715759 43.2860374450684))0.0006POINT(1.7248981992404033 43.2836980819703)
68562POLYGON((11.470817565918 51.1698379516603,11.4855480194092 51.1680183410646,11.4855480194092 51.1680183410646,11.5302810668946 51.1699829101563,11.5317716598512 51.1713371276855,11.5258588790895 51.1783714294434,11.5303792953491 51.1795120239258,11.5383977890015 51.1789360046387,11.5383977890015 51.1789360046387,11.5373497009277 51.1826362609864,11.5290489196778 51.1814918518067,11.5268325805664 51.1874237060547,11.5283317565919 51.1872024536134,11.528497695923 51.1895256042481,11.5330047607423 51.1893577575685,11.5330057144166 51.190700531006,11.5263719558716 51.1905136108398,11.5260467529297 51.1913452148438,11.5234975814819 51.1913299560547,11.5205478668213 51.197826385498,11.5175466537477 51.1987609863282,11.5182857513429 51.2004661560058,11.5324602127075 51.1995925903321,11.5388956069947 51.2004356384278,11.5472373962403 51.2026481628419,11.5513410568238 51.2054710388184,11.5574769973755 51.207576751709,11.5537433624268 51.2103271484375,11.5516633987428 51.2133331298829,11.551700592041 51.2162055969239,11.5496435165405 51.2183837890626,11.5487899780274 51.2211799621583,11.5511503219605 51.2235145568849,11.5512294769288 51.2257270812989,11.5531435012818 51.2292366027833,11.5449972152711 51.228328704834,11.5342149734498 51.2293548583986,11.5362844467163 51.2372703552247,11.5362844467163 51.2372703552247,11.5232524871827 51.2352333068848,11.5314035415649 51.2305221557617,11.5261030197144 51.2319450378417,11.5194358825684 51.228572845459,11.5188217163086 51.2292900085449,11.5144758224487 51.227825164795,11.514437675476 51.2267532348633,11.5118980407715 51.2272453308106,11.5105657577515 51.2285881042481,11.5081872940064 51.2266273498535,11.5051403045655 51.2275543212891,11.5001564025878 51.2237358093261,11.4985313415528 51.2247848510742,11.4985580444336 51.227996826172,11.5002050399781 51.2279281616212,11.498839378357 51.2310447692871,11.4877767562867 51.2297897338867,11.4875402450562 51.2327880859376,11.4842195510864 51.2330055236817,11.4852771759033 51.2355613708496,11.4831447601319 51.2363624572754,11.4807825088502 51.2358131408691,11.4801845550537 51.2319602966309,11.4763002395631 51.2326393127442,11.4744625091552 51.2290840148925,11.473108291626 51.2287597656251,11.4715814590455 51.2297172546387,11.4645776748658 51.2299194335939,11.4584627151489 51.2287826538087,11.4583778381347 51.2302246093751,11.4534664154052 51.2303886413575,11.4534664154052 51.2303886413575,11.4538984298707 51.2270584106446,11.4525861740113 51.2190246582032,11.4560194015504 51.2113075256349,11.476526260376 51.2134895324707,11.4762506484985 51.2113227844239,11.4775333404542 51.2096481323243,11.4854183197022 51.2065696716308,11.4849548339845 51.2050056457521,11.4933767318726 51.2016525268556,11.5011262893676 51.2016944885254,11.5071229934693 51.2002029418945,11.5068988800049 51.1991157531739,11.4947280883788 51.1972122192383,11.4956407546997 51.1937141418458,11.4943838119507 51.1885414123536,11.495005607605 51.1861877441407,11.4979362487793 51.1833000183105,11.4976644515992 51.1826477050781,11.477562904358 51.1785697937012,11.4738664627075 51.179069519043,11.4720516204835 51.1806221008302,11.4701051712036 51.1803092956543,11.4701051712036 51.1803092956543,11.4719791412354 51.1743507385254,11.470817565918 51.1698379516603))0.0006POINT(11.506432703921703 51.208622581080405)
38613POLYGON((1.02919054031383 49.4879913330078,1.01760220527649 49.4825172424316,1.01760220527649 49.4825172424316,1.01572191715235 49.4793930053711,1.02273964881908 49.4745101928712,1.01932394504558 49.4650421142579,1.01932394504558 49.4650421142579,1.03750729560858 49.4656944274903,1.03750729560858 49.4656944274903,1.03826975822449 49.4721107482911,1.04807698726654 49.473976135254,1.04794776439678 49.4806518554689,1.04794776439678 49.4806518554689,1.04838693141937 49.4839859008789,1.02919054031383 49.4879913330078))0.0006POINT(1.031939157417894 49.47569847106939)
49598POLYGON((3.74997997283947 49.4823074340821,3.73153305053705 49.4792022705078,3.73153305053705 49.4792022705078,3.74367356300354 49.4726295471191,3.74165701866156 49.4590339660646,3.73291635513311 49.4552688598633,3.73268294334417 49.4417762756348,3.73268294334417 49.4417762756348,3.75234699249262 49.4347457885742,3.75234699249262 49.4347457885742,3.75675296783453 49.4335021972657,3.76790547370911 49.4392318725587,3.76790547370911 49.4392318725587,3.76918005943298 49.4424400329591,3.76325297355646 49.447105407715,3.77167153358459 49.4587669372559,3.79022955894476 49.4640197753907,3.78907918930059 49.4672470092774,3.78907918930059 49.4672470092774,3.78865861892706 49.4695053100586,3.78865861892706 49.4695053100586,3.76620388031012 49.4768028259277,3.77064347267157 49.4858703613281,3.77064347267157 49.4858703613281,3.76683473587042 49.4876670837402,3.74997997283947 49.4823074340821))0.0006POINT(3.760722084045434 49.460588073730506)
43371POLYGON((1.83808004856115 42.9574012756348,1.82724702358257 42.955997467041,1.82724702358257 42.955997467041,1.82045614719385 42.953338623047,1.8190354108811 42.9479446411133,1.8190354108811 42.9479446411133,1.83036041259777 42.9424743652345,1.82944464683538 42.9326515197755,1.82524883747107 42.9313201904297,1.82524883747107 42.9313201904297,1.82956290245062 42.9201164245605,1.82956290245062 42.9201164245605,1.83375525474543 42.9215850830078,1.84272968769085 42.9140090942383,1.84256505966198 42.9106063842775,1.84256505966198 42.9106063842775,1.85939109325415 42.9123420715332,1.85939109325415 42.9123420715332,1.85794627666479 42.9155044555665,1.86800324916845 42.9218406677246,1.86645674705505 42.9283370971681,1.87407016754162 42.9301910400391,1.87407016754162 42.9301910400391,1.87311410903942 42.9365653991699,1.84551405906683 42.9493408203126,1.83808004856115 42.9574012756348))0.0006POINT(1.8424040651322071 42.93160339355472)
35476POLYGON((5.94485712051403 46.9938468933105,5.95337963104242 46.9972686767579,5.9608235359193 47.0059776306153,5.96679401397705 47.0290603637695,5.96384048461925 47.0352630615236,5.96384048461925 47.0352630615236,5.96877336502081 47.0346221923829,5.9733934402467 47.0407409667969,5.98174571990978 47.0442543029786,5.99166297912609 47.0431671142578,5.99997949600231 47.0467185974122,6.00793790817266 47.0435943603516,6.00793790817266 47.0435943603516,6.01783227920538 47.0319747924805,6.03404045104986 47.0242309570312,6.03889942169189 47.0251121520996,6.03889942169189 47.0251121520996,6.04090547561646 47.0197906494142,6.05356645584106 47.0155982971191,6.05356645584106 47.0155982971191,6.04766082763683 47.0097007751465,6.04513788223272 46.9955673217775,6.04513788223272 46.9955673217775,6.00760507583624 46.9874954223633,6.00760507583624 46.9874954223633,6.00158357620239 46.9909706115723,6.00158357620239 46.9909706115723,6.00439691543579 46.9975166320801,6.00134658813482 47.0002098083497,5.98214673995983 47.0028610229493,5.96365642547619 46.9923210144043,5.95462226867681 46.995189666748,5.94485712051403 46.9938468933105))0.0006POINT(6.000786215066966 47.0155204534531)
1403768POLYGON((2.7023921012879 41.8500976562501,2.70052790641796 41.8510704040527,2.70210909843456 41.8596229553223,2.70602488517761 41.8628845214844,2.71158409118652 41.8650016784668,2.71888589859003 41.8654556274414,2.72097802162165 41.8682594299316,2.72565698623652 41.8698081970215,2.72887802124023 41.8682327270509,2.73496794700623 41.8693962097168,2.7364199161529 41.8639564514161,2.74596190452587 41.8579978942872,2.74710392951971 41.8598403930665,2.75267910957336 41.857292175293,2.75157594680792 41.8513145446778,2.76330900192261 41.8505897521974,2.76376700401312 41.8495292663574,2.75723695755005 41.8344955444337,2.75914192199707 41.8319854736329,2.75829505920422 41.8281860351564,2.76068806648254 41.8169212341309,2.76340889930719 41.8150558471681,2.76815199851995 41.8166885375977,2.77078700065613 41.8143959045411,2.77390003204346 41.8141212463379,2.77442598342901 41.8122062683106,2.77993488311779 41.8115234375001,2.78473711013788 41.8071212768555,2.77681493759167 41.8010559082032,2.76094102859497 41.7975082397462,2.75532007217413 41.7887725830078,2.75439000129711 41.7915458679199,2.74613499641424 41.7959403991699,2.74263906478882 41.792911529541,2.74496603012091 41.7877349853516,2.73807907104498 41.7913932800293,2.73540306091309 41.7892036437989,2.73218703269958 41.7899475097656,2.73163104057312 41.7924804687501,2.72654604911816 41.7956085205079,2.72409200668346 41.7929039001465,2.72175097465515 41.7945785522462,2.72056102752697 41.7937812805177,2.72156596183783 41.7913208007813,2.71960592269903 41.7905006408692,2.71653604507458 41.7942543029785,2.71308994293224 41.7952690124512,2.70305991172791 41.7948875427247,2.70711708068853 41.7995185852052,2.72217488288885 41.8072738647461,2.72869801521307 41.8124313354492,2.73238801956177 41.8180351257324,2.73160099983215 41.8216133117677,2.734209060669 41.829231262207,2.73189806938177 41.8296356201172,2.7315669059754 41.832805633545,2.718092918396 41.8371849060059,2.7189769744873 41.8393936157227,2.71265292167664 41.8408241271973,2.71037793159496 41.8466529846191,2.7023921012879 41.8500976562501))0.0006POINT(2.737143294016556 41.82332083384199)