|
|
|
|
|
Error!
Query:select c.fecha as si_fecha_local,'SFelipeTA' as s_cod, si.imin as imin,si.iprom as iprom,si.imax as imax from (select * from xcalendario where date(fecha)>='2026-01-18 00:00:01' and date(fecha)<='2026-01-19' group by date(fecha),hour(fecha)) as c left join (select s_cod as s_cod, concat(substring(si_fecha_local,1,14),'00:00') as si_fecha_local, min(si_min) as 'imin',avg(si_prom) as 'iprom', max(si_max) as 'imax'
from sensor_informe_2026
where s_cod='SFelipeTA' and date(si_fecha_local)>='2026-01-18 00:00:01' and date(si_fecha_local)<='2026-01-19'
group by date(si_fecha_local),hour(si_fecha_local)
order by si_fecha_local
limit 0,50000) as si on c.fecha=si.si_fecha_local
Error message:
Table 'uvmet.sensor_informe_2026' doesn't exist
Error!
Query:select c.fecha as si_fecha_local,'SFelipeHR' as s_cod, si.imin as imin,si.iprom as iprom,si.imax as imax from (select * from xcalendario where date(fecha)>='2026-01-18 00:00:01' and date(fecha)<='2026-01-19' group by date(fecha),hour(fecha)) as c left join (select s_cod as s_cod, concat(substring(si_fecha_local,1,14),'00:00') as si_fecha_local, min(si_min) as 'imin',avg(si_prom) as 'iprom', max(si_max) as 'imax'
from sensor_informe_2026
where s_cod='SFelipeHR' and date(si_fecha_local)>='2026-01-18 00:00:01' and date(si_fecha_local)<='2026-01-19'
group by date(si_fecha_local),hour(si_fecha_local)
order by si_fecha_local
limit 0,50000) as si on c.fecha=si.si_fecha_local
Error message:
Table 'uvmet.sensor_informe_2026' doesn't exist
Error!
Query:select c.fecha as si_fecha_local,'SFelipeVV' as s_cod, si.imin as imin,si.iprom as iprom,si.imax as imax from (select * from xcalendario where date(fecha)>='2026-01-18 00:00:01' and date(fecha)<='2026-01-19' group by date(fecha),hour(fecha)) as c left join (select s_cod as s_cod, concat(substring(si_fecha_local,1,14),'00:00') as si_fecha_local, min(si_min) as 'imin',avg(si_prom) as 'iprom', max(si_max) as 'imax'
from sensor_informe_2026
where s_cod='SFelipeVV' and date(si_fecha_local)>='2026-01-18 00:00:01' and date(si_fecha_local)<='2026-01-19'
group by date(si_fecha_local),hour(si_fecha_local)
order by si_fecha_local
limit 0,50000) as si on c.fecha=si.si_fecha_local
Error message:
Table 'uvmet.sensor_informe_2026' doesn't exist
Error!
Query:select c.fecha as si_fecha_local,'' as s_cod, si.imin as imin,si.iprom as iprom,si.imax as imax from (select * from xcalendario where date(fecha)>='2026-01-18 00:00:01' and date(fecha)<='2026-01-19' group by date(fecha),hour(fecha)) as c left join (select s_cod as s_cod, concat(substring(si_fecha_local,1,14),'00:00') as si_fecha_local, min(si_min) as 'imin',avg(si_prom) as 'iprom', max(si_max) as 'imax'
from sensor_informe_2026
where s_cod='' and date(si_fecha_local)>='2026-01-18 00:00:01' and date(si_fecha_local)<='2026-01-19'
group by date(si_fecha_local),hour(si_fecha_local)
order by si_fecha_local
limit 0,50000) as si on c.fecha=si.si_fecha_local
Error message:
Table 'uvmet.sensor_informe_2026' doesn't exist
Error!
Query:select c.fecha as si_fecha_local,'' as s_cod, si.imin as imin,si.iprom as iprom,si.imax as imax from (select * from xcalendario where date(fecha)>='2026-01-18 00:00:01' and date(fecha)<='2026-01-19' group by date(fecha),hour(fecha)) as c left join (select s_cod as s_cod, concat(substring(si_fecha_local,1,14),'00:00') as si_fecha_local, min(si_min) as 'imin',avg(si_prom) as 'iprom', max(si_max) as 'imax'
from sensor_informe_2026
where s_cod='' and date(si_fecha_local)>='2026-01-18 00:00:01' and date(si_fecha_local)<='2026-01-19'
group by date(si_fecha_local),hour(si_fecha_local)
order by si_fecha_local
limit 0,50000) as si on c.fecha=si.si_fecha_local
Error message:
Table 'uvmet.sensor_informe_2026' doesn't exist
Error!
Query:select c.fecha as si_fecha_local,'' as s_cod, si.imin as imin,si.iprom as iprom,si.imax as imax from (select * from xcalendario where date(fecha)>='2026-01-18 00:00:01' and date(fecha)<='2026-01-19' group by date(fecha),hour(fecha)) as c left join (select s_cod as s_cod, concat(substring(si_fecha_local,1,14),'00:00') as si_fecha_local, min(si_min) as 'imin',avg(si_prom) as 'iprom', max(si_max) as 'imax'
from sensor_informe_2026
where s_cod='' and date(si_fecha_local)>='2026-01-18 00:00:01' and date(si_fecha_local)<='2026-01-19'
group by date(si_fecha_local),hour(si_fecha_local)
order by si_fecha_local
limit 0,50000) as si on c.fecha=si.si_fecha_local
Error message:
Table 'uvmet.sensor_informe_2026' doesn't exist
| Fecha | TA[ºC] | HR[%] | VV[m/s] | DV | RS[W/mt²] | PP[mm] |
|---|
Variable |
Significado |
| TA | Temperatura del Aire (Promedio) |
| HR | Humedad Relativa (Promedio) |
| VV | Velocidad de Viento (Promedio) |
| DV | Dirección del Viento (Promedio) |
| RS | Radiación Solar (Promedio) |
| PP | Precipitación (Suma) |