+ Reply to Thread
Results 1 to 6 of 6

Thread: Matching regions across two shapefiles

  1. #1
    Tatyana Deryugina
    Join Date
    May 2012
    Posts
    14
    Points
    0
    Answers Provided
    0


    0

    Default Matching regions across two shapefiles

    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".

    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!

  2. #2
    Dan Lee

    Join Date
    Oct 2009
    Posts
    582
    Points
    143
    Answers Provided
    27


    0

    Default Re: Matching regions across two shapefiles

    You can try Spatial Join tool (Analysis toolbox - Overlay toolset) with the INTERSECT match option.
    Dan (Geoprocessing)

  3. #3
    Tatyana Deryugina
    Join Date
    May 2012
    Posts
    14
    Points
    0
    Answers Provided
    0


    0

    Default Re: Matching regions across two shapefiles

    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)?

  4. #4
    Dan Lee

    Join Date
    Oct 2009
    Posts
    582
    Points
    143
    Answers Provided
    27


    0
    This post is marked as the answer

    Default Re: Matching regions across two shapefiles

    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:

    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.
    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.
    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.
    Dan (Geoprocessing)

  5. #5
    Tatyana Deryugina
    Join Date
    May 2012
    Posts
    14
    Points
    0
    Answers Provided
    0


    0

    Default Re: Matching regions across two shapefiles

    That works perfectly, thank you!

  6. #6
    Dan Lee

    Join Date
    Oct 2009
    Posts
    582
    Points
    143
    Answers Provided
    27


    0

    Default Re: Matching regions across two shapefiles

    You are welcome! I am glad it worked for you.
    Dan (Geoprocessing)

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts