The Annapolis Valley Trails Coalition require a multiuser geographic information system to be implemented, merging disparate data sources pertaining to all aspects of their operation. Using this solution, stakeholders will be given the ability to effectively store, view, query, and manipulate spatial and tabular data in an enterprise environment. This will ultimately result in the provision of a flexible, scalable framework able to accommodate future developments. Furthermore, the efficiency of the AVTC's day-to-day operations will be increased, and the ability to share data will be simplified.
As our major term project for the GIS concentration's fall semester, a classmate and I developed a prototype GIS designed to best suit the AVTC's needs. This portfolio piece comprises all major deliverables and supporting documents I created while working on the project.
Project Report & Documentation
Download full size (8.5 x 11" (24 pages), 4.2 MB, PDF)
This document outlines the entire process of designing and implementing the GIS:
• Brainstorming, performing industry research, participating in regular client and team meetings.
• Designing a PostgreSQL relational database and connecting it to a desktop GIS client.
• Researching, developing, and documenting workflows for field collection using Collector for ArcGIS and QField.
• Creating static print maps/infographics for visualization of trail use statistics and ownership information.
• Developing dynamic web mapping applications using GeoServer and Leaflet.
Also included is metadata for the database we designed, step-by-step procedures for field collection, and links to relevant resources. This report was created using Adobe InDesign CC.
HMT Trail Segments Map
Download full size (23.5 x 16.5", 15.52 MB, PDF)
Using information from our newly-created GIS database tables, I created this map displaying ownership information for the various segments comprising the Harvest Moon Trail.
This is a static map designed for print, useful for being shown at Trails Coalition meetings to help inform group decision-making.
ArcGIS for Desktop 10.6 was used to compile the map data, merging and layering vector and raster datasets from the Nova Scotia Topographic Database, Natural Resources Canada, and Esri.
Adobe Illustrator was used to create a modern and visually-appealing final design.
Database Entity Relationship Diagram
Download full size (A1 (23.4 x 33.1"), 509 KB, PDF)
A design for a relational spatial database model, containing information related to the AVTC's assets and other trail features, was developed by creating an entity relationship diagram. This ERD shows all schemas, tables, attributes, and relationships of varying cardinalities, allowing for easy visualization of the information product. The design underwent several iterations of normalization and refinement, using feedback from the client and the results of our own testing to create an efficient and logically-structured model.
Once the design was complete, a functioning database was then constructed using:
• PostgreSQL 10
• pgAdmin 4 v3.0
• The PostGIS extension for PostgreSQL
• Python 3 with the geopandas module to turn the client’s Excel forms into usable data tables.
Sample queries provided by the client were then able to be performed, allowing for information that was previously accessible only via hard copy records to be retrieved less than one second. Examples of these queries and their SQL execution can be found in the project documentation.
Web Map: Harvest Moon Trail Users
Launch: Web Map: Harvest Moon Trail Users
A web-based component is needed for the Annapolis Valley Trails Coalition’s stakeholders to view the locations of trail assets and their attributes. In addition to this, a public-facing web map would be desirable for attracting the interest of tourists planning a day trip to the area.