Category Archives: Urban

Census Block, Block Group & Census Tract GeoDemographics

Census tracts, block groups and blocks are the important small area statistical geographic areas for which data from Census 2010 are tabulated. Data for census tracts and block groups are also tabulated annually from the American Community Survey. For example. in December 2018, we will have new “richer demographics” annual estimates centric to each year 2008 through 2015 for Census 2010 tracts and block groups … data such as educational attainment, language spoken, housing and household characteristics,  income characteristics and employment and other demographic-economic attributes.

Largest Population New York City (NYC) Census Blocks
The following graphic shows the NYC Census 2010 census block having the largest Census 2010 population that is not a group quarters population block. The Lincoln Center census block shown in the graphic (red boundary) has 4,067 population and 2,922 housing units.

– click graphic for larger view; view developed using CV XE GIS

This block (36 061 015500 6000) occupies 0.033 square miles. It has a population density of 122,333 (population per square mile). The NYC block with the largest population is on Rikers Island and has a group quarters population of 8,634 and 0 housing units. For Census 2010, there were 350,169 census blocks covering the state of New York; 13,356 census blocks were water blocks. For the State of New York, as of Census 2010 the average census block population was 55 (57 excluding water blocks).

Census 2010 and Census 2020
These geographies have generally stable geographic areas and codes from one decennial census (e.g., Census 2010) to the next (e.g., Census 2020). Many of these areas will change in terms of code and area for Census 2020, though the geographic changes will typically be small or not at all.

Census 2020 block, block group and tract codes and geometry will be available in late 2020. Initial block level demographics will be available in March 2021.

Census 2010 & Current GeoDemographics
These areas cover the U.S. from wall-to-wall and generally non-changing in terms of boundary and geographic code (geocode) until Census 2020. This section provides a summary of new Web pages with more detail about each of these geographies:
census tracts and tract codes .. 73,056 areas
census block groups and block group codes .. 217,740 areas
census blocks and block codes .. 11,078,297 areas

Each of these pages provides an interactive table to view tallies of Census 2010 for each of these small area geographies.

Combining Address Data with Small Area Geography
The address of the Office of the California Secretary of State, located at 1500 11th St, Sacramento, CA 95814, was geocoded using the APIGeocoder and converted into a shapefile for Geographic Information System applications.  The location is shown as a red marker in the map views shown below, illustrating each type of small area geography: tracts. block groups and blocks.

Census Tracts
Tracts are labeled with green tract codes. Address 1500 11th St, Sacramento, CA 95814 is shown by red marker.  The address is in tract 06067001101.

View created using CV XE GIS.

Block Groups
Block groups are labeled with red block group codes.  Tract 06067001101 is comprised of block groups: 060670011011 and 060670011012.  See pointer in map view; the block group within tract boundary.

View created using CV XE GIS.

Zoom-in to Census Block
Blocks are labeled with yellow block codes. The address is located in block 060670011011085.

View created using CV XE GIS.

Further Zoom-in Showing Streets
Streets are labeled with street names. Identify tool is used to show mini-profile for 1500 block of 11th Street.

View created using CV XE GIS.

Is the tract code 11.01 or 001101?
Both. Census tracts within a county are identified by a 4-digit basic code between 0001 and 9999, and may have a 2-digit suffix ranging from .01 to .98; for example, 6059.02. The decimal point separating the 4-digit basic tract code from the 2-digit suffix is shown in Census Bureau printed reports and maps. For geo-referencing, the decimal point is implied and does not appear; the 6-character tract code with lead zeroes is used — a character string with no blanks and all numbers.

Accessing and Using these Geographies & Related Demographics
There are several ways these geographies can be used.
• The geocodes are the “handles” to access demographic-economic statistical data.
• The geographies may be visually, geospatially, related as shapefiles.
.. the Census Bureau makes these shapefiles available for use in user appications.
.. the shapefiles typically do not include demographic-economic data.

Access Census 2010 Census Block (and Block Group/Tract) data:
• P.L. 94-171 Redistricting Data — http://proximityone.com/cen2010_pl94171.htm
• Summary File 1 — http://proximityone.com/cen2010_sf1.htm

Access Census Block Group and Tract richer demographics:
• 2016 American Community Survey (ACS) 5-year estimates
  — http://proximityone.com/acs1216.htm
• Access annual counterparts to above section
• Census blocks — http://proximityone.com/cenblk.htm
• Census block groups — http://proximityone.com/blockgroups.htm
• Census tracts — http://proximityone.com/tracts.htm

Alternatively use the Census Bureau APIs or CV XE GIS APIGateway.

Data Analytics Web Sessions
.. is my area urban, rural or …
.. how do census blocks relate to congressional district? redistricting?
.. how can I map census block demographics?
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to GeoStatistical Data Analytics Learning. We review current topical issues and data — and how you can access/use tools/data to meet your needs/interests.

About the Author
Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Examining America’s 10 Largest Urban Areas

.. why it matters .. among other reasons, these 10 areas have 24% of the total U.S. population. Three have increased by more than 20% in the past 5 years.

More than 80-percent of America’s population is urban, but far more than 80-percent of America’s geography is rural. Census 2010 shows that America’s urban population increased by 12.1 percent from 2000 to 2010, compared to the national overall growth rate of 9.7 percent. Urban areas now account for 80.7 percent of the U.S. population, compared to 79.0 percent in 2000.

America’s 10 Largest Urbanized Areas
The following table shows the largest 10 Urbanized Areas (UAs) based on the American Community Survey 2011 and 2016 1-year estimates (ACS2016) and change over the period. UAs are sorted in descending order based on the 2016 population estimate. Note that Atlanta, Dallas and Houston moved up in rank.

Geodemographic relationships vary widely between the urbanized areas (UAs). Some, such as Miami, comprise most or all of the urban area within the corresponding metropolitan statistical area. Others, such as Philadelphia, are nested within a mix of adjacent urban areas interspersed with rural areas. Among other things, these different geodemographic structures reflect how planning, needs assessment and market development vary widely from associated metro-to-metro. These data show the importance and need to consider the urban/rural population distribution even in the largest metros.

Visual Analysis — Dallas Urbanized Area
The urbanized area (UA) of the corresponding metropolitan statistical area (MSA) generally occupies less than half of the MSA.
See the Dallas-Fort Worth-Arlington, TX MSA Situation and Outlook Report

… View developed using CV XE GIS.

Map Views for Each of the Largest 10 Urbanized Areas
Maps for each of the 10 largest UAs are shown at
http://proximityone.com/urbanareas_2016.htm.

Each graphic shows the designated urbanized area in a darker salmon color fill pattern, associated metropolitan statistical area with bold brown boundary, and other urban areas with a lighter shade of salmon fill color, counties black boundaries and yellow labels. The ACS 2016 UA population is shown as a white label under the UA name. The ACS 2016 estimates are the most recent data available and will update with 2017 estimates in late 2018.

More About Analyzing Urban/Rural Patterns and Characteristics
See the related section on America’s urban/rural population and geography:
http://proximityone.com/urbanpopulation.htm.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on L

Creating Custom Demographic Datasets with API Tools

.. develop national scale spreadsheet files with virtually no learning time .. easy-to-use API operations to create national scope demographic-economic datasets based on American Community Survey 2016 1-year estimates .. custom subject matter selections. See more detail in related web sections ACS2016 and ACS2016_API.

Benefits and utility … how to acquire a spreadsheet showing the population of all cities with population estimates based on the ACS 2016 1-year data? … or, housing units, median household income, median housing value, etc.? Variations of this need frequently arise — what is the list of largest California counties sorted on total population: What are the 25 metros having the highest median household income? Which 10 congressional districts have the highest poverty incidence? Which urban areas have the highest educational attainment?

Use simple API calls described below to get answers to these types of questions — and more.  Create files that can be used for recurring applications. An example …

Urban Areas with 2016 Population 65,000+ Population
… results from using the API downloaded data … the following graphic shows urban areas with 65,000 or more 2016 population; zoom-in to Texas. The full national scope GIS project is available as described below; examine U.S. or any region. The file used to develop this view was created using the results of the API call reviewed below (requires integration of those data into the urban areas shapefile). Click graphic for larger view; expand browser window. Larger view shows urban areas labeled with name and mini profile for Dallas UA showing all subject matter items downloaded (via API) as described below.

… View developed using CV XE GIS.
… See more about Urban Population & Urban Areas.

Access ACS 2016 1-Year Data Using API Tools
Here are the API links … use these API calls to access/download selected items for selected geographies. See more about using API tools. Click a link and receive a return page with CSV-like structured data. See usage notes below. As these are ACS 2016 1 year estimates; geographies are only available for areas 65,000+ population.
Click a link:
• All U.S. cities/places
• All U.S. counties
• All U.S. CBSAs
• All U.S. Urban Areas
• All 115th Congressional Districts
• All U.S. states
• U.S. only

The following data retrieval operations are by state. These are examples using Arizona (FIPS state code 04).
• All [within state] Elementary School Districts
• All [within state] Secondary School Districts
• All [within state] Unified School Districts

API Call Returned Data Usage Notes
Clicking the All U.S. cities/places link above generates a new page with content very much like a CSV file. Try it .. click an above link.

See the related ACS2016_API web section for more details.

Items Retrieved in the API Calls
The sample header record above shows the subject matter item listed at the left in the following set of items. Modify API call and use other subject matter items. See full array of subject matter – xlsx file.
.. B01003_001E – Total population
Age
.. B01001_011E — Male: 25 to 29 years (illustrating age cohort access)
.. B01001_035E — Female: 25 to 29 years (illustrating age cohort access)
Race/Origin
.. B02001_002E – White alone
.. B02001_003E – Black or African American alone
.. B02001_004E – American Indian and Alaska Native alone
.. B02001_005E – Asian alone
.. B02001_006E – Native Hawaiian and Other Pacific Islander alone
.. B02001_007E – Some other race alone
.. B02001_008E – Two or more races
.. B03001_003E – Hispanic (of any race)
Income
.. B19013_001E – Median household income ($)
.. B19113_001E – Median family income ($)
Housing & Households
.. B25001_001E – Total housing units
.. B25002_002E – Occupied housing units (households)
.. B19001_017E — Households with household income $200,000 or more
.. B25003_002E — Owner Occupied housing units
.. B25075_025E — Housing units value $1,000,000 to $1,499,999
.. B25075_026E — Housing units with value $1,500,000 to $1,999,999
.. B25075_027E — Housing units with value $2,000,000 or more
.. B25002_003E – Vacant housing units
.. B25077_001E – Median housing value ($) – owner occupied units
.. B25064_001E – Median gross rent ($) – renter occupied units

The rightmost fields/columns in the rows/records contain the area name and geographic codes.

Using API Tools for Data Analytics
Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on L

Creating Custom School District Maps

…tools & data to map & geospatially analyze school districts. Ready-to-use state-by-state GIS projects may be downloaded enabling you to view and create custom maps almost instantly. Benefit from the power of using GIS software to perform tasks not available on Web-based mapping options. Use the latest school district and related shapefiles. See more information about using these resources in this related Web section.

Federal Revenue per Student by School District
Create views similar to the one shown below. Optionally combine layers as illstrated here by showing four Texas metros.

.. view developed with CV XE GIS and related GIS project.

Extending Reference and Analytical Possibilities

Texas by School District
Examine reference maps at the state, regional or local level. Optionally combine with roads/streets and other layers.

Patterns of Economic Prosperity by School District
Select from many ready-to-use demographic-economic subject matter items to create custom pattern views.

Drill-down — Houston Metro Area by School District
Zoom-in to a school district of interest. Set attributes of district as shown here.

County/School District
Visually examine the boundaries or school districts and counties. This view shows Harris County, TX area; select a county of interest.

Drill-down to Street Level
Add road/street and other layers. Drill-down within Fort Bend ISD, Houston metro, showing general earth surface features with streets layers. Mouse used to click on street (see pointer) and display mini-profile of street segment attributes.

Use for Analysis, Reference or in the Classroom
Schools and teachers: consider using these resources for classroom use. Familiarize students about how GIS resources can be used with a minimum of learning time and no cost. Enable students to use their own geography and adapt that learning to more general geography. See related Mapping Statistical Data ready-to-use GIS projects.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Housing Value Appreciation by 3-Digit ZIP Code: 2015Q3-2016Q3

.. tools, data and methods to examine housing value appreciation from 2015Q3 to 2016Q3 by 3-digit ZIP code based on the Housing Price Index (HPI).  How is the housing value changing in areas of interest?  How does housing value appreciation compare among a set of ZIP codes? Which ZIP code areas have the highest and lowest housing value appreciation in a state, region custom defined areas of interest? The HPI is calculated in part using home sales price information from Fannie Mae- and Freddie Mac-acquired mortgages. The U.S. all transactions HPI rose 5.6 percent from the 3rd quarter of 2015 to the 3rd quarter of 2016. Rank, compare, evaluate quarterly or annual housing value change for the approximate 900 3-digit ZIP code areas using the interactive table.

3-Digit ZIP Codes with Highest Housing Value Appreciation
Derived from the interactive table below this table shows the ten 3-digit ZIP codes having the highest housing value appreciation over the year 2015Q3-2016Q3. The areas are ranked on percent HPI change (rightmost column).

Gaining Insights in Housing Prices, Conditions & Markets
.. data, tools and methods to assess characteristics, patterns & trends
.. weekly Housing Data Analytics Lab sessions

Patterns of Housing Value Change by 3-Digit ZIP Code
The following graphic shows housing value appreciation 2015Q3-2016Q3 by 3-digit ZIP code based on the HPI. Use related GIS tools to zoom-in, assign labels, show in context with other geography.

– view developed using CVGIS and related GIS project.
– Click graphic for larger view and details;

Examining Housing Appreciation by 3-Digit ZIP Code
Use the interactive table below to view/rank/compare the non-seasonally adjusted “all transactions” HPI for the most recent 5 quarters for all 3-digit ZIP codes. The ranking table shows the latest quarterly HPI data and preceding quarters for one year earlier. This table will be updated on February 24, 2017, with 4th quarter 2016 data and related prior quarterly estimates and re-computed quarterly change values (last column).

Using the Interactive Table
The following graphic illustrates use of the HPI by 3-digit ZIP code interactive table. HPI data are shown for the quarterly period 2015Q3 through 2016Q3. The state selection below the table has been used to select only California ZIP codes. The Group1 button below the table has been used to select ZIP codes with a 2016Q3 HPI value of 175 ore more. The table is then sorted on the rightmost column. The resulting view shows that among all California 3-digit ZIPs having an HPI of 175 or more in 2016Q3, ZIP code 948/Richmond CA had the highest housing value appreciation — a 10.6% increase over the year.

Use the interactive table to examine states or ZIP code groups of interest.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Urban Area Demographic Trends 2010-15

.. tools and analytics to examine all urban areas with particular focus on Urbanized Areas and demographic change between 2010 and 2015 .. examining urban areas in context of metropolitan areas .. the four fastest growing Urbanized Areas (UAs) from 2010 to 2015 were in Texas. McKinney, TX UA led the nation with an increase of 27.5% in total population. View, rank, compare 2010 and 2015 demographic characteristics for UAs using the interactive table in this related section. Urban areas (Urbanized Areas and Urban Clusters) are important for many reasons. More than metros and cities, urban area geography better reflects how the urban and rural population is changing. Both metros and cities can change geographic boundary over the years. Urban areas are based on Census 2010 and unchanging between 2010 and 2020. Annual demographic updates are available from the American Community Survey (ACS 2015).

This section is focused on tools and analytics to examine all urban areas with particular focus on Urbanized Areas and demographic change between 2010 and 2015. Use the interactive table >in the related section to view, rank, query urban areas and demographic change for larger urban areas. Use the related GIS tools and data to develop related thematic and relationship maps. Perform geospatial analysis of geographic and demographic-economic characteristics using the resources we have developed. Gain insights into patterns that might affect you. Use these resources to collaborate on how, where, what, when and why of change.

McKinney TX Urbanized Area in Context of City
The McKinney, TX UA (bold orange pattern) is shown in context of McKinney city (cross-hatched area) and other urban areas (lighter orange pattern). It is easy to see that some parts of the city are rural and that the UA extends beyond the city in many areas. See more about the McKinney UA and in comparison to other urban areas using the interactive table.


– view created using CVGIS software and related GIS project.

Most Urbanized Areas (UAs, 435 of 487) have population 65,000 population or more resulting in the availability of annual demographic-economic estimates. Data are fresher than available for smaller urban areas (ACS 5-year estimates for areas under 65,000). This means more current data to assess more recent characteristics. As annual data are available UAs enabling analysis of change over time. The “2010s” marks the first time these refreshed, time series-like data have been available for urban areas. Businesses and those examining change performing market analysis benefit from the ability to examine characteristics or urban areas in combination with counties and metros.

Houston Urbanized Area in Context of Houston Metro
The Houston metro has a bold brown boundary. It is easy to see how the Houston UA (darker orange fill pattern) geographically relates to the metro. Other urban areas (all) are shown with a lighter orange fill pattern. It is easy to see the urban/pattern character of the general region. While the Houston UA is the largest, there are four UAs that intersect with Houston metro. Use the interactive table below to view their names and characteristics.


– view created using CVGIS software and related GIS project.

Urbanized Areas tend to be associated with metropolitan areas having a similar name. But very often there are multiple UAs within a metro; sometimes one is not dominant. Often there are several UAs in a metro having similar size. Use the interactive table below to view the relationship of UAs and metros (CBSAs).

Using Interactive Table
Use the interactive table to view, rank, compare, query urban areas based on a selection of demographic measures. The following graphic illustrates how the table can be used. Click graphic for larger view.

The graphic shows the urbanized areas ranked in descending order based on 2010-2015 population. The rightmost column shows the area percent change in population over the period.

Fastest Growing Urbanized Areas, 2010-15

Try it yourself. Use the table to examine urban area patterns and characteristics based on your selected criteria.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Analyzing ACS 2014 1-Year Supplemental Data

.. examining 2014 characteristics of areas with population 20,000 and over  .. this section summarizes how to use the America Community Survey (ACS2014) “supplemental” data (ACS2014S) to access more current estimates than otherwise available. The America Community Survey “supplemental” data are just that, a supplemental set of ACS 2014 1-year estimates — for areas 20,000 population and over. See the related Web section providing more detail.

The importance of the ACS 2014S data are two fold.
1 – 2014 1-year estimates for a larger number of areas than available from the ACS 2014 1-year (ACS2014) estimates.
2 – more current (2014) data for those areas only available from the 5-year estimates (centric to 2012) that are between 20,000 and 65,000 population.

The ten cities/places with the highest 2014 median family income based on 1-year estimates were all under 65,000 population. These cities were not included in the ACS 2014 1-year standard estimates but were included in the ACS 2014 1-year supplemental estimates. See list below.

This section provides an overview of the ACS 2014 supplemental data and provides a summary of tools, interactive table and GIS project, to analyze characteristics of these areas. These data are used by ProximityOne to develop/update annual county demographic-economic projections. See schedule of related 2016 updates.

Scope of Expanded Geography Available
As shown in the table below, 2014 1-year “supplemental” estimates are available for more than twice as many counties from the ACS2014S compared to the ACS2014 “standard” 1-year estimates. However, there area a more limited set of subject matter data available from the ACS2014S data compared to both the ACS 2014 1-year and 5-year estimates.

MSA/MISA: Metropolitan Statistical Areas/Micropolitan Statistical Areas Counties: county and county equivalent

ACS 2014S Data Availability by County
The following graphic shows the additional counties for which ACS 2014 1-year estimates are available using the “supplemental” data.
• ACS 2014 1-year “standard” estimate counties — blue fill pattern
• ACS 2014 1-year “supplemental” estimate counties — orange fill pattern
• Only ACS 2014 5-year estimates available for remaining counties
Click graphic for larger view; expand browser window for best quality view. The larger view shows metropolitan area (MSA) boundaries. Note that for example, ACS 2014 1 year data are available for all counties in the Austin and San Antonio metros (see pointer) — previously unavailable..

.. view developed with ProximityOne CV XE GIS and related GIS project.
.. any CV XE GIS user can create this view using the default US1.GIS project

ACS2014S Tables — scroll section
The ACS 2014 supplemental data include 42 tables and a total of 229 data items. Br> The table number and descriptions are summarized below.

View full table/item detail in tables shells: ACS 2014S Table shells (xls)

ACS 2014 Selected Supplemental Items for Selected Geography
  — interactive table
The interactive table contains all geography for which the ACS2014S data have been tabulated for these geographies: U.S., state, county, city/place, 114th Congressional District, MSA/MISA, PUMA, urban area and school district. The table provides access to key selected items.

The following graphic illustrates use of the interactive table. First cities/places were selected using the Type drop-down below the table. Next, the table is ranked in descending order on median family income. As shown in the graphic the largest 10 cities/places were under 65,000 population. Click graphic for larger view.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.