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
24073POLYGON((3.1031260490418 44.884635925293,3.11951589584351 44.8915405273438,3.12838411331177 44.9035797119141,3.12838411331177 44.9035797119141,3.11987781524658 44.9187049865723,3.10852885246277 44.9214172363281,3.10587286949163 44.9309082031251,3.10587286949163 44.9309082031251,3.08967995643621 44.9184532165527,3.0848507881164 44.9177284240723,3.07675886154175 44.9216499328614,3.07675886154175 44.9216499328614,3.07226085662847 44.9224472045899,3.06484270095831 44.9185256958007,3.06146955490107 44.916286468506,3.06195664405817 44.9099388122559,3.05340218544012 44.9074935913086,3.05340218544012 44.9074935913086,3.05999779701239 44.9026260375977,3.06923174858093 44.9015426635742,3.07076048851025 44.8983345031739,3.07076048851025 44.8983345031739,3.09057116508495 44.8896408081055,3.09413242340094 44.8834342956544,3.1031260490418 44.884635925293))0.0006POINT(3.0862666368484812 44.90920225779218)
12464POLYGON((13.614146232605 42.2965927124024,13.6172780990601 42.2948265075685,13.6169786453247 42.2907333374025,13.61851978302 42.2873992919922,13.6549663543701 42.2754402160645,13.6600666046143 42.2698783874511,13.6653556823732 42.2674484252931,13.6653556823732 42.2674484252931,13.6603288650513 42.2603950500488,13.6469850540162 42.2505836486818,13.6441822052002 42.2516860961914,13.635690689087 42.2509765625001,13.635690689087 42.2509765625001,13.6259231567383 42.2548446655274,13.622088432312 42.2544288635253,13.6163749694824 42.2562255859376,13.6004180908204 42.2712135314941,13.5844745635986 42.2792854309082,13.5790739059449 42.2799835205079,13.5790739059449 42.2799835205079,13.5770244598389 42.2843589782716,13.5776681900025 42.286979675293,13.5825805664063 42.2923431396484,13.5860137939454 42.292808532715,13.587766647339 42.3007316589357,13.587766647339 42.3007316589357,13.5986242294312 42.2958450317383,13.6097383499146 42.2951736450195,13.614146232605 42.2965927124024))0.0006POINT(13.616076946258598 42.2764043807984)
21699POLYGON((0.669110000133571 44.9993896484374,0.663352370262203 44.9946746826172,0.663352370262203 44.9946746826172,0.659970998764038 44.9923515319825,0.661145865917319 44.9858016967775,0.654938638210353 44.9809608459474,0.654938638210353 44.9809608459474,0.651129662990684 44.9676742553712,0.651129662990684 44.9676742553712,0.663316190242881 44.962371826172,0.663851797580719 44.9528732299805,0.663851797580719 44.9528732299805,0.676983416080532 44.9549598693848,0.676983416080532 44.9549598693848,0.686907708644981 44.964080810547,0.695376276969967 44.9654846191406,0.695376276969967 44.9654846191406,0.694918811321315 44.9793815612794,0.68454426527029 44.9911918640137,0.669110000133571 44.9993896484374))0.0006POINT(0.6700620086570164 44.97409599705752)
18466MULTIPOLYGON(((9.31538677215582 41.1736793518068,9.30783939361572 41.170726776123,9.27972221374512 41.1684150695801,9.2255392074585 41.1498298645021,9.2255392074585 41.1498298645021,9.23558998107916 41.1446113586426,9.22552680969244 41.1428680419923,9.21470355987555 41.1455459594728,9.20566272735596 41.138786315918,9.20298004150396 41.1356811523437,9.20298004150396 41.1356811523437,9.20805263519293 41.1334609985352,9.21138858795172 41.130039215088,9.21102428436285 41.1275825500488,9.2143287658692 41.1253242492676,9.22098159790045 41.1237602233886,9.23320484161383 41.1239891052246,9.24661254882818 41.1129264831543,9.26032161712652 41.1100959777833,9.26679897308355 41.1126403808594,9.26934623718273 41.1151657104493,9.27226638793951 41.1156692504883,9.29256057739269 41.1073722839355,9.29897499084484 41.1035156250001,9.30069160461437 41.101432800293,9.30069160461437 41.101432800293,9.30134391784674 41.1061134338379,9.30550765991222 41.1153984069824,9.30687236785883 41.132022857666,9.30861473083507 41.1379928588867,9.31251239776611 41.1432037353516,9.31251239776611 41.1432037353516,9.31523513793957 41.1470184326172,9.31748104095459 41.1530990600586,9.31735134124762 41.1607208251953,9.31387710571295 41.1670265197755,9.31538677215582 41.1736793518068)),((9.00637912750256 40.81298828125,8.99300479888922 40.8088645935059,8.99300479888922 40.8088645935059,8.98951053619385 40.8102912902833,8.98951053619385 40.8102912902833,8.98857021331793 40.8131446838379,8.990312576294 40.8162498474122,8.99920558929449 40.8228645324708,9.00506401062012 40.8245010375977,9.00422191619873 40.8294944763184,9.00175476074224 40.8322868347169,9.00175476074224 40.8322868347169,9.04939746856701 40.8651199340821,9.06016445159906 40.8702392578125,9.06229209899902 40.8872985839845,9.06632423400873 40.8957023620605,9.06625556945806 40.9107818603517,9.06625556945806 40.9107818603517,9.06760120391846 40.9135932922363,9.07506179809576 40.9174613952637,9.08585834503168 40.9277687072754,9.09055328369141 40.9388427734374,9.08724689483643 40.9455947875977,9.07973384857183 40.9508666992188,9.06993579864508 40.9548568725585,9.04903507232672 40.9695854187013,9.05281734466558 40.978630065918,9.06529521942144 40.9961700439454,9.06529521942144 40.9961700439454,9.07966327667242 41.0012397766114,9.10829067230225 41.0282058715821,9.10829067230225 41.0282058715821,9.11651325225841 41.0263137817383,9.11824035644537 41.0240516662598,9.12077903747553 41.0141067504883,9.12422657012939 41.0137786865236,9.13055801391607 41.016040802002,9.14043140411377 41.0169181823732,9.14302158355713 41.0161437988281,9.14514827728277 41.009349822998,9.14514827728277 41.009349822998,9.13585853576666 41.002513885498,9.1292085647583 41.0009002685547,9.12311363220215 40.984287261963,9.11887359619152 40.9665908813477,9.12856101989757 40.9611396789551,9.13420200347895 40.9534912109376,9.13661289215094 40.9415092468262,9.13620853424078 40.9358634948732,9.14540386199957 40.9362030029297,9.15961074829113 40.9317970275879,9.1625022888183 40.9286384582519,9.16173076629633 40.9242973327637,9.16372585296625 40.9220046997071,9.16372585296625 40.9220046997071,9.16147041320812 40.9120826721191,9.1624803543092 40.9051475524903,9.16389846801758 40.9023513793946,9.1682071685791 40.8974342346192,9.17719936370855 40.8948822021485,9.19035243988043 40.8744506835938,9.18750762939459 40.8548431396485,9.18750762939459 40.8548431396485,9.17346000671387 40.8496932983399,9.14296531677246 40.8409004211425,9.13458061218262 40.8359184265138,9.11539936065685 40.834156036377,9.10318279266357 40.8108558654786,9.08975887298584 40.7996864318849,9.08975887298584 40.7996864318849,9.10838317871105 40.8227500915528,9.08456325531 40.8343276977539,9.0727329254151 40.8289222717285,9.05691432952875 40.8304252624512,9.05178737640381 40.8261833190919,9.00637912750256 40.81298828125)),((9.73652935028082 40.9270820617677,9.73624897003185 40.9245834350586,9.73236083984375 40.9204216003419,9.7279167175293 40.9204177856446,9.72958278656017 40.9234733581544,9.73652935028082 40.9270820617677)),((9.73430538177496 40.9187507629395,9.73791694641108 40.9209709167482,9.73958110809332 40.9204177856446,9.74152755737316 40.9168052673339,9.74125003814703 40.914031982422,9.74291801452648 40.9126396179199,9.74263763427729 40.9115295410157,9.73402690887457 40.9090270996095,9.73152923583996 40.9093055725098,9.72291564941412 40.90625,9.72235965728765 40.9051399230958,9.7198600769043 40.9048614501954,9.71541976928722 40.9026374816896,9.71402835845959 40.9006958007812,9.71263980865484 40.9009704589844,9.70902919769281 40.8973617553712,9.69930744171143 40.8912506103516,9.6976375579834 40.8893051147461,9.69375038146978 40.8879203796387,9.69124984741211 40.8884735107423,9.68680572509766 40.8909721374512,9.68402957916265 40.8940315246583,9.6787509918214 40.8931999206543,9.67597103118902 40.8906936645508,9.67375087738031 40.8912506103516,9.67708301544201 40.8937492370605,9.68124866485601 40.8943061828613,9.68263912200933 40.8959732055664,9.68402671813959 40.895694732666,9.68402671813959 40.8948593139649,9.68652725219727 40.8954162597656,9.69235992431646 40.9012489318848,9.70291709899897 40.9059715270996,9.71846961975098 40.9151420593262,9.72208213806158 40.9154167175294,9.72735977172857 40.9195823669434,9.73430538177496 40.9187507629395)),((9.65236091613775 40.8895797729493,9.65569305419922 40.8879165649413,9.65402698516857 40.8870849609376,9.65069484710693 40.8873596191406,9.64986133575434 40.886531829834,9.64736080169683 40.8879165649413,9.65013885498047 40.8890266418457,9.65013885498047 40.8898620605469,9.65236091613775 40.8895797729493)),((9.64153003692627 40.8865280151368,9.64152812957769 40.8851394653321,9.63958168029791 40.8840293884277,9.63902759552002 40.8859710693361,9.64153003692627 40.8865280151368)),((9.58453273773193 40.7868690490724,9.57797718048096 40.7934226989746,9.57600402832037 40.7935447692872,9.53283214569097 40.7930030822755,9.52346420288092 40.7909202575683,9.52119922637945 40.7877426147462,9.50366306304926 40.8034515380859,9.50366306304926 40.8034515380859,9.48475837707531 40.8225212097169,9.47947692871094 40.8268661499025,9.47196388244635 40.830997467041,9.45578956604015 40.8329887390137,9.43940734863281 40.8323783874512,9.43236827850336 40.8368453979492,9.43236827850336 40.8368453979492,9.4292716979981 40.8405036926271,9.42480278015148 40.8428802490236,9.40402507781982 40.8511276245117,9.40402507781982 40.8511276245117,9.50413608551031 40.8571624755861,9.540205001831 40.860279083252,9.55095481872559 40.8633079528809,9.55758476257324 40.8672218322753,9.56338119506847 40.8692054748536,9.56932163238525 40.8701553344728,9.57705688476574 40.8698844909667,9.59469318389904 40.8728828430177,9.62816810607916 40.8831939697266,9.62816810607916 40.8831939697266,9.62902736663824 40.8848609924317,9.63041687011724 40.8851394653321,9.63569355010998 40.8843040466309,9.63569355010998 40.8829154968262,9.63652992248541 40.8826370239258,9.63596916198725 40.8812484741211,9.63680553436291 40.880973815918,9.63624954223644 40.8790283203126,9.63791561126709 40.8781929016114,9.63930606842041 40.8787498474122,9.63902759552002 40.873748779297,9.64069366455084 40.873748779297,9.64041614532476 40.8720817565919,9.64319229125977 40.8723602294922,9.64458465576166 40.8748626708985,9.64625072479248 40.8751411437989,9.64708232879644 40.8768043518066,9.64930534362787 40.8768043518066,9.64930725097668 40.8776397705078,9.64625072479248 40.8781929016114,9.64597034454351 40.8798599243165,9.64763927459722 40.880973815918,9.65097141265869 40.8793106079103,9.65347099304211 40.8798599243165,9.65430545806896 40.8779182434082,9.65319347381603 40.8773612976074,9.65458297729504 40.8762512207032,9.65375137329107 40.8751411437989,9.65930843353271 40.8754158020019,9.65958118438715 40.873748779297,9.65652656555176 40.8731956481934,9.65347099304211 40.8701400756837,9.65430545806896 40.868751525879,9.65319538116461 40.8681945800782,9.6551389694215 40.8676376342775,9.6551389694215 40.8645820617676,9.65319538116461 40.863193511963,9.65291690826422 40.8609733581543,9.65180492401129 40.8609733581543,9.65291690826422 40.8598594665528,9.65152740478516 40.858196258545,9.65152740478516 40.8573608398439,9.65319538116461 40.8573608398439,9.65347099304211 40.8565292358399,9.64930534362787 40.8559722900391,9.65430736541754 40.8540267944336,9.65568828582775 40.854030609131,9.65652656555176 40.8556938171387,9.65902709960943 40.8565292358399,9.66403007507324 40.8562507629395,9.66451644897455 40.8554153442383,9.66451644897455 40.8554153442383,9.66232013702393 40.8510856628419,9.65162467956543 40.8371200561525,9.64343070983887 40.8226013183594,9.63728713989258 40.8187141418458,9.61869621276861 40.811149597168,9.59269237518316 40.7978096008301,9.58453273773193 40.7868690490724)),((9.67208003997803 40.8787498474122,9.67291641235346 40.8768043518066,9.67013835906988 40.8776397705078,9.67208003997803 40.8787498474122)),((9.72958278656017 40.8765258789062,9.73152923583996 40.8751373291015,9.73791694641108 40.8748626708985,9.74013996124268 40.8720817565919,9.74152755737316 40.8720817565919,9.74291801452648 40.8704185485841,9.7398624420166 40.8654212951661,9.7398624420166 40.8645820617676,9.74069309234631 40.864860534668,9.74013996124268 40.8618087768555,9.73791694641108 40.8612518310547,9.73736095428461 40.8595848083496,9.73236083984375 40.8590316772462,9.72597026824951 40.8620796203613,9.72541618347162 40.863193511963,9.71485900878912 40.8654212951661,9.71069335937506 40.8676414489746,9.71097087860113 40.8706932067871,9.71374893188477 40.8726387023926,9.71402835845959 40.8745841979981,9.71597194671631 40.8762512207032,9.71930599212658 40.8762512207032,9.72013759613037 40.8754158020019,9.72180557250977 40.8759727478028,9.72375011444097 40.8748588562012,9.72652912139887 40.8754158020019,9.72680664062494 40.8765258789062,9.72958278656017 40.8765258789062)),((9.77875041961664 40.8751373291015,9.77902793884277 40.8743057250977,9.77791595458979 40.8734741210938,9.77735996246332 40.8745841979981,9.77875041961664 40.8751373291015)))0.0006POINT(9.514612255889682 40.87969374413165)
40241POLYGON((1.85260784626018 45.0406494140625,1.8644313812257 45.0482177734374,1.8644313812257 45.0482177734374,1.85089457035059 45.0572891235352,1.85089457035059 45.0572891235352,1.82982826232922 45.0719566345216,1.82065641880047 45.0748023986818,1.81126511096949 45.0909309387208,1.81126511096949 45.0909309387208,1.80286729335791 45.0924720764161,1.79521203041077 45.089614868164,1.79521203041077 45.089614868164,1.80074000358582 45.0648040771486,1.80074000358582 45.0648040771486,1.81240844726574 45.045467376709,1.81240844726574 45.045467376709,1.81992244720459 45.0433235168458,1.82595384120947 45.0355453491212,1.82595384120947 45.0355453491212,1.83370530605316 45.0395965576173,1.85260784626018 45.0406494140625))0.0006POINT(1.8240699172020343 45.06132698059087)
16430POLYGON((9.28823089599615 44.9566307067871,9.28550052642822 44.9536705017091,9.28550052642822 44.9536705017091,9.28487968444824 44.9512672424316,9.28664779663097 44.9497985839843,9.29846477508556 44.9430313110352,9.30082321166992 44.9431266784669,9.31085872650152 44.9363670349121,9.31085872650152 44.9363670349121,9.31557178497314 44.9377670288087,9.32286262512201 44.9450454711914,9.32399654388428 44.9505996704102,9.32399654388428 44.9505996704102,9.32086277008062 44.9501724243165,9.28823089599615 44.9566307067871))0.0006POINT(9.304218224116763 44.94700813293461)
37164POLYGON((6.99764394760138 47.4649467468262,7.00003623962402 47.4643478393555,6.998209476471 47.4516410827637,6.98985242843628 47.4480972290039,6.97028303146368 47.4470520019532,6.97028303146368 47.4470520019532,6.97125720977789 47.4490852355958,6.97125720977789 47.4490852355958,6.99176406860346 47.4664192199708,6.99176406860346 47.4664192199708,6.99764394760138 47.4649467468262))0.0006POINT(6.985235071182274 47.455414581298896)
15336POLYGON((9.92003440856934 45.9568328857423,9.92316722869873 45.9613265991211,9.92570972442627 45.972194671631,9.92489147186279 45.9772605895996,9.92193126678472 45.981731414795,9.91870307922375 45.9933586120607,9.91870307922375 45.9933586120607,9.91624069213879 45.9991188049318,9.91263294219976 46.0011825561523,9.90728664398199 46.0019989013672,9.89663600921637 46.0069694519043,9.89406681060802 46.0102996826172,9.88748168945318 46.0128555297852,9.88748168945318 46.0128555297852,9.88092327117926 46.0097541809083,9.8749418258667 46.0096855163574,9.8657865524292 46.0115280151368,9.8565940856933 46.0109672546387,9.84858131408691 46.0081176757813,9.84284973144537 46.0032463073731,9.84284973144537 46.0032463073731,9.8411483764649 45.9931983947755,9.82931613922119 45.9911499023438,9.82639789581305 45.9885978698732,9.8258628845216 45.9846954345704,9.8258628845216 45.9846954345704,9.83263778686529 45.9827919006348,9.83994102478033 45.9791297912598,9.83893775939947 45.9776992797852,9.8549165725708 45.9641227722169,9.87932300567621 45.9609222412109,9.89233493804943 45.9627761840821,9.90597152709972 45.9601936340333,9.91445064544672 45.9563102722169,9.92003440856934 45.9568328857423))0.0006POINT(9.878664549659325 45.98894624149102)
73190POLYGON((9.6727876663208 47.3068084716797,9.66204452514643 47.3135070800782,9.66204452514643 47.3135070800782,9.66898441314709 47.3260612487794,9.66898441314709 47.3260612487794,9.7147798538208 47.3363418579102,9.7147798538208 47.3363418579102,9.7220659255982 47.343620300293,9.7220659255982 47.343620300293,9.73100090026855 47.3245277404786,9.73100090026855 47.3245277404786,9.6727876663208 47.3068084716797))0.0006POINT(9.69732171838936 47.32681135697805)
23204POLYGON((-0.451441109180394 43.1623191833497,-0.443942695856094 43.1784744262695,-0.434273093938771 43.1859245300294,-0.433478891849518 43.1928443908691,-0.420986235141754 43.2027702331542,-0.422304421663284 43.206111907959,-0.422304421663284 43.206111907959,-0.455253005027714 43.1917114257813,-0.46809059381485 43.1731185913086,-0.46809059381485 43.1731185913086,-0.468494147062302 43.1673431396486,-0.468494147062302 43.1673431396486,-0.451441109180394 43.1623191833497))0.0006POINT(-0.446429446339593 43.1839326222738)