Name: Asphalt Event History Related Table

Display Field: EventType

Type: Table

Geometry Type: N/A

Description:

Service Item Id: d2ec778d35a34e2a96f2cb49e173adad

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: 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 )
• RelatedGlobalID ( type: esriFieldTypeGUID, alias: RelatedGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelatedGlobalID )
• EventType ( type: esriFieldTypeString, alias: Event Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EventType )
• EventDate ( type: esriFieldTypeDate, alias: Event Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EventDate )
• WorkDoneBy ( type: esriFieldTypeString, alias: Work Done By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WorkDoneBy )
• MaintenanceType ( type: esriFieldTypeString, alias: Maintenance Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaintenanceType , Coded Values: [1" Overlay: 1" Overlay] , [1.5" Overlay: 1.5" Overlay] , [2" Overlay: 2" Overlay] , ...18 more... )
• AreaSqFt ( type: esriFieldTypeDouble, alias: Area (sqft), editable: true, nullable: true, defaultValue: null, modelName: AreaSqFt )
• Class ( type: esriFieldTypeString, alias: Class, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Class , Coded Values: [Local: Local] , [Commercial Local: Commercial Local] , [Minor Collector: Minor Collector] , ...12 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• LinkedFiles ( type: esriFieldTypeString, alias: Linked Files, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LinkedFiles )
• OverlayTons ( type: esriFieldTypeSmallInteger, alias: Overlay (tons), editable: true, nullable: true, defaultValue: null, modelName: OverlayTons )
• LaneLevelingTons ( type: esriFieldTypeSmallInteger, alias: Lane Leveling (tons), editable: true, nullable: true, defaultValue: null, modelName: LaneLevelingTons )
• TreesTrimmed ( type: esriFieldTypeSmallInteger, alias: Trees Trimmed, editable: true, nullable: true, defaultValue: null, modelName: TreesTrimmed )
• CrackRating ( type: esriFieldTypeSmallInteger, alias: Crack Rating, editable: true, nullable: true, defaultValue: null, modelName: CrackRating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...11 more... )
• CrackRatingDescription ( type: esriFieldTypeString, alias: Crack Rating Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CrackRatingDescription , 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, editable: true, nullable: true, defaultValue: null, modelName: CrackSealRating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...11 more... )
• CrackSealDescription ( type: esriFieldTypeString, alias: Crack Seal Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CrackSealDescription , 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, editable: true, nullable: true, defaultValue: null, modelName: SealRating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...11 more... )
• SealRatingDescription ( type: esriFieldTypeString, alias: Seal Rating Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SealRatingDescription , 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, editable: true, nullable: true, defaultValue: null, modelName: SmoothnessRating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...11 more... )
• SmoothnessRatingDescription ( type: esriFieldTypeString, alias: Smoothness Rating Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SmoothnessRatingDescription , 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, editable: true, nullable: true, defaultValue: 1, modelName: TotalRating )

Templates:

• Name: Asphalt Event History Related Table
  Description:
  Prototype:
  SmoothnessRatingDescription: null
  TotalRating: 1
  RelatedGlobalID: null
  EventType: null
  EventDate: null
  WorkDoneBy: null
  MaintenanceType: null
  AreaSqFt: null
  Class: null
  Notes: null
  LinkedFiles: null
  OverlayTons: null
  LaneLevelingTons: null
  TreesTrimmed: null
  CrackRating: null
  CrackRatingDescription: null
  CrackSealRating: null
  CrackSealDescription: null
  SealRating: null
  SealRatingDescription: null
  SmoothnessRating: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

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