Non-Permit Inspections by US Government | Transportation and Logistics

About this Dataset

Non-Permit Inspections

These are cases of inspections for work being performed without a permit. For instance, a mobile crane at public space without a permit or construction of a fence without a permit.
Organization: District of Columbia
Last updated: 2024-04-30T17:48:51.347295
Tags: construction, ddot, district-of-columbia, inspection, non-permit, permit, public-space, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_non_permit_inspections.table_1

5.72 MB
36539 rows
35 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "inspectionid" BIGINT,
  "incidentcasenumber" BIGINT,
  "mainward" DOUBLE,
  "assignedinspector" VARCHAR,
  "inspectorfullname" VARCHAR,
  "incidentname" VARCHAR,
  "incidentstatuscode" VARCHAR,
  "incidentstatusdesc" VARCHAR,
  "problemcode" VARCHAR,
  "probelmdescription" VARCHAR,
  "requester" VARCHAR,
  "responderfirstname" VARCHAR,
  "responderlastname" VARCHAR,
  "minutesspent" BIGINT,
  "internalnotes" VARCHAR,
  "notesforpermittee" VARCHAR,
  "creationdate" TIMESTAMP,
  "lastupdatedate" TIMESTAMP,
  "inspectiondate" TIMESTAMP,
  "inspectionlocation" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "topsinsplocationid" BIGINT,
  "gis_last_mod_dttm" VARCHAR,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR
);