1 30 2 https://database.ulinks.ca/files/original/f14828228e4010b1f2d54d9219e3ff31.pdf e6da51b0c53f83d8d547d7cca0baefb4 Dublin Core The Dublin Core metadata element set is common to all Omeka records, including items, files, and collections. For more information see, http://dublincore.org/documents/dces/. Title A name given to the resource Trent University - Community Based Research Dublin Core The Dublin Core metadata element set is common to all Omeka records, including items, files, and collections. For more information see, http://dublincore.org/documents/dces/. Title A name given to the resource GIS Database Migration and Development for the Haliburton Highlands Land Trust Creator An entity primarily responsible for making the resource Roshelle Chan Contributor An entity responsible for making contributions to the resource Haliburton Highlands Land Trust, Greg Wickware & Ralph Baehre Relation A related resource Dr. Tom Whillans, Environment and Resource Studies/Sciences Date A point or period of time associated with an event in the lifecycle of the resource 2021 Source A related resource from which the described resource is derived on-line Spatial Coverage Spatial characteristics of the resource. Haliburton County Subject The topic of the resource Geographic Information Systems Abstract A summary of the resource. The Haliburton Highlands Land Trust (HHLT) is a non-profit organization that aims to protect the natural landscape and cultural heritage of the Haliburton Highlands through acquiring and conserving lands of ecological significance. After reviewing their current database, the land trust has expressed their desire to further develop their spatial data management system to more effectively integrate knowledge of their properties into their stewardship, management, and land acquisition decisions. Open source GIS database software, specifically PostgreSQL with the PostGIS extension, can improve the HHLT’s access to, and use of, existing research and management data. The objective of this project was to migrate the HHLT’s database in Microsoft Access to PostgreSQL, an open source database management system that can help the HHLT eliminate the annual cost of an Access subscription while providing greater flexibility for spatial applications in the future. A requirements analysis was first conducted through stakeholder meetings, discussions with the HHLT, and a comprehensive review of existing documents. After acquiring a copy of the current database and other relevant files, a conceptual database design was produced to provide a description of the database and identify the main database entities along with their relationships. The next step was the translation of the conceptual database design into a logical and physical database design, which contained more detailed information of database elements (e.g., cardinality, data types, constraints). After the final database design was approved by the HHLT, the database was constructed then tested in PostgreSQL and is now ready for deployment. The final database has 24 tables storing a range of data from property details, bird surveys, member contact information, reports, permanent sample plot surveys to species. Relationships between tables were defined and previous survey data were used to populate the database. For rapid access to summary information, queries were created and stored as database views. Three main recommendations for continuing this project in the future include: (a) further refining database tables and definitions with the input of more data collected from the field; (b) developing open source web applications to synchronize data collection with the database; and (c) exploring remote sensing and image analysis for monitoring biophysical and temporal changes in the region. Publisher An entity responsible for making the resource available Trent University database migraton GIS Haliburton Highlands Land Trust HHLT PostGIS PostgreSQL Dublin Core The Dublin Core metadata element set is common to all Omeka records, including items, files, and collections. For more information see, http://dublincore.org/documents/dces/. Title A name given to the resource Haliburton County - Grey Literature Dublin Core The Dublin Core metadata element set is common to all Omeka records, including items, files, and collections. For more information see, http://dublincore.org/documents/dces/. Date A point or period of time associated with an event in the lifecycle of the resource 1999 Title A name given to the resource Integrated Database Committee Subject The topic of the resource Correspondence regarding Geographic Information Systems. Creator An entity primarily responsible for making the resource Integrated Database Committee Source A related resource from which the described resource is derived CC-068 Publisher An entity responsible for making the resource available Martin, Fay geographic information systems GIS health social services