New York City Outdoor Dining License Locations

22 columns detail licenses for sidewalk and roadway dining issued by the New York City Department of Transportation. The dataset includes business names, license status, expiration dates, and precise geographic coordinates. It is published by data.cityofnewyork.us and was last updated in April 2026.

Use Cases

• Map licensed outdoor dining locations using Latitude and Longitude coordinates to visualize spatial density across Boroughs.
• Analyze License Status and License Expiration Date to identify active, pending, or expired permits for compliance monitoring.
• Correlate business locations with demographic or zoning data by joining on Census Tract (2020), BBL, or Community Board fields.
• Assess the distribution of License Types across different City Council Districts or Police Precincts for policy review.
• Track license issuance trends over time using the License Issue Date field.

Strengths

• Dataset contains 22 distinct columns covering administrative, geographic, and temporal license details.
• Includes precise geospatial identifiers such as Latitude, Longitude, BBL, and Census Tract for location-based analysis.
• Data is actively maintained, with a last update timestamp in the future (2026-04-03), indicating planned updates.

Limitations

• The total number of rows (licensed establishments) is unknown, preventing assessment of dataset scale.
• Sample data is unavailable, making initial data quality and structure validation difficult.
• License information and data collection methodology are not specified in the provided description.

Provenance

Source

New York City Department of Transportation, published via data.cityofnewyork.us.

Collection Method

Issued as part of the administrative process for the Dining Out NYC program license applications.

Freshness

Last updated on 2026-04-03 12:31:12.

Geography

New York City, with breakdowns by Borough, Community Districts, and Neighborhood Tabulation Area (NTA).