"Dublin Core:Title","Dublin Core:Creator","Dublin Core:Contributor","Dublin Core:Relation","Dublin Core:Identifier","Dublin Core:Date","Dublin Core:Source","Dublin Core:Spatial Coverage","Dublin Core:Subject","Dublin Core:Description","Dublin Core:Abstract","Dublin Core:Publisher","Dublin Core:Rights","Dublin Core:Format","Dublin Core:Language","Dublin Core:Type","Dublin Core:Coverage","Dublin Core:Alternative Title","Dublin Core:Access Rights","Dublin Core:Table Of Contents","Dublin Core:Date Available","Dublin Core:Date Created","Dublin Core:Date Accepted","Dublin Core:Date Copyrighted","Dublin Core:Date Submitted","Dublin Core:Date Issued","Dublin Core:Date Modified","Dublin Core:Date Valid","Dublin Core:License","Dublin Core:Conforms To","Dublin Core:Has Format","Dublin Core:Has Part","Dublin Core:Has Version","Dublin Core:Is Format Of","Dublin Core:Is Part Of","Dublin Core:Is Referenced By","Dublin Core:Is Replaced By","Dublin Core:Is Required By","Dublin Core:Is Version Of","Dublin Core:References","Dublin Core:Replaces","Dublin Core:Requires","Dublin Core:Extent","Dublin Core:Medium","Dublin Core:Bibliographic Citation","Dublin Core:Temporal Coverage","Dublin Core:Accrual Method","Dublin Core:Accrual Periodicity","Dublin Core:Accrual Policy","Dublin Core:Audience","Dublin Core:Audience Education Level","Dublin Core:Mediator","Dublin Core:Instructional Method","Dublin Core:Provenance","Dublin Core:Rights Holder","Item Type Metadata:Text","Item Type Metadata:Interviewer","Item Type Metadata:Location","Item Type Metadata:Local URL","Item Type Metadata:Original Format","Item Type Metadata:Physical Dimensions","Item Type Metadata:Compression","Item Type Metadata:Producer","Item Type Metadata:Director","Item Type Metadata:Number of Attachments","Item Type Metadata:Objectives","Item Type Metadata:Materials","Item Type Metadata:URL","Item Type Metadata:Participants","Item Type Metadata:Occupation","Item Type Metadata:Biographical Text","Item Type Metadata:Bibliography","Item Type Metadata:Subtitle","Item Type Metadata:Lede","Item Type Metadata:Story","Item Type Metadata:Sponsor","Item Type Metadata:Factoid","Item Type Metadata:Related Resources","Item Type Metadata:Official Website","Item Type Metadata:Street Address","Item Type Metadata:Access Information","PDF Text:Text",tags,file,itemType,collection,public,featured "GIS Database Migration and Development for the Haliburton Highlands Land Trust","Roshelle Chan","Haliburton Highlands Land Trust, Greg Wickware & Ralph Baehre","Dr. Tom Whillans, Environment and Resource Studies/Sciences",,2021,on-line,"Haliburton County","Geographic Information Systems",,"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.","Trent University",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"database migraton,GIS,Haliburton Highlands Land Trust,HHLT,PostGIS,PostgreSQL",https://database.ulinks.ca/files/original/f14828228e4010b1f2d54d9219e3ff31.pdf,,"Trent University - Community Based Research",1,1