Permits Issued By Building Safety
City of Tempe
@usgov.city_of_tempe_building_permits_issued
City of Tempe
@usgov.city_of_tempe_building_permits_issued
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
);
Anyone who has the link will be able to view this.