311 Citizen Requests for Service
311 Citizen Requests for Service
This dataset includes all requests for service received from the City-Parish 311 Call Center, including requests for service submitted online and through the Red Stick 311 mobile application, dating back to January 1, 2016. Submitter names, phone numbers, and e-mail addresses are redacted for privacy purposes. Data is updated daily from the Public Works Business Office and 311 Call Center.
Phone numbers are redacted to protect the contact information and privacy of citizens by replacing raw digits with XXX-XXX-XXXX. For any questions about this process, please contact opendata@brgov.com.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| LONGITUDE | longitude | longitude | Number | The longitude coordinates of the issue or request for service for geocoding purposes. |
| Council Districts_from_9v63_zwfd | :@computed_region_i2e6_956r | :@computed_region_i2e6_956r | Number | |
| Neighborhoods_from_qfmj_2fwi | :@computed_region_uvg4_nwq8 | :@computed_region_uvg4_nwq8 | Number | |
| ZIP Codes_from_tqy7_429i | :@computed_region_jrqt_zu77 | :@computed_region_jrqt_zu77 | Number | |
| Council Districts_2021_from_d8sa-f3ec | :@computed_region_ntzg_c2w3 | :@computed_region_ntzg_c2w3 | Number | |
| GEOLOCATION (zip) | geolocation_zip | geolocation_zip | Text | |
| GEOLOCATION (address) | geolocation_address | geolocation_address | Text | |
| GEOLOCATION (state) | geolocation_state | geolocation_state | Text | |
| DEPARTMENT | department | department | Text | The City-Parish department with oversight over the requested service or reported issue. |
| DEPTDIV ID | deptdivid | deptdivid | Text | The ID of the City-Parish department and division responsible for responding to the requested service or reported issue. |
| CLOSE DATE | closeddate | closeddate | Calendar date | The date the service request was closed due to the request as being addressed or the issue being resolved, confirmed by the responding department/division. |
| STREET NUMBER | streetnum | streetnum | Text | The street number of the address where services are needed or issues need to be resolved. |
| DEPARTMENT-DIVISION NAME | deptdiv | deptdiv | Text | The City-Parish department and division responsible for responding to the requested service or reported issue - matches that of the DeptDivID field. |
| STATUS | statusdesc | statusdesc | Text | Matches Status ID - Open, Closed, or In Progress. |
| GEOLOCATION (city) | geolocation_city | geolocation_city | Text | |
| COMMENTS | comments | comments | Text | Any comments submitted by the reporting citizen associated with the request for service or issue to be resolved. |
| CITY | cityname | cityname | Text | The city of the reported issue - Baton Rouge, Baker, Zachary, or Central. Issues reported in the unincorporated areas of East Baton Rouge Parish or without city information are reported as East Baton Rouge. |
| DIVISION | division | division | Text | The City-Parish division responsible for responding to the requested service or reported issue, which is a division of the department noted in the Department field. |
| PARENT ID | parentid | parentid | Text | The parent category ID of the type of service request (typename) as organized within the City-Parish 311 Citizen Request system. |
| GEOLOCATION | geolocation | geolocation | Point | |
| STATUS ID | status | status | Text | Status of service request 0 = Open, 1 = Closed, 3 = In Progress. |
| FULL ADDRESS | streetaddress | streetaddress | Text | The full street address where service are needed or issues need to be resolved. |
| TYPEI D | typeid | typeid | Text | The specific type of service request represented by the request ID. |
| SERVICE REQUEST ID | id | id | Text | Unique identifier assigned to each citizen request for service for tracking and resolution purposes. |
| CREATE DATE | createdate | createdate | Calendar date | The date the service request was created within the City-Parish's 311 service request and complaint tracking system, either by phone, online, or via web app. |
| LAST ACTION DATE | lastaction | lastaction | Calendar date | The date of the most recent adjustment or notation to this service request, as noted by the responding department/division. Typically, this field will match that of the closed date if a request has been resolved or closed. |
| PARENT TYPE | parenttype | parenttype | Text | The parent type of service request - matches that of the ParentID field. |
| TYPE | typename | typename | Text | A description of the type of service request represented by the request ID - matches that of the TypeID field. |
| STREET NAME | streetname | streetname | Text | The name of the street where services are needed or issues need to be resolved. |
| CROSS STREET | crossname | crossname | Text | Any cross street information available as reported by the submitting citizen (for example, at an intersection). |
| LATITUDE | latitude | latitude | Number | The latitude coordinates of the issue or request for service for geocoding purposes. |
| Zip Codes | :@computed_region_8tu6_j4iw | :@computed_region_8tu6_j4iw | Number | |
| Council District (Shapefile) | :@computed_region_hfgy_t898 | :@computed_region_hfgy_t898 | Number | |
| Neighborhood_BC | :@computed_region_92rf_uvyc | :@computed_region_92rf_uvyc | Number | |
| Council Districts | :@computed_region_9v63_zwfd | :@computed_region_9v63_zwfd | Number | |
| Neighborhoods | :@computed_region_qfmj_2fwi | :@computed_region_qfmj_2fwi | Number | |
| Shape tqy7 429i | :@computed_region_tqy7_429i | :@computed_region_tqy7_429i | Number | |
| Baton Rouge Council Districts | :@computed_region_tm4z_r3je | :@computed_region_tm4z_r3je | Number | |
| ZIP Codes | :@computed_region_8siy_mghw | :@computed_region_8siy_mghw | Number |