DeGAUSS pipeline that generates one CSV file of aggregated, monthly data for JFS from a geocoded CSV file
-
In Docker Desktop, in the top blue search bar, search for "degauss/jfs_data" and "Pull" the container
-
After pulling, navigate to "Images", find degauss/jfs_data and click "Run". In the popup box, expand the options and in the space marked "Local Host", type in "3838" and click Run
-
Navigate to the Containers page and select degauss/jfs_data. Towards top of the screen, click on the blue link that says "3838:3838" to launch the app.
-
Now that you're in the app, you can upload your .csv file
-
After the upload, the app will show you a sample of your original file and the prepared file for use in the next program
-
Click the button to download the prepped file. Save the downloaded file to a known location that you can navigate to (such as your downloads folder)
-
Now in PowerShell, navigate to your Downloads folder (it may be as simple as typing "cd Downloads")
-
Copy & paste the first Docker command into PowerShell and hit enter
-
Repeat for the 2nd and 3rd Docker commands, all in the Downloads folder
-
After the 3rd command, you should have the final output, "monthly_report_v5.0.1.csv" that you can send along to Cole & Andrew
- Screening status
SCREENED IN AR
included withSCREENED IN
- Intakes that either have no listed address or were unsuccessfully geocoded will be included as a "neighborhood" called
Missing
- census tract-level deprivation index from 2015 ACS measures
- census tract-level population under age 18 from 2018 ACS
00_create_tract_to_neighborhood.R
(based on code from Stu) makestract_to_neighborhood.rds
which is used to convert tracts to neighborhoods00_create_tract_to_neighborhood.R
also aggregates tract-level deprivation index (mean) and tract-level population under 18 (sum) to neighborhood and creates the neighborhood shapefile calledham_neighborhoods_dep_index_shp.rds
- Neighborhood level fields with values less than 5 have been censored for privacy considerations
For detailed documentation on DeGAUSS, including general usage and installation, please see the DeGAUSS README.