1
30
2
-
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
-
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