sonomacounty-ca-gov/sonoma-county-sheriffs-office-incident-data-3rsj-iche

  • crime
  • incidents
  • police
  • reports
  • sheriff
  • + 2

Sonoma County Sheriff's Office Incident Data

Sonoma County Sheriff's Office Incident Data

Sheriff’s incident reports are generated after either of two events 1) a citizen has reported an event/crime and a deputy has substantiated that a report is necessary or 2) a deputy has witnessed an event/crime in progress. These incident reports represent a wide spectrum of law enforcement activity from informational reports to serious crime reports. For more information about this dataset please go to the About button and click on the Attachment. For an interactive map of this data, please visit: http://www.raidsonline.com/?address=4787%20Old%20Redwood%20Hwy%20Santa%20Rosa,%20CA.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Zip Codes:@computed_region_dig5_f3vy:@computed_region_dig5_f3vyNumber
agency codeagency_codeagency_codeTextAgency code of agency that wrote the incident report.
citycitycityTextGeographic area where the reported incident took place. Some unincorporated areas are given three character codes rather then full town names. Additionally city names do not imply that the report occurred within city limits, simply within a geographic area designated with that city name. Use the intersection or geographic coordinates to identify the incident location.
incident typeincident_typeincident_typeTextIncident category for the type of incident reported.
location (city)location_citylocation_cityText
location (address)location_addresslocation_addressText
locationlocationlocationPointThis column contains geo-coordinates used for mapping.
location (zip)location_ziplocation_zipText
incident numberincident_numberincident_numberTextSequential number assigned to the incident report.
agencyagencyagencyTextAgency that wrote the incident report including Sheriff's Office and contract city reports.
date timedate_timedate_timeCalendar dateDate and time that the incident was reported to have taken place. For incidents such as burglary when there is a time range within which the incident occurred this is the first possible time the incident could have occurred.
idididTextUnique identifier
intersectionintersectionintersectionTextClosest intersection to the location where the event was reported. Intersections are used to protect victims identities.
location typelocation_typelocation_typeTextLocation category for where the incident report occurred. In the case where multiple locations are reported only the first location will be displayed.
Census Tract Boundary:@computed_region_xw9s_pz78:@computed_region_xw9s_pz78Number
location (state)location_statelocation_stateText
uploaduploaduploadCalendar dateDate the data was uploaded into Socrata after incident approval.

Upstream Metadata