Tag Archives: GIS

New 2018 Vintage Metropolitan Areas

.. new, September 14, 2018 vintage, Core-Based Statistical Area (CBSA) delineations have been released by the U.S. Office of Management and Budget (OMB).  Among other things, the new delineations specify which counties are included in each CBSA.  CBSAs. an OMB standards term, are metropolitan areas comprised of Metropolitan Statistical Areas (now 384 MSAs in the U.S.) and Micropolitan Statistical Areas (now 542 MISAs in the U.S.).

How Metros Change Geographically
The following graphic, focused on the Charlotte, NC-SC MSA region, illustrates how MSAs are changing. 2017 vintage MSAs are shown with bold green boundary, yellow fill pattern. Cross-hatched areas are 2018 vintage MSA counties. As of the 2018 vintage, note that …
• Anson County, NC (to right of pointer) has been added to the Charlotte, NC-SC MSA.
• Union County, SC has been removed from the Spartanburg, SC MSA.
• Harnett County, NC has been added to the Fayetteville, NC MSA.

— graphic developed using CV XE GIS software and related GIS project.

What About My MSAs of Interest?
See detailed information about the 2018 vintage CBSAs/MSAs and their component counties at http://proximityone.com/cbsa2018.htm.

Impact of the 2018 Delineations
The new delineations take place immediately and have numerous impacts.  Going forward, Federal statistical agencies will develop statistics and use the new names and geocodes as set forth in the new delineations (most names and geocodes remain the same).  For CBSAs affected, which are numerous, this will result in challenges for longitudinal analyses where consistently defined geography over time is required.  The total 2017 official population estimates are affected for three of the largest 10 CBSAs using the 2018 delineations compared to the 2017 delineations.  More immediately, it may become confusing whether the 2018, 2017, 2015, or an earlier vintage CBSA geography is being referenced.  On a positive note, the 2018 vintage CBSAs are believed to best reflect the set of counties comprising a CBSA as an entity of highly related demographic-economic conditions.

Keeping Up-to-Date with Metro Demographic-Economic Data
Metropolitan Statistical Areas (MSAs/metros), comprised of one or more contiguous counties, are important for many reasons. Business, demographic and economic data for these 384 areas, each developed around an area of large population concentration, provide a “10,000 foot” view of these characteristics and how they are changing. As they are comprised of county groups, much of the subject matter data are also available for drill-down analysis at the county and sub-county levels. Metro boundaries change some over time … as more peripheral counties are added or removed depending on their demographic-economic affinity with central county(s).

Metros are an important part of the ProximityOne Situation & Outlook program. Metro demographic-economic estimates and projections are updated to reflect 2018 vintage metros. This includes all elements of the Census-sourced age-race/ethnicity-gender annual estimates and American Community Survey demographic-economic subject matter.

Designating Metros and Delineating Metro County Components
More detail … in consultation with Federal statistical agencies, OMB defines metropolitan statistical area boundaries. This section provides a summary of Metropolitan Statistical Areas (MSAs), and component Metropolitan Division and Counties/County Equivalents, as delineated in OMB Bulletin 18-04 issued September 14, 2018. These delineations take place immediately. This is a significant update affecting approximately 20-percent of previous MSA delineations (one or more county addition or removal).

Under the September 14, 2018 delineation, there are 938 Metropolitan Statistical Areas (MSAs) and Micropolitan Statistical Areas (MISAs) in the U.S. and Puerto Rico, collectively referred to as Core-Based Statistical Areas (CBSAs). There are 392 MSAs (384 in the U.S. and 8 in Puerto Rico). 11 MSAs contain a total of 31 Metropolitan Divisions. There are 546 MISAs (542 in the United States and 4 in Puerto Rico).

The 384 U.S. MSAs comprise 1,181 counties of total 3,142 U.S. counties. The total 2017 population of these metros was 280,468,904 of total 325,719,178 U.S. population (86.1%).

See related sections:
• Metros Main Section
• Metros Situation & Outlook Reports
.. click link in column 3 in table in above page to view detailed report
• Metro Demographic-Economic Interactive Tables
• County Population/Components of Change Interactive Table

Data Analytics Web Sessions
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.

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.

School District Revenue & Expenditure Patterns, FY 2016

.. many school districts are adopting 4-day school weeks.  Part of the reason is shortage of funds.  The amount spent per student for public elementary-secondary education for all 50 states and D.C. increased by 3.2 percent to $11,762 during the 2016 fiscal year, based on new data from the Census Bureau released May 21, 2018. The increase in spending in 2016 was due in part to the increase in revenue across all 50 states and D.C. In 2016, public elementary-secondary education revenue, from all sources, amounted to $670.9 billion, up 4.6 percent from the prior year. This is the largest increase since 2007. Yet for many districts this is not enough.

This section provides access to tools and data to to examine K-12 school district finances — sources and uses of funds for FY 2016. The Census Bureau collects these data annually to meet to needs of the National Center for Education Statistics. ProximityOne restructures and integrates these data with other data for GIS/geospatial analysis using the CV XE GIS tools and School District GeoDemographic Information System (SDGIS).

View annual school district finances Web sections: FY 2014 .. FY 2015 .. FY 2016
• Use interactive table to examine school system finances
• Create/view profile for a district(s) of interest.

Current Spending per Student by School District, FY 2016
The following graphic shows patterns of current spending per student by school district, FY 2016, for Texas and adjacent areas. The four largest Texas metros are shown with the bold brown boundary; counties with gray boundaries. Color/fill patterns and corresponding values are shown in the inset legend. Click graphic for larger view showing a partial mini-profile for Houston ISD (at pointer in map).

– view developed using the CV XE GIS analytical tools.
– use these tools on your computer to examine these data & related geography/subject matter.

Data Analytics Web Sessions
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.
 

Metropolitan Area New Residential Construction in 2017

.. understanding the housing situation; examining housing supply and demand market conditions; assessing trends for metropolitan areas … and how metros of interest are changing .. tools and data to examine patterns and change.

During 2017, cities and counties in permit issuing places authorized the construction of 1,281,977 new privately owned housing units with a total valuation of $258.5 billion. This was 1.4 percent above the annual estimate of 1,264,051 housing units and is a 6.2 percent increase from the 2016 total of 1,206,642.

Patterns of New Residential Construction by Metropolitan Area
The following graphic shows the 20 largest metropolitan statistical areas (MSAs) based on the number of new residential housing units authorized in 2017. Click graphic for larger view showing MSAs labeled with rank and name.

View created with CV XE GIS. Click graphic for larger view.

Residential Construction Data Analytics — Using Tools & Data
Visit the related Web section to access interactive table and GIS/GeoSpatial analytical tools and data.

Data Analytics Web Sessions
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.
 

Insights into County/Metro Business Establishment Patterns

.. new data, released this past week, enable us to better assess county and metro business establishment patterns .. these data help businesses understand how sales of their products and services align with markets .. what counties might be underserved? .. where should marketing and sales operations be ramped up or reduced in scope/reallocated? .. what do these tell us us about organization of market territories? how are these characteristics trending by county? Use the this interactive table to examine business establishments characteristics by county and metro by type of business. See more detail in the related Web section about topics covered in this post. 

• U.S. establishments rose 1.2% from 7,663,938 in 2015 to 7,759,807 in 2016.
• First quarter employment was up 2.1% from 124,085,947 to 126,752,238
• Annual payroll was up 2.9% from $6.3 trillion in 2015 to $6.4 trillion in 2016.

Based on the 2016 data (new April 2018), there are 7.3 million establishments in Metropolitan Statistical Areas (MSAs). In these MSAs ..
• 5.3 million establishments have fewer than 10 employees.
• 6,522 of these establishments have 1,000 or more employees.
• 374 of these establishments have 5,000 or more employees.

MSAs by Number of Establishments with 1,000 or more Employees
The following graphic shows Metropolitan Statistical Areas (MSAs) by number of establishments with 1,000 or more employees. Click graphic for larger view view showing metros labeled with number of these establishments. Expand brower to full window for best quality view.
.. View developed with CV XE GIS software and related GIS project.

Business Establishment Characteristics Updated in Metro Reports
Examine 2014, 2015, 2016 mini trend profiles for establishments by 2-digit sector in Metro Situation & Outlook Reports Choose any MSA by clicking column 3 in this table .. then view section 6.3. Examples:
New York .. Los Angeles .. Miami .. Chicago .. Dallas .. Houston .. Denver .. Seattle

Gaining Insights
Gain insights into these types of patterns by county by detailed type of business (NAICS). Use the interactive table below to examine business establishment characteristics for counties and metros of interest. Data reviewed in this section are based on the Census-sourced County Business Patterns released in April 2018. We have integrated current population estimates with the establishment data in the interactive table.

Tools You Can Use
• create maps and geospatially analyze business establishments at 6-digit industry detail with ready-to-use GIS project/tools .. see related section for details.
• Use the APIGateway tools to build custom business establishment datasets.
• Use the interactive table to query/view sort business establishment characteristics by county and metro.

Data Analytics Web Sessions
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.

Location-Based Demographics Update

.. tools you can use to examine characteristics of addresses/locations .. many of us are interested in knowing attributes of addresses or locations. Often knowing address latitude-longitude is important so that the addresses can be viewed on a map .. see below.  Some might need to know what census block, or other geography, in which an address is located .. or what school district is an address located in.  Others need to know demographic-economic attributes of the neighborhood or area where an address is located.  These types of attributes can be obtained for addresses using the Location-Based Demographic (LBD) tools.  The LBD tool has just been made a part of the CV XE GIS software.  The LBD tool is available in all versions of CV XE GIS, including the no fee User Group version. See more about using the LBD tools to look-up and analyze address/location attributes.

Viewing Geocoded Addresses on a Map – automatically
The following view shows addresses geocoded using the LBD tool. Markers show addresses of 27 Trader Joe’s locations in the Los Angeles area. LBD automatically creates a shapefile that is added to your GIS project. The markers are labeled with population ages 18 and over in the corresponding census tract. Marker color/styles reflect different levels of median household income. A separate census tract layer shows patterns of economic prosperity.

Click graphic for larger view. Expand browser window. A mini profile is displayed showing demographic-economic attributes for the marker at pointer.

View the locations without the tract thematic pattern layer:

Make similar views for your addresses.

Get Started Using the LBD Tool
1 – join the User Group .. click here to join (no fee).
2 – run the installer to install on a Windows machine .. requires your userid.
3 – with CV XE GIS running, click Tools>Find Address/LBD
    enter an address .. a form appears showing characteristics of the address.
4 – see more about using the tools on the LDB page.

GeoStatistical Data Analytics Learning Sessions
We are developing a series of “GeoStatistical Data Analytics” (GSDA) Learning Sessions/modules. One of these is focused on using the LBD tools and methods in the broader context of data analytics. We plan to develop the GSDA models for self-guided use by analysts/practitioners as well as in the classroom setting with teacher/student materials. Upcoming blog posts will describe the program in more detail.

Data Analytics Web Sessions
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.

Redistricting & Census 2020

.. most states will not have new redistricting plans until after Census 2020. Redistricting is the process of developing a redistricting plan for 2 or more areas (districts) disjoint and contiguous that are contained within the collective area of all districts based on some criteria. Redistricting is perhaps most familiar with regard to congressional districts and state legislative districts based on a set of demographic characteristics … but may apply to many other types of geographies. This post briefly reviews the Census 2020 & Redistricting Program.

Redrawing the Pennsylvania 115th Congressional Districts
The following views show Pennsylvania 115th Congressional Districts in their gerrymandered configuration (old) and the redrawn configuration (February 2018, new). Counties shown with light gray boundary. Click graphic for larger view. Expand browser window for best quality view.
Pennsylvania 115th CDs — Old

– View developed using CV XE GIS and related GIS project.

Pennsylvania 115th CDs — New, redrawn February 2018

– View developed using CV XE GIS and related GIS project.

Census 2020 & Redistricting Program
The ProximityOne Census 2020 & Redistricting Program enables participants to engage now in preparation for redistricting based on Census 2020. Use resources and processes provided by ProximityOne and the Congressional Districts/State Legislative Districts Group (CDSLD) .. participate in hands-on redistricting for your areas of interest. We start now using Census 2010 redistricting data, current congressional districts and state legislative districts, and related data/tools. Progressively, we move toward accessing the live Census 2020 redistricting data (March 2021). There is no cost to participate. See more about the Census 2020 & Redistricting Program at http://proximityone.com/cen2020_redistricting.htm. Join the CDSLD Group via this form to receive updates on the program and begin participation.

Data Analytics Web Sessions
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to the Census 2020 redistricting Program. 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.