About this Dataset

Permit Inspections

Permit inspections are mostly scheduled during approval (pre-inspection), after work completion (final inspection) to check if the restoration of any cut is properly done. This also includes refunds for deposits and issuing Notice of Violation (NOV).
Organization: District of Columbia
Last updated: 2024-04-30T17:49:02.640963
Tags: construction, ddot, district-of-columbia, inspection, permit, public-space, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_permit_inspections_133a2.table_1

89.43 MB
553,927 rows
31 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "inspectionid" BIGINT,
  "trackingnumber" BIGINT,
  "applicationtype" VARCHAR,
  "inspector" VARCHAR,
  "inspectorfullname" VARCHAR,
  "minutesspent" BIGINT,
  "internalnotes" VARCHAR,
  "notesforpermittee" VARCHAR,
  "creationdate" TIMESTAMP,
  "lastupdatedate" TIMESTAMP,
  "permitnumber" VARCHAR,
  "inspectiondate" TIMESTAMP,
  "permittee" VARCHAR,
  "inspectionlocation" VARCHAR,
  "inspectionstatuscode" VARCHAR,
  "inspectionstatusdesc" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "topsinsplocationid" BIGINT,
  "gis_last_mod_dttm" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR
);