The CFA Download Tool access the numerous databases that the CFA analyses can auto-extract stream data from. The backbone of the other CFA models is a data extractor linked to USGS's National Water Information System (NWIS), EPA's STORET (WQX), and Colorado Division of Water Resource's (CDWR) databases. Flow and water quality data are auto-extracted from these databases within each of the analyses and this tool returns the original downloaded material from the specified database.
Notes about "wq_test":
- See wq_test parameter description for more details on allowed values
- 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": "06752000"
},
{
"name": "wq_test",
"description": "Water Quality Test. If a USGS station can be 'flow', 'flood flow', '15-min flow', 'all' which retrieves all water quality data, the 5 digit USGS water quality code like '00600' for total nitrogen, or 'stage-discharge' to attempt retriving available rating curve data. If it is a STORET station it can be 'flow', 'flood flow' which retrieves normal flow data for a user to later calculate annual maximums from, or the title of a water quality test in the STORET database like 'nitrogen'. If it is a CDWR station it can be 'flow', 'flood flow' which retrieves normal flow data for a user to later calculate annual maximums from, or 'stage-discharge' to attempt retriving available rating curve data.",
"value": "flow"
},
{
"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": ""
}
]
}
{
"metainfo": {
"status": "Finished",
"suid": "b50473bd-d97f-11e5-988e-2579db4e8652",
"cloud_node": "172.1.6.246",
"tstamp": "2016-02-22 09:17:02",
"service_url": "http://csip.engr.colostate.edu:8082/csip-cfa/m/cfa/download/1.0",
"request_ip": "10.2.228.70",
"cpu_time": 7780,
"expiration_date": "2016-02-22 09:17:40"
},
"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": "06752000"
},
{
"name": "wq_test",
"description": "Water Quality Test. If a USGS station can be 'flow', 'flood flow', '15-min flow', 'all' which retrieves all water quality data, the 5 digit USGS water quality code like '00600' for total nitrogen, or 'stage-discharge' to attempt retriving available rating curve data. If it is a STORET station it can be 'flow', 'flood flow' which retrieves normal flow data for a user to later calculate annual maximums from, or the title of a water quality test in the STORET database like 'nitrogen'. If it is a CDWR station it can be 'flow', 'flood flow' which retrieves normal flow data for a user to later calculate annual maximums from, or 'stage-discharge' to attempt retriving available rating curve data.",
"value": "flow"
},
{
"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": ""
}
],
"result": [
{
"name": "start",
"value": "1881-07-01"
},
{
"name": "end",
"value": "2007-09-30"
},
{
"name": "output_location",
"value": "CFA_dataDownload.txt"
},
{
"name": "CFA_dataDownload.txt",
"value": "http://csip.engr.colostate.edu:8082/csip-cfa/q/b50473bd-d97f-11e5-988e-2579db4e8652/CFA_dataDownload.txt"
}
]
}