Example #1
0
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_)
Example #2
0
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