{"id":7963,"date":"2017-11-29T17:25:36","date_gmt":"2017-11-29T22:25:36","guid":{"rendered":"http:\/\/research.prattsils.org\/?p=7963"},"modified":"2017-11-29T17:25:36","modified_gmt":"2017-11-29T22:25:36","slug":"starbucks-new-york-city","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/starbucks-new-york-city\/","title":{"rendered":"Starbucks in New York City"},"content":{"rendered":"

Introduction<\/h3>\n

Jeremiah’s Vanishing New York<\/a> is a blog\u00a0run by Jeremiah Moss that reviews historically important places in New York City. I have followed his blog for about a year. He\u00a0is\u00a0especially skeptical and negative about replacing\u00a0old\/historic restaurants, cafes, and coffee shops with new, giant franchises, in regard that the city is getting lose of its identity and own culture. One\u00a0of the topic he frequently mentioned\u00a0is opening a new Starbucks in old, comparatively untouched neighborhood, assuming that it will result in skyrocketing rent and threatening small local business.<\/p>\n

Starbucks is one of the largest coffeehouse chains in the world, as well as in the United States. Recently, Starbucks is considered as one that threatens local businesses. Not only local businesses, but also property values are affected as well. The property value of homes within a quarter mile of a Starbucks rose 96%, according to Zillow, between 1997 and 2013. In the same time frame, average increase for all U.S. homes is 65%. [1]<\/p>\n

As of July 2017, there are 333 Starbucks store is in New York City only, and 2\/3 of them are in Manhattan area. Starbucks used to be relatively scarce like inner Brooklyn neighborhood or Bronx, but stores are expanded to the areas that used to prevailed by local coffeehouses.<\/p>\n

Using Carto, I visualized Starbucks stores in New York City by zip code in New York City in various ways, to see how Starbucks are distributed in New York City, which area has the highest density with the stores, and how Starbucks expands its stores geographically within the city.<\/p>\n

Visualization Example<\/h3>\n

I referred a\u00a0cartographic guide to Starbucks\u2019 global domination<\/a> from Quartz as my visualization inspiration. This article presents various maps with the worldwide Starbucks location data.<\/p>\n

The map below shows every Starbucks in America. Each dot represents one Starbucks store. In other words, the gray areas are untouched by Starbucks yet. Each dot size is very small and has no boundary around the dot, so it looks like a heat map.<\/p>\n

\"\"<\/p>\n

Another interesting map is “Every Starbucks on Manhattan” shown in below. This\u00a0map helps to understand\u00a0how the stores are distributed in Manhattan.<\/p>\n

\"\"<\/p>\n

The author also shows the distribution in the same scale sizes. The author says the distribution in many cities shapes like each city, or at least its wealthier neighborhoods.<\/p>\n

\"\"<\/p>\n

<\/h3>\n

Data Preparation<\/h3>\n

Socrata.com provides all Starbucks location data in the world<\/a>. I exported the file into Spreadsheet, and filtered by Country (US) – Country Subdivision (NY) first. There is a ‘city’ column within the data, but some of the stores are not under “New York”. For example, Jamaica is in Queens, but the stores in Jamaica is under “Jamaica”,\u00a0not Queens. Therefore I needed to find the names of those neighborhoods in New York City 5 boroughs, so that any of the data is not excluded. I searched all zip codes in New York City, and used as a filter to select stores only within New York City boundary.<\/p>\n

I also would like to find opening dates of the stores, but no organized format exists. I could obtain the opening dates for only around 100+ stores in New York City from this website<\/a>.<\/p>\n

New York City zip code boundary shape file is retrieved from NYC open data<\/a>.<\/p>\n

 <\/p>\n

Results<\/h3>\n

After importing the csv file that contains Starbucks location data and .shp files of New York City zip code boundaries, I added\u00a0 some analysis to calculate the number of Starbucks\u00a0on each\u00a0zip code.<\/p>\n

On the map below, each green dot represents the location of each Starbucks. The choropleth map represents the number of Starbucks on each zip code. I added a widget on the right side of the map to show how many stores in each “area”. This data comes from a column named “city” in the csv file. As I mentioned above, the “city” does not correctly categorize 5 boroughs. In fact, “New York” indicates “Manhattan” only. There is no “Queens” in the column. Instead, Queens’ neighborhoods are separated as Jamaica, Astoria, etc. To deliver clearer message to users, the “city” column in the original data should be reorganized if further study is needed.<\/p>\n

As users click the name, the map shows the borough with the stores.<\/p>\n

(Click the image to the Carto map link)<\/em><\/p>\n

 <\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

This choropleth map shows the density of Starbucks per zip code. Manhattan midtown has definitely the highest store density.<\/p>\n

(Click the image to the Carto map link)<\/em><\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

I also would like to visualize how Starbucks stores geographically expanded by year, but I could find opening dates of about 100 stores only. The darker the color is, the most recent the opening date is. Since I do not have sufficient data (opening dates) of all stores, I am not able to conclude the trend how the stores have expanded geographically. In the future research,\u00a0I would show dynamic changes of geographical expansion.<\/p>\n

(Click the image to the Carto map link)<\/em><\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

Article reviews\u00a0<\/strong><\/p>\n