Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My overall objective is to create a timeline 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 approximatly 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 shape file, 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.

Thank you!

share|improve this question
can we get some small screenshots or data samples? – Brad Nesom Apr 26 '11 at 14:16
try Join - (shapefile to shapefile / dbf to shapefile) – Mapperz Apr 26 '11 at 14:17
Do you have the Tracking Analyst extension for ArcGIS? – Sean Apr 26 '11 at 15:19

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

share|improve this answer
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 Apr 26 '11 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-… – RyanDalton Apr 26 '11 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 Apr 26 '11 at 17:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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