View In:   ArcGIS Online Map Viewer

Name: City Streets PCI (2019)

Display Field: Street_Name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This centerline feature class contains pavement data for the roadways maintained by the City of Gaithersburg, MD. This includes IRI (AVG_IRI), rutting (RUT1, RUT2, representing rutting in each wheel path), PCI (Pavement Condition Index) for each segment, and the density percentage for each distress class (PCT_CLIMATE, PCT_STRUCTURAL and PCT_CONSTRUCTABLILITY). The Pavement Condition Index (PCI) was calculated utilizing VUEWorks® Asset Management Software (AMS). This AMS is based on the ASTM D6433 method of calculating a street segment’s pavement condition index value. ASTM D6433 is based on a 0 to 100 rating scale where 0 represents a failed roadway condition and 100 represent an excellent roadway condition.Typical PCI score and associated conditions are as follows:86-100 = Good71-85 = Satisfactory56-70 = Fair41-55 = Poor26-40 = Very Poor11-25 = Serious0-10 = FailedThe International Roughness Index (IRI) is the roughness index most commonly obtained from measured longitudinal road profiles. It is calculated using a surface profiling system with units of slope (inches/mile)Typica IRI ranges are as follows:<=127 = Excellent128-154 = Good155-240 = Fair241-489 = Marginal490-625 = Poor>625 = Very PoorRutting is a surface depression in the wheel path. Rutting steams from a pavement deformation in any of the pavement layers or subgrades. This is usually caused by consolidated or lateral movement of the materials due to traffic load. Typica Rutting ranges are as follows:1/4-1/2 = Low>1/2-1 = Medium>1 = High

Copyright Text: Data Transfer Solutions, 2019

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1241158.9097587615
YMin: 523266.342498675
XMax: 1263630.887452513
YMax: 546572.8634708375
Spatial Reference: 2893  (2893)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Pavement_Rating
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Good
  Label: Good
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 92, 230, 255]
  Width: 2
• Value: Satisfactory
  Label: Satisfactory
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 2
• Value: Fair
  Label: Fair
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 2
• Value: Poor
  Label: Poor
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [255, 85, 0, 255]
  Width: 2
• Value: Failed
  Label: Failed
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [168, 0, 0, 255]
  Width: 2
Transparency: 0
Labeling Info:

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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Pavement_Rating

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PCS_ID ( type: esriFieldTypeInteger, alias: PCS_ID, editable: true, nullable: true, defaultValue: null, modelName: PCS_ID )
• Prefix_Direction ( type: esriFieldTypeString, alias: Prefix_Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Prefix_Direction )
• Street_Name ( type: esriFieldTypeString, alias: Street_Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Street_Name )
• Street_Type ( type: esriFieldTypeString, alias: Street_Type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Street_Type )
• Suffix_Direction ( type: esriFieldTypeString, alias: Suffix_Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Suffix_Direction )
• Pavement_Width ( type: esriFieldTypeInteger, alias: Pavement_Width, editable: true, nullable: true, defaultValue: null, modelName: Pavement_Width )
• Travel_Lane ( type: esriFieldTypeInteger, alias: Travel_Lane, editable: true, nullable: true, defaultValue: null, modelName: Travel_Lane )
• Full_Street ( type: esriFieldTypeString, alias: Full_Street, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Full_Street )
• City_MP2009_FunClass ( type: esriFieldTypeString, alias: City_MP2009_Functional_Class, editable: true, nullable: true, length: 24, defaultValue: null, modelName: City_MP2009_Functional_Class , Coded Values: [Freeway: Freeway] , [Major Arterial: Major Arterial] , [Arterial: Arterial] , ...4 more... )
• Maint_Responsibility ( type: esriFieldTypeString, alias: Maintenance_Responsibility, editable: true, nullable: true, length: 24, defaultValue: null, modelName: Maintenance_Responsibility , Coded Values: [Unknown: Unknown] , [Federal: Federal] , [State: State] , ...7 more... )
• ROW_Ownership ( type: esriFieldTypeString, alias: ROW_Ownership, editable: true, nullable: true, length: 24, defaultValue: null, modelName: ROW_Ownership , Coded Values: [Unknown: Unknown] , [Federal: Federal] , [State: State] , ...7 more... )
• TreatmentYear ( type: esriFieldTypeString, alias: TreatmentYear, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TreatmentYear )
• PCI_2016 ( type: esriFieldTypeInteger, alias: PCI_2016, editable: true, nullable: true, defaultValue: null, modelName: PCI_2016 )
• COLLECTED ( type: esriFieldTypeString, alias: COLLECTED, editable: true, nullable: true, length: 1, defaultValue: null, modelName: COLLECTED )
• DTS_NOTES ( type: esriFieldTypeString, alias: DTS_NOTES, editable: true, nullable: true, length: 250, defaultValue: null, modelName: DTS_NOTES )
• PAVEMENT_TYPE ( type: esriFieldTypeString, alias: PAVEMENT_TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PAVEMENT_TYPE )
• COLL_DATE ( type: esriFieldTypeString, alias: COLL_DATE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: COLL_DATE )
• L_RUT ( type: esriFieldTypeDouble, alias: L_RUT, editable: true, nullable: true, defaultValue: null, modelName: L_RUT )
• R_RUT ( type: esriFieldTypeDouble, alias: R_RUT, editable: true, nullable: true, defaultValue: null, modelName: R_RUT )
• AVG_RUT ( type: esriFieldTypeDouble, alias: AVG_RUT, editable: true, nullable: true, defaultValue: null, modelName: AVG_RUT )
• AVG_IRI ( type: esriFieldTypeDouble, alias: AVG_IRI, editable: true, nullable: true, defaultValue: null, modelName: AVG_IRI )
• PCI ( type: esriFieldTypeInteger, alias: PCI, editable: true, nullable: true, defaultValue: null, modelName: PCI )
• PCT_CLIMATE ( type: esriFieldTypeInteger, alias: PCT_CLIMATE, editable: true, nullable: true, defaultValue: null, modelName: PCT_CLIMATE )
• PCT_STRUCTURAL ( type: esriFieldTypeInteger, alias: PCT_STRUCTURAL, editable: true, nullable: true, defaultValue: null, modelName: PCT_STRUCTURAL )
• PCT_CONSTRUCTABILITY ( type: esriFieldTypeInteger, alias: PCT_CONSTRUCTABILITY, editable: true, nullable: true, defaultValue: null, modelName: PCT_CONSTRUCTABILITY )
• Pavement_Rating ( type: esriFieldTypeString, alias: Pavement_Rating, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Pavement_Rating )
• PCI_Difference ( type: esriFieldTypeInteger, alias: PCI_Difference, editable: true, nullable: true, defaultValue: null, modelName: PCI_Difference )
• PavementRating16_Dervd ( type: esriFieldTypeString, alias: PavementRating16_Dervd, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Pavement_Rating_2016_Derived )
• InstallationYear ( type: esriFieldTypeString, alias: InstallationYear, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InstallationYear )
• Lane_Miles ( type: esriFieldTypeDouble, alias: Lane_Miles, editable: true, nullable: true, defaultValue: null, modelName: Lane_Miles )
• 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 )

Types:

ID: Good
Name: Good
Domains:
• City_MP2009_FunClass:
  Inherited
• Maint_Responsibility:
  Inherited
• ROW_Ownership:
  Inherited
Templates:
• Name: Good
  Description:
  Prototype:
  Lane_Miles: null
  InstallationYear: null
  PCS_ID: null
  Prefix_Direction: null
  Street_Name: null
  Street_Type: null
  Suffix_Direction: null
  Pavement_Width: null
  Travel_Lane: null
  Full_Street: null
  City_MP2009_FunClass: null
  Maint_Responsibility: null
  ROW_Ownership: null
  TreatmentYear: null
  PCI_2016: null
  COLLECTED: null
  DTS_NOTES: null
  PAVEMENT_TYPE: null
  COLL_DATE: null
  L_RUT: null
  R_RUT: null
  AVG_RUT: null
  AVG_IRI: null
  PCI: null
  PCT_CLIMATE: null
  PCT_STRUCTURAL: null
  PCT_CONSTRUCTABILITY: null
  Pavement_Rating: Good
  PCI_Difference: null
  PavementRating16_Dervd: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Satisfactory
Name: Satisfactory
Domains:
• City_MP2009_FunClass:
  Inherited
• Maint_Responsibility:
  Inherited
• ROW_Ownership:
  Inherited
Templates:
• Name: Satisfactory
  Description:
  Prototype:
  Lane_Miles: null
  InstallationYear: null
  PCS_ID: null
  Prefix_Direction: null
  Street_Name: null
  Street_Type: null
  Suffix_Direction: null
  Pavement_Width: null
  Travel_Lane: null
  Full_Street: null
  City_MP2009_FunClass: null
  Maint_Responsibility: null
  ROW_Ownership: null
  TreatmentYear: null
  PCI_2016: null
  COLLECTED: null
  DTS_NOTES: null
  PAVEMENT_TYPE: null
  COLL_DATE: null
  L_RUT: null
  R_RUT: null
  AVG_RUT: null
  AVG_IRI: null
  PCI: null
  PCT_CLIMATE: null
  PCT_STRUCTURAL: null
  PCT_CONSTRUCTABILITY: null
  Pavement_Rating: Satisfactory
  PCI_Difference: null
  PavementRating16_Dervd: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Fair
Name: Fair
Domains:
• City_MP2009_FunClass:
  Inherited
• Maint_Responsibility:
  Inherited
• ROW_Ownership:
  Inherited
Templates:
• Name: Fair
  Description:
  Prototype:
  Lane_Miles: null
  InstallationYear: null
  PCS_ID: null
  Prefix_Direction: null
  Street_Name: null
  Street_Type: null
  Suffix_Direction: null
  Pavement_Width: null
  Travel_Lane: null
  Full_Street: null
  City_MP2009_FunClass: null
  Maint_Responsibility: null
  ROW_Ownership: null
  TreatmentYear: null
  PCI_2016: null
  COLLECTED: null
  DTS_NOTES: null
  PAVEMENT_TYPE: null
  COLL_DATE: null
  L_RUT: null
  R_RUT: null
  AVG_RUT: null
  AVG_IRI: null
  PCI: null
  PCT_CLIMATE: null
  PCT_STRUCTURAL: null
  PCT_CONSTRUCTABILITY: null
  Pavement_Rating: Fair
  PCI_Difference: null
  PavementRating16_Dervd: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Poor
Name: Poor
Domains:
• City_MP2009_FunClass:
  Inherited
• Maint_Responsibility:
  Inherited
• ROW_Ownership:
  Inherited
Templates:
• Name: Poor
  Description:
  Prototype:
  Lane_Miles: null
  InstallationYear: null
  PCS_ID: null
  Prefix_Direction: null
  Street_Name: null
  Street_Type: null
  Suffix_Direction: null
  Pavement_Width: null
  Travel_Lane: null
  Full_Street: null
  City_MP2009_FunClass: null
  Maint_Responsibility: null
  ROW_Ownership: null
  TreatmentYear: null
  PCI_2016: null
  COLLECTED: null
  DTS_NOTES: null
  PAVEMENT_TYPE: null
  COLL_DATE: null
  L_RUT: null
  R_RUT: null
  AVG_RUT: null
  AVG_IRI: null
  PCI: null
  PCT_CLIMATE: null
  PCT_STRUCTURAL: null
  PCT_CONSTRUCTABILITY: null
  Pavement_Rating: Poor
  PCI_Difference: null
  PavementRating16_Dervd: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Failed
Name: Failed
Domains:
• City_MP2009_FunClass:
  Inherited
• Maint_Responsibility:
  Inherited
• ROW_Ownership:
  Inherited
Templates:
• Name: Failed
  Description:
  Prototype:
  Lane_Miles: null
  InstallationYear: null
  PCS_ID: null
  Prefix_Direction: null
  Street_Name: null
  Street_Type: null
  Suffix_Direction: null
  Pavement_Width: null
  Travel_Lane: null
  Full_Street: null
  City_MP2009_FunClass: null
  Maint_Responsibility: null
  ROW_Ownership: null
  TreatmentYear: null
  PCI_2016: null
  COLLECTED: null
  DTS_NOTES: null
  PAVEMENT_TYPE: null
  COLL_DATE: null
  L_RUT: null
  R_RUT: null
  AVG_RUT: null
  AVG_IRI: null
  PCI: null
  PCT_CLIMATE: null
  PCT_STRUCTURAL: null
  PCT_CONSTRUCTABILITY: null
  Pavement_Rating: Failed
  PCI_Difference: null
  PavementRating16_Dervd: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

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: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata