Cutting a grid into a smaller grid and retaining values

2620
2
Jump to solution
06-22-2012 12:46 PM
KevinOConnell1
New Contributor
I currently have a vector shapefile of Vulcan CO2 emission data that is comprised of many 10km by 10km squares each with a value for emissions for that area.  I would like to split each of the 10km by 10km squares into smaller 2.5km by 2.5km squares, but have each square retain the value of the larger square that it was associated with.  What would be the best way to do this?  Thanks in advance.  Kevin.
0 Kudos
1 Solution

Accepted Solutions
NobbirAhmed
Esri Regular Contributor
If your boundary lines are horizontal and vertical then it is relatively easy.

Step 1:
use Create Fishnet tool (Data Management > Feature Class) with parameter values as:

Output feature class: full path (with name) for the new feature class, say the name be poly2andhalf
Template extent (this is important): Select the 'Same as layer poly10by10 (the 10m by 10m polygons) by clicking on the drop-down arrow. [You must be in ArcMap]
Cell Size Width: 2.5
Cell Size Height: 2.5
Number of Rows: 0  (0 means the tool will calculate the value)
Number of Rows: 0
Opposite corner: automatically fills in if you select a template.
Check off Create Label Points
Geometry type: POLYGON

Origin is the lower-left corner. Must be same for both (poly10by10 and poly2andhalf) polygon feature classes.

Step 2:
run Feature To Point (Data Management > Features) with poly2andhalf as input - say its output is ply2andhalf_ftp

Step 3:
transfer the attribute of poly10by10 to poly2andhalf_ftp using the Spatial Join tool (Analysis tools > Overlay). Use parameter values as:

Target Features: poly2andhalf_ftp
Join Features: poly10by10
Output: poly2andhalf_ftp_spj
Join Operation: JOIN_ONE_TO_ONE
Field Map: Do not change.
Match Option: WITHIN

After running the Spatial Join, you'll see that the attributes of 10by10 polys are transferred to poly2andhalf_ftp_spj.

Step 4:
use Join Field (Data Management > Joins) tool as follows:
Input Table: poly2andhalf
Input Join Field: OID
Join Table: poly2andhalf_ftp_spj
Output Join Field: ORIG_FID
Join Fields: select the fields of the larger grids you want to join to the smaller grids.

Let me know how it goes.

View solution in original post

0 Kudos
2 Replies
NobbirAhmed
Esri Regular Contributor
If your boundary lines are horizontal and vertical then it is relatively easy.

Step 1:
use Create Fishnet tool (Data Management > Feature Class) with parameter values as:

Output feature class: full path (with name) for the new feature class, say the name be poly2andhalf
Template extent (this is important): Select the 'Same as layer poly10by10 (the 10m by 10m polygons) by clicking on the drop-down arrow. [You must be in ArcMap]
Cell Size Width: 2.5
Cell Size Height: 2.5
Number of Rows: 0  (0 means the tool will calculate the value)
Number of Rows: 0
Opposite corner: automatically fills in if you select a template.
Check off Create Label Points
Geometry type: POLYGON

Origin is the lower-left corner. Must be same for both (poly10by10 and poly2andhalf) polygon feature classes.

Step 2:
run Feature To Point (Data Management > Features) with poly2andhalf as input - say its output is ply2andhalf_ftp

Step 3:
transfer the attribute of poly10by10 to poly2andhalf_ftp using the Spatial Join tool (Analysis tools > Overlay). Use parameter values as:

Target Features: poly2andhalf_ftp
Join Features: poly10by10
Output: poly2andhalf_ftp_spj
Join Operation: JOIN_ONE_TO_ONE
Field Map: Do not change.
Match Option: WITHIN

After running the Spatial Join, you'll see that the attributes of 10by10 polys are transferred to poly2andhalf_ftp_spj.

Step 4:
use Join Field (Data Management > Joins) tool as follows:
Input Table: poly2andhalf
Input Join Field: OID
Join Table: poly2andhalf_ftp_spj
Output Join Field: ORIG_FID
Join Fields: select the fields of the larger grids you want to join to the smaller grids.

Let me know how it goes.
0 Kudos
KevinOConnell1
New Contributor
Hey thanks for the response.  That process works well thanks a lot!
0 Kudos