1

I am absolutely new to GIS.

I have imported a map with information in the counties of Germany. Additionally I have added a layer with information on SO2 concentration at various measuring stations in Germany:

enter image description here

Additionally, I have already interpolated the SO2 data using IDW (based on the suggestions from the Federal Environmental Agency, who distributed the data):

enter image description here

I am now struggeling with calculating area means. That is, for my analysis I need one value of SO2 concentration for each county in Germany, which I can export to R.

Improve this question

2 Answers 2

Reset to default
2

I would recommend using Zonal Statistics as Table rather than just Zonal Statistics -- since your end goal is a table (in Excel), it is a more direct workflow. The statistics are the same, but the output is a table.

I am not entirely sure whether Excel is able to open .dbf files (one of the available table formats) directly; if not, you can open it within ArcMap and export the table to a .txt file (comma-separated).

Improve this answer
0
1

What you are looking for is called Zonal statistics. Make sure to specify a field with unique values in your polygon file with counties.

I would probably also exclude any county that hasn't got any points in them at all, since the interpolation there will be very uncertain (or counties with no station within a certain distance).

NB: the suggested tool requires Spatial analyst extension.

Improve this answer
4
  • Thanks @Martin. I think that work. However, do you know how I can export it into a txt file or table?
    – coolcats
    Commented Apr 17, 2014 at 11:54
  • In ArcGIS 10.2 you can use Table to excel.
    – Martin
    Commented Apr 17, 2014 at 11:59
  • I tried that. However, I can only convert the the tables I have imported into ArcGIS from shape files. Do I have to do anything with my interpolated data before I can export it?
    – coolcats
    Commented Apr 17, 2014 at 12:08
  • Since that is a new problem and not directly related to this question, I think you should post that as a separate question where you can outline all details, like what you have tried and what happens when you do. I'll be happy to try and help in that new question instead.
    – Martin
    Commented Apr 17, 2014 at 12:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.