Natalie

#505 WYS null fixes

2

## What this pull request accomplishes: - fix null values issues ## Issue(s) this solves: - #505 ## What, in particular, needs to reviewed: - New sql - Some changes...

Get rid of _value_ attribute for outcome_arr and routepoint_arr

1

## What this pull request accomplishes: - Got rid of _value_ attribute in json for outcome and routepoint column in `bluetooth.all_analyses` - e.g. ``` SELECT all_analyses.analysis_id, (all_analyses.route_points -> 0) ->>...

Bluetooth: Routes that never had data in bluetooth.aggr_5mins

1

In bluetooth.routes_temp, there are 61 routes out of 402 with no data in `bluetooth.aggr_5min` and `bluetooth.observations`.  But it does seems like some routes with data do have coverage on...

Add log cleanup dag

1

## What this pull request accomplishes: - add log cleanup dag to master ## Issue(s) this solves: - There was no issue ## What, in particular, needs to reviewed: -...

Draw routes for newly installed bluetooth detectors

19

Create routes for the following analysis_id ``` select * from bluetooth.all_analyses where route_name like '%DT2%' ``` Steps: - get start and end geom for each analysis_id - create table with...

create centreline table for routing and a function to get centreline between two intersections (that always uses the latest version of centreline in gis_core)

Centreline mat invest

1

## What this pull request accomplishes: - Creates centreline_latest as a mat view and a trigger function that looks at gis_core.centreline updates - Create routing table and function for directional...

GCC Puller: Create primary key only if not exist

1

Ran into an error `ERROR: multiple primary keys for table "loop_detector" are not allowed` Not exactly sure why this wasn't an issue before.... And because there is no `add constraint...

HERE new data pulling plan

3

We are gonna get some new columns from here, set up a plan on how to implement pulling new columns. New Columns: - `harmonic_mean`: Harmonic Means - `vdt` : Vehicle...

812 eoy table

3

## What this pull request accomplishes: - taskflowify-ish the dag (definitely more things can be done on the bluetooth side, but can wait after declarative partitioning switch) - update path...