topic Join, Relate or Relationship? in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/join-relate-or-relationship/m-p/203177#M6964 <HTML><HEAD></HEAD><BODY><SPAN>Hi all, tia for reading. I have Alberta postal code points (just shy of 1 million) and municipal boundary polygons (444 polygons) and I'm trying to find a good way to create an output feature class that lists all 1 million postal codes and append the code for the municipal polygon.</SPAN><BR /><BR /><SPAN>Postal code fields=</SPAN><BR /><SPAN>objectID, Lat, Long, Postal Code</SPAN><BR /><SPAN>OBJECTID * PostalCode * Latitude Longitude Place Province Shape * </SPAN><BR /><BR /><SPAN>Municipal Polygon fields (SGC Boundaries)=</SPAN><BR /><SPAN>OBJECTID * Shape * </SPAN><STRONG>CSDUID</STRONG><SPAN> CSDNAME CSDTYPE PRUID PRNAME CDUID CDNAME CDTYPE CCSUID CCSNAME Muni_Code Shape_Length Shape_Area</SPAN><BR /><BR /><SPAN>So far, I've failed to successfully spatially join them and have the results create a new feature class with SGC Codes appended to the Postal Codes. CCSUID represents the 7 digit code I'd like to relate.</SPAN><BR /><BR /><SPAN>Thanks again,</SPAN><BR /><BR /><SPAN>Kevin McClement</SPAN><BR /><SPAN>GIS Analyst</SPAN><BR /><SPAN>Government of Alberta</SPAN></BODY></HTML> Wed, 13 Feb 2013 19:22:57 GMT KevinMcClement 2013-02-13T19:22:57Z Join, Relate or Relationship? https://community.esri.com/t5/geoprocessing-questions/join-relate-or-relationship/m-p/203177#M6964 <HTML><HEAD></HEAD><BODY><SPAN>Hi all, tia for reading. I have Alberta postal code points (just shy of 1 million) and municipal boundary polygons (444 polygons) and I'm trying to find a good way to create an output feature class that lists all 1 million postal codes and append the code for the municipal polygon.</SPAN><BR /><BR /><SPAN>Postal code fields=</SPAN><BR /><SPAN>objectID, Lat, Long, Postal Code</SPAN><BR /><SPAN>OBJECTID * PostalCode * Latitude Longitude Place Province Shape * </SPAN><BR /><BR /><SPAN>Municipal Polygon fields (SGC Boundaries)=</SPAN><BR /><SPAN>OBJECTID * Shape * </SPAN><STRONG>CSDUID</STRONG><SPAN> CSDNAME CSDTYPE PRUID PRNAME CDUID CDNAME CDTYPE CCSUID CCSNAME Muni_Code Shape_Length Shape_Area</SPAN><BR /><BR /><SPAN>So far, I've failed to successfully spatially join them and have the results create a new feature class with SGC Codes appended to the Postal Codes. CCSUID represents the 7 digit code I'd like to relate.</SPAN><BR /><BR /><SPAN>Thanks again,</SPAN><BR /><BR /><SPAN>Kevin McClement</SPAN><BR /><SPAN>GIS Analyst</SPAN><BR /><SPAN>Government of Alberta</SPAN></BODY></HTML> Wed, 13 Feb 2013 19:22:57 GMT https://community.esri.com/t5/geoprocessing-questions/join-relate-or-relationship/m-p/203177#M6964 KevinMcClement 2013-02-13T19:22:57Z