AN ADVANCED INFORMATION MANAGEMENT SYSTEM FOR LAND TRUSTS
Conservation Connections™ is an integrated relational database application that allows a layperson to access and retrieve information on protected properties for an organization in an easy and rapid manner. It is customized software originally designed by collaboration between the Society for the Protection of New Hampshire Forests and Ewarenow.com, LLC. The application is a complete package that runs on Microsoft Access and does not require any specialized computer or software.
PURPOSES
To facilitate the storage and retrieval of large amounts of data on multiple properties and people in an easy and efficient manner.
To save time and money in managing an easement stewardship or other land related program.
To allow multiple users to access and update common data.
To ease the transition between departing and arriving staff for land trusts by allowing departing staff to store relevant information and by facilitating the learning process for new staff.
To allow land trusts to grow from small to medium to large easily and seamlessly.
DATABASE DESIIGN AND STRUCTURE
The database is designed to provide search capability by any of several criteria to locate a particular property or person. Specific data can then be easily entered to update records and document stewardship activities. The structure consists of linked tables of data organized into Parcels and Contacts. The database is designed to accommodate parcels with multiple contacts and contacts associated with multiple parcels. A consolidated list of specific data is shown below:
Parcels
Parcels refer to all properties.
Data fields include:
Contacts
Contacts refer to people and organizations.
Data fields include: