Population Density / Household Income Updates

[jaime-mckeown]

• 2020 ACS 5-year data will not be available until March 2022
• I looked up the last data I processed, and it was the 2018 ACS 5-year data surprisingly.
• Downloaded the 2019 ACS 5-year data to process to use for now.

[jaime-mckeown]

• Processed Population Density table and created new layer

[jaime-mckeown]

Household Income

• Processed table and created new polygon layer

Calculating Median HH Income Merge field

• Forgot where we got the Austin Median HH Income data from, checked with Andres and he reminded me that it came from ACS 5-year data as well. Found the right table on the website, and downloaded the table.
• The median HH income was a more difficult number to decide the rankings this year. Broke the numbers down and sent to Renee/Andres so we could come up with best break down for this year
• Austin median HH Income: 72k
• greater than median: 75k and above
• 0% - 25% below: 50k to 75k
• 25% - 40% below: 40k to 50k
• 40% - 100% below: 40k and below
• We had to come up with the best option based on the ranges that are given by the Census Bureau data (5k increments up to 50k, then 50k to 60k, then 25k increments up to 200k)
• Changed the Median HH Income Merge field to calculate the percentages instead of actual numbers so the script doesn't have to be updated each year
• Updated the PHB Criteria Ranking ASMP script to calculate rankings based on the percentages instead of the actual numbers.
• Finished by creating the merged polygon layer

[jaime-mckeown]

Updated the Data Driven PHB Ranking Gitbook document for all the changes that were made to the Census Bureau section of the document under the data collection / processing section.

[jaime-mckeown]

• Download GitHub Desktop on new computer
• Get it connected to atd-geospatial
• Push updates on PHB Criteria Ranking ASMP script to master.