minus34

#!/usr/bin/env bash

cd ~/git/minus34

for d in */ ; do
  echo "################################"
  echo "# $d  #"
  echo "################################"
  cd ./$d
  git checkout master

minus34

WITH points_m AS (
  SELECT user_id,
         trip_id,
         time_utc,
         ST_MakepointM(longitude, latitude, legal_speed_difference) AS pointm_geom
  FROM raw_points
), traj AS (
  SELECT user_id,
         trip_id,
         min(time_utc) AS departure_time_utc,

minus34

WITH streets AS (
SELECT upper(street_name) as streetname, SUM(ST_Length(ST_Transform(geom, 3577)))/1000.0::integer AS lenkm
  FROM routing.streets
  WHERE array_length(string_to_array(street_name, ' '), 1) = 2
  AND upper(street_name) NOT LIKE'% HWY'
  GROUP BY street_name
), sts AS (
  SELECT (string_to_array(streetname, ' '))[1] AS streetname, SUM(lenkm) AS lenkm
  FROM streets
  GROUP BY (string_to_array(streetname, ' '))[1]