When you publish a hosted feature layer from a comma-separated values (CSV) or Microsoft Excel file containing addresses, you can review the placement of the address points on the map and attempt to place any features that the portal could not locate using the locator you chose when you published.
Note:
You cannot view addresses in hosted feature layers published to a 10.3.1 or earlier release portal.
When the hosted feature layer is first published, a message appears indicating how many of the addresses were located using the geocoding service you chose when publishing. You are asked to review locations when the publishing process completes. To open Map Viewer and immediately review the placement of features, choose Yes. If you want to review feature placement at a later time, choose No. When you're ready to review, open the hosted feature layer's item page and click Review Locations under the layer name in the Layers section of the Overview tab.
When the layer opens in Map Viewer, a table opens at the bottom of the map. The table lists all unmatched and matched addresses. The Review Locations pane also appears. When you choose a record in the table at the bottom of the map, the Review Locations pane is populated with suggested matching locations.
Note:
Addresses will be reviewed against the geocoding service specified when the layer was published; you cannot change geocoding services to match addresses after publishing.
Only the hosted feature layer owner or an administrator can review addresses.
First, review any addresses for which the portal could find a match.
Review unmatched locations
Any addresses from the CSV or Excel file that could not be located are listed in the Unmatched addresses table at the bottom of the map. There are three ways to find a match for an unmatched address. These are described in the next three sections.
Choose a suggested location
The easiest way to find a location for an unmatched address is to use the suggestions in the Review Locations pane. The portal suggests locations that are similar to the address information in your file.
- Select an address in the Unmatched addresses table.
When you select a record in the table, a list of suggested locations appears in the Review Locations pane, and the map zooms to the extent of all suggested locations.
- Select a suggested address in the Review Locations pane. This selects the corresponding point on the map. Zoom in to the selected point to be sure the suggested location is correct.
- If the location is correct, click Match in the point's pop-up window to approve the new location.
- If the location is not correct, select and review other suggested locations until you find a match.
- If none of the suggested locations are correct, try changing the address information in the Unmatched addresses table.
- Be aware that matching a suggested address to an unmatched address does not update the address attribute information in your layer. If you want the address information in your table to be the same as the suggested address information, edit the data in the table. For example, when you match the address 123 Main Street to 123 E. Main St., the address remains 123 Main St. in the layer's table. If you want the address in the layer to be 123 E. Main St., type that in the Unmatched addresses table.
- Repeat the previous steps for all unmatched addresses.
Edit the address information and choose a suggested location
If there are no suggested locations for your unmatched address, or the suggested locations are not correct, try changing the address information in the unmatched addresses table.
- Select an address in the Unmatched addresses table.
- Correct any address information you know is incorrect. For example, if the city name is spelled incorrectly or the address numbers are transposed, double-click the cell that contains the incorrect information and type the correct information.
As you type new information in the table, the Review Locations pane is populated with suggested matching locations.
- Select a suggested address in the Review Locations pane. This selects the corresponding point on the map. Zoom in to the selected point to be sure the suggested location is correct.
- If the location is correct, click Match in the point's pop-up window to approve the new location.
- If the location is not correct, select and review other suggested addresses until you find a match.
- If none of the suggested addresses are correct, you can manually place a point on the map.
- Repeat the previous steps for the remaining unmatched addresses.
- Be aware that matching a suggested address to an unmatched address does not update the address attribute information in your layer. If you want the address information in your table to be the same as the suggested address information, edit the data in the table. For example, when you match the address 123 Main Street to 123 E. Main St., the address remains 123 Main St. in the layer's table. If you want the address in the layer to be 123 E. Main St., type that in the Unmatched addresses table.
Add a point to the map
If none of the suggested locations are correct even after you change the address information for your unmatched addresses, you can choose to place a point on the map for the unmatched addresses.
- Select a row in the Unmatched table.
- Zoom to the location on the map where the address should be.
- Click on the map to add a point for the selected location.
A point with a yellow marker is added to the map and the pop-up window for that location appears.
- If the location you designated on the map is correct, click Match in the pop-up window to approve the new location.
- Repeat the previous steps for the remaining unmatched locations.
- If you want to perform a quality control check of the matched addresses, proceed with the steps in the next section. If you do not want to check the matched addresses and have finished reviewing and matching all addresses, click Done Reviewing in the Review Locations pane.
For quality control purposes, you can also review matched locations for accuracy.
Review matched locations
You can review the accuracy of the addresses that your portal matched to locations on the map.
- Click Matched to see a list of all addresses that were located on the map.
- If you see any mistakes in the table, double-click the appropriate cell and type the correct information.
- When you select a matched address, the Review Locations pane is populated with suggested matching addresses. The matched address location is denoted by a green marker symbol.
- Zoom to the matched location to be sure it is in the correct place.
- If it is, select the next row in the Matched table to review it for accuracy.
- If it is not, select another suggested location from the Review Locations pane. Zoom to the suggested location to see if it is correct. If it is, click Match in the pop-up window to approve the new location. If it is not, try other suggested locations until you find the correct one.
- If none of the suggested locations are correct, zoom to the location on the map where the address should be and click the map to add a point manually. If the point you added is in the correct place, click Match in the pop-up window to approve the new location.
- Repeat the previous steps for the remaining matched locations.
- When you finish reviewing and matching all addresses, click Done Reviewing in the Review Locations pane.