Name: PPACG_Traffic_Crashes_2015_2020_objects

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• Crash_ID (type: esriFieldTypeInteger, alias: Crash_ID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Serial (type: esriFieldTypeInteger, alias: Serial, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• NetLink_ID (type: esriFieldTypeString, alias: NetLink_ID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Intrsct_ID (type: esriFieldTypeString, alias: Intrsct_ID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Report_Num (type: esriFieldTypeString, alias: Report_Num, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Agency_Nam (type: esriFieldTypeString, alias: Agency_Nam, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Time (type: esriFieldTypeDate, alias: Time, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Date_Time (type: esriFieldTypeDate, alias: Date_Time, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Day (type: esriFieldTypeString, alias: Day, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Severity (type: esriFieldTypeString, alias: Severity, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Vehicles (type: esriFieldTypeSmallInteger, alias: Vehicles, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• AccType (type: esriFieldTypeString, alias: AccType, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Road (type: esriFieldTypeString, alias: Road, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Loc_01 (type: esriFieldTypeString, alias: Loc_01, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Link (type: esriFieldTypeString, alias: Link, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Loc_02 (type: esriFieldTypeString, alias: Loc_02, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Ramp (type: esriFieldTypeString, alias: Ramp, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Contour (type: esriFieldTypeString, alias: Contour, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Lighting (type: esriFieldTypeString, alias: Lighting, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• InjLevel_0 (type: esriFieldTypeSmallInteger, alias: InjLevel_0, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• InjLevel_1 (type: esriFieldTypeSmallInteger, alias: InjLevel_1, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• InjLevel_2 (type: esriFieldTypeSmallInteger, alias: InjLevel_2, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• InjLevel_3 (type: esriFieldTypeSmallInteger, alias: InjLevel_3, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• InjLevel_4 (type: esriFieldTypeSmallInteger, alias: InjLevel_4, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• Vehicle_1 (type: esriFieldTypeString, alias: Vehicle_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Dir_1 (type: esriFieldTypeString, alias: Dir_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Veh_Move_1 (type: esriFieldTypeString, alias: Veh_Move_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Speed_1 (type: esriFieldTypeSmallInteger, alias: Speed_1, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• Limit1 (type: esriFieldTypeString, alias: Limit1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Driver_1 (type: esriFieldTypeString, alias: Driver_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Factor_1 (type: esriFieldTypeString, alias: Factor_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Vehicle_2 (type: esriFieldTypeString, alias: Vehicle_2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Dir_2 (type: esriFieldTypeString, alias: Dir_2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Veh_Move_2 (type: esriFieldTypeString, alias: Veh_Move_2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Speed_2 (type: esriFieldTypeSmallInteger, alias: Speed_2, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• Limit2 (type: esriFieldTypeString, alias: Limit2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Driver_2 (type: esriFieldTypeString, alias: Driver_2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Factor_2 (type: esriFieldTypeString, alias: Factor_2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Vehicle_3 (type: esriFieldTypeString, alias: Vehicle_3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Dir_3 (type: esriFieldTypeString, alias: Dir_3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Veh_Move_3 (type: esriFieldTypeString, alias: Veh_Move_3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Speed_3 (type: esriFieldTypeSmallInteger, alias: Speed_3, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• Limit3 (type: esriFieldTypeString, alias: Limit3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Driver_3 (type: esriFieldTypeString, alias: Driver_3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Factor_3 (type: esriFieldTypeString, alias: Factor_3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• System (type: esriFieldTypeString, alias: System, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• RTE (type: esriFieldTypeSmallInteger, alias: RTE, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• MP (type: esriFieldTypeSmallInteger, alias: MP, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• RUCode (type: esriFieldTypeString, alias: RUCode, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Region (type: esriFieldTypeSmallInteger, alias: Region, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• Latitude (type: esriFieldTypeSmallInteger, alias: Latitude, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• Longitude (type: esriFieldTypeSmallInteger, alias: Longitude, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/15/2023 1:03:50 PM

Schema Last Edit Date: 5/15/2023 1:03:50 PM

Data Last Edit Date: 5/15/2023 1:03:50 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat