Export Data – File Formats

MapIt can export data to number of well known formats. At the moment following formats are supported:

SHP files, CSV, KML, geoJSON, ArcGIS JSON, DXF (Geometry Only).

1. SHP File

Available from version 4.3.0 (published on Google Play on 28-10-2016).

A Shape File is a useful format to exchange Geo information, however it does have some limitations.

• Field names are truncated to 9 characters, please use short names for your attributes to avoid meaningless names.
• Maximum length of the Text Type fields is 128 characters.
• A complete SHP File consists of 3 – 9 single files (*.shp is only one of them) looking at it in a Windows explorer outside a GIS software. This can lead to errors when e.g. copying a SHP file and missing one of the “sub files”.

2. CSV File

CSV files are very common files with a very simple structure. Each line contains of a data record and the (attribute) values of it are separated by a delimiter (e.g. comma, semicolon, space). MapIt uses commas to separate the values in a row.

You can open a CSV file with any text editor – the raw file looks like on the picture below:

Most GIS and other professional third party software can import CSV files, so the data can be processed and analysed. Below you can find some examples of imported CSV files:

 

 

3. KML File

 Keyhole Markup Language (KML) are files commonly used when working with Google Maps. The format is in fact a XML file.  Single point feature created by MapIt looks as follow:

<Placemark>
<name>WPT6</name>
<description>
Sample Point Layer

Attributes:

Species:Oak
Height:5-10
Notes:good condition

Attributes are also available as KML Extended Data
</description>
<Point>
<coordinates>-4.02283675968647,55.79513353527385</coordinates>
 <ExtendedData>
<Data name="Species"><value>Oak</value></Data>
<Data name="Height"><value>5-10</value></Data>
<Data name="Notes"><value>good condition</value></Data>
</ExtendedData>
</Point>
</Placemark>

You can open it e.g. with Google Earth:

 

KML files can also be processed by a number of other mobile or desktopapplications.

4. GeoJSON

GeoJSON is a relatively new open source geo format. However it is becoming very popular as a way of sharing spatial data.

Using the free online tool called OGRE http://ogre.adc4gis.com  you can convert data from GeoJSON to other formats and vice versa.

GeoJSON is a simple text file, however the data is structured and composed of JSON objects.

Raw .geojson file content:

{"features":[{"id":5,"type":"Feature","properties":{"Notes":"good condition","created":"2014-12-03 21:03:50","altitude":-1,"description":"Sample Point Layer","name":"WPT6","Height":"5-10","Species":"Oak","accuracy":-1},"geometry":{"type":"Point","coordinates":[-4.02283675968647,55.79513353527385]}},{"id":4,"type":"Feature","properties":{"Notes":"need treetment","created":"2014-12-03 21:03:29","altitude":-1,"description":"Sample Point Layer","name":"WPT5","Height":"5-10","Species":"Pine","accuracy":-1},"geometry":{"type":"Point","coordinates":[-4.022031091153622,55.79157530978487]}},{"id":3,"type":"Feature","properties":{"Notes":"water problem","created":"2014-12-03 21:03:10","altitude":-1,"description":"Sample Point Layer","name":"WPT4","Height":"0-5","Species":"Oak","accuracy":-1},"geometry":{"type":"Point","coordinates":[-4.020425118505955,55.78937194215658]}},{"id":2,"type":"Feature","properties":{"Notes":"red leaves","created":"2014-12-03 21:02:51","altitude":-1,"description":"Sample Point Layer","name":"WPT3","Height":"0-5","Species":"Oak","accuracy":-1},"geometry":{"type":"Point","coordinates":[-4.018249176442623,55.78838906691654]}},{"id":1,"type":"Feature","properties":{"Notes":"broken","created":"2014-12-03 21:02:31","altitude":-1,"description":"Sample Point Layer","name":"WPT2","Height":"5-10","Species":"Oak","accuracy":-1},"geometry":{"type":"Point","coordinates":[-4.016924500465393,55.787137344864256]}}],"type":"FeatureCollection"}

The same data in the JSON viewer:

The GeoJSON data can be rendered by number of online APIs like Leaflet, ESRI ArcGIS JS API, Open Layers API etc.

5. ArcGIS JSON

ArcGIS JSON is a format used by ESRI and ArcGIS Server Rest API. ArcGIS 10.2 has introduced new JSON toolset – using “JSON To Features (Conversion)” tool with few clicks you can convert ArcGIS JSON file to feature class:

 

The raw ArcGIS JSON format looks as follow:

{"features":[{"attributes":{"Notes":"good condition","created":"2014-12-03 21:03:50","altitude":-1,"description":"Sample Point Layer","name":"WPT6","Height":"5-10","Species":"Oak","accuracy":-1},"geometry":{"spatialReference":{"wkid":4326},"y":55.79513353527385,"x":-4.02283675968647}},{"attributes":{"Notes":"need treetment","created":"2014-12-03 21:03:29","altitude":-1,"description":"Sample Point Layer","name":"WPT5","Height":"5-10","Species":"Pine","accuracy":-1},"geometry":{"spatialReference":{"wkid":4326},"y":55.79157530978487,"x":-4.022031091153622}},{"attributes":{"Notes":"water problem","created":"2014-12-03 21:03:10","altitude":-1,"description":"Sample Point Layer","name":"WPT4","Height":"0-5","Species":"Oak","accuracy":-1},"geometry":{"spatialReference":{"wkid":4326},"y":55.78937194215658,"x":-4.020425118505955}},{"attributes":{"Notes":"red leaves","created":"2014-12-03 21:02:51","altitude":-1,"description":"Sample Point Layer","name":"WPT3","Height":"0-5","Species":"Oak","accuracy":-1},"geometry":{"spatialReference":{"wkid":4326},"y":55.78838906691654,"x":-4.018249176442623}},{"attributes":{"Notes":"broken","created":"2014-12-03 21:02:31","altitude":-1,"description":"Sample Point Layer","name":"WPT2","Height":"5-10","Species":"Oak","accuracy":-1},"geometry":{"spatialReference":{"wkid":4326},"y":55.787137344864256,"x":-4.016924500465393}}],"displayFieldName":"name","spatialReference":{"latestWkid":4326,"wkid":4326},"fieldAliases":{"Notes":"Notes","created":"created","altitude":"altitude","description":"description","name":"name","Height":"Height","accuracy":"accuracy","Species":"Species"},"fields":[{"type":"esriFieldTypeString","alias":"Species","name":"Species"},{"type":"esriFieldTypeString","alias":"Height","name":"Height"},{"type":"esriFieldTypeString","alias":"Notes","name":"Notes"},{"type":"esriFieldTypeString","alias":"name","name":"name"},{"type":"esriFieldTypeString","alias":"description","name":"description"},{"type":"esriFieldTypeString","alias":"created","name":"created"},{"type":"esriFieldTypeDouble","alias":"altitude","name":"altitude"},{"type":"esriFieldTypeDouble","alias":"accuracy","name":"accuracy"}],"geometryType":"esriGeometryPoint"}

And the more human JSON structure:

6. DXF (Geometry Only)

DXF is a CAD data file format developed by Autodesk for enabling the data interoperability between AutoCAD and other programs.

MapIt geographic data can be exported to DXF, however there are some limitations you should know :

• Each exported layer starts in 0,0 position (geographic coordinates will not be maintained).
• Polygon Layers are being exported as line elements.
• If your CAD environment is able to access DXF extended data properties – each element is containing original MapIt ID -, so other attribute data can be added but some post processing is required.

Download : Sample DXF Files