Assignment 8
pdf
keyboard_arrow_up
School
University of Michigan, Dearborn *
*We aren’t endorsed by this school
Course
DS 633
Subject
Information Systems
Date
Feb 20, 2024
Type
Pages
6
Uploaded by monikagautam93
Assignment 8
Problem 1
Use Tableau to create 4 or 5 interesting visuals. At least one visual should be a map. Make sure that the labels on your visuals are clearly displayed. Briefly, explain what you find interesting.
1.
Map Displaying Lead Concentration by location and Land Value
The color spectrum on the map helps to identify regions with varying economic values. It shows zip codes with lower and higher average land values, enabling a visual comparison of wealth distribution across Flint. Moreover, it also depicts the geographical spread of lead concentration averages across different zip code areas. It identifies regions with varying lead contamination levels, aiding in understanding potential environmental concerns related to water quality in specific areas. The data has been filtered on an unspecified condition (SL Type), maintaining 12 members. Upon observation, it's evident that despite their lower average land values, zip codes 48532 and 48504 exhibit higher lead concentrations. This visualization aims to offer an understanding of socio-economic disparities based on land values and the distribution of lead contamination levels across various zip code regions in Flint, Michigan.
2.
Lead Levels Across Property Types & Ownership
The stacked bar chart reveals the average lead concentrations based on property use types (Commercial, Industrial, Residential) segregated by different owner types. Color distinctions represent the homestead status, demonstrating how it affects lead levels in various property types.
Lead levels variation illustrates how lead concentrations differ across property types concerning different owner categories. Whereas color coding highlights the influence of homesteading on lead levels within Commercial, Industrial, and Residential property types. Owner Type displays lead concentration disparities across public, private, and land bank ownerships within each property use category.
The chart specifically concentrates on the Commercial, Industrial, and Residential property types, offering insights into lead levels influenced by ownership types and homesteading.
By seeing the graph clearly state that lead level is more in land bank in residential property with homestead than other types.
The visual representation helps in understanding the relationship between property use types, ownership, and homesteading on the lead concentration levels within Flint, Michigan.
3.
A Tree map Analysis of Owner and Use Types
The treemap visualization provides an insightful look into the average lead contamination levels (in parts per billion - ppb) across different Owner Types, Use Types, and Service Line (SL) Types in residential buildings.
Each square or rectangle in the treemap represents a combination of Owner Type, Use Type, and SL Type, with the color denoting the SL Type's details and the size representing the average lead concentration. The marks within the treemap are labeled by Owner Type, Use Type, and SL Type for better understanding.
The data is filtered specifically for Residential Building Style and Prop Class, excluding Null values in Residential Building Style and keeping CI, II, REF, RI, and RV in the Prop Class.
Key insights from the visualization indicate that different combinations of Owner Types and Use Types show varying levels of lead contamination. For instance, certain combinations exhibit minimal to no lead presence, while others display significantly higher lead levels, raising concerns about water safety in specific contexts.
The visualization serves as a tool to identify patterns and potentially problematic areas in water quality across different owner and use categories, emphasizing the critical need for further investigation and remediation in instances of high lead concentration for the safety of residential water supplies.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
4.
Understanding Lead Levels Trends Over Time Across Owner, Use Types and SL Type
The line graph visualization displays the trend of Lead Concentration across different weeks in the Date Submitted data. It offers insights into the fluctuations of lead levels over time, particularly concerning different Owner Types, Use Types, and Service Line (SL) Types.
The data is filtered for specific categories, including Owner Type (Land Bank, Private, and Public), Use Type (Commercial, Industrial, and Residential), and SL Type (all 12 members).
Examining the line graph reveals the dynamic nature of lead levels across various weeks. It demonstrates fluctuations in Lead, indicating periods of high and low lead contamination. These fluctuations might be indicative of changes in water safety levels within Commercial, Industrial, or Residential contexts, possibly influenced by various factors such as infrastructure, water treatment, or environmental conditions.
The visualization acts as a tool to understand how lead levels vary across different Owner and Use Types. It provides critical insights into potential fluctuations in water quality, particularly in specific contexts or property usages, necessitating attention to areas where lead levels consistently peak.
Understanding these variations is crucial for assessing and addressing potential water quality issues, emphasizing the need for regular monitoring, testing, and potential remediation efforts to ensure safe water supplies in different property contexts.
5.
Analyzing Future Land Use: Relationship between Land Value and Lead Contamination
The bubble chart visualization provides an overview of various future land use categories and their respective average Land Values and Lead contamination levels (measured in parts per billion - ppb).
Each bubble on the chart represents a distinct Future Landuse category. The color of the bubble denotes the average Land Value, while the size of the bubble signifies the average Lead concentration.
Observing the visualization reveals intriguing insights. For instance, certain land use categories, such as Civic/Cultural Campus and Community Open Space, exhibit relatively high average Land Values but comparatively lower average Lead contamination. On the other hand, areas like University Avenue Core, while having high Land Values, display elevated Lead levels.
The size and color variations within the bubbles allow us to understand the potential correlation between Land Value and Lead contamination across different types of future land use. It sheds light on areas where high land value might coexist with higher or lower lead contamination, emphasizing the need for further investigation into potential factors influencing these dynamics.
This visualization acts as a valuable tool for urban planners, policymakers, and environmentalists to consider when assessing land use planning, aiming for a balance between economic value and environmental safety within these different zones. It highlights the importance of comprehensive strategies to ensure both the economic development and safety of these future land use areas by addressing potential lead contamination.
6.
Comparing Lead Levels in Residential Building Styles by Rental and Stories
The stacked bar chart visualizes the distribution of average Lead (ppb) across different Residential Building Styles, further broken down by Rental status and number of Building Stories. Each section of the stacked bars represents a specific Building Style, while the segments within each bar display the Lead levels concerning Rental and Stories.
The data is filtered for various parameters such as Use Type (Null, Commercial, Industrial, and Residential), Prop Class (CI, II, REF, RI, and RV), and USPS Vacancy (N and Y). The view focuses on Residential Building Style and Rental, excluding Null and retaining No and Yes filters, respectively.
Observing the stacked bars provides insights into Lead contamination variations within different Residential Building Styles. It highlights patterns of Lead levels based on the number of stories and whether the property is rented or not. For instance, certain Building Styles might exhibit higher Lead levels when rented compared to their non-rented counterparts, and this variance can differ based on the number of stories of the building.
This visualization aids in understanding the potential impact of building style, rental status, and the number of stories on lead contamination, offering valuable insights for property management, environmental assessments, and potentially necessary interventions to mitigate high lead levels in certain residential structures.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help