-- Function: macnoms.inm_runup_wind(timestamp without time zone, character varying)

-- DROP FUNCTION macnoms.inm_runup_wind(timestamp without time zone, character varying);

CREATE OR REPLACE FUNCTION macnoms.inm_runup_wind(
    timestamp without time zone,
    character varying)
  RETURNS numeric AS
$BODY$select
case

when
    (($2 in ('747400') and (wind_degrees >= 270 or wind_degrees <= 45))
  or
    ($2 in ('SF340','C130','CNA208'))
  or
    (wind_mph>=9.2))
  and
    (wind_degrees not in (999))
  then
    round(wind_degrees/30.0)*30::int
  else
    300
end


/*when wind_mph>=9.2 and $2 in ('CDC10','CMD11')
  then 300
else --inm_low_wind
end */
from mspwx
where observation_time between $1-'3 days'::interval and $1+'3 days'::interval
 order by  abs(extract(epoch from $1)-extract(epoch from observation_time)) asc limit 1;$BODY$
  LANGUAGE sql VOLATILE
  COST 100;
ALTER FUNCTION macnoms.inm_runup_wind(timestamp without time zone, character varying)
  OWNER TO pgsql;
GRANT EXECUTE ON FUNCTION macnoms.inm_runup_wind(timestamp without time zone, character varying) TO pgsql;
GRANT EXECUTE ON FUNCTION macnoms.inm_runup_wind(timestamp without time zone, character varying) TO macnoms;
GRANT EXECUTE ON FUNCTION macnoms.inm_runup_wind(timestamp without time zone, character varying) TO gis;
GRANT EXECUTE ON FUNCTION macnoms.inm_runup_wind(timestamp without time zone, character varying) TO ro_user;
GRANT EXECUTE ON FUNCTION macnoms.inm_runup_wind(timestamp without time zone, character varying) TO public;
GRANT EXECUTE ON FUNCTION macnoms.inm_runup_wind(timestamp without time zone, character varying) TO service_nextgen;
GRANT EXECUTE ON FUNCTION macnoms.inm_runup_wind(timestamp without time zone, character varying) TO service_macnoms_reports;
GRANT EXECUTE ON FUNCTION macnoms.inm_runup_wind(timestamp without time zone, character varying) TO service_track_management;