Adding map contents to Esri Redistricting Online from point locations

Esri Redistricting Online supports geocoding from a Microsoft Excel document. Geocoding is the process that assigns a street or coordinate location (taken from the Microsoft Excel file) and draws the location on the map. You can upload the address or coordinate locations to your redistricting plans to help you define district boundaries.

Esri Redistricting Online supports Microsoft Office 2007 (*.xlsx) and Microsoft Office 1997–2003 (*.xls) files. You can also upload addresses from Microsoft Excel that are stored on multiple worksheets in the same file.

This topic covers how to geocode the following from Microsoft Excel:

• Uploading addresses
• Uploading latitude-longitude coordinates

Note:

For Esri Redistricting Online to successfully read the Microsoft Excel file, the first row of your Excel file must be a header containing text. The Microsoft Excel file must not exceed 2MB.

Uploading addresses

As you create redistricting plans, you might want to geocode address locations to your district map. Esri Redistricting Online lets you upload addresses from Microsoft Excel to your district plan.

Esri Redistricting Online supports geocoding addresses that are single line, meaning the address is contained in one field, or across multiple columns. Once geocoded, you can identify each location to view attributes. Attributes are taken from the columns in your Excel file.

Steps:

1. On the File ribbon, click Add Content.
2. Click Locations.

   The Select file to upload dialog box opens.

3. Navigate to and choose the Microsoft Excel file you want to upload.
4. Click Open.
5. Choose the desired worksheet from the Worksheet menu (Optional).

   If the Microsoft Excel file uses only one worksheet, the worksheet is automatically populated. You will only see one worksheet listed in the menu.

   Esri Redistricting Online automatically maps the corresponding address columns.

   Note:

   If the addresses in the Microsoft Excel file are contained on a single line (compared to column breaks), use the Single Line menu and map to the corresponding address column.

6. Ensure the Address option is selected.
7. Update Import Name as desired (Optional).

   By default, the upload name is taken from the name of the Microsoft Excel file. The upload name will be the display name for the uploaded addresses layer on the Map Contents panel. You might want to customize this name if you are uploading addresses from one Microsoft Excel file that has multiple worksheets.

8. Map the address fields to the corresponding Microsoft Excel columns.
9. Choose the attribute columns to display.

   The attribute columns are displayed when you perform an identify on the address. You can include nonaddress columns as attributes for the location. This can be helpful to provide additional information on the address.

10. Choose a field by which to label the addresses from the menu (Optional).

    The Label option allows you to display a label for each address on the map. The available labels are taken from the column headings in the Microsoft Excel file.

11. Choose a label placement from the Place drop-down menu (Optional).
12. Use the Size slider to select the geocode symbol color (Optional).

    The preview updates as the geocode symbol size is modified.

13. Define the geocode symbol color (Optional).

    By default, the geocode symbol color is set to red.

14. Click Import.

    The geocoding process begins. A Completed message is displayed once all addresses have been geocoded. The Import Locations dialog box displays the number of addresses read, the number that succeeded, and the number that failed.

15. Click Details to view the processing records for each address (Optional).

    The Import Locations dialog box expands to display Located and Not Located tabs.

    The Not Located tab displays a Reason column that may indicate why the location could not be geocoded on the map. You can attempt to geocode addresses manually, using the following steps:

    1. On the Not Located tab, right-click an individual address.
    2. Click Correct Location.
    3. Enter the correct address for the entry.
    4. Click Find. A location found with the minimum score met is added to the list on the Located tab. If multiple results are found, click to geocode the correct address.

    Note:

    Once geocoded, you can use the Identify tool to view attribute information for the location. Click the Identify from arrow to expand <Excel File name> and choose Location. This allows you to identify against the geocoded addresses. For more information on using the Identify tool, see Identifying layers on the map.

16. Click Done.

Uploading latitude-longitude coordinates

As you create redistricting plans, you might want to geocode coordinate locations to your district map. Esri Redistricting Online lets you upload coordinates from Microsoft Excel to your district plan. Once geocoded, you can identify each location to view attributes. Attributes are taken from the columns in your Microsoft Excel file.

Steps:

1. On the File ribbon, click Add Content.
2. Click Locations.

   The Select file to upload dialog box opens.

3. Navigate to and choose the Microsoft Excel file you want to upload.
4. Click Open.
5. Choose the desired worksheet from the Worksheet menu.

   If the Microsoft Excel file uses only one worksheet, you will only see one worksheet listed in the menu.

   Esri Redistricting Online automatically maps the corresponding latitude and longitude columns.

6. Ensure the Latitude/Longitude option is selected.
7. Update Import Name as desired (Optional).

   By default, the upload name is taken from the name of the Microsoft Excel file. The upload name will be the display name for the uploaded coordinates layer in the Map Contents panel. You might want to customize this name if you are uploading multiple worksheets from one Microsoft Excel file.

8. Map the latitude and longitude fields to the corresponding Microsoft Excel columns.
9. Choose the attribute columns to display.

   The attribute columns are displayed when you perform an identify on the coordinates. You can include nonaddress columns as attributes for the location. This can be helpful to provide additional information on the coordinates.

10. Choose a field by which to label the coordinates from the Field drop-down menu (Optional).

    The Label option allows you to display a label for each coordinate location on the map. The available labels are taken from the column headings in the Microsoft Excel file.

11. Choose a label placement from the Place drop-down menu (Optional).
12. Define the geocode symbol color (Optional).
    Note:

    By default, the geocode symbol color is set to red.

13. Click Import.

    The geocoding process begins. A Completed message is displayed once all coordinates have been geocoded. The Import Locations dialog box displays the number of coordinates read, the number that succeeded, and the number that failed.

14. Click Details to view the processing records for each address (Optional).

    The Import Locations dialog box expands to display Located and Not Located tabs.

    The Not Located tab displays a Reason column that may indicate why the location could not be geocoded on the map. You can attempt to geocode coordinates manually, using the following steps:

    1. On the Not Located tab, right-click an individual coordinate entry.
    2. Click Correct Location.
    3. Enter the correct address for the entry.
    4. Click Find. A location found with the minimum score met is added to the list on the Located tab. If multiple results are found, click to geocode the correct address.

    Note:

    Once geocoded, you can use the Identify tool to view attribute information for the location. Click the Identify from arrow, click to expand <Excel File name>, and choose Location. This allows you to identify against the geocoded addresses. For more information on using the Identify tool, see Identifying layers on the map.

15. Click Done.