Name: Pavement Ratings

Display Field: subsegName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 8876fd09ba8f4bffb001abf70d7fce40

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• subsegID ( type: esriFieldTypeString, alias: Subsegment ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: subsegID )
• subsegName ( type: esriFieldTypeString, alias: Subsegment Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: subsegName )
• subsegFrom ( type: esriFieldTypeString, alias: Subsegment From, editable: true, nullable: true, length: 50, defaultValue: null, modelName: subsegFrom )
• subsegTo ( type: esriFieldTypeString, alias: Subsegment To, editable: true, nullable: true, length: 50, defaultValue: null, modelName: subsegTo )
• aadt ( type: esriFieldTypeString, alias: AADT, editable: true, nullable: true, length: 75, defaultValue: null, modelName: aadt )
• alis ( type: esriFieldTypeSmallInteger, alias: Alligator Fatigue Cracking Severity, editable: true, nullable: true, defaultValue: null, modelName: alis , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• alid ( type: esriFieldTypeSmallInteger, alias: Alligator Fatigue Cracking Density, editable: true, nullable: true, defaultValue: null, modelName: alid , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• bles ( type: esriFieldTypeSmallInteger, alias: Bleeding Severity, editable: true, nullable: true, defaultValue: null, modelName: bles , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• bled ( type: esriFieldTypeSmallInteger, alias: Bleeding Density, editable: true, nullable: true, defaultValue: null, modelName: bled , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• blos ( type: esriFieldTypeSmallInteger, alias: Block Cracking Severity, editable: true, nullable: true, defaultValue: null, modelName: blos , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• blod ( type: esriFieldTypeSmallInteger, alias: Block Cracking Density, editable: true, nullable: true, defaultValue: null, modelName: blod , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• bums ( type: esriFieldTypeSmallInteger, alias: Bumps & Sags Severity, editable: true, nullable: true, defaultValue: null, modelName: bums , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• bumd ( type: esriFieldTypeSmallInteger, alias: Bumps & Sags Density, editable: true, nullable: true, defaultValue: null, modelName: bumd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• deps ( type: esriFieldTypeSmallInteger, alias: Depression Serverity, editable: true, nullable: true, defaultValue: null, modelName: deps , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• depd ( type: esriFieldTypeSmallInteger, alias: Bumps & Sags Density, editable: true, nullable: true, defaultValue: null, modelName: depd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• edgs ( type: esriFieldTypeSmallInteger, alias: Edge Cracking Severity, editable: true, nullable: true, defaultValue: null, modelName: edgs , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• edgd ( type: esriFieldTypeSmallInteger, alias: Edge Cracking Density, editable: true, nullable: true, defaultValue: null, modelName: edgd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• jois ( type: esriFieldTypeSmallInteger, alias: Joint Reflection Cracking Severity, editable: true, nullable: true, defaultValue: null, modelName: jois , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• joid ( type: esriFieldTypeSmallInteger, alias: Joint Reflection Cracking Density, editable: true, nullable: true, defaultValue: null, modelName: joid , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• lans ( type: esriFieldTypeSmallInteger, alias: Lane/Shoulder Drop Off Severity, editable: true, nullable: true, defaultValue: null, modelName: lans , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• land ( type: esriFieldTypeSmallInteger, alias: Lane/Shoulder Drop Off Density, editable: true, nullable: true, defaultValue: null, modelName: land , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• lons ( type: esriFieldTypeSmallInteger, alias: Longitudinal Traverse Severity, editable: true, nullable: true, defaultValue: null, modelName: lons , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lond ( type: esriFieldTypeSmallInteger, alias: Longitudinal Traverse Density, editable: true, nullable: true, defaultValue: null, modelName: lond , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• pats ( type: esriFieldTypeSmallInteger, alias: Patching & Utility Cuts Severity, editable: true, nullable: true, defaultValue: null, modelName: pats , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• patd ( type: esriFieldTypeSmallInteger, alias: Patching & Utility Cuts Density, editable: true, nullable: true, defaultValue: null, modelName: patd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• pols ( type: esriFieldTypeSmallInteger, alias: Polished Aggregate Severity, editable: true, nullable: true, defaultValue: null, modelName: pols , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• pold ( type: esriFieldTypeSmallInteger, alias: Polished Aggregate Density, editable: true, nullable: true, defaultValue: null, modelName: pold , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• pots ( type: esriFieldTypeSmallInteger, alias: Pothole Severity, editable: true, nullable: true, defaultValue: null, modelName: pots , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• potd ( type: esriFieldTypeSmallInteger, alias: Pothole Density, editable: true, nullable: true, defaultValue: null, modelName: potd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• ravs ( type: esriFieldTypeSmallInteger, alias: Raveling & Weathering Severity, editable: true, nullable: true, defaultValue: null, modelName: ravs , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• ravd ( type: esriFieldTypeSmallInteger, alias: Raveling & Weathering Density, editable: true, nullable: true, defaultValue: null, modelName: ravd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• ruts ( type: esriFieldTypeSmallInteger, alias: Rutting Severity, editable: true, nullable: true, defaultValue: null, modelName: ruts , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• rutd ( type: esriFieldTypeSmallInteger, alias: Rutting Density, editable: true, nullable: true, defaultValue: null, modelName: rutd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• shos ( type: esriFieldTypeSmallInteger, alias: Shoving & Slippage Cracking Severity, editable: true, nullable: true, defaultValue: null, modelName: shos , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• shod ( type: esriFieldTypeSmallInteger, alias: Shoving & Slippage Cracking Density, editable: true, nullable: true, defaultValue: null, modelName: shod , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• blows ( type: esriFieldTypeSmallInteger, alias: Blow-Ups (Buckling) Severity, editable: true, nullable: true, defaultValue: null, modelName: blows , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• blowd ( type: esriFieldTypeSmallInteger, alias: Blow-Ups (Buckling) Density, editable: true, nullable: true, defaultValue: null, modelName: blowd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• corns ( type: esriFieldTypeSmallInteger, alias: Corner Break Severity, editable: true, nullable: true, defaultValue: null, modelName: corns , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• cornd ( type: esriFieldTypeSmallInteger, alias: Corner Break Density, editable: true, nullable: true, defaultValue: null, modelName: cornd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• curbs ( type: esriFieldTypeSmallInteger, alias: Curb Shoulder Deformation Severity, editable: true, nullable: true, defaultValue: null, modelName: curbs , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• curbd ( type: esriFieldTypeSmallInteger, alias: Curb Shoulder Deformation Density, editable: true, nullable: true, defaultValue: null, modelName: curbd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• dcras ( type: esriFieldTypeSmallInteger, alias: D-Cracking Severity, editable: true, nullable: true, defaultValue: null, modelName: dcras , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• dcrad ( type: esriFieldTypeSmallInteger, alias: D-Cracking Density, editable: true, nullable: true, defaultValue: null, modelName: dcrad , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• fauls ( type: esriFieldTypeSmallInteger, alias: Faulting Severity, editable: true, nullable: true, defaultValue: null, modelName: fauls , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• fauld ( type: esriFieldTypeSmallInteger, alias: Faulting Density, editable: true, nullable: true, defaultValue: null, modelName: fauld , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• ltcrs ( type: esriFieldTypeSmallInteger, alias: Longitudinal/Transverse Cracking Severity, editable: true, nullable: true, defaultValue: null, modelName: ltcrs , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• ltcrd ( type: esriFieldTypeSmallInteger, alias: Longitudinal/Transverse Cracking Density, editable: true, nullable: true, defaultValue: null, modelName: ltcrd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• patcs ( type: esriFieldTypeSmallInteger, alias: Patching & Utility Cuts Severity, editable: true, nullable: true, defaultValue: null, modelName: patcs , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• patcd ( type: esriFieldTypeSmallInteger, alias: Patching & Utility Cuts Densit, editable: true, nullable: true, defaultValue: null, modelName: patcd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• popos ( type: esriFieldTypeSmallInteger, alias: Pop-Outs/MapCracking/Scaling Severity, editable: true, nullable: true, defaultValue: null, modelName: popos , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• popod ( type: esriFieldTypeSmallInteger, alias: Pop-Outs/MapCracking/Scaling Density, editable: true, nullable: true, defaultValue: null, modelName: popod , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• pumps ( type: esriFieldTypeSmallInteger, alias: Pumping Severity, editable: true, nullable: true, defaultValue: null, modelName: pumps , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• pumpd ( type: esriFieldTypeSmallInteger, alias: Pumping Density, editable: true, nullable: true, defaultValue: null, modelName: pumpd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• shats ( type: esriFieldTypeSmallInteger, alias: Shattered Slab Severity, editable: true, nullable: true, defaultValue: null, modelName: shats , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• shatd ( type: esriFieldTypeSmallInteger, alias: Shattered Slab Density, editable: true, nullable: true, defaultValue: null, modelName: shatd , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• spals ( type: esriFieldTypeSmallInteger, alias: Spalling Severity, editable: true, nullable: true, defaultValue: null, modelName: spals , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• spald ( type: esriFieldTypeSmallInteger, alias: Spalling Density, editable: true, nullable: true, defaultValue: null, modelName: spald , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• rehabSuggested ( type: esriFieldTypeString, alias: Suggested Rehab, editable: true, nullable: true, length: 75, defaultValue: null, modelName: rehabSuggested , Coded Values: [Reconstruction: Reconstruction] , [Mill & Overlay: Mill & Overlay] , [Cape Seal: Cape Seal] , ...2 more... )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes )
• parent_guid ( type: esriFieldTypeGUID, alias: Parent GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parent_guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• inspection_date ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspection_date )
• pci ( type: esriFieldTypeSmallInteger, alias: pci, editable: true, nullable: true, defaultValue: null, modelName: pci )
• cbv ( type: esriFieldTypeSmallInteger, alias: cbv, editable: true, nullable: true, defaultValue: null, modelName: cbv )
• pavement_rehab ( type: esriFieldTypeString, alias: Pavement Rehab, editable: true, nullable: true, length: 75, defaultValue: null, modelName: pavement_rehab , Coded Values: [Reconstruction: Reconstruction] , [Mill & Overlay: Mill & Overlay] , [Cape Seal: Cape Seal] , ...2 more... )
• pavement_type ( type: esriFieldTypeInteger, alias: Pavement Type, editable: true, nullable: true, defaultValue: null, modelName: pavement_type , Coded Values: [1: Asphalt] , [2: Concrete] , [3: Composite] , ...7 more... )
• RoadLength ( type: esriFieldTypeDouble, alias: RoadLength, editable: true, nullable: true, defaultValue: null, modelName: RoadLength )
• RoadArea ( type: esriFieldTypeDouble, alias: RoadArea, editable: true, nullable: true, defaultValue: null, modelName: RoadArea )
• Sidewalks ( type: esriFieldTypeSmallInteger, alias: Sidewalk, editable: true, nullable: true, defaultValue: null, modelName: Sidewalks )

Templates:

• Name: Pavement Ratings
  Description:
  Prototype:
  RoadArea: null
  RoadLength: null
  subsegID: null
  subsegName: null
  subsegFrom: null
  subsegTo: null
  aadt: null
  alis: null
  alid: null
  bles: null
  bled: null
  blos: null
  blod: null
  bums: null
  bumd: null
  deps: null
  depd: null
  edgs: null
  edgd: null
  jois: null
  joid: null
  lans: null
  land: null
  lons: null
  lond: null
  pats: null
  patd: null
  pols: null
  pold: null
  pots: null
  potd: null
  ravs: null
  ravd: null
  ruts: null
  rutd: null
  shos: null
  shod: null
  blows: null
  blowd: null
  corns: null
  cornd: null
  curbs: null
  curbd: null
  dcras: null
  dcrad: null
  fauls: null
  fauld: null
  ltcrs: null
  ltcrd: null
  patcs: null
  patcd: null
  popos: null
  popod: null
  pumps: null
  pumpd: null
  shats: null
  shatd: null
  spals: null
  spald: null
  rehabSuggested: null
  notes: null
  parent_guid: null
  Sidewalks: null
  pavement_type: null
  pavement_rehab: null
  cbv: null
  pci: null
  inspection_date: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.Pavement_Type (0) -- Related To: Pavement_Type (1)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: 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

Child Resources:   Field Groups   Contingent Values

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