Name: Sidewalk Cafe
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-by

About this Dataset

Sidewalk Cafe

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).
Organization: District of Columbia
Last updated: 2024-04-30T17:45:36.894231
Tags: business, dc, ddot, district-of-columbia, permit, restaurant, sidewalk-cafe, washington-dc

Tables

Table 1

@usgov.district_of_columbia_sidewalk_cafe.table_1

76.52 kB
452 rows
20 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "owner" VARCHAR,
  "address" VARCHAR,
  "square" VARCHAR,
  "suffix" VARCHAR,
  "lot" VARCHAR,
  "idnum" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "mar_id" BIGINT,
  "gis_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "globalid" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "created" VARCHAR,
  "edited" TIMESTAMP,
  "dcgissidewalkcafeptarea" VARCHAR,
  "objectid" BIGINT
);