Stand Response Distribution recap

Since it is being discussed today, here is a repost of the map showing response areas of Stand.

Poetry Concat()

In the last post, I talked about reshaping the Stand categories to change it from wide to long data. The next thing I did was to concatenate, or reassemble, the responses. The four questions were divided into up to five sections for categorization. In order to easily browse the responses, I put them back together. I used Excel to simply merge the columns and loaded the resulting file in to mysql. To keep the sections neatly separated, I could have inserted a column between them with a special character or string that would mark the change or be replaced by a space or some other delimiter. I didn't. The result is much more interesting as evidenced from a few selections below. The csv file of the concatenated responses can be downloaded and combined with the one for the categories. Two more tables and you will have the basic database I use for ad hoc queries. Woo-hoo!

On to the poetry concat()....

see above healthier population see #2

walkable downtown mountains

outdoors affordable

downtown weather

future potential lifestyle values

see above no rich tards running it no snow see #2

aquarium fiber optic lines

downtown river bridges boats grass

see #1 plus direct air flight to NOLA see #2

drugs that would take care of crime

recycle not litter carpool

visitor - not sure

clean more well restored buildings

see above see #2

clean drug and gang free

i just did

? plant stuff

historic clean safe religious

traffic traffic traffic traffic traffic

education taxes litter pollution

crime education apathy

see above see #2

Ok, that is just a few combinations of words that I liked and found in a few minutes of scanning the first few hundred responses, found a theme, ran some queries and went with it. Many many more and better ones are in there. More gems to come.

Note: If the main download link doesn't work, try the one just above it to the left.

Chattanooga Stand

The Stand results are up and ready for you to explore. There is a nice intro video to demonstrate the use of the query interface as well. I think the best starting point is at the bottom of the page where you can download the Ochs Center's summary and report of Stand. It presents the Stand results alongside the Center's own SOCCR report, giving more breadth and depth to both, in my opinion. Also available are the raw results in both csv and mysql formats. If you intend to spend some time looking at the results via the web interface, it would be a good idea to at least spend a few minutes with the csv file to familiarize yourself with the structure of the data.

Above is a map showing results by zip code in the Chattanooga MSA. There are dots all over the US as well, but that image doesn't translate well....and honestly this map, in its static form doesn't either. The bar chart below does a better job. It is filtered to show only zip codes with 300 or more responses. I chose 300 as the cut off in order to make the image manageable and readable. While I didn't double check it, I am pretty sure most of the ones in the chart are in the MSA as well.

Stay tuned for more Stand data and info as the exploration continues. There are certainly a lot of great individual responses. I will use the ChattaData Twitter feed for one-off observations and post for more substantial ones. Feel free to share any thoughts and/or observations here as well. Go explore!!