sdwis_water_system: Retrieve water system data from sdwis database

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

Description

Retrieve water system data from sdwis database

Usage

sdwis_water_system(PWSID = NULL, PWS_NAME = NULL,
  NPM_CANDIDATE = NULL, PRIMACY_AGENCY_CODE = NULL,
  EPA_REGION = NULL, SEASON_BEGIN_DATE = NULL,
  SEASON_END_DATE = NULL, PWS_ACTIVITY_CODE = NULL,
  PWS_DEACTIVATION_DATE = NULL, PWS_TYPE_CODE = NULL,
  DBPR_SCHEDULE_CAT_CODE = NULL, CDS_ID = NULL, GW_SW_CODE = NULL,
  LT2_SCHEDULE_CAT_CODE = NULL, OWNER_TYPE_CODE = NULL,
  POPULATION_SERVED_COUNT = NULL, POP_CAT_2_CODE = NULL,
  POP_CAT_3_CODE = NULL, POP_CAT_4_CODE = NULL,
  POP_CAT_5_CODE = NULL, POP_CAT_11_CODE = NULL, PRIMACY_TYPE = NULL,
  PRIMARY_SOURCE_CODE = NULL, IS_GRANT_ELIGIBLE_IND = NULL,
  IS_WHOLESALER_IND = NULL, IS_SCHOOL_OR_DAYCARE_IND = NULL,
  SERVICE_CONNECTIONS_COUNT = NULL, SUBMISSION_STATUS_CODE = NULL,
  ORG_NAME = NULL, ADMIN_NAME = NULL, EMAIL_ADDR = NULL,
  PHONE_NUMBER = NULL, PHONE_EXT_NUMBER = NULL, FAX_NUMBER = NULL,
  ALT_PHONE_NUMBER = NULL, ADDRESS_LINE1 = NULL,
  ADDRESS_LINE2 = NULL, CITY_NAME = NULL, ZIP_CODE = NULL,
  COUNTRY_CODE = NULL, STATE_CODE = NULL,
  SOURCE_WATER_PROTECTION_CODE = NULL,
  SOURCE_PROTECTION_BEGIN_DATE = NULL, OUTSTANDING_PERFORMER = NULL,
  OUTSTANDING_PERFORM_BEGIN_DATE = NULL, CITIES_SERVED = NULL,
  COUNTIES_SERVED = NULL)

Arguments

PWSID	e.g. '010106001'. See Details.
PWS_NAME	e.g. 'Mashantucket Pequot Water System'. See Details.
NPM_CANDIDATE	e.g. 'Y'. See Details.
PRIMACY_AGENCY_CODE	e.g. '01'. See Details.
EPA_REGION	e.g. '01'. See Details.
SEASON_BEGIN_DATE	e.g. 'NA'. See Details.
SEASON_END_DATE	e.g. 'NA'. See Details.
PWS_ACTIVITY_CODE	e.g. 'A'. See Details.
PWS_DEACTIVATION_DATE	e.g. 'NA'. See Details.
PWS_TYPE_CODE	e.g. 'CWS'. See Details.
DBPR_SCHEDULE_CAT_CODE	e.g. 'NA'. See Details.
CDS_ID	e.g. 'NA'. See Details.
GW_SW_CODE	e.g. 'SW'. See Details.
LT2_SCHEDULE_CAT_CODE	e.g. 'NA'. See Details.
OWNER_TYPE_CODE	e.g. 'N'. See Details.
POPULATION_SERVED_COUNT	e.g. '39552'. See Details.
POP_CAT_2_CODE	e.g. '2'. See Details.
POP_CAT_3_CODE	e.g. '2'. See Details.
POP_CAT_4_CODE	e.g. '2'. See Details.
POP_CAT_5_CODE	e.g. '4'. See Details.
POP_CAT_11_CODE	e.g. '6'. See Details.
PRIMACY_TYPE	e.g. 'Tribal'. See Details.
PRIMARY_SOURCE_CODE	e.g. 'GU'. See Details.
IS_GRANT_ELIGIBLE_IND	e.g. 'Y'. See Details.
IS_WHOLESALER_IND	e.g. 'Y'. See Details.
IS_SCHOOL_OR_DAYCARE_IND	e.g. 'N'. See Details.
SERVICE_CONNECTIONS_COUNT	e.g. '143'. See Details.
SUBMISSION_STATUS_CODE	e.g. 'Y'. See Details.
ORG_NAME	e.g. 'Mashantucket Pequot Tribal Utilities'. See Details.
ADMIN_NAME	e.g. 'Rodney Butler'. See Details.
EMAIL_ADDR	e.g. 'NA'. See Details.
PHONE_NUMBER	e.g. '8603966740'. See Details.
PHONE_EXT_NUMBER	e.g. 'NA'. See Details.
FAX_NUMBER	e.g. 'NA'. See Details.
ALT_PHONE_NUMBER	e.g. 'NA'. See Details.
ADDRESS_LINE1	e.g. 'Tribal Office'. See Details.
ADDRESS_LINE2	e.g. 'Indiantown Rd, - PO BOX 3060'. See Details.
CITY_NAME	e.g. 'MASHANTUCKET'. See Details.
ZIP_CODE	e.g. '06339-3060'. See Details.
COUNTRY_CODE	e.g. 'US'. See Details.
STATE_CODE	e.g. 'CT'. See Details.
SOURCE_WATER_PROTECTION_CODE	e.g. 'NA'. See Details.
SOURCE_PROTECTION_BEGIN_DATE	e.g. 'NA'. See Details.
OUTSTANDING_PERFORMER	e.g. 'NA'. See Details.
OUTSTANDING_PERFORM_BEGIN_DATE	e.g. 'NA'. See Details.
CITIES_SERVED	e.g. 'Not Reported'. See Details.
COUNTIES_SERVED	e.g. 'Not Reported'. See Details.

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