NOAA-GSL / MATS

MATS is a quick & interactive way to view verification statistics
https://gsl.noaa.gov/mats/
6 stars 0 forks source link

missing points is plots #80

Closed mollybsmith-noaa closed 3 years ago

mollybsmith-noaa commented 3 years ago

Author Name: kirk.l.holub (@kirklholub) Original Redmine Issue: 25659, https://vlab.ncep.noaa.gov/redmine/issues/25659 Original Date: 2016-10-21 Original Assignee: randy.pierce


This query returns 23 rows: select (analysis_utc + fcst_end_utc) as avtime , from_unixtime( analysis_utc + fcst_end_utc) as ymd, ws,sites_siteid from rap_esrl_nwp, nwp_recs where nwp_recs_nwprecid=nwprecid and (analysis_utc + fcst_end_utc) >=0 and (analysis_utc + fcst_end_utc)<=86400 and fcst_end_utc=0 and sites_siteid in (1) order by avtime;

However, only the first (0 utc) and 2nd two points from the last (72000 and 75600 utc) are plotted.

Expected to see 23 point from 0 to 79200 utc.

plot at: https://docs.google.com/a/noaa.gov/document/d/1UEQhCMpuz7IOc759JDxw6u68InCu9Hq1Pj4XIW3w5Wk/edit?usp=sharing

mollybsmith-noaa commented 3 years ago

Original Redmine Comment Author Name: kirk.l.holub (@kirklholub) Original Date: 2016-10-21T18:39:43Z


MATS was sorting times lexigraphicall instead of numerically. Fixed by adding callback function to the sort.

mollybsmith-noaa commented 3 years ago

Original Redmine Comment Author Name: randy.pierce (@randytpierce) Original Date: 2016-10-24T19:58:16Z


In Version 1.2.2016/10/21/22 and up