Tyler Data & Insights

Author: Ian M
Description: 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 January 5, 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.
Category: Infrastructure
Tags: public works, service requests, pot holes, illegal dumping, maintenance
Rating: Current value: 0 out of 5
Data Provided By: City of Oakland Public Works / Department of Transportation
License: Public Domain

Dumping heat mapREQUESTID = 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 January 5, 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.Visit the full page to view this data.

This view cannot be displayed

Embed this Dataset

      <div><iframe width="_width_px" title="Dumping heat map" height="_height_px" src="https://data.oaklandca.gov/w/6px3-jz3j/default?cur=JTVZvcZ6TRV&from=9OIGRHckKNX" frameborder="0"scrolling="no"><a href="https://data.oaklandca.gov/Infrastructure/Dumping-heat-map/6px3-jz3j" title="Dumping heat map" target="_blank">Dumping heat map</a></iframe><p><a href="http://www.socrata.com/" target="_blank">Powered by Tyler Technologies</a></p></div>

Size

500x425
760x646
950x808

Custom Size

425x425 is the minimum size

Width

Height

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

REQUESTID: requestid
DATETIMEINIT: datetimeinit
SOURCE: source
DESCRIPTION: description
REQCATEGORY: reqcategory
REQADDRESS: reqaddress
STATUS: status
REFERREDTO: referredto
DATETIMECLOSED: datetimeclosed
SRX: srx
SRY: sry
COUNCILDISTRICT: councildistrict
Zip Codes: :@computed_region_w23w_jfhw

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

Tyler Data & Insights

API Endpoint:

Field Names:

OData V4 Endpoint:

OData V2 Endpoint:

Want to leave a comment?

You are leaving data.oaklandca.gov.

Notice