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 |
---|---|---|---|
42013 | POLYGON((5.53144884109508 49.375545501709,5.52739953994751 49.369083404541,5.51856374740595 49.3652458190918,5.51339435577387 49.3518562316896,5.50149869918823 49.3453025817872,5.49770498275763 49.3320541381837,5.49770498275763 49.3320541381837,5.49929141998297 49.3139610290527,5.49929141998297 49.3139610290527,5.51505088806158 49.3138389587403,5.51505088806158 49.3138389587403,5.54218626022345 49.3385696411134,5.56787300109858 49.350269317627,5.57835865020758 49.3512763977052,5.57835865020758 49.3512763977052,5.5643973350526 49.3559455871583,5.54519891738897 49.3761901855468,5.54519891738897 49.3761901855468,5.53144884109508 49.375545501709)) | 0.0006 | POINT(5.529887305365707 49.34591441684303) |
55393 | POLYGON((6.21425247192388 46.1937904357911,6.22746849060064 46.2019309997559,6.22746849060064 46.2019309997559,6.23011589050299 46.2035598754883,6.23011589050299 46.2035598754883,6.2335515022279 46.1979942321778,6.2335515022279 46.1979942321778,6.21661853790295 46.1878929138184,6.21661853790295 46.1878929138184,6.21767473220831 46.1928482055664,6.21425247192388 46.1937904357911)) | 0.0006 | POINT(6.224743604660116 46.19693946838383) |
52196 | POLYGON((0.00499540567403756 45.7676734924317,-0.00195143790915608 45.757137298584,-0.00195143790915608 45.757137298584,0.00584598444413587 45.7531700134278,0.0199670176953077 45.7281150817871,0.0199670176953077 45.7281150817871,0.0262300670148079 45.7229118347169,0.0519267916680519 45.7382659912111,0.0519267916680519 45.7382659912111,0.0531878583134358 45.7544364929199,0.081562079489288 45.7680244445801,0.081562079489288 45.7680244445801,0.0865952447057907 45.7731742858887,0.0739939734340282 45.7769660949707,0.0739939734340282 45.7769660949707,0.0676810815930935 45.7770195007325,0.0676810815930935 45.7770195007325,0.0617766492068768 45.7725372314454,0.0335623770953362 45.7701606750489,0.0335623770953362 45.7701606750489,0.00499540567403756 45.7676734924317)) | 0.0006 | POINT(0.04460574877454917 45.758764076232964) |
12583 | POLYGON((13.6876039505005 42.8192176818848,13.7003641128541 42.8237609863282,13.7118043899536 42.8443183898927,13.7074899673462 42.8499031066894,13.7074899673462 42.8499031066894,13.7234039306642 42.8563117980958,13.7234039306642 42.8563117980958,13.721794128418 42.8446731567383,13.7257261276246 42.8361282348633,13.7285814285278 42.8323402404786,13.7480039596558 42.8150596618652,13.7518672943115 42.8145599365234,13.7518672943115 42.8145599365234,13.7594461441041 42.8105087280275,13.7594461441041 42.8105087280275,13.757040977478 42.8023529052734,13.757040977478 42.8023529052734,13.7456216812134 42.80521774292,13.734341621399 42.8066596984863,13.7277965545654 42.8043556213379,13.7154397964479 42.80521774292,13.7135038375855 42.8071937561035,13.7123870849609 42.8109169006348,13.7092628479004 42.8140907287598,13.7004356384278 42.8150978088379,13.6914777755737 42.8089332580566,13.6830358505249 42.7998695373536,13.6674709320069 42.7929687499999,13.6623315811158 42.79598236084,13.6609449386598 42.7979278564453,13.6611347198486 42.8050003051758,13.6645088195801 42.8080825805664,13.6645088195801 42.8080825805664,13.6664400100709 42.8111076354981,13.6773719787599 42.8160972595216,13.6876039505005 42.8192176818848)) | 0.0006 | POINT(13.710868263244663 42.817016383579826) |
19784 | POLYGON((7.01060390472418 45.7903900146484,7.00726079940802 45.788387298584,6.99651193618774 45.7616386413575,6.98726987838739 45.7493896484375,6.97453784942633 45.7413330078126,6.97453784942633 45.7413330078126,6.96840906143188 45.7352294921876,6.96590614318859 45.7305412292482,6.96198606491095 45.7273559570313,6.95470380783092 45.7244262695312,6.95014810562128 45.7242736816407,6.93251895904552 45.7287368774415,6.92877388000483 45.7320175170898,6.92765617370611 45.7393035888672,6.91844320297247 45.7516822814942,6.91159009933483 45.753044128418,6.89806222915661 45.7592735290528,6.89534616470348 45.7631034851075,6.89534616470348 45.7631034851075,6.90219593048096 45.7642555236817,6.92205476760859 45.7724571228028,6.94947814941418 45.7804718017578,6.97363805770874 45.7835845947266,6.99521493911743 45.7892227172851,7.01060390472418 45.7903900146484)) | 0.0006 | POINT(6.950091421604202 45.75393978754684) |
57915 | POLYGON((8.10235881805431 49.6982765197754,8.09057807922363 49.6952285766603,8.08962154388433 49.6965827941895,8.085192680359 49.6955451965333,8.08471107482916 49.6965599060059,8.08100318908686 49.6957893371582,8.08083820343029 49.6968574523927,8.07653045654308 49.6964225769044,8.07591533660889 49.6984176635743,8.05933380126959 49.6951332092286,8.05710792541515 49.6992912292481,8.05710792541515 49.6992912292481,8.05079460144043 49.6982002258302,8.04251861572271 49.6951713562013,8.0381355285644 49.6902770996095,8.04322719573975 49.6883163452149,8.04322719573975 49.6883163452149,8.05047512054443 49.6887817382814,8.05475902557373 49.6802864074708,8.05475902557373 49.6802864074708,8.06188678741461 49.6818313598633,8.07356071472174 49.6822357177735,8.07356071472174 49.6822357177735,8.0800924301148 49.6822929382325,8.07963943481451 49.6830062866212,8.09977436065674 49.689525604248,8.09849739074718 49.6914520263673,8.10381126403809 49.6928520202638,8.10381126403809 49.6928520202638,8.10564517974854 49.6933593750001,8.10235881805431 49.6982765197754)) | 0.0006 | POINT(8.07328249613448 49.691489156087314) |
15443 | POLYGON((10.4365520477295 45.722625732422,10.4277505874635 45.7236900329591,10.4210958480835 45.7323341369629,10.4210958480835 45.7323341369629,10.4231662750245 45.7333984375,10.4253396987915 45.7380065917969,10.4226903915406 45.7429771423339,10.4159402847289 45.7485084533691,10.4097681045533 45.7505187988281,10.4034757614136 45.7508201599121,10.4008884429933 45.7522315979004,10.3984775543213 45.7540435791016,10.3953952789307 45.7608680725099,10.4000959396363 45.7693977355958,10.4025669097902 45.772029876709,10.3990526199342 45.7878227233887,10.3957118988037 45.7895317077637,10.3826255798341 45.7920455932618,10.3826255798341 45.7920455932618,10.3850574493409 45.795166015625,10.3881425857545 45.7971458435058,10.4006576538085 45.802619934082,10.4033918380738 45.8028297424318,10.4033918380738 45.8028297424318,10.4393339157104 45.7973861694337,10.4393339157104 45.7973861694337,10.4384317398072 45.7928352355958,10.4422121047974 45.7742538452149,10.4448747634888 45.7727813720704,10.4524049758912 45.7715415954591,10.4603939056397 45.7726173400879,10.4685602188111 45.7711181640625,10.4752130508424 45.7673530578614,10.4779891967774 45.7628974914551,10.4779891967774 45.7628974914551,10.4692821502685 45.7564582824708,10.4564809799195 45.7433547973633,10.4470062255859 45.7363281250001,10.4445533752442 45.733425140381,10.4442167282104 45.7313423156738,10.4442167282104 45.7313423156738,10.4365520477295 45.722625732422)) | 0.0006 | POINT(10.42603534605449 45.76393025095873) |
1397672 | POLYGON((-2.99096393585199 41.2033233642579,-2.99320697784424 41.2050895690919,-2.99331188201904 41.2193145751954,-2.98249888420099 41.2344818115234,-2.98083591461176 41.2490730285644,-2.98797202110291 41.2590827941895,-2.99426198005676 41.2616500854493,-2.99293804168701 41.2639389038087,-3.00116300582886 41.2692642211915,-3.00591492652887 41.2844047546387,-2.97915101051331 41.2907638549805,-2.96736407279968 41.291919708252,-2.96604895591736 41.2932357788086,-2.95005798339844 41.2926445007325,-2.93366909027094 41.2845191955568,-2.93308091163635 41.2751159667969,-2.929771900177 41.2660713195801,-2.92645311355585 41.2645645141603,-2.92150688171387 41.2683792114259,-2.91669392585754 41.2594337463379,-2.91389107704163 41.2590866088867,-2.91006588935852 41.2531471252442,-2.89835810661316 41.2453536987304,-2.90052294731134 41.2407836914063,-2.90937805175776 41.2424201965332,-2.91402506828302 41.2462539672853,-2.92932009696955 41.2515869140626,-2.93435502052307 41.2435264587403,-2.95282697677612 41.2287445068361,-2.96232891082764 41.2230377197265,-2.97317290306086 41.219940185547,-2.97428488731379 41.2159080505371,-2.96675109863281 41.2041664123536,-2.96637201309198 41.1982040405275,-2.98549199104309 41.1957931518555,-2.98793506622314 41.1976509094239,-2.9855968952179 41.2002716064454,-2.98874592781061 41.2003517150879,-2.99010491371149 41.2012901306153,-2.98882889747614 41.2024612426758,-2.99096393585199 41.2033233642579)) | 0.0006 | POINT(-2.95948055386541 41.242656230926556) |
1390910 | POLYGON((-3.64653897285461 43.4399452209473,-3.64931511878962 43.4441642761231,-3.65500402450556 43.4480934143066,-3.65551900863647 43.4566802978517,-3.63944697380066 43.4657211303711,-3.63703989982605 43.4685783386231,-3.64258003234863 43.4721603393556,-3.64710903167719 43.4783630371094,-3.6465868949889 43.4839019775391,-3.64905309677124 43.4843940734864,-3.65458202362049 43.4934730529785,-3.65180611610413 43.4934730529785,-3.65041589736938 43.4954147338868,-3.64652800559998 43.4959716796876,-3.64652800559998 43.4976387023925,-3.64513993263239 43.4979171752931,-3.64430594444275 43.4993057250977,-3.64319300651545 43.4984741210939,-3.6398611068725 43.4990272521973,-3.63763904571528 43.4979171752931,-3.63458299636835 43.4979171752931,-3.63430500030512 43.4968070983887,-3.628751039505 43.4968070983887,-3.62680602073669 43.4970817565918,-3.6251380443573 43.4987487792969,-3.62374997138971 43.4979362487794,-3.62263798713684 43.500415802002,-3.61958408355713 43.4965286254883,-3.61652803421021 43.5015258789064,-3.61402702331532 43.5001373291016,-3.61569595336903 43.4968070983887,-3.61458301544189 43.495418548584,-3.61291694641113 43.4968070983887,-3.60930490493774 43.5037498474121,-3.60736107826222 43.504306793213,-3.60347294807434 43.5093040466309,-3.60041594505304 43.5098609924316,-3.59763789176935 43.5131950378419,-3.59375 43.5126380920411,-3.59319400787348 43.5140266418458,-3.58652710914612 43.5137481689454,-3.58597111701954 43.514862060547,-3.58430504798889 43.5123596191407,-3.58263897895813 43.5134735107422,-3.57986092567438 43.5131950378419,-3.58180499076843 43.5098609924316,-3.57958292961115 43.5081939697267,-3.58097290992731 43.5068054199219,-3.58069491386408 43.5045852661134,-3.58680510520935 43.5018043518068,-3.58680510520935 43.4934730529785,-3.59069395065302 43.4906959533692,-3.59069395065302 43.4893074035645,-3.59208393096924 43.4884719848633,-3.59180593490601 43.4859733581544,-3.59513807296753 43.4848594665527,-3.59291601181025 43.4806938171387,-3.58902788162231 43.481803894043,-3.5895841121673 43.4793052673341,-3.58791804313648 43.4781951904297,-3.58708310127258 43.4789772033691,-3.58377003669733 43.4777030944825,-3.58756899833674 43.4754333496094,-3.58617401123047 43.4654388427735,-3.58689904212952 43.4636611938477,-3.58807706832886 43.4653396606445,-3.59122490882868 43.4648437500001,-3.59155702590937 43.463565826416,-3.60708999633783 43.4591789245605,-3.60430002212519 43.4534225463868,-3.60994291305536 43.4454498291017,-3.60911798477173 43.4334526062012,-3.61207604408264 43.4326248168946,-3.62873911857605 43.4347038269042,-3.64653897285461 43.4399452209473)) | 0.0006 | POINT(-3.6125957611444512 43.486704027330575) |
69827 | POLYGON((10.0413656234741 54.2683792114258,10.0398912429811 54.2699699401855,10.0369110107423 54.2704086303712,10.0352287292481 54.2727546691895,10.0313329696656 54.274024963379,10.028039932251 54.2735443115234,10.0273094177246 54.2757682800294,10.0273094177246 54.2757682800294,10.0255851745605 54.2762832641602,10.0249795913696 54.2811393737794,10.0267724990845 54.2854919433595,10.0215034484864 54.286003112793,10.0123691558837 54.2889556884766,10.0102319717408 54.29061126709,10.0110321044922 54.2917518615723,10.0105285644532 54.2928466796876,10.0020599365234 54.2951202392579,10.0020599365234 54.2951202392579,10.0124607086182 54.2997856140137,10.0169830322266 54.2990036010743,10.0201225280762 54.2996711730958,10.0303688049316 54.299072265625,10.0310688018798 54.2982940673828,10.0303239822389 54.2975730895997,10.0345935821534 54.2974472045899,10.0363187789918 54.2954063415528,10.0423679351807 54.2938652038574,10.0452814102173 54.2942085266113,10.0462131500245 54.2960319519044,10.0462131500245 54.2960319519044,10.0514211654663 54.2956924438477,10.0522632598877 54.2973823547364,10.0522632598877 54.2973823547364,10.0593900680542 54.2969703674317,10.0598478317262 54.2941970825196,10.05784034729 54.2923851013184,10.0576362609863 54.2883682250976,10.0640144348145 54.2874870300294,10.0669107437133 54.284927368164,10.069501876831 54.2850799560548,10.069501876831 54.2850799560548,10.0684242248536 54.2808303833008,10.0657215118409 54.2810707092285,10.062297821045 54.2797203063965,10.0616340637206 54.2770881652832,10.0557117462158 54.2755661010743,10.0548963546754 54.274326324463,10.0496501922609 54.2742004394532,10.0488014221193 54.2732353210449,10.0433320999147 54.2724609375001,10.0413656234741 54.2683792114258)) | 0.0006 | POINT(10.039557743072542 54.28647567749025) |