City of Philadelphia

2009-2012 Police Advisory Commission Complaints

The datasets below show information about Complaints filed with the Police Advisory Commission against Philadelphia Police officers. The information comes directly from Police Advisory Commission Complaint Database.

311 Service and Information Requests

This represents all service and information requests since December 8th, 2014 submitted to Philly311 via the 311 mobile application, calls, walk-ins, emails, the 311 website or social media.

Please note that this is a very large dataset. Unless you are comfortable working with APIs, we recommend using the visualization to explore the data.

If you are comfortable with APIs, you can also use the API links to access this data. You can learn more about how to use the API at Carto’s SQL API site and in the CARTO guide in the section on making calls to the API.**

Active Residential Parking Permits by District

Trouble downloading or have questions about this City dataset? Visit the OpenDataPhilly Discussion Group

Aerial Photography (imagery)

Data includes aerial photography of the City of Philadelphia.

Affordable Housing Production

The Division of Housing and Community Development (DHCD) provides funding to developers to build and maintain affordable housing units throughout the city. This dataset includes all DHCD-funded housing projects completed since 1994 for which there is data.

Air Monitoring Stations

Street location and types of pollutants sampled at each PDPH air monitoring station.

Air Quality Index Days

Number of bad AQI (air quality index) days, dating back to 1990.

AMS Latest Air Quality Sensor Readings

The latest air quality sensor readings managed by the Air Management Systems (AMS) division of the Philadelphia Department of Public Health (PDPH)

ARCHIVED: 2007-2015 Litter Index

The datasets below have been archived and will not receive further updates, but remain available for reference. The up-to-date and more comprehensive Litter Index is available here and will be updated annually going forward. For those conducting analysis using Litter Index data, please be advised that the survey design between the 2007- 2015 data is vastly different from the 2017 data, so it would not make sense to compare the two.

The Litter Index is used to compare the relative cleanliness of different areas of the city of Philadelphia.

ARCHIVED: Greenworks Metrics

The following datasets are no longer maintained and will not receive further updates. They remain available as a snapshot in time for the public to use.

Greenworks is an initiative of the Office of Sustainability that aims to make Philadelphia a sustainable city. Greenworks Philadelphia envisions a city where all Philadelphians:

*Have access to healthy, affordable, and sustainable food and drinking water. *Breath healthy air inside and outside. *Use clean, efficient, affordable energy. *Prepare for climate change and reduce carbon pollution. *Benefit from parks, trees, stormwater management, and healthy waterways. *Have access to safe, affordable, and low-carbon transportation. *Waste less and keep our neighborhoods clean. *Benefit from sustainability education, employment, and business opportunities.

ARCHIVED: Philadelphia Food Access

The datasets below have been archived and will not receive further updates, but remain available for reference. The up-to-date and more comprehensive Neighborhood Food Retail data is available and will be updated annually going forward. For those conducting analysis using this data, please be advised that the previous methodology is vastly different from the more recent data, so it would not make sense to compare the two.

This dataset is derived from the Walkable Access to Healthy Foods in Philadelphia, 2012-2014 report analyses.

ARCHIVED: Planning Analysis Sections

Please note that this dataset is no longer in use by the Philadelphia City Planning Commission and has been replaced with the Planning Districts dataset.

The Planning Analysis Sections were the boundaries for the city’s twelve planning analysis sections with attribute labels.

ARCHIVED: Valet Parking Locations

Data is from 2015 and does not currently receive any updates.

Arterial Streets

The Arterial layer was developed to aid various city agencies with planning, organizing, and maintaining the streets of the City of Philadelphia. These agencies include PWD, PCPC, Police, BRT, Health, etc.

Big Belly Trash Bin Usage

Trouble downloading or have questions about this City dataset? Visit the OpenDataPhilly Discussion Group

Big Belly Waste Baskets (Trash Bins)

Big Belly brand waste baskets maintained/collected by the City of Philadelphia.

Bike Network - Supporting Datasets

This dataset combines data from various City of Philadelphia departments in order to create a set of supporting documentation for bike network routing. Datasets include Bike Network, Connector Streets, Regional Routes, and Trails and Side paths. Each dataset has its own parameters, dates, and sources, and individuals are encouraged to view the metadata associated with this data. This dataset is experimental and remains a work in progress. Please use with caution.

Bike Network

Line data includes the network of both streets with bike lanes and streets considered bicycle-friendly. Also known as the bicycle network.

Boost Your Business Program

The City of Philadelphia is launching Boost Your Business, a fund for equitable business growth. Businesses owned by people of color face unique barriers in accessing resources and opportunities, which was only worsened by the COVID-19 pandemic. Boost Your Business will provide funding to help diverse entrepreneurs in Philadelphia scale their businesses.

Bridge Locations

This layer was developed to aid the Bridge Division in maintaining and referencing the bridges of the City of Philadelphia. Examples include: routing trucks with height and weight restrictions through out the city, maintenance, and obtaining bridge number.

Building Demolitions

Inventory of building demolitions occurring within the City of Philadelphia. This includes both demolitions performed by private owners/contractors and by the Department of Licenses and Inspections due to dangerous building conditions.

Updated daily.

Building Footprints

Planimetric Coverage containing the delineation of buildings or related structure outlines that represent the footprints of buildings within the City of Philadelphia.

Bullet Voting 2015

Each voter is allowed to select up to five candidates for City Council At-Large. When a voter chooses only one candidate, it is known as “bullet voting.”

Bus Shelters

This is a point dataset of bus transit shelters installed and maintained by the City of Philadelphia, in partnership with Intersection Media.

Business Improvement Districts (BID)

This data set provides geographic boundaries and basic information for Philadelphia’s 15 Business Improvement Districts (BID) as well the University City District and Sports Complex District. More information available here This data set may be helpful to property owners, property purchasers or title companies seeking to know if a property exists within a BID. Note that this dataset may include errors or outdated information. Therefore, it is strongly recommended that interested parties contact BID organizations directly with inquiries.

Business Security Camera Program Grants

Information regarding the number of recipients of grant monies for the Business Security Camera Program. Used for tracking completed projects, by zip code and census tract and dollar value of reimbursement.

Business Technical Support Resources

Services and support available to businesses in Philadelphia.

Campaign Finance Reports

Campaign finance reports from 2019 to the present: The tables below show different cuts of the campaign finance reports data related to Philadelphia elections provided by filers (including candidates and political committees) about their contributions, expenditures and debt. You can explore an interactive dashboard that visualizes much of this data, use the video tutorial to learn how to navigate the dashboard, or read the technical document to understand how we compiled the data and dashboard.

If you want to use the raw, unfiltered data, please visit the searchable database. Filers can submit reports on via the campaign finance filing system.

Candidates

THIS DATASET IS UNDER CONSTRUCTION AND WILL BE RE-RELEASED SHORTLY

The individuals who are candidates for elected office. Internally, this information is used to create the ballot. Externally, candidates and campaigns will want to know who their opponents are.

Census Block Groups

For matching and analyzing demographic data collected and compiled by the U.S. Census Bureau & American Community Survey(ACS) to the geography of Census Block Group boundaries within the City of Philadelphia. These boundaries can change every ten years when the decennial census is conducted.

Census Blocks

The basic unit of aggregation published by the US Census Bureau. Population statistics published for redistricting are distributed at the block level. In an urban area, this corresponds to approximately one city block. This block map has been altered to improve accuracy and align with the City of Philadelphia’s street centerline.

Census Tracts

For matching and analyzing demographic data collected and compiled by the U.S. Census Bureau & American Community Survey(ACS) to the geography of Census Block Group boundaries within the City of Philadelphia. These boundaries can change every ten years when the decennial census is conducted. Adjusted to City’s Standard Boundary Format.

Center City District Boundary (Business Improvement District)

Center City District encompasses 120 blocks and more than 4500 individual properties. The mission is to keep Center City clean, safe, and fun. CCD also makes phyiscal improvements to center city by installing and maintain lighting, signs, banners trees and landscape.

Center City District Police Boundary

The Center City District (CCD) is a business improvement district. The mission is to keep Center City clean, safe, and fun. CCD also makes phyiscal improvements to center city by installing and maintain lighting, signs, banners trees and landscape. This layer displays their policing boundary.

Certified for Rental Suitability

Properties that have applied and been approved as suitable for renting.

Choice Neighborhoods

The Choice Neighborhoods program is administered by the U.S. Department of Housing and Urban Development (HUD). It supports locally driven strategies to address struggling neighborhoods with distressed public or HUD-assisted housing through a comprehensive approach to neighborhood transformation.

City Council Districts

City Council Districts for a variety of different years.

City Employee Earnings

This data does not necessarily represent current salaries of employees and is intended for informational purposes only. Formal requests to document salary details or other personnel information should be made through the City’s Human Resources department.

Earnings for all City employees, including elected officials and Court staff. Data since 2019 up to the most recent quarter of this year. Please note that since employee counts fluctuate throughout the year, the sum of the BASE_SALARY field does not reflect the total budgeted amount. Also, when the BASE_SALARY column is blank, it represents part-time, temporary, or seasonal employees paid by the hour. Please see metadata for detailed explanations of each field.

City Facilities (Master Facilities Database)

An inventory of buildings and other fixed assets owned, leased, or operated by the City of Philadelphia including buildings, structures, and properties (not including surplus properties). Also known as the Master Facilities Database.

City Landmarks

An inventory of cultural landmarks found within the borders of the City of Philadelphia.

City Limits

To provide a base for very generalized maps or used as an outline in conjunction with other data layers. Establishes City Limits for City’s Standard Boundary Format. This layer was updated on July 22, 2012.

City Operating Budget

Proposed, adopted, and estimated operating budgets for City of Philadelphia government. The City’s Fiscal Year begins July 1st and ends June 30th.

City Owned Bridges

This layer identifies the point locations of the city owned bridges that are maintained by the Bridge Division of the City of Philadelphia Streets Department.

City Owned Properties

Web application displaying properties owned by the City, PHDC/RDA or other public entities.

City Payments

This dataset includes checks and ACH (direct deposit) payments made by the City during the fiscal year, which runs from July 1st 2016 through June 31st 2017.

Please see full metadata to learn more detail about important notes to this data, such as:

• This data cannot be compared with other financial and accounting reports released by the City.
• Legal and security-sensitive data has been rolled up to the aggregate dataset.
• This dataset does not include salary and benefits data or payments the City makes to fund the operations of the First Judicial District.
• Vendors should use the vendor payment website, not this dataset, to track payments.

City Plan Boundary

This layer was developed to aid the Surveys Division in planning, modifying and referencing the streets within a city plan of the City of Philadelphia. Examples include: building new streets, modifying existing streets, or observing current streets.

City-Registered Local Businesses

The City of Philadelphia gives preference to certified local businesses through its Local Business Entity program. This dataset provides a list of currently certified local businesses registered with the City of Philadelphia.

For more information, visit: https://www.phila.gov/departments/procurement-department/local-preference/

Civil Service Positions Details

These datasets show job classification and pay ranges details about Civil Service positions approved by the Civil Service commission and Administrative board.

Combined Sewer Service Area

This layer is dissolved and queried from PWD’s internal sewer shed feature class named modelsheds. The polygons in this layer are catchments for sanitary, storm and/or combined sewer flows. These catchments are used in the hydraulic models. Data DevelopmentBase Modelsheds are maintained regularly and delineate waste water and stormwater and combined sewer catchments in Philadelphia. Storm water and waste water pipe flow are analyzed to delineate the shed boundaries.

Commercial Corridors of Philadelphia

These are commercial corridors, centers, districts, and projects that provide consumer-oriented goods and services, including retail, food and beverage, and personal, professional, and business services.

Commodities Contracts

Commodities contracts are bid and awarded by the Procurement Department, for supplies, equipment, non-professional services, and public works. Each data set includes information regarding contracts that were renewed or received payment during the given quarter.

When you click on a file below and it opens in a new tab, simple right click on the page, and choose ‘save as.’ When the save as dialog box appears, make sure the ‘save as type’ is Microsoft Excel Comma Separated Values File. You should then be able to open in excel.

Community Compost Network Site

Community compost network sites located throughout the City of Philadelphia.

Community Health Assessment, Philadelphia Department of Public Health

The Community Health Assessment (CHA) is a systematic assessment of population health in Philadelphia, highlighting key public health challenges and assets and informing local public health programs, policies, and partnerships. The CHA includes indicators reflecting health behaviors, health conditions, health care factors, and social and environmental determinants of health. The Philadelphia Department of Public Health publishes an annual report of the analyses, linked to under the ‘Related’ tab. Additionally, they have released an online, interactive version of the CHA, known as the Community Health Explorer, to make the data more accessible to a broader audience.

Complaints Against Police

As part of the Philadelphia Police Department’s (PPD) accountability processes, PPD publishes three datasets: The Complaints Against Police (CAP) dataset documents the civilian complaints alleging police misconduct; the CAP Findings dataset provides demographic details of the police officer involved, the allegations, and the status of the PPD’s Internal Affairs Division’s investigation of and findings (if available) about the allegation; and the Complainant Demographics dataset shows the race, sex, and age of each person who filed a complaint against a police officer by complaint number.

See metadata links below for dataset and field descriptions.

Includes data from the past five years. Updated monthly.

Complete Streets

The Complete Streets Layer combines the Street Types developed by the City Planning Commission’s Pedestrian and Bicycle Plan, with the Complete Streets Handbook of the Mayor’s Office of Transportation and Utilities. It allows developers, planners, engineers and community groups to easily identify their street type and associated pedestrian, bicycle and other travel priorities to be included during the planning of new streets or large developments.

Condom Distribution Sites

Street location and hours of stores and organizations that distribute PDPH Freedom Condom-branded condoms.

Correctional Facilities Locations

These layers illustrate 10 correctional facilities in the City, administered by the Philadelphia Prisons System.

Courts

Point data of all First Judicial District of PA courts. Aside from the courts and locations, a main telephone number was added for each court. All information was provided by http://www.courts.phila.gov/locations.asp

COVID-19 Test Sites

A dataset of free COVID-19 testing sites.

If looking for a test, please use the Testing Sites locator app. ​No testing site will ask you for money. You will be asked for identification and may also be asked for health insurance information. If you don’t have identification or health insurance, you can still get a test. In addition, some sites may:

• Limit testing to people who meet certain criteria.
• Require an appointment.
• Require a referral from your doctor.
• Ask you to stay in your car (for drive-thru sites).

Check a location’s specific details on the map. Then, call or visit the provider’s website before going for a test.

COVID-19 Vaccinations

As of May 2022, these datasets moved from daily updates to weekly updates every Monday.

Shows distribution counts of first and second dose, as well as total dose information for all vaccinations performed by the health department. Also provides vaccinations by census tract, ZIP code, date, age, race, and sex. Vaccinations include residents and non-residents of Philadelphia. Updates daily.

COVID Deaths

**As of May 2022, these datasets moved from daily updates to weekly updates. **

For greatest accuracy, please use the latest dataset for all analysis and reporting as opposed to any data you downloaded prior to September 29, 2020. All datasets now reflect counts from test collection dates instead of the previously displayed result dates. These changes will adjust, for example, the count of cases for each day. PDPH has also added 376 confirmed COVID-19 cases (positive tests) that were previously missing from the data.

Deidentified, aggregate datasets showing COVID deaths by date, zip, race, or age. You can find COVID cases datasets here. To protect the confidentiality of residents, PDPH suppresses the exact data for any categories that have less than 6 counts (i.e. of cases or fatalities).

COVID Hospitalizations

As of May 2022, these datasets moved from daily updates to weekly updates every Monday.

A break down by census categories of the hospitalizations to date within the city limits.

COVID Tests and Cases

As of May 2022, these datasets moved from daily updates to weekly updates every Monday.

For greatest accuracy, please use the latest dataset for all analysis and reporting as opposed to any data you downloaded prior to September 29, 2020. All datasets now reflect counts from test collection dates instead of the previously displayed result dates. To keep things clear, the field name in the COVID Outcome by Date files also changed from ‘Result_Date’ to ‘CollectionDate.’ These changes will adjust, for example, the count of cases for each day. PDPH has also added 376 confirmed COVID-19 cases (positive tests) that were previously missing from the data.

Deidentified, aggregate datasets showing COVID tests by date, zip, and outcome and cases by race, age or sex. To protect the confidentiality of residents, PDPH suppresses the exact data for any categories that have less than 6 counts (i.e. of tests or fatalities).

Crime Incidents

Crime incidents from the Philadelphia Police Department. Part I crimes include violent offenses such as aggravated assault, rape, arson, among others. Part II crimes include simple assault, prostitution, gambling, fraud, and other non-violent offenses.

Please note that this is a very large dataset. To see all incidents, download all datasets for all years.

If you are comfortable with APIs, you can also use the API links to access this data. You can learn more about how to use the API at Carto’s SQL API site and in the Carto guide in the section on making calls to the API.

Curbs

This data includes curb edges with cartways and curb edges without cartways to represent travelways within the City of Philadelphia and it aids in placement of street centerline.

Dams

This layer shows point representation of all the dams in Philadelphia with latitude and longitude coordinates.

Department of Records Easement

Polygon description of use rights for ingress/egress, driveways, alleyways, utilities, drainage and subsurface areas.

Department of Records Property Parcels

Department of Records (DOR) Boundaries of real estate property parcels derived from legal recorded deed documents.

Digital Elevation Model (DEM)

A digital elevation model (DEM) is a 3D representation of the Earth’s surface, created from terrain elevation data. These DEMs were generated from LiDAR and LAS data was gathered for the City of Philadelphia

District Attorney Data Dashboard

Interactive data reports on the Philadelphia District Attorney’s Office’s work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data. Data downloads can be found at https://opendataphilly.org/datasets/district-attorney/

District Attorney Data Download

Summary data for each of several data sources can be downloaded in CSV and JSON formats. The data sources include: arrests, bail, case length, case outcomes, charges, future years of incarceration imposed, future years of supervision imposed, summary offense arrests, summary offense case length, summary office case outcomes, and summary charges. The data can be grouped by day, month, or year and filtered based on a date range. It can also be downloaded as a city-wide dataset or grouped by police district, zipcode, or census tract. The data is updated daily.

Economic Opportunity Plans

Economic Opportunity Plans (EOP)

Elected Committee People

This data set is a list of elected Committee People by ward, division, and party.

Election Board Who Worked on Election Day

This data reflects which Election Board Officials worked on Election Day and received payment for their services.

Election Results

Certified election results for both primary and general elections.

Empowerment Zones

Data includes commercial and industrial zones, i.e. areas with specific federal-granted special amenities (tax incentives, loans/grants) meant to attract and support businesses in blighted areas. Blighted areas are defined as meeting one of seven city mandated criteria, including unsafe, unsanitary and inadequate conditions; economically or socially undesirable land use; and faulty street and lot layout.

Enterprise Zones

Please note that the enterprise zones expired in the early 2000s, therefore this dataset has been archived, and will not be updated, but remains for historical analysis purposes.

Data includes commercial and industrial zones, i.e. areas with specific federal enterprise zone designation meant to attract and support businesses in blighted areas. Blighted areas are defined as meeting one of seven city mandated criteria, including unsafe, unsanitary and inadequate conditions; economically or socially undesirable land use; and faulty street and lot layout.

Existing Trails

Contains an inventory of all know road bikeable trails in Philadelphia, as compiled for the 2013 Philadelphia Trail Master Plan. This feature class was used to create maps, graphics, and inform analysis as part of the Philadelphia Trail Master Plan, adopted by the Planning Commission in July 2013. Please refer to the Philadelphia Trail Master Plan for further detail on the descriptions of the attributes described in the metadata. Inventory includes both existing trails and existing sidepaths, as defined in the metadata. Sidepaths are designated by the Streets Department with advisory approval from the Planning Commission, with the exception of side paths on Philadelphia Parks and Recreation property.

Exterior Violation Cleanups

Dates and locations of when lots were cleaned (removing weeds, debris, etc.) through the City of Philadelphia’s Community Life Improvement Program.

Farmers Markets Locations

Locations of farmers markets in Philadelphia.

Fatal Crashes

This data set shows all fatal crashes and their investigative outcomes from PPD’s Accident Investigation Unit (AID) from 1/1/19 to the present. The whole dataset gets refreshed nightly. This means the dataset will show new records the day after the source data has updated.

For those conducting analysis, this dataset by PPD and OTIS’ crash data should not be compared, or should be used together cautiously. The same crash may show as in different locations between the two datasets since PPD data represent the location of where crashes are initially reported whereas OTIS’ crash data involves further investigation to confirm initial reports. If you want to analyze the location of crashes in Philadelphia, use OTIS’ dataset. If you want to understand the investigative outcomes of crashes, use the PPD dataset.

FEMA Flood Plain

Federal Emergency Management Administration (FEMA) data clipped to Philadelphia.

Fire Department Facilities

Locations of Philadelphia Fire Department stations. Data originates from the City of Philadelphia Fire Department.

Flu Shot Clinic Schedule and Locations

Flu shot clinic schedule and locations for the City of Philadelphia. Locations include Philadelphia Department of Public Health District Health Centers, federally qualified health centers and community flu clinics.

Philadelphia Free Food and Meal Sites

The City of Philadelphia Office of Children and Families (OCF) partners with local food banks to find locations in the city for meal sites. The food banks provide information such as address, hours of operation, and eligibility that OCF enters to feed the meal site finder application. As needed, OCF updates the active status of each site.

Green Stormwater Infrastructure (GSI) Planning Parcels

PWD Parcels with fields added that help categorize parcels by Green Stormwater Infrastructure (GSI) Planning program and standardize ownership or ownership category and summarize impervious cover by surface type.

Green Stormwater Infrastructure Planning Districts

District planning areas for Green City, Clean Waters stormwater management strategic planning.

Green Stormwater Infrastructure Private Projects

Private Green Stormwater Infrastructure Project data in a tabular relational database. Location point data is digitized manually with a tracking number. Tabular data is queried and joined to point feature class before export to GEODB2 SDE databases.

Green Stormwater Infrastructure Public Projects

Point and line geometric features representing planned and completed Green Stormwater Infrastructure (GSI).

Health Centers

The location of primary care health centers.

Health of the City, Philadelphia Department of Public Health

The Health of the City report summarizes data on community health in Philadelphia through interactive charts and maps. The Health of the City table contains aggregate metrics on population statistics, social determinants of health, and health outcomes that were used to build this report.

Healthy Chinese Takeout

Healthy Chinese Takeout participants as of 2/5/15. The Philadelphia Healthy Chinese Take-out Initiative is working to prevent and control high blood pressure in Philadelphia residents by 1) reducing the sodium content in Chinese take-out dishes by 10-15% and 2) decreasing access to tobacco products. The initiative is a joint effort among Temple University’s Center for Asian Health, the Asian Community Health Coalition, the Philadelphia Chinese Restaurant Association, and the Philadelphia Department of Public Health. Excess consumption of sodium (salt) and tobacco use are two major contributors to hypertension, heart disease and stroke. Chinese take-out restaurant dishes can have large amounts of sodium mainly due to the sauces used in preparation and cooking. And Chinese take-out restaurants tend to have higher rates of illegal tobacco sales to minors than other retailers. To date, 200 Chinese take-out restaurants have enrolled in the initiative, participated in a low-sodium healthy cooking training with a professional chef, and received education about complying with the Tobacco Youth Sales Law.

Healthy Corner Store Locations

This dataset contains location data for both Healthy Corner and Enhanced Healthy Corner Store. It is currently being updated. Please visit Food Fit Philly for information in the interim.

Healthy Start Community Resource Centers

Street location, hours and contact information of PDPH-affiliated HealthyStart Community Resource Centers.

Heat Vulnerability by Census Tract

Describes heat vulnerability by census tract incorporating exposure and sensitivity indicators.

Highway Districts

Please note that the dataset below is a snapshot of data captured at one time and does not receive regular updates.

The Highway Districts dataset shows the boundaries of highway districts used for managing maintenance of roads.

Highway Sections

This layer delineates the fifty-six sections of the Highway Division of the City of Philadelphia Streets Department. Sections can be aggregated into districts and subdivided into subsections. A Highway Engineer is responsible for each district. The section layer was developed to aid the Highway Division in the planning, organizing, and maintaining of the streets within each of the six districts. Examples of maintenance include: paving, snow removal, concrete maintenance, and the monitoring/repairing of ditches and potholes.

Highway Subsections

The subsection layer was developed to aid the Highway Division in the planning, organizing, and maintaining of the streets within each of the fifty-six sections. Examples include: paving, snow removal, concrete maintenance, and the monitoring/repairing of ditches and potholes.

Historic Streams

Philadelphia streams as mapped by Charles Ellet in 1842 and Previous study of historic streams conducted by PWD.

Historic Streets

To map older streets with historical value in the City of Philadelphia.

HIV Testing Sites

This point layer contains the locations of HIV testing sites in the City of Philadelphia.

Homes Saved

To prevent homeowners from becoming homeless due to foreclosure, the City initiated the Residential Mortgage Foreclosure Prevention Program, an innovative program that links a Court of Common Pleas order requiring that homeowners facing foreclosure have an opportunity to meet with their lenders to negotiate an alternative to foreclosure with City-funded housing counseling, outreach, a hotline and legal assistance. Working together, the City and the Court have created and implemented a national model.

Housing Counseling Agencies

OHCD has long supported neighborhood-based and citywide organizations offering housing counseling services to low- and moderate-income people. OHCD-funded services provided by these agencies include mortgage counseling, default and delinquency counseling, tenant support and housing consumer education. Through these services prospective homeowners can avoid predatory loans, a significant cause of foreclosure.

Hydrology

Locations of surface water features (rivers, creeks, ponds, reservoirs) and water beneath city bridges and adjacent to city borders. Separate files are available for each waterbody (and watershed) in KML form, or as a whole in Shapefile form.

Impervious Surfaces

This is one of the planimetric coverages developed as part of the aerial survey project of 1996 and updated using new aerial photography collected between 25 March 2004 and 23 April 2004.

Indego Bike Share Stations

Data relating to the Indego BikeShare program, including station locations and the number of available bikes. More information about the program is available at: https://www.rideindego.com/about/data/

Indego Bike Share Trips

Data relating to the Indego BikeShare program, including station locations and the number of available bikes. More information about the program is available at: https://www.rideindego.com/about/data/

Instore Forgivable Loan Program

Contains information about the applicant, business, project, and costs. Used for tracking completed projects; including tracking amounts paid.

Intersection Controls

This layer identifies the active intersection controls for the Street Lighting and Traffic Engineering Divisions of the City of Philadelphia Streets Department.

Land Use

City of Philadelphia land use as ascribed to individual parcel boundaries or units of land. Land use is the type of activity occurring on the land such as residential, commercial or industrial. Each unit of land is assigned one of nine major classifications of land use (2-digit code), and where possible a more narrowly defined sub-classification (3-digit code). The land use feature class has been field checked and corrected for the following Planning Districts.

LandCare Program

The Philadelphia LandCare layer is an inventory of all vacant parcels that have received the “Clean and Green” stabilization treatment and are currently under maintenance contract with the Pennsylvania Horticultural Society, funded by the City of Philadelphia’s Division of Housing and Community Development. Every spring and fall, additional vacant parcels are stabilized and then added to the maintenance inventory the following year. The parcels in this layer are based off the PARCEL_PWD layer, supplied by the Philadelphia Water Department.

Language Services Usage

This dataset tracks usage of the City’s language access services through contracts with external vendors for translation and interpretation.

Large Building Energy Benchmarking Data

This dataset contains annual building and performance data for those properties required to report. Property data is pulled from the Office of Property Assessment. Energy and water data is self-reported by building owners using the EPA Portfolio Manager tool. This data will be updated annually.

Leaf Collection Areas

To identify boundaries for City Leaf Collection Services.

Leaf Dropoff Sites

Licenses and Inspections Appeals of Code Violations and Permit Refusals

The Department of Licenses and Inspections accepts applications for appeals of various violations, refusals, revocations, and denials to the following Boards: *Board of Building Standards *Licenses and Inspections (L&I) Review Board *Zoning Board of Adjustments

For more information, please visit http://www.phila.gov/li/Pages/Appeals.aspx

The Court Appeals datasets provides details about Appeals that went to court and what the status/results of the court proceedings are. Some Appeal numbers could have multiple appeal types, so those are provided as a dataset below as well.

The Board Decisions datasets shows the decisions made by the Appeal Boards (LIRB, ZBA, BBS).

Licenses and Inspections Building and Zoning Permits

The Department of Licenses & Inspections reviews construction plans and conducts building inspections to ensure the safety of the workers and the public.

Zoning permits are issued to authorize new construction or additions to a building or to authorize the change of use in a building or ground.

Building permits are required before the start of a specific construction activity to enlarge, repair, change, add to or demolish a structure, and to install equipment or systems in a structure. Depending on the scale or type of construction activity, it may need to be first authorized via a zoning permit. Permit contractors are also available as a dataset. Plumbing and electrical permits, among others, may also be required for new or existing buildings.

Please note that this is a very large dataset.

If you are comfortable with APIs, you can also use the API links to access this data. You can learn more about how to use the API at Carto’s SQL API site and in the Carto guide in the section on making calls to the API.

Licenses and Inspections Building Certifications

Certain buildings in the City of Philadelphia require periodic inspections. These inspections are performed by licensed inspection companies. Buildings that contain fire sprinkler systems or hard-wired fire alarm systems must have these systems inspected annually. Buildings over 60 feet must have their façade inspected every five years. Buildings with fire escapes or private bridges must have these structures inspected every five years. Non-vacant piers must be inspected every three years. The Department of Licenses and Inspections collects certifications documenting the conditions of these structures and enforces the requirements that property owners file these certifications with the Department and repair any structural issues or system deficiencies identified during the corresponding inspection. This dataset contains records related to these building certifications.

You can find out more information about fire protection certifications and maintenance inspections.

Licenses and Inspections Business Licenses

Information regarding applications for licenses required by the City to conduct certain business activities. Licenses are required for individuals and businesses to engage in select commercial activities. For example, vendors and restaurants require a license in order to sell goods and food and trades-people, such as plumbers and contractors, require a license in order to practice their trade.

Information includes license application type, applicant, property for which the license would be issued, application date, issue date, and expiration date. Data is accurate; however, it may be misinterpreted by an unfamiliar user.

Licenses and Inspections: Case Investigations

All investigations completed on a property with property maintenance violations by an inspector of the Department of Licenses & Inspections.

Please note that this is a very large dataset. To see all investigations, download all datasets for all years.

If you are comfortable with APIs, you can also use the API links to access this data. You can learn more about how to use the API at Carto’s SQL API site and in the Carto guide in the section on making calls to the API.

Licenses and Inspections Clean and Seal

Address, date of abatement, and more for properties that have been cleaned and sealed by the L&I Clean & Seal Unit.

Licenses and Inspections Code Violations

Violations issued by the Department of Licenses and Inspections in reference to the Philadelphia Building Construction and Occupancy Code.

Please note that L&I Violations is a very large dataset. To see all violations, download all datasets for all years.

If you are comfortable with APIs, you can also use the API links to access this data. You can learn more about how to use the API at Carto’s SQL API site and in the Carto guide in the section on making calls to the API.

Licenses and Inspections Commercial Activity Licenses

Commercial Activity Licenses are required by entities doing business in the City of Philadelphia. Information includes license number, application date, issuance date, applicant information, business entity name and other related information.

Licenses and Inspections Complaints

Complaints that were entered via 311 or by an individual in the department. Complaints were formerly known as ‘Service Requests’ in L&I’s old enterprise database called ‘Hansen’, which was decommissioned in March 2020.

Each row in the table represents a single ‘call’. Calls are sometimes bunched into one ‘Complaint’ all sharing the same unique number.

Licenses and Inspections District Offices

Location and contact information for the L&I district offices.

For all L&I data related inquiries contact ligisteam@phila.gov. For all other L&I related services (including eCLIPSE troubleshooting) please contact Philly311: *Inside City Limits: 311 *Outside City Limits: 215-686-8686

Licenses and Inspections Districts

District Boundaries for the Department of Licenses & Inspections are pre 2014. Districts Broad refers to the five districts which contain their own district offices and are a method the department uses to assign and analyze work.

Licenses and Inspections Property History

This dataset documents the history of permits, licenses, violations, and appeals for each property in the City.

Licenses and Inspections Trade Licenses

Information regarding individuals who have applied for trades licenses such as General Contractor, Master Plumber, and more. Information includes the individual’s name, license number, license status issue date, expiration date, company name, and revenue code.

LiDAR-LAS data

LiDAR and LAS data was gathered for the City of Philadelphia in April 2008, April 2010 and April 2018.

Litter Index

The Litter Index is used to compare the relative cleanliness of different areas of the city of Philadelphia. This data will be updated annually.

Major Watersheds - Philadelphia

Polygon feature class representing major watersheds in Philadelphia. Data was developed originally from either USGS and the 2004 Sanborn DEM (digital elevation model) using ArcHydro watershed extraction tools. Major Watersheds are dissolved from subshed boundaries which reflect surface flow in relationship to stormwater inlets and outfalls.

Major Watersheds - Regional

Polygon feature class representing major watersheds in Philadelphia. Data was developed originally from either USGS and the 2004 Sanborn DEM (digital elevation model) using ArcHydro watershed extraction tools. Major Watersheds are dissolved from subshed boundaries which reflect surface flow in relationship to stormwater inlets and outfalls.

Market Value Assessment (MVA)

The Reinvestment Fund’s (TRF) Market Value Analysis (MVAs) is a tool residents and policymakers can use to identify and understand the elements of their local real estate markets. It is an objective, data driven tool built on local administrative data and validated with local experts. With an MVA, public officials and private actors can more precisely target intervention strategies in stressed markets and support sustainable growth in stronger markets. Visit TRF’s MVA analysis page for more information.

Neighborhood Advisory Committees (NACs)

DHCD’s Neighborhood Advisory Committee (NAC) Program offers community-based non-profit organizations the opportunity to lead and engage neighborhood residents in activities that support the City’s core objectives.

Neighborhood Energy Centers

DHCD supports the Energy Coordinating Agency’s (ECA) Neighborhood Energy Centers, through which residents can complete applications to seek bill payment assistance, learn how to conserve water, gas and electricity, and obtain energy counseling.

Neighborhood Food Retail

This dataset is derived from the Neighborhood Food Retail in Philadelphia report. The report, and accompanying online resource gallery, looks at neighborhood availability of “high-produce supply stores” (e.g., supermarkets, produce stores, farmers’ markets) in relation to “low-produce supply stores” (like dollar stores, pharmacies, and convenience stores).

Neighborhood Resources

Dataset with the contact information for Housing Counseling Agencies, Neighborhood Advisory Committees, and Neighborhood Energy Centers.

.

Non-Thru Streets for Trucks

To map streets with no through trucks in the City of Philadelphia.

OEO Registry of Certified Minority/Women/Disable Owned Business Enterprises

A database of all Minority/Women/Disable Owned (MWD) owned businesses that are registered with the City of Philadelphia’s Office of Economic Opportunity (OEO).

OpenMaps

Explore Philadelphia’s most popular open geographic data in one easy to use mapping tool. This tool was built by the City’s Office of Innovation and Technology’s CityGeo team.

Outdoor Advertising

Locational and relevant attribute data pertaining to billboard and outdoor advertising locations throughout the City of Philadelphia.

2015 Parking Meter & Kiosk Inventory

Raw data dump from the PPA including meter/kiosk manufacturer and model, as well as status.

Parking Violations

Please note that this is a very large dataset. To see all violations, download all datasets for all years.

If you are comfortable with APIs, you can also use the API links to access this data. You can learn more about how to use the API at Carto’s SQL API site and in the Carto guide in the section on making calls to the API.

Parks and Recreation Out of School Time Programs

Philadelphia Parks and Recreation out-of-school time afterschool programs.

Parks and Recreation (PPR) Trails

Linear representation of Philadelphia Parks and Recreation (PPR) trails. Not designed for networking.

Parks & Recreation Districts

Polygon boundaries of Philadelphia Parks and Recreation (PPR) operational districts as established by PPR’s GIS staff and reviewed, revised, and approved by PPR’s executive staff. These boundaries were revised from boundaries that were in place in prior years.

Parks & Recreation Program Sites

Point location features for all PPR Program site locations. This dataset includes recreation centers, playgrounds, older adult centers, swimming pools, and environmental education centers.

Paving Plan

City of Philadelphia paving plan for 2015 that displays paving project funding, City - Local Funding, City - Federal Funding, and State Funding.

Pennsylvania State House of Representatives Districts

Please refer to PA’s open data for the State House Representative Districts.

People Released to Philadelphia from Prison & Jail

This dataset includes people released to Philadelphia from the Philadelphia Department of Prisons (PDP) and the Pennsylvania Department of Correction (PA DOC). Individual-level data for releases from Federal (BOP) incarceration was not available, and makes up less than 2% of people released to Philadelphia in the year analyzed. The dataset also only includes people released to Philadelphia who have been charged with a criminal non-summary type offense in the Philadelphia adult criminal justice system.

Percent for Art Locations

Locations and basic information on public art that is part of the Percent for Art program. Updated as needed.

Philadelphia Basemaps

Basemaps of the Philadelphia area, including from the Department of Records.

Philadelphia Beverage Tax Registered Distributors and Dealers

This data has stopped receiving updates. We’re working to reestablish automation by the end of 2022.

This dataset provides a list of businesses that have registered as sweetened beverage distributors or dealers that file and pay the tax. The search application built off of this dataset allows businesses to find or confirm that their distributors or dealers are registered. Please note that this dataset shows only those Registered Distributors and Registered Dealers who consented to share their information publicly and thus this list may not be a comprehensive list of all who have registered.

Find out more about the Philadelphia Beverage Tax here.

Philadelphia Child Blood Lead Levels

This dataset includes the number of newly identified (incident) children with blood lead levels (BLL) ≥5 µg/dL, the number of children screened, and the percent of children screened with BLLs ≥5 µg/dL. The ZIP code data is for 2015 and the census tract data is for 2013-2015.

Cell counts with missing values are those with less than six observations, which was truncated to ensure confidentiality. Cells with values of zero were included.

Philadelphia Code and Home Rule Charter

Raw text and other formats available of the City of Philadelphia Municipal Code and City Charter.

Philadelphia ESL (English as a Second Language) Class Locations

Location of English as a Second Language (ESL) classes in Philadelphia. To find the best site to visit for ESL classes, or to enroll in training for volunteers to become an ESL tutor, please contact the Office of Adult Education at 215-686-5250.

Philadelphia Hospitals

A list of hospitals and their location in Philadelphia.

Philadelphia Household Internet Assessment Survey

A survey assessment on home broadband and device access in the City of Philadelphia.

Philadelphia Land Cover Raster

The Philadelphia Land Cover Raster provides data on the types of surfaces in Philadelphia in 2008. The data identifies seven categories: tree canopy, grass/shrub, bare earth, water, buildings, roads, other paved surfaces. The data primarily was intended to demonstrate tree canopy levels in Philadelphia. When tree canopy covers another surface type, that area is placed in the tree canopy category. The data was gathered with the assistance of the University of Vermont Spatial Analysis Laboratory.

Philadelphia Lobbying Information System (App)

The Philadelphia Lobbying Information System is a searchable database of registered lobbyists, principals and lobbying firms as well as lobbying expenses

The data was collected to comply with City Code Chapter 20-1200 (and Board Regulation No. 9) and more generally to provide the public insight as to the outside interests who speak with City government officials to influence policy. Data was submitted to PLIS by lobbyists, lobbying firms, and principals. The intended audience for this data is anyone with an interest in the people lobbying City government. The data collected by PLIS is a public record intended to make the legislative and executive process more transparent by providing the public with a clear picture of all of the outside interests involved in policy discussions.

Philadelphia Pennsylvania State Senatorial Districts

Please refer to PA’s open data for the State Senate Districts.

Philadelphia Properties and Assessment History

Some of the information in the open data files below may not yet reflect the data used to calculate the most recent tax year’s property value. If you see missing or incorrect info about your property, use this form to contact OPA to report the issue.

Property characteristic and assessment history from the Office of Property Assessment for all properties in Philadelphia. See more information on how OPA assesses property and their reports on the quality of assessments.

This data updates nightly. Please ignore the ‘created by’ date below - the date of August 2015 shows when this webpage, not the data, was created.

Philadelphia Registered Historic Districts

Historic districts listed on the Philadelphia Register. Data was updated by the Philadelphia City Planning Commission in August 2017. The public can confirm a property’s historic status by contacting the Historical Commission at 215-686-7660.

You can also download a dataset of the Historic sites.

Philadelphia Registered Historic Properties

Historic sites listed on the Philadelphia Register. Data was updated by the Philadelphia City Planning Commission in July 2017. The public should confirm a property’s historic status by contacting the Historical Commission at 215-686-7660.

You can also download a dataset of the Historic districts.

Philadelphia Tree Inventory

A comprehensive inventory of all trees within the limits of the City of Philadelphia. This dataset is a snapshot in time from 2021 and will update yearly.

Philadelphia Universities and Colleges

The purpose of this dataset is to provide the geographic locations of the college and universities in Philadelphia along with their attribute data attached to each polygon.

Philadelphia Vital Statistics - Mortality (Deaths)

Vital Statistics tables that contain aggregate metrics on the mortality (deaths) of Philadelphia residents. Included in these datasets are mortality metrics by planning district or citywide. You can find natality (births) metrics, and social determinants of health metrics at the city and planning district levels of geography as well. Population metrics are provided at the city, planning district, and census tract levels of geography. Please refer to this technical notes document to access detailed technical notes and variable definitions.

Philadelphia Vital Statistics - Natality (Births)

Vital Statistics tables that contain aggregate metrics on the natality (births) of Philadelphia residents. Included in these datasets are natality metrics by planning district or citywide. You can find mortality (deaths) metrics, and social determinants of health metrics at the city and planning district levels of geography as well. Population metrics are provided at the city, planning district, and census tract levels of geography. Please refer to the metadata links below for variable definitions and this technical notes document to access detailed technical notes about the datasets.

Philadelphia Vital Statistics - Population Metrics

Population metrics are provided at the census tract, planning district, and citywide levels of geography.

You can find related vital statistics tables that contain aggregate metrics on natality (births) and mortality (deaths) of Philadelphia residents as well as social determinants of health metrics at the city and planning district levels of geography. Please refer to the metadata links below for variable definitions and the technical notes document to access detailed technical notes and variable definitions.

Philadelphia Vital Statistics - Social Determinants of Health (SDOH)

Social determinants of health metrics at the city and planning district levels of geography. Please refer to the metadata links below for variable definitions and this technical notes document to access detailed technical notes and variable definitions.

You can find related vital statistics tables that contain aggregate metrics on vital events, including natality (births) metrics and mortality (deaths) by planning district or citywide. Population metrics are provided at the city, planning district, and census tract levels of geography.

PhilaDox - Property Documents

PhilaDox is an online database of documents filed with the City of Philadelphia Department of Records. It stores contemporary land records, including deeds, sheriff deeds, mortgages, and land titles since 1974. Data is viewable as lists, tables and scanned images of the actual documents. The database is searchable by grantor/grantee names, address, or county record book and page. Scanned documents can be downloaded as PDFs.

Full access to PhilaDox records is available with a daily, weekly, monthly, or annual subscription. More limited search for names and address is available for free public access.

Philly Rising Boundaries

The boundaries of the four designated pilot areas included in the Philly Rising program. Philly Rising focuses on areas with chronic quality of life concerns and works with residents and community groups to address neighborhood issues.

PhillyHistory.org

PhillyHistory.org is an online database of historic photographs and maps from the Philadelphia City Archives and four additional area institutions. A project of the City of Philadelphia Department of Records, the database contains images dating back to the 1850s and can be searched by geographic criteria such as address, intersection, place name, and neighborhood as well as keyword, date, collection, topics, and other criteria. Images and maps are associated with a location using the database’s geocoding feature. Users can create a free account to save images, bookmark searches, and submit error reports.

PHLmaps

The City of Philadelphia’s ArcGIS Online organization that hosts references to open data releases as feature services and AGO map applications shared with the public. Maintained by the City’s Office of Innovation and Technology’s CityGeo team.

Planning Districts

To illustrate the outlines of the 18 Districts for Philadelphia2035 District Plans.

Playstreets Locations

The streets (at the center of platystreet blocks) involved in the PPR Playstreets Program. This program closes designated streets to traffic so that kids have a safe place to play when school is out. A key feature of the program are the nutritious meals and snacks provided to children. This is important during the summer months when school meals are not available.

Police Athletic League (PAL) Centers

This data was developed for cartographic use – specifically, as reference information for the Police Athletic League.

Police Districts

Police district boundaries. A police Captain is responsible for each district. Districts are subdivided into sectors. Several districts are aggregated into divisions.

Police Divisions

Police division boundaries. Divisions are aggregations of police districts.

Police Service Areas

There are currently 65 Police Service Areas (PSA) boundaries in Philadelphia with two to four per District. These boundaries replaced a much smaller boundary, Sectors in 2009. In several Districts, PSA’s split Sector boundaries and therefore a historical comparison would not necessarily be accurate.

Police Stations

Locations of Police Stations.

Political Ward Divisions

Boundaries of the ward divisions (subunits of wards) in Philadelphia. The first two numbers of a four number division identifier indicates the ward in which the specific division is located.

Political Wards

Boundaries of wards (political units) in the City of Philadelphia. Data was developed by Philadelphia City Planning Commission. Each ward contains no fewer than 10 and no more than 50 divisions. Ward leaders are elected by their party’s committeepeople. Learn more about Democratic Ward Leaders and Committeepeople : http://www.seventy.org/Resources_Ward_Leaders_and_Committeepeople.aspx

Polling Places

The locations of polling places in Philadelphia, along with parking code and building accessibility code attribute markers. Data is originally provided by the Philadelphia City Commissioners and is continuously updated in correspondence with the City Commissioners website, www.philadelphiavotes.com.

PPR Adult Exercise Equipment

Displays the locations of adult exercise equipment located within or are maintained by Philadelphia Parks and Recreation (PPR).

PPR Boat Launches

Boat launches across the city are places where boats (kayaks, canoes, and or motorboats) can be launched onto the Schuylkill River or Delaware River. This dataset identifies the boat launches/ramps located on PPR property or boat launches PPR administers directly.

PPR Building Structures

Footprints of buildings and structures located on Philadelphia Parks and Recreation (PPR) properties or utilized directly by PPR.

PPR Friends Group

Friends groups registered with the Philadelphia Parks and Recreation Stewardship team.

PPR Help Locators

Displays the locations of adult exercise equipment located within or maintained by Philadelphia Parks and Recreation (PPR).

PPR Hydration Stations

Locations of hydration station and water fountains on or near Philadelphia Parks and Recreation (PPR) assets.

PPR Permittable Space

Locations within PPR that are permittable based on PPR team. Feature designed to link with Permitting Application for PPR. BETA Version.

PPR Picnic Sites

Displays the locations of picnic sites located within Philadelphia Parks and Recreation boundaries. Picnic sites are denoted as any location with a picnic table.

PPR Playgrounds

Displays the locations of playgrounds within PPR Boundaries. Playgrounds ARE designated as similar age range equipment within a definable distance (not each piece of equipment).

PPR Program Districts

Polygon boundaries of PPR’s program districts as established by PPR’s GIS staff and reviewed, revised, and approved by PPR’s executive staff.

PPR Properties

Locations and boundaries for properties that Philadelphia Parks and Recreation (PPR) has responsibility for or has a distinct role in the maintenance or management.

PPR Spraygrounds

The location of spraygrounds in Philadelphia run by Parks and Recreation.

PPR Swimming Pools

The location of swimming pools in Philadelphia run by Parks and Recreation.

PPR Tennis Courts

Displays the locations of tennis courts located within properties maintained by Philadelphia Parks and Recreation (PPR).

PPR Tree Canopy

2018 data: This dataset was developed as part of an Urban Tree Canopy (UTC) assessment for Philadelphia,Pennsylvania. It shows how tree canopy changed during the period 2008-2018, highlighting trees that were gained or lost during the 10-year period. It is intended for use in monitoring patterns of change in Philadelphia,Pennsylvania tree canopy.

2015 data: Collection of tree canopy outlines and points generated by Intergraph Government Solutions (IGS) for trees >6’ diameter. Update generated off the 2015 Leaf-Off 3” AccuPLUS Imagery representing changes in tree canopy visible within the imagery. Heights have been derived separately for each tree canopy outline from 2015 LiDAR data capture.

PrEP Providers

This point layer contains the locations of PrEP providers in the City of Philadelphia.

Professional Services Contracts

The entire dataset for Professional Services Contracts by fiscal quarter are available for download in a Microsoft Excel® compatible CSV format below. To download: click on the dataset url, which will open in a new browser tab as a text file. Right click on the text and choose ‘save as’ csv to download it.

The City of Philadelphia, through a joint effort among the Finance Department, Chief Integrity Officer and the Office of Innovation and Technology (OIT), launched an online, open data website for City contracts. The site provides data on the City’s professional services contracts in a searchable format and includes a breakdown of contract dollars by vendor, department and service type. It also features a “frequently asked questions” section to help users understand the available data: http://cityofphiladelphia.github.io/contracts/.

PWD Customer Service Calls

Every call received by the Customer Information Unit for issues like open hydrants, cave ins, and more. Calls are categorized as to the type of issue at hand. Includes outcomes of calls. Billing matters are referred to the Water Revenue Bureau.

PWD Geotechnical Tests

BACKGROUND - The objective of geotechnical testing is to help determine the suitability of a site for green stormwater infrastructure. The tests are used to calculate infiltration rates at proposed green infrastructure locations and evaluate the lithology at depths sufficient to identify any hydraulically limiting layers that would inhibit vertical infiltration and potentially cause lateral flow. The testing includes drilling borings followed by infiltration testing within the footprint of each GSI system.

USING THE LAYER - The infiltration rates and subsurface lithology results such as depth to bedrock and depth to groundwater may be helpful for other users of this layer, but it is important to note that these values can vary widely from location to location, even for nearby sites.

PWD Sewersheds

A sewershed is the area of land where all the sewers flow to a single end point, in most cases it is a regulator/permitted outfall, but in cases when the flow can be split between multiple regulators/permitted outfalls, the area above the point of split is treated as a separate sewershed.

PWD Stormwater Billing Parcels

The primary purpose of PWD_PARCEL layer is to calculate parcel-based stormwater charges for PWD customers under the new parcel-based stormwater billing program. The layer was created from the DOR_PARCELS layer in 2005 after it was decided that none of the other City parcel layers could meet the needs of PWD’s stormwater billing program. Those needs are generally that the parcel delineations match up to what people actually own, that there is an accurate assessment of the impervious area on the parcel, and that there is owner information associated with the parcel. Over the past 5 years, PWD has made corrections based off deeds on file with DOR, BRT information, and other City records. PWD also matched up each DOR parcel to a corresponding BRT record that contained the owner information for that parcel.

PWD Stream Sampling Locations

Locations where PWD has conducted surface water quality sampling and other types of stream assessments. Sampling activities may include water quality grab sampling, habitat assessment, and sampling of invertebrates, fish and algae from wadeable streams. Not all assessment activities are performed at all sites.

Railroad Lines

This is one of the planimetric coverages developed as part of the aerial survey project of 1996 and updated using new aerial photography collected between 25 March 2004 and 23 April 2004.

Rain Barrels

Rain Barrels installed under PWD’s Rain Barrel Workshop and Installation program, which ran from 2006 to 2014.

Rain Check Installation Sites

Rain Check is a Philadelphia Water Department program that helps residents manage stormwater and beautify their homes.

Rain Gauges

The purpose of this data is to describe the Rain Gauges both locationally and via their attributes. This data shows the location and attributes of Rain Gauges throughout the City of Philadelphia.

Real Estate Tax Balances

Data about real estate accounts with tax balances. The aggregated datasets include both accounts with overdue balances (property owner owes a late balance in the current tax year but it is not yet considered delinquent) and tax delinquencies. Tax delinquencies are accounts with outstanding balances for previous tax years. A past due account becomes delinquent when the real estate tax is still unpaid on January 1 of the following year that the tax was due.

Real Estate Transfers

The Department of Records (DOR) published data for all documents recorded since December 06, 1999, including all real estate transfers in Philadelphia. Document type, grantor, and grantee information is presented by address for each transaction. More specifically, the real estate transfers data shows the dates and location of property sales, deeds, mortgages, and sheriff deeds, and includes associated data, such as any realty transfer tax paid. This table contains both raw source data as well as calculated and geocoded/data fields.

Please note that this is a very large dataset and Excel will not load all of the records. If you’re only comfortable with Excel, please use either the links for individual years, or the data visualization which allows you to filter the dataset by your specific interests (i.e. a zip code) and then export a custom CSV from the table at the bottom of the visualization. We provide the CSV of All Years mostly for developers to use when coding. If you are comfortable with APIs, you could also use the API links to access this data. You can learn more about how to use the API at Carto’s SQL API site and in the Carto guide in the section on making calls to the API.

RecycleBank Participation

Count of residents participating in the RecycleBank program by street segment.

Recycling Diversion Rate

Rate of recycling per rubbish/recycling district in total tons of recycling divided by the total tons of rubbish (garbage) collected during the given time period, either fiscal year, a fiscal year through a given quarter, or within one quarter.

Recycling and Donations Resources

A dataset of the places to donate or recycle items in Philadelphia.

Red Light Cameras

Locations of red light cameras maintained by the Philadelphia Parking Authority.

Redevelopment Certified Areas

Development certified areas, i.e. areas deemed blighted and eligible for urban renewal by the Philadelphia City Planning Commission under the amended Pennsylvania Urban Redevelopment Law. Blighted areas are defined as meeting one of seven city mandated criteria, including unsafe, unsanitary and inadequate conditions; economically or socially undesirable land use; and faulty street and lot layout.

Registered Community Gardens

Locations of community gardens throughout the City of Philadelphia that are registered with the Philadelphia Parks and Recreation’s Urban Agriculture Team.

Registered Community Organizations (RCO) Boundaries

Boundaries of Registered Community Organizations (RCO) as established under the City of Philadelphia Zoning Code enacted December 15, 2011 and made effective August 22, 2012.

Residency Waivers

The table below shows which job positions have received a waiver from the following residency requirements.

To get a job with the City, you must fulfill certain residency requirements: -Exempt positions: You must move to Philadelphia within six months after your appointment date. -Civil service positions: you must live in Philadelphia for one year before your appointment date.

Residential Parking Permit Blocks

Trouble downloading or have questions about this City dataset? Visit the OpenDataPhilly Discussion Group

Retrofitted Homes

Trouble downloading or have questions about this City dataset? Visit the OpenDataPhilly Discussion Group

Ryan White HIV Treatment Centers

Street location, contact information and hours of PDPH-funded HIV Treatment Centers.

Sanitation Areas

Data includes the boundaries for city sanitation areas (which are aggregations of Sanitation Districts).

Sanitation Collection Day Boundary

The data is used to determine the day of sanitation collection (rubbish and recycling) for a given location and set of households in the City of Philadelphia. The file is also used to aggregate data such as households, tonnage, and mileage.

This polygon layer has an accompanying arc layer. Certain arcs in the arc layer contain data signifying information relating it to the polygon layer. It can tell you if both sides of the arc belong to one of the bounding polygons. All the arcs, including those with no boundary info, have naming attributes for labeling the polygon borders.

Sanitation Convenience Centers

Sites where residents can drop off household trash and recycling.

Sanitation Districts

Boundaries of city sanitation districts. Collection areas are subdivisions of districts. Districts are aggregated up to Sanitation Areas.

Schools Parcels

The parcel locations of public (School District of Philadelphia), charter, private and archdiocesan schools in the City of Philadelphia. Please keep in mind that this data, particularly with regards to enrollment, is constantly changing or is not publicly available. If you have specific questions about a school, please contact that facility directly. This dataset includes the location of schools in the City of Philadelphia with attribute information for address, grade level, type, and status. The institution types are displayed by default using the following subtypes: district (public schools), charter and private (including archdiocesan). There is also a point layer of Schools available.

Schools

Data includes points identifying public schools, charter schools, many private schools, school annexes, and athletic fields and facilities. The types of data were extended from previous schools layers in order to assist the Streets Department in their school signage and crosswalk initiatives.

The schools layer provides information on public, private, charter and archdiocesan schools. Please keep in mind that this data, particularly with regards to enrollment, is constantly changing or is not publicly available. If you have specific questions about a school, please contact that facility directly.

Sharps Drop Boxes

This point layer contains the locations of sharps (needle) drop boxes in the City of Philadelphia.

Shooting Victims

City-wide shooting victims, including Police Officer-involved shootings

Snow Emergency Routes

From the Streets Department snow emergency route page

When snow accumulations approach emergency status, the Managing Director may declare a snow emergency. Once emergency status is declared, the City’s 110 miles of Snow Emergency Routes receive priority. Owners of vehicles and dumpsters must move them to alternate parking spaces so City forces can clear snow from curb-to-curb on the emergency routes. Any vehicle remaining on a Snow Emergency Route during the declared Snow Emergency will be ticketed and towed. If your car is towed, call 215-686-SNOW for its location. Do NOT call 911. The snow-emergency-routes.csv file was created from the table on the Streets Department snow emergency route page. I used this file to generate the snow-emergency-route-segment-ids.csv file.

The snow-emergency-route-segment-ids.csv file contains the IDs of all of the street segments that are classified as snow emergency routes. The snow emergency routes shapefile/geojson is built by filtering the street centerline layer to include only those rows where the seg_id is contained in this list.

Special Vending Districts

Districts with special sidewalk vending rules pursuant to Sections 9-204 (Sidewalk Vendors in Center City) and 9-206 (Sidewalk Vendors in Neighborhood Business Districts) of The Philadelphia Code.

Storefront Improvement Program Grants Disbursed

This data set reflects the recipients, award amounts, and project sites for grant money disbursed by the Philadelphia Commerce Department for the Storefront Improvement Program whereby businesses are provided the funds to improve the exterior of their storefront.

Stormwater Management Practice Polygons

This layer represents Green Stormwater Infrastructure Stormwater Management Practice types. Integrating Green Stormwater Infrastructure (GSI) into a highly developed area such as Philadelphia requires a decentralized and creative approach to planning and design.

Stormwater Outfalls

This point layer contains all the stormwater outfalls. The Purpose of this data is to describe the asset both locationally and via its attributes which are extensive for a GIS dataset and which are maintained. This data will serve as a platform for planning, analysis and research at PWD.

Street Centerlines for Vision Zero High Injury Network 2017

This dataset contains a modified version of street centerlines used for spatial analysis to derive the High Injury Network (HIN). This version has been arrived at, using steps described in the methodology for High Injury Network. See the Metadata link for an attached PDF describing the methodology.

Street Centerlines

Used citywide as base layer for many purposes/applications. The street centerline is available for reference purposes only and does not represent exact engineering specifiactions. The Philadelphia Streets Department makes no guarantees as to the accuracy of the layer. Associated tables can be found here: https://www.opendataphilly.org/datasets/street-place-names
https://www.opendataphilly.org/datasets/street-name-alias-list

Street Lane Closure Emergency Utility Network

This layer shows the Philadelphia Gas Works (PGW) Emergency Utility Network (EUN) with Excavation points.

Street Lane Closures

Street lane closures for general public use. This is the master layer depicting the Lane Closures due to permitted road work. This layer shows the type and purpose of working being done, the effective dates of the permits issued, as well the status of the work.

Street Legal Cards

Street Centerline Arcs with link to legal cards, which are a collection of cards containing the official record of the legal description and drawings of city streets.

Street Name Alias List

Table to display street names which have aliased street names associated with them.

Street Nodes

The street nodes layer was developed for use by agencies citywide including PWD, PCPC, Police, BRT, Health, etc.

Street Place Names

A listing of “places” and their corresponding addresses to be used for geocoding.

Street Poles

This layer was developed to aid the Street Lighting Division in planning, referencing, and maintaining the active street poles within the City of Philadelphia. Examples include: providing information regarding group replacement projects and any individual edits, using tables from layer for billing, and aiding cityworks.

StreetSmartPHL

This interactive mapping application displays current/future street closures, trash/recycling days, street sweeping plans, snow plowing info (during a snow event) and paving plans.

Street's Code Violation Notices

A code violation notice is issued from the Street’s department when a person has violated one or more codes in the City of Philadelphia or violated one or more Streets Department rules and regulations. A code violation notice (CVN) is a penalty punishable by a fine up to $300.00.

Addresses have been generalized to the hundred-block level (ie. 1234 Market Street becomes 1200 block of Market Street). Please note that the CVN dataset does not include all CVNs. Some are issued as paper tickets. As of 2018, a reporting system upgrade is underway. Once complete, the City plans to update this information to include all CVNs.

Please note that this is a very large dataset. To see all CVNs, download all datasets for all years.

If you are comfortable with APIs, you can also use the API links to access this data. You can learn more about how to use the API at Carto’s SQL API site and in the Carto guide in the section on making calls to the API.

Streets Composite Layer

The composite layer is an arc layer, consisting of street centerline arcs, city boundary arcs, generalized rail arcs, generalized hydrography arcs. This is a layer used by many departments to create boundaries. Used for viewing and analysis puposes. The composite layer is available for reference purposes only and does not represent exact engineering specifications.

Taking Care of Business (TCB) Clean Corridors Program

Philadelphia Taking Care of Business (PHL TCB) Clean Corridors Program funds community-based nonprofits to sweep sidewalks and remove litter within neighborhood commercial corridors. PHL TCB seeks to 1-Maintain clean commercial districts, 2-Promote the economic success of neighborhood businesses by creating an inviting environment for shoppers, 3-Create work opportunities for Philadelphians, 4-Grow the capacity of local small businesses and organizations that provide cleaning services.

Tobacco-Free School Zones

Tobacco-free school zones included in the tobacco retailing regulations. This part of the regulation prohibits new tobacco retailer permits within 500 feet of any K-12 school property parcel. For more information visit

Related datasets include the Tobacco Retailers Permits and Tobacco Youth Sales Violations.

Tobacco Retailer Density Caps

Tobacco Retailer Density Caps for each planning district included in the tobacco retailing regulations. This part of the regulation prohibits new tobacco retailer permits in capped planning districts. Capped districts refer to districts where there are 1 or more retailer(s) per 1,000 people present using daytime population estimates. For more information visit: Tobacco Retailing.

Visit the OpenDataPhilly Discussion Group

Tobacco Retailer Permits

Retailers apply for a tobacco permit through an online application system, entering name, address, and other relevant business information. These data are cleaned and stored in a database maintained by the Department of Public Health.

Related datasets include the Tobacco Youth Sales Violations and Tobacco-Free School Zones.

Topographic Contours

This dataset is a contour data line segments representing the elevation of features covering the City of Philadelphia, PA, approximately 196 sq miles total. Data is typically collected during the month of April. Data Development: Vector (line) data representing the elevation of natural and artificial features in the project area.

Track Streets

Street segments containing train tracks.

Traffic Calming Devices

Point-based dataset showing the approximate locations where Traffic Calming Devices exist in the street to reduce speeding of motor vehicles. Traffic Calming Devices examples are speed cushions, speed humps, and speed tables. These devices could be made of asphalt or rubber materials.

Traffic Districts

This layer was developed to aid the Traffic Division in planning, organizing, and maintaining traffic flow within the City of Philadelphia. Examples include: the maintenance and placing of stop signs and signals and monitoring street travel direction.

Traffic Preventative Maintenance Districts

This layer was developed to aid the Traffic Division in planning, organizing, and maintaining traffic flow within the City of Philadelphia. Examples include: the maintenance and placing of stop signs and signals and monitoring street travel direction. This polygon layer has an accompanying arc layer. Certain arcs in the arc layer contain data signifying information relating it to the polygon layer. It can tell you if both sides of the arc belong to one of the bounding polygons. All the arcs, including those with no boundary info, have naming attributes for labeling the polygon borders. Contact the Streets GIS unit for public consumption of the corresponding arc layer.

Urban Agriculture Projects

Urban agriculture projects located within Philadelphia Parks and Recreation sites.

US Congressional Districts

Please refer to PA’s open data for the United States Congressional Districts.

Vacant Lot Cleanups

Dates and locations of when lots were cleaned (removing weeds, debris, etc.) through the City of Philadelphia’s Community Life Improvement Program.

Vacant Property Indicators Percentage by Block

Block by block percentages across Philadelphia showing the percentages of properties (buildings and lots) in each block considered likely to be vacant by the city’s Vacant Property Indicators Model.

Vacant Property Indicators

The location of properties across Philadelphia that are likely to be a vacant lot or vacant building based on an assessment of City of Philadelphia administrative datasets.

Vehicle & Pedestrian Investigations

Police investigations of pedestrians and vehicles from the Philadelphia Police Department. Provides details related to the location of the investigation, type of investigation, demographics of the individual investigated, and the actions taken.

Please note that this is a large dataset and therefore CSV and SHP files might give an error when you try to download them. If possible, use the API link below, instead of CSV/SHP formats, to access the data. If you can’t use the API and you have trouble downloading the full CSV or SHP files, we’ve split up the dataset by year. Please be sure to download data for all of the years to see the full dataset. You can learn more about how to use the API at Carto’s SQL API site and in the Carto guide in the section on making calls to the API.

Crashes data

This data set contains crash data for the years 2007-2020 from the Pennsylvania Department of Transportation (Penn DOT). This is a subset of the annual Crash Data compiled and released by Penn DOT for the entire state.

Vending Prohibited Areas

Areas where vending is prohibited in the city of Philadelphia.

Vending Prohibited Streets

Streets where vending is prohibited. Used citywide as base layer for many purposes/applications. The street centerline is available for reference purposes only and does not represent exact engineering specifications. The Philadelphia Streets Department makes no guarantees as to the accuracy of the layer.

Vending Prohibition Exceptions

A layer providing exceptions to the vending prohibition streets layer as indicated by the City of Philadelphia’s legislative process. Features represent streets or intersections whereby the City has made exceptions to certain or all vending restrictions. Specific exception parameters are summarized in the “REMARKS” column and can be found in full detail by accessing specific sections/subsections of the Philadelphia Code.

Vision Zero High Injury Network

This data contains the High Injury Network. It is derived using spatial data analysis of crash data for years 2012-2016 from Pennsylvania Department of Transportation.

Voter Election Registration and Turnout

The current dataset captures voter registration counts and voter ‘turnout’, or the percentage of registered voters who voted in each election, since 2017. The data is aggregated at various levels including the political precinct (division), political ward, and city-wide and shows results for different elections (primary, general, special). Historical releases of this data prior to 2017 were separate datasets, one for voter turnout and one for voter registration.

Water Department Grants Disbursed

Collection Process: This data set reflects the recipients, award amounts, and project sites for grant money disbursed by the Philadelphia Water Department. It includes the Stormwater Management Incentive Program, the Soak It Up! Adoption Program Grant, the Green Acre Retrofit Program, and Business Incentive Program. These grants are funded by the Water Department but managed by separate agencies. Data Purpose: This data can be useful for non-commercial properties looking for assistance to reduce their stormwater bill. Intended Audience: It can also be useful to community organizations interested in serving as stewards of green infrastructure located in their area. And it can be useful to businesses impacted by PWD projects.

Water Inlets

This point layer contains all the wastewater and stormwater inlets in Philadelphia with latitude and longitude coordinates.

Watercourses Designated for Protection

Hydrographic features included in Philadelphia Hydrology Map. This map was officially adopted by City Council as the official map of Philadelphia Watercourses Designated for Protection on September 13th, 2012. The geographic data depicts watercourses within Philadelphia County as they appear on the map and will not be edited or updated. For up-to-date hydrography see the Hydrolographic_Features_Poly layer under Hydrology.

West Philadelphia Promise Zone

Area designated by the U.S. Department of Housing and Urban Development deeming West Philadelphia as a Promise Zone. Click here to learn more about promise zones.

Wire Waste Baskets (Trash Bins)

Non Big Belly waste baskets maintained/collected by the City of Philadelphia.

Women, Infants & Children (WIC) Offices

The Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) .

World Meeting of Families Authorized Vehicle Route

This layer highlights the authorized vehicle routes for the 2015 World Meeting of Families. The routes will be held for public safety vehicles, emergency operations, and other mission critical traffic. Regular traffic will not be permitted on the routes. Check for updates frequently as information is subject to change. For a more detailed description of the event and operations: http://www.phila.gov/informationcenters/pope/.

World Meeting of Families Secure Perimeter

Secure perimeter for the 2015 World Meeting of Families in Philadelphia, PA.

World Meeting of Families Secure Vehicle Perimeter

Secure vehicle perimeter for the 2015 World Meeting of Families in Philadelphia, PA.

World Meeting of Families Traffic Box

Traffic box for the 2015 World Meeting of Families in Philadelphia, PA. The boundaries and bordering streets were released during a press conference at City Hall on August 5th, 2015.

Zip Codes

The purpose of this dataset is to represent the Zip Code areas for the City of Philadelphia. The edges of Zip Codes are slightly modified for logical and cartographic purposes.

Zoning Base Districts

Polygon boundaries of Zoning Base Districts based on existing City zoning\ districts with revised codes applied per enactment of the new Zoning Code of December\ 2011, made effective August 22, 2012. District boundaries are unchanged from the previous\ zoning with the exception of certain CMX2 / CMX2.5 splits.

Zoning Overlays

Boundaries of the City of Philadelphia Zoning Overlay Districts enacted December 15, 2011 and made effective August 22, 2012.

Zoning Steep Slope Protected Area

Boundaries of the City’s Steep Slope Overlay district enacted under Section 14-704(2) of the Zoning Code of December 2011 and made effective August 22, 2012. See code for further details.