read.flow: Retrieve flow data from Janus

Description Usage Arguments Details Value Author(s)

Description

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

Usage

1
2
read.flow(..., start = NULL, end = NULL, dsn = 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

dsn

Alternate dsn 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 [email protected]


jasonelaw/BESdata documentation built on June 14, 2019, 1:56 a.m.