All license plate reader data (ALPR)

The Access to Preventive Care Topic includes two Indicators that measure preventable hospitalizations related to acute and chronic disease, and one that measures health insurance. Non-White Oaklanders are more likely to be hospitalized for conditions that could have been prevented by having better access to preventive care. They are also more likely to be uninsured, which is a major deterrent to accessing preventive health services. Poverty and immigration status may make it even more likely for racial and ethnic minorities to lack insurance and forego needed care.

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.

Shotspotter Data 11288

A safe, clean, and healthy environment is a key component of neighborhood quality. The three Indicators in this Topic explored different attributes of neighborhoods that have an impact on resident health. The first Indicator compared park quality in Council District 1 and Council District 7. The second Indicator compared the rates of service request for illegal dumping in majority Latino and majority White census tracts. The third Indicator compared the pollution burden score in majority Asian and majority White census tracts.

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.

This Indicator measures the median response times of calls for service that were routed to patrol. The measurement is broken down between Priority 1 and Priority 2 calls as well as by police area. Priority 1 Calls are defined as those that include potential danger for serious injury to persons, prevention of violent crimes, serious public hazards, felonies in progress with possible suspect on scene. Priority 2 Calls are defined as urgent but not an emergency situation, hazardous / sensitive matters, in-progress misdemeanors and crimes where quick response may facilitate apprehension of suspect(s). There are 5 police areas in Oakland each of which consist of a defined set of police beats and therefore cover a specific geographic part of Oakland. For more information and maps of areas, see here: http://www2.oaklandnet.com/government/o/OPD/o/BFO/index.htm