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 |
|---|---|---|---|
| 49707 | POLYGON((3.82327032089233 49.4001693725587,3.83627486228954 49.3969268798829,3.83960771560675 49.3910064697267,3.83960771560675 49.3910064697267,3.85643005371094 49.3873481750488,3.85984420776379 49.3815231323242,3.85984420776379 49.3815231323242,3.89574146270763 49.3927803039551,3.89574146270763 49.3927803039551,3.89216566085815 49.3994293212892,3.88349151611328 49.4036102294923,3.86283564567572 49.4047775268556,3.86283564567572 49.4047775268556,3.85357713699352 49.4013252258301,3.82238268852245 49.4023780822755,3.82238268852245 49.4023780822755,3.82327032089233 49.4001693725587)) | 0.0006 | POINT(3.856627061963153 49.39585876464851) |
| 21739 | POLYGON((1.00249552726751 44.8260536193849,1.00325143337255 44.8261489868165,1.00325143337255 44.8261489868165,1.01351070404058 44.8173179626466,1.01351070404058 44.8173179626466,1.01250088214886 44.8086624145507,1.01250088214886 44.8086624145507,1.00840604305279 44.8096160888671,1.00444853305822 44.8042030334473,1.00444853305822 44.8042030334473,1.00057697296154 44.8059959411622,0.970901727676448 44.7985420227051,0.970901727676448 44.7985420227051,0.957952737808341 44.8085365295411,0.959686517715568 44.8151397705078,0.949123084545249 44.8261871337892,0.949123084545249 44.8261871337892,0.948056340217704 44.8325233459473,0.934031367302055 44.8404693603517,0.934636592865047 44.8436317443849,0.939075112342891 44.8441123962403,0.939075112342891 44.8441123962403,0.947309434414024 44.8401489257812,0.951881587505341 44.8303604125978,0.959066450595969 44.8255958557129,0.968984961509705 44.8249855041504,0.977959394454899 44.828094482422,1.00249552726751 44.8260536193849)) | 0.0006 | POINT(0.9754321067422255 44.82153701782233) |
| 14179 | POLYGON((9.20401668548584 44.614444732666,9.20128059387213 44.6172981262207,9.19952487945562 44.6407165527344,9.20063495635998 44.6449394226074,9.19908714294439 44.6507873535156,9.19908714294439 44.6507873535156,9.20103740692139 44.6512527465821,9.20465564727795 44.6547393798828,9.20737552642828 44.6605491638183,9.20643901824957 44.6679534912109,9.20506191253673 44.6709136962892,9.20297622680664 44.6725730895996,9.20297622680664 44.6725730895996,9.20892715454102 44.6724166870118,9.22093486785894 44.6751518249512,9.2339591979981 44.6728630065919,9.23649024963379 44.6711921691896,9.23733139038086 44.6688766479492,9.24631404876703 44.6571235656738,9.26510715484619 44.6553421020508,9.27075672149664 44.6581115722657,9.27230834960938 44.6608238220215,9.273850440979 44.6614418029786,9.27912330627447 44.6618156433106,9.28533363342285 44.6606292724611,9.28952217102051 44.6559829711915,9.29050731658936 44.6489677429199,9.29280090332037 44.6462402343751,9.30185794830317 44.6447868347168,9.30583095550531 44.6452598571778,9.30819606781012 44.6487236022949,9.30989456176769 44.6552925109864,9.30814456939709 44.6649208068849,9.30681705474848 44.6665954589844,9.30681705474848 44.6665954589844,9.31587505340576 44.6647644042969,9.32758903503418 44.6667289733887,9.35775947570812 44.6552238464355,9.3774356842041 44.6402893066406,9.37628555297863 44.6302375793457,9.3741655349732 44.6239433288574,9.38392925262445 44.6193466186524,9.3944139480592 44.6192092895509,9.40377902984619 44.6176300048829,9.40377902984619 44.6176300048829,9.39962387084961 44.6163749694825,9.39618778228765 44.6133537292481,9.39590167999273 44.6121101379394,9.40666294097906 44.6017608642578,9.40666294097906 44.6017608642578,9.40653038024902 44.5982933044434,9.40366172790527 44.5917434692384,9.3993320465089 44.5883827209473,9.39481163024908 44.588722229004,9.39040660858149 44.5911788940431,9.38570690155029 44.5852241516113,9.38210964202875 44.5777015686036,9.38210964202875 44.5777015686036,9.37046432495117 44.5840682983399,9.36678695678705 44.5855255126953,9.36209011077875 44.5859184265138,9.35646438598644 44.585361480713,9.35152816772455 44.5836753845216,9.34720802307135 44.5797767639161,9.34326267242426 44.5787315368652,9.32885837554937 44.5899200439453,9.31357383728039 44.5978202819824,9.30900573730474 44.6010818481446,9.30668640136724 44.6051864624023,9.30333709716808 44.6078758239747,9.30101108551031 44.6087913513184,9.2984790802002 44.6076736450195,9.2984790802002 44.6076736450195,9.29480171203625 44.6093940734864,9.28913021087652 44.6088142395021,9.28519916534424 44.598804473877,9.28127193450928 44.5971221923829,9.27327156066889 44.596866607666,9.24668502807617 44.6006622314454,9.24713516235357 44.6028442382814,9.25757980346685 44.6115531921387,9.25388526916504 44.6161346435547,9.2465448379516 44.6205978393554,9.22981929779058 44.6197776794434,9.20621490478521 44.6161422729493,9.20401668548584 44.614444732666)) | 0.0006 | POINT(9.301393789403598 44.627009268368006) |
| 23400 | POLYGON((-0.69965869188303 43.4591674804689,-0.716312527656555 43.4601097106934,-0.726619243621769 43.4653663635255,-0.726619243621769 43.4653663635255,-0.7302565574646 43.4592971801758,-0.725465595722198 43.4500503540038,-0.725465595722198 43.4500503540038,-0.715869069099426 43.4436874389649,-0.715869069099426 43.4436874389649,-0.695192158222142 43.4575805664063,-0.695192158222142 43.4575805664063,-0.69965869188303 43.4591674804689)) | 0.0006 | POINT(-0.7156836282122959 43.45563125610356) |
| 1397196 | POLYGON((-1.66095197200769 40.9783401489258,-1.67762804031366 40.9693336486817,-1.6983499526977 40.9490509033204,-1.71158504486084 40.9392623901367,-1.71699798107147 40.9320640563964,-1.73431694507599 40.9426155090332,-1.73764896392811 40.9422187805176,-1.74300694465637 40.947925567627,-1.74156200885761 40.9495468139648,-1.74442994594568 40.962532043457,-1.74193394184113 40.9762153625489,-1.75295805931086 40.9853706359864,-1.75100696086884 40.9892692565919,-1.73778796195984 41.0022926330566,-1.71470999717712 41.0120887756348,-1.69178605079651 40.9956474304199,-1.67915499210358 40.9893379211426,-1.67472004890442 40.9840469360351,-1.66635096073151 40.9817428588868,-1.66095197200769 40.9783401489258)) | 0.0006 | POINT(-1.7145729880583644 40.96994219328229) |
| 44430 | POLYGON((1.27669382095348 43.3859786987305,1.27053272724163 43.3890037536622,1.27053272724163 43.3890037536622,1.2620817422868 43.3673057556153,1.25806307792675 43.3656044006349,1.25016164779663 43.3691139221191,1.25016164779663 43.3691139221191,1.25443518161785 43.3599662780762,1.24708557128918 43.3481941223145,1.24708557128918 43.3481941223145,1.26333785057068 43.3416023254396,1.27644467353826 43.3444290161133,1.27644467353826 43.3444290161133,1.28564596176147 43.3513412475587,1.29378724098206 43.3653907775879,1.29378724098206 43.3653907775879,1.27292335033417 43.3796463012696,1.27669382095348 43.3859786987305)) | 0.0006 | POINT(1.2676002768909833 43.36374754064229) |
| 62356 | POLYGON((9.65320682525629 52.0207099914551,9.65029621124268 52.0226402282715,9.65122699737549 52.0199241638184,9.64315414428705 52.0191841125489,9.64426231384283 52.015926361084,9.64328861236567 52.0135879516602,9.64357376098633 52.0107879638673,9.64468383789068 52.0089836120607,9.64353275299072 52.0083465576172,9.64480590820312 52.0071563720704,9.64350605010992 52.0066795349122,9.64542102813732 52.0038566589355,9.64872550964367 52.0028381347656,9.64969825744635 52.0039901733398,9.65409660339355 52.0026359558106,9.65307903289795 52.0001373291016,9.65104961395269 52.0011100769044,9.64959144592279 51.998016357422,9.64615154266369 51.9988250732422,9.64330863952642 51.9958000183107,9.64425182342541 51.9952583312988,9.64125919342047 51.9915962219239,9.64161300659191 51.9898986816407,9.63731288909906 51.9899826049806,9.63787364959722 51.9888458251954,9.63376426696783 51.986686706543,9.63662147521967 51.9849929809571,9.63570213317877 51.9843139648438,9.63831996917725 51.9829826354981,9.63426780700684 51.983123779297,9.63570213317877 51.979705810547,9.63741493225098 51.9815635681152,9.63928794860846 51.9811172485352,9.642014503479 51.9794845581056,9.64138889312744 51.9788780212402,9.64565086364757 51.9760017395019,9.64572238922131 51.9743995666504,9.64876651763927 51.972297668457,9.64829063415533 51.971061706543,9.6499423980714 51.9668312072755,9.64724636077875 51.9661521911622,9.64781093597406 51.9647979736329,9.64781093597406 51.9647979736329,9.65069007873547 51.9650077819825,9.65069007873547 51.9650077819825,9.65445518493647 51.9654045104981,9.66259384155285 51.9686546325684,9.67053413391125 51.9652748107911,9.6714181900025 51.963508605957,9.6714181900025 51.963508605957,9.6749591827392 51.9606170654298,9.6791296005249 51.9594612121582,9.68714141845703 51.9552230834962,9.68850135803217 51.9565467834472,9.68850135803217 51.9565467834472,9.69399929046631 51.962574005127,9.69811248779303 51.9646987915039,9.70979881286621 51.9667930603028,9.7114772796632 51.9699440002441,9.71009826660162 51.9721832275391,9.7115802764892 51.9782829284667,9.71475505828863 51.9828262329102,9.71475505828863 51.9828262329102,9.72111892700207 51.9866447448732,9.71977519989025 51.9870796203613,9.72147464752192 51.9938087463379,9.72320842742931 51.9946899414063,9.73492813110352 51.9938545227051,9.74227619171148 51.9955291748048,9.74227619171148 51.9955291748048,9.74446201324469 51.9972877502442,9.7391443252564 52.0006752014161,9.7391443252564 52.0006752014161,9.70847702026373 52.0192527770997,9.70145320892334 52.0121574401856,9.69757843017589 52.0130233764649,9.69706249237072 52.0156707763672,9.69426441192638 52.0163345336913,9.69221591949469 52.0182495117187,9.69221591949469 52.0182495117187,9.69062614440924 52.0189781188965,9.6894359588623 52.0179786682129,9.68798351287842 52.0185279846191,9.68123054504406 52.0143394470214,9.68246078491205 52.0138626098632,9.68041133880627 52.0114059448242,9.68133258819574 52.0109214782715,9.67925071716303 52.009620666504,9.66286849975586 52.0114135742188,9.66246318817139 52.0163421630859,9.65800285339361 52.0215873718261,9.65320682525629 52.0207099914551)) | 0.0006 | POINT(9.671279624268282 51.991697667719265) |
| 16439 | POLYGON((9.83004474639898 46.1606330871583,9.84498882293701 46.1630363464355,9.85449600219721 46.1622161865235,9.86140441894543 46.1591682434082,9.86459732055658 46.1587944030762,9.89208793640148 46.1617317199708,9.89906883239752 46.1641159057618,9.89906883239752 46.1641159057618,9.90013408660894 46.1476020812989,9.89921760559093 46.1430473327637,9.89157867431652 46.1326026916505,9.89234828948975 46.1201515197754,9.89234828948975 46.1201515197754,9.89019584655773 46.1175041198731,9.87454128265392 46.1054840087891,9.8695268630982 46.1058654785156,9.86291503906256 46.1016845703125,9.85449504852295 46.0901565551759,9.85064983367914 46.0831718444825,9.85146141052257 46.0787658691406,9.84677982330334 46.0567703247071,9.84686470031738 46.053924560547,9.84999847412121 46.0508308410645,9.84999847412121 46.0508308410645,9.84589385986334 46.0504226684571,9.84000682830811 46.0543174743652,9.83829975128168 46.0661811828614,9.84174823760981 46.078685760498,9.84235572814947 46.0905952453614,9.83708572387707 46.104736328125,9.8342657089234 46.1219673156738,9.83576011657721 46.136905670166,9.83149814605724 46.1409759521484,9.83002281188971 46.1445159912111,9.82913398742676 46.152530670166,9.83004474639898 46.1606330871583)) | 0.0006 | POINT(9.859282330104332 46.114119720459016) |
| 22396 | POLYGON((-0.708209633827153 43.5413055419922,-0.707608759403229 43.5578804016114,-0.700471758842468 43.5620613098146,-0.700471758842468 43.5620613098146,-0.689067721366882 43.5792655944825,-0.689167976379338 43.5825614929199,-0.693462729454041 43.5836372375489,-0.693462729454041 43.5836372375489,-0.696893990039825 43.5857391357422,-0.713521540164948 43.58207321167,-0.713521540164948 43.58207321167,-0.718392789363804 43.5765533447266,-0.726838946342411 43.5742111206056,-0.726407408714294 43.567756652832,-0.734086692333165 43.5557479858398,-0.734086692333165 43.5557479858398,-0.728544652461892 43.5451736450196,-0.728544652461892 43.5451736450196,-0.7212033867836 43.5413818359376,-0.708209633827153 43.5413055419922)) | 0.0006 | POINT(-0.7117876504596612 43.566528521086106) |
| 1406114 | POLYGON((-0.461380988359338 39.8359756469728,-0.461104989051819 39.8298873901368,-0.46552699804306 39.8315162658693,-0.468977004289627 39.8391494750977,-0.468329995870533 39.8415298461915,-0.465775012969971 39.8420372009277,-0.464352995157242 39.8394088745118,-0.461380988359338 39.8359756469728)) | 0.0006 | POINT(-0.46506399767736994 39.83707209995823) |