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 |
---|---|---|---|
72132 | POLYGON((14.4450063705444 47.6551437377931,14.489881515503 47.6828651428223,14.489881515503 47.6828651428223,14.4893751144409 47.6889266967775,14.4857320785523 47.696346282959,14.4800415039063 47.7023544311523,14.4696683883668 47.7107543945312,14.466802597046 47.714454650879,14.4684371948243 47.7173957824708,14.4772214889527 47.722038269043,14.4819746017457 47.7265739440919,14.4852619171144 47.7324676513672,14.4866437911988 47.7387924194336,14.4858932495117 47.7428855895996,14.4831457138062 47.7489814758301,14.4689435958862 47.7710456848146,14.4689435958862 47.7710456848146,14.4499073028565 47.7793846130372,14.4439229965211 47.7829093933105,14.4417600631714 47.7857971191407,14.4393453598023 47.7939071655273,14.4364814758302 47.79443359375,14.4272108078003 47.7925758361818,14.4232234954833 47.792751312256,14.4193410873414 47.7957572937012,14.4151506423951 47.8014602661134,14.4151506423951 47.8014602661134,14.3412952423095 47.8007888793946,14.3314142227173 47.7999076843262,14.3281879425049 47.798152923584,14.3260374069215 47.7945442199707,14.3236408233643 47.7829055786133,14.3236408233643 47.7829055786133,14.3774528503418 47.7671928405763,14.3858432769776 47.7634010314943,14.3863286972046 47.7625007629395,14.385316848755 47.7604370117189,14.37415599823 47.7516136169434,14.3675270080566 47.74369430542,14.359751701355 47.739818572998,14.3510837554932 47.7369270324707,14.3510837554932 47.7369270324707,14.3385972976685 47.726734161377,14.3389272689819 47.7248306274414,14.3428487777711 47.7194023132324,14.3428487777711 47.7194023132324,14.3661527633667 47.7220649719238,14.3867206573486 47.7084617614747,14.3867206573486 47.7084617614747,14.3974714279175 47.7054901123048,14.4077501296997 47.7061843872071,14.4106483459473 47.7054710388184,14.4255342483521 47.6961288452149,14.4328308105469 47.6894149780274,14.4335718154908 47.6852378845215,14.432291984558 47.6804962158204,14.4217109680176 47.6571197509766,14.4217109680176 47.6571197509766,14.4450063705444 47.6551437377931)) | 0.0006 | POINT(14.41436974755652 47.738950203205015) |
34409 | POLYGON((4.99416828155529 48.4042282104492,5.00089502334606 48.4012794494629,5.00895071029663 48.4030685424805,5.00895071029663 48.4030685424805,5.02145814895636 48.4014434814454,5.02721166610723 48.3967933654786,5.02721166610723 48.3967933654786,5.01203346252453 48.3759117126465,5.01203346252453 48.3759117126465,4.99793767929089 48.3725395202637,4.97458505630499 48.3546066284179,4.97458505630499 48.3546066284179,4.97327518463146 48.355323791504,4.97327518463146 48.355323791504,4.97443437576294 48.3646278381347,4.97140741348267 48.3739471435547,4.96709680557257 48.3753509521486,4.96709680557257 48.3753509521486,4.97527360916149 48.3797760009767,4.97868299484264 48.3899726867677,4.99416828155529 48.4042282104492)) | 0.0006 | POINT(4.992028164863657 48.38049621582035) |
40190 | POLYGON((1.77281260490417 42.5737266540527,1.76031410694122 42.5408515930176,1.76352632045757 42.5269546508789,1.77249884605419 42.5256996154785,1.78174257278454 42.5376472473146,1.79939651489258 42.5428886413574,1.8277895450592 42.5427207946778,1.84108376502991 42.5332641601563,1.85472822189331 42.5305252075195,1.85472822189331 42.5305252075195,1.86083769798279 42.5214195251466,1.85159468650818 42.5143165588379,1.86548101902014 42.5013656616211,1.86548101902014 42.5013656616211,1.84336221218103 42.4771537780763,1.84568166732794 42.4730262756348,1.84568166732794 42.4730262756348,1.83886194229132 42.4790115356446,1.83031678199768 42.4832000732423,1.81906986236578 42.4842071533203,1.81698000431066 42.4831047058107,1.80524814128881 42.4886550903321,1.80029773712164 42.4884033203125,1.79252004623424 42.4853401184083,1.77989852428436 42.4873695373535,1.76676630973816 42.487087249756,1.76676630973816 42.487087249756,1.76285898685461 42.4875221252441,1.74660325050365 42.4948234558105,1.7309360504151 42.4924507141114,1.72628200054174 42.5049133300782,1.72194194793701 42.5012283325196,1.72137904167175 42.5015983581544,1.72444903850555 42.5094299316407,1.72401058673859 42.5202484130859,1.72471797466284 42.5231666564943,1.73269295692444 42.539608001709,1.73871898651123 42.565528869629,1.74537801742559 42.5686111450196,1.77281260490417 42.5737266540527)) | 0.0006 | POINT(1.7903444919831044 42.510489048102) |
35439 | POLYGON((9.36484622955322 42.3713493347167,9.3605890274049 42.3698921203613,9.3605890274049 42.3698921203613,9.33133697509771 42.3598442077637,9.33133697509771 42.3598442077637,9.33391761779797 42.3471908569337,9.33930873870855 42.3421020507812,9.33930873870855 42.3421020507812,9.36484622955322 42.3713493347167)) | 0.0006 | POINT(9.34515416622169 42.35777711868285) |
1404922 | POLYGON((-4.43558120727539 40.2593231201172,-4.44946718215942 40.2731323242189,-4.46843004226685 40.2808494567872,-4.47641086578358 40.2833518981935,-4.48301601409906 40.2792205810548,-4.49350881576538 40.2787704467773,-4.49422311782837 40.280704498291,-4.50626611709589 40.2822608947754,-4.48781394958496 40.2920684814453,-4.4796290397644 40.2981452941895,-4.4765157699585 40.2983932495117,-4.47422313690186 40.3006477355958,-4.47580289840687 40.3040428161621,-4.46691417694086 40.308650970459,-4.46653985977173 40.3142051696778,-4.46897888183594 40.3165702819824,-4.47142887115473 40.3166465759278,-4.47235202789307 40.3195724487305,-4.46469402313227 40.3186683654785,-4.45541095733637 40.3199234008789,-4.45361995697021 40.3329772949219,-4.44491100311279 40.3291893005371,-4.41711521148682 40.332332611084,-4.4078431129455 40.3303451538087,-4.38109111785877 40.3183479309082,-4.38011121749878 40.3141403198243,-4.38798999786371 40.3013000488282,-4.38370990753168 40.2996482849121,-4.38553094863886 40.292552947998,-4.38395404815674 40.2891578674316,-4.3929448127746 40.2869148254395,-4.39887714385975 40.2837524414063,-4.40836286544794 40.2742805480957,-4.41962194442749 40.2654495239258,-4.42610788345337 40.2623672485352,-4.42737579345703 40.2578468322754,-4.43558120727539 40.2593231201172)) | 0.0006 | POINT(-4.443510386678877 40.29710419972741) |
1407480 | POLYGON((-7.48543405532837 39.5841789245605,-7.48857593536371 39.5868721008301,-7.49303913116449 39.5857925415039,-7.49515199661249 39.586181640625,-7.49717378616333 39.5889854431153,-7.49957895278925 39.5897941589356,-7.49891185760492 39.5934219360352,-7.50002288818359 39.5945663452148,-7.50013780593872 39.599449157715,-7.5039181709289 39.6008491516114,-7.50459909439087 39.6043243408203,-7.5078039169311 39.606731414795,-7.51006317138672 39.6187858581544,-7.51391887664795 39.6213340759277,-7.51549100875854 39.6236534118652,-7.52065181732172 39.6262168884278,-7.52739191055298 39.6348686218263,-7.52731609344482 39.6373252868653,-7.52474403381342 39.6427726745606,-7.52689313888538 39.6451683044435,-7.52758312225342 39.6475410461426,-7.52680778503418 39.650806427002,-7.52756118774408 39.6559181213379,-7.5317440032959 39.6584014892579,-7.53209495544428 39.662181854248,-7.53720617294306 39.6614418029785,-7.54168510437012 39.6636772155761,-7.54090595245361 39.6645622253419,-7.53470993041987 39.6669464111329,-7.5304799079895 39.6672554016114,-7.51662683486938 39.6657447814943,-7.49184703826899 39.6657791137696,-7.48204898834229 39.6644248962403,-7.47690391540527 39.6627616882324,-7.45552778244013 39.6623573303223,-7.43970394134516 39.65877532959,-7.42619323730463 39.6514358520508,-7.44272899627686 39.639778137207,-7.4401922225951 39.6381797790527,-7.44300508499146 39.6375236511232,-7.44161701202393 39.6360282897949,-7.44265222549433 39.6334571838379,-7.43882513046265 39.6328125,-7.43949508666992 39.6303710937501,-7.44203901290894 39.6315345764161,-7.44309377670282 39.6303787231446,-7.44140720367432 39.6293182373047,-7.44294309616083 39.628932952881,-7.43930578231812 39.6272201538086,-7.43895721435541 39.6285285949708,-7.43645191192627 39.6286964416504,-7.43983697891235 39.6244163513184,-7.44311714172358 39.6238403320313,-7.44062089920044 39.6232337951661,-7.44521999359125 39.6192207336427,-7.44111490249628 39.6181983947754,-7.43909597396845 39.6110534667969,-7.44325113296509 39.6024932861329,-7.44443607330311 39.5877075195313,-7.44722414016724 39.5812492370607,-7.46576881408691 39.5750160217285,-7.46690893173218 39.5769500732423,-7.47187185287476 39.5786056518555,-7.4789137840271 39.5787582397461,-7.47965288162231 39.5801544189454,-7.48543405532837 39.5841789245605)) | 0.0006 | POINT(-7.481233765528725 39.625152940016555) |
52387 | POLYGON((-0.0615995414554504 45.753719329834,-0.0795318260788918 45.7493324279785,-0.0860279202460674 45.754093170166,-0.0845343694090275 45.7607727050782,-0.103139035403672 45.7612380981445,-0.103139035403672 45.7612380981445,-0.106886364519596 45.7688026428223,-0.106886364519596 45.7688026428223,-0.111323460936546 45.770076751709,-0.109659448266029 45.7800903320312,-0.118201099336034 45.7831001281739,-0.123147211968899 45.7887916564941,-0.123147211968899 45.7887916564941,-0.102460630237942 45.7959251403809,-0.0954627320170403 45.8041534423828,-0.0954627320170403 45.8041534423828,-0.0765527337788967 45.807716369629,-0.0625920444726376 45.805763244629,-0.0522800460457233 45.8129196166992,-0.0522800460457233 45.8129196166992,-0.0444707088172436 45.8154907226564,-0.0413221791386604 45.8133125305177,-0.0436073765157516 45.8042755126954,-0.0436073765157516 45.8042755126954,-0.0421787090599537 45.7872390747071,-0.0356735810637474 45.7783317565919,-0.0472663268446922 45.7676277160645,-0.0450067631900311 45.7609748840333,-0.0615995414554504 45.753719329834)) | 0.0006 | POINT(-0.07848024554547198 45.784426007952035) |
61113 | POLYGON((7.20172214508057 46.0371513366699,7.20167303085339 46.0310707092286,7.20327901840221 46.0273857116699,7.20282220840454 46.020923614502,7.17843818664545 46.0238189697267,7.17018318176281 46.0236892700195,7.15955686569214 46.0200920104982,7.15384721755993 46.0132751464844,7.14838695526123 46.0087928771973,7.15113210678106 46.0020942687989,7.15127277374268 45.9955940246583,7.14988088607799 45.9920654296876,7.1496849060058 45.9861717224121,7.14831686019903 45.9836654663087,7.14653587341309 45.972110748291,7.14362096786505 45.966510772705,7.14509296417248 45.9605865478516,7.1433429718017 45.9550704956055,7.13913679122936 45.9511032104493,7.13557100296026 45.9379005432128,7.1300830841065 45.9333610534668,7.12814617156982 45.9300308227539,7.12890481948853 45.9280395507814,7.13266181945795 45.9250984191896,7.13337707519526 45.9214591979982,7.13516092300409 45.9189758300781,7.1423768997193 45.9168395996094,7.1423768997193 45.9168395996094,7.1471409797669 45.9202384948731,7.15369892120373 45.9222030639648,7.16160821914673 45.929141998291,7.16532993316656 45.9383926391602,7.16974687576294 45.9440956115723,7.16845178604126 45.949089050293,7.17453098297125 45.9609489440919,7.17876386642462 45.963176727295,7.18640279769897 45.9621086120607,7.19321584701532 45.9635467529298,7.19600582122808 45.9707336425782,7.20002222061163 45.9717178344728,7.20674085617065 45.9756050109864,7.21116209030163 45.9757919311523,7.21440601348877 45.9728546142579,7.21636581420904 45.9725761413575,7.21930599212652 45.9728088378907,7.21591901779175 45.9757957458497,7.22047615051275 45.9758682250977,7.22619390487677 45.9696922302247,7.23328685760504 45.9671783447265,7.24484586715704 45.9669303894043,7.25272417068481 45.9652404785157,7.25824499130255 45.9667778015137,7.26536178588873 45.9645881652833,7.26536178588873 45.9645881652833,7.26735877990723 45.9670715332032,7.27297687530518 45.9684600830079,7.27394199371349 45.9701957702637,7.27358722686773 45.9754486083984,7.2677497863769 45.9840354919435,7.26658010482794 45.9877510070801,7.24507617950434 45.995174407959,7.23965692520147 46.0017433166505,7.23690605163569 46.0096778869629,7.23388910293579 46.0122451782227,7.22783517837536 46.0137748718263,7.22045707702648 46.0209426879884,7.21306276321423 46.0239753723145,7.20848083496105 46.0290908813477,7.20751476287842 46.0332336425781,7.20172214508057 46.0371513366699)) | 0.0006 | POINT(7.19270973620211 45.974988799164294) |
15084 | POLYGON((7.99008703231817 44.1456756591797,7.98070287704468 44.1394386291505,7.98000001907354 44.1344795227052,7.98000001907354 44.1344795227052,7.98957014083868 44.1343193054199,7.9925150871278 44.1332511901856,7.9922890663147 44.1288833618163,7.99384021759039 44.1280860900879,8.00699138641369 44.1271286010743,8.01394939422607 44.1206359863282,8.00984287261963 44.1183013916016,8.00419044494629 44.1179389953613,8.00487899780279 44.115306854248,8.01254463195801 44.1119003295898,8.01665210723877 44.111671447754,8.01665210723877 44.111671447754,8.01916885375982 44.1134681701661,8.02278327941906 44.1087379455568,8.02165317535395 44.1022834777832,8.02328109741211 44.0974807739258,8.02904510498058 44.0966377258301,8.02904510498058 44.0966377258301,8.03746128082287 44.101921081543,8.04428958892828 44.1028976440431,8.0473051071167 44.1003036499023,8.0473051071167 44.1003036499023,8.05335712432873 44.1053657531738,8.05633163452154 44.1107559204101,8.05624198913586 44.1119003295898,8.04588890075689 44.1225090026855,8.04872703552246 44.1343193054199,8.05156803131115 44.1367263793945,8.05156803131115 44.1367263793945,8.04400825500488 44.1437950134278,8.04400825500488 44.1437950134278,8.04127788543707 44.1468696594239,8.02984237670904 44.1550636291505,8.01759624481207 44.1568756103517,8.01050186157227 44.1565818786622,8.00697135925299 44.1551933288575,7.99008703231817 44.1456756591797)) | 0.0006 | POINT(8.021598327159928 44.12375793457034) |
18468 | POLYGON((8.73951911926275 40.1804351806642,8.73056697845453 40.1749458312989,8.71638584136969 40.1620826721191,8.7254371643067 40.1480751037598,8.72943305969244 40.1438522338867,8.73388767242432 40.1424102783204,8.73653125762945 40.1390762329103,8.73764324188238 40.1366271972656,8.73732280731213 40.1315536499024,8.73732280731213 40.1315536499024,8.76733398437506 40.1180229187012,8.76750373840332 40.1161689758301,8.7717866897583 40.1127243041993,8.78979873657238 40.1048698425293,8.78979873657238 40.1048698425293,8.80050086975098 40.1082038879395,8.81342697143566 40.1142044067383,8.82424068450928 40.1207084655762,8.83245658874512 40.1295318603517,8.83245658874512 40.1295318603517,8.82901096344006 40.1324844360352,8.81229877471935 40.1403312683105,8.78882503509527 40.1542472839355,8.78668022155762 40.1568298339843,8.77503299713146 40.163932800293,8.73951911926275 40.1804351806642)) | 0.0006 | POINT(8.772208061218315 40.13589096069339) |