I'm somewhat familiar with ArcGIS Desktop, but have no experience in Python. I have about 100 shapefiles which have an attribute table containing a date, but I need a column which contains a corresponding season.
To complicate things a little more, I do not want to define seasons the traditional way. Seasons are defined as follows: a. Summer = June, July, August, September b. Fall = October, November c. Winter = December, January, February, March d. Spring = April, May
So far, I've been pasting and copying each attribute table into Excel, and using a function that looks like this: =CHOOSE(MONTH(J2),"Winter","Winter","Winter","Spring","Spring","Summer","Summer","Summer","Summer","Fall","Fall","Winter")
I'm sure there is a faster way to do things.
I recently added a 'MONTH' column using this script: Left( [GMT_DATE] , Len( [GMT_DATE] ) -8 )
I figured out how to generate a season column from a month column, but I am still unable to generate a season column directly from a date column. When I try I get "Winter" for everything.