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 |
|---|---|---|---|
| 20294 | POLYGON((11.2717123031617 45.5850067138672,11.2665739059449 45.5824317932129,11.2613725662231 45.5777091979981,11.247501373291 45.578197479248,11.247501373291 45.578197479248,11.2445993423462 45.5613975524902,11.2445993423462 45.5613975524902,11.2525177001953 45.543140411377,11.275417327881 45.525260925293,11.2805280685425 45.5237197875976,11.2818450927736 45.5208282470704,11.2823524475098 45.5150032043458,11.2818441390991 45.5119476318359,11.2807216644287 45.5111122131348,11.2807216644287 45.5111122131348,11.285870552063 45.511646270752,11.285870552063 45.511646270752,11.2993240356446 45.5218200683593,11.3002586364746 45.5218276977539,11.2997913360597 45.5210189819337,11.3065462112428 45.5224418640138,11.3100004196167 45.5261154174805,11.3168182373047 45.5399818420411,11.3173532485961 45.5427169799805,11.3157472610473 45.5447845458985,11.3084096908569 45.5498542785645,11.3024616241456 45.5557174682618,11.3024616241456 45.5557174682618,11.2948751449585 45.551872253418,11.2886943817139 45.5548858642579,11.2758369445802 45.5670814514161,11.2750492095947 45.5707321166993,11.2773952484132 45.5729713439943,11.2789192199707 45.5777015686036,11.2785673141479 45.5813446044922,11.2717123031617 45.5850067138672)) | 0.0006 | POINT(11.283430262974356 45.545381164550804) |
| 51208 | POLYGON((2.4656400680542 49.9333610534669,2.4741349220277 49.9490089416505,2.47203755378717 49.9606399536133,2.47203755378717 49.9606399536133,2.48266100883495 49.9621162414551,2.48266100883495 49.9621162414551,2.49191355705267 49.9600524902344,2.49748992919928 49.9551544189454,2.49748992919928 49.9551544189454,2.4912567138673 49.9463577270508,2.49500417709362 49.940456390381,2.49500417709362 49.940456390381,2.48085522651678 49.9411697387695,2.47533154487616 49.932846069336,2.4656400680542 49.9333610534669)) | 0.0006 | POINT(2.4838226693017744 49.94996643066413) |
| 54951 | POLYGON((5.60159587860113 44.5170783996583,5.58841419219971 44.5198020935059,5.57056951522827 44.5155258178711,5.54961919784546 44.5224266052247,5.54940891265869 44.5283660888672,5.54940891265869 44.5283660888672,5.5546545982362 44.533821105957,5.54323673248302 44.5442428588868,5.5539693832398 44.5554161071778,5.57231616973888 44.5530548095704,5.59724903106695 44.5432739257813,5.59724903106695 44.5432739257813,5.61498689651489 44.5327758789063,5.61498689651489 44.5327758789063,5.60833692550671 44.5286560058593,5.60159587860113 44.5170783996583)) | 0.0006 | POINT(5.577733484904017 44.533257039388054) |
| 29613 | POLYGON((3.39794898033153 47.8263359069825,3.39120316505432 47.8213386535645,3.35353851318371 47.812385559082,3.35353851318371 47.812385559082,3.3457453250885 47.8241882324219,3.3457453250885 47.8241882324219,3.34625601768494 47.8266639709473,3.34625601768494 47.8266639709473,3.36322498321545 47.8318939208985,3.38209772109991 47.8318252563477,3.38209772109991 47.8318252563477,3.38989424705511 47.8251037597657,3.39794898033153 47.8263359069825)) | 0.0006 | POINT(3.366462210814211 47.8245665232341) |
| 56022 | POLYGON((4.82389926910406 45.4020729064943,4.8396897315979 45.380054473877,4.83801031112677 45.3694458007812,4.83121776580816 45.3602867126465,4.83121776580816 45.3602867126465,4.79279184341431 45.3572540283203,4.79279184341431 45.3572540283203,4.80428791046143 45.3721733093263,4.80874395370478 45.3889617919922,4.80521726608288 45.3913688659669,4.80521726608288 45.3913688659669,4.80982732772839 45.4030151367188,4.80982732772839 45.4030151367188,4.81162643432629 45.4076156616211,4.81162643432629 45.4076156616211,4.82189464569103 45.4056739807129,4.82189464569103 45.4056739807129,4.82389926910406 45.4020729064943)) | 0.0006 | POINT(4.815281278946886 45.38606688555552) |
| 60541 | POLYGON((9.59994220733643 47.3389053344728,9.5996932983399 47.3384475708008,9.59903717041016 47.3377761840821,9.59878730773931 47.3373184204102,9.59878730773931 47.3373184204102,9.59827518463129 47.3350906372071,9.59720897674561 47.3331451416016,9.59720897674561 47.3331451416016,9.59705257415783 47.3325538635253,9.59679698944086 47.3310279846191,9.5963830947876 47.3299407958986,9.5963830947876 47.3299407958986,9.59570121765148 47.3288536071778,9.59492015838623 47.3267974853516,9.59423923492443 47.3256988525391,9.59423923492443 47.3256988525391,9.59396171569836 47.325107574463,9.59396171569836 47.325107574463,9.59340286254883 47.3225288391114,9.59237194061291 47.3205184936524,9.59185504913341 47.318386077881,9.59185504913341 47.318386077881,9.59078693389893 47.3172569274903,9.59009647369385 47.3166084289551,9.58932113647472 47.3160095214845,9.58831596374512 47.3144264221193,9.58339691162109 47.3109550476075,9.58339691162109 47.3109550476075,9.58111286163336 47.3102302551271,9.58025646209717 47.3096771240235,9.58025646209717 47.3096771240235,9.57493782043463 47.3073196411133,9.57317924499523 47.3068695068361,9.57159614562983 47.3061447143554,9.56991291046154 47.3056449890138,9.56938457489014 47.305347442627,9.56842422485352 47.304485321045,9.55808353424072 47.3068580627441,9.54813957214361 47.3055343627931,9.52603340148926 47.3053245544434,9.51328086853039 47.3095626831056,9.5035543441773 47.3060035705568,9.5035543441773 47.3060035705568,9.49762725830084 47.3056793212891,9.49762725830084 47.3056793212891,9.49386119842529 47.3099670410156,9.4932336807251 47.3122444152833,9.49725246429449 47.3161125183107,9.5000400543214 47.3214302062989,9.5016880035401 47.3281326293945,9.50457668304438 47.3321723937988,9.50487136840815 47.338981628418,9.50487136840815 47.338981628418,9.51625919342035 47.3359985351563,9.52268695831299 47.3379364013673,9.52859115600586 47.3367881774902,9.52859115600586 47.3367881774902,9.5290384292602 47.3332633972169,9.53331661224377 47.3300933837891,9.54176044464111 47.3272056579591,9.5437335968017 47.3274459838868,9.55379581451427 47.3348121643068,9.55159091949463 47.3399085998536,9.55205631256115 47.3410606384278,9.55688095092779 47.3432350158691,9.55950069427485 47.3462295532227,9.56667137146007 47.3457717895509,9.56949901580822 47.3498458862305,9.58175277709955 47.3545951843262,9.58465862274176 47.3568000793457,9.59240436553966 47.3664932250977,9.59614944458013 47.368034362793,9.59614944458013 47.368034362793,9.60031414031988 47.3739700317383,9.60662269592291 47.3757476806642,9.60662269592291 47.3757476806642,9.61217212677008 47.3810844421387,9.61217212677008 47.3810844421387,9.62141418457037 47.3899002075195,9.62432003021252 47.390594482422,9.62432003021252 47.390594482422,9.62468242645264 47.3874168395997,9.62302494049084 47.384105682373,9.62331390380865 47.382007598877,9.62562084197998 47.3808898925782,9.63035202026379 47.3815612792969,9.63197898864746 47.3798103332521,9.63690280914312 47.3783416748047,9.63768959045416 47.3772964477539,9.6359777450561 47.3744125366212,9.62728023529053 47.3667869567872,9.62728023529053 47.3667869567872,9.62630367279053 47.3659019470216,9.62630367279053 47.3659019470216,9.62505054473888 47.3649330139161,9.61520004272467 47.3579063415528,9.61520004272467 47.3579063415528,9.61401462554937 47.3569488525391,9.61281204223644 47.3556747436525,9.60958576202404 47.3533096313477,9.60958576202404 47.3533096313477,9.60869503021252 47.3527793884277,9.60794067382824 47.3521614074708,9.60705471038818 47.3516273498535,9.60705471038818 47.3516273498535,9.60534000396729 47.3501853942872,9.60534000396729 47.3501853942872,9.60474014282232 47.3489837646485,9.60372352600103 47.3478813171387,9.60305309295666 47.3462448120117,9.60216903686523 47.3448829650879,9.6014165878297 47.3427963256836,9.60071468353271 47.3417015075685,9.60071468353271 47.3417015075685,9.60044479370112 47.3411407470704,9.59994220733643 47.3389053344728)) | 0.0006 | POINT(9.581776884327805 47.3404012265413) |
| 14098 | POLYGON((10.7064151763917 44.1991004943848,10.7010908126832 44.1944923400879,10.7010908126832 44.1944923400879,10.7052402496338 44.1921348571777,10.7052402496338 44.1921348571777,10.7219257354736 44.1966667175294,10.7265739440918 44.199432373047,10.7265729904175 44.2066688537598,10.729868888855 44.2171096801758,10.7868347167969 44.219066619873,10.8043909072877 44.2350273132324,10.7998151779175 44.2399826049805,10.7966403961183 44.2418251037598,10.7984018325806 44.2458114624023,10.8175354003907 44.2509574890137,10.8248510360718 44.2510108947755,10.8305311203003 44.2480316162111,10.8320569992065 44.2455101013183,10.8350200653077 44.2437362670898,10.8511667251588 44.2366790771484,10.8621788024902 44.2331542968751,10.8621788024902 44.2331542968751,10.8704395294191 44.2359390258789,10.8708534240723 44.2379035949707,10.8605241775513 44.2411422729493,10.8632497787476 44.2493476867676,10.8655748367311 44.250774383545,10.867943763733 44.2575607299805,10.8672513961793 44.2609939575196,10.8650846481324 44.2626228332521,10.8641929626466 44.2649040222169,10.8643856048585 44.2674598693848,10.8662080764771 44.2699317932128,10.8662080764771 44.2699317932128,10.8561859130859 44.2675666809083,10.8491077423097 44.2684555053712,10.8395214080811 44.2719841003419,10.8235158920288 44.273078918457,10.8174667358398 44.274356842041,10.8136577606202 44.2768096923829,10.8072080612183 44.2846832275392,10.7931785583497 44.2981109619141,10.7931785583497 44.2981109619141,10.7869100570679 44.2881164550782,10.7778663635254 44.2770767211913,10.7569799423218 44.2666397094727,10.7466115951539 44.2575187683107,10.7366104125977 44.2458305358887,10.7339382171631 44.2337646484376,10.7240476608276 44.2248191833497,10.7128839492799 44.208953857422,10.7109498977661 44.2031059265137,10.7064151763917 44.1991004943848)) | 0.0006 | POINT(10.799949150819096 44.24430142916169) |
| 33372 | POLYGON((4.20250749588013 49.7019729614258,4.20093345642101 49.6951141357422,4.18628025054937 49.6851119995118,4.18250513076782 49.6751747131348,4.18250513076782 49.6751747131348,4.20030927658092 49.6814804077149,4.21544170379639 49.6830101013184,4.21544170379639 49.6830101013184,4.22532606124872 49.682228088379,4.22887563705444 49.6847076416016,4.2265539169311 49.691291809082,4.2122921943664 49.7009086608886,4.20250749588013 49.7019729614258)) | 0.0006 | POINT(4.206580996513376 49.686598777771025) |
| 64000 | POLYGON((14.2826099395752 53.2338905334472,14.2812271118164 53.2370109558105,14.2867679595947 53.2361907958985,14.2814245224 53.2440261840821,14.2814245224 53.2440261840821,14.2896604537964 53.2462806701661,14.2923631668091 53.2425880432129,14.2962970733643 53.243465423584,14.2974786758423 53.2368965148927,14.2994623184205 53.23641204834,14.3096170425414 53.2457695007324,14.3214979171753 53.2521324157715,14.3347749710084 53.2534637451172,14.3351068496705 53.2545242309571,14.3369693756104 53.2545394897462,14.3370180130005 53.2578582763672,14.3392219543458 53.2607574462891,14.3461742401123 53.2597465515137,14.3447113037109 53.2582931518555,14.3494834899903 53.2560539245605,14.3508586883545 53.2575302124024,14.3546619415283 53.2558898925782,14.3577461242675 53.2520294189454,14.3567609786987 53.2505493164064,14.3622961044312 53.2472686767579,14.3591566085816 53.2563171386719,14.3728799819947 53.2604637145996,14.3831672668457 53.2669982910156,14.386555671692 53.2681388854981,14.386555671692 53.2681388854981,14.3936414718628 53.2676277160646,14.4013481140137 53.2644577026368,14.4050598144532 53.2641677856445,14.4088630676269 53.2571144104005,14.4109439849854 53.2470855712891,14.4138669967651 53.2470474243165,14.4138231277467 53.2435111999512,14.4254999160767 53.2398338317871,14.4198436737061 53.2352371215821,14.4194784164429 53.2328605651856,14.4194784164429 53.2328605651856,14.4084959030151 53.2232017517091,14.4069948196411 53.2121887207032,14.4036540985108 53.2090110778809,14.3966903686524 53.2060470581055,14.3851776123047 53.2048645019531,14.3772726058959 53.2017478942872,14.3745803833009 53.1878204345704,14.3697519302368 53.1818046569825,14.3699140548707 53.1797218322753,14.3664054870606 53.1726760864258,14.369815826416 53.1642532348633,14.369637489319 53.1605033874512,14.3711080551148 53.1572875976564,14.3825597763063 53.1460075378418,14.3877372741699 53.1430244445801,14.3832483291626 53.1369743347169,14.3837795257568 53.1343383789063,14.3817901611329 53.1317901611328,14.3821115493774 53.1303405761719,14.3821115493774 53.1303405761719,14.3667001724243 53.1259422302246,14.3650808334351 53.1317176818848,14.3696212768556 53.1357154846191,14.3702402114869 53.1373062133789,14.3638906478883 53.1483993530273,14.3612842559816 53.1494178771973,14.3588914871217 53.1523666381836,14.3478517532348 53.1526489257813,14.3450603485107 53.1543045043945,14.3379173278808 53.1554985046386,14.3301610946655 53.161376953125,14.3301610946655 53.161376953125,14.3416080474854 53.174690246582,14.3439617156983 53.1805572509767,14.3340635299682 53.1816520690918,14.3341455459595 53.1853561401367,14.3364753723145 53.1888618469239,14.3222627639772 53.1934089660646,14.3219137191774 53.1948776245118,14.3168897628785 53.1974182128906,14.3108682632447 53.1988105773926,14.3134574890138 53.2011985778809,14.3110818862916 53.2030181884766,14.3136901855469 53.2055473327637,14.3095655441285 53.2062873840332,14.3097286224365 53.2069664001466,14.3105020523072 53.2089767456056,14.3143682479858 53.2110328674316,14.3162689208984 53.2175827026367,14.3068227767945 53.2188034057618,14.301628112793 53.2222137451172,14.299783706665 53.2248268127442,14.2927932739257 53.2281112670898,14.287320137024 53.2335395812988,14.2826099395752 53.2338905334472)) | 0.0006 | POINT(14.350470251786108 53.209819030761736) |
| 50735 | POLYGON((2.72927522659313 49.5594863891601,2.7340037822724 49.5667381286622,2.7340037822724 49.5667381286622,2.75386667251593 49.5681114196778,2.75386667251593 49.5681114196778,2.76126050949097 49.5648078918458,2.77590966224665 49.5672187805176,2.77590966224665 49.5672187805176,2.78329896926874 49.5679588317872,2.78329896926874 49.5679588317872,2.78417229652405 49.5639991760254,2.78417229652405 49.5639991760254,2.7673015594483 49.5489044189454,2.7673015594483 49.5489044189454,2.74973702430725 49.5563735961915,2.72927522659313 49.5594863891601)) | 0.0006 | POINT(2.7624919096628995 49.563101959228575) |