About this Dataset

Building Permit Applications

This dataset contains information on building permit applications in the Town of Cary.

This file is created from the Town of Cary permit application data. It has been created to conform to the BLDS open data specification for building permit data (permitdata.org). In the Town of Cary, a permit application may result in the creation of several permits. Rows in this table represent applications for permits, not individual permits. Individual permits may be released as a separate dataset. With the exception of a few fields, we have applied all of the required and preferred fields of the required dataset for permits.

For additional information check out our Applications & Forms webpage.
Organization: Town of Cary, North Carolina
Last updated: 2020-11-12T13:15:14.188486
Tags: blds, building, contractors, electrical, mechanical, permits, plumbing

Tables

Table 1

@usgov.town_of_cary_north_carolina_building_permit_applications.table_1

8.37 MB
81,585 rows
42 columns

CREATE TABLE table_1 (
  "permitnum" VARCHAR,
  "description" VARCHAR,
  "issuedate" TIMESTAMP,
  "applieddate" TIMESTAMP,
  "completeddate" TIMESTAMP,
  "coissueddate" TIMESTAMP,
  "statuscurrent" VARCHAR,
  "originaladdress1" VARCHAR,
  "originaladdress2" VARCHAR,
  "originalcity" VARCHAR,
  "originalstate" VARCHAR,
  "originalzip" DOUBLE,
  "jurisdiction" VARCHAR,
  "permitclass" VARCHAR,
  "permitclassmapped" VARCHAR,
  "statuscurrentmapped" VARCHAR,
  "workclass" VARCHAR,
  "workclassmapped" VARCHAR,
  "permittype" VARCHAR,
  "permittypemapped" VARCHAR,
  "permittypedesc" VARCHAR,
  "statusdate" TIMESTAMP,
  "totalsqft" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "projectcost" BIGINT,
  "housingunits" DOUBLE,
  "pin" DOUBLE,
  "contractorcompanyname" VARCHAR,
  "contractortrade" VARCHAR,
  "contractortrademapped" VARCHAR,
  "contractorphone" VARCHAR,
  "contractoraddress1" VARCHAR,
  "contractoraddress2" VARCHAR,
  "contractorzip" DOUBLE,
  "ownername" VARCHAR,
  "owneraddress1" VARCHAR,
  "owneraddress2" VARCHAR,
  "ownerzip" VARCHAR,
  "gispoint" VARCHAR,
  "year" DOUBLE,
  "year_text" DOUBLE
);