Any imported locations can be viewed both at the level of the entire file on what is known as the Location Files page, or each individual location on a page known as the File Details page.
- In the Location Files page you can download, share or delete your file
- In the File Details page you can add and remove locations, edit existing locations, and create location queries and filters
Please see the following video (11:38 mins) for an overview.
Required Inputs:
To access the Location Files page, click My Data > Locations in the side panel.
The Location Files page will open. Here you can see a list of any location files that have been previously imported. The list also includes details such as the number of records, the date when the file was imported and the user who imported it. For more information, please see Importing Locations opens in new window.
Managing Locations
A number of options can be found by clicking the gear icon at the top of the Location File page.
Download: download the location file (includes all individual locations in the location file)
Share: share the location file to other accounts within your workgroup (workgroups allow for you to easily share their assets with others)
Make Global: share the location file amongst all your workspaces
Make Local: stop sharing the location file to all your workspaces
Delete Selected: delete the selected location file
Delete All: delete all the location files
Additionally, if you click the gear icon on the right side of the file list, you can rename the file.
Selecting a location file will lead to the File Details page.
-
Within the File Details page, you can:
- Create trade areas around locations
- Edit existing location attributes
- Add new location records
- Delete location records
- Create filters
In the File Details page, a number of options can be found by clicking the gear icon
at the top of the page.
Select Filters - Select a previously created and saved filter query
Create Areas - Create areas around the locations (for more information, please see Creating Areas Around Locations opens in new window)
Delete Selected - Delete selected location(s) -
Add a location by selecting
.
A new row will be added.
-
Add information for each field, where required.
Locations must be added using the same format as the initial location import. For example, you will need to enter a full address if you imported the locations using Geocode Address. Similarly, you will need to enter both latitude and longitude if you imported locations using coordinates.
Once you are finished, click Save (found at the end of the row). Alternatively, you can click the 'x' if you wish to undo your additions.
Filtering & Querying Locations
Individual locations within a file can be easily filtered and queried. If you wanted to work only with locations in a specific city, or locations that fit a specific category, there is an easy way to do so.
The following are the primary functions and applications for filters and queries:
The above functions are defined below.
Filter Using the Search Bar
Within the locations page, you can quickly filter locations using the search bar.
Tip: Your search term will search through all fields of the location file.
Advanced Queries Using Specific Data Types
Advanced queries are available to filter based on values in one specific column of your locations. Additionally, you can save these queries for future use.
Note: In order to create a query on a non-standard column (i.e., a column that is not either address information or coordinates, or the name), you will need to have included that column as an additional field when you originally imported the location file. The querying options that are available will be dependent on the data type you assigned to the column of data when importing.
Query Categorical Data
-
To filter a categorical field, select the filter icon
which will then prompt the following filter dialog box.
-
Select the value you wish to filter by selecting or deselecting any of the check-boxes.
-
Click OK. The list is filtered and the query is added to the Results Query box.
Note: To clear a filter, click Clear under the Result Query box OR click the filter icon
Query Numerical Data
Locations can be filtered using numerical data fields. Some examples of numerical data include:
- Sales
- Spatial size
- Number of employees
-
Within the File Details page, select the filter icon
-
Hover over the Number Filters to view the available operators.
-
The different operators are defined below. Selecting any of the operators will open the Custom Filter dialog box and pre-populates the column name and the first menu item.
Operator Definitions Operator Description Equal Filter everything that matches the exact value Not Equal Filter everything but the exact value Less Than Filter everything smaller than the value Less Than or Equal Filter everything smaller than or the same as the value Greater Than Filter everything larger than the value Greater Than or Equal Filter everything larger than or the same as the value Between Filter based on everything between two values Custom Filter Expanded options, including adding a second filter statement For example:
-
Enter a value. If necessary, you can add a second condition to your filter. Choose either the AND or OR options.
AND: Both statements must be true
OR: One statement or the other must be true
-
Enter a value and click OK when complete. The rows are filtered and the query statement is added to the Result Query box.
Query Text Data
Locations can be filtered using text data fields. Some examples of text data include:
- Name
- Category
- City
-
Within the File Details page, select the filter icon
-
Hover over Text Filters to see the available operators.
-
The different operators are defined below. Selecting any of the operators will open the Custom Filter dialog box and pre-populates the column name and the first menu item.
Operator Definitions Operator Description Equal Filter everything that matches the exact value Not Equal Filter everything but the exact value Starts With Filter everything that starts with a specific string of text Ends With Filter everything that ends with a specific string of text Contains Filter everything that contains a specific string of text Custom Filter Expanded options, including adding a second filter statement For example:
-
Use AND or OR operators if necessary.
AND: Both statements must be true
OR: One statement or the other must be true
-
Click OK when complete. The rows are filtered and the query statement is added to the Result Query box (below).
Query Date Data
Locations can be filtered using date format fields. Some examples of date data include:
- Store open/close date
- Lease start/end date
Note: Ensure that the appropriate date fields are turned ON when importing the location file. Date data must be formatted as YYYY-MM-DD. Date data that is imported incorrectly, cannot be filtered.
For example:
-
Within the File Details page, select the filter icon
-
Hover over the Date Filters to view the available operators.
-
The different operators are defined below. Selecting any of the operators will open the Custom Filter dialog box and pre-populates the column name and the first menu item.
Operator Definitions Operator Description Equal Filter everything that matches the exact value (date) Not Equal Filter everything but the exact value (date) Less Than Filter everything that is earlier than the value (date) specified Less Than Or Equal Filter everything that matches the exact value (date) or earlier Greater Than Filter everything that is later than the value (date) specified Greater Than Or Equal Filter everything that matches the exact value (date) or later Between Filter everything that is between the value (date) range Custom Filter Expanded options, including adding a second filter statement For example:
Use AND or OR operators if necessary.
AND: Both statements must be true
OR: One statement or the other must be true
-
Click OK when complete. The rows are filtered and the query statement is added to the Result Query box (below).
Saving Queries
-
Once a filter has been applied, you can save it within the Result Query box by clicking Save.
-
Enter a name for the filter and specify whether to make it available in all workspaces. Once complete, click Create.
-
To use a saved filter, select the gear icon
After clicking Done, the filter is applied and all filtered records are selected.