Name: TrailInspectionsRT

Display Field: NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 60c6a8817cfa473b984d2c71665df637

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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

Feature Draw Order:

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• NAME ( type: esriFieldTypeString, alias: Trail Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NAME )
• TrailMaterial ( type: esriFieldTypeString, alias: Trail Material, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TrailMaterial , Coded Values: [Asphalt: Asphalt] , [Dirt: Dirt] )
• InspectedBy ( type: esriFieldTypeString, alias: Inspected By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectedBy )
• InspectedDate ( type: esriFieldTypeDate, alias: Inspected Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectedDate )
• Score ( type: esriFieldTypeSmallInteger, alias: Score, editable: true, nullable: true, defaultValue: null, modelName: Score )
• ErosionConcerns ( type: esriFieldTypeString, alias: Have erosion concerns been corrected (gullies, washouts)?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: ErosionConcerns , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ErosionConcernsNotes ( type: esriFieldTypeString, alias: If no, describe the location and severity:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ErosionConcernsNotes )
• ErosionSurfaceStable ( type: esriFieldTypeString, alias: Is the trail surface stable?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: ErosionSurfaceStable , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ErosionHazards ( type: esriFieldTypeString, alias: Have areas where erosion creates a hazard been fixed?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: ErosionHazards , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ErosionHazardsNotes ( type: esriFieldTypeString, alias: Describe where erosion creates a hazard:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ErosionHazardsNotes )
• LMAddressed ( type: esriFieldTypeString, alias: Have areas with loose rocks, gravel, or sand been addressed?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: LMAddressed , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• LMAddressedNotes ( type: esriFieldTypeString, alias: Describe loose rocks, gravel, or sand unaddressed:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LMAddressedNotes )
• LMDebris ( type: esriFieldTypeString, alias: Have debris (branches, leaves, etc.) been removed from the trail?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: LMDebris , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• LMDebrisNotes ( type: esriFieldTypeString, alias: Describe debris:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LMDebrisNotes )
• RRStable ( type: esriFieldTypeString, alias: Are roots and rocks stable?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: RRStable , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• RRStableNotes ( type: esriFieldTypeString, alias: Describe unstable roots and rocks:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RRStableNotes )
• RRSharpEdges ( type: esriFieldTypeString, alias: Have sharp edges or protruding rocks been removed?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: RRSharpEdges , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• RRSharpEdgesNotes ( type: esriFieldTypeString, alias: Describe sharp edges or protruding rocks:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RRSharpEdgesNotes )
• RRWeeds ( type: esriFieldTypeString, alias: Have the weeds been removed from the trail?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: RRWeeds , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• RRWeedsNotes ( type: esriFieldTypeString, alias: Describe weeds:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RRWeedsNotes )
• WeatherMaint ( type: esriFieldTypeString, alias: Has trail maintenance been done since the last weather event?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: WeatherMaint , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• WeatherMaintNotes ( type: esriFieldTypeString, alias: Describe the trail maintenance effects (mud, ice, ect.):, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WeatherMaintNotes )
• WeatherDrainage ( type: esriFieldTypeString, alias: Is drainage adequate?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: WeatherDrainage , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ObstacleTerrain ( type: esriFieldTypeString, alias: Have holes, ruts, or unexpected changes in terrain been addressed?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: ObstacleTerrain , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ObstacleTerrainNotes ( type: esriFieldTypeString, alias: Describe changes in terrain:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ObstacleTerrainNotes )
• ObstacleFeatures ( type: esriFieldTypeString, alias: Are man-made features (jumps, drops, berms) in good condition?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: ObstacleFeatures , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ObstacleFeaturesNotes ( type: esriFieldTypeString, alias: Describe feature condition:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ObstacleFeaturesNotes )
• SightlinesAdequate ( type: esriFieldTypeString, alias: Are sightlines adequate around corners and over blind rises?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: SightlinesAdequate , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SightlinesVegetation ( type: esriFieldTypeString, alias: Has vegetation been removed to increase safety?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: SightlinesVegetation , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• WidthAppropriate ( type: esriFieldTypeString, alias: Is the trail width appropriate for intended use?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: WidthAppropriate , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• WidthPassingZones ( type: esriFieldTypeString, alias: Are there adequate passing zones?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: WidthPassingZones , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SteepnessAppropriate ( type: esriFieldTypeString, alias: Is the steepness of climbs and descents appropriate for the skill level?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: SteepnessAppropriate , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CornerBanked ( type: esriFieldTypeString, alias: Are corners adequately banked or radiused?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: CornerBanked , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CornerBerm ( type: esriFieldTypeString, alias: Is berm integrity sound?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: CornerBerm , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CornerBermNotes ( type: esriFieldTypeString, alias: Describe berm integrity:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CornerBermNotes )
• SignageVisible ( type: esriFieldTypeString, alias: Is signage clear and visible?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: SignageVisible , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SignageCondition ( type: esriFieldTypeString, alias: Is signage in good condition?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: SignageCondition , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SignageMarking ( type: esriFieldTypeString, alias: Are trail difficulty, warnings, and directions clearly marked?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: SignageMarking , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SignageMarkingNotes ( type: esriFieldTypeString, alias: Describe marking issues:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SignageMarkingNotes )
• VegetationHazards ( type: esriFieldTypeString, alias: Have overhanging branches/limbs, thorns, rocks, hazards been removed?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: VegetationHazards , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• VegetationHazardsNotes ( type: esriFieldTypeString, alias: Describe vegetation hazards:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VegetationHazardsNotes )
• MaintSchedule ( type: esriFieldTypeString, alias: Is a regular maintenance schedule in place?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: MaintSchedule , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• MaintEquipment ( type: esriFieldTypeString, alias: Are maintenance tools and equipment adequate?, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: MaintEquipment , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• RiskEvaluation ( type: esriFieldTypeString, alias: Rate the severity and likelihood of each hazard, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RiskEvaluation , Coded Values: [Low: Low] , [Medium: Medium] , [High: High] )
• RiskMitigation ( type: esriFieldTypeString, alias: Describe the mitigation measures taken or recommended:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RiskMitigation )
• AdditionalNotes ( type: esriFieldTypeString, alias: Additional Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: AdditionalNotes )
• RelatedGlobalID ( type: esriFieldTypeGUID, alias: RelatedGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelatedGlobalID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user, required: true )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true )
• SurfaceTotalCompleted ( type: esriFieldTypeSmallInteger, alias: SurfaceTotalCompleted, editable: true, nullable: true, defaultValue: null, modelName: SurfaceTotalCompleted )
• LayoutTotalCompleted ( type: esriFieldTypeSmallInteger, alias: LayoutTotalCompleted, editable: true, nullable: true, defaultValue: null, modelName: LayoutTotalCompleted )
• EnvironmentTotalCompleted ( type: esriFieldTypeSmallInteger, alias: EnvironmentTotalCompleted, editable: true, nullable: true, defaultValue: null, modelName: EnvironmentTotalCompleted )
• InfrastructureTotalCompleted ( type: esriFieldTypeSmallInteger, alias: InfrastructureTotalCompleted, editable: true, nullable: true, defaultValue: null, modelName: InfrastructureTotalCompleted )

Templates:

• Name: TrailInspectionsRT
  Description:
  Prototype:
  EnvironmentTotalCompleted: null
  NAME: null
  TrailMaterial: null
  InspectedBy: null
  InspectedDate: null
  Score: null
  ErosionConcerns: Yes
  ErosionConcernsNotes: null
  ErosionSurfaceStable: Yes
  ErosionHazards: Yes
  ErosionHazardsNotes: null
  LMAddressed: Yes
  LMAddressedNotes: null
  LMDebris: Yes
  LMDebrisNotes: null
  RRStable: Yes
  RRStableNotes: null
  RRSharpEdges: Yes
  RRSharpEdgesNotes: null
  RRWeeds: Yes
  RRWeedsNotes: null
  WeatherMaint: Yes
  WeatherMaintNotes: null
  WeatherDrainage: Yes
  ObstacleTerrain: Yes
  ObstacleTerrainNotes: null
  ObstacleFeatures: Yes
  ObstacleFeaturesNotes: null
  SightlinesAdequate: Yes
  SightlinesVegetation: Yes
  WidthAppropriate: Yes
  WidthPassingZones: Yes
  SteepnessAppropriate: Yes
  CornerBanked: Yes
  CornerBerm: Yes
  CornerBermNotes: null
  SignageVisible: Yes
  SignageCondition: Yes
  SignageMarking: Yes
  SignageMarkingNotes: null
  VegetationHazards: Yes
  VegetationHazardsNotes: null
  MaintSchedule: Yes
  MaintEquipment: Yes
  RiskEvaluation: null
  RiskMitigation: null
  AdditionalNotes: null
  RelatedGlobalID: null
  InfrastructureTotalCompleted: null
  LayoutTotalCompleted: null
  SurfaceTotalCompleted: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.Trails (6) -- Related To: Trails (8)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports OidReservation: 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:

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