UW001

Properties of Attributes in entity 1 table: Monthly stream water chemistry data collected by the Portland Bureau of Environmental Services

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units	Missing Value Code
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	interval	natural	1.-1.		number
SAMPLEID	N	N	char(8)	freetext	ordinal
PROJECT	Y	N	char(2)	enum	nominal
SITECODE	Y	N	char(4)	place	ordinal
DATE_TIME	Y	N	datetime	range	datetime		Jan 7 1998 1:00PM-Aug 30 2010 11:02AM		date as datetime type
ALKALINITY	N	Y	numeric(5,1)	range	interval	real	1.3-102.0		milligrams per liter
ALKCODE	N	N	char(4)	enum	nominal
ARSENIC	N	Y	numeric(6,3)	range	interval	real	0.100-17.330		micrograms per liter
ASCODE	N	N	char(4)	enum	nominal
ASDISS	N	Y	numeric(6,3)	range	interval	real	0.100-13.400		micrograms per liter
ASDICODE	N	N	char(4)	enum	nominal
BOD	N	Y	numeric(2,0)	range	interval	integer	0.-31.		milligrams per liter
BODCODE	N	N	char(4)	enum	nominal
CADMIUM	N	Y	numeric(5,3)	range	interval	real	0.020-0.520		micrograms per liter
CDCODE	N	N	char(4)	enum	nominal
CDDISS	N	Y	numeric(5,3)	range	interval	real	0.010-0.210		micrograms per liter
CDDICODE	N	N	char(4)	enum	nominal
CHLOROPHYLL	N	Y	numeric(5,1)	range	interval	real	0.0-350.0		milligrams per cubic meter
CHLOROCODE	N	N	char(4)	enum	nominal
CHROMIUM	N	Y	numeric(5,2)	range	interval	real	0.20-18.50		micrograms per liter
CRCODE	N	N	char(4)	enum	nominal
CHROMDISS	N	Y	numeric(5,2)	range	interval	real	0.20-13.80		micrograms per liter
CRDICODE	N	N	char(4)	enum	nominal
CONDUCSPE	N	Y	numeric(6,1)	range	interval	real	0.0-1017.0		micro siemens per centimeter
CONDUCCODE	N	N	char(4)	enum	nominal
COPPER	N	Y	numeric(6,3)	range	interval	real	0.100-82.660		micrograms per liter
CUCODE	N	N	char(4)	enum	nominal
COPPERDISS	N	Y	numeric(6,3)	range	interval	real	0.062-19.600		micrograms per liter
CUDICODE	N	N	char(4)	enum	nominal
DEPTH	N	Y	numeric(5,2)	range	interval	real	0.20-50.00		inches
DEPTHCODE	N	N	char(4)	enum	nominal
DO	N	Y	numeric(4,1)	range	interval	real	0.0-121.0		milligrams per liter
DOCODE	N	N	char(4)	enum	nominal
ECOLI	N	Y	numeric(5,0)	range	interval	integer	0.-87000.		cfu/100ml
ECOLICODE	N	N	char(4)	enum	nominal
FECALCOLIFO	N	Y	numeric(5,0)	range	interval	integer	0.-16000.		cfu/100ml
FECALCODE	N	N	char(4)	enum	nominal
HARDNESS	N	Y	numeric(5,1)	range	interval	real	1.0-161.0		milligrams per liter
HARDCODE	N	N	char(4)	enum	nominal
HARDTOTAL	N	Y	numeric(5,1)	range	interval	real	1.0-210.0		milligrams per liter
HARDTOTCODE	N	N	char(4)	enum	nominal
IRON	N	Y	numeric(8,3)	range	interval	real	0.299-5300.000		milligrams per liter
IRONCODE	N	N	char(4)	enum	nominal
IRONDISS	N	Y	numeric(7,3)	range	interval	real	0.011-911.000		milligrams per liter
IRONDICODE	N	N	char(4)	enum	nominal
LEAD	N	Y	numeric(6,3)	range	interval	real	0.000-34.110		micrograms per liter
LEADCODE	N	N	char(4)	enum	nominal
LEADDISS	N	Y	numeric(5,3)	range	interval	real	0.000-1.900		micrograms per liter
LEADDICODE	N	N	char(4)	enum	nominal
MANGA	N	Y	numeric(5,1)	range	interval	real	80.2-184.0		micrograms per liter
MANGACODE	N	N	char(4)	enum	nominal
MANGADISS	N	Y	numeric(5,1)	range	interval	real	0.1-158.0		micrograms per liter
MANGADICODE	N	N	char(4)	enum	nominal
MERCURY	N	Y	numeric(6,4)	range	interval	real	0.0016-0.0400		micrograms per liter
MERCURYCODE	N	N	char(4)	enum	nominal
MERCURYDISS	N	Y	numeric(6,4)	range	interval	real	0.0010-0.0024		micrograms per liter
MERCDICODE	N	N	char(4)	enum	nominal
MOLYBDENUM	N	Y	numeric(5,3)	range	interval	real	0.083-0.894		micrograms per liter
MOLYCODE	N	N	char(4)	enum	nominal
MOLYDISS	N	Y	numeric(5,3)	range	interval	real	0.071-0.854		micrograms per liter
MOLYDICODE	N	N	char(4)	enum	nominal
NICKEL	N	Y	numeric(4,2)	range	interval	real	0.12-9.32		micrograms per liter
NICODE	N	N	char(4)	enum	nominal
NICKELDISS	N	Y	numeric(4,2)	range	interval	real	0.20-2.33		micrograms per liter
NIDICODE	N	N	char(4)	enum	nominal
NKJELDAHL	N	Y	numeric(5,2)	range	interval	real	0.19-10.90		milligrams per liter
NKCODE	N	N	char(4)	enum	nominal
NAMMONIA	N	Y	numeric(5,3)	range	interval	real	0.013-5.910		milligrams per liter
NAMMCODE	N	N	char(4)	enum	nominal
NNITRATE	N	Y	numeric(5,3)	range	interval	real	0.100-7.700		milligrams per liter
NNITRATECODE	N	N	char(4)	enum	nominal
NNITRITE	N	Y	numeric(5,3)	range	interval	real	0.010-0.160		milligrams per liter
NNITRITECODE	N	N	char(4)	enum	nominal
OILGREASENONPOLAR	N	Y	numeric(4,1)	range	interval	real	5.0-33.4		milligrams per liter
OILNONCODE	N	N	char(4)	enum	nominal
OILGREASETOTAL	N	Y	numeric(4,1)	range	interval	real	5.0-75.4		milligrams per liter
OILTOTCODE	N	N	char(4)	enum	nominal
PH	N	Y	numeric(4,1)	range	interval	real	0.0-10.0		pH units
PHCODE	N	N	char(4)	enum	nominal
PHOSPHORUS	N	Y	numeric(5,3)	range	interval	real	0.013-2.980		milligrams per liter
PHOSCODE	N	N	char(4)	enum	nominal
PHOSDISS	N	Y	numeric(5,3)	range	interval	real	0.011-0.530		milligrams per liter
PHOSDICODE	N	N	char(4)	enum	nominal
SECCHI	N	Y	numeric(3,1)	range	interval	real	0.0-4.2		meters
SECCHICODE	N	N	char(4)	enum	nominal
SELENIUM	N	Y	numeric(4,2)	range	interval	real	0.50-1.00		micrograms per liter
SELENCODE	N	N	char(4)	enum	nominal
SELENDISS	N	Y	numeric(4,2)	range	interval	real	0.50-1.00		micrograms per liter
SELENDICODE	N	N	char(4)	enum	nominal
SILVER	N	Y	numeric(4,2)	range	interval	real	0.02-0.18		micrograms per liter
SILVERCODE	N	N	char(4)	enum	nominal
SILVERDISS	N	Y	numeric(4,2)	range	interval	real	0.01-0.10		micrograms per liter
SILVERDICODE	N	N	char(4)	enum	nominal
SOLIDSDISS	N	Y	numeric(5,1)	range	interval	real	0.0-929.0		milligrams per liter
SOLIDSDICODE	N	N	char(4)	enum	nominal
SOLIDSDISS180C	N	Y	numeric(5,1)	range	interval	real	34.0-247.0		milligrams per liter
SOLIDSDI180CODE	N	N	char(4)	enum	nominal
SOLIDSSUS	N	Y	numeric(6,1)	range	interval	real	0.0-1920.0		milligrams per liter
SOLIDSSUSCODE	N	N	char(4)	enum	nominal
SOLIDSTOTAL	N	Y	numeric(6,1)	range	interval	real	0.0-2540.0		milligrams per liter
SOLIDSTOTCODE	N	N	char(4)	enum	nominal
TEMP	N	Y	numeric(4,1)	range	interval	real	0.0-26.1		degrees Celsius
TEMPCODE	N	N	char(4)	enum	nominal
TURBIDITY	N	Y	numeric(5,1)	range	interval	real	0.1-120.0		nephelometric turbidity unit
TURBCODE	N	N	char(4)	enum	nominal
VELOCITY	N	Y	numeric(4,2)	range	interval	real	0.00-9.30		feet per second
VELCODE	N	N	char(4)	enum	nominal
ZINC	N	Y	numeric(6,2)	range	interval	real	0.00-247.00		micrograms per liter
ZNCODE	N	N	char(4)	enum	nominal
ZINCDISS	N	Y	numeric(5,2)	range	interval	real	0.00-60.90		micrograms per liter
ZNDICODE	N	N	char(4)	enum	nominal
FIELDNOTES	N	Y	varchar(100)	enum	nominal
LABNOTES	N	Y	varchar(100)	enum	nominal