GHCNDSetup.py File Reference

Namespaces
	GHCNDSetup
	Builds SQLite3/Spatialite database needed for querying NCDC Global Historical Climatology Network station metadata downloaded from http://www1.ncdc.noaa.gov/pub/data/ghcn/daily/ghcnd-stations.txt.

Variables
string	GHCNDSetup._sanitizeString = '[\'";]'
tuple	GHCNDSetup.SRS = int(4326)
string	GHCNDSetup.DB_NAME = 'GHCND.spatialite'
string	GHCNDSetup.URL = 'http://www1.ncdc.noaa.gov/pub/data/ghcn/daily/ghcnd-stations.txt'
tuple	GHCNDSetup.parser = argparse.ArgumentParser(description='Build database of GHCN station metadata')
string	GHCNDSetup.help = 'Directory to which database named "GHCND.sqlite" should be placed'
tuple	GHCNDSetup.args = parser.parse_args()
tuple	GHCNDSetup.ghcnDB = os.path.join(args.outputDir, DB_NAME)
	GHCNDSetup.url = URL
tuple	GHCNDSetup.conn = spatialite.connect(ghcnDB)
tuple	GHCNDSetup.cursor = conn.cursor()
tuple	GHCNDSetup.hasSpatial = cursor.fetchone()
tuple	GHCNDSetup.f = urllib.urlopen(url)
tuple	GHCNDSetup.line = f.readline()
tuple	GHCNDSetup.id = unicode(line[:11].strip(), errors='replace')
tuple	GHCNDSetup.lat = float(line[12:19].strip())
tuple	GHCNDSetup.lon = float(line[21:29].strip())
tuple	GHCNDSetup.elev = float(line[31:36].strip())
tuple	GHCNDSetup.name = unicode(line[41:70].strip(), errors='replace')
string	GHCNDSetup.sql = u"INSERT INTO ghcn_station (id,name,elevation_m,coord) VALUES ('%s','%s',%f,GeomFromText('POINT(%f %f)', %d) )"