The Oakland Police Department provides crime data to the public through the City of Oakland's Crime Watch web site. This site presents the data in a geographic format, which allows users of the information to produce maps and/or reports.

The file that you are about to electronically download, copy, or otherwise retrieve by other means is a tabular representation of the same data without maps or reporting capabilities. Be advised that the exact address of each crime has been substituted with the block address to protect the privacy of the victim.

Please note: This Crime data are captured from reports filed with the police Department. There may be delays in data due to data processing, incident reporting or maybe technical in nature. Please allow up to 90 days from the end of each month for the data to be completely processed. For example, if you want to retrieve the full data set for the month of March, you will need to generate your report on or after June 30th. (A full 90 days after March 31st)

REQUESTID = The service request number. This should be shown as an integer without decimals. 5-digit REQUESTIDs were imported from the Recycling Hotline’s prior tracking system when they switched to the same system as the Oakland Call Center in August 2012. All others are 6 digits.

DATETIMEINIT = The Date that the request was initiated.

SOURCE = Indicates if the request was received via SeeClickFix or the OAK 311 mobile app, via the legacy Report A Problem website, or via (Phone or Email).

DESCRIPTION = Type of issue. Most of these are self-explanatory. Notes: “test template” and “This is a test subject. Ignore this ticket.” were for testing/training purposes only. Descriptions starting with “Business” “City Services” “CityBldg” (no space) “Events” “Misc” are/were used by the Recycling Hotline “TE” means “Traffic Engineering”

REQCATEGORY = Request Category

REQADDRESS = Request Address An address of ZZ indicates that the address was not recorded, usually this is for general inquiries to the Recycling Hotline.

STATUS = The status as of date of upload. PENDING: Request received for review OPEN: Request assigned to work unit WOCREATE: Work Order created for work to be done (not all work units use this status, so Open service requests may also have work orders created for work to be done) CLOSED: Request is resolved REFERRED: Oakland Call Center received the request and forwarded it to another entity (see REFERREDTO) UNFUNDED: Request is for an service that the City is not funded to provide CANCEL: Request was canceled, generally because it was created erroneously, it was used for testing/training, or it is a request that was received that duplicated an existing unresolved request WAITING ON CUSTOMER: Request involves a process where customer needs to provide information requested by staff EVALUATED - NO FURTHER ACTION: Staff has evaluated the service request and no further action will be taken (e.g., limited resources, temporary issue, staff alerted to ongoing issue, professional judgement says to leave situation as-is, unable to provide requested action) GONE ON ARRIVAL: Staff went to location and was unable to verify the issue

DATETIMECLOSED = The Date that the request was closed

SRX, SRY= Coordinates of the issue. Note that this is in NAD_1983_StatePlane_California_III_FIPS_0403_Feet, not latitude/longitude.

REFERREDTO = If the status is Referred, this shows who it was referred to.

COUNCILDISTRICT = City Council District of the REQADDRESS.

BEAT = Police Beat of the REQADDRESS (see http://mapgis.oaklandnet.com/PoliceDistricts/ for a map of police beats)

The equal access accommodations Indicator is measured by comparing the percent of public contact position (PCP) employees who speak Spanish to the percent of Spanish speakers who have limited English proficiency (LEP) citywide. The Equal Access to Services Ordinance includes a requirement for City departments to offer bilingual services based on citywide demographics. In FY2016-2017, the two languages required by the ordinance were Spanish and Chinese. We chose to measure Spanish-speaking PCP employees for this Indicator because Spanish speakers comprise a larger proportion of the population.

REQUESTID = The service request number. This should be shown as an integer without decimals. 5-digit
REQUESTIDs were imported from the Recycling Hotline’s prior tracking system when they switched to the same system as the rest of Public Works in August 2012. All others are 6 digits.

DATETIMEINIT = The Date/Time that the request was initiated.

DESCRIPTION = Type of issue. Most of these are self-explanatory. Notes:
“test template” and “This is a test subject. Ignore this ticket.” were for testing/training purposes only.
Descriptions starting with “Business” “City Services” “CityBldg” (no space) “Events” “Misc” are/were used by the Recycling Hotline
“TE” means “Traffic Engineering”

REQCATEGORY = Request Category

REQADDRESS = Request Address
An address of ZZ indicates that the address was not recorded, usually this is for general inquiries to the Recycling Hotline.

STATUS = The status as of 1/30/13.
Pending: Request received for review

OPEN: Request assigned to work unit

WOCREATE: Work Order created for work to be done (not all work units use this status, so Open service requests may also have work orders created for work to be done)

CLOSED: Request is resolved

REFERRED: Public Works received the request and forwarded it to another entity (see REFERREDTO)

UNFUNDED: Request is for an service that Public Works is not funded to provide
CANCEL: Request was canceled, generally because it was created erroneously, it was used for testing/training, or it is a request that was received that duplicated an existing unresolved request

DATETIMECLOSED = The Date/Time that the request was closed
SRX, SRY= Coordinates of the issue. Note that this is in NAD_1983_StatePlane_California_III_FIPS_0403_Feet, not latitude/longitude.
REFERREDTO = If the status is Referred, this shows who it was referred to.

A full dataset of CrimeWatch data.

The Oakland Police Department provides crime data to the public through the City of Oakland's Crime Watch web site. This site presents the data in a geographic format, which allows users of the information to produce maps and/or reports.

The file that you are about to electronically download, copy, or otherwise retrieve by other means is a tabular representation of the same data without maps or reporting capabilities. Be advised that the exact address of each crime has been substituted with the block address to protect the privacy of the victim.

Please note: This Crime data are captured from reports filed with the police Department. There may be delays in data due to data processing, incident reporting or maybe technical in nature. Please allow up to 90 days from the end of each month for the data to be completely processed. For example, if you want to retrieve the full data set for the month of March, you will need to generate your report on or after June 30th. (A full 90 days after March 31st)

All license plate reader (ALPR)

This dataset includes all itemized monetary contributions ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "A" Monetary Contributions from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76

Opportunities abound for volunteers to help clean and beautify public spaces throughout the city.