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 |
---|---|---|---|
70594 | POLYGON((10.6411485671997 51.4776496887207,10.6416158676148 51.4799346923829,10.6408987045289 51.4809799194336,10.6408987045289 51.4809799194336,10.6382608413697 51.4805412292481,10.6385021209717 51.4792098999025,10.6262407302856 51.4790077209473,10.6243486404419 51.4828414916993,10.6211471557617 51.4817733764648,10.6208848953247 51.4861106872559,10.6185503005983 51.4860763549806,10.6183223724366 51.4872016906738,10.6251974105835 51.4874992370607,10.6228609085083 51.4922981262206,10.6068143844605 51.4896621704103,10.5989456176758 51.4892807006837,10.5991563796997 51.4869842529297,10.5964784622192 51.4879951477051,10.5950784683228 51.4869346618653,10.5873107910157 51.4866256713868,10.5815782546998 51.4879989624023,10.5811853408813 51.4857406616211,10.5697736740112 51.4867095947266,10.5696563720703 51.485164642334,10.5638771057129 51.4845733642578,10.5660066604614 51.4824676513671,10.5664062499999 51.4795417785645,10.5664062499999 51.4795417785645,10.566951751709 51.4784622192382,10.5725679397584 51.4769096374512,10.5752000808716 51.4740028381348,10.5749769210816 51.4697570800781,10.5749769210816 51.4697570800781,10.5871572494508 51.4664115905762,10.5933361053467 51.466163635254,10.595866203308 51.4641265869142,10.6063995361329 51.4595756530762,10.6063995361329 51.4595756530762,10.6133079528809 51.4578247070314,10.6138334274292 51.4585342407227,10.6172981262207 51.4584770202638,10.61780834198 51.4608345031738,10.6223878860475 51.4600982666017,10.6257638931274 51.4628143310548,10.6251964569092 51.466106414795,10.627974510193 51.4654846191407,10.6281566619872 51.4687385559083,10.6296730041504 51.4699974060059,10.6346807479858 51.4683799743653,10.6359863281251 51.4762687683105,10.6395730972291 51.4760246276857,10.6394195556642 51.4775962829591,10.6411485671997 51.4776496887207)) | 0.0006 | POINT(10.60754698973438 51.476408591637274) |
67622 | POLYGON((9.3955774307251 48.0988502502442,9.39451599121105 48.1011428833008,9.39315891265875 48.1008720397949,9.39132595062256 48.1034812927247,9.39293384551996 48.1036033630372,9.39247322082531 48.1049575805664,9.3939962387085 48.1052780151368,9.39885902404791 48.1140670776368,9.40178394317627 48.1147079467773,9.40546607971186 48.1200752258302,9.4061679840089 48.1175193786622,9.40744590759289 48.1180000305175,9.40736103057867 48.1242637634278,9.40942764282232 48.1242866516114,9.40885257720959 48.1211891174318,9.41549491882324 48.1231689453126,9.41691017150873 48.1217346191406,9.42257499694824 48.1223945617675,9.42140579223633 48.1206207275391,9.42625045776379 48.1170349121094,9.42998504638683 48.1175575256348,9.43049144744873 48.1202125549317,9.43357467651367 48.1204414367677,9.43861579895031 48.1176567077637,9.43749618530285 48.1160202026367,9.44072246551525 48.1152153015137,9.43932342529308 48.1134757995605,9.44763278961182 48.1153907775879,9.44763278961182 48.1153907775879,9.44561386108398 48.1175270080567,9.44747352600098 48.1184539794923,9.44739055633556 48.1210594177246,9.44551849365234 48.1219863891602,9.44788551330572 48.1236534118653,9.4537029266358 48.1221885681153,9.46938133239752 48.1428604125978,9.46799468994141 48.1425018310548,9.46520805358898 48.1386795043946,9.45954704284668 48.1361427307129,9.45657253265381 48.1363792419434,9.45657825469976 48.1373672485351,9.45859813690191 48.1377716064453,9.45574474334722 48.1424827575684,9.45771980285639 48.1431045532227,9.45648574829102 48.144889831543,9.4593248367309 48.1485061645508,9.45745468139648 48.1498908996582,9.45550632476812 48.1479911804199,9.45080184936529 48.1506271362305,9.45072460174561 48.1529998779296,9.44768047332764 48.1540031433107,9.44376182556152 48.1587944030763,9.43529796600342 48.1611747741699,9.42552947998053 48.1611251831055,9.42552947998053 48.1611251831055,9.42479801177984 48.1583404541015,9.425856590271 48.1584587097168,9.42890644073492 48.152328491211,9.42622566223156 48.1495628356934,9.42548561096186 48.1466064453126,9.42856597900396 48.1458053588867,9.42557334899897 48.1455917358398,9.42506790161138 48.1404418945312,9.41889572143555 48.1419639587403,9.42056751251232 48.1386260986329,9.41540050506586 48.1384315490723,9.41509532928472 48.1419258117676,9.40502929687494 48.1409454345704,9.40484237670904 48.1397438049316,9.40199470520031 48.1399536132813,9.39915275573736 48.1359100341797,9.39710617065424 48.1360664367677,9.39568996429443 48.137508392334,9.39636802673351 48.1396293640137,9.39497756958019 48.1405296325684,9.38962268829351 48.1408920288087,9.38651275634777 48.1394577026367,9.38477039337158 48.1369132995605,9.38441944122314 48.1333236694337,9.38650989532471 48.1318321228028,9.38857460021978 48.1320152282715,9.38939571380615 48.1293296813965,9.39096450805675 48.1284713745118,9.3923654556275 48.1216888427736,9.38899040222168 48.1177444458008,9.38735485076899 48.1129074096681,9.3863353729248 48.1122665405274,9.38392066955566 48.1139602661133,9.38048648834229 48.1179695129396,9.37729930877686 48.1176071166993,9.35554504394537 48.1044998168946,9.35554504394537 48.1044998168946,9.35035419464123 48.1014518737793,9.3497686386109 48.1000595092774,9.34995841979986 48.098274230957,9.35270881652838 48.0948677062989,9.35270881652838 48.0948677062989,9.36245441436768 48.0935821533204,9.36545181274408 48.0921936035156,9.36653137207031 48.0936965942383,9.36982822418213 48.0938758850098,9.3731107711792 48.0923805236817,9.37574005126959 48.0947647094727,9.3806991577149 48.0932502746582,9.3806991577149 48.0932502746582,9.38443470001226 48.0906715393068,9.38689136505127 48.0906257629395,9.38877582550049 48.0921440124512,9.3988180160523 48.0936241149902,9.39902210235607 48.0948181152345,9.3955774307251 48.0988502502442)) | 0.0006 | POINT(9.411478649486224 48.12421857660468) |
14315 | POLYGON((12.7902441024781 45.9386978149415,12.7976360321045 45.9501037597657,12.8105926513671 45.9549751281739,12.8150291442872 45.9543685913087,12.8184623718263 45.9550209045411,12.8295001983644 45.9595336914064,12.834740638733 45.9707489013673,12.8349714279175 45.9740791320801,12.8349714279175 45.9740791320801,12.8521699905396 45.9816398620605,12.8521699905396 45.9816398620605,12.8511219024658 45.9773483276367,12.8640298843383 45.9730262756348,12.8661489486694 45.9733200073242,12.8683671951294 45.962272644043,12.8678188323975 45.9610252380371,12.8678188323975 45.9610252380371,12.8665428161622 45.9610290527345,12.8663034439088 45.9598617553712,12.8690080642701 45.9495468139649,12.859411239624 45.936092376709,12.8551921844482 45.934139251709,12.8435592651368 45.932731628418,12.8388967514039 45.9348793029785,12.834140777588 45.9341011047363,12.8233613967896 45.9310722351074,12.8182516098022 45.9281692504883,12.8020391464233 45.9294395446778,12.7954778671266 45.9244918823242,12.7954778671266 45.9244918823242,12.7898216247559 45.9305381774903,12.7975063323975 45.9354705810548,12.801251411438 45.9392967224121,12.7982292175294 45.9403572082521,12.7902441024781 45.9386978149415)) | 0.0006 | POINT(12.832654840805992 45.95084156709562) |
52166 | POLYGON((-0.0655856430530548 45.4917106628419,-0.0674361065028961 45.4871711730958,-0.0674361065028961 45.4871711730958,-0.0539134666323662 45.4896125793458,-0.0500770546495914 45.4876441955566,-0.0424518808722496 45.4686660766602,-0.0424518808722496 45.4686660766602,-0.0401845201849369 45.4518127441406,-0.0260028280317783 45.4610557556153,-0.0164067447185516 45.4623756408693,-0.0164067447185516 45.4623756408693,-0.0160234570503235 45.4656944274902,0.0257686991244555 45.4715576171876,0.0268338769674301 45.4748687744142,0.0185921788216206 45.4830932617187,0.0185921788216206 45.4830932617187,-0.0354479253292084 45.4942321777344,-0.0419581010936554 45.4986953735353,-0.0419581010936554 45.4986953735353,-0.045122303068581 45.50101852417,-0.045122303068581 45.50101852417,-0.0581819675862789 45.5031394958497,-0.064552329480648 45.4982872009277,-0.0655856430530548 45.4917106628419)) | 0.0006 | POINT(-0.03247532742499682 45.48224590135664) |
46838 | POLYGON((2.97173643112183 50.6336479187012,2.96308255195618 50.6201934814453,2.96308255195618 50.6201934814453,2.94132375717174 50.6253890991212,2.94132375717174 50.6253890991212,2.94127964973455 50.6269149780274,2.94127964973455 50.6269149780274,2.96129775047302 50.6296577453613,2.97001504898077 50.6336631774902,2.97001504898077 50.6336631774902,2.97173643112183 50.6336479187012)) | 0.0006 | POINT(2.956443619728133 50.62756271362307) |
63401 | POLYGON((11.2845554351808 53.5597152709962,11.2852201461792 53.5622444152833,11.2832040786744 53.5659942626954,11.2845516204834 53.5670471191406,11.2868623733521 53.5671043395996,11.2872028350831 53.5709495544434,11.2872028350831 53.5709495544434,11.2888736724854 53.5765609741211,11.2824230194092 53.578857421875,11.27787399292 53.5829048156739,11.2826671600342 53.5883102416993,11.2826671600342 53.5883102416993,11.2834854125977 53.5876312255859,11.2900323867799 53.5905456542969,11.2988729476929 53.5924758911133,11.2988729476929 53.5924758911133,11.3083362579346 53.5871925354004,11.3072214126588 53.5865364074708,11.3130311965944 53.5854644775392,11.3138904571534 53.5845603942872,11.3255996704102 53.5824775695801,11.330644607544 53.5833168029785,11.3311214447022 53.5845527648926,11.3344135284424 53.5845565795898,11.3343315124512 53.5834350585938,11.3426179885865 53.5840072631836,11.3426179885865 53.5840072631836,11.3431997299195 53.5797348022462,11.3395309448242 53.575008392334,11.3322792053224 53.5724143981935,11.331353187561 53.5665702819824,11.3303337097169 53.5645370483398,11.3283872604371 53.5637855529786,11.3291702270507 53.5621109008789,11.3257341384888 53.5583572387696,11.326159477234 53.5569076538085,11.3206567764282 53.5564498901368,11.3243503570557 53.5529937744141,11.3138036727906 53.5482368469238,11.3138036727906 53.5482368469238,11.313557624817 53.5495948791504,11.3152370452881 53.5506744384766,11.3135414123536 53.5527954101563,11.3093690872193 53.5523834228516,11.3057880401611 53.5546264648438,11.3007116317748 53.5518188476562,11.2975778579712 53.5554084777833,11.2887258529663 53.5566329956055,11.2845554351808 53.5597152709962)) | 0.0006 | POINT(11.309826354185788 53.57086380322776) |
46575 | POLYGON((3.16797852516174 50.0868453979493,3.15655779838573 50.0815162658692,3.14496827125561 50.0895690917969,3.14496827125561 50.0895690917969,3.14333915710461 50.0959815979004,3.15593624115002 50.1063957214357,3.15516448020935 50.1096992492676,3.1499555110932 50.1191558837891,3.13590764999395 50.120517730713,3.13590764999395 50.120517730713,3.14587068557751 50.1267013549806,3.14587068557751 50.1267013549806,3.16626405715954 50.1302604675292,3.18193435668951 50.1289710998535,3.20429825782776 50.1422080993653,3.20429825782776 50.1422080993653,3.21253466606146 50.1436233520508,3.21253466606146 50.1436233520508,3.21618032455456 50.1366500854492,3.21618032455456 50.1366500854492,3.21246695518505 50.12406539917,3.21246695518505 50.12406539917,3.19736695289618 50.1205787658691,3.18107724189758 50.1119384765626,3.17896342277533 50.0985679626466,3.16797852516174 50.0868453979493)) | 0.0006 | POINT(3.175159654617383 50.11826324462896) |
13929 | POLYGON((15.0872821807861 40.3153114318848,15.0705451965332 40.3131446838379,15.0641469955444 40.3057823181153,15.0634393692017 40.3034400939941,15.0634393692017 40.3034400939941,15.0527801513672 40.3074035644532,15.0527801513672 40.3074035644532,15.0529336929321 40.3088989257812,15.0400285720825 40.3162269592285,15.0361700057984 40.3164825439453,15.0176229476929 40.3230133056641,15.0133972167968 40.3283386230469,15.0133972167968 40.3283386230469,15.01331615448 40.331169128418,15.019871711731 40.3277549743653,15.0268774032594 40.3274459838868,15.0412740707397 40.3303146362305,15.0435352325441 40.3316154479982,15.0435352325441 40.3316154479982,15.0457487106323 40.3323249816895,15.0541887283325 40.3318061828614,15.0605878829955 40.3264617919922,15.0716724395752 40.3220405578614,15.0834016799927 40.3186874389649,15.0872821807861 40.3153114318848)) | 0.0006 | POINT(15.047165513038642 40.320352554321325) |
36309 | POLYGON((6.00743198394781 47.7799110412598,6.00238990783691 47.777473449707,6.00238990783691 47.777473449707,5.99029350280762 47.7821578979493,5.97666692733765 47.7817497253418,5.9706797599793 47.7865219116212,5.9706797599793 47.7865219116212,5.96907091140747 47.7895431518555,5.9821391105653 47.8054695129395,5.9821391105653 47.8054695129395,5.98654747009283 47.802547454834,5.98654747009283 47.802547454834,6.00743198394781 47.7799110412598)) | 0.0006 | POINT(5.985581318537435 47.789782206217474) |
63230 | POLYGON((11.5351276397706 53.8282127380371,11.53155708313 53.8294486999512,11.527364730835 53.8274688720704,11.5217752456666 53.8280639648438,11.5113286972046 53.8353538513184,11.5052680969239 53.8366355895996,11.5078172683715 53.8391380310059,11.5080728530885 53.8416595458984,11.5098695755006 53.8425178527831,11.5021572113037 53.8453483581544,11.4994659423829 53.8432769775391,11.4984254837037 53.8436241149903,11.4989538192749 53.8454437255861,11.4957618713378 53.8500366210939,11.4954357147216 53.8523559570312,11.4977273941041 53.8575477600099,11.4916572570801 53.8559150695801,11.4894580841064 53.8521156311035,11.4858131408693 53.8501853942871,11.4836101531982 53.8501853942871,11.4816284179688 53.8525733947754,11.4815158843995 53.8556747436524,11.4831018447875 53.8592987060547,11.4815368652345 53.8619804382324,11.485471725464 53.8646087646484,11.4835186004639 53.8662948608398,11.4835186004639 53.8662948608398,11.4856176376343 53.8690071105958,11.4872980117797 53.868709564209,11.4889993667604 53.8723831176757,11.4904918670654 53.8722305297852,11.4917736053468 53.8743400573732,11.500171661377 53.8732948303223,11.501259803772 53.8756294250489,11.5068740844728 53.8772315979003,11.5134143829347 53.8772468566894,11.5143423080444 53.8792343139648,11.5101041793823 53.88138961792,11.5107126235963 53.8839988708497,11.5185871124269 53.8826065063477,11.5185871124269 53.8826065063477,11.5242195129395 53.8764228820802,11.5280199050903 53.8783340454102,11.546317100525 53.8785934448243,11.5496339797974 53.8749351501466,11.5496339797974 53.8749351501466,11.5547590255738 53.8737525939943,11.5539073944092 53.8724632263183,11.5562829971314 53.8720130920411,11.560920715332 53.8670692443848,11.5605354309083 53.863136291504,11.5568389892579 53.8586311340333,11.5587368011476 53.8579063415528,11.5656785964966 53.859031677246,11.5737152099609 53.8552093505859,11.5749397277832 53.8439140319824,11.5772066116334 53.8440284729005,11.5780563354493 53.8415489196778,11.5961074829102 53.8338165283204,11.5961074829102 53.8338165283204,11.5949974060059 53.8331451416016,11.5976114273071 53.831829071045,11.5956773757935 53.828224182129,11.5996580123903 53.8277244567872,11.5979433059693 53.8253669738769,11.6030063629151 53.8226165771484,11.6035041809083 53.8212928771973,11.5995826721191 53.8199157714843,11.6009864807129 53.8189964294434,11.5997428894043 53.8178672790528,11.5969238281251 53.8180351257325,11.5959987640381 53.8162803649903,11.5885639190675 53.8134346008301,11.5880498886109 53.8110885620118,11.589750289917 53.8098678588867,11.5875568389893 53.8071632385254,11.573097229004 53.7988090515138,11.5715713500978 53.7997016906739,11.5715713500978 53.7997016906739,11.5689907073975 53.8021583557129,11.5668296813965 53.8025360107423,11.5601987838746 53.806941986084,11.5610475540161 53.8075370788575,11.5585107803345 53.8093223571778,11.5464487075806 53.8127479553224,11.5441961288453 53.8162879943848,11.5441961288453 53.8162879943848,11.5438375473023 53.8171806335449,11.5451602935791 53.8185005187988,11.5439987182617 53.8207359313966,11.5454883575441 53.8264656066896,11.5475597381592 53.8280029296875,11.5470275878906 53.8305053710938,11.5442190170289 53.8330612182618,11.5439634323121 53.835075378418,11.5407056808473 53.8373146057129,11.5404462814331 53.8404350280761,11.5384483337403 53.8400917053223,11.5379419326783 53.8347930908203,11.5385322570801 53.8328132629395,11.5403957366944 53.8313522338868,11.5351276397706 53.8282127380371)) | 0.0006 | POINT(11.539413140551924 53.84289044672901) |