Icon for Socrata external plugin
  • 311_service_requests_for_fiscal_year_2013_2014
Updated 9 months ago
Indexed 5 hours ago

311 Service Requests for Fiscal Year 2013 - 2014

There are over 400 service requests types that are reported in the 311 system that affect the quality of life of our citizens, neighborhoods, and communities. The most popular service requests include but are not limited to animal services requests, high weeds, junk motor vehicles, and a number of other code compliance-related issues. Requests that deal with streets and mobility such as street and pot hole repair are also very common. 311 also receives requests to address environmental issues such as water conservation and air quality complaints.

This dataset represents all Service Requests for the fiscal year time period of October 1, 2013 to September 30, 2014.


NameSocrata field nameColumn name in sgr mountData typeDescription
Lat Long Location (state)lat_long_location_statelat_long_location_stateText
Lat Long Location (city)lat_long_location_citylat_long_location_cityText
Lat Long Location (zip)lat_long_location_ziplat_long_location_zipText
Unique Keyunique_keyunique_keyTextInternal Key
Lat Long Location (address)lat_long_location_addresslat_long_location_addressText
Lat Long Locationlat_long_locationlat_long_locationPointDenotes a location point on a longitude line (perpendicular to the equator) and latitude line (parallel to the equator)
Y Coordinatey_coordinatey_coordinateNumberDenotes a point where vertical (y axis) lines intersect on a map
X Coordinatex_coordinatex_coordinateNumberDenotes a point where (x axis) horizontal lines intersect on a map
Method Received Descriptionmethod_received_descriptionmethod_received_descriptionTextMode in which 311 receives the request for service
OutcomeoutcomeoutcomeTextDocuments the action taken on a service request
Closed Dateclosed_dateclosed_dateCalendar dateDate the service request was completed
Update Dateupdate_dateupdate_dateCalendar dateDate the service request was last updated with new information or activity
Created Datecreated_datecreated_dateCalendar dateDate the service request was created
Overall Service Request Due Dateoverall_service_request_due_dateoverall_service_request_due_dateCalendar dateThe service request and all activities should be completed by the listed date
ERT (Estimated Response Time)ert_estimated_response_timeert_estimated_response_timeNumberThe time allotted for the initial inspection and/or assessment. (There may be variance from department to department concerning calendar versus business days.)
Service Request Typeservice_request_typeservice_request_typeTextType of complaint submitted by customer or service offered by the City
DepartmentdepartmentdepartmentTextCity Departments and Offices
City Council Districtcity_council_districtcity_council_districtNumberGeographical borderlines for legislative representation throughout the city
AddressaddressaddressTextStreet Address
Service Request Numberservice_request_numberservice_request_numberTextUnique ID given to each documented request for a city service; the first two digits designate the last two digits of the calendar year the service request was created (e.g., 16 = 2016)
Zip Codes:@computed_region_3qur_xvie:@computed_region_3qur_xvieNumber
City Councils:@computed_region_at43_7y52:@computed_region_at43_7y52Number
StatusstatusstatusTextDenotes whether a service request is currently being actively worked or has been resolved
PriorityprioritypriorityTextDenotes the precedence of how a service request will be handled
Upstream Metadata