topic Re: How to assign multiple values to a single point field in arcmap in Data Management Questions https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641515#M36268 <HTML><HEAD></HEAD><BODY><P>Linking or stacking lots of data to a single point can be accomplished by data design using relates. &nbsp;For example pictured below is a point field that is linked to an inspection table. &nbsp;For any one point, we can have many inspections attached to the point. &nbsp;In my geodatabase I have linked the Inspection table to Points. &nbsp;In GIS I would use a relate to joint my points to the Inspection table linking on a common field found in both "LocationID". &nbsp;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. &nbsp;<A href="http://pro.arcgis.com/en/pro-app/help/data/tables/joins-and-relates.htm">Joins and relates</A></P><P></P><P><IMG alt="Using a personal geodatabase" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/313699_Relationships.png" style="height: auto;" /></P><P></P><P>There are other ways to address this issue including programming or the carefull use of joins.....</P></BODY></HTML> Thu, 02 Feb 2017 15:40:12 GMT TedKowal 2017-02-02T15:40:12Z How to assign multiple values to a single point field in arcmap https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641514#M36267 <HTML><HEAD></HEAD><BODY><P>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&nbsp;dates into a field for 1 single point???</P></BODY></HTML> Thu, 02 Feb 2017 14:37:21 GMT https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641514#M36267 AmyHarrigan 2017-02-02T14:37:21Z Re: How to assign multiple values to a single point field in arcmap https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641515#M36268 <HTML><HEAD></HEAD><BODY><P>Linking or stacking lots of data to a single point can be accomplished by data design using relates. &nbsp;For example pictured below is a point field that is linked to an inspection table. &nbsp;For any one point, we can have many inspections attached to the point. &nbsp;In my geodatabase I have linked the Inspection table to Points. &nbsp;In GIS I would use a relate to joint my points to the Inspection table linking on a common field found in both "LocationID". &nbsp;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. &nbsp;<A href="http://pro.arcgis.com/en/pro-app/help/data/tables/joins-and-relates.htm">Joins and relates</A></P><P></P><P><IMG alt="Using a personal geodatabase" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/313699_Relationships.png" style="height: auto;" /></P><P></P><P>There are other ways to address this issue including programming or the carefull use of joins.....</P></BODY></HTML> Thu, 02 Feb 2017 15:40:12 GMT https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641515#M36268 TedKowal 2017-02-02T15:40:12Z Re: How to assign multiple values to a single point field in arcmap https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641516#M36269 <HTML><HEAD></HEAD><BODY><P>Ted,</P><P>Thank you for this advice. I will certainly try this method for my data design and creation.</P></BODY></HTML> Thu, 02 Feb 2017 15:57:54 GMT https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641516#M36269 AmyHarrigan 2017-02-02T15:57:54Z Re: How to assign multiple values to a single point field in arcmap https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641517#M36270 <HTML><HEAD></HEAD><BODY><P>Ted has the right idea. &nbsp;Keep an 'Inspections' table in the geodatabase with a relationship to the asset. &nbsp;Whenever the asset is inspected, update the 'Inspections' table with the date and any other attributes.&nbsp;</P></BODY></HTML> Thu, 02 Feb 2017 18:27:21 GMT https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641517#M36270 MitchHolley1 2017-02-02T18:27:21Z Re: How to assign multiple values to a single point field in arcmap https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641518#M36271 <HTML><HEAD></HEAD><BODY><P>This worked great. Thank you for your help!</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/314276_pastedImage_1.png" /></P></BODY></HTML> Fri, 03 Feb 2017 13:14:11 GMT https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641518#M36271 AmyHarrigan 2017-02-03T13:14:11Z Re: How to assign multiple values to a single point field in arcmap https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641519#M36272 <HTML><HEAD></HEAD><BODY><P>Could you mark <A _jive_internal="true" data-userid="5768" data-username="tkowal" href="https://community.esri.com/people/tkowal"><SPAN style="color: #8ca9cd; font-size: large;">Ted Kowal</SPAN></A>&nbsp; Reply As <STRONG>Correct Answer </STRONG></P></BODY></HTML> Fri, 03 Feb 2017 16:34:17 GMT https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641519#M36272 AbdullahAnter 2017-02-03T16:34:17Z Re: How to assign multiple values to a single point field in arcmap https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641520#M36273 <HTML><HEAD></HEAD><BODY><P>Done! <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 03 Feb 2017 16:36:48 GMT https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641520#M36273 AmyHarrigan 2017-02-03T16:36:48Z Re: How to assign multiple values to a single point field in arcmap https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641521#M36274 <HTML><HEAD></HEAD><BODY><P>You should mark <A _jive_internal="true" data-userid="5768" data-username="tkowal" href="https://community.esri.com/people/tkowal"><SPAN style="color: #8ca9cd; font-size: large;">Ted Kowal</SPAN></A>&nbsp; answer , not your answer.</P></BODY></HTML> Fri, 03 Feb 2017 18:04:17 GMT https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641521#M36274 AbdullahAnter 2017-02-03T18:04:17Z Re: How to assign multiple values to a single point field in arcmap https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641522#M36275 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 03 Feb 2017 18:16:17 GMT https://community.esri.com/t5/data-management-questions/how-to-assign-multiple-values-to-a-single-point/m-p/641522#M36275 DavidLok1 2017-02-03T18:16:17Z