AndreaBozzo/ceres-open-data-index huggingface dataset:
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).

# Visualizations

Tags: _etl, bank, borrower, foreclosed, foreclosure, housing, lender, mortgage, parcels, property, real-estate
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Conservatorship Filings

This data includes filings related to conservatorship petitions in Allegheny County. The conservatorship process, defined by PA’s 2008 Act 135, seeks to provide “a mechanism to transform abandoned and blighted buildings into productive reuse”, ideally creating “an opportunity for communities to modernize, revitalize and grow, and to improve the quality of life for neighbors who are already there”. Conservators petition to take possession of the building and oversee the “operation, management and improvement of the building in order to bring it into compliance with all municipal building and housing code requirements”. Conservators can be can be lienholders, non-profit groups, or residents/business owners who are in the proximity of the property in question. More information can be found on the Pennsylvania General Assembly website: https://www.legis.state.pa.us/cfdocs/legis/li/uconsCheck.cfm?yr=2008&sessInd=0&act=135

Conservatorship data in the court system is maintained by the Allegheny County Department of Court Records. Data included here is from the general docket. Several different types of legal filings may occur on a property involved in the conservatorship process. At this time, only the most recent filing in a case is included in the data found here. (All of the fields except the `last_activity` field are expected to be set at the initial filing of the case. The `last_activity` field is the only one we expect to update on a regular basis; it represents the date of the most recent activity on the case.)

To view the detailed conservatorship filings for each property represented in this dataset, please visit the Department of Court Records Civil/Family Division [Website Search Page](https://dcr.alleghenycounty.us/Civil/LoginSearch.aspx), and enter the Case ID for a docket. This will provide detailed information about each conservatorship case by docket , including litigants, attorneys, non-litigants,  docket entries, events, copies of documents, property information (included in the docket report) and services.

Tags: _etl, blight, court, docket, housing, parcel, parcels, property, property-condition, real-estate, vacant
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Assets

This dataset contains lists of various kinds of assets (open prior to or as of March 1, 2020), derived from a variety of local, state, and federal data sources. Some of this data still needs to be verified, as this is a work in progress. Some geocoding is either missing or incorrect. Improvements are pending.

This data was assembled to support 2020 Census outreach efforts, and can also be used to support COVID-19 response efforts.

A [companion map](https://assets.wprdc.org/) displaying this data has also been created to support Census outreach. It too is a work in progress, and we'll be adding new features in the coming weeks. 

Types of assets reflected in the data include (Note - we'll add additional source info. in coming days):

Allegheny County Housing Authority community sites, Allegheny County Health Department clinics, affordable housing properties, apartment buildings, banks, barbershops, bars, bus stops, child care centers, coffee shops, community nonprofit organizations, dentists, doctor's offices, faith-based facilities, family support centers, farmers' markets, food banks, gas stations, hair salons, health centers, homeless shelters, laundromats, libraries, museums, nail salons, nursing homes, park and rides, parks and facilities, pharmacies, polling places, post offices, public buildings, recreation centers, restaurants, schools, senior centers, supermarkets, universities, VA facilities, veterans social orgs, WIC offices, and WIC vendors.

Tags: _etl, assets, businesses, child, civic, early-childhood, faith, fast-food, food, grocery, health, housing, medical, museums, parks, pharmacy, post-offices, restaurant, restaurants, schools, supermarket, supermarkets, transportation
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Restaurant/Food Facility Inspections and Locations

Facilities located within Allegheny County that produce, distribute and sell food products are subject to mandatory, routine inspection by one of the health department's staff of environmental health specialists.

This dataset contains the violation data from the searchable inspection reports posted online here: http://webapps.achd.net/Restaurant/. The inspection date ranges from January 2016 to present. A table of geocoded facility locations is also included. New data will be added monthly.

Tags: _etl, food, health, inspections, public-safety, restaurant, violations
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Condemned and Dead-End Properties

This dataset contains condemned properties in the City of Pittsburgh and is maintained by the Department of Permits, Licenses, and Inspections (PLI). Some of the properties are labelled as "dead-end", which means that they are condemned properties for which PLI cannot locate the owner. Properties are classified as "dead end" if multiple attempts to make contact with the owner fail.

This dataset contains information about the property condition, location, and owner of each property condemned in the City of Pittsburgh.

---
## Motivation/Collection

These pages provide more information about how and why the data on condemned properties is collected:

- https://engage.pittsburghpa.gov/pli-demolition-engagement
- https://pittsburghpa.gov/pli/condemned-buildings

---
## Notes

- Currently, some `parcel_id` values appear in multiple records, leading to the same property appearing multiple times, with different values for fields like `latest_inspection_score` . This will be fixed soon.
- The numerical range for `latest_inspection_score` is currently 0-62,  but the system is being adjusted, and eventually these scores will be adjusted to a 1-4 scale.

Tags: _etl, condemned, parcel_id, pli, properties
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Map Index Grid

Map Index Sheets from Block and Lot Grid of Property Assessment and based on aerial photography, showing 1983 datum with solid line and NAD 27 with 5 second grid tics and italicized grid coordinate markers and outlines of map sheet boundaries. 

Each grid square is 3500 x 4500 feet.  Each Index Sheet contains 16 lot/block sheets, labeled from left to right, top to bottom (4 across, 4 down): A, B, C, D, E, F, G, H, J, K, L, M, N, P, R, S.  The first (4) numeric characters in a parcelID indicate the Index sheet in which the parcel can be found, the alpha character identifies the block in which most (or all) of the property lies.

Tags: _etl, boundaries, grid, planning, reference
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
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

Tags: 9-1-1, 911, _etl, cad, dispatch, emergency, emergency-services, ems, fire, medical
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
ACDBE/DBE Certified Businesses by the Department of Equity and Inclusion (DEI)

This dataset includes Pennsylvania Unified Certification Program (PA UCP) Firms certified as Airport Concessionaire Disadvantaged Business Enterprises (ACDBE)/Disadvantage Business Enterprises(DBEs) by the Department of Equity and Inclusion. It does not include all PA UCP certified businesses in Allegheny County. A complete list of firms certified by the PA UCP is available at [dotsbe.pa.gov](https://paucp.dbesystem.com/). Allegheny County is one of five certifying participant in the PA UCP.  Firms wishing to be certified can do so at no cost through DEI.

According to the Federal Department of Transportation, Disadvantaged Business Enterprises (DBE) are for-profit small business concerns where socially and economically disadvantaged individuals own at least a 51% interest and control management and daily business operations. To encourage participation in government contracting, these businesses can be eligible for contract set-asides and help organizations meet participation goals. To participate in these programs, a small business owned and controlled by socially and economically disadvantaged individuals must receive DBE certification from the relevant state– generally through the state Uniform Certification Program (UCP). The PA UCP is established in accordance with 49 CFR Part 26 and 49 CFR Part 23. More information can be found at [Electronic Code of Federal Regulations](https://www.ecfr.gov). 

Automatic updates to this dataset have been restored. The source for this data is the the [PAUCP web site](https://paucp.dbesystem.com/).

Tags: _etl, business, business-and-economy, dbe, disadvantaged, equity, minority, mwbe
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Addressing Landmarks

This dataset shows the address points in Allegheny County.

## Usage
The value in the `ADDRESS_ID` field lets you look up more information about the landmark locations in the Addressing Address Points dataset (https://data.wprdc.org/dataset/allegheny-county-addressing-address-points2), including the geocoordinates (though they are in the State Plane coordinate system, in that table's `point_x` and `point_y` fields).

## Limitations
Since the CSV file currently does not provide geocoordinates, we can't generate a GeoJSON file from it; until we do, the GeoJSON link will remain as a broken placeholder.

Tags: _etl, address, allegheny-county, landmarks, points
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Zip Code Boundaries

<div>This dataset demarcates the zip code boundaries that lie within Allegheny County.</div><div><br /></div><div>If viewing this description on the Western Pennsylvania Regional Data Center’s open data portal <a href='http://www.wprdc.org' target='_blank'>(http://www.wprdc.org)</a>, this dataset is harvested on a weekly basis from Allegheny County’s GIS data portal (<a href='http://openac.alcogis.opendata.arcgis.com/' target='_blank'>http://openac.alcogis.opendata.arcgis.com/</a>). The full metadata record for this dataset can also be found on Allegheny County’s GIS portal. You can access the metadata record and other resources on the GIS portal by clicking on the “Explore” button (and choosing the “Go to resource” option) to the right of the “ArcGIS Open Dataset” text below.</div><div><br /></div><div><b>Category</b>:  Civic Vitality and Governance</div><div><b><br /></b></div><div><b>Organization</b>:  Allegheny County</div><div><br /></div><div><b>Department:</b>  Geographic Information Systems Group; Department of Administrative Services</div><div><br /></div><div><b>Temporal Coverage:</b>  current</div><div><br /></div><div><b>Data Notes: </b></div><div><br /></div><div><b>Coordinate System:</b>  Pennsylvania State Plane South Zone 3702; U.S. Survey Foot</div><div><br /></div><div><b>Development Notes:</b>  none</div><div><br /></div><div><b>Other:</b> none</div><div><br /></div><div><b>Related Document(s):</b>  Data Dictionary (none)</div><div><br /></div><div><b>Frequency - Data Change:</b>  As needed</div><div><br /></div><div><b>Frequency - Publishing:</b>  As needed</div><div><b><br /></b></div><div><b>Data Steward Name:</b>  Eli Thomas</div><div><br /></div><div><b>Data Steward Email:</b> gishelp@alleghenycounty.us</div>

Tags: _etl, landmarks, street-aliases, street-dictionary, tables, zip-codes
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Block Areas

This dataset overlays a grid on the County to assist in locating a parcel. The grid squares are 3,500 by 4,500 square feet. The data was derived from original MAPINDX: Map Index Sheets from Block and Lot Grid of Property Assessment and based on aerial photography. Tiles are numbered in a clockwise spiral fashion starting with #1 at the point in downtown Pittsburgh. Each tile contains 16 Blocks. Each Index Sheet contains 16 lot/block sheets, labeled from left to right, top to bottom (4 across, 4 down): A, B, C, D, E, F, G, H, J, K, L, M, N, P, R, S. The first (4) numeric characters in a parcelID indicate the Index sheet in which the parcel can be found, the alpha character identifies the block in which most (or all) of the property lies.

Tags: _etl, boundaries, facilities, grid, map-index, property
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Hydrology Areas

The Hydrology Feature Dataset contains photogrammetrically compiled water drainage features and structures including rivers, streams, drainage canals, locks, dams, lakes, ponds, reservoirs and mooring cells.  Lakes are large standing bodies of water greater than 5 acres in size. Ponds are large standing bodies of water greater than 1 acre and less than 5 acres in size. Polygons are created from Stream edges and River Edges.  The Ohio River, Monongahela River and Allegheny River are coded as Major River polygons.  All other River and Stream polygons are coded as River. A Drainage Canal is a manmade or channelized hydrographic feature.  Drainage Canals are differentiated from streams in that drainage canals have had the sides and/or bottom stabilized to prevent erosion for the predominant length of the feature.  Streams may have had some stabilization done, but are primarily in a natural state. Lakes are large standing bodies of water greater than five acres in size.  Ponds are large standing bodies of water greater than one acre in size and less than five acres in size.  Reservoirs are manmade embankments of water.  Included in this definition are both covered and uncovered water tanks. Reservoirs that are greater than one acre in size are digitized. Hidden Streams, Hidden Rivers and Hidden Drainage Canal or Culverts are those areas of drainage where the water flows through a manmade facility such as a culvert. Hydrology Annotation is not being updated but will be preserved.  If a drainage feature has been removed, as apparent on the aerial photography, the associated drainage name annotation will be removed. A Mooring Cell is a structure to which tows can tie off while awaiting lockage.  They are normally constructed of concrete and steel and are anchored to the river bottom by means of gravity or sheet piling. Mooring Cells do not currently exist in the Allegheny County dataset but will be added. Locks are devices that are used to control flow or access to a hydrologic feature.  The edges of the Lock are captured.  Dams are devices that are used to hold or delay the natural flow of water.  The edges of the Dam are shown.

Tags: _etl, environment, inland-waters, lake, river, stream, water, western-pennsylvania
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Wooded Area Boundaries

This dataset demarcates stands of trees (coniferous and deciduous) too numerous to plot as individual trees. The area is delineated following a generalized line along the outside edge of tree trunks. Areas are captured if at least one acre in size or of major significance especially in urban areas.

Tags: _etl, environment, forest, vegetation
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Census Tracts 2016

This is an Allegheny County extract of the 2016 US Census Tracts downloaded from the following website:  https://www.census.gov/geo/maps-data/data/tiger-cart-boundary.html

Tags: 2016, _etl, arcgis, boundaries, census, sd, service-definition, tracts
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Cell Tower Points

This dataset portrays cell tower locations as points in Allegheny County. The dataset is based on outbuilding codes in the Property Assessment Parcel Database used to identify cell towers for tax year 2016.

Tags: _etl, acgis, allegheny-county, cell-towers, communication, facilities, network, technology, telephone
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Magisterial Districts Outlines

This dataset shows the magisterial districts in Allegheny County.

This dataset is harvested on a periodic basis from Allegheny County’s GIS data portal (https://openac.alcogis.opendata.arcgis.com/). The full metadata record for this dataset can also be found on Allegheny County’s GIS portal. You can access the metadata record and other resources on the GIS portal by clicking on the “Explore” button (and choosing the “Go to resource” option) to the right of the “ArcGIS Open Dataset” text below.

Tags: _etl, allegheny-county, government, justice, magisterial, public-safety
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Trails Locations

<div><span><div><p>Shows
 the location of all blazed and unblazed trails in all Allegheny County parks. This is 
the same data used in the Allegheny County Parks Trails Mobile App, 
available for Apple and Android devices.<br /></p>



<p>If viewing this description on the Western Pennsylvania
Regional Data Center’s open data portal (<a href='http://www.wprdc.org'>http://www.wprdc.org</a>), this
dataset is harvested on a weekly basis from Allegheny County’s GIS data portal
(<a href='http://openac.alcogis.opendata.arcgis.com/'>http://openac.alcogis.opendata.arcgis.com/</a>). The
full metadata record for this dataset can also be found on Allegheny County’s
GIS portal. You can access the metadata record and other resources on the GIS
portal by clicking on the “Explore” button (and choosing the “Go to resource”
option) to the right of the “ArcGIS Open Dataset” text below.</p>

<p><b>Category:</b>  Recreation</p>

<p><b>Organization:</b>  Allegheny County</p>

<p><b>Department:</b>  Parks Department</p>

<p><b>Temporal
Coverage:  </b>present</p>

<p><b>Data
Notes:  </b></p>

<p>Coordinate System: 
Pennsylvania State Plane South Zone 3702; U.S. Survey Foot</p>

<p>Development Notes:  none </p>

<p>Other: none</p>

<p><b>Related
Document(s):</b>  Data
Dictionary: none </p>

<p><b>Frequency
- Data Change:</b>  As needed</p>

<p><b>Frequency
- Publishing:</b>  As needed</p>

<p><b>Data
Steward Name:</b>  Eli Thomas</p>

<p><b>Data
Steward Email:</b> gishelp@alleghenycounty.us</p></div></span></div>

Tags: _etl, blaze, park, parks, recreation, trails, unblazed
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center