dataUpload: dataUpload formats files for upload into QWData

Description Usage Arguments

View source: R/dataUpload.R

Description

Assists in formatting data for upload into QWData. Use templateExport to generate spreadsheet templates to create labfile and pcode file.

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
dataUpload(qwsampletype, labfile, pcodefile, DSN = "NWISCO",
  env.db = "01", qa.db = "02", writeFiles = FALSE,
  qwresultname = "qwresult", qwsamplename = "qwsample",
  qwsamplefile = "", qwsample.begin.date = NA,
  qwsample.end.date = NA, censor = FALSE, agencycode = "USGS",
  labid = NA, projectcode = NA, aquifercode = NA,
  analysisstatus = NA, analysissource = NA, hydrologiccond = "A",
  hydrologicevent = 9, tissue = NA, bodypart = NA, labcomment = NA,
  fieldcomment = NA, timedatum = NA, datumreliability = NA,
  colagencycode = "USGS")

Arguments

qwsampletype

Numeric of type of qwsample file. Options 1: Pull qwsample form NWIS, 2:QWSample from file, 3: batch qwsample file

labfile

Character string containing path to the labfile, must be .csv format

pcodefile

Character string containing path to the pcodefile, must be .csv format

DSN

Character string containing local NWIS server name

env.db

Environmental database number

qa.db

QA database number

writeFiles

write out qwresult and qwsample files to text files in working directory

qwresultname

Name of qwresult file

qwsamplename

Name of qwsample file

qwsamplefile

Character string containing path to the qwsample file if using qwsampletype = 2, must be .csv format

qwsample.begin.date

Character string (yyyy-mm-dd) of beggining date to subset qwsample file to

qwsample.end.date

Character string (yyyy-mm-dd) of ending date to subset qwsample file to

censor

Logical. If TRUE results are censored to lrl provided in pcode file

agencycode

Manual qwsample entry

labid

Manual qwsample entry

projectcode

Manual qwsample entry

aquifercode

Manual qwsample entry

analysisstatus

Manual qwsample entry

analysissource

Manual qwsample entry

hydrologiccond

Manual qwsample entry

hydrologicevent

Manual qwsample entry

tissue

Manual qwsample entry

bodypart

Manual qwsample entry

labcomment

Manual qwsample entry

fieldcomment

Manual qwsample entry

timedatum

Manual qwsample entry

datumreliability

Manual qwsample entry

colagencycode

Manual qwsample entry


USGS-R/WQ-Review documentation built on Nov. 12, 2019, 9:51 a.m.