Name: Building Permits - January 1, 2005 Thru December 31, 2016
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Building Permits - January 1, 2005 Thru December 31, 2016

This file is a static view of Building Permit data. This snapshot of data is an extract from the source database as of the moment of the snapshot's creation. A snapshot does not reflect changes that occur in the live data source.
Organization: City of Honolulu
Last updated: 2020-11-10T17:00:10.823030

Tables

Table 1

@usgov.city_of_honolulu_building_permits_january_1_2005_thru__246ad4d5.table_1

23.48 MB
245574 rows
53 columns


CREATE TABLE table_1 (
  "jobid" BIGINT,
  "acceptedvalue" DOUBLE,
  "addition" VARCHAR,
  "alteration" VARCHAR,
  "buildingpermitno" BIGINT,
  "buildingpermittype" VARCHAR,
  "contractor" VARCHAR,
  "contractorelectrical" VARCHAR,
  "contractorplumbing" VARCHAR,
  "curbingtypes" VARCHAR,
  "demolition" VARCHAR,
  "electricalwork" VARCHAR,
  "estimatedvalueofwork" DOUBLE,
  "externalfilenum" VARCHAR,
  "fence" VARCHAR,
  "finalstories" DOUBLE,
  "floodhazardcomplied" VARCHAR,
  "floodhazardexempt" VARCHAR,
  "foundationonly" VARCHAR,
  "issuedate" TIMESTAMP,
  "newbuilding" VARCHAR,
  "numroomsadd" DOUBLE,
  "numroomsdel" DOUBLE,
  "occupancygroupassessed" VARCHAR,
  "occupancygroupcategory" VARCHAR,
  "occupancygroupresidential" VARCHAR,
  "otherwork" VARCHAR,
  "planmaker" VARCHAR,
  "plumbingwork" VARCHAR,
  "pool" VARCHAR,
  "proposeduse" VARCHAR,
  "repair" VARCHAR,
  "retainingwall" VARCHAR,
  "shellonly" VARCHAR,
  "sidewalktypes" VARCHAR,
  "statusdescription" VARCHAR,
  "tmk" VARCHAR,
  "electrical_vehicle_charger" VARCHAR,
  "totalfloorarea" DOUBLE,
  "typesofconstructionactual" VARCHAR,
  "typesofconstructionmin" VARCHAR,
  "bpfeescollected" DOUBLE,
  "ownershipassessed" VARCHAR,
  "structurecode" VARCHAR,
  "createddate" VARCHAR,
  "completeddate" VARCHAR,
  "commercialresidential" VARCHAR,
  "electricalmeteronly" VARCHAR,
  "ohana" VARCHAR,
  "solar" VARCHAR,
  "solarvpinstallation" VARCHAR,
  "accessorydwellingunitadu" VARCHAR,
  "location_1" VARCHAR
);