Select to view content in your preferred language

export raster in model builder not exporting full attribute table

944
3
Jump to solution
03-07-2023 06:21 PM
QuintinChua
Emerging Contributor

Running ArcGIS 3.03

Hello! I'm new to GIS as a whole and I am trying to use it for some applications in my studies at university. Specifically I want to track the density of people and built infrastructure within countries over time.    

 

I've built a model where I clip the global raster by individual countries and then export the attribute table. The clipping part of the function works fine, but the issue I am having is that the exported raster table is missing data.

- Input polygons

QuintinChua_0-1678241644133.png

 

- Raster sample

QuintinChua_1-1678241708895.png

- Model

QuintinChua_2-1678241736942.png

 

- Iterate feature

QuintinChua_3-1678241753801.png

- Clip Polygons (Raster Statistics are turned on)

QuintinChua_4-1678241779017.png

- Export Table

QuintinChua_5-1678241822603.png

- Attribute table of iterated raster

QuintinChua_6-1678241853980.png

- Resulting CSV

QuintinChua_7-1678241867466.png

As shown above the resulting CSV is missing the 2nd and 3rd column of data. Is there something that I am doing wrong that is causing this issue? or is there perhaps a workaround for me to extract the data. Any help and advice would be greatly appreciated.

 

Additional info:

The data I'm using for the polygons comes from here: https://hub.arcgis.com/datasets/WorldPop::national-boundaries-1km/about

and the population and build density data originates from: https://ghsl.jrc.ec.europa.eu/download.php

I've also tried using the build raster attribute function

QuintinChua_8-1678242035666.png

But the resulting CSV is exactly the same, suggesting that its an issue with exporting and not the raster tables themselves.

 

 

 

 

0 Kudos
1 Solution

Accepted Solutions
DanPatterson
MVP Esteemed Contributor

try Table To Table (Conversion)—ArcGIS Pro | Documentation

since all fields are exported

in Export Table (Conversion)—ArcGIS Pro | Documentation

it states

If the output is not in a geodatabase, BLOB or raster fields will not be included. GlobalID fields will be converted to text fields.


... sort of retired...

View solution in original post

3 Replies
DanPatterson
MVP Esteemed Contributor

try Table To Table (Conversion)—ArcGIS Pro | Documentation

since all fields are exported

in Export Table (Conversion)—ArcGIS Pro | Documentation

it states

If the output is not in a geodatabase, BLOB or raster fields will not be included. GlobalID fields will be converted to text fields.


... sort of retired...
QuintinChua
Emerging Contributor

Worked like a charm! Thank you so much. 

0 Kudos
KaustuvNeupane
New Contributor

Do you an image of model builder, which worked for you?

0 Kudos