Indexing Capability for ArcGIS 10 Mapbooks (data driven pages)

05-12-2010 06:36 AM
Status: Open
Labels (1)
New Contributor II

I am hoping to be able to use Data Driven Pages in ArcGIS 10 to create mapbooks.  I have used (30-day trial) software from MapLogic called "Layout Manager" (one time intial cost $1200 - my City cannot pay).  It is the industry leader for the moment.  One strong capability of that software is indexing.  Lets say you create a "Fire District Map" showing the city's roads, streets, hydrant locations, and more.  THERE MUST BE AN INDEX FOR EVERY MAPBOOK (if desired).  The index software figures out for every segment of road or streets which pages of the mapbook contain these streets.  Long Hill Ave may appear on 6 different pages.  It must list those pages.  Constitution Boulevard will also appear an many pages.  The index will tell you which pages to look for that Boulevard.  Huntington Circle will be on one page only.  The index confirms which page.  The index is usually located as a separate section at the end of the mapbook.  The user should have options as to how the index is formated (font, font size, comma delimited page numbers, 1-2-3 column formating, in alphabetical order with option for a break and large capital letter between each alphabet group, page numbering, and so forth.

A fireman going to a fire needs to quickly see which page(s) of the mapbook he needs to turn to to get to the fire and find the hydrant location.  It may be a matter of life or death.  An INDEXING CAPABILITY is VERY IMPORTANT!

[To my knowledge, ArcGIS 10 does not have this capability yet.]  I have been asking ESRI about this.

This is absolutely HUGE.  We have created a 921 polygon grid, with 6 diffrent map books, and one of the terrible challenges of them is that users can't easily find which map to go to.  We are looking at individual hyperlinking every one to a source PDF, but this is time-consuming, and it's not dynamic - so when the pages change, our links are destroyed.  We'd be looking at upwards of 4,000 links! If ESRI gives me a map book, but no index, it's like making a book with no binding - just a bunch of loose sheets flying around in the wind! 
For any others like me reading this who aren't familiar with every tool in the toolbox, here's how you get to the join tool dogtato mentioned.  It's in the Analysis toolbox > Overlay > Spatial Join, then make a new item under "Field Map of Join Features" to find the merge rules and delimiters.
(Until now the only joins I knew of were under Joins & Relates, which doesn't have any kind of rules or delimiters.  It took about an hour on Google to find the right spatial join tool.  All the search results talked about how to use the tool in python and not how to find it in the toolbox.)

I just wanted to confirm how important the street index is for a map book.  These posts that say a map book is useless without a street index are 100% correct.  I used dogtato's idea of the spatial join with the delimiter and it works great.  It took some time to get it to come out the way I wanted it to but it works nonetheless.  I had to merge my centerline segments and increase the length of the pagename column because my page names were 4 digit USNG Grid numbers, but overall its an excellent workaround.
For thos of you interested in creating a street index for a Fire District Map or Map Book check out the Fire Run Book editing map in the ArcGIS for Local Government Resource Center

It was designed to address this specific issue. It uses Data Driven Pages to create individual map pages based on the user specified map index and includes two scirpts.  The first creates the street index based on a Fire Map Index feature class and the second script appends the title page, map pages and street index into a single PDF map book for printing.  Here is the blog post that introduces this map and other for the Fire Service industry.  There are also accompanying videos to see how it works before you download the map doc.
Hi guys, how do I get the Grid Index Features tool to make certain size grids, e.g A3 size paper and 1:5,000 scale? I have to print a plantation map (18,000 ha's) on a A3 size map book in 1:3,000 scale...I used DS Map Books in ArcGis 9.3.1 but now that I have to use ArcView10 I struggle with the index grid feaature and data driven pages...
I wish there was a way to quickly create a street name index for a mapbook like we used to be able to do with DSMapBook.  I read a blog (from 2007) about how to do it manually by spatial join, export to Excel, and manually cutting/copying/pasting and otherwise manipulating the index.  This may work for a small area with only a few streets, but we have a large county with thousands of street names.  It took my analyst over 6 hours to produce the index using the blogs methodology.  And we need to update the mapbook and index quarterly for our first responders and law enforcement officers.

The code was there in DSMapBook.  Can't it be integrated into the new Data Driven Pages functionality?
I cooked up my own version using ArcPy if you want to give that a shot.
I have been trying to find a work around for this for some time. 

The best I can come up with is to add a data driven page name to the attributes for what you want to display.  In my case it is customer location id's and names.  You can add the table to the layout.  This may not work for roads if there is more than on part of a given road name.

The use the data driven page option for defintion query.  However, it works best to have a second copy of the feature in question.  The bad part is yout have to manually refresh the table each time you change a data driven page.
Thanks hiker4k, but I'm not a programmer.  I REALLY need Esri to help.  As I said in the original post, the code existed in SDMapBook.  Why can't it be integrated into the new Data Driven Pages???

Here is the most up-to-date ArcGIS solution that contains the ability to generate a street index. 

Introduction to Fire Service Maps—ArcGIS Solutions | Documentation