Name: Excess_Groundwater_Major_GRID

Display Field: AQ_Name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Intermediate Grid- Score and Parameter Data for Excess Groundwater by grid cell. Many to one record per cell for major aquifers coincident with each other.Source TWDB Draft 2022 State Water Plan database (DB22)Description of FieldsRCIDRow- Column Identifier (grid cell)CTY_BS_AQCounty- Basin- Aquifer concatenated unique identifier. For major aquifers only.RCID_NEW_CTY_BS_AQGrid cell added to County- Basin- Aquifer concatenated unique identifier. For major aquifers only.ClassMajor or Minor Aquifer designationSource_IDUnique ID assigned to each RCID_New_Cty_Bs_Aq combination. SourceID_RCIDSource ID and RCID concatenated AQ_NameAquifer Name from DB22 (major aquifers)Source_RegionRegion showing GW sourceSource_NameFull name of Aquifer (from DB22)GW_IDAquifer ID (from DB22)ASRCodeAlphaUnique Aquifer Code, consistent with four digit aquifer code in Hydrogeological Parameter Screening Tool (Task 2) StatusMAG or Non-MAG (i.e. identified by the RWPG)Source_DetailDetails on Source (from DB22)Source_CountyCounty with Source of Excess GW (DB22)Source_BasinRiver Basin where Excess GW is located (DB22)SalinityFresh, Brackish, Saline identifier used to score WQ (DB22)WB_2020_dividedVolume of Surplus Modeled Available Groundwater (Year 2020) from DB22 for each major and minor aquifer (multiple often per grid cell), divided and assigned equally amongst respective cells located in County- River BasinWB_2030_dividedVolume of Surplus Modeled Available Groundwater (Year 2030) from DB22 for each major and minor aquifer (multiple often per grid cell), divided and assigned equally amongst respective cells located in County- River BasinWB_2040_dividedVolume of Surplus Modeled Available Groundwater (Year 2040) from DB22 for each major and minor aquifer (multiple often per grid cell), divided and assigned equally amongst respective cells located in County- River BasinWB_2050_dividedVolume of Surplus Modeled Available Groundwater (Year 2050) from DB22 for each major and minor aquifer (multiple often per grid cell), divided and assigned equally amongst respective cells located in County- River BasinWB_2060_dividedVolume of Surplus Modeled Available Groundwater (Year 2060) from DB22 for each major and minor aquifer (multiple often per grid cell), divided and assigned equally amongst respective cells located in County- River BasinWB_2070_dividedVolume of Surplus Modeled Available Groundwater (Year 2070) from DB22 for each major and minor aquifer (multiple often per grid cell), divided and assigned equally amongst respective cells located in County- River BasinWB_Min_dividedMinimum MAG over 2020-2070 period for each major and minor aquifers by grid cell. This is the Volume of Excess Groundwater used to calculate GW score.Water_Balance_2020Total volume of Surplus Modeled Available Groundwater at County- River Basin level for Year 2020 (from DB22) before assigning to grid cellsWater_Balance_2030Total volume of Surplus Modeled Available Groundwater at County- River Basin level for Year 2030 (from DB22) before assigning to grid cellsWater_Balance_2040Total volume of Surplus Modeled Available Groundwater at County- River Basin level for Year 2040 (from DB22) before assigning to grid cellsWater_Balance_2050Total volume of Surplus Modeled Available Groundwater at County- River Basin level for Year 2050 (from DB22) before assigning to grid cellsWater_Balance_2060Total volume of Surplus Modeled Available Groundwater at County- River Basin level for Year 2060 (from DB22) before assigning to grid cellsWater_Balance_2070Total volume of Surplus Modeled Available Groundwater at County- River Basin level for Year 2070 (from DB22) before assigning to grid cellsWater_Balance_MinimumMinimum volume of Surplus Modeled Available Groundwater at County- River Basin level over Year 2020- 2070 period (from DB22) before assigning to grid cellsGround_DurationScore of 0 or 1. Based on number of consecutive decades MAG exceeding 500 acft/yr is available over the 2020-2070 period (6 decades)No_of_DecadesNumber of decades MAG exceeding 500 acft/yr is available. For use in scoring Ground_Frequency.Ground_FrequencyScore of 0 or 1. Based on number of decades MAG exceeding 500 acft/yr is available over the 2020-2070 period (6 decades)Ground_VolumeScore of 0-1, for WB_Min_Divided according to volume criteria range.Ground_WQScore of 0-1, for general estimated treatability. High treatment (reuse)- 0; Conventional treatment (SW)- 0.5; Low treatment (low TDS, fresh GW)-1Ground_ScoreGW Excess Supply Score by grid cell (many records per cell based for coincident aquifers/basin/county combinations), considers Volume, Frequency, and Duration. Score 0-1.Freq_CountNot used. Part of internal QC process.

Service Item Id: c28bc11fc53f4abfba49aad100756ed6

Copyright Text: Prepared by HDR Inc. for Texas Water Development Board contract number 2000012405.

Default Visibility: true

MaxRecordCount: 3500

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.18716974792E7
YMin: 2988522.2936999984
XMax: -1.04092414988E7
YMax: 4369693.977300003
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: AQ_Name
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: GULF_COA
  Label: Gulf Coast
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 255, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: TRINITY
  Label: Trinity
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [0, 255, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: CARRIZO
  Label: Carrizo-Wilcox
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: EDWARDS-
  Label: Edwards-Trinity Plateau
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [204, 255, 204, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: OGALLALA
  Label: Ogallala
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [128, 204, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: PECOS VA
  Label: Pecos Valley
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 191, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: EDWARDS
  Label: Edwards-BFZ
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [77, 140, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: SEYMOUR
  Label: Seymour
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [209, 104, 29, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: HUECO_BO
  Label: Hueco-Mesilla Bolson
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 0, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
Transparency: 20
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• RCID ( type: esriFieldTypeInteger, alias: RCID )
• CTY_BS_AQ ( type: esriFieldTypeString, alias: CTY_BS_AQ, length: 150 )
• RCID_NEW_CTY_BS_AQ ( type: esriFieldTypeString, alias: RCID_NEW_CTY_BS_AQ, length: 150 )
• Class ( type: esriFieldTypeString, alias: Class, length: 6 )
• Source_ID ( type: esriFieldTypeString, alias: Source_ID, length: 50 )
• SourceID_RCID ( type: esriFieldTypeString, alias: SourceID_RCID, length: 50 )
• AQ_Name ( type: esriFieldTypeString, alias: AQ_Name, length: 26 )
• Source_Region ( type: esriFieldTypeString, alias: Source_Region, length: 3 )
• Source_Name ( type: esriFieldTypeString, alias: Source_Name, length: 34 )
• GW_ID ( type: esriFieldTypeString, alias: GW_ID, length: 26 )
• ASRCodeAlpha ( type: esriFieldTypeString, alias: ASRCodeAlpha, length: 5 )
• Status ( type: esriFieldTypeString, alias: Status, length: 12 )
• Source_Detail ( type: esriFieldTypeString, alias: Source_Detail, length: 41 )
• Source_County ( type: esriFieldTypeString, alias: Source_County, length: 14 )
• Source_Basin ( type: esriFieldTypeString, alias: Source_Basin, length: 12 )
• Salinity ( type: esriFieldTypeString, alias: Salinity, length: 15 )
• WB_2020_divided ( type: esriFieldTypeDouble, alias: WB_2020_divided )
• WB_2030_divided ( type: esriFieldTypeDouble, alias: WB_2030_divided )
• WB_2040_divided ( type: esriFieldTypeDouble, alias: WB_2040_divided )
• WB_2050_divided ( type: esriFieldTypeDouble, alias: WB_2050_divided )
• WB_2060_divided ( type: esriFieldTypeDouble, alias: WB_2060_divided )
• WB_2070_divided ( type: esriFieldTypeDouble, alias: WB_2070_divided )
• WB_Min_divided ( type: esriFieldTypeDouble, alias: WB_Min_divided )
• Water_Balance_2020 ( type: esriFieldTypeDouble, alias: Water_Balance_2020 )
• Water_Balance_2030 ( type: esriFieldTypeDouble, alias: Water_Balance_2030 )
• Water_Balance_2040 ( type: esriFieldTypeDouble, alias: Water_Balance_2040 )
• Water_Balance_2050 ( type: esriFieldTypeDouble, alias: Water_Balance_2050 )
• Water_Balance_2060 ( type: esriFieldTypeDouble, alias: Water_Balance_2060 )
• Water_Balance_2070 ( type: esriFieldTypeDouble, alias: Water_Balance_2070 )
• Water_Balance_Minimum ( type: esriFieldTypeDouble, alias: Water_Balance_Minimum )
• Ground_Duration ( type: esriFieldTypeDouble, alias: Ground_Duration )
• No_of_Decades ( type: esriFieldTypeDouble, alias: No_of_Decades )
• Ground_Frequency ( type: esriFieldTypeDouble, alias: Ground_Frequency )
• Volume_Score ( type: esriFieldTypeDouble, alias: Ground_Volume )
• Ground_WQ ( type: esriFieldTypeDouble, alias: Ground_WQ )
• Ground_Score ( type: esriFieldTypeDouble, alias: Ground_Score )
• Freq_Count ( type: esriFieldTypeInteger, alias: Freq_Count )
• SHAPE.STArea() ( type: esriFieldTypeDouble, alias: SHAPE.STArea() )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata