Add topics
Citizen Connect Open Public Works Service Requests
Citizen Connect Open Public Works Service Requests
This dataset shows Public Works Open Service Requests reported on or after January 1, 2016. This dataset is used to populate Citizen Connect page.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| POSTAL_CODE | postal_code | postal_code | Text | Zip code |
| RESOLUTION_CODE_MEANING | resolution_code_meaning | resolution_code_meaning | Text | Resolution code meaning |
| DISTRICT | district | district | Text | Council district in which the service request was reported |
| DIVISION | division | division | Text | City division responsible for service request |
| SR_CREATION_CHANNEL | sr_creation_channel | sr_creation_channel | Text | Service request creation channel (phone or web) |
| PARCEL_ID | parcel_id | parcel_id | Text | |
| MAP_PAGE | map_page | map_page | Text | |
| INCIDENT_TYPE_ID | incident_type_id | incident_type_id | Text | Incident type ID |
| CREATED_BY_USER | created_by_user | created_by_user | Text | User who created service request |
| ADDRESS2 | address2 | address2 | Text | Service request address2 |
| SWM_CODE | swm_code | swm_code | Text | Solid Waste Management code (if applicable) |
| CITY | city | city | Text | City (Memphis) |
| SUB_DISTRICT | sub_district | sub_district | Text | Council sub-district in which service request was reported |
| NUMBER_OF_TASKS | number_of_tasks | number_of_tasks | Text | |
| AREA | area | area | Text | Service request area code |
| Location 1 | location_1 | location_1 | Point | Address |
| REQUEST_STATUS | request_status | request_status | Text | Request status (this dataset includes service requests NOT marked as closed or resolved: Open, In Progress, Pending Litigation, etc.) |
| COLLECTION_DAY | collection_day | collection_day | Text | Scheduled collection day |
| DEPARTMENT | department | department | Text | City department responsible for service request (within Division) |
| STATE | state | state | Text | State (TN) |
| CREATED_BY | created_by | created_by | Text | - |
| REQUEST_PRIORITY | request_priority | request_priority | Text | Request priority: High, Medium, or Low |
| Location 1 (address) | location_1_address | location_1_address | Text | Location |
| Community Neighborhoods Boundaries 2 | :@computed_region_nyzj_ikpv | :@computed_region_nyzj_ikpv | Number | |
| Community Neighborhoods Boundaries 1 | :@computed_region_m99d_em2n | :@computed_region_m99d_em2n | Number | |
| Community Neighborhoods Boundaries | :@computed_region_dgrd_cuuf | :@computed_region_dgrd_cuuf | Number | |
| Memphis 3.0 Focus Anchors Buffers | :@computed_region_qnac_u4vd | :@computed_region_qnac_u4vd | Number | |
| City Council Super Districts | :@computed_region_stch_rtry | :@computed_region_stch_rtry | Number | |
| City Council Districts | :@computed_region_gxae_hf64 | :@computed_region_gxae_hf64 | Number | |
| Memphis 3.0 Planning Districts | :@computed_region_xf2b_u4zq | :@computed_region_xf2b_u4zq | Number | |
| Shelby County Zip Codes | :@computed_region_me95_vbw4 | :@computed_region_me95_vbw4 | Number | |
| REPORTED_DATE | reported_date | reported_date | Calendar date | User-submitted service request report date |
| ADDRESS1 | address1 | address1 | Text | Service request address |
| REQUEST_TYPE | request_type | request_type | Text | Request type (acronyms correspond to department: SWM = Solid Waste Management, EMI = Environmental Maintenance, CE = Code Enforcement, etc.) |
| RESOLUTION_CODE | resolution_code | resolution_code | Text | Code indicating how the incident was resolved and/or actions taken to address the service request |
| TARGET_BLOCK | target_block | target_block | Text | Target block |
| LAST_UPDATE_LOGIN | last_update_login | last_update_login | Text | |
| CLOSE_DATE | close_date | close_date | Calendar date | Date service request status was changed to "Closed" |
| OWNER_NAME | owner_name | owner_name | Text | |
| CE_CATEGORY | ce_category | ce_category | Text | Code enforcement incident category |
| STREET_NAME | street_name | street_name | Text | Service request street name |
| ZONE | zone | zone | Text | Zone |
| CATEGORY | category | category | Text | Incident category |
| LAST_MODIFIED_DATE | last_modified_date | last_modified_date | Calendar date | Date service request was last modified |
| LAST_UPDATE_DATE | last_update_date | last_update_date | Calendar date | Date service request was last updated (auto-generated) |
| LAST_UPDATED_BY | last_updated_by | last_updated_by | Text | Person who last updated |
| RESOLUTION_SUMMARY | resolution_summary | resolution_summary | Text | Summary of incident resolution/actions taken |
| ADDRESS3 | address3 | address3 | Text | Service request address3 |
| CREATION_DATE | creation_date | creation_date | Calendar date | Auto-generated date service request was created & entered in database (may be after REPORTED_DATE) |
| GROUP_NAME | group_name | group_name | Text | Group responsible for service request (similar to Division/Department) |
| FOLLOWUP_DATE | followup_date | followup_date | Calendar date | Followup date |
| INCIDENT_ID | incident_id | incident_id | Text | Unique incident ID |
| INCIDENT_NUMBER | incident_number | incident_number | Text | Unique incident number |
| SUMMARY | summary | summary | Text | Description of service request/issue |
| INCIDENT_RESOLVED_DATE | incident_resolved_date | incident_resolved_date | Calendar date | Date incident status was changed to "Resolved" |
| NEXT_OPEN_TASK_DATE | next_open_task_date | next_open_task_date | Calendar date | Next open task date |