SBYC Wet Wednesday 2020 Summer 5

Sail Log

Date

Vessel Name/Type/Model

Escape/ J/70

Course/Sea Miles

Sailed dock to dock: 12.94 mi

Course: A-10 5.63 nm

Notes

Who sailed or my position on the vessel

  1. Boat Owner/Skipper
    1. Me

  2. Crew
    1. Erik

    2. Max

Weather

Start: Mostly cloudy, 68°F, Feels like 67°F, Humidity 67%, Wind 8mph from WSW
End: Partly sunny, 67°F, Feels like 67°F, Humidity 70%, Wind 10mph from WSW - by Klimat.app

Sail Trace (Strava)

Race Qs for WetWednesday

Video/Pictures

John 8:7

John 8:7 NABRE But when they continued asking him, he straightened up and said to them, “Let the one among you who is without sin be the first to throw a stone at her.”[1]

References

Pretending it is Wet Wednesday 20200401 (Single Handing again)

Sail Log

Date

April 1, 2020

Vessel Name/Type/Model

Escape J/70

Course/Sea Miles

Sailed dock to dock: 8.07 mi

Notes

Sort of swelly (yes that is a technical term). Light winds. Single handed again.

There is no such thing as social distancing on a J/70. It is single handed or not at all. As one sailor said, it is BYOB (bring your own boat).

Weather

Forecast
WHUS76 KLOX 011611
MWWLOX

PZZ645-020015-
/O.EXT.KLOX.SC.Y.0048.000000T0000Z-200402T1700Z/
Point Piedras Blancas to Point Sal westward out to 10 NM-
911 AM PDT Wed Apr 1 2020

...SMALL CRAFT ADVISORY NOW IN EFFECT UNTIL 10 AM PDT THURSDAY...

* WHAT...Hazardous sea conditions.

* WHERE...Point Piedras Blancas to Point Sal westward out to 10
  NM.

* WHEN...Until 10 AM PDT Thursday.

* IMPACTS...Conditions will be hazardous to small craft.

* ADDITIONAL DETAILS...See the Coastal Waters Forecast (CWFLOX).

PRECAUTIONARY/PREPAREDNESS ACTIONS...

Inexperienced mariners, especially those operating smaller
vessels, should avoid navigating in hazardous conditions.
...SMALL CRAFT ADVISORY IN EFFECT FROM 3 PM PDT THIS AFTERNOON
THROUGH LATE TONIGHT...

.TODAY...Western portion, NW winds 10 to 20 kt becoming 20 to 30 kt
in the afternoon. Eastern portion, S winds 5 to 10 kt becoming SW 10
to 15 kt in the afternoon. Combined seas 3 to 5 ft dominant period 8
seconds, building to 5 to 7 ft in the afternoon.
.TONIGHT...Western portion, NW winds 20 to 30 kt becoming 10 to 20
kt late. Eastern portion, SW winds 10 to 15 kt becoming variable 10
kt or less after midnight. Combined seas 5 to 7 ft dominant period 8
seconds. Patchy fog after midnight.
.THU...N winds 5 to 15 kt , becoming W 15 to 25 kt in the afternoon.
Combined seas 5 to 7 ft dominant period 9 seconds. Patchy fog in the
morning.
Sort of Actual

Start: Sunny, 62°F, Feels like 66°F, Humidity 80%, Wind 12mph from SE

End: Sunny, 63°F, Feels like 65°F, Humidity 75%, Wind 8mph from SE

Sail Trace (Strava)

Video/Pictures

/images/2020/sdwb.thumbnail.jpg

Monday Hooky Single handed sail 20200323

Sail Log

Date

March 23, 2020

Vessel Name/Type/Model

Escape/ J/70

Course/Sea Miles

Sailed dock to dock: mi 7.78

Notes

I was going to take Escape out of the ocean, but weather was nice. Good personal skill building since I had to do all tasks myself. As a boat owner/skipper, it is important to be able to do it all. This is making realise how much I depend on my crew.

Weather

(not available)

Sail Trace (Strava)

/images/2020/sdwb.thumbnail.jpg

Sat 3/21 Single handing goodness

Sail Log

Date

March 21, 2020

Vessel Name/Type/Model

Escape/ J/70

Course/Sea Miles

Sailed dock to dock: 10.12 mi

Notes

With the COVID-19 (Wuhan Virus). Sailing may be over. Except for some very small boats such as harbors, lasers, RSs it is hard to do social distancing.

As I tell my crew, unless you are willing to get cozy, you have no business being on a J/70 while racing.

What was good about this sail was a renewed appreactiation for seamanship, expecting perfection in rigging, boat trim.

I brought up the topic of rigging. I made too mistakes. I did not put the backstay trim under the traverler. Also, the starbord jib sheet (yes, I know the jib sheet is continuous) went throught the rachet block the wrong way.

Who sailed or my position on the vessel

Just me! Single handed the boat.

Weather

FZUS56 KLOX 211504
CWFLOX
Expires:202003212230;;840660

Coastal Waters Forecast
National Weather Service Los Angeles/Oxnard CA
804 AM PDT Sat Mar 21 2020

Point Piedras Blancas to San Mateo Point CA out 60 NM including the
Channel Islands National Marine Sanctuary


PZZ650-212230-
East Santa Barbara Channel from Pt. Conception to Pt. Mugu CA
including Santa Cruz Island-
804 AM PDT Sat Mar 21 2020

.TODAY...Winds variable 10 kt or less, becoming S 10 kt in the
afternoon. Wind waves 2 ft or less. W swell 2 ft at 7 seconds.
.TONIGHT...SW winds 5 to 10 kt, becoming E after midnight. Wind
waves 2 ft or less. W swell 2 ft at 10 seconds. Slight chance of
rain after midnight.

Sail Trace (Strava)

Video/Pictures

/images/2020/sdwb.thumbnail.jpg

Efficient data exists in table Oracle PL/SQL

Part of my work is writing functions that test if a user is part of a population (set math) The database I work with in the grand scheme is not particular large, but large in its own right. Some rows can be in the millions.

Being me, instead of doing real work, plus having the experience of a Moodle plugin designer who’s module would crash computers and tell me that it worked for him on his laptop, I looked up how to produce a function that is efficient.. I have found two ways to do this. One from stackoverflow, the other method that is used a lot in Ellucian Banner.

I am going to list a function that I wrote in both ways. The logic suited the need of my employer.

StackOverflow method:

FUNCTION is_enrolled (pin_pidm  SATURN.sfrstcr.sfrstcr_pidm%TYPE) RETURN VARCHAR2 AS
   l_count NUMBER;
BEGIN
select count(1) into l_count

        FROM sfrstcr
        INNER JOIN stvrsts ON sfrstcr_rsts_code = stvrsts_code
                WHERE sfrstcr_term_code in (
          SELECT stvterm_code from stvterm where stvterm_code <> '999999' AND stvterm_end_date >= SYSDATE)
          and sfrstcr_pidm = pin_pidm;
        IF l_count > 0
        THEN
          RETURN 'Y';
        ELSE
          RETURN 'N';
        END IF;

END is_enrolled;

Banner Method:

-- Ellucian prefers to return boolian, I need to return (Y/N). They also like cursors
FUNCTION is_enrolled (pin_pidm  SATURN.sfrstcr.sfrstcr_pidm%TYPE) RETURN VARCHAR2 IS
   student_found VARCHAR2(1);
   student_exists VARCHAR2(1);
   CURSOR found_student_c
   IS
        select 'X'
                        FROM sfrstcr
                        INNER JOIN stvrsts ON sfrstcr_rsts_code = stvrsts_code
                        WHERE sfrstcr_term_code in (
                                SELECT stvterm_code from stvterm where stvterm_code <> '999999' AND stvterm_end_date >= SYSDATE)
                        and sfrstcr_pidm = pin_pidm;
BEGIN
        OPEN found_student_c;
        FETCH found_student_c INTO student_found;
        CLOSE found_student_c;
        IF student_found = "X" THEN
        THEN
          student_exists := 'Y';
        ELSE
          student_exists := 'N';
        END IF;
        RETURN student_exists;
END is_enrolled;

Personally, I am not sure which is better, but, I might as well do it the Banner way, instead of always trying to reinvent the wheel or borrow some else's wheel.

SBYC Wet Wednesday 2020 Fun 1

Sail Log

2020 Personal Sail Log Summary

Date

March 11, 2020

Vessel Name/Type/Model

Escape J/70

Course/Sea Miles

Sailed dock to dock: 7.62 mi

Course: K2 St-Kp-Gt-Bp-Fin 2.54 nm

Notes

Who sailed or my position on the vessel

  1. Boat Owner/Skipper
    1. Me

  2. Crew
    1. Jenn

    2. Max

    3. Erik

Weather

FZUS56 KLOX 110918
CWFLOX
Expires:202003111645;;306406

Coastal Waters Forecast
National Weather Service Los Angeles/Oxnard CA
218 AM PDT Wed Mar 11 2020

Point Piedras Blancas to San Mateo Point CA out 60 NM including the
Channel Islands National Marine Sanctuary


PZZ650-111645-
East Santa Barbara Channel from Pt. Conception to Pt. Mugu CA
including Santa Cruz Island-
218 AM PDT Wed Mar 11 2020

.TODAY...SE winds 5 to 10 kt. Wind waves 2 ft or less. W swell 2 to
3 ft at 9 seconds. S swell 2 ft. Chance of showers and slight chance
of tstms.
.TONIGHT...NW winds 10 kt in the evening, becoming variable 10 kt or
less. Wind waves 2 ft or less. W swell 2 ft at 12 seconds. S swell
2 ft. Slight chance of tstms in the evening.

Sail Trace (Strava)

Video/Pictures