Abstract

Data Storage, Analysis, Visualization with PostgreSQL, Esri, Geocortex
Track: Public Transit
Authors: Krystal Phaneuf

VTA Development Review team currently uses MS Access to enter in and store data relating to any new and/or existing projects. The project consisted of transferring the entire MS Access database into PostgreSQL, creating an ArcGIS Service to allow for connection and feature editing to the PostgreSQL database and visualizing the data in a Geocortex Web Service and creating multiple workflows to allow a more user friendly editing interface within the web browser.