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

About this Dataset

Sidewalk Cafe Inspections

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-30T18:28:11.905769
Tags: business, dc, ddot, district-of-columbia, permit, restaurant, sidewalk-cafe, washington-dc

Tables

Table 1

@usgov.district_of_columbia_sidewalk_cafe_inspections.table_1

202.75 kB
579 rows
136 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "cafeid" BIGINT,
  "inspectionid" BIGINT,
  "cafename" VARCHAR,
  "inspectiondate" TIMESTAMP,
  "status" VARCHAR,
  "permitnumber" VARCHAR,
  "abranumber" VARCHAR,
  "coonumber" VARCHAR,
  "counumber" VARCHAR,
  "cafedescription" VARCHAR,
  "hassiteplan" BIGINT,
  "hasabralicense" BIGINT,
  "hascoo" BIGINT,
  "hascou" BIGINT,
  "numberoftables" DOUBLE,
  "numberofadatables" DOUBLE,
  "tablesize" VARCHAR,
  "numberofchairs" DOUBLE,
  "hasfence" BIGINT,
  "isvisibletopublic" BIGINT,
  "hascovering" BIGINT,
  "numberofumbrella" DOUBLE,
  "umbrellaclearancewhenopen" DOUBLE,
  "clearanceofawning" DOUBLE,
  "fenceheight" DOUBLE,
  "numberofgates" DOUBLE,
  "widthofgate" DOUBLE,
  "gatetypecode" VARCHAR,
  "heightofplanter" DOUBLE,
  "otherborder" VARCHAR,
  "widthofcafe" DOUBLE,
  "depthofcafe" DOUBLE,
  "totalsquarefootage" DOUBLE,
  "widthofaisle" DOUBLE,
  "lengthofclearsidewalkpath" DOUBLE,
  "distancetonearestintersection" DOUBLE,
  "nameofintersection" VARCHAR,
  "distancetonearestcrosswalk" DOUBLE,
  "hasstreettreewithin20ft" BIGINT,
  "istreegratedwithin20ft" BIGINT,
  "hasbusstopwithin20ft" BIGINT,
  "hasbusshelterwithin20ft" BIGINT,
  "hasstreetlightwithin20ft" BIGINT,
  "hastrashcanwithin20ft" BIGINT,
  "hastrafficsignalwithin20ft" BIGINT,
  "hasparkingmeterwithin20ft" BIGINT,
  "hasloadingzonewithin20ftofcurb" BIGINT,
  "hasmetparkingwithin20ftofcurb" BIGINT,
  "hasenterancewithin20ftofcurb" BIGINT,
  "hasbuszonewithin20ftofcurb" BIGINT,
  "hasnoparkingwithin20ftofcurb" BIGINT,
  "hasrushhouram" BIGINT,
  "hasrushhourpm" BIGINT,
  "valetparkingname" VARCHAR,
  "valetparkingmanager" VARCHAR,
  "valetparkingpermitnumber" VARCHAR,
  "valetparkingspace" DOUBLE,
  "hasvaletparkingsign" BIGINT,
  "parkingsigntypeid" VARCHAR,
  "hasfollowupappt" BIGINT,
  "doescafeoperateinjanuary" BIGINT,
  "doescafeoperateinfebruary" BIGINT,
  "doescafeoperateinmarch" BIGINT,
  "doescafeoperateinapril" BIGINT,
  "doescafeoperateinmay" BIGINT,
  "doescafeoperateinjune" BIGINT,
  "doescafeoperateinjuly" BIGINT,
  "doescafeoperateinaugust" BIGINT,
  "doescafeoperateinseptember" BIGINT,
  "doescafeoperateinoctober" BIGINT,
  "doescafeoperateinnovember" BIGINT,
  "doescafeoperateindecember" BIGINT,
  "starthourforopening1" VARCHAR,
  "endhourforopening1" VARCHAR,
  "operatesonsuninopening1" BIGINT,
  "operatesonmoninopening1" BIGINT,
  "operatesontueinopening1" BIGINT,
  "operatesonwedinopening1" BIGINT,
  "operatesonthuinopening1" BIGINT,
  "operatesonfriinopening1" BIGINT,
  "operatesonsatinopening1" BIGINT,
  "starthourforopening2" VARCHAR,
  "endhourforopening2" VARCHAR,
  "operatesonsuninopening2" BIGINT,
  "operatesonmoninopening2" BIGINT,
  "operatesontueinopening2" BIGINT,
  "operatesonwedinopening2" BIGINT,
  "operatesonthuinopening2" BIGINT,
  "operatesonfriinopening2" BIGINT,
  "operatesonsatinopening2" BIGINT,
  "starthourofvaletopening1" VARCHAR,
  "endhourofvaletopening1" VARCHAR,
  "valetoperatesonsuninopening1" BIGINT,
  "valetoperatesonmoninopening1" BIGINT,
  "valetoperatesontueinopening1" BIGINT,
  "valetoperatesonwedinopening1" BIGINT,
  "valetoperatesonthuinopening1" BIGINT
);