Asbuilt_Trax

A simplified prototype for an as-built tracking database with API

The purpose of this project is to:

1. Model a database that tracks construction as-builts, GIS contributers, GIS data, and construction crew leaders all in one place
2. Publish an API that provides access to that data
3. Use Jupyter Notebook to analyze and visualize the data

API Reference:

Project evolution

Asbuilt_Trax began as a way to practice PostgreSQL database design, construction, and maintenance by implementing a simplified records management database based on a utilities mapping workflow. What it provides is a solution to the problem of being able to lookup and manage records in an efficient way, leveraging the power of a database to serve the data up via API, and visualize the data in using Jupyter Notebook.

ORM

With a reasonable footing in SQL, I chose to build the API with Flask-SQLAlchemy in order to practice using the ORM and the framework it provides.

Future devlopments

Currently the API only provides for basic query and post/ delete operations. So I am looking forward to expanding those capabilities to return more comprehensive data from the database, including GIS records, creating and updating user tables, and SQL triggers to automate data management. I'd also like to implement more data visualization tools in the associated Jupyter Notebook.