It's a seasonal map, so every year must overlay onto a 366 day grid. The table that contains the data has assigned each day a day number from 1 to 366. If the year isn't a leap year, then day 60 will simply not be registered for that year.
Not only will day 60 not appear except every 4 years, but other days will not appear year to year because they fall on a weekend. The data does not cover weekends. Therefore, although the grid (table) may contain 10 years of data, for example, this does not mean that you will have 10 day 1's, 2's, 3's, etc. There will be different counts for each day number from this 10 year sample. So what I was looking to do (and have successfully done so) is to get a count of each DOY (day of year) in the sampling. This allows for calculations that need to know how many actual particular DOY there is rather than how many years there is. :-) Rick #>-----Original Message----- #>From: [email protected] #>[mailto:[email protected]] On Behalf Of John Machin #>Sent: Sunday, July 26, 2009 8:43 PM #>To: General Discussion of SQLite Database #>Subject: Re: [sqlite] Little Help on SQL #> #>On 27/07/2009 7:40 AM, Rick Ratchford wrote: #> #>> I have a TABLE with a column of Day Numbers (1 to 366) #>called DayNum. #> #>> Let's say that you want get a count of each DayNum. #> #>> How do I word my statement so that it gives me a count of #>each DayNum, #>> which is from 1 to 366? #> #>Consider leap years ... day number 60 means February 29 in a #>leap year and March 01 in other years. The last day of the #>year is day 366 in a leap year and day 365 in other years. #>Comparing day numbers that relate to different years seems #>not very meaningful. Grouping by day numbers that relate to #>different years seems likewise not very meaningful (for day #>numbers greater than 59). #> #>What are you trying to achieve? #> #> #>_______________________________________________ #>sqlite-users mailing list #>[email protected] #>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users #> #> _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
