Jonathan Schroeder NGIS Time Series Tables

Transcript

1. Census Time Series Tables
   from NHGIS
   An Overview for Cartographers
   Jonathan Schroeder
   

   View Slide

2. NHGIS
   Census tables and
   GIS boundary files,
   1790 to the present
   

   View Slide

3. View Slide

4. View Slide

5. View Slide

6. View Slide

7. View Slide

8. Nominal integration
   

   View Slide

9. Nominal integration
   

   View Slide

10. Geographic standardization
    

    View Slide

11. 2000 block
    population:
    1,624
    

    View Slide

12. View Slide

13. 27%
    73%
    Land area
    

    View Slide

14. How often is uncertainty large?
    2010 census areas N %
    Block Groups 33,361 15.3
    Tracts 8,542 11.7
    Range > 10% of max
    

    View Slide

15. How often is uncertainty large?
    2010 census areas N % N %
    Block Groups 33,361 15.3 9,955 4.6
    Tracts 8,542 11.7 1,171 1.6
    Range > 10% of max Range > 50% of max
    

    View Slide

16. How often is uncertainty large?
    2010 census areas N % N %
    Block Groups 33,361 15.3 9,955 4.6
    Tracts 8,542 11.7 1,171 1.6
    County Subdivisions 6,718 18.8 789 2.2
    ZCTAs 13,448 40.8 2,134 6.5
    Places 11,621 39.7 3,341 11.4
    Urban Areas 1,717 48.1 78 2.2
    Counties 5 0.2 0 0.0
    CBSAs 0 0.0 0 0.0
    Cong. Dists. (113th) 0 0.0 0 0.0
    States 0 0.0 0 0.0
    Range > 10% of max Range > 50% of max
    

    View Slide

17. 27%
    73%
    Land area
    

    View Slide

18. 44%
    56%
    Developed land
    NLCD 2001
    5% impervious
    

    View Slide

19. 46%
    54%
    Land near roads
    300 ft buffer around
    2010 TIGER/Line
    residential roads
    

    View Slide

20. 44%
    56%
    Developed land
    near roads
    

    View Slide

21. 40.6%
    59.4%
    2010 block densities
    near roads
    “Refined TDW”
    

    View Slide

22. View Slide

23. Hybrid model
     Weighted RMSE of estimated proportions
    when disaggregating from 2000 block pairs…
     6% lower than refined TDW
     (2010 block densities near roads)
     25% lower than binary dasymetric model
     (2001 developed land near roads)
     34% lower than AW
     (all land)
    

    View Slide

24. Geographically standardized time series
     65 tables: 2000 & 2010 data for 2010 census units
     Geographic levels:
     states, counties, tracts, block groups,
    county subdivisions, places, congressional districts,
    CBSAs, urban areas , ZCTAs
     Short-form counts only
    Next up…
    1. 1990 block-based counts for 2010 areas
    2. 2000 long-form counts for 2012 & 2017 areas
    3. 1990 “ “
    4. 1980 …
    

    View Slide

25. Nominally integrated time series
     233 tables
     Geographic levels:
     nation, regions, divisions, states, counties, tracts,
    county subdivisions, places
     Year ranges…
     Mostly within 1970 to 2010 or 2008-2012
     Total Population back to 1790 &
    Persons by Sex back to 1820
    

    View Slide

26. #
    Nom.
    #
    Std. Tabulation Type
    1 1 Total Households
    1 1 Households by Household Type
    2 2
    Households by Household Type by Household
    Size
    1 1 Total Families
    2 1 Persons in Families
    2 1
    Families by Family Type by Presence and Age
    of Own Children
    10 1
    Persons by Household Type by Relationship to
    Householder
    11 4
    Persons by Household Type by Relationship to
    Householder by Age
    1 1 Total Housing Units
    2 0 Housing Units by Urban/Rural Status
    6 3 Housing Units by Occupancy/Vacancy/Tenure
    2 1 Persons by Housing Tenure
    6 2
    Occupied Housing Units (by Tenure) by Race of
    Householder
    3 0
    Occupied Housing Units (by Tenure) by
    Household Size
    #
    Nom.
    #
    Std. Tabulation Type
    3 1 Total Persons (1790-2012)
    2 0 Persons by Urban/Rural Status
    2 1 Persons by Sex (1820-2012)
    4 2 Persons by Age
    1 0 Median Age of Persons
    4 2 Persons by Sex by Age
    1 0 Median Age of Persons by Sex
    10 3 Persons by Race
    4 1 Persons by Race by Sex
    28 7 Persons by Race by Age
    13 7 Persons by Race by Sex by Age
    4 1 Persons by Hispanic or Latino Origin
    2 1
    Persons by Hispanic or Latino Origin by Sex by
    Age
    4 3 Persons by Hispanic or Latino Origin by Race
    6 4
    Persons by Household, Family and Group
    Quarters Type
    5 3
    Persons by Household and Group Quarters
    Type by Sex
    11 7
    Persons by Household and Group Quarters
    Type by Age
    9 3
    Persons by Household and Group Quarters
    Type by Sex by Age
    Tabulation types— full-count basis
    

    View Slide

27. #
    Tables Tabulation Type
    4 Households by Income in Previous Year
    1 Median Household Income in Previous Year
    4 Families by Income in Previous Year
    1 Median Family Income in Previous Year
    1 Per Capita Income in Previous Year
    1 Persons for Whom Poverty Status is Determined
    2 Persons by Poverty Status in Previous Year
    3
    Persons by Ratio of Income to Poverty Level in
    Previous Year
    6 Persons by Poverty Status in Previous Year by Age
    #
    Tables Tabulation Type
    7 Persons by Marital Status by Sex (by Age)
    1 Persons by Nativity
    13 Persons by Nativity by Place of Birth
    5 Persons by Educational Attainment
    7 Persons by Educational Attainment by Sex (by Age)
    5
    Persons by Labor Force, Employment and Armed
    Forces Status (by Age)
    6
    Persons by Labor Force, Employment and Armed
    Forces Status by Sex (by Age)
    3 Workers by Means of Transportation to Work
    Tabulation tables — sample basis
    298 tables
    49 tabulation types
    ~3,800 time series
    ~29,000 links to source variables
    

    View Slide

28. View Slide

29. Counties
    

    View Slide

30. Census Tracts
    

    View Slide

31. Block Groups
    

    View Slide

32. View Slide

33. Dots indicate upper & lower bounds
    

    View Slide

34. View Slide

35. View Slide

36. Population Change in
    Urbanized Areas
    2000–2010
    

    View Slide

37. Detroit Area
    Poverty Rates
    by County Subdivision
    1970
    

    View Slide

38. Detroit Area
    Poverty Rates
    by County Subdivision
    1980
    

    View Slide

39. Detroit Area
    Poverty Rates
    by County Subdivision
    1990
    

    View Slide

40. Detroit Area
    Poverty Rates
    by County Subdivision
    2000
    

    View Slide

41. Detroit Area
    Poverty Rates
    by County Subdivision
    2008-2012
    

    View Slide

42. Detroit Area
    Poverty Rates
    by County Subdivision
    1970
    

    View Slide

43. National Science Foundation
    NIH – Eunice Kennedy Shriver National Institute of
    Child Health and Human Development
    NHGIS team:
    David Van Riper
    Kevin Horne
    Jason Borah
    Jacob Wellington
    …and our many research assistants!
    

    View Slide

44. Geolytics NCDB US2010 LTDB NHGIS Standardized TSTs
    Tracts with codes
    for larger areas
    Tracts with codes
    for larger areas
    10 levels
    1970–2010 1970–2010 Start with 2000-2010
    Around 1,000
    variables per year,
    semi-aligned
    categories
    About 83 variables,
    aligned categories
    1,000’s of variables in
    100’s of tables,
    aligned categories,
    selected by year range
    No error bounds No error bounds Include lower and upper
    bounds
    2000 block data:
    Area-weighted (?)
    2000 block data:
    Area-weighted*
    2000 block data:
    Dasymetrically refined,
    2010-density-weighted
    

    View Slide