Open Data Network

3rd Grade ELA Proficiency

The measurement is percent of students by race/ethnicity who scored “Standard Not Met” on their SBAC ELA test in 3rd grade. The SBAC is California's state-mandated test for all students starting in 3rd grade. Scores only include students enrolled in OUSD schools, not charters or private schools.

High School Completion

Audubon California Important Bird Areas 2014

The objective of this project was to digitally map the boundaries of Audubon California's Important Bird Areas (IBA). Existing Important Bird Areas identify critical terrestrial and inland water habitats for avifauna, in particular, habitat that supports rare, threatened or endangered birds and/or exceptionally large congregations of shorebirds and/or waterfowl. The digitization of Important Bird Areas represents an important first step in conservation planning of these critical habitats using GIS. As of October 2007, a draft layer of all 148 Important Bird Areas in California was completed. Currently, a review is in progress with Audubon Chapters and local experts, with a final version completed by Nov. 1, 2008. The final map and data will be released to the public in November, 2008.

Parking Citations 2019

Parking citations in Oakland from 2019. Data has been cleaned of personal information but data entry errors still remain. Approximately ~92% of citation addresses matched when geocoded. Refer to Status and Score fields to determine estimated accuracy. Last updated: 11/25/2019

Ratio of Bad-to-Good Financial Institutions by Race/Ethnicity of Zip Codes

Equal Access Accommodations

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.

Illegal Dumping service requests FY12-13

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)

ILLDUMP service requests FY16-17

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)

Teacher Turnover

The measurement is percent of teachers who turned over between the 2016-17 and 2017-18 school years at OUSD schools (data from charters and private schools were not available). Turnover percents are calculated at a school level out of the total number of teachers at that school. Schools are placed into groups based on the racial and ethnic breakdown of their student population (see note below data table for full explanation of grouping). Average teacher turnover percent is then calculated for each group of schools.

Child Health

Wellness, physical activity, and nutrition are essential for children as they prepare for a healthy lifestyle and positive health outcomes as adults. The Child Health Topic includes three Indicators that measure different aspects of child health and wellness: childhood asthma emergency department visits, physical fitness, and SNAP recipiency. The first Indicator measures asthma-related emergency department visits and is related to the environmental and housing conditions that affect children’s health. The second Indicator, physical fitness, a measure of student fitness levels assessed in schools, tracks physical aptitude and activity. The third Indicator, SNAP recipiency, shows whether families have adequate income to provide healthy food for their children.