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 |
|---|---|---|---|
| 57426 | MULTIPOLYGON(((7.58383083343517 49.6737442016602,7.56975746154791 49.6678619384766,7.56870365142822 49.6659278869629,7.56870365142822 49.6659278869629,7.57237386703503 49.6653366088867,7.57389307022106 49.6672592163086,7.58360481262207 49.6701850891114,7.58520746231079 49.6730155944825,7.58520746231079 49.6730155944825,7.58383083343517 49.6737442016602)),((7.57003116607666 49.6531219482423,7.56058788299566 49.6499595642091,7.54631185531616 49.6476097106934,7.54631185531616 49.6476097106934,7.54365634918224 49.6515274047852,7.54382562637329 49.6566276550294,7.5420498847962 49.6561851501465,7.53967142105114 49.6607704162598,7.53967142105114 49.6607704162598,7.55330228805548 49.6623954772949,7.55330228805548 49.6623954772949,7.5635929107666 49.6646194458008,7.56786680221552 49.6644134521484,7.56786680221552 49.6644134521484,7.5689115524292 49.6620864868165,7.57252597808838 49.6603584289551,7.57214117050171 49.6580352783204,7.56849813461309 49.6545944213868,7.57003116607666 49.6531219482423))) | 0.0006 | POINT(7.558843582209738 49.65887819793044) |
| 62095 | POLYGON((7.89232873916626 52.4764671325685,7.88642644882196 52.4757766723634,7.86739015579224 52.4807243347168,7.8488974571228 52.4806518554688,7.8488974571228 52.4806518554688,7.84408473968506 52.4766159057617,7.84424304962158 52.4722709655763,7.84193086624157 52.4703903198243,7.84427595138561 52.4643592834473,7.84427595138561 52.4643592834473,7.86306524276739 52.4557914733887,7.86154413223278 52.4530792236329,7.86194419860834 52.4488258361816,7.86049175262463 52.4487953186036,7.86084938049328 52.4465484619141,7.86327981948858 52.4465866088868,7.86256504058849 52.4439582824708,7.8643040657044 52.4441833496094,7.86573982238775 52.4423065185547,7.86841773986822 52.44234085083,7.86994552612305 52.4381332397462,7.86482191085821 52.4366188049316,7.86736869812017 52.4337387084962,7.8712100982666 52.4353523254395,7.87145090103149 52.4328384399415,7.87294387817377 52.4318771362305,7.87927007675177 52.418628692627,7.87830877304083 52.4164390563965,7.87153673172003 52.412956237793,7.86867523193359 52.4087867736816,7.88413000106823 52.404670715332,7.88810586929327 52.4000587463379,7.88976144790649 52.3927154541016,7.88975000381481 52.3816223144531,7.89177036285395 52.3805122375489,7.89177036285395 52.3805122375489,7.92168235778809 52.3656158447266,7.92168235778809 52.3656158447266,7.9303288459779 52.3642807006836,7.93666982650768 52.3649787902833,7.93666982650768 52.3649787902833,7.93730735778809 52.3660774230957,7.94346046447765 52.3691177368165,7.94372129440313 52.3715133666992,7.94129896163946 52.3755836486816,7.94248247146612 52.3757171630859,7.94915151596069 52.3747901916505,7.94973421096796 52.3723945617676,7.96871376037598 52.3670272827149,7.99448347091675 52.362548828125,7.99475240707403 52.3670196533204,7.99864721298218 52.3672981262208,7.9981684684754 52.3682441711426,8.00130844116205 52.3694152832031,8.0043420791626 52.3685531616212,8.00871086120611 52.3699722290039,8.00883293151855 52.3671226501465,8.01130008697521 52.3656272888185,8.0122652053833 52.3637046813966,8.01423645019531 52.3633575439454,8.01481533050543 52.361888885498,8.01970481872559 52.3629035949708,8.02580356597912 52.3619842529297,8.02607345581066 52.3635559082032,8.03222370147716 52.3636398315431,8.03300094604492 52.3611526489259,8.04079055786127 52.3590087890626,8.04414939880371 52.3609008789063,8.062074661255 52.3603515625001,8.06471443176275 52.3634986877442,8.07170104980474 52.3652305603028,8.07485008239746 52.3682098388673,8.09601306915283 52.3645133972169,8.09601306915283 52.3645133972169,8.10071086883545 52.364330291748,8.10366153717035 52.3668365478516,8.10965251922607 52.3694763183594,8.10783576965343 52.3701820373536,8.10605621337896 52.372413635254,8.11405181884771 52.371997833252,8.11557006835943 52.3727188110352,8.11630344390869 52.3713531494141,8.11887454986584 52.3712730407715,8.1178989410401 52.3744392395019,8.11980247497553 52.3743057250978,8.12025642395031 52.3787879943849,8.12666797637939 52.3781776428223,8.12666797637939 52.3781776428223,8.12690448760986 52.3799514770508,8.12543964385992 52.3809509277344,8.12577915191662 52.3853416442871,8.12902736663818 52.3875541687013,8.12803649902355 52.3898925781251,8.12985229492193 52.3908805847168,8.13024997711182 52.3939399719238,8.12860012054438 52.3989372253419,8.13156032562262 52.4062576293945,8.13512420654291 52.4060859680177,8.13589668273937 52.4078979492189,8.13890552520752 52.4097747802736,8.13876533508312 52.4132804870606,8.15919685363764 52.4329414367677,8.15919685363764 52.4329414367677,8.14143657684338 52.4382171630861,8.1315221786499 52.444507598877,8.11921119689941 52.4429740905762,8.0886869430542 52.4468727111818,8.07552528381348 52.4453887939454,8.06726169586182 52.4454460144043,8.06098937988281 52.4438056945801,8.05411815643305 52.4587326049805,8.05411815643305 52.4587326049805,8.04127597808849 52.4569625854492,8.03823184967052 52.4616966247559,8.03394985198986 52.4625663757324,8.02708530426031 52.4595909118653,8.02180957794189 52.4592132568361,8.02180290222168 52.4578399658204,8.01453018188477 52.4600524902344,8.00834465026861 52.4605522155762,7.99495029449457 52.4606552124024,7.99459505081177 52.4594764709474,7.99251604080212 52.4598617553711,7.99308395385754 52.4614181518555,7.98771047592169 52.462989807129,7.97479343414307 52.4697761535646,7.97091865539562 52.4703903198243,7.97091865539562 52.4703903198243,7.95963621139521 52.4598579406739,7.95349264144897 52.459327697754,7.94254159927362 52.4536972045898,7.93415689468384 52.4621162414551,7.91433143615723 52.4701194763184,7.91452074050915 52.4708976745607,7.90377902984613 52.4745750427246,7.90662956237793 52.4760322570801,7.89232873916626 52.4764671325685)) | 0.0006 | POINT(7.9937696421847955 52.4125579665689) |
| 1390146 | POLYGON((-1.01227796077723 42.5742263793945,-1.01725101470947 42.5872497558594,-1.01641201972956 42.5910110473633,-1.01865005493153 42.599235534668,-1.01487398147583 42.5991706848145,-1.0079380273819 42.6037406921387,-1.00798201560974 42.6085510253906,-1.00601196289063 42.6106262207031,-0.994309008121377 42.6087265014648,-0.976566016673985 42.6006164550782,-0.966804027557373 42.6013145446778,-0.967522025108224 42.5747451782228,-1.01227796077723 42.5742263793945)) | 0.0006 | POINT(-1.0005498429139041 42.59660116831464) |
| 44416 | POLYGON((1.38904082775122 43.3180732727051,1.37821233272558 43.3144454956054,1.37465167045599 43.3157424926759,1.37465167045599 43.3157424926759,1.37913405895245 43.3211097717286,1.37714374065405 43.3335876464844,1.37714374065405 43.3335876464844,1.39586055278778 43.3395881652832,1.39586055278778 43.3395881652832,1.42083871364605 43.3552436828614,1.43472266197216 43.3566246032715,1.43472266197216 43.3566246032715,1.44103777408611 43.3492736816407,1.44103777408611 43.3492736816407,1.40552520751959 43.3311309814454,1.38904082775122 43.3180732727051)) | 0.0006 | POINT(1.4013055960338048 43.33530909220382) |
| 53133 | POLYGON((6.66477251052862 44.3373603820801,6.69695472717291 44.3329658508301,6.72071981430065 44.3337059020997,6.73687362670904 44.3404846191407,6.74639177322393 44.34086227417,6.7550888061524 44.3328323364258,6.7550888061524 44.3328323364258,6.76050329208385 44.3423347473145,6.75583696365351 44.3518791198731,6.75759601593018 44.3723297119141,6.7378969192506 44.3818588256836,6.72705793380737 44.3970146179199,6.71680688858032 44.4043617248536,6.71680688858032 44.4043617248536,6.69845962524414 44.399845123291,6.68458557128901 44.3904342651367,6.67012596130377 44.3899345397949,6.67012596130377 44.3899345397949,6.67194557189947 44.3829269409181,6.66477251052862 44.3373603820801)) | 0.0006 | POINT(6.718086192482434 44.3662241885537) |
| 24775 | POLYGON((2.8651425838471 46.189853668213,2.82204294204723 46.1862258911133,2.82204294204723 46.1862258911133,2.81040477752697 46.1962127685548,2.81040477752697 46.1962127685548,2.81731295585644 46.2050209045411,2.81898069381714 46.2184143066406,2.82330846786505 46.2199630737305,2.82330846786505 46.2199630737305,2.84634780883789 46.2155990600587,2.85249829292309 46.2100982666016,2.86607670784002 46.2055053710938,2.86607670784002 46.2055053710938,2.86587023735058 46.1998023986816,2.85785079002392 46.1967849731446,2.85784602165228 46.1936149597169,2.8651425838471 46.189853668213)) | 0.0006 | POINT(2.8390946984291863 46.202812671661434) |
| 61506 | POLYGON((6.53039312362677 46.5611877441406,6.53287410736095 46.5572319030762,6.53768014907843 46.5536613464355,6.53768014907843 46.5536613464355,6.5252161026001 46.5409240722656,6.5252161026001 46.5409240722656,6.52056503295904 46.5406837463379,6.51413011550915 46.5424041748048,6.50918817520147 46.5418624877929,6.50918817520147 46.5418624877929,6.50596380233765 46.542106628418,6.50596380233765 46.542106628418,6.50642919540417 46.545467376709,6.51002597808849 46.5493125915528,6.51002597808849 46.5493125915528,6.51295185089117 46.5517768859864,6.51801776885986 46.5527954101562,6.5287652015686 46.5611991882325,6.5287652015686 46.5611991882325,6.53039312362677 46.5611877441406)) | 0.0006 | POINT(6.519423158545295 46.548930519505575) |
| 17390 | POLYGON((7.92139101028448 45.7028312683106,7.92499303817749 45.7072372436523,7.92499303817749 45.7072372436523,7.92915916442877 45.7056465148926,7.93902492523188 45.7060546875001,7.94064998626715 45.7118453979492,7.93965101242077 45.7134590148926,7.93965101242077 45.7134590148926,7.94817113876348 45.7110137939454,7.94817113876348 45.7110137939454,7.95868301391607 45.7141990661621,7.95868301391607 45.7141990661621,7.97665023803717 45.7116050720215,7.99277210235596 45.7120628356935,7.99986791610729 45.7150115966798,7.99986791610729 45.7150115966798,8.00174331665039 45.7140083312988,8.00174331665039 45.7140083312988,8.0046815872193 45.7122383117677,8.0046815872193 45.7122383117677,8.00849437713634 45.7053337097169,8.00849437713634 45.7053337097169,8.00819778442383 45.702220916748,8.00819778442383 45.702220916748,8.00502395629888 45.6984214782715,8.00502395629888 45.6984214782715,7.99352407455439 45.6969375610352,7.98334312438971 45.6878623962402,7.96898603439337 45.6865577697754,7.95129108428961 45.6816444396973,7.94653892517096 45.682945251465,7.93360996246344 45.6699600219728,7.93360996246344 45.6699600219728,7.93149089813227 45.6732177734376,7.92279720306391 45.6953659057618,7.92139101028448 45.7028312683106)) | 0.0006 | POINT(7.967538656507262 45.70230810982845) |
| 18852 | POLYGON((14.8454132080078 38.5658073425292,14.8641862869263 38.5776901245118,14.8731927871705 38.5784721374512,14.8731927871705 38.5784721374512,14.8731908798217 38.5770797729493,14.8718070983887 38.5762481689453,14.8720808029176 38.5715293884277,14.8759689331055 38.5623626708985,14.8731927871705 38.5590286254884,14.8726387023926 38.5548629760742,14.8698606491089 38.5537490844727,14.8687486648559 38.5512504577637,14.8698606491089 38.5431900024415,14.8720808029176 38.5370826721192,14.8551397323609 38.5334739685059,14.8463354110718 38.5379180908203,14.8463354110718 38.5379180908203,14.8492832183838 38.5427703857423,14.8498115539552 38.547634124756,14.8463640213013 38.5571784973146,14.8454132080078 38.5658073425292)) | 0.0006 | POINT(14.863434219360391 38.55718593597417) |
| 37342 | POLYGON((1.05126225948334 48.9432144165038,1.047658085823 48.9377288818359,1.047658085823 48.9377288818359,1.02442526817322 48.9307212829589,1.01933169364929 48.9300346374512,1.01159477233892 48.9345741271973,1.00270128250116 48.9315032958985,1.00270128250116 48.9315032958985,0.998319268226737 48.9375190734864,1.00006270408642 48.9507713317871,1.00006270408642 48.9507713317871,1.00324833393097 48.9517517089845,1.00324833393097 48.9517517089845,1.0170916318894 48.9497604370117,1.0170916318894 48.9497604370117,1.02693808078777 48.950855255127,1.04886317253113 48.9434623718263,1.04886317253113 48.9434623718263,1.05126225948334 48.9432144165038)) | 0.0006 | POINT(1.020617875787969 48.94204860263403) |