Alcohol Outlet Density Map

[jacobdadams]

Benefit

The DHHS Office of Substance Use and Mental Health prevention system is interested in mapping alcohol outlet density for the state, similar to what Colorado has done on this site: https://cdphe.colorado.gov/alcohol-outlet-density (click on the CO alcohol outlet density tab and scroll down to see several maps).

Acceptance Criteria

Map/Storymap/ExB with the following info:

1. Plot of all alcohol locations: A state map with county outlines and major cities and a dot for all alcohol outlets. If possible it might be nice to have a different color marker for the different types of outlets.
2. Alcohol outlet density: County areas shaded in lighter/darker color depending on the outlet density based on a designation of population (per 1,000 or 10,000 pop.).
3. Same thing as point 2, but by census tract or Utah health small areas?
4. Alcohol outlet density by square mile: County and census/small area maps with shading of rate based on area instead of population.
5. Crime rates overlayed with either location or one of the density maps. Want to see if more dense areas of alcohol outlets also have higher rates of crime.
6. Same thing as point 5 but with crash data.
7. Overlay of binge drinking rates with location or density map.
8. Average distance of person to nearest alcohol outlet done by county
9. Average distance of an outlet to its nearest neighbor outlet
10. Alcohol related emergency department visits overlayed on density map
11. Proximity of alcohol outlets to schools, public places, churches. Alcohol outlets need to be so far away from public places, a map that draws a circle around the public space and shows the outlets within the proximity, or the other way, the circle around the outlet with markers for the public places.

Notes

Contact: David Watkins, [email protected]

Would this be something that UGRC could help us develop?

I'll provide a list and description of the maps/layers we are interested in having created. Depending on cost and difficulty, we don't need to have all of these maps created, but we do want to see what it might take to make them happen, and if they all can be that would be great.

We don't have a specific timeline, at the very latest I think it would be great to have these maps created before next year's legislative session, so anywhere between now and January works for us.

We may need to gather, but we can provide alcohol related data, including pulling location information and getting them geocoded. I don't know anything about the Utah Health Promotion ArcGIS Online, but if it can be hosted there I think that would work for us. Does that give us the option to put the maps on our own website/dashboard if we wanted to, or would it only live on that website?

Risks

No response

Issue Reference

refs #

[jacobdadams]

Contact: David Watkins, [email protected]

[stdavis]

Dropping to uncommitted for FY25Q2 because its still in the ideation stage.

[jacobdadams]

24.2.4

Met with David, reviewed the scope. We'll put together a scope of work based on the points listed above. David is going to investigate sources for crash, crime, ER, and binge drinking data; if he can't find them, we won't include them. Planning on reconnecting after Thanksgiving.

• @jacobdadams: Find DOH/DHHS AGOL org admin and see if we can get a login
• @jacobdadams: Put together a scope of work for Laura