memphistn-gov/service-requests-since-2016-hmd4-ddta
Icon for Socrata external plugin
 
Preview
  • service_requests_since_2016
     
 
Readme
Updated 12 hours ago
Indexed 27 minutes ago

Service Requests since 2016

This dataset contains all service requests that were created since 01-January-2016

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
South City:@computed_region_ni4r_4h6x:@computed_region_ni4r_4h6xNumber
City Council Districts:@computed_region_gxae_hf64:@computed_region_gxae_hf64Number
Shelby County Zip Codes:@computed_region_me95_vbw4:@computed_region_me95_vbw4Number
AREAareaareaTextService request area
ZONEzonezoneText
RESOLUTION_CODE_MEANINGresolution_code_meaningresolution_code_meaningTextResolution code meaning
REQUEST_TYPErequest_typerequest_typeTextRequest type (acronyms correspond to department: SWM = Solid Waste Management, EMI = Environmental Maintenance, CE = Code Enforcement, etc.)
REPORTED_DATEreported_datereported_dateCalendar dateUser-submitted service request report date
POSTAL_CODEpostal_codepostal_codeTextService request zip code
INCIDENT_RESOLVED_DATEincident_resolved_dateincident_resolved_dateCalendar dateDate service request status changed to "Resolved"
GROUP_NAMEgroup_namegroup_nameTextGroup responsible for service request (similar to Division/Department)
FULL_ADDRESSfull_addressfull_addressTextFull service request address with city, state and zip code
CREATION_DATEcreation_datecreation_dateCalendar dateAuto-generated service request creation date (may be after user-reported REPORTED_DATE if person waited to submit request)
CREATED_BY_USERcreated_by_usercreated_by_userTextUser who created service request
CLOSE_DATEclose_dateclose_dateCalendar dateDate service request status changed to "Closed"
ADDRESS1address1address1TextService request address
REQUEST_STATUSrequest_statusrequest_statusTextRequest status: Open, In Progress, Closed, etc.
DEPARTMENTdepartmentdepartmentTextCity department responsible for service request (departments fall within divisions)
PARCEL_IDparcel_idparcel_idText-
INCIDENT_TYPE_IDincident_type_idincident_type_idTextIncident type ID
INCIDENT_NUMBERincident_numberincident_numberTextUnique incident number
CITYcitycityTextCity (Memphis)
CE_CATEGORYce_categoryce_categoryTextCode enforcement category
SWM_CODEswm_codeswm_codeTextSolid Waste Management code
DISTRICTdistrictdistrictTextCity council district in which SR incident address is located
location1location1location1Point
STATEstatestateTextSR state (TN)
ADDRESS2address2address2TextService request address2
Memphis 3.0 Planning Districts:@computed_region_xf2b_u4zq:@computed_region_xf2b_u4zqNumber
SC Quarter Mile Buffer:@computed_region_h7zg_xcqb:@computed_region_h7zg_xcqbNumber
MAP_PAGEmap_pagemap_pageText-
LAST_MODIFIED_DATElast_modified_datelast_modified_dateCalendar dateDate service request last modified (user-generated)
TARGET_BLOCKtarget_blocktarget_blockText
REQUEST_PRIORITYrequest_priorityrequest_priorityTextRequest priority: High, Medium, or Low
LAST_UPDATE_LOGINlast_update_loginlast_update_loginText-
CREATED_BYcreated_bycreated_byText-
NEXT_OPEN_TASK_DATEnext_open_task_datenext_open_task_dateCalendar dateNext open task date
STREET_NAMEstreet_namestreet_nameTextSR street name
NUMBER_OF_TASKSnumber_of_tasksnumber_of_tasksTextNumber of tasks
INCIDENT_IDincident_idincident_idTextUnique incident ID
LAST_UPDATE_DATElast_update_datelast_update_dateCalendar dateDate service request last updated (auto-generated)
Location 1location_1location_1TextIncident location
RESOLUTION_CODEresolution_coderesolution_codeTextCode indicating how the incident was resolved and/or actions taken to address the service request
SUB_DISTRICTsub_districtsub_districtTextCouncil sub-district in which SR incident is located
SR_CREATION_CHANNELsr_creation_channelsr_creation_channelTextService request creation channel (phone or web)
CATEGORYcategorycategoryTextIncident category
COLLECTION_DAYcollection_daycollection_dayTextScheduled collection day
ADDRESS3address3address3TextService request address3
DIVISIONdivisiondivisionTextCity division responsible for service request
RESOLUTION_SUMMARYresolution_summaryresolution_summaryTextSummary of incident resolution/actions taken
FOLLOWUP_DATEfollowup_datefollowup_dateCalendar dateFollowup date
LAST_UPDATED_BYlast_updated_bylast_updated_byText-
OWNER_NAMEowner_nameowner_nameTextOwner name
Upstream Metadata