Name: Pavement Inspections

Display Field: streetname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cc47aa1132a744dd93c87227ef7c2490

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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

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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• parent_guid ( type: esriFieldTypeGUID, alias: Parent GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parent_guid )
• asset_id ( type: esriFieldTypeInteger, alias: Asset ID, editable: true, nullable: true, defaultValue: null, modelName: asset_id , Range: [0, 2147483647] )
• gis_id ( type: esriFieldTypeInteger, alias: GIS ID, editable: true, nullable: true, defaultValue: null, modelName: gis_id , Range: [0, 2147483647] )
• dot_segid ( type: esriFieldTypeString, alias: DOT SegID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: dot_segid )
• pvmntid ( type: esriFieldTypeInteger, alias: Pavement ID, editable: true, nullable: true, defaultValue: null, modelName: pvmntid , Range: [0, 2147483647] )
• streetname ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: streetname )
• start_position ( type: esriFieldTypeString, alias: Start Position, editable: true, nullable: true, length: 255, defaultValue: null, modelName: start_position )
• end_position ( type: esriFieldTypeString, alias: End_Position, editable: true, nullable: true, length: 255, defaultValue: null, modelName: end_position )
• pci ( type: esriFieldTypeDouble, alias: PCI Rating, editable: true, nullable: true, defaultValue: null, modelName: pci , Range: [0, 100] )
• pci_date ( type: esriFieldTypeDate, alias: PCI Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: pci_date )
• pci_year ( type: esriFieldTypeInteger, alias: PCI Year, editable: true, nullable: true, defaultValue: null, modelName: pci_year , Range: [1900, 2100] )
• pci_month ( type: esriFieldTypeInteger, alias: PCI Month, editable: true, nullable: true, defaultValue: null, modelName: pci_month , Range: [1, 12] )
• pci_m_y ( type: esriFieldTypeInteger, alias: PCI Y/M, editable: true, nullable: true, defaultValue: null, modelName: pci_m_y )
• paser ( type: esriFieldTypeDouble, alias: PASER Rating, editable: true, nullable: true, defaultValue: null, modelName: paser , Range: [0, 10] )
• paser_date ( type: esriFieldTypeDate, alias: PASER Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: paser_date )
• paser_year ( type: esriFieldTypeInteger, alias: PASER Year, editable: true, nullable: true, defaultValue: null, modelName: paser_year , Range: [1900, 2100] )
• paser_month ( type: esriFieldTypeInteger, alias: PASER Month, editable: true, nullable: true, defaultValue: null, modelName: paser_month , Range: [1, 12] )
• paser_y_m ( type: esriFieldTypeInteger, alias: PASER Y/M, editable: true, nullable: true, defaultValue: null, modelName: paser_y_m )
• curb_cond_l ( type: esriFieldTypeInteger, alias: Curb Condition (L), editable: true, nullable: true, defaultValue: null, modelName: curb_cond_l )
• curb_cond_r ( type: esriFieldTypeInteger, alias: Curb Condition (R), editable: true, nullable: true, defaultValue: null, modelName: curb_cond_r )
• inspection_notes ( type: esriFieldTypeString, alias: Inspection Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: inspection_notes )
• asset_status ( type: esriFieldTypeString, alias: Asset Status, editable: true, nullable: true, length: 100, defaultValue: null, modelName: asset_status , Coded Values: [In-service: In-service] , [Removed: Removed] , [Unassumed: Unassumed] , ...1 more... )
• functional_class ( type: esriFieldTypeString, alias: Functional Class, editable: true, nullable: true, length: 100, defaultValue: null, modelName: functional_class , Coded Values: [collector: Collector] , [freeway: Freeway] , [local: Local] , ...2 more... )
• roadside_environment ( type: esriFieldTypeString, alias: Roadside Environment, editable: true, nullable: true, length: 100, defaultValue: null, modelName: roadside_environment , Coded Values: [rural: Rural] , [semi_urban: Semi-Urban] , [urban: Urban] )
• number_of_lanes ( type: esriFieldTypeInteger, alias: # Lanes, editable: true, nullable: true, defaultValue: null, modelName: number_of_lanes , Range: [0, 2147483647] )
• service_type ( type: esriFieldTypeString, alias: Service Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: service_type , Coded Values: [Industrial: Industrial] , [Residential: Residential] , [Commercial: Commercial] )
• surface_type ( type: esriFieldTypeString, alias: Surface Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: surface_type , Coded Values: [composite: Composite] , [concrete: Concrete] , [earth: Earth] , ...4 more... )
• main_source_of_distress ( type: esriFieldTypeString, alias: Main Src of Distress, editable: true, nullable: true, length: 100, defaultValue: null, modelName: main_source_of_distress , Coded Values: [Cracking: Cracking] , [Defects: Defects] , [Deformation: Deformation] )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• rel_feat_search ( type: esriFieldTypeString, alias: Rel Feat Search, editable: true, nullable: true, length: 255, defaultValue: null, modelName: rel_feat_search )

Templates:

• Name: Pavement Inspections
  Description:
  Prototype:
  main_source_of_distress: null
  rel_feat_search: null
  parent_guid: null
  asset_id: null
  gis_id: null
  dot_segid: null
  pvmntid: null
  streetname: null
  start_position: null
  end_position: null
  pci: null
  pci_date: null
  pci_year: null
  pci_month: null
  pci_m_y: null
  paser: null
  paser_date: null
  paser_year: null
  paser_month: null
  paser_y_m: null
  curb_cond_l: null
  curb_cond_r: null
  inspection_notes: null
  asset_status: null
  functional_class: null
  roadside_environment: null
  number_of_lanes: null
  service_type: null
  surface_type: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PavementCL_Feature (1) -- Related To: Paser Ratings (17)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: 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: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Analytic   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata