Dudley Street Neighborhood Initiative

Dudley Village Campus, Dudley Square, Dudley Triangle, and Grove Hall

Census & Map Application

Application created with Docker, Laravel and The US Census Bureau. Open-Source software makes this possible. Please donate: https://my.fsf.org/donate/

For examples on how to add to the application please utilize the Query Builder here http://uscensusbureau.github.io/citysdk/guides/censusModule/queryBuilder.html

GEORequest:

{
    "level": "us",
    "zip": "02120",
    "container": "tract",
    "sublevel": true,
    "variables": [
        "age",
        "employment_employed",
        "employment_unemployed",
        "income",
        "median_contract_rent",
        "population"
    ]
}

Output:

Census Geographies for DVC

Tracts and Block Group Codes

The source for for tracts can be viewed here https://github.com/dsni/data/blob/master/census/tracts and are available within the Census application directory ./dsnidata

Data

• Total Population
• Number of Housing Units
• Median Income

API Key

Census API Key Required: http://api.census.gov/data/citysdk.html

Identify your API key by editing the file docker-compose.yml as shown:

environment:
    CENSUS_APIKEY: Example-U6ufn1MMMFWPqMqMnOnRnaZcJ41aaqIM
    GOOGLE_API_KEY: Example-AIzaSyC6c_Example-fI8SuWZNE6AGX

About the Docker Container Environmenet

If you are not seeing your changes to the Docker environment (such as the database directory is not being used (images/mysql_data)) simply remove all the containers docker-compose rm and then restart with docker-compose up

Database

Create the directory /dev/shm/dsni_mysql to enable an in-memory database. To store the database on disk please create remove the symbolic link images/mysql_data then create a directory images/mysql_data. By default the database will temporarily reside within the docker container.

An example for creating the dsni user account. (Just use mysql-workbench)

INSERT INTO `mysql`.`user`
  (`Host`, `User`, `Password`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `Event_priv`, `Trigger_priv`, `Create_tablespace_priv`, `ssl_type`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`, `plugin`, `authentication_string`, `password_expired`)
VALUES
  ('%', 'dsni', '*D1DC3BBFB68E8F142AE83622634ECCFAF2B63D5B', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '0', '0', '0', '0', 'mysql_native_password', '', 'N');

Table Permissions for the dsni user account

INSERT INTO `mysql`.`db`
  (`Host`, `Db`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Execute_priv`, `Event_priv`, `Trigger_priv`)
VALUES
  ('%', 'dsni', 'dsni', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'N', 'N', 'Y', 'N', 'N');

The fastest way to get this done is to use MySQL-Workbench (in Docker, of course)

docker run \
    -it \
    -v /tmp/.X11-unix:/tmp/.X11-unix \
    -e DISPLAY=unix$DISPLAY \
    raphabot/mysql-workbench

Once the username is set up, you can enter the Docker container, and migrate the database:

docker exec -i -t dsnicensus_php_1 bash
cd /app
./artisan migrate --database=mysql-root --force

You should see:

Migration table created successfully.
Migrated: 2014_10_12_000000_create_users_table
Migrated: 2014_10_12_100000_create_password_resets_table
Migrated: 2015_12_06_064245_create_sessions_table

Assets

Code will be required for the container php to initialize its assents and environement. Surely this can be done outside of the environemnt, but we are not requiring the host operating system to install npm, gulp, bower, git, and etc.. Therefore, you'll want to run these commands to get your javascript up and running with your laravel framework.

✔ ~/Development/dsni/dsni_census [master L|●4✚ 3…1]
04:00 $ docker exec -i -t dsnicensus_php_1 ../start.sh dependencies
Running Dependencies Within Container Directory: /app
[9.1MB/0.07s] Loading composer repositories with package information
[9.5MB/0.08s] Installing dependencies (including require-dev) from lock file
[11.1MB/0.11s] Nothing to install or update
[9.8MB/0.11s] Generating autoload files
[10.7MB/0.41s] > php artisan clear-compiled
[10.7MB/0.53s] > php artisan optimize
Generating optimized class loader
[10.7MB/2.22s] Memory usage: 10.74MB (peak: 11.62MB), time: 2.22s
[8.1MB/0.05s] Generating optimized autoload files
[8.9MB/1.15s] Memory usage: 8.89MB (peak: 12.23MB), time: 1.15s
[09:02:26] Using gulpfile /app/gulpfile.js
[09:02:26] Starting 'default'...
[09:02:26] Starting 'sass'...

Fetching Sass Source Files...
   - resources/assets/sass/app.scss


Saving To...
   - public/css/app.css

[09:02:27] Finished 'default' after 360 ms
[09:02:27] Finished 'sass' after 423 ms
[09:02:27] Starting 'scripts'...

Fetching Scripts Source Files...
   - resources/assets/bower/jquery/dist/jquery.min.js
   - resources/assets/bower/bootstrap/dist/js/bootstrap.min.js


Saving To...
   - public/js/vendor.js

[09:02:27] Finished 'scripts' after 424 ms
[09:02:27] Starting 'scriptsIn'...

Fetching ScriptsIn Source Files...
   - citysdk/js/**/*.js


Saving To...
   - public/js/all.js

[09:02:27] Finished 'scriptsIn' after 44 ms

Generating optimized class loader
Nothing to migrate.
....

Filesystem

The filesystem changes within or around the docker-compose environment(s) then please see the script: start.sh

About the Laravel PHP Framework

Laravel is a web application framework with expressive, elegant syntax. Great documentation for the framework can be found on the Laravel website.

License

The Laravel framework is open-sourced software licensed under the MIT license