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.

Spaltenname	Datentyp	Mögliche Werte	Beschreibung
id_ort	int(10) unsigned	beliebig	Fremdschlü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"	beliebig	Die simplifizierten Geodaten.
epsilon	float(5,4)	beliebig	Die 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"	beliebig	Der geometrische Mittelpunkt des vereinfachten Polygons.

Ausschnitt

id_ort	geodaten	epsilon	mittelpunkt
73893	MULTIPOLYGON(((17.3161392211913 42.9976387023926,17.3129749298096 42.9901313781738,17.3092365264893 42.9870719909668,17.3048973083497 42.9865188598634,17.2940177917481 42.9895095825196,17.2905731201171 42.989631652832,17.2815055847169 42.9842147827149,17.2775230407714 42.9797897338868,17.2665691375732 42.9781494140626,17.2578907012939 42.9815711975098,17.2319965362549 42.9892463684083,17.2165470123292 42.9923629760743,17.2083053588868 42.9968109130861,17.1907520294189 42.9983901977538,17.1621170043946 42.9948616027831,17.1561927795411 42.9954719543457,17.1468791961671 43.0016326904296,17.1386661529541 43.0054740905762,17.1287364959718 43.0234718322753,17.1287364959718 43.0234718322753,17.1368045806885 43.0243072509767,17.1395835876466 43.0254173278809,17.1454162597657 43.0248603820801,17.1464843750001 43.0236816406251,17.1540298461914 43.0254173278809,17.1593055725098 43.0234718322753,17.1695785522462 43.0250892639161,17.1718063354492 43.0245819091797,17.1748619079591 43.0218048095704,17.1812744140626 43.0227050781251,17.1829166412354 43.0204162597657,17.1887493133545 43.0204162597657,17.2004165649414 43.0176391601564,17.2079162597657 43.0187492370605,17.2120838165283 43.0170822143554,17.2165279388427 43.017360687256,17.2290287017822 43.0154151916505,17.2351398468018 43.0156936645509,17.2401123046876 43.0148925781251,17.2434730529786 43.0131950378418,17.24680519104 43.0131950378418,17.2473583221436 43.0120849609376,17.2542724609376 43.0120849609376,17.2623615264894 43.0090293884277,17.2665271759034 43.009304046631,17.2687492370605 43.0112915039063,17.2706909179689 43.0112915039063,17.2748584747314 43.0106925964355,17.2770824432374 43.0090293884277,17.280138015747 43.008472442627,17.2823619842529 43.0068054199219,17.2826385498047 43.0045814514161,17.2854156494142 43.0031929016114,17.2873611450195 43.0059738159181,17.2912483215331 43.0056800842286,17.2970829010011 43.0034713745118,17.3029174804688 43.0026855468751,17.308750152588 43.000415802002,17.3098602294922 42.998748779297,17.3161392211913 42.9976387023926)),((17.1995811462403 43.0206909179689,17.200138092041 43.0184707641602,17.1979160308839 43.0190277099609,17.1979160308839 43.0201377868653,17.1995811462403 43.0206909179689)))	0.0006	POINT(17.23136961007277 43.0073930514404)
27358	POLYGON((-1.53274345397949 49.0761451721192,-1.54746842384327 49.0745964050293,-1.54838562011713 49.0644302368165,-1.55664849281305 49.0601997375489,-1.55664849281305 49.0601997375489,-1.57223153114319 49.0577163696289,-1.6054160594939 49.0611381530763,-1.6054160594939 49.0611381530763,-1.60652804374695 49.0679168701173,-1.60458397865295 49.0695838928222,-1.60152804851532 49.0695838928222,-1.6004159450531 49.0715293884277,-1.60374999046326 49.0743064880372,-1.60597205162048 49.0743064880372,-1.60763800144196 49.0729179382325,-1.60902798175812 49.0737495422364,-1.61013805866236 49.0768051147462,-1.61041605472559 49.083625793457,-1.61041605472559 49.083625793457,-1.55572581291193 49.0843162536621,-1.55572581291193 49.0843162536621,-1.5274121761322 49.0814971923828,-1.5274121761322 49.0814971923828,-1.53274345397949 49.0761451721192))	0.0006	POINT(-1.5809412313543882 49.07239748084031)
1398872	POLYGON((-3.81944394111628 42.3293113708497,-3.82254290580744 42.3286743164064,-3.82267308235157 42.3274497985841,-3.82417011260981 42.3278350830078,-3.82223606109619 42.3311157226563,-3.82755708694458 42.3343391418458,-3.8265500068664 42.3370399475098,-3.82995510101313 42.3367004394532,-3.82407689094538 42.3428688049317,-3.82718610763544 42.3429336547852,-3.8273611068725 42.3443565368653,-3.83966588973999 42.3467254638672,-3.85564088821405 42.3455429077148,-3.8607280254364 42.3483428955079,-3.85717701911921 42.3469276428224,-3.84569501876825 42.3498878479004,-3.8359220027923 42.3572998046876,-3.83069300651545 42.356803894043,-3.8318989276886 42.3615951538086,-3.82966995239252 42.3667640686036,-3.82549905776978 42.368953704834,-3.82431197166443 42.3656311035157,-3.81500411033625 42.3632278442384,-3.80728197097773 42.3671760559082,-3.79684591293335 42.3784408569337,-3.79092001914972 42.3747291564943,-3.79394507408136 42.3707084655762,-3.788733959198 42.3668365478517,-3.78148198127747 42.3639144897462,-3.79430007934565 42.3584938049317,-3.79236698150635 42.3554840087891,-3.79941511154175 42.3415184020997,-3.80123591423029 42.3404159545898,-3.80151391029352 42.3423767089844,-3.80392503738403 42.3410835266113,-3.81350207328791 42.3334770202637,-3.81523394584656 42.3293838500977,-3.81944394111628 42.3293113708497))	0.0006	POINT(-3.819090817425665 42.34930718911666)
60046	POLYGON((9.08585166931164 46.9272460937501,9.09428310394298 46.9335441589355,9.09466457366955 46.9387702941895,9.09667301177979 46.9427947998046,9.09677505493164 46.9457359313966,9.09569454193115 46.9488525390626,9.09249305725098 46.9520339965821,9.08336639404303 46.957160949707,9.08313083648682 46.9645843505859,9.08002090454107 46.972785949707,9.08110713958752 46.9771194458007,9.07507610321056 46.9813156127929,9.07026290893555 46.9922714233399,9.06715869903559 46.9925117492676,9.06457328796387 46.9897575378419,9.06423473358166 46.9875793457032,9.06238174438471 46.9870986938477,9.05791854858404 46.9905891418457,9.05381011962896 46.9915733337402,9.04922199249279 46.9911270141602,9.04520988464367 46.9960174560547,9.04082775115967 46.9975090026856,9.03727912902838 46.9967842102051,9.0323686599732 46.9921340942384,9.0323686599732 46.9921340942384,9.03345394134516 46.9898490905762,9.0331211090089 46.9877738952637,9.02873229980469 46.9853820800781,9.02433776855469 46.9846115112305,9.0242071151734 46.9818382263184,9.02773666381842 46.9783401489258,9.03518772125256 46.9749832153321,9.03961753845221 46.9737358093263,9.04742145538336 46.9737663269044,9.04968166351318 46.9702339172364,9.0581378936767 46.966438293457,9.06326198577881 46.9628448486328,9.06523799896246 46.960075378418,9.06602191925043 46.9569091796874,9.06982707977295 46.9534645080567,9.06811237335199 46.9524383544922,9.06561470031738 46.9545249938964,9.06361579895031 46.9540367126465,9.06233406066889 46.9522323608399,9.06272792816168 46.9489479064943,9.07616519927984 46.9402275085449,9.07842731475824 46.9355697631836,9.07783412933355 46.9315643310547,9.08174133300776 46.9285507202148,9.08585166931164 46.9272460937501))	0.0006	POINT(9.062026724523461 46.96810959796518)
55295	POLYGON((5.9413042068482 45.8847999572754,5.92470407485973 45.8863677978516,5.92470407485973 45.8863677978516,5.91759252548223 45.8817024230957,5.92568922042858 45.8730850219727,5.91215181350708 45.8556480407716,5.91163063049316 45.8421096801758,5.91163063049316 45.8421096801758,5.92897748947138 45.846103668213,5.9384765625 45.8390159606934,5.93960857391369 45.8324356079102,5.93960857391369 45.8324356079102,5.96564197540283 45.8248901367187,5.96564197540283 45.8248901367187,5.96236610412598 45.8378143310548,5.97225189208984 45.8449440002442,5.97225189208984 45.8449440002442,5.961829662323 45.8578453063965,5.961829662323 45.8578453063965,5.96336841583252 45.8610382080079,5.94814395904552 45.8688964843751,5.9413042068482 45.8847999572754))	0.0006	POINT(5.9423525674002855 45.85358519781208)
70200	MULTIPOLYGON(((10.2424688339235 53.7060852050781,10.242325782776 53.7047042846681,10.242325782776 53.7047042846681,10.2369346618652 53.7048797607423,10.2387418746949 53.7038879394532,10.2395257949829 53.7019653320313,10.2385129928589 53.7017478942872,10.2358026504517 53.704158782959,10.2334899902344 53.7035789489747,10.2286977767945 53.7047615051271,10.2285642623901 53.7066841125489,10.2344198226929 53.7049446105958,10.2424688339235 53.7060852050781)),((10.2217617034912 53.6337242126465,10.2317390441896 53.6337699890137,10.2317390441896 53.6337699890137,10.2406902313233 53.6335029602051,10.2406902313233 53.6335029602051,10.2424354553224 53.6348533630371,10.2423315048217 53.6371192932129,10.2454013824464 53.6369895935059,10.2460536956788 53.6391487121583,10.2473993301392 53.6392402648926,10.2485866546632 53.6378860473633,10.2535724639893 53.6384696960449,10.2544393539429 53.6375007629395,10.2543067932129 53.639533996582,10.2574214935303 53.6395759582521,10.2562065124512 53.6432762145996,10.2651481628417 53.642303466797,10.2660636901857 53.640724182129,10.2752418518068 53.6377220153809,10.2742643356324 53.6397399902344,10.2783288955689 53.6402244567871,10.2780380249023 53.6408538818359,10.2780380249023 53.6408538818359,10.2771186828614 53.6431884765626,10.2688331604004 53.6459312438965,10.2684173583985 53.6473503112794,10.2616090774536 53.6479644775391,10.26224899292 53.6498260498047,10.258581161499 53.6513557434083,10.2559509277344 53.6510543823243,10.2561855316163 53.6550903320314,10.2579746246338 53.6542930603027,10.2543191909791 53.6589660644531,10.25182056427 53.6646766662598,10.2582178115844 53.6677360534669,10.2578392028809 53.6706008911133,10.2561922073365 53.6728630065919,10.2621479034424 53.6739501953126,10.2835779190063 53.6733512878417,10.2814331054689 53.6754264831544,10.2816667556763 53.6773033142091,10.2785844802856 53.6792030334474,10.2782754898071 53.6804161071777,10.2806758880615 53.6817321777344,10.2801847457885 53.6830139160156,10.2820386886597 53.6845550537109,10.285698890686 53.6850624084473,10.2968702316285 53.6814422607423,10.2969284057617 53.6787223815918,10.3001966476442 53.6820869445802,10.2995262145996 53.6831207275392,10.3021907806396 53.6862869262695,10.3075561523439 53.6879844665528,10.3080663681031 53.6891708374024,10.3120765686035 53.6893653869628,10.3120765686035 53.6893653869628,10.3118906021119 53.6902618408203,10.3142251968384 53.6931495666505,10.3132266998291 53.6963768005372,10.3147678375245 53.6972045898438,10.3147678375245 53.6972045898438,10.3125190734863 53.6991043090821,10.309871673584 53.6986351013184,10.3039770126343 53.6996574401857,10.3019971847534 53.6988716125489,10.2984495162965 53.7000083923341,10.2969388961793 53.7025413513184,10.2974786758424 53.7037162780762,10.2974786758424 53.7037162780762,10.2896299362183 53.70467376709,10.2814788818359 53.7026824951172,10.2779331207275 53.703182220459,10.2794570922852 53.6982612609864,10.2809600830079 53.6973915100098,10.2834033966064 53.6932373046876,10.282862663269 53.6922454833985,10.262882232666 53.6947441101074,10.2509069442748 53.6923217773437,10.2506771087648 53.6901626586915,10.2429342269897 53.6888275146485,10.2433099746705 53.6918640136719,10.2393426895142 53.6920623779297,10.2399244308473 53.6961097717285,10.2399244308473 53.6961097717285,10.2405185699463 53.698040008545,10.238094329834 53.7008476257324,10.2261972427368 53.7002487182618,10.2246742248536 53.6969375610352,10.2280836105348 53.6963272094726,10.2284994125367 53.6952667236329,10.2263307571411 53.6958618164063,10.2229537963867 53.6935653686524,10.2330875396729 53.6901741027832,10.229856491089 53.6888008117675,10.2266006469727 53.6890258789064,10.2283868789673 53.6865158081055,10.2275123596192 53.6859741210939,10.2146072387696 53.685173034668,10.2160902023317 53.6782569885255,10.2060689926149 53.676456451416,10.197943687439 53.6762924194337,10.1970119476319 53.6797752380372,10.1955184936524 53.6790809631348,10.1894845962525 53.6806640625001,10.1862077713012 53.6796493530274,10.1805143356324 53.6800842285157,10.1757564544678 53.6788215637208,10.1729955673218 53.6796951293946,10.1727304458619 53.6807746887208,10.1697597503663 53.6793632507325,10.1713838577271 53.6766929626465,10.1716842651368 53.6689643859863,10.1716842651368 53.6689643859863,10.1728801727294 53.6687812805176,10.1740894317628 53.6669845581055,10.1730890274049 53.6651954650879,10.176522254944 53.6632347106933,10.1829023361207 53.6637382507325,10.1880903244019 53.6584510803224,10.1869764328003 53.6575355529785,10.1874313354492 53.6565284729005,10.1960563659669 53.6547050476074,10.1951446533204 53.6523056030273,10.198618888855 53.6464347839357,10.1896352767945 53.6381568908692,10.1953248977662 53.637477874756,10.1989650726319 53.6357612609864,10.2015590667725 53.6367111206055,10.2101478576661 53.636516571045,10.2217617034912 53.6337242126465)))	0.0006	POINT(10.247514328220493 53.671749893665954)
51403	POLYGON((2.64679050445557 49.6468544006348,2.61748147010815 49.6336097717285,2.61227679252625 49.6339530944825,2.61227679252625 49.6339530944825,2.59401774406444 49.6387023925781,2.58954572677624 49.6373291015625,2.58954572677624 49.6373291015625,2.59957718849193 49.6514968872071,2.59957718849193 49.6514968872071,2.60926103591913 49.650245666504,2.62131762504589 49.655601501465,2.63067889213573 49.6549491882324,2.6358306407929 49.660400390625,2.6358306407929 49.660400390625,2.64296770095837 49.6532707214355,2.64296770095837 49.6532707214355,2.64679050445557 49.6468544006348))	0.0006	POINT(2.6174964606762687 49.6470539569855)
43619	POLYGON((1.16039776802069 43.053810119629,1.15917980670929 43.0562362670898,1.15917980670929 43.0562362670898,1.14979529380798 43.0592880249023,1.14979529380798 43.0592880249023,1.13831973075861 43.0559844970704,1.13018190860754 43.0492782592775,1.13018190860754 43.0492782592775,1.11749613285076 43.0391502380371,1.12293148040771 43.0262184143067,1.11731171607983 43.020679473877,1.11731171607983 43.020679473877,1.12301993370056 43.0140304565429,1.12301993370056 43.0140304565429,1.13674664497381 43.0202445983887,1.1441468000412 43.0192565917969,1.1441468000412 43.0192565917969,1.14223551750183 43.0360374450685,1.15127122402191 43.051872253418,1.16039776802069 43.053810119629))	0.0006	POINT(1.1377194429699011 43.03793977436269)
36917	POLYGON((5.49208211898804 46.6385231018066,5.47651195526134 46.6458625793458,5.47323942184448 46.6521301269531,5.46443796157843 46.6545066833496,5.46443796157843 46.6545066833496,5.48204183578497 46.6592445373536,5.48204183578497 46.6592445373536,5.4968986511231 46.6505546569824,5.4968986511231 46.6505546569824,5.49615192413336 46.6394157409669,5.49208211898804 46.6385231018066))	0.0006	POINT(5.482474231720022 46.65045433044436)
54014	POLYGON((5.50433158874512 43.7582740783692,5.51109313964849 43.7470436096192,5.51109313964849 43.7470436096192,5.48916244506836 43.7476463317872,5.4728307723999 43.7525215148926,5.4728307723999 43.7525215148926,5.47509145736694 43.7706108093262,5.47509145736694 43.7706108093262,5.48443889617926 43.7695770263672,5.49504089355474 43.7582817077637,5.50433158874512 43.7582740783692))	0.0006	POINT(5.489100456237813 43.75741310119633)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point