Datenbank-Dokumentation

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.

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	geometry Dieser 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: Auswahl von "GeomFromText" in der Spalte "Funktion" Eingabe von POINT(11.583720 48.135876) in der Spalte "Wert"	beliebig	Die simplifizierten Geodaten.
epsilon	float(5,4)	beliebig	Die Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone.
mittelpunkt	point Dieser 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: Auswahl von "GeomFromText" in der Spalte "Funktion" Eingabe von POINT(11.583720 48.135876) in der Spalte "Wert"	beliebig	Der geometrische Mittelpunkt des vereinfachten Polygons.

Ausschnitt

id_ort	geodaten	epsilon	mittelpunkt
60141	POLYGON((10.3363447189332 46.9719123840332,10.3370885849 46.973072052002,10.3389797210694 46.974952697754,10.3420553207399 46.9781150817872,10.3423013687135 46.9807434082031,10.3451099395753 46.9826431274415,10.3451099395753 46.9826431274415,10.3460607528688 46.9831466674805,10.347152709961 46.9836311340333,10.347152709961 46.9836311340333,10.3487939834596 46.9853286743163,10.3487939834596 46.9853286743163,10.3493556976318 46.9878692626953,10.3499984741211 46.9890251159669,10.3499984741211 46.9890251159669,10.3514728546144 46.9900817871095,10.3514728546144 46.9900817871095,10.3535232543946 46.9906730651856,10.3559894561768 46.9920463562013,10.3559894561768 46.9920463562013,10.36137008667 46.9925498962403,10.3657341003418 46.9925460815431,10.3696813583375 46.9923744201661,10.3731241226197 46.9919700622559,10.3760776519777 46.9920463562013,10.3775959014894 46.9923744201661,10.380265235901 46.9938087463378,10.3809928894043 46.9944114685059,10.383436203003 46.9960670471193,10.383436203003 46.9960670471193,10.3841676712037 46.9966888427735,10.385012626648 46.9972648620605,10.3859806060792 46.998218536377,10.3859806060792 46.998218536377,10.3865518569947 46.9986305236816,10.3875494003296 46.9991188049318,10.3908472061158 47.0002212524414,10.3921213150024 47.0004005432129,10.3947038650513 47.0005149841309,10.3996639251708 46.9989051818849,10.4063053131104 46.9933128356934,10.4063053131104 46.9933128356934,10.4070615768433 46.9926948547363,10.4079475402833 46.9921722412111,10.4087133407593 46.9915771484376,10.4095697402955 46.9910583496094,10.410894393921 46.9900016784667,10.410894393921 46.9900016784667,10.4157142639161 46.9853210449218,10.4183731079103 46.9841804504395,10.420919418335 46.9831123352052,10.431757926941 46.9767456054687,10.4319381713867 46.97420501709,10.4304809570312 46.9694213867188,10.4294033050538 46.9680786132813,10.4273014068604 46.9643859863281,10.4281339645386 46.9611358642578,10.436939239502 46.9566917419434,10.436939239502 46.9566917419434,10.4322395324706 46.9541397094727,10.4201154708863 46.9550628662109,10.4145812988281 46.9536933898926,10.4013557434082 46.9477462768554,10.3908405303955 46.939437866211,10.3836097717285 46.9290618896484,10.3828525543213 46.9220237731934,10.379590034485 46.9163398742677,10.379451751709 46.912956237793,10.3809728622438 46.9095268249512,10.380428314209 46.9004936218263,10.380428314209 46.9004936218263,10.3754663467408 46.8981323242189,10.366289138794 46.9029006958009,10.3573589324951 46.9012870788575,10.3454198837281 46.9047012329102,10.3432769775391 46.9062004089356,10.3423767089844 46.9090423583984,10.3360910415649 46.9153060913087,10.3268995285035 46.921657562256,10.3153944015503 46.9268646240235,10.3153944015503 46.9268646240235,10.3159818649293 46.9322738647462,10.312195777893 46.9363479614258,10.3113422393799 46.9368782043458,10.307912826538 46.9401245117187,10.3093290328981 46.9459533691407,10.3098440170288 46.9482231140136,10.3120641708375 46.9511756896973,10.3170700073243 46.9534606933595,10.3205165863037 46.9538078308105,10.3238515853882 46.9537887573243,10.3270311355591 46.9544334411622,10.3276309967042 46.954875946045,10.3280611038209 46.9554023742676,10.3280611038209 46.9554023742676,10.3287935256959 46.9571037292481,10.3297595977783 46.9587745666504,10.330355644226 46.9605712890625,10.330355644226 46.9605712890625,10.3314533233644 46.9630393981934,10.3321008682252 46.9648170471191,10.3324337005616 46.9653701782227,10.3337659835817 46.9669876098634,10.3351364135743 46.9685859680177,10.3363447189332 46.9719123840332))	0.0006	POINT(10.366808753747257 46.96552305955156)
73323	POLYGON((14.5324420928955 46.1717834472657,14.5324029922485 46.1646728515626,14.5272541046142 46.1575546264648,14.5170297622681 46.1575431823731,14.5118408203126 46.1433181762696,14.5067281723024 46.1433105468751,14.5067281723024 46.1433105468751,14.4811677932739 46.1432838439943,14.4811496734619 46.1397285461426,14.4657926559449 46.136157989502,14.4606790542602 46.1361503601075,14.4606790542602 46.1361503601075,14.4607172012329 46.1432647705078,14.4557008743287 46.1610336303711,14.4557600021362 46.1717033386232,14.4506464004517 46.1716957092286,14.450740814209 46.1894721984864,14.450740814209 46.1894721984864,14.455891609192 46.196590423584,14.4559307098389 46.2037010192872,14.4559307098389 46.2037010192872,14.4968299865723 46.203742980957,14.4968299865723 46.203742980957,14.4968099594117 46.2001876831055,14.5018653869629 46.1895294189454,14.5171623229982 46.1824340820313,14.5120315551758 46.1788711547853,14.5273303985596 46.1717758178712,14.5324420928955 46.1717834472657))	0.0006	POINT(14.486600467136965 46.16906724657337)
1389724	POLYGON((-0.029575999826136 40.9049453735352,-0.034671999514046 40.9091262817383,-0.068236999213696 40.9133491516114,-0.072521999478283 40.9165878295898,-0.077868998050633 40.9173545837403,-0.082217000424862 40.9199333190919,-0.08857399970293 40.9193496704103,-0.095995001494884 40.9242210388185,-0.098275996744633 40.93070602417,-0.096505001187325 40.9328575134277,-0.09774000197649 40.9404754638672,-0.09601999819273 40.9450340270996,-0.091240003705025 40.9467773437501,-0.086070999503136 40.9449157714845,-0.08075899630785 40.9476890563966,-0.07303199917078 40.9464683532715,-0.056088998913708 40.9486961364746,-0.046333998441696 40.9433898925782,-0.039262000471354 40.936092376709,-0.03024799935514 40.9344863891602,-0.020889999344945 40.9278564453126,-0.01715499907732 40.921169281006,-0.0204639993608 40.9138259887696,-0.029575999826136 40.9049453735352))	0.0006	POINT(-0.06520639084601747 40.929795970087525)
1400688	POLYGON((-6.38934898376465 40.9836921691895,-6.38724994659424 40.9817085266113,-6.38877010345459 40.9763259887696,-6.39228200912476 40.9732131958008,-6.39531612396235 40.9728393554688,-6.39663314819336 40.9695358276368,-6.39437913894653 40.9596710205078,-6.38706111907959 40.9464302062988,-6.40657520294189 40.9371643066406,-6.41441679000849 40.9351768493652,-6.42092895507801 40.9364242553711,-6.42887210845947 40.9313163757324,-6.43594789505005 40.9226112365723,-6.43938684463495 40.9225273132324,-6.44154596328735 40.9240837097168,-6.43775320053101 40.9258270263673,-6.43848323822021 40.932773590088,-6.44284296035767 40.9359970092773,-6.44283819198608 40.9389038085938,-6.44798707962036 40.9460906982421,-6.44610404968262 40.9502983093262,-6.44909715652466 40.9498291015626,-6.44777011871338 40.9508171081543,-6.45145320892334 40.9542465209962,-6.45157909393305 40.9619064331056,-6.46276903152466 40.9752655029296,-6.46120119094849 40.976402282715,-6.46621704101557 40.9807395935059,-6.46493005752558 40.9818229675294,-6.454999923706 40.9777793884278,-6.4536252021789 40.9801635742188,-6.44231605529779 40.9809150695801,-6.42646884918207 40.9858741760254,-6.42422199249268 40.9844360351563,-6.41679906845093 40.9868621826173,-6.41233587265015 40.9832763671874,-6.40461683273315 40.9838638305664,-6.39812612533569 40.9868392944337,-6.39577388763428 40.9852142333984,-6.39215707778925 40.9858436584474,-6.38934898376465 40.9836921691895))	0.0006	POINT(-6.426279520988446 40.96136770248416)
25807	POLYGON((2.2313027381897 49.0517921447755,2.22387528419489 49.0453033447266,2.22387528419489 49.0453033447266,2.21413445472729 49.0472030639648,2.1899888515473 49.042896270752,2.18558573722845 49.044548034668,2.17388653755188 49.0387649536134,2.17388653755188 49.0387649536134,2.17529988288879 49.0453605651855,2.19417309761053 49.050018310547,2.2040588855744 49.0610656738282,2.2040588855744 49.0610656738282,2.2313027381897 49.0517921447755))	0.0006	POINT(2.1995105147362004 49.047673861185764)
1406614	POLYGON((-0.467447996139413 39.2382698059083,-0.472362011671066 39.2363052368165,-0.478594988584518 39.2446556091309,-0.493948012590408 39.2570266723633,-0.504339993000031 39.2688064575195,-0.505441009998322 39.2799301147462,-0.499651998281479 39.2826881408692,-0.495231002569199 39.2824821472169,-0.490038990974426 39.2847213745118,-0.482740998268071 39.2855033874512,-0.463097006082535 39.275733947754,-0.441372990608215 39.267864227295,-0.437442988157272 39.2649841308594,-0.414269000291824 39.2573280334473,-0.413118004798832 39.2432098388671,-0.418098002672195 39.2461433410646,-0.42662900686264 39.2476081848145,-0.431863993406296 39.2470321655273,-0.45347198843956 39.2374534606934,-0.460557997226658 39.2362289428712,-0.467447996139413 39.2382698059083))	0.0006	POINT(-0.46248589903114806 39.25919876098638)
41793	POLYGON((5.72308826446539 49.0208015441895,5.73057222366333 49.0179595947267,5.74316453933727 49.0211982727051,5.74316453933727 49.0211982727051,5.74967384338379 49.0084991455078,5.78416156768805 49.0150184631349,5.78938674926758 49.014762878418,5.78673934936523 49.0051956176759,5.79152584075939 48.9995956420899,5.80724143981939 49.0001564025878,5.81406402587885 49.0054321289062,5.81406402587885 49.0054321289062,5.81740713119518 49.0080604553223,5.82219362258917 49.0067977905273,5.82136726379389 49.0034141540527,5.80273580551159 48.9871139526367,5.80439376831066 48.9838905334474,5.80439376831066 48.9838905334474,5.80426883697515 48.9737281799317,5.77324962615972 48.9728393554688,5.75973176956177 48.9676780700685,5.75499296188354 48.9615631103516,5.75499296188354 48.9615631103516,5.74647426605236 48.9586067199707,5.73132038116461 48.9588546752929,5.72731924057013 48.956813812256,5.730944633484 48.9506683349609,5.730944633484 48.9506683349609,5.69559240341192 48.9533729553224,5.69559240341192 48.9533729553224,5.69319772720331 48.9564590454102,5.68795585632324 48.9562911987305,5.66343688964844 48.9521408081056,5.65177059173584 48.9634056091309,5.64156913757336 48.9643211364746,5.64154005050653 48.9677848815918,5.64154005050653 48.9677848815918,5.64311981201183 48.974391937256,5.66231966018677 48.9791412353516,5.66513156890863 48.9854583740235,5.64234447479248 48.9922065734863,5.64234447479248 48.9922065734863,5.67817878723145 49.0062484741212,5.69250869750977 49.0162277221681,5.7077784538269 49.0181427001954,5.7077784538269 49.0181427001954,5.71678972244268 49.0162467956544,5.72308826446539 49.0208015441895))	0.0006	POINT(5.732639708417561 48.98627122919615)
19658	POLYGON((12.7083129882814 43.2937507629394,12.7103862762452 43.2933197021484,12.7193136215211 43.2958793640137,12.7227811813354 43.298397064209,12.7290163040162 43.3059272766114,12.7272863388062 43.3069038391113,12.7261629104615 43.3099746704102,12.7280530929567 43.3144302368165,12.7340259552002 43.3176307678223,12.7539157867432 43.3249816894531,12.7654447555543 43.3270606994629,12.78342628479 43.3421211242676,12.78342628479 43.3421211242676,12.792037010193 43.3382492065431,12.7949333190918 43.3352127075196,12.7997522354125 43.3254432678223,12.8033256530762 43.3074188232422,12.8019208908081 43.2957496643067,12.800524711609 43.2917442321778,12.7934865951539 43.2886657714845,12.7901763916017 43.2854461669921,12.7901706695557 43.2838706970215,12.7901706695557 43.2838706970215,12.7717962265015 43.2747802734375,12.7513742446899 43.269157409668,12.7502346038819 43.2693367004394,12.7490692138672 43.2742195129395,12.7456741333008 43.2784118652344,12.7195205688477 43.2873649597169,12.7129640579224 43.2857284545899,12.7103853225707 43.2841644287109,12.7103853225707 43.2841644287109,12.7057867050171 43.2842102050782,12.7035989761354 43.2889442443849,12.7060098648072 43.2930183410645,12.7083129882814 43.2937507629394))	0.0006	POINT(12.750995690482045 43.29947629656113)
1399884	POLYGON((-5.64511299133301 42.1321487426758,-5.66579389572138 42.1368560791016,-5.66536808013916 42.1437110900879,-5.65787887573237 42.1504058837891,-5.643639087677 42.1458625793458,-5.63425779342651 42.1560211181641,-5.63306617736816 42.1555252075196,-5.6231169700622 42.1657867431642,-5.61909914016724 42.1675987243653,-5.61507701873779 42.1689605712891,-5.60710000991816 42.1671867370606,-5.59841394424433 42.1682472229004,-5.57084512710571 42.1600379943848,-5.57205581665033 42.135540008545,-5.53377103805542 42.1406440734864,-5.52666187286371 42.1404876708984,-5.52397918701166 42.1305389404298,-5.51958322525024 42.1279525756837,-5.51663398742676 42.122200012207,-5.52926015853876 42.1136169433594,-5.52689218521112 42.1042861938477,-5.54325199127192 42.0993690490722,-5.54172515869135 42.098087310791,-5.54424285888672 42.0924377441406,-5.54391098022455 42.0862083435058,-5.54813623428345 42.0791130065919,-5.54934215545643 42.0703163146974,-5.55265617370594 42.0637130737305,-5.5573301315307 42.0606575012207,-5.56058692932129 42.0559539794923,-5.56472778320313 42.059211730957,-5.56965303421021 42.0578498840332,-5.57455396652222 42.0645866394044,-5.57761001586914 42.0654335021973,-5.5793309211731 42.0643882751465,-5.58005809783936 42.0584373474122,-5.58649396896362 42.0508995056153,-5.58878421783447 42.0528526306152,-5.58339691162104 42.0659713745118,-5.58638715744019 42.0711822509767,-5.58928108215332 42.0724830627441,-5.58863592147827 42.0756416320801,-5.58036518096918 42.0812377929688,-5.57567501068115 42.0952949523926,-5.58140182495112 42.0966606140138,-5.57563400268555 42.0999336242675,-5.57672309875488 42.1262512207032,-5.61313199996943 42.1349639892578,-5.62340021133417 42.1345863342286,-5.6331639289856 42.1401176452637,-5.64186096191401 42.136573791504,-5.64466190338123 42.1372833251953,-5.64511299133301 42.1321487426758))	0.0006	POINT(-5.584302315345149 42.109256010789174)
56419	POLYGON((4.68749904632574 45.5582084655762,4.69218015670776 45.5582542419434,4.69546413421637 45.5708847045898,4.68665695190435 45.573097229004,4.68621826171886 45.5763854980469,4.68621826171886 45.5763854980469,4.70446062088024 45.571949005127,4.71278762817388 45.5741539001466,4.71278762817388 45.5741539001466,4.72569704055798 45.5735702514648,4.72569704055798 45.5735702514648,4.72347259521484 45.5671920776368,4.6978693008424 45.5564651489258,4.69250202178955 45.5507354736329,4.69250202178955 45.5507354736329,4.68517637252813 45.5547561645509,4.68517637252813 45.5547561645509,4.68749904632574 45.5582084655762))	0.0006	POINT(4.699550909154618 45.56560314402866)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point