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 |
---|---|---|---|
30426 | POLYGON((-2.86087536811829 48.2657966613771,-2.84370279312134 48.268741607666,-2.84370279312134 48.268741607666,-2.83331656455988 48.2685508728027,-2.82651543617249 48.2592430114747,-2.8184027671814 48.2550315856934,-2.8184027671814 48.2550315856934,-2.81123566627502 48.2395515441895,-2.81399965286255 48.2368164062501,-2.81399965286255 48.2368164062501,-2.8273680210113 48.2281379699708,-2.8589785099029 48.2218170166017,-2.8589785099029 48.2218170166017,-2.8606104850769 48.2301712036133,-2.8606104850769 48.2301712036133,-2.86414122581482 48.2600593566896,-2.86414122581482 48.2600593566896,-2.86087536811829 48.2657966613771)) | 0.0006 | POINT(-2.839940113179811 48.24744437722605) |
1406876 | POLYGON((-5.16789197921753 38.6773376464844,-5.18266105651855 38.6761474609374,-5.18564605712891 38.6741905212402,-5.18729019165039 38.6704101562501,-5.17895507812494 38.6657447814943,-5.18485307693476 38.6594352722169,-5.19020509719843 38.6604614257814,-5.19474220275868 38.666790008545,-5.19754314422607 38.6670455932617,-5.19841003417963 38.6645355224609,-5.19675683975208 38.6604919433595,-5.19763183593744 38.6568069458008,-5.19930982589722 38.6564102172852,-5.20144319534296 38.6577835083009,-5.20404386520386 38.6661224365235,-5.20790195465088 38.6679153442384,-5.21221208572388 38.6560020446778,-5.21154403686518 38.6517868041992,-5.21462821960449 38.6485862731933,-5.21711683273315 38.6492118835449,-5.2194190025329 38.6560440063477,-5.22382211685175 38.6564750671387,-5.22226810455317 38.6489448547364,-5.22931003570551 38.6470794677735,-5.2313380241394 38.6443405151367,-5.23551607131952 38.643051147461,-5.23742818832392 38.6377105712891,-5.241868019104 38.637092590332,-5.24734306335449 38.639862060547,-5.24488306045527 38.6321029663086,-5.25387716293335 38.6332130432129,-5.25408887863153 38.6260719299318,-5.27051687240595 38.6210594177247,-5.2732400894165 38.6156539916993,-5.27916383743286 38.6123046875,-5.28697204589844 38.6129875183105,-5.29315280914307 38.6090927124024,-5.3028421401977 38.6122550964356,-5.30549001693726 38.6117439270021,-5.30874681472773 38.6155548095703,-5.31507205963123 38.6183128356934,-5.32015419006348 38.6302223205568,-5.32649517059326 38.6366119384767,-5.32932806015015 38.6358070373535,-5.33429193496704 38.6386528015138,-5.33396291732782 38.6420211791992,-5.33631086349487 38.6435585021973,-5.33604717254639 38.6491966247559,-5.34458923339838 38.6588745117188,-5.3486070632934 38.6682357788087,-5.35130119323725 38.679973602295,-5.34544277191156 38.6924171447755,-5.35845279693598 38.6975708007813,-5.36129713058472 38.6962814331055,-5.36163187026972 38.6924972534181,-5.36760091781611 38.6960258483888,-5.38114213943476 38.7084274291992,-5.38320398330688 38.736255645752,-5.37845420837402 38.7490997314454,-5.37045907974243 38.7560920715333,-5.36933994293213 38.7629356384278,-5.3706321716308 38.7706871032715,-5.36591911315912 38.7761039733887,-5.36327123641968 38.7757072448731,-5.36536312103266 38.7822418212891,-5.36951112747187 38.7875671386719,-5.37040185928339 38.8002243041993,-5.38771486282343 38.8335571289063,-5.38792419433594 38.8446655273438,-5.37537288665766 38.8593635559082,-5.36670112609863 38.8654212951661,-5.35792207717896 38.8776817321777,-5.33637905120844 38.8924789428711,-5.33367395400995 38.8926467895508,-5.33323383331299 38.8953590393068,-5.33015298843378 38.8945541381836,-5.32712078094477 38.8981132507324,-5.32800292968744 38.8993568420411,-5.32481002807617 38.9022483825685,-5.32262897491455 38.9007263183594,-5.32169723510737 38.9025726318359,-5.31826210021973 38.9026489257813,-5.31755781173706 38.9054565429688,-5.31313896179199 38.9039039611817,-5.31212902069086 38.9012222290038,-5.31017589569092 38.903938293457,-5.31138610839844 38.9064254760742,-5.30864906311035 38.9044647216796,-5.30729484558105 38.9054374694825,-5.30611896514893 38.9014663696289,-5.30452394485474 38.9010009765626,-5.30249118804932 38.9037551879883,-5.30299711227411 38.9026641845704,-5.29852485656738 38.9005355834962,-5.29780292510981 38.8970642089844,-5.29410982131958 38.8981094360353,-5.29728078842163 38.8959655761719,-5.29285478591919 38.892417907715,-5.28975009918213 38.8930397033692,-5.28786087036127 38.8862037658693,-5.28488206863403 38.8853797912598,-5.27714920043945 38.8879623413087,-5.26815319061279 38.8943824768067,-5.25970220565796 38.8976631164552,-5.25547504425049 38.9028625488282,-5.26141405105591 38.9072875976564,-5.26373386383051 38.9200096130371,-5.25994586944574 38.9223899841309,-5.25693511962885 38.9271621704101,-5.25131511688227 38.9280891418458,-5.24763202667231 38.9262123107911,-5.24299621582031 38.9266090393067,-5.2394590377807 38.9292526245117,-5.23012781143183 38.930793762207,-5.22014808654785 38.9296417236328,-5.21600198745722 38.9250259399415,-5.20905113220215 38.9139671325684,-5.20817279815674 38.9079551696778,-5.20372390747065 38.9047355651857,-5.19877910614014 38.9035835266114,-5.1951441764831 38.8949394226075,-5.19084978103638 38.890983581543,-5.18449306488037 38.8889694213868,-5.17237710952759 38.8893928527833,-5.16728115081781 38.8874740600587,-5.17176198959351 38.8759956359863,-5.16900396347046 38.864128112793,-5.18171882629395 38.8537330627442,-5.18710994720453 38.8465156555177,-5.19707584381098 38.8180580139161,-5.1870551109314 38.7769432067872,-5.18672704696655 38.7699737548829,-5.19454383850092 38.7396163940431,-5.19378709793091 38.728801727295,-5.19101810455322 38.7281761169434,-5.18438816070551 38.7197151184083,-5.18019676208496 38.7123413085939,-5.18123197555536 38.7066650390624,-5.17536497116089 38.7005462646486,-5.17333221435536 38.6884841918946,-5.16764307022089 38.6816673278809,-5.16789197921753 38.6773376464844)) | 0.0006 | POINT(-5.269102854086126 38.77479439593378) |
15264 | POLYGON((9.61222839355469 45.6246223449708,9.60623455047613 45.6231498718263,9.58807086944574 45.6230659484863,9.57804393768322 45.6254844665527,9.5605611801148 45.6273727416993,9.5605611801148 45.6273727416993,9.56634807586676 45.6393089294434,9.56634807586676 45.6393089294434,9.59332466125483 45.634765625,9.6068687438966 45.635540008545,9.61360073089605 45.6340484619141,9.61360073089605 45.6340484619141,9.61222839355469 45.6246223449708)) | 0.0006 | POINT(9.588815927505534 45.630674044291226) |
64674 | POLYGON((12.674524307251 48.750473022461,12.6684656143189 48.7531280517579,12.6645469665528 48.757396697998,12.6583099365235 48.7578964233399,12.6569843292236 48.7537918090821,12.6578407287598 48.751319885254,12.6573381423951 48.7498016357423,12.6545019149781 48.7481193542481,12.6560516357423 48.7474784851074,12.6541500091552 48.7447891235352,12.6503524780275 48.7453575134277,12.6516571044922 48.7422637939454,12.6456508636475 48.7424087524414,12.639757156372 48.7438621520996,12.6283693313598 48.74320602417,12.6266965866089 48.7373123168946,12.630129814148 48.7371101379396,12.6292619705201 48.7353172302247,12.6304168701172 48.7352943420411,12.6307878494263 48.7341384887696,12.6248998641968 48.7329101562501,12.6206235885621 48.7340354919435,12.6210136413575 48.7354850769044,12.6144399642945 48.735710144043,12.6084985733032 48.7341842651367,12.6035909652711 48.7351760864258,12.6020612716675 48.7366752624512,12.5997781753541 48.7360153198243,12.5997781753541 48.7360153198243,12.5980863571168 48.7384223937989,12.6000318527222 48.7387351989747,12.596357345581 48.7424736022949,12.5976562500001 48.7426223754883,12.5972356796265 48.745174407959,12.5991611480713 48.7453536987305,12.5987701416016 48.7485847473145,12.5997037887574 48.7497177124024,12.6062040328979 48.7512245178224,12.6066236495972 48.7574501037598,12.6052217483521 48.7583923339843,12.6053600311279 48.7603149414062,12.6040868759156 48.760467529297,12.6061410903932 48.7629737854004,12.6078634262085 48.7631492614747,12.6073808670045 48.7651901245118,12.6107530593873 48.7654418945314,12.6099166870118 48.7668609619141,12.61048412323 48.7702140808106,12.6088514328004 48.7730445861816,12.6072216033935 48.7750091552734,12.6044206619263 48.7750968933105,12.6027021408082 48.7794227600099,12.6014566421509 48.7795791625977,12.6014566421509 48.7795791625977,12.6005268096924 48.7835731506348,12.5970096588136 48.7834510803224,12.5952939987184 48.7844009399414,12.5919647216798 48.783905029297,12.590732574463 48.7847023010254,12.5914096832276 48.7858963012695,12.5941743850709 48.7859077453614,12.5956068038941 48.79638671875,12.5943613052368 48.7968711853027,12.5983629226685 48.798397064209,12.5956182479858 48.8013801574708,12.60071849823 48.8034362792969,12.6022634506227 48.8013648986818,12.6145992279053 48.8034706115724,12.6178016662598 48.7991371154785,12.6218748092651 48.7994880676271,12.6204061508178 48.8017044067383,12.6228971481324 48.8023147583008,12.62118434906 48.804874420166,12.6231622695923 48.8055572509766,12.6221370697021 48.8067283630372,12.6273984909058 48.8074378967286,12.6267776489258 48.8097419738771,12.6273784637452 48.8107109069825,12.6263227462769 48.8120994567871,12.6299715042114 48.8129920959474,12.6296281814576 48.8144836425781,12.6309909820557 48.8148002624512,12.630181312561 48.8211860656739,12.6265153884888 48.824592590332,12.6265153884888 48.824592590332,12.6329746246338 48.8270797729492,12.6367740631104 48.8248634338378,12.6376390457154 48.8271675109863,12.6434192657471 48.8238372802734,12.6452617645264 48.823917388916,12.6477746963501 48.8258934020997,12.6544675827026 48.8228759765625,12.6617269515992 48.8240127563476,12.6626844406128 48.8222579956056,12.6669397354127 48.8226699829101,12.6669778823854 48.8238220214843,12.6669778823854 48.8238220214843,12.6707191467285 48.8236961364747,12.672860145569 48.8222122192383,12.6757669448852 48.8156318664551,12.6828708648682 48.8169784545898,12.683313369751 48.815601348877,12.6851358413696 48.8164405822755,12.6892118453979 48.8128700256348,12.6863355636597 48.8113136291505,12.69260597229 48.8065757751465,12.6905078887939 48.8062667846679,12.6923751831055 48.8023796081543,12.6895503997803 48.8013534545898,12.6919937133789 48.7993621826173,12.6943664550782 48.8006286621094,12.6985645294189 48.8003921508789,12.695731163025 48.7970771789551,12.7016487121582 48.7969245910645,12.7017707824708 48.7948150634767,12.70662689209 48.7947006225586,12.7065811157227 48.7954750061036,12.7102050781251 48.7955207824707,12.7099618911743 48.7976493835449,12.718505859375 48.7977561950685,12.7192230224611 48.7997512817384,12.724144935608 48.7995529174806,12.7249145507814 48.7931747436523,12.7317295074463 48.7927169799806,12.7327213287354 48.7900047302246,12.7327213287354 48.7900047302246,12.7342557907104 48.7875442504884,12.7270822525024 48.782543182373,12.7249851226808 48.7822341918945,12.7255020141603 48.7780494689942,12.7210102081298 48.7768898010254,12.7213935852052 48.7751541137696,12.7195501327516 48.7750205993653,12.7145776748658 48.7710418701172,12.7108058929443 48.7707138061524,12.7092151641846 48.7686729431153,12.703935623169 48.7693023681641,12.7020177841188 48.7660179138184,12.7028617858887 48.7618293762208,12.698250770569 48.7582588195802,12.6918525695802 48.7594108581544,12.689847946167 48.7578010559083,12.6870126724244 48.7586059570312,12.6851825714111 48.7548255920411,12.6826534271241 48.755470275879,12.6809148788452 48.7528152465821,12.6792573928834 48.7531776428223,12.679705619812 48.7519454956055,12.6779384613038 48.7531967163087,12.6762809753418 48.7517280578614,12.6754474639893 48.7522468566895,12.674524307251 48.750473022461)) | 0.0006 | POINT(12.650365766310577 48.77940593492117) |
61486 | POLYGON((6.84705686569225 46.5654373168946,6.83978080749523 46.566749572754,6.83978080749523 46.566749572754,6.83260679244995 46.5732002258302,6.83416891098028 46.5764846801758,6.83416891098028 46.5764846801758,6.83658123016363 46.5767860412598,6.84000396728527 46.5799369812012,6.84000396728527 46.5799369812012,6.84412622451788 46.5788764953614,6.84828901290905 46.5764694213868,6.84717082977295 46.5730667114258,6.84705686569225 46.5654373168946)) | 0.0006 | POINT(6.840311527252273 46.57418155670172) |
48672 | POLYGON((-0.513000428676605 48.4610061645509,-0.515146136283875 48.4679756164552,-0.515146136283875 48.4679756164552,-0.519926607608795 48.4736328124999,-0.518987476825714 48.4834556579589,-0.534906804561615 48.4915466308595,-0.534906804561615 48.4915466308595,-0.553156673908234 48.4729652404785,-0.557991862297001 48.4721717834474,-0.564255356788578 48.4768562316895,-0.564255356788578 48.4768562316895,-0.571638762950897 48.4689254760742,-0.571638762950897 48.4689254760742,-0.565793931484222 48.4640235900879,-0.555729389190617 48.4637680053711,-0.543342769145966 48.4579963684083,-0.524097204208317 48.4546699523926,-0.513000428676605 48.4610061645509)) | 0.0006 | POINT(-0.5425835567362001 48.47142926384425) |
1409288 | MULTIPOLYGON(((-2.70681095123291 43.3272476196289,-2.70153188705439 43.3267860412598,-2.69928908348078 43.3279037475587,-2.69617199897766 43.3244857788087,-2.68664908409113 43.3229560852051,-2.67713809013367 43.32377243042,-2.67615389823902 43.3267898559571,-2.67298603057856 43.3258056640626,-2.67594194412226 43.318790435791,-2.67167091369623 43.3149070739747,-2.67149090766907 43.3090362548829,-2.67575502395624 43.3067321777344,-2.6762540340423 43.3036537170411,-2.68510603904724 43.2992553710938,-2.68600010871887 43.2953300476074,-2.6922628879546 43.2961730957031,-2.70172810554493 43.3040580749512,-2.71328806877131 43.3053932189941,-2.71771597862244 43.3075828552247,-2.7092928886413 43.3185310363771,-2.70681095123291 43.3272476196289)),((-2.65646409988403 43.2943458557129,-2.66101598739624 43.2927894592285,-2.66183590888977 43.2924156188964,-2.66710305213923 43.2940979003906,-2.66516590118403 43.2952995300293,-2.65646409988403 43.2943458557129))) | 0.0006 | POINT(-2.6892039238631935 43.31391670005522) |
26915 | POLYGON((-1.35258376598358 48.6498718261718,-1.3372163772583 48.6552238464356,-1.3372163772583 48.6552238464356,-1.3157799243927 48.6628684997559,-1.31384527683258 48.675838470459,-1.31384527683258 48.675838470459,-1.34157729148865 48.6785888671876,-1.34157729148865 48.6785888671876,-1.35472166538239 48.6781425476075,-1.35472023487085 48.6751899719238,-1.35472023487085 48.6751899719238,-1.35258376598358 48.6498718261718)) | 0.0006 | POINT(-1.3379821560599483 48.6691422895952) |
40344 | POLYGON((1.81437766551977 45.3213081359863,1.80308771133423 45.3168220520021,1.7941416502 45.3179206848145,1.7941416502 45.3179206848145,1.78977763652796 45.3366622924805,1.7680088281632 45.3481216430664,1.7680088281632 45.3481216430664,1.76911830902111 45.356861114502,1.76911830902111 45.356861114502,1.78526508808142 45.3620719909667,1.78526508808142 45.3620719909667,1.79065239429485 45.3569412231446,1.79147088527685 45.343360900879,1.79621052742016 45.3426818847657,1.80452954769135 45.3453941345215,1.80907928943634 45.3619461059571,1.8223956823349 45.3622970581055,1.8223956823349 45.3622970581055,1.82968044281012 45.3578872680665,1.83699762821203 45.3622589111329,1.856036901474 45.3626174926758,1.84413647651672 45.3445205688477,1.84891438484186 45.3277549743652,1.84891438484186 45.3277549743652,1.81437766551977 45.3213081359863)) | 0.0006 | POINT(1.8059052079916402 45.345935662587515) |
60378 | POLYGON((8.2441349029541 47.1257476806641,8.24278926849371 47.1214981079103,8.23852443695068 47.1182327270509,8.23975944519054 47.1126022338867,8.23385906219482 47.0984687805177,8.23421669006348 47.096549987793,8.23753261566162 47.0944976806641,8.23753261566162 47.0944976806641,8.24357223510742 47.0907402038574,8.2495107650758 47.0902709960938,8.25495815277105 47.0874481201172,8.26356124877941 47.088436126709,8.27256774902349 47.0936317443848,8.28431606292725 47.0967483520508,8.28918457031261 47.0995063781738,8.295087814331 47.1001052856446,8.29893493652355 47.1041145324707,8.30604839324963 47.1046257019042,8.30779170989996 47.1081428527833,8.31190967559814 47.1082420349122,8.31411933898926 47.1100158691407,8.31411933898926 47.1100158691407,8.31428146362316 47.1143188476562,8.30784416198742 47.117546081543,8.30369663238537 47.1177482604982,8.29428291320801 47.1136283874512,8.28800582885742 47.1142807006836,8.28748512268072 47.1168289184571,8.291735649109 47.1197624206543,8.29221153259289 47.1227684020996,8.29221153259289 47.1227684020996,8.28559875488276 47.1224937438965,8.28012180328369 47.1204566955566,8.27463436126715 47.1202812194824,8.26658058166498 47.122341156006,8.26103591918951 47.1214523315431,8.25258064270025 47.1226615905762,8.24724006652838 47.1256332397462,8.2441349029541 47.1257476806641)) | 0.0006 | POINT(8.275094157771106 47.10971340380221) |