Census Insights
of
Denver's N Line

Project Overview:

The project analyzes demographic and transportation data in Denver, Colorado. It aims to investigate two main aspects: the proximity of census tracts to the N Line transportation route and the distribution of households without vehicles across the city. Using census tract-level data and geospatial analysis techniques, the project seeks to provide insights into transportation accessibility and household characteristics within Denver. The project's outcomes will inform urban planning endeavors, transportation infrastructure development, and initiatives focused on social equity in the region.

Geoprocessing and Visualization:

• Data Acquisition: Obtained tract-level data for the 2022 West Adams County, Colorado, from www.Census.gov, along with the required data tables and Census geography boundaries for the same area and year.

• Data Loading and Joining: Loaded the cleaned census tract boundaries data into ArcGIS Pro and joined it with the Python-cleaned data based on the FIPS (geoID) field to create a unified dataset for mapping.

• Spatial Analysis: Conducted spatial analysis to understand transportation dynamics within communities, based on household vehicle ownership data.

• Data Cleaning: Utilized Python scripting to clean the census tract information, separating relevant data after the 'US' identifier in each string to prepare it for joining with the geographic layer.

Skills Demonstrated:

• Data Acquisition

• Data Cleaning

• Data Joining

• Proximity Analysis/ Buffer

• Geocoding

• Python

• Resource Allocation

Conclusion:

The project effectively utilized census data and geographic analysis to reveal insights into Denver's N Line proximity and households lacking vehicles. Through data processing and visualization, key demographic trends were identified, offering valuable inputs for urban planning and transportation initiatives. The demonstrated skills in data analysis and spatial visualization underscore the significance of GIS techniques in addressing transportation challenges and promoting equitable access to resources in urban areas.