topic Spatial Join multiple labels in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/spatial-join-multiple-labels/m-p/6077#M254 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I have done a spacial join with a land parcel layer as the target. The join is one to many using point features. The output table consequently can have multiple records with the one Target_Fid. For example, if there are three point features within a land parcel, three output records are produced. When I put 'Labels on' for the output I can have multiple values appearing. How can I limit the label for a particular parcel? The label field will always have the same value for each output record for the one parcel.</SPAN></BODY></HTML> Mon, 28 Apr 2014 22:05:03 GMT BobMCkay 2014-04-28T22:05:03Z Spatial Join multiple labels https://community.esri.com/t5/geoprocessing-questions/spatial-join-multiple-labels/m-p/6077#M254 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I have done a spacial join with a land parcel layer as the target. The join is one to many using point features. The output table consequently can have multiple records with the one Target_Fid. For example, if there are three point features within a land parcel, three output records are produced. When I put 'Labels on' for the output I can have multiple values appearing. How can I limit the label for a particular parcel? The label field will always have the same value for each output record for the one parcel.</SPAN></BODY></HTML> Mon, 28 Apr 2014 22:05:03 GMT https://community.esri.com/t5/geoprocessing-questions/spatial-join-multiple-labels/m-p/6077#M254 BobMCkay 2014-04-28T22:05:03Z Re: Spatial Join multiple labels https://community.esri.com/t5/geoprocessing-questions/spatial-join-multiple-labels/m-p/6078#M255 <HTML><HEAD></HEAD><BODY><SPAN>I have a way around it. The reason I needed to do a spatial join was to be able to do a SUM over the point feature values in each parcel.</SPAN><BR /><SPAN>The stat was done on a table of the joined data. I then rejoined the table to the already joined data with the multiple records for each Target_Fid. What I ended up doing is joining to the original parcel layer and hence only one record per parcel.&nbsp; Silly me.</SPAN><BR /><SPAN>Thanks to all viewers!</SPAN></BODY></HTML> Mon, 28 Apr 2014 23:34:22 GMT https://community.esri.com/t5/geoprocessing-questions/spatial-join-multiple-labels/m-p/6078#M255 BobMCkay 2014-04-28T23:34:22Z