Name: InteractiveTable_StatewideTable20052024_ExportTable

Display Field: first_sampling_year

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 3fa2be2e092d4ea0958d11b86105d908

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: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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: false
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• first_sampling_year ( modelName: first_sampling_year, nullable: true, editable: true, defaultValue: null, length: 8000, alias: First Sampling Year, type: esriFieldTypeString )
• second_sampling_year ( modelName: second_sampling_year, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Second Sampling Year, type: esriFieldTypeString )
• third_sampling_yearb ( modelName: third_sampling_yearb, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Third Sampling Year, type: esriFieldTypeString )
• fourth_sampling_yearc ( modelName: fourth_sampling_yearc, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Fourth Sampling Year, type: esriFieldTypeString )
• water_body ( modelName: water_body, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Water body, type: esriFieldTypeString )
• county ( modelName: county, nullable: true, editable: true, defaultValue: null, length: 8000, alias: County, type: esriFieldTypeString )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• species ( modelName: species, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Species, type: esriFieldTypeString )
• f15_year_hg_trends__first___fou ( modelName: f15_year_hg_trends__first___fou, nullable: true, editable: true, defaultValue: null, length: 8000, alias: 15-year Hg Trends (First - Fourth), type: esriFieldTypeString )
• f10_year__first___third_ ( modelName: f10_year__first___third_, nullable: true, editable: true, defaultValue: null, length: 8000, alias: 10-year (First - Third), type: esriFieldTypeString )
• f5_year_hg_trends__third_fourth ( modelName: f5_year_hg_trends__third_fourth, nullable: true, editable: true, defaultValue: null, length: 8000, alias: 5-year Hg Trends (Third-Fourth), type: esriFieldTypeString )
• co_variate ( modelName: co_variate, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Co-variate, type: esriFieldTypeString )
• historical_hgbass__2001_2002_ ( modelName: historical_hgbass__2001_2002_, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Historical Hgbass (2001-2002), type: esriFieldTypeString )
• first_sampling_hgbass ( modelName: first_sampling_hgbass, nullable: true, editable: true, defaultValue: null, length: 8000, alias: First Sampling Hgbass, type: esriFieldTypeString )
• second_sampling_hgbass ( modelName: second_sampling_hgbass, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Second Sampling Hgbass, type: esriFieldTypeString )
• third_sampling_hgbass ( modelName: third_sampling_hgbass, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Third Sampling Hgbass, type: esriFieldTypeString )
• fourth_sampling_hgbass ( modelName: fourth_sampling_hgbass, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Fourth Sampling Hgbass, type: esriFieldTypeString )
• mean_fish_length___mm_ ( modelName: mean_fish_length___mm_, nullable: true, editable: true, defaultValue: null, alias: Mean Fish Length (mm), type: esriFieldTypeInteger )

Templates:

• Name: InteractiveTable_StatewideTable20052024_ExportTable
  Description:
  Prototype:
  co_variate: null
  third_sampling_hgbass: null
  f5_year_hg_trends__third_fourth: null
  latitude: null
  county: null
  third_sampling_yearb: null
  first_sampling_hgbass: null
  water_body: null
  mean_fish_length___mm_: null
  fourth_sampling_yearc: null
  second_sampling_hgbass: null
  first_sampling_year: null
  second_sampling_year: null
  f15_year_hg_trends__first___fou: null
  species: null
  historical_hgbass__2001_2002_: null
  fourth_sampling_hgbass: null
  f10_year__first___third_: null
  longitude: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata