Illegal Dumpings in December 2012

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.

REQUESTID：服务请求编号。应显示为不含小数的整数。5位数的REQUESTID在2012年8月，回收热线切换至与公共工程相同的系统时导入。其余均为6位数。
DATETIMEINIT：请求发起的日期/时间。
DESCRIPTION：问题类型。其中大部分内容一目了然。备注：
“test template”和“This is a test subject. Ignore this ticket.”仅用于测试/训练目的。
以“Business”、“City Services”、“CityBldg”（无空格）、“Events”、“Misc”开头的描述曾（现）由回收热线使用。
“TE”代表“交通工程”。
REQCATEGORY：请求类别。
REQADDRESS：请求地址。ZZ地址表示地址未记录，通常此类地址用于对回收热线的普通咨询。
STATUS：截至2013年1月30日的状态。
Pending：收到请求，待审查。
OPEN：请求已分配给工作单位。
WOCREATE：已创建工作订单以执行工作（并非所有工作单位都使用此状态，因此开放的服务请求也可能创建工作订单以执行工作）。
CLOSED：请求已解决。
REFERRED：公共工程收到请求并将其转发给其他实体（见REFERREDTO）。
UNFUNDED：请求是一项公共工程未获资助提供的服务。
CANCEL：请求被取消，通常是因为请求错误创建、用于测试/训练，或接收到的请求与现有未解决请求重复。
DATETIMECLOSED：请求关闭的日期/时间。
SRX、SRY：问题的坐标。请注意，这些坐标使用的是NAD_1983_StatePlane_California_III_FIPS_0403_Feet，而非纬度/经度。
REFERREDTO：如果状态为“转发”，则显示其被转给了谁。