This dataset shows Public Works Open Service Requests reported on or after January 1, 2016. This dataset is used to populate Citizen Connect page.
This dataset has the following 48 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| ADDRESS1 | address1 | text | Service request address | 0 Grove Rd 1711 PENDLETON ST 3124 HARRIS AVE 5045 AIRWAYS BLVD 0 view top 100 |
| ADDRESS2 | address2 | text | Service request address2 | APT SUITE UNIT 3125 3215 view top 100 |
| ADDRESS3 | address3 | text | Service request address3 | 1 2 3 4 T view top 100 |
| AREA | area | text | Service request area code | C A D B E view top 100 |
| CATEGORY | category | text | Incident category | Inspection-Structures Weeds Miscellaneous Inspection-Vehicle Environmental Maintenance view top 100 |
| CE_CATEGORY | ce_category | text | Code enforcement incident category | VIOLATION (NS) VIOLATION (S) COURT NOT-CATEGORIZED NPA view top 100 |
| CITY | city | text | City (Memphis) | MEMPHIS Memphis BARTLETT CORDOVA Cordova view top 100 |
| CLOSE_DATE | close_date | calendar_date | Date service request status was changed to "Closed" | 2024-02-01T00:00:00.000 2024-05-14T19:00:00.000 2024-05-23T00:00:00.000 2024-05-15T18:00:00.000 2024-05-13T00:00:00.000 view top 100 |
| COLLECTION_DAY | collection_day | text | Scheduled collection day | 3 5 4 2 1 view top 100 |
| CREATED_BY | created_by | text | - | 460101 3735 view top 100 |
| CREATED_BY_USER | created_by_user | text | User who created service request | Sa_GISIdentitystore Esri_Anonymous SCF DIANA.SMITH JUDITH.NORMAN view top 100 |
| CREATION_DATE | creation_date | calendar_date | Auto-generated date service request was created & entered in database (may be after REPORTED_DATE) | 2023-10-09T12:00:36.000 2023-10-10T12:00:18.000 2023-10-05T12:00:45.000 2023-10-12T12:00:21.000 2023-10-06T12:00:32.000 view top 100 |
| DEPARTMENT | department | text | City department responsible for service request (within Division) | Code Enforcement Environmental Maintenance GROUNDS MAINTENANCE Solid Waste Management CE Commercial view top 100 |
| DISTRICT | district | text | Council district in which the service request was reported | 7 4 6 5 3 view top 100 |
| DIVISION | division | text | City division responsible for service request | Public Works Solid Waste Management view top 100 |
| FOLLOWUP_DATE | followup_date | calendar_date | Followup date | 2023-08-01T00:00:00.000 2024-05-16T00:00:00.000 2024-05-21T00:00:00.000 2024-05-17T00:00:00.000 2024-05-14T00:00:00.000 view top 100 |
| GROUP_NAME | group_name | text | Group responsible for service request (similar to Division/Department) | Community Enhancement Memphis MEMPHIS EMI Repair - New CITIZEN view top 100 |
| INCIDENT_ID | incident_id | text | Unique incident ID | 0 7075920 7001644 7084724 7086622 view top 100 |
| INCIDENT_NUMBER | incident_number | text | Unique incident number | 4522720 6398780 5766292 7096570 7071866 view top 100 |
| INCIDENT_RESOLVED_DATE | incident_resolved_date | calendar_date | Date incident status was changed to "Resolved" | 2016-07-01T22:22:31.000 2017-07-10T12:01:03.000 2018-07-25T09:28:22.000 2019-10-04T14:45:01.000 2019-10-10T11:40:03.000 view top 100 |
| INCIDENT_TYPE_ID | incident_type_id | text | Incident type ID | 10409 10396 10400 10205 10395 view top 100 |
| LAST_MODIFIED_DATE | last_modified_date | calendar_date | Date service request was last modified | 2022-07-15T21:46:45.000 2024-02-06T14:31:44.000 2022-07-15T21:47:17.000 2022-07-15T21:46:55.000 2022-07-15T21:47:16.000 view top 100 |
| LAST_UPDATE_DATE | last_update_date | calendar_date | Date service request was last updated (auto-generated) | 2024-05-25T07:20:38.000 2024-05-27T13:25:26.000 2024-05-27T14:25:26.000 2023-08-19T17:39:13.000 2022-07-23T17:39:10.000 view top 100 |
| LAST_UPDATE_LOGIN | last_update_login | text | 460101 3735 view top 100 | |
| LAST_UPDATED_BY | last_updated_by | text | Person who last updated | 460101 Esri_Anonymous Sa_GISIdentitystore allie.harrison AWPM_atummala view top 100 |
| MAP_PAGE | map_page | text | 21-H 082 22-J 152 036 view top 100 | |
| Location 1 (address) | location_1_address | text | Location | MEMPHIS TN MEMPHIS TN 38115 Memphis TN Cordova TN 38016 1711 PENDLETON ST MEMPHIS TN 38114 view top 100 |
| NEXT_OPEN_TASK_DATE | next_open_task_date | calendar_date | Next open task date | 2023-10-09T08:00:00.000 2023-10-10T08:00:00.000 2023-10-05T08:00:00.000 2023-10-12T08:00:00.000 2023-10-06T08:00:00.000 view top 100 |
| NUMBER_OF_TASKS | number_of_tasks | text | 2 0 3 5 4 view top 100 | |
| OWNER_NAME | owner_name | text | Muhammad, Anthony Nelson, Roderick D Hill, Cori W Sr. Rivers, Deborah Nelson, Roderick Dejuan view top 100 | |
| PARCEL_ID | parcel_id | text | 074090 00079 D0209 00546 047073 00028 059042 00011 079087 00059C view top 100 | |
| POSTAL_CODE | postal_code | text | Zip code | 38116 38109 38111 38122 38118 view top 100 |
| REPORTED_DATE | reported_date | calendar_date | User-submitted service request report date | 2024-05-14T19:00:00.000 2024-05-16T19:00:00.000 2024-05-13T19:00:00.000 2024-05-15T19:00:00.000 2024-05-08T19:00:00.000 view top 100 |
| REQUEST_PRIORITY | request_priority | text | Request priority: High, Medium, or Low | Low Medium High Emergency view top 100 |
| REQUEST_STATUS | request_status | text | Request status (this dataset includes service requests NOT marked as closed or resolved: Open, In Progress, Pending Litigation, etc.) | In Progress Open Pending Litigation Back to Department Back to MCSC view top 100 |
| REQUEST_TYPE | request_type | text | Request type (acronyms correspond to department: SWM = Solid Waste Management, EMI = Environmental Maintenance, CE = Code Enforcement, etc.) | CE-Substandard,Derelict Struc CE-Code Miscellaneous CE-Vehicle Violations CW-Weeds Vacant Lots CE-Junky Yard view top 100 |
| RESOLUTION_CODE | resolution_code | text | Code indicating how the incident was resolved and/or actions taken to address the service request | VOYC CTCNT FM-7 VOM VIOLATION view top 100 |
| RESOLUTION_CODE_MEANING | resolution_code_meaning | text | Resolution code meaning | V.O. Yard/Vehicle No Progress Form 11 Complete Hearing missed - FORM 7 Court case continued V.O. for miscellaneous view top 100 |
| RESOLUTION_SUMMARY | resolution_summary | text | Summary of incident resolution/actions taken | Property in Violation Active NPA case Active NPA Case ��� WROTE UP PROPERTY TO BE REHABBED view top 100 |
| SR_CREATION_CHANNEL | sr_creation_channel | text | Service request creation channel (phone or web) | WEB PHONE Web Phone view top 100 |
| STATE | state | text | State (TN) | TN Tennessee CT view top 100 |
| STREET_NAME | street_name | text | Service request street name | WINCHESTER RD CHELSEA AVE LAMAR AVE FAXON AVE PENDLETON ST view top 100 |
| SUB_DISTRICT | sub_district | text | Council sub-district in which service request was reported | 5 2 3 4 1 view top 100 |
| SUMMARY | summary | text | Description of service request/issue | Not Applicable NPA court date set for 8/31/2023 at 10:00 AM. COURT DATE 02/16/2024 @ 9:00AM. NPA COURT DATE SET FOR 2/8/2024 @ 10:00AM. NPA COURT DATE SET FOR 1/18/2024 @ 10:00AM. view top 100 |
| SWM_CODE | swm_code | text | Solid Waste Management code (if applicable) | C10 C3 C11 C80 C20 view top 100 |
| TARGET_BLOCK | target_block | text | Target block | null 39 40 192 128 view top 100 |
| ZONE | zone | text | Zone | C2 A2 D3 A1 C1 view top 100 |
| Location 1 | location_1 | point | Address | {"coordinates":[-89.748246027,35.196687842],"type":"Point"} {"coordinates":[-90.0521356,35.1433781],"type":"Point"} {"coordinates":[-89.970708978,35.098144987],"type":"Point"} {"coordinates":[-89.988098997,35.14116301],"type":"Point"} {"coordinates":[-89.958505011,35.090838985],"type":"Point"} view top 100 |