Bears Ears National Monument and Outdoor Recreation in San Juan County, Utah

The data and code provided here allow for a focused look at the influence of the creation, and subsequent downsizing, of Bears Ears National Monument on outdoor recreation and industries related to outdoor recreation in San Juan County, Utah. Our analysis is reported full in Smith, Wilkins, and Miller (2021).<br><br>Reference:<br>Smith, J. W., Wilkins, E. J., &amp; Miller, A. B. (2021). Bears Ears National Monument and outdoor recreation in San Juan County, Utah. Society &amp; Natural Resources, 34(7), 966-979.<br><br><b>GUIIDE TO ANALYSIS AND FILES<br></b><b>Python<br></b><b>flickr_download_benm.py:</b> This code downloads all flickr posts within a bounding box that includes San Juan County, Utah.<br><b><br>R Markdown<br></b><b>clip_flickr_and_genreate_flickr_PUD_031921.Rmd:</b> This file reads in the flickr data, clips it to a 5km buffer around the county, generates a 5km grid over the study area (county + 5km buffer), and identifies unique photo user days (puds) for each 5km grid cell.<br><b><br>spatial_files.zip<br></b>Zip file containing:<br><b>san_juan_county.shp:</b> Shapefile for the boundary of San Juan County, Utah.<br><b><br>stata_files.zip<br></b>Zip file containing:<br><b>data_cleaning_pud.do:</b> Stata do file for reading in the PUD data, converting dates to Stata readable format using datetime, generating project-specific period codes, reading in the monthly_flickr_posts_utah.dta file, and generating summary statistics for the project-specific periods.<br><b><br>adding_econ_variables_regressioins.do:</b> Stata do file for generating summary statistics by quarter, dropping duplicate months, and reading in the bls_data.dta file.<br><b><br>monthly_flickr_posts_utah.dta:</b> Stata data file with summary statistics of all flickr posts within Utah between January 2004 and December 2019.<br><b><br>bls_data.dta:</b> Stata data file with all jobs, wages, payroll, and establishment data for San Juan County, Utah from January 2014 to December 2019. See bls_industry_key.csv for the key to reading the industry variable names.<br><b><br>quarterly_flickr_pud_utah_w_econ.dta:</b> Stata data file of quarterly flickr and bls data ready for regression analyses.<br><br><b>csv<br></b><b>BENM_SJC.csv: </b>CSV file of all Flickr posts within San Juan County, Utah. This is generated through the flickr_download_benm.py script.<br><br><b>monthly_flickr_posts_utah.csv: </b>CSV file with summary statistics of all flickr posts within Utah between January 2004 and December 2019.<br>

本文提供的数据集与代码可用于聚焦分析犹他州圣胡安县内，熊耳国家纪念碑（Bears Ears National Monument）的设立及后续缩界对户外休闲活动及相关产业的影响。本研究的完整分析成果已发表于Smith、Wilkins与Miller（2021）的研究中。

**参考文献**：
Smith, J. W., Wilkins, E. J., & Miller, A. B. (2021). 犹他州圣胡安县的熊耳国家纪念碑与户外休闲活动. 《Society & Natural Resources》, 34(7), 966-979.

**分析与文件指南**
**Python**
**flickr_download_benm.py**：本代码用于下载涵盖犹他州圣胡安县的边界框内的所有Flickr帖子。

**R Markdown**
**clip_flickr_and_genreate_flickr_PUD_031921.Rmd**：本文件用于读取Flickr数据，将其裁剪至该县周边5公里缓冲区范围，在研究区域（县界+5公里缓冲区）生成5公里网格，并为每个5公里网格单元识别唯一的照片用户日（Photo User Days, PUDs）。

**spatial_files.zip**：压缩包内含：
**san_juan_county.shp**：犹他州圣胡安县边界的形状文件（Shapefile）。

**stata_files.zip**：压缩包内含：
**data_cleaning_pud.do**：Stata do文件，用于读取PUD数据，使用datetime命令将日期转换为Stata可识别格式，生成项目专属时段代码，读取monthly_flickr_posts_utah.dta文件，并为项目专属时段生成汇总统计量。
**adding_econ_variables_regressioins.do**：Stata do文件，用于按季度生成汇总统计量，剔除重复月份数据，并读取bls_data.dta文件。
**monthly_flickr_posts_utah.dta**：Stata数据文件，包含2004年1月至2019年12月间犹他州境内所有Flickr帖子的汇总统计数据。
**bls_data.dta**：Stata数据文件，包含2014年1月至2019年12月间犹他州圣胡安县的全部就业、薪资、薪酬及经营机构数据，行业变量名称的解读指南可参阅bls_industry_key.csv。
**quarterly_flickr_pud_utah_w_econ.dta**：Stata数据文件，包含季度级Flickr及相关经济数据，可直接用于回归分析。

**CSV文件**
**BENM_SJC.csv**：包含犹他州圣胡安县境内所有Flickr帖子的CSV文件，该文件通过flickr_download_benm.py脚本生成。
**monthly_flickr_posts_utah.csv**：包含2004年1月至2019年12月间犹他州境内所有Flickr帖子的汇总统计数据的CSV文件。