topic Re: extract data from multiple datasets in Data Management Questions

extract data from multiple datasets

Maria_RetchiePagliawan — Mon, 18 Mar 2013 12:05:22 GMT

Hi everyone!
I am a student and currently doing my thesis. I took an introduction course on ArcGIS (hence, I am just a newbie in the using the software). I need to extract sea surface temperature data for a specific area (Sulu Sea). The data I'm using were downloaded from NOAA, and are in .nc files. These data are on a daily basis. So, I practically have to extract data for this area, from a global dataset for 365 * 10 years, which is a very large dataset. I did one extraction using the 'zonal statistics as a table'. What the table provides are the data I actually needed. However, I need to do this for 10 years (dataset on a daily basis), which is a lot of work. My question is, if there is an easier way to extract these data without actually having to do it for every daily dataset? Thanks in advance for your help.

Regards,

Retchie

Re: extract data from multiple datasets

D__SamuelRajasekhar — Thu, 21 Mar 2013 14:57:56 GMT

You can use a model and batch process the data sets in one go.

Re: extract data from multiple datasets

StavrosC — Thu, 21 Mar 2013 19:12:17 GMT

For this type of stuff, I like to automate with a Python Script like the one here. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//009z000000w8000000.htm

If you put all rasters in a single folder, you can use Python to make a list of all the raster names in your folder and automate running zonal statistics on each file.

glob.glob("/home/username/www/*")
(for example) will list all files in the www directory.

Re: extract data from multiple datasets

Maria_RetchiePagliawan — Mon, 25 Mar 2013 13:47:34 GMT

For this type of stuff, I like to automate with a Python Script like the one here. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//009z000000w8000000.htm

If you put all rasters in a single folder, you can use Python to make a list of all the raster names in your folder and automate running zonal statistics on each file.

glob.glob("/home/username/www/*")
(for example) will list all files in the www directory.

Thanks for this. I will try it. I'm actually just starting to explore python. Thanks for the help!! 🙂 -retchie

Re: extract data from multiple datasets

Maria_RetchiePagliawan — Wed, 27 Mar 2013 08:13:13 GMT

Hi everyone,

I have tried to learn scripting, but I can only do the simple ones. However, what I need are more complex ones (atleast compared to what I did). That is why I am asking for assistance now, if anyone has worked with the same data or same process that I need to do, maybe you could give my the script that I coud use.

Here's what I need to do: Obtain a zonal statistics table (all the statistics provided in the table) of sea surface temperature (which are .nc files obtained from NOAA) of Sulu Sea in the Philippines on a daily basis from 1998 to present.

Thanks in advance for the help!! 🙂

Regards,
Retchie