ACS Data Users Group

 View Only
  • 1.  Mapping 5 Year Data

    Posted 01-11-2016 03:07 AM
    I’m wondering if there’s a best practice for reporting on/mapping the 5 year data with such wide margins of error, such as a 24.7% poverty rate w/ an MOE of +/-36.2, or even 0% poverty rate w/ an MOE of +/-28. For example, is there an MOE threshold that we could establish as too high to report on (leaving many counties in our map without data). This seems especially tricky when looking at differences between groups – such as difference between white and black poverty rates - when one race/ethnicity has a higher MOE than the other


  • 2.  RE: Mapping 5 Year Data

    Posted 01-11-2016 07:29 AM
    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.


  • 3.  RE: Mapping 5 Year Data

    Posted 01-11-2016 04:24 PM
    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]


  • 4.  RE: Mapping 5 Year Data

    Posted 01-12-2016 05:14 AM
    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.


  • 5.  RE: Mapping 5 Year Data

    Posted 01-13-2016 04:14 AM
    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.


  • 6.  RE: Mapping 5 Year Data

    Posted 01-18-2016 07:10 AM
    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.


  • 7.  RE: Mapping 5 Year Data

    Posted 01-25-2016 08:43 AM
    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