KML

KML is a file format used to display geographic data in an Earth browser such as Google Earth. KML uses a tag-based structure with nested elements and attributes and is based on the XML standard. (See official definition of KML)

KMZ is a zip archive containing a doc.kml main file in the KML format and other arbitrary files. (See additional information on Google developers website about KMZ)

Dataiku can read both formats and create datasets from KML or KMZ files.

This capability is provided by the KML format plugin, which you need to install. Please see Installing plugins.

Features

In both cases (KML or KMZ), this capability reads a KML file and converts it to a Dataiku dataset. A KML file contains a nested structure (XML-like) of tags. For each geospatial object contained in a <Placemark> tag, a row of a Dataiku dataset is created. There are three expected types for the geospatial objects: Point, LineString and Polygon.

How to use

Create a dataset from a KML or KMZ file in Dataiku.

Select KML/KMZ as the input format of your dataset. The capability selects the appropriate processing of the input file based on its extension to extract tags.

Given the output dataset, a chart can be created by choosing the Geometry Map chart type. Information contained in the KML/KMZ file is displayed as usual in Dataiku.

Import KMZ file as Dataiku dataset

When a KMZ is uploaded instead of a KML, Dataiku applies KML processing on the doc.kml file that must be contained in the KMZ archive.