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).
| Date Class | Year Range | Records | Taxa | Cumulative no. of distinct taxa |
|---|---|---|---|---|
| DC 0 | 1666-1929 | 763 | 184 | 184 |
| DC 1 | 1930-1969 | 8,266 | 1,139 | 1,172 |
| DC 2 | 1970-1986 | 14,585 | 1,472 | 1,633 |
| DC 3 | 1987-1999 | 71,403 | 1,970 | 2,197 |
| DC 4 | 2000-2009 | 150,016 | 1,984 | 2,445 |
| DC 5 | 2010-2019 | 135,795 | 1,854 | 2,654 |
| Totals | 1666-2019 | 380,828 | 2,654 | 2,654 |
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 1
| Length of OSGridRef | OSGridRef Type | Number of OSGridRefs | Percentage of Squares |
|---|---|---|---|
| 0 | Blank | 15 | 0.004 |
| 4 | Hectads - 10km Square | 2,447 | 0.643 |
| 5 | Tetrads - 2km Square | 8,330 | 2.187 |
| Subtotal | 10,792 | 2.834 | |
| 6 | Monads - 1km Square | 72,884 | 19.138 |
| 8 | 100m Square | 290,144 | 76.188 |
| 10 | 10m Square | 6,913 | 1.815 |
| 12 | 1m Square | 95 | 0.025 |
| Subtotal | 370,036 | 97.166 | |
| Totals | 380,828 | 100 |
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