topic Re: How can I aggregate raster data? in ArcGIS Pro Questions

How can I aggregate raster data?

QuintinChua — Fri, 10 Feb 2023 12:10:41 GMT

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.

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 ID	Cell_0	Cell_1-900	Cell_901-4000	Cell_4000-20000	Cell_20000-80000	Total
PH	312654	21564	12865	6075	354	353512

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

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

Re: How can I aggregate raster data?

AndreasHall — Fri, 10 Feb 2023 14:20:04 GMT

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

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.
I exported the resulting layer to a folder.
I used the exported raster and country polygons as input to Tabulate Area (Spatial Analyst)—ArcGIS Pro | Documentation

Result:

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

Re: How can I aggregate raster data?

QuintinChua — Sat, 11 Feb 2023 00:35:12 GMT

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