API Technical Discussions

Population for each of all places within a particular county

Via API queries I have easily obtained all county populations within a state, and all places populations within a state. Is there a way to obtain population for each place in a particular county? The main problem is that I want to know all of the places that are contained in one particular county. A secondary special case issue is the situation where a place (incorporated or CDP) may cross a county boundary... thus making it difficult to determine what percentage of the places area and population is in each county. Do you think this is possible, and do I need to go down to tract and group levels?

Tags

Submitted by

Stage: Active

Feedback Score

1 vote
1 up votes
0 down votes
Idea#49

Idea Details

Vote Activity

  1. Upvoted

Similar Ideas [ 4 ]

Events

  1. The idea was posted

Comments

  1. Comment
    Jan Vink

    In American FactFinder, I would use SUMLEV 155 (County within place) or SUMLEV 070 (Place/Remainder) for Census 2010. Both are not listed in the list of geographies available for the SF1. For the ACS you can use level 070 (state-county-county subdivision-place) and total over the county subdivisions.

  2. Comment
    Ingles_Kevin ( Idea Submitter )

    Jan, thanks for the suggestions. I noticed that SUMLEV 101 for SF1 has all of the required fields, but the API examples for SUMLEV 101 only provides state-county-tract-block. The following 2 queries work.

    get=P0010001,NAME&for=tract:*&in=state:06+county:91

    get=P0010001,NAME&for=block:*&in=state:06+county:91+tract:010000

    These 2 API queries do NOT work.

    get=P0010001,NAME&for=place:*&in=state:06+county:91

    get=P0010001,NAME&for=place:*&in=state:06+county:91+tract:010000

    It would be nice if the API query could capability include SUMLEV 101 place fields. The Census SF1 documentation does include place fields for SUMLEV 101, but I assume the API only has a subset of 101 implemented.

  3. Comment
    Phillip Thomas

    I believe this information is partially incorrect, but is how I understand this situation as it stands.

    Those queries should not work as summary level 101 (as understood by our software) does not include a place field, only State,County,Tract,Block

    Summary level 070 and 155 as Jan suggested could possibly be a better way to obtain this information in a time-saving form.

    If you do indeed have the time and resources you could also use the Tiger Line shape files provided by Census's Geography division to determine what blocks fall into what place. As of this time, I have no knowledge on how to accomplish this fast or easily (someone else here might).

    Comments on this comment

    1. Comment
      Ingles_Kevin ( Idea Submitter )

      Thanks Phillip,

      I was able to pull the data (SUMLEV 155) from FactFinder. I was just hoping to automate with an API query ... especially because I am looking to do the whole country. And I want people to be able to easily update for future data releases.

      Kevin

  4. Comment
    Ingles_Kevin ( Idea Submitter )

    Of course, I always make it harder on myself when I try to provide an Easy button for the user.

Add your comment