read.flow | R Documentation |
Submits a query to a table join allowing for queries by Hansen ID and Date
read.flow(
...,
start = NULL,
end = NULL,
server = NULL,
date.field = "reading_datetime"
)
... |
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" |
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.
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
Peter Bryant peter.bryant@portlandoregon.gov
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.