Hello!
I have looked at the tool box etc and not found what I am looking for.
Can someone point me in the right direction to do the following please?
1 - I have Phase 1 habitat data mapped for areas in Essex, England. (1980 data and 2014 data)
This is to look at habitat change over 30 years or so
The data in the attribute table is in the following...
Text for the habitat codes eg A1.1.1 , B2.1 etc and then for each code there is an area in hectares.
I would like to calculate the totals in areas for each habitat code using the two columns....
How do I do this please without whipping the data out into Excel?
2 - I would like to compare the changes in habitats between the 1980 data and 2014 data.
The 2014 data was mapped using a copy of the 1980 data with shapes amended and attributes amended where needed. Therefore retaining in one column where possible the original habitat data and the new habitat data in new columns.
Therefore we can either do this using the 2014 data or for better accuracy as with merging shapes that shape takes on the attributes of one or the other, using both the 2014 shape and the 1980 shape files.....
Any clues, ideas will be gratefully appreciated... I can then build a model to run if possible!
Thank you
Kate, Biological Mapping Officer, Essex Wildlife Trust , UK
Solved! Go to Solution.
1 - Summary Statistics tool. Statistics field = area, stat type = sum, case field = habitat code.
2 - Need more information. Suppose in 1980 there was a forest in one polygon, then logged and now agriculture in 2014. Do you want a field that says "1980: Forest, 2014: Agriculture", or something else entirely?
1 - Summary Statistics tool. Statistics field = area, stat type = sum, case field = habitat code.
2 - Need more information. Suppose in 1980 there was a forest in one polygon, then logged and now agriculture in 2014. Do you want a field that says "1980: Forest, 2014: Agriculture", or something else entirely?
Many thanks, it has worked a treat!
I had tried that tool but missed putting something in the Case field.
I used Union to generate a column where changes had occurred ( advised on another forum) so I now have a nice report of what has changed.
Popped into Excel to generate percentages..
Thanks
Kate