Monthly Archives: November 2015

Neighborhood stats for H-1


The smallest geographic area for the census is called "block groups."

There are three block groups within the overall census Tract 67. One of the block groups is outside our neighborhood, mostly South of Magnolia.

This leaves two block groups we’re interested in.

From this page, there’s a YouTube video on how to get data for a block group:

The census created a data access tool using Microsoft Excel.

I tried to get the block group data using the tool, but I don’t think the tool works with the Mac version of Microsoft Excel.

I can try a Windows computer at the UT library, however:

I’m sharing it now in case anyone with a Windows computer / Windows version of Excel wants to try.

I have the boundary files for the block groups already, I just don’t have the table data with all the interesting data points that Lynne mentions.

I have a strategy in mind for collecting data about specific parcels within the proposed H1 extension (whatever that may be); the strategy is outlined in this blog post.

What I need to make it work are the specific blocks / areas proposed for the H1 extension, so that I can get the specific addresses of potentially included properties.


On Sat, Nov 7, 2015 at 1:57 PM, Lynne Sullivan <hiwarch> wrote:

Hi, All,

Some of us talked informally about getting some statistics for the neighborhood regarding rental vs owner-occupied properties. The thought was to get an idea of whether the property owners in an expanded H-1 would be mostly landlords or homeowners. I realized that we could get estimates of these data from the 2010 census (the most recent one taken). The data are online.

I was able to get stats for Knoxville Census Tract 67, which includes all of Parkridge and a narrow strip on the south side of Magnolia to McCalla. I think we could get block coverage which would exclude the area across Magnolia. Tanner, maybe you can figure out how to do that. I have found how to do so previously, but had no luck today.

In any case, the stats for Tract 67 are likely fairly representative of Parkridge. Here are the numbers:

Total housing 1735 units
Occupied 1354
Renter occupied 899
# of tenants 1879
Owner occupied 455
# of residents in owner-occupied 1027
Vacant properties 381

So, there likely are twice as many rentals in our neighborhood as there are owner-occupied homes. This means that it is mostly landlords who would be required to comply with H-1 designation. We have not heard much from that group of property owners at the H-1 meetings even though they have been contacted.

Just FYI, other types of stats about the neighborhood can be pulled from the census, including education, income, age demographics, and race.




Dr. Andre,

I had a phone conversation with a sales guy, Mark Evans.

He suggested we could "get by" with Tableau Public, which is free.

He described it as a "YouTube" for data visualizations created with Tableau.

Importantly, the Tableau Public site allows us to embed our data visualization onto the actual IBSS website using a piece of javascript code.

Downsides of Tableau Public:

You can’t "save" a visualization except at the instant you publish it – that means you get your visualization right in one session of working with the data, or you do it over.

On the bright side, you can delete things you create/upload.

I did read on Quora that Tableau Public has a limitation on the number of rows.

I don’t know what the limit is, but I can say that our NIR predict dataset does not exceed the cap:

There are 1,271 rows of data in the Tableau Public version of the NIR-predict dataset, as imported by Tableau Public Desktop

That matches the number of rows in the raw data.

There’s good information here:

For future reference on pricing…

Evans’ recommendation is to get one copy of Tableau Desktop Personal.

There is education pricing for that specific product at $750.

$500 of the license is a one time, perpetual use license.

$150 is an annual "maintenance" charge I was told you don’t actually need to get, you’d just stop getting updates for the software.

Next Steps

  1. I’ve asked SREF if they can modify the plone portal to accept the javascript embed that Tableau provides
  2. Once it’s online, it may be helpful to meet up again to have you go over the available visualizations and pick out the ones that potentially offer the most value.



Tanner Jessel

Information Design Specialist

Center for Renewable Carbon

2621 Jacob Drive,

Knoxville, TN 37996-4505

865-946-1162 Office | |


H1 Zoning Boundaries

Hi Jennifer,

Congrats on VP post. I voted for you. I think it’s a good fit.

Just a quick message while I’m thinking about it, I need to get the details on the houses / parcels / blocks that might be up for consideration.

I took some notes at the meeting but doubt I got everything:

  • Glenwood from the freeway to Olive, Washington to Chestnut
  • Jefferson to Cherry
  • Woodbine to Cherry
  • East Fifth to Cherry
  • John Craig potentially opting in
  • East Knox Library is opposite him.
  • Catch part of Magnolia.

If you could add to that or send me a scribble or whatever.

If you want in on some "magic" this is one site I use, you might be able to draw on the map and share it with me if you have time.

Another option is to take pen to paper and either get together or scan / e-mail.

If you happen to be able to get the street addresses that’d be helpful for another aspect of collecting data I’m working on that I outlined here: