AllocationAmounts_fact - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: AllocationAmounts_fact

Columns

PKNameData TypeNULLAutoDefaultCommentFK

AllocationAmountIDBigInt

Primary key unique identifier for allocation records.
MethodIDBigInt Primary internal key unique identifier for method records.

OrganizationIDBigInt Primary internal key unique identifier for organization records.

VariableSpecificIDBigInt Primary internal key unique identifier for variable records.

AllocationApplicationDateIDBigInt

Foreign key unique identifier to Dates_dim table. Date of the original filing on the water allocation recrod.

AllocationAssociatedConsumptiveUseSiteIDsNVarChar(500)

List of other sites if this water right has one or more associate consumptive use sites. Add the consumptive use UUIDs as comma separated list here.
AllocationAssociatedWithdrawalSiteIDsNVarChar(500)

List of other sites if this water right has one or more associate diversion sites. Add the diversion UUIDs as comma separated list
AllocationBasisCVNVarChar(250)

Description of whether this water right is based on water withdrawals/diversion or consumptive use/depletion amount.

AllocationChangeApplicationIndicatorNVarChar(100)

Indicate if this water right was the result of a change application.
AllocationCommunityWaterSupplySystemNVarChar(250)

If the use is municipal, the data provider can add the SDWIS identifier for the CWS. Only for site specific data. Leave it null for aggregate data
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.
AllocationExpirationDateIDBigInt

Expiration date the water right expires (only really applies if the right is a temporary one).

AllocationFlow_CFSFloat

The state recognized water right water amount in terms of flow (CFS).
AllocationLegalStatusCVNVarChar(250)

The state recognized legal status of the water right (e.g., proven, approved, perfected, adjudicated, etc.)

AllocationNativeIDNVarChar(250)

The state's unique identifier for the water right and it's record.
AllocationOwnerNVarChar(500)

Name of the owner / entity with possesion of the water right.
AllocationPriorityDateIDBigInt

Date given to the water right by the state. Date the water right become legal.

AllocationTimeframeEndNVarChar(5)

End month/day for the water right each year in MM/DD
AllocationTimeframeStartNVarChar(5)

Start month/day for the water right each year in MM/DD
AllocationTypeCVNVarChar(250)

Description of the type of water right (e.g., Underground Water Claim, Federal Reserved Water Right, etc).

AllocationVolume_AFFloat

The state recognized water right water amount in terms of volume (AF).
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 servies (e.g., Residential, Commercial, Industrial, Institutional, Combined, Unspecified, etc).

CommunityWaterSupplySystemVarChar(250)

Name of the community water system the water right serves (if available).
DataPublicationDateIDBigInt Date that this data was published by the data provider to the public.

DataPublicationDOINVarChar(100)

A unique digital object identifier into the original dataset.
ExemptOfVolumeFlowPriorityBoolean Database indicator for special records. if yes (1), then amount flow, volume, and priority dates can be null (e.g., this case represents groundwater rights in Arizona outside the AMA and INA areas).
GeneratedPowerCapacityMWFloat

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

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

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

If this water right was the result of a change application, add the legacy right IDs as a comma separated list here.
OwnerClassificationCVNVarChar(500)

A term that catagorizes the water right owner to a predetermined WaDE defined group. Used for data query and filtering purposes.
PopulationServedFloat

The amount of population servied by the water right (if available).
PowerTypeBigInt

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

The primary benefical used by the water right (if available).

SDWISIdentifierCVBigInt

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

WaterAllcationNativeURLNVarChar(250)

Refers back to the state URL that describes the water right (e.g., https://www.waterrights.utah.gov/asp_apps/wrprint/wrprint.asp?wrnum=55-12888).

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_AllocationAmounts_fact_BeneficialUseCategoryCVs.BeneficialUseCore.AllocationAmounts_factNamePrimaryUseCategoryCV
fk_AllocationAmounts_fact_CustomerTypeCVCVs.CustomerTypeCVCore.AllocationAmounts_factNameCustomerTypeCV
fk_AllocationAmounts_fact_Date_dim_applCore.Date_dimCore.AllocationAmounts_factDateIDAllocationApplicationDateID
fk_AllocationAmounts_fact_Date_dim_expirCore.Date_dimCore.AllocationAmounts_factDateIDAllocationExpirationDateID
fk_AllocationAmounts_fact_Date_dim_priorityCore.Date_dimCore.AllocationAmounts_factDateIDAllocationPriorityDateID
fk_AllocationAmounts_fact_Date_dim_pubCore.Date_dimCore.AllocationAmounts_factDateIDDataPublicationDateID
fk_AllocationAmounts_fact_LegalStatusCVs.LegalStatusCore.AllocationAmounts_factNameAllocationLegalStatusCV
fk_AllocationAmounts_fact_Methods_dimCore.Methods_dimCore.AllocationAmounts_factMethodIDMethodID
fk_AllocationAmounts_fact_Organizations_dimCore.Organizations_dimCore.AllocationAmounts_factOrganizationIDOrganizationID
fk_AllocationAmounts_fact_SDWISIdentifierCVs.SDWISIdentifierCore.AllocationAmounts_factNameSDWISIdentifierCV
fk_AllocationAmounts_fact_Variables_dimCore.Variables_dimCore.AllocationAmounts_factVariableSpecificIDVariableSpecificID
fk_AllocationAmounts_fact_WaterAllocationBasisCVs.WaterAllocationBasisCore.AllocationAmounts_factNameAllocationBasisCV
fk_AllocationAmounts_fact_WaterRightTypeCVs.WaterAllocationTypeCore.AllocationAmounts_factNameAllocationTypeCV

Triggers

(none)


Used in Diagrams

Diagram Name
1_WaterAllocations