Santa Clara Valley Transportation Authority (VTA) is the Congestion Management Agency and Transit Agency for Santa Clara County. Our Development Review team "reviews, analyzes, and tracks land use developments within and near Santa Clara County to improve land use/transportation coordination, promote alternative travel modes, and encourage a balanced approach to addressing congestion." This process has been in effect since the late 1990s and has not had a huge technology overhaul since then. The team currently uses MS Access to enter in and store data relating to any new and/or existing projects. The database contains over 1,500 entries dating from 1997 - 2016.
This project consisted of:
- Transferring the entire MS Access database into PostgreSQL for better storage capabilities and to reduce the incidents of data corruption.
- Creating an ArcGIS Service to allow for connection and feature editing to the PostgreSQL database.
- Visualizing the data in a Geocortex Web Service and creating multiple workflows to allow a more user friendly editing interface within the web browser.
The project was greatly received by the customer, the Development Review Team, and is currently in testing with plans for full integration with the program in April 2017.