Investigate the settlement pattern for the Hispanics/Latinos population in the Piedmont region

Problem

There has been interest in the settlement pattern of migrants in the United States. The Office of State Human Resources wants to know the settlement pattern of Hispanics or Latino migrants in the Piedmont region in North Carolina.

Analysis Procedure

There are 33 counties in the Piedmont region in North Carolina as shown in the map below. Data for the Hispanics or Latinos Census Tract for counties in Piedmont Region can be downloaded from American Fact Finder web site in a csv format, DEC_10_SF1_P9_with_ann.csv. The geographic boundary TIGER file for the Census Tract filtered down to counties in Piedmont Region was downloaded from the US Census Bureau website.

The table DEC_10_SF1_P9_with_ann.csv comes from P9 of the 2010 Census Data that shows the number of Hispanics or Latinos and non-Hispanics or Latinos per census tract level. The field name for the Number of Hispanics or Latinos is D002 and the field name for county ID is GEOid2. The data table is to be joined to each county in the Piedmont boundary TIGER tl_2010_37_tract10 layer. Since each county is divided into smaller geographical areas known as census tracts, by mapping D002, the clustering effect on Hispanic population can be seen at each county level. ArcGIS Pro is used here. Appropriate statistics tool will be used for spatial analysis.

The data was prepped for use by converting DEC_10_SF1_P9_with_ann.csv to .xls, and deleting the 2^nd heading. The spreadsheet was loaded using Excel to Table. The TIGER file was loaded and projected to NAD83 NC State Plane FIPS 3200 feet. The field GEOid2 of DEC_10_SF1_P9_with_ann was converted to text using Add Field and Calculate Field, so that it joined to the county ID of the TIGER file using Add Join. The data can now be displayed by symbolizing field D002 as shown in the results below. Hot Spot Analysis (Getis-Ord Gi*) tool was used, and Calculate Distance Band tool was ran at 6, 14, 20 neighbor counts to get bands at 28000, 44000 and 57000 feet, with the best results for Getis-Ord Gi* at 57000 feet.

Workflow Diagram

Results

Application and Reflection

Census data can be used in many ways, from migration to age, gender and to household income.

Problem Description There is a possibility if I strike lottery, I would be able to invest in an Interactive Science and Art Museum which is one of a kind. It already has a location in the west coast. I need to study households with children below 18 years of age in the east coast for a feasibility report.

Data Needed The tabular data is downloaded from AFF and the boundary shape file from TIGER. The tabular data is from PCT 21 Household type by number of people under 18 years (excluding householders, spouses, and unmarried partners) 2010 Census Data or S1101 Household and Families 2017 ACS. Both filter for 15 east coast states at the census tract level.

Analysis Procedures The .csv table is converted to .xls, prepped and GEOid2 converted to text. It is then table join to the boundary shape file. The Getis-Ord Gi* Hot Spot Analysis tool is used to generate hot spots where families with kids 18 years and below are clustered.