Watershed Assessment, Tracking & Environmental ResultS

RAD Supplemental Attributes

A small number of RAD Event Programs have supplemental attribute tables providing additional information.

RAD_NDZ_ATTR

Field Name	Data Type	NULL?	Description
st_fips	VARCHAR2(10)	N	FIPS code.
ndz_count	NUMBER(10)	N	Count of No Discharge Zones by state.
state_code	VARCHAR2(20)	N	State abbreviation.
ndz	VARCHAR2(10)	N	No Discharge Zone ID.

RAD_SWA_ATTR

Field Name	Data Type	NULL?	Description
swa_id	VARCHAR2(50)	N	Unique ID for the source water area (defined by state).
state	VARCHAR2(2)	N	Two letter state abbreviation for state that delineated the SWA.
swa_name	VARCHAR2(255)	N	A name for the source water area.
swa_type	VARCHAR2(2)	N	Indicates if the SWA is for a surface or ground water source.
sys_type	VARCHAR2(4)	N	Type of system the source water area was delineated for.
swa_area_type	VARCHAR2(50)	N	Denotes the characteristics of a specific source water area.
meth_code	VARCHAR2(255)	N	National method code to indicate the general type of delineation method used.
meth_det	VARCHAR2(255)	N	Additional details about the delineation method.
aq_type	VARCHAR2(2)	N	Foreign key to external program database.