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
36686	POLYGON((5.57664680480951 46.9648513793946,5.57635116577148 46.9713439941407,5.56531429290783 46.9816970825195,5.570556640625 46.9873008728028,5.57959127426142 46.9895935058594,5.58288764953625 46.99520111084,5.58288764953625 46.99520111084,5.58995199203491 46.9956283569335,5.58995199203491 46.9956283569335,5.59741735458385 46.9928932189941,5.59741735458385 46.9928932189941,5.58980751037592 46.9783477783204,5.57664680480951 46.9648513793946))	0.0006	POINT(5.583231806755099 46.98671499888105)
1397744	POLYGON((-3.5371520519256 39.8690032958984,-3.54419898986811 39.872817993164,-3.54476404190063 39.8704910278321,-3.54697990417475 39.8724250793458,-3.54871010780323 39.8711051940919,-3.55042409896851 39.8718910217286,-3.55205798149109 39.8699455261231,-3.55763888359058 39.8704223632813,-3.55673003196711 39.8723907470704,-3.55804705619812 39.8761787414551,-3.56005311012268 39.8769073486329,-3.56109905242914 39.8848762512208,-3.56710910797119 39.9001808166505,-3.56914710998535 39.9003143310547,-3.56007599830622 39.9070358276368,-3.54678392410278 39.9098167419434,-3.54110908508301 39.9124336242676,-3.54056906700129 39.9107398986816,-3.5309100151062 39.9145317077637,-3.52869391441345 39.9126167297363,-3.52569293975819 39.9131889343262,-3.52431797981262 39.9107780456544,-3.51815605163569 39.9096336364747,-3.51557588577259 39.9074821472168,-3.51105403900135 39.9081802368165,-3.50162291526789 39.901626586914,-3.50625395774841 39.8997230529786,-3.50565195083618 39.8958129882813,-3.50898694992065 39.8942947387696,-3.50892496109003 39.8893775939941,-3.52206897735584 39.8827133178712,-3.52255702018732 39.8776054382325,-3.52885603904724 39.8726005554199,-3.53669905662531 39.8706550598145,-3.5371520519256 39.8690032958984))	0.0006	POINT(-3.536431536954952 39.89058225295126)
67418	POLYGON((9.51485538482672 48.6423072814943,9.51410102844244 48.643123626709,9.50695419311535 48.6429481506348,9.50778102874767 48.6483345031739,9.51222991943354 48.6491394042969,9.51272773742681 48.6500244140626,9.50788879394531 48.6537055969239,9.51348781585705 48.656047821045,9.52378940582281 48.6574783325196,9.52378940582281 48.6574783325196,9.52604293823237 48.6574630737306,9.53190231323248 48.65975189209,9.54094600677502 48.6602973937988,9.54094600677502 48.6602973937988,9.54423046112066 48.6575736999513,9.54292297363276 48.6564407348633,9.54921913146984 48.655143737793,9.55485725402832 48.6556167602539,9.55485725402832 48.6556167602539,9.55514335632324 48.6513633728027,9.55419921875 48.6503295898438,9.55488872528076 48.6484031677247,9.55243682861339 48.6481590270997,9.5524635314942 48.6467819213868,9.55078315734875 48.6466598510742,9.55078315734875 48.6466598510742,9.54536342620861 48.6454887390137,9.54474258422846 48.6439361572267,9.54273700714111 48.6451873779297,9.54183673858648 48.6447296142578,9.54121780395513 48.6423873901368,9.53903198242193 48.6417274475099,9.53946399688721 48.6404914855957,9.52598762512218 48.6391944885254,9.51762676239008 48.6422386169434,9.51597690582281 48.64164352417,9.51485538482672 48.6423072814943))	0.0006	POINT(9.534672551684956 48.649560292561894)
20064	POLYGON((11.8207006454468 45.7249603271484,11.8208847045898 45.7216300964355,11.8250246047974 45.7075386047363,11.8163843154907 45.6963996887208,11.8169517517091 45.6936035156251,11.8193492889404 45.6898765563965,11.8226814270019 45.6880722045899,11.8226814270019 45.6880722045899,11.8238992691041 45.6872863769532,11.8238992691041 45.6872863769532,11.8419666290283 45.6780090332032,11.8402576446533 45.6838569641113,11.8402576446533 45.6838569641113,11.8361892700195 45.7003517150879,11.8368692398072 45.7011756896974,11.8815326690675 45.70845413208,11.8815326690675 45.70845413208,11.8773679733278 45.731414794922,11.8774929046631 45.7335968017578,11.8793725967408 45.7361602783204,11.8779859542846 45.7451858520508,11.8767166137696 45.7460021972657,11.8590593338013 45.7448616027833,11.8588953018188 45.7486801147462,11.8588953018188 45.7486801147462,11.8567934036255 45.7463035583497,11.8531942367554 45.7445487976074,11.8321714401246 45.7414093017578,11.8321714401246 45.7414093017578,11.8150720596314 45.744255065918,11.8150720596314 45.744255065918,11.8207006454468 45.7249603271484))	0.0006	POINT(11.843268486761307 45.71760153001357)
1402152	POLYGON((-4.55682802200317 41.3879432678223,-4.56218194961536 41.3868255615236,-4.56529521942139 41.3839569091798,-4.56490278244019 41.378547668457,-4.57999277114862 41.3849449157715,-4.5886697769165 41.3866615295411,-4.59151411056519 41.3889923095703,-4.61018514633179 41.3899917602539,-4.61056613922113 41.3932914733887,-4.6153678894043 41.3945045471192,-4.61889410018915 41.3982849121095,-4.62101602554316 41.3979644775391,-4.61669683456415 41.4013023376465,-4.61543607711792 41.4088325500489,-4.60688686370844 41.4163932800293,-4.6075820922851 41.420753479004,-4.60130786895746 41.4220542907716,-4.6025857925415 41.4258651733399,-4.59960508346558 41.4248809814453,-4.59811687469477 41.4271507263184,-4.59210920333862 41.4276084899902,-4.58915281295776 41.4270706176759,-4.58840990066528 41.4251060485841,-4.58397483825678 41.4262504577638,-4.57709693908691 41.4254150390625,-4.57421398162842 41.4234733581544,-4.56843614578247 41.4239959716797,-4.56312322616577 41.4195556640625,-4.55479288101196 41.4074363708496,-4.5580358505249 41.4000167846681,-4.55682802200317 41.3879432678223))	0.0006	POINT(-4.589432573318459 41.40750236511236)
42741	POLYGON((6.53689956665039 49.3966903686524,6.54052829742437 49.4011459350587,6.54052829742437 49.4011459350587,6.54912471771252 49.4000473022461,6.55205249786383 49.3945274353028,6.55205249786383 49.3945274353028,6.55475807189941 49.3815994262696,6.54491472244263 49.3707313537599,6.55438184738171 49.3703536987305,6.55660438537609 49.3674163818359,6.55660438537609 49.3674163818359,6.52896022796631 49.3574676513673,6.51398897171026 49.3477973937989,6.51398897171026 49.3477973937989,6.50659179687511 49.34676361084,6.50659179687511 49.34676361084,6.51727199554455 49.3583755493165,6.5160875320434 49.3676681518555,6.5160875320434 49.3676681518555,6.52114391326916 49.3678703308107,6.53068828582775 49.3794784545898,6.52984237670898 49.3890571594238,6.53689956665039 49.3966903686524))	0.0006	POINT(6.533622394908615 49.37374132329773)
70509	POLYGON((10.8201246261598 50.6604843139649,10.8169021606445 50.6612777709962,10.8169021606445 50.6612777709962,10.8216781616211 50.6640243530273,10.8203248977662 50.6670532226564,10.8159122467042 50.6697654724122,10.8159122467042 50.6697654724122,10.81476688385 50.6721343994141,10.8098211288452 50.6757278442383,10.8098211288452 50.6757278442383,10.8201742172242 50.6780586242676,10.8234004974366 50.6777267456056,10.8280067443847 50.6803588867188,10.8288011550903 50.6824798583986,10.8231506347656 50.6865806579591,10.8160037994385 50.695858001709,10.8181018829346 50.702247619629,10.8271579742433 50.7007217407227,10.8189840316772 50.7049636840821,10.8207378387452 50.7064628601074,10.8242721557618 50.7053451538087,10.8265714645386 50.7059326171876,10.8298568725586 50.7035942077638,10.8302040100098 50.7005958557129,10.8335771560669 50.7008934020997,10.8344345092773 50.7018241882325,10.8383026123047 50.6979370117189,10.8384046554566 50.7003288269044,10.8437290191651 50.7037963867188,10.8444232940674 50.7076721191407,10.8470315933228 50.7077522277833,10.8515501022339 50.713191986084,10.8593645095825 50.7121887207032,10.862545967102 50.7130851745607,10.8641223907471 50.7152862548829,10.8641223907471 50.7152862548829,10.8661556243898 50.7143363952637,10.8638410568237 50.711940765381,10.8620939254762 50.7114677429199,10.8633565902709 50.70613861084,10.8687467575074 50.7104835510254,10.872597694397 50.7117767333984,10.8728466033937 50.7109680175781,10.8694334030151 50.7077369689942,10.8708019256592 50.7051239013672,10.8708019256592 50.7051239013672,10.866967201233 50.7039756774903,10.8657083511352 50.7024421691896,10.8661727905274 50.7002372741699,10.8672437667848 50.6995658874513,10.8642530441284 50.6957168579102,10.8632717132569 50.6915702819825,10.8642597198486 50.6893539428712,10.8589496612549 50.6876869201661,10.8519954681397 50.6877632141114,10.8480510711671 50.6867866516114,10.8400878906251 50.6824378967285,10.8373126983642 50.6785583496094,10.8304300308228 50.676498413086,10.8287420272828 50.6720314025879,10.830798149109 50.6704978942872,10.8294267654419 50.6688537597656,10.8257732391357 50.6687126159668,10.8252296447754 50.6658248901368,10.8260412216187 50.6644744873047,10.8242864608765 50.6646385192872,10.822696685791 50.661907196045,10.8201246261598 50.6604843139649))	0.0006	POINT(10.84026224221759 50.69122445405423)
42120	POLYGON((6.41106891632086 49.3163261413575,6.41486883163464 49.3248634338379,6.42349147796631 49.3272285461427,6.42349147796631 49.3272285461427,6.43690299987804 49.3326530456543,6.44175577163702 49.3313064575196,6.44175577163702 49.3313064575196,6.45015525817871 49.3189849853516,6.45015525817871 49.3189849853516,6.42858886718761 49.3119697570802,6.42632627487183 49.3058700561523,6.42632627487183 49.3058700561523,6.42140865325928 49.3059997558593,6.41106891632086 49.3163261413575))	0.0006	POINT(6.4304842948913965 49.31989170954782)
38895	POLYGON((2.14085006713867 43.119140625,2.13212537765509 43.1195907592774,2.12539625167847 43.1236648559571,2.10822153091436 43.121768951416,2.10822153091436 43.121768951416,2.11064100265514 43.1321258544922,2.11064100265514 43.1321258544922,2.11899971961981 43.1300354003906,2.13083958625799 43.1332435607911,2.14351987838756 43.130386352539,2.14351987838756 43.130386352539,2.14535355567932 43.1243209838867,2.14085006713867 43.119140625))	0.0006	POINT(2.1265274484952896 43.126546541849784)
1402164	MULTIPOLYGON(((-4.06753015518188 41.5620498657227,-4.07684183120722 41.5553703308107,-4.08290719985962 41.5544052124023,-4.08528184890741 41.5559310913086,-4.09657716751099 41.5501747131348,-4.10191106796259 41.5499801635742,-4.10486698150635 41.5538787841797,-4.10838794708241 41.5530433654786,-4.11522483825684 41.5545082092286,-4.11954021453857 41.5592956542968,-4.12280988693237 41.5604858398438,-4.12785816192627 41.559799194336,-4.13104486465454 41.5616683959962,-4.13352012634277 41.5687561035157,-4.13709783554071 41.570297241211,-4.15094804763794 41.568214416504,-4.15292692184448 41.5748977661134,-4.15865421295166 41.5724639892578,-4.15345287322987 41.5795135498046,-4.1579270362854 41.5855026245118,-4.15866994857788 41.5908355712891,-4.15121078491211 41.5957298278809,-4.15848588943481 41.5959358215333,-4.16913795471186 41.5991973876953,-4.18285894393915 41.5994453430175,-4.19028615951532 41.5961494445802,-4.20173692703241 41.5963287353516,-4.21777009963989 41.5934066772462,-4.22420883178705 41.5937767028809,-4.22189617156977 41.5977096557618,-4.21718502044678 41.5999298095703,-4.21784305572504 41.6068344116211,-4.20137882232666 41.6172561645509,-4.19901514053339 41.6237182617189,-4.20430088043207 41.6290588378907,-4.19968795776367 41.6302642822266,-4.18110418319702 41.6229057312011,-4.17795610427856 41.6234436035156,-4.16891717910767 41.6281280517579,-4.16817378997803 41.6368255615235,-4.16466712951654 41.6380920410156,-4.15834379196167 41.6371002197267,-4.15057516098022 41.6423187255859,-4.14840698242182 41.6413612365724,-4.1456561088562 41.6337661743165,-4.13949823379511 41.6317939758301,-4.13531398773188 41.6272926330566,-4.13113403320307 41.6298332214355,-4.12909412384033 41.6292572021486,-4.12776279449463 41.6307563781738,-4.10987615585327 41.6223564147949,-4.10183811187744 41.6204872131348,-4.1013679504394 41.6168975830078,-4.09543800353998 41.6132621765137,-4.08836317062378 41.6151504516603,-4.08394384384155 41.6128578186035,-4.07590818405146 41.6203269958497,-4.06913185119629 41.6229515075684,-4.06721115112305 41.6221733093262,-4.0637531280517 41.6119117736816,-4.05506086349487 41.6072425842286,-4.04497289657587 41.6053619384766,-4.0417799949646 41.6023292541504,-4.04194402694702 41.5967712402344,-4.0449800491333 41.5939140319824,-4.04858112335199 41.5932273864747,-4.05189514160151 41.5837211608887,-4.05792808532709 41.5777282714844,-4.06114578247065 41.5765571594238,-4.05830383300781 41.574447631836,-4.06041908264154 41.5710067749024,-4.06694221496582 41.5671615600586,-4.06753015518188 41.5620498657227)),((-4.13299083709717 41.5617904663086,-4.1356959342956 41.5601272583008,-4.13674688339233 41.5619468688965,-4.13299083709717 41.5617904663086)))	0.0006	POINT(-4.126647481268264 41.59715948568348)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point