How to select data from layers within an area or distance based on another layers selected feature on the map.
This document explains how to select records from various layers within an area or distance of another layers selected feature and then exporting the results to Excel. The following is an example workflow, but the methods apply to the majority of layers in the map. In some cases the examples below may not work at a scale where the map is zoomed more than halfway outside of the city due to the number of features and limited access to a layers visibility.
1. Launch the viewer.
2. On the left hand side of the map below the home panel text, find and click the ‘Layers’ tab next to the home button as seen below:
3. Find and turn on the Neighborhood layer by checking the box next to it. Zoom into a neighborhood of interest.
4. With the neighborhood located, you will now turn on the layers you want to select in the next step.*Note- a layer has to be visible in order to be available for selection.
5. Expand the ‘Permits and Land Use’ data group and turn on the ‘Subdivisions’ Layer. You should now have the Neighborhood and subdivisions layers both turned on.
6. Click the ‘I want to…’ button at the top left of the map and select the ‘Find data and information…” option.
7. Click on the map somewhere inside a neighborhood boundary. A list of results will appear on the left hand side. It may include many results in addition to the neighborhood result.
8. Look for the result that lists the neighborhood association, and click on it within the list. It should highlight yellow and re-center the map.
9. Above the neighborhood details on the left hand side, click the panel actions button as seen below:
10. Select ‘Show buffer options. *Note- there are a couple ways to use the tool depending on how you enter data as described below:
a. Using a distance of 0 tells the map to select features from only within the selected features boundary. OR
b. Using a distance and unit greater than 0 tells the map to find all features not only inside the selected area, but also those within the specified distance beyond the actual boundary. For example, if you wanted to find all businesses, parks or schools within a half mile of a property you would make those layers visible, select a property, and set the buffer distance to 0.5 miles.
11. Set the distance to 0.
12. Click ‘Continue’
13. After clicking continue, the map will select all the features from the visible layers on the map.
14. We can now export the results to excel. Click the panel actions menu button again:
15. Select export to .xlsx or other format if you like.
16. Click OK to confirm the download.
17. Open the file (or save it somewhere and open after it saves).
18. You should now have an Excel file with multiple worksheet tabs (one tab for each layer that was visible in the map), one of which is the subdivisions. You can modify, sort, and clean up and save the file as you like.