topic kml data formats in Connectivity & Data Prep

kml data formats

chriscammers — Mon, 20 Jul 2015 13:48:46 GMT

Hello everybody,

I'm a pretty experienced QlikView developer so this is more of a general question about KML data which is somewhat new to me.

I aquired a "kml" data file from Google Fusion Tables but the download is formatted as a csv, qlik Sense does not recognize is as a KML format at all which is logical since it does not have the typical xml type of layout.

Could somebody describe for me the requirements and field contents I need to make this data into recognizable area data. for example there is some "header" data in the geometry field and I am having a hard time importing this data into sense in a way that works to show it on the map. There are tags within the geometry data that seem to be delimiting several shapes within the same geographic entity, probably things like islands in the Alaskan islands make this data very complex.

Thanks for your thoughts

Chris

Re: kml data formats

Patrik_Lundblad — Tue, 21 Jul 2015 08:47:31 GMT

Hi Chris,

In this case I think the easiest solution is to go to that website, then click the visualize tab on the top and choose map. Then a link on the top will appear where you can download the KML file instead of the CSV.

In regards to formats Qlik Sense reads KML files, but the actual storage of the data is using a derivative of GeoJSON. So you could take that csv file and do a search and replace of the xml tags with brackets.

Best regards,

Patrik.

Re: kml data formats

chriscammers — Tue, 21 Jul 2015 14:32:01 GMT

Thanks Patirk

I will give that a try.

After I load the area data do I just set a tag on the field to interpret it as an area? What is the tag?

Thanks

Re: kml data formats

chriscammers — Tue, 21 Jul 2015 15:39:33 GMT

Patrik,

Stripping out the tags did not work but I did find a different method to download the file as a true KML so that worked out.

Thanks for the info

Chris