Sidewalk Cafe

District Department of Transportation (District of Columbia)
The dataset contains locations and attributes of sidewalk cafes provided by the District Department of Transportation. These came from DDOT's Transportation Online Permit System (TOPS).
Data Format CSV, GeoJSON, Shapefile, ArcGIS GeoServices REST API, OGC WMS, KML
Download Url https://opendata.dc.gov/api/download/v1/items/58562a06412...
Download Url Validated True
Validation Message Valid CSV data
Alternate Download Urls https://opendata.dc.gov/api/download/v1/items/5...
https://opendata.dc.gov/api/download/v1/items/5...
https://maps2.dcgis.dc.gov/dcgis/rest/services/...
Update Frequency Unknown
Last Updated 2021-11-02 (Data Last Modified); Metadata Updated: April 16, 2025
Geospatial Bounds -77.1023,38.8709,-76.9812,38.9792
Portal Type arcgis
Success True
Quality Score
100%
Usable
Yes
Total Rows
452
Valid Geometries
452 / 452

Schema Compliance

Geometry Type Point
CRS {"$schema": "https://proj.org/schemas/v0.7/projjso...
WGS84 Yes
Required Columns Yes

Spatial Bounds

SW: (-77.1023, 38.8709)
NE: (-76.9812, 38.9792)

Column Completeness

Column Completeness
id 100.0%
names 100.0%
categories 100.0%
operating_status 100.0%
addresses 100.0%
sources 100.0%
source_properties 100.0%

Top Categories

cafe (452)

Issues

Overture Comparison

cafe (auto-inferred)
Candidate POIs
452
Overture POIs
234

H3 Cell Coverage (res 10)

Candidate Cells 243
Overture Cells 205
Overlapping 57
Candidate Only 186
Overture Only 148

Coverage Ratios

Overlap Ratio
23.5%
Unique Coverage
76.5%

Density Statistics

Mean Max Min
Candidate 1.86 10 1
Overture 1.14 4 1