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
18844	POLYGON((14.9215383529664 38.0630111694337,14.931791305542 38.0747222900392,14.931791305542 38.0747222900392,14.9383583068848 38.0723457336427,14.9552450180054 38.0706787109376,14.9608659744262 38.0709228515626,14.9729690551757 38.0741691589356,14.9763927459717 38.0730743408203,14.9822435379028 38.0655021667482,14.9862327575684 38.0638656616212,15.0013608932496 38.0669555664062,15.006820678711 38.0725708007813,15.0112771987916 38.0730743408203,15.0112771987916 38.0730743408203,15.0109834671022 38.0686073303223,15.0038452148439 38.0515365600586,14.9917583465577 38.0429267883301,14.9861717224122 38.0269317626953,14.9876432418824 38.0153808593751,14.9770851135254 38.0063896179199,14.9626646041871 37.9872703552247,14.9626646041871 37.9872703552247,14.955065727234 37.9911422729493,14.9440898895265 38.0008201599122,14.9430837631226 38.0079536437988,14.9468612670898 38.0136604309082,14.9438028335571 38.022403717041,14.9398212432861 38.0297470092773,14.9321393966675 38.0318603515625,14.930703163147 38.0332221984864,14.927984237671 38.0398635864257,14.928949356079 38.0419960021974,14.9246006011963 38.0609207153321,14.9215383529664 38.0630111694337))	0.0006	POINT(14.963275215842547 38.04389676180758)
22343	POLYGON((-0.174250617623272 44.9313545227052,-0.207608014345169 44.9412460327148,-0.207608014345169 44.9412460327148,-0.2186101675033 44.9463615417481,-0.2186101675033 44.9463615417481,-0.224472433328629 44.9408493041992,-0.225498422980252 44.9342041015625,-0.21251106262207 44.9243011474609,-0.211424544453564 44.9175109863282,-0.202620625495911 44.915023803711,-0.202620625495911 44.915023803711,-0.195212692022324 44.9236717224122,-0.174250617623272 44.9313545227052))	0.0006	POINT(-0.20842061564323924 44.93142954508466)
18873	POLYGON((14.0787706375122 37.6453247070313,14.081482887268 37.6506118774414,14.0892543792725 37.6483268737794,14.1017827987671 37.6526679992676,14.1082057952881 37.6568145751954,14.0979862213135 37.6610298156738,14.0929050445558 37.6602668762207,14.0661611557008 37.6639366149903,14.0569086074829 37.6729164123536,14.0569086074829 37.6729164123536,14.0633001327516 37.676010131836,14.0755224227905 37.6779251098633,14.082007408142 37.6769790649415,14.0863943099975 37.6778259277345,14.0885143280029 37.6809577941896,14.0885143280029 37.6809577941896,14.1014471054078 37.6843261718749,14.1080808639526 37.6909217834473,14.1050996780396 37.6926994323731,14.1019630432128 37.6969757080078,14.0979661941529 37.7058143615723,14.0971908569337 37.7099075317383,14.1045017242432 37.7235641479493,14.113245010376 37.7306785583497,14.120855331421 37.7281227111816,14.120192527771 37.7246742248535,14.1220836639404 37.7230949401857,14.1259832382203 37.7224273681642,14.1302251815797 37.7235946655275,14.1309490203858 37.724681854248,14.1309490203858 37.724681854248,14.1343898773194 37.7235565185547,14.1482238769531 37.7351188659669,14.1563415527344 37.7378005981445,14.1563415527344 37.7378005981445,14.1653375625611 37.7361068725587,14.1653375625611 37.7361068725587,14.1710319519043 37.7333412170411,14.1697483062745 37.7274322509765,14.1699380874635 37.7225494384766,14.1711416244507 37.7132186889649,14.1723699569703 37.7120361328125,14.1644763946533 37.7037544250488,14.1594457626342 37.7000579833985,14.1594457626342 37.7000579833985,14.1556310653686 37.7014083862305,14.1256675720215 37.6989288330079,14.1233854293824 37.6973724365235,14.122320175171 37.6924324035644,14.125602722168 37.6881332397462,14.1522817611695 37.6677932739258,14.1524639129639 37.6627235412598,14.1459894180298 37.6579627990723,14.1453800201417 37.6537132263183,14.1474466323854 37.6444358825684,14.1458005905153 37.6408462524413,14.1400623321533 37.6351623535156,14.1546726226807 37.6288757324219,14.1546726226807 37.6288757324219,14.1470651626588 37.6213607788087,14.1357288360596 37.6178245544435,14.1357288360596 37.6178245544435,14.1325588226318 37.612762451172,14.1247987747193 37.6127853393556,14.1220502853394 37.6248435974122,14.1001672744752 37.6305923461914,14.0923137664795 37.6361923217774,14.0875415802003 37.6360054016113,14.0875415802003 37.6360054016113,14.0787706375122 37.6453247070313))	0.0006	POINT(14.122402799302288 37.68152800850248)
36251	POLYGON((6.37408685684204 47.5759696960449,6.37375831604004 47.5716094970704,6.37375831604004 47.5716094970704,6.38100290298462 47.5672302246095,6.39618492126465 47.5472297668458,6.39618492126465 47.5472297668458,6.40741491317755 47.5428276062012,6.40741491317755 47.5428276062012,6.4150013923645 47.5470199584962,6.4200763702392 47.5564498901367,6.40897130966198 47.5674324035645,6.39585208892822 47.5708885192872,6.39711046218872 47.5741310119629,6.39711046218872 47.5741310119629,6.38298559188848 47.5728912353516,6.37408685684204 47.5759696960449))	0.0006	POINT(6.395127582550064 47.56196517944341)
49192	POLYGON((-0.728071630001068 46.4613990783692,-0.725854516029358 46.4680900573732,-0.710517466068268 46.4771804809571,-0.710517466068268 46.4771804809571,-0.70536345243454 46.4858207702637,-0.696462035179138 46.4856109619141,-0.696462035179138 46.4856109619141,-0.691378951072636 46.4726066589356,-0.673804223537388 46.4669914245607,-0.669728219509068 46.4607009887696,-0.669728219509068 46.4607009887696,-0.671362102031594 46.4574584960938,-0.685581088066044 46.4549713134766,-0.691110193729401 46.4493675231934,-0.68820458650589 46.4293518066406,-0.702142298221588 46.4299430847169,-0.711263477802277 46.4218254089355,-0.711263477802277 46.4218254089355,-0.716758549213409 46.4181022644044,-0.728481411933899 46.4212265014649,-0.728481411933899 46.4212265014649,-0.729464709758645 46.4375190734864,-0.736030459403935 46.4420013427735,-0.736030459403935 46.4420013427735,-0.72798037528986 46.4455642700195,-0.728071630001068 46.4613990783692))	0.0006	POINT(-0.7056817126273836 46.45177108764654)
29223	POLYGON((4.86248636245733 46.6528511047364,4.8755350112915 46.6565017700195,4.87993383407593 46.6622772216797,4.87993383407593 46.6622772216797,4.88263416290278 46.6650772094726,4.8723087310791 46.679801940918,4.87387228012079 46.6864433288575,4.87387228012079 46.6864433288575,4.83912372589123 46.6775398254396,4.83912372589123 46.6775398254396,4.84713077545166 46.6613311767578,4.86248636245733 46.6528511047364))	0.0006	POINT(4.865995883941661 46.66982581398709)
29434	POLYGON((5.15960979461676 46.5784606933595,5.15612125396729 46.5725097656251,5.13779067993175 46.5680618286133,5.13779067993175 46.5680618286133,5.11975717544561 46.573844909668,5.10242700576782 46.5691833496094,5.0723695755006 46.5790100097657,5.0723695755006 46.5790100097657,5.07889795303356 46.5823516845703,5.07964420318609 46.5875244140626,5.07964420318609 46.5875244140626,5.09845447540289 46.5874252319337,5.09845447540289 46.5874252319337,5.12908411026012 46.5965805053712,5.13853693008429 46.5950355529785,5.14351463317877 46.6006622314453,5.15799474716187 46.6013183593751,5.15799474716187 46.6013183593751,5.16287231445324 46.595802307129,5.16272735595703 46.5891914367676,5.15619659423839 46.5846405029297,5.15960979461676 46.5784606933595))	0.0006	POINT(5.123916784922346 46.584997267950214)
1389714	POLYGON((0.111325003206673 40.796688079834,0.108979001641217 40.7944259643556,0.09389399737114 40.7900886535645,0.076109997928143 40.7988853454591,0.071548998355979 40.7935371398927,0.05621499940753 40.7860946655273,0.040931001305694 40.7853622436523,0.036364000290632 40.7831420898439,0.033900000154972 40.7852592468262,0.034301001578683 40.7911758422853,0.032915998250303 40.790958404541,0.030822999775523 40.7999382019043,0.032869998365697 40.8055725097656,0.035790000110978 40.8090248107911,0.038577001541853 40.8098220825196,0.037744998931942 40.8154830932617,0.039214998483715 40.818084716797,0.029984999448061 40.8239364624024,0.034967001527605 40.8320465087891,0.041409999132156 40.8342208862305,0.040690001100302 40.8415145874025,0.051610998809338 40.8433074951172,0.057227000594196 40.8460235595704,0.05853499844676 40.8512840270997,0.070511996746063 40.8560638427734,0.073615998029766 40.8611221313477,0.072743996977806 40.8653526306152,0.075684003531933 40.8645172119141,0.077399998903331 40.8605918884277,0.08277399837965 40.8562660217286,0.082528002560252 40.8527526855469,0.08774700015789 40.8507118225098,0.087273001670837 40.8471488952638,0.089776001870632 40.8463897705078,0.092283003032321 40.8429183959961,0.094218000769672 40.8383331298828,0.091023996472359 40.8337173461915,0.09454300254589 40.8277854919434,0.102542996406498 40.8249168395996,0.123741000890732 40.8013877868653,0.111325003206673 40.796688079834))	0.0006	POINT(0.06560837486761809 40.82389631271366)
19289	POLYGON((11.0600728988647 43.1848487854004,11.057596206665 43.1898384094238,11.0602197647096 43.1990928649903,11.0646476745606 43.2055587768555,11.0710954666138 43.2080345153809,11.084114074707 43.2108039855957,11.0964975357055 43.208309173584,11.1044998168945 43.208335876465,11.1093139648438 43.2097930908203,11.1188850402831 43.2334327697755,11.1177005767822 43.2394256591798,11.1177005767822 43.2394256591798,11.1169853210449 43.2429237365723,11.1084938049317 43.247787475586,11.1055774688721 43.2517662048341,11.1073923110962 43.2568855285646,11.1098909378053 43.2575492858887,11.1103105545043 43.2593803405763,11.1051416397095 43.2656059265137,11.0882253646852 43.2691764831543,11.0866727828979 43.2727966308594,11.0831546783447 43.2755088806153,11.076024055481 43.2788887023926,11.0579214096069 43.282554626465,11.0489130020142 43.2825736999512,11.0315914154053 43.2931098937989,11.0247163772583 43.2917480468749,11.0224437713623 43.2905082702636,11.0213832855225 43.2886085510254,11.0024738311767 43.2840538024902,10.9857540130616 43.2864532470703,10.9857540130616 43.2864532470703,10.9844551086426 43.2832870483399,10.9863061904907 43.2791862487794,10.9985580444337 43.2660789489747,10.995083808899 43.2589263916017,10.9923667907716 43.2481422424318,10.9924821853638 43.24564743042,10.9949998855591 43.2423896789552,10.9975328445435 43.2411270141602,10.9941148757936 43.2352828979492,10.9899225234985 43.2320938110352,10.9579858779908 43.2372932434081,10.9440212249755 43.2473983764649,10.9440212249755 43.2473983764649,10.9329795837402 43.2371482849121,10.9329795837402 43.2371482849121,10.928192138672 43.2320976257325,10.9397106170655 43.2279777526855,10.9431266784669 43.2168998718262,10.9423913955688 43.2049827575684,10.9403877258301 43.2011871337891,10.9329423904418 43.1949577331543,10.9247150421143 43.192024230957,10.9118814468384 43.1814193725587,10.9095659255982 43.1734695434571,10.909294128418 43.1655311584474,10.9125165939331 43.1636009216309,10.9125165939331 43.1636009216309,10.9434061050416 43.1613273620607,10.961133003235 43.16756439209,10.9699239730836 43.1716613769532,10.9754467010499 43.1766090393068,10.9874153137208 43.179168701172,11.0022382736207 43.1802062988281,11.0097694396972 43.1794967651368,11.0195608139039 43.1865463256837,11.0338582992555 43.1850204467774,11.047113418579 43.1814346313477,11.0600728988647 43.1848487854004))	0.0006	POINT(11.015015643575937 43.2293705041858)
33403	POLYGON((4.36243438720703 49.5688667297364,4.37666845321667 49.5709075927736,4.38835382461548 49.581398010254,4.38835382461548 49.581398010254,4.39433908462524 49.5890235900879,4.39433908462524 49.5890235900879,4.38443756103521 49.6119918823242,4.37505483627331 49.6195526123048,4.37505483627331 49.6195526123048,4.36543273925776 49.6187438964845,4.35844135284435 49.6143531799316,4.35844135284435 49.6143531799316,4.34678602218639 49.595573425293,4.34151935577387 49.5956230163574,4.33496713638317 49.5866622924805,4.32004308700573 49.5772438049317,4.32004308700573 49.5772438049317,4.32007408142096 49.5746841430665,4.32007408142096 49.5746841430665,4.32129478454601 49.5716209411621,4.33934593200689 49.5690345764161,4.33934593200689 49.5690345764161,4.34524726867687 49.5642967224122,4.36243438720703 49.5688667297364))	0.0006	POINT(4.355221395907257 49.58847244926126)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point