Urban planning community

+ Reply to thread
Results 1 to 8 of 8

Thread: NSP grant technical issues

  1. #1
    Cyburbian WSU MUP Student's avatar
    Registered
    Mar 2007
    Location
    Lowering the PCI in the Hills
    Posts
    5,741

    NSP grant technical issues

    Mods - Feel free to move this if you think it should be elsewhere -I considered in the tech forum but thought more eyes that might be familiar with NSP would see it here



    Somebody in our Community & Home Improvement department came to us for a map with varying shades representing what type of NSP grants particular tracts or block groups might qualify for. They provided us with a list of FIPS codes and the city, village, or township that each individual FIPS code is physically located in. The problem is that these FIPS codes all have 23 characters and we have never seen them this long.

    Here is one as an example: 261256204062020121500U3 This particular geography is somewhere within the Village of Oxford, MI for reference.

    It's about the last 11 characters or so that we are trying to figure out what it represents. I know that the U3 has to do with whether or not the geography is urban or not but most of the rest of that last part is a mystery.

    We want to make sure that the map we provide has the correct locations shaded. Any idea what these extra characters are? Could it be a particular block or block face? Is the entire string maybe not a FIPS code at all but possibly some other federal designator like a OMB code? The HUD and Census sites are not much help.
    "Where free unions and collective bargaining are forbidden, freedom is lost." - 1980 Republican presidential candidate Ronald Reagan

  2. #2
    Cyburbian Plus
    Registered
    Jun 2003
    Location
    De Noc
    Posts
    18,032
    U3
    Populated (Community) Place (except those associated with facilities). Alternate official common name for an incorporated or census designated place.
    http://geonames.usgs.gov/pls/gnispub...66702826381129
    Oddball
    Why don't you knock it off with them negative waves?
    Why don't you dig how beautiful it is out here?
    Why don't you say something righteous and hopeful for a change?
    From Kelly's Heroes (1970)


    Are you sure you're not hurt ?
    No. Just some parts wake up faster than others.
    Broke parts take a little longer, though.
    From Electric Horseman (1979)

  3. #3
    Cyburbian JimPlans's avatar
    Registered
    Aug 2006
    Location
    Gone to a better place (in my mind)
    Posts
    407
    26125 - Oakland County

    62040 - Oxford charter township (MCD)

    62020 - Oxford City (Place)

    121500 - Census Tract

    U3 - Populated Place Code

    So, as I'm reading this, the census tract is 26125121500. The other numbers are just there for the sake of completeness (confusion?).

  4. #4
    Cyburbian Plus
    Registered
    Jun 2003
    Location
    De Noc
    Posts
    18,032
    No extra numbers if you ask me

    26 125 62040 62020 121500

    State 26
    County 125
    County Subdivision 62040
    Place 62020
    Census Tract 121500

    American Factfinder, sf 1, detailed tables, under options geographic identifiers
    Oddball
    Why don't you knock it off with them negative waves?
    Why don't you dig how beautiful it is out here?
    Why don't you say something righteous and hopeful for a change?
    From Kelly's Heroes (1970)


    Are you sure you're not hurt ?
    No. Just some parts wake up faster than others.
    Broke parts take a little longer, though.
    From Electric Horseman (1979)

  5. #5
    Cyburbian WSU MUP Student's avatar
    Registered
    Mar 2007
    Location
    Lowering the PCI in the Hills
    Posts
    5,741
    Quote Originally posted by JimPlans View post
    So, as I'm reading this, the census tract is 26125121500. The other numbers are just there for the sake of completeness (confusion?).
    I believe you are correct. Thanks for the help! I knew the numbers for the tract were in there somewhere, that order and extra characters were throwing me off though.

    Thanks again.
    "Where free unions and collective bargaining are forbidden, freedom is lost." - 1980 Republican presidential candidate Ronald Reagan

  6. #6
    Cyburbian DetroitPlanner's avatar
    Registered
    Mar 2004
    Location
    Where the weak are killed and eaten.
    Posts
    6,247
    remarkable! everyone's level of geography geekdom has me impressed!
    We hope for better things; it will arise from the ashes - Fr Gabriel Richard 1805

  7. #7
    Cyburbian Plus
    Registered
    Jun 2003
    Location
    De Noc
    Posts
    18,032
    Quote Originally posted by JNA View post
    No extra numbers if you ask me
    Census Tract 121500
    Census tracts are identified by a four-digit basic number and may have a two-digit numeric suffix; or example, 6059.02. The decimal point separating the four-digit basic tract number from the two-digit suffix is shown in the printed reports and on census maps. In computer-readable files, the decimal point is implied. Many census tracts do not have a suffix; in such cases, the suffix field is either left blank or is zero-filled.
    http://www.census.gov/geo/www/cob/tr_metadata.html
    Oddball
    Why don't you knock it off with them negative waves?
    Why don't you dig how beautiful it is out here?
    Why don't you say something righteous and hopeful for a change?
    From Kelly's Heroes (1970)


    Are you sure you're not hurt ?
    No. Just some parts wake up faster than others.
    Broke parts take a little longer, though.
    From Electric Horseman (1979)

  8. #8
    Cyburbian
    Registered
    Mar 2006
    Location
    Somewhere Out There
    Posts
    48
    The U3 at the end means that it has been designated by the census as "urban" and it is block group 3.

    State 1‐2 State FIPS Code
    County 3‐5 Census 2000 County FIPS code
    County Subdivision 6‐10 Census 2000 Census County Subdivision Code
    Place 11‐15 Census 2000 Census Place Code
    Tract 12‐21 Census 2000 Census Tract Code
    Urban/Rural 22 Census 2000 Designation as Urban or Rural (U/R)
    Block Group 23 Census 2000 Block Group Code


    This is from the HUD data dictionary for NSP3.

+ Reply to thread

More at Cyburbia

  1. Replies: 5
    Last post: 26 Feb 2007, 12:10 PM
  2. Technical Question About Outlook
    Friday Afternoon Club
    Replies: 6
    Last post: 07 Jul 2004, 4:06 PM
  3. technical skills
    Friday Afternoon Club
    Replies: 3
    Last post: 06 Sep 2001, 12:14 PM
  4. Replies: 3
    Last post: 18 Jun 2001, 6:06 PM