Prescription Drug Take-Back Box Locations County Drug and Alcohol Programs
Prescription Drug Take-Back Box Locations County Drug and Alcohol Programs
This dataset reports the site name, street address, city, county, zip code, telephone number, hours of availability, latitude, and longitude of Pennsylvania prescription drug take-back boxes as of May 2018. These monitored locations include police departments, courthouses, pharmacies, and hospitals/medical centers.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| City | city | city | Text | City |
| Location | location_1 | location_1 | Point | Number and street name location of prescription drug take-back site. Geocoded with latitude and longitude |
| Georeferenced Latitude & Longitude | geo | geo | Point | Georeferenced Latitude & Longitude Point field to help in creating mapping visuals. |
| Hours of Availability | hours_of_availability | hours_of_availability | Text | Hours of availability of prescription drug take-back site |
| County | county | county | Text | Geographic region in Pennsylvania of prescription drug take-back site. Pennsylvania has 67 counties. |
| Address | address | address | Text | Address |
| Longitude | longitude | longitude | Text | Longitude |
| Latitude | latitude | latitude | Text | Latitude |
| Phone Number | phone_number | phone_number | Text | Contact telephone number of prescription drug take-back site |
| Location 1 (zip) | location_1_zip | location_1_zip | Text | |
| Location 1 (address) | location_1_address | location_1_address | Text | |
| Location 1 (state) | location_1_state | location_1_state | Text | |
| Municipality Boundary | :@computed_region_amqz_jbr4 | :@computed_region_amqz_jbr4 | Number | |
| Pa School Districts (2017) | :@computed_region_rayf_jjgk | :@computed_region_rayf_jjgk | Number | |
| Pa House Districts (2017-01) | :@computed_region_r6rf_p9et | :@computed_region_r6rf_p9et | Number | |
| Pa Senatorial Districts (2017-01) | :@computed_region_d3gw_znnf | :@computed_region_d3gw_znnf | Number | |
| Pennsylvania County Boundaries | :@computed_region_nmsq_hqvv | :@computed_region_nmsq_hqvv | Number | |
| US House Districts for PA 2019 | :@computed_region_3x3q_vpda | :@computed_region_3x3q_vpda | Number | This column was automatically created in order to record in what polygon from the dataset 'US House Districts for PA 2019' (3x3q-vpda) the point in column 'geo' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. |
| State | state_fips | state_fips | Text | State Name |
| Location 1 (city) | location_1_city | location_1_city | Text | |
| Drug Take-Back Site | drug_take_back_site | drug_take_back_site | Text | Name of prescription drug take-back site |
| Zip Code | zip_code | zip_code | Text | Zip code location of prescription drug take-back site |