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???
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
There are other ways to address this issue including programming or the carefull use of joins.....
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.
You should mark Ted Kowal answer , not your answer.
Done!
Could you mark Ted Kowal Reply As Correct Answer
This worked great. Thank you for your help!
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.
Ted,
Thank you for this advice. I will certainly try this method for my data design and creation.
サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
