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 |
|---|---|---|---|
| 45449 | POLYGON((0.332087635994014 43.2798652648926,0.327056556940022 43.2682723999025,0.327056556940022 43.2682723999025,0.321243852377052 43.259765625,0.321243852377052 43.259765625,0.339578419923896 43.2595558166505,0.354633092880306 43.2672157287599,0.354633092880306 43.2672157287599,0.362252473831234 43.2753944396974,0.362252473831234 43.2753944396974,0.332087635994014 43.2798652648926)) | 0.0006 | POINT(0.3402038007975138 43.268071746826266) |
| 17624 | POLYGON((8.05141639709484 44.6137046813965,8.05319786071789 44.6112022399902,8.05319786071789 44.6112022399902,8.06441116333019 44.6087875366211,8.06441116333019 44.6087875366211,8.06670570373535 44.6107749938964,8.07331275939953 44.6131439208986,8.076828956604 44.6159133911133,8.08204078674322 44.6215744018555,8.08125019073481 44.6233253479005,8.08125019073481 44.6233253479005,8.08445644378668 44.6252365112305,8.08498954772955 44.6315383911133,8.08401870727545 44.635524749756,8.08209609985357 44.6367568969728,8.08209609985357 44.6367568969728,8.07747745513922 44.6367950439454,8.0560474395752 44.6499710083007,8.05041599273693 44.6518821716309,8.04911994934093 44.6517295837403,8.04727935791021 44.6493492126465,8.04496192932129 44.6419486999512,8.04496192932129 44.6419486999512,8.04740905761719 44.6395797729493,8.04973793029785 44.6349792480469,8.05584526062017 44.6188087463379,8.05482769012457 44.6150398254395,8.05141639709484 44.6137046813965)) | 0.0006 | POINT(8.06458384902394 44.628132855450694) |
| 37693 | POLYGON((0.463232547044868 49.3366889953614,0.448956966400146 49.3389854431153,0.437227308750153 49.3456993103028,0.434328734874839 49.3522224426271,0.429137200117225 49.3525238037111,0.429137200117225 49.3525238037111,0.419232994318065 49.3512611389161,0.419232994318065 49.3512611389161,0.426118642091808 49.3393554687501,0.411234974861202 49.3150520324706,0.411234974861202 49.3150520324706,0.412680208683071 49.3150367736818,0.412680208683071 49.3150367736818,0.421297788619995 49.3121719360352,0.445289045572281 49.3146705627441,0.445289045572281 49.3146705627441,0.456653356552181 49.3235816955568,0.456653356552181 49.3235816955568,0.471815675497112 49.3356628417969,0.471815675497112 49.3356628417969,0.463232547044868 49.3366889953614)) | 0.0006 | POINT(0.4361624449492041 49.33203506469733) |
| 68987 | POLYGON((12.9766540527344 50.9512062072754,12.9759874343873 50.9523468017579,12.9795856475831 50.9535293579103,12.9816284179688 50.9557571411133,12.9815273284913 50.9581146240236,12.9852714538574 50.9607009887696,12.9818525314332 50.9666061401368,12.9836158752442 50.9667854309083,12.9819288253785 50.9680366516114,12.9823322296143 50.9689102172852,12.9708061218262 50.9754943847656,12.9712696075439 50.9764404296876,12.9671907424927 50.9764251708986,12.9559841156006 50.9807586669922,12.9453258514405 50.9836311340332,12.940622329712 50.9804420471192,12.9375286102296 50.9796447753907,12.9376058578491 50.97758102417,12.9352521896362 50.9753875732422,12.9268236160279 50.971549987793,12.9268236160279 50.971549987793,12.9270133972169 50.968906402588,12.9178857803345 50.9685745239259,12.9152488708496 50.9663887023927,12.9120101928712 50.9600296020509,12.9114513397216 50.9566802978516,12.9114513397216 50.9566802978516,12.9204053878784 50.9523735046387,12.9221391677856 50.9503669738771,12.9245071411133 50.950954437256,12.9324350357056 50.9431266784669,12.9324350357056 50.9431266784669,12.9454669952394 50.9454498291016,12.9567613601685 50.9509887695313,12.9660320281982 50.9516563415528,12.9674568176271 50.950050354004,12.9738616943359 50.9493484497071,12.9766540527344 50.9512062072754)) | 0.0006 | POINT(12.950329136204113 50.96258379962) |
| 1408506 | POLYGON((-17.7540378570556 28.7848987579346,-17.7512474060057 28.7809715270996,-17.7529163360595 28.7798614501954,-17.7529163360595 28.7787494659425,-17.7515296936034 28.7776393890381,-17.752082824707 28.7765274047852,-17.7501373291016 28.7731952667237,-17.7479152679443 28.7712497711182,-17.7481937408447 28.7693042755127,-17.7437496185302 28.7668056488038,-17.7418060302733 28.7620830535888,-17.7398586273193 28.761251449585,-17.740140914917 28.7598590850831,-17.7384700775146 28.7595825195313,-17.7376403808594 28.7606945037843,-17.7362499237061 28.7606945037843,-17.7359714508057 28.7593078613281,-17.7343044281005 28.7595825195313,-17.7348613739013 28.757360458374,-17.7326393127441 28.7568054199219,-17.7326393127441 28.7545833587647,-17.7337493896484 28.7543048858644,-17.7334728240967 28.7523612976074,-17.7301387786865 28.7506942749023,-17.7298603057861 28.7454166412354,-17.7284736633301 28.7437496185304,-17.7240295410156 28.7434730529786,-17.7245826721191 28.739860534668,-17.7234725952148 28.7381954193116,-17.7248592376708 28.7373638153077,-17.7256946563721 28.7334728240966,-17.7281951904297 28.7304153442384,-17.7312507629395 28.7287502288818,-17.7301387786865 28.7256946563722,-17.7323608398436 28.7243061065674,-17.732084274292 28.7206935882568,-17.7348613739013 28.7190265655519,-17.7343044281005 28.7176361083986,-17.7381954193115 28.7143058776857,-17.7431945800781 28.7134723663331,-17.7443046569824 28.7112503051758,-17.7465286254883 28.710973739624,-17.7473602294922 28.7087516784669,-17.7518062591553 28.7065296173096,-17.752082824707 28.7037506103517,-17.7543048858643 28.7023620605469,-17.7647533416748 28.7177886962891,-17.7849330902099 28.7280063629152,-17.7931118011475 28.7269191741944,-17.8008766174316 28.7326278686523,-17.8169078826903 28.7350311279298,-17.8223800659179 28.7304458618165,-17.8384628295898 28.7397041320802,-17.8302383422852 28.7432384490967,-17.8118782043456 28.7415046691895,-17.7981967926025 28.7472763061523,-17.787857055664 28.7473106384278,-17.7793750762939 28.7590446472168,-17.7632598876952 28.7677268981935,-17.7614917755126 28.7761707305908,-17.7540378570556 28.7848987579346)) | 0.0006 | POINT(-17.752372296651167 28.74467690785731) |
| 43586 | POLYGON((1.01545763015758 42.9008827209473,0.998417139053345 42.892604827881,0.989936172962189 42.8923301696778,0.989936172962189 42.8923301696778,0.996470510959625 42.8816604614257,0.996470510959625 42.8816604614257,1.00831985473638 42.8717689514161,1.00831985473638 42.8717689514161,1.01316356658936 42.8846130371094,1.02198767662043 42.8920173645021,1.01545763015758 42.9008827209473)) | 0.0006 | POINT(1.0038479089737105 42.886163711547894) |
| 1407078 | POLYGON((-6.37056684494019 38.2995300292969,-6.3689489364624 38.3087730407715,-6.36476898193359 38.3135757446289,-6.35429620742792 38.3210144042969,-6.35651588439941 38.327751159668,-6.3445000648498 38.3377609252931,-6.33144283294672 38.3543548583986,-6.3269419670105 38.3544578552247,-6.31238698959351 38.3617172241212,-6.30285120010376 38.3520317077637,-6.2882027626037 38.3428230285646,-6.28269195556641 38.336841583252,-6.27985715866083 38.33837890625,-6.27732992172236 38.3361091613771,-6.28023815155018 38.3346138000489,-6.27375984191895 38.32820892334,-6.2766318321228 38.325969696045,-6.27144479751581 38.3255348205566,-6.2672009468078 38.3196640014648,-6.2636928558349 38.3192214965821,-6.25935888290405 38.3140983581543,-6.26350879669189 38.2982902526856,-6.28395986557007 38.2820701599122,-6.30817794799799 38.2762794494628,-6.31279516220087 38.2813110351564,-6.31777715682972 38.2822799682617,-6.32654476165771 38.2938117980958,-6.3450880050658 38.2975921630859,-6.37056684494019 38.2995300292969)) | 0.0006 | POINT(-6.307552882603202 38.320145198277125) |
| 45674 | POLYGON((1.8589700460434 44.7310256958007,1.847580909729 44.7339057922364,1.847580909729 44.7339057922364,1.85285890102386 44.7395896911622,1.83945393562323 44.7482299804688,1.83592355251307 44.761302947998,1.83592355251307 44.761302947998,1.8472558259964 44.7756805419922,1.85319018363958 44.770450592041,1.86674296855932 44.7671775817871,1.8718638420105 44.7614021301271,1.8718638420105 44.7614021301271,1.87529742717743 44.7489585876465,1.87529742717743 44.7489585876465,1.8589700460434 44.7310256958007)) | 0.0006 | POINT(1.8557002374104137 44.75309235709057) |
| 67890 | POLYGON((7.91328859329235 49.1716499328613,7.91329336166382 49.1725845336915,7.91558265686047 49.1728973388672,7.91572999954235 49.177059173584,7.91669988632208 49.177921295166,7.91669988632208 49.177921295166,7.92849636077892 49.1781120300292,7.93219661712646 49.1766815185546,7.94014263153082 49.1777648925782,7.9412150382995 49.178249359131,7.94195985794067 49.1815490722657,7.94345712661755 49.1823120117188,7.94298601150513 49.1834297180177,7.94679307937622 49.1836128234864,7.95013332366943 49.1853561401368,7.95013332366943 49.1853561401368,7.95618391036993 49.1854362487794,7.95618391036993 49.1854362487794,7.95671510696417 49.1847381591797,7.95594644546509 49.1831741333008,7.95135450363159 49.1796569824219,7.95076179504395 49.1768531799317,7.95271348953247 49.1739463806152,7.95114755630493 49.1731910705566,7.95204353332531 49.1723403930664,7.9542555809021 49.172821044922,7.95430564880371 49.1659011840821,7.94801759719843 49.1638603210449,7.94801759719843 49.1638603210449,7.94482135772711 49.1640930175781,7.94247055053717 49.1623573303223,7.94190263748175 49.1634864807129,7.93991804122925 49.163646697998,7.9403190612793 49.1653938293457,7.93930864334118 49.1645240783693,7.93680620193493 49.1661605834962,7.9305562973023 49.166763305664,7.92636251449596 49.1661376953126,7.92310857772827 49.1705245971681,7.92422628402716 49.1709289550782,7.92188024520885 49.1729545593261,7.91328859329235 49.1716499328613)) | 0.0006 | POINT(7.939222801022452 49.174162050572875) |
| 47635 | POLYGON((1.96830236911779 50.4792022705078,1.95268142223352 50.4659004211427,1.95296394824982 50.4624557495117,1.97153651714331 50.4455108642578,1.97153651714331 50.4455108642578,1.95574295520788 50.4444007873535,1.93139851093304 50.4574050903321,1.92609250545502 50.4569587707521,1.92609250545502 50.4569587707521,1.91671550273901 50.4686088562013,1.91671550273901 50.4686088562013,1.92882084846502 50.484073638916,1.92882084846502 50.484073638916,1.93895876407635 50.4857215881348,1.93895876407635 50.4857215881348,1.93309891223919 50.4800529479982,1.93992817401892 50.4750938415528,1.95543003082281 50.4737548828126,1.96191537380224 50.4791946411134,1.96191537380224 50.4791946411134,1.96830236911779 50.4792022705078)) | 0.0006 | POINT(1.9438812673092436 50.46892013549811) |