sdwis_violation: Retrieve violation data from sdwis database

In markwh/envirofacts: Access EPA Data via the Envirofacts Web Services

Description

Retrieve violation data from sdwis database

Usage

sdwis_violation(PWSID = NULL, VIOLATION_ID = NULL,
  FACILITY_ID = NULL, POPULATION_SERVED_COUNT = NULL,
  NPM_CANDIDATE = NULL, PWS_ACTIVITY_CODE = NULL,
  PWS_DEACTIVATION_DATE = NULL, PRIMARY_SOURCE_CODE = NULL,
  POP_CAT_5_CODE = NULL, PRIMACY_AGENCY_CODE = NULL,
  EPA_REGION = NULL, PWS_TYPE_CODE = NULL, VIOLATION_CODE = NULL,
  VIOLATION_CATEGORY_CODE = NULL, IS_HEALTH_BASED_IND = NULL,
  CONTAMINANT_CODE = NULL, COMPLIANCE_STATUS_CODE = NULL,
  VIOL_MEASURE = NULL, UNIT_OF_MEASURE = NULL, STATE_MCL = NULL,
  IS_MAJOR_VIOL_IND = NULL, SEVERITY_IND_CNT = NULL,
  COMPL_PER_BEGIN_DATE = NULL, COMPL_PER_END_DATE = NULL,
  LATEST_ENFORCEMENT_ID = NULL, RTC_ENFORCEMENT_ID = NULL,
  RTC_DATE = NULL, PUBLIC_NOTIFICATION_TIER = NULL,
  ORIGINATOR_CODE = NULL, SAMPLE_RESULT_ID = NULL,
  CORRECTIVE_ACTION_ID = NULL, RULE_CODE = NULL,
  RULE_GROUP_CODE = NULL, RULE_FAMILY_CODE = NULL)

Arguments

PWSID	e.g. '010109005'. See Details.
VIOLATION_ID	e.g. '010900526310042011'. See Details.
FACILITY_ID	e.g. '3'. See Details.
POPULATION_SERVED_COUNT	e.g. '37860'. See Details.
NPM_CANDIDATE	e.g. 'N'. See Details.
PWS_ACTIVITY_CODE	e.g. 'A'. See Details.
PWS_DEACTIVATION_DATE	e.g. 'NA'. See Details.
PRIMARY_SOURCE_CODE	e.g. 'SWP'. See Details.
POP_CAT_5_CODE	e.g. '4'. See Details.
PRIMACY_AGENCY_CODE	e.g. '01'. See Details.
EPA_REGION	e.g. '01'. See Details.
PWS_TYPE_CODE	e.g. 'CWS'. See Details.
VIOLATION_CODE	e.g. '26'. See Details.
VIOLATION_CATEGORY_CODE	e.g. 'MR'. See Details.
IS_HEALTH_BASED_IND	e.g. 'N'. See Details.
CONTAMINANT_CODE	e.g. '3100'. See Details.
COMPLIANCE_STATUS_CODE	e.g. 'R'. See Details.
VIOL_MEASURE	e.g. 'NA'. See Details.
UNIT_OF_MEASURE	e.g. 'NA'. See Details.
STATE_MCL	e.g. 'NA'. See Details.
IS_MAJOR_VIOL_IND	e.g. 'NA'. See Details.
SEVERITY_IND_CNT	e.g. 'NA'. See Details.
COMPL_PER_BEGIN_DATE	e.g. '01-APR-11'. See Details.
COMPL_PER_END_DATE	e.g. '30-APR-11'. See Details.
LATEST_ENFORCEMENT_ID	e.g. '0109005IF2/16/2012'. See Details.
RTC_ENFORCEMENT_ID	e.g. '0109005OX2/16/2012'. See Details.
RTC_DATE	e.g. '16-FEB-12'. See Details.
PUBLIC_NOTIFICATION_TIER	e.g. '3'. See Details.
ORIGINATOR_CODE	e.g. 'R'. See Details.
SAMPLE_RESULT_ID	e.g. 'NA'. See Details.
CORRECTIVE_ACTION_ID	e.g. 'NA'. See Details.
RULE_CODE	e.g. '110'. See Details.
RULE_GROUP_CODE	e.g. '100'. See Details.
RULE_FAMILY_CODE	e.g. '110'. See Details.

markwh/envirofacts documentation built on May 21, 2019, 12:26 p.m.