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 |
---|---|---|---|
55400 | POLYGON((6.18610763549805 46.1782188415528,6.18833398818975 46.1680984497071,6.17693471908581 46.1594963073732,6.17693471908581 46.1594963073732,6.17529916763311 46.158260345459,6.17529916763311 46.158260345459,6.19046020507818 46.1544723510743,6.19046020507818 46.1544723510743,6.20360612869274 46.1648483276367,6.22565603256226 46.1723442077637,6.24489355087286 46.1688194274903,6.24489355087286 46.1688194274903,6.24616718292248 46.1703987121583,6.24616718292248 46.1703987121583,6.2458238601684 46.1735801696778,6.23758459091187 46.1764106750489,6.23758459091187 46.1764106750489,6.23253917694097 46.1821517944336,6.22367715835571 46.1843566894532,6.22367715835571 46.1843566894532,6.21810579299927 46.1752052307129,6.19346857070923 46.1740722656251,6.18610763549805 46.1782188415528)) | 0.0006 | POINT(6.212894287976396 46.16967946832838) |
36860 | POLYGON((5.7892632484436 46.6163673400879,5.79235315322876 46.6324920654297,5.78202104568487 46.6432418823243,5.78202104568487 46.6432418823243,5.77894306182861 46.6459922790528,5.76398181915295 46.6460914611818,5.75181770324713 46.6358070373535,5.72737360000616 46.6392478942871,5.72737360000616 46.6392478942871,5.72474908828747 46.6369857788087,5.72474908828747 46.6369857788087,5.73242855072021 46.63285446167,5.73571252822882 46.619613647461,5.7583651542663 46.6135215759277,5.77624464035034 46.6151809692383,5.77624464035034 46.6151809692383,5.7892632484436 46.6163673400879)) | 0.0006 | POINT(5.757727622985879 46.63200330734258) |
32077 | POLYGON((0.298426210880223 47.0539779663087,0.281750857830048 47.0469360351562,0.26767656207096 47.0440483093262,0.264221280813217 47.0464324951172,0.264221280813217 47.0464324951172,0.263549834489822 47.0685081481934,0.243871793151015 47.0709495544434,0.235155329108181 47.069164276123,0.235155329108181 47.069164276123,0.234750792384261 47.0752525329589,0.244693726301193 47.0863456726074,0.244693726301193 47.0863456726074,0.2586506009103 47.0818862915039,0.284244686365184 47.0832748413087,0.303369581699428 47.0782279968262,0.303369581699428 47.0782279968262,0.305293381214142 47.0742988586425,0.305293381214142 47.0742988586425,0.310645788908062 47.0692977905273,0.309817850589809 47.0636940002442,0.298426210880223 47.0539779663087)) | 0.0006 | POINT(0.27294257879260025 47.06833820343017) |
33368 | POLYGON((4.30957698822021 49.7087860107423,4.33173847198498 49.7201042175294,4.33173847198498 49.7201042175294,4.34606218338024 49.7176971435547,4.34606218338024 49.7176971435547,4.33890485763555 49.7015838623046,4.34376478195202 49.6956443786622,4.33431529998785 49.6881637573243,4.33074998855597 49.678882598877,4.33074998855597 49.678882598877,4.31669521331793 49.6929931640624,4.30957698822021 49.7087860107423)) | 0.0006 | POINT(4.3327598571778125 49.70186719027436) |
13387 | POLYGON((15.9716444015503 38.6680450439454,15.9514961242677 38.6697998046876,15.9514961242677 38.6697998046876,15.9499044418335 38.6719436645509,15.9425935745239 38.6763038635254,15.9352731704712 38.6791496276855,15.933069229126 38.6820220947267,15.9357070922852 38.6842193603516,15.942747116089 38.6862335205079,15.9513874053956 38.6858367919923,15.9592266082764 38.6892776489259,15.9699382781982 38.6974563598634,15.9696893692017 38.6994323730469,15.9637832641603 38.7038078308106,15.9637832641603 38.7038078308106,15.9709730148315 38.7126388549805,15.971529006958 38.71541595459,15.9737510681153 38.7148628234864,15.9754171371461 38.7156944274903,15.9779167175293 38.7190284729004,15.9851398468018 38.7231941223145,15.9926376342773 38.7231941223145,15.9929161071777 38.7240295410156,15.9947156906128 38.7240295410156,15.9947156906128 38.7240295410156,15.9972372055054 38.7197456359863,16.0001773834229 38.708122253418,15.9997215270997 38.7026138305665,15.9949321746826 38.6969833374023,15.9896202087403 38.696475982666,15.9883155822755 38.6952552795411,15.9787788391114 38.6762962341309,15.9716444015503 38.6680450439454)) | 0.0006 | POINT(15.970944821834605 38.69871079921727) |
63648 | POLYGON((9.33495140075695 51.0136756896973,9.32564163208008 51.0151367187501,9.32366847991949 51.0142097473145,9.31905269622803 51.0156288146974,9.31389141082775 51.0144348144531,9.31727504730219 51.0126419067384,9.31441974639893 51.0104789733888,9.31280899047846 51.0076637268066,9.31494140625006 51.0051574707032,9.31285762786877 51.003517150879,9.30452632904053 51.0008583068848,9.30352973937994 50.9985618591309,9.30600357055664 50.9966545104981,9.30254936218256 50.9951171875001,9.30024528503429 50.9954414367676,9.29849624633783 50.9919509887695,9.29879951477062 50.9874114990235,9.29631996154797 50.9890060424806,9.29478168487549 50.9878463745118,9.2887659072876 50.9883766174316,9.28528976440441 50.9877281188965,9.28528976440441 50.9877281188965,9.28563213348394 50.9860763549805,9.29001903533941 50.9856986999511,9.29101181030285 50.9815254211426,9.28300476074219 50.9786338806153,9.28227615356457 50.9803276062013,9.28515148162842 50.9826431274415,9.28062057495117 50.984188079834,9.28043746948242 50.9819374084473,9.27819347381597 50.9805564880371,9.26489353179932 50.9773368835449,9.26128292083746 50.9743003845215,9.25567245483404 50.9714241027832,9.25209426879888 50.9714508056642,9.25209426879888 50.9714508056642,9.2495107650758 50.9700202941896,9.25549221038818 50.9701919555664,9.2628755569458 50.9674797058106,9.25863456726086 50.9635276794435,9.25811672210705 50.9594459533691,9.25418090820312 50.9590454101564,9.25045299530029 50.95565032959,9.25408077240002 50.9537544250489,9.25527000427246 50.9513549804688,9.25409317016602 50.9463653564453,9.26614189147949 50.9389610290528,9.27337741851812 50.937858581543,9.26922607421869 50.9343605041505,9.2760467529298 50.9311294555665,9.27917003631603 50.9309463500977,9.28473377227789 50.92728805542,9.28468322753901 50.9264945983887,9.28244972229004 50.9258766174316,9.28218555450439 50.9228439331056,9.28489303588873 50.9230461120606,9.28567218780523 50.9217796325685,9.28903293609631 50.9207725524903,9.2894201278686 50.9184341430665,9.29155158996593 50.9181861877441,9.29268646240229 50.9197273254395,9.29451656341564 50.9190139770509,9.29464244842541 50.9163665771484,9.29230403900146 50.9161643981934,9.28988361358648 50.91162109375,9.29160308837891 50.9084358215333,9.29735279083263 50.9056968688965,9.29961109161383 50.9031105041503,9.30264568328869 50.9024200439454,9.30264568328869 50.9024200439454,9.30370616912847 50.8993911743163,9.30661869049084 50.8962440490722,9.30661869049084 50.8962440490722,9.30931472778326 50.896541595459,9.31009006500244 50.8979339599609,9.31551647186279 50.8993949890137,9.31870174407965 50.9017219543458,9.32389163970953 50.9019203186036,9.32771587371826 50.9007949829102,9.33488368988037 50.9021873474121,9.3377828598023 50.9019050598145,9.33818054199224 50.9004516601563,9.33964538574219 50.8996925354004,9.34493827819824 50.8994026184083,9.35341548919683 50.9000854492188,9.35667610168457 50.9020042419434,9.35592269897455 50.902572631836,9.35344886779785 50.9013137817383,9.35150146484375 50.9018173217775,9.35195541381836 50.9035949707031,9.34403038024908 50.9035148620605,9.34227371215826 50.9060707092286,9.338454246521 50.9039993286133,9.33194446563721 50.907772064209,9.33341026306164 50.9087867736818,9.33203220367432 50.9096717834473,9.33578681945812 50.9133148193359,9.34073448181152 50.9140739440919,9.34126853942865 50.9189758300782,9.3488245010376 50.9214248657227,9.34892463684088 50.9225311279297,9.34647655487066 50.9230918884278,9.34676074981701 50.9242477416992,9.34987545013422 50.9243965148926,9.35142230987549 50.9228706359864,9.36221027374279 50.9212760925293,9.36551380157471 50.9218215942383,9.37230777740479 50.9199562072754,9.37568664550781 50.9220848083497,9.38187217712414 50.9224128723145,9.38537597656244 50.9247055053712,9.39363098144531 50.9248008728028,9.39363098144531 50.9248008728028,9.40073966979992 50.9306564331056,9.40192985534662 50.930305480957,9.4067440032959 50.933277130127,9.41263103485113 50.9348602294923,9.41263103485113 50.9348602294923,9.41370868682873 50.9368972778321,9.41235923767096 50.9391784667969,9.41520595550543 50.9471588134766,9.41903686523443 50.9502639770509,9.41296863555903 50.9557418823243,9.41619205474859 50.9598388671876,9.41333580017101 50.9613494873048,9.41412734985352 50.9652709960938,9.41557788848883 50.964771270752,9.41604328155518 50.9661979675294,9.41421127319342 50.966579437256,9.41202831268311 50.9745750427247,9.40990924835199 50.9768066406251,9.40746784210205 50.976978302002,9.4019565582276 50.974365234375,9.39729881286632 50.9754638671876,9.39425754547125 50.9744606018066,9.39156055450451 50.9799957275391,9.38585376739513 50.983180999756,9.37655353546143 50.9845848083496,9.37572765350336 50.9827613830567,9.37625503540045 50.9816131591797,9.38290214538574 50.9784469604493,9.38995552063 50.9773635864259,9.38792228698736 50.9736022949219,9.38342857360834 50.9743576049804,9.3804559707641 50.9705581665039,9.37444877624523 50.9708518981934,9.36956501007086 50.9794273376465,9.36524200439459 50.9813652038574,9.36425685882568 50.9831733703614,9.35383605957037 50.9819984436036,9.35186195373529 50.9834365844727,9.35159111022949 50.9845848083496,9.35413646698009 50.9859962463379,9.34998703002941 50.98832321167,9.3467903137207 50.9930686950684,9.34995555877697 50.9948005676271,9.34810733795172 50.9985733032226,9.35003852844244 50.9989128112793,9.34760093688965 51.0023384094238,9.35072422027588 51.0040512084962,9.35193157196045 51.0059967041017,9.34983444213867 51.0071640014648,9.34910774230963 51.0094070434571,9.34477138519287 51.0117378234864,9.34308338165289 51.0113639831544,9.33495140075695 51.0136756896973)) | 0.0006 | POINT(9.33191813844626 50.95279561823066) |
43378 | POLYGON((1.82956290245062 42.9201164245605,1.79650843143463 42.9201850891114,1.79650843143463 42.9201850891114,1.79353260993963 42.9226417541504,1.79357540607464 42.9388313293457,1.79357540607464 42.9388313293457,1.79598665237432 42.943561553955,1.79598665237432 42.943561553955,1.82524883747107 42.9313201904297,1.82524883747107 42.9313201904297,1.82956290245062 42.9201164245605)) | 0.0006 | POINT(1.8045734167099572 42.931055450439445) |
20818 | POLYGON((7.78001499176025 48.6387176513672,7.75573396682751 48.6357612609864,7.73800563812256 48.6402702331543,7.73800563812256 48.6402702331543,7.72886276245123 48.6384010314942,7.7191076278686 48.6264343261719,7.7191076278686 48.6264343261719,7.72089242935175 48.6228675842286,7.72089242935175 48.6228675842286,7.75040245056152 48.6270637512208,7.78001499176025 48.6387176513672)) | 0.0006 | POINT(7.737102556228633 48.63190879821782) |
39158 | POLYGON((3.94003009796137 44.2838745117188,3.93586063385015 44.2939529418946,3.92494344711315 44.3008270263672,3.92494344711315 44.3008270263672,3.92285895347607 44.3052253723145,3.92285895347607 44.3052253723145,3.94370388984686 44.3178863525392,3.94808268547052 44.3270568847656,3.9488189220429 44.3238487243653,3.9488189220429 44.3238487243653,3.95715045928966 44.3271064758302,3.96842384338379 44.3087043762207,3.97709774971014 44.305721282959,3.97709774971014 44.305721282959,4.00297927856445 44.3039779663085,4.00890922546381 44.2955780029296,4.00890922546381 44.2955780029296,3.99149727821361 44.2939987182618,3.99199461936956 44.2844505310059,3.98799228668207 44.2784194946288,3.98799228668207 44.2784194946288,3.96259379386902 44.2857933044434,3.95415830612194 44.2827072143555,3.94003009796137 44.2838745117188)) | 0.0006 | POINT(3.9625093936920526 44.30124996019447) |
67658 | POLYGON((9.09335899353027 48.6474800109863,9.08906841278076 48.645679473877,9.08780956268316 48.6436653137206,9.08780956268316 48.6436653137206,9.09241199493408 48.6365928649903,9.09718227386475 48.6325607299805,9.09840202331549 48.6293029785156,9.10126972198498 48.627727508545,9.1013298034668 48.6246986389161,9.09739303588873 48.6219329833985,9.09739303588873 48.6219329833985,9.10777378082281 48.6228103637695,9.107346534729 48.6172943115234,9.10828113555914 48.6162490844728,9.11390686035162 48.6160697937012,9.11713409423834 48.6138763427734,9.11420059204113 48.6114768981934,9.1119060516358 48.6077537536622,9.11270999908447 48.6071243286134,9.11047077178949 48.6059112548829,9.11291217803966 48.6033439636231,9.12147808074945 48.6003684997558,9.12917613983154 48.6012649536133,9.12917613983154 48.6012649536133,9.13725185394287 48.6013069152833,9.14472007751471 48.6036796569824,9.15122985839844 48.6040534973145,9.15122985839844 48.6040534973145,9.14920425415039 48.6125373840333,9.14385986328136 48.6179313659668,9.16713333129883 48.62451171875,9.16781139373791 48.6254997253419,9.16547870635992 48.6304359436036,9.16562557220453 48.6335144042969,9.16796684265137 48.6342163085939,9.17207622528076 48.6327896118165,9.17417240142828 48.6335449218751,9.17417240142828 48.6335449218751,9.16735458374029 48.6392364501953,9.16836166381842 48.6396522521974,9.16602325439464 48.6437530517579,9.16245079040533 48.645851135254,9.16245079040533 48.645851135254,9.15917396545422 48.6485099792481,9.15710258483892 48.6517562866212,9.15710258483892 48.6517562866212,9.15500926971447 48.6504096984863,9.15093421936041 48.6504974365234,9.14877891540539 48.6518630981446,9.14770984649658 48.6512489318849,9.1391334533692 48.6579895019532,9.13421058654797 48.653923034668,9.1309032440185 48.653263092041,9.1272287368775 48.649269104004,9.11816310882568 48.653491973877,9.11614990234381 48.6517486572267,9.12209224700939 48.6489639282227,9.1146183013916 48.6426010131837,9.10881519317627 48.643825531006,9.10472488403315 48.6468391418458,9.10472488403315 48.6468391418458,9.10218048095703 48.646583557129,9.10167789459234 48.6480140686036,9.1010885238648 48.647289276123,9.09921646118164 48.6486587524415,9.09335899353027 48.6474800109863)) | 0.0006 | POINT(9.129218673706092 48.63232850294848) |