Vote up to Idea Poverty map by age and sex Vote down to Idea Poverty map by age and sex


This idea is active.
Application Showcase »

Poverty map by age and sex

I had already created a thematic map application that gave information about the uncertainty surrounding ACS estimates (move your mouse over the counties). This website generates the map using API data requests. A future expansion will include parsing the variables XML file.


Submitted by 2 years ago

Comments (9)

  1. Moderator

    That's nice! I'll assume it was pretty easy for you to get the data via the API.

    2 years ago
    1. Jan Vink Idea Submitter

      I am using ColdFusion and did it like this:

      cfhttp url=",B17001_003M,B17001_032E,B17001_032M,NAME&for=county:*&in=state:36" result="result">


      cfset JSONarray = result.filecontent.toString('UTF-8')>

      cfset CFresult = DeserializeJSON(JSONarray)>

      which results in a easy to work with array in ColdFusion.

      The four table elements I pull depends on the requested subgroup.

      2 years ago
  2. Jan,

    Nice work! Did you find it easy to work with the geography?

    2 years ago
  3. Jan Vink Idea Submitter

    I think I started with an easy geography and I am very familiar with linking data from different datasets, using geographic identifiers. I did only a quick scan of the available documentation though and noted that it was not clear whether all geographic levels are available for the SF1 data and for the ACS data. Blocks for example are listed and I know there is no ACS data for that, but can I get data for blockgroups and tracts?

    2 years ago
    1. Moderator

      Hi Jan,

      You're correct that blocks are listed in one of the examples. The Decennial SF1 dataset includes block data as the lowest level geography. For the ACS data, block data isn't supported, but both tract and blockgroup data is available. Do you need any help getting that data?

      2 years ago
  4. Howdy Jan,

    I have some experience with the geography linked to the ACS sf1 data, and I believe that block groups and tracts both have data associated with them.

    Glad to see you have made use of the API.


    2 years ago
  5. very nice. are you able to use SAIPE in place of ACS 5 year? the recommended source for poverty x age for county is SAIPE. see,

    2 years ago
    1. Moderator

      Hi CM.

      Since this is the infancy of the API, there are only two datasets being supported, the Decennial SF1 and the 5-year ACS Summary File. I guess that as the API begins to be utilized that additional sources may be added. Hopefully, the SAIPE will be one of those, allowing developers to use the most appropriate / recommended source.

      Thanks for pointing this out.

      2 years ago
  6. Moderator

    Nice work :)

    2 years ago

Vote Activity Show


  1. The idea was posted
    2 years ago

Attachments Show