topic Re: Matching regions across two shapefiles in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/matching-regions-across-two-shapefiles/m-p/463582#M15592 <HTML><HEAD></HEAD><BODY><SPAN>The inconsistency in boundaries from different data sources may exist, even when the datasets are in the same coordinate system. So, instead of using the county polygons, you can try to use points that represent the polygons:</SPAN><BR /><BR /><SPAN>1. Use Feature To Point tool (Data Management toolbox - Features toolset) with the "Inside" option to get county_points from county_polygons. Each point carrries the county_polygons FID and attributes.</SPAN><BR /><SPAN>2. Use Spatial Join tool to find INTERSECT matches between county_points and the division_polygons. Now the spatialJoined_county_points have division polygon attributes.</SPAN><BR /><SPAN>3. Use Join Field to join county_polygons with the spatialJoined_county_points via the county_polygons FID to transfer the division attributes to county_polygons.</SPAN></BODY></HTML> Tue, 08 May 2012 21:16:47 GMT DanLee 2012-05-08T21:16:47Z Matching regions across two shapefiles https://community.esri.com/t5/geoprocessing-questions/matching-regions-across-two-shapefiles/m-p/463579#M15589 <HTML><HEAD></HEAD><BODY><SPAN>I have two shapefiles that I'm working with - one of US counties and one of US climate divisions (which are subsets of US states). I would like to match each county to the climate division that it is located in. The only common variable that the two shapefiles contain is "state". </SPAN><BR /><BR /><SPAN>I'm not sure which tool I should use to achieve this. I know I need to match counties to divisions based on geographic coordinates alone, but I have no idea how to do that. Any suggestions would be appreciated!</SPAN></BODY></HTML> Mon, 07 May 2012 21:16:00 GMT https://community.esri.com/t5/geoprocessing-questions/matching-regions-across-two-shapefiles/m-p/463579#M15589 TatyanaDeryugina1 2012-05-07T21:16:00Z Re: Matching regions across two shapefiles https://community.esri.com/t5/geoprocessing-questions/matching-regions-across-two-shapefiles/m-p/463580#M15590 <HTML><HEAD></HEAD><BODY><SPAN>You can try Spatial Join tool (Analysis toolbox - Overlay toolset) with the INTERSECT match option.</SPAN></BODY></HTML> Mon, 07 May 2012 22:39:23 GMT https://community.esri.com/t5/geoprocessing-questions/matching-regions-across-two-shapefiles/m-p/463580#M15590 DanLee 2012-05-07T22:39:23Z Re: Matching regions across two shapefiles https://community.esri.com/t5/geoprocessing-questions/matching-regions-across-two-shapefiles/m-p/463581#M15591 <HTML><HEAD></HEAD><BODY><SPAN>Thank you, Dan! That almost worked. My .shp files seem to be in different spatial coordinates (one is GSC_North_American_1983, the other is GSC_WGS_1984). I tried a few transformations, but there doesn't appear to be an exact one. As a result, some counties get matched to multiple divisions (I allowed, "one-to-many" match) because their borders spill over a tiny bit. I've tried "one-to-one" matching and that seems to work, but I'm not sure how it chooses which division to match to - would it be the one that matches best (that would be ideal)?</SPAN></BODY></HTML> Tue, 08 May 2012 20:49:45 GMT https://community.esri.com/t5/geoprocessing-questions/matching-regions-across-two-shapefiles/m-p/463581#M15591 TatyanaDeryugina1 2012-05-08T20:49:45Z Re: Matching regions across two shapefiles https://community.esri.com/t5/geoprocessing-questions/matching-regions-across-two-shapefiles/m-p/463582#M15592 <HTML><HEAD></HEAD><BODY><SPAN>The inconsistency in boundaries from different data sources may exist, even when the datasets are in the same coordinate system. So, instead of using the county polygons, you can try to use points that represent the polygons:</SPAN><BR /><BR /><SPAN>1. Use Feature To Point tool (Data Management toolbox - Features toolset) with the "Inside" option to get county_points from county_polygons. Each point carrries the county_polygons FID and attributes.</SPAN><BR /><SPAN>2. Use Spatial Join tool to find INTERSECT matches between county_points and the division_polygons. Now the spatialJoined_county_points have division polygon attributes.</SPAN><BR /><SPAN>3. Use Join Field to join county_polygons with the spatialJoined_county_points via the county_polygons FID to transfer the division attributes to county_polygons.</SPAN></BODY></HTML> Tue, 08 May 2012 21:16:47 GMT https://community.esri.com/t5/geoprocessing-questions/matching-regions-across-two-shapefiles/m-p/463582#M15592 DanLee 2012-05-08T21:16:47Z Re: Matching regions across two shapefiles https://community.esri.com/t5/geoprocessing-questions/matching-regions-across-two-shapefiles/m-p/463583#M15593 <HTML><HEAD></HEAD><BODY><SPAN>That works perfectly, thank you!</SPAN></BODY></HTML> Wed, 09 May 2012 13:57:47 GMT https://community.esri.com/t5/geoprocessing-questions/matching-regions-across-two-shapefiles/m-p/463583#M15593 TatyanaDeryugina1 2012-05-09T13:57:47Z Re: Matching regions across two shapefiles https://community.esri.com/t5/geoprocessing-questions/matching-regions-across-two-shapefiles/m-p/463584#M15594 <HTML><HEAD></HEAD><BODY><SPAN>You are welcome! I am glad it worked for you.</SPAN></BODY></HTML> Wed, 09 May 2012 16:03:02 GMT https://community.esri.com/t5/geoprocessing-questions/matching-regions-across-two-shapefiles/m-p/463584#M15594 DanLee 2012-05-09T16:03:02Z