Name: Asphalt Event History Related Table

Display Field: EventType

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 204a0ae75bcc4381b550024a676bc212

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• RelatedGlobalID ( type: esriFieldTypeGUID, alias: RelatedGlobalID, length: 38 )
• EventType ( type: esriFieldTypeString, alias: Event Type, length: 255 )
• EventDate ( type: esriFieldTypeDate, alias: Event Date, length: 8 )
• WorkDoneBy ( type: esriFieldTypeString, alias: Work Done By, length: 255 )
• MaintenanceType ( type: esriFieldTypeString, alias: Maintenance Type, length: 255 , Coded Values: [1" Overlay: 1" Overlay] , [1.5" Overlay: 1.5" Overlay] , [2" Overlay: 2" Overlay] , ...18 more... )
• AreaSqFt ( type: esriFieldTypeDouble, alias: Area (sqft) )
• Class ( type: esriFieldTypeString, alias: Class, length: 255 , Coded Values: [Local: Local] , [Commercial Local: Commercial Local] , [Minor Collector: Minor Collector] , ...12 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• LinkedFiles ( type: esriFieldTypeString, alias: Linked Files, length: 255 )
• OverlayTons ( type: esriFieldTypeSmallInteger, alias: Overlay (tons) )
• LaneLevelingTons ( type: esriFieldTypeSmallInteger, alias: Lane Leveling (tons) )
• TreesTrimmed ( type: esriFieldTypeSmallInteger, alias: Trees Trimmed )
• CrackRating ( type: esriFieldTypeSmallInteger, alias: Crack Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...11 more... )
• CrackRatingDescription ( type: esriFieldTypeString, alias: Crack Rating Description, length: 255 , Coded Values: [Heavy Alligator Cracking: Heavy Alligator Cracking] , [Light Alligator Cracking: Light Alligator Cracking] , [Transverse & Longitudinal Cracking: Transverse & Longitudinal Cracking] , ...2 more... )
• CrackSealRating ( type: esriFieldTypeSmallInteger, alias: Crack Seal Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...11 more... )
• CrackSealDescription ( type: esriFieldTypeString, alias: Crack Seal Description, length: 255 , Coded Values: [Sealed but Alligatoring: Sealed but Alligatoring] , [Sealed with Heavy Cracking: Sealed with Heavy Cracking] , [Sealed with Light Cracking: Sealed with Light Cracking] , ...4 more... )
• SealRating ( type: esriFieldTypeSmallInteger, alias: Seal Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...11 more... )
• SealRatingDescription ( type: esriFieldTypeString, alias: Seal Rating Description, length: 255 , Coded Values: [No Seal: No Seal] , [Seal in Poor Condition: Seal in Poor Condition] , [Seal in Fair Condition: Seal in Fair Condition] , ...2 more... )
• SmoothnessRating ( type: esriFieldTypeSmallInteger, alias: Smoothness Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...11 more... )
• SmoothnessRatingDescription ( type: esriFieldTypeString, alias: Smoothness Rating Description, length: 255 , Coded Values: [Rough and Needs Replacement: Rough and Needs Replacement] , [Significant Bumps, Settling & Recurring Pot Holes: Significant Bumps, Settling & Recurring Pot Holes] , [Moderate Bumps or Settling: Moderate Bumps or Settling] , ...2 more... )
• TotalRating ( type: esriFieldTypeSmallInteger, alias: Total Rating )

Relationships:

• DBO.Asphalt (4) -- Related To: Asphalt (1)

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

  Iteminfo   Thumbnail   Metadata