Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Delivered: data volume delivered to user after post-processing(e.g. interpolation) applied if asked for
  • Retrieved: data volume retrieved from MARS before post-processing
    • retrieved data volume is normally equal or bigger then the delivered one with exception when user asked for higher then archived grid resolution resulting in artificially bigger interpolated files
Chart
3Dtrue
showShapesfalse
timePeriodQuarter
width1200
categoryLabelPositionup45
dataOrientationvertical
typebarline
yLabelTB
height400


SQL
idmydata
dataSourcemars_apistats
select  to_char(month, 'MM/YYYY') as monthyear, CAST(delivered AS FLOAT)/1024^4 as "Delivered" from datasets_stats_monthly where dataset='tigge-global' and month>=date'20061001' order by month ;
select  to_char(month, 'MM/YYYY') as monthyear, CAST(retrieved AS FLOAT)/1024^4 as "Retrieved" from datasets_stats_monthly where dataset='tigge-global' and month>=date'20061001' order by month


...