WaterSources - Table

WaDE2.0 [WaDE2.01.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: WaterSources

WaterSources including the source type (groundwater or surface water) and its quality

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	WaterSourceUUID	BigInt				Foreign key unique identifier to WaterSource_dim table.
	Geometry	Geometry				The GIS objects / shape written in Well-Known Text (WKT) format.
	GNISFeatureNameCV	NVarChar(250)				The most appropriate Geographic Names Information System (GNIS) identifier for the source location.
	WaterQualityIndicatorCV	NVarChar(100)				Description of the water quality (e.g., fresh, saline, mixed quality, etc.).
	WaterSourceName	NVarChar(250)				The water source name as recognized by the data provider.
	WaterSourceNativeID	NVarChar(250)				The water source native ID used by the data provider.
	WaterSourceTypeCV	NVarChar(100)				The high level description of the water source type (e.g., surface water, groundwater, mixed, reuse, etc.)

Indexes

(none)

Foreign Keys

(none)

Triggers

(none)

Used in Diagrams