HS004

Properties of Attributes in entity 1 table: Annual sediment basin survey raw data

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	Y	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	ratio	natural	1.-1.	1.	number
SITECODE	Y	N	char(6)	place	nominal
DATE	Y	N	date	range	datetime		Aug 14 1986-Jul 31 2018		date as date type
STATUS	N	N	char(1)	enum	nominal
INSTHT	N	N	numeric(5,3)	range	ratio	real	0.110-2.850	0.010	meters
DISTANCE	Y	N	numeric(3,0)	range	interval	whole	0.-102.	1.	feet
SUBSTRATE01	N	N	char(2)	enum	nominal
RODHT01	N	Y	numeric(4,2)	range	ratio	real	0.11-3.33	0.01	meters
FLAG01	N	N	char(1)	enum	nominal
SUBSTRATE02	N	N	char(2)	enum	nominal
RODHT02	N	Y	numeric(4,2)	range	ratio	real	0.79-4.33	0.01	meters
FLAG02	N	N	char(1)	enum	nominal
SUBSTRATE03	N	N	char(2)	enum	nominal
RODHT03	N	Y	numeric(4,2)	range	ratio	real	0.80-3.93	0.01	meters
FLAG03	N	N	char(1)	enum	nominal
SUBSTRATE04	N	N	char(2)	enum	nominal
RODHT04	N	Y	numeric(4,2)	range	ratio	real	0.68-4.55	0.01	meters
FLAG04	N	N	char(1)	enum	nominal
SUBSTRATE05	N	N	char(2)	enum	nominal
RODHT05	N	Y	numeric(4,2)	range	ratio	real	0.62-4.59	0.01	meters
FLAG05	N	N	char(1)	enum	nominal
SUBSTRATE06	N	N	char(2)	enum	nominal
RODHT06	N	Y	numeric(4,2)	range	ratio	real	0.47-4.57	0.01	meters
FLAG06	N	N	char(1)	enum	nominal
SUBSTRATE07	N	N	char(2)	enum	nominal
RODHT07	N	Y	numeric(4,2)	range	ratio	real	0.10-4.49	0.01	meters
FLAG07	N	N	char(1)	enum	nominal
SUBSTRATE08	N	N	char(2)	enum	nominal
RODHT08	N	Y	numeric(4,2)	range	ratio	real	0.11-4.42	0.01	meters
FLAG08	N	N	char(1)	enum	nominal
SUBSTRATE09	N	N	char(2)	enum	nominal
RODHT09	N	Y	numeric(4,2)	range	ratio	real	0.22-4.41	0.01	meters
FLAG09	N	N	char(1)	enum	nominal
SUBSTRATE10	N	N	char(2)	enum	nominal
RODHT10	N	Y	numeric(4,2)	range	ratio	real	0.01-4.35	0.01	meters
FLAG10	N	N	char(1)	enum	nominal
SUBSTRATE11	N	N	char(2)	enum	nominal
RODHT11	N	Y	numeric(4,2)	range	ratio	real	0.03-4.44	0.01	meters
FLAG11	N	N	char(1)	enum	nominal
SUBSTRATE12	N	N	char(2)	enum	nominal
RODHT12	N	Y	numeric(4,2)	range	ratio	real	0.02-4.77	0.01	meters
FLAG12	N	N	char(1)	enum	nominal
SUBSTRATE13	N	N	char(2)	enum	nominal
RODHT13	N	Y	numeric(4,2)	range	ratio	real	0.03-5.07	0.01	meters
FLAG13	N	N	char(1)	enum	nominal
SUBSTRATE14	N	N	char(2)	enum	nominal
RODHT14	N	Y	numeric(4,2)	range	ratio	real	0.02-5.41	0.01	meters
FLAG14	N	N	char(1)	enum	nominal
SUBSTRATE15	N	N	char(2)	enum	nominal
RODHT15	N	Y	numeric(4,2)	range	ratio	real	0.04-5.61	0.01	meters
FLAG15	N	N	char(1)	enum	nominal
SUBSTRATE16	N	N	char(2)	enum	nominal
RODHT16	N	Y	numeric(4,2)	range	ratio	real	0.50-5.68	0.01	meters
FLAG16	N	N	char(1)	enum	nominal
SUBSTRATE17	N	N	char(2)	enum	nominal
RODHT17	N	Y	numeric(4,2)	range	ratio	real	0.67-5.68	0.01	meters
FLAG17	N	N	char(1)	enum	nominal
SUBSTRATE18	N	N	char(2)	enum	nominal
RODHT18	N	Y	numeric(4,2)	range	ratio	real	0.51-5.63	0.01	meters
FLAG18	N	N	char(1)	enum	nominal
SUBSTRATE19	N	N	char(2)	enum	nominal
RODHT19	N	Y	numeric(4,2)	range	ratio	real	1.90-5.53	0.01	meters
FLAG19	N	N	char(1)	enum	nominal
SUBSTRATE20	N	N	char(2)	enum	nominal
RODHT20	N	Y	numeric(4,2)	range	ratio	real	2.00-5.37	0.01	meters
FLAG20	N	N	char(1)	enum	nominal
SUBSTRATE21	N	N	char(2)	enum	nominal
RODHT21	N	Y	numeric(4,2)	range	ratio	real	2.01-5.12	0.01	meters
FLAG21	N	N	char(1)	enum	nominal
SUBSTRATE22	N	N	char(2)	enum	nominal
RODHT22	N	Y	numeric(4,2)	range	ratio	real	1.94-4.78	0.01	meters
FLAG22	N	N	char(1)	enum	nominal
SUBSTRATE23	N	N	char(2)	enum	nominal
RODHT23	N	Y	numeric(4,2)	range	ratio	real	1.88-4.38	0.01	meters
FLAG23	N	N	char(1)	enum	nominal
SUBSTRATE24	N	N	char(2)	enum	nominal
RODHT24	N	Y	numeric(4,2)	range	ratio	real	1.90-3.93	0.01	meters
FLAG24	N	N	char(1)	enum	nominal
SUBSTRATE25	N	N	char(2)	enum	nominal
RODHT25	N	Y	numeric(4,2)	range	ratio	real	1.31-3.90	0.01	meters
FLAG25	N	N	char(1)	enum	nominal
SUBSTRATE26	N	N	char(2)	enum	nominal
RODHT26	N	Y	numeric(4,2)	range	ratio	real	1.28-4.02	0.01	meters
FLAG26	N	N	char(1)	enum	nominal