How to assign multiple values to a single point field in arcmap

1546
8
Jump to solution
02-02-2017 06:37 AM
Highlighted
New Contributor III

I work for a utility company and we do a survey on our assets every year and was wondering if there was a way to stack dates into a field for 1 single point???

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
Regular Contributor II

Linking or stacking lots of data to a single point can be accomplished by data design using relates.  For example pictured below is a point field that is linked to an inspection table.  For any one point, we can have many inspections attached to the point.  In my geodatabase I have linked the Inspection table to Points.  In GIS I would use a relate to joint my points to the Inspection table linking on a common field found in both "LocationID".  After you use a relate if you click the point with the information button all of its "related" inspection will show for the one point.  Joins and relates

Using a personal geodatabase

There are other ways to address this issue including programming or the carefull use of joins.....

View solution in original post

8 Replies
Highlighted
Regular Contributor II

Linking or stacking lots of data to a single point can be accomplished by data design using relates.  For example pictured below is a point field that is linked to an inspection table.  For any one point, we can have many inspections attached to the point.  In my geodatabase I have linked the Inspection table to Points.  In GIS I would use a relate to joint my points to the Inspection table linking on a common field found in both "LocationID".  After you use a relate if you click the point with the information button all of its "related" inspection will show for the one point.  Joins and relates

Using a personal geodatabase

There are other ways to address this issue including programming or the carefull use of joins.....

View solution in original post

Highlighted
New Contributor III

Ted,

Thank you for this advice. I will certainly try this method for my data design and creation.

Reply
0 Kudos
Highlighted
MVP Regular Contributor

Ted has the right idea.  Keep an 'Inspections' table in the geodatabase with a relationship to the asset.  Whenever the asset is inspected, update the 'Inspections' table with the date and any other attributes. 

Reply
0 Kudos
Highlighted
New Contributor III

This worked great. Thank you for your help!

Reply
0 Kudos
Highlighted
Regular Contributor II

Could you mark Ted Kowal  Reply As Correct Answer

Highlighted
New Contributor III

Done!

Highlighted
Regular Contributor II

You should mark Ted Kowal  answer , not your answer.

Reply
0 Kudos
Highlighted
New Contributor

May I also add that relate works for 1-1 or 1-M relationships etc.. It is important to acknowledge this in the aspect of data design.