def observation_update2(site_key): site = Site.get_by_key_name(site_key) if site is None: return Response(status=404) url = "http://www.metoffice.gov.uk/public/data/PWSCache/BestForecast/Observation/%s?format=application/json" % site_key result = urlfetch.fetch(url) if result.status_code == 200: observations = parse_observation(result.content) # issued_date = parse_date(forecast["@dataDate"]) for date, data in timesteps(observations): obs_timestep = ObservationTimestep.get_by_site_and_datetime( site, date) if obs_timestep is None: obs_timestep = ObservationTimestep( site=site, observation_datetime=date, observation_date=date.date()) for k, v in data.items(): prop_name = snake_case(k) if hasattr(obs_timestep, prop_name): if v == "missing": v = None elif prop_name == 'temperature': v = float(v) setattr(obs_timestep, prop_name, v) obs_timestep.save() #logging.info("%s, %s" % (str(date), str(ObservationTimestep))) return Response(status=204)
def observation_update2(site_key): site = Site.get_by_key_name(site_key) if site is None: return Response(status = 404) url = "http://www.metoffice.gov.uk/public/data/PWSCache/BestForecast/Observation/%s?format=application/json" % site_key result = urlfetch.fetch(url) if result.status_code == 200: observations = parse_observation(result.content) # issued_date = parse_date(forecast["@dataDate"]) for date, data in timesteps(observations): obs_timestep = ObservationTimestep.get_by_site_and_datetime(site, date) if obs_timestep is None: obs_timestep = ObservationTimestep(site = site, observation_datetime = date, observation_date = date.date()) for k,v in data.items(): prop_name = snake_case(k) if hasattr(obs_timestep, prop_name): if v == "missing": v = None elif prop_name == 'temperature': v = float(v) setattr(obs_timestep, prop_name, v) obs_timestep.save() #logging.info("%s, %s" % (str(date), str(ObservationTimestep))) return Response(status = 204)
def latest_obs_and_forecast(site_id): result = memcache.get(site_id, "site_latest") if result: return result site = Site.get_by_key_name(site_id) if site is None: return None obs = ObservationTimestep.find_latest_by_site(site, limit=6) result = None if len(obs) > 0: forecasts = ForecastTimestep.find_by_site_closest_by_date( site, first(obs).observation_datetime, limit=50) closest_forecast = first(forecasts) if closest_forecast: matching_obs = first( filter( lambda o: o.observation_datetime == closest_forecast. forecast_datetime, obs)) matching_forecasts = ifilter( lambda f: f.forecast_datetime == closest_forecast. forecast_datetime, forecasts) if matching_obs: #finally have both... a single obs report and multiple forecasts obs_dict = to_dict_excl_sites(matching_obs) obs_dict['best_forecast'] = map( to_dict_excl_sites, make_five_day_list(matching_forecasts)) result = {'site': site.to_dict(), 'observation': obs_dict} memcache.set(site_id, result, 60 * 60, namespace='site_latest') return result
def latest_obs_and_forecast(site_id): result = memcache.get(site_id, "site_latest") if result: return result site = Site.get_by_key_name(site_id) if site is None: return None obs = ObservationTimestep.find_latest_by_site(site, limit=6) result = None if len(obs) > 0: forecasts = ForecastTimestep.find_by_site_closest_by_date(site, first(obs).observation_datetime, limit=50) closest_forecast = first(forecasts) if closest_forecast: matching_obs = first(filter(lambda o: o.observation_datetime == closest_forecast.forecast_datetime, obs)) matching_forecasts = ifilter(lambda f: f.forecast_datetime == closest_forecast.forecast_datetime, forecasts) if matching_obs: #finally have both... a single obs report and multiple forecasts obs_dict = to_dict_excl_sites(matching_obs) obs_dict['best_forecast'] = map(to_dict_excl_sites, make_five_day_list(matching_forecasts)) result = { 'site': site.to_dict(), 'observation': obs_dict } memcache.set(site_id, result, 60 * 60, namespace='site_latest') return result
def site_graph_data(site_id): site = Site.get_by_key_name(site_id) if site is None: return Response(status = 404) day = date.today() if request.args.has_key('day'): p = request.args.get('day') day = parse_yyyy_mm_dd_date(p) # obs data first obs = ObservationTimestep.find_by_site_and_date(site, day) series = [make_series('Observation temperature °C', obs, 'observation_datetime', 'temperature')] return json_response({'day': str(day), 'series': series})
def site_detail(site_id): site = Site.get_by_key_name(site_id) if site is None: return Response(status = 404) obs = ObservationTimestep.find_latest_by_site(site = site, limit = 24) forecasts = [] if len(obs) > 0: first_obs = first(obs) last_obs = last(obs) forecasts = ForecastTimestep.find_by_site_between_dates( site = site, from_dt = last_obs.observation_datetime, to_dt = first_obs.observation_datetime) return Response(json.dumps({ 'site': site.to_dict(), 'observations': map(lambda o: o.to_dict(excluding = ['site']), obs), 'forecasts': map(lambda f: f.to_dict(excluding = ['site']), forecasts) }), content_type = "application/json")