Street Sweeping Schedule

This dataset contains the street sweeping schedule for 2016. Public Works mechanically sweeps each street in Cambridge once per month, April through December (weather permitting). Signs are posted on each residential street indicating the schedule, which differs by city district and street side. In order to ensure that streets are properly cleaned, cars must move off the side of the street being swept to avoid being ticketed and towed. The Cambridge Open Data portal contains a related dataset called Street Sweeping Districts, which is a polygon layer illustrating the districts on a map. That dataset is available here: https://data.cambridgema.gov/Geographic-Information-GIS-/Street-Sweeping-Districts/upm7-2w6p.

Street sweeping does not occur on holidays. Sweeping that would otherwise fall on a holiday is rescheduled for an alternate date. This dataset indicates when sweeping is rescheduled for an alternate day due to a holiday. Holiday schedule is:

Patriot's Day, April 18th will be swept on April 29th

Independence Day, July 4th will be swept on June 29th

Labor Day, September 5th will be swept on August 29th

Columbus Day, October 10th will be swept on September 29th

Veteran's Day, November 11th will be swept on October 31st

Thanksgiving Day, November 24th will be swept on November 29th

Christmas holiday, December 26th -will be swept on December 29th

In addition to neighborhood sweeping, City squares are cleaned daily: on weekdays from 7 am to 3 pm, weekends and holidays from 4 am to 8 am (street sweeping) and 6 am to 10 am (hand-cleaning crew). Litter barrels in squares are emptied twice daily on weekdays and three times daily on weekends.

See the Cambridge street sweeping webpage at:http://www.cambridgema.gov/theworks/ourservices/streetcleaning/schedulesandroutes

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cambridgema-gov/street-sweeping-schedule-uvf3-2xt3\".\"street_sweeping_schedule\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.