7 Replies Latest reply: May 12, 2016 8:33 AM by Yuriy Chayka RSS

    KML and Qlik Sense

    Yuriy Chayka

      Hello to everybody!

       

      There are some useful guides from M.Taralo and others about polygon maps in QS. For example, polygon map for USA. My question is following : how can I make polygon map for Ukraine?  Does Google or some another engine have possibility to give user list of coordinates or kml file of selected area ?  Also it is interesting to know how can I see selected area that kml file describes. For example ,

      <coordinates>29.6639912107,45.2126777257,0 29.5815912351,45.3871367193,0 29.2190313425,45.4258320041,0 28.7026581622,45.2204429335,0 28.3785515915,45.3019131682,0 28.2137516404,45.4490363677,0 28.5323648793,45.5301760008,0 28.4884182257,45.6651472759,0 28.9663380840,46.0068881904,0 29.0377513962,46.1941362050,0 28.9333780938,46.4301452039,0 29.2025513474,46.5439754575,0 29.2410046693,46.3693377078,0 29.4991912595,46.4832958208,0 29.8672444838,46.3465173133,0 30.0979644154,46.3807443084,0 29.9002044740,46.5363942316,0 29.9716177862,46.7407134740,0 29.8672444838,46.8614252394,0 29.5760979034,46.9480185040,0 29.5980712302,47.2780328309,0 29.4112979522,47.2892470291,0 29.1366313669,47.5502328137,0 29.2574846644,47.7654924940,0 29.1750846889,47.9540350929,0 28.9608447523,47.9466542596,0 28.8070314646,48.1271794621,0 28.2137516404,48.2080246585,0 27.7632984405,48.4497913601,0 27.5490585040,48.4680600470,0 27.2414319285,48.3693305611,0 26.7030854213,48.3400403343,0 26.6371654408,48.2557365678,0 26.3185522019,48.1749671188,0 26.1592455824,47.9835478216,0 25.3352458266,47.9171203213,0 25.1155125584,47.7580846082,0 24.9012726218,47.7173222650,0 24.5551927244,47.9540350929,0 24.2475661489,47.9023469884,0 23.5004730369,47.9835478216,0 23.1269264809,48.0903892603,0 22.8962065493,47.9540350929,0 22.7918332469,48.1161451835,0 22.6050599689,48.1161451835,0 22.1491134373,48.4132341450,0 22.1601001007,48.5775333163,0 22.3303933836,48.6867686431,0 22.5556199835,49.0780476618,0 22.8632465590,49.0022067199,0 22.7039399396,49.1681828743,0 22.7588732566,49.2869091337,0 22.6544999542,49.5306529181,0 22.7808465835,49.6734633915,0 23.3027130955,50.0993735989,0 23.7202063051,50.3847290451,0 24.0003662221,50.4128191334,0 24.1102328562,50.5670155623,0 23.9564195685,50.7903987248,0 24.1322061831,50.8391213514,0 23.6817529832,51.2891084440,0 23.6048463393,51.5261635206,0 23.7531662954,51.6527715237,0 23.9619129002,51.5843788093,0 24.2860194708,51.7415272176,0 24.3958861049,51.8845323855,0 24.9946592608,51.9117197661,0 25.1704458754,51.9592578998,0 25.8186590167,51.9354951610,0 26.4339121677,51.8573284669,0 26.9283120212,51.7517570016,0 27.2029786065,51.7517570016,0 27.2798852504,51.5980656411,0 27.8676717429,51.6220076233,0 28.0764183477,51.5638407887,0 28.6257515183,51.5638407887,0 28.7575914792,51.4163785426,0 28.8344981231,51.5501435924,0 29.1805780206,51.6185881172,0 29.3398846400,51.3717025168,0 29.6255378887,51.4918842408,0 29.7628711814,51.4404167008,0 30.2078310495,51.4850252735,0 30.5539109470,51.2512028342,0 30.6418042543,51.3682640827,0 30.5539109470,51.5432934392,0 30.6637775811,51.8233003060,0 30.9604174932,51.9999645868,0 30.9604174932,52.0778818493,0 31.7844172491,52.1083340627,0 32.1250038148,52.0440215512,0 32.3007904294,52.1083340627,0 32.3667104099,52.3175487071,0 32.9160435804,52.2467965778,0 33.2071901608,52.3781030502,0 33.5148167364,52.3276468871,0 33.8334299753,52.3646537333,0 34.0641499069,52.1961898106,0 34.1300698874,51.9863998220,0 34.3827631458,51.8437203046,0 34.3882564776,51.7142364086,0 34.1080965606,51.6732691382,0 34.3827631458,51.2649903292,0 34.7672963652,51.1718440501,0 35.0749229408,51.2201657703,0 35.1683095798,51.0577411983,0 35.3715628529,51.0404281725,0 35.4869228187,50.6788407675,0 35.4594561602,50.4864759994,0 35.6956694235,50.3460778417,0 35.8604693747,50.4303669398,0 36.1461226234,50.4233486017,0 36.2779625843,50.2933206384,0 36.6515091403,50.2193616216,0 36.8108157598,50.3144305847,0 37.4645222327,50.4373842322,0 37.7446821497,50.0817027563,0 38.0248420667,49.9046338266,0 38.1841486862,50.0640253615,0 38.6510818812,49.9578233506,0 38.9422284616,49.8122987810,0 39.2004150517,49.8726917743,0 39.2498550371,49.7731805301,0 39.5904416028,49.7197862482,0 39.8101748711,49.5521013076,0 40.1397747734,49.6021107348,0 40.0573747978,49.4734109187,0 40.1672414319,49.2509617783,0 39.9200415052,49.0491695894,0 39.7058015687,49.0347242236,0 39.8266548662,48.8247920109,0 39.6618549150,48.6030428372,0 39.8486281930,48.5556577018,0 39.9969481491,48.2960732325,0 39.7772148808,48.0241001226,0 39.7332682272,47.8173179810,0 38.8982818079,47.8690914766,0 38.7554551836,47.6913658744,0 38.3544419691,47.6097039817,0 38.2226020081,47.3415483292,0 38.2335886715,47.1095327747,0 37.5414288766,47.0795208432,0 36.7613757744,46.7520417800,0 36.6130558184,46.7746912050,0 36.1955626087,46.6651302068,0 35.9099093600,46.6500007743,0 35.3495895260,46.3503213784,0 35.2067629017,46.3883473766,0 35.0364696188,46.2513290861,0 34.7013763848,46.1750585856,0 34.5640430921,45.9877452614,0 34.4047364727,46.0145434958,0 34.5365764336,46.1826904329,0 34.3278298288,46.1712422622,0 34.1575365459,46.2818074386,0 34.1245765557,46.1177857472,0 33.9597766045,46.2132071613,0 33.6686300241,46.2170205531,0 33.8993499557,46.0375030133,0 34.3607898190,46.0145434958,0 34.3607898190,45.8842582601,0 34.6354564043,45.9379424510,0 34.4651631214,45.7690447055,0 34.6464430677,45.7844203807,0 34.9870296335,45.6304715879,0 35.0584429456,45.3639067408,0 35.3440961943,45.3329184934,0 35.0529496139,45.6111979804,0 34.7563097018,46.0107159764,0 34.8222296823,46.0719242945,0 35.0694296091,45.6343255092,0 35.4594561602,45.2980363018,0 36.1351359600,45.4567690211,0 36.6020691549,45.4180950817,0 36.2285225990,45.0065107462,0 35.8549760430,44.9870223321,0 35.5253761406,45.1194119689,0 35.1023895993,44.8074158402,0 34.7233497116,44.8074158402,0 34.4431897946,44.7056492945,0 34.3388164922,44.5487330403,0 33.9323099460,44.3795717445,0 33.7125766778,44.3953284986,0 33.3664967803,44.5840764333,0 33.5532700583,44.6233215122,0 33.6191900388,44.9168087923,0 33.5642567217,45.0882892228,0 33.2786034730,45.1544046418,0 32.9325235755,45.3445410874,0 32.5095370342,45.3406671563,0 32.5260170293,45.4567690211,0 32.9325235755,45.6574434347,0 33.7675099948,45.9264430955,0 33.5917233802,46.1559743030,0 33.4269234291,46.0451540530,0 33.1907101657,46.1597916926,0 32.5370036927,46.0757475483,0 31.7679372539,46.3084620071,0 32.0590838343,46.3921485111,0 31.6580706198,46.4719107980,0 31.7624439222,46.5515556181,0 32.3502304147,46.4605233779,0 32.4930570391,46.5742897085,0 32.1414838099,46.5591347135,0 31.9382305368,46.7633676903,0 32.0096438490,46.9254425262,0 31.8393505661,47.1807429076,0 31.9382305368,46.8538887381,0 31.9107638783,46.6537835318,0 31.1746574297,46.6272986381,0 30.8340708640,46.5477656710,0 30.7626575518,46.3807443084,0 30.2462843715,45.8727477052,0 29.9826044496,45.8420411586,0 29.7408978545,45.6227629452,0 29.6365245521,45.8190000481,0 29.6200445570,45.4876889622,0 29.7518845180,45.4490363677,0 29.6639912107,45.2126777257,0 </coordinates>

       

      list of coordinates for Ukraine . But how can I see that on Google map . And vice versa.

        • Re: KML and Qlik Sense
          Andrey Khoronenko

          Hi, Yuriy!

           

          When it comes to loading the geo-coordinates in the Qlik Sense, you can do without Google map.


          Geodata files in the proper format for the regions of the world, including to the Ukraine, can be downloaded at www.gadm.org. On this page, select the Ukraine and KMZ format of files. You can download geodata several levels (countries, regions, districts, etc.).

          KMZ - KML is an archive file that can be extracted by any archiver (WinRAR? WinZIP, etc).

          After extracting the KML files can be loaded into Qlik Sense.


          Regards

          Andrey Kh.