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
27380POLYGON((-1.42487514019012 49.1455459594728,-1.40265619754791 49.1583366394043,-1.40265619754791 49.1583366394043,-1.393276810646 49.1696319580078,-1.393276810646 49.1696319580078,-1.40675890445704 49.1734580993653,-1.43039810657496 49.1701316833496,-1.43039810657496 49.1701316833496,-1.43883156776428 49.1592674255371,-1.43883156776428 49.1592674255371,-1.43586170673359 49.1572990417482,-1.44041454792023 49.1529159545899,-1.44041454792023 49.1529159545899,-1.42487514019012 49.1455459594728))0.0006POINT(-1.421434631714424 49.1612977247972)
42759POLYGON((6.36885690689093 49.4598197937011,6.37155675888067 49.4540596008302,6.37155675888067 49.4540596008302,6.36528730392462 49.436897277832,6.37090778350841 49.4268836975098,6.37090778350841 49.4268836975098,6.36289978027349 49.4240112304689,6.36172962188732 49.4143257141114,6.36172962188732 49.4143257141114,6.36023616790777 49.4146842956543,6.36023616790777 49.4146842956543,6.34995269775396 49.4227867126466,6.34862852096569 49.4473724365234,6.34862852096569 49.4473724365234,6.36251783370966 49.4498291015625,6.36439085006714 49.4594841003418,6.36885690689093 49.4598197937011))0.0006POINT(6.36250144243247 49.435467481613195)
56384POLYGON((4.43625164031994 45.5225410461426,4.42493677139282 45.5229721069336,4.42493677139282 45.5229721069336,4.41586589813227 45.5355339050294,4.41691493988031 45.5459861755371,4.41691493988031 45.5459861755371,4.42122840881348 45.5447616577148,4.42659330368053 45.5535163879396,4.41924619674683 45.56547164917,4.41924619674683 45.56547164917,4.42200374603283 45.5655097961426,4.42200374603283 45.5655097961426,4.44380187988293 45.5542068481446,4.44380187988293 45.5542068481446,4.44754123687744 45.5407943725587,4.4353404045105 45.5259475708008,4.43625164031994 45.5225410461426))0.0006POINT(4.427289247512849 45.545711755752606)
68142POLYGON((6.58929252624517 49.7766914367676,6.59236431121826 49.77689743042,6.59528827667236 49.7753410339355,6.59299755096441 49.7722358703614,6.60478830337524 49.7702598571778,6.60933303833002 49.7704811096193,6.61272335052496 49.7682380676269,6.61212778091442 49.7669792175294,6.61296558380138 49.7652702331544,6.61891222000122 49.7644271850587,6.61560440063488 49.7621994018556,6.60684823989868 49.7605628967286,6.60110712051397 49.7575607299805,6.60319423675543 49.7558479309081,6.5995707511903 49.7547950744629,6.57876014709484 49.7572898864747,6.57451391220104 49.7556571960449,6.5685391426087 49.7500457763672,6.56045532226562 49.7452316284181,6.55969381332403 49.7426757812501,6.55423498153692 49.7397651672364,6.55423498153692 49.7397651672364,6.55055904388433 49.7401924133302,6.54923295974743 49.7430419921876,6.54700946807861 49.7422447204591,6.54664182662975 49.7429237365723,6.53975248336803 49.7398910522462,6.53975248336803 49.7398910522462,6.5356850624085 49.7388191223146,6.54152679443354 49.743465423584,6.54008483886724 49.7442550659181,6.54159641265869 49.7456398010254,6.54436206817627 49.744312286377,6.54717254638678 49.7456283569337,6.54635572433483 49.7470932006837,6.54776477813721 49.7480430603027,6.54537725448603 49.7495002746583,6.54641103744518 49.7504463195802,6.54495906829834 49.7513504028321,6.54655933380138 49.7533454895021,6.54391765594482 49.7560195922852,6.53935050964367 49.7555885314942,6.53652906417847 49.7507247924805,6.53343057632446 49.7516975402832,6.53632068634033 49.7553977966309,6.53369903564464 49.7568321228027,6.53658676147467 49.76171875,6.53494787216187 49.7621917724611,6.53533744812023 49.7630271911622,6.53533744812023 49.7630271911622,6.52966785430908 49.7649116516114,6.52710962295538 49.7691154479981,6.52937746047974 49.773609161377,6.52705097198492 49.7759094238282,6.53393268585211 49.7793922424317,6.54300546646124 49.7814559936525,6.54818105697632 49.786907196045,6.55124759674084 49.7854003906251,6.55379629135138 49.7877235412598,6.56262302398687 49.7904663085937,6.56410455703741 49.792236328125,6.56410455703741 49.792236328125,6.56484365463263 49.7923889160156,6.56484365463263 49.7923889160156,6.56760501861578 49.7864303588868,6.56889009475714 49.7867088317872,6.56877803802485 49.7850303649902,6.57183170318615 49.784278869629,6.5768251419068 49.7792434692383,6.5867362022401 49.7742805480958,6.58929252624517 49.7766914367676))0.0006POINT(6.5612623555320155 49.76249487740656)
54766POLYGON((4.37621307373053 44.9128227233887,4.36668539047253 44.9102935791017,4.36668539047253 44.9102935791017,4.37159538269049 44.9043159484863,4.38378667831415 44.8987617492677,4.387529373169 44.8923034667969,4.37333297729504 44.8831596374512,4.37449884414684 44.8728446960449,4.37449884414684 44.8728446960449,4.39531803131109 44.8708114624025,4.39531803131109 44.8708114624025,4.42203235626221 44.8831138610841,4.42203235626221 44.8831138610841,4.39437723159796 44.9017715454102,4.39118003845215 44.9082336425781,4.39118003845215 44.9082336425781,4.37621307373053 44.9128227233887))0.0006POINT(4.386641502380425 44.89273309707647)
1401824POLYGON((-3.09709692001337 41.8810577392579,-3.09548306465149 41.8815879821777,-3.09173798561091 41.8759002685548,-3.08766603469849 41.8763465881349,-3.08206605911255 41.8801765441896,-3.07927107810974 41.8799438476563,-3.07538104057312 41.8831176757814,-3.06354498863215 41.8833656311036,-3.0585629940033 41.8913230895996,-3.0451710224151 41.8894844055176,-3.04515504837036 41.8858184814454,-3.04121208190918 41.8837280273439,-3.04631710052485 41.8773612976074,-3.04014110565186 41.8663215637207,-3.03918600082397 41.8612327575684,-3.04265308380121 41.8548545837402,-3.0431768894195 41.8476371765137,-3.04083800315857 41.8443984985353,-3.03943395614624 41.8349571228028,-3.03730297088623 41.8343353271484,-3.03696393966669 41.8287811279298,-3.03293704986572 41.8232269287111,-3.05213594436646 41.8135795593262,-3.05684208869928 41.8127670288087,-3.05593800544739 41.8117790222168,-3.06428408622736 41.8023414611818,-3.06883311271656 41.8006553649903,-3.07555198669428 41.792537689209,-3.0953528881073 41.7789382934571,-3.09789705276489 41.781307220459,-3.10153198242188 41.7811584472656,-3.10350608825678 41.7825889587402,-3.10015296936029 41.785472869873,-3.10318207740778 41.7901992797852,-3.10945892333979 41.7938690185548,-3.11305689811701 41.7939033508301,-3.11607289314264 41.7972221374513,-3.12044191360468 41.7969284057618,-3.12101197242731 41.7996292114257,-3.12409806251526 41.801483154297,-3.12353706359858 41.8047904968262,-3.12658190727234 41.8045043945313,-3.12751197814941 41.8056869506837,-3.12669801712036 41.8079719543457,-3.13613104820246 41.8119430541993,-3.13623404502857 41.8146171569824,-3.13411688804621 41.8156661987305,-3.13687896728516 41.8177986145021,-3.11352491378784 41.8472557067871,-3.11253094673157 41.8506889343262,-3.10759902000427 41.8545303344728,-3.10079288482666 41.856330871582,-3.09709191322327 41.861385345459,-3.09673595428467 41.8658828735352,-3.10109400749207 41.871307373047,-3.10116505622864 41.8773422241212,-3.09709692001337 41.8810577392579))0.0006POINT(-3.08605128526685 41.834803921835814)
68551POLYGON((11.5207633972167 51.962574005127,11.5205373764039 51.9635200500489,11.516788482666 51.9632377624512,11.5167703628541 51.9624099731445,11.5088396072388 51.9626731872559,11.5095777511597 51.9663925170898,11.5052909851075 51.967498779297,11.5056924819947 51.968532562256,11.4914026260377 51.9724388122559,11.493257522583 51.9760131835938,11.4819784164429 51.9784698486329,11.4815330505371 51.9814529418945,11.4752635955811 51.9820785522462,11.4752635955811 51.9820785522462,11.458909034729 51.9849472045899,11.458909034729 51.9849472045899,11.4588756561279 51.9882125854493,11.450496673584 51.9881362915039,11.4495143890381 51.991355895996,11.4469470977783 51.9912071228028,11.446834564209 52.0067863464356,11.446834564209 52.0067863464356,11.4469537734986 52.0076141357422,11.4484252929688 52.0075569152833,11.448603630066 52.0091209411622,11.4497547149658 52.0091133117676,11.4492349624634 52.0114364624023,11.4519357681275 52.0116119384766,11.4523029327393 52.0186805725099,11.4742679595948 52.0224151611329,11.4898147583008 52.0272254943848,11.4850301742554 52.0298500061035,11.4857969284059 52.0329093933106,11.4876422882081 52.034610748291,11.489206314087 52.0387649536133,11.4912748336793 52.0412940979004,11.494031906128 52.0493125915528,11.49857711792 52.0575942993164,11.4978542327881 52.0592384338379,11.4988555908204 52.0596160888673,11.4966220855714 52.0648994445801,11.5069398880005 52.0648384094239,11.516441345215 52.0668258666993,11.5171651840211 52.0684852600099,11.5209045410156 52.0673103332521,11.5209045410156 52.0673103332521,11.5251550674439 52.0651664733887,11.5273513793945 52.0678482055664,11.534785270691 52.0666503906251,11.5328292846681 52.0639686584473,11.5419120788575 52.0624656677246,11.5452060699463 52.0666694641114,11.5524482727051 52.0655059814454,11.5545234680175 52.0676078796387,11.5580835342407 52.067943572998,11.563536643982 52.0656700134277,11.5999288558961 52.0697364807129,11.6006078720093 52.0676345825196,11.6028432846069 52.0677223205568,11.6035461425782 52.0600357055664,11.6075124740601 52.0599060058594,11.6079835891724 52.0570869445801,11.6154088974 52.0569648742676,11.6159009933471 52.0508880615234,11.6235609054565 52.0514526367188,11.6239376068116 52.045467376709,11.6256036758423 52.0438079833984,11.6257677078248 52.0397186279297,11.6280965805054 52.0361480712892,11.632703781128 52.0362815856934,11.6370687484742 52.0301170349122,11.6370687484742 52.0301170349122,11.6198806762695 52.0297622680665,11.6249675750732 52.0214080810547,11.6042613983155 52.0217437744141,11.6036949157716 52.0197257995605,11.6014757156372 52.0192680358888,11.6030063629151 52.0162658691407,11.6039285659791 52.0110321044922,11.6032381057739 52.0089874267579,11.6047973632812 51.9862289428711,11.6030826568605 51.9762229919434,11.6032228469849 51.9694023132325,11.6032228469849 51.9694023132325,11.597357749939 51.9659767150879,11.5710744857789 51.9674034118653,11.5270872116089 51.9640045166016,11.5270872116089 51.9640045166016,11.5207633972167 51.962574005127))0.0006POINT(11.534813382408878 52.02082733674485)
63276POLYGON((12.9100904464722 53.5906982421875,12.9119653701782 53.5951042175294,12.9140062332154 53.5964736938477,12.9164409637451 53.5954132080079,12.9222393035889 53.5950546264648,12.9253511428832 53.5922966003418,12.9315462112427 53.5903854370118,12.9511680603028 53.589729309082,12.9582986831665 53.591033935547,12.9582986831665 53.591033935547,12.9649286270141 53.598472595215,12.965090751648 53.602684020996,12.9701471328735 53.6049766540528,12.9702844619751 53.6060600280762,12.9727201461793 53.6079635620118,12.9688854217529 53.6109962463379,12.9712381362915 53.6130447387695,12.9712381362915 53.6130447387695,12.9629983901979 53.6157264709474,12.9579000473023 53.6162071228028,12.9539794921876 53.6134338378907,12.9469070434571 53.6113357543946,12.9443655014039 53.6088676452638,12.9426784515382 53.6087036132813,12.933518409729 53.6108894348145,12.9324874877929 53.6124763488771,12.9299201965332 53.6136207580568,12.9255447387696 53.6137809753419,12.9255447387696 53.6137809753419,12.9216775894165 53.6143760681153,12.9190616607667 53.6083602905275,12.9079570770264 53.6016197204591,12.9061002731323 53.6013832092286,12.9061002731323 53.6013832092286,12.9062709808351 53.5987281799318,12.9022550582886 53.5982398986816,12.9035911560058 53.5967140197754,12.9050283432007 53.5970115661622,12.9100904464722 53.5906982421875))0.0006POINT(12.936521705828241 53.60371328655047)
38447POLYGON((0.546239495277462 49.7386360168458,0.539671719074249 49.7384948730469,0.539671719074249 49.7384948730469,0.553800761699677 49.7530975341797,0.56942176818859 49.7627601623535,0.56942176818859 49.7627601623535,0.576767385005951 49.7553367614746,0.576767385005951 49.7553367614746,0.584305286407528 49.7461471557618,0.584305286407528 49.7461471557618,0.575519025325775 49.7433280944825,0.56763863563549 49.7351913452148,0.56763863563549 49.7351913452148,0.560713112354392 49.7396545410157,0.546239495277462 49.7386360168458))0.0006POINT(0.5651344273772086 49.746469770159074)
33227POLYGON((4.82899475097662 49.8498191833497,4.80879878997808 49.8481788635254,4.80879878997808 49.8481788635254,4.80739879608166 49.8580856323243,4.79361248016363 49.8668518066407,4.79361248016363 49.8668518066407,4.79242038726812 49.8772468566895,4.78358221054077 49.8793907165528,4.78358221054077 49.8793907165528,4.78626966476452 49.8894157409668,4.77152013778698 49.8976249694824,4.78202295303345 49.9274940490724,4.77540206909191 49.9436111450196,4.77540206909191 49.9436111450196,4.78953981399542 49.9520912170411,4.79092407226574 49.9583969116212,4.79092407226574 49.9583969116212,4.80807876586914 49.9553070068359,4.81384706497204 49.9542694091798,4.81384706497204 49.9542694091798,4.8088898658753 49.916244506836,4.83418750762934 49.9108009338379,4.84710597991949 49.8956069946289,4.8417177200318 49.8896865844727,4.8322758674621 49.8862609863281,4.8380880355835 49.8769645690917,4.83687448501593 49.8629455566406,4.84280872344971 49.8494300842286,4.84280872344971 49.8494300842286,4.82899475097662 49.8498191833497))0.0006POINT(4.807701225938521 49.898132850383945)