Surrey's Vascular Plants and Charophytes: Analysis of the Number of Records and Taxa per 1km Square (monad) by Date Class (Year range)

Surrey covers 2,104 monads, including 1,822 complete monads, 145 with 50% to 99.9% coverage and 137 with 0.1% to 49.9% coverage.

The number of records and taxa of Vascular Plants and Charophytes accumulated by the Surrey Botanical Society and stored in MapMate as at 13th February, 2013 stood at 380,828

An analysis of all these records revealed Surrey monads without records. A list of monads and the percentage of each 1km square in Surrey was copied from the Biological Records Centre and pasted into a MS Access table. This table was then merged with the list of Surrey 1km Squares from MapMate.

The 1km Squares straddling the VC Boundary were checked against an OS Map with a UK OS grid and a Surrey VC boundary overlay developed by Robin Day from code originally provided by Bill Chadwick, to produce a 'map'.

The majority of records (c.96%) are at a sufficient precision to enable analysis at the monad (1km Square) level (see Appendix 1)

The analyses for each Date Class and all years were carried out in MS Access using queries developed for the purpose (see Appendix 2 for records & Appendix 3 for taxa).

The resulting Crosstab tables were first sorted in descending order and then copied and pasted into an Excel spread sheet prior to reformatting the data to produce a 'map' for each Date Class, for all records click HERE and taxa click HERE.

Acknowledgements
I am extremely grateful to David Williams, Robin Day and Peter Wakeham for invaluable assistance and Bill Chadwick who provided the code for SBS use which Robin adapted.
Brian Pitkin, 21 September 2011

Download Records Analysis Spread Sheet : Download Taxa Analysis Spread Sheet

Appendix 2 - Queries to generate a table of the number of records per 1km Square. View

Appendix 3 - Queries to generate a table of the number of taxa per 1km Square. View