This is an collaborate project with Nicholas OMalley. Boston– Emergency Shelter shortage - it’s been a problem for a while since November, 2023, while the state government uses transportation building(MTB) as a temporary solution for two weeks. Later in January this year, the Terminal E of Logan Airport was used as “de facto shelter” as well. Both of the locations are the overnight only shelter for the homeless families. And this temporary shelter has been kept until now. Where are the Shelters located across the state? The current families in the shelters are located in the state with significant locations around the Boston area. According to the bi-weekly report from the state, more than a half of families who currently stay in the state’s emergency shelter are located in the greater Boston Area. Most of the families live in the eastern part of the state. The families on the west side of the state are mostly located around the Springfield neighborhoods. In the Greater  Boston area, the city of boston took nearly 20% of the…

Methods: The first thing we did is use the data from the MA Emergency Assistance Shelter Report. In its Appendix A, there is a list and table of the total families. But since the report was on PDF we used an open-source tool called Tabula to get the data out from the report. After that we could import data to the tableau and create some charts and graphs based on the family. There is a small problem when we extract these data, which is the first three towns–Acton, Amherst, Andover– their total number is on the third column instead of every town else which was on the second column. So we made a little bit of adjustment on this. After we cleaned the data, we were finally able to import this csv file into tableau.  And we got some interesting findings which we discussed for the first time. So right here when we put data into the map, we found out that a lot of the resources and facility are located on the east side…

I was on a research to figure how how the Hong Kong housing price changed from years and compare by region. Although there is the chart provided by the Rating and Valuation Department. They only provide the number with three different(Hong Kong, Kowloon and New Tertiary. And the data was come with the five category by the area of the house. But there is no index that I could use to represent the overall price change for each region, and later on to the whole SAR. In order to get the overall price change for each region, I used the data from the Rating and Valuation Department, and by weighted arithmetic to create create an overall price for each region, they I can add them together to create a overall index of whole Hong Kong. And compare that data to with another data showing the overall data. there is a note on the data I used for this is “Changes in average prices between different periods may be due to variations in the characteristics of…

This is a collaborate project with David Cartledge. Original purpose and application These datasets were compiled by the MBTA to best inform commuters about the daily flow of public transit within the city of Boston. Using real time data collected and distributed by the MBTA, commuters are informed of any delays, slowdowns, or closures across the public transit system. Along with the knowledge of the delays, riders are informed of potential down time for each alert, as well as the reasoning behind the alert. This is the primary system the city uses to inform its riders of delays, as well as charts the accuracy of the delay warnings and ETA’s of the past through its years of logged data to best keep Bostonians informed. https://mbta-massdot.opendata.arcgis.com/datasets/155ab68df00145cabddfb90377201b0e/explore https://mbta-massdot.opendata.arcgis.com/datasets/90ed9092bd7a4285b296d5ff938edf29_0/explore History, standards, and format The Massachusetts Department of Transportation (MASSDOT) has been compiling the dataset regarding the accuracy of the transit prediction system since 2020, while the system categorizing the reason for these shutdowns has been collected since the end of 2018. They have been the sole data collectors…

  this is a chart that i created with Tableau. It showing the relationship between the average air price between state. At first i was trying put the airport code with the price, it did come with the map, but there was only airport point there. Since I would like to make it connect with states, i then add State factor into it, then the whole map goes white. there is no point at all. So my next step will going to put the airport point and the state together. there is another problem is that the price is not averaged by states, so it all add together. I also need to fix that problem.   Three questions that explored your data visually provoked you to ask (you don't have to answer them; ask them). what makes this different by state? How can this price connected with the number of passenger ? Is there any relationship with the income by state?

i will be using this Active Food Establishment Licenses as my first data site. the table also available below. Who collects this data set? If it's an organization, which department of the organization? Is there a specific person listed who you could contact? the data was collected by the The Health Division of the Department of Inspectional Services (ISD), City of Boston and published by the Department of Innovation and Technology, City of Boston. There isn't a specific person that I could reach, but there is an email list on the website that could let me connect with their ISD team. Why do you think the organization collects this data? Does it specify how it uses the data?              think the data was originally collected simply because it is health division's job to issue the food establishment licenses and they have to keep everything in to record. it said in the description "The Health Division of the Department of Inspectional Services (ISD) creates and enforces food safety codes to protect public health. All businesses which…

Boston, the east coast city I'm currently live in and studying. Irvine, the west coast city in California. they are two different vibe of the city but there are some similar thing that both cities share together. Let's start with some background. Population & Diversity Based on the data from DataUSA, summarized from the Census Bureau ACS 5-year Estimate. White hold about half share of total 673 thousands of people in Boston, followed by Black or African American and Hispanic which both take around 20% share. Asian with slightly less than 10% become the final composition. Compare to Boston, Irvine is not that diversity. The Asian and White composed 80% of the 298 thousands people's city, with 42.6% of Asian and 37.4% of White. 12% of the people in the city are Hispanic, and Black and African American hold share as less than 2%. It is the "the largest city in the continental United States with an Asian plurality" according to the Orange County Register, and only Honolulu have Asian more than other race in the…