Name: DNR_env_Major_Scores

Display Field: HUC_4

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 2ac775a093a94da1a68bea38b5e8a0bb

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• MAJOR ( type: esriFieldTypeDouble, alias: Major Watershed ID, editable: true, nullable: true, defaultValue: null, modelName: MAJOR )
• HUC_4 ( type: esriFieldTypeString, alias: HUC_4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HUC_4 )
• HUC_8 ( type: esriFieldTypeString, alias: HUC_8, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HUC_8 )
• A_I_MEAN ( type: esriFieldTypeSmallInteger, alias: Average of All Component Mean Indices, editable: true, nullable: true, defaultValue: null, modelName: A_I_MEAN )
• A_I_MINIMUM ( type: esriFieldTypeSmallInteger, alias: Minimum of All Indices, editable: true, nullable: true, defaultValue: null, modelName: A_I_MINIMUM )
• H_I_MEAN ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Mean Index , editable: true, nullable: true, defaultValue: null, modelName: H_I_MEAN )
• H_I_PC_16 ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Perennial Cover, 2016, editable: true, nullable: true, defaultValue: null, modelName: H_I_PC_16 )
• H_I_PC_13 ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Perennial Cover, 2013, editable: true, nullable: true, defaultValue: null, modelName: H_I_PC_13 )
• H_I_PC_11 ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Perennial Cover, 2011, editable: true, nullable: true, defaultValue: null, modelName: H_I_PC_11 )
• H_I_PC_08 ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Perennial Cover, 2008, editable: true, nullable: true, defaultValue: null, modelName: H_I_PC_08 )
• H_I_PC_06 ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Perennial Cover, 2006, editable: true, nullable: true, defaultValue: null, modelName: H_I_PC_06 )
• H_I_PC_04 ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Perennial Cover, 2004, editable: true, nullable: true, defaultValue: null, modelName: H_I_PC_04 )
• H_I_PC_01 ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Perennial Cover, 2001, editable: true, nullable: true, defaultValue: null, modelName: H_I_PC_01 )
• H_I_IC_16 ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Impervious Cover, 2016, editable: true, nullable: true, defaultValue: null, modelName: H_I_IC_16 )
• H_I_IC_11 ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Impervious Cover, 2011, editable: true, nullable: true, defaultValue: null, modelName: H_I_IC_11 )
• H_I_IC_06 ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Impervious Cover, 2006, editable: true, nullable: true, defaultValue: null, modelName: H_I_IC_06 )
• H_I_IC_01 ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Impervious Cover, 2001, editable: true, nullable: true, defaultValue: null, modelName: H_I_IC_01 )
• H_I_WW ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Water Withdrawal, editable: true, nullable: true, defaultValue: null, modelName: H_I_WW )
• H_I_FV ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Flow Variability, editable: true, nullable: true, defaultValue: null, modelName: H_I_FV )
• H_M_FV_MM ( type: esriFieldTypeSmallInteger, alias: Hyd Metric - Flow Variability, Monthly Magnitude, editable: true, nullable: true, defaultValue: null, modelName: H_M_FV_MM )
• H_M_FV_RFC ( type: esriFieldTypeSmallInteger, alias: Hyd Metric - Flow Variability, Rate and Frequency of Change, editable: true, nullable: true, defaultValue: null, modelName: H_M_FV_RFC )
• H_M_FV_MDX ( type: esriFieldTypeSmallInteger, alias: Hyd Metric - Flow Variability, Magn. and Duration of Annual Extremes, editable: true, nullable: true, defaultValue: null, modelName: H_M_FV_MDX )
• H_M_FV_TX ( type: esriFieldTypeSmallInteger, alias: Hyd Metric - Flow Variability, Timing of Annual Extremes, editable: true, nullable: true, defaultValue: null, modelName: H_M_FV_TX )
• H_M_FV_FDP ( type: esriFieldTypeSmallInteger, alias: Hyd Metric - Flow Variability, Freq. and Dur. of High/Low Pulse, editable: true, nullable: true, defaultValue: null, modelName: H_M_FV_FDP )
• H_I_LHS ( type: esriFieldTypeSmallInteger, alias: Hyd Index - Loss of Hydrologic Storage, editable: true, nullable: true, defaultValue: null, modelName: H_I_LHS )
• H_M_LHS_WL ( type: esriFieldTypeSmallInteger, alias: Hyd Metric - Loss of Hydrologic Storage, Wetland Loss, editable: true, nullable: true, defaultValue: null, modelName: H_M_LHS_WL )
• H_M_LHS_AW ( type: esriFieldTypeSmallInteger, alias: Hyd Metric - Loss of Hydrologic Storage, Altered Watercourse, editable: true, nullable: true, defaultValue: null, modelName: H_M_LHS_AW )
• G_I_MEAN ( type: esriFieldTypeSmallInteger, alias: Geo Index - Mean Index, editable: true, nullable: true, defaultValue: null, modelName: G_I_MEAN )
• G_I_SEP ( type: esriFieldTypeSmallInteger, alias: Geo Index - Soil Erosion Susceptibility, editable: true, nullable: true, defaultValue: null, modelName: G_I_SEP )
• G_I_PSNSM ( type: esriFieldTypeSmallInteger, alias: Geo Index - Pollution Sensitivity of Near-Surface Materials, editable: true, nullable: true, defaultValue: null, modelName: G_I_PSNSM )
• G_H_PSNSM_SC ( type: esriFieldTypeString, alias: Geo Highlight - Pollution Sensitivity of Near-Surface Materials, Special Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: G_H_PSNSM_SC )
• G_I_SSNS ( type: esriFieldTypeSmallInteger, alias: Geo Index - Steep Slopes Near Streams, editable: true, nullable: true, defaultValue: null, modelName: G_I_SSNS )
• G_I_CV ( type: esriFieldTypeSmallInteger, alias: Geo Index - Climate Water Balance, editable: true, nullable: true, defaultValue: null, modelName: G_I_CV )
• B_I_MEAN ( type: esriFieldTypeSmallInteger, alias: Bio Index - Mean Index, editable: true, nullable: true, defaultValue: null, modelName: B_I_MEAN )
• B_I_TH ( type: esriFieldTypeSmallInteger, alias: Bio Index - Terrestrial Habitat Quality, editable: true, nullable: true, defaultValue: null, modelName: B_I_TH )
• B_I_SR ( type: esriFieldTypeSmallInteger, alias: Bio Index - Species Richness, editable: true, nullable: true, defaultValue: null, modelName: B_I_SR )
• B_M_SR_I ( type: esriFieldTypeSmallInteger, alias: Bio Metric - Species Richness, Invertebrate Richness, editable: true, nullable: true, defaultValue: null, modelName: B_M_SR_I )
• B_M_SR_F ( type: esriFieldTypeSmallInteger, alias: Bio Metric - Species Richness, Fish Richness, editable: true, nullable: true, defaultValue: null, modelName: B_M_SR_F )
• B_M_SR_B ( type: esriFieldTypeSmallInteger, alias: Bio Metric - Species Richness, Bird Richness, editable: true, nullable: true, defaultValue: null, modelName: B_M_SR_B )
• B_M_SR_M ( type: esriFieldTypeSmallInteger, alias: Bio Metric - Species Richness, Mussel Richness, editable: true, nullable: true, defaultValue: null, modelName: B_M_SR_M )
• B_I_ARSR ( type: esriFieldTypeSmallInteger, alias: Bio Index - At Risk Species Richness, editable: true, nullable: true, defaultValue: null, modelName: B_I_ARSR )
• B_M_ARSR_M ( type: esriFieldTypeSmallInteger, alias: Bio Metric - At Risk Species Richness, Mussel Species, editable: true, nullable: true, defaultValue: null, modelName: B_M_ARSR_M )
• B_M_ARSR_B ( type: esriFieldTypeSmallInteger, alias: Bio Metric - At Risk Species Richness, Bird Species, editable: true, nullable: true, defaultValue: null, modelName: B_M_ARSR_B )
• B_M_ARSR_F ( type: esriFieldTypeSmallInteger, alias: Bio Metric - At Risk Species Richness, Fish Species, editable: true, nullable: true, defaultValue: null, modelName: B_M_ARSR_F )
• B_I_SSQ ( type: esriFieldTypeSmallInteger, alias: Bio Index - Stream Species Quality, editable: true, nullable: true, defaultValue: null, modelName: B_I_SSQ )
• B_M_SSQ_FI ( type: esriFieldTypeSmallInteger, alias: Bio Metric - Stream Species Quality, Fish IBI, editable: true, nullable: true, defaultValue: null, modelName: B_M_SSQ_FI )
• B_M_SSQ_II ( type: esriFieldTypeSmallInteger, alias: Bio Metric - Stream Species Quality, Aquatic Invertebrate IBI, editable: true, nullable: true, defaultValue: null, modelName: B_M_SSQ_II )
• B_M_SSQ_MS ( type: esriFieldTypeSmallInteger, alias: Bio Metric - Stream Species Quality, Mussel Score, editable: true, nullable: true, defaultValue: null, modelName: B_M_SSQ_MS )
• C_I_MEAN ( type: esriFieldTypeSmallInteger, alias: Con Index - Mean Index, editable: true, nullable: true, defaultValue: null, modelName: C_I_MEAN )
• C_I_TC ( type: esriFieldTypeSmallInteger, alias: Con Index - Terrestrial Habitat Connectivity, editable: true, nullable: true, defaultValue: null, modelName: C_I_TC )
• C_I_RC ( type: esriFieldTypeSmallInteger, alias: Con Index - Riparian Connectivity, editable: true, nullable: true, defaultValue: null, modelName: C_I_RC )
• C_I_AC ( type: esriFieldTypeSmallInteger, alias: Con Index - Aquatic Disruption, editable: true, nullable: true, defaultValue: null, modelName: C_I_AC )
• C_M_AC_BC ( type: esriFieldTypeSmallInteger, alias: Con Metric - Aquatic Disruption, Bridges and Culverts, editable: true, nullable: true, defaultValue: null, modelName: C_M_AC_BC )
• C_M_AC_D ( type: esriFieldTypeSmallInteger, alias: Con Metric - Aquatic Disruption, Dams, editable: true, nullable: true, defaultValue: null, modelName: C_M_AC_D )
• W_I_MEAN ( type: esriFieldTypeSmallInteger, alias: WQ Index - Mean Index, editable: true, nullable: true, defaultValue: null, modelName: W_I_MEAN )
• W_I_PS ( type: esriFieldTypeSmallInteger, alias: WQ Index - Localized Pollution Sources, editable: true, nullable: true, defaultValue: null, modelName: W_I_PS )
• W_I_NPS ( type: esriFieldTypeSmallInteger, alias: WQ Index - Non-Point Sources, editable: true, nullable: true, defaultValue: null, modelName: W_I_NPS )
• W_M_NPS_PR ( type: esriFieldTypeSmallInteger, alias: WQ Metric - Non-Point Sources, Phosphorus Risk from Uplands, editable: true, nullable: true, defaultValue: null, modelName: W_M_NPS_PR )
• W_M_NPS_IS ( type: esriFieldTypeSmallInteger, alias: WQ Metric - Non-Point Sources, Impervious Surfaces within Riparian Areas, editable: true, nullable: true, defaultValue: null, modelName: W_M_NPS_IS )
• W_M_NPS_CA ( type: esriFieldTypeSmallInteger, alias: WQ Metric - Non-Point Sources, Rate of Ag. Chemical Application, editable: true, nullable: true, defaultValue: null, modelName: W_M_NPS_CA )
• W_I_WQA ( type: esriFieldTypeSmallInteger, alias: WQ Index - Water Quality Assessments, editable: true, nullable: true, defaultValue: null, modelName: W_I_WQA )
• W_M_WQA_AL ( type: esriFieldTypeSmallInteger, alias: WQ Metric - Water Quality Assessments, Aquatic Life, editable: true, nullable: true, defaultValue: null, modelName: W_M_WQA_AL )
• W_M_WQA_AR ( type: esriFieldTypeSmallInteger, alias: WQ Metric - Water Quality Assessments, Aquatic Recreation, editable: true, nullable: true, defaultValue: null, modelName: W_M_WQA_AR )
• W_M_WQA_AC ( type: esriFieldTypeSmallInteger, alias: WQ Metric - Water Quality Assessments, Aquatic Consumption, editable: true, nullable: true, defaultValue: null, modelName: W_M_WQA_AC )

Templates:

• Name: DNR_env_Major_Scores
  Description:
  Prototype:
  W_M_WQA_AR: null
  W_M_WQA_AC: null
  MAJOR: null
  HUC_4: null
  HUC_8: null
  A_I_MEAN: null
  A_I_MINIMUM: null
  H_I_MEAN: null
  H_I_PC_16: null
  H_I_PC_13: null
  H_I_PC_11: null
  H_I_PC_08: null
  H_I_PC_06: null
  H_I_PC_04: null
  H_I_PC_01: null
  H_I_IC_16: null
  H_I_IC_11: null
  H_I_IC_06: null
  H_I_IC_01: null
  H_I_WW: null
  H_I_FV: null
  H_M_FV_MM: null
  H_M_FV_RFC: null
  H_M_FV_MDX: null
  H_M_FV_TX: null
  H_M_FV_FDP: null
  H_I_LHS: null
  H_M_LHS_WL: null
  H_M_LHS_AW: null
  G_I_MEAN: null
  G_I_SEP: null
  G_I_PSNSM: null
  G_H_PSNSM_SC: null
  G_I_SSNS: null
  G_I_CV: null
  B_I_MEAN: null
  B_I_TH: null
  B_I_SR: null
  B_M_SR_I: null
  B_M_SR_F: null
  B_M_SR_B: null
  B_M_SR_M: null
  B_I_ARSR: null
  B_M_ARSR_M: null
  B_M_ARSR_B: null
  B_M_ARSR_F: null
  B_I_SSQ: null
  B_M_SSQ_FI: null
  B_M_SSQ_II: null
  B_M_SSQ_MS: null
  C_I_MEAN: null
  C_I_TC: null
  C_I_RC: null
  C_I_AC: null
  C_M_AC_BC: null
  C_M_AC_D: null
  W_I_MEAN: null
  W_I_PS: null
  W_I_NPS: null
  W_M_NPS_PR: null
  W_M_NPS_IS: null
  W_M_NPS_CA: null
  W_I_WQA: null
  W_M_WQA_AL: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata