Written by:
Ann
Last updated: 03/07/2019 17:07:13

In this guide we will show you how to create a new map and import a CSV.


Time to complete: 2 mins.


Step 1 - Download Files

Sample Files to Download: Sample CSV

The zip file contains 2 CSV files - one with spatial information (location data) and one without


Step 2 - Click on Maps section and create NEW map

Name your new map and save


Step 3 - Create map and upload data

When you try to load a map without any layers attached you get the below window


Choose the create / Import button (This is accessible on the map using the gears button on the layer tree view


Choose Import



Drag and drop to the DnD area the earlier downloaded zip file

Rename Your Layers after upload


Step 2: Configure Imports and add to map

After Upload CSV imports need to be configured:

  • Coordinate system (EPSG)
    • Set EPSG code - All spatial data needs a co-ordinate system (this is recognised automatically for spatial files like SHP or TAB but must be set manually for CSV) further information on EPSG codes available here - For spatial enabled CSV the correct coorinate system (EPSG) must be chosen or else the data will be in the wrong location.
    • Each Country will have its one or many of its own EPSG codes (GB: 27700, Ire: 2157)
    • Searchs can be processed by EPSG code or by name
    • Latitude and Longitude are in 'EPSG:4326' - worldwide coordinate system in degrees
    • Non spatial CSV like 'EdinburghHotSpotsNonSpatial' can have any cordinate system the user desires - let's choose 'EPSG: 4326' for it
    • The 'EdinburghHotSpots' CSV has a EPSG code of 'EPSG:3857' which covers worldwide and is the same as our basemaps (Google, Bing, OSM) 

            

Import Options - click CONFIGURE button

  • Keep geometry column as attributes - will create a new column in with text version of the geometry (lat lon or well known Text (WKT)) useful for point features but a WKT of lines or polygons can be very large
  • Let us guess column formats - our importer will try to auto discover the types in each column (String, text, date etc.), if unticked all data will be imported as string unless a .csvt file is used (The .csvt file has to have the same name as the .csv file it describes. It enables definition of the following data types: Integer, Real, String, Date (YYYY-MM-DD), Time (HH:MM:SS+nn) and DateTime (YYYY-MM-DD HH:MM:SS+nn) and geometry column types (WKT, lat, X, lon, Y). A .csvt file contains only one line and the types for each column have to be quoted and comma separated, e.g.
"Integer","WKT","String"
    • Precision can also be applied
"Integer","Real","String(500)"
  • Contains spatial columns
    • 'EdinburghHotSpots' CSV has a spatial column in WKT format
    • 'EdinburghHotSpotsNonSpatial' CSV does not so this should be unticked
    • Supported column names are:
    • WKT - short for Well Known Text. Details of format available here. The type supports almost all geometry types including points, lines, polygons, and their multi variants
    • Lat or Y - lat of y for the Y axis point coordinate
    • Lon or X - lon of x for the X axis point coordinate
  • Select Geometry Drop down
    • Choose point, line or polygon
    • For spatial CSV you must choose the format of the applicable type - in our case 'EdinburghHotSpots' CSV = point
    • For non spatial CSV you can choose the format you want to capture - 'EdinburghHotSpotsNonSpatial' CSV  = line

Close and click SAVE


Your new layers will be added to the map



Thanks for reading and if you haven't yet tried Azimap please go to the website to register


DMCQ: 11/05/2017