Database statements

Database statements

SELECT ID , stop_name, ST_Distance_Sphere(
        ST_GeomFromText('POINT(' || stop_lon || ' ' || stop_lat || ')'),
        ST_GeomFromtext('POINT(-93.2446454 44.9723784)')
      ), stop_lat, stop_lon
FROM STOPS
order by 3
limit 10;

insert into stops
(stop_code, stop_name, stop_desc, stop_lat, stop_lon, zone_id, stop_street, stop_city, stop_region, stop_postcode, stop_country)
SELECT
external_stop_id, external_stop_name, external_stop_desc,external_lat, external_lon, external_zone_id, 
external_stop_street, external_stop_city, external_stop_region, external_stop_postcode, external_stop_country
FROM source_stops;

update source_stops set stop_id = (SELECT ID FROM STOPS WHERE STOP_CODE = EXTERNAL_STOP_ID);