TsTools Software

Intent to Single Source: The Bureau of Reclamation intends to negotiate a sole source contract with Open Water Foundation as a Non-Profit. For the development project will be maintained as an open source project with resulting source code in the public domain or appropriate open source license. Existing open source software and open data standards will be used: - MySQL http://www.mysql.com/ - HydroJSON https://github.com/gunnarleffler/hydroJSON - Pisces https://github.com/usbr/Pisces - WaterML2 (example http://waterservices.usgs.gov/ , and http://www.waterml2.org/ ) - TSTool http://openwaterfoundation.org/owf-for-users/tstool The product will be developed and delivered in incremental design steps approximately 2 month increments beginning when the work is started and ending September 30, 2015. Task 1: Connection between Pisces and TSTool. TSTool will need to query the Pisces database schema to: - Create Java application programming interface (API) package to interface with Pisces MySQL database via ODBC/JDBC queries, with the following functionality: o Support a TSTool "datastore" configuration file for the database connection. o Generate a list of available site/timeseries with metadata such as location, data type, units. o Retrieve daily timeseries data. - Use the API to implement a Pisces database browse capability in the main TSTool window, which is used to list time series for selection and query of individual time series. - Add a TSTool command ReadPisces() (or similar) that will use the API to automate reading one or more Pisces time series based on input, consistent with other TSTool read commands. - Update TSTool WriteWaterML() command to write time series in WaterML2 format. - Add a TSTool WriteHydroJSON() command to write time series in HydroJSON format. The result of this task will be source code, executables, automated tests, and updated TSTool documentation (for command and datastore). The datastore package code will be available for use in other Java applications such as the REST web service application and can be ported to other languages. Task 2: Web service. Using the new TSTool features from task 1, create a REST time series web service application with the following features: - Simple to use, for both web browser (via the published RESTful API) and software developers (via code packages) and perform reasonably fast compared to similar web services. This application may be implemented in one or more of the following configurations (or others determined during design): o Create a REST server application that utilizes the internal TSTool code such as Pisces API, but not the commands. o Create a REST server application that runs TSTool command files similar to the desktop tool (this has the advantage of allowing testing of command files before implementing in the REST server). - Query a list of all sites via web service calls and return site information and all parameters in CSV, HTML, and HydroJSON formats. - Simple queries of timeseries data via web service calls -- simple enough that queries can be bookmarked in a browser or utilized in a program. Output formats: HTML, CSV, HydroJSON, and WaterML2. Reclamation will provide: - Reclamation will provide the Java programming language WaterML2 jar files that are used by the USGS web service. http://waterservices.usgs.gov/ The results of Task 2 will be source code, executables and documentation for the web server application that provides web services. A demonstration/test web page will also be provided to demonstrate the web services and provide access to the Pisces database. Design Ideas: The following design is a supplement intended to express the requirements for RESTful URLs. ? Main Landing Page /beta/daily (provides information about querying the web services) ? Inventory Landing Page /beta/daily/inventory (provides information about querying daily time series) ? Inventory Queries /beta/daily/inventory/uc -- list of UC series data /beta/daily/inventory?basin=uc -- list of UC series data (alternate design) /beta/daily/inventory/gp - list of gp region data /beta/daily/inventory?region=gp -- list of gp region data (alternate design) /beta/daily/inventory/all (provides a full list of all series) /beta/daily/inventory (provides a full list of all series, alternate design) ? Time Series Data Queries /beta/daily/series?sdi=sdi14&t1=2012-10-01&t2=2013-09-30[&format=csv|waterml2|hydrojson] - query data from October 1, 2012 through September 30, 2013 in format specified. /beta/daily/series?sdi=sdi1,sdi24&back=30[?format=csv|waterml2|hydrojson] --- query the last 30 days for the time series data specified by sdi1 and sdi24 (multiple locations) /beta/daily/series/sdi1 -- get all data for the series indicated by sdi1 The statutory authority for other than full and open competition is 10 USC 2304 (c) (1), only one responsible source and no other supplies or services will satisfy agency requirements. THIS IS NOT A REQUEST FOR COMPETITIVE PROPOSALS OR QUOTES. Responsible sources may submit a capability statement in response to this requirement, which shall be considered by the Agency. Capability statements must be received in 3 days after publication of this notice and shall include documentation on the ability to satisfy the Government's requirements. A determination by the Government not to compete based upon responses to this notice is solely within the discretion of the Government. Questions concerning this notice may be directed to Jennifer McCord at jmccord@usbr.gov.