To make fisheries data more accessible to scientists, water operators and the public, 34 North is developing web services in collaboration with United States Fish and Wildlife Service for their key monitoring data in the Sacramento San Joaquin Bay-Delta.
The USFWS Web Services for the Delta Juvenile Fish Monitoring Program and Expanded Delta Smelt Monitoring Program provide a simple, reliable REST / CGI interface that accepts parameters as name/value pairs in the REQUEST QUERY STRING. The Web Services then determine the RESPONSE from these parameters and then return either COMMA SEPARATED VALUES or a JSON STRING to the requesting agent.
The parameters roughly describe two types of information:
- Locators – E.g. resource identifiers such as IDs or action/view
- Filters – E.g. parameters that provide a search for, sorting or narrow down the set of results.
There are two base types of requests: Station metadata requests (stationInfo) and Sensor / Timeseries requests (getData). The (getData) request also provides comprehensive summary data through special subtypes of requests that can be described as a reporting tool. These special requests are also described in more detail below.
Requests for Station metadata
The stationInfo service is queried for stations located within a geographic bounding box. The return values contain station identifiers, latitudes, longitudes, sensors/measurement types, ancillary information such as display icons, and various other important items.
stationInfo requests accept the following parameters:
- At least one of these parameters must be present: stationId, stationName, regionCode, subRegionCode, stratumCode or extent
- extent four geographic coordinates specifying a rectangular box
- sensorNum an optional sensor or measurement identifier. Without sensorNum the web service would return all stations for the extent/date range
- startDate optionally filters stations who have data after the given value
- endDate optionally filters stations who have data before the given value
- active optionally filters stations that are active (1) or inactive(0)
- regionCode optionally filters stations by region code
- regionCode can have two different sets of values
When methodType is EDSM
- 10 – Far West
- 20 – North
- 30 – South
- 40 – West
When methodType is NOT EDSM
- 1 – Lower Sacramento River
- 2 – North Delta
- 3 – Central Delta
- 4 – South Delta
- 5 – San Joaquin River
- 6 – Bay
- subRegionCode an optional filtering identifier when methodType is EDSM.
- stratumCode an optional filtering identifier when methodType is EDSM.
- methodType optionally filters stations by method type (KDTR, MWTR, SEIN, EDSM)
About 34 North:
34 North has been a part of the effort to provide a solution for data sharing between entities to keep data as current and near real time as possible to enable adaptive management actions. 34 North has extended the OpenNRM Data Portal platforms to support scientific studies within the Sacramento-San Francisco Bay Delta and provide a lens into each project as well as try to provide connections using computer science. Each platform collects extensive information including databases, images, reports, presentations, and manuscripts focused on specific research questions. Near real time data collected on the platform will inform decisions about the future of this region. Through the timely sharing of data, it will be possible to link and compare data collected in the different studies, avoid duplication of data, allow for near real time data analysis and provide updates outside of the normal quarterly report format.