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 |
---|---|---|---|
72966 | POLYGON((12.2741317749023 47.6392402648927,12.2872428894044 47.6646614074707,12.2927350997925 47.6718254089357,12.2990055084229 47.6751670837402,12.3097295761108 47.6783103942872,12.3286314010621 47.679141998291,12.3296613693237 47.6837997436523,12.3279266357422 47.6953926086426,12.3279266357422 47.6953926086426,12.3380451202393 47.6970863342285,12.3380451202393 47.6970863342285,12.335301399231 47.6922645568849,12.3385496139528 47.6905479431153,12.3410873413087 47.6905593872071,12.3410873413087 47.6905593872071,12.3512601852417 47.6752738952638,12.3533153533937 47.6692390441895,12.3506040573121 47.6653709411622,12.3343334197998 47.6571426391602,12.3304281234742 47.6523666381836,12.3282709121704 47.6426811218263,12.3330993652344 47.6303977966309,12.3331823348999 47.6263504028321,12.3305263519287 47.6174125671387,12.321370124817 47.5974464416505,12.321370124817 47.5974464416505,12.3240308761597 47.5921936035157,12.3240308761597 47.5921936035157,12.308632850647 47.5814933776855,12.308632850647 47.5814933776855,12.2858333587646 47.5867538452148,12.2803659439088 47.5896377563477,12.2771520614624 47.6093559265137,12.2872810363771 47.6148910522462,12.2888727188111 47.6173515319824,12.2741317749023 47.6392402648927)) | 0.0006 | POINT(12.31947713579455 47.64678649902347) |
51700 | POLYGON((-0.463497936725616 45.483383178711,-0.464408934116307 45.4772453308107,-0.471783429384175 45.4742965698243,-0.471783429384175 45.4742965698243,-0.46252715587616 45.462890625,-0.474632084369659 45.4594268798829,-0.474632084369659 45.4594268798829,-0.476381093263569 45.4552421569825,-0.476381093263569 45.4552421569825,-0.474311918020248 45.4522590637208,-0.482443869113922 45.4336738586426,-0.475791424512863 45.4290428161621,-0.466575652360859 45.4296684265137,-0.466575652360859 45.4296684265137,-0.456079155206567 45.4350242614747,-0.456079155206567 45.4350242614747,-0.457904607057571 45.4417266845703,-0.446090102195683 45.4566383361818,-0.446090102195683 45.4566383361818,-0.444903343915939 45.46248626709,-0.435764074325562 45.4648590087891,-0.426052153110504 45.4722862243653,-0.417563289403802 45.4696502685547,-0.419706046581268 45.4597244262696,-0.419706046581268 45.4597244262696,-0.413351207971516 45.4557304382324,-0.404701173305455 45.4550094604493,-0.404701173305455 45.4550094604493,-0.397352993488312 45.4623794555665,-0.403866767883301 45.4702301025391,-0.403866767883301 45.4702301025391,-0.416095495223999 45.484935760498,-0.40880873799324 45.4939727783203,-0.40880873799324 45.4939727783203,-0.416788667440414 45.4989051818848,-0.416788667440414 45.4989051818848,-0.41904628276825 45.4987297058106,-0.41904628276825 45.4987297058106,-0.429521858692112 45.4867706298828,-0.445543318986836 45.4781684875489,-0.463497936725616 45.483383178711)) | 0.0006 | POINT(-0.44089879915115376 45.46478061676029) |
35861 | POLYGON((6.74199008941662 47.542808532715,6.74719905853277 47.5366249084474,6.74719905853277 47.5366249084474,6.72803354263311 47.534481048584,6.71768712997442 47.528060913086,6.71768712997442 47.528060913086,6.70101356506359 47.5249519348146,6.70101356506359 47.5249519348146,6.70394182205212 47.5322647094727,6.70394182205212 47.5322647094727,6.70895910263067 47.5432090759278,6.70895910263067 47.5432090759278,6.72213411331188 47.5456809997559,6.72213411331188 47.5456809997559,6.74199008941662 47.542808532715)) | 0.0006 | POINT(6.719420943941474 47.53563390459341) |
30607 | MULTIPOLYGON(((-4.02680587768549 48.7545814514161,-4.02652788162226 48.7526397705079,-4.02791595458984 48.7523612976075,-4.02902793884277 48.7523612976075,-4.0304160118103 48.7540283203125,-4.02680587768549 48.7545814514161)),((-4.00485992431635 48.7540283203125,-4.003749847412 48.7526397705079,-4.00597286224365 48.7523612976075,-4.00569486618042 48.7512512207032,-4.00347185134876 48.7512512207032,-4.00347185134876 48.7493057250977,-3.99986195564264 48.7481956481933,-3.99847197532648 48.7459716796876,-3.99430608749384 48.7456932067872,-3.99291801452631 48.7476387023926,-3.99208402633661 48.7465286254884,-3.98958301544189 48.7473602294922,-3.98847103118896 48.7448616027833,-3.9912490844726 48.7437515258789,-3.9887490272522 48.7418060302734,-3.98819494247437 48.7393074035645,-3.99180507659901 48.7368049621582,-3.99402809143066 48.7365264892578,-3.99402809143066 48.7387504577637,-3.99514007568354 48.7379150390626,-3.99680590629566 48.7381935119629,-3.99375009536743 48.7395820617677,-3.99430608749384 48.7406959533693,-3.99958395957941 48.7404174804689,-4.00152778625488 48.7390289306641,-4.00152778625488 48.7409706115723,-4.00430393218994 48.7412490844727,-4.00513792037958 48.7401390075685,-4.0068039894104 48.7401390075685,-4.00958299636841 48.7431945800781,-4.0131950378418 48.7440261840821,-4.01458311080927 48.7429161071777,-4.0134711265564 48.7412490844727,-4.0156950950622 48.7409706115723,-4.01763916015619 48.7376403808594,-4.0179181098938 48.7398605346681,-4.0215277671814 48.7390289306641,-4.02264022827148 48.7379150390626,-4.02374982833857 48.7390289306641,-4.02597188949579 48.7390289306641,-4.02680587768549 48.741527557373,-4.02930593490595 48.741527557373,-4.02986001968384 48.7395820617677,-4.03097200393677 48.7398605346681,-4.03180694580078 48.7404174804689,-4.03180694580078 48.7426376342774,-4.03375101089466 48.7420845031738,-4.03347301483149 48.7406959533693,-4.03569507598871 48.7398605346681,-4.03875112533564 48.7437515258789,-4.04152679443359 48.7445831298829,-4.03902721405029 48.7481956481933,-4.03652715682983 48.7490272521973,-4.03291702270502 48.7476387023926,-4.03347301483149 48.7501373291017,-4.03263807296753 48.750415802002,-4.03069400787354 48.7487487792969,-4.02930593490595 48.7501373291017,-4.02513790130615 48.7510299682618,-4.02347183227533 48.7540283203125,-4.01958417892456 48.7540283203125,-4.01874923706055 48.7526397705079,-4.00485992431635 48.7540283203125)),((-3.99902796745295 48.7509727478028,-3.99958395957941 48.7490272521973,-4.00097179412842 48.7490272521973,-4.00236177444458 48.750415802002,-3.99902796745295 48.7509727478028))) | 0.0006 | POINT(-4.00811799991841 48.746440794937314) |
41964 | POLYGON((5.28048658370972 49.5062255859376,5.27456665039068 49.5181579589844,5.27456665039068 49.5181579589844,5.29941320419317 49.5246925354004,5.31543111801142 49.5334968566895,5.32414579391485 49.5536041259766,5.32414579391485 49.5536041259766,5.3304553031922 49.5516510009767,5.3304553031922 49.5516510009767,5.33513069152843 49.5465774536133,5.33513069152843 49.5465774536133,5.33115339279186 49.5341415405273,5.32232713699341 49.52592086792,5.32406806945812 49.5195121765138,5.32406806945812 49.5195121765138,5.31139421463007 49.5110168457032,5.31216907501215 49.5079803466796,5.31216907501215 49.5079803466796,5.31302261352545 49.5048522949219,5.30871725082409 49.5033683776855,5.29010725021368 49.5070953369141,5.28048658370972 49.5062255859376)) | 0.0006 | POINT(5.313005901518368 49.525989350818485) |
33642 | POLYGON((4.69986200332647 48.194896697998,4.69950866699224 48.2065048217774,4.69950866699224 48.2065048217774,4.70778846740728 48.2189559936525,4.73309707641602 48.2215232849122,4.73309707641602 48.2215232849122,4.73959159851086 48.2061004638672,4.73959159851086 48.2061004638672,4.69986200332647 48.194896697998)) | 0.0006 | POINT(4.719005644321499 48.21026372909551) |
13418 | POLYGON((15.2963953018189 40.8391418457031,15.2998685836793 40.8401222229005,15.3116493225098 40.840518951416,15.3192586898805 40.839584350586,15.3315877914429 40.8334197998047,15.3339509963989 40.8340454101563,15.3358268737792 40.8358612060547,15.3358268737792 40.8358612060547,15.3541641235352 40.8387031555176,15.3541641235352 40.8387031555176,15.3554506301881 40.842555999756,15.3555812835693 40.8556976318359,15.3523073196411 40.8646202087403,15.355115890503 40.8689422607422,15.3578624725342 40.8711128234864,15.3578624725342 40.8711128234864,15.3550071716309 40.8836402893066,15.3550071716309 40.8836402893066,15.3519096374512 40.8836631774902,15.3469524383544 40.902458190918,15.3430490493774 40.9029846191406,15.340817451477 40.9052314758301,15.3410863876343 40.9118118286133,15.3410863876343 40.9118118286133,15.3389167785645 40.9149246215821,15.3278980255128 40.9172477722168,15.3159923553468 40.915412902832,15.3028640747071 40.9115676879882,15.2959346771241 40.9107818603517,15.2939577102661 40.9114799499512,15.2939577102661 40.9114799499512,15.2873468399048 40.9064521789552,15.2748250961305 40.8877563476562,15.2602396011352 40.8851509094238,15.2602396011352 40.8851509094238,15.2828931808472 40.8620071411133,15.2839584350587 40.8584632873535,15.2826280593873 40.8530006408692,15.2785539627076 40.8466033935547,15.2785539627076 40.8466033935547,15.2963953018189 40.8391418457031)) | 0.0006 | POINT(15.321013712883024 40.87398319244387) |
20279 | POLYGON((11.6216506958008 45.6905784606934,11.6221294403076 45.6812896728516,11.6221294403076 45.6812896728516,11.6164026260377 45.6829757690431,11.5853929519654 45.6827201843262,11.5822105407715 45.6808128356934,11.5780410766603 45.675178527832,11.5643749237061 45.6732139587402,11.5643749237061 45.6732139587402,11.5587930679322 45.6789093017579,11.5527038574218 45.6905746459962,11.5527038574218 45.6905746459962,11.5454607009888 45.7062721252442,11.5454607009888 45.7062721252442,11.5500707626343 45.7081947326661,11.567632675171 45.7267112731935,11.5855197906495 45.7258415222168,11.590612411499 45.7278594970703,11.590612411499 45.7278594970703,11.5880622863771 45.7238388061523,11.5884084701538 45.7185363769532,11.5915699005128 45.7126846313478,11.6018285751343 45.7081718444825,11.6049089431763 45.7080917358399,11.6076898574829 45.7062911987305,11.6144180297852 45.7004394531251,11.6216506958008 45.6905784606934)) | 0.0006 | POINT(11.584352419926605 45.69955370976379) |
24460 | POLYGON((3.80016064643866 45.4914627075196,3.79309415817261 45.4951095581054,3.79309415817261 45.4951095581054,3.81426811218267 45.5218887329102,3.83209037780756 45.5272178649903,3.83747434616083 45.540153503418,3.8351817131043 45.5538482666017,3.8351817131043 45.5538482666017,3.83518505096441 45.5540733337403,3.83518505096441 45.5540733337403,3.84505200386059 45.5850257873536,3.84505200386059 45.5850257873536,3.85454297065741 45.5692291259766,3.8448841571809 45.5622138977051,3.85214877128601 45.5494346618652,3.84633827209473 45.5398902893066,3.84744811058056 45.5294876098633,3.84889602661133 45.5261535644532,3.87056541442882 45.5183181762696,3.87056541442882 45.5183181762696,3.86402225494379 45.5110740661621,3.86402225494379 45.5110740661621,3.85390019416815 45.5058288574219,3.85414862632757 45.49951171875,3.84580922126776 45.4883728027344,3.84580922126776 45.4883728027344,3.83983445167542 45.493724822998,3.80016064643866 45.4914627075196)) | 0.0006 | POINT(3.8408872109872725 45.52843856811527) |
31184 | POLYGON((-2.9696934223175 48.0318450927736,-2.94555640220636 48.048484802246,-2.94555640220636 48.048484802246,-2.93970942497253 48.0651931762696,-2.92205166816706 48.0773735046386,-2.94396662712091 48.0856819152833,-2.94532418251038 48.0890045166016,-2.94532418251038 48.0890045166016,-2.96099138259882 48.0969047546387,-2.98927283287037 48.0913619995118,-2.99624800682062 48.1003532409669,-2.99624800682062 48.1003532409669,-3.00475835800171 48.097827911377,-3.00520443916315 48.0883636474609,-3.01396036148066 48.0893173217773,-3.01396036148066 48.0893173217773,-3.01816201210016 48.0835151672363,-3.00492739677429 48.0729026794434,-3.00416994094849 48.0659980773926,-2.99590682983387 48.061882019043,-2.99590682983387 48.061882019043,-2.98676300048828 48.0539016723633,-2.96213436126709 48.0526237487793,-2.95951890945435 48.0497245788574,-2.9691104888916 48.038600921631,-2.9696934223175 48.0318450927736)) | 0.0006 | POINT(-2.9773770332336045 48.07319610595707) |