topic Re: Maps in Integration, Extension & APIs

Maps

Anonymous — Mon, 13 Nov 2017 03:49:55 GMT

Hi Expert,

I wanted to draw map for malaysia..can i get the excel sheets with kml files and area fields for states and cities in it

thanks

Re: Maps

Ralf_Heukäufer — Mon, 13 Nov 2017 07:25:04 GMT

Hello Rupesh,

I don´t know where to find a kml file from malaysia, but here you can find files with geocoordinates:

GeoNames

Or the direct link to the malaysia file:

http://download.geonames.org/export/zip/MY.zip

To read this you can use something like that:

LOAD

@1 AS country,

@2 AS "post code",

@3 AS city,

@4 AS "federeal state",

@5 AS "federeal state shortcut",

@8 AS district,

'[' & @11 & ','& @10 &']' as geocoordinates

FROM [lib://Path to read from/MY.txt]

(txt, utf8, no labels, delimiter is '\t', msq);

TAG FIELDS geocoordinates WITH $geopoint;

Re: Maps

Anonymous — Mon, 13 Nov 2017 07:58:41 GMT

yeah..thanks coordinates... i am having...looking state/city ares/kmls

thanks

Re: Maps

Ralf_Heukäufer — Mon, 13 Nov 2017 08:08:31 GMT

Great,

I am glad that I could help you, if that answers your question please mark my answer as correct.

Re: Maps

Anonymous — Mon, 13 Nov 2017 08:12:58 GMT

Sure..I have coordinates information and looking for area\kml info. in same format like csv and all

thanks

Re: Maps

shraddha_g — Mon, 13 Nov 2017 08:20:54 GMT

If you have latitude & longitude information then you can use geomakepoint() to plot on map

Re: Maps

Ralf_Heukäufer — Mon, 13 Nov 2017 08:24:05 GMT

I have tried it but it doesn´t work correct with this files.

Re: Maps

Anonymous — Mon, 13 Nov 2017 08:27:16 GMT

Right...i wanted to know area info like this

Re: Maps

jurciello — Mon, 13 Nov 2017 08:39:24 GMT

Hi, Rupesh

also You can look into this topic

KML and Qlik Sense

HIT ,

BR,Yuriy Chayka

Re: Maps

Anonymous — Mon, 13 Nov 2017 08:46:11 GMT

yes. this map is available in for UK and USA .Need for asian countries

Re: Maps

Ralf_Heukäufer — Mon, 13 Nov 2017 09:07:09 GMT

Look at this post:

KML files for Germany, Austria, Switzerland (County, District Level)

There is a Description of Christof Schwarz:

There's always a chance 😉

I looked up http://www.gadm.org/download for .kmz files, which I converted to .kml using Google Earth, and I looked up http://geocommons.com , where I pulled down this map: http://geocommons.com/overlays/116292.kml - this works fine, it is UK (with Scottland ) but without Northern Ireland.

Re: Maps

jurciello — Mon, 13 Nov 2017 09:58:37 GMT

Try to use this Download | Global Administrative Areas

extract kmz archive to kml files.

Re: Maps

Anonymous — Mon, 13 Nov 2017 10:10:00 GMT

let me check this...

thanks

Re: Maps

Ralf_Heukäufer — Mon, 13 Nov 2017 12:28:23 GMT

The kmz files you can unzip with 7 Zip to a kml file.

I have tried it by myself and created a short testapp :

Re: Maps

Anonymous — Mon, 13 Nov 2017 16:19:25 GMT

Ralf,

You made my day!!