My overall objective is to create a time line animation depicting when a person is working in a particular region. The .dbf table consists of over 6000 record entries of shift data, including date start and date stop times along with an assignment ID. I have approximately 100 different shapes/regions also with assignment ID's. I would like for that region to turn on or off based of the table shift data and show when someone is working that region.

When I join the table to the shapefile, only the first shift entry gets attached and displayed. Do I have to have 6000 shapes for each of the 6000 record entries?

There has to be a better way, please help.

  • can we get some small screenshots or data samples?
    – Brad Nesom
    Commented Apr 26, 2011 at 14:16
  • try arcscripts.esri.com/details.asp?dbid=15260 Join - (shapefile to shapefile / dbf to shapefile)
    – Mapperz
    Commented Apr 26, 2011 at 14:17
  • Do you have the Tracking Analyst extension for ArcGIS?
    – Sean
    Commented Apr 26, 2011 at 15:19

1 Answer 1


It sounds like you need to do a many-to-one relationship join.

  • I'm not certain that processing for relationships is fully functional in ArcGIS 10 without an ArcInfo license. If this is the case, you may need to reconsider your methodology moving forward.
    – Nathanus
    Commented Apr 26, 2011 at 14:59
  • Creating related tables (an ArcMap function) is available to ArcView and above licenses. Creating Relationship Classes (a geodatabase function) is available to ArcEditor & ArcInfo license. This help page details the differences- help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/… Commented Apr 26, 2011 at 15:28
  • When I join the poly shape file to the table only the first shift entry from the table attaches, one for each shape. I can join the table to the shape file and the attribute table comes out the way it should, all 6000 shifts connected to each shape based off of the assign ID field, but how do I get a table to display a shape? Hope that makes since! Tried attaching a screen shot, but not sure how on this website. Thank you all for your help/input!
    – Susan
    Commented Apr 26, 2011 at 17:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.