About this Dataset

Permits Issued By Building Safety

The dataset contains data extracted from multiple tables that are part of the City of Tempe's instance of Accela Civic Platform. Data is extracted from Accela Civic Platform, transformed to meet the minimum requirements of the Building and Land Data Specification (BLDS), and loaded into its final state that is shown here.

The permits issued dashboard can be found here: Permits Issued by Building Safety

Additional Information:

Source: Accela
Contact: Jacob Payne
Contact E-Mail: Jacob_Payne@tempe.gov
Data Source Type: Table
Preparation Method: Manual
Publish Frequency: Weekly
Publish Method: Manual
Data Dictionary
Organization: City of Tempe
Last updated: 2024-02-09T15:02:09.641565
Tags: building-permits, building-safety, community-development, engineering-permits, open-data, permits, permitting, planning, public-data

Tables

Table 1

@usgov.city_of_tempe_building_permits_issued.table_1

1.74 MB
14,750 rows
46 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "permitnum" VARCHAR,
  "description" VARCHAR,
  "applieddate" TIMESTAMP,
  "applieddatedtm" TIMESTAMP,
  "issueddate" TIMESTAMP,
  "issueddatedtm" TIMESTAMP,
  "completeddate" TIMESTAMP,
  "completeddatedtm" TIMESTAMP,
  "type" VARCHAR,
  "statuscurrent" VARCHAR,
  "originaladdress1" VARCHAR,
  "originaladdress2" VARCHAR,
  "originalcity" VARCHAR,
  "originalstate" VARCHAR,
  "originalzip" DOUBLE,
  "permitclass" VARCHAR,
  "permittype" VARCHAR,
  "permittypedesc" VARCHAR,
  "statusdate" VARCHAR,
  "statusdatedtm" VARCHAR,
  "totalsqft" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "estprojectcost" DOUBLE,
  "housingunits" BIGINT,
  "contractorcompanyname" VARCHAR,
  "contractorlicnum" VARCHAR,
  "expiresdate" TIMESTAMP,
  "expiresdatedtm" TIMESTAMP,
  "coissueddate" TIMESTAMP,
  "coissueddatedtm" TIMESTAMP,
  "voiddate" TIMESTAMP,
  "voiddatedtm" TIMESTAMP,
  "projectname" VARCHAR,
  "fee" DOUBLE,
  "contractorphone" VARCHAR,
  "contractoraddress1" VARCHAR,
  "contractoraddress2" VARCHAR,
  "contractorcity" VARCHAR,
  "contractorstate" VARCHAR,
  "contractorzip" VARCHAR,
  "contractoremail" VARCHAR,
  "zone" VARCHAR
);