brla-gov/311-citizen-requests-for-service-7ixm-mnvx
Icon for Socrata external plugin
 
Preview
  • 311_citizen_requests_for_service
     
 
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

NameSocrata field nameColumn name in sgr mountData typeDescription
GEOLOCATION (city)geolocation_citygeolocation_cityText
Neighborhoods:@computed_region_qfmj_2fwi:@computed_region_qfmj_2fwiNumber
Shape tqy7 429i:@computed_region_tqy7_429i:@computed_region_tqy7_429iNumber
Baton Rouge Council Districts:@computed_region_tm4z_r3je:@computed_region_tm4z_r3jeNumber
ZIP Codes:@computed_region_8siy_mghw:@computed_region_8siy_mghwNumber
Council Districts_from_9v63_zwfd:@computed_region_i2e6_956r:@computed_region_i2e6_956rNumber
Neighborhoods_from_qfmj_2fwi:@computed_region_uvg4_nwq8:@computed_region_uvg4_nwq8Number
ZIP Codes_from_tqy7_429i:@computed_region_jrqt_zu77:@computed_region_jrqt_zu77Number
Council Districts_2021_from_d8sa-f3ec:@computed_region_ntzg_c2w3:@computed_region_ntzg_c2w3Number
STATUS IDstatusstatusTextStatus of service request 0 = Open, 1 = Closed, 3 = In Progress.
Council Districts:@computed_region_9v63_zwfd:@computed_region_9v63_zwfdNumber
PARENT IDparentidparentidTextThe parent category ID of the type of service request (typename) as organized within the City-Parish 311 Citizen Request system.
DEPTDIV IDdeptdividdeptdividTextThe ID of the City-Parish department and division responsible for responding to the requested service or reported issue.
FULL ADDRESSstreetaddressstreetaddressTextThe full street address where service are needed or issues need to be resolved.
GEOLOCATION (zip)geolocation_zipgeolocation_zipText
GEOLOCATION (state)geolocation_stategeolocation_stateText
GEOLOCATIONgeolocationgeolocationPoint
SERVICE REQUEST IDididTextUnique identifier assigned to each citizen request for service for tracking and resolution purposes.
DEPARTMENTdepartmentdepartmentTextThe City-Parish department with oversight over the requested service or reported issue.
STATUSstatusdescstatusdescTextMatches Status ID - Open, Closed, or In Progress.
LATITUDElatitudelatitudeNumberThe latitude coordinates of the issue or request for service for geocoding purposes.
TYPEI DtypeidtypeidTextThe specific type of service request represented by the request ID.
CLOSE DATEcloseddatecloseddateCalendar dateThe date the service request was closed due to the request as being addressed or the issue being resolved, confirmed by the responding department/division.
CITYcitynamecitynameTextThe 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_addressgeolocation_addressText
COMMENTScommentscommentsTextAny comments submitted by the reporting citizen associated with the request for service or issue to be resolved.
PARENT TYPEparenttypeparenttypeTextThe parent type of service request - matches that of the ParentID field.
STREET NUMBERstreetnumstreetnumTextThe street number of the address where services are needed or issues need to be resolved.
Neighborhood_BC:@computed_region_92rf_uvyc:@computed_region_92rf_uvycNumber
Council District (Shapefile):@computed_region_hfgy_t898:@computed_region_hfgy_t898Number
STREET NAMEstreetnamestreetnameTextThe name of the street where services are needed or issues need to be resolved.
CROSS STREETcrossnamecrossnameTextAny cross street information available as reported by the submitting citizen (for example, at an intersection).
DIVISIONdivisiondivisionTextThe 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.
LONGITUDElongitudelongitudeNumberThe longitude coordinates of the issue or request for service for geocoding purposes.
CREATE DATEcreatedatecreatedateCalendar dateThe 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 DATElastactionlastactionCalendar dateThe 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.
TYPEtypenametypenameTextA description of the type of service request represented by the request ID - matches that of the TypeID field.
DEPARTMENT-DIVISION NAMEdeptdivdeptdivTextThe 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_j4iwNumber
Upstream Metadata