Name: CommercialCarrier

Display Field: Report_Number

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: b2464ad8a74b473eb3b05bc9b80be1b6

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

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

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Report_Number ( type: esriFieldTypeString, alias: Report Number, length: 255 )
• Record_Type ( type: esriFieldTypeString, alias: Record Type, length: 255 )
• Unit_Number ( type: esriFieldTypeString, alias: Unit Number, length: 255 )
• Commercial_Carrier_Interstate_Indicator ( type: esriFieldTypeString, alias: Commercial Carrier Interstate Indicator, length: 255 , Coded Values: [0: No] , [1: Yes] )
• Commercial_Carrier_USDOT_Number ( type: esriFieldTypeString, alias: Commercial Carrier USDOT Number, length: 255 )
• Commercial_Carrier_Configuration ( type: esriFieldTypeString, alias: Commercial Carrier Configuration, length: 255 , Coded Values: [1: Bus] , [2: Single-Unit Truck; 2 axle, 6 tires] , [3: Single-Unit Truck; 3 or more axles] , ...6 more... )
• Commercial_Carrier_Cargo_Body ( type: esriFieldTypeString, alias: Commercial Carrier Cargo Body, length: 255 , Coded Values: [1: Bus] , [2: Van/Enclosed Box] , [3: Cargo Tank] , ...6 more... )
• Commercial_Carrier_Number_of_Axles ( type: esriFieldTypeInteger, alias: Commercial Carrier Number of Axles )
• Commercial_Carrier_GVWR ( type: esriFieldTypeString, alias: Commercial Carrier GVWR, length: 255 )
• Commercial_Carrier_HazMat_Placard_Number ( type: esriFieldTypeString, alias: Commercial Carrier HazMat Placard Number, length: 255 )
• Commercial_Carrier_Placard_Suffix ( type: esriFieldTypeString, alias: Commercial Carrier Placard Suffix, length: 255 , Coded Values: [1: Explosive] , [2: Gas] , [3: Combustible] , ...6 more... )
• ID ( type: esriFieldTypeString, alias: ID, length: 255 )

Relationships:

• Collisions (3) -- Related To: Collisions (15)
• Collisions (13) -- Related To: Collisions This Year (16)
• Collisions (23) -- Related To: Collisions Last Year (17)
• Collisions (33) -- Related To: Collisions Last 3 Years (18)
• Collisions (43) -- Related To: Collisions Dashboard Layer (41)
• Collisions (53) -- Related To: Collisions- Fatality (42)
• Collisions (63) -- Related To: Collisions- Ped/Bicycle (43)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata