The District of Columbia

311 Service Requests

by Office of Unified Communications (OUC)

Keywords
About: Government operations, Transparency, Accountability, DC Data warehouse, Nuisance abatement, Service requests, Department of Public Works, District Department of Transportation, DPW, DDOT, Department of Health, DOH, Mayor's Call Center, 727-1000, Office of Customer Service Operations, Abandoned Bicycles, Abandoned Vehicles, Alley Cleaning, Alley Lights, Alley Repair, Autumn Leaf Collection, Bulk Collection, Curb & Gutter Repair, Dead Animal, Eviction, Graffiti, Grass & Weeds Mowing, Illegal Dumping, Litter Can Service or Repair, Parking Enforcement, Parking Meters, Pavement Markings, Potholes, Rat Abatement, Recycling Bin, Recycling Collection, Residential Parking Permit, Sanitation Enforcement, Sidewalk Repair, Signs - Parking, Signs - Street Name, Street Cleaning, Street Repair, Streetlight Repair, Supercan, Traffic Signals, Traffic Signs, Trash Collection, Tree Maintenance, Utility Cuts Repair, Vacant Lot, Yard Waste Collection, Mayors Call Center, Office of Unified Communications, OUC
Taking place at: Washington, D.C., District of Columbia, DC

Abstract

311 Service Requests. The dataset contains locations and attributes of service requests received by the Office of Customer Service Operations of the Office of Unified Communications (OUC) through the Mayor's Call Center (311), citizens web intake, electronic and US mail service or via other methods of communication.

The Customer Service Operations recently upgraded the system of capturing and tracking service requests. As a result there are major changes in classification of service requests, duration days to complete, capturing and tracking performed activities. The dataset shows inspection flag, inspection date,and resolution only for the most recent activity. Please note that the changes affected service requests statuses. The deviation in statistics of open and closed service requests made in old and new systems is expected.

All historic data from 1999 year up to 08/21/09 was migrated to the new system. The old service request numbers are converted into strings '09-########', where 8-digit part after a dash is an old service request number with padded zeroes at the beginning. Example: service request number '23456' is converted into '09-00023456'.

The source database for service requests dataset is automatically accessed every hour Monday to Sunday.

Purpose

This dataset has been created by Citywide Data Warehouse program. The mission of the Citywide Data Warehouse is to provide timely and accurate information for decision-making; support executive and agency management in the implementation of business processes which will guarantee access to useful and well-organized information for DC Government workers, non-governmental organizations, and the public.

Access constraints

Contact the Citywide Data Warehouse Program: CityDW@dc.gov. Any data obtained outside of the Citywide Data Warehouse program are unauthorized copies.

Use constraints

By using data made available here the user agrees to all the conditions stated in the terms and conditions described under the District portal, http://dc.gov/page/terms-and-conditions-use-district-data?

Point of contact

Citywide Data Warehouse Program

441 4th Street NW, Suite 930 South
Washington DC, 20001, USA

fax: 202-727-5660
hours: Monday to Friday 8:30am -5pm

Credits

Mayor's Call Center
Office of Unified Communications (OUC) Office of Customer Service Operations
DC Office of the Chief Technology Officer (OCTO) Citywide Data Warehouse

Data accuracy

Accuracy: Service requests and service delivery do not correspond in a one-to-one fashion; a request for filling a pothole will prompt the filling of multiple potholes (often recorded in the hundreds) and this is only recorded in freetext notes. This makes straightforward quantitative analysis difficult.

Horizontal positional accuracy: Uses DC GIS Master Address Repository (MAR) to assign coordinates, coordinates for features in public space (trees, light poles, etc.) will be assigned to the recorded address, not actual x,y coordinates.

Vertical positional accuracy: N/A

Lineage / Sources

 

Distribution

Distribution liability: Neither the District of Columbia Government nor the Office of the Chief Technology Officer (OCTO) makes any claims as to the completeness, accuracy or content of any data contained in this application; makes any representation of any kind, including, but not limited to, warranty of the accuracy or fitness for a particular use; nor are any such warranties to be implied or inferred with respect to the information or data furnished herein. The data is subject to change as modifications and updates are complete. It is understood that the information contained in the dataset is being used at one's own risk.

Distributed by
Citywide Data Warehouse Program

441 4th St NW, Suite 930 South
Washington DC, 20001, USA

fax: (202) 727-5660
hours: Monday to Friday 8:30 am - 5:30 pm

Entity

SERVICE_REQUESTS / Office of Unified Communications
Service Request

Attributes

  • SERVICEREQUESTID / Office of Unified Communications
    Unique identifier assigned to the service request
  • SERVICEPRIORITY / Office of Unified Communications
    Priority
  • SERVICECODE / Office of Unified Communications
    Service request type code
  • SERVICECODEDESCRIPTION / Office of Unified Communications
    Service request type code description
  • SERVICETYPECODE / Office of Unified Communications
    Type of service request
  • SERVICETYPECODEDESCRIPTION / Office of Unified Communications
    Description of service request type
    • ANC / Advisory Neighborhood Commissions
    • CSO / Customer Service Operations
    • DOH / Department Of Health
    • DDOT / Department Of Transportation
    • DMV / Department Of Motor Vehicles
    • DPW / Department Of Public Works
    • EMA / Emergency Management Agency
    • EOM / Executive Office Of The Mayor
    • FM / Facilities Maintenance
    • HIV / Human Immunodeficiency Virus Administration
    • IPMA / Infrastructure Project Management Adminstration
    • MPD / Metropolitan Police Dept.
    • OCA / Office of the City Administrator
    • OCO / Office of Community Outreach
    • OCTO / Office of the Chief Technology Officer
    • OCTO - GIS / Office of the Chief Technology Officer - Geographic Information System
    • ORM / Office Of Risk Management
    • OUC / Office Of Unified Communications
    • ONS / Office of Neighborhood Services
    • SIOD / System Inspection & Oversight Division
    • TCO / Traffic Control Operations
    • TOA / Transportation Operations Administration
  • SERVICEORDERDATE / Office of Unified Communications
    Service order date
  • SERVICEORDERSTATUS / Office of Unified Communications
    Status of the service
    • Open
    • Closed
    • Open overdue
    • Closed overdue
  • SERVICECALLCOUNT / Office of Unified Communications
    Numbers of calls associated with the particular service request
  • AGENCYABBREVIATION  / Office of Unified Communications
    Abbreviation of the agency responsible
  • INSPECTIONFLAG / Office of Unified Communications
    A flag stating if the most recent activity for the service resuest is complete or not
  • INSPECTIONDATE / Office of Unified Communications
    The date the most recent activity is completed
  • RESOLUTION / Office of Unified Communications
    Description of resolution made upon the completion of the most recent activity
  • RESOLUTIONDATE / Office of Unified Communications
    Date the request was resolved
  • SERVICEDUEDATE / Office of Unified Communications
    Date due to close the service type. Most services have standard closure rates
  • SERVICENOTES / Office of Unified Communications
    Comments entered to further describe the service request
  • PARENTSERVICEREQUESTID / Office of Unified Communications
    Identifier for a service request who is a parent of this service
  • ADDDATE / Office of Unified Communications
    Date the request was entered in the system; this date may be different from the problem date
  • LASTMODIFIEDDATE / Office of Unified Communications
    Date service request was last updated
    Due to conversion to another system on 09/22/2009 the vast majority of historic data has the last modified date as 09/22/2009.
  • SITEADDRESS  / Office of Unified Communications
    Address where service is requested
  • LATITUDE  / CityDW
    Latitude
  • LONGITUDE  / CityDW
    Longitude
  • ZIPCODED  / CityDW
    Zipcode
  • MARADDRESSREPOSITORYID  / CityDW
    Master Address Repository ID
  • DCSTATADDRESSKEY / CITYDW
    CityDW program address identifier
  • DCSTATLOCATIONKEY  / CityDW
    CityDW Location Key
  • WARD  / CityDW
    Ward
  • ANC  / CityDW
    Advisory Neighborhood Commission
  • SMD  / CityDW
    Single Member District
  • DISTRICT  / CityDW
    District
  • PSA  / CityDW
    Police Service Area
  • NEIGHBORHOODCLUSTER  / CityDW
    Neighborhood Cluster
  • HOTSPOT2006NAME  / CityDW
    Hotspot Name for 2006
  • HOTSPOT2005NAME  / CityDW
    Hotspot Name for 2005
  • HOTSPOT2004NAME  / CityDW
    Hotspot Name for 2004

Metadata

FGDC Content Standards for Digital Geospatial Metadata / FGDC-STD-001-1998 as of 07/25/2007

Provided by
Citywide Data Warehouse Program

441 4th St NW, Suite 930 South
Washington DC, 20001, USA

fax: (202) 727-5660
hours: Monday to Friday 8:30 am - 5 pm