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)
This dataset has the following 13 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
REQUESTID | requestid | number | 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. | 1315428 1318302 1316994 1314448 1317984 view top 100 |
DATETIMEINIT | datetimeinit | calendar_date | The Date that the request was initiated. | 2023-07-13T08:23:18.000 2023-07-24T09:15:05.000 2023-07-24T19:22:34.000 2023-07-20T12:59:59.000 2023-07-16T12:22:37.000 view top 100 |
SOURCE | source | text | Indicates if the request was received via SeeClickFix, via the Report A Problem website at www.oaklandpw.com, or via (Phone or Email). | Phone SeeClickFix view top 100 |
DESCRIPTION | description | text | 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” | Sewers - Blockage Streets - Potholes/Depression Manhole Cover - Missing view top 100 |
REQCATEGORY | reqcategory | text | Request Category | SEWERS view top 100 |
REQADDRESS | reqaddress | location | Request Address | view top 100 |
STATUS | status | text | 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 WAITING ON CUSTOMER: Request involves a process where customer needs to provide information requested by staff EVALUATED - NO FURTHER ACTION: Staff has evaluated the service request and no further action will be taken (e.g., limited resources, temporary issue, staff alerted to ongoing issue, professional judgement says to leave situation as-is, unable to provide requested action) GONE ON ARRIVAL: Staff went to location and was unable to verify the issue | OPEN REFERRED view top 100 |
REFERREDTO | referredto | text | If the status is Referred, this shows who it was referred to. | PG&E, view top 100 |
DATETIMECLOSED | datetimeclosed | calendar_date | The Date that the request was closed | view top 100 |
SRX | srx | number | Coordinates of the issue. Note that this is in NAD_1983_StatePlane_California_III_FIPS_0403_Feet, not latitude/longitude. | 6051229.03 6055473.999 6071522.652 6048442.584 6072208.126 view top 100 |
SRY | sry | number | Coordinates of the issue. Note that this is in NAD_1983_StatePlane_California_III_FIPS_0403_Feet, not latitude/longitude. | 2111569.046 2104583.434 2124071.012 2117188.958 2125872.265 view top 100 |
COUNCILDISTRICT | councildistrict | text | City Council District of the REQADDRESS. | CCD6 CCD2 CCD1 CCD3 view top 100 |
BEAT | beat | text | Police Beat | 28X 08X 01X 14X 30X view top 100 |