brla-gov/311-citizen-requests-for-service-7ixm-mnvx

 
External

311 Citizen Requests for Service

  • 311
  • public works
  • request
  • 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

NameSocrata field nameColumn name in sgr mountData typeDescription
LONGITUDElongitudelongitudeNumberThe longitude coordinates of the issue or request for service for geocoding purposes.
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
GEOLOCATION (zip)geolocation_zipgeolocation_zipText
GEOLOCATION (address)geolocation_addressgeolocation_addressText
GEOLOCATION (state)geolocation_stategeolocation_stateText
DEPARTMENTdepartmentdepartmentTextThe City-Parish department with oversight over the requested service or reported issue.
DEPTDIV IDdeptdividdeptdividTextThe ID of the City-Parish department and division responsible for responding to the requested service or reported issue.
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.
STREET NUMBERstreetnumstreetnumTextThe street number of the address where services are needed or issues need to be resolved.
DEPARTMENT-DIVISION NAMEdeptdivdeptdivTextThe City-Parish department and division responsible for responding to the requested service or reported issue - matches that of the DeptDivID field.
STATUSstatusdescstatusdescTextMatches Status ID - Open, Closed, or In Progress.
GEOLOCATION (city)geolocation_citygeolocation_cityText
COMMENTScommentscommentsTextAny comments submitted by the reporting citizen associated with the request for service or issue to be resolved.
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.
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.
PARENT IDparentidparentidTextThe parent category ID of the type of service request (typename) as organized within the City-Parish 311 Citizen Request system.
GEOLOCATIONgeolocationgeolocationPoint
STATUS IDstatusstatusTextStatus of service request 0 = Open, 1 = Closed, 3 = In Progress.
FULL ADDRESSstreetaddressstreetaddressTextThe full street address where service are needed or issues need to be resolved.
TYPEI DtypeidtypeidTextThe specific type of service request represented by the request ID.
SERVICE REQUEST IDididTextUnique identifier assigned to each citizen request for service for tracking and resolution 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.
PARENT TYPEparenttypeparenttypeTextThe parent type of service request - matches that of the ParentID field.
TYPEtypenametypenameTextA description of the type of service request represented by the request ID - matches that of the TypeID field.
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).
LATITUDElatitudelatitudeNumberThe latitude coordinates of the issue or request for service for geocoding purposes.
Zip Codes:@computed_region_8tu6_j4iw:@computed_region_8tu6_j4iwNumber
Council District (Shapefile):@computed_region_hfgy_t898:@computed_region_hfgy_t898Number
Neighborhood_BC:@computed_region_92rf_uvyc:@computed_region_92rf_uvycNumber
Council Districts:@computed_region_9v63_zwfd:@computed_region_9v63_zwfdNumber
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

Upstream Metadata