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.

The Incarceration Topic includes three Indicators that measure racial and ethnic disparities in adult felony arrests, jail incarceration, and prison incarceration. The first Indicator measures disparities in adult felony arrests between African Americans and Asians. The second Indicator measures disparities in jail incarceration between African Americans and Asians. The third Indicator measures disparities in prison incarceration between African Americans and Asians. In all three indicator areas the disparities between African American and White residents were nearly as large.

Public health relates to many of the other Themes in the Equity Indicators framework. Public health outcomes are tied to housing quality, environment, and neighborhood. Social determinants of health include poverty, employment, and educational attainment. The public health field has historically been dedicated to understanding and addressing racial and ethnic disparities in health outcomes, but the complexity of these issues contributes to the persistence of inequity.

In Oakland and across the Bay Area, there are wide disparities in economic outcomes for different groups. Structural barriers in society result in some residents having more access than others to economic opportunities that build wealth and financial stability. This Theme not only includes the standard measures of economic well-being (e.g., unemployment, poverty) but it also evaluates racial and ethnic disparities in the quality of jobs, business development, and elements of financial health.

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.

Affordable, stable, and high-quality housing is a basic right of Oakland residents. Many Oaklanders face challenges in accessing adequate housing, and racial and ethnic minorities are even more disadvantaged. The Indicators in this Theme reveal disparities among individuals and neighborhoods and highlight the pressing need for more equitable housing policy.

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.

Education has long been an area of well-known disparities in outcomes across racial and ethnic groups, both in Oakland and throughout the country. Yet, education is also perhaps the single most powerful tool to rectify disparities in other Themes, such as Economy. This Theme includes measures that span from traditional measures of student attendance and achievement to measures of teachers, recognizing that teachers play a critical role in a child’s education.

For a city to thrive, it is essential that neighborhoods are safe and accessible, and that residents have the opportunity to access city services and hold the city government accountable. Oakland residents face disparities based on where they live in the city, with majority non-White neighborhoods faring worse than majority White neighborhoods. Neighborhood differences rooted in historical segregation result in disparate outcomes for people of color, especially African American and Latino residents.