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.
SpaltennameDatentypMögliche WerteBeschreibung
id_ortint(10) unsignedbeliebigFremdschlü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"
beliebigDie simplifizierten Geodaten.
epsilonfloat(5,4)beliebigDie 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"
beliebigDer geometrische Mittelpunkt des vereinfachten Polygons.
Ausschnitt
id_ortgeodatenepsilonmittelpunkt
18610POLYGON((8.66174602508551 40.8504180908204,8.65923023223877 40.8533821105958,8.6594028472901 40.8566436767578,8.66076469421387 40.859504699707,8.66693401336681 40.8667678833008,8.66693401336681 40.8667678833008,8.6744594573974 40.8735885620118,8.6767568588258 40.8745574951171,8.67873573303234 40.8726196289064,8.68836879730236 40.8732376098633,8.69521522521973 40.8787879943848,8.6976318359375 40.884750366211,8.71987056732189 40.8857879638673,8.72628402709972 40.8849563598633,8.73432540893555 40.880443572998,8.73701000213623 40.8769454956055,8.74589061737072 40.8758926391601,8.75594902038574 40.877384185791,8.76729202270519 40.8744735717774,8.76729202270519 40.8744735717774,8.75990486145025 40.8728523254395,8.74872398376465 40.8548393249512,8.74872398376465 40.8548393249512,8.74638557434088 40.8549156188965,8.72497081756592 40.8435401916505,8.72301578521729 40.8345565795898,8.71935558319103 40.827808380127,8.71585273742681 40.8232154846191,8.71167659759516 40.8209609985351,8.71167659759516 40.8209609985351,8.70714855194103 40.8206901550293,8.70081043243408 40.8222846984864,8.69188785552973 40.8309555053712,8.66907882690424 40.8386116027831,8.66777324676514 40.8365554809571,8.66777324676514 40.8365554809571,8.66481113433832 40.8430213928223,8.66388416290289 40.8481101989747,8.66174602508551 40.8504180908204))0.0006POINT(8.704830194774463 40.85596466064455)
1405780POLYGON((-0.71322101354599 38.7104377746582,-0.71642100810999 38.7104110717774,-0.730571985244694 38.7047157287598,-0.740140020847264 38.7032508850098,-0.746812999248505 38.7009086608887,-0.752919018268585 38.6961250305176,-0.755189001560211 38.6962966918946,-0.759168028831368 38.6921882629395,-0.759486973285675 38.6875228881837,-0.76769000291813 38.6799545288087,-0.776519000530243 38.6962165832521,-0.785391986370087 38.6937446594239,-0.787190020084381 38.6968955993652,-0.786191999912262 38.7039871215821,-0.790992021560669 38.7183952331542,-0.796482026576882 38.7223091125489,-0.800270020961705 38.7296981811525,-0.800994992256165 38.7371978759766,-0.792594015598297 38.7392044067383,-0.787522971630096 38.7465782165528,-0.783668994903508 38.7483863830566,-0.779520988464299 38.7467231750489,-0.770413994789124 38.7506484985352,-0.765681982040292 38.7510795593262,-0.76139497756958 38.7490997314454,-0.752013981342202 38.7554130554199,-0.743296027183533 38.7556686401368,-0.726848006248417 38.7275352478028,-0.71322101354599 38.7104377746582))0.0006POINT(-0.765307430710077 38.71966402871273)
54304POLYGON((5.0986528396607 46.2520370483399,5.10830068588257 46.2510299682617,5.11960172653198 46.2618713378906,5.13757610321056 46.2588577270508,5.13534641265875 46.2716217041016,5.13534641265875 46.2716217041016,5.12901973724371 46.2769546508789,5.11523628234875 46.2749328613282,5.09079313278193 46.2968406677247,5.09079313278193 46.2968406677247,5.07256841659546 46.2950019836426,5.07016086578375 46.2921562194824,5.07016086578375 46.2921562194824,5.07833766937267 46.2836914062501,5.0802955627442 46.266487121582,5.09294939041149 46.2614707946778,5.0986528396607 46.2520370483399))0.0006POINT(5.101571202278184 46.2752232551575)
27418POLYGON((-1.15707981586451 48.836368560791,-1.16243326663971 48.8422431945801,-1.1826092004776 48.8433837890626,-1.19989717006678 48.8603057861328,-1.19989717006678 48.8603057861328,-1.18460035324097 48.8691787719728,-1.14897501468658 48.8822441101075,-1.14897501468658 48.8822441101075,-1.14103972911829 48.8738136291504,-1.13127827644342 48.8715744018555,-1.12035906314844 48.8564262390137,-1.12035906314844 48.8564262390137,-1.12115621566772 48.8482208251954,-1.12115621566772 48.8482208251954,-1.13137829303736 48.8489303588868,-1.14280033111572 48.8376197814943,-1.15707981586451 48.836368560791))0.0006POINT(-1.1508746370672887 48.85734415054327)
12980POLYGON((15.9649190902711 40.3578758239747,15.9567747116089 40.3534584045411,15.9541320800781 40.3511009216309,15.9536762237549 40.3488426208496,15.959776878357 40.3324050903321,15.966953277588 40.3280715942384,15.9680681228638 40.3228759765626,15.967574119568 40.3187980651857,15.9611606597902 40.3080978393555,15.9611606597902 40.3080978393555,15.9570064544678 40.3119506835938,15.9454622268677 40.3131713867189,15.9251918792725 40.3136215209961,15.8876132965088 40.3124923706055,15.8483533859253 40.329429626465,15.8431282043458 40.3330802917481,15.8408346176147 40.3363838195802,15.8408346176147 40.3363838195802,15.8386497497559 40.3394966125488,15.8387088775636 40.3415107727052,15.8462390899658 40.3681488037111,15.853217124939 40.3780326843262,15.8656692504883 40.3855514526367,15.8656692504883 40.3855514526367,15.8686056137086 40.3857574462891,15.8709335327148 40.3927078247071,15.8868589401245 40.4013557434083,15.8949213027955 40.4023361206055,15.9130992889404 40.4116172790527,15.9130992889404 40.4116172790527,15.9210300445557 40.4116096496582,15.9261293411256 40.4096145629883,15.9304189682006 40.4052734375001,15.9388656616211 40.4014511108399,15.9496221542359 40.399055480957,15.9496221542359 40.399055480957,15.9480686187744 40.3958625793458,15.9488916397095 40.3873291015626,15.9580020904541 40.3792495727539,15.9586563110353 40.3714027404786,15.9580087661743 40.3671951293946,15.9591894149781 40.3632812500001,15.9649190902711 40.3578758239747))0.0006POINT(15.916780880519363 40.36214764912927)
58949POLYGON((7.34819412231457 51.4826698303223,7.34761047363281 51.4842376708984,7.34322595596319 51.4834022521973,7.34037351608276 51.4860801696778,7.34384202957165 51.4918479919434,7.33977746963501 51.4930534362792,7.34118366241466 51.495891571045,7.3369030952453 51.4975051879884,7.33114051818853 51.4957084655763,7.3318076133728 51.4931526184083,7.330071926117 51.4930152893068,7.32699441909801 51.4891242980958,7.32191085815424 51.4896278381347,7.32060718536371 51.4949111938477,7.31698322296137 51.4945373535156,7.31646966934204 51.4984016418456,7.3190474510194 51.4995079040528,7.31738042831427 51.5064888000489,7.31592226028437 51.5062866210939,7.31287670135509 51.5033950805665,7.3035936355592 51.5039176940919,7.30388736724865 51.505699157715,7.30231046676647 51.5082130432129,7.30404186248785 51.5160865783693,7.31428194046026 51.5224227905274,7.31428194046026 51.5224227905274,7.32549858093267 51.5232467651368,7.33577632904053 51.5207328796387,7.34032821655279 51.5219192504884,7.34332323074341 51.5243301391602,7.3435111045838 51.5233459472656,7.34645652771002 51.5241088867188,7.34653902053839 51.5222816467285,7.35392332077026 51.5238380432129,7.35704326629639 51.5263366699218,7.36403560638433 51.5281600952149,7.36285114288336 51.52938079834,7.36378431320196 51.5298042297364,7.36078643798828 51.5327568054199,7.36191844940197 51.5329589843751,7.36134099960321 51.5340270996094,7.35756635665888 51.5335845947265,7.3571453094483 51.5357170104981,7.35436677932745 51.5386276245118,7.35248470306408 51.5380630493165,7.34978199005121 51.5394668579103,7.3489232063294 51.5442924499512,7.35110950469982 51.5461616516114,7.35424327850347 51.5515747070312,7.35059452056896 51.5523262023927,7.35417699813848 51.556251525879,7.35434246063232 51.5577011108399,7.35172700881969 51.5605316162109,7.35188484191895 51.5669097900392,7.35008811950689 51.5676918029785,7.34659957885748 51.5719718933107,7.34386157989513 51.5712318420411,7.33846807479858 51.576530456543,7.34979724884028 51.581153869629,7.35368633270269 51.5834274291992,7.35361862182617 51.5850639343262,7.35736894607555 51.5819244384766,7.36126232147222 51.5821495056152,7.36072444915771 51.5830612182618,7.36288166046148 51.5837211608887,7.370032787323 51.5821876525879,7.37172794342047 51.5908050537109,7.37172794342047 51.5908050537109,7.38442373275763 51.5879898071289,7.39632225036632 51.5873184204103,7.39972591400152 51.5907058715821,7.39997386932373 51.5931434631349,7.41101026535034 51.5956382751466,7.41793394088739 51.5995216369629,7.41793394088739 51.5995216369629,7.42060184478771 51.598976135254,7.42556238174438 51.5944442749023,7.4237260818482 51.5937995910645,7.42534685134888 51.5918273925781,7.42286157608044 51.5906791687013,7.42328262329107 51.5901069641114,7.42052936553966 51.5866889953614,7.42797613143921 51.5857582092285,7.4464545249939 51.5811767578126,7.44961547851557 51.5827674865723,7.45239973068237 51.581974029541,7.45532274246216 51.5838775634766,7.46085214614874 51.5846252441407,7.46797513961792 51.5887947082521,7.4691162109375 51.5875091552736,7.47407770156866 51.5908927917482,7.47743272781372 51.5894355773926,7.48987817764282 51.5926895141603,7.4977068901062 51.5921211242676,7.50179195404058 51.5864715576172,7.50401306152344 51.5861053466797,7.50254869461054 51.5806579589845,7.51498556137079 51.5801010131837,7.51709032058716 51.5766677856446,7.52854299545288 51.5767135620117,7.55288505554205 51.5836563110352,7.56342029571528 51.5855293273927,7.56378889083862 51.5847930908204,7.57028102874767 51.5856475830079,7.5720739364624 51.5854110717775,7.57148265838629 51.5838127136232,7.58168649673462 51.5835685729981,7.5823850631715 51.581226348877,7.59054279327393 51.5831565856934,7.59054279327393 51.5831565856934,7.59194087982178 51.58065032959,7.59735202789312 51.5763549804688,7.59613370895386 51.5738639831544,7.59294176101696 51.573558807373,7.59078121185303 51.5721893310547,7.59047365188604 51.5698089599611,7.59343671798712 51.5686531066895,7.59104299545299 51.5657310485839,7.59486627578747 51.5646743774413,7.59922170639044 51.5647888183594,7.59929895400995 51.5676727294923,7.60654592514038 51.5677604675294,7.60648632049561 51.5652732849122,7.60464477539074 51.5626373291016,7.60410976409912 51.5567054748536,7.60649108886724 51.5566024780274,7.60684680938732 51.5540733337403,7.60399150848383 51.5535545349121,7.60563182830816 51.5515861511232,7.60687208175653 51.5522994995117,7.60838413238525 51.5507698059083,7.60654592514038 51.550148010254,7.60797500610363 51.5485534667969,7.61897659301763 51.5499687194825,7.62505292892456 51.5518646240236,7.632242679596 51.5486717224122,7.632242679596 51.5486717224122,7.63381052017218 51.5455398559571,7.62869977951055 51.5418319702148,7.63218545913708 51.5419692993165,7.63125705718994 51.5395011901856,7.63210153579718 51.5373153686524,7.63793277740479 51.5276260375978,7.63568735122681 51.5268325805665,7.63711595535284 51.5231399536133,7.63123846054071 51.5211143493652,7.63198375701916 51.5202751159669,7.63198375701916 51.5202751159669,7.61731100082403 51.5176849365235,7.59656190872192 51.5091972351075,7.59792852401739 51.497184753418,7.59615421295166 51.4967384338379,7.60029268264782 51.4910507202148,7.60227441787725 51.4907302856445,7.60848617553717 51.479190826416,7.60450220108032 51.4762268066406,7.60450220108032 51.4762268066406,7.59446573257446 51.4691886901857,7.58529138565069 51.4651985168458,7.5836186408996 51.4688415527344,7.58133459091192 51.4689369201661,7.57911205291754 51.4712409973145,7.57749223709118 51.4708671569825,7.57451295852673 51.4741859436035,7.57206583023077 51.475025177002,7.56309843063349 51.4709663391113,7.55313444137585 51.4696464538574,7.54630088806152 51.4662895202637,7.54597282409674 51.4642181396484,7.5426545143128 51.4627189636232,7.54222822189331 51.4612617492676,7.54494667053228 51.4606819152832,7.5507221221925 51.455810546875,7.54400634765636 51.4540214538574,7.53867053985596 51.4511680603028,7.53613471984863 51.4482574462891,7.53251028060924 51.4383430480957,7.53119373321533 51.4375381469727,7.52885913848888 51.4364318847657,7.52658128738398 51.4373474121094,7.52136039733892 51.4345512390137,7.51166677474981 51.4323158264161,7.50912666320812 51.4279632568359,7.50578832626343 51.4268074035645,7.50955724716187 51.4213485717774,7.50845289230341 51.4179420471191,7.50845289230341 51.4179420471191,7.50291728973389 51.4179840087892,7.49498176574713 51.4155807495117,7.48508501052862 51.4176788330078,7.46533250808727 51.416072845459,7.46533250808727 51.416072845459,7.46414995193487 51.4228591918946,7.46584224700928 51.4244956970215,7.46316289901745 51.4275512695312,7.46353960037237 51.429039001465,7.46797132492077 51.4295501708985,7.46888208389282 51.4305877685546,7.46771192550665 51.4347915649413,7.46377086639416 51.434913635254,7.46167516708368 51.4369773864746,7.45541000366222 51.4371643066407,7.44220447540289 51.4346961975097,7.43914365768433 51.4354476928712,7.43333148956293 51.4344673156739,7.43163490295416 51.4352798461915,7.42362356185907 51.4329338073732,7.42362356185907 51.4329338073732,7.42235898971558 51.4380416870117,7.41945552825922 51.4400939941407,7.41892242431641 51.4439582824708,7.41581296920788 51.4471282958986,7.41494226455694 51.4504356384278,7.39937353134161 51.4584007263184,7.39380502700806 51.4582557678223,7.39082622528082 51.4624366760254,7.38859558105469 51.4634475708008,7.39025592803955 51.4661750793457,7.38873910903936 51.4666481018067,7.38902759552013 51.4738769531251,7.38077974319452 51.4787559509277,7.37179136276239 51.476490020752,7.37109470367432 51.4780387878418,7.37244367599482 51.4802551269532,7.37134790420544 51.4825744628907,7.36273384094238 51.480525970459,7.35800075531017 51.4807815551758,7.35415506362915 51.4838638305664,7.34993839263916 51.4835014343263,7.35002851486212 51.4821929931641,7.34819412231457 51.4826698303223))0.0006POINT(7.463668439699289 51.517535566247034)
29621POLYGON((3.66660928726208 47.8420639038087,3.64785742759705 47.8380928039551,3.6451895236969 47.835262298584,3.65011763572704 47.8294334411621,3.65011763572704 47.8294334411621,3.65883135795593 47.8261337280273,3.6611704826355 47.819694519043,3.66834378242504 47.8152084350585,3.68798804283148 47.8163642883301,3.68798804283148 47.8163642883301,3.68971490859991 47.8227882385254,3.70513367652899 47.8356018066407,3.70764422416687 47.8454627990723,3.70764422416687 47.8454627990723,3.7069132328034 47.8457794189453,3.7069132328034 47.8457794189453,3.66660928726208 47.8420639038087))0.0006POINT(3.678011044859937 47.83180785179139)
34352POLYGON((5.46277952194214 47.733425140381,5.46539354324347 47.7307739257812,5.45989418029797 47.7180595397949,5.44229364395136 47.7119522094727,5.4230256080628 47.7151374816896,5.4230256080628 47.7151374816896,5.43177366256725 47.7217521667481,5.43141937255871 47.7277297973633,5.43141937255871 47.7277297973633,5.44813680648815 47.7334136962891,5.46277952194214 47.733425140381))0.0006POINT(5.441916131973335 47.723511123657275)
56419POLYGON((4.68749904632574 45.5582084655762,4.69218015670776 45.5582542419434,4.69546413421637 45.5708847045898,4.68665695190435 45.573097229004,4.68621826171886 45.5763854980469,4.68621826171886 45.5763854980469,4.70446062088024 45.571949005127,4.71278762817388 45.5741539001466,4.71278762817388 45.5741539001466,4.72569704055798 45.5735702514648,4.72569704055798 45.5735702514648,4.72347259521484 45.5671920776368,4.6978693008424 45.5564651489258,4.69250202178955 45.5507354736329,4.69250202178955 45.5507354736329,4.68517637252813 45.5547561645509,4.68517637252813 45.5547561645509,4.68749904632574 45.5582084655762))0.0006POINT(4.699550909154618 45.56560314402866)
28127POLYGON((4.90612316131597 47.1643180847169,4.90389490127563 47.1618003845216,4.90760183334362 47.1564865112305,4.90760183334362 47.1564865112305,4.91224241256725 47.1559333801269,4.91664743423468 47.1502418518066,4.9125657081604 47.144588470459,4.9125657081604 47.144588470459,4.92600250244135 47.1349830627441,4.92521333694469 47.1250915527345,4.92521333694469 47.1250915527345,4.9517712593078 47.1151695251465,4.9517712593078 47.1151695251465,4.96535539627087 47.1208496093751,4.96535539627087 47.1208496093751,4.97937250137323 47.1367950439453,4.97937250137323 47.1367950439453,4.96659803390509 47.1473045349122,4.96147298812866 47.1479415893555,4.96147298812866 47.1479415893555,4.95221662521357 47.1496734619141,4.95092058181763 47.1561698913574,4.94203472137457 47.1587142944336,4.93691015243525 47.1641693115235,4.93744611740118 47.1706275939941,4.93744611740118 47.1706275939941,4.93393707275396 47.1784477233886,4.93393707275396 47.1784477233886,4.92449522018433 47.1792449951173,4.92013597488409 47.1881141662599,4.92013597488409 47.1881141662599,4.9097056388855 47.1756172180176,4.9097056388855 47.1756172180176,4.91063928604132 47.1695404052736,4.90612316131597 47.1643180847169))0.0006POINT(4.934055314344548 47.15328093136063)