def calc_ioveru_fom(config) : """calculates the intersection over union figure of merit. This function assumes that the mask_sum raster already exists in the database. Returns a floating point number from 0..1""" query = "SELECT viirs_calc_fom('{0}')".format(config.DBschema) # now, need to execute a query that returns a single result. ConnParam = vt.postgis_conn_params(config) conn = psycopg2.connect(ConnParam) # Open a cursor to perform database operations cur = conn.cursor() cur.execute(query) rows = cur.fetchall() conn.commit() # Close communication with the database cur.close() conn.close() return rows[0][0]
def calc_ioveru_fom(config): """calculates the intersection over union figure of merit. This function assumes that the mask_sum raster already exists in the database. Returns a floating point number from 0..1""" query = "SELECT viirs_calc_fom('{0}')".format(config.DBschema) # now, need to execute a query that returns a single result. ConnParam = vt.postgis_conn_params(config) conn = psycopg2.connect(ConnParam) # Open a cursor to perform database operations cur = conn.cursor() cur.execute(query) rows = cur.fetchall() conn.commit() # Close communication with the database cur.close() conn.close() return rows[0][0]
def find_missing_zonetbl_runs(gt_schema, zone_tbl, config): """locates missing run_ids in the zone_tbl by comparing with the list of schemas""" query = """select b.runs from (select nspname runs from pg_namespace where nspname LIKE 'Run_%') b where b.runs not in (select distinct run_id from "{0}"."{1}")""".format( gt_schema, zone_tbl) # now, need to execute a query that returns multiple results. ConnParam = vt.postgis_conn_params(config) conn = psycopg2.connect(ConnParam) # Open a cursor to perform database operations cur = conn.cursor() cur.execute(query) rows = cur.fetchall() conn.commit() # Close communication with the database cur.close() conn.close() runs = [i[0] for i in rows] return runs
def find_missing_zonetbl_runs(gt_schema, zone_tbl, config) : """locates missing run_ids in the zone_tbl by comparing with the list of schemas""" query = """select b.runs from (select nspname runs from pg_namespace where nspname LIKE 'Run_%') b where b.runs not in (select distinct run_id from "{0}"."{1}")""".format( gt_schema, zone_tbl) # now, need to execute a query that returns multiple results. ConnParam = vt.postgis_conn_params(config) conn = psycopg2.connect(ConnParam) # Open a cursor to perform database operations cur = conn.cursor() cur.execute(query) rows = cur.fetchall() conn.commit() # Close communication with the database cur.close() conn.close() runs = [ i[0] for i in rows ] return runs