Export Data – File Formats 15


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).

Export Screen

Export Screen

 

Following common file formats are available:

1. SHP File

Available from version 4.3.0 (published on Google Play on 28-10-2016). Shape files is useful format to exchange information, however does contain 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.

2. CSV File

CSV files are the very common files with very simple structure. Each line contains a data record and the values are separated by a delimiter. MapIt uses coma to separate values in the row.

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

CSV file

Sample CSV file

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

CSV File imported to ArcGIS

CSV File imported to ArcGIS

Sample CSV - MS Excel

Sample CSV – MS Excel

 

qgis_csv1

CSV Imported to qGIS

 

 

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>



KML file can be processed by number of applications, on mobile or desktop you can open it e.g. with Google Earth:

 

KML file opened by Google Earth Desktop

KML file opened by Google Earth Desktop

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 free on-line tool called OGRE http://ogre.adc4gis.com  you can convert your data to SHP file.

Convert GeoJSON to SHP file using http://ogre.adc4gis.com

Convert GeoJSON to SHP file using http://ogre.adc4gis.com

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:
GeoJSON Structure

GeoJSON Structure

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

GeoJSON viewer & validator

GeoJSON viewer & validator

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:

Convert ArcGIS JSON to ArcGIS Features.

Convert ArcGIS JSON to ArcGIS Features.

 

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:

ESRI ArcGIS JSON Structure

ESRI ArcGIS JSON Structure

6. DXF (Geometry Only)

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

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

  • 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 if necessary but some post processing is required.

Download : Sample DXF Files

DXF - Sample Polygon Layer

DXF – Sample Polygon Layer

DXF - Sample Line Layer

DXF – Sample Line Layer

DXF - Sample Point Layer

DXF – Sample Point Layer

 

 

 

 

 

 

 


Leave a Reply

15 thoughts on “Export Data – File Formats

    • osedok Post author

      Hi Lynne, all points are saved in SDCard->MapIt->Pictures->Your Layer Name->Feature ID, you need to copy them over manually to your PC and then link somehow from qGIS, however I am not qGIS expert and cannot comment on this.

      • Lynne

        Thanks! Is there anyway to get the photo’s file name (ie “xxxx.jpg”) into the export file in an attribute field? I’ve figured out how to manually tag a photo to each point on QGIS but it would be much less tedious if the file name data was already attached to the point.

        • osedok Post author

          Yes, it should be possible however I need to think about it as some people are having more than one picture attached to the point. I am afraid it will be also difficult to get it implemented in April and it can be only looked at some point in May.

  • steve

    Hi, very good app!! I am really enjoy it, I was using another one app similar to this one where I can save the KML file with comments, notes, photos etc and then I can export a kml file and open it in Google Earth with all the fields (text and numbers) and the Photos that I have in each waypoint automatically . with Mapit I can export the KML and visualize all the fields but not the Photos in each waypoint. How I can do this in Mapit?….is possible work with the photos as a field in google earth?. if not, is a very cool and very useful.
    Thanks!

    • osedok Post author

      You can save your data as CSV directly from Excel, just Google it if you are not sure how to do that. If you need to convert your data to a KML you can use software like ArcGIS or qGIS to do so, as well just Google it to get more details.
      Please do remember however that when you import the data back to MapIt it will not import all the fields but only geometry, name and description.

  • Colleen Archibald

    Hi
    I have exported point, line and polygon data as GPX files but when loaded onto QGIS the attributes are missing. CSV export of the point files has worked fine.
    Also having problems converting the GeoJson files to shapefiles using Ogre. Any idea of what is going wrong?

  • Jürgen Schicker

    Hi,

    when exporting a line to geosjon or shape GIS will always show the line “closed” like “polygon”.
    I am using ArcGIS and QGIS.
    Do you have a fix for this problem?

    Thanks

    Jürgne Schicker