34 North Develops Web Services for USFWS Fisheries Data for Water Operations and Science

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:

  1. Locators – E.g. resource identifiers such as IDs or action/view
  2. 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.

USFWS DJFMP and EDSM Web Service Documentation

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
    • stationId
    • stationName
    • regionCode
  • sensorNum an optional sensor or measurement identifier. Without sensorNum the web service would return all stations for the extent/date range
    • conductivity
    • do
    • secchi
    • turbidity
    • watertemp
  • 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)

USFWS DJFMP and EDSM Web Service Documentation

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.