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 |
---|---|---|---|
42205 | POLYGON((6.5866847038269 48.8100547790527,6.58076715469372 48.8153800964355,6.57181692123413 48.8124885559082,6.57181692123413 48.8124885559082,6.56897163391119 48.8220977783203,6.55372238159185 48.8305931091308,6.55372238159185 48.8305931091308,6.55677175521851 48.842700958252,6.57036876678478 48.8434829711914,6.57036876678478 48.8434829711914,6.58161640167242 48.8426170349121,6.58161640167242 48.8426170349121,6.6122717857362 48.8460693359376,6.6122717857362 48.8460693359376,6.62003707885742 48.8382797241212,6.61507225036632 48.8294296264649,6.61507225036632 48.8294296264649,6.60030078887945 48.8252296447755,6.5866847038269 48.8100547790527)) | 0.0006 | POINT(6.584626118342145 48.83128356933596) |
43861 | POLYGON((2.56871342658997 44.3406066894531,2.53973793983459 44.3608245849609,2.53973793983459 44.3608245849609,2.53036546707159 44.3607368469238,2.52418589591991 44.3554992675781,2.5230250358581 44.3354225158692,2.5230250358581 44.3354225158692,2.54030466079723 44.3234329223632,2.55464029312145 44.3246345520021,2.56773281097406 44.3162155151367,2.56773281097406 44.3162155151367,2.57575988769543 44.3191719055176,2.57575988769543 44.3191719055176,2.57840991020214 44.3219451904297,2.56871342658997 44.3406066894531)) | 0.0006 | POINT(2.5506522144590464 44.3350088936942) |
1390506 | POLYGON((-1.71404898166651 41.5984458923341,-1.71780502796167 41.597225189209,-1.72148597240442 41.5930519104004,-1.72983205318451 41.5896759033203,-1.7280490398407 41.5740852355956,-1.73072695732117 41.5634956359864,-1.72987997531885 41.5608520507813,-1.73255300521851 41.5547866821289,-1.73294305801392 41.5477371215821,-1.73707699775696 41.5416946411134,-1.73926997184753 41.541187286377,-1.74803304672236 41.5448951721191,-1.75422096252441 41.5447540283204,-1.76264905929565 41.5492057800294,-1.77007699012751 41.5470428466798,-1.77446901798243 41.5449562072754,-1.77433204650879 41.5432586669923,-1.78277802467346 41.5397300720216,-1.79971504211426 41.5398902893068,-1.80308103561401 41.5498123168945,-1.81123805046082 41.5529060363769,-1.81776094436646 41.5521812438965,-1.83224499225611 41.5589408874512,-1.83601403236389 41.5633735656739,-1.8383070230484 41.5731887817384,-1.8437340259552 41.5763130187989,-1.86080694198608 41.5931091308594,-1.86530995368958 41.6065940856934,-1.87262201309198 41.6105308532715,-1.87066400051111 41.6147537231446,-1.86766195297241 41.6162796020509,-1.85691905021667 41.6183738708496,-1.84892094135284 41.6144943237305,-1.84371101856232 41.6145553588868,-1.8354040384292 41.6113281250001,-1.83077704906458 41.6124076843263,-1.82650995254517 41.6113204956056,-1.8198029994964 41.6139297485352,-1.81817603111267 41.6162872314454,-1.81597602367401 41.6170768737794,-1.8138250112533 41.616008758545,-1.80355000495905 41.6199188232423,-1.79720294475544 41.6325874328614,-1.79882097244263 41.640480041504,-1.79555499553675 41.6521987915039,-1.79307794570917 41.6523437500001,-1.78187298774719 41.6465225219727,-1.77911996841431 41.6423416137696,-1.76637494564056 41.6419372558594,-1.75671899318695 41.6340065002441,-1.74988400936127 41.6248970031739,-1.74339294433594 41.6222610473633,-1.74019694328308 41.6180839538575,-1.7298680543899 41.6140937805177,-1.72573602199554 41.6087341308594,-1.72012901306141 41.6071434020996,-1.71353995800018 41.5998535156251,-1.71404898166651 41.5984458923341)) | 0.0006 | POINT(-1.7860430353566001 41.5927568402207) |
39614 | POLYGON((2.77795100212103 43.3973960876465,2.75880980491638 43.4135398864746,2.75880980491638 43.4135398864746,2.74465823173534 43.396053314209,2.73053050041204 43.3964157104493,2.72317290306091 43.3922424316407,2.72317290306091 43.3922424316407,2.71164202690125 43.3791580200195,2.71498274803173 43.3770065307617,2.71498274803173 43.3770065307617,2.72737002372742 43.373405456543,2.73664116859436 43.3740119934083,2.75087523460394 43.3820266723633,2.7594952583313 43.3794174194337,2.7594952583313 43.3794174194337,2.76481795310974 43.3928146362306,2.77795100212103 43.3973960876465)) | 0.0006 | POINT(2.74108797311786 43.38848090171818) |
1401516 | POLYGON((-2.19887995719904 41.955867767334,-2.20445299148554 41.960922241211,-2.1883299350738 41.968635559082,-2.18103194236755 41.9702415466308,-2.17997002601618 41.9758796691895,-2.18354392051697 41.988956451416,-2.18212604522699 41.992172241211,-2.17177009582514 41.9947929382325,-2.16722702980036 41.9903450012208,-2.15935802459717 41.9958000183105,-2.14722800254822 41.9881439208985,-2.13989591598511 41.9742126464844,-2.1355218887328 41.9602546691895,-2.11508297920227 41.9660987854004,-2.11603593826288 41.9635734558105,-2.10989999771112 41.9578704833985,-2.1003799438476 41.9552726745606,-2.09106111526484 41.9563331604004,-2.08616805076593 41.9543952941896,-2.08006191253656 41.9543571472169,-2.07830905914307 41.9513320922852,-2.07615494728083 41.9508857727051,-2.07864904403687 41.948600769043,-2.07712411880493 41.9430580139161,-2.08194208145136 41.9377174377442,-2.07390809059143 41.9318695068359,-2.07105493545527 41.9281387329103,-2.07111406326288 41.9241638183595,-2.07569289207453 41.9278335571289,-2.08072996139521 41.9255485534669,-2.08145403862 41.9271965026855,-2.08947706222534 41.9296264648438,-2.10465407371515 41.9283409118652,-2.1159451007843 41.9308815002442,-2.12972211837769 41.9297332763672,-2.14960098266596 41.9413833618164,-2.14376592636108 41.9457359313965,-2.14328694343567 41.9517211914063,-2.16513109207153 41.9569053649902,-2.17661094665527 41.9620704650879,-2.18747806549067 41.9634437561036,-2.19887995719904 41.955867767334)) | 0.0006 | POINT(-2.126581250167442 41.95512957689242) |
25523 | POLYGON((3.01164555549627 48.3978996276856,2.99332642555243 48.3959808349611,2.99332642555243 48.3959808349611,2.98516774177551 48.3921318054199,2.98486065864574 48.3791656494142,2.98486065864574 48.3791656494142,2.99342322349543 48.376522064209,2.99415373802185 48.366268157959,2.99928450584417 48.3665733337402,3.00745415687555 48.3748931884766,3.01201820373547 48.3733024597169,3.01394653320312 48.3633499145509,3.01394653320312 48.3633499145509,3.02347660064697 48.3592910766602,3.02347660064697 48.3592910766602,3.03208351135254 48.3715782165528,3.04741144180309 48.3735160827637,3.0728738307954 48.3695106506348,3.0728738307954 48.3695106506348,3.07525920867926 48.3757438659668,3.07525920867926 48.3757438659668,3.07604670524603 48.3973617553711,3.07604670524603 48.3973617553711,3.06411123275763 48.4032516479492,3.04562282562262 48.3975830078125,3.03050589561474 48.3986320495605,3.02122330665594 48.3957748413087,3.01164555549627 48.3978996276856)) | 0.0006 | POINT(3.02680315794773 48.380323480676765) |
62573 | POLYGON((9.67237758636486 51.5684051513672,9.68400382995617 51.5665321350098,9.68597221374512 51.5686798095703,9.68835163116466 51.5744552612305,9.69094753265381 51.576316833496,9.68533039093012 51.5820159912111,9.68533039093012 51.5820159912111,9.68773365020758 51.584285736084,9.68755626678478 51.5878562927246,9.69050884246826 51.5872802734376,9.69318675994879 51.5893669128419,9.70202541351318 51.5918922424316,9.70551013946545 51.5958480834962,9.72238731384277 51.6015281677247,9.72670841217047 51.6065864562988,9.72666931152344 51.6088714599611,9.72857570648199 51.6123733520508,9.73156738281244 51.6132774353027,9.73156738281244 51.6132774353027,9.74312877655029 51.6144981384278,9.75188827514643 51.6112480163575,9.75871944427496 51.6103134155273,9.76156997680675 51.6089973449708,9.77474498748774 51.6075096130371,9.77973937988287 51.6083984375,9.77875709533691 51.6100807189942,9.78304100036621 51.6099166870117,9.7901811599732 51.6074600219727,9.79372787475592 51.6111221313477,9.79748725891113 51.6116065979004,9.79702091217035 51.6082878112793,9.7961101531983 51.6078300476075,9.79642105102545 51.6049995422364,9.79963016510021 51.6051826477052,9.80229377746588 51.601692199707,9.80440330505371 51.6033973693848,9.80629634857189 51.6033744812012,9.80707263946533 51.6017303466797,9.80653285980225 51.5992088317872,9.81524848937994 51.5988540649414,9.81590270996094 51.5972824096681,9.81590270996094 51.5972824096681,9.81565189361584 51.5960693359376,9.81749629974371 51.5956993103027,9.81614112854004 51.5945892333986,9.81775856018072 51.5943450927735,9.822099685669 51.588176727295,9.8187084197998 51.5849685668946,9.81607627868652 51.58646774292,9.81508445739746 51.5843315124512,9.82167053222662 51.5836296081544,9.82342147827148 51.5824851989747,9.8223114013673 51.5804443359376,9.82392501831066 51.5784301757812,9.82306003570562 51.5775451660157,9.8242912292481 51.5743598937988,9.82571792602539 51.5731353759766,9.82571792602539 51.5731353759766,9.82647418975824 51.5683479309083,9.81501865386969 51.5659713745118,9.81433582305908 51.5643310546875,9.81151485443115 51.562786102295,9.81922054290777 51.5589485168458,9.81812858581543 51.5578956604005,9.8185663223266 51.5567054748536,9.81107330322277 51.5507469177247,9.80564975738525 51.5488243103028,9.80688095092773 51.5465888977051,9.80944919586182 51.5456771850587,9.80418205261225 51.5438041687012,9.80399131774897 51.5411758422853,9.80033302307129 51.5388221740724,9.80033302307129 51.5388221740724,9.79702854156494 51.5407371520996,9.79174900054937 51.5406684875489,9.79153728485102 51.5364570617676,9.78320503234869 51.5343551635742,9.78265666961676 51.5334892272949,9.77402019500732 51.5314025878907,9.77314090728771 51.5322799682617,9.76803588867188 51.5312690734863,9.76832389831537 51.5304145812989,9.76116275787348 51.5299301147462,9.75942134857178 51.5314750671387,9.75720214843756 51.5313453674318,9.75565719604504 51.5234260559082,9.75270462036133 51.5231819152833,9.75270462036133 51.5231819152833,9.74320602416998 51.5219535827637,9.7339878082276 51.52640914917,9.73104190826416 51.5257415771486,9.72470283508312 51.5296325683594,9.7189302444458 51.5306015014648,9.70375633239752 51.5295715332032,9.70362186431885 51.5306243896485,9.69826030731195 51.5316009521485,9.69478607177734 51.5402984619141,9.68715190887463 51.539608001709,9.6819925308227 51.5409049987794,9.6819925308227 51.5409049987794,9.68357467651379 51.5516929626465,9.66177272796631 51.5499305725098,9.65935325622564 51.5535850524902,9.65838146209728 51.5570144653321,9.65838146209728 51.5570144653321,9.66196537017817 51.5583534240723,9.66096496582043 51.5625305175782,9.668857574463 51.5634765625001,9.67237758636486 51.5684051513672)) | 0.0006 | POINT(9.760941169880084 51.57040242795592) |
34192 | POLYGON((5.4744958877564 48.3545684814454,5.46888160705561 48.3491973876954,5.45987510681152 48.3494911193848,5.44382524490356 48.3368339538574,5.42604827880865 48.3310623168946,5.42604827880865 48.3310623168946,5.42614269256603 48.3304748535157,5.42614269256603 48.3304748535157,5.44010448455805 48.3264694213868,5.45300102233887 48.3161773681641,5.45278739929199 48.3127403259277,5.45278739929199 48.3127403259277,5.4581561088562 48.3124046325684,5.4581561088562 48.3124046325684,5.46904611587536 48.3118362426759,5.46904611587536 48.3118362426759,5.50061607360851 48.3170776367188,5.50061607360851 48.3170776367188,5.5063467025758 48.3217926025392,5.53351402282715 48.3251037597656,5.53351402282715 48.3251037597656,5.52302217483515 48.3405113220215,5.52652692794794 48.3468551635742,5.52652692794794 48.3468551635742,5.50706338882446 48.3501586914063,5.49938535690308 48.3545532226564,5.4744958877564 48.3545684814454)) | 0.0006 | POINT(5.475449085235621 48.32980243976303) |
72215 | POLYGON((13.5527925491334 48.1861000061035,13.5791645050049 48.2018852233888,13.5791645050049 48.2018852233888,13.6082353591919 48.1950035095216,13.6130027770997 48.1930465698243,13.6128931045532 48.1912651062012,13.6047821044923 48.1824493408204,13.6069011688232 48.1780014038086,13.6129016876221 48.1719131469727,13.6129016876221 48.1719131469727,13.5672092437745 48.1758003234863,13.5619993209839 48.1784896850587,13.5527925491334 48.1861000061035)) | 0.0006 | POINT(13.592662334442176 48.18564605712897) |
62955 | POLYGON((13.4942502975465 54.0946197509766,13.4908332824708 54.0973434448243,13.4908332824708 54.0973434448243,13.4886112213135 54.0976371765137,13.4863891601562 54.0998611450196,13.4858331680297 54.1020851135255,13.4847230911256 54.1026382446289,13.4836111068726 54.1104164123536,13.4808330535889 54.1123619079591,13.4786100387574 54.1120834350587,13.4780569076539 54.1145820617676,13.4763879776002 54.1159706115723,13.4769439697266 54.118751525879,13.4908332824708 54.1243057250978,13.5002784729004 54.1265258789063,13.5080566406251 54.1270828247071,13.5097227096557 54.1281929016114,13.5241680145264 54.1287498474122,13.5286121368408 54.1304168701173,13.551040649414 54.1298599243163,13.551040649414 54.1298599243163,13.5563516616822 54.1219520568847,13.5578613281251 54.1216621398926,13.5586156845094 54.1124496459962,13.5565948486328 54.1102600097656,13.5527734756469 54.1085739135742,13.5493612289429 54.1096343994142,13.5433502197267 54.103786468506,13.5424966812134 54.1018829345703,13.538498878479 54.0991859436036,13.538498878479 54.0991859436036,13.5276651382446 54.0990982055665,13.5184507369996 54.0974617004395,13.5180568695068 54.0950965881348,13.4942502975465 54.0946197509766)) | 0.0006 | POINT(13.515242492451419 54.11120347415705) |