Live CDEC Agent

<< Click to Display Table of Contents >>

Navigation:  Live > Agents > Web API Agents > Web API Open Data >

Live CDEC Agent

Report Names: EQuIS Live: CDEC Agent and EQuIS Live: CDEC Historical Data Loader (example)

File Name: EarthSoft.Live.Reports.dll


Description: The EQuIS Live: CDEC Agent and EQuIS Live: CDEC Historical Data Loader reports allow users to retrieve water data from the California Data Exchange Center (CDEC) web API in EQuIS Professional and Enterprise.





Adding Station(s)


Before running these reports, one or more stations must be added to the DT_LOGGER table:

1.Add the station (DT_LOGGER row) in EQuIS Professional.


3.Set LOGGER_CODE to a station ID from here (e.g., IGO for CLEAR CREEK NEAR IGO).

4.Set STATUS_FLAG to 'A' to activate the logger.



Loading Data


These reports will automatically add the series (and datum) when they run. They use the Html Agility Pack library to get the series info (e.g., from CLEAR CREEK NEAR IGO). A series can then be activated or deactivated, by setting its STATUS_FLAG = 'A' or 'R', to start or stop (respectively) obtaining data for it. Also, the SERIES_UNIT and SERIES_DESC for a series may be changed, but not its SERIES_NAME; it uniquely identifies the series using the CDEC Sensor Number and Duration Code (e.g., 41-D for CLEAR CREEK NEAR IGO's FLOW, MEAN DAILY, CFS).


These reports can be run manually or as scheduled EQuIS Information Agents (EIAs), at the desired frequency, to automatically load data as often as needed. The Agent report will load data for all loggers with LIVE_DATA_SOURCE containing CDEC from the logger's most recent date (in DT_LOGGER_DATUM.DATUM_UTC_DT) until today's date. The Historical Data Loader report allows the user to select the logger(s) and date range.


Historical Data Loader Report Parameters


Select the desired logger(s).

If no logger is selected, data for all loggers will be retrieved.

Date Range


Start Date

Enter the desired start date (defaults to the first day of the current month).

End Date

Enter the desired end date (defaults to the first day of the following month).

Update existing values?

Check this box to update existing database values if they are different from what the web API's reporting.

* This report also includes hidden parameter: Facility