2

I have a featureclass that is a grid of the countries of the world (88,110 squares).
enter image description here

I am trying to assign all the grid cells to the country that each cell MOST contains (from a shapefile of country polygons).

The example cell shown below is on the border of Mexico and the United States. It mostly contains Mexico and I would like the corresponding "COUNTRY" field to only assign/populate with "Mexico".enter image description here

I've performed a union of mygrid2 to a shapefile (world_countries_generalized). A bit confused on the proper inputs on summarize within and creating a query layer. enter image description here

3

1 Answer 1

2

I would try the following workflow:

  1. Union your grid with your country boundaries
  2. Summarize your data, grouping by cell ID and county name and computing max area
  3. Create a query layer joining on cell ID and max area and pass over county name

This approach requires all datasets to be in the same file geodatabase.

2
  • I've performed the union but am a bit confused on the proper inputs for the summarize within step (what input for each blank) and your suggestion of the query layer step. I've included an updated screenshot above.
    – emwtg2
    Feb 19, 2023 at 17:46
  • @emwtg2, I have added links in my answer to the appropriate tools.
    – Hornbydd
    Feb 20, 2023 at 10:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.