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 |
|---|---|---|---|
| 49789 | POLYGON((3.37812781333935 49.9969100952149,3.37009835243236 50.0060157775879,3.35582089424133 50.0110893249512,3.35582089424133 50.0110893249512,3.36620426177973 50.0129890441895,3.39247918128973 50.0311317443848,3.39247918128973 50.0311317443848,3.3984739780426 50.0345802307129,3.3984739780426 50.0345802307129,3.41055321693426 50.0280990600587,3.41996717453009 50.0284080505371,3.42846965789795 50.0247764587402,3.42846965789795 50.0247764587402,3.42779159545904 50.022087097168,3.42779159545904 50.022087097168,3.42545223236095 50.0173873901368,3.42545223236095 50.0173873901368,3.41683721542364 49.9969635009766,3.41683721542364 49.9969635009766,3.41216707229614 50.0018577575685,3.4071364402771 50.0018577575685,3.37812781333935 49.9969100952149)) | 0.0006 | POINT(3.402614468619977 50.01676995413647) |
| 63990 | POLYGON((14.0071382522584 53.3401947021486,14.0057697296144 53.3409347534181,14.0057697296144 53.3409347534181,13.9989280700685 53.3375244140626,13.9913330078126 53.3389892578126,13.9687948226929 53.337802886963,13.9679574966432 53.3361511230469,13.9412050247192 53.330623626709,13.9278163909913 53.3266181945801,13.9278163909913 53.3266181945801,13.9279527664185 53.3227729797363,13.9205951690674 53.3180122375488,13.9215383529664 53.3115959167481,13.9249668121338 53.304500579834,13.9408559799195 53.2881202697754,13.9414310455323 53.2860717773438,13.9414310455323 53.2860717773438,13.9511384963989 53.2859802246094,13.9714508056641 53.2792778015138,13.9770097732545 53.2785720825196,13.9820241928102 53.282569885254,13.9874248504639 53.280616760254,14.0032920837403 53.279453277588,14.0221805572511 53.2830505371094,14.0342359542846 53.2841529846192,14.0342359542846 53.2841529846192,14.0314188003541 53.2937812805175,14.0291347503663 53.3057518005372,14.0298585891725 53.3061599731446,14.027624130249 53.3127670288085,14.0142440795899 53.3111534118652,13.9942340850831 53.3213996887208,13.9849128723145 53.3241920471192,13.9917039871217 53.3283348083496,13.9940385818481 53.3282051086426,13.9949827194214 53.3270378112793,13.9998321533203 53.3271598815917,14.0059995651245 53.3326950073243,14.0128622055054 53.3367576599121,14.0071382522584 53.3401947021486)) | 0.0006 | POINT(13.982952289092294 53.311968192076094) |
| 26217 | POLYGON((-0.721298456192017 49.1744995117188,-0.726622581481934 49.1801872253419,-0.735638201236668 49.1831665039062,-0.735638201236668 49.1831665039062,-0.742072999477386 49.1986618041992,-0.734159350395146 49.2066116333009,-0.724487483501434 49.2081184387207,-0.724487483501434 49.2081184387207,-0.705095767974854 49.2047271728516,-0.704627573490086 49.1914863586426,-0.714075863361359 49.1796379089355,-0.714075863361359 49.1796379089355,-0.721298456192017 49.1744995117188)) | 0.0006 | POINT(-0.7235233187675286 49.19150161743165) |
| 32165 | POLYGON((0.913666129112357 46.8158836364746,0.894038617610931 46.8165512084961,0.885675668716488 46.8247566223145,0.842311978340206 46.8226280212403,0.842311978340206 46.8226280212403,0.858262658119145 46.8294105529785,0.859581470489559 46.8325691223145,0.853046357631797 46.8514251708984,0.853046357631797 46.8514251708984,0.870666742324829 46.8563995361328,0.873622953891697 46.8657150268556,0.881191611289978 46.8696289062501,0.885261952877102 46.8824310302735,0.885261952877102 46.8824310302735,0.903914570808411 46.8783836364747,0.922923982143402 46.8827629089357,0.922923982143402 46.8827629089357,0.924444735050258 46.8653717041016,0.919119596481437 46.8593940734863,0.925190806388855 46.8465881347657,0.910469233989716 46.8324432373047,0.915158331394252 46.8262062072754,0.913666129112357 46.8158836364746)) | 0.0006 | POINT(0.8882768939842239 46.84989981217822) |
| 20598 | POLYGON((7.25914716720592 48.3704261779786,7.25090551376337 48.3741912841797,7.2483224868775 48.380714416504,7.2483224868775 48.380714416504,7.26863050460821 48.3891220092775,7.26863050460821 48.3891220092775,7.27811813354492 48.3863563537599,7.29275083541876 48.3887977600099,7.30092668533337 48.3845672607422,7.32128429412853 48.3825912475587,7.32968330383295 48.3786430358887,7.32968330383295 48.3786430358887,7.3143835067749 48.3700370788575,7.30630970001215 48.3612861633301,7.30630970001215 48.3612861633301,7.29172325134283 48.3576698303223,7.27706003189081 48.3580665588379,7.27706003189081 48.3580665588379,7.27375793457026 48.3636817932129,7.25914716720592 48.3704261779786)) | 0.0006 | POINT(7.2864741777119 48.37442016601568) |
| 1401014 | POLYGON((-6.82558107376093 40.7834091186523,-6.82546806335449 40.7853202819825,-6.82222795486445 40.787567138672,-6.82237005233765 40.7887344360351,-6.81918478012079 40.7924957275392,-6.81957197189331 40.7944564819335,-6.80099678039545 40.7898025512696,-6.77964019775391 40.7924156188966,-6.76497793197632 40.7913093566894,-6.74959802627558 40.7879486083986,-6.71292018890369 40.7854881286622,-6.69912719726563 40.7782058715821,-6.70828008651728 40.7602767944337,-6.71839714050287 40.74906539917,-6.71737384796143 40.7432250976563,-6.71980094909668 40.7427864074708,-6.71731901168812 40.7312240600587,-6.72966289520264 40.7266998291017,-6.72960615158075 40.7214241027833,-6.73249816894531 40.7225532531739,-6.73608112335205 40.7214317321778,-6.73550891876221 40.7232818603517,-6.74247598648071 40.721508026123,-6.74322080612183 40.7183418273926,-6.75072717666626 40.7164764404297,-6.75357103347773 40.717357635498,-6.75508880615229 40.7155151367188,-6.75810623168945 40.7157173156739,-6.7590799331665 40.7206192016603,-6.76354217529297 40.7189254760742,-6.76494216918945 40.7162742614747,-6.76773595809937 40.7156448364259,-6.7692670822143 40.7180099487305,-6.76700401306152 40.7188262939454,-6.77123212814331 40.7320556640626,-6.78042602539063 40.732608795166,-6.78217887878418 40.7344970703126,-6.78004312515253 40.7494621276856,-6.78781890869141 40.7543945312499,-6.80948019027704 40.7612190246582,-6.81326580047607 40.7605552673341,-6.81565523147577 40.7579879760743,-6.82859992980957 40.7594757080079,-6.82719898223871 40.7620582580567,-6.82837009429932 40.7636108398438,-6.8259220123291 40.7677841186523,-6.82776594161987 40.7760696411133,-6.82615423202509 40.7786521911622,-6.82558107376093 40.7834091186523)) | 0.0006 | POINT(-6.772605528434094 40.75005769729619) |
| 54338 | POLYGON((4.93980360031139 46.390422821045,4.93747901916515 46.3876457214357,4.94117403030401 46.3787994384766,4.93038606643688 46.3729476928712,4.93038606643688 46.3729476928712,4.89628076553345 46.3846168518066,4.89628076553345 46.3846168518066,4.89791584014893 46.3987121582032,4.89791584014893 46.3987121582032,4.9130363464356 46.3992347717286,4.92500734329235 46.3927650451661,4.93980360031139 46.390422821045)) | 0.0006 | POINT(4.918696880340639 46.387401927601275) |
| 59592 | POLYGON((7.79730796813965 46.6591987609864,7.7920618057251 46.6576309204103,7.78581380844111 46.6572418212892,7.77654600143433 46.6543426513673,7.77254199981695 46.655128479004,7.76524782180798 46.6541175842285,7.75311183929443 46.6574897766114,7.75310087203979 46.6603622436523,7.75692176818859 46.668285369873,7.75790119171148 46.6734848022461,7.76087522506708 46.678035736084,7.76177406311035 46.6792182922364,7.77016782760626 46.6815376281739,7.78507709503174 46.6816749572754,7.79396009445202 46.683921813965,7.80165004730236 46.6830787658693,7.80532693862921 46.6837005615235,7.81025314331055 46.6818313598634,7.8168358802796 46.6813697814943,7.82006406784058 46.6771965026855,7.83557081222534 46.6691055297852,7.8357338905335 46.6666641235352,7.83410882949823 46.6643676757812,7.82564401626587 46.6595115661621,7.81969404220592 46.6595191955566,7.81351280212402 46.6627388000488,7.81004190444946 46.6634330749513,7.80439519882214 46.6628570556641,7.79730796813965 46.6591987609864)) | 0.0006 | POINT(7.793401462691201 46.66846588679727) |
| 32794 | POLYGON((0.965269982814903 47.6295700073243,0.973494589328766 47.6518554687501,0.962437987327689 47.6629257202149,0.971111357212067 47.6661643981934,0.971111357212067 47.6661643981934,0.968137621879578 47.6703987121582,0.968137621879578 47.6703987121582,0.944579243659973 47.6580581665039,0.937331497669277 47.6493835449219,0.937331497669277 47.6493835449219,0.918492317199764 47.6380577087403,0.915916621685085 47.6351013183595,0.919604957103672 47.6327552795411,0.919604957103672 47.6327552795411,0.937342524528503 47.6284217834473,0.937342524528503 47.6284217834473,0.951655030250606 47.6261558532715,0.965269982814903 47.6295700073243)) | 0.0006 | POINT(0.9469942170031167 47.64682186351108) |
| 32265 | POLYGON((0.598065555095729 47.5391426086426,0.608967781066951 47.5290985107423,0.613430202007294 47.5301094055177,0.613430202007294 47.5301094055177,0.626096725463867 47.5356178283692,0.63593548536312 47.5347557067871,0.639688551426048 47.5145072937013,0.649535477161464 47.5024757385255,0.654608309269065 47.5028648376466,0.654608309269065 47.5028648376466,0.654794692993164 47.5061912536621,0.681573033332825 47.5139045715333,0.680893659591732 47.5200691223145,0.685626924037877 47.5258903503419,0.685626924037877 47.5258903503419,0.688609719276428 47.5347061157227,0.688609719276428 47.5347061157227,0.679682135582084 47.5317535400392,0.67496889829647 47.5331192016601,0.663424134254456 47.5398750305177,0.653204500675258 47.5518264770508,0.62295770645153 47.5532760620118,0.614256560802573 47.549732208252,0.614256560802573 47.549732208252,0.611322045326233 47.5433654785157,0.598065555095729 47.5391426086426)) | 0.0006 | POINT(0.6477669525146962 47.529423370361386) |
