memphistn-gov/citizen-connect-closed-public-works-service-2244-gnrp

Add topics

Citizen Connect Closed Public Works Service Requests

Citizen Connect Closed Public Works Service Requests

This dataset shows closed public works service requests reported on or after January 1, 2020, for Citizen Connect.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
LAST_UPDATED_BYlast_updated_bylast_updated_byTextPerson who last updated request
Location 1location1location1Point
POSTAL_CODEpostal_codepostal_codeTextService request zip code
CITYcitycityTextService request city
RESOLUTION_SUMMARYresolution_summaryresolution_summaryTextSummary of incident resolution/actions taken
RESOLUTION_CODE_MEANINGresolution_code_meaningresolution_code_meaningTextResolution code meaning
LAST_UPDATE_DATElast_update_datelast_update_dateCalendar dateDate request was last updated
TARGET_BLOCKtarget_blocktarget_blockText
DISTRICTdistrictdistrictTextCouncil district in which the service request was reported
STREET_NAMEstreet_namestreet_nameTextStreet name
SUB_DISTRICTsub_districtsub_districtTextSub-district in which the service request was reported
MAP_PAGEmap_pagemap_pageText
FOLLOWUP_DATEfollowup_datefollowup_dateCalendar dateFollowup date
NUMBER_OF_TASKSnumber_of_tasksnumber_of_tasksTextNumber of tasks
INCIDENT_TYPE_IDincident_type_idincident_type_idTextIncident type ID
ADDRESS3address3address3Text
DIVISIONdivisiondivisionTextCity division responsible for the service request
STATEstatestateTextService request state
CREATED_BYcreated_bycreated_byTextSR creator
INCIDENT_IDincident_idincident_idTextUnique incident ID
DEPARTMENTdepartmentdepartmentTextResponsible city department within each division
LAST_MODIFIED_DATElast_modified_datelast_modified_dateCalendar dateDate the service request was last updated
AREAareaareaText
REQUEST_STATUSrequest_statusrequest_statusTextRequest status: All incidents in this dataset are Closed
SR_CREATION_CHANNELsr_creation_channelsr_creation_channelTextService request creation channel (phone or web)
LAST_UPDATE_LOGINlast_update_loginlast_update_loginText
REQUEST_PRIORITYrequest_priorityrequest_priorityTextRequest priority: High, Medium, or Low
COLLECTION_DAYcollection_daycollection_dayText
ADDRESS2address2address2Text
Community Neighborhoods Boundaries 2:@computed_region_nyzj_ikpv:@computed_region_nyzj_ikpvNumber
Community Neighborhoods Boundaries 1:@computed_region_m99d_em2n:@computed_region_m99d_em2nNumber
Community Neighborhoods Boundaries:@computed_region_dgrd_cuuf:@computed_region_dgrd_cuufNumber
Memphis 3.0 Focus Anchors Buffers:@computed_region_qnac_u4vd:@computed_region_qnac_u4vdNumber
City Council Super Districts:@computed_region_stch_rtry:@computed_region_stch_rtryNumber
City Council Districts:@computed_region_gxae_hf64:@computed_region_gxae_hf64Number
Memphis 3.0 Planning Districts:@computed_region_xf2b_u4zq:@computed_region_xf2b_u4zqNumber
Shelby County Zip Codes:@computed_region_me95_vbw4:@computed_region_me95_vbw4Number
FULL_ADDRESSfull_addressfull_addressTextFull incident/service request address with city, state & zip code
SWM_CODEswm_codeswm_codeTextSolid Waste Management code
PARCEL_IDparcel_idparcel_idTextParcel ID
GROUP_NAMEgroup_namegroup_nameTextGroup responsible for service request (similar to Division/Department)
NEXT_OPEN_TASK_DATEnext_open_task_datenext_open_task_dateCalendar dateNext open task date
RESOLUTION_CODEresolution_coderesolution_codeTextCode indicating how the incident was resolved and/or actions taken to address the service request
CREATED_BY_USERcreated_by_usercreated_by_userTextUser who created the service request
INCIDENT_RESOLVED_DATEincident_resolved_dateincident_resolved_dateCalendar dateDate incident was marked "Resolved"
CREATION_DATEcreation_datecreation_dateCalendar dateAuto-generated report creation date (may be after the actual incident date if user submits request later - see REPORTED_DATE for user-reported date)
ZONEzonezoneText
CLOSE_DATEclose_dateclose_dateCalendar dateDate service request was closed
REQUEST_TYPErequest_typerequest_typeTextRequest type (acronyms correspond to department: SWM = Solid Waste Management, EMI = Environmental Maintenance, CE = Code Enforcement, etc.)
CATEGORYcategorycategoryTextIncident category
CE_CATEGORYce_categoryce_categoryTextCode enforcement category, if applicable
ADDRESS1address1address1TextService request incident address
OWNER_NAMEowner_nameowner_nameTextOwner name
REPORTED_DATEreported_datereported_dateCalendar dateUser-submitted service request report date
INCIDENT_NUMBERincident_numberincident_numberTextUnique incident number

Upstream Metadata