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
68255POLYGON((7.90644979476934 50.666431427002,7.91614723205578 50.6614151000977,7.93192291259771 50.6609649658204,7.9363870620727 50.6601486206055,7.93818473815929 50.658618927002,7.93818473815929 50.658618927002,7.93960762023937 50.6592712402344,7.93856716156012 50.6609420776368,7.93856716156012 50.6609420776368,7.92999029159546 50.661849975586,7.9231004714967 50.6647872924804,7.92320251464838 50.668327331543,7.92552518844604 50.6716384887696,7.9212064743042 50.6736907958985,7.91531562805176 50.6728668212891,7.9098687171936 50.6701698303224,7.9098687171936 50.6701698303224,7.90644979476934 50.666431427002))0.0006POINT(7.926005672006086 50.66475610172053)
68061POLYGON((6.67334175109875 49.6520767211915,6.67128181457514 49.6512947082521,6.67128181457514 49.6512947082521,6.66695547103893 49.6497077941895,6.65184211730957 49.6370735168457,6.65184211730957 49.6370735168457,6.65511989593512 49.6378364562988,6.65511989593512 49.6378364562988,6.65949583053595 49.6377525329591,6.66347074508673 49.6357612609864,6.66614294052124 49.6327171325684,6.666175365448 49.6292037963868,6.67423343658453 49.627296447754,6.67810201644897 49.6310958862305,6.6837329864502 49.6335182189942,6.6837329864502 49.6335182189942,6.68766450881958 49.6335792541503,6.69284820556641 49.6360931396485,6.69511175155634 49.6383361816407,6.70443916320812 49.6416435241699,6.70443916320812 49.6416435241699,6.69962596893316 49.6410446166993,6.69567155838018 49.643840789795,6.68718624115002 49.6430854797364,6.67984199523937 49.6440277099609,6.67885494232178 49.6457862854003,6.67621231079107 49.6453437805176,6.67334175109875 49.6520767211915))0.0006POINT(6.6768061849806415 49.63961043181247)
14849POLYGON((11.7973976135254 42.6444702148438,11.8057289123535 42.6449775695801,11.8057289123535 42.6449775695801,11.8254470825195 42.639991760254,11.8254470825195 42.639991760254,11.8325700759888 42.6356239318848,11.8355522155762 42.6327476501465,11.8448801040651 42.6073837280273,11.838888168335 42.5960235595704,11.8390579223633 42.5943717956543,11.8390579223633 42.5943717956543,11.8278503417969 42.5965347290039,11.8167009353638 42.5971641540528,11.8116493225098 42.5956268310547,11.8040838241577 42.5959320068361,11.7932443618774 42.5990486145021,11.7840547561646 42.6065826416017,11.7830524444581 42.6159973144531,11.7847175598146 42.6309623718262,11.7818450927734 42.6356620788575,11.7818450927734 42.6356620788575,11.7875289916992 42.640251159668,11.7927999496461 42.6412200927735,11.7973976135254 42.6444702148438))0.0006POINT(11.810396899347742 42.620242409084206)
31336POLYGON((2.51526832580572 47.036418914795,2.4610586166383 47.0579872131348,2.4610586166383 47.0579872131348,2.47194957733154 47.0651588439941,2.46929001808178 47.0890579223634,2.46929001808178 47.0890579223634,2.49555945396435 47.0865478515626,2.49555945396435 47.0865478515626,2.50155162811285 47.0814323425294,2.51133489608759 47.0810432434082,2.53653526306158 47.0703430175782,2.55633950233459 47.0689506530763,2.55633950233459 47.0689506530763,2.55691361427307 47.0632362365722,2.55691361427307 47.0632362365722,2.55186390876776 47.057285308838,2.53759837150568 47.0539245605469,2.52423501014704 47.0395812988282,2.51526832580572 47.036418914795))0.0006POINT(2.5127032995224408 47.06759707132981)
19284POLYGON((11.7694625854493 42.8209266662598,11.75590133667 42.8281593322753,11.7511291503906 42.8325424194337,11.7503557205201 42.8346939086915,11.7503557205201 42.8346939086915,11.7486553192139 42.8346900939941,11.7356719970703 42.8412857055664,11.7327737808227 42.8485336303711,11.7277755737306 42.8550720214844,11.7198362350465 42.8612823486328,11.7131252288818 42.86483001709,11.7055997848511 42.8612327575684,11.6775455474854 42.8547172546387,11.672067642212 42.8565292358398,11.6699342727661 42.8598289489746,11.6647815704346 42.8641014099122,11.6626987457276 42.8646278381348,11.6569232940674 42.8652305603027,11.6530179977418 42.8629341125488,11.6371726989746 42.8594398498535,11.6371726989746 42.8594398498535,11.6381216049194 42.8503036499024,11.6350479125978 42.8410377502442,11.6331796646119 42.8281745910645,11.6365804672242 42.8192481994629,11.6327266693116 42.8082885742188,11.6245079040527 42.8062324523925,11.626534461975 42.7989196777344,11.626534461975 42.7989196777344,11.631018638611 42.7974319458008,11.6353979110718 42.7997703552246,11.6422958374025 42.8006744384766,11.6625356674194 42.7890663146972,11.6785430908204 42.7902755737306,11.6950197219849 42.7964172363281,11.6982374191285 42.7990722656249,11.7267055511475 42.7940559387207,11.7389974594117 42.7908096313477,11.7469730377197 42.7867431640625,11.7469730377197 42.7867431640625,11.750922203064 42.7914466857911,11.7543115615846 42.8032188415527,11.7594118118286 42.8092613220216,11.7653951644897 42.8127059936524,11.7695198059082 42.8163909912111,11.7694625854493 42.8209266662598))0.0006POINT(11.694387732611798 42.82622222900393)
48530POLYGON((-1.09440624713898 47.8298873901368,-1.1064121723175 47.8243598937989,-1.1311639547348 47.8287620544434,-1.1311639547348 47.8287620544434,-1.13547897338856 47.8226432800294,-1.12958753108973 47.8172607421876,-1.09524035453791 47.8105010986328,-1.07290446758265 47.8022041320801,-1.07290446758265 47.8022041320801,-1.0488263368606 47.7995605468751,-1.04591023921955 47.7969207763672,-1.04591023921955 47.7969207763672,-1.0594651699065 47.8155670166017,-1.0594651699065 47.8155670166017,-1.06594550609583 47.8210487365723,-1.09440624713898 47.8298873901368))0.0006POINT(-1.086318985621074 47.81414464314785)
1396850POLYGON((-2.09551405906672 39.7556037902833,-2.12803792953491 39.7378883361816,-2.13459897041315 39.7209243774415,-2.13605999946594 39.7112693786622,-2.14774298667902 39.7146682739259,-2.17091488838196 39.7251281738282,-2.18466711044312 39.7373428344728,-2.18780398368835 39.7457008361816,-2.1861720085144 39.7484283447267,-2.19830107688904 39.7583236694337,-2.20401310920715 39.7610778808594,-2.20670008659357 39.7609214782716,-2.20968103408813 39.7666549682618,-2.20606589317322 39.7714500427246,-2.19049096107483 39.7842979431153,-2.18563103675842 39.7923126220704,-2.18001604080195 39.7970123291016,-2.17470288276672 39.7988128662109,-2.19991898536682 39.8201179504395,-2.20165801048273 39.8224067687988,-2.20149207115173 39.8275756835939,-2.19405102729797 39.8334808349611,-2.1811261177063 39.8403472900392,-2.14740395545959 39.873748779297,-2.14577198028564 39.8770256042481,-2.13041710853577 39.8761596679688,-2.11630892753601 39.8647994995118,-2.10770606994629 39.8636894226075,-2.10570693016047 39.8618202209474,-2.10965895652771 39.8617782592773,-2.10945105552673 39.8606758117677,-2.09891295433044 39.8539466857911,-2.0990269184112 39.8522872924805,-2.09554600715632 39.8522071838379,-2.09214806556696 39.8501358032227,-2.09268593788147 39.8491668701171,-2.09975600242615 39.8493194580079,-2.09830904006952 39.8402824401857,-2.0994439125061 39.8320999145508,-2.1066370010376 39.7981796264649,-2.10958099365234 39.7972030639649,-2.10726094245911 39.7932586669923,-2.1082088947295 39.779640197754,-2.09907197952265 39.765438079834,-2.09551405906672 39.7556037902833))0.0006POINT(-2.145099406892584 39.80419566414578)
73892MULTIPOLYGON(((16.7499828338622 42.9765281677247,16.7531414031983 42.970817565918,16.7600193023682 42.9626197814943,16.7608566284181 42.9568519592286,16.7590484619141 42.953384399414,16.7533512115479 42.9503211975098,16.7515583038331 42.9450225830078,16.7457027435303 42.939754486084,16.7422122955323 42.9343109130859,16.7372436523439 42.9330482482911,16.729112625122 42.933521270752,16.7053890228271 42.941577911377,16.6922454833984 42.9424018859864,16.6881217956544 42.9412956237793,16.6858406066896 42.9389686584474,16.6840381622316 42.9284553527833,16.6781845092773 42.9281349182129,16.6745223999023 42.9262504577637,16.6745223999023 42.9262504577637,16.6737499237061 42.9268074035645,16.6731948852539 42.9248695373535,16.6720829010009 42.9243049621582,16.6684722900391 42.9259719848633,16.6676387786865 42.9279174804688,16.6659717559814 42.9270820617676,16.665138244629 42.9287490844728,16.6640281677247 42.9287490844728,16.6640281677247 42.9262504577637,16.6657638549805 42.9251518249512,16.665693283081 42.9223594665528,16.6671142578125 42.9195823669434,16.6662502288818 42.9165267944337,16.6645812988281 42.9145851135254,16.6598606109619 42.9156951904297,16.6598606109619 42.9165267944337,16.661527633667 42.9168052673341,16.6601390838624 42.91902923584,16.6587505340577 42.91902923584,16.6579189300537 42.9173622131348,16.65625 42.9170837402345,16.651252746582 42.9201393127441,16.650972366333 42.9215087890626,16.6418075561524 42.9234733581544,16.6384716033936 42.9259719848633,16.6390991210938 42.9271240234375,16.6409721374512 42.927360534668,16.6412830352784 42.9284629821778,16.6437492370605 42.9290275573732,16.6381931304932 42.9320831298828,16.6395854949951 42.9329223632814,16.6395854949951 42.9348602294923,16.637638092041 42.9359741210939,16.6384372711182 42.9373779296875,16.6412506103516 42.937084197998,16.6429176330568 42.9356956481935,16.6428833007812 42.9381942749024,16.6459712982178 42.9381942749024,16.6470832824708 42.9398612976075,16.6506938934327 42.9393043518068,16.6526393890381 42.9412841796876,16.6548614501953 42.9412498474122,16.6554145812989 42.9429168701172,16.6584720611573 42.9437484741212,16.665138244629 42.943473815918,16.6676387786865 42.9423599243164,16.6693000793457 42.9437484741212,16.6643066406251 42.9464721679689,16.6635131835938 42.948486328125,16.6609725952148 42.9490814208985,16.6604175567628 42.9531936645507,16.6634712219239 42.9543037414551,16.6655273437501 42.9543037414551,16.6676387786865 42.9529151916504,16.6716938018798 42.9534797668456,16.6716938018798 42.9534797668456,16.6745834350587 42.9554176330566,16.6784744262696 42.9551391601562,16.6795825958252 42.9568061828614,16.6840286254884 42.9562492370606,16.6870841979981 42.9576377868653,16.6937503814698 42.957359313965,16.6956787109374 42.9595832824706,16.7001380920411 42.9604148864747,16.705135345459 42.9600982666016,16.7064819335938 42.9586791992189,16.7099018096924 42.9578857421876,16.7095832824708 42.9593048095703,16.7126388549806 42.9595832824706,16.7140274047852 42.9618072509766,16.7170734405519 42.9626388549805,16.7143058776855 42.9676399230957,16.713472366333 42.9670829772949,16.7149047851564 42.9656982421876,16.7151393890381 42.9629173278809,16.7070846557618 42.9615287780762,16.7023601531982 42.9637489318849,16.7028808593751 42.9659729003906,16.7040271759034 42.9665260314942,16.7040271759034 42.9676399230957,16.7026977539064 42.968505859375,16.6956958770753 42.9659729003906,16.6920814514161 42.966251373291,16.6898803710938 42.9681930541993,16.6862506866455 42.9670829772949,16.6840286254884 42.9687500000001,16.6806964874268 42.9676399230957,16.6765270233155 42.9687500000001,16.6743049621583 42.9679183959961,16.6726398468017 42.9698600769044,16.6734714508057 42.9706954956056,16.6768054962159 42.9701385498048,16.6773738861084 42.9729461669922,16.6717834472657 42.9740867614746,16.6693077087402 42.9731941223145,16.6693077087402 42.979305267334,16.6679172515869 42.979305267334,16.6670856475831 42.9768066406251,16.6645812988281 42.9756927490234,16.6637496948243 42.9768066406251,16.6645812988281 42.9795837402344,16.6640281677247 42.9812507629395,16.6590270996095 42.9809722900391,16.6576385498047 42.9829177856446,16.6549072265625 42.9843139648438,16.6540279388429 42.9840278625488,16.6534748077393 42.9804153442384,16.6526393890381 42.9798622131348,16.6506958007812 42.9813232421876,16.6498603820801 42.9809722900391,16.6490268707275 42.9773597717285,16.6470832824708 42.9759712219239,16.6473617553712 42.9745826721192,16.6445827484131 42.9737510681152,16.6437015533447 42.9784736633301,16.6406955718995 42.9801406860352,16.6398620605469 42.9826393127443,16.6368045806885 42.9804153442384,16.6298618316651 42.9812507629395,16.6276855468751 42.9829101562501,16.6273612976074 42.9854164123536,16.6312503814697 42.985694885254,16.6318054199219 42.9876403808594,16.6334838867189 42.9890747070312,16.6354980468751 42.9899291992188,16.6395854949951 42.9893417358399,16.6401386260987 42.9906959533691,16.6448612213135 42.989860534668,16.6473617553712 42.9904174804688,16.6490631103516 42.9887390136719,16.6479167938234 42.9868049621583,16.6484718322753 42.985694885254,16.6511230468751 42.9871215820314,16.6540279388429 42.9865112304689,16.6570835113526 42.9904174804688,16.6609725952148 42.9895820617676,16.6601390838624 42.9906959533691,16.6606941223145 42.9926376342775,16.6640281677247 42.9920845031739,16.665693283081 42.9931945800782,16.6671142578125 42.9921264648438,16.6662502288818 42.9887504577638,16.6684722900391 42.9879150390625,16.6693077087402 42.9899291992188,16.6715145111085 42.9895820617676,16.6723613739013 42.9929161071778,16.6743049621583 42.9918060302735,16.6759700775148 42.9934730529786,16.6784744262696 42.9923629760743,16.6795825958252 42.9934730529786,16.6829166412355 42.993751525879,16.6843261718751 42.992919921875,16.68430519104 42.9909706115723,16.6859722137451 42.9906959533691,16.6876411437988 42.9923629760743,16.69069480896 42.9912490844727,16.6923637390137 42.9943046569824,16.6940917968751 42.9943237304688,16.6951389312745 42.9923629760743,16.6968078613282 42.9931945800782,16.6984729766846 42.9926376342775,16.697639465332 42.9881935119628,16.6998615264893 42.9876403808594,16.70068359375 42.9904785156251,16.7031936645508 42.9909706115723,16.7068042755127 42.9862518310547,16.707914352417 42.9893074035646,16.7101383209229 42.9884719848632,16.7115287780762 42.9909706115723,16.7126388549806 42.9909706115723,16.7154159545899 42.9881935119628,16.7190284729005 42.9876403808594,16.7215251922609 42.9879150390625,16.7229003906251 42.9899291992188,16.7254161834717 42.989860534668,16.7268047332764 42.9879150390625,16.730972290039 42.9859733581544,16.7301387786866 42.9837493896484,16.7312507629394 42.9823608398439,16.7343044281007 42.9807281494141,16.7404174804688 42.9806938171388,16.7418060302736 42.9784736633301,16.7454166412354 42.979305267334,16.7499828338622 42.9765281677247)),((16.6181945800782 42.9897117614746,16.620138168335 42.9854164123536,16.6231937408448 42.9854164123536,16.6240272521974 42.9823608398439,16.6184730529786 42.9809722900391,16.6182117462159 42.9829483032226,16.6168079376221 42.983196258545,16.614860534668 42.9809722900391,16.613473892212 42.9806938171388,16.6121215820314 42.9821166992188,16.6079158782959 42.9818038940429,16.6065273284913 42.983196258545,16.6076393127443 42.9851379394532,16.6104164123536 42.9848594665528,16.6109714508057 42.9868049621583,16.6131954193116 42.9865264892579,16.6137504577636 42.9879150390625,16.6162700653077 42.9865112304689,16.6165275573731 42.9893074035646,16.6181945800782 42.9897117614746)),((16.6815280914307 42.9622802734376,16.6856708526611 42.9617576599122,16.6856937408448 42.959861755371,16.6848602294922 42.9601402282716,16.6831951141359 42.9581947326661,16.6812496185303 42.9581947326661,16.6798610687256 42.9584732055665,16.6779174804689 42.9613037109376,16.6768054962159 42.9615287780762,16.6773605346679 42.9623603820801,16.6815280914307 42.9622802734376)))0.0006POINT(16.677166479537128 42.96356019481581)
22310POLYGON((-0.35554376244545 44.9826583862305,-0.364054739475193 44.9934959411622,-0.361758410930634 44.9962844848634,-0.361758410930634 44.9962844848634,-0.3929782807827 44.9990158081054,-0.3929782807827 44.9990158081054,-0.405520051717758 44.9754981994629,-0.405520051717758 44.9754981994629,-0.383602708578053 44.969352722168,-0.383602708578053 44.969352722168,-0.380725592374745 44.9719543457031,-0.362286239862385 44.970386505127,-0.362286239862385 44.970386505127,-0.362297713756561 44.9794616699219,-0.35554376244545 44.9826583862305))0.0006POINT(-0.3767795136996436 44.98204612731936)
50165POLYGON((3.82479453086853 49.8532638549805,3.81966018676758 49.8580322265625,3.8151421546936 49.8579292297363,3.8151421546936 49.8579292297363,3.81326484680187 49.8639526367188,3.80611658096325 49.8680686950684,3.79795026779175 49.8649330139161,3.79795026779175 49.8649330139161,3.80036950111389 49.8800659179689,3.81128120422369 49.8869361877441,3.81128120422369 49.8869361877441,3.81660771369945 49.8870010375977,3.82747697830195 49.8798828125001,3.84854626655579 49.881103515625,3.84854626655579 49.881103515625,3.87537312507635 49.8847961425782,3.87537312507635 49.8847961425782,3.85325860977184 49.8752326965333,3.84407377243048 49.8628807067871,3.82479453086853 49.8532638549805))0.0006POINT(3.826432039863221 49.872619829679834)