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 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 October 6, 2015. 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 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.

The Employment Topic includes three Indicators that measure participation in the workforce, an essential component of economic wellbeing. The first Indicator in this Topic measures disparities in the rate of disconnectedness from school or work among young people ages 16 to 24 between African Americans and Asians. The second Indicator measures disparities in labor force participation, while the third Indicator focuses on disparities in unemployment, both between African American and White Oaklanders.

Oakland has a long history of activism around issues of inequity and social justice. 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.

According to the records of the City Clerk (the City's local filing officer), the Oakland Public Ethics Commission has identified the campaign finance disclosure filers in this table as non-responsive (NR) filers. NR filers are those that have not responded to two or more written notices and one or more verbal notices regarding past-due campaign finance reporting. Please note that Public Ethics Commission records are subject to change and the table below may not include all NR filers or reflect recent activity. The NR filers are encouraged to contact the Commission because continued failure to file may result in an enforcement action. Posted NR filers are removed from the list after filing their past-due campaign statement(s) or five years have elapsed since the applicable filing deadline.

Building Footprints created from Aerial Imagery 2002-2003

This dataset includes all itemized accrued expenses ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "F" Accrued Expenses (Unpaid Bills) 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