memphistn-gov/citizen-connect-open-public-works-service-requests-aiee-9zqu

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

NameSocrata field nameColumn name in sgr mountData typeDescription
POSTAL_CODEpostal_codepostal_codeTextZip code
RESOLUTION_CODE_MEANINGresolution_code_meaningresolution_code_meaningTextResolution code meaning
DISTRICTdistrictdistrictTextCouncil district in which the service request was reported
DIVISIONdivisiondivisionTextCity division responsible for service request
SR_CREATION_CHANNELsr_creation_channelsr_creation_channelTextService request creation channel (phone or web)
PARCEL_IDparcel_idparcel_idText
MAP_PAGEmap_pagemap_pageText
INCIDENT_TYPE_IDincident_type_idincident_type_idTextIncident type ID
CREATED_BY_USERcreated_by_usercreated_by_userTextUser who created service request
ADDRESS2address2address2TextService request address2
SWM_CODEswm_codeswm_codeTextSolid Waste Management code (if applicable)
CITYcitycityTextCity (Memphis)
SUB_DISTRICTsub_districtsub_districtTextCouncil sub-district in which service request was reported
NUMBER_OF_TASKSnumber_of_tasksnumber_of_tasksText
AREAareaareaTextService request area code
Location 1location_1location_1PointAddress
REQUEST_STATUSrequest_statusrequest_statusTextRequest status (this dataset includes service requests NOT marked as closed or resolved: Open, In Progress, Pending Litigation, etc.)
COLLECTION_DAYcollection_daycollection_dayTextScheduled collection day
DEPARTMENTdepartmentdepartmentTextCity department responsible for service request (within Division)
STATEstatestateTextState (TN)
CREATED_BYcreated_bycreated_byText-
REQUEST_PRIORITYrequest_priorityrequest_priorityTextRequest priority: High, Medium, or Low
Location 1 (address)location_1_addresslocation_1_addressTextLocation
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
REPORTED_DATEreported_datereported_dateCalendar dateUser-submitted service request report date
ADDRESS1address1address1TextService request address
REQUEST_TYPErequest_typerequest_typeTextRequest type (acronyms correspond to department: SWM = Solid Waste Management, EMI = Environmental Maintenance, CE = Code Enforcement, etc.)
RESOLUTION_CODEresolution_coderesolution_codeTextCode indicating how the incident was resolved and/or actions taken to address the service request
TARGET_BLOCKtarget_blocktarget_blockTextTarget block
LAST_UPDATE_LOGINlast_update_loginlast_update_loginText
CLOSE_DATEclose_dateclose_dateCalendar dateDate service request status was changed to "Closed"
OWNER_NAMEowner_nameowner_nameText
CE_CATEGORYce_categoryce_categoryTextCode enforcement incident category
STREET_NAMEstreet_namestreet_nameTextService request street name
ZONEzonezoneTextZone
CATEGORYcategorycategoryTextIncident category
LAST_MODIFIED_DATElast_modified_datelast_modified_dateCalendar dateDate service request was last modified
LAST_UPDATE_DATElast_update_datelast_update_dateCalendar dateDate service request was last updated (auto-generated)
LAST_UPDATED_BYlast_updated_bylast_updated_byTextPerson who last updated
RESOLUTION_SUMMARYresolution_summaryresolution_summaryTextSummary of incident resolution/actions taken
ADDRESS3address3address3TextService request address3
CREATION_DATEcreation_datecreation_dateCalendar dateAuto-generated date service request was created & entered in database (may be after REPORTED_DATE)
GROUP_NAMEgroup_namegroup_nameTextGroup responsible for service request (similar to Division/Department)
FOLLOWUP_DATEfollowup_datefollowup_dateCalendar dateFollowup date
INCIDENT_IDincident_idincident_idTextUnique incident ID
INCIDENT_NUMBERincident_numberincident_numberTextUnique incident number
SUMMARYsummarysummaryTextDescription of service request/issue
INCIDENT_RESOLVED_DATEincident_resolved_dateincident_resolved_dateCalendar dateDate incident status was changed to "Resolved"
NEXT_OPEN_TASK_DATEnext_open_task_datenext_open_task_dateCalendar dateNext open task date

Upstream Metadata