The Bar Map: Where do Atlantans go for a drink?

CP-6521 Advanced GIS Final Project

Introduction

Bars are an integral part of people's social lives, providing a critical "third space" (Oldenburg, 1989) for socializing, networking, entertainment, and community-building. In addition to being a place to unwind and forget about work or personal problems, bars are also a venue for professional networking and relationship building.

Our study aims to explore the relationship between bars and local neighborhoods in Atlanta by asking the following questions:

  1. What is the spatio-temporal pattern of bar visits from neighborhoods in Atlanta metro area?
  2. What is the socioeconomic characteristics of patrons for different drinking places?

Data & Geography

There are two primary data sources for this study.

SafeGraph monthly patterns data example

SafeGraph POI monthly visits

anonymously sampled mobile phone data containing estimated number of visits from an aggregated geography (census tract or census block group) to POIs of different categories (6-digit NAICS code)

Bars - 722410 Drinking Places (Alcoholic Beverages)


Census ACS 5-year Estimate

Ethnicity Composition, Household Income

Heatmaps for selected socioeconomic status variables


Bar Visit Map

JANUARY

FEBRUARY

MARCH

APRIL

MAY

JUNE

JULY

AUGUST

SEPTEMBER

OCTOBER

NOVEMBER

DECEMBER


Bar Customer Characteristics

For each Bar X i  , visits V ji  come from Census Tract T j  (j = 1,2,...,N i ). Then, we compute the following three indicators to quantify the socioeconomic characteristics of customers for Bar X i .

1.Weighted Mean - Median Household Income (WMMHI i )

2.Weighted Variance - Median Household Income (WVMHI i )

3.Shannon Entropy - Racial Diversity (SERD i )

Weighted Mean Median Household Income (Quantile)

Weighted Variance of Median Household Income (Quantile)

Racial Diversity (Quantile)


Can bars attract people from diverse backgrounds?

Context- vs. Customer-based Neighborhoods

RACIAL ENTROPY RATIO

MEDIAN HOUSEHOLD INCOME RATIO

INCOME VARIANCE RATIO

SafeGraph monthly patterns data example

Heatmaps for selected socioeconomic status variables

Weighted Mean Median Household Income (Quantile)

Weighted Variance of Median Household Income (Quantile)

Racial Diversity (Quantile)

Context- vs. Customer-based Neighborhoods