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 |
---|---|---|---|
37995 | POLYGON((1.15522623062145 49.7145881652833,1.14503657817841 49.7173194885253,1.14503657817841 49.7173194885253,1.14615380764008 49.7304840087891,1.16321325302135 49.7372932434083,1.16321325302135 49.7372932434083,1.16600191593176 49.7310638427735,1.18428242206585 49.7262077331544,1.18352353572857 49.7229766845703,1.18352353572857 49.7229766845703,1.15522623062145 49.7145881652833)) | 0.0006 | POINT(1.1635211110115802 49.725752258300815) |
42322 | POLYGON((6.59459924697882 48.9637298583985,6.58563137054443 48.9562034606934,6.56605529785162 48.9539871215821,6.56605529785162 48.9539871215821,6.56118631362926 48.9529418945312,6.56118631362926 48.9529418945312,6.56669712066662 48.9402313232422,6.58555603027355 48.9301528930665,6.58555603027355 48.9301528930665,6.59564447402965 48.9322090148927,6.59564447402965 48.9322090148927,6.60365581512451 48.9409523010254,6.60175848007208 48.9508476257325,6.60175848007208 48.9508476257325,6.59459924697882 48.9637298583985)) | 0.0006 | POINT(6.5836417675019065 48.94581386021212) |
67258 | POLYGON((8.33996963500982 49.0801506042481,8.34168910980225 49.0766296386719,8.34700298309332 49.0708007812501,8.34685134887701 49.0692939758301,8.34458065032959 49.0664710998536,8.3479213714599 49.0646286010743,8.35244560241705 49.0645256042481,8.3558721542359 49.0663108825685,8.35671710968018 49.0685577392578,8.3546867370606 49.0710945129396,8.35805416107172 49.0711288452149,8.36126232147217 49.0698165893556,8.36597728729242 49.0703468322753,8.37460708618164 49.0678215026857,8.37554073333746 49.0693206787109,8.39335346221924 49.0687942504883,8.40233898162847 49.064968109131,8.40356254577642 49.065486907959,8.4087963104248 49.0625801086426,8.41630935668957 49.0709457397462,8.41061687469477 49.0727272033692,8.41150379180914 49.0813636779786,8.41805076599127 49.0829544067383,8.42376422882091 49.0915336608887,8.43560218811035 49.0915298461915,8.43560218811035 49.0915298461915,8.4273538589477 49.0723915100099,8.44073009490978 49.0577087402344,8.44888019561773 49.0508613586427,8.46273136138922 49.0428085327148,8.46352863311768 49.045322418213,8.46597671508789 49.0450439453126,8.46646022796631 49.0429840087891,8.46973228454596 49.0432777404785,8.46946239471441 49.041229248047,8.4716148376466 49.0395126342775,8.4741353988648 49.0417480468751,8.47545337677013 49.0416526794434,8.47552013397217 49.044319152832,8.47737121582037 49.0435791015625,8.47776794433599 49.0468521118164,8.48056602478033 49.05326461792,8.47982692718512 49.0581817626954,8.47763156890875 49.0599212646486,8.48173999786383 49.0608787536622,8.48588371276855 49.0583381652832,8.48588371276855 49.0583381652832,8.49093341827404 49.0515251159668,8.49501991271978 49.048194885254,8.50061321258556 49.0443687438966,8.50659179687506 49.0419998168946,8.51025199890131 49.0354919433595,8.51658630371088 49.0318717956543,8.51994609832764 49.0310134887695,8.51994609832764 49.0310134887695,8.52056503295898 49.0289268493653,8.51950931549072 49.0279731750489,8.52242755889887 49.0248756408692,8.52272415161138 49.0229759216309,8.52122116088879 49.0149116516114,8.51957225799561 49.0127601623535,8.51458644866949 49.0112686157228,8.5129156112672 49.0009803771973,8.51146125793468 48.9987678527833,8.50253963470465 48.995948791504,8.50263786315918 48.9948883056642,8.49963569641125 48.9927635192871,8.50386905670166 48.9895820617676,8.50258636474615 48.9875259399414,8.50519371032721 48.9833068847656,8.50997829437262 48.982322692871,8.50839900970459 48.9808197021484,8.50608825683588 48.9755401611329,8.50836277008068 48.973747253418,8.50901126861572 48.9672813415528,8.52365112304682 48.9655075073243,8.52626895904547 48.9646453857422,8.52591323852545 48.9633064270021,8.528476715088 48.9624252319337,8.54289817810059 48.9599151611329,8.53982257843018 48.9538879394532,8.53982257843018 48.9538879394532,8.53738307952881 48.9523887634278,8.53143405914318 48.9532089233399,8.52384281158459 48.9517822265626,8.51548004150391 48.947494506836,8.51342391967785 48.9456748962403,8.51326465606684 48.9439010620118,8.51112461090088 48.9427833557129,8.49501800537121 48.942195892334,8.49143409729015 48.9403610229492,8.49011611938488 48.9424858093262,8.48686599731451 48.9411697387695,8.48686599731451 48.9411697387695,8.46203327178955 48.9405670166016,8.46001243591314 48.9421844482422,8.46063041687023 48.9446868896486,8.4551219940185 48.9447746276856,8.45521831512463 48.9463691711425,8.44672679901123 48.9443321228027,8.44672679901123 48.9443321228027,8.43898391723638 48.946216583252,8.44022655487061 48.9487915039062,8.44492721557629 48.9503555297852,8.44408226013184 48.9548225402832,8.44774818420422 48.9611701965333,8.45163536071789 48.9632568359375,8.44806289672852 48.966636657715,8.43944358825695 48.971031188965,8.4118585586549 48.9600715637208,8.38771438598644 48.9566192626953,8.38893985748297 48.9633102416992,8.38359928131109 48.967311859131,8.38449382781982 48.9709205627443,8.38328552246094 48.9723014831542,8.37824916839611 48.9752464294434,8.37483787536621 48.973560333252,8.37340450286871 48.9713478088378,8.37181282043468 48.9714965820312,8.36475372314447 48.9754867553711,8.36475372314447 48.9754867553711,8.36229038238537 48.977279663086,8.34293556213379 48.9824981689454,8.33616161346441 48.9869194030762,8.33046054840082 48.9893531799317,8.32974243164068 48.9919586181641,8.32445812225342 48.9890594482422,8.32078933715815 48.9885444641113,8.32211494445801 48.9840087890626,8.32071113586437 48.9839172363282,8.31177616119385 48.9840965270997,8.29888343811035 48.9910049438477,8.29776287078857 48.9888954162597,8.29372501373297 48.9857025146486,8.28237724304199 48.9833068847656,8.27734851837158 48.9899406433106,8.27734851837158 48.9899406433106,8.28759670257574 48.9984283447266,8.28759670257574 48.9984283447266,8.29152870178234 49.0035896301269,8.29152870178234 49.0035896301269,8.29865646362316 49.016815185547,8.30413722991943 49.0406532287598,8.30871105194103 49.0499572753907,8.31643581390392 49.0604782104493,8.32399082183838 49.0684471130371,8.3281078338623 49.0722084045411,8.33996963500982 49.0801506042481)) | 0.0006 | POINT(8.430092986749177 49.00878960745677) |
61213 | POLYGON((7.59987878799433 46.2138595581055,7.58963108062738 46.2225418090821,7.58434104919439 46.2331657409667,7.58434104919439 46.2331657409667,7.58099412918091 46.2331123352052,7.58099412918091 46.2331123352052,7.5810279846192 46.2258987426758,7.58290910720825 46.2205429077148,7.58617877960205 46.2154693603517,7.59047794342047 46.2112693786621,7.59047794342047 46.2112693786621,7.59987878799433 46.2138595581055)) | 0.0006 | POINT(7.586477453058432 46.22303702614526) |
1401686 | POLYGON((-2.76779603958119 41.7813568115234,-2.76397109031677 41.78666305542,-2.76210689544672 41.7932395935058,-2.74926900863647 41.8044548034669,-2.74640107154841 41.8052520751954,-2.74616408348083 41.8074226379395,-2.73810791969294 41.8050155639648,-2.69623303413385 41.80379486084,-2.70167303085327 41.8014068603516,-2.67675590515125 41.7969779968262,-2.66176104545593 41.7962303161622,-2.64499402046198 41.798484802246,-2.63908100128174 41.7968482971193,-2.63259506225586 41.7922973632813,-2.62343311309814 41.7906990051271,-2.61927103996265 41.7843017578126,-2.60772299766541 41.78568649292,-2.59395909309376 41.7811164855958,-2.58464193344116 41.7706260681153,-2.57611799240112 41.7568855285645,-2.58260703086847 41.7450141906738,-2.58512806892395 41.7437477111817,-2.58236503601074 41.7393913269044,-2.58316993713373 41.7361145019531,-2.58736801147461 41.7339210510253,-2.58860993385315 41.7294311523437,-2.5942919254303 41.7303352355957,-2.60889196395874 41.7397193908692,-2.61648607254028 41.742832183838,-2.63039088249201 41.7422828674318,-2.63669300079346 41.7466278076172,-2.64504599571228 41.7434196472169,-2.64501190185541 41.7410049438477,-2.64946103096008 41.7365226745606,-2.67695188522333 41.7316246032714,-2.68748307228083 41.7243766784667,-2.69678497314453 41.7251052856445,-2.69963407516479 41.7457008361818,-2.70909404754633 41.7630996704102,-2.71421289443964 41.7667236328126,-2.74393105506897 41.7726135253907,-2.76779603958119 41.7813568115234)) | 0.0006 | POINT(-2.6584309310447582 41.76630169007841) |
35486 | POLYGON((6.10416698455816 46.980308532715,6.10155868530285 46.9775314331055,6.10760784149176 46.9725990295411,6.1041951179505 46.9702606201171,6.07432031631475 46.9599418640137,6.07432031631475 46.9599418640137,6.06854820251471 46.9686088562013,6.05372476577759 46.9760131835938,6.05372476577759 46.9760131835938,6.05937767028814 46.9786643981934,6.05937767028814 46.9786643981934,6.07591724395752 46.985450744629,6.10087013244635 46.9841079711915,6.10087013244635 46.9841079711915,6.10416698455816 46.980308532715)) | 0.0006 | POINT(6.081327131816368 46.975158146449566) |
73265 | POLYGON((15.0181751251222 45.4999923706055,15.0081176757812 45.5046997070312,14.9965219497681 45.5070800781251,14.9810781478882 45.5065307617189,14.9677133560181 45.5134887695312,14.931568145752 45.5371475219727,14.9137048721313 45.539867401123,14.898838043213 45.5341033935547,14.896414756775 45.5219421386719,14.896414756775 45.5219421386719,14.8919372558594 45.5250625610351,14.8816919326782 45.5214958190919,14.881711959839 45.5250511169434,14.8663759231568 45.5250358581544,14.8562088012696 45.5356903076173,14.8408908843994 45.5392303466797,14.8408727645875 45.5356750488282,14.8255338668824 45.5356597900391,14.8203849792481 45.5285415649414,14.8254766464235 45.5249938964844,14.8254203796386 45.5143280029298,14.8202686309814 45.5072097778321,14.8100271224977 45.5036430358887,14.8100061416627 45.5000877380372,14.8046684265137 45.5013236999512,14.8046684265137 45.5013236999512,14.8016958236694 45.5081176757812,14.7949228286744 45.5142822265626,14.7869071960449 45.5156898498536,14.7869071960449 45.5156898498536,14.7386827468872 45.5462341308593,14.7387027740479 45.549789428711,14.7284793853759 45.5497779846191,14.7284965515138 45.5533332824708,14.7131824493409 45.5568733215332,14.7131996154786 45.5604286193849,14.7183866500856 45.5746574401856,14.7132749557495 45.5746498107911,14.7132959365845 45.5782089233399,14.7081813812255 45.5782012939454,14.7082767486572 45.5959777832032,14.7031650543213 45.5959739685059,14.7031650543213 45.5959739685059,14.7032814025879 45.6173057556152,14.698166847229 45.617301940918,14.6982049942017 45.6244125366212,14.6880016326904 45.6279563903808,14.6880378723145 45.635066986084,14.7136011123657 45.635093688965,14.7136583328248 45.6457633972168,14.7187719345093 45.6457672119142,14.7187719345093 45.6457672119142,14.7442741394044 45.6351280212403,14.7596101760865 45.6351432800294,14.7647790908814 45.6458168029786,14.7699689865112 45.6600418090821,14.7649517059327 45.6778144836426,14.759838104248 45.6778106689454,14.7598972320557 45.6884765625001,14.7650089263917 45.6884803771973,14.7958164215087 45.7134017944337,14.7958545684814 45.7205123901368,14.8009672164918 45.7205200195314,14.8061180114747 45.7276344299317,14.7806329727173 45.7418289184571,14.7806510925293 45.7453842163086,14.7806510925293 45.7453842163086,14.7806901931763 45.7524986267091,14.7960443496704 45.7560691833497,14.7960653305054 45.7596244812012,14.7960653305054 45.7596244812012,14.8062705993653 45.7560806274414,14.8216247558594 45.7596511840821,14.8267374038696 45.7596549987794,14.8267192840577 45.7560997009278,14.8573923110961 45.7561340332032,14.8573350906372 45.7454681396485,14.8880071640016 45.7454986572267,14.8931579589844 45.7526168823242,14.8983659744263 45.7703971862794,14.9239473342896 45.7739791870117,14.9392452239991 45.7668838500978,14.9648065567017 45.7669143676757,14.9648065567017 45.7669143676757,14.9646339416505 45.7349128723146,14.9544095993042 45.7349014282227,14.9542388916017 45.7029037475587,14.9644432067872 45.6993560791017,14.9644041061403 45.6922454833985,14.9695177078247 45.692253112793,14.9796857833863 45.6815948486329,14.9950037002564 45.6780586242676,14.9948511123658 45.6496124267578,14.9999608993531 45.6496200561523,14.9999036788942 45.6389503479004,15.0101099014283 45.6354064941407,15.0152215957642 45.6354141235352,15.0152215957642 45.6354141235352,15.0152044296265 45.6318588256837,15.0202589035035 45.6211967468262,15.0253705978394 45.6212005615234,15.0253324508667 45.6140899658204,15.0304441452026 45.614097595215,15.035517692566 45.606990814209,15.0457439422609 45.6070022583008,15.0457048416139 45.5998916625977,15.05592918396 45.5998992919922,15.05592918396 45.5998992919922,15.0507402420044 45.5856742858887,15.0558519363403 45.5856781005861,15.0557203292847 45.560791015625,15.0761499404908 45.5572547912598,15.0760908126831 45.5465888977051,15.0607538223267 45.546573638916,15.0453996658325 45.5430030822754,15.0453815460206 45.5394477844239,15.0402669906616 45.5394401550294,15.0401525497437 45.5181083679199,15.0503587722778 45.5145645141601,15.0708456039429 45.5216941833497,15.0708646774293 45.5252494812012,15.0862007141113 45.5252685546875,15.0964069366455 45.5217208862305,15.0963678359986 45.5146102905273,15.0605449676514 45.5074615478517,15.055480003357 45.5023193359376,15.055480003357 45.5023193359376,15.0391225814819 45.5046997070312,15.0205068588257 45.4989013671876,15.0181751251222 45.4999923706055)) | 0.0006 | POINT(14.886869290078362 45.610349374224064) |
14025 | POLYGON((11.7322597503663 44.7147102355958,11.7393426895142 44.7264099121095,11.7543325424194 44.7407493591309,11.7664976119996 44.7471847534181,11.7733039855957 44.7483863830567,11.7816181182862 44.7533302307129,11.7842388153076 44.7559356689454,11.7842388153076 44.7559356689454,11.7876176834106 44.7589492797852,11.7639198303224 44.7894668579102,11.7531471252442 44.7930412292481,11.7546634674073 44.7975273132324,11.7546634674073 44.7975273132324,11.7548847198487 44.7985420227051,11.7525882720948 44.7998008728027,11.7364377975465 44.8049240112305,11.7145109176635 44.7890853881837,11.7012538909912 44.786148071289,11.6951208114625 44.780933380127,11.699821472168 44.7711296081544,11.701870918274 44.7627067565919,11.7014312744142 44.7542343139649,11.7120351791382 44.7467231750489,11.7149505615235 44.7371520996094,11.7085781097413 44.7335014343262,11.707995414734 44.7289543151856,11.707995414734 44.7289543151856,11.7157793045044 44.7290725708009,11.7171039581299 44.7280426025391,11.7156944274902 44.7232284545898,11.7229852676392 44.7205696105958,11.7322597503663 44.7147102355958)) | 0.0006 | POINT(11.73583489079634 44.758156684137205) |
43232 | POLYGON((6.87117528915405 48.1074256896973,6.8966789245606 48.1022987365723,6.8966789245606 48.1022987365723,6.90173387527477 48.1080932617188,6.90457153320318 48.1279296875001,6.89659357070934 48.1399955749512,6.89659357070934 48.1399955749512,6.86764430999767 48.1536521911622,6.86305713653564 48.163272857666,6.84421539306652 48.1595344543458,6.84039402008068 48.1617965698242,6.84039402008068 48.1617965698242,6.8386282920838 48.1489868164064,6.8386282920838 48.1489868164064,6.84833097457891 48.1467247009278,6.86351060867315 48.1278877258302,6.87117528915405 48.1074256896973)) | 0.0006 | POINT(6.869301795959546 48.137542247772274) |
42038 | POLYGON((5.22715139389038 49.4829597473145,5.22490739822393 49.4798965454103,5.20975732803356 49.4815330505372,5.20200014114391 49.4769821166993,5.19977140426641 49.4739112854005,5.20102834701538 49.467170715332,5.18961334228516 49.4524536132814,5.18458223342901 49.4515342712403,5.18458223342901 49.4515342712403,5.18595266342163 49.4393196105958,5.19390487670898 49.4311447143555,5.19390487670898 49.4311447143555,5.1928381919862 49.4297256469728,5.1928381919862 49.4297256469728,5.20768451690674 49.4239158630372,5.20768451690674 49.4239158630372,5.21114110946667 49.4228820800782,5.21114110946667 49.4228820800782,5.21675348281866 49.4286956787109,5.24745178222656 49.4283294677735,5.26739740371704 49.4323463439943,5.29576683044445 49.4238967895508,5.29576683044445 49.4238967895508,5.30382537841808 49.4259376525879,5.30382537841808 49.4259376525879,5.29888343811047 49.4304122924805,5.30077028274548 49.4359245300294,5.30077028274548 49.4359245300294,5.29145479202282 49.4388236999513,5.29689931869518 49.4551658630372,5.29499864578241 49.4617233276368,5.29499864578241 49.4617233276368,5.25440406799322 49.4658927917482,5.22715139389038 49.4829597473145)) | 0.0006 | POINT(5.23892274047395 49.44385644161347) |