SweepNYC Street Cleaning
This dataset contains NYC Street Centerline (CSCL) physical_IDs which represent segments of streets and the date and time those street segments were last visited by a mechanical broom. This dataset is connected to SweepNYC (nyc.gov/sweepnyc), a tool maintained by the NYC Department of Sanitation (DSNY) that allows New Yorkers to track the progress of DSNY mechanical brooms. The mechanical broom, also known as a street sweeper, is New York City's first line of defense against dirty curbs. Each one picks up 1,500 lbs. of litter on a single shift. For information on how to file a street sweeping complaint see the article on NYC 311.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Due
- Says it updates
- Daily
- Actually updates about every
- 1 days
- Publisher last updated the data
- Oct 6, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 5, 2026, 3:34 PM
- Rows in our copy
- 9,621,082
- Rows at the source
- 9,621,082
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
0 of 3 columns carry a concept; 3 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
physical_id | Physical ID | A unique ID assigned to intersection stretches of a street. This unique ID is the key that can be used to join SweepNYC data to NYC Street Centerline (CSCL) data. | Not bound | Text | physical_id | text | — | |
date_visited | Date Visited | Date and time when street segment was last associated with a GPS signal emitted from a DSNY Mechanical Broom during that segment's allowed sweep time frame. | Not bound | Calendar date | date_visited | timestamp | — | |
cscl_version | CSCL Version | The version of the Citywide Street Centerline (CSCL) used to generate the record's Physical ID. Citywide Street Centerline is a road-bed representation of New York City streets containing address ranges and other information such as traffic directions, road types, and segment types. | Not bound | Text | cscl_version | text | — |
Download
This file was produced on Oct 5, 2026, 10:12 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/c23c-uwsm
- Version
- Content hash:
d930d672bb3610ac244dd5f38c9e32d491b9074e37c3da5c42bdbb106af7f2c2 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 5, 2026, 3:34 PM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 5, 2026, 9:06 PM | full_replace | success | 9,621,082 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 4, 2026, 10:01 PM | full_replace | success | 9,608,271 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 4, 2026, 9:00 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 3, 2026, 10:15 PM | full_replace | success | 9,608,020 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 3, 2026, 9:00 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 2, 2026, 9:06 PM | full_replace | success | 9,592,256 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 1, 2026, 10:30 PM | full_replace | success | 9,568,578 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 1, 2026, 9:18 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 30, 2026, 10:15 PM | full_replace | success | 9,552,577 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 30, 2026, 9:03 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |