A working version of this project can be found at http://census.delawareagenda.com/
The first "Population" map requests population data from online the US Census data, enhances it with geo-json features and sends it to the front end site for display.
Generalization of this code could display many more of the data sets available from the US Census.
The second "Worker Flow" map uses our own processed census data, "LEHD Origin-Destination Employment Statistics", which displays the flow of workers. The census data includes the census tract of both home and work, this map displays the calculated difference.
Install requirements
pip install -r ./server/requirements.txt
pip install -r ./server/dev_requirements.txt # Note that this installs supporting packages in editable mode
Run the development server
./server/run_dev_server.sh
create user
mysql -u -p
> CREATE USER 'ob_census_user'@'%' IDENTIFIED BY 'ob_census_pass';
> GRANT ALL PRIVILEGES ON ob_census.* TO 'ob_census_user'@'%' IDENTIFIED BY 'ob_census_pass';
> create database ob_census;
> use ob_census;
> source ob_census.sql