Name: Pavement

Display Field: FROM_DATE

Type: Table

Geometry Type: N/A

Description: Table displaying pavement data for all paved ALTIS routes

Service Item Id: febcce89e68e4cc7830644d1092295a6

Copyright Text: Montana Department of Transportation

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: false
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 )
• ROUTE_ID ( type: esriFieldTypeString, alias: ROUTE ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Route_ID )
• FROM_MEASURE ( type: esriFieldTypeDouble, alias: FROM MEASURE, editable: true, nullable: true, defaultValue: null, modelName: From_Measure )
• TO_MEASURE ( type: esriFieldTypeDouble, alias: TO MEASURE, editable: true, nullable: true, defaultValue: null, modelName: To_Measure )
• DATE_ ( type: esriFieldTypeDate, alias: DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date )
• ROUTE ( type: esriFieldTypeString, alias: Route, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Route )
• DIR_DSC ( type: esriFieldTypeString, alias: Direction DSC, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Dir_DSC )
• DIR ( type: esriFieldTypeString, alias: Direction, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Dir )
• LANE ( type: esriFieldTypeInteger, alias: Lane, editable: true, nullable: true, defaultValue: null, modelName: Lane )
• FROM_ ( type: esriFieldTypeDouble, alias: From, editable: true, nullable: true, defaultValue: null, modelName: From_ )
• TO_ ( type: esriFieldTypeDouble, alias: To, editable: true, nullable: true, defaultValue: null, modelName: To )
• ROUGH_DIS ( type: esriFieldTypeDouble, alias: Rough Distance, editable: true, nullable: true, defaultValue: null, modelName: Rough_Dis )
• RUT_L_AVG ( type: esriFieldTypeDouble, alias: Rutting L Average, editable: true, nullable: true, defaultValue: null, modelName: Rut_L_Avg )
• RUT_L_STD ( type: esriFieldTypeDouble, alias: Rutting L Standard Deviation, editable: true, nullable: true, defaultValue: null, modelName: Rut_L_Std )
• RUT_R_AVG ( type: esriFieldTypeDouble, alias: Rutting R Average, editable: true, nullable: true, defaultValue: null, modelName: Rut_R_Avg )
• RUT_R_STD ( type: esriFieldTypeDouble, alias: Rutting R Standard Deviation, editable: true, nullable: true, defaultValue: null, modelName: Rut_R_Std )
• IRI_1 ( type: esriFieldTypeInteger, alias: IRI 1, editable: true, nullable: true, defaultValue: null, modelName: IRI_1 )
• IRI_2 ( type: esriFieldTypeInteger, alias: IRI 2, editable: true, nullable: true, defaultValue: null, modelName: IRI_2 )
• AVG_IRI ( type: esriFieldTypeSmallInteger, alias: Average IRI, editable: true, nullable: true, defaultValue: null, modelName: Avg_IRI )
• LATITUDEDEGREES ( type: esriFieldTypeDouble, alias: Latitude Degrees, editable: true, nullable: true, defaultValue: null, modelName: LatitudeDegrees )
• LATITUDEMINUTES ( type: esriFieldTypeDouble, alias: Latitude Minutes, editable: true, nullable: true, defaultValue: null, modelName: LatitudeMinutes )
• LONGITUDEDEGREES ( type: esriFieldTypeDouble, alias: Longitude Degrees, editable: true, nullable: true, defaultValue: null, modelName: LongitudeDegrees )
• LONGITUDEMINUTES ( type: esriFieldTypeDouble, alias: Longitude Minutes, editable: true, nullable: true, defaultValue: null, modelName: LongitudeMinutes )
• HEIGHT ( type: esriFieldTypeInteger, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: Height )
• TRACK ( type: esriFieldTypeInteger, alias: Track, editable: true, nullable: true, defaultValue: null, modelName: Track )
• SPEED ( type: esriFieldTypeDouble, alias: Speed, editable: true, nullable: true, defaultValue: null, modelName: Speed )
• TIME ( type: esriFieldTypeString, alias: Time, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Time )
• ALLIGA_LOW ( type: esriFieldTypeDouble, alias: Alligator Cracking A - Low, editable: true, nullable: true, defaultValue: null, modelName: AlligA_Low )
• ALLIGA_MED ( type: esriFieldTypeDouble, alias: Alligator Cracking A - Medium, editable: true, nullable: true, defaultValue: null, modelName: AlligA_Med )
• ALLIGA_HIGH ( type: esriFieldTypeDouble, alias: Alligator Cracking A - High, editable: true, nullable: true, defaultValue: null, modelName: AlligA_High )
• ALLIGB_LOW ( type: esriFieldTypeDouble, alias: Alligator Cracking B - Low, editable: true, nullable: true, defaultValue: null, modelName: AlligB_Low )
• ALLIGB_MED ( type: esriFieldTypeDouble, alias: Alligator Cracking B - Medium, editable: true, nullable: true, defaultValue: null, modelName: AlligB_Med )
• ALLIGB_HIGH ( type: esriFieldTypeDouble, alias: Alligator Cracking B - High, editable: true, nullable: true, defaultValue: null, modelName: AlligB_High )
• ALLIGC_LOW ( type: esriFieldTypeDouble, alias: Alligator Cracking C - Low, editable: true, nullable: true, defaultValue: null, modelName: AlligC_Low )
• ALLIGC_MED ( type: esriFieldTypeDouble, alias: Alligator Cracking C - Medium, editable: true, nullable: true, defaultValue: null, modelName: AlligC_Med )
• ALLIGC_HIGH ( type: esriFieldTypeDouble, alias: Alligator Cracking C - High, editable: true, nullable: true, defaultValue: null, modelName: AlligC_High )
• BLOCK ( type: esriFieldTypeInteger, alias: Block, editable: true, nullable: true, defaultValue: null, modelName: Block )
• TRANS_LOW ( type: esriFieldTypeDouble, alias: Trasnverse Cracking - Low, editable: true, nullable: true, defaultValue: null, modelName: Trans_Low )
• TRANS_MED ( type: esriFieldTypeDouble, alias: Trasnverse Cracking - Medium, editable: true, nullable: true, defaultValue: null, modelName: Trans_Med )
• TRANS_HIGH ( type: esriFieldTypeDouble, alias: Trasnverse Cracking - High, editable: true, nullable: true, defaultValue: null, modelName: Trans_High )
• LONG_LOW ( type: esriFieldTypeDouble, alias: Longitudinal Cracking - Low, editable: true, nullable: true, defaultValue: null, modelName: Long_Low )
• LONG_MED ( type: esriFieldTypeDouble, alias: Longitudinal Cracking - Medium, editable: true, nullable: true, defaultValue: null, modelName: Long_Med )
• LONG_HIGH ( type: esriFieldTypeDouble, alias: Longitudinal Cracking - High, editable: true, nullable: true, defaultValue: null, modelName: Long_High )
• FINE_RAVELING ( type: esriFieldTypeDouble, alias: Fine Raveling, editable: true, nullable: true, defaultValue: null, modelName: Fine_Raveling )
• COARSE_RAVELING ( type: esriFieldTypeDouble, alias: Coarse Raveling, editable: true, nullable: true, defaultValue: null, modelName: Coarse_Raveling )
• PATCH_GOOD ( type: esriFieldTypeInteger, alias: Patch Good, editable: true, nullable: true, defaultValue: null, modelName: Patch_Good )
• PATCH_FAIR ( type: esriFieldTypeInteger, alias: Patch Fair, editable: true, nullable: true, defaultValue: null, modelName: Patch_Fair )
• PATCH_POOR ( type: esriFieldTypeInteger, alias: Patch Poor, editable: true, nullable: true, defaultValue: null, modelName: Patch_Poor )
• DISTRESS_FLAG ( type: esriFieldTypeInteger, alias: Distress Flag, editable: true, nullable: true, defaultValue: null, modelName: Distress_Flag )
• FAULTING ( type: esriFieldTypeDouble, alias: Faulting, editable: true, nullable: true, defaultValue: null, modelName: Faulting )
• PAVEMENT_TYPE ( type: esriFieldTypeInteger, alias: Pavement Type, editable: true, nullable: true, defaultValue: null, modelName: Pavement_Type )
• SHOULDER_CONDITION ( type: esriFieldTypeInteger, alias: Shoulder Condition, editable: true, nullable: true, defaultValue: null, modelName: Shoulder_Condition )
• PCC_SLAB_1ST_2ND_STAGE ( type: esriFieldTypeDouble, alias: PCC Slab 1st & 2nd Stage, editable: true, nullable: true, defaultValue: null, modelName: PCC_Slab_1st_2nd_Stage )
• PCC_SLAB_3ER_STAGE ( type: esriFieldTypeDouble, alias: PCC Slab 3er Stage, editable: true, nullable: true, defaultValue: null, modelName: PCC_Slab_3er_Stage )
• PCC_SPALLING_SEVERITY ( type: esriFieldTypeString, alias: PCC Spalling Severity, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PCC_Spalling_Severity )
• PCC_SEPARATION_SEVERITY ( type: esriFieldTypeString, alias: PCC Separation Severity, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PCC_Separation_Severity )
• PCC_SHOULDER_DISPLACEMENT_UP ( type: esriFieldTypeInteger, alias: PCC Shoulder Displacement Up, editable: true, nullable: true, defaultValue: null, modelName: PCC_Shoulder_Displacement_Up )
• PCC_SHOULDER_DISPLACEMENT_DOWN ( type: esriFieldTypeInteger, alias: PCC Shoulder Displacement Down, editable: true, nullable: true, defaultValue: null, modelName: PCC_Shoulder_Displacement_Down )
• CRACKING_PERCENT ( type: esriFieldTypeDouble, alias: Cracking%, editable: true, nullable: true, defaultValue: null, modelName: Cracking_Percent )
• SURFACE_TYPE ( type: esriFieldTypeString, alias: Surface Type, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Surface_Type )
• BASE_CONDITION ( type: esriFieldTypeInteger, alias: Base Condition, editable: true, nullable: true, defaultValue: null, modelName: Base_Condition )
• SUBGRADE_CONDITION ( type: esriFieldTypeInteger, alias: Sub-Grade Condition, editable: true, nullable: true, defaultValue: null, modelName: SubGrade_Condition )
• PSR ( type: esriFieldTypeDouble, alias: Present Serviceability Rating, editable: true, nullable: true, defaultValue: null, modelName: PSR )
• AVG_RUTTING ( type: esriFieldTypeDouble, alias: Average Rutting, editable: true, nullable: true, defaultValue: null, modelName: Avg_Rutting )
• DATA_SOURCE ( type: esriFieldTypeString, alias: Data Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Data_Source )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Pavement
  Description:
  Prototype:
  DATA_SOURCE: null
  AVG_RUTTING: null
  ROUTE_ID: null
  FROM_MEASURE: null
  TO_MEASURE: null
  DATE_: null
  ROUTE: null
  DIR_DSC: null
  DIR: null
  LANE: null
  FROM_: null
  TO_: null
  ROUGH_DIS: null
  RUT_L_AVG: null
  RUT_L_STD: null
  RUT_R_AVG: null
  RUT_R_STD: null
  IRI_1: null
  IRI_2: null
  AVG_IRI: null
  LATITUDEDEGREES: null
  LATITUDEMINUTES: null
  LONGITUDEDEGREES: null
  LONGITUDEMINUTES: null
  HEIGHT: null
  TRACK: null
  SPEED: null
  TIME: null
  ALLIGA_LOW: null
  ALLIGA_MED: null
  ALLIGA_HIGH: null
  ALLIGB_LOW: null
  ALLIGB_MED: null
  ALLIGB_HIGH: null
  ALLIGC_LOW: null
  ALLIGC_MED: null
  ALLIGC_HIGH: null
  BLOCK: null
  TRANS_LOW: null
  TRANS_MED: null
  TRANS_HIGH: null
  LONG_LOW: null
  LONG_MED: null
  LONG_HIGH: null
  FINE_RAVELING: null
  COARSE_RAVELING: null
  PATCH_GOOD: null
  PATCH_FAIR: null
  PATCH_POOR: null
  DISTRESS_FLAG: null
  FAULTING: null
  PAVEMENT_TYPE: null
  SHOULDER_CONDITION: null
  PCC_SLAB_1ST_2ND_STAGE: null
  PCC_SLAB_3ER_STAGE: null
  PCC_SPALLING_SEVERITY: null
  PCC_SEPARATION_SEVERITY: null
  PCC_SHOULDER_DISPLACEMENT_UP: null
  PCC_SHOULDER_DISPLACEMENT_DOWN: null
  CRACKING_PERCENT: null
  SURFACE_TYPE: null
  BASE_CONDITION: null
  SUBGRADE_CONDITION: null
  PSR: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

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

Supports Coordinates Quantization: false

Child Resources:

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