Written by:
Ann
Last updated: 04/07/2019 11:12:25

In this guide we will show you how to create a new map and import a spreadsheet for adding features to the spreadsheet.


Time to complete: 10 mins.

Step 1: Download files

Sample Files to Download: Sample Excel

The zip file contains 1 Excel file with an ID and a String


Step 2 - Convert excel file to CSV

Open the file in Excel or Libreoffice and choose File: Save As - from the save as type drop down choose CSV (Comma Delimited_ (*.csv)




Step 3 - Click on Maps section and create NEW map

Name your new map and save


Step 4 - 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 
    • Each Country will have its one or many of its own EPSG codes (GB: 27700, Ire: 2157)
    • Search can be processed by EPSG code or by name
    • Search for 4326 and select (EPSG:4326 is a worldwide coordinate system measured in degrees)

            

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  - NOT APPLICABLE
  • 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 non spatial CSV you can choose the format you want to capture - 'EdinburghHotSpotsNonSpatial' CSV  = point

Close and click SAVE


Your new layer will be added to the map, as their is no data in the layer it will default to the centre of the coordinate system (somewhere in the Atlantic)

Use the address bar in the top right of the map to search for 'Edinburgh'


Step 3 - Add features to the map

To facilitate fast digitising Azimap has a geocoding workflow click the Geocoding button


This will open the data panel at the bottom of the screen where all of the imported data will be listed, on the left of the panel each row has a DIGITISE button which when clicked will change the map to digitising mode 


Order by ID (click on arrows beside ID column name

Click on the first row digitise button


This will convert the toolbar to 'digitising' mode with the add feature button highlighted

The dataset is the top 10 attractions in Edinburgh, as you can see number 1 is Arthur's seat, use the address search in the top left of the map to search for 'Arthur's seat'

This will zoom the map to the correct location

Click the map at the correct location to place a point

The toolbar will revert to normal and the former DIGITISE button will be changed from green to blue to highlight a digitised record


Step 4 - Repeat step 3 for all features

All the green buttons should turn blue and you're data is now spatial!




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


DMcQ: 11/05/17