Mapping 5 Year Data

Not sure if you're using ESRI products for mapping, but maybe their article on Margin of Error can help: www.esri.com/.../understanding-margin-error

Also, I attended an Association of American Geographers annual conference several years back where David Wong of George Mason University presented a ArcGIS extension he created that overlays a cross-hatching pattern on top of your data values, based upon the margin of error: http://gesg.gmu.edu/census/ The "documentation" PDF on their download page is worth reading.

Just reiterating Patrick's earlier post ... a paper by David Wong and Min Sun (2013) titled "Handling Data Quality Information of Survey Data in GIS: A Case of Using the ACS data" is available at:

spatialdemography.org/.../2.-Wong-and-Sun.pdf

[Updated on 1/11/2016 9:23 PM]

Thanks, all!

I'm reviewing the materials you passed along.

Sarah, I am interested in how you marked the data as excessive, and your examination of race/ethnicity in general. I was hoping to compare differences in poverty levels among race/ethnicity, but that's an even more difficult challenge, as MOEs vary dramtically among groups.

Hello, the way I have approached this problem on a census tract level in a county is to group geographies by ones that have no statistically significant differences within the group. I then end up with a number of groupings where I can say these census tracts (geographies) all have the highest (or lowest, etc) % of the population in poverty in the county. Unfortunately, it take a fair bit of calculation to get there, but I feel allows easier interpretation of the data.

Sorry for the late entry in this discussion. I would add a caution about the Esri approach mentioned above which is based on the Coefficient of Variation (CV). CV's make sense when working with metrics like median income where it is important to normalize the estimate. However, CV's can be misleading when the estimate is near zero. For example if the estimate of the percent below poverty is 0% with an MOE of +/- 5%, the CV is infinitely large. The Esri approach would classify this as "Low Reliability" even though we can be quite confident that the percent below poverty is less than 5%.

In fact, I would not recommend using CVs with percentages at all. There is no need to normalize percentages - they are already normalized. I would just use the MOE directly to assess data reliability.

Hi all,

Thanks again for feedback! Here's the final product. Some of the methodology can be found in the feedback. Happy to answer questions:

www.ctvoices.org/.../mapping-disparities-race-and-place