/wilkinsburg_pittsburgh_merger_analysis

A few tools, graphs, and docs for analyzing data and researching the ramifications of an annexation of the Borough of Wilkinsburg by the City of Pittsburgh

Primary LanguageHTMLOtherNOASSERTION

Wilkinsburg and Pittsburgh Annexation/Merger Analysis

Quick links:

This little site contains some documents, graphs, and programs to analyze the proposed Wilkinsburg/Pittsburgh Annexation/Merger.

Share this site with a more speakable URL: j.mp/cd-wilk-pgh-merger or scan this convenient QRcode with your smartphone's Camera app or QRCode reader app to geta link to this page.

QRcode to the link above

What do I do with this information?

I believe that it's important to make informed decisions supported by careful analysis of data. It's on you to decide if the change in taxation is worth it for yourself, but consider also your neighbors.

Tax Calculator

The Tax Calculator shows what your household's income and property taxes would be in three scenarios:

  1. a full annexation of Wilkinsburg and merger of the school districts
  2. an annexation of the borough that does not include merging the school districts
  3. a merger of the school districts but no annexation of the borough

Tax Graphs

The heat map charts the percentage change difference when accounting for earned income taxes and real estate and school district property tax going from Wilkinsburg to Pittsburgh under the proposed annexation.

Three version of the graph are provided:

  1. a scalable version that should look good on all screens and when printed (SVG)
  2. a compressed version that's easy to share on social media (PNG)
  3. a more compressed version that's smaller for email and mobile phones (WEBP)

Walkthrough

The coloration of the graph is kind of like heat: blue means taxes go down, red means taxes go up. The darker the color, the deeper the change. The white line that is approximately diagonal is where there is ultimately no change in taxation.

The graphs are quite simple math but I've chosen the ranges based on some heuristics:

  • The range for property value is based on June 2021 county assessment data from WPRDC for the whole municipality, but residences only.
    • The mean assessed value is around $48,000 in the standard deviation is about $50,000. I chose zero as the starting point for the benefit of renters and a little more than three standard deviations above the mean, approximately $200,000, as the max for that axis.
  • For earned income taxes, I chose $15,000 as approximately full-time minimum wage and $300,000 as a two-income, highly-skilled professional household. I don't know where I can get better data on incomes so if you have a suggestion I'm all ears.
    • Noted on the graphs are the median income and 65% mark according to the US Census Bureau.

It's important to note that renters aren't well represented on the graphs because their property taxes are zero: they do not pay property tax directly. The owner of the property does. Renters can expect to see a net tax increase in the event of a full merger or school district only merger unless property owners lower rent voluntarily commensurate with their lower property tax burden or through an act of borough or city government.

A quick refresher on statistics

The graphs bear some abbreviations of statistical terminology to help explain where in the dataset some real numbers are.

Symbol Term Meaning
1Q First quartile 25% or 1/4 are below this level, 75% or 3/4 are above it
Med Median Approximately 50% are below and above this level, also called second quartile
3Q Third quartile 75% or 3/4 are below this level, 25% or 1/4 are above it
Mean The mathematical average, the sum of the amounts divided by the count of amounts
σ / stddev Standard deviation A measure of variation from the mean; the smaller the stddev, the closer in general the amounts are to the mean
1σ/2σ/3σ First/second/third standard deviation The number of standard deviations away from the mean, see also 68-95-99.7 rule.

Future Work

What I would love to do is somehow scale this or carve out areas on the graph that include various percentages of the Wilkinsburg population. The graphs do indicate the median household income with a vertical line but I don't have any other data about household incomes in order to find where on the map the majority of Wilkinsburg residents are. According to Census Bureau data, approximately 2/3 of Wilkinsburg households are under $50,000 per year. I have a line representing that figure on the graph.

Help Wanted

I could use a GNUplot expert to help me clean up the code and help make the color changes more stark.

I could use someone interested in make a better small static website for this. I'm using GitHub Pages for now and it's adequate but it could be snazzier.

Find a problem? Want to say thanks? Raise an issue.

All code for this mini-site, documents, and graphs are available here.

Quality Assurance

All sources of information should be cited. If you find a fact or figure that isn't cited and it is represented as factual, please raise an issue on the repository.

The figures provided by these materials should be treated as estimates. Some information may grow out of date over time.

I try to act on bug reports quickly. However, as a volunteer, most of my time spent on this is on the weekends and late evenings, so there could be a few days delay before I'm able to address your concerns.

Who Built This?

This information is collected and presented principally by Colin Dean, a long-time resident of Wilkinsburg. There may be other contributors listed on GitHub.

How May I Use This?

Creative Commons License Any graphs, their source code, and associated data analysis code are licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Affero General Public License Any other source code is licensed under the Affero General Public License 3.0, except where noted.