WaDE Tables
HomeTablesSchemasDiagramsForeign KeysIndexes

Tables

Table NameCommentSchema
DATA_SOURCES Metadata
DETAIL_ALLOCATIONDetailed, site specific information on water allocations, diversions, use, and return flows.DataValues
DETAIL_DIVERSIONDescription of the location for the diverted water.DataValues
DETAIL_RETURN_FLOWThe amount and location of water returnedDataValues
DETAIL_USEInformation about the use of the waterDataValues
D_ALLOCATION_ACTUALThe actual amount of water diverted at this diversion for the reporting period.DataValues
D_ALLOCATION_FLOWDefines the amount of water attributed to the entire allocation. If an allocation has diversions associated with it, then report this information for each diversion.DataValues
D_ALLOCATION_LOCATIONThe Location of the detailed allocation, diversion, use, or return flow.DataValues
D_ALLOCATION_USEBeneficial use for which the water is used.DataValues
D_COMMUNITY_WATER_SUPPLYAdditional Metadata for community water supply uses.DataValues
D_CONSUMPTIVE_USEEstimate of water useDataValues
D_DIVERSION_ACTUALThe actual amount of water diverted at this diversion for the reporting period.DataValues
D_DIVERSION_FLOWDefines the amount of water attributed to the entire allocation. If an allocation has diversions associated with it, then report this information for each diversion.DataValues
D_DIVERSION_USEBeneficial use for which the water is used.DataValues
D_IRRIGATIONAdditional Metadata for irrigation water supply usesDataValues
D_RETURN_FLOW_ACTUALWeb Feature Service feature reference for the return flowDataValues
D_THERMOELECTRICAdditional Metadata for thermoelectric water supply uses.DataValues
D_USE_AMOUNTThe actual volume of water diverted at this diversion for the reporting period.DataValues
D_USE_LOCATIONThe location of the detailed allocation, diversion, use, or return flowDataValues
GEOSPATIAL_REFHeader for the Geospatial Information related to the report.Metadata
LU_BENEFICIAL_USE Lookups
LU_CROP_TYPE Lookups
LU_FRESH_SALINE_INDICATOR Lookups
LU_GENERATOR_TYPE Lookups
LU_IRRIGATION_METHOD Lookups
LU_LEGAL_STATUS Lookups
LU_REGULATORY_STATUS Lookups
LU_SOURCE_TYPE Lookups
LU_STATE Lookups
LU_UNITS Lookups
LU_VALUE_TYPE Lookups
LU_WATER_SUPPLY_TYPE Lookups
METHODS Metadata
METRICS Metadata
ORGANIZATIONOrganization responsible for the data reported.Metadata
REPORTHeader for the water summary or water detail report.Metadata
REPORTING_UNITThe Unit for which the Allocation or Estimate is being reportedDataValues
SUMMARY_ALLOCATIONAnnual summary of water allocations within the reporting unit.DataValues
SUMMARY_AVAILABILITYSummary of water availability within the reporting unit.DataValues
SUMMARY_REGULATORYSummary of regulatory status for the reporting unit.DataValues
SUMMARY_USEAnnual summary of water use within the reporting unitDataValues
SUMMARY_WATER_SUPPLYSummary of derived water supply within the reporting unit for the reporting year.DataValues
S_ALLOCATION_IRRIGATIONAdditional Metadata for irrigation water supply usesDataValues
S_AVAILABILITY_AMOUNTEstimate of the water availability for the given time frame as either a volume amount or a relative metric.DataValues
S_AVAILABILITY_METRICMetric measuring relative availability of water within this reporting unit.DataValues
S_USE_AMOUNTAmount of water usedDataValues
S_USE_IRRIGATIONAdditional Metadata for irrigation water supply usesDataValues
S_WATER_SUPPLY_AMOUNTWater supply summaries for the specified time frameDataValues