read.flow: Retrieve flow data from Janus

In jasonelaw/BESdata: Retrieve BES data from internal databases.

Retrieve flow data from Janus

Description

Submits a query to a table join allowing for queries by Hansen ID and Date

Usage

read.flow(
  ...,
  start = NULL,
  end = NULL,
  server = NULL,
  date.field = "reading_datetime"
)

Arguments

...	query arguments in the form 'field = value'
start	start date of data range
end	end date of data range
server	Alternate server for the JANUS database - for access to production or test instances.
date.field	the field used for the start and end query arguments. The default value is "reading_datetime"

Details

To query by Hansen ID use the field name mv.manhole_hansen_id. To query a specific date range use start and end arguments, otherwise all available data at that location will be returned.

The user running R must have permission to access the view (V_METER_VISIT_LIST_NARROW) and and table (METER_READING) used in the query. The user must have an ODBC Data Source set up for the Janus database on the current computer. The reporting server version of the database is currently BESREPORTS.JANUS.

Value

a data frame of results with the fields:
project_name
location_code
location_description
manhole_hansen_id
reading_datetime
depth_inches
velocity_fps
depth_qualifier
velocity_qualifier
flow_cfs_AxV

Author(s)

Peter Bryant [e-mail]

jasonelaw/BESdata documentation built on Nov. 3, 2023, 9:32 a.m.