Information about development services permits such as building commercial, residential and signs. See also https://citydata.mesaaz.gov/Development-Services/Building-Permits/2gkz-7z4f. Included: All building permits applied. Not Included: Applications for Documents or Services, Code Compliance Complaints, Planning Cases, or Engineering Projects. It is assumed that all permits have been issued based on meeting all building and zoning codes.
This dataset has the following 76 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| RowID | rowid | text | Unique Row Identifier | 10 100 1000 10000 100000 view top 100 |
| Permit Number | permit_number | text | The case/permit number used to refer to this application or permit record This number consists of: 1) A three-character prefix (BLD or PMT, which means a building permit); 2) A four or two digit year (the year in which the application was made); 3) A hyphen; 4) A five digit sequential number | PMT18-02588 AFP17-02394 BLD2003-00560 AFP18-01864 AFP18-01869 view top 100 |
| Property Address | property_address | text | The street address where the construction will take place | 5001 E MAIN ST 4700 E MAIN ST 1452 S ELLSWORTH RD 8700 E UNIVERSITY DR 1350 S GREENFIELD RD view top 100 |
| Street Number | street_number | text | The street number of the property address where the construction will take place | 5001 8700 1452 4700 2550 view top 100 |
| Street Direction | street_direction | text | The street direction of the property address where the construction will take place | E S N W S. view top 100 |
| Street Name | street_name | text | The street name of the property address where the construction will take place | MAIN SOUTHERN UNIVERSITY BASELINE ELLSWORTH view top 100 |
| Street Type | street_type | text | The street type of the property address where the construction will take place | AVE RD ST DR CIR view top 100 |
| Unit Num | unit_num | text | The Unit Number of Property Address | 101 103 102 104 105 view top 100 |
| Council District | council_district | text | City Council District Associated with Property Address | 6 5 2 1 4 view top 100 |
| Fiscal Year | fiscal_year | text | The Fiscal Year in which the permit was issued. | FY05-06 FY03-04 FY04-05 FY06-07 FY16-17 view top 100 |
| Issued Date | issued_date | calendar_date | The date the permit was issued by the City of Mesa, allowing construction to begin | 2018-09-26T00:00:00.000 2005-06-02T00:00:00.000 2007-04-26T00:00:00.000 2007-04-17T00:00:00.000 2006-02-17T00:00:00.000 view top 100 |
| Issued Year | issued_year | text | The year the permit was issued by the City of Mesa. | 2005 2004 2006 2007 2017 view top 100 |
| Issued Month | issued_month | text | The month the permit was issued by the City of Mesa | Mar Apr May Aug Jun view top 100 |
| Finaled Date | finaled_date | calendar_date | The date the final inspection was completed. There can be NO work done after this date. | 2018-09-26T00:00:00.000 2014-08-21T00:00:00.000 2005-05-09T00:00:00.000 2015-03-23T00:00:00.000 2014-09-04T00:00:00.000 view top 100 |
| Finaled Year | finaled_year | text | The year the final inspection was completed. | 2018 2017 2021 2019 2020 view top 100 |
| Finaled Month | finaled_month | text | The month the final inspection was completed. | Mar May Aug Apr Oct view top 100 |
| Permit Year | permit_year | text | The year when the permit was issued by City of Mesa | 2005 2004 2006 2007 2018 view top 100 |
| Status | status | text | The current status of the permit, which is one of these: Under Review, Approved, Issued, Finaled (meaning project is completed), Void | Finaled Issued C of O Issued C of C Issued Revisions Required view top 100 |
| Description of work | description_of_work | text | A brief description of the work to be done, sometimes includes location information | ELECTRICAL PERMIT TO REPLACE 200AMP SERVICE LIKE FOR LIKE AT EXISTING SFR, TO BE INSTALLED PER 2005 NEC AND SRP SPECIFICATIONS. NO PLANS REQUIRED. MASTER PLAN 5-A,B,C -- FOR TWO STORY TRIPLEX UNITS WITH ATTACHED 2 CAR GARAGES FOR THE PALMS AT COUNTRY CLUB MASTER PLAN FOR WASHER AND DRYER HOOK UPS. INSPECTIONS WILL BE PER BLDG. PERMIT. REFERENCE MASTER PLAN AT PERMIT ISSUANCE.. SEE ADDENDUM MST2015-00209 MASTER PLAN 6 - FOR TWO STORY TRIPLEX UNITS WITH ATTACHED 2 CAR GARAGES FOR THE PALMS AT COUNTRY CLUB Cadence Multi-Family-Plan 2 Associated with PMT20-08710 includes a single story 969 SF residence with new gas and electrical meters. Water is master metered. Special Inspections for Hercuwall, foam insulation, intumescent coating and post tension slabs view top 100 |
| Permit Type | permit_type | text | Type of permit: COM = Commercial construction; RES = Residential construction; SVC = Application for Service(s) | RES COM SIGN view top 100 |
| ICC Value | icc_value | number | The dollar value of the work to be done based on valuation rates furnished by the International Code Council (ICC) | 0 2000 2500 5000 25000 view top 100 |
| Job Value | job_value | number | Job value, Total Value or Total Project Valuation as entered by the applicant | 0 1000 2000 2500 5000 view top 100 |
| Type of Work | type_of_work | text | A more specific description of the Use | Res (SFR) -- Single Family (Detached) Single Family (Detached) Res (MSC) -- Swimming Pool Res (OTH) -- Additions Com (OTH) -- Renovations/Remodels view top 100 |
| Contractor Name | contractor_name | text | The name of the contractor associated with the permit, if any | MBI BUILDERS LLC CALIFORNIA POOLS & SPAS CAL-AM CONSTRUCTION SERVICES FARNSWORTH HOMES TAYLOR MORRISON/ARIZONA INC view top 100 |
| Contractor Address | contractor_address | text | The address of the contractor associated with the permit, if any | 3321 E BASELINE RD GILBERT AZ 85234 525 E BASELINE RD GILBERT AZ 85233 385 CLINTON ST COSTA MESA CA 92626 15111 N PIMA RD SUITE #100 SCOTTSDALE AZ 85260 16767 N PERIMETER DR SCOTTSDALE AZ 85260 view top 100 |
| Contractor City | contractor_city | text | The city of the contractor associated with the permit, if any | MESA PHOENIX SCOTTSDALE GILBERT TEMPE view top 100 |
| Contractor State | contractor_state | text | The state of the contractor associated with the permit, if any | AZ CA TX UT CO view top 100 |
| Contractor Zip | contractor_zip | text | The zip code of the contractor associated with the permit, if any | 85233 85234 85210 85260 85282 view top 100 |
| Contractor Phone | contractor_phone | text | The phone number of the contractor associated with the permit, if any | 480-344-7000 4802134039 480-892-4492 4807552110 4808404064 view top 100 |
| Contractor Email | contractor_email | text | The email address of the contractor associated with the permit, if any | riderpermitservice@yahoo.com tlarsen@taylormorrison.com CHRISTA@BLANDFORDHOMES.COM roberts@dvmhs.net RIDERPERMITSERVICE@YAHOO.COM view top 100 |
| Contractor License | contractor_license | text | The contractor license number associated with the permit, if any | 228129 319376 246034 KB-01 8469 I 10 g 179178B view top 100 |
| Change of Occupancy Date | cofo_date | calendar_date | Date Certificate of Occupancy issued | 2022-03-23T00:00:00.000 2023-09-27T00:00:00.000 2020-11-25T00:00:00.000 2022-03-24T00:00:00.000 2022-12-19T00:00:00.000 view top 100 |
| Change of Occupancy Month | cofo_month | text | Month Certificate of Occupancy issued | Oct Nov Dec May Apr view top 100 |
| Change of Occupancy Year | cofo_year | text | Year of Certificate of Occupancy issued | 2019 2020 2023 2022 2018 view top 100 |
| Parcel Number | parcel_number | text | The primary parcel number associated with this permit This number is assigned by Maricopa County and consists of: Book Number (first three characters); Page Number (next two characters); Parcel Number (last three or four characters) | MASTER PLAN 14022003H 21807014X 30403008R 14022001E view top 100 |
| Total Square Feet | total_square_feet | number | The total square footage for work being accomplished by this permit | 0 400 120 420 360 view top 100 |
| Applicant | applicant | text | The name of the person that applied for the permit | MBI BUILDERS LLC Stacy Palfreyman CALIFORNIA POOLS & SPAS PULTE HOMES WILLIAM LYON HOMES INC view top 100 |
| Number of Dwellings | number_of_dwellings | number | The number of buildings considered to be dwellings for this project. | 1 0 3 2 4 view top 100 |
| Number of Dwelling Units | number_of_dwelling_units | number | The number of units or apartments for this project. | 1 0 3 6 12 view top 100 |
| New Residential Permit | new_residential_permit | text | 'Y' if this is a permit for a new residential building, or 'N' if otherwise. | N Y view top 100 |
| Record ID | record_id | text | Internal Record identifier assigned by the system | MESA-REC18-00000-005PR MESA-REC17-00000-001EJ MESA-REC17-00000-00580 MESA-REC17-00000-001EV MESA-REC17-00000-001F1 view top 100 |
| Permit Module | permit_module | text | Record Module (e.g. Permits, Licences etc) | Permits view top 100 |
| Record Type | record_type | text | Type of Permit (e.g. Residential, Commericial, Sign) | Residential Permit Commercial Permit Sign Permit Mobile Home Annual Facilities Permit view top 100 |
| Permits ID | permits_id | text | Permits ID (Internal Use) | Permits-Residential-NA-NA Permits-Commercial-NA-NA Permits-Sign-NA-NA Permits-Residential-Mobile.cHome-NA Permits-Commercial-Annual.cFacilities-NA view top 100 |
| Application Name | application_name | text | Application or Job Name as identified by applicant | NSFR SWIMMING POOL PLUMBING SWIMMING POOL NO GAS ELECTRICAL view top 100 |
| Opened Date | opened_date | calendar_date | Date record opened (aka File Date) | 2018-09-25T00:00:00.000 2003-08-06T00:00:00.000 2020-12-14T00:00:00.000 2018-10-01T00:00:00.000 2018-03-01T00:00:00.000 view top 100 |
| Update Date | update_date | calendar_date | Date Updated | 2017-10-09T00:00:00.000 2003-08-04T00:00:00.000 2004-06-17T00:00:00.000 2004-03-12T00:00:00.000 2003-08-15T00:00:00.000 view top 100 |
| Reported Date | reported_date | calendar_date | Reported Date | 2017-06-23T00:00:00.000 2017-06-22T00:00:00.000 2018-04-19T00:00:00.000 2017-06-27T00:00:00.000 2021-10-13T13:10:00.000 view top 100 |
| Status Date | status_date | calendar_date | Date status changed | 2024-06-03T00:00:00.000 2018-09-26T00:00:00.000 2024-05-30T00:00:00.000 2024-06-04T00:00:00.000 2019-07-11T00:00:00.000 view top 100 |
| Tracking ID | tracking_id | number | Internal Tracking identifier assigned by the system | 261954479 13 2738 17 26 view top 100 |
| Application Class | application_class | text | Indicates whether or not the application is finished | COMPLETE view top 100 |
| Short Notes | short_notes | text | Notes entered by the applicant | 1 2 3 4 5 view top 100 |
| Reported Channel | reported_channel | text | Channel used to report (e.g. telephone - Used for Code, not permits) | Call Center view top 100 |
| Created by | created_by | text | UserID of person who created the record | PUBLICUSER254786 PUBLICUSER251835 PUBLICUSER242270 PUBLICUSER176590 PUBLICUSER181290 view top 100 |
| Product Name Identifier | product_name_identifier | text | Tracks where the application's information was entered | ACA AV360 view top 100 |
| Total Fee Assessed | total_fee_assessed | number | Total fees assessed | 0 343.2 228.8 280.8 187.2 view top 100 |
| Total Fee Invoiced | total_fee_invoiced | number | Total fees paid | 0 343.2 228.8 280.8 187.2 view top 100 |
| Balance | balance | number | Remaining balance to be paid | 0 4658 124.8 58.8 228.8 view top 100 |
| Booking | booking | text | Not used by permits | FALSE view top 100 |
| Infraction | infraction | text | Not used by permits | FALSE view top 100 |
| Misdemenor | misdemenor | text | Not used by permits | FALSE view top 100 |
| Offense Witnessed | offense_witnessed | text | Not used by permits | FALSE view top 100 |
| Public Owned | public_owned | text | Not used by permits | FALSE view top 100 |
| Created by Cloning | created_by_cloning | text | Indicates record created by cloning another record (used with subdivisions) | FALSE TRUE view top 100 |
| Assigned Date | assigned_date | calendar_date | Date Assigned | view top 100 |
| Assigned Department | assigned_department | text | Department the workflow is assigned to | MESA/PLNEXAM/NA/NA/NA/NA/NA MESA/PERMIT/NA/NA/NA/NA/NA MESA/PLANNING/NA/NA/NA/NA/NA MESA/ENGINEER/NA/NA/NA/NA/NA MESA/ADMIN/NA/NA/NA/NA/NA view top 100 |
| Completed Date | completed_date | calendar_date | Date Completed | view top 100 |
| Closed Date | closed_date | calendar_date | Date Closed | 2019-07-11T00:00:00.000 2019-06-04T00:00:00.000 2022-03-23T00:00:00.000 2019-06-12T00:00:00.000 2022-12-19T00:00:00.000 view top 100 |
| Closed by Department | closed_by_department | text | Department of the staff member who closed the permit | MESA/PERMIT/NA/NA/NA/NA/NA MESA/ADMIN/NA/NA/NA/NA/NA MESA/PLNEXAM/NA/NA/NA/NA/NA MESA/ENGINEER/NA/NA/NA/NA/NA MESA/PLANNING/NA/NA/NA/NA/NA view top 100 |
| Completed by Department | completed_by_department | text | Department of the staff member who completed the permit | view top 100 |
| Assigned User | assigned_user | text | UserID of person assigned to the permit | SDOMING RLEMCKE CSPILLERS DSANDOV LDAVIS2 view top 100 |
| Closed by User | closed_by_user | text | UserID of person who closed the permit | ADMIN DWHITE SWILLI3 TWOOD CBLACKM view top 100 |
| Latitude | latitude | number | The latitude for the location associated with this permit | 33.414659 33.422602 33.417712 33.391942 33.370806 view top 100 |
| Longitude | longitude | number | The longitude for the location associated with this permit | -111.724278 -111.643484 -111.731311 -111.642179 -111.638035 view top 100 |
| Location | location | point | Geocoded location associated with this permit. | {"coordinates":[-111.724278,33.414659],"type":"Point"} {"coordinates":[-111.643484,33.422602],"type":"Point"} {"coordinates":[-111.731311,33.417712],"type":"Point"} {"coordinates":[-111.642179,33.391942],"type":"Point"} {"coordinates":[-111.638035,33.370806],"type":"Point"} view top 100 |
| FiscalYear | fiscalyear | text | FY05-06 FY03-04 FY04-05 FY06-07 FY16-17 view top 100 |