The Civic Engagement Topic measures three different aspects of an engaged community working to improve conditions and collectively shape the future of Oakland. The first Indicator compares the percents of drains that have been adopted in majority Asian and majority White census tracts through the Adopt a Drain program. The second Indicator compares voter turnout rates among residents in Council District 7 and Council District 1. Finally, the third Indicator compares the percent of the population that is Spanish-speaking with limited English proficiency (LEP) and the percent of city public contact position (PCP) employees that are bilingual in Spanish and English to ensure that LEP status does not inhibit access to city services.

All license plate reader data (ALPR)

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, via the Report A Problem website at www.oaklandpw.com, 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

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)

Shotspotter Data 11288

All license plate reader data (ALPR)

The Enrollment Topic includes three Indicators that measure racial and ethnic disparities in preschool enrollment, chronic absenteeism, and high school on-time completion. The first Indicator measures disparities in preschool enrollment between Latinos and Whites. The second Indicator measures disparities in chronic absenteeism between African Americans and Asians. The third Indicators measures disparities in how many high school students are still enrolled after four years between Latinos and Whites.

Oakland has a long history of activism around issues of justice and equity. Both oppression and this resistance to oppression have shaped the city’s past and the lives of its residents to this day. It is, therefore, not surprising that Oakland was chosen in 2017 to be among the first cohort of five cities to develop local Equity Indicators tools in partnership with the City University of New York’s Institute for State and Local Governance (CUNY ISLG) and with funding from the Rockefeller Foundation.