|Date: ||Mon, 17 Sep 2001 16:14:14 -0400|
|Reply-To: ||Mike Rhoads <RHOADSM1@WESTAT.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Mike Rhoads <RHOADSM1@WESTAT.COM>|
|Subject: ||Re: Time zone|
|Content-Type: ||text/plain; charset="iso-8859-1"|
The U.S. National Weather Service has a web page from which a county-level
file can apparently be downloaded that includes state and county name, FIPS
code, and time zone. The web site is at
http://isl715.nws.noaa.gov/mapdata/newcat/county/county_all.htm. I haven't
tried the download. This should help dealing with the "troublesome twelve".
The page mentions that there are 10 counties which are themselves divided by
a time zone boundary (not too bad, out of 3,000+).
Of course, presumably you will have to use zip code to get county code, and
that's not perfect either (zip codes may overlap counties). This has been
discussed on the list on numerous occasions. The best resource I've found
on this issue is the Zip Code Resource Page, courtesy of John Blodgett and
the Office of Social and Economic Data Analysis at the University of
Missouri. The URL is http://www.oseda.missouri.edu/uic/ZIP.resources.html.
From: David L. Cassell [mailto:Cassell.David@EPAMAIL.EPA.GOV]
Sent: Monday, September 17, 2001 2:36 PM
Subject: Re: Time zone
Unfortunately for the poster, there are about 12 states which have
time-zone lines cutting through them [including my home state of
Tennessee]. For the other 38, a lookup table on state would suffice,
with some additional info used for the 'troublesome twelve'.
David Cassell, CSC
Senior computing specialist