oceano app: "no observations were found"; + log all queries w/ response stats; + Shiny bookmark query state

[bbest]

from @evsatt:

I have been wanting to share Oceano's app with some of the folks I have been meeting about regarding utility for long term patterns related to Offshore Wind (e.g., showing a trend over time for temperature). But I can't easily get the CalCOFI data to load - it says "sorry no obs found". Am I doing something wrong?

This points to the very real need to:

• + Query Log
  Log all queries and basic stats on the response, but particularly for those queries which fail and need to be debugged.
• + Link to Shiny bookmark
  Also add a copy link button to return to the app to the same state (possible with Shiny Bookmarking).

[bbest]

Hi @evsatt ,

Sorry about the issue here, which I'm having trouble understanding and replicating. I see a contoured surface map, so not sure if it was for a different area or other setting not visible when you clicked Update. This points to the very real need to log all queries and basic stats on the response, but particularly for those queries which fail and need to be debugged. And ideally to also add a copy link button to return to the app in the same state (possible with Shiny Bookmarking).

Here's what I was able to successfully generate:

And some of the outputs from the bottom Downloads links:

oceano-app_query-5800caf2.zip

[evsatt]

Thanks! So it’s weird, I also can get the contour map (but it still has that repot message below (maybe residual). But I am trying to create a time series too and that gives an error too. Can send a screen shot if needed.

…

On Wed, Nov 29, 2023 at 8:55 AM Ben Best ***@***.***> wrote: Hi @evsatt <https://urldefense.com/v3/__https://github.com/evsatt__;!!Mih3wA!Etve7mN5wPEc6s4V6xoR5jYsv9OGR9KuQZZ0_OG0fVKy1oA8y6cW8M6CZ2sssKnHtVUal_uSrJKqh2sBijFk4-FV8U9Few$> , Sorry about the issue here, which I'm having trouble understanding and replicating. I see a contoured surface map, so not sure if it was for a different area or other setting not visible when you clicked *Update*. This points to the very real need to log all queries and basic stats on the response, but particularly for those queries which fail and need to be debugged. And ideally to also add a copy link button to return to the app in the same state (possible with Shiny Bookmarking <https://urldefense.com/v3/__https://mastering-shiny.org/action-bookmark.html__;!!Mih3wA!Etve7mN5wPEc6s4V6xoR5jYsv9OGR9KuQZZ0_OG0fVKy1oA8y6cW8M6CZ2sssKnHtVUal_uSrJKqh2sBijFk4-E1tBda6Q$> ). Here's what I was able to successfully generate: Screenshot.2023-11-29.at.10.51.27.AM.png (view on web) <https://urldefense.com/v3/__https://github.com/CalCOFI/apps/assets/2837257/6697111b-ac4a-4f6b-a78f-992cb63b0478__;!!Mih3wA!Etve7mN5wPEc6s4V6xoR5jYsv9OGR9KuQZZ0_OG0fVKy1oA8y6cW8M6CZ2sssKnHtVUal_uSrJKqh2sBijFk4-GbzsDJ3A$> And some of the outputs from the bottom Downloads links: oceano-app_query-5800caf2.zip <https://urldefense.com/v3/__https://github.com/CalCOFI/apps/files/13502652/oceano-app_query-5800caf2.zip__;!!Mih3wA!Etve7mN5wPEc6s4V6xoR5jYsv9OGR9KuQZZ0_OG0fVKy1oA8y6cW8M6CZ2sssKnHtVUal_uSrJKqh2sBijFk4-HUbNINlQ$> — Reply to this email directly, view it on GitHub <https://urldefense.com/v3/__https://github.com/CalCOFI/apps/issues/24*issuecomment-1832185480__;Iw!!Mih3wA!Etve7mN5wPEc6s4V6xoR5jYsv9OGR9KuQZZ0_OG0fVKy1oA8y6cW8M6CZ2sssKnHtVUal_uSrJKqh2sBijFk4-ERp2A6XQ$>, or unsubscribe <https://urldefense.com/v3/__https://github.com/notifications/unsubscribe-auth/AD356WJVLXNFLZBOAG4RRLTYG5LGVAVCNFSM6AAAAAA77WHPD6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZSGE4DKNBYGA__;!!Mih3wA!Etve7mN5wPEc6s4V6xoR5jYsv9OGR9KuQZZ0_OG0fVKy1oA8y6cW8M6CZ2sssKnHtVUal_uSrJKqh2sBijFk4-EfQriCZg$> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[bbest]

Yes please! I'll try to have this sorted by our meeting Wednesday

[evsatt]

Here is the error message: [image: image.png] Also, when I do get it to work with a different area, the year increments are incorrect (e.g., for "year" should have whole years not halves too).

…

On Wed, Nov 29, 2023 at 8:17 AM Ben Best ***@***.***> wrote: Yes please! I'll try to have this sorted by our meeting Wednesday — Reply to this email directly, view it on GitHub <https://urldefense.com/v3/__https://github.com/CalCOFI/apps/issues/24*issuecomment-1832226443__;Iw!!Mih3wA!CKkSi5Kwce4LsF1K7ASMS4MfZVU_XSUVdBlSc5lUCfCccA-gt-DcITpexjarBntv-4ojw50X729Uq4_kQpCYCQifh4h67g$>, or unsubscribe <https://urldefense.com/v3/__https://github.com/notifications/unsubscribe-auth/AD356WLTK6AEFTV3W4XBBWDYG5N2FAVCNFSM6AAAAAA77WHPD6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZSGIZDMNBUGM__;!!Mih3wA!CKkSi5Kwce4LsF1K7ASMS4MfZVU_XSUVdBlSc5lUCfCccA-gt-DcITpexjarBntv-4ojw50X729Uq4_kQpCYCQiorejAaQ$> . You are receiving this because you were mentioned.Message ID: ***@***.***>

-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Erin Satterthwaite | she/her Marine Ecologist & Sustainability Researcher CalCOFI Program Coordinator UC San Diego - Scripps Institution of Oceanography California Sea Grant & CalCOFI 9500 Gilman Dr., La Jolla, CA 92093-0232 *work: *(858) 380-5835 *Play is the highest form of research * * ~Albert Einstein*

[bbest]

Shiny Bookmarking in URL

Now the URL in the browser's location bar gets updated as the user changes input values, so the URL can be shared to return to the same state.

References:

• Chapter 11 Bookmarking | Mastering Shiny
• Shiny - Bookmarking and modules
• Shiny - Advanced bookmarking
• Bookmarking and restoring selected tabs | shinydashboard

Here are the URLs for two maps with entirely different inputs:

1. initial
   URL decoded: https://shiny.calcofi.io/oceano/?_inputs_&

   • aoi_cat="CalCOFI Zones"&
   • aoi_ewkt=null&
   • aoi_keys=["cc_nearshore-extended","cc_offshore-extended","cc_nearshore-standard","cc_offshore-standard"]&
   • aoi_rows=[1,2,5,6]&
   • hash="ffefc04c"&
   • map_center={"lng":-122.080078125,"lat":33.9068955512887}&
   • map_init=true&
   • map_zoom=6&
   • mapedit_counter=1&
   • num_depth_bins=10&
   • sel_date_range=["2015-01-25","2020-01-26"]&
   • sel_depth_range=[0,515]&
   • sel_qtr=["1","2"]&
   • sel_time_step="year"&
   • sel_val="avg"&
   • sel_var="ctd_bottles.t_degc"&
   • tabs="map"
   

2. modified
   URL decoded: https://shiny.calcofi.io/oceano/?_inputs_&

   • aoi_cat="CalCOFI Zones"
   • aoi_keys=null&
   • aoi_ewkt="SRID=4326;POLYGON ((-122.239895 34.052659, -120.120392 32.915188, -120.952606 34.803091, -122.239895 34.052659))"&
   • aoi_rows=null&
   • hash="0885655b"&
   • map_zoom=7&
   • map_center={"lng":-121.1801435,"lat":33.8643573446832}&
   • num_depth_bins=10&
   • sel_date_range=["2010-01-01","2019-01-01"]&
   • sel_depth_range=[120,1000]&
   • sel_place_category="CalCOFI Zones"&
   • sel_qtr=["3","4"]&
   • sel_time_step="year"&
   • sel_val="avg"&
   • sel_var="ctd_bottles.salinity"&
   • tabs="map"&
   • map_init=true&
   • mapedit_counter=2&
   

[bbest]

Logging with logger or loggit

Not sure logging is necessary now with bookmarkable URL, but # comments for logger and loggit included.

apps/oceano/global.R

Lines 8 to 18 in 560187f

	# logger, loggit,
	lubridate, plotly, png, readr, shiny, shinydashboard, shinyjs,
	stringr, webshot)
	# remotes::install_github("calcofi/calcofi4r", force=T) # install remote
	# devtools::install_local(here::here("../calcofi4r"), force=T) # install local
	# devtools::load_all(here("../calcofi4r")) # debug
	# loggit::set_logfile("/share/github/apps_dev/oceano/logs/loggit.log")
	# loggit::read_logs()
	# logger::log_appender(appender_file("/share/github/apps_dev/oceano/logs/logger.log"))
	# logger::log_appender()

apps/libs/functions.R

Lines 339 to 363 in 560187f

	# log_info(
	# list(get_map_data = list(
	# variable = variable,
	# value = value,
	# aoi_ewkt = aoi_ewkt,
	# aoi_keys = aoi_keys)))
	# loggit(
	# "INFO",
	# "get_map_data()",
	# data_json = jsonlite::toJSON(list(
	# variable = variable,
	# value = value,
	# aoi_ewkt = aoi_ewkt,
	# aoi_keys = aoi_keys,
	# date_beg = date_beg,
	# date_end = date_end,
	# date_qrtr = date_qrtr,
	# depth_m_min = depth_m_min,
	# depth_m_max = depth_m_max,
	# n_bins = n_bins,
	# return_type = return_type,
	# dir_cache = dir_cache,
	# clientData = clientData)) |>
	# as.character())

Skipping shinylogs since logging excessive and not customizable.

Surprisingly the client's IP address is not included in Shiny's session$clientData so can't easily include in log:

• Make client IP address available on clientData · Issue #141 · rstudio/shiny

[bbest]

Logging with Google Analytics

a bit complicated ...

• Shiny - Add Google Analytics
• R Shiny Google Analytics: How to Add GA to Shiny Apps - R programming
• Event tracking a Shiny application with Google Analytics - Hypebright
• Top 3 Tools to Monitor User Adoption in R Shiny
• Shuttle Thread