About this Dataset

Residential Snow Removal Service Requests

Data provided here are from the DC's 311 service request center. They represent all service requests for residential snow removal. Requests are received by the Office of Unified Communications (OUC) through the Mayor's Call Center (311), citizens web intake at 311.dc.gov, electronic and US mail service or via other methods of communication.

The Office of Unified Communications (OUC) oversees the designated call center for all 311 calls and for all District 911 calls.

Please also visit the DC 311 Service Request Map which allows the public to see service requests in the last 30 days. Users can view requests by Ward within charts. Just set the area filter to select service requests. Click on a service request to view details.
Organization: District of Columbia
Last updated: 2024-04-30T18:47:41.863549
Tags: 311, call-center, district-of-columbia, ouc, resident, service-requests, snow, washington-dc, winter

Tables

Table 1

@usgov.district_of_columbia_snow_removal_in_the_last_30_days.table_1

26.8 KB
2 rows
41 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "snowzone" BIGINT,
  "snowarea" BIGINT,
  "snowroutetype" VARCHAR,
  "snowrouteid" BIGINT,
  "servicecode" VARCHAR,
  "servicecodedescription" VARCHAR,
  "servicetypecodedescription" VARCHAR,
  "organizationacronym" VARCHAR,
  "servicecallcount" BIGINT,
  "adddate" TIMESTAMP,
  "resolutiondate" VARCHAR,
  "serviceduedate" TIMESTAMP,
  "serviceorderdate" TIMESTAMP,
  "inspectiondate" VARCHAR,
  "inspectorname" VARCHAR,
  "status_code" VARCHAR,
  "servicerequestid" VARCHAR,
  "priority" VARCHAR,
  "streetaddress" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" BIGINT,
  "maraddressrepositoryid" BIGINT,
  "ward" BIGINT,
  "se_anno_cad_data" VARCHAR,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "inspectionflag" VARCHAR,
  "serviceorderstatus" VARCHAR,
  "details" VARCHAR
);