Active-Travel-Academy / ata-traffic-recorder

MIT License
3 stars 0 forks source link

Tomtom #3

Closed nikolai-b closed 3 years ago

nikolai-b commented 3 years ago

Adds TomTom data:

ltns=> \d tomtom_journey_runs
                                                        Table "public.tomtom_journey_runs"
                    Column                     |           Type           | Collation | Nullable |                     Default                     
-----------------------------------------------+--------------------------+-----------+----------+-------------------------------------------------
 id                                            | bigint                   |           | not null | nextval('tomtom_journey_runs_id_seq'::regclass)
 journey_id                                    | bigint                   |           | not null | 
 run_id                                        | bigint                   |           | not null | 
 traffic_delay_in_seconds                      | integer                  |           | not null | 
 travel_time_in_seconds                        | integer                  |           | not null | 
 live_traffic_incidents_travel_time_in_seconds | integer                  |           | not null | 
 historic_traffic_travel_time_in_seconds       | integer                  |           | not null | 
 length_in_meters                              | integer                  |           | not null | 
 created_at                                    | timestamp with time zone |           | not null | now()
 overview_polyline                             | jsonb                    |           | not null | 

Also adds created_at to journey_runs and finished_at to runs