This is an API for the Link react app. Most of the calls use SQLAlchemy models and schemas to access a Postgres DB, but the /analyze endpoint uses the LTS Connectivity tool (linked below).

It uses:

• FastAPI
• Postgres (with PostGIS and PGrouting)
• DVRPC's LTS/sidewalk connectivity tool.
• ogr2ogr

sudo apt install postgresql-15-pgrouting

which will install PostgreSQL, PostGIS, and PGrouting. If you have postgres already, you need to install the other two individually. Setup any roles you want.

You also need ogr2ogr. For Linux:

  sudo apt-get install gdal-bin

python -m venv ve

Then activate the environment.

. ve/bin/activate

pip install wheel && pip install -r requirements_base.txt

Create a .env file at the root of the project. An example is below, which contains a URI to a database.

DB_URI=postgresql://user:pw@host:port/db

You may also alter the path by including a URL_ROOT variable (that starts with a /). If not included, it will not be used.

DB_URI=postgresql://user:pw@host:port/db
URL_ROOT=/api

You'll need to add a configuration file for pg-data-etl at the root of this project. It must be named 'database_connections.cfg', and should be formatted like this:

[localhost] 
host = host
un = postgres
pw = password
port = port
db_name = db_name

Don't edit the localhost in brackets, as the script searches for it (see analyze endpoint) but change all the other variables.

If you're putting this onto a remote server, you need to pipe a copy of the database from a machine that's behind the DVRPC firewall, as all of the data import and setup scripts can only be run behind the firewall, pulling from DVRPC's GIS postgres server. The most recent backup can be found in 'G:\Shared drives\Bike LTS and Connectivity Analysis Webmap\Rethinking Connectivity\DB_Backups'.

Pipe a copy in with:

psql -U your_username -h your_host -p your_port -d target_database < backup.sql  

Start the development server with

cd app
uvicorn main:app --reload

See what API calls are supported by visiting localhost:8000/docs. (Note that if you set URL_ROOT, this would be different, e.g. a URL_ROOT of /api would result in localhost:8000/api/docs).

The project uses the GPL 3.0 license.