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
16671	POLYGON((12.9871520996094 43.6563301086425,12.9850578308105 43.6381340026856,12.9850578308105 43.6381340026856,13.0029916763306 43.6300125122071,13.015661239624 43.6175575256349,13.0170621871948 43.6126174926758,13.0218448638916 43.6033248901368,13.0218448638916 43.6033248901368,13.0254764556885 43.6046943664551,13.0384807586669 43.6143188476562,13.0494403839111 43.620304107666,13.0610866546631 43.6292533874511,13.069531440735 43.6311111450195,13.0962438583375 43.6286964416504,13.0962438583375 43.6286964416504,13.1021766662598 43.6438369750976,13.1021766662598 43.6438369750976,13.098307609558 43.6513175964357,13.0911140441895 43.6548881530762,13.0887670516968 43.655014038086,13.0853509902954 43.6587181091309,13.0805463790895 43.6666526794434,13.0819292068483 43.6742668151855,13.0819292068483 43.6742668151855,13.0823383331299 43.6882934570312,13.0823383331299 43.6882934570312,13.070704460144 43.6939849853517,13.070704460144 43.6939849853517,13.048469543457 43.6835746765138,13.0396738052369 43.677101135254,13.0340127944946 43.6757202148438,13.0273141860962 43.676872253418,13.0273141860962 43.676872253418,13.0223417282106 43.674530029297,13.0138082504273 43.6651344299316,13.0052042007446 43.6594390869142,12.9923658370972 43.656566619873,12.9871520996094 43.6563301086425))	0.0006	POINT(13.048704430863687 43.6510723217114)
25353	POLYGON((2.67420864105225 48.9840202331544,2.67382717132568 48.9773292541504,2.67382717132568 48.9773292541504,2.67218017578131 48.9763908386231,2.67218017578131 48.9763908386231,2.66082525253307 48.9747581481935,2.66082525253307 48.9747581481935,2.64949703216558 48.9814720153809,2.63506531715393 48.999683380127,2.62410616874706 49.0070304870605,2.62410616874706 49.0070304870605,2.64789080619806 48.9987487792969,2.66385889053339 48.9999351501466,2.67420864105225 48.9840202331544))	0.0006	POINT(2.65633832491365 48.987298231858524)
67522	POLYGON((8.58895397186274 48.787296295166,8.5801038742066 48.7893676757813,8.56904602050776 48.7887611389161,8.56190490722662 48.789608001709,8.55655384063732 48.7885894775391,8.55090522766119 48.7912788391114,8.55090522766119 48.7912788391114,8.55427360534679 48.7972564697267,8.55654621124279 48.8047714233398,8.56000995635981 48.8104553222657,8.57868957519537 48.8144493103028,8.58778953552252 48.8182601928712,8.5889244079591 48.8157234191895,8.59510040283209 48.8121147155762,8.59414005279547 48.8102188110353,8.59503269195557 48.8086509704589,8.59718322753912 48.8076324462891,8.59718322753912 48.8076324462891,8.6018323898316 48.8075256347657,8.60061645507818 48.8051643371583,8.6030740737915 48.8039665222169,8.60847854614258 48.8036880493165,8.60249233245855 48.8000335693359,8.6049013137818 48.7990226745606,8.60216426849377 48.7993698120118,8.59973335266119 48.795711517334,8.59455299377447 48.7951850891114,8.59636592864996 48.7923431396484,8.59539890289307 48.7885322570801,8.58895397186274 48.787296295166))	0.0006	POINT(8.585270914538201 48.800823737835096)
44185	POLYGON((0.953983128070888 43.7873725891113,0.942079126834983 43.7918663024903,0.923683822155112 43.7909393310547,0.917444229125977 43.7858619689941,0.904057025909424 43.7842979431153,0.897291123867092 43.7885360717774,0.897291123867092 43.7885360717774,0.893154025077877 43.7746810913085,0.893154025077877 43.7746810913085,0.90447282791132 43.7485351562501,0.90447282791132 43.7485351562501,0.9269779920578 43.7504577636718,0.942258715629634 43.7582130432129,0.950641393661556 43.7551002502443,0.950641393661556 43.7551002502443,0.959232270717678 43.7551803588868,0.966055691242275 43.7595672607423,0.966055691242275 43.7595672607423,0.969891250133571 43.7613754272461,0.95909887552267 43.7718048095704,0.953983128070888 43.7873725891113))	0.0006	POINT(0.9310968279838988 43.76951045989995)
1389344	POLYGON((-0.065834999084416 42.4220390319825,-0.071411997079849 42.4254150390626,-0.072134003043118 42.427433013916,-0.085946001112461 42.4286193847657,-0.103059999644756 42.4333686828613,-0.123429000377598 42.4369354248047,-0.128840997815018 42.4430046081544,-0.128647997975349 42.449104309082,-0.132710993289948 42.4565086364747,-0.131332993507385 42.4611244201661,-0.134056001901627 42.4651336669922,-0.139222994446754 42.465732574463,-0.153699994087219 42.4715499877931,-0.160787999629918 42.4678535461427,-0.163936004042625 42.4678764343262,-0.173987001180649 42.4726638793946,-0.178968995809498 42.4687232971192,-0.176234006881714 42.4735488891602,-0.176903992891312 42.4765090942384,-0.182426005601883 42.4772949218751,-0.179526999592781 42.4844284057617,-0.182929992675724 42.4915504455566,-0.175358995795193 42.4935188293458,-0.174660995602608 42.5027656555175,-0.179792001843396 42.5053253173829,-0.181712999939919 42.5099983215333,-0.170759007334652 42.5113143920898,-0.166317000985146 42.5156326293946,-0.159349992871284 42.5170669555665,-0.149531006812992 42.5167045593262,-0.144035995006504 42.526165008545,-0.140394002199173 42.5286026000978,-0.133672997355404 42.5118789672852,-0.127352997660637 42.5116844177247,-0.124862000346184 42.5057601928711,-0.119102999567929 42.5018196105956,-0.103294998407364 42.5112953186036,-0.09893199801445 42.5164222717286,-0.096796996891442 42.5302200317383,-0.08992800116539 42.5357627868652,-0.093865998089314 42.5463981628419,-0.085253000259399 42.5584945678712,-0.078460998833179 42.56205368042,-0.075310997664815 42.5658340454102,-0.076334998011532 42.5585479736329,-0.050030998885575 42.555046081543,-0.04856999963522 42.5674362182618,-0.040975999087095 42.5508155822755,-0.033984001725912 42.5538940429688,-0.02683899924159 42.5510063171388,-0.026737999171019 42.548267364502,-0.017711000516954 42.5416755676269,-0.009860999882108 42.5392990112304,-0.004240998998227 42.5328216552734,-0.009391999803483 42.5259246826173,-0.006322000175658 42.5213623046874,0.004395001102296 42.5214653015136,0.009548000059965 42.5146942138671,0.013772999867797 42.5139923095703,0.015207000076828 42.5121421813965,0.016681000590324 42.504108428955,0.023150000721273 42.5001983642578,0.030703000724316 42.4988288879395,0.024095000699276 42.4937973022462,0.021663999185023 42.4857597351075,0.024676999077258 42.4854087829589,0.02903899922967 42.4802589416503,0.027837999165115 42.4765663146973,0.033884000033254 42.472541809082,0.035007998347396 42.463092803955,0.033112000674009 42.4628639221193,0.032083999365625 42.4649810791016,0.022841999307389 42.4657745361329,0.0198010001331 42.4678077697755,0.020105000585318 42.4581565856934,0.016371000558252 42.4553985595703,0.012055000290331 42.4480400085449,-0.005826999899 42.4488601684571,-0.012958999723196 42.4397888183594,-0.007493000011891 42.4274063110352,-0.011268000118434 42.4219512939454,-0.009324000217021 42.4180908203126,-0.011998999863863 42.4203414916992,-0.018322000280023 42.4207839965821,-0.026298999786377 42.4168586730958,-0.024466000497227 42.4144973754884,-0.028381999582052 42.4100532531739,-0.031700000166893 42.40824508667,-0.037732999771777 42.4078521728517,-0.043359998613596 42.4109420776367,-0.045653000473976 42.4144058227539,-0.054074000567198 42.4169807434082,-0.057897001504898 42.4207649230957,-0.065834999084416 42.4220390319825))	0.0006	POINT(-0.06695160162081672 42.48345089984198)
38534	POLYGON((1.06796097755443 49.6222915649414,1.07440757751476 49.6271133422852,1.05778539180761 49.6381568908691,1.05778539180761 49.6381568908691,1.08291518688213 49.646427154541,1.08291518688213 49.646427154541,1.10386550426495 49.6376533508301,1.10386550426495 49.6376533508301,1.10006666183477 49.6296119689941,1.10453379154217 49.6289329528809,1.10453379154217 49.6289329528809,1.09153807163239 49.612621307373,1.09153807163239 49.612621307373,1.08927476406097 49.6117324829103,1.08927476406097 49.6117324829103,1.08037042617792 49.6101379394532,1.06796097755443 49.6222915649414))	0.0006	POINT(1.0864144414663952 49.62751269340517)
36050	POLYGON((6.37835025787354 47.2268447875977,6.3779811859132 47.2336044311525,6.38644075393688 47.2423057556153,6.40672636032104 47.2450370788574,6.41403579711914 47.2405395507812,6.41403579711914 47.2405395507812,6.42016220092773 47.2376289367676,6.42016220092773 47.2376289367676,6.41467380523693 47.2295455932618,6.41829776763927 47.2243309020997,6.41471624374401 47.2225074768066,6.41471624374401 47.2225074768066,6.39495038986206 47.2241058349611,6.37917804718018 47.2168655395509,6.37917804718018 47.2168655395509,6.37482643127453 47.2217025756836,6.37835025787354 47.2268447875977))	0.0006	POINT(6.400526970624972 47.2301599979401)
33423	POLYGON((4.40420675277716 49.4913406372071,4.42416381835949 49.4999351501465,4.42416381835949 49.4999351501465,4.41871452331549 49.5055351257325,4.41665935516357 49.5251197814941,4.41665935516357 49.5251197814941,4.40342283248901 49.5212745666504,4.37890815734869 49.5374908447267,4.37890815734869 49.5374908447267,4.36872291564936 49.5372581481933,4.3643970489502 49.5314254760743,4.34726858139038 49.5244178771973,4.34726858139038 49.5244178771973,4.33955049514771 49.5164756774902,4.34255456924438 49.5104560852051,4.34255456924438 49.5104560852051,4.3473920822143 49.5112113952637,4.35391807556164 49.5063591003417,4.35391807556164 49.5063591003417,4.3788042068482 49.4970703125001,4.38381385803223 49.4919433593751,4.38381385803223 49.4919433593751,4.40420675277716 49.4913406372071))	0.0006	POINT(4.378171985799645 49.513774351640194)
51588	POLYGON((3.08794903755194 49.7375068664552,3.08156991004944 49.718849182129,3.08331942558294 49.7124938964844,3.08331942558294 49.7124938964844,3.07919955253612 49.6916580200195,3.07919955253612 49.6916580200195,3.0840756893158 49.6920166015626,3.09256625175487 49.6996192932129,3.09256625175487 49.6996192932129,3.09727430343639 49.7058715820313,3.11865234375 49.7058334350586,3.11865234375 49.7058334350586,3.12039780616766 49.7057342529298,3.12039780616766 49.7057342529298,3.11365270614635 49.7254791259766,3.1006710529328 49.735221862793,3.1006710529328 49.735221862793,3.08794903755194 49.7375068664552))	0.0006	POINT(3.09730203011463 49.710637934067705)
15646	POLYGON((9.28752326965338 45.8968048095703,9.28520488739019 45.899700164795,9.28520488739019 45.899700164795,9.28308677673351 45.8962745666505,9.27546501159662 45.8960609436036,9.25010395050049 45.899700164795,9.25010395050049 45.899700164795,9.24958133697521 45.8895225524902,9.25450325012213 45.8835067749023,9.25830459594727 45.8807640075684,9.25830459594727 45.8807640075684,9.26116180419933 45.8771400451661,9.26732540130615 45.8752632141114,9.27238845825195 45.8752593994141,9.28297042846685 45.883529663086,9.2872486114502 45.8885421752931,9.2872486114502 45.8885421752931,9.28752326965338 45.8968048095703))	0.0006	POINT(9.270337048698906 45.88886911728809)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point