Git Product home page Git Product logo

ca_census_migration's Introduction

ACS Migration In-Out Table Creator

Data

This uses ACS input tables from iPUMS... the variables that you need are:

  • "State", "PUMA", "MIGPLAC1", "MIGPUMA" Or any variables that you want to filter and create demographic filters by.

There's a slight discrepancy from previous year and current year location, this is noted and mostly affects some counties in Alabama, IPUMS has chosen to bury its cross-walk table while it makes the correction, but you can still find it and its still good for most of the country.

The second cross-walk that's required is a PUMA geography to county one, the University of Missouri State Data Center web page has a set of wonderful tools to help with this translation depending on what type of geographic roll-up is required, areal weighting (apportioning the PUMA or division over multiple areas) but keep that in mind depending on the area that you want to roll up to, especially if you need to apportion a PUMA across METROS that cross state boundaries for example. Census and geographic data can get complicated!

Quick Visualization

Some quick visualizations - there are honestly so many: using the R circalize package

This chart filters out migration cells with less than 4000 households, just to simplify the data. There is lots of migration between Los Angeles and the Inland Empire, but not as much between the Inland-Empire and the Bay Area, San Diego is largely self-contained.

Other ways of visualizaing this data: sankey/ flow chart types which are better for one-way or net flows. In general migration data can get very busy, so it helps to consolidate areas into properly generalized groupings. For example, inner city to suburbs, to out-of-state flows depending on what you want to emphasize.

Map Visualizations

I also tried my hand at "great (well maybe not so great?) circle" gis maps using QGIS with Anita Grasser (sp?)'s flow package. It takes some work to make it look good, but it's much easier to use this to show net-migration change by arrow-thickness and shape.

The general pattern for migration in the bay area, is from the 6 or 7 central bay counties into peripheral counties as people get priced out of the bay. Then, as people get priced out of the outer-bay counties they simply move out of the state.

These charts still get busy, animated charts could help simplify some of that.

Core to Periphery

Periphery To Out of State

Citations

Gu, Z. (2014) circlize implements and enhances circular visualization in R. Bioinformatics. DOI: 10.1093/bioinformatics/btu393

IPUMS cite - Ruggle 2014

ca_census_migration's People

Contributors

azadag avatar

Watchers

 avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.