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

SBYC Openning Day 2020 on J70 Escape

Talk about wind. There were gusts just before the race of 33 mph! We played it safe with the kite and still hit above 15.5 km/h or on my Garmin Fenix 6, 18.3 mph surfing a wave downwind. Sailed course A8 or St-Ap-Gt-Bp-Xp-Dp-Fin …..6.65

SBYC Opening Day 2020

Sail Log

Date

Vessel Name/Type/Model

Course/Sea Miles

Coure

Total Sailed: 14.78 mi

Notes

Very windy. Winds close to 20 mi and gusts close to 30mi. We has one wave surf that got us up to 15+ nm/hr with just jib and main.

We made it around with no damage or harm.

Who sailed or my position on the vessel

  1. Boat Owner/Skipper
    1. Me

  2. Crew
    1. Jenn

    2. Mike F.

    3. Max

    4. Nicole

Weather

FZUS56 KLOX 011708
CWFLOX
Expires:202003012315;;331955

Coastal Waters Forecast
National Weather Service Los Angeles/Oxnard CA
908 AM PST Sun Mar 1 2020

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


PZZ650-012315-
East Santa Barbara Channel from Pt. Conception to Pt. Mugu CA
including Santa Cruz Island-
908 AM PST Sun Mar 1 2020

...GALE WARNING IN EFFECT THROUGH LATE TONIGHT...

.TODAY...W winds 25 to 30 kt with gusts to 35 kt. Combined seas 8 to
9 ft dominant period 10 seconds.
.TONIGHT...NW winds 20 to 30 kt with local gusts to 35 kt, becoming
15 to 20 kt with local gusts to 25 kt after midnight. Strongest
western portion. Combined seas 9 to 11 ft dominant period 11 seconds,
subsiding to 6 to 8 ft dominant period 11 seconds after midnight.
Slight chance of showers in the evening.

Sail Trace (Strava)

Video/Pictures

SBSC Opening Day 2020

Sail Log

Date

Feb. 29th 2020

Vessel Name/Type/Model

Course/Sea Miles

5 short windward/leewards

Got 4-4-3-4-1

The the first race we should have gotten a 2nd. I did not stear properly for the takedown for our team. The last race was awesome. Second around the first mark. Bunched up at the last mark. The mexican was ughly but very effective. Nothing like a first to finish a day. I hope my team remembers how it feels to win against good sailors.

Notes

Who sailed or my position on the vessel

  1. Boat Owner/Skipper
    1. Me

  2. Crew
    1. Jenn

    2. Mike F.

    3. Galin

Weather

FZUS56 KLOX 291118
CWFLOX
Expires:202002291800;;270350

Coastal Waters Forecast
National Weather Service Los Angeles/Oxnard CA
318 AM PST Sat Feb 29 2020

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


PZZ650-291800-
East Santa Barbara Channel from Pt. Conception to Pt. Mugu CA
including Santa Cruz Island-
318 AM PST Sat Feb 29 2020

...SMALL CRAFT ADVISORY IN EFFECT FROM THIS AFTERNOON THROUGH LATE
TONIGHT...
...GALE WARNING IN EFFECT FROM LATE TONIGHT THROUGH SUNDAY EVENING...

.TODAY...SW winds 5 to 10 kt, becoming W 10 to 20 kt in the
afternoon, except 15 to 25 kt western portion. Combined seas 2 to 3
ft dominant period 12 seconds, building to 3 to 5 ft dominant period
12 seconds in the afternoon. Patchy fog in the morning.

Sail Trace (Strava)

Video/Pictures