-
Notifications
You must be signed in to change notification settings - Fork 0
/
constants.py
66 lines (59 loc) · 3.31 KB
/
constants.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
stations = ['SKBO','SKBG','SKCL','SKCC','SKCG','SKPE','SKSP','SKSM','SKRG']
query = "SELECT * FROM dataclean where day_hour > now() - interval '1MONTH'"
air_names = {#'SKAR':'Aeropuerto Internacional el Edén (Armenia - QuindÃo)',
'SKBG':'Aeropuerto Internacional Palonegro (Bucaramanga - Santander)',
'SKBO':'Aeropuerto Internacional El Dorado (Bogotá - Bogotá D.C.)',
'SKCC':'Aeropuerto Internacional Camilo Daza (Cúcuta - Norte de Santander)',
'SKCG':'Aeropuerto Internacional Rafael Nuñez (Cartagena - Bolívar)',
'SKCL':'Aeropuerto Internacional Alfonso Bonilla Aragon (Cali - Valle)',
#'SKMR':'Aeropuerto Internacional Los Garzones (MonterÃa - Córdoba)',
'SKPE':'Aeropuerto Internacional Matecaña (Pereira - Risaralda)',
'SKSM': 'Aeropuerto Internacional Simón Bolivar (Santa Marta - Magdalena)',
'SKSP':'Aeropuerto Internacional Gustavo Rojas Pinilla (San Andrés - Colombia)',
'SKRG':'Aeropuerto Internacional José María Córdova (Medellín - Antioquia)',
'SKBQ':'Aeropuerto Internacional Ernesto Cortissoz (Barranquilla - Atlantico)'}
airport_lat_lon = [
{'station_name':'SKBG','lat':7.1156792, 'lon':-73.1721692},
{'station_name':'SKBO','lat':4.6931832, 'lon':-74.1460662},
{'station_name':'SKCC','lat':7.9169411, 'lon':-72.5126214},
{'station_name':'SKCG','lat':10.446381, 'lon':-75.5174062},
{'station_name':'SKCL','lat':3.5411098, 'lon':-76.3867725},
{'station_name':'SKPE','lat':4.8151963, 'lon':-75.7384446},
{'station_name':'SKSM','lat':11.116147, 'lon':-74.2343331},
{'station_name':'SKSP','lat':12.5861164,'lon':-81.7043465},
{'station_name':'SKRG','lat':6.1707687, 'lon':-75.4298088},
{'station_name':'SKBQ','lat':10.886538, 'lon':-74.778667}]
################
#### Lista de diccionarios de Nombre De Variables Para el Dropdown
vars_list = [
{'label':'Airport','value':'station_name'},
{'label':'Date','value':'day_hour'},
#{'label':'Longitude','value':'lon'},
#{'label':'Latitude','value':'lat'},
{'label':'Air Temperature (F)','value':'tmpf'},
{'label':'Dew Point (F)','value':'dwpf'},
{'label':'Relative Humidity %','value':'relh'},
{'label':'Wind Direction (Degrees From North)','value':'drct'},
{'label':'Wind Speed (Knots)','value':'sknt'},
{'label':'Pressure in Altimeter','value':'alti'},
{'label':'Horizontal Visibility','value':'vsby'},
{'label':'Vertical Visibility','value':'skyl1'},
{'label':'Apparent Temperature (Wind Chill or Heat Index in F)','value':'feel'},
]
################
#### Lista de diccionarios de Nombre De Variables Para el la Tabla
vars_list_dt = [
{'name':'Airport','id':'station_name'},
{'name':'Date','id':'day_hour'},
#{'name':'Longitude','id':'lon'},
#{'name':'Latitude','id':'lat'},
{'name':'Air Temperature (F)','id':'tmpf'},
{'name':'Dew Point (F)','id':'dwpf'},
{'name':'Relative Humidity %','id':'relh'},
{'name':'Wind Direction (Degrees From North)','id':'drct'},
{'name':'Wind Speed (Knots)','id':'sknt'},
{'name':'Pressure in Altimeter','id':'alti'},
{'name':'Horizontal Visibility','id':'vsby'},
{'name':'Vertical Visibility','id':'skyl1'},
{'name':'Apparent Temperature (Wind Chill or Heat Index in F)','id':'feel'},
]