AndreaBozzo/ceres-open-data-index huggingface dataset:
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
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, _gisds, boundaries, grid, planning, reference
Organization: Allegheny County
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, _gisds, environment, inland waters, lake, river, stream, water, western pennsylvania
Organization: Allegheny County
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, _gisds, environment, forest, vegetation
Organization: Allegheny County
Landslides

From [NASA's Cooperative Open Online Landslide Repository (COOLR)](https://science.gsfc.nasa.gov/600/citizen-science/landslides/index.html). 

The Cooperative Open Online Landslide Repository (COOLR) is a worldwide database of landslide events. It currently includes NASA’s Global Landslide Catalog (GLC) and landslide events contributed by citizen scientists. In a future release of COOLR, collated landslide inventories will be added by REST API or manually.

Tags: NASA, environment, federal, geography, landslide
Organization: Western Pennsylvania 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: Allegheny County, _etl, _gisds, government, justice, magisterial, public safety
Organization: Allegheny County
Allegheny County Watershed Boundaries

This dataset demarcates the 52 isolated sub-Watersheds of Allegheny County that drain to single point on the main stem rivers. Created by 3 Rivers 2nd Nature based upon Allegheny County watershed file showing all tributaries of all streams. All tributaries draining to a single point on the river were joined as a single major stream system watershed for field measurement and analysis purposes. 

Tags: _etl, _gisds, allegheny county, clairton, duquesne, environment, inland waters, mckeesport, pittsburgh, southwest pennsylvania, water, western pennsylvania
Organization: Allegheny County
Allegheny County Landslide Portal Archive

## Overview

This is an archive of the [Allegheny County Landslide Portal](https://landslide-portal-alcogis.opendata.arcgis.com/), a web site developed by the Allegheny County Landslide Task Force.

---
## Collection

The archive process we used: The Landslide Portal was stored mostly as PDF files, using [single-file HTML](https://www.getsinglefile.com/) archives on pages with many outgoing links, and supplemented by individual links to external resources listed on Landslide Portal pages captured as PDF files. The order of the resources below assumes that the user starts at the home page, and works through the navigation tab left-to-right, browsing each page from top-to-bottom.

---
## Recommended Uses

**Disclaimer from the footer of the site:** "For informational purposes and government use only. Not to be relied upon by the general public."

---
## Further Documentation and Resources

The WPRDC data portal contains several other datasets concerning landslides (all of which can be found [here](https://data.wprdc.org/dataset/?tags=landslide)). In particular, the data in the [Landslides Pomeroy Study](https://data.wprdc.org/dataset/landslides-pomeroy-study) was used in the Landslide Portal.

Tags: archive, landslide, web site
Organization: Allegheny County
Allegheny County Trails Locations

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.

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.

<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>

Tags: _etl, blaze, park, parks, recreation, trails, unblazed
Organization: Allegheny County
Allegheny County Council Districts

This dataset portrays the boundaries of the County Council Districts in
Allegheny County. The dataset is based on municipal boundaries and City of Pittsburgh ward boundaries and was updated as the result of reapportionment in September 2002. It has also been attributed with the current representatives' names.

This dataset is harvested on a weekly basis from [Allegheny County’s GIS data portal](http://openac.alcogis.opendata.arcgis.com/).

Category: Civic Vitality and Governance

Department: Geographic Information Systems Group; Department of Administrative Services


Tags: _etl, _gisds, boundaries, council, districts, municipalities, wards
Organization: Allegheny County
Public Water Supplier Service Areas

Boundaries of current public water supplier's (PWS) service areas from [PA Department of Environmental Projection open data portal](https://newdata-padep-1.opendata.arcgis.com/datasets/fdf53cdeb2ec42b8a9422569f2e9531b_302/explore?location=40.865273%2C-77.621150%2C7.97). 

This data set contains the present service area boundary of the water system and does not contain locations of surface and groundwater sources, storage facilities, transmission and distribution system lines, and interconnections with other water systems. Revisions, updates and additions are done on an as needed basis. All boundaries should be considered approximate.


Tags: map, water, water_service
Organization: Western Pennsylvania Regional Data Center
Allegheny County Greenways (2008)

Greenways data was compiled by the Allegheny Land Trust as a planning effort in the development of Allegheny Places, the Allegheny County Comprehensive Plan. The plan was published in 2008.

___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, Greenway, environmental, open space, recreation, scenic, social determinants of health
Organization: Allegheny County
Allegheny County Department of Public Works Maintenance District Boundaries

This dataset is regularly updated from [Allegheny County’s GIS server]
(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.

Department: Geographic Information Systems Group; Department of Administrative Services

Tags: _etl, boundaries, dpw, government, public works
Organization: Allegheny County
Implemented Stormwater Control Measures, ACCD

Shows the locations of Stormwater Control Measures (SCMs) that were implemented as a condition of National Pollutant Discharge Elimination System (NPDES) and Erosion and Sediment Control General Permit (ESCGP) permits within Allegheny County, PA. Specifically, this data set consists of SCMs associated with constructed permits that were terminated by the Allegheny County Conservation District (ACCD). Features were digitized using paper and/or digital as-built plan drawings, where available, received as part of the Notice of Termination (NOT) submission process. SCM data was obtained from submitted NOT forms which are also required as part of this submission. Construction of SCMs are often required by NPDES and ESCGP permits to manage excess stormwater, created by increased impervious area, by treating rate, volume, and/or water quality.

Tags: accd, allegheny county conservation district, chapter 102, environment, not, notice of termination, pcsm, post-construction stormwater management, scm, stormwater, stormwater control measures
Organization: Allegheny County Conservation District
Allegheny County WIC Vendor Locations

This dataset contains the locations of Women, Infants, and Children (WIC) program vendors.    

___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, _gisds, assistance, dhs, food, human services, nutrition, social services, socialservices, vendor locations, wic
Organization: Allegheny County
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: City of Pittsburgh
Allegheny County Park Features

A combination of all park features, events, recreations, facilities, all in one layer, including Activenet information.

Tags: _etl, _gisds, activenet, ballfield, barn, bocce, camping, court, events, facilities, field, horse, parks, picnic, pools, recreation, rink, shelters, skating rink, soccer, sports, stage, swimming pools, tennis, volleyball
Organization: Allegheny County
Allegheny County Municipal Boundaries

This dataset demarcates the municipal boundaries in Allegheny County. Data was created to portray the boundaries of the 130 Municipalities in Allegheny County the attribute table includes additional descriptive information including Councils of Government (COG) affiliation (regional governing and coordinating bodies comprised of several bordering municipalities), School District, Congressional District, FIPS and County Municipal Code and County Council
District.

This dataset is harvested on a weekly basis from [Allegheny County’s GIS data portal](http://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.

Category: Civic Vitality and Governance

Department: Geographic Information Systems Group; Department of Administrative Services


Tags: _etl, administrative, boundaries, local government
Organization: Allegheny County
Allegheny County Cemeteries

This dataset was previously obtained and regularly updated from [this URL](https://data.wprdc.org/dataset/allegheny-county-cemetery-outlines/resource/84e59451-7d70-438a-a50f-fd5f9f301aea/edit) on the [Allegheny County's GIS server](http://openac.alcogis.opendata.arcgis.com). We've switched to mirroring a new cemeteries dataset on the same server.

**Description of previous version of this dataset:** "Outlines of public and private cemeteries greater than one acre in size.
Areas were delineated following a generalized line along the outside edge of
the area. Individual features within the cemetery are not shown."

Category: Civic Vitality and Governance

Department: Geographic Information Systems Group; Department of
Administrative Services

Coordinate System: Pennsylvania State Plane South Zone 3702; U.S. Survey Foot

Tags: _etl, _gisds, burial ground, grave, graveyard, property
Organization: Allegheny County
Allegheny County Soil Type Areas

This dataset contains soil type and soil classification, by area.

This dataset is harvested on a weekly basis from [Allegheny County’s GIS data portal](http://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.

Category: Environment

Department: Geographic Information Systems Group; Department of Administrative Services

Development Notes: This data set is a digital soil survey and generally is the most detailed level of soil geographic data developed by the National Cooperative Soil Survey. The information was prepared by digitizing maps, by compiling information onto a planimetric correct base and digitizing, or by revising digitized maps using remotely sensed and other information. This data set consists of georeferenced digital map data and computerized attribute data. The map data are in a soil survey area extent format and include a
detailed, field verified inventory of soils and miscellaneous areas that normally occur in a repeatable pattern on the landscape and that can be cartographically shown at the scale mapped. A special soil features layer (point and line features) is optional. This layer displays the location of features too small to delineate at the mapping scale, but they are large enough and contrasting enough to significantly influence use and management. The soil
map units are linked to attributes in the National Soil Information System relational database, which gives the proportionate extent of the component soils and their properties. The soil map and data used in the SSURGO product were prepared by soil scientists as part of
the National Cooperative Soil Survey.

Related Documents: [Data Dictionary for SOIL_CODE](https://alleghenycounty-my.sharepoint.com/:t:/g/personal/melinda_angeles_alleghenycounty_us/ETPZnkA93thJs6tnW7ZivmMBL0KH6dFMQa5_Ax8m3OkMdQ?e=cYsXcz), https://www.nrcs.usda.gov/Internet/FSE_MANUSCRIPTS/pennsylvania/PA003/0/legends.pdf (the last page includes the soil legend for this dataset)

Tags: _etl, _gisds, earth, environment, planning
Organization: Allegheny County
POGOH Trip Data

Dataset includes closed status, trip duration, Start Station Id, Start Date, Start Station Name, End Date, End Station Id, End Station Name, and Rider Type. 

In the closed status colum, normal correlates to a standard rider return. Grace period indicates the bike was not removed within 60 seconds, and was relocked and returned without being removed from the dock. Terminated or forced close trips are ended by staff, and typically have incorrect durations or return locations.

In the rider type column, casual type correlates to our "Pay-as-you-Go" product. All annual, prepaid, or corporate passes types are member types.

Tags: active, activetransportation, bike, bikepgh, bikeshare, data, ebike, pgh, pittsburgh, ridership, share, transportation, trip
Organization: POGOH
Allegheny County Property Sale Transactions

This dataset contains data on all Real Property parcels that have sold since 2013 in Allegheny County, PA.

Before doing any market analysis on property sales, check the sales validation codes. Many property "sales" are not considered a valid representation of the true market value of the property. For example, when multiple lots are together on one deed with one price they are generally coded as invalid ("H") because the sale price for each parcel ID number indicates the total price paid for a group of parcels, not just for one parcel. See the Sales Validation Codes Dictionary for a complete explanation of valid and invalid sale codes.

Sales Transactions Disclaimer: Sales information is provided from the Allegheny County Department of Administrative Services, Real Estate Division. Content and validation codes are subject to change. Please review the Data Dictionary for details on included fields before each use. Property owners are not required by law to record a deed at the time of sale. Consequently the assessment system may not contain a complete sales history for every property and every sale. You may do a deed search at http://www.alleghenycounty.us/re/index.aspx directly for the most updated information.
Note: Ordinance 3478-07 prohibits public access to search assessment records by owner name. It was signed by the Chief Executive in 2007.

Tags: _etl, housing, parcel, property, real estate, real property, sales
Organization: Allegheny County
Allegheny County Fatal Accidental Overdoses

Fatal accidental overdose incidents in Allegheny County, denoting age, gender, race, drugs present, zip code of incident and zip code of residence.

Zip code of incident is where the Office of the Medical Examiner received the body, not necessarily where the overdose occurred. 

Data includes closed cases only and the previous calendar year data will be updated monthly until the close of the current calendar year. For example, the 2014 resource will be updated monthly until December 2015. 

**Pre-processing:** The cumulative Fatal Accidental Overdoses resource (the first table below) has been modified to address a number of issues, including (but not limited to) duplication of many records.

_If you are looking for the old yearly files they have been archived and compressed and are available below as a zip file._

___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: OD, _etl, accidental, alcohol, alprazolam, cocaine, codeine, death, drugs, fatal, fentanyl, heroin, opiate, opioid, overdose, oxycodone
Organization: Allegheny County