20260426
22384100
1.0
FALSE
002
DOT.VisionZeroCrashFactsLastFiveYears
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_California_III_FIPS_0403_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WKT>PROJCS["NAD_1983_StatePlane_California_III_FIPS_0403_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",6561666.666666666],PARAMETER["False_Northing",1640416.666666667],PARAMETER["Central_Meridian",-120.5],PARAMETER["Standard_Parallel_1",37.06666666666667],PARAMETER["Standard_Parallel_2",38.43333333333333],PARAMETER["Latitude_Of_Origin",36.5],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2227]]</WKT><XOrigin>-115860600</XOrigin><YOrigin>-93269500</YOrigin><XYScale>3048.00609601219</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.00328083333333333</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102643</WKID><LatestWKID>2227</LatestWKID></ProjectedCoordinateSystem>
150000000
5000
20240228
16223900
20240926
10044900
ItemDescription
dataset
20240926
Enterprise Geodatabase Feature Class
Esri ArcGIS 13.1.3.41833
DOT.VisionZeroCrashFactsLastFiveYears
1
-124.090783
-0.000000
75.885130
-14.014199
Locations of all crashes known to the City since 1977.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Locations of all crashes known to the City over the past five years. Crash reports are logged by the Police Department and collected by the Department of Transportation, which analyzes them to inform roadway safety improvements. This dataset is a subset of the "Crash Locations", which contains all crashes since 1977.</SPAN></P><P><SPAN>Data is updated weekly.</SPAN></P></DIV></DIV></DIV>
Department of Transportation
Transportation
Public Safety
Vision
Zero
Crash
Crashes
Accident
Bike
Bicycle
Car
Vehicle
Pedestrian
Safety
City
San Jose
GeoDOT
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>External Public Facing</SPAN></P></DIV></DIV></DIV>
0
EPSG
5.3(9.0.0)
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
SHAPE
SHAPE
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
CITYDAMAGEFLAG
City Damage Flag
String
1
0
0
Was city property damaged
COLLISIONTYPE
Collision Type
String
30
0
0
What type of collision occurred in the crash
CRASHDATETIME
Crash Date Time
Date
8
0
0
Date and time of the crash
CRASHDATETIMEUTC
Crash Date Time (UTC)
Date
8
0
0
Date and time of the crash in UTC time
DATEDIMID
Date Dim Id
String
20
0
0
Field for joining to RZ date table
DAYOFWEEKNAME
Day of Week
String
20
0
0
Day of week of the crash
DIRECTIONFROMINTERSECTION
Direction From Intersection
String
20
0
0
What direction was the crash from the intersection
DISTANCE
Distance From Intersection
Integer
4
10
0
What is the distance to the intersection
ENTERPRISEID
Enterprise ID
String
20
0
0
Enterprise Wide Global Facility Identifier
FACILITYID
Facility Identifier
String
20
0
0
Locally Assigned Facility Identifier
FATALINJURIES
Fatal Injuries
Integer
4
10
0
Number of fatal injuries
HOUR
Hour
Integer
4
10
0
Hour of the crash
INTASTREETNAME
Intersection A Street Name
String
65
0
0
A Street Name of the intersection
INTASTREETTYPE
Intersection A Street Type
String
30
0
0
A Street Type of the intersection
INTBSTREETNAME
Intersection B Street Name
String
65
0
0
B Street Name of the intersection
INTBSTREETTYPE
Intersection B Street Type
String
30
0
0
B Street Type of the intersection
INTERSECTIONDIMID
Intersection Dim Id
String
20
0
0
Field for joining to RZ intersection table
INTERSECTIONNUMBER
Intersection Number
String
20
0
0
Identifier of the nearest associated intersection
INTERSECTIONTYPE
Intersection Type
String
20
0
0
Intersection Type of the intersection
INTID
Integer ID
Integer
4
10
0
Integer of Facility Identifier
INTTRAFFICCONTROLTYPE
Intersection Traffic Control Type
String
30
0
0
Traffic Control Type of the intersection
LASTEDITOR
Last Editor
String
20
0
0
The user who performed the last update
LASTUPDATE
Last Update Date
Date
8
0
0
The date the feature was last updated
LIGHTING
Lighting
String
40
0
0
What kind of lighting was present if any
MINORINJURIES
Minor Injuries
Integer
4
10
0
Number of minor injuries
MODERATEINJURIES
Moderate Injuries
Integer
4
10
0
Number of moderate injuries
MONTHNAME
Month
String
20
0
0
Month of the crash
NOTES
Notes
String
255
0
0
Miscelleanous notes pertaining to the feature
PEDESTRIANACTION
Pedestrian Action
String
50
0
0
What actions did pedestrians in the crash take if any
PEDESTRIANDIRECTIONFROM
Pedestrian Direction From
String
30
0
0
Direction that pedestrian if any was travelling from
PEDESTRIANDIRECTIONTO
Pedestrian Direction To
String
30
0
0
Direction that pedestrian if any was travelling to
PRIMARYCOLLISIONFACTOR
Primary Collision Factor
String
40
0
0
What was the primary collision factor
PROXIMITYTOINTERSECTION
Proximity To Intersection
String
30
0
0
Was the crash in the intersection, near it, or not at all
ROADWAYCONDITION
Roadway Condition
String
40
0
0
What was the roadway condition
ROADWAYSURFACE
Roadway Surface
String
30
0
0
What was the roadway surface type
SEVEREINJURIES
Severe Injuries
Integer
4
10
0
Number of severe injuries
SHORTFORMFLAG
Short Form Flag
String
1
0
0
Was the short form filled out
TCRNUMBER
TCR Number
String
20
0
0
Police record number for use as key field
TRAFFICCONTROL
Traffic Control Status Intersection
String
40
0
0
Was traffic control functioning in the intersection if any
VEHICLECOUNT
Vehicle Count
Integer
4
10
0
Vehicle count summarized from vehicle table
VEHICLEDAMAGE
Vehicle Damage
String
150
0
0
Vehicle damage summarized from vehicle table
VEHICLEDRIVERINTOXICATED
Driver Intoxicated
Integer
4
10
0
The number of vehicle drivers that were intoxicated
VEHICLEINVOLVEDWITH
Vehicle Involved With
String
35
0
0
If a vehicle was involved in the crash what other item was involved
VEHICLEPARTYCATEGORY
Vehicle Party Category
String
150
0
0
Vehicle party category summarized from vehicle table
VEHICLEVIOLATIONCODEDESCRIPTION
Vehicle Violation Code Description
String
255
0
0
Vehicle violation summarized from vehicle table
WEATHER
Weather
String
30
0
0
What was the weather when the crash occurred
YEAR
Year
String
4
0
0
Year of the crash
DOT.VisionZeroCrashFactsLastFiveYears
Feature Class
0
GlobalID
GlobalID
GlobalID
38
0
0
DAYNUMBER
Day Number
Integer
4
10
0
NARRATIVE
Narrative
String
255
0
0
AGERANGE
Age Range
String
80
0
0
CRASHNAME
Crash Name Identifier
String
20
0
0
LATITUDE
Latitude
Double
8
38
8
LONGITUDE
Longitude
Double
8
38
8
INTERSECTIONNUMBERINT
Intersection Number Integer
Integer
4
10
0
REPORTEDLOCATIONFOUND
Reported Location Found
String
3
0
0
SPEEDINGFLAG
Speeding Flag
String
5
0
0
HITANDRUNFLAG
Hit and Run Flag
String
5
0
0
Simple
FALSE
0
TRUE
FALSE