Skip to content

Ancillary Scripts

Christy Lam edited this page Sep 20, 2024 · 4 revisions

Pre-processing scripts to run once, until a new dataset is updated

1. convert-shps-to-rda.R

Instead of connecting directly to the data portal, read in shapefiles and export everything to a .rda file. If any shapefiles get updated, re-run script. Save a copy of the .rda to X:/DSA/shiny-uploads/community-profiles/data/community_profile_shapes.rda

2. compile-raw-chas.R

Download the CHAS data and run script to munge it into an Elmer-friendly format.

3. disp-risk-to-sqlite.R

Exports CHAS views from Elmer to a stand-alone SQLite database. This allows the app to be publicly available.

4. compile-rdi-for-download.R

Exports the RDI related data by jurisdiction to excel workbooks, similar to the ACS versions.

5. census_data_profiles.py

Exports profiles by jurisdiction to excel workbooks. Will need to create a copy of the profile notes script and save is as the latest year.

6. download_data_place.R

Creates two files: census_data_by_place.csv & jurisdictions.csv'