Islam Taha

## What this pull request accomplishes: - It handles the exception `json.decoder.JSONDecodeError` in `wys_api.py` by logging the returned error message and passing the exception back to the calling function in...

The DAG run of Aug 22, 2022 stopped due to an unhandled exception: `json.decoder.JSONDecodeError`. Here is the full stack: ``` [2022-08-25 12:12:05,095] {taskinstance.py:1150} ERROR - Expecting value: line 1 column...

Update the collisions Readme with the new replicator details

3

## What this pull request accomplishes: - Updates the collisions README to match the new replicator DAG that copies collisions tables from `move_staging` to `collisions` Closes issue #933

Need to add a certificate (on VFH servers) to our requests that pulls the GIS layers to resolve the below warning ``` [2023-12-22, 11:54:00 EST] {logging_mixin.py:154} WARNING - /home/airflow/airflow_venv/lib64/python3.9/site-packages/urllib3/connectionpool.py:1061 InsecureRequestWarning:...

Add GitHub action to check for DAG import errors

2

## What this pull request accomplishes: Add GitHub action to check for: - DAG import errors - empty DAGs ## Issue(s) this solves: - Closes #796 ## What, in particular,...

Add GitHub action to check for DAG import errors

One of the records in `gis.traffic_signal`, which is being updated daily by the DAG `traffic_signals_dag`, has invalid geometry (latitude) as shown below. We need to check each record's coordinates before...

Organize the daily WYS DAG

1

The current structure of `pull_wys` DAG has too many tasks done within `pull_wys` task which is implemented in `wys_api.py` which contains many long sql queries. It could be better to...