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 |
---|---|---|---|
33279 | POLYGON((4.24900436401367 49.8569564819337,4.23366975784302 49.8486862182617,4.23017024993908 49.8360900878906,4.23017024993908 49.8360900878906,4.23750114440924 49.8318977355958,4.2470955848695 49.8328704833984,4.25575733184814 49.8252792358399,4.25575733184814 49.8252792358399,4.28167343139648 49.8302383422852,4.28167343139648 49.8302383422852,4.28172874450689 49.8396377563478,4.27620744705206 49.8449516296387,4.27620744705206 49.8449516296387,4.2547721862793 49.8518867492676,4.24900436401367 49.8569564819337)) | 0.0006 | POINT(4.256527764456652 49.838218144008124) |
50117 | POLYGON((3.87046027183533 50.0157165527343,3.86703848838818 50.0145187377931,3.84493613243114 50.0232620239258,3.81332778930675 50.0222625732422,3.81582736968994 50.0390434265138,3.81582736968994 50.0390434265138,3.83705854415894 50.0478096008302,3.83705854415894 50.0478096008302,3.84812402725214 50.0405311584473,3.86877107620234 50.0376091003418,3.88231921195978 50.0323677062989,3.88332080841076 50.0290184020996,3.87832355499273 50.0278854370118,3.87832355499273 50.0278854370118,3.87046027183533 50.0157165527343)) | 0.0006 | POINT(3.8529083388192604 50.03176879882818) |
19196 | POLYGON((9.76150226593018 44.3910064697266,9.77949523925781 44.3812065124512,9.79211139678966 44.3815689086915,9.8067131042481 44.3783073425293,9.82956981658941 44.3787307739259,9.84638023376465 44.3834838867189,9.84959983825684 44.38138961792,9.85097980499273 44.3795814514161,9.85131072998058 44.3765525817871,9.85035514831537 44.3686294555663,9.84662914276134 44.3677825927735,9.83843326568604 44.3693923950195,9.83791160583507 44.3706665039063,9.83700561523449 44.3705101013184,9.8318920135498 44.368278503418,9.8244314193725 44.3622817993165,9.82000446319574 44.3453254699707,9.82045173645031 44.3388328552246,9.82776927947992 44.3250122070312,9.82990455627441 44.322910308838,9.82990455627441 44.322910308838,9.81824493408209 44.3146133422853,9.81516361236572 44.3111228942871,9.81520843505865 44.2981338500977,9.8220729827882 44.2934455871582,9.82079792022705 44.290943145752,9.8158073425293 44.2871704101564,9.8158073425293 44.2871704101564,9.81414604187012 44.2856788635254,9.80721378326422 44.2835884094239,9.79158687591564 44.2926635742189,9.78482913970947 44.2977714538574,9.78482913970947 44.2977714538574,9.76530265808105 44.3083534240723,9.76076126098638 44.3176918029786,9.75413227081305 44.3236885070802,9.74340629577637 44.3280334472656,9.73557472229015 44.32958984375,9.73048210144049 44.329288482666,9.73048210144049 44.329288482666,9.72504615783697 44.338882446289,9.71940898895275 44.3517036437989,9.71848678588879 44.3562927246094,9.71217823028576 44.3645324707032,9.70732879638683 44.3671455383302,9.69166088104254 44.3662147521974,9.68772888183594 44.3668975830079,9.68772888183594 44.3668975830079,9.69101619720465 44.3700904846191,9.71792602539068 44.3841323852539,9.7264604568482 44.3831405639648,9.73310184478771 44.3803329467773,9.74376869201672 44.3813476562501,9.74538898468029 44.3824157714844,9.74397945404053 44.389015197754,9.74487590789801 44.3904418945312,9.76150226593018 44.3910064697266)) | 0.0006 | POINT(9.781862310000875 44.346604483468234) |
39999 | POLYGON((3.95063948631287 44.4338836669922,3.92365932464611 44.4259223937989,3.92365932464611 44.4259223937989,3.92260146141052 44.4326934814454,3.91241478919989 44.4398880004883,3.91355156898504 44.4558029174804,3.91658473014837 44.4583740234376,3.93555283546448 44.4599151611329,3.93555283546448 44.4599151611329,3.94322347641003 44.4548149108887,3.94322347641003 44.4548149108887,3.95063948631287 44.4338836669922)) | 0.0006 | POINT(3.929151209917994 44.445631547407714) |
64026 | POLYGON((13.6229228973389 52.0732116699219,13.6287975311279 52.0715332031251,13.6366291046143 52.0666999816895,13.6478109359742 52.0569190979004,13.6478109359742 52.0569190979004,13.6529541015625 52.0481491088868,13.6370306015014 52.0349655151368,13.6410360336303 52.0240898132324,13.6378917694092 52.025993347168,13.6368465423584 52.0217628479005,13.6351194381714 52.0218963623047,13.6349277496338 52.0199661254882,13.6398220062257 52.0187187194824,13.6395120620729 52.0170364379883,13.6468706130983 52.0139503479003,13.6468381881715 52.0120086669922,13.6426258087158 52.0101737976074,13.6333694458008 52.0102920532227,13.6333694458008 52.0102920532227,13.6146259307861 52.0097122192383,13.6087312698365 52.0075798034669,13.6030921936036 52.0079002380371,13.5965251922609 52.0065841674806,13.5907211303711 52.004680633545,13.5914039611816 52.0009994506837,13.5605201721191 51.9987640380861,13.560700416565 51.9949607849122,13.5442733764649 51.9895362854003,13.5259466171265 51.9872970581056,13.5155649185182 51.9766845703125,13.5124168395996 51.9754905700684,13.5027379989625 51.9686470031739,13.4918842315674 51.9656257629395,13.4918842315674 51.9656257629395,13.4836587905884 51.9666404724122,13.4590883255005 51.9729347229005,13.4533996582031 51.9730834960938,13.4507503509522 51.9713516235352,13.4465274810792 51.9747772216797,13.4350957870483 51.9754028320313,13.4309453964234 51.9770431518554,13.4148387908936 51.9761505126953,13.4148387908936 51.9761505126953,13.4090967178346 51.9741325378418,13.4090042114258 51.9733695983887,13.3915920257568 51.9755210876465,13.3921327590942 51.9721145629883,13.3910865783693 51.9684944152833,13.373233795166 51.9735794067384,13.3728904724122 51.9630851745605,13.375563621521 51.962730407715,13.3753995895387 51.9564895629883,13.3592958450317 51.9589462280273,13.3564214706422 51.9586563110352,13.356315612793 51.9576683044435,13.3506259918212 51.9587059020996,13.351354598999 51.9608039855957,13.3463134765626 51.9635963439941,13.3461618423463 51.97066116333,13.3434782028199 51.9729194641114,13.3358688354493 51.9740409851075,13.319899559021 51.9737777709962,13.318289756775 51.9771881103517,13.304347038269 51.9747123718262,13.304347038269 51.9747123718262,13.3052730560304 51.9776611328125,13.2931079864503 51.9784660339357,13.2786312103271 51.9777183532714,13.2787637710572 51.981071472168,13.2787637710572 51.981071472168,13.2799425125122 51.9810447692872,13.2878179550171 51.9884567260743,13.2953510284424 51.9867324829103,13.3035564422609 51.9864387512208,13.3025741577148 51.9898948669435,13.3113069534302 51.9901199340821,13.3122901916505 51.9946975708008,13.3071031570435 51.9945297241212,13.3070726394653 51.9982681274414,13.3086442947388 51.9986877441407,13.3100566864015 52.00288772583,13.3100156784057 52.0062370300294,13.3183259963989 52.0045356750489,13.3317918777467 51.9998397827149,13.3316183090211 52.0034370422364,13.3258352279664 52.0056648254395,13.3354969024659 52.0083236694335,13.3444223403931 52.0078315734864,13.3477840423585 52.0060958862305,13.3503923416138 52.0065078735352,13.3502321243287 52.007438659668,13.357385635376 52.0096282958986,13.3566818237304 52.013038635254,13.3588171005249 52.0175247192383,13.3647975921632 52.0168037414552,13.3722858428956 52.0143356323243,13.3739194869995 52.0143318176269,13.3754329681397 52.0156555175782,13.379722595215 52.0140495300294,13.3808755874635 52.0147399902344,13.3827314376831 52.0138778686523,13.3814496994019 52.0127639770508,13.3808536529542 52.0098075866699,13.3814506530762 52.0074920654297,13.3972721099854 52.0049095153809,13.3969316482545 52.0141906738282,13.4088621139526 52.0173187255859,13.4093418121339 52.019344329834,13.4080705642701 52.022274017334,13.4147596359253 52.0321273803712,13.411340713501 52.0368385314941,13.4104194641113 52.0434074401856,13.4066333770753 52.044460296631,13.406120300293 52.0455703735352,13.4067335128784 52.0485191345215,13.4091033935548 52.0490531921386,13.4076528549195 52.0496482849121,13.4076147079468 52.0631599426269,13.403102874756 52.0631828308105,13.4033393859863 52.0652809143066,13.4012069702149 52.065731048584,13.3819303512573 52.0655403137208,13.3819856643677 52.0638923645021,13.3753938674927 52.0644989013672,13.3753814697266 52.0652198791505,13.3669443130494 52.0650749206542,13.36732006073 52.0663948059083,13.3734588623046 52.0662307739258,13.3680067062377 52.0811614990236,13.3727903366089 52.0814781188964,13.3729066848755 52.0888481140137,13.3729066848755 52.0888481140137,13.39603805542 52.0952262878418,13.4175720214844 52.1077919006347,13.4250106811523 52.1106796264649,13.4335565567016 52.1119270324708,13.4474744796753 52.1099433898926,13.4527673721314 52.1104316711427,13.4527673721314 52.1104316711427,13.461877822876 52.1128387451173,13.4926605224609 52.1084785461426,13.4954147338868 52.0990676879884,13.5010595321655 52.0922813415528,13.5140571594239 52.0923500061035,13.5408229827882 52.0972175598145,13.5408229827882 52.0972175598145,13.556160926819 52.0908012390138,13.5774841308594 52.0903701782227,13.5966014862061 52.0837554931641,13.6036100387573 52.0802574157715,13.605586051941 52.0779762268067,13.6146440505983 52.0747680664062,13.6229228973389 52.0732116699219)) | 0.0006 | POINT(13.436981383122928 52.01978836561505) |
60449 | POLYGON((7.94691705703741 47.1301574707031,7.94661808013922 47.1274909973146,7.94756984710705 47.1252212524415,7.94678115844727 47.1239738464356,7.94287395477306 47.1225395202638,7.93596220016491 47.1221771240235,7.93130779266357 47.1208686828613,7.92885780334473 47.119701385498,7.9283270835877 47.1177482604982,7.9283270835877 47.1177482604982,7.92394876480108 47.1162261962891,7.92141914367676 47.1118659973146,7.91922378540045 47.1112060546874,7.91792297363281 47.1126976013184,7.91282081604004 47.115032196045,7.91138315200811 47.1190643310547,7.90630292892467 47.1244812011719,7.90332698822033 47.1265487670899,7.8986959457398 47.127368927002,7.894455909729 47.1298713684082,7.894455909729 47.1298713684082,7.89560794830322 47.1326866149902,7.90318584442144 47.1360893249513,7.90797519683832 47.141300201416,7.91563320159918 47.1449089050293,7.91952800750732 47.1456146240235,7.92290592193604 47.1478424072266,7.92542505264294 47.1516342163087,7.926106929779 47.1571731567382,7.92972993850708 47.1612968444824,7.92972993850708 47.1612968444824,7.93407821655279 47.1614608764649,7.93663501739513 47.1625595092773,7.94384098052973 47.1607284545899,7.94754886627203 47.1609840393067,7.9521679878236 47.1577339172364,7.95174312591564 47.1544990539551,7.95893716812128 47.1529655456544,7.96082687377941 47.1514167785645,7.96082687377941 47.1514167785645,7.95507097244268 47.1472053527832,7.94973802566534 47.1458168029786,7.94972515106207 47.1441383361816,7.95240497589117 47.1413879394531,7.95433187484747 47.1362533569336,7.94691705703741 47.1301574707031)) | 0.0006 | POINT(7.930471165974979 47.13689490424265) |
19091 | POLYGON((11.2904806137085 43.838264465332,11.2874813079835 43.8476333618165,11.2910451889038 43.8503799438478,11.2922630310058 43.8591232299806,11.2909307479859 43.862030029297,11.2879753112794 43.8624954223633,11.2847461700441 43.8594093322755,11.2777996063232 43.862590789795,11.2747640609742 43.8655242919922,11.2857360839844 43.8683547973633,11.28697681427 43.8696289062501,11.2864093780518 43.8709983825684,11.2831230163574 43.8722877502441,11.264464378357 43.872200012207,11.2576932907106 43.8645858764648,11.2533807754517 43.8630943298339,11.2434034347534 43.8677711486817,11.2413578033448 43.8736381530762,11.2359132766724 43.8801383972169,11.2334928512573 43.8813095092773,11.2334928512573 43.8813095092773,11.2344999313354 43.8869438171387,11.2337961196901 43.8937454223633,11.2309398651123 43.9009437561036,11.2515802383423 43.9064712524415,11.2626304626465 43.9184150695801,11.2625360488892 43.9247894287109,11.2552165985108 43.9269142150879,11.2512912750245 43.9314689636231,11.2512912750245 43.9314689636231,11.2542104721069 43.9335708618163,11.2595672607422 43.9355278015138,11.2706270217896 43.9351272583008,11.2806787490845 43.9324684143068,11.304009437561 43.9223785400391,11.3109426498414 43.9210014343262,11.3109426498414 43.9210014343262,11.3124837875367 43.9138336181641,11.3175439834594 43.9081573486329,11.3360977172852 43.8954162597656,11.3549842834474 43.8919258117676,11.353219985962 43.8872871398927,11.345615386963 43.8793792724611,11.344443321228 43.8761596679687,11.3457422256471 43.8713607788087,11.3457422256471 43.8713607788087,11.3450155258179 43.8688735961915,11.3406114578248 43.865074157715,11.3145647048951 43.8489608764649,11.2963180541993 43.8415946960449,11.2904806137085 43.838264465332)) | 0.0006 | POINT(11.285201454162642 43.88628776550296) |
38834 | POLYGON((2.43362236022944 43.0223731994629,2.42868947982788 43.0030174255372,2.41464018821728 42.9902992248535,2.41464018821728 42.9902992248535,2.39529085159313 42.9801979064941,2.38641142845165 42.9720001220704,2.38641142845165 42.9720001220704,2.4069557189942 42.9630508422853,2.41231751441961 42.9571800231934,2.41231751441961 42.9571800231934,2.45914554595953 42.9617347717285,2.45914554595953 42.9617347717285,2.46359038352972 42.9789619445801,2.46359038352972 42.9789619445801,2.46578907966614 42.9955635070801,2.45531105995184 43.0062408447266,2.45531105995184 43.0062408447266,2.45207667350769 43.0204277038574,2.45207667350769 43.0204277038574,2.43362236022944 43.0223731994629)) | 0.0006 | POINT(2.432491214651865 42.986204850046285) |
60911 | POLYGON((9.06827259063732 46.1327133178712,9.08008766174316 46.1202011108398,9.08008766174316 46.1202011108398,9.08424282073975 46.1209716796875,9.08939266204834 46.1236915588379,9.09938621521007 46.125301361084,9.10422229766846 46.1297836303712,9.11821556091314 46.1332588195801,9.11821556091314 46.1332588195801,9.12165737152105 46.1337127685547,9.1227531433106 46.135280609131,9.1227531433106 46.135280609131,9.12878990173334 46.1463699340821,9.13479614257812 46.1528053283693,9.14583206176763 46.1588783264161,9.15420436859131 46.1597633361816,9.15657234191895 46.1610832214355,9.15819740295416 46.1633415222169,9.15836715698242 46.1671943664551,9.15836715698242 46.1671943664551,9.14848423004162 46.1722984313966,9.13745021820068 46.1824569702149,9.13745021820068 46.1824569702149,9.1305017471314 46.1813774108887,9.11008739471436 46.1815299987793,9.10317611694347 46.1842155456544,9.08276176452642 46.185359954834,9.07708072662359 46.1873741149903,9.07708072662359 46.1873741149903,9.06431770324713 46.182300567627,9.05818653106701 46.1813125610352,9.05818653106701 46.1813125610352,9.05787277221685 46.1776618957519,9.05311965942388 46.173397064209,9.05163192749029 46.1708641052247,9.04483985900879 46.1703147888184,9.04358100891125 46.1687316894532,9.04760456085211 46.1640167236328,9.06046390533447 46.1650810241699,9.06355190277111 46.1643447875978,9.06492519378656 46.161922454834,9.06262302398687 46.1584625244142,9.06820487976074 46.1520042419434,9.075258255005 46.1474418640137,9.07396411895758 46.1447372436525,9.07359790802013 46.1397361755371,9.06987762451183 46.1350097656251,9.06987762451183 46.1350097656251,9.06827259063732 46.1327133178712)) | 0.0006 | POINT(9.095211903254238 46.15704981486005) |
49813 | POLYGON((3.39074015617382 49.7684402465821,3.39454388618481 49.7705993652345,3.39454388618481 49.7705993652345,3.38550472259527 49.7787170410157,3.36679530143749 49.7855644226075,3.36138439178472 49.791576385498,3.36138439178472 49.791576385498,3.35364031791687 49.789577484131,3.35364031791687 49.789577484131,3.35293149948126 49.7833786010743,3.35293149948126 49.7833786010743,3.38111281394958 49.7683868408203,3.39074015617382 49.7684402465821)) | 0.0006 | POINT(3.370762765407623 49.78094768524176) |