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
69181	POLYGON((9.15431022644054 54.0181999206542,9.14706420898443 54.0172500610352,9.14195442199713 54.0148048400879,9.12386512756353 54.0152549743653,9.11958599090576 54.0116844177247,9.11958599090576 54.0116844177247,9.11564922332769 54.0098075866699,9.1027364730835 54.0120162963867,9.10468864440924 54.0082473754883,9.10251045227056 54.0081634521486,9.10124778747564 54.0104293823243,9.09756565094006 54.0106124877931,9.0972843170166 54.0117683410645,9.09164714813238 54.0120353698732,9.09219360351574 54.0097808837891,9.08834552764887 54.0099334716797,9.0899534225465 54.0055122375489,9.09278106689464 54.0034255981445,9.0876026153565 54.0037269592285,9.08859252929682 54.0023536682128,9.09145355224604 54.0020637512208,9.09017086029053 53.996955871582,9.08457946777355 53.9968643188477,9.08457946777355 53.9968643188477,9.08621597290033 53.9952659606935,9.08531856536877 53.9938087463379,9.07946872711176 53.9932136535644,9.08029460906982 53.9903297424318,9.08191967010504 53.9905281066894,9.08223152160645 53.989372253418,9.08441448211676 53.9897575378419,9.08482933044439 53.9887123107911,9.08735942840576 53.9891891479493,9.08826637268061 53.9871063232422,9.08769130706787 53.9860305786134,9.0796623229981 53.9845008850098,9.08340167999268 53.9802742004395,9.08791732788097 53.9803009033204,9.09272289276123 53.9747123718261,9.10129451751715 53.9763832092286,9.10370540618896 53.9720344543456,9.10554504394543 53.9726486206056,9.106520652771 53.9688415527345,9.10825061798101 53.9666862487792,9.11509799957287 53.9688644409181,9.11582183837902 53.9662399291992,9.10950279235851 53.964210510254,9.10990333557135 53.9636039733888,9.10990333557135 53.9636039733888,9.12096118926996 53.9660987854005,9.12172985076904 53.9653968811035,9.12822914123541 53.9675369262696,9.13204765319819 53.9667434692384,9.1392908096314 53.9689941406251,9.13802337646484 53.9700508117676,9.14467239379888 53.9718284606935,9.1380882263183 53.9747772216798,9.14458656311035 53.9750556945802,9.14811706542963 53.9776535034179,9.15782356262213 53.9777145385742,9.16699218749994 53.980381011963,9.16699218749994 53.980381011963,9.15943622589123 54.0048789978027,9.16580009460444 54.0052146911621,9.16550827026379 54.0107269287109,9.16550827026379 54.0107269287109,9.15417194366455 54.0162734985352,9.15431022644054 54.0181999206542))	0.0006	POINT(9.112316216995499 53.99083721103955)
62267	MULTIPOLYGON(((11.4387474060058 52.9240608215333,11.4451246261597 52.9279937744142,11.4451246261597 52.9279937744142,11.4395580291747 52.9321289062501,11.4489536285402 52.9373512268066,11.460259437561 52.9401435852052,11.4606094360352 52.9410285949708,11.457540512085 52.943504333496,11.4585628509522 52.9460525512696,11.4453468322754 52.9563369750977,11.4460554122925 52.9577484130861,11.4377145767211 52.960418701172,11.4386119842529 52.9627227783204,11.4350728988648 52.9643516540528,11.4352865219117 52.9659957885743,11.4268865585328 52.9673538208008,11.4276447296143 52.9700965881349,11.430856704712 52.9696121215821,11.4347257614136 52.9704666137696,11.4380664825441 52.9692916870117,11.442066192627 52.977767944336,11.4353227615356 52.9769020080567,11.4341659545899 52.9817848205566,11.402367591858 52.9845733642578,11.3957281112671 52.9833374023439,11.3955659866334 52.9849319458008,11.3739290237427 52.9800987243653,11.3739290237427 52.9800987243653,11.3742589950562 52.9771995544434,11.3709821701051 52.9771881103516,11.3692245483398 52.9786834716797,11.366400718689 52.9790267944336,11.3465442657472 52.9743118286133,11.3304376602173 52.9679031372071,11.3193483352662 52.9646263122559,11.3157539367676 52.9526176452637,11.3128986358643 52.9489402770996,11.3128986358643 52.9489402770996,11.3126516342164 52.9483833312988,11.3191061019898 52.948585510254,11.3259935379029 52.9453544616699,11.3268508911134 52.9469604492188,11.3397207260132 52.944034576416,11.3437547683717 52.9424514770508,11.3438091278076 52.9408760070802,11.3587207794191 52.9370155334473,11.357081413269 52.9343948364258,11.3727388381959 52.9297599792481,11.3748111724854 52.9312782287598,11.3762731552124 52.934066772461,11.3834590911866 52.9325218200685,11.4340419769287 52.928783416748,11.4387474060058 52.9240608215333)),((11.4691400527955 52.9582557678224,11.4710884094239 52.9584236145021,11.4687891006471 52.960720062256,11.4641675949097 52.961524963379,11.4640712738038 52.9570846557617,11.4687032699586 52.9567909240723,11.4691400527955 52.9582557678224)))	0.0006	POINT(11.39436733760864 52.95574419991526)
68314	POLYGON((7.82113504409796 50.3730659484863,7.82723760604864 50.3699760437013,7.82782554626465 50.3685493469238,7.83639955520641 50.3670387268067,7.83994102478033 50.3651504516601,7.84736013412481 50.3663749694825,7.84904813766479 50.3678894042969,7.85236167907726 50.3667945861816,7.85067939758306 50.365665435791,7.85125732421886 50.3651580810547,7.85471487045288 50.366497039795,7.85525178909307 50.3694648742676,7.86138772964483 50.3717460632324,7.86496829986578 50.3746757507325,7.86436700820929 50.3763618469238,7.86533784866339 50.377124786377,7.86533784866339 50.377124786377,7.87261915206909 50.3785972595214,7.88068819046015 50.377052307129,7.87993049621593 50.3724594116211,7.87993049621593 50.3724594116211,7.87861013412481 50.3718986511232,7.87645578384405 50.3686256408693,7.87645578384405 50.3686256408693,7.8755922317506 50.3664474487306,7.87716674804693 50.3634567260742,7.87716674804693 50.3634567260742,7.87696313858044 50.3610496520996,7.87696313858044 50.3610496520996,7.87472581863403 50.3590240478517,7.87145853042603 50.358814239502,7.87145853042603 50.358814239502,7.86795330047619 50.3588256835939,7.86795330047619 50.3588256835939,7.86709165573131 50.3561210632324,7.86808776855463 50.3539123535156,7.86808776855463 50.3539123535156,7.87046718597418 50.351375579834,7.8696179389953 50.3499488830568,7.8696179389953 50.3499488830568,7.86593818664556 50.3485794067383,7.86593818664556 50.3485794067383,7.86498880386358 50.3474388122559,7.86498880386358 50.3474388122559,7.85742473602306 50.3483390808106,7.85567188262939 50.3502349853517,7.85452365875256 50.3501358032227,7.85490179061895 50.3534202575683,7.85302972793579 50.3541793823243,7.85302972793579 50.3541793823243,7.85198211669928 50.3557853698731,7.8521547317506 50.3582191467285,7.85077428817743 50.3589897155762,7.84956121444708 50.3617897033693,7.83578491210943 50.3642234802247,7.82845211029053 50.3668785095215,7.8191056251527 50.3648490905763,7.82052755355829 50.3674278259278,7.82113504409796 50.3730659484863))	0.0006	POINT(7.859111218616928 50.362483583647666)
1401060	POLYGON((-3.99480009078979 41.4348907470704,-4.00895404815674 41.432155609131,-4.01419115066528 41.4272346496582,-4.01853704452509 41.4327011108398,-4.03147220611572 41.4377555847168,-4.04118490219116 41.4515914916992,-4.02515411376953 41.4690399169923,-3.98730397224426 41.4693984985352,-3.98726797103876 41.4551582336426,-3.99490690231323 41.4394569396973,-3.99480009078979 41.4348907470704))	0.0006	POINT(-4.010377240180956 41.44493827819828)
21728	POLYGON((1.09404051303864 44.8152809143066,1.07117092609411 44.8213691711426,1.05647695064545 44.8123054504395,1.05647695064545 44.8123054504395,1.05958366394043 44.7974433898927,1.05958366394043 44.7974433898927,1.07626175880432 44.7994461059571,1.0837512016297 44.796443939209,1.0837512016297 44.796443939209,1.09404051303864 44.8152809143066))	0.0006	POINT(1.0712329811520256 44.8053868611654)
41323	POLYGON((6.16786050796514 48.7468223571778,6.1794891357423 48.7424278259278,6.1794891357423 48.7424278259278,6.20210313797008 48.7294654846193,6.20210313797008 48.7294654846193,6.21535921096813 48.7478485107423,6.21573352813721 48.7685050964356,6.20794200897222 48.7728919982911,6.20794200897222 48.7728919982911,6.172203540802 48.7687873840331,6.172203540802 48.7687873840331,6.17592096328735 48.7551422119142,6.16786050796514 48.7468223571778))	0.0006	POINT(6.191529154777586 48.75378863016771)
16014	POLYGON((10.5960378646851 45.1917839050293,10.5970926284791 45.1915435791016,10.5991592407227 45.1971244812012,10.5989446640015 45.2004013061525,10.5962018966676 45.2056427001953,10.5942821502686 45.2071189880372,10.5915212631227 45.2076454162598,10.5879669189453 45.2057762145997,10.5746307373047 45.2106971740723,10.5746307373047 45.2106971740723,10.5600719451904 45.2138214111328,10.5600719451904 45.2138214111328,10.5526638031006 45.2055168151855,10.5457382202149 45.1998939514161,10.5439500808716 45.1996994018555,10.5439500808716 45.1996994018555,10.5338077545167 45.1880264282226,10.5444421768189 45.178352355957,10.5444421768189 45.178352355957,10.5471420288085 45.1798171997071,10.5639953613281 45.1817779541016,10.5760688781738 45.1763038635253,10.5760688781738 45.1763038635253,10.578805923462 45.1829948425293,10.5834512710571 45.1894111633302,10.5856389999391 45.190731048584,10.59504032135 45.192798614502,10.5960378646851 45.1917839050293))	0.0006	POINT(10.572067331384757 45.19539826004596)
58425	POLYGON((8.0284414291383 50.6970024108887,8.03969001770025 50.6973762512207,8.03969001770025 50.6973762512207,8.03916454315191 50.6984634399415,8.04304599761963 50.7117156982421,8.0403261184693 50.7256584167481,8.03382110595714 50.7309303283691,8.02763271331793 50.7334098815918,8.02763271331793 50.7334098815918,8.02051544189453 50.7338676452637,8.01831340789795 50.7315330505372,8.00864410400402 50.7279777526857,8.00119781494152 50.7274589538574,8.00137901306152 50.7259216308594,8.00731086730963 50.7253303527833,8.00764751434326 50.7232742309571,8.00764751434326 50.7232742309571,8.00981712341309 50.7232856750488,8.00865936279291 50.720802307129,8.01133918762218 50.7192039489747,8.01144123077387 50.7170372009278,8.01478099823009 50.7147445678712,8.01943302154541 50.7142295837403,8.01985740661615 50.7105026245118,8.01985740661615 50.7105026245118,8.02376651763916 50.7062988281251,8.02069568634039 50.7061729431153,8.01920127868658 50.7049674987793,8.01954746246332 50.7016029357911,8.0169620513916 50.6997680664063,8.02022457122814 50.6978988647462,8.02089118957531 50.6989059448243,8.02356338500982 50.6988677978516,8.02410316467297 50.6977348327637,8.02572250366205 50.6977500915527,8.02718544006359 50.696361541748,8.02718544006359 50.696361541748,8.0284414291383 50.6970024108887))	0.0006	POINT(8.020982020610127 50.71289134669951)
52023	POLYGON((-0.639264523983002 45.8222770690919,-0.621191263198853 45.8217315673829,-0.607809364795685 45.8247032165528,-0.600574851036072 45.8205337524414,-0.600574851036072 45.8205337524414,-0.594855904579049 45.8198242187501,-0.594855904579049 45.8198242187501,-0.598538041114807 45.8262710571289,-0.598538041114807 45.8262710571289,-0.621473371982574 45.8323135375978,-0.63137012720108 45.8398475646974,-0.617990791797638 45.8572692871095,-0.605653047561646 45.8623352050781,-0.605653047561646 45.8623352050781,-0.595003545284214 45.8683891296387,-0.595003545284214 45.8683891296387,-0.598811507225037 45.8705825805665,-0.626984715461731 45.8653373718262,-0.626984715461731 45.8653373718262,-0.655467629432678 45.8621101379395,-0.662355601787567 45.8498458862306,-0.680489182472172 45.8385810852051,-0.680489182472172 45.8385810852051,-0.677217960357666 45.8361358642579,-0.665406465530396 45.8400459289552,-0.652298629283905 45.8360900878907,-0.639264523983002 45.8222770690919))	0.0006	POINT(-0.6251867619844409 45.84213447570805)
12981	POLYGON((16.6467838287354 39.0696525573731,16.6365051269532 39.0761184692382,16.6365051269532 39.0761184692382,16.6353473663331 39.0744476318359,16.6172027587891 39.0704460144044,16.6034088134766 39.0697631835938,16.5986862182618 39.0741500854493,16.5960693359376 39.0780220031739,16.5941772460939 39.0828399658203,16.5945091247559 39.0850028991699,16.5909004211426 39.0872230529786,16.578971862793 39.085262298584,16.5765571594238 39.0832519531251,16.5799999237062 39.0815010070802,16.5871238708496 39.0673370361329,16.5866985321046 39.065299987793,16.5749835968017 39.0619430541993,16.5773220062257 39.0564041137696,16.5705966949462 39.0469207763673,16.5696811676025 39.0435295104981,16.5769863128662 39.0330543518068,16.5878467559815 39.0262413024902,16.5903453826904 39.0161628723145,16.5867080688477 39.0139923095703,16.5867080688477 39.0139923095703,16.5894412994386 39.0103149414062,16.589849472046 39.0084877014161,16.5888042449952 39.0072441101075,16.5916862487793 39.0038108825684,16.598934173584 38.9965324401855,16.6056327819825 38.9924087524414,16.6056327819825 38.9924087524414,16.6100101470948 38.988437652588,16.6100101470948 38.988437652588,16.6160736083985 38.992603302002,16.6160736083985 38.992603302002,16.6095390319825 38.9982719421387,16.6064796447755 39.0062789916993,16.6056671142578 39.0134429931641,16.6079654693605 39.020938873291,16.610185623169 39.0261726379395,16.6148662567139 39.0279045104982,16.6159210205079 39.0296058654786,16.6068267822266 39.0400543212892,16.6065006256104 39.0445365905763,16.6083221435546 39.0463066101074,16.6099529266359 39.046028137207,16.6159648895264 39.0370101928712,16.6184158325196 39.0366210937501,16.6229934692384 39.0442543029786,16.619348526001 39.049171447754,16.6187915802003 39.0525131225586,16.622522354126 39.0574798583984,16.624755859375 39.0591163635254,16.6274871826172 39.0548515319824,16.6288261413574 39.0543022155762,16.6404933929444 39.0556068420411,16.6468544006348 39.0573463439941,16.6475448608399 39.0685462951661,16.6467838287354 39.0696525573731))	0.0006	POINT(16.605745735815066 39.0413275896493)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point