get_metadata.py

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
Created on Wed Jul 24 10:11:53 2024

@author: vicky
"""


def get_metadata(station, mydb, mycursor):

    query = ("select mg.source, mg.project, ms.stationName, mg.country, ms.latitude, ms.longitude, ms.elevation, mg.link,ms.timeZone, ms.UTCoffset from metadata_global mgjoin MetadataStations ms on ms.project = mg.project where stationName like '{station}';")

    mycursor.execute(query)
    result = mycursor.fetchall()
    source = result[0]
    project = result[1]
    stationName = result[2]
    country = result[3]
    latitude = result[4]
    longitude = result[5]
    elevation = result[6]
    link = result[7]
    timeZone = result[8]
    UTCoffset = result[9]

    stationID = stationName+country

    return (source, project, stationName, stationID, latitude, longitude, elevation, link, timeZone, UTCoffset)