Name: Pavement Defects

Display Field: Name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: d338823547fb448c93c4ff910af07101

Copyright Text:

Default Visibility: false

MaxRecordCount: 20000

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:

• Area_of_Base_Pavement_Repair_sq ( type: esriFieldTypeDouble, alias: Total area requiring base repair Sqft, editable: true, nullable: true, defaultValue: null, modelName: Area_of_Base_Pavement_Repair_sq )
• PavementID ( type: esriFieldTypeString, alias: Unique Pavement ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PavementID )
• Name ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Name )
• PCI ( type: esriFieldTypeDouble, alias: Pavement Condition Index, editable: true, nullable: true, defaultValue: null, modelName: PCI )
• Subgrade_Structure_Support ( type: esriFieldTypeString, alias: Structural Index, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Subgrade_Structure_Support , Coded Values: [1: Strong] , [2: Moderate] , [3: Weak] )
• Rehab_Recommendations ( type: esriFieldTypeString, alias: Defect Driven Rehabilitation Recommendation, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Rehab_Recommendations )
• Alligator_Low_ft2 ( type: esriFieldTypeDouble, alias: Total area of low severity alligator cracking SqFt, editable: true, nullable: true, defaultValue: null, modelName: Alligator_Low_ft2 )
• Alligator_Low_Density ( type: esriFieldTypeString, alias: Percent of low severity alligator cracking per segment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Alligator_Low_Density )
• Alligator_Mod_ft2 ( type: esriFieldTypeDouble, alias: Total area of moderate severity alligator cracking SqFt, editable: true, nullable: true, defaultValue: null, modelName: Alligator_Mod_ft2 )
• Alligator_Mod_Density ( type: esriFieldTypeString, alias: Percent of moderate severity alligator cracking per segment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Alligator_Mod_Density )
• Alligator_High_ft2 ( type: esriFieldTypeDouble, alias: Total area of high severity alligator cracking SqFt, editable: true, nullable: true, defaultValue: null, modelName: Alligator_High_ft2 )
• Alligator_High_Density ( type: esriFieldTypeString, alias: Percent of high severity alligator cracking per segment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Alligator_High_Density )
• Block_Low_ft2 ( type: esriFieldTypeDouble, alias: Total area of low severity block cracking SqFt, editable: true, nullable: true, defaultValue: null, modelName: Block_Low_ft2 )
• Block_Low_Density ( type: esriFieldTypeString, alias: Percent of low severity block cracking per segment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Block_Low_Density )
• Block_Mod_ft2 ( type: esriFieldTypeDouble, alias: Total area of moderate severity block cracking SqFt, editable: true, nullable: true, defaultValue: null, modelName: Block_Mod_ft2 )
• Block_Mod_Density ( type: esriFieldTypeString, alias: Block_Mod_Density, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Block_Mod_Density )
• Block_High_ft2 ( type: esriFieldTypeDouble, alias: Total area of high severity block cracking SqFt, editable: true, nullable: true, defaultValue: null, modelName: Block_High_ft2 )
• Block_High_Density ( type: esriFieldTypeString, alias: Block_High_Density, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Block_High_Density )
• LongTrans_Low_ft ( type: esriFieldTypeDouble, alias: Total area of low severity longitudinal & transverse cracking cracking SqFt, editable: true, nullable: true, defaultValue: null, modelName: LongTrans_Low_ft )
• LongTrans_Mod_ft ( type: esriFieldTypeDouble, alias: Total area of moderate severity longitudinal & transverse cracking cracking SqFt, editable: true, nullable: true, defaultValue: null, modelName: LongTrans_Mod_ft )
• LongTrans_High_ft ( type: esriFieldTypeDouble, alias: Total area of high severity longitudinal & transverse cracking cracking SqFt, editable: true, nullable: true, defaultValue: null, modelName: LongTrans_High_ft )
• Edge_Low_ft ( type: esriFieldTypeDouble, alias: Total area of low severity edge cracking SqFt, editable: true, nullable: true, defaultValue: null, modelName: Edge_Low_ft )
• Edge_Mod_ft ( type: esriFieldTypeDouble, alias: Total area of Moderate severity edge cracking SqFt, editable: true, nullable: true, defaultValue: null, modelName: Edge_Mod_ft )
• Edge_High_ft ( type: esriFieldTypeDouble, alias: Total area of high severity edge cracking SqFt, editable: true, nullable: true, defaultValue: null, modelName: Edge_High_ft )
• Pothole_Low ( type: esriFieldTypeDouble, alias: Count of low severity potholes, editable: true, nullable: true, defaultValue: null, modelName: Pothole_Low )
• Pothole_Mod ( type: esriFieldTypeDouble, alias: Count of moderate severity potholes, editable: true, nullable: true, defaultValue: null, modelName: Pothole_Mod )
• Pothole_High ( type: esriFieldTypeDouble, alias: Count of high severity potholes, editable: true, nullable: true, defaultValue: null, modelName: Pothole_High )
• PatchingUtilityCuts_Low_ft2 ( type: esriFieldTypeDouble, alias: Total area of low severity patching & utility cuts SqFt, editable: true, nullable: true, defaultValue: null, modelName: PatchingUtilityCuts_Low_ft2 )
• PatchingUtilityCuts_Mod_ft2 ( type: esriFieldTypeDouble, alias: Total area of moderate severity patching & utility cuts SqFt, editable: true, nullable: true, defaultValue: null, modelName: PatchingUtilityCuts_Mod_ft2 )
• PatchingUtilityCuts_High_ft2 ( type: esriFieldTypeDouble, alias: Total area of high severity patching & utility cuts SqFt, editable: true, nullable: true, defaultValue: null, modelName: PatchingUtilityCuts_High_ft2 )
• Raveling_Mod_ft2 ( type: esriFieldTypeDouble, alias: Total area of moderate severity raveling SqFt, editable: true, nullable: true, defaultValue: null, modelName: Raveling_Mod_ft2 )
• Raveling_High_ft2 ( type: esriFieldTypeDouble, alias: Total area of high severity raveling SqFt, editable: true, nullable: true, defaultValue: null, modelName: Raveling_High_ft2 )
• Rutting_Low_ft2 ( type: esriFieldTypeDouble, alias: Total area of low severity rutting SqFt, editable: true, nullable: true, defaultValue: null, modelName: Rutting_Low_ft2 )
• Rutting_Low_Density ( type: esriFieldTypeString, alias: Percent of low severity rutting per segment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Rutting_Low_Density )
• Rutting_Mod_ft2 ( type: esriFieldTypeDouble, alias: Total area of moderate severity rutting SqFt, editable: true, nullable: true, defaultValue: null, modelName: Rutting_Mod_ft2 )
• Rutting_Mod_Density ( type: esriFieldTypeString, alias: Percent of moderate severity rutting per segment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Rutting_Mod_Density )
• Rutting_High_ft2 ( type: esriFieldTypeDouble, alias: Total area of high severity rutting SqFt, editable: true, nullable: true, defaultValue: null, modelName: Rutting_High_ft2 )
• Rutting_High_Density ( type: esriFieldTypeString, alias: Percent of high severity rutting per segment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Rutting_High_Density )
• Patching_Large_UtilityCuts_Low ( type: esriFieldTypeSmallInteger, alias: Count of low severity patching (Large) & utility cuts, editable: true, nullable: true, defaultValue: null, modelName: Patching_Large_UtilityCuts_Low )
• Patching_Large_UtilityCuts_Mod ( type: esriFieldTypeSmallInteger, alias: Count of moderate severity patching (Large) & utility cuts, editable: true, nullable: true, defaultValue: null, modelName: Patching_Large_UtilityCuts_Mod )
• Patching_Large_UtilityCuts_High ( type: esriFieldTypeSmallInteger, alias: Count of high severity patching (Large) & utility cuts, editable: true, nullable: true, defaultValue: null, modelName: Patching_Large_UtilityCuts_High )
• Patching_Small_Low ( type: esriFieldTypeSmallInteger, alias: Count of low severity patching (Small) & utility cuts, editable: true, nullable: true, defaultValue: null, modelName: Patching_Small_Low )
• Patching_Small_Mod ( type: esriFieldTypeSmallInteger, alias: Count of moderate severity patching (Small) & utility cuts, editable: true, nullable: true, defaultValue: null, modelName: Patching_Small_Mod )
• Patching_Small_High ( type: esriFieldTypeSmallInteger, alias: Count of high severity patching (Small) & utility cuts, editable: true, nullable: true, defaultValue: null, modelName: Patching_Small_High )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• PavementGUID ( type: esriFieldTypeGUID, alias: Pavement unique identifier for relationships, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PavementGUID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• DateSurveyed ( type: esriFieldTypeDate, alias: Date Pavement surveyed for defects, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateSurveyed )

Templates:

• Name: Pavement Defects
  Description:
  Prototype:
  PavementGUID: null
  Area_of_Base_Pavement_Repair_sq: null
  PavementID: null
  Name: null
  PCI: null
  Subgrade_Structure_Support: null
  Rehab_Recommendations: null
  Alligator_Low_ft2: null
  Alligator_Low_Density: null
  Alligator_Mod_ft2: null
  Alligator_Mod_Density: null
  Alligator_High_ft2: null
  Alligator_High_Density: null
  Block_Low_ft2: null
  Block_Low_Density: null
  Block_Mod_ft2: null
  Block_Mod_Density: null
  Block_High_ft2: null
  Block_High_Density: null
  LongTrans_Low_ft: null
  LongTrans_Mod_ft: null
  LongTrans_High_ft: null
  Edge_Low_ft: null
  Edge_Mod_ft: null
  Edge_High_ft: null
  Pothole_Low: null
  Pothole_Mod: null
  Pothole_High: null
  PatchingUtilityCuts_Low_ft2: null
  PatchingUtilityCuts_Mod_ft2: null
  PatchingUtilityCuts_High_ft2: null
  Raveling_Mod_ft2: null
  Raveling_High_ft2: null
  Rutting_Low_ft2: null
  Rutting_Low_Density: null
  Rutting_Mod_ft2: null
  Rutting_Mod_Density: null
  Rutting_High_ft2: null
  Rutting_High_Density: null
  Patching_Large_UtilityCuts_Low: null
  Patching_Large_UtilityCuts_Mod: null
  Patching_Large_UtilityCuts_High: null
  Patching_Small_Low: null
  Patching_Small_Mod: null
  Patching_Small_High: null
  DateSurveyed: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Pavements (9) -- Related To: Pavement by Owner (19)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

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