You are not logged in. Click here to log in.

Application Lifecycle Management

Search In Project

Search inClear

CFA Load Estimator (LOADEST) Analysis#6467/HEAD / v8
Tags:  not added yet

CFA Load Estimator (LOADEST) Analysis[SERVICE-6467]

Tracker: Services Priority: NormalNormal Status: Deployed
Submitted by: wlloydJan 12 2016 11:03 Modified by: tcwibleFeb 28 2019 14:40 Type:
Model
Path: m/cfa/loadest Context: csip-cfa Version: 1.0
Endpoints: http://csip.engr.colostate.edu:8088/csip-cfa/m/cfa/loadest/1.0
Maintainers:
Website: http://onewatersolutions.com/our-software/tools/water-quality Apps:
--
Test Status:
--
Last Tested: -- Test Count: --
Test Success Rate: -- Failed Tests: --
Traceability
Loading…
Description
Another executable-based analysi included in CFA is the Load Estimator which is a tool (LOADEST) developed by the U.S. Geological Survey (Runkel et al. 2004). LOADEST is a FORTRAN executable that estimates the amount of constituent loads in streams and rivers given a time series of stream flows and constituent concentrations. Estimation of constituent loads occurs in two steps, the calibration procedure and the estimation procedure, both of which are based on three statistical estimation methods. These methods are Adjusted Maximum Likelihood Estimation (AMLE), Maximum Likelihood Estimation (MLE) and Least Absolute Deviation (LAD). The first two methods are appropriate when the calibration model errors, or residuals, are normally distributed. Of these two, AMLE is best utilized when the calibration data (i.e. stream flow and constituent concentration) are censored. The LAD is an alternative to maximum likelihood estimation when the residuals are not normally distributed.

In the calibration step, known constituent concentrations with corresponding stream flows are used to calibrate LOADEST so that it may be determined which of the preloaded models in LOADEST may best be used for determining the load. Next, in the estimation step, all of the known stream flows are used to estimate loads of constituent for each day. Please note that the names of the output file are dynamically determined by the water quality test analyzed.

References:

Runkel, Robert L., Charles G. Crawford, and Timothy A. Cohn. U.S. Department of the Interior, U.S. Geological Survey. Load Estimator (LOADEST): A FORTRAN Program for Estimating Constituent Loads in Streams and Rivers.Reston, Virginia: 2004.

Notes about "wq_test":

- A complete list of water quality tests accepted by the databases accessed by this service is available here: https://www.waterqualitydata.us/public_srsnames/

- STORET water quality test names (wq_test) should match the format of Parm Code<space>Characteristic Name<space>--<space>units (i.e. "00600 Nitrogen, mixed forms (NH3), (NH4), organic, (NO2) and (NO3) -- mg/l")

- USGS water quality test names (wq_test) should match the format of Parm Code<space>Description<space>--<space>units (i.e. "00600 Total nitrogen (nitrate + nitrite + ammonia + organic-N), water, unfiltered, milligrams per liter -- mg/l")

Notes about Data Sources:

- All Data sources are accessed through the csip-lib-water library

- USGS Data extracted from the National Water Information System (NWIS) by encoded url (i.e. station id, begin/end dates, parameter type): https://help.waterdata.usgs.gov/faq/automated-retrievals

- STORET Data extracted from the Water Quality Data Portal (by the National Water Quality Monitoring Council) Web Services: https://www.waterqualitydata.us/webservices_documentation/

- CDWR Data extracted from the Colorado Decision Support System (CDSS) REST Services: http://dnrweb.state.co.us/dwr/dwrapiservice/help#TechInfoHelp&#All&#gettingstarted&#jsonxml

{
  "metainfo": {},
  "parameter": [
    {
      "name": "database",
      "description": "the database that the flow station belongs to (CDWR | STORET | USGS)",
      "value": "USGS"
    },
    {
      "name": "org_id",
      "description": "The ID for the supervising organization for the station within the STORET database (only used if database = 'STORET')",
      "value": "n\/a"
    },
    {
      "name": "station_id",
      "description": "station ID or name abbreviation used to query the specified database",
      "value": "06741510"
    },
    {
      "name": "station_name",
      "description": "Station name",
      "value": "BIG THOMPSON RIVER AT LOVELAND, CO."
    },
    {
      "name": "wq_test",
      "description": "Formatted name for the water quality test being used, Format is: '00600 Total nitrogen, water, unfiltered, milligrams per liter -- mg\/L' = '5-digit-USGS-water-quality-test-code test-name -- units'",
      "value": "00600 Total nitrogen, water, unfiltered, milligrams per liter -- mg\/L"
    },
    {
      "name": "ptopt",
      "description": "Print option for load estimates to be included in the output (0 | 1)",
      "value": 1
    },
    {
      "name": "seopt",
      "description": "Standard error option (1 | 2 | 3)",
      "value": 1
    },
    {
      "name": "ldopt",
      "description": "Determines the estimation period (0 for entire estimation period or 2 for entire estimation period and each month within the period)",
      "value": 0
    },
    {
      "name": "modelnumber",
      "description": "Determines the regression model used (0|1|2|3|4|5|6|7|8|9|10|11), see LOADEST user instruction for regression equations",
      "value": 0
    },
    {
      "name": "pbmon",
      "description": "Only used if modelnumber = 10 or 11, it is the beginning month for the periodic terms in the regression model (1|2|3|4|5|6|7|8|9|10|11|12)",
      "value": 5
    },
    {
      "name": "pemon",
      "description": "Only used if modelnumber = 10 or 11, it is the ending month for the periodic terms in the regression model (1|2|3|4|5|6|7|8|9|10|11|12)",
      "value": 7
    },
    {
      "name": "ulflag",
      "description": "Units of estimated load output (1 for kg\/day, 2 for g\/day, 3 lbs\/day, 4 tons\/day)",
      "value": 1
    },
    {
      "name": "begin_date",
      "description": "Begin date of data analysis, blank or formatted yyyy-MM-dd",
      "value": ""
    },
    {
      "name": "end_date",
      "description": "End date of data analysis, blank or formatted yyyy-MM-dd",
      "value": ""
    },
    {
      "name": "merge_datasets",
      "description": "true if user data is provided and this dataset is to be merged with the public dataset, false if public or user data is to be analyzed alone (not merged)",
      "value": false
    },
    {
      "name": "merge_method",
      "description": "Method of merging the datasets, user data first, public data first, max, ave., min (user | public | max | average | min)",
      "value": "user"
    },
    {
      "name": "user_data",
      "description": "String containing user uploaded data with one line header, first column dates (yyyy-mm-dd format), second column flow values in a tab-delimited format followed by a '$$' delimiter followed by one line header (date,00600 which needs to match the 5-digit USGS water quality code provided in wq_test), first column dates (yyyy-mm-dd format), second column water quality test values in a tab-delimited format. Only used if merge_datasets == 'true' or database == 'UserData'.",
      "value": ""
    }
  ]
}
{
  "metainfo": {
    "status": "Finished",
    "suid": "d6a17e5f-d97f-11e5-988e-ed9830c33600",
    "cloud_node": "172.1.6.246",
    "tstamp": "2016-02-22 09:17:58",
    "service_url": "http://csip.engr.colostate.edu:8082/csip-cfa/m/cfa/loadest/1.0",
    "request_ip": "10.2.228.70",
    "cpu_time": 28053,
    "expiration_date": "2016-02-22 09:18:57"
  },
  "parameter": [
    {
      "name": "database",
      "description": "the database that the flow station belongs to (CDWR | STORET | USGS)",
      "value": "USGS"
    },
    {
      "name": "org_id",
      "description": "The ID for the supervising organization for the station within the STORET database (only used if database = 'STORET')",
      "value": "n/a"
    },
    {
      "name": "station_id",
      "description": "station ID or name abbreviation used to query the specified database",
      "value": "06741510"
    },
    {
      "name": "station_name",
      "description": "Station name",
      "value": "BIG THOMPSON RIVER AT LOVELAND, CO."
    },
    {
      "name": "wq_test",
      "description": "Formatted name for the water quality test being used, Format is: '00600 Total nitrogen, water, unfiltered, milligrams per liter -- mg/L' = '5-digit-USGS-water-quality-test-code test-name -- units'",
      "value": "00600 Total nitrogen, water, unfiltered, milligrams per liter -- mg/L"
    },
    {
      "name": "ptopt",
      "description": "Print option for load estimates to be included in the output (0 | 1)",
      "value": 1
    },
    {
      "name": "seopt",
      "description": "Standard error option (1 | 2 | 3)",
      "value": 1
    },
    {
      "name": "ldopt",
      "description": "Determines the estimation period (0 for entire estimation period or 2 for entire estimation period and each month within the period)",
      "value": 0
    },
    {
      "name": "modelnumber",
      "description": "Determines the regression model used (0|1|2|3|4|5|6|7|8|9|10|11), see LOADEST user instruction for regression equations",
      "value": 0
    },
    {
      "name": "pbmon",
      "description": "Only used if modelnumber = 10 or 11, it is the beginning month for the periodic terms in the regression model (1|2|3|4|5|6|7|8|9|10|11|12)",
      "value": 5
    },
    {
      "name": "pemon",
      "description": "Only used if modelnumber = 10 or 11, it is the ending month for the periodic terms in the regression model (1|2|3|4|5|6|7|8|9|10|11|12)",
      "value": 7
    },
    {
      "name": "ulflag",
      "description": "Units of estimated load output (1 for kg/day, 2 for g/day, 3 lbs/day, 4 tons/day)",
      "value": 1
    },
    {
      "name": "begin_date",
      "description": "Begin date of data analysis, blank or formatted yyyy-MM-dd",
      "value": ""
    },
    {
      "name": "end_date",
      "description": "End date of data analysis, blank or formatted yyyy-MM-dd",
      "value": ""
    },
    {
      "name": "merge_datasets",
      "description": "true if user data is provided and this dataset is to be merged with the public dataset, false if public or user data is to be analyzed alone (not merged)",
      "value": false
    },
    {
      "name": "merge_method",
      "description": "Method of merging the datasets, user data first, public data first, max, ave., min (user | public | max | average | min)",
      "value": "user"
    },
    {
      "name": "user_data",
      "description": "String containing user uploaded data with one line header, first column dates (yyyy-mm-dd format), second column flow values in a tab-delimited format followed by a '$$' delimiter followed by one line header (date,00600 which needs to match the 5-digit USGS water quality code provided in wq_test), first column dates (yyyy-mm-dd format), second column water quality test values in a tab-delimited format. Only used if merge_datasets == 'true' or database == 'UserData'.",
      "value": ""
    }
  ],
  "result": [
    {
      "name": "flow_len",
      "value": "13370"
    },
    {
      "name": "wq_len",
      "value": "240"
    },
    {
      "name": "wq_units",
      "value": "kg"
    },
    {
      "name": "start",
      "value": "1979-06-28"
    },
    {
      "name": "end",
      "value": "2016-02-21"
    },
    {
      "name": "data_source",
      "value": "Stream flow data and water quality test data retrieved from the U.S. Geological Survey, National Water Information System: Web Interface. http://waterdata.usgs.gov/nwis, accessed: 2016-02-22 09:18"
    },
    {
      "name": "daily_max",
      "value": "15470.0",
      "unit": "cfs"
    },
    {
      "name": "daily_min",
      "value": "1.076",
      "unit": "cfs"
    },
    {
      "name": "daily_upper_quartile",
      "value": "102.285",
      "unit": "cfs"
    },
    {
      "name": "daily_lower_quartile",
      "value": "14.402",
      "unit": "cfs"
    },
    {
      "name": "daily_median",
      "value": "40.376",
      "unit": "cfs"
    },
    {
      "name": "daily_mean",
      "value": "137.722",
      "unit": "cfs"
    },
    {
      "name": "daily_standard_deviation",
      "value": "511.54",
      "unit": "cfs"
    },
    {
      "name": "monthly_max",
      "value": "214127.4",
      "unit": "cfs"
    },
    {
      "name": "monthly_min",
      "value": "151.478",
      "unit": "cfs"
    },
    {
      "name": "monthly_upper_quartile",
      "value": "3426.56",
      "unit": "cfs"
    },
    {
      "name": "monthly_lower_quartile",
      "value": "529.911",
      "unit": "cfs"
    },
    {
      "name": "monthly_median",
      "value": "1698.717",
      "unit": "cfs"
    },
    {
      "name": "monthly_mean",
      "value": "4175.383",
      "unit": "cfs"
    },
    {
      "name": "monthly_standard_deviation",
      "value": "13446.616",
      "unit": "cfs"
    },
    {
      "name": "yearly_max",
      "value": "375449.716",
      "unit": "cfs"
    },
    {
      "name": "yearly_min",
      "value": "2230.347",
      "unit": "cfs"
    },
    {
      "name": "yearly_upper_quartile",
      "value": "55936.16",
      "unit": "cfs"
    },
    {
      "name": "yearly_lower_quartile",
      "value": "17820.317",
      "unit": "cfs"
    },
    {
      "name": "yearly_median",
      "value": "24329.776",
      "unit": "cfs"
    },
    {
      "name": "yearly_mean",
      "value": "48456.417",
      "unit": "cfs"
    },
    {
      "name": "yearly_standard_deviation",
      "value": "66298.086",
      "unit": "cfs"
    },
    {
      "name": "user_resultFile1",
      "value": "Totalnitrogen.ind"
    },
    {
      "name": "user_resultFile2",
      "value": "Totalnitrogen.out"
    },
    {
      "name": "user_resultFile3",
      "value": "Totalnitrogen.res"
    },
    {
      "name": "graph_data_files",
      "value": "daily_graph.out|daily_boxplot.out|monthly_graph.out|monthly_boxplot.out|yearly_graph.out|yearly_boxplot.out"
    },
    {
      "name": "daily_graph.out",
      "value": "http://csip.engr.colostate.edu:8082/csip-cfa/q/d6a17e5f-d97f-11e5-988e-ed9830c33600/daily_graph.out"
    },
    {
      "name": "daily_boxplot.out",
      "value": "http://csip.engr.colostate.edu:8082/csip-cfa/q/d6a17e5f-d97f-11e5-988e-ed9830c33600/daily_boxplot.out"
    },
    {
      "name": "monthly_graph.out",
      "value": "http://csip.engr.colostate.edu:8082/csip-cfa/q/d6a17e5f-d97f-11e5-988e-ed9830c33600/monthly_graph.out"
    },
    {
      "name": "monthly_boxplot.out",
      "value": "http://csip.engr.colostate.edu:8082/csip-cfa/q/d6a17e5f-d97f-11e5-988e-ed9830c33600/monthly_boxplot.out"
    },
    {
      "name": "yearly_graph.out",
      "value": "http://csip.engr.colostate.edu:8082/csip-cfa/q/d6a17e5f-d97f-11e5-988e-ed9830c33600/yearly_graph.out"
    },
    {
      "name": "yearly_boxplot.out",
      "value": "http://csip.engr.colostate.edu:8082/csip-cfa/q/d6a17e5f-d97f-11e5-988e-ed9830c33600/yearly_boxplot.out"
    },
    {
      "name": "Totalnitrogen.ind",
      "value": "http://csip.engr.colostate.edu:8082/csip-cfa/q/d6a17e5f-d97f-11e5-988e-ed9830c33600/Totalnitrogen.ind"
    },
    {
      "name": "Totalnitrogen.out",
      "value": "http://csip.engr.colostate.edu:8082/csip-cfa/q/d6a17e5f-d97f-11e5-988e-ed9830c33600/Totalnitrogen.out"
    },
    {
      "name": "Totalnitrogen.res",
      "value": "http://csip.engr.colostate.edu:8082/csip-cfa/q/d6a17e5f-d97f-11e5-988e-ed9830c33600/Totalnitrogen.res"
    }
  ]
}
 (none)
 Totalnitrogen.ind; Totalnitrogen.out; Totalnitrogen.res
Details
Comments & Attachments
Associations
Children
SCM Commits
History (8)
Baselines
All (8)

Filter
 
No data to display.