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.
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 | geometryDieser 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:
| beliebig | Die simplifizierten Geodaten. |
epsilon | float(5,4) | beliebig | Die Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone. |
mittelpunkt | pointDieser 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:
| beliebig | Der geometrische Mittelpunkt des vereinfachten Polygons. |
Ausschnitt
id_ort | geodaten | epsilon | mittelpunkt |
---|---|---|---|
1405398 | POLYGON((-2.28374099731445 42.4736595153809,-2.28796195983887 42.467357635498,-2.29683303833002 42.4681434631348,-2.29686903953552 42.4649085998536,-2.29316592216492 42.4599952697755,-2.2973780632019 42.4574813842773,-2.30874991416931 42.4618568420411,-2.31678700447077 42.4621124267578,-2.32579588890076 42.4681510925294,-2.33192706108093 42.468074798584,-2.33635807037348 42.4642143249513,-2.33135890960682 42.4573783874511,-2.3317830562591 42.4540023803712,-2.34578609466553 42.4513664245606,-2.34764409065247 42.4526748657228,-2.35219311714172 42.4656219482423,-2.35806608200068 42.4670333862305,-2.36304593086243 42.4617195129396,-2.3709499835968 42.4643783569336,-2.37136101722712 42.4706535339356,-2.37667107582092 42.4736480712892,-2.38403892517084 42.4704437255859,-2.3900470733642 42.470630645752,-2.39578390121454 42.473472595215,-2.4001190662384 42.4717826843262,-2.41556406021118 42.4905662536621,-2.42065095901484 42.4892959594728,-2.42326807975763 42.4996376037598,-2.42370104789728 42.5096282958985,-2.42201399803162 42.5117187500001,-2.40925288200373 42.5160217285156,-2.39215302467346 42.5169486999512,-2.39324903488153 42.5231132507325,-2.39819288253778 42.5293807983398,-2.3983519077301 42.5341835021974,-2.40100288391113 42.538501739502,-2.40014410018915 42.5431632995607,-2.39597702026367 42.5468482971191,-2.38990402221674 42.5490608215333,-2.39051008224487 42.5607337951661,-2.39304208755487 42.5645942687988,-2.39814710617065 42.5861778259277,-2.39375495910645 42.590316772461,-2.38910794258118 42.590618133545,-2.38553905487061 42.5843086242676,-2.37748003005981 42.5454788208008,-2.34709906578064 42.5447349548339,-2.34277296066284 42.5496444702148,-2.32729101181025 42.5545082092285,-2.32944011688227 42.5470848083496,-2.32366490364069 42.5383300781251,-2.31869411468506 42.5350685119629,-2.30962610244751 42.5194168090821,-2.30768108367914 42.4924964904785,-2.30876588821405 42.4856491088868,-2.30064988136286 42.4726600646973,-2.28374099731445 42.4736595153809)) | 0.0006 | POINT(-2.359305492469217 42.50322593961446) |
13632 | POLYGON((14.2851619720459 41.4730911254882,14.3055944442749 41.4674224853516,14.3280410766603 41.4544258117676,14.3430576324463 41.4550704956055,14.3600282669069 41.449535369873,14.3600282669069 41.449535369873,14.3503808975221 41.4361801147462,14.3421649932862 41.4272384643555,14.3166646957397 41.4316177368165,14.3097572326661 41.4319763183594,14.3097572326661 41.4319763183594,14.303069114685 41.4381866455078,14.2905769348146 41.4388961791993,14.2745885849 41.4376106262208,14.2506885528564 41.4383544921876,14.2412633895875 41.4398536682129,14.2368631362916 41.4415435791016,14.2358732223511 41.4443283081055,14.2358732223511 41.4443283081055,14.2279262542725 41.4502296447754,14.2279262542725 41.4502296447754,14.2384500503541 41.4574317932129,14.271216392517 41.4737968444824,14.278642654419 41.4756431579591,14.2827758789063 41.4713211059571,14.2845506668091 41.4709320068361,14.2851619720459 41.4730911254882)) | 0.0006 | POINT(14.288112346942661 41.44925983135521) |
45586 | POLYGON((1.12161755561829 44.48539352417,1.11720013618464 44.4756469726562,1.09832608699799 44.4725685119629,1.09423887729645 44.4744338989259,1.09423887729645 44.4744338989259,1.09189474582672 44.4678726196289,1.08317875862133 44.4649581909179,1.08409249782562 44.4580307006837,1.08409249782562 44.4580307006837,1.1030982732774 44.4476547241211,1.10878372192383 44.438144683838,1.11737346649176 44.4357070922852,1.11737346649176 44.4357070922852,1.13010907173162 44.4363174438478,1.14016723632812 44.4419288635255,1.14016723632812 44.4419288635255,1.14092814922333 44.4516639709474,1.12828218936926 44.4558258056641,1.12699413299572 44.4590377807617,1.12788426876062 44.4689865112305,1.13631713390356 44.4767646789551,1.13631713390356 44.4767646789551,1.12161755561829 44.48539352417)) | 0.0006 | POINT(1.1146670688282623 44.458990964022604) |
71325 | POLYGON((14.440019607544 46.8914947509766,14.4090127944946 46.9059867858887,14.4041929244996 46.9092445373536,14.4033727645875 46.9119987487793,14.404013633728 46.915325164795,14.4103937149048 46.9322433471681,14.4103937149048 46.9322433471681,14.4479541778564 46.9418640136719,14.4535036087037 46.9415817260743,14.4668674468994 46.9387474060059,14.4668674468994 46.9387474060059,14.4570465087891 46.9281501770021,14.4635486602783 46.9106254577638,14.4635486602783 46.9106254577638,14.4391946792603 46.8990516662598,14.4383001327514 46.8970603942872,14.440019607544 46.8914947509766)) | 0.0006 | POINT(14.436139404773725 46.91906189918525) |
1407212 | POLYGON((-5.84154510498041 39.210678100586,-5.83594083786011 39.2388305664063,-5.83857822418213 39.2390174865723,-5.84771680831909 39.2576065063477,-5.84262084960926 39.2628288269044,-5.84236621856689 39.2668075561525,-5.83877420425415 39.2700157165527,-5.83485984802246 39.2787284851075,-5.83588600158686 39.2823104858398,-5.8344001770019 39.287712097168,-5.81863117218018 39.299789428711,-5.81307411193842 39.3086433410645,-5.81240177154535 39.3190841674806,-5.80763387680048 39.323127746582,-5.80066680908203 39.3246841430664,-5.79142189025873 39.3130073547364,-5.78931617736816 39.3090209960938,-5.79041004180908 39.3044357299804,-5.78315782546997 39.3010940551758,-5.78557920455921 39.2969284057618,-5.78344106674194 39.2935905456544,-5.78095006942743 39.2927513122559,-5.78020191192627 39.2847328186035,-5.77543210983276 39.2819366455078,-5.77576684951782 39.2798385620117,-5.77133417129511 39.2779731750489,-5.77103614807123 39.2739181518554,-5.7663750648498 39.2703704833985,-5.7764458656311 39.2539138793945,-5.76374912261957 39.2336387634277,-5.77036523818964 39.2280616760254,-5.76825714111328 39.2213096618653,-5.78180408477783 39.2203178405762,-5.81570005416864 39.1930007934571,-5.83396911621094 39.2077102661134,-5.84154510498041 39.210678100586)) | 0.0006 | POINT(-5.8028516905648075 39.27164045061387) |
40305 | POLYGON((1.69227313995361 44.9925765991211,1.70337665081036 44.9865760803223,1.70337665081036 44.9865760803223,1.71708858013159 44.9951095581055,1.72629022598272 44.9961967468263,1.72629022598272 44.9961967468263,1.72283542156219 45.0052223205566,1.73901760578167 45.0098114013672,1.73610115051275 45.0158576965333,1.73610115051275 45.0158576965333,1.72473895549786 45.0230865478516,1.72473895549786 45.0230865478516,1.71521902084356 45.0218391418457,1.69217574596405 45.0255622863771,1.69217574596405 45.0255622863771,1.68889975547785 45.0233879089355,1.68935155868536 45.0078887939454,1.68437135219585 45.0026588439942,1.68437135219585 45.0026588439942,1.69227313995361 44.9925765991211)) | 0.0006 | POINT(1.7104628023348951 45.008195375141405) |
18121 | POLYGON((8.31863021850592 45.7932701110841,8.31832408905029 45.7933578491212,8.31832408905029 45.7933578491212,8.32339191436773 45.81005859375,8.32339191436773 45.81005859375,8.36123561859137 45.8056869506836,8.37093639373774 45.8087882995605,8.37093639373774 45.8087882995605,8.37627506256104 45.8067092895508,8.37627506256104 45.8067092895508,8.37829113006597 45.7991409301757,8.37562465667725 45.7910652160645,8.37585353851318 45.7851257324219,8.37585353851318 45.7851257324219,8.36913013458252 45.784164428711,8.3618602752685 45.7777900695801,8.35695552825928 45.7759590148927,8.35695552825928 45.7759590148927,8.35094738006592 45.7733116149902,8.35094738006592 45.7733116149902,8.34115505218506 45.776496887207,8.34115505218506 45.776496887207,8.33735179901134 45.7771186828613,8.33589172363287 45.7747268676757,8.32809352874767 45.7713737487794,8.3214960098266 45.7698135375977,8.31929683685314 45.7678527832032,8.31929683685314 45.7678527832032,8.31794738769537 45.7699089050293,8.31808185577398 45.784019470215,8.32229614257812 45.791473388672,8.32130432128906 45.7928199768066,8.31863021850592 45.7932701110841)) | 0.0006 | POINT(8.34479707479479 45.78680288791659) |
19979 | POLYGON((12.1374959945679 45.057186126709,12.1239681243896 45.0592193603516,12.1110649108888 45.0650825500489,12.0486536026001 45.1062850952149,12.0413694381714 45.1172065734863,12.0265169143677 45.1205215454102,12.0265169143677 45.1205215454102,12.0298852920533 45.1144981384277,12.0274372100831 45.1078758239746,12.0207490921021 45.1015701293946,12.0137100219726 45.0965385437013,12.0108871459961 45.0955505371094,12.0076513290405 45.0958786010743,11.9912099838257 45.105194091797,11.983715057373 45.101375579834,11.9786520004272 45.1010398864747,11.9612216949463 45.111270904541,11.956018447876 45.1106834411621,11.956018447876 45.1106834411621,11.9445314407349 45.1092796325684,11.9445314407349 45.1092796325684,11.9459161758423 45.1085243225098,11.9530410766603 45.0815811157228,11.9556589126587 45.07861328125,11.9706611633302 45.0707435607911,11.9691963195801 45.069923400879,11.9691963195801 45.069923400879,11.9692907333374 45.0617141723634,11.9661426544189 45.0533981323242,11.9673976898194 45.0479545593262,11.9729614257812 45.0425872802735,11.9729614257812 45.0425872802735,11.9825448989869 45.0462074279786,11.9875898361207 45.0509300231935,11.9985504150391 45.0550689697267,12.0083980560303 45.0510749816895,12.0128440856933 45.046989440918,12.0143852233886 45.0432128906251,12.0141191482545 45.0388793945312,12.0078601837158 45.0364532470703,12.000512123108 45.0287322998048,12.000512123108 45.0287322998048,11.9914598464967 45.0238418579102,11.9958810806275 45.013957977295,11.9976825714112 45.0042343139649,11.9972114562988 45.0002937316895,12.0004358291626 44.9984054565431,12.0004358291626 44.9984054565431,12.0056037902831 44.9965438842773,12.0066194534302 44.9975242614747,12.0072717666626 45.0016899108887,12.0169744491577 45.0067405700683,12.0217437744141 45.0074348449708,12.0335969924927 45.0024185180665,12.043890953064 45.000373840332,12.0454950332642 45.007152557373,12.0482158660889 45.0129966735841,12.0703020095825 45.021396636963,12.0726108551026 45.0212440490723,12.073558807373 45.0186958312989,12.073558807373 45.0186958312989,12.0949382781982 45.0216484069824,12.0949382781982 45.0216484069824,12.10795211792 45.022201538086,12.1272029876709 45.018409729004,12.1337394714357 45.0195693969728,12.1495180130005 45.0263366699219,12.1596326828003 45.0286254882812,12.1596326828003 45.0286254882812,12.1469163894654 45.0397682189941,12.1509828567505 45.0426177978516,12.1564350128173 45.0429344177247,12.1649637222291 45.0504684448243,12.1524562835694 45.0550804138184,12.1497440338134 45.0551834106446,12.1470975875854 45.052574157715,12.1439352035524 45.0525436401368,12.1402273178101 45.0541648864747,12.1374959945679 45.057186126709)) | 0.0006 | POINT(12.036723161355065 45.051987427931586) |
1397430 | POLYGON((-2.54437899589539 40.4746475219727,-2.54960489273071 40.4708976745605,-2.57732105255127 40.4889450073242,-2.6003839969635 40.5014228820801,-2.62005090713501 40.5069046020508,-2.62723898887629 40.5132331848145,-2.62683796882624 40.5152244567872,-2.61461710929871 40.5305252075195,-2.61392211914057 40.5342445373535,-2.60764503479004 40.5353393554688,-2.60126590728754 40.5279388427736,-2.59499406814564 40.5266647338867,-2.58950304985046 40.5230522155762,-2.58504104614252 40.5226478576661,-2.58139395713806 40.5245971679688,-2.56645894050592 40.5248069763185,-2.55377602577209 40.5164413452149,-2.55134606361383 40.516170501709,-2.54619097709656 40.518970489502,-2.53990888595575 40.5069732666017,-2.52865290641779 40.4983978271486,-2.53658890724176 40.4922676086426,-2.53638410568232 40.4860954284669,-2.54437899589539 40.4746475219727)) | 0.0006 | POINT(-2.5779785176981718 40.51114820397423) |
71044 | POLYGON((11.5700225830079 51.0695648193359,11.5684328079225 51.0687522888184,11.5684328079225 51.0687522888184,11.5661630630494 51.0700607299806,11.5698432922363 51.0717010498047,11.5652112960815 51.074001312256,11.5595321655275 51.0829887390137,11.5779190063477 51.0873184204102,11.5987071990967 51.0897254943848,11.5987071990967 51.0897254943848,11.6027488708497 51.0812301635742,11.5939350128175 51.0770378112794,11.5897760391235 51.0769424438478,11.58775806427 51.0749549865724,11.5822849273683 51.0723876953124,11.5764093399048 51.0715332031251,11.5758848190308 51.0710945129396,11.5772552490236 51.0698318481446,11.5762872695923 51.0687522888184,11.5729084014893 51.0683708190919,11.5719242095948 51.070915222168,11.5700225830079 51.0695648193359)) | 0.0006 | POINT(11.57857826777873 51.07503055390863) |