Data Driven Pages and Key Numbering

Question

Hello all-

My problem is two-fold.

I am making a mapbook for a client and am struggling putting it together in the most efficient manner.  I have a transmission line and parcels that intersect it along the way in my MXD.  I have already created an index polygon to use for data driven pages, but I am struggling with the labeling of the parcels.  My client wants each page to key number the parcels instead of labeling them individually on the map.

Each page has a polygon (which is the data driven pages index).  There are also parcels located within these polygons.  I need to find a way to spatially join the parcel attributes to the associated polygon that it is within.  I do realize this is a many-to-one relationship and cannot be done with a normal spatial join.  Does anyone know of a way to accomplish this?

Also, I want to only label the parcels that have their centroid located in the index of each sheet.  For example, parcels a, b, c, and d are located on page 22 (within the index polygon for page 22).  I only want to label those parcels and not the surrounding ones.  The catch is that I need them to be key numbered in a specific format (below).

Easement          Owner Name          Deed
a
b
c
d
 
If I can join the parcel attributes to each index polygon I think I can accomplish this with dynamic text and maybe a definition query?

Thank you in advance!!!

wightman_akibby · Answer

Instead of labeling the parcel within the polygon itself, they want me to label each with a number and list them on the page in list of sorts.

A few of the parcels are in multiple index polygons.

After a little more research, I guess I am trying to insert a dynamic table to work with the DDP.

Thank you!

MattSayler · Answer

My client wants each page to key number the parcels instead of labeling them individually on the map.

I'm not sure I understand that bit. Instead of labeling the parcels on the map, are you talking about listing them somewhere on the page or on a separate page, sort of like a road atlas does for streets?

Are the parcels only ever in one of the index polygons, or is there overlap?