topic Spatial Join - Identifying the correct polygon to merge with (condo buildings) in 3D Cities / Campuses Questions https://community.esri.com/t5/3d-cities-campuses-questions/spatial-join-identifying-the-correct-polygon-to/m-p/791302#M29 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have created an address locator where the reference data is a shapefile of county parcel data. I then geocoded utility service addresses using my custom locator, which worked quite well. However, I am having trouble relating the parcel APN (feature in shapefile) to the geocoded utility address attribute table. I have tried to select the APN as the point address ID and as 'additional field' when making an address locator, but this does not work. The reason I cannot do a simple spatial join is that some condo buildings have four parcel APNs in the same area. I need to select which utility address matches each condo.</P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/439206_shapefile_features.PNG" /><IMG alt="The darker shading indicates multiple APNs for a given area (due to multiple floors of condos). Each condo has one or more utility service accounts" class="image-2 jive-image" height="366" src="https://community.esri.com/legacyfs/online/439207_multiple_apns.PNG" width="322" /></P><P>I'm assuming that, since the utility addresses are being geocoded to the centroid of each parcel, that I should be able to extract the parcel APN and place it in the resulting geocode output.</P><P></P><P>Thank you!</P><P>-Robert</P></BODY></HTML> Mon, 11 Mar 2019 23:33:10 GMT RobertSpragg 2019-03-11T23:33:10Z Spatial Join - Identifying the correct polygon to merge with (condo buildings) https://community.esri.com/t5/3d-cities-campuses-questions/spatial-join-identifying-the-correct-polygon-to/m-p/791302#M29 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have created an address locator where the reference data is a shapefile of county parcel data. I then geocoded utility service addresses using my custom locator, which worked quite well. However, I am having trouble relating the parcel APN (feature in shapefile) to the geocoded utility address attribute table. I have tried to select the APN as the point address ID and as 'additional field' when making an address locator, but this does not work. The reason I cannot do a simple spatial join is that some condo buildings have four parcel APNs in the same area. I need to select which utility address matches each condo.</P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/439206_shapefile_features.PNG" /><IMG alt="The darker shading indicates multiple APNs for a given area (due to multiple floors of condos). Each condo has one or more utility service accounts" class="image-2 jive-image" height="366" src="https://community.esri.com/legacyfs/online/439207_multiple_apns.PNG" width="322" /></P><P>I'm assuming that, since the utility addresses are being geocoded to the centroid of each parcel, that I should be able to extract the parcel APN and place it in the resulting geocode output.</P><P></P><P>Thank you!</P><P>-Robert</P></BODY></HTML> Mon, 11 Mar 2019 23:33:10 GMT https://community.esri.com/t5/3d-cities-campuses-questions/spatial-join-identifying-the-correct-polygon-to/m-p/791302#M29 RobertSpragg 2019-03-11T23:33:10Z