-
Notifications
You must be signed in to change notification settings - Fork 0
/
TODO
34 lines (25 loc) · 1023 Bytes
/
TODO
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
# TESS import utility
- Use SQL file as the final output
- search for duplicate sequence nambers in a +- 15 seconds time span
- search for instrument id daily from instrument name from tess_readings_t
- Modify tess_units_t to add source type (real-time or imported)
and fix tess_units_id to use
- search for location id daily based on instrument name existing in tess_readings_t
- create an output table similar to tess_readings_t with additional fields_
- tess_name
- processed_flag
- etc. º
Hitorico de tess y sitios asignados
SELECT DISTINCT i.name, l.site
FROM tess_readings_t as r
JOIN tess_t AS i USING (tess_id)
JOIN location_t AS l USING (location_id)
ORDER BY i.name;
PROBLEMAS
=========
1) tess location create ""
2) EL RETORNO DE CARRO
tess location create "Gladstone Inn
" --longitude "175.6311110" --latitude "-41.0725000" --elevation "0.0" --dbase "/var/dbase/tess.db"
3) Error => name 'photometer' is not defined
4) Error => You did not supply a value for binding 1.