Dataset: Solar Permit Applications

About this Dataset

Solar Permit Applications

This dataset contains a subset of data from our Building Permit Application dataset. The data has been filtered to only include permit applications for solar (permit type = PVRS).

To learn more about solar energy in Cary check out our Solar Energy webpage.

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.

This data is updated daily.

Used as a part of the Solar, Cary, and You Dashboard
Organization: Town of Cary, North Carolina
Last updated: 2022-05-12T01:12:55.923826
Tags: environment, permits, solar

Tables

Table 1

@usgov.town_of_cary_north_carolina_solar_permit_applications.table_1

292.24 KB
1907 rows
41 columns


CREATE TABLE table_1 (
  "permitnum" VARCHAR,
  "description" VARCHAR,
  "issuedate" TIMESTAMP,
  "applieddate" 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" VARCHAR,
  "pin" DOUBLE,
  "contractorcompanyname" VARCHAR,
  "contractortrade" VARCHAR,
  "contractortrademapped" VARCHAR,
  "contractorphone" VARCHAR,
  "contractoraddress1" VARCHAR,
  "contractoraddress2" VARCHAR,
  "contractorzip" DOUBLE,
  "ownername" VARCHAR,
  "owneraddress1" VARCHAR,
  "owneraddress2" VARCHAR,
  "ownerzip" DOUBLE,
  "gispoint" VARCHAR,
  "year" DOUBLE,
  "year_text" DOUBLE
);