use test;

drop table if exists wtemp;

create temporary table wtemp (
  dir   double,
  speed double,
  color varchar(255), 
  label varchar(255)
);

-- the data labels
insert into wtemp
  values
    (225, 78,  'rgb(0,0,0,0)', '0'),
    (247.5, 78,  'rgb(0,0,0,0)', '10'),
    (270, 78,  'rgb(0,0,0,0)', '20'),
    (292.5, 78,  'rgb(0,0,0,0)', '30'),
    (315,  78,  'rgb(0,0,0,0)','40'),
    (337.5, 78,  'rgb(0,0,0,0)', '50'),
    (360, 78,  'rgb(0,0,0,0)', '60'),
    (382.5, 78,  'rgb(0,0,0,0)', '70'),
    (45, 78,  'rgb(0,0,0,0)',  '80'),
    (67.5, 78,  'rgb(0,0,0,0)', '90'),
    (90, 78,  'rgb(0,0,0,0)',  '100'),
    (112.5, 78,  'rgb(0,0,0,0)', '110'),
    (135, 78,  'rgb(0,0,0,0)', '120')
;
 
insert into wtemp
 select 
   (((temp * 270.0)/120.0) + 225.0) % 360, 75, 'light red', null
   from raws_bl
   where gmt = (select max(gmt) from raws_bl)
;

plot radarchart
  length, direction, color override, datalabels
  with
    note " "
    note "Temperature"
    font 'sans serif' plain 14
    zerobased
    no labels y
    no labels x 
    scale x 225 135 22.5
    scale y 0 75 25

    framecolor very light gray
 --  background very light blue
    page 0 0 210 180
    frame 40 15 150 155
select SPEED, dir, color, label
  from wtemp
;