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 |
|---|---|---|---|
| 35180 | POLYGON((8.82095527648931 41.7911338806152,8.81636619567865 41.7970695495605,8.79729175567627 41.8061637878419,8.78490161895752 41.810546875,8.77291488647467 41.8111877441407,8.77291488647467 41.8111877441407,8.77430629730225 41.8123626708986,8.77430629730225 41.8143043518067,8.77236175537104 41.8162498474122,8.773193359375 41.8187484741211,8.77236175537104 41.8229179382325,8.77402782440186 41.825138092041,8.77847194671631 41.8279151916505,8.78152847290045 41.8276405334473,8.7829160690307 41.829029083252,8.7829160690307 41.8304176330568,8.78486347198498 41.8304176330568,8.78402805328363 41.8326377868653,8.78263759613031 41.8334732055665,8.77986240386963 41.8331947326661,8.78013801574713 41.83402633667,8.77791595458984 41.8345832824708,8.77430629730225 41.8337516784669,8.773193359375 41.83402633667,8.773193359375 41.8351402282716,8.77152729034418 41.8348617553712,8.77180480957031 41.8373603820801,8.76652717590332 41.8381958007812,8.76791667938232 41.839584350586,8.76513862609875 41.8406944274903,8.76652717590332 41.84375,8.76097297668451 41.8431930541993,8.76069545745844 41.8415260314941,8.7587509155274 41.8406944274903,8.75847339630133 41.8415260314941,8.75680637359619 41.8409729003907,8.75514030456537 41.8423614501953,8.75125026702887 41.8423614501953,8.75041580200201 41.8448600769044,8.74874973297119 41.844581604004,8.74874973297119 41.8454170227051,8.75986099243158 41.8470840454103,8.75958156585693 41.8490295410156,8.76069545745844 41.8501396179199,8.76208305358887 41.8490295410156,8.76180458068853 41.8473625183107,8.76291656494146 41.8468055725099,8.76624870300293 41.8476371765137,8.76819515228271 41.8454170227051,8.77208423614513 41.8454170227051,8.77264022827143 41.8462486267091,8.77458381652838 41.8462486267091,8.77486228942871 41.8473625183107,8.77847194671631 41.8481941223145,8.7804155349732 41.8473625183107,8.78347206115717 41.8476371765137,8.78513813018799 41.8498611450196,8.78736114501959 41.8498611450196,8.78902912139904 41.8509712219239,8.7895832061767 41.8530540466309,8.7895832061767 41.8530540466309,8.79860687255865 41.852596282959,8.81990909576416 41.8578605651857,8.83862400054932 41.8486557006836,8.84310531616217 41.8493804931642,8.85365104675299 41.838752746582,8.86038017272961 41.8226051330566,8.86038017272961 41.8226051330566,8.86275577545177 41.8197288513185,8.83969306945812 41.8098487854004,8.82095527648931 41.7911338806152)) | 0.0006 | POINT(8.782243374415819 41.83578594752724) |
| 54419 | POLYGON((5.24498987197882 46.2888870239258,5.23940229415899 46.2834930419922,5.2414340972901 46.2734565734863,5.2483086585998 46.2687683105469,5.25787162780762 46.2672576904297,5.27261495590216 46.2459831237793,5.28525400161743 46.2408103942871,5.28525400161743 46.2408103942871,5.30450439453131 46.2370185852051,5.30450439453131 46.2370185852051,5.30378150939947 46.2469940185546,5.29623937606823 46.255714416504,5.3194432258606 46.2602272033693,5.31994152069086 46.2701530456544,5.31994152069086 46.2701530456544,5.30427122116089 46.2780838012695,5.30938196182251 46.2840423583984,5.30938291549683 46.2942237854004,5.31671857833857 46.2977409362794,5.31671857833857 46.2977409362794,5.31545257568371 46.313892364502,5.31545257568371 46.313892364502,5.30752563476562 46.3149070739747,5.30752563476562 46.3149070739747,5.30087566375727 46.3057823181153,5.29138851165783 46.3036575317383,5.27623605728161 46.2946815490723,5.26722431182861 46.2917251586915,5.24747943878185 46.2941360473633,5.24747943878185 46.2941360473633,5.24498987197882 46.2888870239258)) | 0.0006 | POINT(5.289219951629668 46.27934315999351) |
| 38155 | POLYGON((1.47685933113104 49.8318061828613,1.45527422428137 49.8340225219727,1.45527422428137 49.8340225219727,1.43569099903107 49.8297843933106,1.43569099903107 49.8297843933106,1.41605138778692 49.8135795593263,1.39061403274536 49.8095092773439,1.39061403274536 49.8095092773439,1.38114964962017 49.7974967956544,1.38913547992706 49.7846145629883,1.40421986579901 49.7855682373047,1.41195356845861 49.7903861999512,1.41195356845861 49.7903861999512,1.43752646446228 49.8092918395996,1.43752646446228 49.8092918395996,1.47685933113104 49.8318061828613)) | 0.0006 | POINT(1.421968952814772 49.810603586832734) |
| 17303 | POLYGON((8.26195812225347 44.8500404357911,8.25258255004883 44.8427085876464,8.24721908569336 44.8367729187013,8.23970222473145 44.8349227905275,8.23048973083496 44.8278961181642,8.2231884002685 44.8244171142579,8.21508312225353 44.8266639709474,8.21194458007824 44.8249893188477,8.20419788360601 44.8143386840821,8.19913864135742 44.8092727661133,8.19913864135742 44.8092727661133,8.19680118560791 44.805534362793,8.19680118560791 44.805534362793,8.21076965332037 44.7912406921387,8.22115230560303 44.787281036377,8.22115230560303 44.787281036377,8.22344875335693 44.7915153503419,8.23706436157221 44.806022644043,8.24713706970221 44.8094177246093,8.26844501495367 44.8054466247559,8.2712860107423 44.8044509887696,8.27502155303966 44.8015022277831,8.27502155303966 44.8015022277831,8.277268409729 44.8026084899903,8.277268409729 44.8026084899903,8.27159214019781 44.8160438537598,8.27159214019781 44.8160438537598,8.25113868713373 44.8164100646973,8.24891757965094 44.8170204162598,8.24752235412598 44.8199729919435,8.24743556976313 44.8258323669434,8.25406646728521 44.8344802856446,8.26757621765148 44.8450889587403,8.26757621765148 44.8450889587403,8.26195812225347 44.8500404357911)) | 0.0006 | POINT(8.241491121404342 44.81585951412428) |
| 22955 | POLYGON((0.581631302833557 44.5716743469238,0.566051900386867 44.5639190673829,0.566051900386867 44.5639190673829,0.564417839050293 44.5556602478027,0.564417839050293 44.5556602478027,0.568828701973075 44.554443359375,0.573571860790253 44.5413894653321,0.561066508293209 44.5367240905763,0.558034479618186 44.5308418273927,0.559820294380188 44.5241889953613,0.569175004959163 44.5165672302246,0.569175004959163 44.5165672302246,0.574204504489956 44.5257835388184,0.600027441978568 44.5180549621583,0.606866240501404 44.5227241516114,0.606866240501404 44.5227241516114,0.598782896995544 44.5265998840333,0.593620777130127 44.5431518554687,0.60003769397747 44.5483245849609,0.614190459251461 44.5499000549318,0.61557358503336 44.5532379150392,0.581631302833557 44.5716743469238)) | 0.0006 | POINT(0.581543451263829 44.54009791782929) |
| 67531 | MULTIPOLYGON(((8.81926822662365 48.7634353637696,8.82528877258301 48.7589187622071,8.83545398712158 48.7540969848633,8.83349990844721 48.7432289123535,8.83151340484613 48.743263244629,8.83102321624762 48.7424812316895,8.83203792572016 48.7420692443849,8.82979202270513 48.7395782470703,8.82920265197765 48.7364730834961,8.82920265197765 48.7364730834961,8.82177448272711 48.7361640930177,8.82177448272711 48.7361640930177,8.81474876403814 48.7368202209473,8.81049251556391 48.7383766174317,8.80677223205566 48.7378044128419,8.79895782470709 48.73881149292,8.79074478149425 48.7422637939454,8.78848648071283 48.7465400695801,8.79526901245123 48.7520027160644,8.79526901245123 48.7520027160644,8.8023681640625 48.7575988769532,8.81926822662365 48.7634353637696)),((8.78350162506104 48.7548103332521,8.78351020812988 48.7539062500001,8.78200626373297 48.7536697387695,8.78283977508551 48.7524909973145,8.78125572204601 48.7474212646485,8.7793235778808 48.7471084594728,8.77891731262207 48.7484092712402,8.77739429473888 48.7477188110351,8.77704620361334 48.7453575134277,8.76742649078363 48.7447357177735,8.76580333709717 48.7460174560547,8.75908088684082 48.7476043701172,8.75506782531738 48.754062652588,8.75527954101568 48.7580032348634,8.75527954101568 48.7580032348634,8.76579761505121 48.7625579833986,8.77096652984625 48.7572441101075,8.77387046813965 48.7563171386719,8.77813243865978 48.7565879821777,8.78350162506104 48.7548103332521))) | 0.0006 | POINT(8.804350856219571 48.7465975557377) |
| 42664 | POLYGON((7.00300216674816 49.1434402465821,6.98197841644287 49.1385993957521,6.98197841644287 49.1385993957521,6.97736167907715 49.1394119262696,6.97759199142467 49.1484756469727,6.97759199142467 49.1484756469727,6.98464441299444 49.1609382629394,6.99215364456182 49.1646842956544,6.99215364456182 49.1646842956544,6.99769639968872 49.1671295166017,6.99769639968872 49.1671295166017,6.99630403518677 49.164031982422,7.00350427627563 49.1559638977052,7.00300216674816 49.1434402465821)) | 0.0006 | POINT(6.989512113424485 49.153966463529244) |
| 20276 | POLYGON((11.5140476226807 45.4452590942383,11.5100402832031 45.4255447387695,11.5084276199341 45.4246520996094,11.5084276199341 45.4246520996094,11.510669708252 45.4212989807129,11.5155096054077 45.4177551269532,11.5310125350953 45.4103279113769,11.5472993850707 45.4053230285646,11.552622795105 45.3967323303224,11.5517301559449 45.3920707702637,11.5553827285768 45.3876609802246,11.5675573348998 45.3769721984863,11.5670938491821 45.3739547729493,11.5670938491821 45.3739547729493,11.5882501602173 45.3820686340333,11.5963439941407 45.3897514343262,11.6167030334472 45.3889389038086,11.6167030334472 45.3889389038086,11.6213579177856 45.3923110961913,11.6213579177856 45.3923110961913,11.6189594268799 45.3923873901368,11.6121454238892 45.3983573913574,11.6045331954956 45.4003677368164,11.592887878418 45.4019279479982,11.57803440094 45.4023399353027,11.5490016937257 45.4153480529785,11.5408735275269 45.4222640991211,11.5298137664795 45.4343872070313,11.5264949798585 45.4388008117676,11.5264425277711 45.442211151123,11.5264425277711 45.442211151123,11.5140476226807 45.4452590942383)) | 0.0006 | POINT(11.560427758001534 45.40648651123049) |
| 43584 | POLYGON((0.858305692672843 42.8257179260254,0.859883189201469 42.8382987976074,0.859883189201469 42.8382987976074,0.880255162715969 42.8531494140626,0.897999823093528 42.8580970764161,0.897182941436768 42.8651237487794,0.902106881141663 42.8709945678711,0.915350496768895 42.8751220703126,0.934281766414699 42.8734550476075,0.960107266903037 42.8822975158693,0.960107266903037 42.8822975158693,0.965446710586491 42.8765335083008,0.964809715747947 42.8524856567382,0.961041688919067 42.8424568176271,0.964876472950039 42.8289451599121,0.958088696002903 42.8124008178712,0.960393071174678 42.8051567077637,0.960393071174678 42.8051567077637,0.947250843048096 42.8010139465333,0.933131754398403 42.7908592224122,0.935513019561768 42.7888412475586,0.925827205181179 42.7896728515626,0.909962475299949 42.7967720031739,0.907664000988063 42.7969741821288,0.907157421112061 42.7985649108888,0.884979069232941 42.8130722045899,0.878965377807617 42.8146743774415,0.877350986003876 42.8142967224121,0.873970985412654 42.8159866333008,0.870769023895377 42.8156242370605,0.860931992530823 42.8212585449219,0.858305692672843 42.8257179260254)) | 0.0006 | POINT(0.915289911531677 42.83043867541902) |
| 72297 | POLYGON((14.2292423248292 47.9754295349122,14.2407913208008 47.9815635681153,14.2431869506837 47.9844589233398,14.2417793273925 47.988063812256,14.2350721359252 47.9970397949219,14.2335500717164 48.001392364502,14.2346229553223 48.0075073242188,14.2408676147462 48.0263633728028,14.2408676147462 48.0263633728028,14.2211017608644 48.0312423706055,14.2277660369873 48.0247039794922,14.2277660369873 48.0247039794922,14.2257261276245 48.0190544128418,14.2224845886232 48.0163002014161,14.2017040252686 48.0161666870118,14.1968421936036 48.0151557922364,14.1936769485474 48.0111808776857,14.1879978179932 47.9986038208008,14.1879978179932 47.9986038208008,14.2009763717651 47.9779319763184,14.2213335037232 47.9719696044923,14.2213335037232 47.9719696044923,14.2292423248292 47.9754295349122)) | 0.0006 | POINT(14.22166759317576 48.00298950888899) |