Readme
Updated 7 hours ago
‧ Indexed 26 minutes ago
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 |
|---|---|---|---|---|
| GEOLOCATION (city) | geolocation_city | geolocation_city | Text | |
| 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 | |
| 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 | |
| STATUS ID | status | status | Text | Status of service request 0 = Open, 1 = Closed, 3 = In Progress. |
| Council Districts | :@computed_region_9v63_zwfd | :@computed_region_9v63_zwfd | Number | |
| 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. |
| DEPTDIV ID | deptdivid | deptdivid | Text | The ID of the City-Parish department and division responsible for responding to the requested service or reported issue. |
| FULL ADDRESS | streetaddress | streetaddress | Text | The full street address where service are needed or issues need to be resolved. |
| GEOLOCATION (zip) | geolocation_zip | geolocation_zip | Text | |
| GEOLOCATION (state) | geolocation_state | geolocation_state | Text | |
| GEOLOCATION | geolocation | geolocation | Point | |
| SERVICE REQUEST ID | id | id | Text | Unique identifier assigned to each citizen request for service for tracking and resolution purposes. |
| DEPARTMENT | department | department | Text | The City-Parish department with oversight over the requested service or reported issue. |
| STATUS | statusdesc | statusdesc | Text | Matches Status ID - Open, Closed, or In Progress. |
| LATITUDE | latitude | latitude | Number | The latitude coordinates of the issue or request for service for geocoding purposes. |
| TYPEI D | typeid | typeid | Text | The specific type of service request represented by the request ID. |
| 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. |
| 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. |
| GEOLOCATION (address) | geolocation_address | geolocation_address | Text | |
| COMMENTS | comments | comments | Text | Any comments submitted by the reporting citizen associated with the request for service or issue to be resolved. |
| PARENT TYPE | parenttype | parenttype | Text | The parent type of service request - matches that of the ParentID field. |
| STREET NUMBER | streetnum | streetnum | Text | The street number of the address where services are needed or issues need to be resolved. |
| Neighborhood_BC | :@computed_region_92rf_uvyc | :@computed_region_92rf_uvyc | Number | |
| Council District (Shapefile) | :@computed_region_hfgy_t898 | :@computed_region_hfgy_t898 | Number | |
| 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). |
| 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. |
| LONGITUDE | longitude | longitude | Number | The longitude coordinates of the issue or request for service for geocoding 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. |
| TYPE | typename | typename | Text | A description of the type of service request represented by the request ID - matches that of the TypeID field. |
| 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. |
| Zip Codes | :@computed_region_8tu6_j4iw | :@computed_region_8tu6_j4iw | Number |
Upstream Metadata