Visualizations Portfolio

.

Reinventing Worcester

Analyzing the ever-evolving landscape of Worcester through the Decennial Censuses data (link)

Date: July 2023
Software used: ArcGIS StoryMaps
Content themes: City of Worcester, Georeferenced Historical Map, Decennial Census, Demographic Data, Population, Age and Sex, Race and Ethnicity, Economic Characteristics, Occupation, Industry, Educational Attainment.
Technical features: ArcGIS Sidecar View, ArcGIS Swipe Comparison, Choropleths, Point Layer
Summary: The city of Worcester is the second largest in New England, and over the past few decades, it has undergone substantial demographic and economic changes. As an economic and population hub for many cities and towns in the central region of Massachusetts, studying past changes not only helps us better understand the present but also allows us to think more informedly about the future. This StoryMap explores these elements.

Onboard for Data

Dynamic visualizations on the WRTA finances, region, riders, and ridership (link)

Date: April 2023
Software used: ArcGIS StoryMaps (1) | ArcGIS Experience Builder (1) | Tableau Public Dashboards (4)
Content themes: City of Worcester, Transportation, Worcester Regional Transportation Authority WRTA, WRTA Finances, Origin-Destination Matrix, Origin-Destination Maps, Riders Profiles, WRTA Satisfaction Surveys, Ridership, Post-Pandemic Recovery.
Technical features: ArcGIS Sidecar View, ArcGIS Swipe Comparison, Choropleths, Point Layer, Line Layer, ArcGIS Interactive Web App, Embedded Tableau Public Dashboard, Tableau Dashboards featuring geographic layers, interactive-interconnected charts and maps, timelines, origin-destination vectors, color coding, etc.
Summary: This StoryMap presents a series of interactive dashboards and maps following The Research Bureau’s work on the Worcester Regional Transportation Authority (WRTA) and the feasibility of it becoming free-fare, and should be read in conjunction with our previous reports: All Aboard: Financing a Fare-Free WRTA and Resurging Regional Ridership: An Analysis of Mobility Flows, Riders, and Ridership in the WRTA Region.

Governing for Excellence

City Council and School Districts – Interactive Portal (link)

Date: December 2022
Software used: ArcGIS Experience Builder
Content themes: City of Worcester, School Districts, School Public Schools, School Committee Districts, Public School Quadrants, Municipal Government, Elections, Voting Precincts, Voting Wards, Voting City Council Districts, Polling Locations
Technical features: ArcGIS Experience Builder Dashboard, Choropleths, Point Layer, Line Layer, Layers and Legends Display
Summary: Built as an accompanying dashboard to the report Governing for Excellence: Worcester Public Schools’ Evolution in Governance. This online dashboard displays the geographic boundaries of school districts and electoral districts, as well as their intersections and overlaps. It allows you to view the location of public schools and polling locations, as well as their interaction with the district definitions mentioned earlier.

Evaluación Cuantitativa

MÁS 2.0 TechnoServe (link)

Date: December 2022
Software used: Tableau Public Dashboard
Content themes: Honduras, Latin America, Rural, Agronomic, Development, International Aid, Coffee Farming, Agronomic Production, Agronomic Productivity, Agronomic Income, Agronomic Best Practices
Technical features: Tableau Interactive Dashboard, Survey Dashboard, Map, Point Layer, Interconnected Tables-Maps-Graphs, Filtering, Geo-Located Surveys
Summary: This interactive dashboard displaying the main agronomic outcomes of the region intervened by the project funded by the US Department of Agriculture (USDA) and implemented by TechnoServe, The Sustainable Agricultural Improvement Project, in Honduras, and was created as a complement to the collection, analysis, and presentation of qualitative inputs for its Endline Evaluation.

Static Income, Rising Costs

Renting in the Heart of the Commonwealth (link)

Date: December 2022
Software used: ArcGIS StoryMaps (1) | ArcGIS Experience Builder (1) | Embedded Tableau Public Dashboards (1)
Content themes: City of Worcester, Renters and Owners Profiles, Cost Burden, Regional Comparison to Similar Cities, Redlining, 1936 Redlining Map, Redlining Current Effects, Redlined Zones Demographic Profiles
Technical features: Historical Map Digitization, Georeferenced Historical Map, Geographic Apportionment Methods, ArcGIS Sidecar View, ArcGIS Map Tour – Explorer View, ArcGIS Map Actions, ArcGIS Swipe Comparison, Choropleths, Point Layer, Line Layer, Embedded Tableau Public Dashboard, ArcGIS Interactive Web App,
Summary: Renter-households in Worcester have become the majority and have been increasingly cost-burdened since 2010; their costs have increased while their wages have remained static in terms of inflation-adjusted dollars. This StoryMap covers renters and owners’ profiles, a definition and analysis of cost burden between 2010 and 2020 by census tract and income range, a comparison against similar cities in the region, the first digitization of the 1936 Redlining Map of the City of Worcester, and analyses of its correlation with current socioeconomic patterns.

Is Worcester County Food Insecure? It Depends on Where

A geographic review of Worcester´s food situation (link)

Date: November 2022
Software used: ArcGIS StoryMaps (1) | ArcGIS Experience Builder (1) | Embedded Tableau Public Dashboards (2)
Content themes: City of Worcester, Worcester County, Central Massachusetts, Food Security, Food Access, SNAP Usage, SNAP Users’ Income Profile, Social Vulnerability, Bivariate Choropleth, Demographics, Food Pantries, Food Retailers, Food Retailer Types
Technical features: ArcGIS Sidecar View, ArcGIS Map Actions, ArcGIS Swipe Comparison, Address Geo-Coding, Choropleths, Point Layer, Line Layer, Embedded Tableau Public Dashboard, ArcGIS Interactive Web App,
Summary: According to the USDA, in 2021, 33.8 million people (including 5 million children) in the United States lived in households that experienced hardships providing enough food. This StoryMap covers food security, food access, SNAP usage, and food resources in Worcester, at the city and county level.

Investing in Excellence

Worcester Public Schools FY2019-FY2023 Budget (link)

Date: October 2022
Software used: Tableau Public Dashboard
Content themes: City of Worcester, Central Massachusetts, Education, Schools Budget, Public Schools, Municipal Budget, Revenues, Expenses
Technical features: Interactive Tables, Tables and Graphs Breakdowns, Point Layer, Tables Linked to Map Points, Year Checkbox, Map Filters
Summary: The yearly budget of the Worcester Public Schools is complicated, and necessarily so. With 23,735 students and 5,149 employees spread across 46 schools, there are many moving parts of which to take account. It covers revenues and expenses breakdowns, and school by school budgets.

How to consolidate an autocratic regime?

Understanding the electoral results of a key legislative election. A geographical analysis in El Salvador (link)

Date: April 2022
Software used: ArcGIS StoryMaps
Content themes: El Salvador, Latin America, Authoritarianism, Politics, Electoral Analysis, History, Legislative and Municipal Support, Electoral Participation by Age, Population Density, Socioeconomic Profile
Technical features: ArcGIS Map Tour View, ArcGIS Sidecar View, Swipe Comparison, Choropleths, Point Layer, Buffer, Bivariate Choropleth, Kernel Density Map, Multivariate Clustering
Summary: In February 2021, El Salvador had elections to choose Mayors for the 262 municipalities and the 84 Congress Representatives for 2021-2024. With a particular emphasis on the legislative results, these elections have been shown to be crucial for the modern history of the country and its near future, as it marks the end of a very young and fragile democracy that lasted almost 30 years. Understanding the geo-socioeconomic determinants of the electoral results for the Salvadoran Congress is the focus of this study.

Boston’s Education in Space and Time (link)

Date: March 2021
Software used: RStudio, RPubs
Content themes: Education, Historical, Boston City, School Types, Public Schools, Universities and Colleges
Technical features: R Coding, RPubs, Temporal Change, Geographic Change, Point Layer, Choropleths, Discreet Variables, Ratios
Summary: Where are K-12 schools located? Is there any geographical difference regarding public or non-public schools’ locations? Does any neighborhood have a higher level of public/non-public schools? Are non-public schools identical? Do these locations have geographical patterns? Are K-12 schools’ patterns different for colleges and universities? How has the number of colleges/universities evolved over the years? Are all these questions relevant to studying a city’s educational environment? Here I will answer this for Boston.