Pedestrian or Bicycle at Fault
SafeTREC began assessing the usage of the California Statewide Integrated Traffic Records System (SWITRS) by state and local agencies in 2003 on a project funded by the California Office of Traffic Safety (OTS). Specifically, the project looked at the needs of agencies to geocode and map the crashes in an efficient and simple manner. The lack of expertise or capabilities at many agencies did not allow any geographic analysis of traffic crashes and resulted in exorbitant consulting expenses, redundancy of various efforts, technical difficulties, inaccuracy, and other problems. Further grants from OTS allowed SafeTREC to develop a geocoding methodology and apply it to SWITRS data statewide. In order to distribute the geocoded SWITRS data, a web-based data query and download application was developed with the ability to display pin maps in Google Maps. A second application was designed to provide a more map-centric experience with other types of data layers and spatial analysis capabilities typically seen in a Geographic Information System (GIS). The TIMS concept was subsequently formed to give these applications a common foundation and provide a framework for continued development in the future.
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'domain': None}, {'name': 'CASE_ID', 'type': 'esriFieldTypeDouble', 'alias': 'CASE_ID', 'domain': None}, {'name': 'ACCIDENT_YEAR', 'type': 'esriFieldTypeDouble', 'alias': 'ACCIDENT_YEAR', 'domain': None}, {'name': 'PROC_DATE', 'type': 'esriFieldTypeDate', 'alias': 'PROC_DATE', 'length': 8, 'domain': None}, {'name': 'JURIS', 'type': 'esriFieldTypeDouble', 'alias': 'JURIS', 'domain': None}, {'name': 'COLLISION_DATE', 'type': 'esriFieldTypeDate', 'alias': 'COLLISION_DATE', 'length': 8, 'domain': None}, {'name': 'COLLISION_TIME', 'type': 'esriFieldTypeDouble', 'alias': 'COLLISION_TIME', 'domain': None}, {'name': 'CNTY_CITY_LOC', 'type': 'esriFieldTypeDouble', 'alias': 'CNTY_CITY_LOC', 'domain': None}, {'name': 'PRIMARY_RD', 'type': 'esriFieldTypeString', 'alias': 'PRIMARY_RD', 'length': 255, 'domain': None}, {'name': 'SECONDARY_RD', 'type': 'esriFieldTypeString', 'alias': 'SECONDARY_RD', 'length': 255, 'domain': None}, {'name': 'DISTANCE', 'type': 'esriFieldTypeDouble', 'alias': 'DISTANCE', 'domain': None}, {'name': 'DIRECTION', 'type': 'esriFieldTypeString', 'alias': 'DIRECTION', 'length': 255, 'domain': None}, {'name': 'INTERSECTION', 'type': 'esriFieldTypeString', 'alias': 'INTERSECTION', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'Y or N', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}]}}, {'name': 'WEATHER_1', 'type': 'esriFieldTypeString', 'alias': 'WEATHER_1', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'SWITRS_Weather', 'codedValues': [{'name': 'Clear', 'code': 'A'}, {'name': 'Cloudy', 'code': 'B'}, {'name': 'Raining', 'code': 'C'}, {'name': 'Snowing', 'code': 'D'}, {'name': 'Fog', 'code': 'E'}, {'name': 'Other', 'code': 'F'}, {'name': 'Wind', 'code': 'G'}, {'name': 'Not Stated', 'code': '-'}]}}, {'name': 'WEATHER_2', 'type': 'esriFieldTypeString', 'alias': 'WEATHER_2', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'SWITRS_Weather', 'codedValues': [{'name': 'Clear', 'code': 'A'}, {'name': 'Cloudy', 'code': 'B'}, {'name': 'Raining', 'code': 'C'}, {'name': 'Snowing', 'code': 'D'}, {'name': 'Fog', 'code': 'E'}, {'name': 'Other', 'code': 'F'}, {'name': 'Wind', 'code': 'G'}, {'name': 'Not Stated', 'code': '-'}]}}, {'name': 'STATE_HWY_IND', 'type': 'esriFieldTypeString', 'alias': 'STATE_HWY_IND', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'Y or N', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}]}}, {'name': 'STATE_ROUTE', 'type': 'esriFieldTypeDouble', 'alias': 'STATE_ROUTE', 'domain': None}, {'name': 'POSTMILE', 'type': 'esriFieldTypeDouble', 'alias': 'POSTMILE', 'domain': None}, {'name': 'LOCATION_TYPE', 'type': 'esriFieldTypeString', 'alias': 'LOCATION_TYPE', 'length': 255, 'domain': None}, {'name': 'NUMBER_KILLED', 'type': 'esriFieldTypeDouble', 'alias': 'NUMBER_KILLED', 'domain': None}, {'name': 'NUMBER_INJURED', 'type': 'esriFieldTypeDouble', 'alias': 'NUMBER_INJURED', 'domain': None}, {'name': 'PARTY_COUNT', 'type': 'esriFieldTypeDouble', 'alias': 'PARTY_COUNT', 'domain': None}, {'name': 'PRIMARY_COLL_FACTOR', 'type': 'esriFieldTypeString', 'alias': 'PRIMARY_COLL_FACTOR', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'SWITRS_Prim_Col_Fact', 'codedValues': [{'name': '(Vehicle) Code Violation', 'code': 'A'}, {'name': 'Other Improper Driving', 'code': 'B'}, {'name': 'Other Than Driver', 'code': 'C'}, {'name': 'Unknown', 'code': 'D'}, {'name': 'Fell Asleep', 'code': 'E'}, {'name': 'Not Stated', 'code': '-'}]}}, {'name': 'PCF_VIOL_CATEGORY', 'type': 'esriFieldTypeString', 'alias': 'PCF_VIOL_CATEGORY', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'PCF_VIOL_CATEGORY', 'codedValues': [{'name': 'Driving or Bicycling Under the Influence of Alcohol or Drugs', 'code': '1'}, {'name': 'Impeding Traffic', 'code': '2'}, {'name': 'Unsafe Speed', 'code': '3'}, {'name': 'Following Too Closely', 'code': '4'}, {'name': 'Wrong Side of Road', 'code': '5'}, {'name': 'Improper Passing', 'code': '6'}, {'name': 'Unsafe Lane Change', 'code': '7'}, {'name': 'Improper Turning', 'code': '8'}, {'name': 'Automobile Right of Way', 'code': '9'}, {'name': 'Pedestrian Right of Way', 'code': '10'}, {'name': 'Pedestrian Violation', 'code': '11'}, {'name': 'Traffic Signals and Signs', 'code': '12'}, {'name': 'Hazardous Parking', 'code': '13'}, {'name': 'Lights', 'code': '14'}, {'name': 'Brakes', 'code': '15'}, {'name': 'Other Equipment', 'code': '16'}, {'name': 'Other Hazardous Violation', 'code': '17'}, {'name': 'Other Than Driver (or Pedestrain)', 'code': '18'}, {'name': '(blank)', 'code': '19'}, {'name': '(blank)', 'code': '20'}, {'name': 'Unsafe Starting or Backing', 'code': '21'}, {'name': 'Other Improper Driving', 'code': '22'}, {'name': 'Pedestrian or "Other" Under the Influence of Alcohol or Drug', 'code': '23'}, {'name': 'Fell Asleep', 'code': '24'}, {'name': 'Unknown', 'code': '0'}]}}, {'name': 'HIT_AND_RUN', 'type': 'esriFieldTypeString', 'alias': 'HIT_AND_RUN', 'length': 255, 'domain': None}, {'name': 'TYPE_OF_COLLISION', 'type': 'esriFieldTypeString', 'alias': 'TYPE_OF_COLLISION', 'length': 255, 'domain': None}, {'name': 'MVIW', 'type': 'esriFieldTypeString', 'alias': 'MVIW', 'length': 255, 'domain': None}, {'name': 'PED_ACTION', 'type': 'esriFieldTypeString', 'alias': 'PED_ACTION', 'length': 255, 'domain': None}, {'name': 'ROAD_SURFACE', 'type': 'esriFieldTypeString', 'alias': 'ROAD_SURFACE', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'SWITRS_Road_Surface', 'codedValues': [{'name': 'Dry', 'code': 'A'}, {'name': 'Wet', 'code': 'B'}, {'name': 'Snowy or Icy', 'code': 'C'}, {'name': 'Slippery (Muddy, Oily, etc.)', 'code': 'D'}, {'name': 'Not Stated', 'code': '-'}]}}, {'name': 'ROAD_COND_1', 'type': 'esriFieldTypeString', 'alias': 'ROAD_COND_1', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'SWITRS_Road_Cond', 'codedValues': [{'name': 'Holes, Deep Ruts', 'code': 'A'}, {'name': 'Loose Material on Roadway', 'code': 'B'}, {'name': 'Obstruction on Roadway', 'code': 'C'}, {'name': 'Construction or Repair Zone', 'code': 'D'}, {'name': 'Reduced Roadway Width', 'code': 'E'}, {'name': 'Flooded', 'code': 'F'}, {'name': 'Other', 'code': 'G'}, {'name': 'No Unusual Condition', 'code': 'H'}, {'name': 'Not Stated', 'code': '-'}]}}, {'name': 'ROAD_COND_2', 'type': 'esriFieldTypeString', 'alias': 'ROAD_COND_2', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'SWITRS_Road_Cond', 'codedValues': [{'name': 'Holes, Deep Ruts', 'code': 'A'}, {'name': 'Loose Material on Roadway', 'code': 'B'}, {'name': 'Obstruction on Roadway', 'code': 'C'}, {'name': 'Construction or Repair Zone', 'code': 'D'}, {'name': 'Reduced Roadway Width', 'code': 'E'}, {'name': 'Flooded', 'code': 'F'}, {'name': 'Other', 'code': 'G'}, {'name': 'No Unusual Condition', 'code': 'H'}, {'name': 'Not Stated', 'code': '-'}]}}, {'name': 'LIGHTING', 'type': 'esriFieldTypeString', 'alias': 'LIGHTING', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'SWITRS_Lighting', 'codedValues': [{'name': 'Daylight', 'code': 'A'}, {'name': 'Dusk - Dawn', 'code': 'B'}, {'name': 'Dark - Street Lights', 'code': 'C'}, {'name': 'Dark - No Street Lights', 'code': 'D'}, {'name': 'Dark - Street Lights Not Functioning', 'code': 'E'}, {'name': 'Not Stated', 'code': '-'}]}}, {'name': 'CONTROL_DEVICE', 'type': 'esriFieldTypeString', 'alias': 'CONTROL_DEVICE', 'length': 255, 'domain': None}, {'name': 'PEDESTRIAN_ACCIDENT', 'type': 'esriFieldTypeString', 'alias': 'PEDESTRIAN_ACCIDENT', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'Y or N', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}]}}, {'name': 'BICYCLE_ACCIDENT', 'type': 'esriFieldTypeString', 'alias': 'BICYCLE_ACCIDENT', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'Y or N', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}]}}, {'name': 'MOTORCYCLE_ACCIDENT', 'type': 'esriFieldTypeString', 'alias': 'MOTORCYCLE_ACCIDENT', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'Y or N', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}]}}, {'name': 'TRUCK_ACCIDENT', 'type': 'esriFieldTypeString', 'alias': 'TRUCK_ACCIDENT', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'Y or N', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}]}}, {'name': 'NOT_PRIVATE_PROPERTY', 'type': 'esriFieldTypeString', 'alias': 'NOT_PRIVATE_PROPERTY', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'Y or N', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}]}}, {'name': 'ALCOHOL_INVOLVED', 'type': 'esriFieldTypeString', 'alias': 'ALCOHOL_INVOLVED', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'Y or N', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}]}}, {'name': 'COUNT_SEVERE_INJ', 'type': 'esriFieldTypeDouble', 'alias': 'COUNT_SEVERE_INJ', 'domain': None}, {'name': 'COUNT_VISIBLE_INJ', 'type': 'esriFieldTypeDouble', 'alias': 'COUNT_VISIBLE_INJ', 'domain': None}, {'name': 'COUNT_COMPLAINT_PAIN', 'type': 'esriFieldTypeDouble', 'alias': 'COUNT_COMPLAINT_PAIN', 'domain': None}, {'name': 'COUNT_PED_KILLED', 'type': 'esriFieldTypeDouble', 'alias': 'COUNT_PED_KILLED', 'domain': None}, {'name': 'COUNT_PED_INJURED', 'type': 'esriFieldTypeDouble', 'alias': 'COUNT_PED_INJURED', 'domain': None}, {'name': 'COUNT_BICYCLIST_KILLED', 'type': 'esriFieldTypeDouble', 'alias': 'COUNT_BICYCLIST_KILLED', 'domain': None}, {'name': 'COUNT_BICYCLIST_INJURED', 'type': 'esriFieldTypeDouble', 'alias': 'COUNT_BICYCLIST_INJURED', 'domain': None}, {'name': 'COUNT_MC_KILLED', 'type': 'esriFieldTypeDouble', 'alias': 'COUNT_MC_KILLED', 'domain': None}, {'name': 'COUNT_MC_INJURED', 'type': 'esriFieldTypeDouble', 'alias': 'COUNT_MC_INJURED', 'domain': None}, {'name': 'LATITUDE', 'type': 'esriFieldTypeDouble', 'alias': 'LATITUDE', 'domain': None}, {'name': 'LONGITUDE', 'type': 'esriFieldTypeDouble', 'alias': 'LONGITUDE', 'domain': None}, {'name': 'COUNTY', 'type': 'esriFieldTypeString', 'alias': 'COUNTY', 'length': 255, 'domain': None}, {'name': 'CITY', 'type': 'esriFieldTypeString', 'alias': 'CITY', 'length': 255, 'domain': None}, {'name': 'POINT_X', 'type': 'esriFieldTypeDouble', 'alias': 'POINT_X', 'domain': None}, {'name': 'POINT_Y', 'type': 'esriFieldTypeDouble', 'alias': 'POINT_Y', 'domain': None}, {'name': 'DAY_OF_WEEK', 'type': 'esriFieldTypeString', 'alias': 'DAY_OF_WEEK', 'length': 50, 'domain': {'type': 'codedValue', 'name': 'SWITRS_Day_of_Week', 'codedValues': [{'name': 'Monday', 'code': '1'}, {'name': 'Tuesday', 'code': '2'}, {'name': 'Wednesday', 'code': '3'}, {'name': 'Thursday', 'code': '4'}, {'name': 'Friday', 'code': '5'}, {'name': 'Saturday', 'code': '6'}, {'name': 'Sunday', 'code': '7'}]}}, {'name': 'POPULATION', 'type': 'esriFieldTypeString', 'alias': 'POPULATION', 'length': 50, 'domain': {'type': 'codedValue', 'name': 'SWITRS_Population', 'codedValues': [{'name': 'Incorporated (less than 25000)', 'code': '1'}, {'name': 'Incorporated (2500-10000)', 'code': '2'}, {'name': 'Incorporated (10000-25000)', 'code': '3'}, {'name': 'Incorporated (25000-50000)', 'code': '4'}, {'name': 'Incorporated (50000-100000)', 'code': '5'}, {'name': 'Incorporated (100000-250000)', 'code': '6'}, {'name': 'Incorporated (over 250000)', 'code': '7'}, {'name': 'Unincorporated (Rural)', 'code': '9'}, {'name': 'Univeristy (Private Property)', 'code': '0'}, {'name': 'Not Stated', 'code': '-'}]}}, {'name': 'COLLISION_SEVERITY', 'type': 'esriFieldTypeString', 'alias': 'COLLISION_SEVERITY', 'length': 70, 'domain': {'type': 'codedValue', 'name': 'SWITRS_Col_Severity', 'codedValues': [{'name': 'Fatal', 'code': '1'}, {'name': 'Injury (Severe)', 'code': '2'}, {'name': 'Injury (Other Visible)', 'code': '3'}, {'name': 'Injury (Complaint of Pain)', 'code': '4'}, {'name': 'Property Damage Only (PDO)', 'code': '0'}]}}, {'name': 'FMEUpdate', 'type': 'esriFieldTypeDate', 'alias': 'FMEUpdate', 'length': 8, 'domain': None}, {'name': 'Shape', 'type': 'esriFieldTypeGeometry', 'alias': 'Shape', 'domain': None}, {'name': 'PARTY_NUMBER', 'type': 'esriFieldTypeDouble', 'alias': 'PARTY_NUMBER', 'domain': None}, {'name': 'AT_FAULT', 'type': 'esriFieldTypeString', 'alias': 'AT_FAULT', 'length': 255, 'domain': {'type': 'codedValue', 'name': 'Y or N', 'codedValues': [{'name': 'Yes', 'code': 'Y'}, {'name': 'No', 'code': 'N'}]}}, {'name': 'PARTY_TYPE', 'type': 'esriFieldTypeString', 'alias': 'PARTY_TYPE', 'length': 50, 'domain': {'type': 'codedValue', 'name': 'SWITRS_Party_Type', 'codedValues': [{'name': 'Driver', 'code': '1'}, {'name': 'Pedestrian', 'code': '2'}, {'name': 'Parked Vehicle', 'code': '3'}, {'name': 'Bicyclist', 'code': '4'}, {'name': 'Other', 'code': '5'}, {'name': 'Operator', 'code': '6'}, {'name': 'Not Stated', 'code': '-'}]}}, {'name': 'CASE_ID_1', 'type': 'esriFieldTypeDouble', 'alias': 'Kern.KERN.Traffic_Collisions.CASE_ID_1', 'domain': None}]
[{'name': 'R1356_pk', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': ''}, {'name': 'Pedestrian_Bicyc', 'fields': 'PEDESTRIAN_ACCIDENT,BICYCLE_ACCIDENT,ACCIDENT_YEAR', 'isAscending': True, 'isUnique': False, 'description': ''}, {'name': 'S1208_idx', 'fields': 'Shape', 'isAscending': True, 'isUnique': True, 'description': ''}]
nan
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriPMS', 'url': 'a2c89555f176b53aba9a8052007f114d', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAABKZJREFUSInF1ntMU1ccwPHvvW2hFwpoC63aIuCD4GKAJTgzhckyTDBBi2Q+Nkfi3BDwj6EwMJMoCg4fuLkt4nhkhmTsoShzi9E/NDODxZn4h5AsGfISkGVSoIJtpWV97A+0WcdLE+POX/f+zjm/zzk595dz5bzAJv9fMI/H8zLwCiA8x/xm4IIgCC4frKWl5frg4GCIIDw/y2azYTQaNwIXfTCz2Ry4du3aaSfah4aw3e1hfHgYj8uJPCgISa8nMCICUT71aVy9ehVgzpP3Wc/sYXs7f9V/w6PGnxBCglAsfwkxOJi/u7pxtXchi16MNjcb7Zo1iH5+M+aaFnO7XPSfPcdw+XFU72xh0fnvCYyKRFQoEEVxYreDgwzfuMH9snLMF38k6sB+JJ3u2TCP201vTS0jldVoj5SiT0vD7fGQl5eHxWKhtrYWhUKBMiwMvdFIaFIS3UeO0pGdy9KaKiSt9umxgZ+vM/JVHSj9Gf66HvWKFfhrtVitVqxWKx6Px2e8v1pNdFkp7cXF3C37mJhPTiD6KWbHxkdHuV96mPnlZfjP09GzYycdH+Sx9IvPOX36NMeOHSM/P59t27aRkJCAQjGRVKZUErVvH20bNmJq+oV5KSmzY0PNzcjC9WhfT0ZUKOBMjReUCj/k0KFDAFRWVmI0GikqKmLVqlUAKDUaQvPzMFXVoE1Onh17cOky6k1vTkDA3NhYL2gp3s92f3/qHA4AUlNTqa+v92IAmtWrGSw5jK2vb2bMNTbG+K+/EbArx2fQ3NhYhspLseTvJTtyCfR0UudwIEkSJpPJZ6xSp0MwzGesv39mzDk2NhFUqbwxt9vNlStXKCkp4eDbm9A3NJK7bDmeP37Hbrdjt9t9EgqCgN/iRTgtFvhP3flggigDwON0emOiKGIwGGhubkaSJNri4/EUFZMTuYTW/n6qqqom7cA1MoIgm/yh+0TkQSpQBWA3mQiOjvbG4+LivM+X29qwmgdIU+uIa/iBoKwsX8jhwHmnEz+NBkYeTI+JMhmq9PU8vHkTbWLipJWNjo5SUFBARUUFfTYbCxsu0pWzi2V1Z7yFbO3qBruDwKhIuD0DBqBOSaFvexa2rVsJNBh8+np7ewHIzMxEEASqqqtZr5DRmbeHJZ+fRAoLY+BCIwEZG1CGhk5a7CRsbnw8A8mJ9FfXsPTAfm8JAHR3d7Nu3Tq0Wi2CIBCydy+XTp0iraOLzrw9qLduxnb2PIsbz06CpsREuZyFRYV0bH6L3vBwIt7d7gVbW1sxGo08ufPS09OJ3L2btIYjOI+ewFR8EM1HhT7nPSMGoFq4kMiaL+nZmcv4vXuEZ2cTYNCTkZGB6l9lERERQeutW6j77jFodxCS8z6GLZunhKbFYKKQFee+o+94BXdS0wjekYlu5UqUSiWWri6cFgvW9nao/5ahYTPzPz2OLuUNhMfXzzNhT3YY89lJHrS0YL52jT8LisD6yNvvl/gqmqz3CE1Kwn/OnBkyPQUGE2eoSUhAk5CAu7AQp8WKx+1CLknIJGnGuY+vIu995MViYmJuNDU1vTbr8p6hLViwwAbcnoTp9fo1zxOaqr3Qn9R/AF0lmPbXX9FvAAAAAElFTkSuQmCC', 'contentType': 'image/png', 'width': 20, 'height': 20, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'label': '', 'description': ''}, 'transparency': 0, 'labelingInfo': None}
nan
nan
nan