http://fawn.ifas.ufl.edu/scripts/fawndataserver.asp?sql=select datePart(yy,datetime) AS Year,datePart(mm,datetime) AS Month,datePart(dd,datetime) AS Day, FLOOR(AVG(soiltempavg)*100)/100 as 'avgST',count(soiltempavg) as 'soilTCount' from weather where id=260 and (datetime between '04/14/2005' and '04/23/2005') GROUP BY datePart(yy,datetime), datePart(mm,datetime),datePart(dd,datetime) ORDER BY datePart(yy,datetime),datePart(mm,datetime),datePart(dd,datetime)
 


YEAR,MONTH,DAY,AVGWSPD,WINDCOUNT,AVGST,SOILTCOUNT
2005,3,14,12,95,18.31,95
2005,3,15,10,96,17.78,96
2005,3,16,8,96,17.61,96
2005,3,17,8,96,17.2,96
2005,3,18,7,96,15.33,96
2005,3,19,5,96,15.31,96
2005,3,20,4,96,16.41,96
2005,3,21,8,96,17.64,96
2005,3,22,12,96,18.76,96
2005,3,23,18,96,19.28,96
2005,3,24,8,96,19.2,96
2005,3,25,7,96,19.51,96
2005,3,26,6,96,19.27,96
2005,3,27,16,96,19.9,96
2005,3,28,25,96,20.47,96
2005,3,29,11,96,19.79,96
2005,3,30,5,95,20.16,95
2005,3,31,8,96,20.97,96
2005,4,1,13,96,21.37,96
2005,4,2,17,96,21.21,96
2005,4,3,6,1,19.96,1