USACE / instrumentation

Instrumentation project issue tracking and project planning
MIT License
4 stars 1 forks source link

Add 'unknown' timeseries parameter and units #82

Closed adamscarberry closed 3 years ago

adamscarberry commented 3 years ago

will be used primarily for streamgages automated loads where an opendcs param set in xml cannot be mapped to a param and/or unit in midas.

adamscarberry commented 3 years ago

The following was run on dev, test and prod database:

update measure set name = 'unknown' where id = '43fefa8b-10e9-4b27-8ed4-36e36174fbeb';

INSERT INTO unit (id, unit_family_id, measure_id, name, abbreviation) VALUES
('4a999277-4cf5-4282-93ce-23b33c65e2c8', 'c9f3b6d2-3136-4330-a330-66e402b4ee04', '43fefa8b-10e9-4b27-8ed4-36e36174fbeb', 'unknown', 'unknown');

INSERT INTO parameter (id, name) VALUES
('2b7f96e1-820f-4f61-ba8f-861640af6232', 'unknown');