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
13466POLYGON((15.1203174591064 40.9734916687012,15.1293773651123 40.9749641418458,15.1293773651123 40.9749641418458,15.1360349655152 40.9761848449707,15.144476890564 40.9828834533692,15.1496391296388 40.9848480224609,15.1496391296388 40.9848480224609,15.1565999984742 40.9833908081055,15.1565999984742 40.9833908081055,15.161813735962 40.9809608459473,15.1646432876588 40.9808502197266,15.1715049743653 40.9912490844728,15.1715049743653 40.9912490844728,15.1764135360719 40.9822807312012,15.1785602569581 40.9800872802734,15.1813535690308 40.9800300598145,15.1857776641846 40.9641418457032,15.1842880249023 40.9538917541504,15.1842880249023 40.9538917541504,15.1748514175415 40.9482383728028,15.1630096435547 40.9454460144043,15.1534147262574 40.9468574523926,15.1548938751221 40.9492149353028,15.1546373367311 40.9512596130372,15.1418046951295 40.9619255065919,15.1304731369019 40.9705390930177,15.1223602294922 40.9736175537109,15.1203174591064 40.9734916687012))0.0006POINT(15.156579830028443 40.971285078260685)
24907POLYGON((2.33132791519165 48.4076919555664,2.32533431053156 48.4019432067872,2.33048391342163 48.392276763916,2.32721567153936 48.3784637451172,2.32721567153936 48.3784637451172,2.32174801826488 48.3730621337892,2.30872750282288 48.3691635131836,2.30872750282288 48.3691635131836,2.26728963851923 48.3718376159669,2.26728963851923 48.3718376159669,2.27349042892467 48.3921928405762,2.28859996795649 48.4017028808595,2.28870630264282 48.4118156433106,2.28870630264282 48.4118156433106,2.3083484172821 48.4164772033693,2.32483673095709 48.4249114990235,2.32483673095709 48.4249114990235,2.32773590087896 48.4127922058106,2.33234000205999 48.4120597839357,2.33234000205999 48.4120597839357,2.33132791519165 48.4076919555664))0.0006POINT(2.310265028476734 48.39673213958746)
34428POLYGON((5.03915977478033 48.4379386901856,5.0197105407716 48.4386329650878,5.02745580673229 48.430103302002,5.0139732360841 48.4159774780275,5.00895071029663 48.4030685424805,5.00895071029663 48.4030685424805,5.02145814895636 48.4014434814454,5.02721166610723 48.3967933654786,5.02721166610723 48.3967933654786,5.03123807907116 48.391872406006,5.03726053237909 48.3952407836913,5.03726053237909 48.3952407836913,5.0752296447755 48.4115562438965,5.0752296447755 48.4115562438965,5.07500505447393 48.4134063720703,5.07500505447393 48.4134063720703,5.05805110931402 48.4195785522462,5.04730176925665 48.4372520446778,5.04730176925665 48.4372520446778,5.03915977478033 48.4379386901856))0.0006POINT(5.0396297605414695 48.4131674515574)
55678POLYGON((5.3523378372193 45.0469589233399,5.35804700851452 45.0554847717286,5.35096168518078 45.0631942749024,5.35471010208136 45.0649795532228,5.35471010208136 45.0649795532228,5.38843679428112 45.0662803649902,5.40956306457514 45.0577239990236,5.4282283782959 45.0617065429689,5.44781160354626 45.0717926025391,5.44781160354626 45.0717926025391,5.43597459793091 45.0568733215333,5.42287302017223 45.053092956543,5.41229724884045 45.0459632873536,5.39797306060791 45.0449943542481,5.38541698455811 45.0550842285156,5.38481283187878 45.0489616394044,5.39726829528803 45.0383338928223,5.39726829528803 45.0383338928223,5.38409471511841 45.0359802246095,5.3697967529298 45.0439491271973,5.3523378372193 45.0469589233399))0.0006POINT(5.394019699096732 45.05432300567634)
1402310POLYGON((-5.84738397598267 41.8786659240724,-5.84546518325806 41.8788642883302,-5.81483411788935 41.9232711791992,-5.8170919418335 41.9299430847169,-5.80665206909174 41.9341545104982,-5.79633808135986 41.9371604919434,-5.79009103775024 41.9368553161621,-5.78970193862915 41.9395637512207,-5.78626203536987 41.9406318664552,-5.7825927734375 41.939998626709,-5.77631187438965 41.935359954834,-5.77652406692499 41.9321632385254,-5.77370023727417 41.9304313659668,-5.76689386367798 41.9295272827148,-5.76372623443604 41.9268188476564,-5.76067686080927 41.9195976257325,-5.7497940063476 41.9171943664552,-5.74520778656 41.9115066528321,-5.74371814727778 41.901165008545,-5.7495641708374 41.8992347717286,-5.74867486953735 41.8976058959962,-5.8234810829162 41.877914428711,-5.82781600952143 41.8734931945802,-5.83795309066767 41.8752059936523,-5.84738397598267 41.8786659240724))0.0006POINT(-5.788352310657477 41.91526365280158)
1396500POLYGON((-3.27456808090204 38.881031036377,-3.27500605583185 38.8749198913575,-3.28286004066467 38.867172241211,-3.29093909263611 38.8529396057129,-3.28973793983459 38.8382530212403,-3.29590606689447 38.8332824707032,-3.30242609977722 38.8328590393066,-3.30350708961487 38.8295593261719,-3.31640911102284 38.8242874145508,-3.31837296485901 38.8177337646484,-3.316731929779 38.8164405822753,-3.3174729347229 38.8146438598633,-3.32272601127619 38.8098373413087,-3.33768701553345 38.8048629760743,-3.34258008003235 38.8049392700195,-3.3445360660553 38.8065643310548,-3.35726404190063 38.8279495239259,-3.35986709594727 38.8389968872071,-3.34885907173157 38.8856010437012,-3.35033106803888 38.8987998962403,-3.36965394020069 38.9134635925294,-3.38446402549738 38.9347457885743,-3.3905849456786 38.9485664367677,-3.37319993972778 38.9784774780273,-3.35659408569336 38.9910202026368,-3.34953808784485 38.9911117553711,-3.32855010032654 38.9965629577637,-3.28760290145874 38.9999046325685,-3.26678991317749 38.9990158081056,-3.26248192787165 38.9799308776855,-3.26872897148132 38.9773330688477,-3.27026295661926 38.9713363647462,-3.28791499137878 38.951271057129,-3.29609489440918 38.931568145752,-3.28653788566584 38.9277725219727,-3.27638006210321 38.920597076416,-3.28560209274286 38.9068298339844,-3.27456808090204 38.881031036377))0.0006POINT(-3.3159126913225063 38.89405894923859)
1403908POLYGON((0.734206020832005 41.3707885742188,0.745217978954258 41.3787345886232,0.73879998922348 41.3839683532715,0.738530993461666 41.3859672546388,0.746994018554801 41.3996124267579,0.729155004024562 41.4147262573242,0.725071012973785 41.4165344238282,0.733920991420746 41.4229621887208,0.752614021301383 41.4197349548341,0.762610971927643 41.416561126709,0.764997005462646 41.4178886413574,0.762486994266567 41.4214668273927,0.764219999313411 41.4224433898925,0.756254017353172 41.4326553344726,0.765348017215786 41.4444427490236,0.785260975360984 41.4300117492676,0.787980020046177 41.4356231689454,0.792925000190849 41.4387550354004,0.795808017253989 41.4211006164552,0.798583984375057 41.4174346923828,0.803026020526943 41.4152488708496,0.805413007736263 41.4046897888185,0.829352974891719 41.4038047790527,0.830581009388084 41.4047698974611,0.835105001926536 41.4021530151367,0.835843980312347 41.3974380493165,0.840731978416443 41.3933410644532,0.8388450145722 41.390537261963,0.840517997741813 41.3828277587892,0.83818697929388 41.3818092346193,0.845661997795105 41.370288848877,0.844802975654602 41.3620109558105,0.832161009311676 41.3588104248048,0.819530010223389 41.3288497924806,0.812978982925529 41.327320098877,0.802048981189841 41.3304100036622,0.794782996177787 41.3287124633789,0.792070984840507 41.3313980102539,0.767830014228878 41.333869934082,0.754721999168453 41.3458976745606,0.740656018257255 41.3554763793946,0.73995399475109 41.3615531921388,0.734206020832005 41.3707885742188))0.0006POINT(0.7863283086391264 41.39053880600708)
16155POLYGON((8.96832561492914 45.6092109680177,8.97927474975586 45.615577697754,8.97844123840332 45.6164321899414,8.97696590423595 45.6157913208009,8.97512912750238 45.6189575195312,8.97512912750238 45.6189575195312,8.96636676788336 45.631046295166,8.95694160461431 45.626003265381,8.95562076568609 45.6263961791992,8.95454120635992 45.6302566528321,8.95757770538336 45.6344108581544,8.95757770538336 45.6344108581544,8.94093799591064 45.643581390381,8.94093799591064 45.643581390381,8.93754863739019 45.6423835754395,8.93754863739019 45.6423835754395,8.93006324768072 45.6363410949708,8.93349456787121 45.6273956298829,8.93349456787121 45.6273956298829,8.93775653839117 45.6244544982911,8.93775653839117 45.6244544982911,8.93863296508789 45.624797821045,8.94338321685797 45.6210098266602,8.94013881683361 45.6116371154786,8.94013881683361 45.6116371154786,8.9429874420166 45.6070213317871,8.94937133789057 45.6055908203125,8.95283889770519 45.6080131530762,8.95922183990484 45.6098365783691,8.96832561492914 45.6092109680177))0.0006POINT(8.951660123364718 45.62375746102175)
44258POLYGON((0.389889597892875 43.797378540039,0.381634414196071 43.8006629943849,0.367875844240189 43.7989807128907,0.350663363933677 43.7827911376954,0.350663363933677 43.7827911376954,0.353940278291702 43.7807273864746,0.352768123149872 43.7746391296387,0.352768123149872 43.7746391296387,0.355985015630779 43.7684860229493,0.366643458604869 43.7617759704591,0.366643458604869 43.7617759704591,0.382010191679115 43.7606964111329,0.382010191679115 43.7606964111329,0.386577516794205 43.766227722168,0.386577516794205 43.766227722168,0.389889597892875 43.797378540039))0.0006POINT(0.36844336390500604 43.775899759928436)
35929POLYGON((6.66252899169928 47.2308616638185,6.64326286315924 47.2288818359376,6.64326286315924 47.2288818359376,6.65208435058599 47.2128677368163,6.65208435058599 47.2128677368163,6.6612572669984 47.2156867980957,6.66658639907837 47.2214851379395,6.66252899169928 47.2308616638185))0.0006POINT(6.654438155038073 47.22164753505164)