Name: AUMIRA Site Inspection (Active)

Display Field: REMEDIATION

Type: Table

Geometry Type: N/A

Description:

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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• TIER ( type: esriFieldTypeInteger, alias: Tier, editable: true, nullable: true, defaultValue: null, modelName: TIER , Coded Values: [1: Tier 1] , [2: Tier 2] , [3: Tier 3] , ...1 more... )
• REMEDIATION ( type: esriFieldTypeString, alias: Remediation, editable: true, nullable: true, length: 14, defaultValue: null, modelName: REMEDIATION , Coded Values: [Remediated: Remediated] , [Non-Remediated: Non-Remediated] )
• EMERG_DETERMINATION ( type: esriFieldTypeString, alias: Emergency Determination, editable: true, nullable: true, length: 1, defaultValue: null, modelName: EMERG_DETERMINATION , Coded Values: [Y: Yes] , [N: No] )
• EMERG_DECLARATION_NBR ( type: esriFieldTypeString, alias: Emergency Declaration Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: EMERG_DECLARATION_NBR )
• EMERG_DECLARATION_DATE ( type: esriFieldTypeDate, alias: Emergency Declaration Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EMERG_DECLARATION_DATE )
• DETAILED_RATING_SCORE ( type: esriFieldTypeInteger, alias: Detailed Rating Score, editable: true, nullable: true, defaultValue: null, modelName: DETAILED_RATING_SCORE )
• HAZARD_AREA_BMP ( type: esriFieldTypeDouble, alias: Hazard Area BMP, editable: true, nullable: true, defaultValue: null, modelName: HAZARD_AREA_BMP )
• HAZARD_AREA_BMP_ELEV ( type: esriFieldTypeInteger, alias: Hazard Area BMP Elevation (ft), editable: true, nullable: true, defaultValue: null, modelName: HAZARD_AREA_BMP_ELEV , Range: [0, 9999] )
• HAZARD_AREA_EMP ( type: esriFieldTypeDouble, alias: Hazard Area EMP, editable: true, nullable: true, defaultValue: null, modelName: HAZARD_AREA_EMP )
• HAZARD_AREA_EMP_ELEV ( type: esriFieldTypeInteger, alias: Hazard Area EMP Elevation (ft), editable: true, nullable: true, defaultValue: null, modelName: HAZARD_AREA_EMP_ELEV , Range: [0, 9999] )
• HAZARD_AREA_LENGTH ( type: esriFieldTypeInteger, alias: Hazard Area Length (ft), editable: true, nullable: true, defaultValue: null, modelName: HAZARD_AREA_LENGTH )
• STRUCTURES_IN_ROW ( type: esriFieldTypeInteger, alias: Structures in the Right of Way, editable: true, nullable: true, defaultValue: null, modelName: STRUCTURES_IN_ROW , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...2 more... )
• ACCIDENT ( type: esriFieldTypeString, alias: Accident Due to Geohazard, editable: true, nullable: true, length: 1, defaultValue: N, modelName: ACCIDENT , Coded Values: [Y: Yes] , [N: No] )
• INSPECTION_COMMENTS ( type: esriFieldTypeString, alias: Inspection Comments, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: INSPECTION_COMMENTS )
• INSPECTION_DATE ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPECTION_DATE )
• REMEDIATION_EFFECT ( type: esriFieldTypeString, alias: Remediation Effectiveness, editable: true, nullable: true, length: 3, defaultValue: null, modelName: REMEDIATION_EFFECT , Coded Values: [Y: Yes] , [N: No] , [TBD: To Be Determined] )
• AADT_SCORE ( type: esriFieldTypeInteger, alias: AADT Total Number Score, editable: true, nullable: true, defaultValue: null, modelName: AADT_SCORE )
• AADTT_SCORE ( type: esriFieldTypeInteger, alias: AADT Truck Number Score, editable: true, nullable: true, defaultValue: null, modelName: AADTT_SCORE )
• SPEED_LIMIT_SCORE ( type: esriFieldTypeInteger, alias: Speed Limit Score, editable: true, nullable: true, defaultValue: null, modelName: SPEED_LIMIT_SCORE )
• STRUCTURE_IN_ROW_SCORE ( type: esriFieldTypeInteger, alias: Structures in the Right of Way Score, editable: true, nullable: true, defaultValue: null, modelName: STRUCTURE_IN_ROW_SCORE )
• SECONDARY_MINING_SCORE ( type: esriFieldTypeInteger, alias: Secondary Mining Score, editable: true, nullable: true, defaultValue: null, modelName: SECONDARY_MINING_SCORE )
• SPECIAL_FEATURE_SCORE ( type: esriFieldTypeInteger, alias: Special Mine Features Score, editable: true, nullable: true, defaultValue: null, modelName: SPECIAL_FEATURE_SCORE )
• REPORTED_PROBLEM_SCORE ( type: esriFieldTypeInteger, alias: Problems Reported During Active Mining Score, editable: true, nullable: true, defaultValue: null, modelName: REPORTED_PROBLEM_SCORE )
• AGE_OF_MINING_SCORE ( type: esriFieldTypeInteger, alias: Age of Mining Score, editable: true, nullable: true, defaultValue: null, modelName: AGE_OF_MINING_SCORE )
• SIDE_CRIBBING_SCORE ( type: esriFieldTypeInteger, alias: Type of Side Cribbing Score, editable: true, nullable: true, defaultValue: null, modelName: SIDE_CRIBBING_SCORE )
• MIN_OVERBURDEN_SCORE ( type: esriFieldTypeInteger, alias: Minimum Overburden Thickness Score, editable: true, nullable: true, defaultValue: null, modelName: MIN_OVERBURDEN_SCORE )
• MINED_INTERVAL_SCORE ( type: esriFieldTypeInteger, alias: Maximum Mined Interval Thickness Score, editable: true, nullable: true, defaultValue: null, modelName: MINED_INTERVAL_SCORE )
• OVERBURDEN_INTER_SCORE ( type: esriFieldTypeInteger, alias: Ratio of Minimum Total Overburden Thickness to Maximum Mined Interval Thickness Score, editable: true, nullable: true, defaultValue: null, modelName: OVERBURDEN_INTER_SCORE )
• UNCONSOL_BEDROCK_SCORE ( type: esriFieldTypeInteger, alias: Ratio of Unconsolidated Material to Bedrock in the Overburden Interval Score, editable: true, nullable: true, defaultValue: null, modelName: UNCONSOL_BEDROCK_SCORE )
• DRIFT_OPENING_SCORE ( type: esriFieldTypeInteger, alias: # of Drift Openings Score, editable: true, nullable: true, defaultValue: null, modelName: DRIFT_OPENING_SCORE )
• SLOPE_UKNOWN_SCORE ( type: esriFieldTypeInteger, alias: # of Slope / Unknown Openings Score, editable: true, nullable: true, defaultValue: null, modelName: SLOPE_UKNOWN_SCORE )
• VERTICAL_SHAFT_SCORE ( type: esriFieldTypeInteger, alias: # of Vertical Shaft Openings Score, editable: true, nullable: true, defaultValue: null, modelName: VERTICAL_SHAFT_SCORE )
• LOCATION_SCORE ( type: esriFieldTypeInteger, alias: Location Score, editable: true, nullable: true, defaultValue: null, modelName: LOCATION_SCORE )
• PLAN_AREA_SCORE ( type: esriFieldTypeInteger, alias: Plan Area of Shaft Opening Score, editable: true, nullable: true, defaultValue: null, modelName: PLAN_AREA_SCORE )
• CUMULA_PLAN_AREA_SCORE ( type: esriFieldTypeInteger, alias: Cumulative Plan Area of Mine Opening Score, editable: true, nullable: true, defaultValue: null, modelName: CUMULA_PLAN_AREA_SCORE )
• CLOSURE_METHOD_SCORE ( type: esriFieldTypeInteger, alias: Method of Closure Score, editable: true, nullable: true, defaultValue: null, modelName: CLOSURE_METHOD_SCORE )
• SURFACE_DEFOR_SCORE ( type: esriFieldTypeInteger, alias: Number of Surface Deformations Score, editable: true, nullable: true, defaultValue: null, modelName: SURFACE_DEFOR_SCORE )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GLOBALID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• sys_updated_date ( type: esriFieldTypeDate, alias: sys_updated_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: sys_updated_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: AUMIRA Site Inspection (Active)
  Description:
  Prototype:
  sys_updated_date: null
  TIER: null
  REMEDIATION: null
  EMERG_DETERMINATION: null
  EMERG_DECLARATION_NBR: null
  EMERG_DECLARATION_DATE: null
  DETAILED_RATING_SCORE: null
  HAZARD_AREA_BMP: null
  HAZARD_AREA_BMP_ELEV: null
  HAZARD_AREA_EMP: null
  HAZARD_AREA_EMP_ELEV: null
  HAZARD_AREA_LENGTH: null
  STRUCTURES_IN_ROW: null
  ACCIDENT: N
  INSPECTION_COMMENTS: null
  INSPECTION_DATE: null
  REMEDIATION_EFFECT: null
  AADT_SCORE: null
  AADTT_SCORE: null
  SPEED_LIMIT_SCORE: null
  STRUCTURE_IN_ROW_SCORE: null
  SECONDARY_MINING_SCORE: null
  SPECIAL_FEATURE_SCORE: null
  REPORTED_PROBLEM_SCORE: null
  AGE_OF_MINING_SCORE: null
  SIDE_CRIBBING_SCORE: null
  MIN_OVERBURDEN_SCORE: null
  MINED_INTERVAL_SCORE: null
  OVERBURDEN_INTER_SCORE: null
  UNCONSOL_BEDROCK_SCORE: null
  DRIFT_OPENING_SCORE: null
  SLOPE_UKNOWN_SCORE: null
  VERTICAL_SHAFT_SCORE: null
  LOCATION_SCORE: null
  PLAN_AREA_SCORE: null
  CUMULA_PLAN_AREA_SCORE: null
  CLOSURE_METHOD_SCORE: null
  SURFACE_DEFOR_SCORE: null
  REL_GLOBALID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• GEOHAZARDS_AUM_SITE_INVENTORY (13) -- Related To: AUMIRA Site BMP (Active) (4)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata