Name: Sinkhole Measurements

Display Field: relateid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: f27300e1a8fd4b7caf8a677b5383863c

Copyright Text:

Default Visibility: false

MaxRecordCount: 40000

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 )
• relateid ( type: esriFieldTypeString, alias: Relateid, editable: true, nullable: true, length: 10, defaultValue: null, modelName: relateid )
• observer ( type: esriFieldTypeString, alias: Observer, editable: true, nullable: true, length: 100, defaultValue: null, modelName: observer , Coded Values: [Aaren Mathison: Aaren Mathison] , [Andrew Luhmann: Andrew Luhmann] , [Andrew Peters: Andrew Peters] , ...28 more... )
• observer_org ( type: esriFieldTypeString, alias: Observer Organization, editable: true, nullable: true, length: 100, defaultValue: null, modelName: observer_org , Coded Values: [Chosen Valley Testing: Chosen Valley Testing] , [Dakota County Environmental Resources: Dakota County Environmental Resources] , [Dodge County SWCD: Dodge County SWCD] , ...27 more... )
• observation_date ( type: esriFieldTypeDate, alias: Observation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: observation_date )
• size ( type: esriFieldTypeString, alias: Size, editable: true, nullable: true, length: 3, defaultValue: null, modelName: size , Coded Values: [M: medium, 3-10 meters in diameter] , [L: large, 10-30 meters in diameter] , [X: extra-large, > 30 meters in diameter] , ...3 more... )
• shapes ( type: esriFieldTypeString, alias: Shape of Sinkhole Walls, editable: true, nullable: true, length: 1, defaultValue: null, modelName: shapes , Coded Values: [B: Bowl] , [C: Compound] , [F: Funnel] , ...6 more... )
• length_meters ( type: esriFieldTypeDouble, alias: Length (Meters), editable: true, nullable: true, defaultValue: null, modelName: length_meters )
• width_meters ( type: esriFieldTypeDouble, alias: Width (Meters), editable: true, nullable: true, defaultValue: null, modelName: width_meters )
• depth_meters ( type: esriFieldTypeDouble, alias: Depth (Meters), editable: true, nullable: true, defaultValue: null, modelName: depth_meters )
• dimension_method ( type: esriFieldTypeString, alias: Dimension Method, editable: true, nullable: true, length: 1, defaultValue: null, modelName: dimension_method , Coded Values: [D: taken from engineer's drawings] , [E: estimated in the field] , [L: recalled by landowner or other person] , ...2 more... )
• sides ( type: esriFieldTypeString, alias: Sides, editable: true, nullable: true, length: 8, defaultValue: null, modelName: sides , Coded Values: [S: Shallow] , [T: Steep] , [U: Not Field Checked] , ...1 more... )
• setting ( type: esriFieldTypeString, alias: Setting, editable: true, nullable: true, length: 50, defaultValue: null, modelName: setting , Coded Values: [C: crest/plain, topographic high location] , [S: slope, gently to steeply sloped w/out incised waterway] , [U: not field checked] , ...2 more... )
• trend ( type: esriFieldTypeSmallInteger, alias: Trend of Sinhole's Long Axis, editable: true, nullable: true, defaultValue: null, modelName: trend , Range: [0, 360] )
• activity ( type: esriFieldTypeString, alias: Activity, editable: true, nullable: true, length: 1, defaultValue: null, modelName: activity , Coded Values: [A: ambiguous] , [C: shows evidence of recent collapse] , [I: inactive sinkhole, no obvious opening, appears to be in-filling w/out water infiltration, includes sinkhole ponds and filled sinkholes] , ...2 more... )
• treatment ( type: esriFieldTypeString, alias: Treatment, editable: true, nullable: true, length: 1, defaultValue: null, modelName: treatment , Coded Values: [E: surface water diversion way constructed by engineer (i.e. SCS)] , [F: filled with permeable material by engineer] , [G: filled with impermeable seal by engineer, requires grout plus plastic and/or clay] , ...9 more... )
• treatment_date ( type: esriFieldTypeDate, alias: Treatment Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: treatment_date )
• contents ( type: esriFieldTypeString, alias: Contents in Sinkhole, editable: true, nullable: true, length: 7, defaultValue: null, modelName: contents , Coded Values: [A: animal waste or carcasses] , [B: brush, logs, tree stumps] , [D: demolition debris, including lumber, concrete, metal] , ...8 more... )
• formed_before ( type: esriFieldTypeDate, alias: Sinkhole Formed Before, editable: true, nullable: true, length: 8, defaultValue: null, modelName: formed_before )
• formed_after ( type: esriFieldTypeDate, alias: Sinkhole Formed After, editable: true, nullable: true, length: 8, defaultValue: null, modelName: formed_after )
• created_user ( type: esriFieldTypeString, alias: Created User, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Created Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• karst_guid ( type: esriFieldTypeGUID, alias: karst_guid, editable: false, nullable: true, length: 38, defaultValue: null, modelName: karst_guid )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )

Templates:

• Name: Sinkhole Measurements
  Description:
  Prototype:
  created_date: null
  relateid: null
  observer: null
  observer_org: null
  observation_date: null
  size: null
  shapes: null
  length_meters: null
  width_meters: null
  depth_meters: null
  dimension_method: null
  sides: null
  setting: null
  trend: null
  activity: null
  treatment: null
  treatment_date: null
  contents: null
  formed_before: null
  formed_after: null
  created_user: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• karst_prod.karst.to_karst_features (0) -- Related To: Karst Features (0)

Capabilities: Query,Extract

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   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata