#!/usr/bin/env python
# coding: utf-8

# # Revisualizing Geographic Disparities:
# ### Examining Trends in Racial and Economic Inequality on Charlotte Streets without GIS

# * Creator: Valerie Sallis   
# * Source Available: https://archive.org/details/charlottenorthca1911pied
# * License: [Creative Commons - Attribute 4.0 Intl](https://creativecommons.org/licenses/by/4.0/)
# * Attribution: This work is based upon digital assignments completed by UMD Students in INST742: Implementing Digital Curation

# ## 5. Revisualizing Geographic Disparities: Examining Trends in Racial and Economic Inequality on the Streets w/o GIS:
# * **Author:** Valerie Sallis
# * **Abstract:** Examining racial disparities in key areas of Charlotte, using faceted clustering of types of homes.
# * **Dataset:** Full datified Directory (16,000 entries), 1911 Sanborn map, 1910 Census
# * **Tools:** Excel, OpenRefine, Tableau
# * **Video:** https://youtu.be/hyeYfOKnFBs (9′ 57″)

# <h3> Computational Thinking </h3>
#     

# This exercise utilizes the following elements of computational thinking: 
# 
# Data Practices:
# <ul>
#     <li>Manipulating data</li>
#     <li>Analyzing data</li>
#     <li>Visualizing data</li>
# </ul>
# Modeling and Simulation Practices:
# <ul>
#     <li>Using computational models to understand a concept</li>
# </ul>
# Computational Problem Solving Practices:
# <ul>
#     <li>Preparing Problems for Computational Solutions</li>
#     <li>Assessing Different Approaches/Solutions to a Problem</li>
# </ul>
# Systems Thinking Practices:
# <ul>
#     <li>Understanding relationships within systems</li>
#     <li>Thinking in levels</li>
# 

# <h3>Overview of the Project</h3>

# This project examines the racial and economic disparities on several of the most populous streets in Charlotte in 1911 using simple database manipulation techniques in OpenRefine and Excel and visual graphs created in Tableau Public. The purpose behind this method is to find alternative methods for analyzing geographic data using free database and visualization tools that may be easier to access for a single researcher or a small institution. While GIS software is a powerful tool and would be a natural choice for analyzing geographic disparities in data, not all institutions may have staff who are trained or feel confident using GIS software, as licenses for GIS programs with robust user interfaces and technical support like ArcGIS can be expensive and open-source programs like QGIS require signficant start up knowledge or self-education. 
# 
# Charlotte makes an interesting candidate for geographic analysis because it has an unorthodox layout. The historic area is designed on a grid, however the grid does not follow a N/S axis. Rather the grid sits on a skewed axis formed by the intersection of Tryon St and Trade St as seen in this Sanborn Fire Insurance map from 1911. This project attempts to find patterns in the data in terms of racial makeup and economic equality using the Tryon St/Trade St axis as the pivot point for analysis.
# 
# ![Charlotte 1911 Sanborn Map](Images/charlotteSanborn1911downtownaxis.jpg)
# 
# </u>

# <h3>Objectives</h3>

# <ol>
#     <li>Examine how racial and economic inequities were concentrated geographically in Charlotte in 1911. </li>
#     <li>Use simple data manipulation and cleaning techniques that would be accessible to researchers/library and arhival staff with minimal database training using OpenRefine and Excel.</li>
#     <li>Explore options for visualizing data with free software like Tableau Public. </li>

# <h3>Notebooks</h3>

# 1. [Data Manipulation](DataManipulation.ipynb) 
# 2. [Visualization Methods](Visualization.ipynb)
# 3. [Revisualizing Charlotte 1911](RevisualizingCharlotte.ipynb)
# 
# Next: [Data Manipulation](DataManipulation.ipynb)