This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--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 |