potholereports

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.

服务请求编号（REQUESTID）：需以无小数的整数形式呈现。2012年8月，回收热线（Recycling Hotline）切换至与公共工程部其他部门统一的追踪系统时，从原有系统导入的请求编号均为5位；其余请求编号均为6位。
请求发起日期（DATETIMEINIT）：请求被提交的日期。
请求来源（SOURCE）：标识请求的接收渠道，包括SeeClickFix、奥克兰公共工程部官网www.oaklandpw.com的“上报问题”页面，或（电话/邮件）。
问题描述（DESCRIPTION）：问题类型，多数条目含义清晰。备注："test template"与"This is a test subject. Ignore this ticket."仅用于测试或培训目的。以"Business""City Services""CityBldg"（无空格）、"Events""Misc"开头的描述为回收热线过往或当前所用；"TE"代表"交通工程（Traffic Engineering）"。
请求类别（REQCATEGORY）：请求所属类别。
请求地址（REQADDRESS）：请求对应的地址。若地址为ZZ，则表示未记录该地址，此类请求通常为回收热线的通用咨询。
请求状态（STATUS）：截至2015年10月6日的请求状态，各状态含义如下：
- 待审核（Pending）：已接收请求，等待审核
- 待分配（OPEN）：请求已分配至对应工作单元
- 已创建工单（WOCREATE）：已为待执行工作创建工作订单（并非所有工作单元都会使用该状态，因此处于OPEN状态的服务请求也可能已创建工作订单）
- 已结案（CLOSED）：请求已解决
- 已转办（REFERRED）：公共工程部已接收请求并转至其他主体（详见转办对象（REFERREDTO）字段）
- 无资金支持（UNFUNDED）：请求对应的服务公共工程部无资金予以提供
- 已取消（CANCEL）：请求已取消，通常原因包括错误创建、用于测试/培训，或为重复提交的未解决请求
结案日期（DATETIMECLOSED）：请求被结案的日期。
问题坐标（SRX, SRY）：问题的地理坐标。需注意其坐标系为NAD_1983_StatePlane_California_III_FIPS_0403_Feet，而非经纬度坐标。
转办对象（REFERREDTO）：若请求状态为"已转办"，该字段将显示请求被转至的主体。
市议会选区（COUNCILDISTRICT）：请求地址所属的市议会选区。