Layer: Truck Crash Data 2012-2023 (ID:42)

View In: Map Viewer

Name: Truck Crash Data 2012-2023

Display Field: OBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

The objective is to show truck crashes statewide collected using SWITRS Summary tool through the Transportation Injury Mapping System (TIMS ) https://tims.berkeley.edu/. The Statewide SWITRS Summary is a tool for accessing and mapping statewide crash and injury data. The data can be queried and viewed in tables and a map:

Fatal and injury crashes (overall);
Fatalities and injuries (overall);
Fatalities and injuries to pedestrians, bicyclists, motorcyclists, older adults and unrestrained vehicle passengers; and
Fatalities and injuries related to alcohol, drugs, distracted driving, and speeding.

The Statewide Integrated Traffic Records System (SWITRS) is a database that collects and processes data gathered from a collision scene. The Internet SWITRS application is a tool that leverages this database to allow California Highway Patrol (CHP) staff, members of its Allied Agencies, as well as researchers and members of the public to request various types of statistical reports in an electronic format. The application allows for the creation of custom reports requested by the user based on different categories including, but not limited to locations, dates, and collision types.

The Transportation Injury Mapping System (TIMS) has been developed over the past ten-plus years by SafeTREC to provide quick, easy and free access to California crash data, the Statewide Integrated Traffic Records System (SWITRS), that has been geo-coded by SafeTREC to make it easy to map crashes. TIMS currently provides 3 statewide summaries as well as 6 different crash and geospatial analysis tools that allow users to visualize and compare SWITRS data across California.

Transportation Injury Mapping System (TIMS), Safe Transportation Research and Education Center, University of California, Berkeley. 2024

Copyright Text: Caltrans, Division of Transportation Planning

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"87ea2c5c60dcb29e689a538c1e731be6","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABqklEQVQ4jaWTMWvbUBDHf8KmY/dnCNm8dOt56ebsT/4SBb3NUDJ1srwnGLxJU7YM7WT5A3jzkLxsWTwFAhJ09FQC7utwliW1KRl6ICQ93f93/ztxff4z+v/8Mg1CDyEwIKLkgGcZ+bcB0yDjIdnlGJEzMO+h2oN/huth8Jsdrg3qAr6EuPjMyn4A1mv4rnkGsIC1VvKPcu96wbGI8i5gGuQkBvBeLxF9LwoAkpkAZO4QPMvInwDjIdlJDJAkEMcNYDBQiLUkn4TbB7INjPp19csxchJ7D1WlojTVszjW+3oNIlxNkNEuiAJ6iPzw8LMFAMgydeA9lKUCjyFnqlNAYGAuBJyDPG8sV5U+r1ZaOU2blo46BUSU1R5MmjbDK0uFZZkmWwvGnKDVXo8VcMD7Z7BfXdM7KMSYpmKrevEI/KJQwDLy1++evJ3NBBGYzzXZmK6LVmyf6P7Gzcu5y1/O75O6krXNIP+IfAs3d8ybFo4uXC84IEtq8SuRb8F9Y8IiKroAgEWUu0Pwtw9kVxPdhXpgxaPavrljXov/BhydbGA02rW2ER3Ya9v4G/VEstg4Y1rbAAAAAElFTkSuQmCC","contentType":"image/png","width":12,"height":12,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID_1

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
CASE_ID (type: esriFieldTypeInteger, alias: CASE ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
ACCIDENT_YEAR (type: esriFieldTypeInteger, alias: ACCIDENT YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
PROC_DATE (type: esriFieldTypeDate, alias: PROCESSING DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
JURIS (type: esriFieldTypeInteger, alias: JURISDICTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
COLLISION_DATE (type: esriFieldTypeDate, alias: COLLISION DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COLLISION_DAY (type: esriFieldTypeString, alias: COLLISION DAY, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
COLLISION_TIME (type: esriFieldTypeInteger, alias: COLLISION TIME, SQL Type: sqlTypeOther, nullable: true, editable: true)
OFFICER_ID (type: esriFieldTypeInteger, alias: OFFICER ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
REPORTING_DISTRICT (type: esriFieldTypeString, alias: REPORTING DISTRICT, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
DAY_OF_WEEK (type: esriFieldTypeString, alias: DAY OF WEEK, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
CHP_SHIFT (type: esriFieldTypeInteger, alias: CHP SHIFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
POPULATION (type: esriFieldTypeInteger, alias: POPULATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
CNTY_CITY_LOC (type: esriFieldTypeInteger, alias: COUNTY CITY LOCATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
SPECIAL_COND (type: esriFieldTypeInteger, alias: SPECIAL CONDITION, SQL Type: sqlTypeOther, nullable: true, editable: true)
BEAT_TYPE (type: esriFieldTypeInteger, alias: BEAT TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
CHP_BEAT_TYPE (type: esriFieldTypeInteger, alias: CHP BEAT TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
CITY_DIVISION_LAPD (type: esriFieldTypeString, alias: CITY DIVISION LAPD, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
CHP_BEAT_CLASS (type: esriFieldTypeInteger, alias: CHP BEAT CLASS, SQL Type: sqlTypeOther, nullable: true, editable: true)
BEAT_NUMBER (type: esriFieldTypeInteger, alias: BEAT NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
PRIMARY_RD (type: esriFieldTypeString, alias: PRIMARY ROAD, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
SECONDARY_RD (type: esriFieldTypeString, alias: SECONDARY ROAD, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
DISTANCE (type: esriFieldTypeInteger, alias: DISTANCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
DIRECTION (type: esriFieldTypeString, alias: DIRECTION, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
INTERSECTION (type: esriFieldTypeString, alias: INTERSECTION, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
WEATHER_1 (type: esriFieldTypeString, alias: WEATHER 1, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
WEATHER_2 (type: esriFieldTypeString, alias: WEATHER 2, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
STATE_HWY_IND (type: esriFieldTypeString, alias: STATE HIGHWAY INDICATOR, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
CALTRANS_COUNTY (type: esriFieldTypeString, alias: CALTRANS COUNTY, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
CALTRANS_DISTRICT (type: esriFieldTypeInteger, alias: CALTRANS DISTRICT, SQL Type: sqlTypeOther, nullable: true, editable: true)
STATE_ROUTE (type: esriFieldTypeInteger, alias: STATE ROUTE, SQL Type: sqlTypeOther, nullable: true, editable: true)
ROUTE_SUFFIX (type: esriFieldTypeString, alias: ROUTE SUFFIX, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
POSTMILE_PREFIX (type: esriFieldTypeString, alias: POSTMILE PREFIX, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
POSTMILE (type: esriFieldTypeDouble, alias: POSTMILE, SQL Type: sqlTypeOther, nullable: true, editable: true)
LOCATION_TYPE (type: esriFieldTypeString, alias: LOCATION TYPE, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
RAMP_INTERSECTION (type: esriFieldTypeString, alias: RAMP INTERSECTION, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
SIDE_OF_HWY (type: esriFieldTypeString, alias: SIDE OF HIGHWAY, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
TOW_AWAY (type: esriFieldTypeString, alias: TOW AWAY, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
COLLISION_SEVERITY (type: esriFieldTypeInteger, alias: COLLISION SEVERITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
NUMBER_KILLED (type: esriFieldTypeInteger, alias: NUMBER KILLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
NUMBER_INJURED (type: esriFieldTypeInteger, alias: NUMBER INJURED, SQL Type: sqlTypeOther, nullable: true, editable: true)
PARTY_COUNT (type: esriFieldTypeInteger, alias: PARTY COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
PRIMARY_COLL_FACTOR (type: esriFieldTypeString, alias: PRIMARY COLLISION FACTOR, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
PCF_CODE_OF_VIOL (type: esriFieldTypeString, alias: PCF CODE OF VIOLATION, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
PCF_VIOL_CATEGORY (type: esriFieldTypeInteger, alias: PCF VIOLATION CATEGORY, SQL Type: sqlTypeOther, nullable: true, editable: true)
PCF_VIOLATION (type: esriFieldTypeString, alias: PCF VIOLATION, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
PCF_VIOL_SUBSECTION (type: esriFieldTypeString, alias: PCF VIOLATION SUBSECTION, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
HIT_AND_RUN (type: esriFieldTypeString, alias: HIT AND RUN, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
TYPE_OF_COLLISION (type: esriFieldTypeString, alias: TYPE OF COLLISION, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
MVIW (type: esriFieldTypeString, alias: MOTOR VEH INVOLVED WITH, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
PED_ACTION (type: esriFieldTypeString, alias: PEDESTRIAN ACTION, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
ROAD_SURFACE (type: esriFieldTypeString, alias: ROAD SURFACE, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
ROAD_COND_1 (type: esriFieldTypeString, alias: ROAD CONDITION 1, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
ROAD_COND_2 (type: esriFieldTypeString, alias: ROAD CONDITION 2, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
LIGHTING (type: esriFieldTypeString, alias: LIGHTING, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
CONTROL_DEVICE (type: esriFieldTypeString, alias: CONTROL DEVICE, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
CHP_ROAD_TYPE (type: esriFieldTypeInteger, alias: CHP ROAD TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
PEDESTRIAN_ACCIDENT (type: esriFieldTypeString, alias: PEDESTRIAN ACCIDENT, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
BICYCLE_ACCIDENT (type: esriFieldTypeString, alias: BICYCLE ACCIDENT, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
MOTORCYCLE_ACCIDENT (type: esriFieldTypeString, alias: MOTORCYCLE ACCIDENT, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
TRUCK_ACCIDENT (type: esriFieldTypeString, alias: TRUCK ACCIDENT, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
NOT_PRIVATE_PROPERTY (type: esriFieldTypeString, alias: NOT PRIVATE PROPERTY, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
ALCOHOL_INVOLVED (type: esriFieldTypeString, alias: ALCOHOL INVOLVED, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
STWD_VEHTYPE_AT_FAULT (type: esriFieldTypeString, alias: STATEWIDE VEH TYPE AT FAULT, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
CHP_VEHTYPE_AT_FAULT (type: esriFieldTypeInteger, alias: CHP VEH TYPE AT FAULT, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNT_SEVERE_INJ (type: esriFieldTypeInteger, alias: COUNT SEVERE INJURY, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNT_VISIBLE_INJ (type: esriFieldTypeInteger, alias: COUNT VISIBLE INJURY, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNT_COMPLAINT_PAIN (type: esriFieldTypeInteger, alias: COUNT COMPLAINT PAIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNT_PED_KILLED (type: esriFieldTypeInteger, alias: COUNT PEDESTRIAN KILLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNT_PED_INJURED (type: esriFieldTypeInteger, alias: COUNT PEDESTRIAN INJURED, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNT_BICYCLIST_KILLED (type: esriFieldTypeInteger, alias: COUNT BICYCLIST KILLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNT_BICYCLIST_INJURED (type: esriFieldTypeInteger, alias: COUNT BICYCLIST INJURED, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNT_MC_KILLED (type: esriFieldTypeInteger, alias: COUNT MOTORCYCLIST KILLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNT_MC_INJURED (type: esriFieldTypeInteger, alias: COUNT MOTORCYCLIST INJURED, SQL Type: sqlTypeOther, nullable: true, editable: true)
PRIMARY_RAMP (type: esriFieldTypeString, alias: PRIMARY RAMP, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
SECONDARY_RAMP (type: esriFieldTypeString, alias: SECONDARY RAMP, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
POINT_X (type: esriFieldTypeDouble, alias: POINT X, SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_Y (type: esriFieldTypeDouble, alias: POINT Y, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2024 4:25:24 AM

Schema Last Edit Date: 8/13/2024 4:25:24 AM

Data Last Edit Date: 7/16/2024 8:19:43 PM

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