kphaneuf

--create geometry columns
ALTER TABLE vta_wkday_od_database ADD COLUMN origin_geom geometry(Point, 4326);
ALTER TABLE vta_wkday_od_database ADD COLUMN first_board_geom geometry(Point, 4326);

--create geometry from latitude and longitude columns
UPDATE vta_wkday_od_database SET first_board_geom = ST_SetSRID(ST_MakePoint(first_board_lon::double precision, first_board_lat::double precision), 4326);
UPDATE vta_wkday_od_database SET origin_geom = ST_SetSRID(ST_MakePoint(origin_lon::double precision, origin_lat::double precision), 4326);

--change to 2227 so that calculations are in feet not meters.
ALTER TABLE vta_wkday_od_database