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
1408036	POLYGON((-7.92120504379272 41.8778266906739,-7.92846488952637 41.8778457641602,-7.93770980834961 41.8752250671388,-7.94410181045521 41.8715705871583,-7.94881820678711 41.8710098266602,-7.95605278015137 41.8732299804689,-7.95670223236073 41.8752250671388,-7.95929813385004 41.8747787475585,-7.96103096008295 41.8755722045898,-7.96196079254145 41.8741722106934,-7.96492099761957 41.8750114440919,-7.96919393539429 41.8743858337403,-7.97147083282471 41.8763694763185,-7.97217321395874 41.8752899169923,-7.97454214096069 41.8753128051759,-7.97835111618036 41.8725852966308,-7.98057508468628 41.8722496032715,-7.99227905273432 41.8849487304688,-7.99387884140015 41.8912506103516,-8.01599788665766 41.9001083374025,-8.01909732818598 41.9047698974609,-8.01711463928217 41.9186325073243,-8.01867961883539 41.9200057983398,-8.02712154388428 41.921443939209,-8.03333473205561 41.9190559387208,-8.03203392028809 41.9152145385742,-8.03699493408197 41.9119529724122,-8.03902435302729 41.9184150695801,-8.04466533660889 41.9246788024902,-8.04883956909174 41.9224510192872,-8.05417060852051 41.9313201904297,-8.05329132080078 41.9346694946288,-8.04886341094965 41.9390602111817,-8.05544281005859 41.9422073364258,-8.05026721954346 41.9427680969238,-8.04189109802246 41.9472618103028,-8.0394926071167 41.9465217590333,-8.03816223144526 41.9432792663575,-8.03213882446283 41.9442634582521,-8.02771663665766 41.9485855102538,-8.01606845855702 41.9482994079589,-8.01628303527821 41.9510154724121,-8.01048469543457 41.9542770385743,-8.00817394256586 41.953125,-8.00168037414545 41.9552307128907,-7.99973583221436 41.9570274353028,-8.00025081634516 41.9606933593751,-7.99369621276855 41.9623107910157,-7.99504280090332 41.966423034668,-7.98243093490601 41.9675636291503,-7.97583484649658 41.9742736816407,-7.97784280776972 41.9767951965333,-7.97400188446045 41.9813919067382,-7.96930980682373 41.9832763671876,-7.9559240341186 41.9809074401857,-7.95467090606689 41.9779701232911,-7.95174884796143 41.9770164489747,-7.94288110733032 41.9893035888672,-7.94542694091797 41.9920997619629,-7.94296503067017 41.9962997436523,-7.9381017684936 41.996467590332,-7.93214416503906 42.0011978149415,-7.93315076827997 42.0034332275391,-7.93159723281855 42.0067520141603,-7.91592788696289 42.0028343200685,-7.90464782714838 42.0033950805664,-7.90060091018677 42.0014533996583,-7.89947700500488 41.993579864502,-7.90304613113392 41.9897918701171,-7.90278387069691 41.9871635437013,-7.909598827362 41.9843139648438,-7.90458679199219 41.9759407043458,-7.89592409133911 41.9694786071777,-7.89495515823364 41.967098236084,-7.9000129699707 41.9625663757325,-7.90602016448975 41.9599075317383,-7.91032314300531 41.9501533508302,-7.90812921524042 41.9286766052246,-7.90561723709101 41.9273605346681,-7.90972423553467 41.9224586486817,-7.91082811355591 41.9140167236329,-7.91006278991699 41.9073448181152,-7.91314315795887 41.8986473083497,-7.9157309532165 41.894744873047,-7.92127990722656 41.8818168640137,-7.91966676712036 41.8801956176758,-7.92120504379272 41.8778266906739))	0.0006	POINT(-7.969286103581242 41.93554204009302)
27797	POLYGON((-0.3228839635849 48.8413124084473,-0.329659789800587 48.8355216979982,-0.329659789800587 48.8355216979982,-0.330098479986191 48.8415336608887,-0.33575060963625 48.8463172912598,-0.33575060963625 48.8463172912598,-0.328520447015762 48.8576011657715,-0.328520447015762 48.8576011657715,-0.30743807554245 48.8577079772949,-0.298548251390457 48.8491592407228,-0.298548251390457 48.8491592407228,-0.3228839635849 48.8413124084473))	0.0006	POINT(-0.32230715589087755 48.847068439830494)
52478	POLYGON((0.278114348650035 45.874855041504,0.259182035923061 45.8781433105469,0.259182035923061 45.8781433105469,0.224056467413959 45.8773345947267,0.209625661373138 45.8744354248048,0.209625661373138 45.8744354248048,0.210297018289509 45.8675422668457,0.214391529560203 45.8666610717773,0.224925816059113 45.872875213623,0.237566292285919 45.862850189209,0.237294271588382 45.8523216247559,0.237294271588382 45.8523216247559,0.242839246988297 45.8461227416992,0.241620808839912 45.8400650024415,0.241620808839912 45.8400650024415,0.25903427600872 45.850757598877,0.263078600168228 45.8490295410157,0.270565539598579 45.8530197143555,0.270565539598579 45.8530197143555,0.263579815626144 45.8578987121583,0.264183431863842 45.8613281249999,0.278114348650035 45.874855041504))	0.0006	POINT(0.24374492750286253 45.86110596429738)
51542	POLYGON((2.61235380172741 49.9367065429689,2.59203100204468 49.940574645996,2.59203100204468 49.940574645996,2.58806252479559 49.9407691955567,2.58806252479559 49.9407691955567,2.57871031761181 49.9372329711915,2.57871031761181 49.9372329711915,2.5724184513092 49.9323768615723,2.57038307189947 49.92289352417,2.56231856346136 49.9190101623536,2.56231856346136 49.9190101623536,2.56468057632452 49.9177436828614,2.56468057632452 49.9177436828614,2.57426643371593 49.917751312256,2.58991360664379 49.9096488952637,2.58991360664379 49.9096488952637,2.60126614570618 49.9236450195312,2.61297416687012 49.9301681518555,2.61235380172741 49.9367065429689))	0.0006	POINT(2.5830608473884333 49.92741669548887)
1397406	POLYGON((-2.44555091857904 40.648220062256,-2.4437689781189 40.6492462158204,-2.4474949836731 40.665096282959,-2.44704794883728 40.6747512817383,-2.45019102096552 40.6796112060548,-2.4454140663147 40.686191558838,-2.44087910652155 40.6893959045411,-2.44204592704773 40.6942367553712,-2.43964099884028 40.6959190368653,-2.44522500038147 40.6976432800294,-2.44713711738581 40.7012443542482,-2.45173001289368 40.7040252685548,-2.45872402191162 40.7056503295899,-2.46073889732355 40.708423614502,-2.45843505859375 40.7107124328614,-2.46199011802673 40.7147369384766,-2.45674610137939 40.7232246398926,-2.44128394126886 40.7215118408204,-2.44316005706787 40.7167739868165,-2.43242788314819 40.7147750854492,-2.4186959266662 40.706184387207,-2.41867804527277 40.7015457153321,-2.40821909904469 40.7010040283203,-2.40156602859491 40.6970252990724,-2.39440298080444 40.697422027588,-2.38804197311401 40.6940650939941,-2.37692809104914 40.696662902832,-2.37475395202637 40.6949653625489,-2.36067795753479 40.6965293884277,-2.3566780090332 40.6987228393555,-2.33193802833551 40.683536529541,-2.32477307319635 40.6771163940431,-2.32363295555109 40.673957824707,-2.32684206962585 40.6691856384278,-2.33545708656311 40.6725044250488,-2.33764100074768 40.6718139648437,-2.35111689567566 40.6631507873535,-2.35295200347895 40.658260345459,-2.35703802108759 40.6540603637696,-2.38627290725708 40.6364555358887,-2.40300893783564 40.6294784545898,-2.4157030582428 40.628604888916,-2.42652010917664 40.6318321228028,-2.43567299842823 40.6358871459962,-2.44156193733204 40.6456604003907,-2.44555091857904 40.648220062256))	0.0006	POINT(-2.409075673421195 40.682600487603125)
12613	POLYGON((16.8305320739747 41.0693435668945,16.827299118042 41.0705146789552,16.8173999786378 41.0650024414063,16.8078975677491 41.0577163696289,16.8046875000001 41.0539093017578,16.8108596801759 41.052131652832,16.8075313568116 41.0448875427247,16.8037338256837 41.0438919067384,16.8037338256837 41.0438919067384,16.8028392791748 41.0472946166993,16.7498016357423 41.0751495361329,16.7498016357423 41.0751495361329,16.7490558624268 41.080810546875,16.7560386657714 41.1011962890625,16.7524566650391 41.1079978942872,16.7507801055909 41.1129112243652,16.7507915496826 41.11580657959,16.7507915496826 41.11580657959,16.7579002380372 41.1151008605958,16.7621059417725 41.1125373840332,16.7684059143068 41.1125717163087,16.787488937378 41.1214256286622,16.7977352142334 41.1122665405273,16.8090686798096 41.0991744995118,16.8100318908691 41.0949745178223,16.8096961975098 41.0918273925781,16.8194103240966 41.077449798584,16.8249568939208 41.0744705200195,16.8305320739747 41.0693435668945))	0.0006	POINT(16.78831543241233 41.08375753675193)
73884	POLYGON((15.9118862152101 45.5772056579591,15.9305210113525 45.5745353698732,15.9441776275636 45.5738525390626,15.9613103866578 45.5676231384278,15.964228630066 45.5682601928712,15.9677352905274 45.5705833435059,15.9712181091309 45.5772056579591,15.9712181091309 45.5772056579591,15.9704561233521 45.5828056335449,15.9761972427369 45.5964736938477,15.9820308685303 45.6027069091797,15.9862451553345 45.6047515869142,15.9990653991699 45.6075096130372,16.0097885131835 45.6063041687012,16.0256290435792 45.6071815490723,16.0422439575195 45.6061592102052,16.046974182129 45.607982635498,16.0556735992432 45.6163635253907,16.0638656616212 45.620174407959,16.0778198242188 45.6243705749512,16.0845851898193 45.625114440918,16.0961971282959 45.6218528747558,16.0961971282959 45.6218528747558,16.1068935394287 45.6222343444824,16.1147232055664 45.6212921142579,16.1183967590333 45.621955871582,16.1269302368164 45.6281127929688,16.1341285705566 45.6374053955078,16.1370944976807 45.6399002075195,16.1470298767089 45.6430931091309,16.1534862518311 45.6436004638672,16.1652965545655 45.6414489746094,16.169319152832 45.6391983032227,16.1782741546631 45.6231575012208,16.1798038482666 45.6141357421874,16.1823635101318 45.6120719909669,16.1861743927003 45.6116065979004,16.1918487548829 45.6131553649903,16.1978588104248 45.6134757995605,16.2159690856934 45.6111068725586,16.2199840545654 45.6088752746583,16.2264118194581 45.6011581420898,16.2294406890869 45.5998992919922,16.232749938965 45.6005592346191,16.2393283843994 45.605525970459,16.2453441619873 45.6082191467286,16.2453441619873 45.6082191467286,16.2380924224854 45.6189002990723,16.2372817993165 45.6264533996582,16.2354507446289 45.6305465698242,16.2314586639405 45.6327857971191,16.2164382934571 45.6354179382324,16.2137756347657 45.6367263793946,16.210777282715 45.6417579650879,16.2100238800049 45.6484413146973,16.2060642242433 45.6551551818848,16.1928977966309 45.6652336120606,16.1860752105712 45.6689147949219,16.1806793212892 45.6777572631837,16.1772956848145 45.6909408569337,16.1622333526611 45.708610534668,16.1541175842285 45.7120628356935,16.1528167724611 45.7135887145997,16.1529712677003 45.7154197692872,16.1561164855958 45.720069885254,16.1574459075928 45.7278442382812,16.1683387756349 45.739631652832,16.1786460876466 45.741985321045,16.1871356964112 45.7422561645509,16.2086658477784 45.7378005981446,16.2086658477784 45.7378005981446,16.2103080749513 45.7468414306642,16.2079601287842 45.7499618530273,16.1958084106445 45.7515869140626,16.1896476745606 45.7551231384278,16.1854133605957 45.7560577392578,16.1700687408447 45.751808166504,16.1646900177003 45.7524070739747,16.1591510772706 45.7566261291504,16.1380805969238 45.7685585021973,16.1232204437257 45.7849273681641,16.1153888702393 45.7909278869629,16.1125564575196 45.7919845581055,16.1125564575196 45.7919845581055,16.0886211395264 45.7936935424805,16.0790920257569 45.7877845764161,16.0674152374269 45.7830467224121,16.0423831939698 45.7659225463868,16.033296585083 45.7644271850585,16.0235023498535 45.7653961181641,16.021936416626 45.7635917663574,16.0103187561035 45.7593688964844,16.0071487426758 45.7568473815919,16.0044288635254 45.7499084472657,16.003568649292 45.73787689209,16.0039768218994 45.7285118103027,16.0010643005372 45.7264060974121,15.9868078231812 45.7255592346193,15.9748630523682 45.7225189208984,15.9725208282471 45.720443725586,15.9658117294312 45.7101097106935,15.9536066055298 45.7012138366699,15.9519987106324 45.6968231201172,15.9534568786621 45.6861610412598,15.9527502059936 45.6798324584962,15.9503011703491 45.6747627258301,15.9460840225221 45.6701393127441,15.9434928894044 45.6638488769532,15.9355564117432 45.6564521789551,15.9344787597656 45.6526870727539,15.9341154098512 45.6428871154785,15.9330701828003 45.6401824951172,15.923487663269 45.6340751647949,15.9181213378906 45.6293411254884,15.904396057129 45.6226196289063,15.904396057129 45.6226196289063,15.9053287506103 45.6186523437501,15.9069652557373 45.6168479919435,15.9180030822754 45.6145324707031,15.9204540252687 45.6124420166016,15.9212360382081 45.6098937988282,15.9208698272706 45.5891990661622,15.9197063446046 45.5866088867189,15.9118862152101 45.5772056579591))	0.0006	POINT(16.080702487046192 45.66557411255876)
69999	MULTIPOLYGON(((9.80716228485102 53.9353828430177,9.80776119232183 53.9379653930665,9.80609989166265 53.9399871826172,9.80966758728039 53.9434661865236,9.81461811065685 53.9443092346192,9.81313323974615 53.9457664489746,9.80974769592291 53.9537315368652,9.81285762786865 53.9554901123048,9.81106853485113 53.9569206237794,9.81106853485113 53.9569206237794,9.82164669036871 53.9612350463868,9.82164669036871 53.9612350463868,9.82342529296881 53.960506439209,9.82310676574713 53.9594192504883,9.82310676574713 53.9594192504883,9.82830047607422 53.9574699401856,9.83412933349621 53.9587707519531,9.84698581695551 53.9536628723145,9.84929943084728 53.9537658691407,9.84934520721436 53.9517250061036,9.85146427154547 53.9515838623047,9.85146427154547 53.9515838623047,9.85634231567388 53.9471015930176,9.86020946502686 53.9471664428711,9.8664922714234 53.9433784484864,9.86645603179932 53.9416999816894,9.86777400970459 53.9400825500489,9.86777400970459 53.9400825500489,9.86178779602056 53.9382171630859,9.85340404510504 53.9389190673829,9.84567642211925 53.9374885559083,9.84311485290527 53.9347343444825,9.83804225921631 53.9319419860841,9.83385944366461 53.9327545166016,9.83385944366461 53.9327545166016,9.81666660308832 53.9331550598145,9.80716228485102 53.9353828430177)),((9.826003074646 53.9259567260743,9.82610225677502 53.9244766235352,9.82395839691168 53.9243278503419,9.82395839691168 53.9243278503419,9.81793117523205 53.9262886047363,9.81000232696539 53.9262809753418,9.80318546295166 53.9280395507814,9.80150318145746 53.9276008605956,9.80147361755382 53.9285163879396,9.80509185791021 53.9287528991699,9.80967140197754 53.9269981384278,9.8141822814942 53.9276084899902,9.826003074646 53.9259567260743)))	0.0006	POINT(9.833892832681261 53.94643866575683)
25935	POLYGON((1.85498213768 48.9876403808595,1.82833874225622 48.9814567565917,1.82833874225622 48.9814567565917,1.81761264801037 48.9754791259766,1.81761264801037 48.9754791259766,1.83657824993134 48.9777717590333,1.83990728855139 48.9614448547363,1.83471536636358 48.952392578125,1.83471536636358 48.952392578125,1.84971427917486 48.9354858398438,1.84971427917486 48.9354858398438,1.85223746299749 48.9343490600587,1.85223746299749 48.9343490600587,1.85678875446331 48.9434127807617,1.86992383003241 48.9471435546876,1.86992383003241 48.9471435546876,1.86429202556621 48.9530601501465,1.85498213768 48.9876403808595))	0.0006	POINT(1.844566653756595 48.95740845624142)
37169	POLYGON((6.86116886138927 47.5823249816895,6.85903596878057 47.5848808288575,6.85903596878057 47.5848808288575,6.84508800506592 47.5817108154298,6.83996057510387 47.5763473510743,6.82101106643677 47.5743293762208,6.82101106643677 47.5743293762208,6.8217244148255 47.573314666748,6.8217244148255 47.573314666748,6.83463001251221 47.5685119628907,6.84832811355602 47.5717811584473,6.854561328888 47.5666275024415,6.854561328888 47.5666275024415,6.86116886138927 47.5823249816895))	0.0006	POINT(6.8416800865760745 47.575306232159015)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point