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 |
---|---|---|---|
22883 | POLYGON((0.242344543337822 44.6378135681153,0.242464393377418 44.6358795166016,0.242464393377418 44.6358795166016,0.229563578963337 44.6403846740723,0.215959772467613 44.6373672485353,0.197482660412845 44.6410446166992,0.180567607283649 44.6480026245118,0.176969841122741 44.6543235778809,0.176969841122741 44.6543235778809,0.182751506567115 44.6613616943361,0.182751506567115 44.6613616943361,0.206060126423893 44.6599273681641,0.224075958132858 44.6490745544435,0.224075958132858 44.6490745544435,0.226458474993819 44.6463050842285,0.239658266305867 44.6473197937012,0.242344543337822 44.6378135681153)) | 0.0006 | POINT(0.2119136517868193 44.647465229034495) |
56820 | POLYGON((5.95028400421148 45.570915222168,5.94025087356573 45.5684928894043,5.94025087356573 45.5684928894043,5.94046783447277 45.5619468688966,5.93636846542353 45.560359954834,5.93000841140747 45.5480194091797,5.93000841140747 45.5480194091797,5.92534542083746 45.5403366088867,5.92534542083746 45.5403366088867,5.93067073822027 45.5345840454103,5.93067073822027 45.5345840454103,5.94636821746826 45.5452842712403,5.94636821746826 45.5452842712403,5.94314193725586 45.5545692443848,5.95073938369762 45.5582618713379,5.95028400421148 45.570915222168)) | 0.0006 | POINT(5.93775259653731 45.55196584065758) |
59305 | POLYGON((9.52915763854975 47.4617576599122,9.5320138931275 47.455722808838,9.52859687805181 47.4542579650879,9.52459144592291 47.4539527893067,9.52459144592291 47.4539527893067,9.52548503875732 47.4486808776857,9.51980876922613 47.4432830810546,9.51990890502941 47.4375000000001,9.52104759216314 47.4346771240236,9.51715373992926 47.4297752380372,9.51715373992926 47.4297752380372,9.51736164093018 47.4269180297852,9.51736164093018 47.4269180297852,9.52049255371094 47.4234504699708,9.52848243713373 47.4240074157715,9.52848243713373 47.4240074157715,9.53646469116217 47.4240264892578,9.5391988754273 47.4258308410644,9.54061126708996 47.4295539855958,9.54227542877203 47.430778503418,9.54837322235107 47.4294319152833,9.54837322235107 47.4294319152833,9.55206489562994 47.4316902160646,9.5615692138673 47.4317970275879,9.5615692138673 47.4317970275879,9.56067371368414 47.4341659545898,9.56067371368414 47.4341659545898,9.5563173294068 47.4369773864747,9.53955841064453 47.4443817138673,9.5418643951416 47.4470977783203,9.54364776611339 47.456298828125,9.54797267913824 47.4623947143555,9.54797077178966 47.4646453857421,9.54797077178966 47.4646453857421,9.54710960388184 47.4652709960938,9.54710960388184 47.4652709960938,9.54343700408936 47.4650726318359,9.5370502471925 47.4622955322267,9.5315265655517 47.46346282959,9.52915763854975 47.4617576599122)) | 0.0006 | POINT(9.537309548793736 47.44254156259396) |
31576 | POLYGON((2.45479440689093 47.4406204223633,2.43499064445496 47.4513206481934,2.42493414878851 47.4510192871094,2.42011737823486 47.4570884704591,2.41113567352301 47.4603271484376,2.39157748222362 47.4608497619629,2.37790298461914 47.4565010070802,2.36392331123363 47.4657249450684,2.36392331123363 47.4657249450684,2.35821747779858 47.4965248107911,2.36250996589672 47.50638961792,2.37192583084118 47.514575958252,2.39118814468395 47.5172882080078,2.41468071937561 47.5306854248047,2.41468071937561 47.5306854248047,2.43815827369684 47.5187759399415,2.4529435634613 47.5166244506837,2.46735286712658 47.5187339782715,2.46750664710999 47.5153045654297,2.46750664710999 47.5153045654297,2.4696896076203 47.5108947753907,2.4696896076203 47.5108947753907,2.47464418411266 47.4974784851075,2.47175645828247 47.487247467041,2.47873711585993 47.4741096496582,2.47833299636847 47.470615386963,2.46697115898127 47.4636955261231,2.47735953331005 47.4520225524902,2.46511507034313 47.4408645629883,2.45479440689093 47.4406204223633)) | 0.0006 | POINT(2.431112618281974 47.48613423314592) |
25946 | POLYGON((1.53316533565533 49.0478019714357,1.53174841403973 49.0466270446778,1.53174841403973 49.0466270446778,1.54645168781281 49.036506652832,1.56189143657696 49.0351371765137,1.56189143657696 49.0351371765137,1.58298408985144 49.042610168457,1.58298408985144 49.042610168457,1.59928178787243 49.0545921325684,1.59928178787243 49.0545921325684,1.59525048732769 49.0604629516603,1.58096826076519 49.062297821045,1.58096826076519 49.062297821045,1.54802000522619 49.041561126709,1.54331088066101 49.0402183532715,1.53316533565533 49.0478019714357)) | 0.0006 | POINT(1.565329758326302 49.047271982828825) |
40616 | POLYGON((1.7397204637528 45.8513908386231,1.72966921329504 45.8434944152831,1.71482646465302 45.8411941528321,1.69488227367407 45.8437995910645,1.67687296867371 45.8376464843751,1.66735339164734 45.8386154174806,1.65991973876953 45.8338012695314,1.65991973876953 45.8338012695314,1.65282809734344 45.845630645752,1.65282809734344 45.845630645752,1.65140211582195 45.8523063659668,1.66356706619274 45.8571586608887,1.66970098018652 45.8663101196289,1.66358983516699 45.871120452881,1.66358983516699 45.871120452881,1.69394075870514 45.8917465209962,1.70341289043427 45.891513824463,1.70854973793024 45.8864021301269,1.70854973793024 45.8864021301269,1.70314764976501 45.8770217895508,1.72577941417705 45.8746681213379,1.7306450605393 45.861572265625,1.72698795795446 45.8552627563477,1.7397204637528 45.8513908386231)) | 0.0006 | POINT(1.6896384125170798 45.85902653569765) |
56012 | POLYGON((4.86645078659069 45.3525733947754,4.84378337860113 45.3523902893066,4.84378337860113 45.3523902893066,4.84398317337048 45.3379859924318,4.84398317337048 45.3379859924318,4.84347677230841 45.3277091979982,4.85305356979376 45.3265686035156,4.85749959945679 45.317081451416,4.85749959945679 45.317081451416,4.87392282485968 45.3218078613282,4.8762059211731 45.3304519653321,4.8762059211731 45.3304519653321,4.87642192840582 45.3429298400879,4.86645078659069 45.3525733947754)) | 0.0006 | POINT(4.858174617473951 45.33441602266756) |
67677 | POLYGON((8.81874465942388 48.6645050048829,8.82609939575195 48.6666336059571,8.83027362823481 48.6633033752443,8.84211826324469 48.6643905639648,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.83845710754395 48.63875579834,8.8379344940185 48.6369743347169,8.83547782897949 48.6373710632324,8.83493232727062 48.635482788086,8.82635402679443 48.6394653320313,8.80917167663574 48.6339874267579,8.80116367340099 48.6336555480958,8.79564285278326 48.6351203918457,8.79564285278326 48.6351203918457,8.79077911376959 48.6382293701171,8.79775142669678 48.643138885498,8.80193901062012 48.6437149047853,8.79738426208502 48.6466598510742,8.79955577850342 48.6482315063477,8.79877281188976 48.6504402160645,8.79947471618658 48.6536445617676,8.79873085021967 48.6586265563965,8.80882167816162 48.6628456115723,8.81874465942388 48.6645050048829)) | 0.0006 | POINT(8.82166869064861 48.646861503864194) |
21615 | POLYGON((0.731526017189026 45.1770248413086,0.727234005928153 45.1779632568359,0.720555186271667 45.1737174987794,0.720555186271667 45.1737174987794,0.711000084877128 45.1753616333008,0.704161286354122 45.1803092956542,0.693339407444114 45.1996269226074,0.688858568668365 45.2010650634766,0.676632940769196 45.1902008056641,0.676632940769196 45.1902008056641,0.673608839511928 45.2000999450685,0.673608839511928 45.2000999450685,0.68298751115799 45.2013015747071,0.688273847103176 45.2102584838868,0.688273847103176 45.2102584838868,0.691742479801235 45.2135925292968,0.691742479801235 45.2135925292968,0.699129700660762 45.2053565979004,0.712724685668888 45.2063217163087,0.720278859138602 45.1979522705078,0.734356939792747 45.1989059448242,0.737974107265472 45.1967391967774,0.737974107265472 45.1967391967774,0.730990409851131 45.1892623901368,0.739702880382652 45.1873970031738,0.739702880382652 45.1873970031738,0.743681013584194 45.1797370910644,0.731526017189026 45.1770248413086)) | 0.0006 | POINT(0.7087870019454026 45.19385924162692) |
63488 | POLYGON((12.0507211685182 53.6035194396974,12.0438327789307 53.6048622131349,12.0425081253052 53.6045837402343,12.0429286956788 53.6014938354493,12.0339784622193 53.6004829406738,12.0335159301759 53.598503112793,12.0371942520141 53.5982589721681,12.036548614502 53.5970878601074,12.0330533981323 53.5969352722169,12.0357742309571 53.5961265563965,12.0350761413575 53.5938720703126,12.0317392349244 53.5947952270508,12.0293684005738 53.5939712524414,12.0293760299684 53.58597946167,12.0254697799683 53.584831237793,12.0296239852906 53.5839996337891,12.0407524108887 53.5847511291504,12.0450792312623 53.5836906433107,12.0462951660157 53.5847434997559,12.0559234619141 53.5832481384278,12.0609216690064 53.5794105529786,12.0604648590089 53.5784568786622,12.0620021820069 53.5779418945312,12.0603828430176 53.5761718749999,12.060996055603 53.5730285644532,12.0624961853027 53.5685348510742,12.0640735626222 53.5666084289551,12.0663661956787 53.5661315917969,12.0651082992554 53.5634765625001,12.0624141693116 53.5624237060548,12.0624790191651 53.561695098877,12.050971031189 53.558162689209,12.0479402542115 53.5582542419434,12.0440740585327 53.5599212646486,12.0401363372804 53.5591087341309,12.038094520569 53.5602951049806,12.0300178527831 53.5593948364258,12.0241270065308 53.5623283386232,12.0232648849488 53.5635871887208,12.0127248764038 53.5639572143554,11.9989700317384 53.5700569152833,11.9911651611329 53.5585861206056,11.986385345459 53.5574111938477,11.9797925949098 53.5592803955079,11.980308532715 53.5558052062989,11.976466178894 53.5532989501953,11.9765968322755 53.5517959594727,11.9855117797852 53.5445442199708,11.9855117797852 53.5445442199708,11.9832620620728 53.5418548583984,11.9829740524293 53.5400085449219,11.9786109924317 53.5386047363281,11.9802570343018 53.5377578735352,11.9785814285278 53.5341567993165,11.9795169830323 53.5332641601562,11.9786796569825 53.5299224853516,11.9755125045776 53.5294837951661,11.9755125045776 53.5294837951661,11.9748468399048 53.5334625244141,11.9726152420045 53.5357284545898,11.9672651290894 53.5376968383789,11.9647111892701 53.5398292541503,11.9637317657472 53.5412368774415,11.9638881683349 53.5436515808105,11.9553213119506 53.5451354980469,11.94539642334 53.5521278381348,11.9426507949829 53.5512351989747,11.9372329711913 53.5535545349122,11.9372329711913 53.5535545349122,11.9388570785523 53.5547294616699,11.9393787384033 53.5531501770021,11.9435119628906 53.5526351928712,11.9459638595582 53.5533103942872,11.9487819671632 53.5563659667969,11.9544715881349 53.5581703186035,11.9532413482667 53.5606651306152,11.9534006118775 53.5636367797852,11.9507379531861 53.5657463073732,11.9496335983277 53.5679702758788,11.9508419036866 53.5698051452637,11.9499330520629 53.57470703125,11.956353187561 53.5752525329591,11.972267150879 53.5743064880372,11.9719572067262 53.5758743286133,11.9732818603515 53.5775413513185,11.9727897644042 53.5790748596193,11.9757080078126 53.5805015563965,11.9721307754518 53.5863952636719,11.967779159546 53.5885963439942,11.9614448547364 53.5893440246583,11.9587106704712 53.5884513854982,11.9507446289064 53.5951080322266,11.9618816375733 53.6046905517579,11.9602937698364 53.6055374145507,11.9650239944458 53.609172821045,11.9591655731201 53.6134033203125,11.9593086242676 53.6145248413086,11.955442428589 53.615047454834,11.9548330307007 53.6162872314453,11.9548330307007 53.6162872314453,11.9593143463135 53.6155967712402,11.9604644775392 53.6179008483887,11.9716491699219 53.6255149841309,11.9731845855713 53.6244354248047,11.9905948638917 53.6260414123535,11.9905948638917 53.6260414123535,11.9924097061157 53.6260643005371,11.9997177124024 53.6218414306641,12.0006694793702 53.6196289062501,12.0084085464478 53.6165618896486,12.0116310119629 53.6161880493165,12.0155963897706 53.6128692626954,12.0237054824829 53.6126708984376,12.0252742767335 53.6117172241212,12.0311336517335 53.6124458312989,12.0338087081909 53.6111717224121,12.0429773330688 53.612720489502,12.0507211685182 53.6035194396974)) | 0.0006 | POINT(11.997180865361184 53.5772427289914) |