HOW TO

Create a street index for use with Data Driven Pages

Last Published: September 1, 2022

Summary

The instructions provided in this article describe two methods used to create a street index for use with Data Driven Pages.

With the introduction of Data Driven Pages at version 10, requests have been made to include the ability to create a street index page. Although this is not available out of the box, there are ways to produce a street index for the map book.

Procedure

This article addresses two methods for adding a street index. Either option may be used, depending on the system environment and user needs.

Use Python

Use the following script tool at ArcGIS Online that processes the data to make the index, GenerateMapBookWithIndexPages_10_v2. Modify the Python script sample as desired.

Use DBF table

  1. Intersect the streets feature class with the map grid index feature class using the Spatial Join tool.
    1. In ArcMap, navigate to ArcToolbox > Analysis Tools > Overlay > Spatial Join. The Spatial Join window opens.
    2. In the Spatial Join window, fill in the required fields and parameters as follows:
      • Target Features: The target streets layer. In this example, the streets layer is F_Atlanta_Streets_Int.
      • Join Features: The map grid index layer. In this example, the input is B_PrimaryIndex.
      • Join Operation (optional): Select JOIN_ONE_TO_MANY.
      • Leave the other parameters as default.
    3. Click OK to run the tool.
The Spatial Join tool window displaying the Target Features, Join Features, and Join Operation (optional) parameters. Click OK.
  1. Add a new text field to the attribute table of the desired field.
    1. Open the attribute table of the feature class created in Step 1.
    2. Add a new text field to the attribute table. Refer to ArcMap: Adding fields for instructions.
  2. Concatenate the street name and page number fields.
    1. In the attribute table, right-click the newly created field in Step 2, and click Field Calculator.
    2. In the Field Calculator window, in the NewTextField section, copy and paste the following to concacenate the street name and the page number fields. In this example, they are FullName and PageNumber:
[FullName]& "" &[PageNumber]).
  1. Click OK.
The Field Calculator window displaying the expression to concatenate the street name and page number fields.
  1. Summarize the new field to remove duplicates.
    1. In the attribute table, right-click the newly created field with the generated results from Step 3, and click Summarize.
    2. In the Summarize window, click OK.
    3. When prompted with 'Do you want to add the result table in the map?', click Yes.
The Summarize window displaying the newly created field as the input. Click OK.
  1. In the Table Of Contents, open the created .dbf file in Microsoft Excel and make the desired changes. Print or convert the table to the desired format and add it to the map book.
Note:
This table can be added into the layout using the other add-in, arcpy.mapping map book with Dynamic Graphic Tables, listed in the Related Information links below. Moreover, 'insert object' and 'add table to layout' are options to add static tables to the layout.

Article ID:000011455

Software:
  • ArcMap

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic