Name: Building Permits - January 1, 2005 Through March 31, 2025
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Building Permits - January 1, 2005 Through March 31, 2025

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:07.202516

Tables

Table 1

@usgov.city_of_honolulu_building_permits_january_1_2005_thru__9458bead.table_1

53.91 MB
428,097 rows
77 columns

CREATE TABLE table_1 (
  "acceptedvalue" DOUBLE,
  "addition" VARCHAR,
  "alteration" VARCHAR,
  "buildingpermitno" DOUBLE,
  "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,
  "totalfloorarea" DOUBLE,
  "typesofconstructionactual" VARCHAR,
  "typesofconstructionmin" VARCHAR,
  "bpfeescollected" DOUBLE,
  "ownershipassessed" VARCHAR,
  "structurecode" VARCHAR,
  "createddate" TIMESTAMP,
  "completeddate" TIMESTAMP,
  "commercialresidential" VARCHAR,
  "electricalmeteronly" VARCHAR,
  "ohana" VARCHAR,
  "solar" VARCHAR,
  "solarvpinstallation" VARCHAR,
  "accessorydwellingunitadu" VARCHAR,
  "applicant" VARCHAR,
  "bpfeecalculation" DOUBLE,
  "cityproject" VARCHAR,
  "datereviewscompleted" TIMESTAMP,
  "externalid" VARCHAR,
  "isstateespprojectbp" VARCHAR,
  "isstateespprojectsd" VARCHAR,
  "jobaddress" VARCHAR,
  "joblocation" VARCHAR,
  "locationpermitissued" VARCHAR,
  "numunitsadd" DOUBLE,
  "numunitsdel" DOUBLE,
  "objectid" BIGINT,
  "processreviewtype" VARCHAR,
  "stateproject" VARCHAR,
  "statusid" BIGINT,
  "tmklookup" VARCHAR,
  "coissued" VARCHAR,
  "requireaffidavit" VARCHAR,
  "existingfloorarea" DOUBLE,
  "finalcoissued" VARCHAR,
  "relocationfrom" VARCHAR,
  "relocationto" VARCHAR,
  "requirerestrictivecovenant" VARCHAR,
  "newfloorarea" DOUBLE,
  "electricvehiclecharger" VARCHAR,
  "address" VARCHAR
);