Table tblSoils

GLHI Database HTML Dump

Table: tblSoils

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

Table to hold automatically populated SSURGO data for each project area. Table uses standard NRCS naming conventions for field names.

FORM: AUTOMATICALLY POPULATED

Fields

Name	Data type	Default	Description
SoilsID	integer	nextval('"tblSoils_SoilsID_seq"'::regclass)
PROJECT_ID	integer
GeographyID	integer
MUNAME	varchar(256)		Mapunit Name: Correlated name of the mapunit (recommended name or field name for surveys in progress).
MUSYM	varchar(6)		Mapunit Symbol: The symbol used to uniquely identify the soil mapunit in the soil survey.
MUKEY	integer		Mapunit Key: A non-connotative string of characters used to uniquely identify a record in the Mapunit table.
HYDCLPRS	varchar(256)		An indication of the proportion of the map unit, expressed as a class, that is 'hydric', based on the hydric classification of individual mapunit components.

Foreign Keys

Name	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblSoils_fk	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action		Immediate

Checks

There are no check constraints for table tblSoils

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblSoils_pkey	btree		SoilsID

Triggers

There are no triggers for table tblSoils

Rules

There are no rules for table tblSoils

Referenced

There are no tables referenced by table tblSoils

Options

Option	Value
Inherited From
Rows	0
Pages	0
System
Temporary
With OID

Definition


CREATE TABLE "public"."tblSoils" (
  "SoilsID" SERIAL, 
  "PROJECT_ID" INTEGER NOT NULL, 
  "GeographyID" INTEGER NOT NULL, 
  "MUNAME" VARCHAR(256), 
  "MUSYM" VARCHAR(6), 
  "MUKEY" INTEGER, 
  "HYDCLPRS" VARCHAR(256), 
  CONSTRAINT "tblSoils_pkey" PRIMARY KEY("SoilsID"), 
  CONSTRAINT "tblSoils_fk" FOREIGN KEY ("PROJECT_ID")
    REFERENCES "public"."tblProject"("PROJECT_ID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblSoils"
IS 'Table to hold automatically populated SSURGO data for each project area. Table uses standard NRCS naming conventions for field names.

FORM: AUTOMATICALLY POPULATED';

COMMENT ON COLUMN "public"."tblSoils"."MUNAME"
IS 'Mapunit Name: Correlated name of the mapunit (recommended name or field name for surveys in progress).';

COMMENT ON COLUMN "public"."tblSoils"."MUSYM"
IS 'Mapunit Symbol: The symbol used to uniquely identify the soil mapunit in the soil survey.';

COMMENT ON COLUMN "public"."tblSoils"."MUKEY"
IS 'Mapunit Key: A non-connotative string of characters used to uniquely identify a record in the Mapunit table.';

COMMENT ON COLUMN "public"."tblSoils"."HYDCLPRS"
IS 'An indication of the proportion of the map unit, expressed as a class, that is ''hydric'', based on the hydric classification of individual mapunit components.';

Pete Giencke
pgiencke@glc.org