This dataset contains all service requests that were created since 01-January-2016
This dataset has the following 51 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| ADDRESS1 | address1 | text | Service request address | 746 CHAPEL ST 119 South Main Street 1049 SLEDGE AVE 0 0 N MAIN view top 100 |
| ADDRESS2 | address2 | text | Service request address2 | APT SUITE UNIT Apt 3 Apt 3/4 view top 100 |
| ADDRESS3 | address3 | text | Service request address3 | 1 2 3 4 300 view top 100 |
| AREA | area | text | Service request area | D C A E B view top 100 |
| CATEGORY | category | text | Incident category | Others Garbage Cart Maintenance Weeds Billing view top 100 |
| CE_CATEGORY | ce_category | text | Code enforcement category | VIOLATION (NS) NOT-CATEGORIZED VIOLATION (S) COURT CD view top 100 |
| CITY | city | text | City (Memphis) | MEMPHIS Memphis CORDOVA BARTLETT New Haven view top 100 |
| CLOSE_DATE | close_date | calendar_date | Date service request status changed to "Closed" | 2022-12-20T07:58:32.000 2020-05-01T05:00:00.000 2017-04-08T23:35:15.000 2020-07-12T05:00:00.000 2024-02-07T00:00:00.000 view top 100 |
| COLLECTION_DAY | collection_day | text | Scheduled collection day | 3 2 4 1 5 view top 100 |
| CREATED_BY | created_by | text | - | 3735 460101 -1 view top 100 |
| CREATED_BY_USER | created_by_user | text | User who created service request | SCF CAROLYN.FRANKLIN GIS LOVEETA.ROGERS HELEN.ANDERSON view top 100 |
| CREATION_DATE | creation_date | calendar_date | Auto-generated service request creation date (may be after user-reported REPORTED_DATE if person waited to submit request) | 2019-05-06T18:00:13.000 2019-06-18T12:00:12.000 2021-11-01T13:41:28.000 2019-05-20T12:00:12.000 2021-05-05T11:29:36.000 view top 100 |
| DEPARTMENT | department | text | City department responsible for service request (departments fall within divisions) | Solid Waste Management Code Enforcement Grounds Maintenance Environmental Maintenance Street Maintenance view top 100 |
| DISTRICT | district | text | City council district in which SR incident address is located | 6 4 7 5 2 view top 100 |
| DIVISION | division | text | City division responsible for service request | Solid Waste Management Public Works Engineering 311 Shelby County view top 100 |
| FOLLOWUP_DATE | followup_date | calendar_date | Followup date | 2017-06-19T00:00:00.000 2024-05-03T12:00:00.000 2024-05-22T12:00:00.000 2024-03-22T11:00:00.000 2016-07-15T00:00:00.000 view top 100 |
| FULL_ADDRESS | full_address | text | Full service request address with city, state and zip code | MEMPHIS TN 746 CHAPEL ST New Haven CT 06510 119 South Main Street MEMPHIS TN 38103 1049 SLEDGE AVE MEMPHIS TN 38104 0 N MAIN MEMPHIS TN view top 100 |
| GROUP_NAME | group_name | text | Group responsible for service request (similar to Division/Department) | Solid Waste Management Community Enhancement Public Works EMI Stoppage MEMPHIS view top 100 |
| INCIDENT_ID | incident_id | number | Unique incident ID | 0 7015970 7017294 7081754 7079736 view top 100 |
| INCIDENT_NUMBER | incident_number | number | Unique incident number | 2606436 2606438 2606442 2606444 2606448 view top 100 |
| INCIDENT_RESOLVED_DATE | incident_resolved_date | calendar_date | Date service request status changed to "Resolved" | 2022-12-20T07:58:32.000 2020-05-01T05:00:00.000 2020-07-12T05:00:00.000 2021-04-24T05:00:00.000 2020-06-06T05:00:00.000 view top 100 |
| INCIDENT_TYPE_ID | incident_type_id | text | Incident type ID | 10431 10507 10205 10432 10204 view top 100 |
| LAST_MODIFIED_DATE | last_modified_date | calendar_date | Date service request last modified (user-generated) | 2021-08-23T21:53:11.000 2021-09-24T21:50:25.000 2016-02-03T09:23:07.000 2021-08-16T21:53:52.000 2021-09-13T21:51:38.000 view top 100 |
| LAST_UPDATE_DATE | last_update_date | calendar_date | Date service request last updated (auto-generated) | 2021-06-26T05:00:04.000 2023-08-19T17:39:13.000 2023-06-17T17:39:24.000 2023-07-08T17:39:19.000 2022-08-27T17:39:12.000 view top 100 |
| LAST_UPDATE_LOGIN | last_update_login | text | - | 3735 460101 -1 view top 100 |
| LAST_UPDATED_BY | last_updated_by | text | - | 460101 Esri_Anonymous Sa_GISIdentitystore allie.harrison GIS311ADMIN view top 100 |
| Location 1 | location_1 | text | Incident location | MEMPHIS TN Memphis TN 746 CHAPEL ST New Haven CT 06510 MEMPHIS TN 38109 119 South Main Street MEMPHIS TN 38103 view top 100 |
| MAP_PAGE | map_page | text | - | 29-A 28-C 41-O 51-G 42-K view top 100 |
| MLGW_ON | mlgw_on | text | Last date MLGW utility services were turned on | 1983-05-12T00:00:00 1983-04-28T00:00:00 1983-05-10T00:00:00 1983-05-16T00:00:00 2016-09-10T00:00:00 view top 100 |
| MLGW_STATUS | mlgw_status | text | MLGW status | A I F N C3 Republic 04/01/19 view top 100 |
| NEXT_OPEN_TASK_DATE | next_open_task_date | calendar_date | Next open task date | 2016-04-25T08:00:00.000 2016-05-09T08:00:00.000 2017-04-24T08:00:00.000 2017-10-16T08:00:00.000 2017-06-13T08:00:00.000 view top 100 |
| NUMBER_OF_TASKS | number_of_tasks | text | Number of tasks | 1 0 2 3 4 view top 100 |
| OWNER_NAME | owner_name | text | Owner name | Nickelberry, Terence E. Kimble, Cheryl Bell, Karen R. Smith, Michael A. Millen, Kenneth Allen view top 100 |
| PARCEL_ID | parcel_id | text | - | GIS-Oracle Setup 032015 00005 032021 00001C 002008 00001C 047064 00001 view top 100 |
| POSTAL_CODE | postal_code | text | Service request zip code | 38109 38118 38106 38111 38114 view top 100 |
| REPORTED_DATE | reported_date | calendar_date | User-submitted service request report date | 2023-10-17T20:30:00.000 2023-10-17T20:26:00.000 2021-12-13T00:00:00.000 2021-12-10T00:00:00.000 2021-12-14T00:00:00.000 view top 100 |
| REQUEST_PRIORITY | request_priority | text | Request priority: High, Medium, or Low | Low Medium High Emergency MODERATE view top 100 |
| REQUEST_STATUS | request_status | text | Request status: Open, In Progress, Closed, etc. | Closed In Progress Open Pending Litigation Resolved 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.) | SWM-Missed Bulk Trash SWM-Picker Pile CW-Weeds Vacant Lots SWM-Garbage Missed CW-Weeds Vacant Houses view top 100 |
| RESOLUTION_CODE | resolution_code | text | Code indicating how the incident was resolved and/or actions taken to address the service request | SWM100 OTHER EMICRESS CVOYC SWMCT4 view top 100 |
| RESOLUTION_CODE_MEANING | resolution_code_meaning | text | Resolution code meaning | See resolution summary Please see Resolution Summary Picker Pile was removed COMP. V.O. - Yard cleaned Trash or debris was removed by crews view top 100 |
| RESOLUTION_SUMMARY | resolution_summary | text | Summary of incident resolution/actions taken | picked up p/u pu Serviced by Public Works DO NOT BILL view top 100 |
| SR_CREATION_CHANNEL | sr_creation_channel | text | Service request creation channel (phone or web) | PHONE WEB Phone Web AGENT view top 100 |
| STATE | state | text | SR state (TN) | TN Tennessee CT Tn TN. view top 100 |
| STREET_NAME | street_name | text | SR street name | TUTWILER AVE FAXON AVE WINCHESTER RD PARK AVE MACON RD view top 100 |
| SUB_DISTRICT | sub_district | text | Council sub-district in which SR incident is located | 1 2 3 4 5 view top 100 |
| SWM_CODE | swm_code | text | Solid Waste Management code | C10 C80 C3 C11 C10A view top 100 |
| TARGET_BLOCK | target_block | text | null 207 39 214 40 view top 100 | |
| ZONE | zone | text | E8 D3 D2 A2 A3 view top 100 | |
| location1 | location1 | point | {"coordinates":[-90.04925,35.14976],"type":"Point"} {"coordinates":[-90.0521356,35.1433781],"type":"Point"} {"coordinates":[-89.784962593,35.178881921],"type":"Point"} {"coordinates":[-89.783948687,35.141121175],"type":"Point"} {"coordinates":[-89.869200043,35.202502978],"type":"Point"} view top 100 | |
| SUMMARY_1 | summary_1 | text | 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 |