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 |
---|---|---|---|
1399344 | POLYGON((-3.5888979434967 41.9676628112794,-3.58417797088617 41.9662132263185,-3.58241796493525 41.9678573608398,-3.57983803749084 41.9667739868164,-3.57284998893726 41.9693489074707,-3.55031204223633 41.9715194702148,-3.53426909446716 41.9769287109376,-3.53204894065851 41.9626541137696,-3.51096010208124 41.9602279663085,-3.50153589248657 41.961799621582,-3.50419402122492 41.9589958190918,-3.50280094146723 41.9522857666016,-3.50955200195301 41.948642730713,-3.51272010803217 41.9449005126954,-3.51971006393427 41.9424743652345,-3.52083110809326 41.930633544922,-3.52574992179871 41.9330596923829,-3.53137397766113 41.9394035339355,-3.5375599861145 41.9405097961426,-3.54569005966187 41.9375228881835,-3.55256795883173 41.9322586059571,-3.56354689598083 41.9313240051269,-3.56812810897821 41.9283447265626,-3.57294607162476 41.9288902282715,-3.56875491142273 41.9323348999025,-3.56672596931458 41.9416007995607,-3.57220101356506 41.9412689208985,-3.58953309059143 41.9437217712402,-3.5888979434967 41.9676628112794)) | 0.0006 | POINT(-3.546496220997373 41.94925567082) |
20455 | POLYGON((7.28116989135742 48.5074768066407,7.28164863586426 48.5088577270509,7.28164863586426 48.5088577270509,7.2821445465089 48.5122718811035,7.30192184448242 48.523105621338,7.30192184448242 48.523105621338,7.3475804328919 48.5212287902832,7.3475804328919 48.5212287902832,7.33431148529058 48.5051002502442,7.33431148529058 48.5051002502442,7.33312416076654 48.5084495544434,7.3229484558106 48.5096855163575,7.30701065063488 48.5010299682618,7.29201650619501 48.4992027282715,7.29201650619501 48.4992027282715,7.28116989135742 48.5074768066407)) | 0.0006 | POINT(7.309423700968447 48.51026026407884) |
49015 | POLYGON((0.481847673654613 48.0716667175293,0.459794729948101 48.0746421813965,0.459794729948101 48.0746421813965,0.453421384096089 48.0661048889161,0.455378949642238 48.0597534179688,0.442220658063945 48.0557861328125,0.442220658063945 48.0557861328125,0.442520678043479 48.0429077148439,0.431082725525016 48.0373497009277,0.431082725525016 48.0373497009277,0.453934997320232 48.025562286377,0.469236671924591 48.0334129333497,0.469236671924591 48.0334129333497,0.474733889102993 48.037769317627,0.48327606916439 48.0365562438964,0.48327606916439 48.0365562438964,0.496202111244315 48.0459632873535,0.501641154289246 48.0581703186035,0.501641154289246 48.0581703186035,0.504011750221252 48.0634346008302,0.491686254739761 48.0647544860841,0.491686254739761 48.0647544860841,0.481847673654613 48.0716667175293)) | 0.0006 | POINT(0.46908763457433234 48.05156846479938) |
25642 | POLYGON((2.74270582199108 48.8472099304199,2.73207640647882 48.8526649475099,2.73207640647882 48.8526649475099,2.72754216194153 48.8597602844239,2.72754216194153 48.8597602844239,2.72966074943537 48.8690986633302,2.72966074943537 48.8690986633302,2.74235057830805 48.8639564514161,2.75211143493664 48.8637237548828,2.75235056877148 48.8506736755371,2.75235056877148 48.8506736755371,2.74270582199108 48.8472099304199)) | 0.0006 | POINT(2.7382206916809246 48.85811684348373) |
54295 | POLYGON((5.00124406814587 45.9277267456055,5.01157808303839 45.9346427917482,5.01157808303839 45.9346427917482,5.03816986083984 45.9310760498048,5.04114961624151 45.928581237793,5.04114961624151 45.928581237793,5.04046201705933 45.9253425598145,5.05505228042603 45.9175033569337,5.0577917098999 45.9079208374023,5.0577917098999 45.9079208374023,5.04299259185791 45.9069175720215,5.01990461349499 45.9004783630372,5.02123546600353 45.8899803161622,5.03336477279663 45.884132385254,5.06776142120367 45.8802757263185,5.06776142120367 45.8802757263185,5.07369565963751 45.872428894043,5.07369565963751 45.872428894043,5.06194925308233 45.8665962219238,5.05542421340948 45.8575935363771,5.06103372573858 45.8521041870118,5.0620255470277 45.8386344909669,5.0620255470277 45.8386344909669,5.04180097579962 45.8531646728516,5.01290321350098 45.857852935791,4.98931741714483 45.8705406188966,4.98931741714483 45.8705406188966,4.99063444137585 45.8841629028321,4.97404432296759 45.8905601501466,4.97404432296759 45.8905601501466,4.96415472030651 45.9008216857911,4.96660661697388 45.9066162109376,4.96331405639648 45.9087257385253,4.96331405639648 45.9087257385253,4.97639751434338 45.9133796691895,4.98497533798212 45.9100418090821,4.99438428878784 45.9118843078614,5.00124406814587 45.9277267456055)) | 0.0006 | POINT(5.022812044298374 45.89356747189088) |
53141 | POLYGON((6.63229990005499 44.4469146728516,6.60309171676647 44.4479293823243,6.58886432647711 44.4455528259278,6.58886432647711 44.4455528259278,6.58815717697138 44.438575744629,6.58029842376715 44.4298744201661,6.58586025238043 44.4202117919922,6.58287239074713 44.3956756591798,6.58534383773798 44.3888626098633,6.58534383773798 44.3888626098633,6.60579490661621 44.3834266662598,6.61875581741344 44.385280609131,6.61875581741344 44.385280609131,6.63284254074097 44.3870544433594,6.63795518875116 44.403636932373,6.65219926834112 44.4128150939941,6.65219926834112 44.4128150939941,6.65317249298107 44.4364471435547,6.65317249298107 44.4364471435547,6.64102220535278 44.4399566650392,6.63229990005499 44.4469146728516)) | 0.0006 | POINT(6.614343309402505 44.41655864715581) |
1404886 | POLYGON((-3.94529509544373 40.4549980163575,-3.93923902511591 40.4606246948243,-3.93966102600098 40.4653930664064,-3.93692398071289 40.4679946899415,-3.93843698501587 40.4741973876954,-3.93631505966187 40.4785652160645,-3.93666410446161 40.4925003051759,-3.93513894081104 40.4982872009278,-3.93324494361872 40.4995384216309,-3.92633509635925 40.4991035461425,-3.91041493415821 40.5016899108887,-3.90590310096741 40.4953384399415,-3.89508104324341 40.4907379150391,-3.89204311370844 40.4877891540528,-3.83665299415583 40.4750328063966,-3.83825993537903 40.4676513671876,-3.83425807952869 40.464427947998,-3.84652900695795 40.4582481384278,-3.84940290451044 40.4493751525879,-3.85408401489252 40.4467277526856,-3.85307002067566 40.4456596374513,-3.86261010169983 40.4440040588379,-3.88129210472096 40.4451446533204,-3.89894008636475 40.456340789795,-3.90496611595154 40.4509963989258,-3.90882706642145 40.4426307678224,-3.92469191551208 40.4421920776367,-3.93342089653015 40.4500198364258,-3.94529509544373 40.4549980163575)) | 0.0006 | POINT(-3.8999179175921497 40.46804319109241) |
30612 | POLYGON((-4.02447128295898 48.6866493225098,-4.01218509674072 48.6961975097657,-4.0074582099914 48.6964492797852,-4.0074582099914 48.6964492797852,-3.99783515930176 48.6955871582032,-3.9875750541687 48.7022857666017,-3.97362947463989 48.7038879394531,-3.97350144386286 48.7015266418457,-3.97350144386286 48.7015266418457,-3.97569394111622 48.6987495422364,-3.97152805328363 48.6948623657228,-3.96458292007441 48.693473815918,-3.96569299697876 48.6906929016114,-3.96430492401117 48.689582824707,-3.96124911308289 48.6887512207032,-3.95902705192566 48.6898612976074,-3.95763897895807 48.6887512207032,-3.95819497108454 48.6873626708985,-3.96152710914612 48.6865272521974,-3.96097302436823 48.6851387023926,-3.95874905586243 48.6843070983887,-3.95902705192566 48.6829185485841,-3.96013903617859 48.6829185485841,-3.96013903617859 48.6843070983887,-3.96263909339905 48.6856956481934,-3.96124911308289 48.6873626708985,-3.96541810035694 48.6881942749025,-3.96791791915894 48.6901397705078,-3.97069406509394 48.6865272521974,-3.96986198425293 48.6851387023926,-3.97069406509394 48.6837501525879,-3.96819400787348 48.6809730529786,-3.96819400787348 48.6798629760742,-3.96874999999989 48.6754150390626,-3.97097206115717 48.6745834350587,-3.9695839881897 48.6737518310547,-3.96652793884277 48.6743049621583,-3.96652793884277 48.6776390075684,-3.96541810035694 48.6781959533691,-3.96347093582153 48.6754150390626,-3.96097302436823 48.6743049621583,-3.95902705192566 48.674861907959,-3.95902705192566 48.6737518310547,-3.9565269947052 48.6734733581543,-3.95541691780085 48.6781959533691,-3.95375108718866 48.6770820617676,-3.9540290832519 48.6762504577638,-3.95208191871643 48.6754150390626,-3.95291709899902 48.6734733581543,-3.94986009597773 48.6734733581543,-3.94986009597773 48.670970916748,-3.95069408416742 48.6701393127443,-3.95347309112549 48.670970916748,-3.95430493354792 48.6693038940431,-3.95430493354792 48.6679153442383,-3.95263910293579 48.6670837402344,-3.9512510299682 48.6640281677247,-3.9512510299682 48.6573600769044,-3.95375108718866 48.6554183959961,-3.95569491386408 48.6509590148926,-3.95569491386408 48.6509590148926,-3.95721554756165 48.6478538513185,-3.97134280204762 48.6450691223145,-3.99755477905273 48.6524391174316,-4.00653934478748 48.6512413024903,-4.00653934478748 48.6512413024903,-4.00666189193726 48.6546936035156,-4.0255446434021 48.66019821167,-4.01939678192139 48.6769142150879,-4.02447128295898 48.6866493225098)) | 0.0006 | POINT(-3.9695582700811944 48.678126901820114) |
66481 | MULTIPOLYGON(((9.34236431121826 50.0834541320801,9.34891700744635 50.0808143615724,9.353759765625 50.0737075805663,9.3613538742066 50.068977355957,9.35589981079113 50.063274383545,9.34728050231939 50.0647506713867,9.34436893463146 50.064353942871,9.34301376342773 50.0620384216309,9.34346961975092 50.0599441528321,9.34155178070068 50.0589447021485,9.34026527404785 50.0612525939941,9.34158515930176 50.063850402832,9.33633327484125 50.0648307800292,9.32634830474854 50.0700645446778,9.32202625274658 50.0712699890138,9.32202625274658 50.0712699890138,9.32797527313238 50.0766334533693,9.33129405975336 50.08207321167,9.33844089508068 50.0866012573243,9.33844089508068 50.0866012573243,9.34236431121826 50.0834541320801)),((9.34012985229492 50.0428047180176,9.34057331085211 50.0424041748048,9.34057331085211 50.0424041748048,9.3457231521607 50.0449295043945,9.34744930267334 50.0480728149415,9.34759902954107 50.0493698120118,9.3442754745484 50.0544357299804,9.34510707855219 50.056423187256,9.34811687469482 50.0562591552735,9.34977340698254 50.0576705932618,9.34905815124523 50.0583381652833,9.34614753723139 50.0579185485841,9.3440980911256 50.0594291687012,9.34200859069836 50.058536529541,9.34284114837646 50.0564918518066,9.34006881713879 50.0555801391601,9.34035587310802 50.0541343688966,9.34382152557384 50.0535507202148,9.34666061401373 50.0494575500489,9.34438419342052 50.0448455810548,9.34012985229492 50.0428047180176))) | 0.0006 | POINT(9.34062009576108 50.069447404678684) |
47051 | POLYGON((2.54189682006847 50.2624130249024,2.55186057090765 50.2634735107423,2.5541987419129 50.2604293823242,2.55528163909923 50.2503662109375,2.546147108078 50.2383117675781,2.54814910888672 50.2351646423339,2.54814910888672 50.2351646423339,2.54332113265991 50.2318420410156,2.54332113265991 50.2318420410156,2.52811694145203 50.2350196838379,2.52811694145203 50.2350196838379,2.51808571815502 50.2504959106446,2.51808571815502 50.2504959106446,2.54189682006847 50.2624130249024)) | 0.0006 | POINT(2.5403638986441237 50.244618342472975) |