def gridData(res): #gives data located in S_DRIVER.cursor for gridding np_arrays = [] g_longs = [] g_lats = [] g_time = [] g_data = [] name = "" longs = [] # 1 lats = [] # 2 data = [] # 3 time_doy = [] # 4 , 5 , 6 time_ = [] # 4 , 5 , 6 for entry in S_DRIVER.cursor: name = entry[0] time_tmp = [entry[4],entry[5],entry[6]] time_doy.append(OCO2_Driver.dateToDOY(time_tmp)) time_.append(time_tmp) data.append(entry[3]) longs.append(entry[1]) lats.append(entry[2]) return (name, longs, lats , data, time_doy,time_)
def main(): #connect to data base cnx = SQL.connect(user='******', database='sciencedata', password='******') #create Ameriflux entries # Handle.getRoot() # Handle.CURR_DIR = Handle.FILE_SYS.root # files = AMERIFLUX_L2_STD.findCO2ByDate(Handle.CURR_DIR, "201412") # addData(cnx,files,"Ameriflux_TW") # print("Data Complete") # Handle.FILE_SYS = 0 # Handle.CURR_DIR = 0 #create OCO2_LITE Barrow entries # Handle.getRoot() # Handle.CURR_DIR = Handle.FILE_SYS.root # long_ = input("Enter longitude.") # lat_ = input("Enter Latitude.") # files = OCO2_LITE.findFilesByCoords(Handle.CURR_DIR, long_, lat_,"") # addData(cnx,files,"OCO2_Barrow") # print("Data Complete") # Handle.FILE_SYS = 0 # Handle.CURR_DIR = 0 #create OCO2_LITE Twitchell entries # Handle.getRoot() # Handle.CURR_DIR = Handle.FILE_SYS.root # long_ = input("Enter longitude.") # lat_ = input("Enter Latitude.") # files = OCO2_LITE.findFilesByCoords(Handle.CURR_DIR, long_, lat_,"") # addData(cnx,files,"OCO2_Twitchell") # print("Data Complete") # Handle.FILE_SYS = 0 # Handle.CURR_DIR = 0 #create OCO2_LITE Fort Peck entries # Handle.getRoot() # Handle.CURR_DIR = Handle.FILE_SYS.root # long_ = input("Enter longitude.") # lat_ = input("Enter Latitude.") # files = OCO2_LITE.findFilesByCoords(Handle.CURR_DIR, long_, lat_,"") # addData(cnx,files,"OCO2_FortPeck") # print("Data Complete") # Handle.FILE_SYS = 0 # Handle.CURR_DIR = 0 #create OCO2_LITE Fort Peck entries # Handle.getRoot() # Handle.CURR_DIR = Handle.FILE_SYS.root # long_ = input("Enter longitude.") # lat_ = input("Enter Latitude.") # files = OCO2_LITE.findFilesByCoords(Handle.CURR_DIR, long_, lat_,"") # addData(cnx,files,"OCO2_K34") # print("Data Complete") # Handle.FILE_SYS = 0 # Handle.CURR_DIR = 0 #create OCO2_World entries Handle.getRoot() Handle.CURR_DIR = Handle.FILE_SYS.root long_ = input("Enter longitude.") lat_ = input("Enter Latitude.") files = OCO2_LITE.findFilesByCoords(Handle.CURR_DIR, long_, lat_,"") print("Adding data now...") addData(cnx,files,"OCO2_World") print("Data Complete") Handle.FILE_SYS = 0 Handle.CURR_DIR = 0