Generating statistics from a table in a shape file Plus comparing changes

3653
3
Jump to solution
01-19-2015 07:28 AM
KateHayward
New Contributor II

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

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
DarrenWiens2
MVP Honored Contributor

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?

View solution in original post

0 Kudos
3 Replies
DarrenWiens2
MVP Honored Contributor

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?

0 Kudos
KateHayward
New Contributor II

Many thanks Daren!

Will have a go on a mo!

Best wishes

Kate

Kate Hayward

Biological Mapping Officer (Part Time)

(Usual work days are Monday and Wednesday)

01621 862958

KateHayward
New Contributor II

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

0 Kudos