ArcGIS layer
Crash Locations Last Five Years
Crash Locations Last Five Years from the City of San Jose open-data MapServer. The brief uses ArcGIS count and sample-feature queries from the source layer.
Field preview
| Field | Display label | Type |
|---|---|---|
| INJURYSEVERITY | Injury Severity | esriFieldTypeString |
| KSIINJURIES | Total Fatal and Severe Injuries | esriFieldTypeInteger |
| NEARBYSAFETYCORRIDORS | Safety Corridors Within 50 Feet | esriFieldTypeString |
| OBJECTID | OBJECTID | esriFieldTypeOID |
| Shape | SHAPE | esriFieldTypeGeometry |
| GlobalID | GlobalID | esriFieldTypeGlobalID |
| FACILITYID | Facility Identifier | esriFieldTypeString |
| INTID | Integer ID | esriFieldTypeInteger |
| TCRNUMBER | TCR Number | esriFieldTypeString |
| CRASHDATETIME | Crash Date Time | esriFieldTypeDate |
| CRASHDATETIMEUTC | Crash Date Time (UTC) | esriFieldTypeDate |
| VEHICLECOUNT | Vehicle Count | esriFieldTypeInteger |
| VEHICLEPARTYCATEGORY | Vehicle Party Category | esriFieldTypeString |
| VEHICLEVIOLATIONCODEDESCRIPTION | Vehicle Violation Code Description | esriFieldTypeString |
| VEHICLEDAMAGE | Vehicle Damage | esriFieldTypeString |
| VEHICLEDRIVERINTOXICATED | Driver Intoxicated | esriFieldTypeInteger |
| MINORINJURIES | Minor Injuries | esriFieldTypeInteger |
| MODERATEINJURIES | Moderate Injuries | esriFieldTypeInteger |
Sample records
The table shows up to six source records from the current pull. Empty source fields are preserved as blanks.
| Total Fatal and Severe Injuries | Safety Corridors Within 50 Feet | OBJECTID | GlobalID | Facility Identifier | Integer ID | TCR Number | Crash Date Time |
|---|---|---|---|---|---|---|---|
| 0 | Story Rd | 9615 | {CBF321EE-C798-4EAE-B56E-349EA7873F4D} | 556892 | 556892 | 21-005-4002 | 1609459500000 |
| 0 | 9616 | {01187DA1-09C5-4AC5-91D8-D34350E1981E} | 555409 | 555409 | 21-002-0253 | 1609464600000 | |
| 0 | Monterey Road | 9617 | {1A1ADDA7-9D3B-4682-9E51-867F2C388F95} | 556179 | 556179 | 21-001-0205 | 1609473180000 |
| 0 | 9618 | {ABB7CB6F-4372-4C37-8A40-2B7076760890} | 556180 | 556180 | 21-001-0215 | 1609475520000 | |
| 0 | 9619 | {FB5E5A75-D60F-4E33-8435-2F9061AF9EF5} | 555438 | 555438 | 21-001-0325 | 1609493340000 |