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 |
|---|---|---|---|
| 14089 | POLYGON((11.0500755310059 44.7234573364258,11.0553493499756 44.7221870422363,11.0670471191407 44.7262992858888,11.0822029113771 44.7281684875489,11.0899152755737 44.7252731323243,11.0942535400391 44.7193679809571,11.1026630401611 44.7153549194337,11.1179971694947 44.7113761901856,11.1179971694947 44.7113761901856,11.1236639022828 44.7506408691407,11.1308927536011 44.7838516235353,11.1308927536011 44.7838516235353,11.1116847991943 44.7787628173828,11.1104068756105 44.7776794433594,11.1093549728394 44.7741432189942,11.1070251464844 44.7722892761232,11.1003189086914 44.7727546691895,11.1003189086914 44.7727546691895,11.0750141143799 44.7593002319336,11.0521097183228 44.7451171875001,11.0428142547607 44.7315063476563,11.0500755310059 44.7234573364258)) | 0.0006 | POINT(11.093904676891546 44.74692916870123) |
| 18918 | POLYGON((13.4530649185181 37.9493103027344,13.4530649185181 37.9477882385255,13.4613389968872 37.9424171447754,13.4651384353637 37.9419822692871,13.4719457626343 37.9378929138185,13.4724922180177 37.9321060180664,13.4724922180177 37.9321060180664,13.4696350097656 37.9308815002441,13.453790664673 37.9295730590821,13.4515800476074 37.9286422729493,13.4478225708009 37.9233322143555,13.4464073181152 37.9077644348146,13.4464073181152 37.9077644348146,13.4327487945557 37.9063034057618,13.4327487945557 37.9063034057618,13.4144525527955 37.9097023010254,13.4144525527955 37.9097023010254,13.4209661483765 37.9327964782715,13.4152088165284 37.9333076477052,13.4123373031616 37.9355506896973,13.4123373031616 37.9355506896973,13.4039382934571 37.9383964538575,13.3981227874756 37.9425926208497,13.401647567749 37.957893371582,13.4041852951051 37.9637603759765,13.4026794433594 37.9665718078613,13.4012918472291 37.9674491882325,13.3846979141236 37.9580421447754,13.3726444244385 37.9606971740723,13.371169090271 37.963478088379,13.3737678527832 37.9674072265625,13.374568939209 37.9708976745607,13.3663635253907 37.9764137268068,13.3629417419434 37.9762268066407,13.3608980178834 37.9795837402343,13.3622236251832 37.9844703674316,13.3676757812501 37.9881134033204,13.3747520446777 37.9889526367188,13.3747520446777 37.9889526367188,13.3800506591797 37.9887084960939,13.3858280181885 37.9869842529298,13.3872003555299 37.9836654663087,13.3893041610718 37.981616973877,13.4101495742798 37.9731941223144,13.4203863143921 37.9720268249513,13.4251565933229 37.9661712646485,13.4416999816895 37.957920074463,13.4440011978151 37.9541130065919,13.4440011978151 37.9541130065919,13.4530649185181 37.9493103027344)) | 0.0006 | POINT(13.414418999029703 37.951820217833266) |
| 26557 | POLYGON((-0.59727543592453 49.1883583068849,-0.591751098632756 49.1827545166017,-0.616179764270726 49.1694679260255,-0.614357531070652 49.1661758422853,-0.614357531070652 49.1661758422853,-0.587915062904301 49.1601104736328,-0.587915062904301 49.1601104736328,-0.556904196739197 49.1613464355469,-0.556904196739197 49.1613464355469,-0.553590476512909 49.1820335388184,-0.553590476512909 49.1820335388184,-0.556568622589111 49.1860160827637,-0.556568622589111 49.1860160827637,-0.595006048679295 49.1894912719727,-0.595006048679295 49.1894912719727,-0.59727543592453 49.1883583068849)) | 0.0006 | POINT(-0.5822593450545962 49.17539520263677) |
| 64219 | POLYGON((13.1407594680786 53.0233421325684,13.1417665481568 53.0184707641602,13.1392860412599 53.0166358947755,13.1403055191041 53.0122261047364,13.1384420394897 53.0122375488282,13.1383666992188 53.0103797912598,13.1337385177613 53.0100402832032,13.127986907959 53.0036849975587,13.1276388168335 53.0023422241212,13.129210472107 52.9988059997559,13.1285495758058 52.9958305358888,13.1236734390259 52.991527557373,13.1131019592286 52.986183166504,13.1131019592286 52.986183166504,13.1108264923097 52.9837493896484,13.1031246185304 52.9825401306152,13.0960502624512 52.9831581115723,13.0937929153442 52.9853286743164,13.0942430496216 52.9871711730958,13.090166091919 52.9941864013673,13.0794639587402 53.0008811950684,13.0811080932617 53.005054473877,13.0843105316162 53.0093421936036,13.0963487625123 53.0170288085938,13.1119089126587 53.0211143493653,13.1268806457521 53.0277976989747,13.1287355422974 53.0268783569336,13.1282424926758 53.0256118774415,13.1304569244386 53.0239601135254,13.1349668502808 53.0252838134767,13.1407594680786 53.0233421325684)) | 0.0006 | POINT(13.11755180358892 53.005565897623754) |
| 26680 | POLYGON((0.172443762421608 49.3970527648927,0.156833231449184 49.3895072937012,0.141941964626369 49.3894462585449,0.1301105618478 49.3794670104982,0.1301105618478 49.3794670104982,0.132443457841873 49.3858184814454,0.150933712720871 49.4012603759766,0.14889873564249 49.4070816040038,0.14889873564249 49.4070816040038,0.161526992917061 49.4109725952149,0.165693998336849 49.4106941223145,0.169305995106811 49.4120826721193,0.171250000596046 49.4115295410156,0.183751001954192 49.415153503418,0.183751001954192 49.415153503418,0.184686198830605 49.4153594970704,0.194228067994175 49.4067153930664,0.194228067994175 49.4067153930664,0.190613418817577 49.4055137634277,0.190613418817577 49.4055137634277,0.172622635960693 49.4003219604493,0.172443762421608 49.3970527648927)) | 0.0006 | POINT(0.16547073920573516 49.402471814836815) |
| 43235 | POLYGON((6.76689386367809 48.1028175354004,6.76932477951061 48.1057853698732,6.78359222412109 48.107048034668,6.78359222412109 48.107048034668,6.77519512176525 48.1194229125978,6.77647399902355 48.1363754272462,6.76314067840582 48.1468162536621,6.76314067840582 48.1468162536621,6.753242969513 48.1475219726562,6.73816156387329 48.1388931274413,6.73316669464111 48.1392478942872,6.73316669464111 48.1392478942872,6.73319768905651 48.1322669982911,6.73319768905651 48.1322669982911,6.75633144378662 48.1184616088868,6.76689386367809 48.1028175354004)) | 0.0006 | POINT(6.757454554239966 48.128002421061254) |
| 66780 | POLYGON((8.14049911499035 48.0084915161133,8.14772987365734 48.0010299682617,8.1509103775025 48.0012245178224,8.1509103775025 48.0012245178224,8.15722942352301 48.0013427734376,8.16183376312256 47.9994735717773,8.16317462921148 47.9983215332031,8.16118812561041 47.9964179992676,8.16152477264404 47.9938278198243,8.16423892974859 47.9925270080566,8.17125701904303 47.9951400756836,8.17417144775402 47.994987487793,8.17780208587658 47.9924278259278,8.18093872070312 47.992099761963,8.19100761413574 47.9936599731446,8.19100761413574 47.9936599731446,8.19366645813 47.9973640441895,8.1936149597168 47.9992294311525,8.20151615142817 48.0067863464357,8.20108604431152 48.0134239196778,8.20392227172852 48.0172958374024,8.21053791046154 48.0176963806152,8.21460056304937 48.014488220215,8.22543811798107 48.0169372558594,8.23629951477051 48.0159721374512,8.24294757843029 48.0130424499513,8.2481431961059 48.0140228271484,8.26236629486084 48.0136680603027,8.27050781250011 48.015308380127,8.26884555816645 48.0221252441407,8.2743673324585 48.028678894043,8.27076530456549 48.0309715270997,8.27620792388922 48.0386962890626,8.27658081054693 48.0482749938965,8.27602386474621 48.051399230957,8.26440048217773 48.0542488098146,8.26346015930181 48.056926727295,8.26686763763439 48.0628433227539,8.26568317413341 48.0644187927246,8.26727962493891 48.0670700073243,8.26622390747082 48.0687561035156,8.26804447174084 48.0715255737306,8.27055644989025 48.0732345581056,8.27986431121832 48.075138092041,8.28238391876226 48.0808563232423,8.28238391876226 48.0808563232423,8.28044605255127 48.0836601257325,8.28190803527832 48.0872573852539,8.27752399444574 48.0907135009766,8.28007698059093 48.0948295593262,8.27705192565924 48.095516204834,8.27465534210199 48.0992431640625,8.27278709411615 48.0998878479003,8.27278709411615 48.0998878479003,8.25730228424078 48.0979194641114,8.25439357757574 48.0951614379884,8.25439357757574 48.0951614379884,8.25405883789068 48.0918998718262,8.24939727783203 48.0893402099609,8.24620246887207 48.0858306884767,8.23614501953131 48.0835723876953,8.22919845581066 48.0805320739747,8.21783542633062 48.0801544189453,8.21528625488281 48.080711364746,8.21478939056408 48.0841903686523,8.21070194244385 48.0849227905273,8.20598030090332 48.0842666625977,8.19502639770513 48.0894699096681,8.19175243377691 48.0877113342285,8.18887138366699 48.0901756286621,8.19011116027832 48.0932235717774,8.18315410614019 48.0981407165528,8.18472576141369 48.1001243591309,8.17967033386242 48.1008377075196,8.17290496826172 48.1036529541016,8.15997505187988 48.103343963623,8.15671062469494 48.1008338928222,8.15590858459484 48.1024627685546,8.1494665145874 48.1040840148925,8.1494665145874 48.1040840148925,8.14910793304449 48.102668762207,8.15038967132568 48.1005020141603,8.15347862243658 48.0996322631836,8.15366077423101 48.0980644226075,8.15180778503429 48.0972213745118,8.15205383300793 48.0948791503906,8.14953708648687 48.0944213867189,8.15115356445312 48.0932922363282,8.14833068847656 48.0891838073732,8.14874458312988 48.0882644653321,8.14631748199469 48.0873641967775,8.14798355102533 48.0856552124025,8.14539241790766 48.0853843688964,8.15414810180664 48.0788192749023,8.15648269653326 48.0791206359863,8.15600395202648 48.077606201172,8.15898704528814 48.0772590637208,8.16050338745123 48.07865524292,8.16607475280767 48.0757904052734,8.16607475280767 48.0757904052734,8.16880989074713 48.0730133056641,8.16819000244146 48.0668411254883,8.17249393463146 48.0640563964844,8.17491149902349 48.0591697692872,8.17575550079351 48.0532226562501,8.17469120025635 48.0510520935058,8.16902065277111 48.0506896972657,8.16998386383062 48.0453491210938,8.1716356277467 48.0436019897462,8.17205333709717 48.0390357971191,8.16338539123529 48.0377273559571,8.16083240509033 48.0364036560059,8.15480804443359 48.0364799499512,8.13802719116222 48.0340805053712,8.13580703735352 48.034797668457,8.1307697296142 48.0324859619141,8.13280963897705 48.0290832519531,8.14424133300793 48.021614074707,8.14278602600092 48.0158805847169,8.14003467559814 48.0137176513673,8.14049911499035 48.0084915161133)) | 0.0006 | POINT(8.199316287040746 48.05706494649254) |
| 70801 | POLYGON((11.5463409423829 50.557960510254,11.5307302474977 50.5561866760254,11.5253839492798 50.5543327331544,11.52299118042 50.5527954101564,11.5243110656739 50.5498504638672,11.5285949707032 50.5487594604493,11.5278902053833 50.5452957153321,11.5151958465577 50.5411033630371,11.513771057129 50.5418014526367,11.5091438293457 50.5413551330566,11.508065223694 50.5424461364746,11.5051498413087 50.5421180725098,11.5016040802003 50.5433654785157,11.493106842041 50.5434379577637,11.4911584854126 50.5445976257324,11.4875345230103 50.5428276062012,11.4882774353028 50.5419387817384,11.4860248565674 50.5413856506348,11.4863586425781 50.5389709472656,11.4923830032349 50.5367317199707,11.4915113449098 50.534912109375,11.4926481246949 50.5345878601075,11.488751411438 50.5282783508302,11.4842300415038 50.5263710021974,11.4855041503907 50.525188446045,11.4825038909912 50.5241203308105,11.4825038909912 50.5241203308105,11.4849004745484 50.5226669311525,11.4914360046387 50.521324157715,11.4995355606079 50.5212097167969,11.5025300979614 50.5186653137208,11.5105247497559 50.5176696777344,11.5229339599611 50.5111236572266,11.5245895385743 50.5031547546387,11.5272197723389 50.5021591186523,11.5273675918579 50.5005111694337,11.5244140625001 50.498992919922,11.5255098342897 50.4981460571289,11.5303144454956 50.4991722106934,11.533278465271 50.4985504150391,11.5299491882324 50.4940986633301,11.5313768386841 50.4935760498047,11.5334730148317 50.4958610534669,11.5364513397216 50.4953117370607,11.5349683761597 50.490779876709,11.5415945053102 50.487419128418,11.5446796417237 50.4910697937013,11.5487489700318 50.4894676208496,11.5506429672241 50.4871368408204,11.5708932876587 50.4826316833497,11.5753297805786 50.4799270629884,11.5753297805786 50.4799270629884,11.5803661346436 50.4836769104005,11.5827407836915 50.4875602722168,11.5981235504152 50.4924812316895,11.5993604660034 50.4917526245118,11.601040840149 50.4927673339844,11.6026067733766 50.4920501708984,11.6075820922853 50.4948654174805,11.6075820922853 50.4948654174805,11.61208152771 50.4990081787111,11.6138572692871 50.5054512023926,11.6121940612794 50.5072937011719,11.6165590286255 50.5092773437501,11.610975265503 50.513038635254,11.6109304428101 50.5165214538574,11.6176671981813 50.5202598571778,11.6192455291748 50.5230903625489,11.6225385665895 50.5220756530762,11.6209764480591 50.5210571289063,11.6242074966432 50.5193977355957,11.6265840530397 50.5206680297852,11.6270418167114 50.5186042785645,11.6249799728394 50.5185432434083,11.6231212615967 50.5163841247559,11.6261911392212 50.5142669677736,11.6237134933473 50.5098724365236,11.63414478302 50.5099754333497,11.6381406784058 50.5106658935548,11.6385889053345 50.5134162902833,11.6411170959472 50.5140838623048,11.6486539840699 50.5118217468262,11.651767730713 50.5133209228517,11.6539945602418 50.5126342773438,11.6573686599731 50.5132637023926,11.6616477966309 50.5156440734864,11.6639575958251 50.5188674926759,11.6661138534547 50.5192947387695,11.6790075302124 50.518482208252,11.684760093689 50.5199050903321,11.6863851547241 50.5216636657715,11.6921949386596 50.5242042541504,11.6880407333375 50.5246162414551,11.6873893737794 50.5272941589356,11.6873893737794 50.5272941589356,11.6857690811158 50.5296516418456,11.686679840088 50.5316123962402,11.6847467422485 50.5311012268067,11.6810302734376 50.5335731506348,11.6800317764283 50.5348701477051,11.6811237335205 50.5358085632324,11.6774082183838 50.53910446167,11.6784210205078 50.5403442382813,11.6759862899781 50.5426177978516,11.6829385757447 50.5461730957031,11.6825523376465 50.5476455688478,11.6808319091798 50.5488586425781,11.6835622787476 50.5529632568361,11.6806898117066 50.5555725097657,11.6810436248779 50.5572814941406,11.6945953369142 50.5602455139161,11.6969547271728 50.5618858337402,11.7001037597657 50.5618362426758,11.7001037597657 50.5618362426758,11.7070941925049 50.5672149658204,11.7090406417847 50.5703735351562,11.7089366912842 50.5723533630372,11.7064762115478 50.5739517211915,11.7021255493165 50.5739974975585,11.6965866088867 50.5684928894044,11.6965866088867 50.5684928894044,11.69344997406 50.5685005187989,11.6863508224487 50.5732803344727,11.6863508224487 50.5732803344727,11.684557914734 50.5727767944337,11.6803827285767 50.5754928588868,11.6755981445312 50.5761413574219,11.6760549545289 50.5770111083986,11.6743412017823 50.5778656005859,11.664662361145 50.5779266357422,11.6621828079224 50.5787811279297,11.6623926162719 50.5821342468262,11.6680765151979 50.5878715515137,11.6684055328369 50.589183807373,11.6675052642823 50.5899314880371,11.6675052642823 50.5899314880371,11.653489112854 50.5924835205079,11.6526880264282 50.5943717956543,11.6551914215088 50.5955810546875,11.6541862487794 50.6006660461426,11.649082183838 50.601245880127,11.6461105346681 50.604606628418,11.6441259384156 50.6015129089357,11.6470546722413 50.5981254577636,11.6470546722413 50.5981254577636,11.6488685607911 50.5966072082519,11.6476068496705 50.5947189331055,11.63703250885 50.5912513732911,11.6333799362183 50.5921859741211,11.6333799362183 50.5921859741211,11.6264743804932 50.5889701843261,11.6248483657837 50.5848197937012,11.6232347488403 50.58353805542,11.6148471832276 50.5838623046876,11.6148471832276 50.5838623046876,11.6134262084961 50.5817718505861,11.6091041564941 50.5807075500489,11.6082611083984 50.5773124694825,11.6065225601196 50.5761146545411,11.6068372726441 50.5720977783203,11.6051540374756 50.5703811645507,11.5976333618165 50.5672264099121,11.5951728820801 50.5637054443359,11.5941543579102 50.5642280578613,11.5859527587891 50.5605163574219,11.5762681961061 50.5577201843262,11.572958946228 50.5556983947754,11.5735511779786 50.553165435791,11.5718660354615 50.552360534668,11.5738039016723 50.5500297546388,11.5645723342896 50.5477867126465,11.5610971450807 50.5483741760254,11.5593366622925 50.5517044067383,11.5647087097169 50.5531768798829,11.5623855590821 50.5540962219238,11.5587100982666 50.5533485412598,11.5569133758545 50.5550842285157,11.5564470291137 50.5570373535156,11.5468835830688 50.5565261840821,11.5463409423829 50.557960510254)) | 0.0006 | POINT(11.604899731428294 50.54124876906753) |
| 40563 | POLYGON((2.48892021179211 46.2500076293946,2.4840013980866 46.2499237060547,2.4782640933991 46.2444763183595,2.46851253509533 46.2449264526367,2.46036624908459 46.2365570068359,2.45558524131781 46.2357978820802,2.44042491912836 46.2437286376954,2.4321653842926 46.2404365539551,2.4321653842926 46.2404365539551,2.44547533988964 46.2358741760254,2.44705033302307 46.2186737060547,2.45263314247137 46.2091445922852,2.44058942794811 46.1907539367676,2.45881533622742 46.1859893798828,2.45881533622742 46.1859893798828,2.46519684791576 46.1950149536133,2.48466110229504 46.1977424621582,2.50105571746838 46.2059555053712,2.50648188591009 46.2299156188964,2.51520299911499 46.2385444641113,2.51520299911499 46.2385444641113,2.51631116867077 46.2394409179688,2.51631116867077 46.2394409179688,2.48892021179211 46.2500076293946)) | 0.0006 | POINT(2.4723568791929096 46.22597022678543) |
| 54135 | POLYGON((5.72478771209722 45.7239875793458,5.72448825836182 45.7484512329102,5.72448825836182 45.7484512329102,5.73032379150402 45.7563743591309,5.73032379150402 45.7563743591309,5.73569774627697 45.7580642700196,5.73569774627697 45.7580642700196,5.74873352050787 45.7541046142579,5.76155185699469 45.7393951416017,5.76155185699469 45.7393951416017,5.7471599578858 45.738250732422,5.74064159393316 45.733425140381,5.73126983642589 45.732292175293,5.72478771209722 45.7239875793458)) | 0.0006 | POINT(5.73820891747115 45.745125403771105) |