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 |
|---|---|---|---|
| 61675 | POLYGON((8.62933158874512 47.4365997314453,8.63519287109386 47.4344673156738,8.63790225982677 47.4321823120118,8.64364528656006 47.4314422607423,8.65245628356939 47.4275436401368,8.66048717498779 47.4256057739258,8.66048717498779 47.4256057739258,8.66130828857433 47.4285316467285,8.65810775756842 47.431583404541,8.65728473663324 47.4339141845704,8.65833759307867 47.4368896484376,8.66129779815674 47.4392204284668,8.66129779815674 47.4392204284668,8.64827632904058 47.4454078674317,8.64221954345709 47.4498519897462,8.63772296905523 47.4570999145508,8.62787342071545 47.4624977111816,8.62787342071545 47.4624977111816,8.61978530883795 47.4646835327148,8.61283493041992 47.4610900878907,8.60781288146967 47.4564666748047,8.60755634307861 47.449089050293,8.60570907592785 47.4449462890626,8.60570907592785 47.4449462890626,8.60971641540533 47.4412651062013,8.61267852783214 47.4400444030762,8.61902999877935 47.4392395019532,8.62261295318615 47.4404106140137,8.62794399261469 47.4396095275879,8.62933158874512 47.4365997314453)) | 0.0006 | POINT(8.634913510289731 47.4421363041319) |
| 46838 | POLYGON((2.97173643112183 50.6336479187012,2.96308255195618 50.6201934814453,2.96308255195618 50.6201934814453,2.94132375717174 50.6253890991212,2.94132375717174 50.6253890991212,2.94127964973455 50.6269149780274,2.94127964973455 50.6269149780274,2.96129775047302 50.6296577453613,2.97001504898077 50.6336631774902,2.97001504898077 50.6336631774902,2.97173643112183 50.6336479187012)) | 0.0006 | POINT(2.956443619728133 50.62756271362307) |
| 71372 | POLYGON((14.854546546936 46.6756134033203,14.8009662628173 46.6727905273438,14.8009662628173 46.6727905273438,14.7795991897584 46.6751747131348,14.7738018035889 46.6743469238282,14.7662210464477 46.6709938049317,14.7613220214844 46.6711044311524,14.7542352676392 46.6742515563965,14.7324333190919 46.6869239807128,14.7250928878784 46.6893577575685,14.7187042236328 46.6881027221681,14.7044467926025 46.6810150146485,14.7044467926025 46.6810150146485,14.7075662612916 46.6669120788574,14.7096433639526 46.6621170043946,14.7233638763428 46.6525421142578,14.7260732650758 46.6494407653809,14.7283973693848 46.6332130432129,14.7283973693848 46.6332130432129,14.7334852218628 46.6331520080566,14.7334852218628 46.6331520080566,14.7772874832154 46.6297950744629,14.7837047576904 46.6316146850587,14.8037366867066 46.6414413452148,14.8099050521851 46.6425590515137,14.8203296661378 46.6426239013672,14.8203296661378 46.6426239013672,14.8274421691895 46.6448707580567,14.8307056427003 46.6470565795899,14.8393850326539 46.6645355224609,14.8490953445434 46.6651268005372,14.8490953445434 46.6651268005372,14.854546546936 46.6756134033203)) | 0.0006 | POINT(14.771194100379967 46.65920615196231) |
| 70439 | POLYGON((12.0328931808472 50.7130470275879,12.0359687805176 50.7091636657715,12.0364427566529 50.7067642211914,12.0362367630005 50.7056694030763,12.0339212417604 50.704647064209,12.0339279174804 50.703540802002,12.0373106002808 50.7021255493165,12.0368213653566 50.700180053711,12.0306959152222 50.6970405578614,12.032377243042 50.6947402954101,12.0305280685426 50.6932258605958,12.0319204330445 50.6898689270019,12.0384206771851 50.6893577575684,12.0417194366456 50.6871452331544,12.0435695648194 50.6869773864747,12.0459833145142 50.6914367675782,12.0531892776489 50.695110321045,12.0560884475709 50.6923713684082,12.0582914352417 50.6934471130372,12.0558671951295 50.6955261230469,12.0563240051271 50.6977424621582,12.0623655319215 50.7012939453126,12.0630416870118 50.6973533630371,12.0733633041383 50.700912475586,12.0769548416137 50.6977310180665,12.0751171112061 50.6957778930665,12.0761299133302 50.6955490112305,12.0761299133302 50.6955490112305,12.0791425704957 50.6987380981445,12.0793285369873 50.7004699707031,12.0774974822999 50.6986885070801,12.0740718841554 50.7013244628907,12.0774669647217 50.7011528015137,12.0759105682373 50.7029037475587,12.0769081115724 50.703067779541,12.0782814025878 50.7017822265626,12.0798692703247 50.7017860412598,12.0749378204347 50.7051467895508,12.0746212005616 50.7146835327149,12.0696763992311 50.7160186767579,12.068639755249 50.7176246643067,12.0684852600098 50.7189598083497,12.0706930160524 50.7222137451172,12.0691585540771 50.7246398925782,12.0691585540771 50.7246398925782,12.0594015121461 50.7266693115235,12.0536375045776 50.7298622131348,12.0430126190187 50.7250175476074,12.0398855209351 50.7217559814454,12.0372152328491 50.7216033935548,12.0354909896851 50.720043182373,12.0354909896851 50.720043182373,12.0363788604737 50.7164459228517,12.0328931808472 50.7130470275879)) | 0.0006 | POINT(12.055961518917497 50.70506747263785) |
| 73319 | POLYGON((14.5324420928955 46.1717834472657,14.5324029922485 46.1646728515626,14.5272541046142 46.1575546264648,14.5170297622681 46.1575431823731,14.5118408203126 46.1433181762696,14.5067281723024 46.1433105468751,14.5067281723024 46.1433105468751,14.5117835998536 46.1326484680175,14.5117835998536 46.1326484680175,14.5373620986938 46.1362342834474,14.547589302063 46.1362419128419,14.5527400970459 46.1433601379395,14.568076133728 46.1433753967285,14.568076133728 46.1433753967285,14.56809425354 46.1469306945802,14.5732059478761 46.1469383239747,14.5834512710572 46.150505065918,14.5834865570068 46.1576156616212,14.5783777236938 46.1576080322266,14.5785303115846 46.1860542297363,14.5785303115846 46.1860542297363,14.5785493850709 46.1896095275879,14.5683240890503 46.1895980834961,14.5683240890503 46.1895980834961,14.5529699325562 46.1860275268555,14.5529489517213 46.182472229004,14.5324621200562 46.1753387451172,14.5324420928955 46.1717834472657)) | 0.0006 | POINT(14.549225630583626 46.159026958324326) |
| 39794 | POLYGON((4.04754924774164 43.6231689453126,4.04621267318731 43.6300125122071,4.06149339675915 43.6383590698242,4.06149339675915 43.6383590698242,4.08045053482061 43.6232261657715,4.08279657363892 43.6097145080567,4.08279657363892 43.6097145080567,4.07271957397472 43.6026077270509,4.05983209609997 43.5987663269043,4.05167150497448 43.6068077087402,4.04754924774164 43.6231689453126)) | 0.0006 | POINT(4.064701557159487 43.618073654174836) |
| 69412 | POLYGON((8.6431360244751 54.3446807861328,8.64684772491455 54.3451614379884,8.6472692489624 54.343578338623,8.65276622772222 54.3429031372071,8.65908336639416 54.346965789795,8.65778064727789 54.3529167175294,8.65778064727789 54.3529167175294,8.66305732727056 54.3523597717285,8.66361045837402 54.3545837402344,8.66472339630121 54.3551406860352,8.67249870300299 54.3531951904298,8.67638874053955 54.3531951904298,8.68583202362055 54.3570823669435,8.6841659545899 54.358196258545,8.6813898086549 54.3570823669435,8.68083381652843 54.3595848083497,8.67305469512951 54.3601379394531,8.67305469512951 54.3634719848634,8.67694568634033 54.3640098571777,8.67694568634033 54.3640098571777,8.69335365295416 54.3652725219727,8.69331550598145 54.3674049377443,8.69522190094 54.3661003112792,8.7049036026001 54.3647994995118,8.71095657348638 54.3564720153809,8.71401596069342 54.3546371459962,8.71317195892345 54.3538627624513,8.71317195892345 54.3538627624513,8.70659351348883 54.3479042053223,8.69615077972418 54.3465423583984,8.69655609130865 54.340919494629,8.68105602264416 54.3388900756837,8.67670345306402 54.3389434814453,8.67288970947271 54.3408012390137,8.6679573059082 54.3400459289551,8.66059684753418 54.3364105224611,8.65500450134272 54.3360061645509,8.65500450134272 54.3360061645509,8.65152835845947 54.335693359375,8.64410591125488 54.3381614685059,8.64628124237066 54.3385848999023,8.6431360244751 54.3446807861328)) | 0.0006 | POINT(8.67526107881131 54.350694982017025) |
| 48182 | POLYGON((-0.324862897396031 47.5988159179688,-0.325159698724633 47.5849800109864,-0.33025324344635 47.578899383545,-0.328599572181645 47.5649719238281,-0.333770722150746 47.5591011047364,-0.333770722150746 47.5591011047364,-0.320792198181096 47.5545806884766,-0.320792198181096 47.5545806884766,-0.301726311445236 47.5548782348633,-0.301726311445236 47.5548782348633,-0.284673035144806 47.5705947875977,-0.266887485980988 47.5751571655274,-0.266887485980988 47.5751571655274,-0.266120612621307 47.5856933593751,-0.272085636854172 47.5954627990723,-0.268515378236714 47.6056709289552,-0.268515378236714 47.6056709289552,-0.27109032869339 47.6105155944824,-0.27109032869339 47.6105155944824,-0.280870974063873 47.6086044311525,-0.285817801952362 47.6028327941894,-0.31046745181078 47.6065979003906,-0.324862897396031 47.5988159179688)) | 0.0006 | POINT(-0.2970216260714681 47.582602761008566) |
| 66407 | POLYGON((10.840259552002 48.2489471435546,10.826455116272 48.254005432129,10.8268766403198 48.2545776367188,10.817177772522 48.2598838806153,10.8138341903687 48.2592201232911,10.8107385635377 48.257266998291,10.8045988082886 48.2593536376954,10.8053283691407 48.2597389221191,10.7998552322388 48.262996673584,10.8028945922853 48.2668304443361,10.7926902770997 48.269474029541,10.7909927368165 48.2673034667969,10.7876491546631 48.2682418823242,10.7869157791138 48.2676277160645,10.7824611663818 48.2681427001954,10.7790803909302 48.2655143737794,10.7791643142701 48.263771057129,10.7755632400514 48.2626571655275,10.7778749465942 48.262020111084,10.7721385955812 48.2594642639161,10.7724981307984 48.2587623596191,10.7605152130128 48.2509689331055,10.7605152130128 48.2509689331055,10.7598094940186 48.2499198913575,10.7754306793213 48.2462234497071,10.792049407959 48.2388000488282,10.7930917739868 48.2398223876953,10.8124294281006 48.2330627441407,10.8131341934205 48.23388671875,10.8284387588502 48.2305793762207,10.8284387588502 48.2305793762207,10.8368148803712 48.2295646667482,10.8368148803712 48.2295646667482,10.8378047943115 48.2306594848633,10.833745956421 48.2313537597657,10.8383293151855 48.2365455627442,10.8419675827026 48.2429008483888,10.8424425125123 48.2453956604005,10.8432216644288 48.2452239990235,10.840259552002 48.2489471435546)) | 0.0006 | POINT(10.804616463490078 48.25107232118269) |
| 1400822 | POLYGON((-5.86086511611933 40.5533866882325,-5.85229778289789 40.5602073669434,-5.84933519363403 40.555778503418,-5.84590291976929 40.5606193542481,-5.83911800384521 40.5638389587403,-5.83739519119263 40.5697097778321,-5.82421493530262 40.5773086547852,-5.82081890106195 40.5816993713379,-5.82295894622803 40.5850868225099,-5.81748199462891 40.6037940979005,-5.81883382797241 40.6069488525392,-5.82447910308838 40.6088409423829,-5.83240604400629 40.6028785705566,-5.83919811248779 40.6014404296875,-5.85319805145264 40.6019515991212,-5.85567378997803 40.6040000915527,-5.85521078109736 40.6056327819825,-5.84527778625488 40.6104888916016,-5.84593486785877 40.6123275756836,-5.84174585342407 40.6138801574708,-5.84243392944336 40.6247787475587,-5.8343071937561 40.6282768249512,-5.82875013351435 40.6369781494141,-5.82063913345331 40.6422576904297,-5.8185510635376 40.6393165588379,-5.81429815292353 40.6393852233887,-5.80661106109619 40.6427459716797,-5.8048009872436 40.6384887695313,-5.81161308288574 40.6348953247071,-5.81291484832758 40.6323471069336,-5.79916191101069 40.6218299865723,-5.7960700988769 40.6100616455078,-5.7918758392334 40.6075325012208,-5.78732204437256 40.6014556884766,-5.7710719108581 40.5974235534669,-5.76923322677612 40.5946846008301,-5.77170801162714 40.5793609619141,-5.76865386962891 40.5723495483399,-5.77968502044678 40.5720062255861,-5.78246498107904 40.5695686340333,-5.80716419219965 40.5687561035157,-5.8243150711059 40.5664978027345,-5.83212089538574 40.5572662353516,-5.82799291610718 40.5551338195802,-5.83163499832148 40.5518989562989,-5.840744972229 40.5495338439942,-5.843924999237 40.5506973266601,-5.85356092452997 40.5459823608398,-5.86086511611933 40.5533866882325)) | 0.0006 | POINT(-5.821999430656405 40.593986034393346) |