Abandoned Autos CCD7 Starting 7-1-17

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)

REQUESTID = 请求ID（REQUESTID）：服务请求编号，需以无小数的整数形式展示。2012年8月，回收热线（Recycling Hotline）迁移至与奥克兰呼叫中心相同的系统时，导入的请求ID均为5位数字；其余请求ID均为6位。
DATETIMEINIT = 发起时间（DATETIMEINIT）：服务请求的发起日期。
SOURCE = 来源渠道（SOURCE）：标识服务请求的接收途径，包括SeeClickFix、奥克兰公共工程部问题上报网站www.oaklandpw.com，以及（电话或邮件）。
DESCRIPTION = 问题类型（DESCRIPTION）：服务所涉问题类别，多数条目含义明确。备注："test template"（测试模板）与"This is a test subject. Ignore this ticket."（此为测试主题，请勿处理此工单）仅用于测试或培训目的。以"Business"（业务）、"City Services"（城市服务）、"CityBldg"（无空格，市政建筑）、"Events"（活动）、"Misc"（杂项）开头的描述，曾或当前由回收热线使用；"TE"代表"Traffic Engineering（交通工程）"。
REQCATEGORY = 请求类别（REQCATEGORY）：服务请求的分类项。
REQADDRESS = 请求地址（REQADDRESS）：服务请求对应的地址。若地址为ZZ，则表示未记录该地址，此类请求通常为回收热线的通用咨询。
STATUS = 状态（STATUS）：数据上传时的请求状态，各状态说明如下：
- Pending（待审核）：请求已接收，等待审核
- OPEN（待分配）：请求已分配至执行工作单元
- WOCREATE（已创建工单）：已为待执行工作创建工作订单（并非所有执行单元都使用该状态，因此处于OPEN状态的服务请求也可能已创建工作订单）
- CLOSED（已办结）：请求已完成解决流程
- REFERRED（已转办）：奥克兰呼叫中心已接收请求，并将其转至其他主体（详见REFERREDTO字段）
- UNFUNDED（无经费支持）：请求涉及的服务未纳入本市财政预算覆盖范围
- CANCEL（已取消）：请求已取消，常见原因包括误创建、用于测试或培训，或该请求与现有未办结请求重复
DATETIMECLOSED = 办结日期（DATETIMECLOSED）：服务请求的办结时间。
SRX, SRY = 问题坐标（SRX, SRY）：需注意，该坐标采用NAD_1983_StatePlane_California_III_FIPS_0403_Feet坐标系，而非经纬度坐标系。
REFERREDTO = 转办对象（REFERREDTO）：当STATUS字段为REFERRED时，该字段显示请求转至的具体主体。
COUNCILDISTRICT = 议会选区（COUNCILDISTRICT）：请求地址所属的城市议会选区。
BEAT = 警务辖区（BEAT）：请求地址所属的警务辖区，警务辖区地图可参考http://mapgis.oaklandnet.com/PoliceDistricts/。