begin;

truncate sst_map;

drop index sst_map__report_time_stamp;
drop index sst_map__report_time_stamp_z;

insert into sst_map (
  station_id,
  time_stamp,
  z,
  label_z,
  temperature_celcius,
  temperature_fahrenheit,
  lon,
  lat,
  title,
  institution,
  institution_url,
  institution_dods_url,
  source,
  refs,
  contact,
  report_time_stamp,
  the_geom,
  value_temperature_celcius,
  value_temperature_fahrenheit
)
select
  station_id,
  time_stamp,
  z,
  label_z,
  temperature_celcius,
  temperature_fahrenheit,
  lon,
  lat,
  title,
  institution,
  institution_url,
  institution_dods_url,
  source,
  refs,
  contact,
  report_time_stamp,
  the_geom,
  value_temperature_celcius,
  value_temperature_fahrenheit
from sst_prod
where top_of_hour = 1;

--
-- indexes
--

create index sst_map__report_time_stamp on sst_map(report_time_stamp);
create index sst_map__report_time_stamp_z on sst_map(report_time_stamp,label_z);

end;