VariableAmounts_fact - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: VariableAmounts_fact

Columns

PKNameData TypeNULLAutoDefaultCommentFK

VariableAmountIDBigInt

Primary internal key unique identifier for site amount records.
MethodIDBigInt Primary internal key unique identifier for method records.

OrganizationIDBigInt Primary internal key unique identifier for organization records.

SiteIDBigInt Primary internal key unique identifier for site records.

VariableSpecificIDBigInt Primary internal key unique identifier for variable records.

WaterSourceIDBigInt Primary internal key unique identifier for water source records.
AllocationCropDutyAmountFloat

Crop Duty amount. The number of acres of land that is irrigated for the complete growth of a crop by supplying 1-meter cubes per second of water continuously throughout the crop.
AmountFloat The amount of water at this data site at the time.
AssociatedNativeAllocationIDsNVarChar(500)

Associated unique identifier for the water right at this data site used by the data provider's in the source data.
CommunityWaterSupplySystemNVarChar(250)

Name of the community water system the water right serves (if available).
CropTypeCVNVarChar(100)

The type of crop watered by the water right (if available) (e.g., wheat, alfalfa, corn, hay, etc.) (applies mostly to irrigation uses).

CustomerTypeCVNVarChar(100)

Description of the type of customer the water right services (e.g., Residential, Commercial, Industrial, Institutional, Combined, Unspecified, etc).

DataPublicationDateIDBigInt Unique key identifier for Date that this data was published by the data provider to the public.

DataPublicationDOINVarChar(100)

A unique digital object identifier into the original dataset.
GeometryGeometry

The GIS objects / shape written in Well-Known Text (WKT) format.
IrrigationMethodCVNVarChar(100)

A term to describe the method used for the place of use (if available) (applies mostly to irrigation beneficial uses).

IrrigatedAcreageFloat

Number of acres irrigated by the water right (if available).
PopulationServedFloat

The amount of population served by the water right (if available).
PowerGeneratedGWhFloat

The power (GWh) to be generated by the water right record (if available) (mostly applies to power generating beneficial uses).
PowerTypeNVarChar(50)

Description of the type of power generated.
PrimaryUseCategoryCVNVarChar(250)

The primary stated purpose by the water allocation (if available).

ReportYearCVNVarChar(4)

Year corresponding to the annual reporting period for the aggregated data in the reporting unit.

SDWISIdentifierCVNVarChar(250)

If the use is municipal, the data provider can add the SDWIS identifier for the CWS.

TimeframeEndIDBigInt End date when the water right no longer can legally access the assigned water. Format of MM/DD.

TimeframeStartIDBigInt Start date when the water right can legally access the assigned water. Format of MM/DD.


Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_SiteVariableAmounts_Date_dim_endCore.Date_dimCore.VariableAmounts_factDateIDTimeframeEndID
fk_SiteVariableAmounts_Date_dim_pubCore.Date_dimCore.VariableAmounts_factDateIDDataPublicationDateID
fk_SiteVariableAmounts_Date_dim_startCore.Date_dimCore.VariableAmounts_factDateIDTimeframeStartID
fk_SiteVariableAmounts_fact_BeneficialUseCategoryCVs.BeneficialUseCore.VariableAmounts_factNamePrimaryUseCategoryCV
fk_SiteVariableAmounts_fact_CropTypeCVs.CropTypeCore.VariableAmounts_factNameCropTypeCV
fk_SiteVariableAmounts_fact_CustomerTypeCVCVs.CustomerTypeCVCore.VariableAmounts_factNameCustomerTypeCV
fk_SiteVariableAmounts_fact_IrrigationMethodCVs.IrrigationMethodCore.VariableAmounts_factNameIrrigationMethodCV
fk_SiteVariableAmounts_fact_Methods_dimCore.Methods_dimCore.VariableAmounts_factMethodIDMethodID
fk_SiteVariableAmounts_fact_Organizations_dimCore.Organizations_dimCore.VariableAmounts_factOrganizationIDOrganizationID
fk_SiteVariableAmounts_fact_ReportYearCVCVs.ReportYearCVCore.VariableAmounts_factNameReportYearCV
fk_SiteVariableAmounts_fact_SDWISIdentifierCVs.SDWISIdentifierCore.VariableAmounts_factNameSDWISIdentifierCV
fk_SiteVariableAmounts_fact_Variables_dimCore.Variables_dimCore.VariableAmounts_factVariableSpecificIDVariableSpecificID
fk_VariableAmounts_fact_Sites_dimCore.Sites_dimCore.VariableAmounts_factSiteIDSiteID

Triggers

(none)


Used in Diagrams

Diagram Name
2_SiteSpecificAmounts