AndreaBozzo/ceres-open-data-index huggingface dataset:
Allegheny County Plumbing Inspections & Violations

**The data feed for this dataset is under maintenance. We're established a new feed for plumbing inspections and are working to restore the violations feed.**

Inspections of Plumbing Project Plans by the Department of Health. This applies to any plumbing that is installed or altered. It includes replacement cards for the installation of water heaters and dishwasher transmittal sheets. Approximately 14,000 plans are filed, reviewed, and have permits issued by the Health Department annually. Previously, residents were required to submit a formal Right-to-Know request to the Office of Open Records for access to plumbing inspection. These records can now be downloaded and accessed without a request. 

More about the County's Plumbing Program can be found on the County website at: https://www.alleghenycounty.us/Services/Health-Department/Plumbing-Program

*Due to a process error the Plumbing Inspection Violations were under-represented and have been removed from this dataset as of September 2024. The Allegheny County Health Department will be implementing a new software system by early 2025 that will restore and/or expand the information for future inspections.*

___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, achd, inspections, plumbing
Organization: Allegheny County
Applications for Development, ACCD

Applications for development that were received, reviewed, and approved by the Allegheny County Conservation District (ACCD). Application types consist of Chapter 102 National Pollutant Discharge Elimination System (NPDES) permits, E&S plan reviews for sites not needing an NPDES permit, Erosion and Sediment Control General Permits (ESCGPs) for projects associated with oil and gas, and applications for earth disturbance associated with Chapter 105 General Permits issued by ACCD. Features were digitized using paper plans and/or digital plans, where available, and are represented as permit boundaries and limits of disturbance for permits and non-permits, respectively. Includes plan identification numbers, application dates, land use type, municipalities, site acreage, pre-construction impervious acreage, post-construction impervious acreage, number of discharge points, and whether or not the project uses non-structural stormwater control measures to treat at least 25% of the total stormwater volume.

Tags: accd, allegheny county conservation district, chapter 102, chapter 105, earth disturbance, environment, erosion and sediment control plans, npdes
Organization: Allegheny County Conservation District
Allegheny County Voting District Boundaries

This dataset demarcates municipal voting districts in Allegheny County. These were updated in 2019 to match municipal boundaries.

To inquire about obtaining historical versions of this dataset, please contact Mark VanderVen (Mark.VanderVen@AlleghenyCounty.US).

Tags: _etl, _gisds, boundaries, districts, election districts, elections, elections allegheny, municipalities, precincts, voting areas, wards
Organization: Allegheny County
Allegheny County Housing and Community Environment Inspections

Residential Complaint Housing and Community Environment Inspection Reports posted to this web site include owner and tenant occupied dwellings with or without health code violations. The reports are based on visual inspection by Allegheny County Health Department (ACHD) inspectors. The primary basis for the inspections are the rules and regulations contained in “Article VI, Houses and Community Environment”. The entire health and housing code can be found at: http://www.achd.net/housing/pubs/pdf/hrules.pdf. 

All ownership data listed on the inspection reports is collected from multiple sources, and is subject to change at any time. Changes in ownership may not be reflected on the posted reports. 
The following terms, definitions, and descriptions will be useful as you review the ACHD inspection reports. 

__Property Locations:__ A property location is typically a street address for a parcel of land which may or may not include a structure. Each location is associated with a city, borough, or township, state, and ZIP code, with geographic divisions by 2010 census tract. 

__Service Requests, Types of Service Requests, and Inspection Reports:__ A service request is a recorded instance, created when a complaint is made about a specific property. Each case has a unique service request number and cites a specific property location in violation.

__Inspection Report and Violation Details:__ Each inspection report cites the sections of Article VI for which a property is found to be in violation. These citations are known as Violations. The nature of the violation is described in the inspection report. 
Each inspection report lists the property address or location, the date of inspection, a service request number, service request type, and a narrative description of the violation with a suggested remedy. It is possible that a property address may have more than one service request, particularly when multiple apartments at the same location or address have been inspected.

Note: All ACHD inspection reports and data posted on this web site are subject to errors and/or omissions. The cited violations are valid only as of the date of the inspection report. Inspection reports are uploaded monthly during the first week of the month and the upload includes new inspections up to the end of the preceding month.

Data is in three relational resources with the common field of Inspection ID.

___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, _hce, achd, community, environment, garbage, health, housing, inspections, vegetation
Organization: Allegheny County
City-Owned Property (Real Estate Tax Database)

This dataset contains a listing of property owned by the City of Pittsburgh obtained from the City's Real Estate Database. For a more complete listing of City-owned properties obtained from the City's eProperties Plus database, please visit this WPRDC dataset: [City-Owned Properties Dataset](https://data.wprdc.org/dataset/city-owned-properties)

## CHANGELOG
2023-09-22: This dataset's feed was restored, with significant changes to the published fields. A sales price is now included among the fields, as well as four dates relevant to the history of the property.

Tags: _etl, city property, finance, pittsburgh, property, real estate, treasury
Organization: City of Pittsburgh
City Treasury Sales

A listing of all the properties currently available for sale at the City's Treasurer Sale.

## CHANGELOG

2023-09-21: This dataset's feed was restored, with significant changes to the published fields. One example is that more kinds of tax due are now published and a `total_tax_due` field was added.

Tags: _etl, delinquency, finance, property, real estate, sale, treasury
Organization: City of Pittsburgh
Allegheny County Jail Daily Census

A daily census of the inmates at the Allegheny County Jail (ACJ). Includes gender, race, age at booking, and current age. The records for each month contain a census for every day, therefore many inmates records are repeated each day. 

Another representation of this data is the County's [jail population management dashboard](https://tableau.alleghenycounty.us/t/PublicSite/views/AC_JailPopulationManagement_Final/Home?iframeSizedToWindow=true&:embed=y&:showAppBanner=false&:display_count=no&:showVizHome=no).

Tags: _etl, census, crime, inmates, jail, public safety
Organization: Allegheny County
Pittsburgh Zoning Map 1967

The 1967 zoning map, dated 12/28/1967, is one of the surviving zoning maps that capture amendments to the map after the 1958 Zoning Ordinance was adopted. High level changes between 1958 and 1967 are adjustments to zoning district boundaries to support urban renewal projects and adjustments to the locations of the Special District introduced in 1958 to protect the city's hillsides. Details Reviewed created this map based on the paper map available at the University of Pittsburgh Library System Digital Collections. Digitization of the map was funded by the Pennsylvania Housing Finance Agency's Kathy A. Possinger Housing Policy Fellowship.

Tags: historic pittsburgh, pittsburgh, property, zoning
Organization: Details Reviewed
Pittsburgh Development Map 1969-1974

This map provides a snapshot of urban renewal and other major development projects in Pittsburgh. It was originally published as part of the 1970 report "A Development and Renewal Program for Pittsburgh Summary Documentation," available from the Pittsburgh City Archives. The map shows three types of areas: (1) urban renewal projects started before 1970, (2) urban renewal projects proposed to begin in the early 1970s, and (3) other major development actions which often were highway development projects. Details Reviewed created this digitization in 2024 with funding from the Heinz Endowments.

Tags: historic pittsburgh, pittsburgh, property, urban redevelopment
Organization: Details Reviewed
BikePGH's Pittsburgh Bike Map Geographic Data

Files include data for bike lanes, protected bike lanes, trails, bike routes, shared lane markings, cautionary bike routes, and bridge data from the BikePGH Pittsburgh Bike Map. BikePGH developed this map in 2007 and has been publishing it both on paper and online ever since. See: http://bikepgh.org/maps for more info.

Tags: BikePGH, bicycling, bike lanes, bike routes, bridge, cautionary, on-street bike routes, protected bike lanes, shared lane markings, sharrows, trails, transportation
Organization: BikePGH
Registered Community Groups

Registered Community Groups for the Department of City Planning 

---

From [https://engage.pittsburghpa.gov/registered-community-organizations](https://engage.pittsburghpa.gov/registered-community-organizations):

"**What is a Registered Community Organization (RCO)?**

Registered Community Organizations (RCOs) are nonprofit community organizations, or a collaboration of community organizations, that are registered with the Department of City Planning and act as key stakeholders for a specific geographic area. RCO's must meet a specific set of standards [to] be registered through the City. Each RCO is also required to renew their status by submitting a recertification every two (2) years.

The City of Pittsburgh adopted the Registered Community Organization (RCO) ordinance in September 2018.

**What do RCOs do?**

RCOs play a vital role in the development projects and neighborhood planning process within their geographic area. RCO's are guaranteed a public meeting with a developer or applicant prior to a public hearing for any new development, also known as a Development Activities Meeting (DAM). If an RCO does not exist in a neighborhood, developers are still encouraged to engage with community members but a formal meeting is not required.

DAMs are open to the public and intended as spaces for the wider community to ask questions and share feedback with the developer."

---

This data is obtained from the [City of Pittsburgh's GIS Portal](https://pghgishub-pittsburghpa.opendata.arcgis.com/) on a weekly basis.

Tags: _etl, _gis, pittsburgh
Organization: City of Pittsburgh
Allegheny County Toxics Release Inventory

The Toxics Release Inventory (TRI) data provides information about toxic substances released into the environment or managed through recycling, energy recovery, and treatment in the United States. Annual releases are compiled and reported by the U.S. Environmental Protection Agency (EPA) and shared on the TRI Website. The TRI covers over 650 chemicals and chemical groupings across a broad range of industries. Chemicals covered are linked to cancer or other chronic human health effects, tied to significant adverse human health effects, or significant adverse environmental effects.

_This data is obtained from the EPA’s API. Users can also query the EPA's website for this information by using the links to each table listed as HTML resources below and supplying the State FIPS Code of "42003" to limit the results returned to only Allegheny County on the Search Criteria page._

___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: ACHD DASH, EMBRACE, Structural Racism, Toxic Release Inventory, _etl, environment, health, social determinants of health, toxics release inventory
Organization: Allegheny County
Pittsburgh Zoning Map 1927

This map is more fully known as the City of Pittsburgh Zoning Map adopted July 1923 and amended through August 1927. In 1926, Pittsburgh adopted its first exclusively single-family zoning district. The 1927 zoning map is the earliest existing map after this amendment. From 1923-1958, Pittsburgh mapped uses, area, and height as three different layers each with its own boundaries. In 1927, there were 6 use districts, 5 area districts, and 5 height districts. In this digitization, these three layers are collapsed to create zones more readily comparable to the modern approach where each zoning district has its own distinct regulations for use, area, and height. With this flattening, there are 54 distinct districts. The data table identifies the zoning district (aka use district), height district, and area district as well as a combined district based on the short names of the individual districts. Details Reviewed created this map based on the original paper map available in the Pittsburgh Zoning Office. The digitization was funded by the Pennsylvania Housing Agency's Kathy A. Possinger Housing Policy Fellowship and the Heinz Endowments.

Tags: historic pittsburgh, pittsburgh, property, zoning
Organization: Details Reviewed
Allegheny County Mortgage Foreclosure Records

This data includes filings related to mortgage foreclosure in Allegheny County. The foreclosure process enables a lender to take possession of a property due to an owner's failure to make mortgage payments.  Mortgage foreclosure differs from tax foreclosure, which is a process enabling local governments to take possession of a property if the owner fails to pay property taxes.

As Pennsylvania is a judicial foreclosure state, a lender files for foreclosure through the court system.  Foreclosure data in the court system is maintained by the Allegheny County Department of Court Records. Data included here is from the general docket, and a  mortgage foreclosure docket created to help homeowners maintain ownership of their property following an initial filing. Several different types of legal filings may occur on a property involved in the foreclosure process. At this time, only the most recent filing in a case is included in the data found here, but we hope to add all filings for a case in the coming months.

After a property enters the foreclosure process, several potential outcomes are possible. Some of the more common outcomes include:  borrowers may come to an agreement with the lender for unpaid debt; borrowers may sell the property to satisfy part or all of the debt; borrowers may voluntarily relinquish ownership to the lender; lenders may decide not to pursue the foreclosure any further; and the property may proceed all the way through a sheriff sale, where it is sold to a new owner.

Before September 2022, the data presented here included only the final filing for the month in which each case (represented by Case ID) is opened; since then the feed has changed so we now have a new `last_activity` field, which gets updated whenever there is a new filing in the case with the date of the last filing for the month. The `last_activity` value gives some indication of which cases are still ongoing. (However, the new feed does not include the `docket_type` field, so these are blank for cases started after August 2022.) To view the detailed mortgage foreclosure filings for each property represented in this dataset, please visit the [Department of Court Records Website](https://dcr.alleghenycounty.us/Civil/View/CaseSearchByCaseNumber.aspx), and enter the Case ID for a property to pull-up detailed information about each foreclosure case, including parties, docket entries, and services.

## CHANGELOG

2022-12-14: Loaded data back to September (which had been missing due to the schema migration). Added a new `last_activity` field. Data since September 2022 is missing the `docket_type` value, for now those new values will be set to '' (empty string).

Tags: _etl, bank, borrower, foreclosed, foreclosure, housing, lender, mortgage, parcels, property, real estate
Organization: Allegheny County
Pittsburgh Zoning Map 1958

The 1958 Zoning Map and Text was the first completely rewritten/remapped zoning ordinance for Pittsburgh since it first adopted zoning in 1923. It is the first ordinance to combine use, area, and height regulations into a single layer of zoning districts. This ordinance remains the foundation of the current (2025) zoning ordinance, even though it underwent a significant overhaul in 1999. Details Reviewed created this map based on the map included in the May 1958 Zoning Ordinance available from the Pittsburgh City Archives. The digitization was funded by the Heinz Endowments.

Tags: historic pittsburgh, pittsburgh, property, zoning
Organization: Details Reviewed
Pittsburgh Regional Transit Schedule Period Lookup

Pittsburgh Regional Transit makes schedule adjustments quarterly. These schedule adjustments are called "picks" and correspond with operators picking their assignments. 

The data in this dataset is pulled from the [PRT Period Schedule Lookup - Historical dataset](https://open-data-pgh-transit.hub.arcgis.com/datasets/pgh-transit::prt-schedule-period-lookup-historical/about) on the [PRT's data portal](https://open-data-pgh-transit.hub.arcgis.com/) on a weekly basis.

Tags: 1711, 1803, 1806, 1809, 1811, 1903, 1906, 1909, _etl, bus, incline, light rail, pick, public transit, rail, schedule, transit, transportation
Organization: Pittsburgh Regional Transit
Pittsburgh Regional Transit Stops

All transit stops within the Pittsburgh Regional Transit's service area for the current schedule period.

The data files in this dataset are pulled from the [current stops dataset](https://open-data-pgh-transit.hub.arcgis.com/datasets/a29f37608eb34c3895332ff99eea9b17_0/explore?location=40.470338%2C-79.980563%2C10) on the [PRT's data portal](https://open-data-pgh-transit.hub.arcgis.com/) on a weekly basis. 

**Note:** historical stops from February 2023/present are available at:
https://open-data-pgh-transit.hub.arcgis.com/datasets/pgh-transit::prt-stops-historical-full-system/about


Tags: _etl, bus, incline, light rail, pittsburgh rapid transit, routes, shelter, station, stop, transit, transportation
Organization: Pittsburgh Regional Transit
Pittsburgh Regional Transit Transit Routes

Shapefiles of Pittsburgh Regional Transit routes. Routes change over time. The 4-digit code corresponds to the "pick" or schedule period of that route; for example, the schedule period beginning in September 2019 is known as the 1909 pick.

The data files in this dataset are pulled from the [current routes dataset](https://open-data-pgh-transit.hub.arcgis.com/datasets/9483dc3e6dc8495badef05a3f7f38dff_0/explore?location=40.469873%2C-79.986781%2C10) on the [PRT's data portal](https://open-data-pgh-transit.hub.arcgis.com/) on a weekly basis. 

**Note:** Historical routes from September 2022/present are available at:
https://open-data-pgh-transit.hub.arcgis.com/datasets/pgh-transit::prt-routes-historical-full-system/about

Tags: _etl, bus, gis, incline, light rail, pittsburgh rapid transit, port authority, port authority of allegheny county, routes, transit, transporation
Organization: Pittsburgh Regional Transit
Allegheny County 911 Dispatches - EMS and Fire

The Allegheny County 911 center answers and dispatches 911 calls for 111 out of 130 municipalities in Allegheny County. Agencies are dispatched via a computer aided dispatch (CAD) system. This dataset contains dispatched EMS and Fire events from the CAD and includes details about the nature of the emergency.

To protect the privacy of callers and prevent sensitive health or other identifying information being revealed, the following steps were taken:
  
* Aggregated event location to census block groups.  
* Aggregated call date/time to quarter and year. 
* Shortened call types to remove potentially identifying information. 
* Flagged certain call types as containing sensitive health information, such as mental health issues, overdose, etc.  
* Checked frequency of calls with sensitive health information: 
    * If the number of calls (in a particular category related to sensitive health information) for a certain quarter/year and census block group was greater than or equal to 5, the call description was included.  
    * If less than 5, the call description was redacted. 

Events requiring EMS and Fire services will appear in both datasets with a different Call ID. Events requiring two agencies of the same service (e.g. two or more different fire companies responded to a major fire) will only list the primary responder.

The call descriptions are based on information provided by the caller. The calls are not later updated with a disposition or correction if the original description was inaccurate. For example, if EMS is dispatched to the scene of a stroke, but the person actually had a heart attack, that record would not be updated later with the correct description. 

A small subset of the CAD data had no call type recorded. These records are preserved with a "null" in the Description_Short field. Redacted call types are listed as "Removed".

The 19 municipalities that dispatch their own EMS, Fire, and/or Police services are called "ringdown municipalities". These are subject to change. The list can be found in the Ringdown Municipalities 2019 resource.

**Due to the size of these tables, you may experience 504 Gateway Timeout errors when trying to download the first two resources below. Use the following links instead.**

**To download the 911 EMS Dispatches table, click on this link:** https://tools.wprdc.org/downstream/ff33ca18-2e0c-4cb5-bdcd-60a5dc3c0418

**To download the 911 Fire Dispatches table, click on this link:**
https://tools.wprdc.org/downstream/b6340d98-69a0-4965-a9b4-3480cea1182b

___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: 9-1-1, 911, _etl, cad, dispatch, emergency, emergency services, ems, fire, medical
Organization: Allegheny County