Name: TrailMaintenanceRT

Display Field: NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df6605145b454de69ec5492e8d78e93c

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: false
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: true
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: null

Fields:

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

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata