Saturday, December 22, 2007

Full Moon Hash - 21 Dec 2007

Doggie Style
from Duke's Station at Baptist Rd, into South Park.

first beer stop, a collapsed shelter.
second beer stop, beer hops tavern in a shopping center.

true trail

Friday, December 21, 2007

Vintage shorts from the 70's

Bouldering between Palena and Colledimacine, Abbruzzi, Italy, 1100 meters altitute, YMCA camp in 1979.




Monday, December 17, 2007

Dick-a-Day hash at PanHandle Trail trailhead

In the first blast of winter of the year, three beerstops. Terrain was all in the woods, some slag, some pipeline, powerlines. Moon helped setting ribbons. Otherwise it was pink flouron trees.

True Trail

Sunday, December 9, 2007

Flicker's hash in White Oak county park




Started at 12 (noon) because of the Steelers came playing undefeated New England. We had one santa.
true trail

Monday, November 19, 2007

Evergreen Hash Nov 2007

The trail took us on a catholic industrial complex, and there it was, in neat order, rows and rows of beautiful shining white marble tombstones of Sister this and Sister that served.



Kind of a reminder of the hash near LaRoche College, where the Halloween Hash took us near the nunnary cemetery:



... since we are collecting nun cemeteries now, let me add the satellite image of one that was found by chance while placing a geocache in Bellevue, site of the Sisters of the Holy Family of Nazareth, visible on the right side of I-279 behind a long red brick wall while traveling north, wall at the base of which Moon, Norton, Swamp Bitch and Golden Showers emerged from a 20" high culvert as they scouted an orifice during Norton's inaugural hash as hare in 2005.

Tuesday, November 13, 2007

Tuesday, October 30, 2007

Halloween 2007 Hash

sh.t trail, awesome area 51 beer stop

I had no idea it was "Plush Animal Lover's Day". telepathy, i guess. some higher entity must be at play here to have made this happen...
I googled "Plush Animal Lover's Day" and all the hits came out as Oct
28, so by internet-applause- meter, it must be correct.

true trail

Wednesday, October 10, 2007

Tuesday, October 2, 2007

Great Race runner analysis methodology

Copied the results from the website, 100 runners at a time, and pasted them in an Excel spreadsheet. Saved the file in comma delimited format (.CSV). Then, used SQL Server 2000 to import the data.

Massaged and changed some of the data, as to replace NULL values in names, cities, states. Replaced single quotes with empty string.

update RunnerRaw set
Col004 = 'Unknown'
where Col004 IS NULL
go
update RunnerRaw set
Col005 = 'UK'
where Col005 IS NULL
go
update RunnerRaw set
Col008 = 'U'
where Col008 IS NULL
go
update RunnerRaw set
Col002 = (select replace(Col002,'''',''))

update RunnerRaw set
Col003 = (select replace(replace(Col003,'''',''),' ',''))

update RunnerRaw set
Col003 = (select replace(Col003,'Sr.',''))

update RunnerRaw set
Col003 = (select replace(Col003,'Jr.',''))

update RunnerRaw set
Col003 = (select replace(Col003,'St.','St. '))

update RunnerRaw set
Col004 = (select replace(replace(replace(Col004,'''',''),'.',''),',',''))

CREATE VIEW RunnerRawV
AS
select
CAST(Col001 as Integer) as 'Bib',
UPPER(Col002) as 'First',
UPPER(Col003) as 'Last',
UPPER(Col004) as 'City',
UPPER(Col005) as 'State',
UPPER(Col006) as 'Country',
CAST (Col007 as INTEGER) as 'Age',
UPPER(Col008) as 'Gender',
Col009 as 'ChipTime',
Col010 as 'ClockTime',
Cast(SubString (Col009, 1, 1) as Integer) * 3600 + CAST(SubString (Col009, 3, 2) as Integer) * 60 + CAST(SubString (Col009, 6, 2) as Integer) as 'TotalChipSeconds',
Cast(SubString (Col010, 1, 1) as Integer) * 3600 + CAST(SubString (Col010, 3, 2) as Integer) * 60 + CAST(SubString (Col010, 6, 2) as Integer) as 'TotalClockSeconds'
from RunnerRaw

CREATE Table Runner
(
Bib integer NOT NULL,
First varchar (20) NOT NULL,
Last varchar (30) NOT NULL,
City varchar (30) NOT NULL,
State char (2) NOT NULL,
Age Integer NOT NULL,
Gender char (1) NOT NULL,
ChipTime char (7) NOT NULL,
ClockTime char (7) not null,
TotalChipSeconds int not null,
TotalClockSeconds int not null
)

select 'INSERT INTO Runner (Bib, First, Last, City, State, Age, Gender, ChipTime, ClockTime, TotalChipSeconds, TotalClockSeconds) VALUES (' + CAST(Bib AS VARCHAR) + ',''' + LTRIM(RTRIM(First)) + ''',''' + LTRIM(RTRIM(Last)) + ''',''' + LTRIM(RTRIM(City)) + ''',''' + LTRIM(RTRIM(State)) + ''',' + CAST (Age AS VARCHAR) + ',''' + LTRIM(RTRIM(GENDER)) + ''',''' + LTRIM(RTRIM(ChipTime)) + ''',''' + LTRIM(RTRIM(ClockTime)) + ''',' + CAST (TotalChipSeconds AS VARCHAR) + ',' + CAST (TotalClockSeconds AS VARCHAR) + ')'
from RunnerRawV

select State, Replicate ('*', count(State) / 2)
from Runner
where State <> 'PA'
group by State
order by count(State) desc

select avg (totalclockseconds - totalchipseconds) from Runner

select count (First), First
from Runner
where Gender = 'F'
group by First
order by count(First) desc

select distinct First from Runner where Gender = 'F' and First in (select first from Runner where Gender = 'M')

select AVG (CAST (age as float)) from Runner where gender = 'F'

select totalclockseconds - totalchipseconds, *
from Runner
order by totalclockseconds - totalchipseconds desc

select TotalClockSeconds - TotalChipSeconds , * from Runner where TotalClockSeconds - TotalChipSeconds > 400
order by TotalClockSeconds - TotalChipSeconds desc

Monday, October 1, 2007

Great race Runner Analysis

total number of runners: 5550
2566 runners were residents of Pittsburgh city
23 runners were residents of Morgantown city
5 runners were residents of Cleveland city
3 runners were residents of Philadelphia city
0 runners were residents from outside the United States and Terrorties, and Canada

number of men running: 3321
number of women running: 2229

throwing out 5% at both tail's ends:
average finish time of men: 53'03"
average finish time of women: 58'39"

number of runners under age of 14: 80
number of runners under age of 18: 280
number of runners under age of 21: 440 (8% of total running population)

average age of men: 39.4
average age of women: 34.4

age distribution of men

8 *
9 *
10 **
11 **
12 ****
13 **************
14 ************
15 **************
16 ******************
17 *************
18 *********
19 *********
20 **********************
21 **************************
22 ***********************
23 ****************************
24 ********************************
25 **********************************
26 *********************************************
27 *******************************************
28 ***************************************
29 *****************************************
30 *****************************************
31 *****************************************
32 ************************************************
33 *************************************
34 *************************************
35 **************************************
36 ************************************************
37 **********************************************
38 *******************************************
39 **************************************
40 ************************************
41 ***************************************
42 ********************************
43 **********************************
44 ***********************************
45 ************************************
46 ****************************************
47 ********************************
48 **************************************************
49 **********************************************
50 ****************************************
51 *******************************************
52 ***********************************
53 ***************************************
54 **************************************
55 ***************************
56 *************************
57 *********************
58 ****************************
59 ********************
60 *************************
61 ************
62 ************
63 *****
64 ************
65 ********
66 *****
67 *****
68 ***
69 *
70 **
71 *
72 *
74 **
76
80
83
84
99 **


age distribution of women

8
10 *
11
12 ***
13 ********
14 ***********
15 ********
16 ***********
17 ***********
18 ******
19 ************
20 ********************
21 ***********************
22 ****************************
23 *****************************************
24 *********************************************
25 *****************************************
26 ***************************************
27 *******************************
28 ***********************************************
29 *******************************************
30 **********************************
31 ************************************
32 ********************************
33 *****************************
34 **************************************
35 ****************************
36 ********************************
37 *********************************
38 *********************************
39 **************************************
40 **************************
41 ***************************
42 *****************************
43 **************************
44 *********************
45 ******************
46 ***********************
47 ***************
48 ******************
49 *****************
50 ********************
51 ***********
52 **************
53 ***********
54 ***********
55 *********
56 *******
57 ****
58 ***
59 ******
60 *******
61 **
62 *
63
64
65 *
66 *
67 *
68 *
69 *
71
74
75
77
78
99 *

participation of "outa-towners":

OH *********************************************************************
WV **********************************
VA *************************
NY *******************
MD ****************
FL ********
CT *******
NJ ******
NC ******
MA ******
IL *****
DC *****
KY ****
MI ****
GA ****
CA ***
MN ***
AZ **
IN **
SC **
DE **
MO **
TX **
LA *
WI *
OR *
ND
PR
OK
VT
OA
WA
ME
TN
CO
AK
ON
MS
VW
PW
AR

Longest time a runner waited before his shoe with chip crossed the start line: 10 min 14 sec (99% of runners had to wait less than six minutes)

Average time a runner waited before his shoe with chip crossed the start line: 2 min 22 sec

person that most likely was passed by most:
VICTORIA ACKER and EVELINE YORK
both had identical chip time and clock time, meaning they were right at the start line when race started, but arrived 26th from last

person that most likely passed most other runners:
JOSEPH MARTIN, age 31 aka Strap-On, who waited more than 7 minutes before crossing the start line and 7th from last to do so, and then (why I am not surprised...), arrived 469th, more or less passing over five thousand other runners.

Most common last names:
35 SMITH
26 MILLER
20 BROWN
20 JONES
17 THOMAS
17 WILLIAMS
16 WINSCHEL
16 ANDERSON
14 MARTIN
14 MURPHY
14 BAKER
14 CLARK
14 HOFFMAN
13 THOMPSON
12 KELLY
12 KING
10 COOK

Most common first names among men:
95 MICHAEL
86 DAVID
75 JOHN
54 ROBERT
49 CHRISTOPHE
47 JAMES
47 MARK
38 TOM
37 WILLIAM
36 MATTHEW

Most common first names among women:
35 AMY
35 JENNIFER
33 ELIZABETH
29 LISA
26 SARAH
24 SUSAN
24 LAURA
23 KATIE
23 MARY
22 JULIE

first names that are used in both genders:
BRETT
CASEY
CHRIS
CHRISTINE
CHRISTOPHE
DAVE
FRANCIS
JAMIE
JAN
JEAN
KAREN
KELLY
KELLY M
KERRY
KIM
KRIS
LESLIE
MARIA
MICHAEL
MORGAN
PAT
SHELLY
SUSAN
TERRY
TIMOTHY

people whose first name have two Z:
IZZY ICKE

first names with two O:
JOOP
COOKIE
WOODY
LEXIE BROO
KENLEY WOO
BROOKE
COOKIE ARI
GOOD

last names with two Z:
ADDRIZZO
CAPOZZOLI
COZZENS
GALLUZZO
GLIOZZI
GUIZZETTI
LAZZARA
LAZZARIS
MARCOZZI
MAZZEI
MAZZINI
MAZZOCCO
PASCUZZI
PEDAZZOLI
RIZZA
RIZZARDI
ROZZO
RUZZI
SCARAZZO
SPICUZZA

last names with TZ:
ALBITZ
ARETZ
BAMETZRIEDER
BELTZ
BOTZER
CHAMOVITZ
COBLENTZ
COLTZ
DIETZ
DITZLER
FITZGERALD
FITZMAURICE
FITZPATRICK
FRANTZ
GLATZ
GOODYKOONTZ
HARTZELL
HATZO
HETZLER
HOLTZ
HOROWITZ
HORWITZ
HULTZ
KATZ
KRAFTOWITZ
KREITZER
KREUTZER
KURUTZ
LANTZMAN
LEBOUITZ
LEITZE
LEITZEL
LIPETZKY
LIPSITZ
LUTZ
MEDVITZ
MINTZ
MORITZ
MOSKOVITZ
OMATZ
ORNITZ
PEITZ
PELTZ
PITZER
POMERANTZ
RADDATZ
REITZ
RETZLAFF
ROTZ
SCHULTZ
SCHUTZMAN
SCHWEITZER
SETZKORN
SIMITZ
STULTZ
STUTZ
SWARTZLANDER
VOLTZ
WALTZER
WATZLAF
WETZEL
ZELKOWITZ

last names with ICH:
ADAMEROVICH
ALDRICH
BABICH
BASICH
BERKOVICH
BIELICH
CAVRICH
COPERICH
COPICH
DIETRICH
EHRLICH
EICHENLAUB
EICHER
EVANKOVICH
FREUDENRICH
FREUDENRICH III
FROEHLICH
GEORGEVICH
GUREKOVICH
JELOVICH
KNEZEVICH
KRIZMANICH
KUNDICH
MARAVICH
MICHAEL
MICHAELSON
MICHALSKI
MICHEL
MILANOVICH
NICHOLAS
NICHOLSON
NOVAKOVICH
ORLICH
PAVLICH
PERETICH
PEZICH
POSTREICH
QUALLICH
REICH
RESOVICH
RICH
RICHARD
RICHARDS
RICHARDSON
RICHEY
RICHTER
ROTHERMICH
SCLICHTER
SICHER
SICHOK
STANICH
STANKEVICH
STIPANOVICH
TURKOVICH
TWICHELL
WICHMANN
WIDICH
WUKICH
YAKICH
YANOVICH
YURKOVICH

last names with SKI:
ANTOSZEWSKI
BACHOWSKI
BADACZEWSKI
BAGINSKI
BARANOWSKI
BASINSKI
BETHOSKI
BOJARSKI
BORAWSKI
BRONISZEWSKI
CWIKLINSKI
CYTERSKI
DABKOWSKI
DEBOWSKI
DEBSKI
DISKIN
DOBRZYNSKI
DOMBROWSKI
DONAJKOWSKI
FALENSKI
GAJEWSKI
GASKILL
GIELAROWSKI
GOLASHEWSKI
GOLEBIEWSKI
GOODZINSKI
GORALSKI
HUCHROWSKI
JANCZEWSKI
JEGLINSKI
KALKOWSKI
KANSKI
KARLOSKI
KLOSINSKI
KOMARINSKI
KORZENIEWSKI
KOSKI
KOWALSKI
KUMINKOSKI
KUZMKOWSKI
LECZKOWSKI
LESNIAKOWSKI
LEWANDOWSKI
LINKOWSKI
MALESKI
MARKILINSKI
MICHALSKI
MILINSKI-GROSS
MORASKI
MURAWSKI
OLSZEWSKI
ORCHOWSKI
OSEKOWSKI
OSLOWSKI
OSSOWSKI
PASZKOWSKI
PILARSKI
RADKOWSKI
ROSPORSKI
RUSKIN
RUTKOSKI
SASINOSKI
SEKOWSKI
SIKORSKI
SISKIND
SKIDMORE
SKINNER
SOKOLOSKI
SOKULSKI
STARZYNSKI
SULKOWSKI
SWIDZINSKI
TABORSKI
TAMBORSKI
TOMKOWSKI
TRZCINSKI
TWARGOWSKI
ULESKI
WARUSZEWSKI
WINKOWSKI
WINNOSKI
WYZOMIRSKI
ZAGORSKI
ZALENSKI
ZANIESKI
ZAPINSKI
ZATAWSKI
ZUKOWSKI

Thursday, September 27, 2007

Folker's Full Moon

West View section of McKees Rocks

At about km 3.5, there was a tavern with Beer Stop #1, but both Moon and Sherpes completely missed it by checking a street with steps at the end after a check, and found marks, leading the turkey trail at the end of which a tavern with Beer Stop #2, where they waited and waited and waited, and in the meantime a huge thunderstorm with lightning has happening outside that washed all the chalk marks away. The tavern at Beer Stop #2 had no windows, so Moon and Sherpes had no idea it was raining outside. Eventually, the hare led the pack to the second beer stop.

Actual trail covered.

Notes: some really neat abbandoned (and condemmed) steps at about km 1.1, Edison Way.

Monday, September 24, 2007

Ped'er Pants Hash on Panhandle trail

Memorable hash with lots of toys, swings, axes, shovels, geocaches. Duke had its day of fun bringing down tres ("timber !").

Starting on the Panhandel Trail near Oakmont, the pack started locking for marks and beer. What they found was an assortment of tools and a almost hacked tree, that just had about two inches of fiber holding it. It didn't take much for Pound Puppy, Duke of Hurl, and Luke Fairy to bring the poor arboreal speciment to horizontal rest, and then subjected to the excrutiatingly painful Duke of Hurl Fat Boy Test. At the second beer stop, a swing rope gave room to the half-mind's imagination, and one by one, several volunteered to act as Tarzan and Jane. But, not once but twice, the rope got twisted around an upper branch, stucking the rope, and unstucking required a concerted intervention of eager-to-help crowds.

While on trail, Sherpes recognized a location and yelled to the crowd behind him that there was a geocache nearby. Giant Ankle found it, and with Folker, the three of them signed the log and took a travel bug with them, a necklace of buckeyes stringed together.

Map of true trail.







Tuesday, September 18, 2007

FukStik Sept 2007 Hash

as far as Luke Fairy and Spermit could tell where marks were ... true trail.

on-in for sherpes who got lost in Brentwood after last mark at Pine
Tree Apts...

Wednesday, August 8, 2007

Four Hashers at Coon Cave

Folker, Sherpes, Norton, Ped'er Pants.
Coon Cave is near Bolivar, PA.

Tuesday, July 31, 2007

TV Repairman Location

This is where you can get WMD's Sony 36" Trinitron fixed. Russian emigres, one of them is Misha. Right across from Giant Eagle on Murray Ave in Greenfield. My guess: it is just the power supply, under $80, Misha and his soviet-era training in electronics will be glad to fix that up for you. If you question him on whether it is worth fixing, he will say "Tis TeVe still vrRy Gud. VrRy Gud components. Made in Japan, not China".

Why Y Beer Stop











pictures of the Y steps merge, and steps going up from there.