Create a new layer - To add your own data, Open or Create a new project and then choose Add Data, Create New Layer.
Choose which type of layer to create - Select Map Pins to add each of the rows in your data as points on the map.
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
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.
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.
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.
Use Existing Layer - To use an existing layer, Open or Create a new project and then choose Add Data, Use Existing Layer.
Add the Existing Layer
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.
Return to the project
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.
Copy existing Map Pins layer - To create a Hot-Spot layer from an existing Map Pins layer, Open an existing project that contains the Map Pins layer that you wish to base the Hot-Spot layer on, and then select Add Data, and choose Create New Layer.
Choose which type of layer to create - Select Hot-Spot Map to add each of the rows in your data as hotspots on the map.
Copy Existing Layer - To add Hot-Spots to the map, you can build a Hot-Spots layer by copying the data from an existing Map Pins layer. Select Copy Existing Layer to create a Hot-Spots layer from an existing Map Pins layer.
Choose a Map Pins layer - Select the Map Pins layer that contains the data which you wish to create your Hot-Spot layer from.
Choose boundaries and data - Select the boundary which you would like to group your data by. The system will then automatically prompt you to choose which column from your data you would like to use to create the Hot-Spot layer. Select Confirm to create the new Hot-Spot layer.
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.
Choose which type of layer to create - Select Map Pins to add each of the rows in your data as points on the map.
Manually place pins onto your map - Choose Manually Place Pins to add Map Pins one at a time to your map.
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.
Name your Map Pin - Under the Pin Name dropdown, type a name for your new Map Pin in the text box.
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.
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.
Select your target layer - Select the layer you wish to update from the target layer dropdown
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.
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.
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.
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
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.
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.
Create new layer - To add and group your own data, Open or Create a new project and then choose Add Data, Create New Layer.
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
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.
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.
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.
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.
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
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.
