PLI Permits

**NOTE: The data pipeline for this dataset has been switched to a new feed which should alleviate the previous problem of partial updates (you can still check [agency counter](https://pittsburghpa.agencycounter.com/) to verify the completeness of the records published here). However, we are still working on restoring the `owner_name` field, so, for now, some owner names (beyond the redacted ones) may be missing.**

# Overview
The City of Pittsburgh’s Permits, Licenses, and Inspections (PLI) Department regulates construction in Pittsburgh. This dataset contains records of permits issued by PLI from 2019-06-01 until the present. Permit records dating back to 2012 may be found in [this historical datasets of PLI permits](https://data.wprdc.org/dataset/city-of-pittsburgh-building-permit-summary).

# Motivation
These permit records are used to manage permitting data by City employees and can be used to understand when permits are issued, the nature of the work, where work is occurring, and the dollar value of the project. 

# Collection
The permit records in this dataset are drawn from the Computronix (CX) system which is used to manage these permits. 

There are four general classes of permits that are present in these data (building permits, mechanical permits, electrical permits, and “general” permits). Building permits pertain to new construction or construction updates to existing properties. Mechanical permits are obtained for installation or alterations to systems in a building such as HVAC, gas systems, boilers, etc. Electrical permits are required for new work or upgrades to electrical systems such as electrical panels, generators, or wiring. "General permits" is a miscellaneous class that contains the following permit types:

- [LAND OPERATIONS PERMIT](https://pittsburghpa.gov/pli/land-ops-permit)
- [SIGN PERMIT](https://pittsburghpa.gov/pli/sign-permit)
- [OCCUPANT LOAD PLACARD PERMIT](https://pittsburghpa.gov/pli/occupant-load-placard)
- [OCCUPANCY ONLY PERMIT](https://pittsburghpa.gov/pli/cert-occupancy)
- [SUPPRESSION SYSTEM PERMIT](https://pittsburghpa.gov/pli/fire-suppression-permit)
- [FIRE ALARM PERMIT](https://pittsburghpa.gov/pli/commercial-fire-alarm)
- [DEMOLITION PERMIT](https://pittsburghpa.gov/pli/private-demo)
- [STORM WATER PERMIT](https://pittsburghpa.gov/pli/commercial-stormwater-permit)
- FLOOD PLAIN PERMIT
- PLAN REVIEW MEETING 

**Update**: The Building and Development Application (BDA) went live in June 2024. This new application replaced both the primary PLI permit type (the Building Permit) and the main Zoning Application (Zoning and Development Review). By combining these processes into one, the BDA streamlines and simplifies the overall permitting process. As a consequence, if you are looking for building permit records (which previously always had `permit_type == "BUILDING"`), you should also look at records with `permit_type == "Building & Development Application"`, to ensure you find them all.

More documentation on PLI permits can be found at [https://pittsburghpa.gov/pli/pli-permits](https://pittsburghpa.gov/pli/pli-permits).

Mechanical, electrical, and building permits are far more prevalent in the dataset because general permits are divided into 10 sub-types.

The field `ext_file_num` represents the only UUID for each permit record.

# Pre-processing
All string text (most fields) were converted to UPPERCASE data. The data are manually
entered and often contain non-uniform formatting. While several solutions for cleaning the data exist, including allowing the user to clean the data after accessing it here, text were transformed to UPPERCASE to ensure the data were uniformly formatted in this case. Future improvements to this ETL pipeline may approach this problem with a more sophisticated technique.

We've redacted owner names for permits where the property appears to be currently owner-occupied.

# Known Limitations/Biases
Plumbing permits are not included in this dataset, because the [Allegheny County Health Department Plumbing Division](https://www.alleghenycounty.us/Health-Department/Programs/Plumbing/Project-Plans-and-Permitting.aspx) is responsible for all plumbing permits in the City of Pittsburgh.

# Other
___Support for Health Equity datasets and tools provided by [Amazon Web Services (AWS)](https://aws.amazon.com/) through their [Health Equity Initiative](https://aws.amazon.com/government-education/nonprofits/global-social-impact/health-equity/).___

Tags: _etl, building permits, computronix, permits, pli
Organization: City of Pittsburgh