Select to view content in your preferred language

How can I aggregate raster data?

1500
2
Jump to solution
02-10-2023 04:10 AM
Labels (2)
QuintinChua
Emerging Contributor

Running ArcGIS pro 3.0.3 with spatial analyst enabled.

Hello! I'm currently a beginner to GIS and am trying to use it for university.

QuintinChua_1-1676030223721.png

What I'm trying to do is get a summary of cells per country in reference to density. I was hoping to try and export this data and run some analysis similar to the paper "MEASURING ECONOMIC GROWTH FROM OUTER SPACE" (Henderson, J. Vernon, Adam Storeygard and David N. Weil. 2012.)

Country IDCell_0Cell_1-900Cell_901-4000Cell_4000-20000Cell_20000-80000Total
PH31265421564128656075354353512

 

I was hoping that I could export the data into something that would look like this as so I could export It as a csv and run it using other programs.

Below is some additional data as well as the source

QuintinChua_4-1676030892179.png

 

QuintinChua_3-1676030867406.png

QuintinChua_5-1676030931439.png

 

 

 

 

https://ghsl.jrc.ec.europa.eu/download.php

 

 

 

 

 

0 Kudos
1 Solution

Accepted Solutions
AndreasHall
Esri Regular Contributor

Hi, there might be better solutions than this but this is how I did it:

  1. I used Remap raster function to recalculate the raster values. You have five classes in your example so you would recalculate to values 1-5.
  2. I exported the resulting layer to a folder.
  3. I used the exported raster and country polygons as input to Tabulate Area (Spatial Analyst)—ArcGIS Pro | Documentation

Result:

AndreasHall_0-1676038713530.png

(It is also possible to get a table with one row and one column for each raster value.)

 

View solution in original post

0 Kudos
2 Replies
AndreasHall
Esri Regular Contributor

Hi, there might be better solutions than this but this is how I did it:

  1. I used Remap raster function to recalculate the raster values. You have five classes in your example so you would recalculate to values 1-5.
  2. I exported the resulting layer to a folder.
  3. I used the exported raster and country polygons as input to Tabulate Area (Spatial Analyst)—ArcGIS Pro | Documentation

Result:

AndreasHall_0-1676038713530.png

(It is also possible to get a table with one row and one column for each raster value.)

 

0 Kudos
QuintinChua
Emerging Contributor

Thank you so much, You're a life saver!