search

AFSC-Shellfish-Assessment-Program / boreal-opie

0 stars 0 forks source link

Connect R to oracle station data #1

Closed mikelitzow closed 2 years ago

mikelitzow commented 2 years ago

@JonRichar-NOAA

Can you please put together a script that will open the oracle station data in R so we can access all available bottom temp, station ID, date, and lat-long data? No need to select those data in particular, I'm just looking for a connection to the full oracle table that contains those data.

Emily Markowitz might be a really good resource on that. Thanks!

JonRichar-NOAA commented 2 years ago

I now have a working script that pulls data from Oracle, using the ROracle package. Please note anyone who wants to run it will need to get their own Oracle username and password. The latest version of this script has been added to the scripts folder.

When the time comes for others to set up, the OFIS contact who handled things was Kevin Bornemann with substantial help from David Weekley.

mikelitzow commented 2 years ago

Thanks!!