A script/query adding vehicle_location_point to siri_arrivals about open-bus HOT 5 CLOSED

Create column:
SELECT AddGeometryColumn ('siri_arrivals_filtered','vehicle_location_point',4326,'POINT',2);
Populate data:
update siri_arrivals_filtered set vehicle_location_point = ST_SetSRID(ST_MakePoint(cast(vehicle_location_lon as double precision), cast(vehicle_location_lat as double precision)),4326);

from open-bus.

The populate data query should also have the line:
where vehicle_location_lon !=''
(Otherwise the cast caused it to fail).
Only thing left to do is to add these queries to the loading scripts.

from open-bus.

@daphshez can we close?

from open-bus.

Yes, I'm done with it =) @daphshez

from open-bus.

Note that has been changed so that there is no need to actually hold siri_arrivals_filtered column, we added it to the query that populates the data in Add route offset to siri_arrivals

from open-bus.