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
33070POLYGON((1.95596265792841 47.9023971557617,1.94175434112549 47.8926658630372,1.93827879428869 47.8790817260743,1.95762026309978 47.8677330017091,1.95762026309978 47.8677330017091,1.95564651489258 47.8647117614746,1.93685972690582 47.8637504577636,1.93685972690582 47.8637504577636,1.93183231353771 47.8643341064454,1.92622399330139 47.8737945556641,1.91286158561707 47.8841514587403,1.91202545166016 47.890998840332,1.91869723796844 47.895896911621,1.93798637390142 47.9004020690918,1.93798637390142 47.9004020690918,1.95596265792841 47.9023971557617))0.0006POINT(1.9372143745422654 47.880786895751974)
13823POLYGON((14.6806030273438 40.6694068908693,14.6868343353271 40.6701622009278,14.6925992965699 40.6693725585938,14.7098350524902 40.6643981933594,14.7140274047852 40.6618041992188,14.7140274047852 40.6618041992188,14.7129173278809 40.6604156494141,14.7129173278809 40.6576385498048,14.7093048095704 40.6559715270997,14.708194732666 40.6531944274903,14.7051391601564 40.6501388549805,14.7043066024781 40.6473770141603,14.7043066024781 40.6473770141603,14.6961793899536 40.6469879150392,14.6924028396607 40.6477737426757,14.682680130005 40.65291595459,14.6753816604614 40.6628608703614,14.6806030273438 40.6694068908693))0.0006POINT(14.700097476734879 40.65762351540965)
69874POLYGON((9.41466236114513 54.5365028381348,9.40845870971685 54.5387039184571,9.40548610687262 54.5427703857423,9.39690208435064 54.5409622192383,9.3893775939942 54.5423431396485,9.38843727111828 54.5440750122071,9.38369941711437 54.5433540344238,9.38001728057861 54.5407066345215,9.36818790435802 54.5390014648437,9.3645477294923 54.5407028198242,9.35755825042725 54.5462417602538,9.35426807403564 54.5474510192872,9.36149883270269 54.551368713379,9.3659029006958 54.5553398132324,9.37629890441895 54.5576248168946,9.37743186950689 54.560962677002,9.38099288940435 54.5624237060548,9.39045810699469 54.5631713867189,9.3999719619751 54.5680465698242,9.40591621398931 54.5675888061525,9.40591621398931 54.5675888061525,9.41057014465343 54.5674476623536,9.41717338562023 54.5708808898926,9.42188549041742 54.5720863342285,9.42544651031506 54.5718307495117,9.42708778381353 54.5704612731934,9.42729759216303 54.5688552856446,9.43493080139166 54.5669631958008,9.43453788757319 54.5660018920899,9.43824863433832 54.5646209716797,9.44701671600353 54.5636444091797,9.44701671600353 54.5636444091797,9.44569110870367 54.5609931945802,9.45407295227062 54.5593681335449,9.45409393310547 54.5572586059571,9.45530700683599 54.5569190979004,9.45382881164556 54.5485038757324,9.45211410522461 54.5485343933106,9.44747066497808 54.5452079772949,9.4464902877807 54.5423736572267,9.44018650054932 54.541316986084,9.43892478942865 54.54301071167,9.43719387054455 54.5430603027344,9.43677997589123 54.5447959899903,9.43324851989746 54.5421562194824,9.42922401428228 54.542552947998,9.42689514160162 54.541202545166,9.42689514160162 54.541202545166,9.41466236114513 54.5365028381348))0.0006POINT(9.414283732573237 54.553371349970526)
12407POLYGON((13.3792638778687 41.9127731323242,13.3676843643189 41.9209136962892,13.3667392730713 41.9244117736818,13.3652811050414 41.9257431030273,13.3574714660645 41.9267272949219,13.3574714660645 41.9267272949219,13.3859310150147 41.9452209472656,13.4101476669312 41.9537353515624,13.4244060516357 41.9567794799806,13.428490638733 41.9545364379883,13.4368886947632 41.9535102844238,13.4368886947632 41.9535102844238,13.4439926147462 41.9526214599609,13.4439926147462 41.9526214599609,13.4208526611329 41.9365005493165,13.4056510925293 41.9172515869142,13.3792638778687 41.9127731323242))0.0006POINT(13.401947081089057 41.9383490085602)
45692POLYGON((1.98594939708721 44.7660789489746,1.98687469959259 44.7729492187501,2.00092244148249 44.7755546569825,2.00224065780651 44.7789154052734,2.00224065780651 44.7789154052734,1.99048793315899 44.7899551391603,1.98995876312267 44.7968902587891,1.98464787006384 44.8024787902832,1.98464787006384 44.8024787902832,1.96544945240021 44.8004379272462,1.95683908462536 44.8037452697755,1.95683908462536 44.8037452697755,1.95478641986858 44.7971420288087,1.96865832805639 44.7902755737305,1.96961569786083 44.7835769653321,1.96903240680695 44.7802238464356,1.9511766433717 44.7703399658203,1.9511766433717 44.7703399658203,1.9530498981477 44.7640914916992,1.9530498981477 44.7640914916992,1.98362922668457 44.7650871276855,1.98362922668457 44.7650871276855,1.98594939708721 44.7660789489746))0.0006POINT(1.9747682864016485 44.78283639387654)
64642POLYGON((11.8859024047853 49.8091735839844,11.8799753189088 49.8143119812012,11.8765010833741 49.8158226013184,11.8729953765869 49.8157844543457,11.8735866546631 49.8179550170898,11.8659982681275 49.8225097656249,11.8653125762941 49.8247833251954,11.8625450134277 49.8262290954589,11.8588695526124 49.8256340026857,11.8585567474366 49.8288078308106,11.8646965026855 49.8309364318849,11.8662338256837 49.8326454162598,11.8629474639893 49.8354301452637,11.8629961013794 49.8371391296387,11.861813545227 49.8376235961914,11.861813545227 49.8376235961914,11.8675670623779 49.8383712768555,11.8684959411621 49.8396835327148,11.8714084625245 49.8408279418945,11.8774480819703 49.8413314819337,11.8814229965211 49.8397598266602,11.8845081329346 49.8401107788086,11.8850803375244 49.8382606506348,11.8889179229737 49.8372230529786,11.8867254257202 49.8378982543946,11.8867082595826 49.8401718139649,11.8838014602661 49.8416404724122,11.8844451904297 49.8431968688964,11.8909692764282 49.8440704345703,11.8901605606079 49.8411750793458,11.8906974792481 49.8395576477052,11.8996829986573 49.8418312072755,11.8981943130493 49.8456192016602,11.9015626907349 49.8460998535157,11.9015512466432 49.8476028442383,11.9005174636842 49.8479499816896,11.9032783508301 49.8485984802246,11.9019203186036 49.8506965637207,11.9065961837768 49.8525810241699,11.9086780548096 49.8519058227539,11.9123210906983 49.8527450561524,11.9180164337158 49.8505058288574,11.9197902679444 49.8474578857423,11.9225969314576 49.8477745056152,11.9232025146485 49.8466148376466,11.927830696106 49.8445587158204,11.9326543807983 49.8448753356935,11.9334115982057 49.8423118591309,11.9311151504518 49.8390579223634,11.9323081970216 49.8352165222168,11.931022644043 49.8327331542969,11.942045211792 49.8306045532227,11.9422569274903 49.8297729492188,11.9481763839721 49.827735900879,11.9533643722534 49.8268165588379,11.9573726654054 49.8218688964844,11.9585704803467 49.8187675476075,11.9631347656251 49.8143157958984,11.9706840515138 49.8124465942383,11.9706840515138 49.8124465942383,11.9512538909913 49.8055076599122,11.94379901886 49.8063392639161,11.9352979660035 49.8121528625488,11.9290285110474 49.8108100891113,11.9254999160767 49.8072090148926,11.9217386245728 49.8055839538575,11.9217386245728 49.8055839538575,11.9208250045777 49.8061714172364,11.9156923294068 49.8019142150879,11.9097766876222 49.7997856140137,11.9062271118165 49.8034019470215,11.8984594345094 49.8044776916503,11.8999300003053 49.80721282959,11.8971605300903 49.8080825805665,11.8908672332764 49.8034896850586,11.8859024047853 49.8091735839844))0.0006POINT(11.903985811869351 49.82953231811525)
67676POLYGON((8.90029239654547 48.6572761535645,8.88447952270508 48.6555175781251,8.88085365295416 48.6531066894531,8.87956714630133 48.6575050354004,8.87562084197992 48.6614418029785,8.86859130859381 48.6588821411133,8.85305404663092 48.6622314453126,8.84511470794683 48.6609191894532,8.84511470794683 48.6609191894532,8.85252952575689 48.6472473144531,8.85241127014166 48.6422996520997,8.85027217864996 48.6393623352051,8.84886360168468 48.6389694213868,8.84886360168468 48.6389694213868,8.85795879364019 48.6303367614746,8.86217308044434 48.628475189209,8.86811161041271 48.6274032592773,8.86811161041271 48.6274032592773,8.86991596221935 48.6286354064941,8.87492752075195 48.6288986206055,8.87493228912359 48.6324157714844,8.87714958190924 48.6330871582031,8.88064861297607 48.6315002441407,8.88064193725586 48.6329193115234,8.89116001129162 48.6328926086426,8.89504718780523 48.6351699829103,8.91791057586681 48.637767791748,8.92316150665278 48.6344604492188,8.91630458831798 48.6279029846191,8.91438198089611 48.6227493286134,8.9158239364624 48.6188774108886,8.91714763641369 48.618221282959,8.9209365844726 48.6197662353516,8.92462730407721 48.6151237487793,8.92967224121105 48.6143341064454,8.92967224121105 48.6143341064454,8.93469524383556 48.6175880432129,8.94702911376964 48.6204872131348,8.9458274841308 48.6228637695313,8.949541091919 48.6259536743165,8.94816112518311 48.6292266845704,8.9531135559082 48.6352233886719,8.96016025543219 48.6346740722656,8.96907997131348 48.6379890441895,8.97271251678461 48.640754699707,8.97022724151623 48.6416473388673,8.96919536590582 48.6395111083986,8.96903991699219 48.6410026550292,8.96663475036632 48.6406555175782,8.96663475036632 48.6406555175782,8.94958400726318 48.6374053955079,8.94674205780041 48.6397018432618,8.93907070159912 48.6419334411622,8.93544101715099 48.6421089172364,8.93288612365723 48.6396865844727,8.92776775360113 48.6431045532227,8.91786289215099 48.6425895690918,8.91605663299555 48.6437377929689,8.91586875915533 48.6463012695312,8.90516090393061 48.6512298583984,8.90645027160656 48.6524887084962,8.90343093872076 48.6522293090821,8.90029239654547 48.6572761535645))0.0006POINT(8.908297092683906 48.63754955414805)
19660POLYGON((12.6221742630005 42.8154411315918,12.6191234588623 42.8114471435548,12.6071691513062 42.8049354553223,12.6032867431641 42.8047676086426,12.5847368240356 42.8125877380371,12.5739488601685 42.8038482666015,12.5672616958618 42.801628112793,12.5672616958618 42.801628112793,12.5512638092041 42.82275390625,12.5423851013184 42.82767868042,12.5291213989258 42.8388061523438,12.5291213989258 42.8388061523438,12.5278244018555 42.8403663635253,12.5264806747437 42.8485603332521,12.5365591049194 42.8606872558593,12.5546731948853 42.8700408935547,12.5660133361816 42.8732872009278,12.5740442276002 42.8730049133301,12.5794010162354 42.8784866333008,12.5794010162354 42.8784866333008,12.5822820663452 42.8761901855469,12.5887804031373 42.8677253723145,12.6019372940065 42.8640022277833,12.6244411468506 42.8504447937013,12.6227979660034 42.8476638793946,12.6227979660034 42.8476638793946,12.6193771362305 42.8405151367188,12.6171970367433 42.8224258422852,12.6221742630005 42.8154411315918))0.0006POINT(12.57931651387899 42.840138571602985)
19311POLYGON((11.5850353240968 46.7099914550782,11.594687461853 46.7033653259277,11.6120977401734 46.6990203857423,11.624366760254 46.6917266845704,11.6265363693238 46.6871147155761,11.6263513565063 46.6832847595216,11.6206007003785 46.6712036132812,11.6152238845825 46.6659736633301,11.6152238845825 46.6659736633301,11.6300106048585 46.6706123352051,11.6369714736939 46.6752662658693,11.6463012695314 46.6722145080568,11.6717061996459 46.6611213684083,11.6797266006471 46.6589279174806,11.6874876022339 46.6599235534669,11.7040109634399 46.6675453186036,11.7199602127075 46.6706657409669,11.7324924468994 46.670295715332,11.7435646057129 46.6659088134766,11.7492094039918 46.6650619506837,11.7787113189698 46.6687164306641,11.7930660247803 46.6691207885742,11.7930660247803 46.6691207885742,11.7947826385499 46.6704673767091,11.7947826385499 46.6704673767091,11.7894449234009 46.6716651916503,11.7791223526 46.6817092895508,11.7599229812623 46.6944732666016,11.7529439926147 46.6953544616699,11.743824005127 46.6929550170898,11.7398490905762 46.6934814453126,11.7343845367432 46.6963958740234,11.7344570159912 46.700668334961,11.7373790740967 46.7051773071289,11.7414550781251 46.7084197998047,11.7422704696655 46.7128715515137,11.7395696640016 46.7220878601075,11.7258195877075 46.7322731018068,11.72256565094 46.7365341186524,11.7235527038574 46.7413177490236,11.722749710083 46.7430534362793,11.7158184051514 46.746307373047,11.706711769104 46.745632171631,11.7041215896606 46.7435874938965,11.705093383789 46.7412796020508,11.7030363082887 46.7402610778809,11.688401222229 46.7454528808594,11.688401222229 46.7454528808594,11.6855697631837 46.743293762207,11.6801223754882 46.7437820434571,11.671504020691 46.7463417053223,11.6642742156982 46.7396278381348,11.6584072113038 46.7371940612794,11.6584072113038 46.7371940612794,11.6578197479248 46.7316322326661,11.6565685272218 46.730411529541,11.6512670516969 46.7277259826661,11.6418552398682 46.7257919311523,11.6392879486084 46.7257728576661,11.636875152588 46.7291488647462,11.6340169906617 46.7311935424805,11.625099182129 46.7327117919922,11.6007289886474 46.7215805053711,11.5850353240968 46.7099914550782))0.0006POINT(11.692677331349243 46.70480800810318)
48306POLYGON((-0.0221859104931355 47.5764694213867,-0.0255599468945888 47.5664710998536,-0.0157755073159365 47.5596008300782,-0.0274657644331455 47.5444412231446,-0.0164838843047619 47.5337295532227,-0.0179251953959465 47.5236816406251,-0.0179251953959465 47.5236816406251,-0.0264815408735899 47.5211906433105,-0.0392598658800125 47.5239753723145,-0.0392598658800125 47.5239753723145,-0.0542338117957115 47.5253601074219,-0.0761317387223244 47.5331077575684,-0.0761317387223244 47.5331077575684,-0.0897178500890732 47.5467720031738,-0.0897178500890732 47.5467720031738,-0.0793737322091488 47.5533599853516,-0.0702298060058979 47.5688362121583,-0.057696670293808 47.5793876647949,-0.057696670293808 47.5793876647949,-0.0221859104931355 47.5764694213867))0.0006POINT(-0.047329081320433966 47.54543726067798)