Dataset: Building Permits In 2011

About this Dataset

Building Permits In 2011

The dataset contains locations and attributes of building construction and alteration permits applied for and approved by the District of Columbia Department of Buildings. These data are shared via an automated process where addresses are batch matched (geocoded) to the District's Master Address Repository. Users may find that some data points will contain 0,0 for X,Y coordinates resulting in inconsistent spatial locations. Addresses for these data points could not be automatically geocoded and will need to be manually geocoded to 'best fit' locations in DC.
Organization: District of Columbia
Last updated: 2024-04-30T19:15:17.858952
Tags: building-permits, construction, dc, district-of-columbia, dob, economic, washington-dc

Tables

Table 1

@usgov.district_of_columbia_building_permits_in_2011.table_1

4.6 MB
36990 rows
44 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "dcrainternalnumber" BIGINT,
  "issue_date" TIMESTAMP,
  "permit_id" VARCHAR,
  "permit_type_name" VARCHAR,
  "permit_subtype_name" VARCHAR,
  "permit_category_name" VARCHAR,
  "application_status_name" VARCHAR,
  "full_address" VARCHAR,
  "desc_of_work" VARCHAR,
  "ssl" VARCHAR,
  "zoning" VARCHAR,
  "permit_applicant" VARCHAR,
  "fee_type" VARCHAR,
  "fees_paid" BIGINT,
  "owner_name" VARCHAR,
  "lastmodifieddate" TIMESTAMP,
  "city" VARCHAR,
  "state" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "zipcode" VARCHAR,
  "maraddressrepositoryid" BIGINT,
  "dcstataddresskey" VARCHAR,
  "dcstatlocationkey" VARCHAR,
  "ward" BIGINT,
  "anc" VARCHAR,
  "smd" VARCHAR,
  "district" VARCHAR,
  "psa" BIGINT,
  "neighborhoodcluster" VARCHAR,
  "hotspot2006name" VARCHAR,
  "hotspot2005name" VARCHAR,
  "hotspot2004name" VARCHAR,
  "businessimprovementdistrict" VARCHAR,
  "globalid" VARCHAR,
  "created_user" VARCHAR,
  "created_date" TIMESTAMP,
  "last_edited_user" VARCHAR,
  "last_edited_date" TIMESTAMP
);