Update Prison Data with Distance to Other Facilities

[lindsaypoirier]

Here we will create a new csv that appends to the prisons data columns that designate other types of facilities within 5000 meters, along with their distances to the prison. This will be done for:

• airports
• military bases
• superfund sites
• ...

So for one row in the prisons dataset, there will be several new columns:

• closest_airport_1
• closest_airport_1_dist
• closest_airport_2
• closest_airport_2_dist
• closestairport...
• closestairport..._dist
• closest_airport_5
• closest_airport_5_dist

The later columns will be set to 0 (perhaps this should be null) if there aren't 5 airports within 5000 meters. This will be the case for most rows; most only have one.

We will repeat the same strategy adding columns for closest__1 and closest___1_dist for each facility type listed above.

[lindsaypoirier]

The script for airports is complete and should be easy to amend for other sites.

see:

• find_objects_proximate_prisons.R
• prisons_with_airports.csv

...in proximity-app folder

[lindsaypoirier]

This is done; see: cleaning_scripts/find_objects_proximate_prisons.R

The data is structured a bit differently than described above. Each row is a carceral facility and a proximate object, with variables including the object's ID, its site_type, its ranking of distance to the facility, and its distance to the facility.

The resulting data frame is in data-clean/prisons_with_facility_distances.csv