About this Application

• Enter a shapefile, and this R Shiny web application will return all wells in the California Online State Well Completion Report Database (OSWCR) that fall within that shapefile.
  
• Please note that the wells returned by this interface are a cleaned version of OSWCR, containing nearly 900,000 well reports. The steps used in the cleaning of this database are detailed here).
  
• More wells may have been added to the database since the publication of this application, and can be obtained from the California Department of Water Resources at this location.
  
• The code for this project can be found in this Github repository.

How to Use this Application

See this online instructional video that accompanies the written instructions below.

On the Database Search Tab:

1. click Upload Shapefile. A popup window will appear.
   
2. Enter the 6 required shapefile components (.dbf, .prj, .sbn, .sbx, .shp and .shx), which can be done all at once by selecting multiple files.
   
3. Click on Clip Points to shapefile to preform the clip, then close the window by clicking close in the lower right corner.
   
4. Your clipped data will appear on the interactive map. Click on the numeric map marker to zoom into your area.
   
5. Click on individual markers to access particular information about the well, including a link to download a PDF of the well completion report.
   
6. Click on Download clipped data in the left hand toolbar to download a .csv of the clipped data points with all fields.
   

Contact Information

Rich Pauloo, PhD Candidate | University of California Davis
Github | Website | LinkedIn

For questions specific to UC Water, please contact Graham Fogg [gefogg at ucdavis dot edu].
For questions about this web application, please contact Rich Pauloo [richpauloo at gmail dot com].

Acknowledgments

In no particular order, I would like to thank:

• Ben Breezing and the California Department of Water Resources for their assistance with data
  
• the University of California Office of the President for the UC Water Security and Sustainability Research Initiative
  
• Matthew Leonawicz for his open source R web apps that helped with building this app
  
• Omen Wild, computer guru Sys Admin extraordinaire for his insight and help in configuring our servers to launch this app.