Marlborough District Council SNA System
Marlborough District Council's (MDC) SNA Database was developed in Access by Peter Hamill. It has been designed to integrate with the wider MDC Property Database, but this link has not yet been activated.
The system distinguishes between properties (land parcels) and ecologically significant sites. If an ecological site straddles two or more properties, the site is divided along the property boundaries. This allows the Council to keep site reports specific to only one property and owner, and therefore maintain confidentiality.
The database contains two main tables: one to hold data about properties, and one to hold data about sites. The property table enables the system to be linked to the wider Council system. This table also holds data, such as ownership details, and a link to an electronic version of the original ecological site survey.
The site table holds the data detailed in the site attributes list. The attributes are also visible as fields in the main window screen below.
Lists of species at the site are not recorded in the ecologists's report and therefore not in this system. Eco Type, Site Type and other drop-down lists are set in a glossary table. This means that another user could easily modify the menus to fit their own requirements.
Ranking of the site against SNA criteria is recorded as low, low-medium, medium, medium-high, and high by the ecologists. These rankings are then converted into a numerical value of 1-5. The National Priorities Rankings are recorded as a value of 1-5 also. Management Feasibility is given a value of 1-3. The total values for each of these three areas are then concatenated into an overall ranking.
MDC have made this database available to other councils as a free download (604kb).
- Main Window
- Selecting a Site Type
- Selecting an Eco Type
- Ranking Drop Down List
- Ranking Concatenation
- List of Attributes
- Site # (Number)
- Property (Number)
- Site Name (Text)
- Easting (Number)
- Northing (Number)
- Site Type (1 of 6 categories)
- Eco Type (1 of 40+ categories)
- District (Text)
- Area (ha.) (Number)
- Date of Survey (dd/mm/yyyy)
- Landform (Text)
- Vegetation (Text)
- Flora (Text)
- Other (Text)
- Future Management (Text)
- Overall Significance (L/L-M/M/M-H/H)
- Representativeness - Rank (L/L-M/M/M-H/H)
- Representativeness - Comment (Text)
- Rarity - Rank (L/L-M/M/M-H/H)
- Rarity - Comment (Text)
- Diversity & Pattern - Rank (L/L-M/M/M-H/H)
- Diversity & Pattern - Comment (Text)
- Distinctiveness - Rank (L/L-M/M/M-H/H)
- Distinctiveness - Comment (Text)
- Size & Shape - Rank (L/L-M/M/M-H/H)
- Size & Shape - Comment (Text)
- Connectivity - Rank (L/L-M/M/M-H/H)
- Connectivity - Comment (Text)
- Sustainability - Rank (L/L-M/M/M-H/H)
- Sustainability - Comment (Text)
- SNA Ranking - Representativeness (0-5)
- SNA Ranking - Rarity (0-5)
- SNA Ranking - Diversity/Pattern (0-5)
- SNA Ranking - Distinctiveness (0-5)
- SNA Ranking - Size/Shape (0-5)
- SNA Ranking - Connectivity (0-5)
- Total SNA Rank (0-30)
- National Prioriities Ranking - Threatened Land Environment (0-5)
- National Prioriities Ranking - Wetland/Dune (0-5)
- National Prioriities Ranking - Originally rare (0-5)
- National Prioriities Ranking - Habitat for threatened spp (0-5)
- Total National Priorities Rank (0-20)
- Management Feasability (1-3)
- Overall Ranking (Concatenation of Total SNA Rank, Total National Priorities Rank & Management Feasibility)
- Justification (Memo)
Log in and Edit this Page. You can view the edit history without logging in.
This site is provided by OnlineGroups.Net, where you can start your own free groups site, and powered by GroupServer, the open source web-based mailing list manager.