meteortools.ukmondb.getDetections

 1# Copyright (C) 2018-2023 Mark McIntyre
 2
 3# use the API to retrieve single-station data
 4
 5import datetime 
 6import requests
 7import pandas as pd
 8
 9
10def getDetections(dtstr, interval='m'):
11    """ 
12    Returns a list of detections within one interval of the specified time  
13
14    Arguments:  
15        dtstr:      [string] Date to search for in the format YYYYMMDD_HHMMSS  
16        interval:   [string] window to search around the specified time. Currently only 'm' supported  
17
18    Returns:  
19        pandas dataframe containing [ID, Dtstamp, Filename] of any matching detections  
20
21    Note:  
22        dtstr must be at least YYYYMMDD_HHMM. If seconds are omitted, the window wil be centred on 
23        hh:mm:30.  
24
25    """
26    srchapi = 'https://api.ukmeteors.co.uk/detections?'
27    if len(dtstr) < 13:
28        print('date range too wide. Must contain minutes')
29        return False
30    if len(dtstr) == 13:
31        dtstr = dtstr + '30'
32    if len(dtstr) == 14:
33        dtstr = dtstr + '0'
34    dt = datetime.datetime.strptime(dtstr[:15], '%Y%m%d_%H%M%S')
35    if interval == 'm':
36        dt1 = (dt + datetime.timedelta(seconds=-30)).strftime('%Y-%m-%dT%H:%M:%S.000Z')
37        dt2 = (dt + datetime.timedelta(seconds=30)).strftime('%Y-%m-%dT%H:%M:%S.000Z')
38    apiurl = f'{srchapi}d1={dt1}&d2={dt2}&opts=t:S'
39
40    res = requests.get(apiurl)
41    ids = []
42    filenames = []
43    dtstamps = []
44    if res.status_code == 200:
45        rawdata=res.text.strip()
46        rawdata = rawdata[8:-2]
47        spls = rawdata.split('"')
48        for spl in spls:
49            if len(spl) > 10:
50                thisrow = spl.split(',')
51                ids.append(thisrow[4])
52                fname = thisrow[5].split('/')[-1].strip()
53                filenames.append(fname)
54                dtstamps.append(fname[10:25])
55        df = pd.DataFrame({'ID':ids, 'Dtstamp':dtstamps, 'Filename':filenames})
56        return df
57    else:
58        return False