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 |
---|---|---|---|
20115 | POLYGON((12.0562629699708 45.8947982788087,12.0420160293579 45.8929176330566,12.0359554290773 45.8899879455568,12.0294742584229 45.8809623718262,12.0346622467042 45.8764724731446,12.033899307251 45.8688507080079,12.0316143035889 45.8671112060547,12.0287246704103 45.8627891540527,12.0286035537719 45.8598480224609,12.0286035537719 45.8598480224609,12.024172782898 45.8593902587892,12.0120573043823 45.8614006042482,11.9848699569703 45.8776588439941,11.9793481826783 45.8782539367676,11.9619731903076 45.8859252929687,11.9515514373779 45.8928108215333,11.9502115249633 45.8962364196778,11.9502115249633 45.8962364196778,11.9515380859374 45.8966903686524,11.9515380859374 45.8966903686524,11.9594526290894 45.9027595520021,11.9658880233765 45.9061813354492,11.9748706817627 45.905876159668,11.9835796356201 45.9146575927735,11.9791336059571 45.9207344055175,11.9786548614501 45.92333984375,11.985429763794 45.9421501159668,11.9870462417603 45.9438934326173,12.001971244812 45.9526977539062,12.006890296936 45.9544143676758,12.0082283020021 45.9588813781738,12.0038290023804 45.9675102233887,12.0038290023804 45.9675102233887,12.0047121047974 45.9690208435059,12.0047121047974 45.9690208435059,12.0126457214357 45.9677314758301,12.0315341949463 45.9744644165039,12.0337238311768 45.9745178222657,12.0337238311768 45.9745178222657,12.0503463745117 45.9620895385742,12.0503463745117 45.9620895385742,12.0401277542115 45.9576759338379,12.0466012954712 45.9458198547364,12.0556201934815 45.9322204589845,12.0622081756592 45.9274711608887,12.0687427520752 45.9243621826172,12.0779371261597 45.9147911071778,12.0788259506226 45.9059181213379,12.0788259506226 45.9059181213379,12.0628614425659 45.896942138672,12.0562629699708 45.8947982788087)) | 0.0006 | POINT(12.013991737365743 45.9164011383057) |
1388956 | POLYGON((-5.23458194732655 36.6231956481934,-5.23872709274286 36.6246032714843,-5.24416780471796 36.6225090026856,-5.25303077697754 36.6243247985839,-5.25557708740234 36.6234588623046,-5.26854276657104 36.6294021606445,-5.27183198928827 36.6332588195802,-5.26463890075678 36.6427078247071,-5.2594580650329 36.6445541381837,-5.25822782516479 36.647632598877,-5.23922395706171 36.6615180969238,-5.23943614959717 36.6703567504884,-5.23502206802368 36.6724052429199,-5.22964286804194 36.6640090942383,-5.23450422286987 36.6583900451661,-5.23870515823364 36.6562767028809,-5.23748111724854 36.6526489257812,-5.22965621948242 36.6493873596192,-5.22889089584351 36.6476364135743,-5.22967195510859 36.6426010131836,-5.23424005508423 36.6415061950684,-5.23098278045649 36.6337089538574,-5.22809505462646 36.6324729919435,-5.23458194732655 36.6231956481934)) | 0.0006 | POINT(-5.242797250333012 36.64341586569084) |
62834 | POLYGON((12.8411302566529 54.3150749206544,12.8265600204469 54.3181114196778,12.8278312683107 54.316333770752,12.8277730941772 54.3144149780274,12.819863319397 54.3127555847168,12.8180704116821 54.3145484924318,12.8135852813721 54.3148536682129,12.8126296997071 54.3190841674804,12.803903579712 54.3211326599121,12.8017988204957 54.3202743530273,12.799201965332 54.3165473937988,12.7966098785401 54.3177795410156,12.7931270599366 54.316722869873,12.7874164581299 54.3171119689941,12.7856969833375 54.3203239440917,12.7813072204591 54.3238906860352,12.7813072204591 54.3238906860352,12.7746906280518 54.3263282775879,12.7801876068116 54.3302955627441,12.7803096771241 54.3337516784669,12.7831106185913 54.3378715515136,12.7846736907959 54.3424034118653,12.7890558242799 54.3444252014161,12.7930545806886 54.345027923584,12.794282913208 54.34672164917,12.7940759658813 54.3500404357911,12.7974481582643 54.3501319885254,12.7990722656251 54.3482971191406,12.8029451370239 54.3505592346192,12.8102788925171 54.3499031066895,12.8102788925171 54.3499031066895,12.8075008392333 54.3487510681152,12.8091669082642 54.3476371765137,12.8086109161377 54.3454170227051,12.8097229003907 54.3451385498047,12.8113889694215 54.3456954956055,12.8124990463257 54.3481941223145,12.814721107483 54.3487510681152,12.8174991607667 54.3512496948243,12.8290195465088 54.3520851135254,12.8290195465088 54.3520851135254,12.8250751495362 54.3480415344238,12.8311128616334 54.3434028625488,12.8342533111573 54.3426361083985,12.8345603942871 54.3417778015137,12.8392505645751 54.3412208557129,12.8391780853271 54.3390502929689,12.847794532776 54.3372192382812,12.8518972396851 54.3338165283203,12.8575477600098 54.3311882019042,12.8631877899169 54.3311538696289,12.8659019470215 54.3262977600098,12.8659019470215 54.3262977600098,12.8641977310182 54.3218650817871,12.8674831390381 54.3184509277345,12.8656053543092 54.3156127929689,12.8656053543092 54.3156127929689,12.8454713821411 54.3143730163575,12.8411302566529 54.3150749206544)) | 0.0006 | POINT(12.81766294610916 54.33312988281251) |
1405478 | POLYGON((-1.53239500522614 42.0202789306642,-1.53905701637262 42.0125732421876,-1.54084098339081 41.9958190917969,-1.54516196250916 41.985767364502,-1.55049598217005 41.9837913513184,-1.55663597583771 41.9844703674317,-1.56478798389429 41.9832115173339,-1.57618796825409 41.985221862793,-1.5848970413208 41.9942512512208,-1.59409999847412 41.9995079040528,-1.60136604309076 42.0123481750489,-1.60714995861053 42.0140495300294,-1.60595405101776 42.0190086364747,-1.59682095050812 42.0246505737306,-1.58310294151306 42.0260581970215,-1.58535695075977 42.0312004089356,-1.57846105098724 42.0338439941406,-1.57697904109955 42.0374031066895,-1.57505595684052 42.0364532470704,-1.57065498828888 42.0388298034669,-1.5549629926681 42.0307159423829,-1.56127798557276 42.02490234375,-1.56055796146393 42.0225715637208,-1.55808305740356 42.0214424133301,-1.54774498939514 42.0219154357911,-1.53910899162287 42.0197868347169,-1.53239500522614 42.0202789306642)) | 0.0006 | POINT(-1.5687383780112436 42.01384896498466) |
14120 | POLYGON((10.1937732696533 44.5554161071778,10.2076625823975 44.5574951171875,10.214659690857 44.5603981018068,10.2305002212526 44.5647239685059,10.2305002212526 44.5647239685059,10.2401065826415 44.5718307495117,10.2401065826415 44.5718307495117,10.2463569641114 44.5779647827149,10.2518625259401 44.5887336730958,10.264142036438 44.6040267944336,10.275486946106 44.6142730712892,10.2801809310914 44.6198768615724,10.2811965942383 44.6237335205079,10.2802743911744 44.6311607360841,10.2770328521729 44.6369400024415,10.2761564254762 44.6418762207032,10.2792253494263 44.6497611999512,10.2877988815309 44.6561470031739,10.2922143936157 44.6567726135254,10.3099155426025 44.6635360717773,10.3099155426025 44.6635360717773,10.3069114685058 44.6673622131349,10.2956094741821 44.6734886169435,10.2942476272584 44.6752319335938,10.2979698181152 44.6848487854004,10.2981786727906 44.6905670166017,10.2944116592408 44.6922531127931,10.2944116592408 44.6922531127931,10.2909240722657 44.6919593811036,10.2855577468873 44.68904876709,10.2723407745361 44.6744232177734,10.261206626892 44.6699981689453,10.2469730377197 44.6575355529785,10.2396974563599 44.653305053711,10.2253828048707 44.6476745605468,10.2106513977051 44.6486320495606,10.1986083984376 44.6379623413086,10.1986083984376 44.6379623413086,10.2113571166993 44.6239089965821,10.2122907638549 44.6202545166016,10.1954326629639 44.6072311401368,10.1890277862549 44.6064147949219,10.1847229003907 44.6078643798828,10.1720361709595 44.5983238220216,10.1723575592042 44.5915832519532,10.1754131317139 44.5906791687012,10.1757717132568 44.589714050293,10.1748876571656 44.5851135253906,10.1696977615357 44.573829650879,10.1679201126099 44.5730895996095,10.1679201126099 44.5730895996095,10.1746673583984 44.5618095397949,10.1806297302247 44.5584411621094,10.1896314620972 44.5572700500489,10.1937732696533 44.5554161071778)) | 0.0006 | POINT(10.238787474455695 44.621812608506985) |
1407044 | POLYGON((-6.57500314712519 38.307559967041,-6.57987117767328 38.3061294555663,-6.58379983901978 38.3095512390137,-6.58690500259394 38.3064308166504,-6.586501121521 38.301929473877,-6.58909893035883 38.2990112304689,-6.59291887283325 38.2983436584474,-6.60134983062744 38.3001022338868,-6.60600090026855 38.3030586242676,-6.60109186172485 38.3106040954589,-6.60625886917114 38.3112640380861,-6.61920690536493 38.3037757873535,-6.62429618835444 38.3029289245607,-6.63180780410767 38.3116455078126,-6.63399410247803 38.3116683959961,-6.63823080062866 38.308609008789,-6.64193201065058 38.3099212646486,-6.64452314376825 38.3134956359863,-6.64617776870728 38.326873779297,-6.65114688873285 38.334529876709,-6.65311288833607 38.351333618164,-6.65189409255976 38.3552894592285,-6.6610169410705 38.3833236694337,-6.65841484069819 38.3854866027833,-6.65873193740839 38.3879165649415,-6.66192197799683 38.3869438171387,-6.66378021240234 38.3924636840821,-6.66693019866938 38.3940925598146,-6.66827392578125 38.4057464599609,-6.67298078536987 38.4105072021484,-6.66974210739136 38.4137077331544,-6.67136907577509 38.4180068969727,-6.66837501525879 38.41902923584,-6.66915607452393 38.4208755493165,-6.67225980758667 38.4218254089355,-6.67358684539795 38.4292411804199,-6.67182111740107 38.4327735900879,-6.66525220870972 38.4369430541993,-6.66840600967407 38.4490318298341,-6.65426206588739 38.4493026733399,-6.64782381057739 38.4508743286134,-6.64395618438721 38.448902130127,-6.64031791687006 38.4496917724611,-6.63278388977045 38.4552040100098,-6.62907314300531 38.455005645752,-6.61808490753174 38.4593276977539,-6.61211585998535 38.4554290771486,-6.60558700561523 38.4544792175293,-6.60226392745972 38.4528732299805,-6.59734487533569 38.4465522766114,-6.58126783370972 38.4387969970704,-6.57625198364252 38.4378776550293,-6.57571220397949 38.4359931945801,-6.57352781295776 38.4360694885255,-6.57255697250366 38.4384231567383,-6.56629419326777 38.4370918273926,-6.56574487686152 38.4389724731446,-6.55631589889521 38.4421615600586,-6.5528039932251 38.4398880004883,-6.54595279693598 38.445728302002,-6.53949213027954 38.4459152221681,-6.53317403793335 38.4415626525879,-6.52811002731312 38.4422225952149,-6.52212190628046 38.4352569580078,-6.51552391052246 38.4373588562012,-6.49587821960449 38.417350769043,-6.49488210678101 38.4123497009278,-6.49991893768311 38.4094734191895,-6.50006294250488 38.4079589843751,-6.49691486358643 38.4032325744629,-6.49819612503052 38.4022598266601,-6.49647998809809 38.3991813659669,-6.49160003662109 38.3960304260255,-6.49089384078974 38.3937187194825,-6.49336004257202 38.3881416320801,-6.4911150932312 38.3757514953614,-6.50337696075439 38.3706550598146,-6.51022481918329 38.3650627136231,-6.51165914535511 38.3594970703126,-6.51613998413086 38.3589210510254,-6.52087116241449 38.3557434082031,-6.52801418304443 38.3485374450685,-6.52964401245112 38.3443908691407,-6.5393500328064 38.3485412597657,-6.53861379623407 38.3468208312989,-6.54336881637562 38.3429832458497,-6.56843709945679 38.34033203125,-6.56190919876099 38.3366928100586,-6.55873394012451 38.3325576782227,-6.56264495849598 38.3218345642091,-6.57074499130249 38.319362640381,-6.57437181472773 38.3196220397949,-6.57406377792358 38.3119659423829,-6.57689189910883 38.3108787536622,-6.57499599456781 38.3102416992188,-6.57500314712519 38.307559967041)) | 0.0006 | POINT(-6.5883048860650035 38.38203181216594) |
35518 | POLYGON((5.7393412590028 47.2494964599609,5.72565746307373 47.2465324401855,5.72301769256592 47.2401161193848,5.72301769256592 47.2401161193848,5.72550868988048 47.2373390197755,5.73451614379888 47.2391624450684,5.74092197418219 47.2472877502443,5.74092197418219 47.2472877502443,5.7393412590028 47.2494964599609)) | 0.0006 | POINT(5.731612861156514 47.24341726303106) |
63509 | POLYGON((11.2467050552369 53.1907997131348,11.2308731079102 53.1927833557129,11.2308139801025 53.1873817443848,11.2161426544189 53.1907768249513,11.2161426544189 53.1907768249513,11.2197742462158 53.1922454833984,11.2196741104127 53.2045097351075,11.2241010665895 53.2042045593262,11.2231025695801 53.2081375122071,11.2175397872925 53.2094917297363,11.2187662124634 53.2121543884277,11.2217283248901 53.2147712707521,11.2294845581055 53.2174377441406,11.230770111084 53.2263221740723,11.2481203079224 53.2328071594238,11.2501821517944 53.2351112365723,11.2482271194457 53.2355651855469,11.2489709854127 53.2370147705079,11.2515888214111 53.2368011474611,11.2528934478761 53.2386016845703,11.2542448043824 53.2448921203614,11.259111404419 53.2455825805665,11.2635812759399 53.2483940124511,11.2611446380616 53.2496223449708,11.2676763534547 53.2581214904785,11.2675304412842 53.2591857910156,11.2675304412842 53.2591857910156,11.267147064209 53.2604179382324,11.2690086364746 53.2614402770997,11.2714529037476 53.2614974975586,11.2751893997193 53.2599906921388,11.2771568298341 53.2602195739746,11.2775144577028 53.261791229248,11.2808961868286 53.2597732543945,11.2852811813355 53.2627029418946,11.2902240753174 53.2641639709474,11.2914390563966 53.2658538818359,11.2950458526612 53.2654876708984,11.308352470398 53.2692489624025,11.3101358413696 53.2675743103028,11.3187093734741 53.2723083496095,11.3187093734741 53.2723083496095,11.3219060897827 53.2716331481935,11.3219060897827 53.2716331481935,11.3205080032348 53.269832611084,11.3256464004517 53.2696113586426,11.3283853530885 53.2645683288575,11.3241024017335 53.2640228271485,11.3280200958253 53.2618827819825,11.3280200958253 53.2618827819825,11.330283164978 53.2570686340333,11.330283164978 53.2570686340333,11.3309488296509 53.254997253418,11.3327083587648 53.2537078857422,11.3324871063233 53.2427978515625,11.3342046737671 53.242504119873,11.3323154449463 53.2408370971681,11.3340406417847 53.2401504516602,11.3319520950317 53.233497619629,11.330665588379 53.2319869995118,11.330665588379 53.2319869995118,11.3218832015991 53.2326393127442,11.3231706619262 53.2301597595215,11.2999629974365 53.2299613952637,11.2971944808961 53.2309417724609,11.2826919555664 53.2291564941407,11.2653226852418 53.2235755920411,11.2606315612793 53.2190399169922,11.2516460418702 53.214672088623,11.2557668685913 53.2122116088868,11.2774791717529 53.2070770263673,11.2764072418213 53.2048721313477,11.2747926712036 53.2041625976563,11.2749042510986 53.2002792358398,11.2749042510986 53.2002792358398,11.2681818008423 53.1985321044922,11.2666893005371 53.1996459960939,11.2618370056153 53.1995239257812,11.262342453003 53.1940841674806,11.2532806396484 53.1937255859376,11.2467050552369 53.1907997131348)) | 0.0006 | POINT(11.279010272026095 53.2354208469391) |
1401836 | POLYGON((-3.27826690673822 41.8148574829103,-3.28480410575867 41.8145980834962,-3.28107094764704 41.8229026794434,-3.28458309173584 41.8272628784181,-3.28867197036743 41.8285675048829,-3.28893804550171 41.8424644470215,-3.28376197814936 41.8457298278809,-3.28478789329529 41.851661682129,-3.27896690368647 41.8679122924804,-3.28389000892639 41.8695068359376,-3.28950095176697 41.8764114379883,-3.28368902206421 41.8838119506837,-3.27467799186707 41.882137298584,-3.27096509933472 41.878761291504,-3.26894593238819 41.8690643310547,-3.26297688484192 41.8678436279297,-3.25675892829889 41.8706436157227,-3.24327397346497 41.863998413086,-3.24673795700073 41.8563232421875,-3.24253511428822 41.8472290039063,-3.23431897163391 41.8406448364258,-3.23818588256836 41.8376426696778,-3.23510503768915 41.8347167968749,-3.24509501457214 41.820068359375,-3.25517106056213 41.8229713439943,-3.26369190216059 41.8188171386719,-3.26384305953974 41.8172683715821,-3.27826690673822 41.8148574829103)) | 0.0006 | POINT(-3.267156097624013 41.84717842384626) |
19063 | POLYGON((11.4848928451539 43.6270866394044,11.4766235351562 43.6300582885743,11.471700668335 43.6305961608887,11.456597328186 43.6429061889648,11.456597328186 43.6429061889648,11.4531984329224 43.6426849365236,11.4469785690308 43.6451110839844,11.4304361343385 43.6433601379394,11.4195404052736 43.6490631103516,11.3933916091919 43.6487922668458,11.3924312591552 43.6495704650879,11.3924312591552 43.6495704650879,11.3874931335449 43.6522941589357,11.3822832107545 43.6491241455079,11.3692483901977 43.6332626342774,11.3752403259277 43.6289787292481,11.373257637024 43.6182975769044,11.3713321685792 43.6166000366211,11.3733205795289 43.6117057800292,11.3945569992066 43.5988388061523,11.3963146209717 43.598503112793,11.4005832672119 43.6014747619629,11.4024028778076 43.6014251708985,11.4079875946045 43.5954666137696,11.4050970077515 43.5826072692872,11.4038982391357 43.5686683654786,11.4060821533203 43.5631942749023,11.4090175628663 43.561679840088,11.4090175628663 43.561679840088,11.4187860488893 43.5610504150392,11.4394645690919 43.5641975402833,11.4462785720826 43.5673637390137,11.4660987854004 43.5824317932129,11.4655017852784 43.5878295898438,11.4825229644777 43.5839653015137,11.5082054138184 43.5799674987794,11.5082054138184 43.5799674987794,11.5120162963868 43.5780906677247,11.5174293518067 43.579315185547,11.5225162506104 43.5820426940919,11.5174980163575 43.5866928100587,11.5149536132812 43.59183883667,11.5175828933716 43.595184326172,11.5175828933716 43.595184326172,11.5169677734376 43.5976638793946,11.5109796524048 43.6038093566895,11.5049476623535 43.6068153381348,11.5010509490967 43.6150398254395,11.5010509490967 43.6150398254395,11.4952077865601 43.6241722106934,11.4848928451539 43.6270866394044)) | 0.0006 | POINT(11.446536006927523 43.606463394165075) |