pcs.icis_pcs_permit_facility: Retrieve pcs permit facility data from pcs-icis database

Description Usage Arguments

Description

Retrieve pcs permit facility data from pcs-icis database

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
pcs.icis_pcs_permit_facility(NPDES = NULL, NAME_1 = NULL,
  NAME_2 = NULL, MAJOR_DISCHARGE_INDICATOR = NULL, REGION = NULL,
  CITY_CODE = NULL, CITY_NAME = NULL, COUNTY_CODE = NULL,
  COUNTY_NAME = NULL, SIC_CODE = NULL, LOCATION_NAME = NULL,
  LOCATION_STREET_1 = NULL, LOCATION_STREET_2 = NULL,
  LOCATION_CITY = NULL, LOCATION_STATE = NULL,
  LOCATION_ZIP_CODE = NULL, LOCATION_TELEPHONE_NUMBER = NULL,
  MAILING_NAME = NULL, MAILING_STREET_1 = NULL,
  MAILING_STREET_2 = NULL, MAILING_CITY = NULL, MAILING_STATE = NULL,
  MAILING_ZIP_CODE = NULL, INACTIVE_CODE = NULL,
  PERMIT_EXPIRED_DATE = NULL, PERMIT_ISSUED_DATE = NULL,
  DRAFT_PERM_PUB_NOTIF_DATE = NULL, APPL_RECEIVED_DATE = NULL,
  INACTIVE_DATE = NULL, TYPE_OF_OWNERSHIP = NULL,
  COGN_OFFICIAL = NULL, COGN_OFFICIAL_TELE_NUMBER = NULL,
  INDUSTRY_CLASS = NULL, ORIGINL_PERMIT_ISSUE_DATE = NULL,
  TYPE_OF_PERMIT_ISSUED = NULL, RIVER_BASIN = NULL,
  RECEIVING_WATERS = NULL, CURR_YEAR_MANL_QNCR_STAT = NULL,
  CURR_YEAR_AUTO_QNCR_STAT = NULL, PREV_YEAR_MANL_QNCR_STAT = NULL,
  PREV_YEAR_AUTO_QNCR_STAT = NULL, FEDERAL_GRANT_IND = NULL,
  FINAL_LIMITS_IND = NULL, FLOW_RATE = NULL,
  PRETREATMENT_CODE = NULL, NMP_FINAN_STAT_CODE = NULL,
  NMP_FINAL_SCHED = NULL, NMP_QUARTER = NULL, LATITUDE = NULL,
  LONGITUDE = NULL, CODE_OF_ACCURACY = NULL, METHOD = NULL,
  DATUM = NULL, SCALE = NULL, DESCRIPT = NULL,
  USGS_HYDRO_BASIN_CODE = NULL, STREAM_SEGMENT = NULL,
  MILEAGE_IND = NULL, RECVNG_STREAM_CLASS_CODE = NULL)

Arguments

NPDES

e.g. 'AK0000272'. See Details.

NAME_1

e.g. 'ALYESKA SEAFOODS INC'. See Details.

NAME_2

e.g. 'S: UNALASKA (FISH MEAL/SURIMI)'. See Details.

MAJOR_DISCHARGE_INDICATOR

e.g. 'M'. See Details.

REGION

e.g. '10'. See Details.

CITY_CODE

e.g. '92820'. See Details.

CITY_NAME

e.g. 'UNALASKA'. See Details.

COUNTY_CODE

e.g. '010'. See Details.

COUNTY_NAME

e.g. 'ALEUTIAN ISLANDS DI'. See Details.

SIC_CODE

e.g. '2091'. See Details.

LOCATION_NAME

e.g. 'ALYESKA SEAFOODS INC'. See Details.

LOCATION_STREET_1

e.g. 'S: UNALASKA (FISH MEAL/SURIMI)'. See Details.

LOCATION_STREET_2

e.g. '551 WEST BROADWAY AVE'. See Details.

LOCATION_CITY

e.g. 'UNALASKA'. See Details.

LOCATION_STATE

e.g. 'AK'. See Details.

LOCATION_ZIP_CODE

e.g. '99685'. See Details.

LOCATION_TELEPHONE_NUMBER

e.g. '9075811211'. See Details.

MAILING_NAME

e.g. 'ALYESKA SEAFOODS INC'. See Details.

MAILING_STREET_1

e.g. 'P.O. BOX 31359'. See Details.

MAILING_STREET_2

e.g. 'NA'. See Details.

MAILING_CITY

e.g. 'SEATTLE'. See Details.

MAILING_STATE

e.g. 'WA'. See Details.

MAILING_ZIP_CODE

e.g. '98103'. See Details.

INACTIVE_CODE

e.g. 'A'. See Details.

PERMIT_EXPIRED_DATE

e.g. '31-MAR-08'. See Details.

PERMIT_ISSUED_DATE

e.g. '05-FEB-03'. See Details.

DRAFT_PERM_PUB_NOTIF_DATE

e.g. '21-SEP-01'. See Details.

APPL_RECEIVED_DATE

e.g. '27-NOV-00'. See Details.

INACTIVE_DATE

e.g. 'NA'. See Details.

TYPE_OF_OWNERSHIP

e.g. 'PRI'. See Details.

COGN_OFFICIAL

e.g. 'WINN BRINDLE, GENERAL MANAGER'. See Details.

COGN_OFFICIAL_TELE_NUMBER

e.g. '2065472100'. See Details.

INDUSTRY_CLASS

e.g. 'R'. See Details.

ORIGINL_PERMIT_ISSUE_DATE

e.g. '14-APR-75'. See Details.

TYPE_OF_PERMIT_ISSUED

e.g. 'E'. See Details.

RIVER_BASIN

e.g. '160600'. See Details.

RECEIVING_WATERS

e.g. 'UNALASKA BAY, ILIULIUK HARBOR'. See Details.

CURR_YEAR_MANL_QNCR_STAT

e.g. 'NA'. See Details.

CURR_YEAR_AUTO_QNCR_STAT

e.g. 'NA'. See Details.

PREV_YEAR_MANL_QNCR_STAT

e.g. 'NA'. See Details.

PREV_YEAR_AUTO_QNCR_STAT

e.g. 'NA'. See Details.

FEDERAL_GRANT_IND

e.g. 'NA'. See Details.

FINAL_LIMITS_IND

e.g. 'F'. See Details.

FLOW_RATE

e.g. 'NA'. See Details.

PRETREATMENT_CODE

e.g. 'NA'. See Details.

NMP_FINAN_STAT_CODE

e.g. 'NA'. See Details.

NMP_FINAL_SCHED

e.g. 'NA'. See Details.

NMP_QUARTER

e.g. 'NA'. See Details.

LATITUDE

e.g. '+5352440'. See Details.

LONGITUDE

e.g. '-16632250'. See Details.

CODE_OF_ACCURACY

e.g. 'NA'. See Details.

METHOD

e.g. 'A'. See Details.

DATUM

e.g. '1'. See Details.

SCALE

e.g. 'U'. See Details.

DESCRIPT

e.g. '01099'. See Details.

USGS_HYDRO_BASIN_CODE

e.g. 'NA'. See Details.

STREAM_SEGMENT

e.g. 'NA'. See Details.

MILEAGE_IND

e.g. 'NA'. See Details.

RECVNG_STREAM_CLASS_CODE

e.g. 'NA'. See Details.


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