Map Pins Guide - Add layers

 

Importing Map Pins to the map 

 

Video Guide

Step One

Create a new layer - To add your own data, Open or Create a new project and then choose Add Data, Create New Layer. 

Step Two

Choose which type of layer to create - Select Map Pins to add each of the rows in your data as points on the map. 

Step Three

Import your data - To add multiple Map Pins to the map, you can import data from an external source such as Microsoft Excel. Select Import Data to add your data to the map

Step Four

Choose the file that you want to display 

In order to map the locations automatically, your data needs to contain columns with either a Postcode or an Address or X/Y Coordinates.      

Press Choose file and locate the file that contains the records that you would like to display as points on the map. 

Step Five

Check that the location method is correct 

The system will review the first 10 records in your file and look for a column it can use to locate each record on the map (i.e. Postcode, Address, X and Y).      

If the system finds one of these columns, it will show you the first 10 locations on the map and highlight the column it is using in the Data View.  

If the system cannot find a suitable column automatically, you will be re-directed to the Advanced Options for importing.       

In the Import Advanced Options, Location Settings section you can specify both the method used to map each location and the column that contains this information.       

Return to the preview screen by clicking the Import Data back arrow button.      

Once you are happy with your Location Method, press Confirm Preview to import the remaining records. 

Step Six

Check how many of your records can be displayed 

The Matched Records figure here shows how many of your records could be located on the map. Any Records that could not be matched will have ‘Unmatched’ in the Location Match column in the Data View below. You will need to update the column in the import file and start the import process again if you wish to include the unmatched records.      

Once you are happy with the Matching Results, press Create Layer and wait until the processing is complete. Your layer will then be created and ready for use. 

Adding an existing layer to the map

 

Video Guide

Step One

Use Existing Layer - To use an Existing Layer, Open or Create a new project and then choose Add Data, Use Existing Layer.

Step Two

 A list of all the available layers will be displayed. The layers are grouped into two sections. My Points (Map Pin layers) and My Boundaries (Catchment, Hot-Spot and Territory layers). Select the layer that you want to use by clicking on it. Your layer will then be added. You can add as many existing layers as you want to by clicking on the layer name and adding one layer at a time.       

When you have added all the existing layers that you require, press the Project back arrow to return to the Project Editor. 

Step Three

All of the layers that you have added will now be included within the My Data section of the Project Editor panel.       

Note that any changes which are made to a layer will be saved after you have saved the project. If there are any other projects which contain this layer, then the changes will also appear in the layer of these projects too. 

Manually adding a Map Pins layer to the map

 

Video Guide

Step One

Create a new Map Pin layer - To add your own data, Open or Create a new project and then choose Add Data, Create New Layer. 

Step Two

Choose which type of layer to create - Select Map Pins to add each of the rows in your data as points on the map. 

Step Three

Manually place pins onto your map - Choose Manually Place Pins to add Map Pins one at a time to your map. 

Step Four

Add a new Map Pin 

To add a new Map Pin, navigate to Design and Build and then Set Location. From the drop down choose Google and then type in the location you want to add your pin to. Click Search and select the relevant search results to update your pin location.      

TIP: You can also choose to set the Map Pin location manually by clicking on the map, or set the location using a layer within SKiN using the other dropdown options available and searching in the same way. 

Step Five

Name your Map Pin - Under the Pin Name dropdown, type a name for your new Map Pin in the text box.  

Step Six

Add further Map Pins - Once you are happy with your first Map Pin, you can add additional Map Pins by opening the Select section, selecting All and clicking Add. Use the appropriate set location method to add a new Map Pin to the map. 

Updating an existing Map Pins layer 

 

Video Guide

Step One

Update an Existing Layer - To update an existing layer you have created, open the project that contains the data to update and then choose Add Data and then Update Existing Layer. 

Step Two

Select your target layer - Select the layer you wish to update from the target layer dropdown

Step Three

Update the existing layer 

To update the existing data, select Action from the dropdown, where you will be presented with the option to Update or Replace:       

Update allows you to add new columns, or update existing columns, within the data layer you previously selected.      

Replace allows you to replace the entire dataset with a brand new set of data. This option means that all projects containing the data layer you previously selected will reference the new data.      

To update your data, click on Update.   

Step Four

Choose the file that you want to update - Navigate to File Selection and press Choose file and locate the file that contains the records that you would like to update your layer with. 

Step Five

Data settings 

Under the Data Settings option you need an ID Column. An ID Column is what the system uses to match your existing dataset with your new one. Select the column from the dropdown which matches the ID column in your existing data layer identically.      

The Only update matched IDs should be checked if you want the system to only update data entries that can be matched in both datasets. If the box is left unchecked, new entries may be added to your data layer.       

Step Six

Apply your column settings

Click on Advanced Options to select the columns of data you wish to update/add. Use the check box on the left to make your selection.      

Once you have finished, click on the Update Existing tab to the left of Project, to return to the previous menu

Step Seven

Run the update

To run the process, click the Update button. Clicking Cancel will take you back to the project that you are working within.

Step Eight

Check how many of your records can be matched

The Match Report provides a figure for the number of Matched IDs and Unmatched IDs in your dataset when matching against the existing layer. You will need to update any unmatched IDs in the imported file and start the import process again if you wish to include the unmatched records.      

Once you are happy with the Match Report, press Update and wait until the processing is complete. Your layer will then be created and ready for use. 

Grouping Map Pins imported to the map

Lorem ipsum

grouping

Step One

Create new layer - To add and group your own data, Open or Create a new project and then choose Add Data, Create New Layer. 

Step Two

Choose which type of layer to create - Select Map Pins to add each of the rows in your data as grouped points on the map

Step Three

Import your data - To add multiple Map Pins to the map, you can import data from an external source such as Microsoft Excel. Select Import Data to add your data to the map. 

Step Four

Choose the file that you want to display - In order to map the locations automatically, your data needs to contain columns with either a Postcode or an Address or X/Y Coordinates

 

Press Choose file and locate the file that contains the records that you would like to display as points on the map. 

Step Five

Check that the location method is correct - The system will review the first 10 records in your file and look for a column it can use to locate each record on the map (i.e. Postcode, Address, X and Y).

 

 If the system finds one of these columns, it will show you the first 10 locations on the map and highlight the column it is using in the Data View.

 

If the system cannot find a suitable column automatically, you will be re-directed to the Advanced Options for importing. 

 

In the Import Advanced Options, Location Settings section you can specify both the method used to map each location and the column that contains this information. 

Step Six

Group your records - In the Import Advanced Options, you can also choose to group your records and how to group them, in the Grouping section. 

 

If you want to group sets of records click on the Grouping section and tick the box next to Use Grouping. A list of all the columns included in your data file will be displayed, along with a Type dropdown box which allows you to define how you want your data to be grouped.

 

When Use Grouping has been selected the system automatically groups all records that share an identical location (for example an identical Postcode). If you would like to group by additional columns you can select Group By from the dropdown list next to the column that you wish to group. You can select to group by as many columns as you wish and the system will group all records that share an identical value in the relevant column(s).

 

For the remaining columns that you have not selected to group by, you can choose how the data should be displayed. The options depend on whether the column is numeric or not: 

 

Numeric options for grouped records 

Sum – the system will show a total in this column for each grouped record Average – the system will show a mean value for each grouped record Min – the system will show the lowest value from the group for each grouped record Max – the system will show the maximum value from the group for each grouped record 

 

Non numeric options for grouped records 

First – the system will show the value of the first record from the group for each grouped record List – the system will show a list of all the values for the relevant column in the group for each grouped record. 

 

Return to the preview screen by clicking the Import Data back arrow button. 

Step Seven

Check how many of your records can be displayed - Press Confirm Preview to import and group the full set of records. 

 

Once imported the Matched Records figure shows how many of your records could be located on the map. Any Records that could not be matched will have ‘Unmatched’ in the Location Match column in the Data View below. You will need to update the column in the import file and start the import process again if you wish to include the unmatched records.

 

 Once you are happy with the Matching Results, press Create Layer and wait until the processing is complete. Your layer will then be created and ready for use

Step Eight

View grouped records in Datagrid - The imported record details can be viewed in the datagrid below the map. Note that if the system has managed to group sets of records based on the Grouping options that you selected, then the number of records in the datagrid will be less than the number of records imported. 

 

The COUNT column in the datagrid shows the number of unique records from the input file which have been grouped together as part of the output.