
CREATE TABLE `cue` (
  `cue` int NOT NULL AUTO_INCREMENT,
  `trip` smallint DEFAULT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `sort` decimal(5,2) DEFAULT '100.00',
  PRIMARY KEY (`cue`)
) ENGINE=MyISAM AUTO_INCREMENT=425 DEFAULT CHARSET=latin1^^

INSERT INTO cue VALUES("327","57","Largo","6.00")^^
INSERT INTO cue VALUES("328","29","MCT 2 day ride","9.00")^^
INSERT INTO cue VALUES("329","29","Bourse Rd to Super 8 (alt extra 0.8 mi)","10.00")^^
INSERT INTO cue VALUES("330","29","MCT 2 day #2","11.00")^^
INSERT INTO cue VALUES("113","29","NPV to Forest Park with Metra stations - 24.8 miles via Main Stem, 26.4 via GW Trail","5.00")^^
INSERT INTO cue VALUES("114","29","Kewanee to Galesburg","3.00")^^
INSERT INTO cue VALUES("184","29","Wheaton (EggClectic Cafe) to GW Trail","6.00")^^
INSERT INTO cue VALUES("203","29","Galesburg to Kewanee via Bishops Hill","1.00")^^
INSERT INTO cue VALUES("207","29","End of IPP to River Forest Metra","7.00")^^
INSERT INTO cue VALUES("298","66","Brataslava dock to Freedom Bridge","4.00")^^
INSERT INTO cue VALUES("315","70","NYP to L hotel","1.00")^^
INSERT INTO cue VALUES("314","31",NULL,"1.00")^^
INSERT INTO cue VALUES("299","66","Passau to Vilshofen","6.00")^^
INSERT INTO cue VALUES("402","78",NULL,"1.00")^^
INSERT INTO cue VALUES("303","66","Around Tegernsee","2.00")^^
INSERT INTO cue VALUES("284","66","Munich Airport to bbHotel","9.00")^^
INSERT INTO cue VALUES("339","29","NPV to Ill Prairie Path","4.00")^^
INSERT INTO cue VALUES("323","57","840 Virginia to Drew & Keene","3.00")^^
INSERT INTO cue VALUES("341","57","Hands on return via trail","7.00")^^
INSERT INTO cue VALUES("255","54","<b>4 persons M2 to Deák Ferenc tér<br>Sofitel Hotel</b>","8.00")^^
INSERT INTO cue VALUES("245","54","Prater Reisenrad to Hotel","3.00")^^
INSERT INTO cue VALUES("256","54","Hotel - Stephansplatz - HBF","7.00")^^
INSERT INTO cue VALUES("249","54","Hotel - Danube Island - Prater","2.00")^^
INSERT INTO cue VALUES("239","54","Brataslava ship dock to Marchegg bhf","5.00")^^
INSERT INTO cue VALUES("243","54","Marchegg BHF to Wien outskirts","6.00")^^
INSERT INTO cue VALUES("248","54","Bahnhof Meidling (bike station) to Renaissance Hotel (bike station)","1.00")^^
INSERT INTO cue VALUES("251","54","Hotel (bike station) to St. Stephen Cathedral","4.00")^^
INSERT INTO cue VALUES("254","29","Laurel Park, St. Peters, Mo","8.00")^^
INSERT INTO cue VALUES("306","66","Vilhofen to BHF","7.00")^^
INSERT INTO cue VALUES("313","29","Galesburg to Kewanne","2.00")^^
INSERT INTO cue VALUES("292","66","Regensburg HBF to Ibis","8.00")^^
INSERT INTO cue VALUES("304","66","Freedom Bridge to Weikendorf BHF","5.00")^^
INSERT INTO cue VALUES("261","66","Budapest train station to Docking location 2 (bus 76)","3.00")^^
INSERT INTO cue VALUES("262","66","Munich airport to Ibis south","1.00")^^
INSERT INTO cue VALUES("316","70","Cambridge Station to Barton Close","2.00")^^
INSERT INTO cue VALUES("324","57","840 Virginia to Aldi (Sprouts)","1.00")^^
INSERT INTO cue VALUES("325","57","Sunnyvale Blvd & Belcher to Walmart","4.00")^^
INSERT INTO cue VALUES("326","57","Dunedin to Hermosa Springs avoiding 19","5.00")^^
INSERT INTO cue VALUES("322","57","Keene & Montclair to Best Buy","2.00")^^
INSERT INTO cue VALUES("334","29","NPV to Downers Grove","12.00")^^
INSERT INTO cue VALUES("335","29","Downers Grove to Brookfield (short)","14.00")^^
INSERT INTO cue VALUES("336","29","Downers Grove to Brookfield (scenic)","13.00")^^
INSERT INTO cue VALUES("345","29","Hamel to Wanda via Nickel Plate","16.00")^^
INSERT INTO cue VALUES("344","29","Wanda Trailhead to Hamel","15.00")^^
INSERT INTO cue VALUES("342","57","840 Virginia to I275","8.00")^^
INSERT INTO cue VALUES("411","29","Oldsmar Tr","17.00")^^
INSERT INTO cue VALUES("357","76","RGH to HI Raleight Downtown","1.00")^^
INSERT INTO cue VALUES("356","76","NYP to Leo House","2.00")^^
INSERT INTO cue VALUES("362","76","US 74 to CLT","3.00")^^
INSERT INTO cue VALUES("410","85","Moynihan to Sheraton","1.00")^^
INSERT INTO cue VALUES("366","80","Slater to Woodward via High Tressle","2.00")^^
INSERT INTO cue VALUES("368","80","Quincy to IA 16 to Quality Inn Ankeny","1.00")^^
INSERT INTO cue VALUES("395","80","Neal Smith Trail","3.00")^^
INSERT INTO cue VALUES("387","80","Ottumwa Trails","4.00")^^
INSERT INTO cue VALUES("412","89","Frankfurt HBF to Intercity Hotel","2.00")^^
INSERT INTO cue VALUES("413","89","Moynihan to L hotel","1.00")^^
INSERT INTO cue VALUES("417","89","Passau HBF to Central Bus Station","3.00")^^
INSERT INTO cue VALUES("415","89","Frankfurt airport fern BHF to Holiday Inn","4.00")^^
INSERT INTO cue VALUES("416","89","Holiday Inn to FRA terminal 2","5.00")^^
INSERT INTO cue VALUES("424","29","  Home to FMD","18.00")^^




CREATE TABLE `detail` (
  `detail` int NOT NULL AUTO_INCREMENT,
  `cue` smallint DEFAULT NULL COMMENT 'FK to cue record id',
  `sort` decimal(5,2) DEFAULT NULL,
  `map` smallint DEFAULT NULL COMMENT 'FK pointing to map inserted in cue sheet',
  `dir` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `distance` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT 'miles or feet',
  `services` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '.' COMMENT 'used manly for comments',
  PRIMARY KEY (`detail`)
) ENGINE=MyISAM AUTO_INCREMENT=5800 DEFAULT CHARSET=utf8mb3^^

INSERT INTO detail VALUES("3185","303","14.00","0","Turn right onto Schwaighof-Anlage
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3184","303","13.00","0","Slight right onto Courths-Mahler-Anlage
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("4397","368","3.00","0","Turn right onto IA-1 N/IA-16 W
","12.8 mi","Birmingham")^^
INSERT INTO detail VALUES("5013","395","7.00","566","Turn right
","0.1 mi","1st right")^^
INSERT INTO detail VALUES("5014","395","8.00","568","Turn right toward Neal Smith Trail
","482 ft
","Just after Restroom on right")^^
INSERT INTO detail VALUES("5015","395","9.00","0","Slight left onto Neal Smith Trail","0.7 mi
","at large parking area, to Saylorville Lake Marina")^^
INSERT INTO detail VALUES("4415","368","6.00","542","Keep left to continue on US Hwy 63 N","27.0 mi","not 34 W. at Ottumwa; Eddyville")^^
INSERT INTO detail VALUES("4413","368","4.00","0","Turn right onto the ramp toward Ottumwa","0.3 mi","at Fairfield")^^
INSERT INTO detail VALUES("4403","368","9.00","0","Follow Exit 84 & merge onto I-80 W","2.9 mi","signs for I-80 W/Council Bluffs")^^
INSERT INTO detail VALUES("4401","368","7.00","0","Continue onto IA-163 W
","55.8 mi","just before Oskaloosa, Pella, Monroe, Prarie City")^^
INSERT INTO detail VALUES("3050","299","5.00","0","Slight left onto Wirtschaftsweg
","1.2 mi","becomes Wörth")^^
INSERT INTO detail VALUES("5012","395","4.00","567","Turn right
","0.2 mi","Almost immediately after crossing street")^^
INSERT INTO detail VALUES("3052","299","6.00","0","Turn right onto bike path along St2125","0.7 mi
",NULL)^^
INSERT INTO detail VALUES("3053","299","7.00","0","Turn right then left","0.3 mi","at Minihofstraße to switch paths")^^
INSERT INTO detail VALUES("3055","299","8.00","0","Turn left to stay on bike path","3.1 mi","just past bridge across Danube")^^
INSERT INTO detail VALUES("5016","395","10.00","565","Turn left onto road at Saylorville Lake marina","0.1 mi
","temporary end of trail")^^
INSERT INTO detail VALUES("3060","299","9.00","0","Turn left onto bike path along St2125","1.0 mi
",NULL)^^
INSERT INTO detail VALUES("3061","299","10.00","0","Turn left onto bike path","1.2 mi","away fro st2125")^^
INSERT INTO detail VALUES("3063","299","11.00","0","Turn left back onto bike path along St2125","2.1 mi","becomes Passauer Str., then Marktpl. in Windorf")^^
INSERT INTO detail VALUES("5017","395","11.00","0","Turn right onto Neal Smith Trail
","1.2 mi","brown bike path sign, cross McBride Dr")^^
INSERT INTO detail VALUES("3436","316","5.00","0","Turn left onto Gonville Pl/Hills Rd/Regent St/A603
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3435","316","4.00","0","Turn right onto Hills Rd/A1307
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3437","316","6.00","0","At the roundabout, take the 1st exit onto Trumpington Rd
","171 ft
",NULL)^^
INSERT INTO detail VALUES("4071","344","6.00","0","Turn left onto Quercus Grove Trail","5.3 mi
",NULL)^^
INSERT INTO detail VALUES("4069","344","4.00","0","Turn right onto N Main St
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("4070","344","5.00","0","Turn left onto Hillsboro Ave
","0.5 mi
","2nd left")^^
INSERT INTO detail VALUES("3746","328","27.00","0","Turn right
","154 ft","Into Watershed Trail Parking lot")^^
INSERT INTO detail VALUES("3751","328","1.00","491","Watershead trail head via Hardin, Jerseyville, US 67 and Ill 255","0 mi",NULL)^^
INSERT INTO detail VALUES("3911","334","21.00","0","Turn left onto Hitchcock Ave
","0.4 mi
","cross I355")^^
INSERT INTO detail VALUES("3912","334","22.00","0","Turn right onto Walnut Ave
","433 ft
","at T")^^
INSERT INTO detail VALUES("3913","334","23.00","0","Turn left onto Curtiss St
","1.2 mi
",NULL)^^
INSERT INTO detail VALUES("3914","334","24.00","0","Turn left onto Cornell Ave
","0.2 mi
","at T")^^
INSERT INTO detail VALUES("3915","334","25.00","0","Slightly right onto Burlington Ave","1.0 mi
","Continue to follow Gilbert Ave
 ")^^
INSERT INTO detail VALUES("3908","334","18.00","0","Turn right onto Kingston Ave
","256 ft
",NULL)^^
INSERT INTO detail VALUES("3909","334","19.00","0","Turn left onto Front St
","0.5 mi
",NULL)^^
INSERT INTO detail VALUES("3760","329","1.00","0","Continue south on Goshen Trail (extra 0.8 mi)","0.9 mi
","at Bouse Rd")^^
INSERT INTO detail VALUES("3761","329","2.00","492","Turn left onto Madison County Transit Schoolhouse Trail
","302 ft
","Don't veer left onto Schoolhouse Trail")^^
INSERT INTO detail VALUES("3762","329","3.00","0","Continue onto Sugarmill Rd
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3763","329","4.00","0","Turn left onto Long Branch Rd
","0.8 mi
",NULL)^^
INSERT INTO detail VALUES("3764","329","5.00","0","Turn left onto Frontage Rd
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("3765","329","6.00","0","Continue onto Formosa Rd
","344 ft
","at Il 162 Traffic Light")^^
INSERT INTO detail VALUES("3766","329","7.00","0","Turn left
","0.2 mi
","Onto service road")^^
INSERT INTO detail VALUES("3767","329","8.00","0","Turn right
","105 ft
","at Super 8")^^
INSERT INTO detail VALUES("3907","334","17.00","0","Turn left onto Front St
","0.3 mi
","Metra station on left")^^
INSERT INTO detail VALUES("3910","334","20.00","0","Front St turns right and becomes Westview Ln
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3904","334","14.00","0","Turn right
","0.2 mi
","at T, cts sign")^^
INSERT INTO detail VALUES("3905","334","15.00","0","Continue onto Burlington Ave
","1.0 mi
",NULL)^^
INSERT INTO detail VALUES("3906","334","16.00","0","Turn right onto Main St
","459 ft
","Lisle")^^
INSERT INTO detail VALUES("3899","334","9.00","0","Continue onto Burlington Ave
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3900","334","10.00","0","Turn left onto Beau Bien Blvd
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3901","334","11.00","0","Turn right onto Wellington Ave
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3902","334","12.00","0","Turn right onto Molex Dr
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3903","334","13.00","0","Turn left onto Indiana Ave
","135 ft
",NULL)^^
INSERT INTO detail VALUES("3949","334","3.00","0","Turn right onto E 5th Ave","0.4 mi",NULL)^^
INSERT INTO detail VALUES("3894","334","4.00","0","Continue onto Plank Rd
","1.4 mi
","after slight left")^^
INSERT INTO detail VALUES("3895","334","5.00","498","Turn right onto Radcliff Rd
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3896","334","6.00","0","Turn left onto Burlington Ave
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3897","334","7.00","0","Turn right onto Burnham St
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3898","334","8.00","0","Turn left onto Handley Dr
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("3891","334","1.00","0","Head east on E 4th Ave","0.1 mi","Naperville Amtrak")^^
INSERT INTO detail VALUES("3892","334","2.00","0","Turn left onto Loomis","450 ft",NULL)^^
INSERT INTO detail VALUES("3889","330","2.00","0","Turn right onto S Buchanan St",NULL,NULL)^^
INSERT INTO detail VALUES("3890","330","3.00","0","Turn right onto Longfellow Ave",NULL,"Trailhead 714 Longfellow Av")^^
INSERT INTO detail VALUES("3886","330","29.00","0","Turn right onto Nickel Plate Trail","0.3 mi",NULL)^^
INSERT INTO detail VALUES("3883","330","26.00","496","Turn right onto New Poag Rd","2.3 mi","Pass over Goshen Trail, becomes St Louis St, then Vandalia, cross Main St")^^
INSERT INTO detail VALUES("3887","330","30.00","0","Parking lot on left",NULL,NULL)^^
INSERT INTO detail VALUES("3885","330","28.00","0","Turn left onto Wolf St
","207 ft
",NULL)^^
INSERT INTO detail VALUES("3884","330","27.00","0","Turn right onto S Fillmore St
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3882","330","25.00","0","Turn left to stay on Delyte Morris Trail
","0.7 mi","after crossing No. U Drive")^^
INSERT INTO detail VALUES("3880","330","4.00","0","Head southwest on Nickel Plate Trail","0.4 mi","MCT Nickel Plate Trail Parking Lot
; 747 Longfellow Ave")^^
INSERT INTO detail VALUES("3881","330","24.00","0","Straight onto Delyte Morris Trail","1.7 mi","after turning right at parking lot; Bluff Trail turns left")^^
INSERT INTO detail VALUES("3743","328","25.00","0","Turn left onto W High St
","410 ft",NULL)^^
INSERT INTO detail VALUES("3744","328","26.00","0","Turn right onto Watershed Trail","4.9 mi",NULL)^^
INSERT INTO detail VALUES("3888","330","1.00","497","from IL 143/159, turn left on Vandalia",NULL,NULL)^^
INSERT INTO detail VALUES("3879","330","5.00","0","Turn left to stay on Nickel Plate Trail","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3878","330","6.00","0","Turn right onto Nature Trail","0.1 mi","at T; circle right under trail and up to right on Nature and NP trails")^^
INSERT INTO detail VALUES("3873","330","11.00","0","Slight right onto Schoolhouse Trail; pass Drost Park on right","5.7 mi
","After passing over IL 162")^^
INSERT INTO detail VALUES("3740","328","24.00","0","Turn right onto N Main St
","0.2 mi",NULL)^^
INSERT INTO detail VALUES("3739","328","21.00","0","Turn left onto E Vandalia St
","259 ft",NULL)^^
INSERT INTO detail VALUES("3737","328","19.00","490","Turn left onto Springer Ave
","367 ft
","At E Schwarz St; sidewalk on LHS")^^
INSERT INTO detail VALUES("3738","328","20.00","0","Turn left onto Quercus Grove Trail","0.2 mi
","just past Bldg Mats. Makes left turn")^^
INSERT INTO detail VALUES("3071","299","15.00","0","Turn toward ship","105 ft",NULL)^^
INSERT INTO detail VALUES("3877","330","7.00","0","Slight right to stay on Nickel Plate Trail","3.9 mi
",NULL)^^
INSERT INTO detail VALUES("3749","328","22.00","0","Turn right onto Quercus Grove Trail","0.2 mi",NULL)^^
INSERT INTO detail VALUES("3069","299","14.00","450","Turn left onto Untere Donaulände
","259 ft","then left down to river")^^
INSERT INTO detail VALUES("4091","345","8.00","0","Turn left to stay on Madison County Transit Nickel Plate Trail
","0.2 mi
","After spur to right")^^
INSERT INTO detail VALUES("4090","345","7.00","0","Cross Schwartz and turn left to stay on Trail","0.9 mi
","After running along Schwartz")^^
INSERT INTO detail VALUES("4087","345","6.00","0","Turn right onto Nickel Plate Trail","5.8 mi",NULL)^^
INSERT INTO detail VALUES("4085","345","4.00","0","Turn right onto Maple Rd
","0.5 mi
","At T")^^
INSERT INTO detail VALUES("4086","345","5.00","0","Turn left onto Columbia Rd
","1.5 mi
","1st left")^^
INSERT INTO detail VALUES("170","113","2.00","0","Wheaton","9.0 mi","UP West Week day 12:54-1:50, 2:54-3:50; $6.25")^^
INSERT INTO detail VALUES("171","113","3.00","0","College Av","1.2 mi",NULL)^^
INSERT INTO detail VALUES("172","113","4.00","0","Glen Ellyn","1.5 mi",NULL)^^
INSERT INTO detail VALUES("173","113","5.00","0","Main Street, <b>Lombard</b>","2.5 mi","0.3 mi N to station")^^
INSERT INTO detail VALUES("174","113","6.00","0","Ardmore Av, <b>Villa Park</b> (0.9 mi before Villa Park station)","2.0 mi","1 mi north to Station")^^
INSERT INTO detail VALUES("175","113","7.00","0","Prospect Av, <b>Elmhurst</b> (at Pioneer Park)","1.8 mi","0.9 mi N on Prospect, cross track, turn right to station")^^
INSERT INTO detail VALUES("176","113","8.00","0","Taft Av, <b>Berkeley</b>","1.7 mi","0.9 mi N on Taft to station parking lot")^^
INSERT INTO detail VALUES("177","113","9.00","0","19th AV, <b>Maywood</b>","3.0 mi","1 mi N on 19th to Melrose Park station")^^
INSERT INTO detail VALUES("178","113","10.00","0","5th Av, <b>Maywood</b>","0.9 mi","0.9 mi to Maywood station")^^
INSERT INTO detail VALUES("179","113","11.00","0","Cemetery","0.8 mi","1.3 mi to River Forest Metra; 1:25-2:00, 3:25-4:00; $3.75
$3.75")^^
INSERT INTO detail VALUES("180","114","1.00","175","Head <b>southwest</b> on <b>W 3rd St</b>","0.1 mi","Kewanee, IL Amtrak")^^
INSERT INTO detail VALUES("181","114","2.00","0","Turn right onto <b>W 2nd St</b>","0.4 mi","Becomes Commercial St at Park")^^
INSERT INTO detail VALUES("182","114","3.00","0","Turn left onto <b>S Boss St</b>","364 ft",NULL)^^
INSERT INTO detail VALUES("183","114","4.00","0","Turn right onto <b>Rose St</b>","0.4 mi",NULL)^^
INSERT INTO detail VALUES("184","114","5.00","0","Turn slightly right onto <b>Red Adams Rd</b>","1.0 mi",NULL)^^
INSERT INTO detail VALUES("185","114","6.00","0","Turn right onto <b>N 570th Ave</b>","4.0 mi",NULL)^^
INSERT INTO detail VALUES("186","114","7.00","0","Turn left onto <b>Co Rd 5/<wbr/>2050 </b>","4.7 mi","Soon turns L (south; becomes Center St in Galva")^^
INSERT INTO detail VALUES("187","114","8.00","0","Turn right onto <b>Front St</b>","0.2 mi",NULL)^^
INSERT INTO detail VALUES("188","114","9.00","0","Turn left onto <b>Exchange St</b>","0.1 mi","around Park and across RR tracks")^^
INSERT INTO detail VALUES("189","114","10.00","0","Slight left onto <b>SW 2nd St</b>","0.1 mi",NULL)^^
INSERT INTO detail VALUES("190","114","11.00","0","Turn right onto <b>IL-17 E/<wbr/>S Center Ave</b>","3.5 mi",NULL)^^
INSERT INTO detail VALUES("191","114","12.00","0","Turn right onto <b>Co Hwy 4</b>","9.7 mi","Altona after 6.2 mi")^^
INSERT INTO detail VALUES("192","114","13.00","0","Turn left onto <b>Knox Hwy 3</b>","2.6 mi",NULL)^^
INSERT INTO detail VALUES("193","114","14.00","0","Continue onto <b>N Wataga St</b>","0.5 mi","Oneida")^^
INSERT INTO detail VALUES("194","114","15.00","0","Turn right onto <b>US-34 W</b>","3.5 mi",NULL)^^
INSERT INTO detail VALUES("195","114","16.00","0","Turn left onto <b>IL-167 E</b>","0.1 mi","towards Wataga")^^
INSERT INTO detail VALUES("196","114","17.00","0","Slight right onto <b>N Depot Rd</b>","1.2 mi",NULL)^^
INSERT INTO detail VALUES("197","114","18.00","0","Becomes <b>Co Hwy 40</b>","4.9 mi","Leaving Wataga")^^
INSERT INTO detail VALUES("198","114","19.00","0","Becomes <b>Lincoln St</b>","1.2 mi","entering Galesburg")^^
INSERT INTO detail VALUES("199","114","20.00","0","Turn right onto <b>E Main St</b>","0.4 mi",NULL)^^
INSERT INTO detail VALUES("200","114","21.00","0","Turn left onto <b>S Seminary St</b>","0.2 mi","5 S Seminary St, Galesburg Amtrak")^^
INSERT INTO detail VALUES("4367","368","5.00","0","Merge onto US-34 west","23.3 mi","Batavia, Agency")^^
INSERT INTO detail VALUES("4373","368","10.00","0","Exit 137B to merge onto I-35 N","5.2 mi
","toward Minneapolis")^^
INSERT INTO detail VALUES("4377","368","12.00","0","Turn left onto SE Delaware Ave","0.2 mi","Turn left onto SE Delaware Ave
 ")^^
INSERT INTO detail VALUES("4378","368","13.00","0","Turn left onto 3rd St
","72 ft","Backtrack to Quality Inn & Suites 201 SE Delaware Ave, Ankeny, IA 50021")^^
INSERT INTO detail VALUES("4381","368","1.00","0","Home to IA 16 & US 218","67.6 mi",NULL)^^
INSERT INTO detail VALUES("4380","368","2.00","541","Turn left on IA-16 W toward","21.1 mi","Houghton, right then left")^^
INSERT INTO detail VALUES("4387","368","8.00","543","Turn right to merge onto US-65 N","4.2 mi","toward I-80")^^
INSERT INTO detail VALUES("4362","366","13.00","535","Continue on High Tressle Trail","3.0 mi","Woodward Trailhead
; Woodward, IA 50276")^^
INSERT INTO detail VALUES("4359","366","7.00","0","Turn left onto Greene St","0.3 mi",NULL)^^
INSERT INTO detail VALUES("4516","366","9.00","0","Turn left at N Carroll St","98 ft",NULL)^^
INSERT INTO detail VALUES("4514","366","8.00","0","Turn left onto 1st Ave N","358 ft",NULL)^^
INSERT INTO detail VALUES("4515","366","6.00","0","Turn right at T","177 ft","just past swimming pool")^^
INSERT INTO detail VALUES("4360","366","10.00","0","Turn right onto High Trestle Trail
","5.3 mi",NULL)^^
INSERT INTO detail VALUES("4317","362","1.00","519","Charlotte, NC 28208
","10 min (6.3 mi)
","Take Wilkinson Blvd and I-77 N/US-21 N to W 11th St. Take exit 3B from I-277 S/NC-16 S
 
; Wilkinson Blvd & Boyer St")^^
INSERT INTO detail VALUES("4316","362","11.00","0","Turn right
","1.1 mi","Amtrak Charlotte Station
; ")^^
INSERT INTO detail VALUES("4517","366","5.00","540","Take path north (right) at west end of lot","0.1 mi","Hi Tressle Tr Parking, before tennis ct")^^
INSERT INTO detail VALUES("4614","366","3.00","0","Turn right onto US-69 N for 6.0 mi","0",NULL)^^
INSERT INTO detail VALUES("4615","366","14.00","0","Turn left onto IA-210 W for 4.5 mi","0","Trail Parking on right")^^
INSERT INTO detail VALUES("4616","366","4.00","0","Turn left onto IA-210 W for 5.5 mi","0",NULL)^^
INSERT INTO detail VALUES("4281","356","2.00","0","Turn left onto 8th Ave
","0.7 mi",NULL)^^
INSERT INTO detail VALUES("4280","356","1.00","517","Head west on W 31st St toward 8th Ave","128 ft","from 8th Av & 31st St exit")^^
INSERT INTO detail VALUES("4309","362","4.00","0","Take the I-77/US-21 N exit toward I-85/Statesville
","0.6 mi","right into cloverleaf")^^
INSERT INTO detail VALUES("4307","362","2.00","0","Head East on Wilkinson Blvd","=","Pass by Bojangles (on the right in 1.8 mi)
 ")^^
INSERT INTO detail VALUES("5544","411","7.00","0","Continue onto St Petersburg Dr W
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("3991","336","15.00","500","Turn left onto Canterberry Ln
","2.8 mi","becomes Salt Creek Trail")^^
INSERT INTO detail VALUES("3993","336","16.00","0","Turn right to stay on Salt Creek Trail
","0.2 mi
","Before Edgewood av")^^
INSERT INTO detail VALUES("3994","336","17.00","0","Continue onto W Jackson Ave
","489 ft
",NULL)^^
INSERT INTO detail VALUES("3995","336","18.00","0","Turn right onto N Stone Ave
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3996","336","19.00","0","Turn left onto W Harding Ave
","1.4 mi","becomes Washington at Kemman")^^
INSERT INTO detail VALUES("3998","336","20.00","0","At the traffic circle, take the 3rd exit onto Grand Blvd
","0.5 mi
",NULL)^^
INSERT INTO detail VALUES("3999","336","21.00","0","Turn right onto Prairie Ave
","240 ft
",NULL)^^
INSERT INTO detail VALUES("4000","336","22.00","0","Turn left onto Burlington Ave
","121 ft
","Brookfield Metra Station
; Brookfield, IL 60513
")^^
INSERT INTO detail VALUES("4080","344","13.00","0","Turn right
","203 ft","Innkeeper Motel
; 401 E State St, Hamel, IL 62046
")^^
INSERT INTO detail VALUES("4082","345","1.00","0","Head east toward Hamel Dr
","203 ft
","Innkeeper Motel
; 401 E State St, Hamel, IL 62046
")^^
INSERT INTO detail VALUES("4063","342","3.00","0","Left onto FL-60 E / Gulf to Bay Blvd","13.0 mi","Pass Tampa Airport")^^
INSERT INTO detail VALUES("4061","342","1.00","511","E on Virginia","0.9 mi",NULL)^^
INSERT INTO detail VALUES("4062","342","2.00","0","R on Keene (Cty Rd 1)","3.5 mi",NULL)^^
INSERT INTO detail VALUES("4056","341","1.00","510","South on Patricia","3.3 mi","becomes N Highland Ave")^^
INSERT INTO detail VALUES("4057","341","2.00","0","Turn right onto Grove St
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("4058","341","3.00","0","Turn left onto N San Remo Ave
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("4059","341","4.00","0","Sharp right onto Gulf to Bay Blvd
","0.3 mi
","Bike shop LHS at Franklin Str")^^
INSERT INTO detail VALUES("4060","341","5.00","0","Continue onto Cleveland St
","1.0 mi
","to Pinellas Trail")^^
INSERT INTO detail VALUES("4094","345","10.00","0","Turn right then left onto Goshen Trail","2.2 mi
",NULL)^^
INSERT INTO detail VALUES("4095","345","11.00","0","Continue onto Watershed Trail","1.2 mi","Trailhead on right")^^
INSERT INTO detail VALUES("4361","366","11.00","534","Cross IA-210","1.2 mi","to Madrid trail head")^^
INSERT INTO detail VALUES("5561","411","20.00","0","Turn right
","187 ft
",NULL)^^
INSERT INTO detail VALUES("5560","411","19.00","0","Turn left to stay on Oldsmar Trail
","413 ft
",NULL)^^
INSERT INTO detail VALUES("5562","411","21.00","0","Turn Right to Mobbly Bayou Beach Park","0.1 mi","4.9 mi back via Shore Dr.")^^
INSERT INTO detail VALUES("5554","411","15.00","0","Turn right onto Oldsmar Trail
","1.2 mi",NULL)^^
INSERT INTO detail VALUES("5552","411","14.00","0","Turn left onto Patty Dr
","82 ft",NULL)^^
INSERT INTO detail VALUES("5551","411","13.00","0","Turn right onto National Orange Ave
","430 ft
",NULL)^^
INSERT INTO detail VALUES("5559","411","18.00","574","Continue onto Oldsmar Trail
","0.9 mi
",NULL)^^
INSERT INTO detail VALUES("5558","411","17.00","573","Turn left onto Country Club Dr
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("5557","411","16.00","0","Turn right onto Dunkirk Rd
","472 ft
",NULL)^^
INSERT INTO detail VALUES("4315","362","10.00","0","Turn left onto N Tryon S","1.0 mi",NULL)^^
INSERT INTO detail VALUES("4314","362","9.00","0","Take exit 3B for Eleventh St/Church St/Tryon St
","0.2 mi",NULL)^^
INSERT INTO detail VALUES("4313","362","8.00","0","Merge onto I-277 S/NC-16 S
","0.8 mi",NULL)^^
INSERT INTO detail VALUES("4310","362","5.00","0","Use the left lane to keep left at the fork and continue toward I-77 N/US-21 N
","0.2 mi","after completing cloverleaf")^^
INSERT INTO detail VALUES("4311","362","6.00","0","Keep left at the fork and merge onto I-77 N/US-21 N
","1.3 mi
","Parts of this road may be closed at certain times or days
 ")^^
INSERT INTO detail VALUES("4308","362","3.00","520","Continue onto I-277 N/US-74 E (signs for Outer/I-77 N/US-21 N/Statesville)
","3.6 mi",NULL)^^
INSERT INTO detail VALUES("4287","357","4.00","0","on LHS","39 ft
","Holiday Inn Raleigh Downtown
;")^^
INSERT INTO detail VALUES("4286","357","3.00","0","Turn right onto Hillsborough St
","358 ft
","3rd cross street")^^
INSERT INTO detail VALUES("5549","411","11.00","572","Continue on Shore Dr E","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("5550","411","12.00","0","Turn left onto Lafayette Blvd
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("5547","411","10.00","0","Continue onto Bayview Blvd
","0.2 mi",NULL)^^
INSERT INTO detail VALUES("5546","411","9.00","0","Slight right onto Oldsmar Trl
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3875","330","9.00","0","Turn right toward Goshen Trail","0.2 mi","At trailhead after passing under Goshen Trail")^^
INSERT INTO detail VALUES("3727","328","15.00","0","Turn right onto Nickel Plate Trail","3.9 mi
",NULL)^^
INSERT INTO detail VALUES("3916","334","26.00","0","Turn left onto Forest Ave
","0.5 mi","at T, Downers Grove, cross tracks")^^
INSERT INTO detail VALUES("3726","328","14.00","0","Turn left onto Glen Carbon Heritage Bike Trail
","3.4 mi
",NULL)^^
INSERT INTO detail VALUES("3724","328","13.00","493","Turn right toward Glen Carbon Heritage Trail","0.2 mi","and old Troy Rd")^^
INSERT INTO detail VALUES("3723","328","12.00","0","Turn right onto Madison County Transit Goshen Trail
","1.3 mi
",NULL)^^
INSERT INTO detail VALUES("3721","328","10.00","0","Turn left onto Formosa Rd
","0.8 mi
",NULL)^^
INSERT INTO detail VALUES("3722","328","11.00","0","Turn left onto Bouse Rd
","0.8 mi
",NULL)^^
INSERT INTO detail VALUES("3608","323","21.00","0","Turn left onto Drew","210 ft","Drew & Keene")^^
INSERT INTO detail VALUES("3187","303","16.00","0","Turn right onto Nördliche Hauptstraße/B307
","440 ft
",NULL)^^
INSERT INTO detail VALUES("3188","303","17.00","0","Turn right onto Seestraße
","0.6 mi
",NULL)^^
INSERT INTO detail VALUES("3189","303","18.00","0","Turn left onto Aribostraße
","0.8 mi
",NULL)^^
INSERT INTO detail VALUES("3190","303","19.00","0","Turn right onto Wiesseer Str./B318
","0.8 mi
",NULL)^^
INSERT INTO detail VALUES("3191","303","20.00","0","Turn right onto am See
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("3192","303","21.00","0","Continue onto Ringseeweg
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3193","303","22.00","0","Continue onto Ringbergstraße
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3194","303","23.00","0","Turn right onto Sonnenfeldweg
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3195","303","24.00","0","Continue straight onto Altwiesseer Weg
","272 ft
",NULL)^^
INSERT INTO detail VALUES("3196","303","25.00","0","Turn right onto Dorfpl.
","449 ft
",NULL)^^
INSERT INTO detail VALUES("3197","303","26.00","0","Turn right onto Seepromenade
","174 ft
",NULL)^^
INSERT INTO detail VALUES("3198","303","27.00","0","Slight left to stay on Seepromenade
","374 ft
",NULL)^^
INSERT INTO detail VALUES("3199","303","28.00","0","Turn left to stay on Seepromenade
","30 ft
",NULL)^^
INSERT INTO detail VALUES("3200","303","29.00","0","Turn right to stay on Seepromenade
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3201","303","30.00","0","Slight right to stay on Seepromenade
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3202","303","31.00","0","Turn left toward Adrian-Stoop-Straße
","351 ft
",NULL)^^
INSERT INTO detail VALUES("3203","303","32.00","0","Turn right onto Adrian-Stoop-Straße
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3204","303","33.00","0","Continue onto Rupert-von-Miller-Platz
","167 ft
",NULL)^^
INSERT INTO detail VALUES("3205","303","34.00","0","Continue onto Wilhelminastraße
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3206","303","35.00","0","Continue onto Anton-von-Rieppel-Straße
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3207","303","36.00","0","Turn right onto Münchner Str./B318
","2.6 mi","Back to BHF")^^
INSERT INTO detail VALUES("3606","323","19.00","0","Turn left onto Ridgewood St
","302 ft
",NULL)^^
INSERT INTO detail VALUES("3605","323","18.00","0","Turn left onto N Saturn Ave
","0.9 mi
",NULL)^^
INSERT INTO detail VALUES("3601","323","14.00","0","Turn right onto Murray Ave
","259 ft
",NULL)^^
INSERT INTO detail VALUES("3602","323","15.00","0","Turn left onto Carlisle St
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3603","323","16.00","0","Turn right onto N Keene Rd
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3604","323","17.00","0","Turn right onto Flagler Dr
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3237","304","6.00","461","Continue onto Salmhof
","2.9 mi
",NULL)^^
INSERT INTO detail VALUES("3238","304","7.00","0","Slight left onto Oberweiden
","3.5 mi","cross RR, Oberweiden Bhf next right, becomes L3005 leaving Oberweiden")^^
INSERT INTO detail VALUES("1239","207","6.00","0","Continue onto Forest Ave
","0.1 mi
","crossing Madison")^^
INSERT INTO detail VALUES("3600","323","13.00","0","Turn left onto Greenlea Dr
","259 ft
",NULL)^^
INSERT INTO detail VALUES("3591","323","4.00","0","Turn left onto Beltrees St
","220 ft
",NULL)^^
INSERT INTO detail VALUES("3590","323","3.00","0","Turn right onto 3rd Ave
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3581","322","14.00","0","Turn right onto Duke Energy Trail
","0.5 mi","after crossing street")^^
INSERT INTO detail VALUES("3696","327","11.00","0","Turn left onto Pinellas Trail
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("3716","328","7.00","0","Turn right onto service road","0.2 mi
","just before IL 162")^^
INSERT INTO detail VALUES("3645","326","2.00","0","Turn right onto Main St","5.3 mi
","Cross arm of Tampa BAy")^^
INSERT INTO detail VALUES("3646","326","3.00","0","Turn left onto Forest Lakes Blvd
","2.7 mi
","just after small bridge")^^
INSERT INTO detail VALUES("3647","326","4.00","0","Turn left onto Race Track Rd
","5.1 mi
",NULL)^^
INSERT INTO detail VALUES("3648","326","5.00","0","At the traffic circle, 1st right to stay on Race Track Rd","0.7 mi
",NULL)^^
INSERT INTO detail VALUES("3649","326","6.00","0","Turn left onto Co Rd 587/Co Rd 582/Gunn Hwy","2.2 mi","T, white fence")^^
INSERT INTO detail VALUES("3713","328","4.00","488","Slight left to stay on  Goshen Trail","3.9 mi","Nickel Plate continues straight")^^
INSERT INTO detail VALUES("3714","328","5.00","0","Turn left onto Bouse Rd
","0.8 mi",NULL)^^
INSERT INTO detail VALUES("3711","328","2.00","487","Turn left onto Madison County Transit Watershed Trail
","3.6 mi","from Watershed Trail Parking")^^
INSERT INTO detail VALUES("3712","328","3.00","0","Straight onto Goshen Trail","2.4 mi","Watershead Trail continues left; Leclaire Park large picnic pav after 6.7 mi")^^
INSERT INTO detail VALUES("3706","327","19.00","0","Turn right at 125th st","1.2 mi
","immed left back on  trail")^^
INSERT INTO detail VALUES("3707","327","20.00","0","Turn first left","0.1 mi
","to go around lake")^^
INSERT INTO detail VALUES("3708","327","21.00","0","continue around lake and back to Pinellas trail","0.2 mi",NULL)^^
INSERT INTO detail VALUES("3658","326","7.00","0","Turn right onto Van Dyke Rd
","1.6 mi",NULL)^^
INSERT INTO detail VALUES("3694","327","9.00","0","Turn left toward Washington Ave SW
","79 ft
",NULL)^^
INSERT INTO detail VALUES("3695","327","10.00","0","Turn right onto Washington Ave SW
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3705","327","18.00","0","Turn right
","23 ft
","to stay on trail")^^
INSERT INTO detail VALUES("3704","327","17.00","0","Turn left on trail","440 ft
","around lake")^^
INSERT INTO detail VALUES("3703","327","16.00","486","Turn right onto Walsingham Rd
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("3665","326","8.00","0","Turn left on Fl 589","41.1 mi",NULL)^^
INSERT INTO detail VALUES("3702","327","15.00","0","Turn right onto Pinellas Trail
","1.5 mi
",NULL)^^
INSERT INTO detail VALUES("3950","335","1.00","0","Head east on Warren Ave","0.1 mi","from Forest Av in DG")^^
INSERT INTO detail VALUES("3698","327","13.00","0","Turn left into park","0.5 mi
","along side lake")^^
INSERT INTO detail VALUES("3699","327","14.00","0","Turn left along 16th AV SW","0.4 mi",NULL)^^
INSERT INTO detail VALUES("3670","326","9.00","0","Turn left onto US-98 S","4.4 mi",NULL)^^
INSERT INTO detail VALUES("3697","327","12.00","0","Turn right
","0.3 mi
","LHS 8th Av SW")^^
INSERT INTO detail VALUES("3672","326","10.00","0","Turn right onto US-19 N/US-98 N","46 ft","Continue to follow US-19 N/US-98 N
 ")^^
INSERT INTO detail VALUES("3684","327","1.00","485","Head east toward Central Park Dr
","177 ft
","Largo")^^
INSERT INTO detail VALUES("3685","327","2.00","0","Turn left onto Central Park Dr
","0.2 mi",NULL)^^
INSERT INTO detail VALUES("3688","327","3.00","0","Turn left onto E Bay Dr
","0.4 mi
","Cross Alt 19")^^
INSERT INTO detail VALUES("3689","327","4.00","0","Turn left onto 2nd St SW
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3690","327","5.00","0","Turn right onto Cleveland Ave SW
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3691","327","6.00","0","Turn left onto 6th St SW
","167 ft
",NULL)^^
INSERT INTO detail VALUES("3692","327","7.00","0","Turn right onto 2nd Ave SW
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3693","327","8.00","0","Turn right toward Washington Ave SW
","262 ft
",NULL)^^
INSERT INTO detail VALUES("766","184","3.00","0","Turn left onto N Main St
","459 ft",NULL)^^
INSERT INTO detail VALUES("767","184","4.00","0","Turn right onto E Franklin St","0.4 mi",NULL)^^
INSERT INTO detail VALUES("3966","335","14.00","0","Turn right onto W Harding Ave
","1.5 mi","becomes Washington Ave after 1 mi")^^
INSERT INTO detail VALUES("3965","335","13.00","0","Turn left onto N Brainard Ave
","0.8 mi
",NULL)^^
INSERT INTO detail VALUES("764","184","1.00","315","Head north on N Hale St","0.1 mi
","Wheaton Eggclectic Cafe")^^
INSERT INTO detail VALUES("3960","335","11.00","0","Turn left onto Justina St
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3961","335","12.00","0","Turn right at Minneola St
","1.9 mi","becomes Maple St after crossing I 294, continue on 41st St at Wolf Rd")^^
INSERT INTO detail VALUES("3957","335","8.00","0","Turn left onto W Hinsdale Ave
","0.3 mi
","W. Hinsdale Metra station")^^
INSERT INTO detail VALUES("3958","335","9.00","0","Turn left onto S Monroe St
","0.5 mi
","cross RR")^^
INSERT INTO detail VALUES("3959","335","10.00","0","Turn right onto W Hickory St
","1.2 mi
",NULL)^^
INSERT INTO detail VALUES("3067","299","13.00","0","Turn left onto Marienbrücke
","0.3 mi","Flugplatz on left")^^
INSERT INTO detail VALUES("773","184","8.00","0","Turn right onto Wakeman Ave
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("774","184","9.00","0","Turn left onto N President St
","1.3 mi","side walk on Left at Geneva Rd. Continue on trail at end of road")^^
INSERT INTO detail VALUES("772","184","7.00","0","Turn left onto Irving Ave
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("771","184","6.00","0","Turn right onto E Prairie Ave
","302 ft
",NULL)^^
INSERT INTO detail VALUES("770","184","5.00","0","Turn left onto Irving Ave","0.5 mi
",NULL)^^
INSERT INTO detail VALUES("3876","330","8.00","494","Turn left onto Glen Carbon Heritage Bike Trail
","3.4 mi
","after bridge entering Glen Carbon")^^
INSERT INTO detail VALUES("765","184","2.00","0","Turn right onto W Union Ave
","430 ft
",NULL)^^
INSERT INTO detail VALUES("4078","344","11.00","0","Turn right onto E State St
","0.6 mi
","At 1st Nat bank. Trail continues straight ahead")^^
INSERT INTO detail VALUES("4079","344","12.00","0","Turn right onto Hamel Dr
","105 ft
","After crossing I55")^^
INSERT INTO detail VALUES("4077","344","10.00","0","Turn right onto S Old Rte 66","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("4076","344","9.00","0","Turn left onto Trotter Dr
","69 ft
","Trail ends")^^
INSERT INTO detail VALUES("4075","344","8.00","0","Turn left onto MCT Quercus Grove Trail
","1.6 mi
","After crossing Il 157")^^
INSERT INTO detail VALUES("4072","344","7.00","0","Turn right onto Jerusalem Rd
","0.8 mi","After lake on left")^^
INSERT INTO detail VALUES("4083","345","2.00","0","Turn right onto Hamel Dr
","1.4 mi
","Turns Rt, Left, Left")^^
INSERT INTO detail VALUES("4066","344","1.00","0","Head east on Watershed Trail","3.6 mi
",NULL)^^
INSERT INTO detail VALUES("4084","345","3.00","0","Turn right to stay on Hamel Dr
","1.0 mi
","First right after 2nd left")^^
INSERT INTO detail VALUES("4067","344","2.00","0","Slight left to stay on Watershed Trail","1.3 mi
",NULL)^^
INSERT INTO detail VALUES("4068","344","3.00","0","Turn left onto W High St
","410 ft
",NULL)^^
INSERT INTO detail VALUES("3972","336","1.00","0","Turn right onto Chicago Ave
","1.1 mi","from Forest av in Downers Grove")^^
INSERT INTO detail VALUES("3951","335","2.00","0","Turn left onto Washington St
","299 ft
",NULL)^^
INSERT INTO detail VALUES("3952","335","3.00","0","Turn right onto Rogers St
","0.6 mi
",NULL)^^
INSERT INTO detail VALUES("3953","335","4.00","0","Slight left onto Maple Ave
","397 ft
",NULL)^^
INSERT INTO detail VALUES("3954","335","5.00","0","Turn right into alley","495 ft
","Hi Tech Auto Repair on lhs")^^
INSERT INTO detail VALUES("3955","335","6.00","0","Turn left onto Burlington Ave
","2.6 mi
","At Fairview Av metra station")^^
INSERT INTO detail VALUES("3956","335","7.00","0","Turn right onto S Stough St
","157 ft
",NULL)^^
INSERT INTO detail VALUES("1140","203","8.00","0","Turn left onto Knox Rd 1125 E
","1.5 mi","Becomes S Center St in <b>Oneida</b>")^^
INSERT INTO detail VALUES("1138","203","7.00","0","Slight right onto Knox Rd 2350 N","0.2 mi",NULL)^^
INSERT INTO detail VALUES("1137","203","6.00","0","Turn left onto Foxtown Rd/Knox Rd 1100 E
","1.4 mi
",NULL)^^
INSERT INTO detail VALUES("1136","203","5.00","0","Continue onto IL-167 E
","2.3 mi
","turn right instead of left to US34")^^
INSERT INTO detail VALUES("3066","299","12.00","0","Slight left onto Vilshofener Str.
","1.8 mi
",NULL)^^
INSERT INTO detail VALUES("1132","203","4.00","0","Turn left onto Lincoln St
","7.1 mi","Continue on Old US Hwy 34 and N Depot Rd into <b>Wataga</b/>")^^
INSERT INTO detail VALUES("1131","203","3.00","0","Turn right onto E North St
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3640","325","8.00","0","Turn right
","440 ft
","Walmart Supercenter 23106 US Hwy 19 N")^^
INSERT INTO detail VALUES("1130","203","2.00","0","Turn left onto S Chambers St
","0.4 mi","just before tracks")^^
INSERT INTO detail VALUES("1128","203","1.00","0","Turn right onto Mulberry St (east)","511 ft","Amtrak station")^^
INSERT INTO detail VALUES("3048","299","4.00","0","Turn left onto Kachletstraße","0.4 mi","signs for Maierhof, just after overpass. Becomes Ranklhofweg")^^
INSERT INTO detail VALUES("3047","299","3.00","0","Turn right onto Franz-Josef-Strauß-Brücke","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3990","336","14.00","0","Turn right onto York Rd
","0.3 mi
","at Christ Church")^^
INSERT INTO detail VALUES("3988","336","13.00","0","Turn right onto Grant St
","0.2 mi","and immediately left onto 31st St (sidewalk on left)")^^
INSERT INTO detail VALUES("3986","336","11.00","0","Turn right on path","0.3 mi
","after first street")^^
INSERT INTO detail VALUES("3987","336","12.00","0","Path Turns right","0.4 mi
","and crosses street")^^
INSERT INTO detail VALUES("3985","336","5.00","0","Turn left
","390 ft
","bike path thru small field")^^
INSERT INTO detail VALUES("3981","336","6.00","0","Turn right
","1.2 mi","Bike path along 35th; cross to LHS then 
cass av")^^
INSERT INTO detail VALUES("1148","203","9.00","0","Turn left onto W Ontario Rd
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3046","299","2.00","449","Slight right up toward bridge","0.1 mi
","just past Shell station")^^
INSERT INTO detail VALUES("3979","336","7.00","0","cross Trinity Ln","0.4 mi
","Slight left to stay on path")^^
INSERT INTO detail VALUES("3978","336","10.00","0","Turn left at Spring Street","308 ft
","cross 31st to bike path")^^
INSERT INTO detail VALUES("3977","336","9.00","0","Turn right
","0.9 mi
","on bike path along 31st str, cross Kings Hyway")^^
INSERT INTO detail VALUES("3976","336","8.00","0","Turn left at Y","0.2 mi
","after crossing St. Francis Cir")^^
INSERT INTO detail VALUES("3975","336","4.00","0","Turn right onto Hambletonian Dr
","0.4 mi
","1st Rt")^^
INSERT INTO detail VALUES("3974","336","3.00","0","Cumnor Rd turns left and becomes 38th St
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3973","336","2.00","499","Turn left onto Cumnor Rd
","1.1 mi
",NULL)^^
INSERT INTO detail VALUES("3970","335","17.00","0","Turn left onto Burlington Ave
","121 ft
","Brookfield Metra Station
; Brookfield, IL 60513
")^^
INSERT INTO detail VALUES("3968","335","15.00","0","At the traffic circle, take the 3rd exit onto Grand Blvd
","0.5 mi
",NULL)^^
INSERT INTO detail VALUES("3969","335","16.00","0","Turn right onto Prairie Ave
","240 ft
",NULL)^^
INSERT INTO detail VALUES("4092","345","9.00","0","Turn right onto Madison County Transit Nature Trail
","378 ft","At T, then under pass")^^
INSERT INTO detail VALUES("3434","316","3.00","0","Turn right onto Station Rd
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3731","328","17.00","0","Circle left under trail","0.1 mi",NULL)^^
INSERT INTO detail VALUES("3748","328","18.00","0","Turn left to stay on Nickel Plate Trail","1.1 mi","swerve left after 0.2 mi. Pedestrian tunnel after another 0.2 mi")^^
INSERT INTO detail VALUES("3040","298","10.00","0","Better bike path","2.0 mi
","on LHS")^^
INSERT INTO detail VALUES("3750","328","23.00","0","Turn left onto Hillsboro Ave","0.5 mi",NULL)^^
INSERT INTO detail VALUES("3874","330","10.00","0","Turn left to stay on Goshen Trail","2.2 mi
",NULL)^^
INSERT INTO detail VALUES("3728","328","16.00","0","Merge with Goshen Trail","0.1 mi",NULL)^^
INSERT INTO detail VALUES("3598","323","11.00","0","Turn left onto Sunset Point Rd
","125 ft
",NULL)^^
INSERT INTO detail VALUES("3599","323","12.00","480","Turn right onto Greenhill Dr
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3597","323","10.00","0","Turn right onto Nugget Dr
","0.5 mi
",NULL)^^
INSERT INTO detail VALUES("3596","323","9.00","0","Turn left onto Union St
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3718","328","9.00","0","Head back to Formosa Rd","0.2 mi",NULL)^^
INSERT INTO detail VALUES("3588","323","1.00","0","Cross Virginia onto Vine Ave","0.4 mi
","840 Virginia St ; Dunedin, FL")^^
INSERT INTO detail VALUES("3584","322","16.00","0","Turn right
","318 ft","Best Buy ; 21415 US Hwy 19 N")^^
INSERT INTO detail VALUES("3583","322","15.00","0","Turn left onto Drew St
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("3589","323","2.00","0","Turn left onto Lyndhurst St
","102 ft
",NULL)^^
INSERT INTO detail VALUES("3041","298","11.00","447","Turn right
","0.3 mi","and then sharp right onto path to bridge in Devinska Nova Ves")^^
INSERT INTO detail VALUES("3576","322","12.00","0","Turn right onto Old Coachman Rd
","0.5 mi
",NULL)^^
INSERT INTO detail VALUES("4612","366","1.00","0","Head north (Rt) on SE Delaware Ave for 4.3 mi","0","from Quality Inn; becomes NE 22nd St after 3.3 mi")^^
INSERT INTO detail VALUES("1242","207","9.00","0","Turn left onto Hawthorne Ave
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("1243","207","10.00","0","Turn right onto Thatcher Ave
","85 ft","River Forest Metra")^^
INSERT INTO detail VALUES("1149","203","10.00","0","Turn right onto Knox Hwy 3
","2.6 mi
","Leaving Oneida")^^
INSERT INTO detail VALUES("1150","203","11.00","0","Turn right onto Knox Hwy 4
","3.4 mi","Becomes W Main in <b>Altona</B>")^^
INSERT INTO detail VALUES("1152","203","12.00","0","Turn left onto US-34","4.6 mi
",NULL)^^
INSERT INTO detail VALUES("1225","113","12.00","0","UP West from River Forest","0.3 mi","CTA Blue Line, $3")^^
INSERT INTO detail VALUES("1153","203","13.00","0","Turn left onto E 1570th St
","1.0 mi","Go 1 more mi if not paved")^^
INSERT INTO detail VALUES("1155","203","15.00","0","Turn left onto E 1670th St","2.1 mi","becomes <b>Bishop Hill</b> Rd then Co Hwy 39 after leaving Bishop Hill. P J Johnson Restaurant, Bishop Hill Bakery, Filling Station")^^
INSERT INTO detail VALUES("1157","203","16.00","0","Turn right onto N 400th Ave","4.9 mi","or continue to N 570th Ave (may be less hilly but some traffic)")^^
INSERT INTO detail VALUES("1158","203","17.00","0","Turn left onto E 2150th St","1.5 mi","or continue to 2250 or 2350")^^
INSERT INTO detail VALUES("1159","203","18.00","0","Turn right onto N 570th Ave
","3.5 mi",NULL)^^
INSERT INTO detail VALUES("1160","203","19.00","0","Turn left onto Red Adams Rd
","1.0 mi
",NULL)^^
INSERT INTO detail VALUES("1161","203","20.00","0","Turn slightly left onto Rose St","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("1162","203","21.00","0","Turn left onto S Boss St
","364 ft
",NULL)^^
INSERT INTO detail VALUES("1163","203","22.00","0","Turn right onto Commercial St
","0.4 mi","becomes W 2nd St after slight right")^^
INSERT INTO detail VALUES("3038","298","9.00","0","Turn left onto Kremelská
","0.2 mi","main road, bike path?? on LHS")^^
INSERT INTO detail VALUES("1166","203","23.00","0","Turn left onto W 3rd St
","0.1 mi","Kewanee Amtrak Station on left")^^
INSERT INTO detail VALUES("3037","298","8.00","0","Turn right
","0.2 mi
","at chapel and cemetary on right")^^
INSERT INTO detail VALUES("3036","298","7.00","0","Turn left onto Muránská
","197 ft
","at main road")^^
INSERT INTO detail VALUES("3034","298","6.00","446","Turn right onto Hutnícka
","0.6 mi","in Devin; 1 blk past main road to right; becomes Brigádnická")^^
INSERT INTO detail VALUES("3032","298","5.00","0","Stay on bike path","3.7 mi","at hyway interchange, becomes Slovanske nabrezie")^^
INSERT INTO detail VALUES("1195","203","14.00","0","Turn right onto N 200th Ave","1.1 mi",NULL)^^
INSERT INTO detail VALUES("3044","299","1.00","0","Head upstream on Fritz-Schäffer-Promenade","2.0 mi","becomes Regensburger Str./B8")^^
INSERT INTO detail VALUES("1226","113","1.00","0","Naperville",NULL,"arrive 9:47")^^
INSERT INTO detail VALUES("3028","298","2.00","448","Turn left onto sidewalk","0.2 mi
","blue hiking sign, cars parked to left")^^
INSERT INTO detail VALUES("3029","298","3.00","0","Turn left
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3030","298","4.00","0","Merge left onto bike path","0.3 mi","LHS of Devínska cesta")^^
INSERT INTO detail VALUES("3027","298","1.00","0","Head west along river promenade","1.7 mi
","from Bratislava dock. Pass under bridge, turn right at woods")^^
INSERT INTO detail VALUES("1241","207","8.00","0","Turn right onto Keystone Ave
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("1240","207","7.00","0","Turn left onto Vine St
","387 ft
",NULL)^^
INSERT INTO detail VALUES("1238","207","5.00","0","Turn right","0.1 mi
","at T")^^
INSERT INTO detail VALUES("1237","207","4.00","0","Turn left into Cemetery","0.3 mi
","1st left after bridge. Continue straight 0.4 mi for Forest Park Blue Line station")^^
INSERT INTO detail VALUES("3641","326","1.00","483","Head east on Virginia (becomes Achieva Way at Keene)","1.6 mi","840 Virginia St
; Dunedin, FL")^^
INSERT INTO detail VALUES("3639","325","7.00","0","Turn left onto Stag Run Blvd
","0.5 mi
",NULL)^^
INSERT INTO detail VALUES("4064","342","4.00","0","Use the right 2 lanes to merge onto I-275",NULL,NULL)^^
INSERT INTO detail VALUES("5545","411","8.00","0","Turn right onto Oakwood Blvd
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3637","325","6.00","0","Turn right onto Wetherington Rd
","0.1 mi",NULL)^^
INSERT INTO detail VALUES("3636","325","5.00","0","Turn left onto Old Coachman Rd
","121 ft
",NULL)^^
INSERT INTO detail VALUES("5543","411","6.00","571","Turn right onto Forest Lakes Blvd
","410 ft
","bike path of right, cross RR then FL 580")^^
INSERT INTO detail VALUES("5542","411","5.00","0","Turn right onto Oldsmar Trail
","0.5 mi
","at end of street")^^
INSERT INTO detail VALUES("3633","325","4.00","0","Turn left onto S Lagoon Cir
","0.2 mi",NULL)^^
INSERT INTO detail VALUES("3715","328","6.00","489","Turn right onto Formosa Rd
","0.8 mi",NULL)^^
INSERT INTO detail VALUES("3631","325","2.00","0","Turn left onto Manor Blvd N
","489 ft
",NULL)^^
INSERT INTO detail VALUES("3632","325","3.00","0","Turn right onto Ragland Ave
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3626","324","17.00","0","Turn left onto Lawson Rd
","0.4 mi
","shopping center with Sprouts to right")^^
INSERT INTO detail VALUES("3623","324","14.00","0","Continue onto Americus Dr
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3624","324","15.00","0","Americus Dr turns right and becomes Albany Dr
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3625","324","16.00","0","Turn left onto Sunset Point Rd
","0.5 mi
",NULL)^^
INSERT INTO detail VALUES("3630","325","1.00","482","Turn right onto N Belcher Rd
","446 ft
","See ? to Best Buy for direction to Sunnydale Blvd & Belcher")^^
INSERT INTO detail VALUES("3416","313","25.00","0","Turn left onto W 3rd St
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("4029","339","3.00","0","Turn left onto E Bauer Rd
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("4030","339","4.00","0","Turn right onto N Washington St
","1.3 mi
","Cross over I88, cross Warrensville Rd at light, take path into Harrick Lake preserve")^^
INSERT INTO detail VALUES("4031","339","5.00","508","Four left turns thru park","2.0 mi",NULL)^^
INSERT INTO detail VALUES("4038","207","1.00","509","Head north (left) on S 1st Ave","98 ft","from end of trail")^^
INSERT INTO detail VALUES("4035","339","6.00","0","Turn right onto Herrick Rd
","108 ft
","Cross Butterfield Rd at light")^^
INSERT INTO detail VALUES("4036","339","7.00","0","Continue onto Wiesbrook Rd S
","0.5 mi","Pass High School on left, turn right onto Ill Prairie Path")^^
INSERT INTO detail VALUES("4039","207","2.00","0","Turn right onto Maybrook Dr","0.4 mi","cross at light")^^
INSERT INTO detail VALUES("4040","207","3.00","0","Slight left to cross bike bridge","0.2 mi",NULL)^^
INSERT INTO detail VALUES("5541","411","4.00","0","Continue onto Mapleleaf Blvd
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("3627","324","18.00","0","Turn right onto Hidden Cove Ln
","449 ft","ALDI 24756 US Hwy 19 N, Clearwater, FL")^^
INSERT INTO detail VALUES("3592","323","5.00","0","Turn right onto Portree Dr
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("5019","395","12.00","0","Slight left to stay on Neal Smith Trail
","1.0 mi","Do not turn right toward IA 415, Take the pedestrian tunnel")^^
INSERT INTO detail VALUES("5011","395","3.00","0","Head north across NW 94th Ave","0.6 mi","from Cherry Glen campground parking lot")^^
INSERT INTO detail VALUES("2670","284","6.00","0","Backtrack on Ludwigstraße","121 ft",NULL)^^
INSERT INTO detail VALUES("2629","262","1.00","0","<b>Note</b>",NULL,"<b>Train S1</b> going towards <b>München Ost</b> also goes to <b>Rosenheimer Platz</b> but takes about 50 min.")^^
INSERT INTO detail VALUES("2672","284","9.00","0","Turn right on Messerschmittstraße","194 ft","Hotel on RHS after turn")^^
INSERT INTO detail VALUES("2673","284","7.00","0","Turn left onto Lilienthalstraße","0.1 mi",NULL)^^
INSERT INTO detail VALUES("2671","284","8.00","0","Turn right on footpath","0.1 mi","as street turns left. Office bld on RHS, parking lot on LHS, then thru field")^^
INSERT INTO detail VALUES("2665","284","1.00","431","Take S8 to Halbergmoos",NULL,"2nd Stop")^^
INSERT INTO detail VALUES("2666","284","2.00","0","take bus 698 (dir Hallbergmoos) to Messerschmittstraße",NULL,"5 min non-stop")^^
INSERT INTO detail VALUES("2667","284","5.00","0","<hR></hR>OR take bus 692 (dir Hallbergmoos Sportpark) to  Lilienthalstraße",NULL,"5 min non-stop")^^
INSERT INTO detail VALUES("3183","303","12.00","0","Turn right onto Seestraße/B307
","0.9 mi
","Continue to follow B307
 ")^^
INSERT INTO detail VALUES("3182","303","11.00","0","Turn left onto Schloßpromenade
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3180","303","9.00","0","Turn right onto Tegernseer Str./B307
","2.6 mi
","Continue to follow B307
 ")^^
INSERT INTO detail VALUES("3181","303","10.00","459","Turn right toward Schloßpromenade
","33 ft
",NULL)^^
INSERT INTO detail VALUES("3179","303","8.00","0","Turn right onto Seeglas
","331 ft
",NULL)^^
INSERT INTO detail VALUES("3607","323","20.00","0","Turn right onto N Mars Ave
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3176","303","6.00","0","Turn right
","0.3 mi
","just before Seepromenade")^^
INSERT INTO detail VALUES("3177","303","7.00","0","Turn right","508 ft","at T, then immediately left")^^
INSERT INTO detail VALUES("3172","303","2.00","458","Head right on Wiesseer Str./B318","449 ft
","Gmund am Tegernsee BHF")^^
INSERT INTO detail VALUES("2668","284","3.00","0","Backtrack on Dornierstraße toward Messerschmittstraße","75 ft",NULL)^^
INSERT INTO detail VALUES("3186","303","15.00","0","Turn left toward Nördliche Hauptstraße/B307
","443 ft
",NULL)^^
INSERT INTO detail VALUES("4028","339","2.00","0","Turn left onto N Loomis St
","1.0 mi
",NULL)^^
INSERT INTO detail VALUES("4027","339","1.00","507","Head east on E 4th Ave","0.1 mi
","Left as you step off train at Naperville")^^
INSERT INTO detail VALUES("3593","323","6.00","0","Turn left onto Dunvegan Dr
","476 ft
",NULL)^^
INSERT INTO detail VALUES("3577","322","13.00","0","Turn right onto Ream Wilson Trail","0.3 mi",NULL)^^
INSERT INTO detail VALUES("3572","322","10.00","0","Turn right onto W Manor Ave
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3573","322","11.00","0","Turn left onto S Lagoon Cir
","0.2 mi",NULL)^^
INSERT INTO detail VALUES("3595","323","8.00","479","Turn left onto Lexington Dr
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("3433","316","2.00","0","Turn left onto Tenison Rd
","344 ft
",NULL)^^
INSERT INTO detail VALUES("3872","330","12.00","0","Turn left onto IL-157 S/N Bluff Rd
","0.4 mi
","Culvers on right as you turn")^^
INSERT INTO detail VALUES("3594","323","7.00","0","Turn right onto Patricia Ave
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3571","322","9.00","0","Turn left onto Manor Blvd N
","226 ft
",NULL)^^
INSERT INTO detail VALUES("3570","322","8.00","0","Turn right onto N Belcher Rd
","446 ft
",NULL)^^
INSERT INTO detail VALUES("3569","322","7.00","0","Turn left onto Sunnydale Blvd
","0.5 mi
",NULL)^^
INSERT INTO detail VALUES("3567","322","5.00","0","Turn left onto Sunset Point Rd
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3568","322","6.00","0","Turn right onto N Hercules Ave
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3565","322","3.00","0","Hastings Dr turns left and becomes Hastings Ln
","256 ft
",NULL)^^
INSERT INTO detail VALUES("3566","322","4.00","0","Turn right onto Barrington Dr W
","203 ft
",NULL)^^
INSERT INTO detail VALUES("3564","322","2.00","0","Turn right onto Hastings Dr
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3173","303","3.00","0","Turn right onto Ludwig-Erhard-Platz
","276 ft
",NULL)^^
INSERT INTO detail VALUES("3174","303","4.00","0","Turn right
","0.2 mi
","onto path, crossRR")^^
INSERT INTO detail VALUES("3563","322","1.00","478","Head east on Montclair Rd toward Seton Dr
","0.3 mi
","Montclair Rd & N Keene Rd
")^^
INSERT INTO detail VALUES("3175","303","5.00","0","Turn left
","184 ft
","cross lake")^^
INSERT INTO detail VALUES("3414","313","23.00","0","Slight left to stay on Commercial St
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3622","324","13.00","0","Slight left onto Belcher Rd
","121 ft
",NULL)^^
INSERT INTO detail VALUES("2669","284","4.00","0","Turn right onto Messerschmittstraße","220 ft","Hotel on left")^^
INSERT INTO detail VALUES("3406","313","18.00","0","Turn right onto  N 570th Ave","4.0 mi",NULL)^^
INSERT INTO detail VALUES("3417","313","26.00","0","Turn left
","125 ft
","Kewanee Station")^^
INSERT INTO detail VALUES("4391","368","11.00","544","Take exit 92 toward 1st St
","0.6 mi","turn left on 1st")^^
INSERT INTO detail VALUES("5540","411","3.00","0","Turn right to stay on Oldsmar Trail","0.5 mi",NULL)^^
INSERT INTO detail VALUES("5539","411","2.00","570","Turn left into Sheffield Park","0.1 mi","Or continue along Canal to Kayak launch")^^
INSERT INTO detail VALUES("5538","411","1.00","0","Take underpass to left; continue on Oldsmar Trail","0.8 mi","Parking lot to left on Curlew Rd just past McMullin & canal")^^
INSERT INTO detail VALUES("4282","356","3.00","0","Turn right onto W 23rd St
","0.1 mi","The Leo House on LHS")^^
INSERT INTO detail VALUES("4284","357","1.00","516","Exit the traffic circle onto W Martin St
","0.1 mi
","Raleigh Union Station ; 510 W Martin St,")^^
INSERT INTO detail VALUES("4285","357","2.00","0","Turn left onto S Harrington St
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("4312","362","7.00","0","Take exit 11A for I-277 S/NC-16 S/Brookshire Freeway E toward Downtown
","2.5 mi",NULL)^^
INSERT INTO detail VALUES("3870","330","14.00","0","Turn right onto Gateway Dr
","0.2 mi","Super 8 visible")^^
INSERT INTO detail VALUES("3871","330","13.00","0","Turn right onto Eastport Plaza Dr
","0.3 mi
","Regions Bank (on the right)")^^
INSERT INTO detail VALUES("3432","316","1.00","475","Head northwest on Great Northern Rd","0.1 mi
","Cycle Hire - Station; 156 Great Northern Rd
; Cambridge CB1 2FX, UK")^^
INSERT INTO detail VALUES("3431","315","6.00","0","Turn left onto 32nd St","266 ft","Hotel on right")^^
INSERT INTO detail VALUES("3430","315","5.00","474","Head northeast on 4th Ave toward 35th St","0.2 mi",NULL)^^
INSERT INTO detail VALUES("3869","330","15.00","0","Turn right onto Gateway Dr
","0.4 mi","opposite direction from arrival")^^
INSERT INTO detail VALUES("3429","315","4.00","0","N line (->86th St) OR D line (->Coney Island - Stillwell Av) to 36th Str",NULL,"23 min")^^
INSERT INTO detail VALUES("3428","315","3.00","0","Turn right onto W 34th St","0.1 mi","Herald Square subway NW corner of 34th & Brdwy")^^
INSERT INTO detail VALUES("3427","315","2.00","0","Turn left on 7th AV","0.1 mi",NULL)^^
INSERT INTO detail VALUES("3425","314","8.00","0","Turn left onto Virginia St
","0.1 mi
","840 Virginia St ; ")^^
INSERT INTO detail VALUES("3424","314","7.00","0","Turn right onto New York Ave
","0.8 mi
",NULL)^^
INSERT INTO detail VALUES("3423","314","6.00","0","Turn left onto San Christopher Dr
","194 ft
",NULL)^^
INSERT INTO detail VALUES("3422","314","5.00","0","Turn right onto Bass Blvd
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3421","314","4.00","0","Turn left onto San Salvador Dr
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3420","314","3.00","0","Turn right onto San Mateo Dr
","0.6 mi
",NULL)^^
INSERT INTO detail VALUES("3419","314","2.00","0","Turn left onto Buena Vista Dr N
","282 ft
",NULL)^^
INSERT INTO detail VALUES("3426","315","1.00","0","Take 7th Ave exit","200 ft","cross street on cross walk")^^
INSERT INTO detail VALUES("2340","248","7.00","0","Turn left onto Lobkowitzbr�cke","289 ft","Walk your bicycle")^^
INSERT INTO detail VALUES("2339","248","6.00","385","Head south on Ullmannstra�e","184 ft",NULL)^^
INSERT INTO detail VALUES("2345","249","1.00","386","Head northeast (R) on Bruno-Pittermann-Platz","486 ft
","Citybike Station 1201 L�ngenfeldgasse
; 1120 Wien, Austria")^^
INSERT INTO detail VALUES("2419","255","2.00","0","turn right & go diagonally thru park","210 m",NULL)^^
INSERT INTO detail VALUES("3867","330","17.00","0","Turn left onto Schoolhouse Trail","3.9 mi
",NULL)^^
INSERT INTO detail VALUES("3868","330","16.00","0","Turn right onto Eastport Plaza Dr
","0.7 mi","at T")^^
INSERT INTO detail VALUES("3866","330","18.00","0","Turn right onto Transit Nature Trail","0.5 mi
","Cross Horseshoe Lake Rd, then Il 162")^^
INSERT INTO detail VALUES("2420","255","3.00","0","Turn left onto József Attila u.","250 m",NULL)^^
INSERT INTO detail VALUES("2403","251","18.00","0","Turn left to Tegetthoffstrasse","0.2 mi","becomes Neuer Markt")^^
INSERT INTO detail VALUES("2402","251","17.00","0","Turn right at Albertinaplatz","49 ft
",NULL)^^
INSERT INTO detail VALUES("2421","255","4.00","0","Slight left onto Eötvös tér","20 m",NULL)^^
INSERT INTO detail VALUES("3865","330","19.00","0","Turn right to stay on Nature Trail","0.9 mi
","at T; Golf Course on left")^^
INSERT INTO detail VALUES("3864","330","20.00","0","Turn left onto Lake Dr
","200 ft
","Cross abandoned?  RR")^^
INSERT INTO detail VALUES("2320","245","14.00","0","Turn right onto L�ngenfeldgasse","0.1 mi","Bike stand <b>Längenfeldgasse 1201</b>")^^
INSERT INTO detail VALUES("3862","330","22.00","0","Turn right to stay on Nature Trail","1.7 mi","at Chain o Rocks Rd; cross road shortly, the veer left away from road")^^
INSERT INTO detail VALUES("3863","330","21.00","0","Turn right back onto Nature Trail","4.6 mi
","after a while loop around I 255")^^
INSERT INTO detail VALUES("3861","330","23.00","495","Continue onto Bluff Trail","1.1 mi","at St. Paul UCC; Nature Trail turns right, cross Stadium Drive after 0.2 mi")^^
INSERT INTO detail VALUES("2318","245","13.00","0","Continue onto Arndtstra�e","0.4 mi","at Hyw 221")^^
INSERT INTO detail VALUES("2410","251","13.00","0","Slight left onto Heumühlgasse","171 ft","at T")^^
INSERT INTO detail VALUES("2399","251","16.00","390","Turn left onto Operngasse","0.6 mi","past Karlsplatz")^^
INSERT INTO detail VALUES("2398","251","12.00","0","Turn left onto Schönbrunner Str.","0.4 mi",NULL)^^
INSERT INTO detail VALUES("2397","251","11.00","0","Turn right onto Pilgramgasse
","463 ft","Pass Billa on left")^^
INSERT INTO detail VALUES("2395","251","10.00","0","Continue onto Rechte Wienzeile
","0.7 mi","Slight left after 0.5 mi")^^
INSERT INTO detail VALUES("2394","251","9.00","0","Turn left","482 ft
","after river, before park")^^
INSERT INTO detail VALUES("2393","251","8.00","0","Turn right","184 ft
","back to RHS of river")^^
INSERT INTO detail VALUES("2392","251","7.00","0","Turn left","249 ft
","back to LHS of river")^^
INSERT INTO detail VALUES("2390","251","5.00","0","Slight left toward river","203 ft
","if turn missed, turn left at next T")^^
INSERT INTO detail VALUES("2391","251","6.00","389","Turn right at T","0.1 mi
","back to RHS of river")^^
INSERT INTO detail VALUES("2389","251","4.00","0","Turn right
","0.1 mi
","at T")^^
INSERT INTO detail VALUES("2388","251","3.00","0","Turn left on path","118 ft
","Dunklergasse straight ahead")^^
INSERT INTO detail VALUES("2387","251","2.00","0","Continue onto Rechte Wienzeile
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("2418","255","1.00","398","Head west on Deák Ferenc tér","44 m","toward river")^^
INSERT INTO detail VALUES("2386","251","1.00","0","Head northeast on Bruno-Pittermann-Platz","486 ft","Citybike Station 1201 Laengenfeldgasse")^^
INSERT INTO detail VALUES("2313","245","12.00","381","Continue on Margaretenstraße","1.3 mi","Jog right at Reinprechtsdorfer Str.")^^
INSERT INTO detail VALUES("2312","245","11.00","0","Turn left onto Operngasse
","0.4 mi","Just past Staatsoper; stay on Operngasse around Karlsplatz")^^
INSERT INTO detail VALUES("2350","249","6.00","0","Turn left onto Wiener G�rtel Str.","0.6 mi","Merge onto Gumpendorfer G�rtel")^^
INSERT INTO detail VALUES("2417","254","4.00","0","Turn right onto Driftwood Ln","0.5 mi","Into Laurel Park, Pavilion O")^^
INSERT INTO detail VALUES("2306","245","10.00","380","Continue on Ring (LHS)","1.1 mi","Stuben, Park, Schubert, cross to RHS, K�rntner, Opernring")^^
INSERT INTO detail VALUES("2341","248","8.00","0","Turn left onto Sch�nbrunner Str./B1","0.1 mi",NULL)^^
INSERT INTO detail VALUES("2342","248","9.00","0","Turn left onto Bruno-Pittermann-Platz
","433 ft","after 2 blocks")^^
INSERT INTO detail VALUES("2416","254","3.00","0","Turn left onto Barkwood Trails Dr","0.2 mi","stop light")^^
INSERT INTO detail VALUES("2305","245","9.00","0","Turn left onto Aspernbrücke
","328 ft
",NULL)^^
INSERT INTO detail VALUES("2415","254","2.00","0","Turn right onto Jungermann Rd","1.9 mi","White Castle, Burger King")^^
INSERT INTO detail VALUES("2414","254","1.00","396","Take exit 222B for Veterans Memorial Pkwy","2.4 Mi","At Midrivers Mall")^^
INSERT INTO detail VALUES("2800","292","3.00","0","Continue onto Furtmayrstraße","108 ft","Ibis on corner of Furtmayrstraße & Galgenbergstraße")^^
INSERT INTO detail VALUES("2349","249","5.00","0","Slight left toward river","203 ft
","at T (missed turn), turn left")^^
INSERT INTO detail VALUES("3717","328","8.00","0","Turn right
","210 ft","Super 8 by Wyndham Troy IL/St. Louis Area
; Exit 18, 910 Edwardsville Rd, I-55, Troy, IL 62294
")^^
INSERT INTO detail VALUES("2347","249","3.00","0","Turn left","118 ft
","Only choice")^^
INSERT INTO detail VALUES("3415","313","24.00","0","Continue onto W 2nd St
","387 ft
",NULL)^^
INSERT INTO detail VALUES("3413","313","22.00","0","Turn right onto Commercial St
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3412","313","21.00","0","Turn left onto S Boss St
","364 ft
",NULL)^^
INSERT INTO detail VALUES("2425","256","3.00","0","RJ61 dep 11:40 track  9C-E",NULL,"arrive 14:19")^^
INSERT INTO detail VALUES("2348","249","4.00","0","Turn right","0.1 mi
","at T")^^
INSERT INTO detail VALUES("2424","256","2.00","0","U 1 (Wien Oberlaa)",NULL,"every 5 min, takes 6 min")^^
INSERT INTO detail VALUES("3410","313","19.00","465","Turn left onto Red Adams Rd
","1.0 mi
",NULL)^^
INSERT INTO detail VALUES("3411","313","20.00","0","Red Adams Rd turns slightly left and becomes Rose St
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("3439","316","8.00","0","At the roundabout, take the 1st exit onto Newnham Rd/A603
","0.5 mi
","Bear right at Barton Rd (end of park)")^^
INSERT INTO detail VALUES("2346","249","2.00","0","Continue onto Rechte Wienzeile
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("2423","256","1.00","0","8:58 Meidling Hauptstraße U4 (Spittelau); 9:14 Landstraße; U3 (Ottokring) 2 stops -> 9:16
9:14 AM",NULL,"5 min to change at landstrasse")^^
INSERT INTO detail VALUES("5021","395","13.00","0","Turn left to stay on Neal Smith Trail
","5.0 mi","Before Parker Blvd")^^
INSERT INTO detail VALUES("5023","395","14.00","0","Beach is on left","0 ft",NULL)^^
INSERT INTO detail VALUES("5026","395","1.00","0","Turn right onto SE Delaware Ave 0.1 mi","0","from Quality Inn")^^
INSERT INTO detail VALUES("5027","395","2.00","0","Use the left 2 lanes to turn left onto E 1st St, 5.1 mi","0.6 mi","detour via Irvinedale, 5th, Weigel if necessary. becomes NW 94th av, parking lot on left")^^
INSERT INTO detail VALUES("5028","395","6.00","564","slight left onto campground road","0.8 mi","leave bike bath")^^
INSERT INTO detail VALUES("2124","239","11.00","0","Turn right
","331 ft
","after going under road to Austria")^^
INSERT INTO detail VALUES("2121","239","10.00","0","Slight left onto bike path on LHS of Kremeľská","2.2 mi","pass turn off to town of <b>Kostolne</b>")^^
INSERT INTO detail VALUES("2120","239","9.00","0","Turn left onto Muránská at Kremeľská","0.1 mi","Turn right past cemetery on right")^^
INSERT INTO detail VALUES("2119","239","8.00","0","Continue onto Brigádnická","0.4 mi","Cafe Eden (Pilsner beer sigh) down street to left")^^
INSERT INTO detail VALUES("2118","239","7.00","0","Turn right onto Hutnícka
","0.2 mi
","along side Penzión a Reštaurácia U SrnÄíka; town of <b>Devin</B>")^^
INSERT INTO detail VALUES("2117","239","6.00","0","Continue onto Slovanské nábrežie
","0.3 mi
","don't turn right on Kremelska")^^
INSERT INTO detail VALUES("2115","239","5.00","0","Left onto Devínska cesta","3.4 mi","after crossing road; <b>or</b> stay on sidewalk on LHS as far as possible")^^
INSERT INTO detail VALUES("2114","239","4.00","0","Stay on bike path on LHS of Devínska cesta","0.3 mi
","gate?")^^
INSERT INTO detail VALUES("2113","239","3.00","0","Bear left on bike path","0.3 mi
","in front of small, brown shed; parking lot to right")^^
INSERT INTO detail VALUES("2112","239","2.00","0","Turn left onto bike path","0.2 mi
","after Vodácky klub Tatran Karlova Ves (orange); before Vodácky klub Tatran Karlova Ves")^^
INSERT INTO detail VALUES("2110","239","1.00","0","Head west on promenade between Dvořákovo nábrežie and river","1.8 mi","<b>Ship dock</b>")^^
INSERT INTO detail VALUES("2125","239","12.00","0","Sharp right onto road to Austria","0.6 mi
","Gril bar tenis to east; cross river into Austria")^^
INSERT INTO detail VALUES("2126","239","13.00","0","Continue onto Markthof","0.5 mi
","Slight right?")^^
INSERT INTO detail VALUES("2127","239","14.00","0","Turn right onto L3001
","2.8 mi","Schloßhof (Prince Eugene's palace) straight ahead")^^
INSERT INTO detail VALUES("2129","239","15.00","0","Turn left onto Am Bahnhof
","240 ft","<b>Marchegg Bahnhof</b>")^^
INSERT INTO detail VALUES("2257","243","28.00","0","Turn left onto L11
","112 ft
",NULL)^^
INSERT INTO detail VALUES("2258","243","29.00","0","Turn right onto Pysdorf
","0.5 mi","becomes Am Bahnhof at <b>Raasdorf BHF</b>")^^
INSERT INTO detail VALUES("2256","243","27.00","0","Turn right
","1.1 mi
","stay with RR on right")^^
INSERT INTO detail VALUES("2255","243","26.00","0","Turn left
","115 ft
",NULL)^^
INSERT INTO detail VALUES("2254","243","25.00","0","Turn right
","1.1 mi
","first right after RR & <b>Glinzendorf BHF</b>")^^
INSERT INTO detail VALUES("2249","243","21.00","0","Turn right
","0.8 mi","first path/farm road; becomes Wienerweg; toward Cholerakapelle")^^
INSERT INTO detail VALUES("2251","243","23.00","0","Slight right onto L6","0.3 mi",NULL)^^
INSERT INTO detail VALUES("2252","243","24.00","0","Turn left onto Glinzendorf
","0.6 mi","shortly thereafter take either fork")^^
INSERT INTO detail VALUES("2248","243","20.00","0","Turn left onto Br�ckengasse","0.1 mi
","at T at edge of town")^^
INSERT INTO detail VALUES("2247","243","19.00","0","Turn right to stay on Dorfstra�e","0.2 mi
","first street")^^
INSERT INTO detail VALUES("2246","243","18.00","0","Turn left to stay on Dorfstra�e","361 ft
","first street")^^
INSERT INTO detail VALUES("2242","243","14.00","0","Slight right onto Freundschaftsgasse
","98 ft
",NULL)^^
INSERT INTO detail VALUES("2243","243","15.00","0","Continue onto Sch�nfelderstra�e","0.1 mi
","Left fork")^^
INSERT INTO detail VALUES("2244","243","16.00","0","Turn left onto Bahnstraße
","171 ft
",NULL)^^
INSERT INTO detail VALUES("2245","243","17.00","0","Turn right onto Dorfstra�e","0.1 mi
","first street; <B>Untersiebenbrunn BHF</b> 5 blocks straight ahead")^^
INSERT INTO detail VALUES("2226","243","2.00","0","Turn left onto Bahnstraße
","351 ft
",NULL)^^
INSERT INTO detail VALUES("2227","243","3.00","0","Turn left to stay on Bahnstra�e","0.3 mi","Becomes Berggasse")^^
INSERT INTO detail VALUES("2229","243","4.00","0","Turn left onto Friedweg
","417 ft","slight left after 217 ft")^^
INSERT INTO detail VALUES("2231","243","5.00","0","Turn right onto Breitenseer Str.
","1.8 mi","becomes L3003 at hwy 49")^^
INSERT INTO detail VALUES("2233","243","6.00","0","Turn right at Säulenweg
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("2234","243","7.00","0","Turn right at Seeweg
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("2235","243","8.00","0","Turn left
","1.6 mi
","Left fork after 0.5 mi")^^
INSERT INTO detail VALUES("2236","243","9.00","0","Turn right","0.9 mi
","at crooked T")^^
INSERT INTO detail VALUES("2237","243","10.00","0","Continue straight onto Wagramstraße
","0.6 mi
",NULL)^^
INSERT INTO detail VALUES("2238","243","11.00","0","Turn right onto L4
","0.3 mi
","<b>Bahnhof Schönfeld-Lassee</b> 3 blocks staight ahead")^^
INSERT INTO detail VALUES("2239","243","12.00","0","Turn left
","1.2 mi","become Meierhof after 0.5 mi")^^
INSERT INTO detail VALUES("2240","243","13.00","0","Slight left onto L2","1.7 mi","Wiener Strasse to right")^^
INSERT INTO detail VALUES("2225","243","1.00","0","Head northeast on Am Bahnhof","240 ft
","<b>Marchegg Bahnhof</b>")^^
INSERT INTO detail VALUES("2260","243","30.00","0","Turn right onto L5
","322 ft
",NULL)^^
INSERT INTO detail VALUES("2261","243","31.00","0","Turn left
","0.9 mi","after crossing RR; continue straight at  L2")^^
INSERT INTO detail VALUES("2264","243","32.00","0","Turn left toward Guntherstra�e","0.3 mi
","at 2nd lake")^^
INSERT INTO detail VALUES("2265","243","33.00","0","Turn left onto Guntherstraße
","0.5 mi
",NULL)^^
INSERT INTO detail VALUES("2266","243","34.00","0","Turn right onto Wolfgang-Mühlwanger-Straße
","1.4 mi
",NULL)^^
INSERT INTO detail VALUES("2267","243","35.00","0","Turn right onto Cassinonestraße
","361 ft
",NULL)^^
INSERT INTO detail VALUES("2268","243","36.00","0","Turn left onto Ostbahnbegleitstra�e","1.7 mi
","<b>Aspern Nord Ubahn</b> to right after 0.6 mi")^^
INSERT INTO detail VALUES("2269","243","37.00","0","Continue straight at Hausfelderstrasse","0.1 mi","<b>Wien HausFelderstrasse BHF<b>")^^
INSERT INTO detail VALUES("2272","243","22.00","0","Continue onto Wienerweg","3.5 mi","after 0.9 mi <b>Siebenbrunn-Leopoldsdorf BHF</b> is 0.4 mi South;")^^
INSERT INTO detail VALUES("2334","248","2.00","0","Turn left onto Niederhofstraße
","348 ft
",NULL)^^
INSERT INTO detail VALUES("2304","245","8.00","0","Turn right onto Sch�ttelstra�e/B227","0.5 mi
","Continue to follow B227. Also bike path to left along river")^^
INSERT INTO detail VALUES("2303","245","7.00","0","Turn left onto Helenengasse
","295 ft
","right after RR")^^
INSERT INTO detail VALUES("2302","245","6.00","0","Turn right onto Vivariumstrasse","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("2301","245","5.00","0","Turn left at T in bike path","46 ft
",NULL)^^
INSERT INTO detail VALUES("2300","245","4.00","0","Turn right onto bike path","203 ft
",NULL)^^
INSERT INTO detail VALUES("2299","245","3.00","0","Turn left onto Hauptallee
","112 ft
",NULL)^^
INSERT INTO detail VALUES("2298","245","2.00","0","Slight right onto Antifaschismusplatz","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("2333","248","1.00","367","Head north on Vivenotgasse","0.4 mi
","Bike Station <b>1203 Vivenotgasse</b> across main street from Station")^^
INSERT INTO detail VALUES("2297","245","1.00","379","Head southeast from Riesenradplatz toward Eduard Lang Weg","72 ft
","<b>Riesenrad</b>")^^
INSERT INTO detail VALUES("2335","248","3.00","0","Continue onto Meidlinger Hauptstraße
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("2336","248","4.00","0","Continue onto Lobkowitzbrücke
","256 ft
",NULL)^^
INSERT INTO detail VALUES("2337","248","5.00","0","Continue onto Ullmannstra�e","1.4 mi","<b>Renaissance Wien Hotel No. 71</b>")^^
INSERT INTO detail VALUES("2343","248","10.00","0","Turn left to stay on Bruno-Pittermann-Platz","256 ft","Bike Station <b>Längenfeldgasse 1201</b> on the right")^^
INSERT INTO detail VALUES("2352","249","7.00","387","Turn right onto Mariahilfer Str.
","0.7 mi
","Near Westbahnhof")^^
INSERT INTO detail VALUES("2353","249","8.00","0","Turn left onto Kirchengasse
","0.3 mi","at Mariahilf church")^^
INSERT INTO detail VALUES("2355","249","9.00","0","Turn right onto Burggasse/B223
","0.4 mi","becomes Bellariastrasse at back of Museums")^^
INSERT INTO detail VALUES("2357","249","10.00","0","Turn left onto Dr.-Karl-Renner-Ring
","1.0 mi","becomes Universit�ts, Schottenring")^^
INSERT INTO detail VALUES("2362","249","11.00","388","Slight right, sharp left onto Franz-Josefs-Kai","0.7 mi
",NULL)^^
INSERT INTO detail VALUES("2363","249","12.00","0","Turn right at Alserbachstra�e","400 ft
","cross bridge")^^
INSERT INTO detail VALUES("2364","249","13.00","0","Turn left onto path","1.7 mi","after crossing river")^^
INSERT INTO detail VALUES("2366","249","14.00","0","Turn right then sharp left toward Steinitzsteg","0.2 mi",NULL)^^
INSERT INTO detail VALUES("2368","249","15.00","0","Continue onto Steinitzsteg
","0.3 mi
","Bike bridge")^^
INSERT INTO detail VALUES("2369","249","16.00","0","Turn right onto Donauinsel
","2.3 mi","1st right after crossing river")^^
INSERT INTO detail VALUES("2377","249","17.00","0","Turn right
","0.4 mi
","to cross Danube")^^
INSERT INTO detail VALUES("2378","249","18.00","0","Slight right onto Lassallestrasse/B8","0.4 mi",NULL)^^
INSERT INTO detail VALUES("2379","249","19.00","393","Turn left onto Venediger Au","190 ft
",NULL)^^
INSERT INTO detail VALUES("2380","249","20.00","0","Turn right on path in park","0.3 mi","<b>Prater</b>")^^
INSERT INTO detail VALUES("2406","251","19.00","0","Turn left to stay on Neuer Markt
","92 ft
",NULL)^^
INSERT INTO detail VALUES("2407","251","20.00","0","Turn right onto Seilergasse
","469 ft
","Walk your bicycle
 ")^^
INSERT INTO detail VALUES("2408","251","21.00","0","Turn right at Graben
","79 ft
","Walk your bicycle
 ")^^
INSERT INTO detail VALUES("2409","251","22.00","0","Turn left onto Stock-im-Eisen-Platz
","351 ft
","<b>Stephansdom")^^
INSERT INTO detail VALUES("2411","251","14.00","0","Turn right onto Mühlgasse","0.3 mi",NULL)^^
INSERT INTO detail VALUES("2412","251","15.00","0","Turn right onto Faulmanngasse","178 ft","at T")^^
INSERT INTO detail VALUES("2422","255","5.00","0","Turn left onto Széchenyi István tér","27 m","Sofitel Budapest Chain Bridge left")^^
INSERT INTO detail VALUES("3249","306","6.00","0","Turn left to stay on Bahnhofstraße
","36 ft
","Vilshofen(Niederbay); ")^^
INSERT INTO detail VALUES("3247","306","4.00","0","Turn left onto Passauer Str.
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3248","306","5.00","0","Turn right onto Bahnhofstraße
","276 ft
",NULL)^^
INSERT INTO detail VALUES("3244","306","1.00","462","Head southeast","446 ft
","downstream from dock")^^
INSERT INTO detail VALUES("3440","316","9.00","0","Airbnb 36 Barton Rd (RHS)",NULL,"Enter from Barton Close")^^
INSERT INTO detail VALUES("3245","306","2.00","0","Turn right onto Kirchpl.
","0.2 mi
","cross river")^^
INSERT INTO detail VALUES("3246","306","3.00","0","Continue onto Vilsvorstadt
","433 ft
","Partial restricted usage road
 ")^^
INSERT INTO detail VALUES("2798","292","1.00","441","Head south out of center of station","0.1 mi","tunnel, bridge, walkway? across tracks")^^
INSERT INTO detail VALUES("3240","304","8.00","0","Slight left onto Sonnenweg
","0.7 mi
",NULL)^^
INSERT INTO detail VALUES("3241","304","9.00","0","Turn right onto Bahnstraße
","266 ft
","Weikendorf Bahnhof; ")^^
INSERT INTO detail VALUES("3234","304","4.00","0","Turn right onto Bernstein Str./B49
","0.7 mi
",NULL)^^
INSERT INTO detail VALUES("3235","304","5.00","0","Turn left
","1.3 mi","stay left at next fork")^^
INSERT INTO detail VALUES("3233","304","3.00","0","Continue onto Bahnstraße/L3001
","0.9 mi
","In Marchegg Bahnhof")^^
INSERT INTO detail VALUES("3231","304","1.00","460","Head northwest
","0.5 mi
","From Freedom Bridge")^^
INSERT INTO detail VALUES("3232","304","2.00","0","Turn right onto L3001
","2.8 mi
","Straight for Schlosshof")^^
INSERT INTO detail VALUES("2801","261","2.00","442","Head northeast on Szent István park
","213 ft
","Opposite direction as  bus")^^
INSERT INTO detail VALUES("2454","261","1.00","0","Bus 76 to Szent István park","0.3 mi","From Munkás u, dir Jászai Mari tér, after Victor Hugo U.")^^
INSERT INTO detail VALUES("2803","261","4.00","0","Turn left to stay on Szent István park
","433 ft
","at T called Újpesti rkp. to right")^^
INSERT INTO detail VALUES("2804","261","5.00","0","Turn right onto Carl Lutz rkp","0.2 mi","1st right, slight left (cross street?)")^^
INSERT INTO detail VALUES("2799","292","2.00","0","Turn left onto Friedenstraße","0.1 mi",NULL)^^
INSERT INTO detail VALUES("2802","261","3.00","0","Turn left to stay on Szent István park
","0.1 mi
","1st left, then turns right, then left")^^
INSERT INTO detail VALUES("2458","262","2.00","0","Take <b>train S8</b> to  <b>Rosenheimer Platz</b> (train going towards Herrsching)",NULL,"10th stop, next one after Munich Ost (34 min)")^^
INSERT INTO detail VALUES("2459","262","3.00","0","Take <b>tram 15</b> to <b>Tegernseer Landstrasse</b> (going towards Großhesseloher Brücke)",NULL,"4th stop, next after Silberhornstraße
 (6 min.)")^^
INSERT INTO detail VALUES("2460","262","4.00","427","Walk south on Tegernseer Landstraße","161 ft","same direction as tram")^^
INSERT INTO detail VALUES("2461","262","5.00","0","Turn left to stay on Tegernseer Landstraße","384 ft","sidewalk on LHS")^^
INSERT INTO detail VALUES("2462","262","6.00","0","Turn left onto Raintaler Str.","112 ft","Ibis on right")^^
INSERT INTO detail VALUES("3621","324","12.00","481","Continue onto Montclair Rd
","1.3 mi
",NULL)^^
INSERT INTO detail VALUES("3438","316","7.00","0","At the roundabout, take the 2nd exit onto The Fen Causeway/A1134
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("3404","313","17.00","0","Turn left onto N Center Ave
","4.6 mi","becomes 2050 E/E 2100th St leaving Galva")^^
INSERT INTO detail VALUES("3403","313","16.00","0","Slight right onto NW 2nd St
","217 ft
",NULL)^^
INSERT INTO detail VALUES("3402","313","15.00","0","Turn right onto Main St
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3401","313","14.00","467","Turn left onto <b>SW 4th Avenue</b>","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3620","324","11.00","0","Turn left onto Algonquin Dr
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3400","313","13.00","0","Slight right onto <b>SW 4th Street</b>","0.2 mi
","entering <i><b>Galva</b></i>")^^
INSERT INTO detail VALUES("3418","314","1.00","472","Slight right onto Fred Marquis Pinellas Trail
","1.1 mi
","trail & curlew")^^
INSERT INTO detail VALUES("3397","313","12.00","0","Continue onto Hayes Rd
","1.9 mi","slight left, right, left")^^
INSERT INTO detail VALUES("3396","313","11.00","354","Turn right onto S County Rd/N Knox Rd
","0.7 mi
","2nd right, if gravel continue straight to US 34")^^
INSERT INTO detail VALUES("3395","313","10.00","0","Turn left onto 1800 E","2.5 mi
","3rd Left")^^
INSERT INTO detail VALUES("3393","313","9.00","0","Turn right onto E Main St
","3.5 mi","in <i><b>Altona</b></i>; becomes Knox Hwy 4")^^
INSERT INTO detail VALUES("3388","313","6.00","0","Slight right to stay on Knox Rd 1100 E","0.2 mi",NULL)^^
INSERT INTO detail VALUES("3618","324","9.00","0","Turn left onto Union St
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3390","313","7.00","0","Turn left onto Knox Rd 1125 E
","1.3 mi","becomes  S Center St in <i><b>Oneida</b></i>")^^
INSERT INTO detail VALUES("3392","313","8.00","0","Turn right onto US-34 E
","4.2 mi
",NULL)^^
INSERT INTO detail VALUES("3386","313","4.00","463","Slight right onto IL-167 E","2.3 mi
","Leaving Wataga")^^
INSERT INTO detail VALUES("3387","313","5.00","0","Turn left onto Knox Rd 1100 E","1.4 mi
","second left")^^
INSERT INTO detail VALUES("3619","324","10.00","0","Turn right onto Nugget Dr
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("3617","324","8.00","0","Turn left onto Lexington Dr
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("3616","324","7.00","0","Turn right onto Patricia Ave
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("3380","313","1.00","466","Turn right onto S Seminary St
","0.4 mi
","Galesburg station")^^
INSERT INTO detail VALUES("3381","313","2.00","0","Turns right onto E North St","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("3382","313","3.00","0","Turn left onto Lincoln St
","7.1 mi","becomes  Old US Hwy 34, then Depot St in <i><b>Wataga</b></i>")^^
INSERT INTO detail VALUES("3615","324","6.00","0","Turn left onto Dunvegan Dr
","476 ft
",NULL)^^
INSERT INTO detail VALUES("3610","324","1.00","0","Cross Virginia onto Vine Ave","0.4 mi
","840 Virginia St ; Dunedin, FL")^^
INSERT INTO detail VALUES("3611","324","2.00","0","Turn left onto Lyndhurst St
","102 ft
",NULL)^^
INSERT INTO detail VALUES("3612","324","3.00","0","Turn right onto 3rd Ave
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("3613","324","4.00","0","Turn left onto Beltrees St
","220 ft
",NULL)^^
INSERT INTO detail VALUES("3614","324","5.00","0","Turn right onto Portree Dr
","0.1 mi
","optional thru Skyloch villas")^^
INSERT INTO detail VALUES("3230","303","1.00","0","Silberhornstr->HBF U2 18/hr. 6 min.<br> Wettersteinplz.->HBF U1 1988/hr, 9-11 min",NULL,"HBF Gl 27-36 to Gmund am Tegernsee dep 9:04, 9:24, 10:04 1:05-1:12<br>
Radius bike rental track 33 open 8:30AM-8:pm, 16E/day")^^
INSERT INTO detail VALUES("5025","395","5.00","0","Continue onto bike path","0.9 mi","just past picnic shelter #1")^^
INSERT INTO detail VALUES("4613","366","2.00","0","Turn left onto NE 126th Ave for 1.0 mi","0",NULL)^^
INSERT INTO detail VALUES("5537","410","3.00","0","Turn left onto W 25th St
","197 ft
"," Destination will be on the right
")^^
INSERT INTO detail VALUES("4513","366","12.00","0","Continue on High Tressle Trail","2.6 Miles","to Tressle")^^
INSERT INTO detail VALUES("4657","387","4.00","0","Turn right onto 4th St E","0",NULL)^^
INSERT INTO detail VALUES("4658","387","5.00","0","Turn left onto N Market St 0.3 mi","0","Trail parking lot on LHS")^^
INSERT INTO detail VALUES("5536","410","2.00","0","Turn right onto 7th Ave
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("5535","410","1.00","569","Head southeast on W 31st St toward 8th Ave
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("4656","387","3.00","0","Turn left onto N Jefferson St 0.9 mi","0",NULL)^^
INSERT INTO detail VALUES("4653","387","23.00","0","Turn left onto bridge on Market St.","0.2 mi","sidewalk on right")^^
INSERT INTO detail VALUES("4654","387","1.00","0","Take exit 35 toward Pennsylvania Ave 0.4 mi","0","from US 63 southbound")^^
INSERT INTO detail VALUES("4655","387","2.00","0","Turn right onto 100th St 1.0 mi","0","100th becomes Pennsylvania Ave")^^
INSERT INTO detail VALUES("4636","387","6.00","563","Turn right onto bike path","0.3 mi
","towards river out of parking lot")^^
INSERT INTO detail VALUES("4637","387","7.00","0","Slight right
","0.3 mi
","cross river")^^
INSERT INTO detail VALUES("4638","387","8.00","562","Continue onto Bike Trail","1.1 mi
","cross under US 34")^^
INSERT INTO detail VALUES("4639","387","9.00","0","Turn left onto E Mary St
","0.2 mi
","Ideal auto repair on left")^^
INSERT INTO detail VALUES("4640","387","10.00","0","Turn left onto bike Trail","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("4641","387","11.00","0","Take the pedestrian tunnel
","1.2 mi
","Under US 34")^^
INSERT INTO detail VALUES("4642","387","12.00","0","Turn left onto Church St
","0.5 mi
","Bridge View Center on left")^^
INSERT INTO detail VALUES("4643","387","13.00","0","Turn right onto Myrtle St
","305 ft
",NULL)^^
INSERT INTO detail VALUES("4644","387","14.00","0","Turn left onto Chief Wapello Trail
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("4645","387","15.00","0","Turn right onto Lark Ln
","0.6 mi
",NULL)^^
INSERT INTO detail VALUES("4646","387","16.00","0","Continue onto Swan Ln
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("4647","387","17.00","0","Turn right onto Teal Dr
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("4648","387","18.00","0","Continue onto Swallow Dr
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("4649","387","19.00","0","Continue onto Mallard Dr
","0.3 mi
",NULL)^^
INSERT INTO detail VALUES("4650","387","20.00","0","Turn left
","0.2 mi
","on gravel bike path")^^
INSERT INTO detail VALUES("4651","387","21.00","0","Turn right
","0.1 mi
","go under US 34")^^
INSERT INTO detail VALUES("4652","387","22.00","0","Turn right
","0.9 mi
","just before river")^^
INSERT INTO detail VALUES("5563","412","1.00","1539","Walk toward station","100 ft",NULL)^^
INSERT INTO detail VALUES("5564","412","2.00","0","turn right at concourse (near elevators)","525 ft","toward South Exit; Pass Reisezentrum")^^
INSERT INTO detail VALUES("5565","412","3.00","0","At exit, cross Mannheimerstr to hotel","50 ft",NULL)^^
INSERT INTO detail VALUES("5566","413","1.00","1541","Turn right onto W 33rd S","479 ft","opposite Metro Lounge")^^
INSERT INTO detail VALUES("5567","413","2.00","0","Turn left onto 8th Ave","276 ft",NULL)^^
INSERT INTO detail VALUES("5568","413","3.00","0","Turn right onto W 34th St","0.3 mi","34 St - Herald Sq subway station")^^
INSERT INTO detail VALUES("5569","413","4.00","0","Take N or D train (Coney Island-Stillwell Av) ",NULL,"to 36th Street station ( 23 or 26 minutes)")^^
INSERT INTO detail VALUES("5570","413","5.00","1540","Head northeast on 4th Ave toward 35th St","0.2 mi",NULL)^^
INSERT INTO detail VALUES("5571","413","6.00","0","Turn left onto 32nd St","302 ft","L Hotel on right")^^
INSERT INTO detail VALUES("5639","417","3.00","0","Turn slight left on Grünaustraße","177 ft","platform 1 A/B")^^
INSERT INTO detail VALUES("5578","415","1.00","1545","Take S8 or S9 to Gateway Gardens","0.0 mi","from regional BH; 1st stop")^^
INSERT INTO detail VALUES("5638","417","2.00","0","Turn right onto Heuwieserstraße","0.1 mi","2nd street to right")^^
INSERT INTO detail VALUES("5637","417","1.00","1547","Head east on Bahnhofstraße","0.2 mi","to right coming out of station")^^
INSERT INTO detail VALUES("5579","415","2.00","0","Head west on Bessie-Coleman-Straße ","0.2  mi",NULL)^^
INSERT INTO detail VALUES("5580","415","3.00","0","Cross Bessie-Coleman-Straße","161 ft","continue on Bessie-Coleman-Straße; Hotel on right")^^
INSERT INTO detail VALUES("5631","416","1.00","1546","Head southwest on Bessie-Coleman-Straße
","115 ft
","to right")^^
INSERT INTO detail VALUES("5632","416","2.00","0","Turn right onto Thea-Rasche-Straße
","0.2 mi
",NULL)^^
INSERT INTO detail VALUES("5633","416","3.00","0","Turn left onto Kapitän-Lehmann-Straße
","0.2 mi
","Cross under? roadway")^^
INSERT INTO detail VALUES("5634","416","4.00","0","Turn right
","79 ft
","Just before road splits in 2")^^
INSERT INTO detail VALUES("5635","416","5.00","0","Sharp left
","0.1 mi
",NULL)^^
INSERT INTO detail VALUES("5636","416","6.00","0","Turn left after rental car return on right
","0.2 mi
","Terminal 2 will be on the right
")^^
INSERT INTO detail VALUES("5755","424","1.00","0","Turn right onto N 18th St
","2.7 mi
",NULL)^^
INSERT INTO detail VALUES("5756","424","2.00","0","Turn right onto Weiss Ln
","0.5 mi
","end of 18th")^^
INSERT INTO detail VALUES("5757","424","3.00","0","Turn left onto IL-96 N
","2.0 mi
",NULL)^^
INSERT INTO detail VALUES("5758","424","4.00","0","Turn right onto IL-96 N/US-24 E
","25.2 mi
","
")^^
INSERT INTO detail VALUES("5759","424","5.00","0","Turn right to stay on IL-96 N
","3.9 mi
","warsaw to left")^^
INSERT INTO detail VALUES("5760","424","6.00","0","Turn right onto US 136
","1.5 mi","in Hamilton")^^
INSERT INTO detail VALUES("5761","424","7.00","0","Turn left onto N Co Rd 1000
","10.8 mi",NULL)^^
INSERT INTO detail VALUES("5762","424","8.00","0","Bear right onto IL-96 N
","5.0 mi
","Navoo to left")^^
INSERT INTO detail VALUES("5763","424","9.00","1549","Turn left onto IL-9 W/Great River Rd
","1.2 mi","Cross Mississippi
")^^
INSERT INTO detail VALUES("5765","424","10.00","0","Turn left onto Ave H
","0.4 mi
",NULL)^^
INSERT INTO detail VALUES("5766","424","11.00","0","Turn left at 6th St
","187 ft
",NULL)^^
INSERT INTO detail VALUES("5767","424","12.00","0","Turn right at the 1st cross street onto Riverview Dr
","0.3 mi","Destination will be on the right
")^^




CREATE TABLE `itin` (
  `price` char(7) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `itin` int NOT NULL AUTO_INCREMENT,
  `trip` int DEFAULT NULL,
  `map` char(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sort` decimal(5,2) DEFAULT NULL COMMENT 'sort key',
  `days` smallint DEFAULT '1' COMMENT 'no of days at this location',
  `date` date DEFAULT NULL,
  `dow` varchar(3) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `miles` varchar(7) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `town` int DEFAULT NULL COMMENT 'fk to town',
  `lodging` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `currency` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT '$ or E; default from trip',
  `address` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `website` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `email` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `status` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '-',
  `chk` tinyint DEFAULT NULL COMMENT 'checked if accepts checks',
  `credit` tinyint DEFAULT NULL COMMENT 'checked if accepts credit cards',
  `note` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `comment` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`itin`)
) ENGINE=MyISAM AUTO_INCREMENT=571 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci^^

INSERT INTO itin VALUES("45.50","83","6",NULL,"9.00","3","2011-08-18","Thu","9","84","Hotel Berlin, Berlin","$","Lützowplatz 17","(30)2605392716","http://www.hotel-berlin.de/hotel-berlin.html","info@hotel-berlin.de","E","0","1","mileage 19.0, 3.1,11.3, 24.3","Hotel.com #17154259336; Savoy cancel# C33779B0; res #53967280,")^^
INSERT INTO itin VALUES("23","84","6",NULL,"10.00","1","2011-08-21","Sun",NULL,"20","Haus Lechner","E","Breitenfelderstrasse 22","662 645084","http://www.privatvermieter.com/haus-lechner/de_unser-haus_erholung.html","haus-lechner@ce-consulting.at","E","0","0","BRUNNMEISTERHOF 22E Moosstrasse 160 bus 21 to 27; Am moos 24E, Wierer Verena 22.5E","Dep zoo sta  9:36, HBF 9:52 arr 18:09; conf 33410631.  Key code 7698B ???")^^
INSERT INTO itin VALUES("15.1","86","6","D","7.00","2","2011-08-14","Sun","6.5","87","Katharina Schmidhofer","E","Hofgasse 231","(0)6457 2553","http://www.kathis-appartements.at/","schmidhofer@sbg.at","R","0","0","2.1 Rad-fl  7.9 ghfAlm 8.0 around flach  3","near center of Flachau")^^
INSERT INTO itin VALUES("1505","4","6",NULL,"3.00","1","2011-08-02","Tue","- -","4","to Salzburg","$","AC8654, 1:20PM - Terminal 2 most likely gate E2","888-247-2262",NULL,NULL,"P","0","0","http://quincybicycleclub.org/50/cue/AC%20itinerary.htm
Also: AC6211 dep FRA 08:10 arr SZG 09:15","Ref# L8WXSA; Frankfurt Arr FRA 6:30 dep AC6209 (OS 264) 12:45 arr SZG 13:50")^^
INSERT INTO itin VALUES(NULL,"5","6",NULL,"1.00","1","2011-07-31","Sun",NULL,"4",NULL,"$",NULL,NULL,NULL,NULL,"-","0","0",NULL,NULL)^^
INSERT INTO itin VALUES("22","85","6","C","6.00","4","2011-08-10","Wed","2.1","17","Landhaus Christa","E","Oberreit 18","(6542) 68755","http://www.sbg.at/landhaus-christa","landhaus-christa@sbg.at","E","0","0","pension 2.1 mh x 3 1.4, mh+ 2,3, around lake,bhf 19.8, Kaprun, 18.0, MH Ghf concert 6.7, mittersill 21.1, MH ghf 2 x 1.4","Rest leave for Stuttgart and Zurich on the 11th")^^
INSERT INTO itin VALUES("75","153","25","D","5.00","1","2015-10-06","Tue","29","192","Parker House","$","213 Yough Street","(814) 395-9616","http://www.theparkerhousecountryinn.com/",NULL,"P","0","1",NULL,NULL)^^
INSERT INTO itin VALUES("75","188","25","E","6.00","1","2015-10-07","Wed","32","193","Yoder Guest House","$","106 Meyers Ave","(814) 634-8791","http://www.yodersguesthouse.com/index.html",NULL,"E","1","0",NULL,"PP trans Id 4EM8289009952132W.")^^
INSERT INTO itin VALUES("60","152","25","C","4.00","1","2015-10-05","Mon","34","162","Melody Motor Lodge","$","1607 Morrell Ave.","724-628-9600","http://melodymotorlodge.com/index.html","lodge@zoominternet.net","P","0","0",NULL,"Across from Walmart")^^
INSERT INTO itin VALUES("89","151","25","B","3.00","1","2015-10-04","Sun","29","194","John Butler B&B","$","800 Rock Run Rd, Elizabeth Tp","412-751-6670","http://www.butlersgolf.com/Pittsburgh-Pennsylvania-Bed-Breakfast.html","hbergman@butlersgolf.com","P","0","1",NULL,"Arr PGH: 5:05am (Avg 2 hr late)")^^
INSERT INTO itin VALUES(NULL,"302","42",NULL,"13.00","1","2015-08-10","Mon",NULL,"74",NULL,"$",NULL,NULL,NULL,NULL,"-","0","0",NULL,NULL)^^
INSERT INTO itin VALUES(NULL,"301","42","D","4.00","1","2015-08-03","Mon","41.8","268","Erie Canal Motel","$","7761 State Hwy 31","(315) 946-6586",NULL,NULL,"R","0","0",NULL,"other # 315-727-6409; owner said he has two rooms each with double bed, made tentative res, call later to confirm")^^
INSERT INTO itin VALUES("17.50","73","6","B","5.00","6","2011-08-04","Thu","1.4","14","Haus Christine","E","Maurach 239","512 5351 555","http://www.tiscover.com/at/portal/accommodation/5,en,SCH1/objectId,ACC131655at,ffs,2/home.html","sabine.hussl@utanet.at","R","0","0","1.3, strass, jb 6.5,strass, schwatz 16.2, Achensee, pertisau, schwarzenau, wiesing 1.3, 18.9, ziller 32, Innsbruch 2x 1.3, 7.3, jb,3.4","Top bike near F Hanusch Platz (Fischkrieg) stop on bus line 8, Meet  Stafford at Jenbach HBFat 14:33")^^
INSERT INTO itin VALUES(NULL,"82","6",NULL,"12.00","1","2011-08-23","Tue",NULL,"74",NULL,"E",NULL,NULL,NULL,NULL,"-","0","0","AmK: dep CUS 7:35; LAG 7:54; Metra NCS SP->CUS 6:23 - 6:55, 7:13 - 7:47; 6:42-7:20, 7:05-7:36; bus IPR->LAG 6:30-7:09, 7:00-7:39","Amtrak")^^
INSERT INTO itin VALUES("64","76","6",NULL,"11.00","1","2011-08-22","Mon",NULL,"82","OHare Inn & Suites","$","4101 Mannheim Road Schiller Park IL","(847) 671-1404",NULL,"AC Austria phone: 585363040","E","0","0","ref # 1D28-1244-5402","Dep SZG AC6212 2:30 PM arr Chi 10:10PM:  ref # 1D28-1244-5402")^^
INSERT INTO itin VALUES("22","77","6","A","4.00","1","2011-08-03","Wed","0.7","20","Privatzimmervermietung Hämmer","E","Innsbrucker Bundesstrasse 57a","662 827647","http://www.zimmervermietung-salzburg.at/","zimmervermietung-haemmerle@aon.at","E","0","0","canceled Kolbe","bus  stop Jodok-Fink on line 8 or 2, in next block towards town; Gasthof Noisternig next door; J&M arrive HBF 16:56")^^
INSERT INTO itin VALUES("64","81","6",NULL,"2.00","1","2011-08-01","Mon",NULL,"82","Ohare Inn  Suites","E","4101 Mannheim Road Schiller Park","847-671-1404","http://www.ohareinnsuites.com/","info@ohareinnsuites.com","E","0","1","conf # 1D28-1226-5251 ; king bed room; AMTRAK tickets purchased #108FBD","Amtrak to CUS, Metra to Franklin Park  Call for  shuttle; AL & Joe's Delicatessen")^^
INSERT INTO itin VALUES(NULL,"90","6",NULL,"8.00","2","2011-08-16","Tue","14","84","Gesche Lobodzinskina","E","Niklasstr. 37, Berlin 14163","030 8 01 62 42",NULL,"lobolina@arcor.de","E","0","0","10.3 + potsdamm","Arr Zoo Bhf 08:16;")^^
INSERT INTO itin VALUES(NULL,"256","31",NULL,"6.00","1","2014-07-26","Sat","43","231",NULL,"E",NULL,NULL,NULL,NULL,"-","0","0",NULL,"dinner in Bad Salzungen")^^
INSERT INTO itin VALUES(NULL,"257","31",NULL,"7.00","1","2014-07-27","Sun","41","232",NULL,"E",NULL,NULL,NULL,NULL,"-","0","0",NULL,"dinner in Meiningen")^^
INSERT INTO itin VALUES("50","189","25",NULL,"1.00","1","2015-10-02","Fri",NULL,"138","Kewanee Motor Lodge","$","400 S Main St","(309) 853-4000","http://kewanee-il.com/KewaneeMotorLodge/","kharvari.b@gmail.com","P","0","0",NULL,"Carl Sandburg departs QCY at 5:30P, arrives KEE 7:25PM, amtrak #85133B")^^
INSERT INTO itin VALUES(NULL,"190","25",NULL,"8.00","1","2015-10-09","Fri",NULL,"74",NULL,"$","Illinois Zephyr",NULL,NULL,NULL,"-","0","0","new res# A82B04 total 336.50","Arr CHI 8:45 AM; dep CHI 5:55PM; arr QCY 10:23PM.  Bike along lake")^^
INSERT INTO itin VALUES("501","199","25",NULL,"7.00","1","2015-10-08","Thu","33","277","Room 019, car 2909","$","Capitol Limited",NULL,NULL,NULL,"E","0","0",NULL,"res # 83E2A9; dep 7:24Pm")^^
INSERT INTO itin VALUES("432","198","25",NULL,"2.00","1","2015-10-03","Sat",NULL,"277","Rm 18 Car 3009","$","Capitol Limited",NULL,NULL,NULL,"E","0","0",NULL,"Kee-Chi #8511AB; CHI-PGH #83dfed; pay in Chicago")^^
INSERT INTO itin VALUES("48","227","31",NULL,"11.00","1","2014-08-09","Sat",NULL,"84","Wyndham Excelsior","E","Hardenbergstr. 14","+49 (0) 30 / 31","http://www.wyndhamberlinexcelsior.com/","use website","E","0","1",NULL,"conf # 8023591371581, 8023591371581-1")^^
INSERT INTO itin VALUES("599","225","31",NULL,"10.00","7","2014-08-02","Sat",NULL,"212","MS Diana Danube cruise ship","E",NULL,NULL,"http://www.travelydays.com/index.php/en/boat-bike/danube/danube-to-vienna",NULL,"I","0","0",NULL,"IC 1:06 every 2hrs from Regensburg to Passau")^^
INSERT INTO itin VALUES("31","224","31",NULL,"9.00","3","2014-07-30","Wed",NULL,"217","Haus Maria","E","Innbruckstrasse 25","7712 / 6034","http://www.haus-maria-wagner.at/","haus.wagner@utanet.at","E","0","1",NULL,"ICE 91 track 10 10:03 arr Passau track 5 13:33; Quiet coach 23; dep track 3 14:44 arr Schärding 14:56. Auftrag# 1N7ZXS")^^
INSERT INTO itin VALUES(NULL,"223","31",NULL,"8.00","2","2014-07-28","Mon","33","211","Klumpe","E",NULL,NULL,NULL,NULL,"-","0","0",NULL,"End toure at 14 Holy Helpers Shrine near near Lichtenfels: Dinner in Coburg")^^
INSERT INTO itin VALUES(NULL,"222","31",NULL,"5.00","1","2014-07-25","Fri","37","230","?","E",NULL,NULL,NULL,NULL,"-","0","0",NULL,"5 days, 4 nights bike ride along the Werratal bike route organized by Jürgen")^^
INSERT INTO itin VALUES(NULL,"221","31",NULL,"4.00","2","2014-07-23","Wed",NULL,"211","Klumpe","E","DB conf (auftrag) # DL1LDF",NULL,NULL,NULL,"-","0","0",NULL,"S1 Mexikoplatz Friedrichstr, S7 HBF, ICE597 Goettingen, Quiet Car=coach 2")^^
INSERT INTO itin VALUES(NULL,"220","31",NULL,"3.00","1","2014-07-22","Tue",NULL,"84","Hotel Lobo (Gesche)","E","Niklasstr. 37",NULL,NULL,"lobolina@arcor.de","P","0","0",NULL,"TXL JetExpressBus every 10 min to Alexanderplatz; Change to S 1 for MexiKoplatz (Potsdam) at Brandenburg Gate")^^
INSERT INTO itin VALUES("1248","219","31",NULL,"2.00","1","2014-07-21","Mon",NULL,"4","Air Berlin","$","E-TicketS: 7457359395185, 7457359395186",NULL,"http://www.airberlin.com","AB BOOKING REF: Y9YGJA","E","0","0","CHEAPO AIR booking  no 20588722;","Amtrak KEE-CHI dep 8:09AM, conf# 18B450; Air Berlin dep 3:25PM arr 7:00AM next day")^^
INSERT INTO itin VALUES("55","218","31",NULL,"1.00","1","2014-07-20","Sun",NULL,"138","Kewanee Motor Lodge","$","500 S Main St.","(309) 853-4000",NULL,NULL,"P","0","0",NULL,"Amtrak conf # 18B26F; arr KEE 7:27")^^
INSERT INTO itin VALUES(NULL,"228","31",NULL,"12.00","1","2014-08-10","Sun",NULL,"74","Air Berlin","E",NULL,NULL,NULL,NULL,"-","0","0",NULL,"Air Berlin dep 10:00 arr 12:10; Amtrak conf #18B936; call 888-707-6600 to apply upgrade coupons")^^
INSERT INTO itin VALUES("76","289","42","D","5.00","1","2015-08-04","Tue","46","270","Red Carpet Inn","$","1735 Route 14","315-789-4510",NULL,NULL,"E","0","1","Gary's room changed to 2 people 6/30","Hotels.com Conf #8131856193532 changed  to 2 Dbl no smooking 6/4; added 1 King (Gary) #8139260311923.")^^
INSERT INTO itin VALUES("279","288","42","A","1.00","1","2015-08-01","Sat","25","277","Lakeshore Limited","$","Car 4812 - Room 008",NULL,NULL,NULL,"E","0","0",NULL,"res# B7C44A, Dep CHI 9:30PM; bike Naperville to Forest Park, subway to union station")^^
INSERT INTO itin VALUES("55","290","42","E","6.00","1","2015-08-05","Wed","42.4","269","Camillus Inn","$","2382 West Genesee Turnpike","315-672-3022","http://www.camillusinn.com/","thecamillusinn@live.com","E","0","1","two conv stores, God Father Pizza. Howland Island WLR is an option between Clyde and the trail at Port Bryon 15.6 mi, 42.5 total, 1 mile shorter.","motel will call my cell phone in July to get CC; emailed request for 2 rooms 6/4")^^
INSERT INTO itin VALUES("60","291","42","F","8.00","1","2015-08-06","Thu","40","263","Sharway Motel","$","3669 Seneca Turnpike (NY 5)","(315) 697-7935",NULL,"confirm week before","E","0","0",NULL,"road alternative to Old Erie Canal Trail saves 0.8 mi.; confirmed 2nd room 6/8")^^
INSERT INTO itin VALUES("103.2","292","42","G","10.00","1","2015-08-07","Fri","39","264","Hotel Utica","$","102 Lafayette St","(315) 724-7829","http://hotelutica.com/",NULL,"E","0","0",NULL,"1 queen, conf no 16853859, 2nd room 2 dbl # 26236923")^^
INSERT INTO itin VALUES("60","293","42","H","11.00","1","2015-08-08","Sat","43","265","Palatine Motel","$","203 W Grand St","(518) 673-1050",NULL,NULL,"P","0","0","Budget Inn, Booking.com #794337656, canceled 6/4","1 Rm 1 King Bed $?, 1 Rm 2 beds $70, called re 4 people")^^
INSERT INTO itin VALUES("84","296","42","B","2.00","1","2015-08-02","Sun","40","266","Dollinger Courtyard Motel","$","11360 Maple Ridge Road","(585) 798-0016",".",NULL,"P","0","0","arr BUF 8:58; via Lockport; 33.1 mi via Clarence Pathway","Confirmed 2nd room 6/8; Dollinger's 2 day cancellation")^^
INSERT INTO itin VALUES("56","297","42","C","3.00","1","2015-08-03","Mon","44.1","267","Motel 6","$","115 Buell Rd","(585) 436-2170",NULL,NULL,"E","0","0","canceled 1221M52542 canc # 1221X07555; canceled 1221M53276, canc # 1221X07556","Conf # 1221M54078 2 beds ($56). 2nd room (2 beds) # 1221M53915")^^
INSERT INTO itin VALUES("364.5","298","42","I","12.00","1","2015-08-09","Sun","40.5","277","Lakeshore Limited","$","Car 4920 - Room 006",NULL,NULL,NULL,"E","0","0","Amtrak station 518-346-8651; ALB-SDY ticket cancellation Reference Number: 1423","res # B7C799; Departs Schenectady 7:31PM; Gary, Lynn, Paula res# 3CE442")^^
INSERT INTO itin VALUES(NULL,"299","42",NULL,"9.00","1","2015-08-06","Thu","33","279","Lucas's parents","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"include stop at Dinosaur BarBQ")^^
INSERT INTO itin VALUES(NULL,"300","42",NULL,"7.00","1","2015-08-05","Wed","37","262","Elbridge Motel","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,NULL)^^
INSERT INTO itin VALUES("378","312","45",NULL,"7.00","1","2016-02-04","Thu",NULL,"277","Car 0632 - Room 003","$","eVoucher covered cost",NULL,NULL,NULL,"E","0","0",NULL,"res # 207A62; arr GBB 11:41, dep 5:38")^^
INSERT INTO itin VALUES("0","305","45",NULL,"1.00","2","2016-01-05","Tue",NULL,"277","Car 31 Room A<br> Car 3001 Rm E<br> Car 9711 Rm A","$","SW Chief<br>Capitol Limited<br>Silver Meteor",NULL,NULL,NULL,"E","0","0","canceled Denver segment","res # 088108; dep FMD 11:09 AM, arr CHI 3:15PM")^^
INSERT INTO itin VALUES("707","306","45",NULL,"2.00","7","2016-01-07","Thu",NULL,"295","Master Suite By The Beach","$","1600 Jackson St","312-685-2023","http://www.tripadvisor.com/VacationRentalReview-g34296-d8857360-Giant_Master_Suite_By_The_Beach-Holl","kurtconradsports@gmail.com","E","0","1","Hollywood Beach Golf Resort canceled 12/4; hotel.com booking #125691225525;","Booking # BR18792666; Silver Meteor arr 5:59; bus #7 6:18, 6:40, 7:02, 7:22 (11 min then 6 min walk)")^^
INSERT INTO itin VALUES("548","307","45",NULL,"3.00","7","2016-01-14","Thu",NULL,"297","LAKE MORTON COTTAGE","$","741 Park Hill Ave","863-409-8089",NULL,NULL,"E","0","0",NULL,"Confirmation Code: YB2TPS; Silver Star dep Hol 12:14, Arr Lakeland 4:18, res # D894FC")^^
INSERT INTO itin VALUES("723","308","45",NULL,"4.00","7","2016-01-21","Thu",NULL,"296","Bungalow near Downtown","$","803 W Highland Ave",NULL,"https://www.airbnb.com/rooms/9181839?eluid=1&euid=4fdad53c-6484-c00e-83ce-cff67227608b",NULL,"E","0","1","BEST WESTERN Orlando West on bus line to Leesburg, $80","Res Code CYN3CM.  Res #E38038: Bus 6098 dep LAKELAND 11:15 AM; Silver Meteor arr Deland 2:39")^^
INSERT INTO itin VALUES(NULL,"309","45",NULL,"5.00","3","2016-01-28","Thu",NULL,"277","9811<br>Rm A<br>4911<br>rm B<br>531<br>Rm C","$","Res # 14C495",NULL,NULL,NULL,"E","0","0",NULL,"Dep DLD 2:39")^^
INSERT INTO itin VALUES(NULL,"311","45",NULL,"6.00","4","2016-01-31","Sun",NULL,"294",NULL,"$",NULL,NULL,NULL,NULL,"-","0","0",NULL,NULL)^^
INSERT INTO itin VALUES(NULL,"313","47",NULL,"8.00","1","2016-08-18","Thu",NULL,"74",NULL,"$",NULL,NULL,NULL,NULL,"-","0","0",NULL,NULL)^^
INSERT INTO itin VALUES("75","314","47",NULL,"1.00","1","2016-07-26","Tue",NULL,"82","ohare inn & suites","$","4101 Mannheim Rd, Schiller Park","(847) 671-1404","http://www.ohareinnsuites.com/","info@ohareinnsuites.com","E","0","1","Amtrak #A9C37F (both)<br>  
Metra to FP dep 11:30, 12:30 arr 11:58, 12:50 $5.00 Buy using Ventra app<br>
Ohare Inn ref# 6B1513409161 Phone for shuttle 847-671-1404<br>
Al & Joe's 0.7 mile S on Mannheim Rd","conf #  6B1513409161; 24 hr canc.  Al & Joe's 10348 Addison Av, 0.7 mi S on Mannheim. Amtr #A9C37F (both)")^^
INSERT INTO itin VALUES("1028R","315","47",NULL,"2.00","1","2016-07-27","Wed",NULL,"4","Icelandair #852,#450","$","trip# 107-668-563-40  Icelandair conf ZKB8JI",NULL,NULL,NULL,"E","0","0",NULL,"Dep 7:30pm arr 11:45am; 1hr 5 min change in Reykjavik")^^
INSERT INTO itin VALUES("1036","316","47",NULL,"3.00","7","2016-07-28","Thu",NULL,"302","4 Bedroom home","$","11 Lamden Way, Burghfield Common","+44 7841 781318","https://www.airbnb.com/rooms/9829899",NULL,"E","0","1","purchase rail tickets Terminal 2 rail station, £18.60 <br>
take Heathrow <b>CONNECT</b> to Hayes And Harlington, change to Reading <br>
From Blagrave Street bus stop(near station) take Lime Bus 2 to Burghfield Common or Lime bus 2a to Opp Holmdene, Lime 2 and Lime 2a alternate every 1/2 hr, ask for group fare<br>
Bainton Bike Rental 78 Walton Street, 0.6 mi from Oxford station, phone 01865 311610, 8:45-5:30 SA 9-5 SU 10-4, Can prearrange to return when closed<br>","Conf Code: PA8CT5, February 14, 2016, Receipt # 2151729142, 7 mi from Reading station, 3 miles from Theale station")^^
INSERT INTO itin VALUES("61","317","47",NULL,"6.00","4","2016-08-13","Sat",NULL,"304","ibis Frankfurt Airport","$","Langer Kornweg 9a-11; 65451 KELSTERBACH","(+49)6107/9870","http://www.accorhotels.com/gb/hotel-2203-ibis-frankfurt-airport/index.shtml",NULL,"E","0","1","Bikes dB 15/24, next 9/24, Intra ?, F station ?, hex ?","Janelle & Marcia leave 8/15 at 2:15PM; ibis conf# DJGBBPXR; J & M  DJGBVJQL; DB #H66S1O")^^
INSERT INTO itin VALUES("928 P","318","47",NULL,"5.00","7","2016-08-06","Sat",NULL,"300","MS Angela Esmee","$","North Holland; dep & arr Amsterdam",NULL,"https://www.travelydays.com/index.php/en/boat-bike/holland/north-holland-boat-bike","info@travelydays.com","E","0","0","Thalys dep 12:13 arr 15:42 From Central Station to ship: <b>Bus 48</b> to Borneo Eiland, every 15 min, takes 13 min, E 2.90.","board as early as 9:00AM, address of pier: Sumatrakade 1, 1019 BJ.  train from Paris arrives 13:42")^^
INSERT INTO itin VALUES("61.39","320","47",NULL,"4.00","2","2016-08-04","Thu",NULL,"75","ibis Paris Canal Saint Martin","$","12 Rue Louis Blanc","(+33)1/42012121",NULL,NULL,"E","0","1",NULL,"res# DDQBKSCT. ES booking ref UVQQSY")^^
INSERT INTO itin VALUES(NULL,"321","47",NULL,"7.00","1","2016-08-17","Wed",NULL,"82","ohare inn & suites","$","conf # 6D2814097997","(847) 671-1404",NULL,NULL,"E","0","0","return from FRA #521,#853 2:00PM to 6:15PM","fly back from frankfort; dep 2:00PM arr 6:15PM, 1 hr 10 min change in Reykjavik: Gary dep FRA 10:15")^^
INSERT INTO itin VALUES(NULL,"322","45",NULL,"5.50","1","2016-08-15","Mon",NULL,"74",NULL,"$",NULL,NULL,NULL,NULL,"-","0","0",NULL,NULL)^^
INSERT INTO itin VALUES("100","332","49",NULL,"2.00","1","2016-07-07","Thu","34","307","Bright Morning B&B","$","127 Jefferson Ct.","724-872-0792","http://www.brightmorning.net/","mlrendulic@yahoo.com","E","0","1",NULL,"Special rate for Anne's group")^^
INSERT INTO itin VALUES("928 P","339","45",NULL,"6.50","1","2016-08-16","Tue",NULL,"4","Icelandair #852,#450","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,NULL)^^
INSERT INTO itin VALUES("75","333","49",NULL,"3.00","1","2016-07-08","Fri","53","192","River's Edge","$","203 Yough Street","814-395-5059","http://www.riversedgecafebnb.com/bed-and-breakfast/",NULL,"P","0","1",NULL,NULL)^^
INSERT INTO itin VALUES("pts","335","49",NULL,"5.00","1","2016-07-10","Sun","16","277","car 2901 rm 12","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"ride to Cumberland (19 mil RT additional to Lock 75); res # 98d58e, bike #a9df08")^^
INSERT INTO itin VALUES(NULL,"336","49",NULL,"6.00","1","2016-07-11","Mon",NULL,"74",NULL,"$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"Upgrade coupon: AMZUF2FF84B8")^^
INSERT INTO itin VALUES("pts","337","49",NULL,"1.00","1","2016-07-06","Wed","26","277","Car 3000 - Room 011","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"Arrive PGH 5:05AM next morning; ride Naperville to Forest Park; res # 98D9C1")^^
INSERT INTO itin VALUES("88","338","49",NULL,"4.00","1","2016-07-09","Sat","47","308","Failingers Hotel Gunther","$","11 West Main Street","301-689-6511","http://www.failingershotelgunter.com/","hotelgunter@yahoo.com","E","0","0",NULL,"Mass Sat 5:00 Sun 8:00 & 12:00")^^
INSERT INTO itin VALUES(NULL,"387","55",NULL,"8.00","1","2019-02-12","Tue",NULL,"277","4911 - Room 002","$","Lakeshore Limited",NULL,NULL,NULL,"-","0","0",NULL,"New York to Chicago")^^
INSERT INTO itin VALUES("227","357","53",NULL,"1.00","1","2017-01-31","Tue",NULL,"277","LSL","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"res #375DFF from Ft Mad")^^
INSERT INTO itin VALUES("90","358","53",NULL,"2.00","1","2017-02-01","Wed",NULL,"311","Pennsyvania Hotel","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"res # CI21D5YY, Penn5000 One Double Bed,  no cancel")^^
INSERT INTO itin VALUES("$224","359","53",NULL,"3.00","1","2017-02-02","Thu",NULL,"277","silver star","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,NULL)^^
INSERT INTO itin VALUES("83","360","53",NULL,"4.00","7","2017-02-03","Fri",NULL,"297","Airbnb (3d ays)","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"Airbnb reserved for 3 nights, Fri,Sat, Sun")^^
INSERT INTO itin VALUES("79","361","53",NULL,"5.00","7","2017-02-10","Fri",NULL,"295","AirBnB same as last year","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"LKL to HOL #4CB697")^^
INSERT INTO itin VALUES(NULL,"362","53",NULL,"8.00","1","2017-02-26","Sun",NULL,"74","or other SE FL","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,NULL)^^
INSERT INTO itin VALUES(NULL,"363","53",NULL,"6.00","7","2017-02-17","Fri",NULL,"314","Park Terrace","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"HOL to TPA #4C5687")^^
INSERT INTO itin VALUES(NULL,"364","53",NULL,"7.00","2","2017-02-24","Fri",NULL,"277","SM, LSL,SWC","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"TPA to NYP #4C53AC; NYP to FMD #4C5532")^^
INSERT INTO itin VALUES("90","365","54",NULL,"1.00","1","2018-07-30","Mon",NULL,"82","Candlewood Suites Chicago-O`Hare","$","4021 North Mannheim Road Schiller Park, IL 60176","847-671-4663","https://www.ihg.com/candlewood/hotels/us/en/schiller-park/chimr/hoteldetail?qRef=df&qRpn=1&qChld=0&q",NULL,"E","0","1",NULL,"AMTK res # 47D4C6. hotel conf # 66126853, bring AARP card; cancel by 6:00PM 29 July,")^^
INSERT INTO itin VALUES("726","366","54",NULL,"2.00","1","2018-07-31","Tue",NULL,"4","KLM 612, seats 21J & H","$","Dep ORD 4:00pm, arr AMS 6:45am",NULL,NULL,NULL,"E","0","0",NULL,"KLM booking code/conf# TCP2PR; Priceline Trip Number: 136-306-842-87")^^
INSERT INTO itin VALUES("78.71","367","54",NULL,"3.00","1","2018-08-01","Wed","3","310","Dorint now Ramada Inn","E","Sloterweg 299, 1171 VB Badhoevedorp","+31-20-6588111",NULL,NULL,"E","0","1",NULL,"not refundable; swimming pool, shuttle, bike rental; conf# 77491SB001129")^^
INSERT INTO itin VALUES(NULL,"368","54",NULL,"4.00","1","2018-08-02","Thu",NULL,"277","NJ 40421 car 255 Rm 036 032","E",NULL,NULL,NULL,NULL,"E","0","0",NULL,"Dep Dusseldorf 20:54, J&M car 255  rm 052 und 056")^^
INSERT INTO itin VALUES(NULL,"369","54",NULL,"6.00","14","2018-08-05","Sun",NULL,"303","Luminary room 206, J&M 111","E","Avalon Waterways","866-755-8581","https://my.avalonwaterways.com/Login.aspx?ReturnUrl=%2Fdefault.aspx",NULL,"E","0","1",NULL,"cruise code WBA 805, booking no 954407, J&M 954409; RJ dep Wien 11:40 arr 2:17")^^
INSERT INTO itin VALUES("82.84","370","54",NULL,"7.00","1","2018-08-19","Sun",NULL,"310","Bastion Hotel Amsterdam Airport","$","Vuursteen 3, 2132 LZ Hoofddorp","+31 20-82044466",NULL,"info@bastionhotels.nl","E","0","0",NULL,"res # B37-F61184; shuttle at platform A9")^^
INSERT INTO itin VALUES("90","371","54",NULL,"8.00","1","2018-08-20","Mon",NULL,"82","Candlewood suites","$",NULL,NULL,NULL,NULL,"E","0","1",NULL,"conf # 61877180, cancel by 6:00pm 19 August")^^
INSERT INTO itin VALUES(NULL,"372","54",NULL,"9.00","1","2018-08-21","Tue",NULL,"74",NULL,"E",NULL,NULL,NULL,NULL,"-","0","0",NULL,"Amtk res # 47D4C6")^^
INSERT INTO itin VALUES("$60","373","54",NULL,"5.00","2","2018-08-03","Fri","101","315","Marriot Renaisance","$","Linke Wienzeile/Ullmannstrasse 71","+43-1-891020","http://marriott-res.com/15c5a1f7blayeousiawtbh6iaaaaaaaaaaaaa2mct4zkqaaa2gq4kkaab",NULL,"E","0","0",NULL,"conf #  84840429 and 84840431. Cancel by Aug 2")^^
INSERT INTO itin VALUES("78","376","55",NULL,"1.00","1","2019-01-15","Tue",NULL,"330","La Quinta Orlando Airport West","$","7931 Daetwyler Dr","407-857-9215",NULL,NULL,"E","0","0",NULL,"UAL conf #: H0CEY3 $146.70.  La Quinta conf # 3245401078; 2 Db beds, airport shuttle")^^
INSERT INTO itin VALUES("111","377","55",NULL,"7.00","1","2019-02-11","Mon",NULL,"311","HI Express - Times Square S","$","60 West 36th Street","212-897-3388",NULL,NULL,"E","0","0",NULL,"conf 24786221")^^
INSERT INTO itin VALUES("62.32","378","55",NULL,"3.00","7","2019-01-20","Sun",NULL,"129","The Old Haven","$","718 Carroll Avenue Southwest","(863) 521-4743","https://www.airbnb.com/rooms/13116480?bev_ref=&eal_exp=1544191912&eal_sig=d7c671aeb88a198f638b02953e",NULL,"E","0","0",NULL,"Confirmation code: HM8SQ48RQX; 3BR: Qu, Qu, 2 single 1 sofa bed; train dep 1:13 arr 1:35")^^
INSERT INTO itin VALUES("54.46","379","55",NULL,"5.00","7","2019-02-03","Sun",NULL,"329","Baseball, breweries & beaches","$","902 Beltrees St","(305) 394-0012","https://www.airbnb.com/rooms/22985728?bev_ref=&eal_exp=1544131995&eal_sig=bc19b04092611c955c6f132df8",NULL,"E","0","1",NULL,"Confirmation code: HMW5PR95AR; 3 BR: Qu, Qu, single; four bikes available")^^
INSERT INTO itin VALUES("37.62","381","55",NULL,"4.00","7","2019-01-27","Sun",NULL,"328","Chateau Sur Lac in the Heart of Winter Park","$","915 North Kentucky Avenue","(407) 758-0666","https://www.airbnb.com/rooms/24824133?bev_ref=&eal_exp=1544035622&eal_sig=3649e9aec7f9d77c14b20ed42a",NULL,"E","0","1",NULL,"HMHEYMBBJM; 2 BR: Qu, 2 Singles; canceled train from WTH ref # 8114")^^
INSERT INTO itin VALUES("79.50","448","55",NULL,"2.00","4","2019-01-16","Wed","79.50","297","LAKE MORTON HISTORIC COTTAGE KING","$","741 Park Hill Avenue","(863) 409-8038","https://www.airbnb.com/rooms/5241779?bev_ref=&eal_exp=1544231855&eal_sig=648abe49677eb713ccec01f5926",NULL,"E","0","0",NULL,"airbnb res code HM59ZEPMXM. train dep orlando 10:20 arr 11:29; res # 01294F")^^
INSERT INTO itin VALUES("1081","382","55",NULL,"6.00","1","2019-02-10","Sun",NULL,"277","Car 9811 - Room 003","$","Silver Meteor",NULL,NULL,NULL,"E","0","0",NULL,"used $832 eVoucher + CC for return tickets")^^
INSERT INTO itin VALUES(NULL,"385","55",NULL,"9.00","1","2019-02-13","Wed",NULL,"74",NULL,"$","Ill Zephyr",NULL,NULL,NULL,"-","0","0",NULL,"CHI to QCY")^^
INSERT INTO itin VALUES(NULL,"388","57",NULL,"1.00","1","2019-08-18","Sun",NULL,"277","IZ, Cap Lim. Car 3009 - Room 002","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"CL dep 6:40PM arr 1:05pm")^^
INSERT INTO itin VALUES(NULL,"389","57",NULL,"2.00","1","2019-08-19","Mon",NULL,"277","Silver Star. Car 9110 - Room 008","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"CL arr WAS 1:05PM, SS dep 3:05PM")^^
INSERT INTO itin VALUES("409","390","57",NULL,"3.00","5","2019-08-20","Tue",NULL,"329","Airbnb #HMANST9FWJ Beth","$","1100 Curlew Road Lot 145 on 5th street","(812) 698-1299",NULL,NULL,"E","0","0",NULL,"arr STP 1:40PM; Honeymoon Mobile Home Park")^^
INSERT INTO itin VALUES("127","468","70",NULL,"2.00","1","2020-05-12","Tue",NULL,"311","The L Hotel, Ascend Collection","$","135 32nd Street, Brooklyn","(718) 788-1801",NULL,NULL,"E","0","1",NULL,"conf #  40290317")^^
INSERT INTO itin VALUES(NULL,"391","57",NULL,"4.00","1","2019-08-25","Sun",NULL,"74",NULL,"$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"Bus dep STP 9:55AM arr ORL ??; SM dep ORL 1:35PM")^^
INSERT INTO itin VALUES("pts","467","70",NULL,"1.00","1","2020-05-11","Mon",NULL,"277","LSL  Car 4812 - Room 006","$","Lakeshore ltd",NULL,NULL,NULL,"E","0","0",NULL,"res # 92AA8E; arr NYP  6:23 PM")^^
INSERT INTO itin VALUES("180","451","66",NULL,"5.00","1","2019-07-06","Sat",NULL,"277","463, car 263; spaces 26,22;36,32","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"Train <  1 hr to Baden-Baden; 4:23 to Munich, dep 23:20 arr Budapest 9:19")^^
INSERT INTO itin VALUES(NULL,"446","68",NULL,"2.00","3","2018-10-30","Tue","73.4","327","Windsor Crossroads Motel","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,NULL)^^
INSERT INTO itin VALUES(NULL,"444","68",NULL,"1.00","1","2018-10-29","Mon","0","326","Bothwell","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"drive to Sedalia")^^
INSERT INTO itin VALUES(NULL,"447","68",NULL,"3.00","1","2018-11-02","Fri","19","74",NULL,"$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"Ride to Sedaila, 19 mi; drive back")^^
INSERT INTO itin VALUES(NULL,"427","66","4-5","6.00","7","2019-07-07","Sun",NULL,"322","AmaMagna Rms 102, 112 (Paula)","$","Budapest to Vilshofen","800-626-0126","https://www.amawaterways.com/destination/europe-river-cruises/2018/melodies-of-the-danube",NULL,"E","0","0",NULL,"Train arr 9:19")^^
INSERT INTO itin VALUES(NULL,"428","66","2-3","4.00","7","2019-06-29","Sat",NULL,"300","MS Arkona rms 131 & 125 (Paula, Terry)","$","Mainz - Strasbourg",NULL,"https://www.travelydays.com/boatbike/germany/rhine-mainz-strasbourg-biketours#mainz-strasbourg",NULL,"E","0","0",NULL,"Train dep Munich 11:57 arr Mainz 4:18PM. Board 3:00 – 5:00PM")^^
INSERT INTO itin VALUES(NULL,"429","66",NULL,"2.00","1","2019-06-26","Wed",NULL,"4","Iberia","$","ORD-MUC",NULL,"https://www.britishairways.com/en-us/home#/",NULL,"E","0","0",NULL,"BA conf# VGNTWO; IB seat res code MGHF2; my ticket #125-8783395834; airHelp claim# 1735475")^^
INSERT INTO itin VALUES("83.12","430","66","1","7.00","1","2019-07-14","Sun",NULL,"214","Ibis City","$","Furtmayrstrasse 1","+49 94178040",NULL,"H0904@accor.com","-","0","0",NULL,"3 bed room + terry res# HGSDCBQQ")^^
INSERT INTO itin VALUES("87.40","431","66",NULL,"9.00","1","2019-07-16","Tue",NULL,"82","Candlewood Suites","$","conf #29135345",NULL,NULL,NULL,"E","0","0",NULL,"BA0951 dep MUC 12:45; BA0297 arr ORD18:45")^^
INSERT INTO itin VALUES(NULL,"432","66",NULL,"10.00","1","2019-07-17","Wed",NULL,"74",NULL,"$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"SWC Chi-FMD dep 3:50 arr 6:25, conf # 6A16BC (points)")^^
INSERT INTO itin VALUES("105","433","66",NULL,"1.00","1","2019-06-25","Tue",NULL,"82","candlewood suites","$","4021 North Mannheim Road, Schiller Park","847-6714663",NULL,NULL,"E","0","0",NULL,"SWC to chi, dep FMD 10:49  arr 2:50PM,  res # 6A15B6, hotel. conf # 23534618, CC charged 5/22")^^
INSERT INTO itin VALUES("99","434","66","1","3.00","2","2019-06-27","Thu",NULL,"332","ibis Munich City South","$","Raintaler Str. 47","(+49)89/6659820","https://www.accorhotels.com/gb/hotel-8075-ibis-munich-city-south/index.shtml#origin=accorhotels","h8075@accor.com","E","0","0",NULL,"one double bed & 1 single bed. res #  GWLDBCPT; Terry res # HGTDMLVC; Terry arr KLM 5:00PM")^^
INSERT INTO itin VALUES("2,637","469","70",NULL,"3.00","7","2020-05-13","Wed",NULL,"303","QM2 - 4004 / Twin Beds","$","Pier 12, Clinton Wharf","1-800-728-6273",NULL,NULL,"P","0","0",NULL,"booking ref 2QMVVW")^^
INSERT INTO itin VALUES("54.46","466","66",NULL,"8.00","1","2019-07-15","Mon",NULL,"332","B&B Hotel München-Airport","$","Messerschmittstraße 1(near Dornierstraße) Halberg",NULL,NULL,"phone +49 ?(0)811 / 998850","E","0","0",NULL,"Terry res conf #72007000. 3 bed room still pending")^^
INSERT INTO itin VALUES("949","471","70",NULL,"5.00","7","2020-05-23","Sat",NULL,"303","MS Olympia","E","Rotterdam to Cologne",NULL,"https://www.travelydays.com/boatbike/holland/cycling-along-river-rhine#travel-dates-amp-prices",NULL,"E","0","0",NULL,"embark 3:00-5:00, disembark 9:00AM,  CBG to LON GNR conf # 84RR56WC, eurostar ref SBRVUF")^^
INSERT INTO itin VALUES("61","472","70",NULL,"4.00","3","2020-05-20","Wed",NULL,"337","room 6 on the ground floor","$","36 barton road, cambridge cb3 9lf (Barton Close)","+44 7411 075257","airbnb.com",NULL,"E","0","0",NULL,"conf HMDYYYSMHX. pd 1/2, $99.27 due May 5")^^
INSERT INTO itin VALUES("59","473","70",NULL,"6.00","3","2020-05-30","Sat",NULL,"304","Crowne Plaza Frankfurt Congress Hotel","$","Lyoner Strasse 44-48, Niederrad, Schwanheim, Frlft","+496966330","https://www.ihg.com/crowneplaza/hotels/us/en/frankfurt/fracg/hoteldetail","reservation@cp-frankfurt.com","E","0","0",NULL,"conf # 9005318921166; Koeln to FRA 1 hr as low as 24E")^^
INSERT INTO itin VALUES("76","475","70",NULL,"7.00","1","2020-06-02","Tue",NULL,"82","Candlewood Suites","$","shuttle door ?","847-671-4663",NULL,NULL,"E","0","0",NULL,"conf # 255-2805333")^^
INSERT INTO itin VALUES(NULL,"476","70",NULL,"8.00","1","2020-06-03","Wed",NULL,"74","dep 2:50PM arr 6:25","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"amtrak conf # 97C8A6")^^
INSERT INTO itin VALUES(NULL,"523","76",NULL,"4.00","1","2021-09-12","Sun",NULL,"294","Kevin","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"Kevin pick us up in Longmont")^^
INSERT INTO itin VALUES(NULL,"524","77",NULL,"1.00","1","2021-11-15","Mon",NULL,"277","Cap Ltd Car 3000 - Room 005","$","res #401140",NULL,NULL,NULL,"E","0","0",NULL,"Dep CHI 6:40PM Arr WAS 1:05")^^
INSERT INTO itin VALUES(NULL,"518","76",NULL,"6.00","7","2021-09-16","Thu",NULL,"342","Sisters of Mercy","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"AA fl 926 dep ABQ 12:58p arr DFW 3:49p; fl 2917 dep DFW 4:49, arr CLT 8:35PM")^^
INSERT INTO itin VALUES(NULL,"517","76",NULL,"1.00","1","2021-09-07","Tue",NULL,"277","Cal Zephyr Car 532 - Room 014","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"Reservation: 3FEC4E, dep Galesburg 4:38PM; res changed via AGR phone 7/10")^^
INSERT INTO itin VALUES(NULL,"516","76",NULL,"3.00","2","2021-09-10","Fri",NULL,"341","Diann","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"Bus DUS to Longmont, changing in Bolder")^^
INSERT INTO itin VALUES(NULL,"534","80",NULL,"2.00","1","2022-07-11","Mon",NULL,"74",NULL,"$",NULL,NULL,NULL,NULL,"-","0","0",NULL,NULL)^^
INSERT INTO itin VALUES("75","560","89",NULL,"4.00","1","2023-07-28","Fri",NULL,"304","IntercityHotel Frankfurt Hauptbahnhof","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"DB BRU-FRA Order number: 32LEQP; $139.46")^^
INSERT INTO itin VALUES(NULL,"515","76",NULL,"2.00","2","2021-09-08","Wed",NULL,"294","Kevin","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"Bus Longmont to Denver ?")^^
INSERT INTO itin VALUES(NULL,"514","76",NULL,"5.00","3","2021-09-13","Mon",NULL,"320","Yvonne","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"Kevin drive us to Raton; SWC departs 10:30AM ( 9:24 Trinidad)  Google say 24 minutes Trinidad to Raton station")^^
INSERT INTO itin VALUES("81.93","533","80",NULL,"1.00","3","2022-07-08","Fri",NULL,"343","Quality Inn Ankeny","$","201 SE Delaware Ave, Ankeny 50021, I 35 exit 92","515-964-8202",NULL,NULL,"E","0","0",NULL,"conf  85685844, king bed, indoor pool, cont breakfast")^^
INSERT INTO itin VALUES(NULL,"525","77",NULL,"3.00","1","2021-11-17","Wed",NULL,"74",NULL,"$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"Bus Dep TPA 1:00PM arr STP 1:40PM")^^
INSERT INTO itin VALUES(NULL,"527","78",NULL,"1.00","1","2022-04-22","Fri",NULL,"277","Silver Star 9214 - Room 8","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"res# E59FCB")^^
INSERT INTO itin VALUES(NULL,"526","77",NULL,"2.00","1","2021-11-16","Tue",NULL,"277","Silver Star Car 9110 - Room 003","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"dep Was 3:04 arr TPA 12:23PM")^^
INSERT INTO itin VALUES(NULL,"528","78",NULL,"2.00","3","2022-04-23","Sat",NULL,"342","Paula","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,NULL)^^
INSERT INTO itin VALUES("121","529","78",NULL,"4.00","2","2022-04-27","Wed",NULL,"311","Leo House","$","332 West 23rd Street","212)929-1010",NULL,NULL,"E","0","0",NULL,"Silver Star res# E5A589 Car 9213 - Room 1; Leo House conf# 88628C285980; 1 nite ($151.00 tax incl) pre-paid")^^
INSERT INTO itin VALUES("76","530","78",NULL,"3.00","1","2022-04-26","Tue",NULL,"340","Best western","$","1722 Walnut Street","(919) 481-1200",NULL,NULL,"E","0","0",NULL,"Piedmont res# E5A676; Best western conf # 894523758. Bus #1 6:30pm and 7:00pm (17 min)")^^
INSERT INTO itin VALUES(NULL,"531","78",NULL,"5.00","1","2022-04-29","Fri",NULL,"277","LSL Car 4911 - Room 6","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"res# E5A272")^^
INSERT INTO itin VALUES(NULL,"532","78",NULL,"6.00","1","2022-04-30","Sat",NULL,"74",NULL,"$",NULL,NULL,NULL,NULL,"-","0","0",NULL,NULL)^^
INSERT INTO itin VALUES("112","519","76",NULL,"7.00","1","2021-09-23","Thu",NULL,"338","Holiday Inn","$","320 Hillsborough Street","1-919-832-0501",NULL,NULL,"E","0","0",NULL,"HI conf #  44968799;")^^
INSERT INTO itin VALUES("75","520","76",NULL,"8.00","2","2021-09-24","Fri",NULL,"311","Leo House; conf# 3761.573.585 PIN CODE: 7274","$","332 West 23rd Street","(212) 929-1010",NULL,NULL,"E","0","0",NULL,"To CC payments made $67.24 + $92.24  to Leo House;")^^
INSERT INTO itin VALUES(NULL,"521","76",NULL,"9.00","1","2021-09-26","Sun",NULL,"277","LSL; Car 4911 - Room 003","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"res # 4490B7; dep 3:40")^^
INSERT INTO itin VALUES(NULL,"522","76",NULL,"10.00","1","2021-09-27","Mon",NULL,"74","arr MTP","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"Dep CHI 2:00, arr MTP 5:59")^^
INSERT INTO itin VALUES("1002.88","559","89",NULL,"3.00","7","2023-07-21","Fri",NULL,"303","QM2, SR 11050 / cat BC","$",NULL,NULL,NULL,NULL,"P","0","0",NULL,"ref # 2HCJDP; price is PP & incl travel insurance; pd by credit from 2020.")^^
INSERT INTO itin VALUES(NULL,"558","89",NULL,"2.00","1","2023-07-20","Thu",NULL,"311","The L Hotel, Ascend Hotel Collection","$","135 32nd Street, Brooklyn, NY, 11232"," (718) 788-1801","https://www.choicehotels.com/new-york/brooklyn/ascend-hotels/ny629",NULL,"E","0","0",NULL,"arr NYP 6:42 PM. hotel conf# 67925729")^^
INSERT INTO itin VALUES("148","554","88",NULL,"2.00","1","2023-05-01","Mon",NULL,"311","american dream hostel","$","168 East 24th Street","(212)-260-9779","https://www.americandreamhostel.com/contact-us","americandream24@aol.com","E","0","1",NULL,"conf# 4550710569582;  received corrected conf (adj date, same conf #); door code 2424")^^
INSERT INTO itin VALUES(NULL,"557","89",NULL,"1.00","1","2023-07-19","Wed",NULL,"277","Car 4810- Room 6","$","Ilinois Zephyr QCY-CHI; Lakeshore Limited CHI-NYP",NULL,NULL,NULL,"E","0","1",NULL,"conf # 6DAACC.  Apply 48 hr coupon to BC after 6:12AM Monday")^^
INSERT INTO itin VALUES(NULL,"544","85",NULL,"2.00","5","2022-11-20","Sun",NULL,"341","Diann, Kevin","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,NULL)^^
INSERT INTO itin VALUES(NULL,"543","85",NULL,"4.00","1","2022-11-27","Sun",NULL,"311","Four Points By Sheraton Manhattan Chelsea","$","160 West 25th Street NY","212-627-1888",NULL,NULL,"E","0","0",NULL,"Priceline Trip Number: 142-752-625-18")^^
INSERT INTO itin VALUES(NULL,"542","85",NULL,"3.00","2","2022-11-25","Fri",NULL,"277","CZ car 632 rm 6I, LSL car 4812 rm 3","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"54,777 PTS; dep Den 7:15, Dep CHI 9:30PM; res # 7DC959")^^
INSERT INTO itin VALUES(NULL,"541","85",NULL,"1.00","1","2022-11-19","Sat",NULL,"277","CZ  GBB to DEN car 532 rm 4","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"QCY-GBB + bike res # BF75D5;  GBB-DEN and NYP-TPA res # 7DCA61; $1,346.40; dep GBB 4:38PM")^^
INSERT INTO itin VALUES(NULL,"545","85",NULL,"5.00","1","2022-11-28","Mon",NULL,"277","Silver Star car 9111 rm 4","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"res # 7DCA61; dep NYP 11:02 AM")^^
INSERT INTO itin VALUES(NULL,"546","85",NULL,"6.00","1","2022-11-29","Tue",NULL,"74","dunedin","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"arr TPA 12:55PM;  BOOKED John Hallmeyer shuttle driver 727-475-8337 cell phone 727-244-7663 text also")^^
INSERT INTO itin VALUES(NULL,"556","88",NULL,"4.00","1","2023-05-03","Wed",NULL,"74",NULL,"$","Illinois Zephyr #383",NULL,NULL,NULL,"-","0","0",NULL,"chi-QCY ticket on same reservation as LSL; added bike ticket")^^
INSERT INTO itin VALUES(NULL,"555","88",NULL,"3.00","1","2023-05-02","Tue",NULL,"277","LSL Car 4912 Room - 5","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"res # 3997BD; 26913 agr points; ; AGR # 7005426775")^^
INSERT INTO itin VALUES("9xx","553","88",NULL,"1.00","1","2023-04-30","Sun",NULL,"277","Silver Star Car 9211 Room - 5","$",NULL,NULL,NULL,NULL,"P","0","0",NULL,"res # 399929;  plan to ship bike in box to CHI")^^
INSERT INTO itin VALUES(NULL,"561","89",NULL,"5.00","7","2023-07-29","Sat",NULL,"303","MS Prinzessin Katharina","$","M.H. Tromplaan 47, NL-7513 AB Enschede","+31-53-7850851","https://www.travelydays.com/","info@travelydays.com","R","0","0",NULL,"DB FRA-Passau 9:53- 14:25 (chg in Wuerzburg) order #  HE9CEZ. Boarding ship 4 pm. ")^^
INSERT INTO itin VALUES(NULL,"562","89",NULL,"6.00","1","2023-08-05","Sat",NULL,"304","Holiday Inn Airport","$",NULL,NULL,NULL,NULL,"E","0","0",NULL,"conf # 608976298; 10 minute walk to Term 2")^^
INSERT INTO itin VALUES("84","563","89",NULL,"7.00","1","2023-08-06","Sun",NULL,"82","oHare Inn & suites","$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"AA flt 705 FRA-CLT 09:20 AM - 01:00 PM; AA flt 815 CLT-ORD 08:33 PM - 09:43 PM; departs from Term 2")^^
INSERT INTO itin VALUES(NULL,"567","89",NULL,"8.00","1","2023-08-07","Mon",NULL,"74",NULL,"$",NULL,NULL,NULL,NULL,"-","0","0",NULL,"IZ res# 91E758, incl BC")^^




CREATE TABLE `latest` (
  `latest` int NOT NULL AUTO_INCREMENT,
  `trip` int DEFAULT NULL,
  `date` date DEFAULT NULL,
  `updates` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`latest`)
) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=latin1^^

INSERT INTO latest VALUES("98","70","2020-03-25","sent cancelation request to Priceline re Icelandair. they canceled it")^^
INSERT INTO latest VALUES("99","70","2020-03-23","Received BnB voucher for 2021 from Travelydays")^^
INSERT INTO latest VALUES("68","54","2018-07-10","New Amtrak ticket; dep CHI 2:50PM")^^
INSERT INTO latest VALUES("95","70","2020-03-25","canceled both Amtrack res")^^
INSERT INTO latest VALUES("100","70","2020-03-31","Sent cancelation request to Icelandair (?)")^^
INSERT INTO latest VALUES("84","66","2019-03-30","final cruise payments 3/39 and 3/30")^^
INSERT INTO latest VALUES("85","66","2019-04-06","final B&B pmt")^^
INSERT INTO latest VALUES("86","66","2019-04-09","BA complaint regarding seat selection. #19017228")^^
INSERT INTO latest VALUES("87","66","2019-04-09","Completed cruise check in for Jeanine and I")^^
INSERT INTO latest VALUES("106","88","2023-04-08",NULL)^^
INSERT INTO latest VALUES("107","88","2023-04-08",NULL)^^
INSERT INTO latest VALUES("101","70","2020-04-03","submitted Cambridge airbnb cancel request")^^
INSERT INTO latest VALUES("67","54","2018-07-05","Received Avalon travel packet")^^
INSERT INTO latest VALUES("79","55","2019-01-07","Canceled train WTH to WPK (Diann & Andrew will drive us)")^^
INSERT INTO latest VALUES("102","70","2020-04-06","Brooklyn hotel canceled; recvd email w refund")^^
INSERT INTO latest VALUES("78","55","2019-01-02","Booked return train + NY hotel")^^
INSERT INTO latest VALUES("103","70","2020-04-20","Candlewood canceled, CC credited 4/23")^^
INSERT INTO latest VALUES("104","70","2020-04-28","email from Icelandair claims I purchased from 3rd party.  Replied with copies of CC info. Replied Priceline. 4/28")^^
INSERT INTO latest VALUES("105","70","2020-04-29","Submitted Icelandair canc request at Priceline. Replied to Icelandair regarding $190 for seats")^^
INSERT INTO latest VALUES("108","89","2023-06-19","All res's booked")^^




CREATE TABLE `link` (
  `link` smallint NOT NULL AUTO_INCREMENT,
  `trip` int DEFAULT NULL,
  `sort` decimal(4,1) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `type` char(1) DEFAULT NULL,
  PRIMARY KEY (`link`)
) ENGINE=MyISAM AUTO_INCREMENT=442 DEFAULT CHARSET=latin1^^

INSERT INTO link VALUES("353","66","7.0","IB boarding pass.pdf","IB boarding pass","L")^^
INSERT INTO link VALUES("362","31","1.0","virginia.pdf","curlew to 840 Virginia","L")^^
INSERT INTO link VALUES("439","76","2.0","https://bikerentalcentralpark.com/?utm_source=GoogleMyBusiness&utm_medium=1391_6th_Ave","Bike rental Central Park (212) 664-9600","R")^^
INSERT INTO link VALUES("366","29","5.0","Bus Bolder to Longmont.pdf","Bus Bolder to Longmont (holidays)","L")^^
INSERT INTO link VALUES("368","29","6.0","bustang.rtf","Bustang North Labor day","L")^^
INSERT INTO link VALUES("369","29","7.0","bustang.txt","Bustang Nort Labor Day","L")^^
INSERT INTO link VALUES("407","70","14.0","Icelandair.pdf","FRA-ORD less info","L")^^
INSERT INTO link VALUES("406","29","9.0","fl.pdf","dunedin to various Clearwater points","L")^^
INSERT INTO link VALUES("375","70","3.0","QM2 conf.pdf","QM2 booking confirmation","L")^^
INSERT INTO link VALUES("376","70","1.0","fmd-nyp.pdf","FMD-NYP e-ticket","L")^^
INSERT INTO link VALUES("377","70","2.0","ascendNYRes.pdf","NY: L Hotel, Ascend Collection","L")^^
INSERT INTO link VALUES("378","70","10.0","BnBConf2020.pdf","BnB Rotterdam to Cologne confirmation with E-bike addition","L")^^
INSERT INTO link VALUES("379","70","11.0","BnPDeposit2020.pdf","BnB deposit receipt","L")^^
INSERT INTO link VALUES("395","70","18.0","stenaFerryCancel.pdf","Stena Ferry cancelation confirmation","L")^^
INSERT INTO link VALUES("381","70","5.0","https://www.frankfurtbiketour.com/fahrradverleih-frankfurt/","Fahrradverleih Frankfurt (near S-bahn)","R")^^
INSERT INTO link VALUES("392","70","2.0","https://www.rutlandcycling.com/pages/cycle-hire-cambridge/","Rutland Cycling - Cambridge station (online booking) £25.00/wk","R")^^
INSERT INTO link VALUES("386","70","1.0","https://ojp.nationalrail.co.uk/service/planjourney/search","British rail ticket site","R")^^
INSERT INTO link VALUES("384","70","16.0","candlewoodOhare.pdf","Candlewood Ohare","L")^^
INSERT INTO link VALUES("385","70","13.0","FRA-ORD flight.pdf","FRA-ORD incl seats","L")^^
INSERT INTO link VALUES("387","70","6.0","airbnbCambridge.pdf","airbnb Cambridge","L")^^
INSERT INTO link VALUES("388","70","12.0","CrownPlazaFRA.pdf","Crowne Plaza Frankfurt Congress Hotel","L")^^
INSERT INTO link VALUES("394","70","17.0","CHI-FMD.pdf","CHI-FMD ticket","L")^^
INSERT INTO link VALUES("390","70","5.0","EAngliaRailMap.pdf","East Anglia rail map","L")^^
INSERT INTO link VALUES("391","70","6.0","https://www.nextbike.de/en/frankfurt/","Next Bike FRA","R")^^
INSERT INTO link VALUES("436","57","2.0","hands on.pdf","Hands on","L")^^
INSERT INTO link VALUES("356","66","29.0","Passport J.jpg","Passport Jeanine","L")^^
INSERT INTO link VALUES("438","76","1.0","https://centralparkrentbike.com/checkout/bike-rental","bikerent.nyc (212) 541 - 8759","R")^^
INSERT INTO link VALUES("345","66","13.0","MainzBus.pdf","Mainz bus to dock","L")^^
INSERT INTO link VALUES("355","66","28.0","passport P.jpg","Passport Paul","L")^^
INSERT INTO link VALUES("334","66","2.0","https://bikebringer.de/rent-a-bike.html","BIKEBRINGER Munich bike rental","R")^^
INSERT INTO link VALUES("247","54","4.0","CHI-AMS KLM.pdf","Priceline conf: CHI-AMS AND AMS-CHI","L")^^
INSERT INTO link VALUES("341","66","6.0","https://www.fahrradverleih-regensburg.de/pages/en/rates.php","Rent a Bike Regensburg","R")^^
INSERT INTO link VALUES("246","54","17.0","AMS-ORD Delta.pdf","AMS-ORD Delta via Detroit","L")^^
INSERT INTO link VALUES("437","76","3.0","https://www.centralparkbicycles.com/p/central-park-bike-rental-map.html","Central Park NYC bike rental","R")^^
INSERT INTO link VALUES("396","70","4.0","https://www.eurostar.com/uk-en/","Eurostar UK","R")^^
INSERT INTO link VALUES("397","70","8.0","eurostarTicketP.pdf","Eurostar ticket - Paul","L")^^
INSERT INTO link VALUES("398","70","9.0","eurostarTicketJ.pdf","Eurostar ticket - Jeanine","L")^^
INSERT INTO link VALUES("399","70","19.0","NYP to L hotel.pdf","NYP to L hotel","L")^^
INSERT INTO link VALUES("400","70","20.0","CBG station to airbnb.pdf","CBG station to Barton Close (airbnb)","L")^^
INSERT INTO link VALUES("401","70","4.0","SOU-CBG ticket.pdf","Southhampton to Cambridge ticket","L")^^
INSERT INTO link VALUES("402","70","7.0","CBG-KGX ticket.pdf","CBG to Kings Cross ticket","L")^^
INSERT INTO link VALUES("408","70","21.0","CandlewoodCancel.jpg","Candlewood Cancel","L")^^
INSERT INTO link VALUES("404","29","8.0","airport via oldsmar.pdf","oldsmar","L")^^
INSERT INTO link VALUES("121","29",NULL,"https://www.travelydays.com/","Travelydays bike & barge tours","R")^^
INSERT INTO link VALUES("410","70","15.0","icland seats.pdf","FRA-ORD seat receipt","L")^^
INSERT INTO link VALUES("240","29","3.0","UP west Saturday.pdf","UP west Saturday","L")^^
INSERT INTO link VALUES("417","29","10.0","NPV-DG.pdf","NPV to Downers Grove","L")^^
INSERT INTO link VALUES("125","29",NULL,"http://www.bikeforums.net/touring/1042102-android-app-route-planning-off-line-maps.html","Bike forum gps app discussion","R")^^
INSERT INTO link VALUES("245","54","7.0","amsterdam dorint hotel.pdf","amsterdam dorint (now Ramada) hotel","L")^^
INSERT INTO link VALUES("244","54","10.0","NJTicketJanelle.pdf","NJ ticket, Janelle and Marcia","L")^^
INSERT INTO link VALUES("243","54","9.0","NJticket.pdf","NJ Duss-Wien ticket","L")^^
INSERT INTO link VALUES("340","66","9.0","MVV-airport group ticket.pdf","Group ticket Munich Airport","L")^^
INSERT INTO link VALUES("325","66","7.0","https://ec.europa.eu/transport/sites/transport/files/themes/passengers/air/doc/complain_form/eu_complaint_form_en.pdf","EU 261 complaint form","R")^^
INSERT INTO link VALUES("323","66","6.0","IBseatPurchase.pdf","Iberia seat selection (2 flights)","L")^^
INSERT INTO link VALUES("322","66","5.0","SeatAssignmentsBoth.pdf","BA seat selection (all 4 flights)","L")^^
INSERT INTO link VALUES("319","66","18.0","OBB-Munich Budapest-Ticket1.pdf","Overnight train Munich to Budapest ticket 1","L")^^
INSERT INTO link VALUES("303","66","1.0","FMD-CHI.pdf","Amtrak FMD-CHI","L")^^
INSERT INTO link VALUES("304","66","2.0","metraSched.pdf","Metra CHI <> Franklin Pk schedule","L")^^
INSERT INTO link VALUES("305","66","3.0","Candlewood June 25.pdf","Candlewood June 25","L")^^
INSERT INTO link VALUES("306","66","25.0","Candlewood July 16.pdf","Candlewood July 16","L")^^
INSERT INTO link VALUES("333","66","12.0","Munic-Mainz DB ticket.pdf","Munich - Mainz train ticket (4 per)","L")^^
INSERT INTO link VALUES("343","66","10.0","MunichIbisRes.pdf","Ibis Munich South - 3 person room","L")^^
INSERT INTO link VALUES("326","66","17.0","DB-Baden-Munich-ticket-4per.pdf","DB Baden-Baden to Munich ticket (4 Per)","L")^^
INSERT INTO link VALUES("213","54","1.0","https://www.citybikewien.at/en/","Vienna Citybike rental","R")^^
INSERT INTO link VALUES("271","55","1.0","ORL-LAK.pdf","Orlando to Lakeland","L")^^
INSERT INTO link VALUES("321","66","3.0","https://velhop.strasbourg.eu/hire-velhop-online/?lang=en","Velhop online bike rental Strasbourg","R")^^
INSERT INTO link VALUES("342","66","5.0","https://www.zweirad-ehrl.de/verleih.html","zweirad-ehrl Regensburg","R")^^
INSERT INTO link VALUES("339","66","15.0","BnBDetails.pdf","BnB details, incl telephone #","L")^^
INSERT INTO link VALUES("314","66","24.0","HotelBB-Munich Airport Terry.pdf","HotelBB Munich Airport (Terry
)","L")^^
INSERT INTO link VALUES("315","66","26.0","CHI-FMD.pdf","Amtrak CHI-FMD","L")^^
INSERT INTO link VALUES("316","66","8.0","Paula flight Eticket.pdf","Paula round trip flight","L")^^
INSERT INTO link VALUES("313","66","23.0","HotelBB-Munich Airport.pdf","HotelBB Munich Airport (3 persons)","L")^^
INSERT INTO link VALUES("312","66","22.0","Regensburg Ibis.pdf","Ibis Regensburg City (3 persons + Terry)","L")^^
INSERT INTO link VALUES("311","66","21.0","amaCruisFinalPmtPaulaTerry.pdf","Budapest-Vilshofen Cruise (Terry)","L")^^
INSERT INTO link VALUES("239","29","2.0","UP West Weekday.pdf","UP West Weekday and Sunday","L")^^
INSERT INTO link VALUES("338","66","14.0","BnBVoucher.pdf","BnB voucher & receipt","L")^^
INSERT INTO link VALUES("310","66","20.0","amaCruiseFinalPmt.pdf","Budapest-Vilshofen Cruise","L")^^
INSERT INTO link VALUES("309","66","11.0","MunicIbisResTerry.pdf","Ibis Munich South (Terry)","L")^^
INSERT INTO link VALUES("242","54","8.0","DB AMS-DUS ticket.pdf","AMS-DUS ticket (4 persons)","L")^^
INSERT INTO link VALUES("275","66","4.0","http://www.rent-a-sportsman.de/","Bike rental Baden-baden","R")^^
INSERT INTO link VALUES("272","55","2.0","LKL-WTH.pdf","Lakeland to Winter Haven","L")^^
INSERT INTO link VALUES("273","55","3.0","WTH-WPK.pdf","Winter Haven to Winter Park","L")^^
INSERT INTO link VALUES("274","55","4.0","WPK-STP.pdf","Winter Park to StP-Clearwater","L")^^
INSERT INTO link VALUES("320","66","19.0","OBB-Munich Budapest-Ticket2.pdf","Overnight train Munich to Budapest ticket 2","L")^^
INSERT INTO link VALUES("257","54","2.0","FMD-CHI.pdf","FMD - CHI round trip","L")^^
INSERT INTO link VALUES("248","54","16.0","BastionHotelAmsRes.JPG","Bastion Hotel Amsterdam Airport Res","L")^^
INSERT INTO link VALUES("251","54","15.0","BudapestPortMap.JPG","Budapest dock location map","L")^^
INSERT INTO link VALUES("264","54","1.0","QCY-CHI tr.pdf","QCY - CHI round trip","L")^^
INSERT INTO link VALUES("253","54","12.0","RennaisanceWien.pdf","Rennaisance Marriot Hotel Viena","L")^^
INSERT INTO link VALUES("254","54","13.0","obbWien-Budapest.pdf","Vienna to Budapest, 4 tickets + seat reservation","L")^^
INSERT INTO link VALUES("255","54","3.0","CandelwoodJulyRes.pdf","Candlewood Suites, July 30","L")^^
INSERT INTO link VALUES("256","54","18.0","CandelwoodAugRes.pdf","Candlewood Suites, Aug 20","L")^^
INSERT INTO link VALUES("263","54","2.0","https://www.klm.com/ams/mytrip/bookingsOverview.xhtml?COUNTRY=nl&LANG=en&POS=nl","klm res details","R")^^
INSERT INTO link VALUES("258","54","6.0","klm.pdf","KLM ORD-AMS ticket (OLD)","L")^^
INSERT INTO link VALUES("259","54","11.0","cityBike.htm","Citybike Wien instructions","L")^^
INSERT INTO link VALUES("261","54","3.0","https://www.avalonwaterways.com/river-cruise/magnificent-europe-westbound/wba/?content=overview","Cruise details: itinerary, means, amenities, etc.","R")^^
INSERT INTO link VALUES("262","54","14.0","AvalonTravelPacket.pdf","Avalon Travel Packet","L")^^
INSERT INTO link VALUES("265","54","5.0","airline Itin.pdf","Airline itinerary (NEW)","L")^^
INSERT INTO link VALUES("266","54","19.0","BP.pdf","AMS-ORD boarding pass","L")^^
INSERT INTO link VALUES("365","29","4.0","buss DUS to Bolder.pdf","bus DUS to Bolder (holidays)","L")^^
INSERT INTO link VALUES("337","66","16.0","BnB Itinerary.htm","B & B itinerary","L")^^
INSERT INTO link VALUES("270","66","1.0","https://www.radiustours.com/en/bike-rental/information-and-prices.html","Bike rental track 33 Munich HBF","R")^^
INSERT INTO link VALUES("393","70","3.0","https://www.citycyclehire.com/rental-info/","City Cycle Hire Cambr 2-3 Days £20","R")^^
INSERT INTO link VALUES("277","55","5.0","airbnb Lakeland receipt.pdf","airbnb Lakeland","L")^^
INSERT INTO link VALUES("278","55","6.0","airBnB Winter Haven receipt.pdf","airBnB Winter Haven","L")^^
INSERT INTO link VALUES("279","55","7.0","airbnb winter Park receipt.pdf","airbnb winter Park","L")^^
INSERT INTO link VALUES("281","55","8.0","airbnb dunedin receipt.pdf","airbnb dunedin","L")^^
INSERT INTO link VALUES("285","55","9.0","STP-NYP NYP-QCY.pdf","STP-NYP-QCY multi-city","L")^^
INSERT INTO link VALUES("286","55","10.0","HI-express NY.pdf","HI Express NY","L")^^
INSERT INTO link VALUES("440","47","1.0",NULL,NULL,"R")^^
INSERT INTO link VALUES("300","66","4.0","BAflightDetails.pdf","Flight there and back","L")^^
INSERT INTO link VALUES("299","55","14.0","NYP-QCY.pdf","NYP-QCY","L")^^
INSERT INTO link VALUES("441","88","1.0",NULL,NULL,"R")^^
INSERT INTO link VALUES("418","29","11.0","DG-BF senic.pdf","Downers Grove to Brookfield Metra (scenic)","L")^^
INSERT INTO link VALUES("419","29","12.0","DG-BF short.pdf","Downers Grove to Brookfield Metra (short)","L")^^
INSERT INTO link VALUES("434","29","1.0","insulin.pdf","cvs","L")^^
INSERT INTO link VALUES("422","29","13.0","metra","UP & BNSF metra scheds","L")^^
INSERT INTO link VALUES("424","29","14.0","NPV-IPP.pdf","Naperville Amtrak to Ill Prairie Path","L")^^
INSERT INTO link VALUES("425","29","15.0","River Forest Metra","End of IPP to River Forest Metra","L")^^
INSERT INTO link VALUES("426","29","16.0","salt creek.png","Hinsdale to Riverside Metra via Salt Creek Trail","L")^^
INSERT INTO link VALUES("427","29","17.0","salt creek N.png","LaGrange Rd Amtrak to Wood Dale Metra via Salt Creek Trail","L")^^




CREATE TABLE `log` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NULL DEFAULT NULL,
  `username` varchar(20) DEFAULT NULL,
  `nWatch` char(2) DEFAULT NULL,
  `nChange` char(3) DEFAULT NULL,
  `nAlert` char(3) DEFAULT NULL,
  `nSent` char(3) DEFAULT NULL,
  `err` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=29969 DEFAULT CHARSET=latin1^^

INSERT INTO log VALUES("29968","2014-07-13 00:45:01","JOHNMAC88","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29967","2014-07-13 00:45:01","NOSHOESFORUS","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29966","2014-07-13 00:45:01","MWHEALY31","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29965","2014-07-13 00:45:01","PAPPAYLIOU","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29909","2014-07-12 00:45:04","JOHNMAC88","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29908","2014-07-12 00:45:04","MWHEALY31","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29907","2014-07-12 00:45:04","PAPPAYLIOU","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29906","2014-07-12 00:45:04","URITEST88","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29905","2014-07-12 00:45:04","I005547","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29904","2014-07-12 00:45:04","WILADAYVO","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29903","2014-07-12 00:45:04","JERIANN57","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29902","2014-07-12 00:45:03","TRFAMSNAG","4","0","0",NULL,"9")^^
INSERT INTO log VALUES("29901","2014-07-12 00:45:03","MARSHONE","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29900","2014-07-12 00:45:01","MARYCAR","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29899","2014-07-12 00:45:01","GETBENT","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29898","2014-07-12 00:45:01","SALTATORIA","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29897","2014-07-12 00:40:02","131159300","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29896","2014-07-12 00:40:02","GRAHAMIRWIN","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29895","2014-07-12 00:40:02","VALENCIA","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29894","2014-07-12 00:40:02","FRANANN","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29893","2014-07-12 00:40:02","NOSHOESFORUS","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29892","2014-07-12 00:40:02","UTEST88","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29891","2014-07-12 00:40:02","SUPERSTAR","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29890","2014-07-12 00:40:02","PHYSGIRL","4","0","0",NULL,"9")^^
INSERT INTO log VALUES("29889","2014-07-12 00:40:02","REDSKINS","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29888","2014-07-12 00:40:01","ELDUB51","9","0","0",NULL,"9")^^
INSERT INTO log VALUES("29887","2014-07-12 00:40:01","CMA6273","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29886","2014-07-12 00:40:01","TJEMARTIN","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29885","2014-07-12 00:40:01","FRANKP01","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29884","2014-07-12 00:40:01","GRANNY1","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29883","2014-07-12 00:40:01","MJBYL","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29882","2014-07-12 00:35:16","KEYMUSIC","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29881","2014-07-12 00:35:16","LARISSAWBB","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29880","2014-07-12 00:35:03","JBONNER","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29879","2014-07-12 00:35:03","ADHALSEY","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29878","2014-07-12 00:35:03","RITZAROV","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29877","2014-07-12 00:35:03","SWANPR","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29876","2014-07-12 00:35:03","JOEWELL40","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29875","2014-07-12 00:35:03","NAMELESS91","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29874","2014-07-12 00:35:03","CHASIIND","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29873","2014-07-12 00:35:03","MRG0223","5","0","0",NULL,"9")^^
INSERT INTO log VALUES("29872","2014-07-12 00:35:03","TEDLEIMBACH","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29871","2014-07-12 00:35:02","CAMACHINIST","12","0","0",NULL,"9")^^
INSERT INTO log VALUES("29870","2014-07-12 00:35:02","DANNTM","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29869","2014-07-12 00:35:02","REGNID1@SRT.COM","6","0","0",NULL,"9")^^
INSERT INTO log VALUES("29868","2014-07-12 00:35:02","DUGARM","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29867","2014-07-12 00:30:08","JUAN88","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29866","2014-07-12 00:30:08","SPEEDBIRD1K","4","0","0",NULL,"9")^^
INSERT INTO log VALUES("29865","2014-07-12 00:30:08","JOHN","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29864","2014-07-12 00:30:07","FRITZF","15","0","0",NULL,"9")^^
INSERT INTO log VALUES("29863","2014-07-12 00:30:07","RAVENSIVY","5","0","0",NULL,"9")^^
INSERT INTO log VALUES("29862","2014-07-12 00:30:06","WGDVICTORY","4","0","0",NULL,"9")^^
INSERT INTO log VALUES("29861","2014-07-12 00:30:06","LOIS SALCH","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29853","2014-07-12 00:30:01","KRLKOM@AOL.COM","19","0","0",NULL,"9")^^
INSERT INTO log VALUES("29854","2014-07-12 00:30:05","JOANIE2100","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29855","2014-07-12 00:30:06","DCMARSH","7","0","0",NULL,"9")^^
INSERT INTO log VALUES("29856","2014-07-12 00:30:06","VABIKER23518","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29857","2014-07-12 00:30:06","SUZANNE.CALL","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29858","2014-07-12 00:30:06","RODMANB294","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29859","2014-07-12 00:30:06","KHATERA","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29860","2014-07-12 00:30:06","SCOOTERCUB","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29964","2014-07-13 00:45:01","URITEST88","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29963","2014-07-13 00:45:01","I005547","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29962","2014-07-13 00:45:01","WILADAYVO","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29961","2014-07-13 00:45:01","JERIANN57","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29960","2014-07-13 00:45:01","TRFAMSNAG","4","0","0",NULL,"9")^^
INSERT INTO log VALUES("29959","2014-07-13 00:45:01","MARSHONE","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29958","2014-07-13 00:45:01","MARYCAR","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29957","2014-07-13 00:45:01","FRANKP01","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29956","2014-07-13 00:45:01","GETBENT","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29955","2014-07-13 00:45:01","SALTATORIA","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29954","2014-07-13 00:40:03","131159300","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29953","2014-07-13 00:40:03","GRAHAMIRWIN","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29952","2014-07-13 00:40:03","VALENCIA","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29951","2014-07-13 00:40:03","KEYMUSIC","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29950","2014-07-13 00:40:03","FRANANN","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29949","2014-07-13 00:40:03","UTEST88","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29948","2014-07-13 00:40:03","SUPERSTAR","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29947","2014-07-13 00:40:02","PHYSGIRL","4","0","0",NULL,"9")^^
INSERT INTO log VALUES("29946","2014-07-13 00:40:02","REDSKINS","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29945","2014-07-13 00:40:02","ELDUB51","9","0","0",NULL,"9")^^
INSERT INTO log VALUES("29944","2014-07-13 00:40:02","CMA6273","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29910","2014-07-13 00:30:02","KRLKOM@AOL.COM","19","0","0",NULL,"9")^^
INSERT INTO log VALUES("29911","2014-07-13 00:30:05","JOANIE2100","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29912","2014-07-13 00:30:05","BIGNANAVC","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29913","2014-07-13 00:30:05","DCMARSH","7","0","0",NULL,"9")^^
INSERT INTO log VALUES("29914","2014-07-13 00:30:06","VABIKER23518","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29915","2014-07-13 00:30:06","SUZANNE.CALL","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29916","2014-07-13 00:30:06","RODMANB294","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29917","2014-07-13 00:30:06","SCOOTERCUB","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29918","2014-07-13 00:30:06","LOIS SALCH","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29919","2014-07-13 00:30:06","WGDVICTORY","4","0","0",NULL,"9")^^
INSERT INTO log VALUES("29920","2014-07-13 00:30:07","RAVENSIVY","5","0","0",NULL,"9")^^
INSERT INTO log VALUES("29921","2014-07-13 00:30:07","FRITZF","15","0","0",NULL,"9")^^
INSERT INTO log VALUES("29922","2014-07-13 00:30:07","SPEEDBIRD1K","4","0","0",NULL,"9")^^
INSERT INTO log VALUES("29923","2014-07-13 00:30:08","JUAN88","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29924","2014-07-13 00:30:08","HELLO","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29925","2014-07-13 00:35:01","REGNID1@SRT.COM","6","0","0",NULL,"9")^^
INSERT INTO log VALUES("29926","2014-07-13 00:35:02","DANNTM","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29927","2014-07-13 00:35:02","CAMACHINIST","12","0","0",NULL,"9")^^
INSERT INTO log VALUES("29928","2014-07-13 00:35:02","TEDLEIMBACH","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29929","2014-07-13 00:35:02","MRG0223","5","0","0",NULL,"9")^^
INSERT INTO log VALUES("29930","2014-07-13 00:35:02","CHASIIND","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29931","2014-07-13 00:35:02","NAMELESS91","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29932","2014-07-13 00:35:02","JOEWELL40","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29933","2014-07-13 00:35:02","KHATERA","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29934","2014-07-13 00:35:02","SWANPR","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29935","2014-07-13 00:35:03","RITZAROV","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29936","2014-07-13 00:35:03","ADHALSEY","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29937","2014-07-13 00:35:03","JBONNER","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29938","2014-07-13 00:35:03","LARISSAWBB","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29939","2014-07-13 00:35:03","JOHN","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29940","2014-07-13 00:40:01","DUGARM","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29941","2014-07-13 00:40:02","MJBYL","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29942","2014-07-13 00:40:02","GRANNY1","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29943","2014-07-13 00:40:02","TJEMARTIN","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29852","2014-07-11 00:45:03","JOHNMAC88","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29833","2014-07-11 00:40:03","SUPERSTAR","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29834","2014-07-11 00:40:03","UTEST88","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29851","2014-07-11 00:45:03","NOSHOESFORUS","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29850","2014-07-11 00:45:03","MWHEALY31","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29849","2014-07-11 00:45:03","PAPPAYLIOU","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29848","2014-07-11 00:45:03","URITEST88","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29847","2014-07-11 00:45:03","I005547","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29846","2014-07-11 00:45:03","WILADAYVO","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29845","2014-07-11 00:45:03","JERIANN57","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29844","2014-07-11 00:45:03","TRFAMSNAG","4","0","0",NULL,"9")^^
INSERT INTO log VALUES("29843","2014-07-11 00:45:02","MARSHONE","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29842","2014-07-11 00:45:02","MARYCAR","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29841","2014-07-11 00:45:02","FRANKP01","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29840","2014-07-11 00:45:02","GETBENT","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29839","2014-07-11 00:45:02","SALTATORIA","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29838","2014-07-11 00:40:04","GRAHAMIRWIN","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29837","2014-07-11 00:40:03","VALENCIA","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29836","2014-07-11 00:40:03","KEYMUSIC","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29835","2014-07-11 00:40:03","FRANANN","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29832","2014-07-11 00:40:03","PHYSGIRL","4","0","0",NULL,"9")^^
INSERT INTO log VALUES("29831","2014-07-11 00:40:03","REDSKINS","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29830","2014-07-11 00:40:03","ELDUB51","9","0","0",NULL,"9")^^
INSERT INTO log VALUES("29829","2014-07-11 00:40:03","CMA6273","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29828","2014-07-11 00:40:03","TJEMARTIN","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29827","2014-07-11 00:40:03","GRANNY1","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29826","2014-07-11 00:40:03","MJBYL","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29825","2014-07-11 00:40:01","DUGARM","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29824","2014-07-11 00:35:03","JOHN","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29823","2014-07-11 00:35:02","LARISSAWBB","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29822","2014-07-11 00:35:02","JBONNER","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29821","2014-07-11 00:35:02","ADHALSEY","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29820","2014-07-11 00:35:02","RITZAROV","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29819","2014-07-11 00:35:02","SWANPR","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29818","2014-07-11 00:35:02","KHATERA","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29817","2014-07-11 00:35:02","JOEWELL40","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29816","2014-07-11 00:35:02","NAMELESS91","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29815","2014-07-11 00:35:02","CHASIIND","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29814","2014-07-11 00:35:02","MRG0223","5","0","0",NULL,"9")^^
INSERT INTO log VALUES("29813","2014-07-11 00:35:02","TEDLEIMBACH","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29812","2014-07-11 00:35:02","DANNTM","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29811","2014-07-11 00:35:02","REGNID1@SRT.COM","6","0","0",NULL,"9")^^
INSERT INTO log VALUES("29810","2014-07-11 00:30:08","JUAN88","1","0","0",NULL,"9")^^
INSERT INTO log VALUES("29809","2014-07-11 00:30:08","SPEEDBIRD1K","4","0","0",NULL,"9")^^
INSERT INTO log VALUES("29808","2014-07-11 00:30:07","FRITZF","15","0","0",NULL,"9")^^
INSERT INTO log VALUES("29807","2014-07-11 00:30:07","RAVENSIVY","5","0","0",NULL,"9")^^
INSERT INTO log VALUES("29806","2014-07-11 00:30:07","WGDVICTORY","4","0","0",NULL,"9")^^
INSERT INTO log VALUES("29805","2014-07-11 00:30:07","LOIS SALCH","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29804","2014-07-11 00:30:06","SCOOTERCUB","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29803","2014-07-11 00:30:06","RODMANB294","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29802","2014-07-11 00:30:05","SUZANNE.CALL","3","0","0",NULL,"9")^^
INSERT INTO log VALUES("29801","2014-07-11 00:30:05","VABIKER23518","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29800","2014-07-11 00:30:04","CAMACHINIST","13","0","0",NULL,"9")^^
INSERT INTO log VALUES("29799","2014-07-11 00:30:04","DCMARSH","7","0","0",NULL,"9")^^
INSERT INTO log VALUES("29798","2014-07-11 00:30:04","JOANIE2100","2","0","0",NULL,"9")^^
INSERT INTO log VALUES("29797","2014-07-11 00:30:02","KRLKOM@AOL.COM","19","0","0",NULL,"9")^^




CREATE TABLE `map` (
  `map` int NOT NULL AUTO_INCREMENT,
  `trip` int DEFAULT NULL,
  `link` varchar(55) DEFAULT NULL,
  `caption` varchar(50) DEFAULT NULL,
  `width` char(3) DEFAULT '80' COMMENT '% width of cell',
  `sort` decimal(5,2) DEFAULT NULL,
  PRIMARY KEY (`map`)
) ENGINE=MyISAM AUTO_INCREMENT=1550 DEFAULT CHARSET=latin1^^

INSERT INTO map VALUES("461","66","gansendorf.JPG","Gansendorf","80","5.00")^^
INSERT INTO map VALUES("462","66","vilsHBF.JPG","Vilshofen BHF","80","21.00")^^
INSERT INTO map VALUES("439","66","mainz1.JPG","Mainz HBF to dock (1)","80","1.00")^^
INSERT INTO map VALUES("442","66","budapestDock2.JPG","Mahart Garam","80","3.00")^^
INSERT INTO map VALUES("431","66","bbHotel.JPG","BBHotel Munich airpot","80","24.00")^^
INSERT INTO map VALUES("432","66","bad ischl.JPG","bad ischl","80","13.00")^^
INSERT INTO map VALUES("433","66","siegl.JPG","siegl","80","14.00")^^
INSERT INTO map VALUES("434","66","Mitterweissenbach.JPG","mitterwiessenbach","80","15.00")^^
INSERT INTO map VALUES("435","66","lahnstein.JPG","lahnstein","80","16.00")^^
INSERT INTO map VALUES("436","66","steinkogel.JPG","steinkogel","80","17.00")^^
INSERT INTO map VALUES("477","29","airport vis oldsmar.jpg","Tampa airport - dunedin via oldsmar","80","7.00")^^
INSERT INTO map VALUES("478","29","bestBuy.jpg","Montclair & Keene to Best Buy","80","9.00")^^
INSERT INTO map VALUES("523","78","stp.png","793 77th Avenue N St. Petersburg","80","1.00")^^
INSERT INTO map VALUES("524","78","Cary.png","Cary Amtrak to Best Western","80","2.00")^^
INSERT INTO map VALUES("526","78","LeoHouse.png","Leo House","80","3.00")^^
INSERT INTO map VALUES("467","29","galvaFood.jpg","Galva Restaurants","80","5.00")^^
INSERT INTO map VALUES("520","76","char2.png","I77 to I277 Charlontte","80","4.00")^^
INSERT INTO map VALUES("510","57","hands on.png","Hands on bike shop","80","4.00")^^
INSERT INTO map VALUES("511","57","I275.png","840 Virginia to I275","89","5.00")^^
INSERT INTO map VALUES("517","76","leoHouse.png","NYP to Leo House","80","2.00")^^
INSERT INTO map VALUES("519","76","char1.png","Us 74 to I77 charlont","80","3.00")^^
INSERT INTO map VALUES("489","29","troy.jpg","Super 8, Troy","80","19.00")^^
INSERT INTO map VALUES("490","29","edwadsville.jpg","Edwardsville","80","21.00")^^
INSERT INTO map VALUES("491","29","Hardin to MCT head.jpg","Hardin to MCT Watershead trail head","80","22.00")^^
INSERT INTO map VALUES("492","29","Bourse R to Super 8 alt.jpg","Bourse Rd to Super 8 (alt)","80","23.00")^^
INSERT INTO map VALUES("493","29","glen Carbon.jpg","Glen Carbon Heritage - Nickel Plate","80","20.00")^^
INSERT INTO map VALUES("494","29","Collinsville Super 8.png","Collinsville Super 8","80","24.00")^^
INSERT INTO map VALUES("495","29","siue.png","SIUE trails","80","25.00")^^
INSERT INTO map VALUES("496","29","leclaire.JPG","SIUE to Leclaire Trailhead","98","26.00")^^
INSERT INTO map VALUES("497","29","leclaire Trailhead.JPG","Leclaire Trailhead","80","27.00")^^
INSERT INTO map VALUES("498","29","npvEast.png","lisle","80","28.00")^^
INSERT INTO map VALUES("499","29","oakbrook1.png","Oakbrook west","80","29.00")^^
INSERT INTO map VALUES("500","29","oakbrook2.png","oakbrook east","80","30.00")^^
INSERT INTO map VALUES("574","29","Oldsmar5.png","Oldsmar Tr Mobbly Park (end)","80","38.00")^^
INSERT INTO map VALUES("571","29","Oldsmar2.png","Oldsmar Tr crossing FL 580","80","35.00")^^
INSERT INTO map VALUES("572","29","Oldsmar3.png","Oldsmar Tr Shore Dr","80","36.00")^^
INSERT INTO map VALUES("573","29","Oldsmar4.png","Oldsmar Tr Dunkirk Dr","80","37.00")^^
INSERT INTO map VALUES("570","29","Oldsmar1.png","Oldsmar Tr Sheffield Park","80","34.00")^^
INSERT INTO map VALUES("507","29","from NPV.png","NPV to Harrick Lake Preserve","80","31.00")^^
INSERT INTO map VALUES("508","29","Harrick Lake.png","Harrick Lake to Ill Prairie Path","80","32.00")^^
INSERT INTO map VALUES("509","29","River Forest.png","River Forest Metra","80","33.00")^^
INSERT INTO map VALUES("516","76","RGH.png","RGH to HI Raleigh","80","1.00")^^
INSERT INTO map VALUES("446","66","devin.jpg","Devin","80","7.00")^^
INSERT INTO map VALUES("447","66","DEVINSKA.JPG","Devinska Nova Ves","80","8.00")^^
INSERT INTO map VALUES("448","66","brataslafa.jpg","Brataslava","90","6.00")^^
INSERT INTO map VALUES("449","66","steinbach.JPG","Steinbach","80","20.00")^^
INSERT INTO map VALUES("450","66","vilshofen.JPG","Vilshofen","80","22.00")^^
INSERT INTO map VALUES("451","66","hollabrunn.JPG","Hollabrunn","80","10.00")^^
INSERT INTO map VALUES("452","66","stockerau.JPG","Stockerau","80","11.00")^^
INSERT INTO map VALUES("532","80","flowerMap.png","Hiking route thru Flower Campground","80","5.00")^^
INSERT INTO map VALUES("488","29","Goshen-Nickel Plate.jpg","Goshen and Nickel Plate junction","80","18.00")^^
INSERT INTO map VALUES("479","29","drew-keene1.jpg","Drew & Keene (1)","80","10.00")^^
INSERT INTO map VALUES("480","29","drew-keene2.jpg","Drew & Keene (2)","80","11.00")^^
INSERT INTO map VALUES("481","29","aldi.jpg","Keene & Montclair to Aldi","80","8.00")^^
INSERT INTO map VALUES("482","29","walmart.jpg","Walmart","80","12.00")^^
INSERT INTO map VALUES("483","29","hermosa springs.jpg","Dunedin to Hermosa Springs avoiding 19","80","13.00")^^
INSERT INTO map VALUES("484","29","WV.jpg","I275 to Dunedin","80","14.00")^^
INSERT INTO map VALUES("485","29","largo1.jpg","Largo central park","80","15.00")^^
INSERT INTO map VALUES("486","29","largo2.jpg","Walsingham park, Largo","80","16.00")^^
INSERT INTO map VALUES("487","29","watershead parking.jpg","Watershead Trail Parking Lot via Il-255","80","17.00")^^
INSERT INTO map VALUES("445","66","schlosshof.JPG","Schlosshof","80","9.00")^^
INSERT INTO map VALUES("567","80","94th.jpg","94th street","80","6.00")^^
INSERT INTO map VALUES("466","29","GBb-KEE.JPG","Galesburg to Kewanne overview","80","1.00")^^
INSERT INTO map VALUES("465","29","kewanne.jpg","Kewanne","80","3.00")^^
INSERT INTO map VALUES("469","57","curlew.JPG","1100 Curlew Rd, Lot 145, 5th st","80","1.00")^^
INSERT INTO map VALUES("470","57","oxford Ct.jpg","Heather Hills, Oxford Ct","80","2.00")^^
INSERT INTO map VALUES("471","57","stPeter.JPG","Chi Union Station to St. Peter church","80","3.00")^^
INSERT INTO map VALUES("472","31","dunedin.JPG","Curlew Rd to 840 Virginia","80","1.00")^^
INSERT INTO map VALUES("474","70","Lhotel.jpg","36 Str subway to L hotel Brooklyn","80","1.00")^^
INSERT INTO map VALUES("475","70","barton.JPG","Station cycle hire to Barton Close","95","2.00")^^
INSERT INTO map VALUES("476","29","aldi-clearwater.jpg","Patricia - Aldi - Downtown Clearwater","80","6.00")^^
INSERT INTO map VALUES("455","66","stockerau1.jpg","stockerau to Danube","80","12.00")^^
INSERT INTO map VALUES("542","80","ottumwa-pella.png","Ottumwa to Pella","80","2.00")^^
INSERT INTO map VALUES("543","80","pella-Ankeny.png","Pella to Ankeny","80","3.00")^^
INSERT INTO map VALUES("544","80","quality inn.png","Quality Inn","80","4.00")^^
INSERT INTO map VALUES("568","80","flower2.jpg","turn by restroom","80","9.00")^^
INSERT INTO map VALUES("569","85","Sheraton.png","Moynihan to Sheraton","80","1.00")^^
INSERT INTO map VALUES("565","80","flower1.jpg","marina",NULL,"10.00")^^
INSERT INTO map VALUES("564","80","flower4.jpg","trail<->campgrounnd","80","7.00")^^
INSERT INTO map VALUES("562","80","ott2.png","2nd Ottumwa","80","15.00")^^
INSERT INTO map VALUES("563","80","ottumwa1.jpg","1st Ottumwa","80","14.00")^^
INSERT INTO map VALUES("380","54","stadtpark-hotel1.JPG","Stadtpark - hotel (1)","80","14.00")^^
INSERT INTO map VALUES("521","76","char3.png","US 74 to I277 Charlotte","80","5.00")^^
INSERT INTO map VALUES("463","29","wataga-oneida.jpg","Wataga-Oneida","80","2.00")^^
INSERT INTO map VALUES("522","77","amBus-MillersAleHouse.png","Ambus to Miller's Ale House","80","1.00")^^
INSERT INTO map VALUES("354","29","galva1.png","Galva","80","4.00")^^
INSERT INTO map VALUES("437","66","ebensee.JPG","ebensee","80","19.00")^^
INSERT INTO map VALUES("438","66","gmunden.JPG","gmunden","80","18.00")^^
INSERT INTO map VALUES("460","66","marchegg.JPG","Marchegg","80","4.00")^^
INSERT INTO map VALUES("441","66","regensburgIbis.JPG","Regensburg HBF to Ibis","80","23.00")^^
INSERT INTO map VALUES("361","54","Augarten.jpg","Augarten entrance","80","7.00")^^
INSERT INTO map VALUES("362","54","Karlsplaz.jpg","Karlsplatz","80","6.00")^^
INSERT INTO map VALUES("384","54","prater.jpg","Prater (from Augarten)","80","9.00")^^
INSERT INTO map VALUES("379","54","reisenRad-Ring.JPG","Reisenrad to Stadtpark","80","13.00")^^
INSERT INTO map VALUES("389","54","guertel towards Karlsplatz.JPG","Guertel to Karlsplatz","90","16.00")^^
INSERT INTO map VALUES("367","54","Meiding-Marriot.JPG","Bhf Meiding - Marriot","80","4.00")^^
INSERT INTO map VALUES("422","55","sanford.JPG","sanford","80","4.00")^^
INSERT INTO map VALUES("420","55","deBary.JPG","deBary","80","6.00")^^
INSERT INTO map VALUES("381","54","stadtpark-hotel2.JPG","Stadtpark to hotel (2)","80","15.00")^^
INSERT INTO map VALUES("419","55","baldwinPark.JPG","Baldwin Park","80","3.00")^^
INSERT INTO map VALUES("418","55","lake VA.JPG","Lake VA","80","2.00")^^
INSERT INTO map VALUES("385","54","Hotel Bike Station.JPG","Bike statiin near Renaissance Hotel","80","5.00")^^
INSERT INTO map VALUES("386","54","Hotel to Guertel.JPG","Hotel Bike station to Wienerguertel","80","10.00")^^
INSERT INTO map VALUES("387","54","guertel to ring.JPG","Guertel to ring","86","11.00")^^
INSERT INTO map VALUES("388","54","ring Danube Island Prater.JPG","Ring to Danube Island to Prater","80","12.00")^^
INSERT INTO map VALUES("390","54","Karlsplatz to St. Stephens.JPG","Karlsplatz to St. Stephens","80","17.00")^^
INSERT INTO map VALUES("391","54","stephansdom-ring.JPG","Stephansdom to Ring","80","18.00")^^
INSERT INTO map VALUES("392","54","hbhf.JPG","Ring to HBF","80","19.00")^^
INSERT INTO map VALUES("393","54","Venedigerau.JPG","Venedigerau leading to Prater","80","8.00")^^
INSERT INTO map VALUES("394","54","RamadaAMS1.jpg","Ramada AMS","80","2.00")^^
INSERT INTO map VALUES("395","54","RamadaAMS2.jpg","Ramada AMS vicinity","80","3.00")^^
INSERT INTO map VALUES("397","54","schipol.JPG","Schipol","80","1.00")^^
INSERT INTO map VALUES("398","54","sofitel.JPG","Deák Ferenc tér subway to Sofitel hotel","80","20.00")^^
INSERT INTO map VALUES("566","80","flower3.jpg","campaground","80","8.00")^^
INSERT INTO map VALUES("406","66","BudapestDock1.JPG","Budapest Mahart - International Passenger Port","80","2.00")^^
INSERT INTO map VALUES("417","55","blueSpr2.JPG","DeBary to Blue Sp SP (2)","80","1.00")^^
INSERT INTO map VALUES("424","55","lake monroe.JPG","lake monroe","80","5.00")^^
INSERT INTO map VALUES("541","80","houghton-ottumwa.png","Houghton-Ottumwa",NULL,"1.00")^^
INSERT INTO map VALUES("535","80","woodward.png","Woodward","80","13.00")^^
INSERT INTO map VALUES("540","80","slater.png","Slater","80","11.00")^^
INSERT INTO map VALUES("534","80","madrid.png","Madrid","80","12.00")^^
INSERT INTO map VALUES("1546","89","HI to FRA terminal 2.png","Holiday Inn to FRA terminal 2","80","8.00")^^
INSERT INTO map VALUES("1545","89","Frankfurt airport.png","Frankfurt airport BHF to Holiday Inn","80","7.00")^^
INSERT INTO map VALUES("1547","89","passai hbf-ZOB.png","  Passau hbf to Central Bus Station","80","6.00")^^
INSERT INTO map VALUES("1542","89","Victoria Sta.png","Victoria Sta to Victoria Underground","85","3.00")^^
INSERT INTO map VALUES("1541","89","Moynihan to 34th Herald Sq subway.png","  Moynihan to 34th Herald SQ subway","85","1.00")^^
INSERT INTO map VALUES("1540","89","subway to L Hotel.png","  Subway to L Hotel","80","2.00")^^
INSERT INTO map VALUES("1538","89","frankfurt HBF.png","Frankfurt HBF to Intercity Hotel","80","4.00")^^
INSERT INTO map VALUES("1539","89","frankfurt HBF2.png","Frankfurt HBF site Plan","80","5.00")^^
INSERT INTO map VALUES("1549","29","FMD.png","  FMD station","80","39.00")^^




CREATE TABLE `note` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `itin` mediumint DEFAULT NULL,
  `notesort` decimal(4,1) DEFAULT NULL,
  `note` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=297 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci^^

INSERT INTO note VALUES("202","472","4.0","Northern (High Barnet via Charing Cross) to Leicester Square; Piccadilly (Cockfosters)</li>")^^
INSERT INTO note VALUES("207","472","10.0","Wifi: Name SKY255BA, Password XCNLFDWBLR  +44 7411 075257")^^
INSERT INTO note VALUES("204","471","1.0","CBG- ROT dep 9:14 arr Kings X 10:05, dep st. Pan 11:04 arr Rot 15:32 ")^^
INSERT INTO note VALUES("200","472","1.0","0.5 mi from ocean term to Platform tavern, bus U!A to station 8 min very frequent")^^
INSERT INTO note VALUES("199","472","2.0","SOU-CBB Collection reference CNX2H538, CC Order reference number 59239317 ")^^
INSERT INTO note VALUES("215","472","5.0","Bakerloo (Harrow & Wealdstone or Queens Park) to Oxford Circus; Victoria (Walthamstow Central)</li>")^^
INSERT INTO note VALUES("195","469","1.0","bus or uber/lift from hotel to ship?")^^
INSERT INTO note VALUES("191","389","2.0","Rm 13 car 9712")^^
INSERT INTO note VALUES("193","473","1.0","Fahrradverleih Frankfurt near Lokalbahn SB station; open Sat til 1:00PM, opens Tue 9:00AM")^^
INSERT INTO note VALUES("194","469","2.0","Boarding details arrive 4-6 weeks prior to departure.")^^
INSERT INTO note VALUES("184","429","4.0","Filed compensation claim at https://app.airhelp.com/claims/1735475")^^
INSERT INTO note VALUES("175","433","1.0","dep CUS to Fr Pk 3:30, 4:05, 4:20x, 4:30, 4:50x, 4:55x, 5:05, 5:27, 5:46x")^^
INSERT INTO note VALUES("176","433","2.0","dep CUS to Mannheim: 4:20x, 5:05 ")^^
INSERT INTO note VALUES("177","430","1.0","2 bike rentals closed on sunday.  Next day hourly RE at xx:14 takes 1:18 to airport")^^
INSERT INTO note VALUES("179","427","1.0","12:00 Mass St Margaret church 1.0 miles from ship; 0.5 miles from Szent István park on Victor Hugo")^^
INSERT INTO note VALUES("180","428","3.0","Kirche St. Peter, Petersstraße 3 55116 Mainz, 700 m walk, 6:00PM")^^
INSERT INTO note VALUES("182","428","4.0","St. Bonifaz, Bonifaziusplatz 1 near hbf, 270 m walk, 5:00PM")^^
INSERT INTO note VALUES("183","427","2.0","11:00 Mass St Elizabeth church 9.4 mi from Keleti station")^^
INSERT INTO note VALUES("188","389","1.0","Call Dr Quintero 217-223-1981. return 8/27,  new 9/11 2:15")^^
INSERT INTO note VALUES("178","466","5.0","also bus 691 (direction Friesing) to Lilienthalstraße, 7 min walk")^^
INSERT INTO note VALUES("185","388","1.0","Verizon store 1004 S Canal S (about 8 bls 0.6 mi straight S of US) open 11:00AM")^^
INSERT INTO note VALUES("171","451","2.0","B-B-MUC 18:42-22:26, pd $113.65 for 4.  There is left luggage at Baden-Baden station")^^
INSERT INTO note VALUES("164","466","4.0","Airport Shuttle bus at bus stop No. 6 - Hallbergmoos (close to to to CheckIn Z area)")^^
INSERT INTO note VALUES("167","451","3.0","Velhop bike Strasbourg; int link to online booking; shop CENTER 3 Rue d Or, 17 min by Tram D from Kehl")^^
INSERT INTO note VALUES("162","466","2.0","airport to Halbergmoos (S8) 00:07 every 20 min")^^
INSERT INTO note VALUES("163","466","3.0","Bus 698 (dir Hallbergmoos) 5min to Messerschmittstr stop, 2 min walk, every 20 min")^^
INSERT INTO note VALUES("186","390","1.0","SS Arr TPA 12:45; bus dep 1:00PM arr STP 1:40PM; Uber or Lyft from STP to Dunedin")^^
INSERT INTO note VALUES("76","366","1.0","KLM Flight 612 depart 4:00 PM term 5; seats 21J & H; booking code TCP2PR")^^
INSERT INTO note VALUES("77","367","1.0","Ramada Sloterweg 299, +31-20-6588111")^^
INSERT INTO note VALUES("116","379","1.0","dep WPK 9:43 arr TPA 12:23; bus dep TPA 1:00 arr STP 1:40")^^
INSERT INTO note VALUES("43","371","1.0","DL 137 (KL 6120) 1:00PM-3:39PM seats 28A&B; ")^^
INSERT INTO note VALUES("102","367","3.0","At shuttle bus stop, turn right (out of airport), cross over two sections of zebra crossing to the correct bus. There is no shelter or signage,  just BUS STOP painted ON ROAD. Sheraton in front of you")^^
INSERT INTO note VALUES("75","365","1.0","Candlewood Suites, 4021 North Mannheim Road Schiller Park, IL 60176, 1-847-671-4663")^^
INSERT INTO note VALUES("47","373","2.0","Meidling BHF ==>Ren Hotel: bus 62A (walk 3+2); Bus 9A (5+2); U6 (9+4)")^^
INSERT INTO note VALUES("48","373","8.0","STRASSER BRÄU WS v S E8.90, Schönbrunner Str. 253")^^
INSERT INTO note VALUES("52","373","9.0","High mass St. Stephens 9:30; U-bahn to HBF 11 min (every 5 min)")^^
INSERT INTO note VALUES("113","376","1.0","dep Quincy 7:55 am arr chi 9:17 UA 5074 (term 1); 45 min before for baggage check")^^
INSERT INTO note VALUES("114","376","2.0","dep chi 11:25, arr orl 3:07 UA 848 (term 1)")^^
INSERT INTO note VALUES("115","376","4.0","shuttle loc: B-Side of the Terminal, on the Ground Transportation Level (1) at Commercial Lane spaces B42-B47")^^
INSERT INTO note VALUES("60","386","1.0","Enterprise rental #1155471007; $276.49")^^
INSERT INTO note VALUES("61","386","2.0","Pickup West El Paso officef 4115 North Mesa, (915) 532-7717 closes 6:00PM")^^
INSERT INTO note VALUES("62","386","3.0","Return Sunday Jan 28. 3961 Cerrillos Rd,  (505) 424-1134  Hours 10:00 AM - 2:00 P")^^
INSERT INTO note VALUES("119","451","6.0","Overnight train dep Munich 23:20 to Budapest arr 9:19 booked 3/21 with OBB")^^
INSERT INTO note VALUES("120","451","1.0","Kehl-baden-baden 8:03-8:41, 09:33-10:27, E9.2.   No additional for bus to Merkur tal station ")^^
INSERT INTO note VALUES("192","5","1.0",NULL)^^
INSERT INTO note VALUES("117","401","1.0","Engelhartszell-Aschach, Brats-Hof, Szentendre,Visegrad-Esztergom,Vienna,Krems-Melk")^^
INSERT INTO note VALUES("118","451","4.0","B-B bike rental http://www.rent-a-sportsman.de/")^^
INSERT INTO note VALUES("71","386","4.0","Car rental canceled # 1155471007")^^
INSERT INTO note VALUES("73","369","1.0","RJ to Budapest: 11:40-14:19; ")^^
INSERT INTO note VALUES("74","369","3.0","Meet at Sofitel Chain Bridge hotel, Széchenyi István tér 2, 1051 via M2 to Deák Ferenc tér")^^
INSERT INTO note VALUES("78","368","1.0","IC 3153 dep Schipol 14:30 track 3; arr Utrecht Centraal 15:07 track 18 ")^^
INSERT INTO note VALUES("79","368","2.0","ICE 129 dep Utrecht 17:06 track 15; arr Düsseldorf 18:46 , Car 32, seats 81 83 85 87")^^
INSERT INTO note VALUES("80","368","3.0","NJ40421 dep Dusseldorf 20:54, car 255 rm 036 032, arr Meidling 8:07")^^
INSERT INTO note VALUES("81","373","1.0","Renaissance Wien Hotel, Linke Wienzeile/Ullmannstrasse 71, +43-1-891020")^^
INSERT INTO note VALUES("82","373","3.0","BHF bike station: cross main str, 1203  Vivenotgasse  corner of Wilhelmstrass; to hotel 0.7 mi")^^
INSERT INTO note VALUES("83","373","7.0","Hotel bike station, left on Linke Wienzeile 0.2mi, right on Storchensteg 102 ft, Right Bruno-Pittermann-Platz 46 ft")^^
INSERT INTO note VALUES("84","370","1.0","Bastion Hotel Amsterdam Airport, Vuursteen 3, 2132 LZ Hoofddorp, +31 20-820 4466")^^
INSERT INTO note VALUES("86","372","1.0","SWC dep CHI 2:50, arr FMD 6:25 PM")^^
INSERT INTO note VALUES("87","394","1.0","Sun Metra to Brookfield 4:40-5:03, 6:40-7:03; to LaG 3 min later; Sat add 5:40-6:03")^^
INSERT INTO note VALUES("88","366","2.0","carry on 21 5/8 x 13 3/4 x 9 7/8; accessory 15/ 34 x 11 3/4 x 5 7/8")^^
INSERT INTO note VALUES("89","371","3.0","upgraded to comfort + 6/10; conf #GGZVE8")^^
INSERT INTO note VALUES("90","371","4.0","LT: recommended 3 hr, checked in 60 min; at gate 45 min")^^
INSERT INTO note VALUES("91","371","5.0","online checkin at Delta.com up to 24 hours; click ")^^
INSERT INTO note VALUES("92","366","3.0","online in at klm.com up to 24 hours before dep; i.e. after 4 PM at candlewood")^^
INSERT INTO note VALUES("93","373","4.0","Citybike Wien (P) customer number 1055476, user name QCY, PW 5225")^^
INSERT INTO note VALUES("94","373","6.0","Citybike Wien (J) customer number 1028077, user name jobtrak1, PW 5225")^^
INSERT INTO note VALUES("95","365","2.0","SWC dep FMD 11:09, arr CHI 3:15. Drive to FMD 1:13 + 30 => leave 9:26 AM if on time)")^^
INSERT INTO note VALUES("97","365","3.0","Metra to FP 3:30-4:02; 4:05-4:40; 4:20-4:44; 4:30-5:07; dep CHI 6:40 every hr til 12:40")^^
INSERT INTO note VALUES("96","365","4.0","Metra to Mannheim: 4:20-4:46 and 5:05-5:36; 0.2 mi to Al & Joes, 0.6 mi further to Candlewood")^^
INSERT INTO note VALUES("98","372","2.0","Cancer center appt 10:45 tommorow")^^
INSERT INTO note VALUES("99","366","4.0","Free WIFI at Schipol")^^
INSERT INTO note VALUES("100","367","2.0","Shuttle: lane C, around C13(not lane A for Ramada Apollo). Accros road from sign, mini bus with Red Ramada lettering. Reserve day before leaving.")^^
INSERT INTO note VALUES("101","371","2.0","DTW to ORD: Delta Connection (DLD 1174 or KL 8250)) 5:50PM-6:16 seats 11D&E")^^
INSERT INTO note VALUES("103","367","4.0","unclear whether mini bus is black or white")^^
INSERT INTO note VALUES("104","373","5.0","Citybike Wien (P) customer number 105494, user name jack_, PW 5225")^^
INSERT INTO note VALUES("105","369","2.0","Buy subway tickets at tourist office (not on platform)")^^
INSERT INTO note VALUES("106","370","2.0","Shuttle  quarter to- and a quarter past the hour from platform A9")^^
INSERT INTO note VALUES("107","370","3.0",NULL)^^
INSERT INTO note VALUES("111","446","2.0","Day 2: bike to Clinton & back 33.2 mi")^^
INSERT INTO note VALUES("110","446","1.0","Day 1; bike to Windsor from Sedalia, 19 MI")^^
INSERT INTO note VALUES("112","446","3.0","Day3: bike to leeton & back 21.2 mi")^^
INSERT INTO note VALUES("123","431","1.0","flight: MUC-LHR BA0951 dep term 1 12:45 arr term 5 13:50,  seats 11D, 11C. Changed 12/4 to 10D & 10 E (exit row)")^^
INSERT INTO note VALUES("124","431","2.0","LH-ORD BA0297 dep term 5 16:05, arr term 5 18:45,  seats 20C & 20B")^^
INSERT INTO note VALUES("125","429","1.0","Chi term 5 to MAD IB 6274 dep 16:25 arr 7:25AM.  MAD term 4 to MUC IB 3190, dep 8:55AM arr 11:30")^^
INSERT INTO note VALUES("187","388","2.0","Mass at St. Peters 11:00 and12:30 0.6 mi")^^
INSERT INTO note VALUES("127","429","2.0","ORD to MAD paid for seats 21C, 21A ($79 & $37)")^^
INSERT INTO note VALUES("128","429","3.0","MAD to MUC paid for 11C & 11 D ($12 each)")^^
INSERT INTO note VALUES("129","431","3.0","Paula 12:45 PM United 9261 S")^^
INSERT INTO note VALUES("130","431","4.0","Terry dep MUC 10:10 KLM?")^^
INSERT INTO note VALUES("132","434","1.0","From MUC: S8 or S1 to rosenheimer Platz, tram 15 to Tegernseer Landstrasse")^^
INSERT INTO note VALUES("133","434","2.0","MVV single ticket airport to center e11.60, group e24.30 (8.10pp), approx 1 hr to hotel, can buy online")^^
INSERT INTO note VALUES("168","451","5.0","One City Bike rental")^^
INSERT INTO note VALUES("136","434","4.0","HBF Gl 27-36 to Gmund am Tegernsee dep 9:04, 9:24, 10:04 1:05-1:12")^^
INSERT INTO note VALUES("137","434","3.0","Silberhornstr->HBF U2 18/hr. 6 min. Wettersteinplz.->HBF U1 1988/hr, 9-11 min")^^
INSERT INTO note VALUES("138","434","5.0","Radius bike rental track 33 open 8:30AM-8:pm, 16E/day")^^
INSERT INTO note VALUES("190","390","3.0","lyft est $21-24, Uber 22.79")^^
INSERT INTO note VALUES("189","390","2.0","station address 5251 110th Ave N, Clearwater, FL 33760")^^
INSERT INTO note VALUES("141","428","1.0","MUC-Mainz 11:57-16:18 booked 4 persons 4/5 conf # VL6OGO")^^
INSERT INTO note VALUES("142","428","2.0","ICE 1004 11:57-12:58 Nürnberg; 13:30 - 15:36 Frankfurt Hbf;  15:44 - 16:18 15:44 Mainz Hbf")^^
INSERT INTO note VALUES("159","466","1.0","Regensburg-airport RE 1:18 every hour (4:14-5:32PM)")^^
INSERT INTO note VALUES("146","379","2.0","Uber est STP to 902 Beltrees, Dunedin $19.93; ")^^
INSERT INTO note VALUES("147","381","2.0","Amtrak to 914 N Kentucky UBER $7.60 ")^^
INSERT INTO note VALUES("148","378","2.0","Uber WHT Amtrak to 718 Carrol Av SW $6.26. Lyft $6-8")^^
INSERT INTO note VALUES("149","448","1.0","La Quinta to ORL amtrak Lyft $12-15, Uber $9.91")^^
INSERT INTO note VALUES("150","448","3.0","Lakeland Amtrak to house Lyft Uber $6-8, Uber $6.26")^^
INSERT INTO note VALUES("151","376","3.0","UAL carry-on 9x14x22; personal 9x10x17")^^
INSERT INTO note VALUES("152","448","2.0","Dep ORL 10:20 AM arive LAK 11:29 AM")^^
INSERT INTO note VALUES("153","378","1.0","dep LKL 1:13 PM arr WTH 1:35 PM")^^
INSERT INTO note VALUES("154","381","1.0"," SM dep WTH 12:07 pm, arr WPK 1:52 pm")^^
INSERT INTO note VALUES("155","382","1.0","bus dep STP 9:55AM arr ORL 12:50 PM; SM dep 1:35 PM arr NYP 11:00; takes 20 min; dep 9:00")^^
INSERT INTO note VALUES("156","377","1.0","To HI Express: N on 7th Av 4 blocks, right on 36th cross Bdwy & 6th Av, on right")^^
INSERT INTO note VALUES("157","387","1.0","dep NYP 3:40, arr Chi 9:50")^^
INSERT INTO note VALUES("203","472","3.0","UG waterloo-to Kings Cross St. Pancras <ul>")^^
INSERT INTO note VALUES("205","475","1.0","Iceland Air Fl 521 dep FRA terminal 2 14:00; arr Iceland 15:35")^^
INSERT INTO note VALUES("208","472","8.0","key is in key safer in front of door. Code: 3006. lift door handle first then lock the door")^^
INSERT INTO note VALUES("209","472","9.0","when you check out, lock the door, and kept the key as before when you check in. ")^^
INSERT INTO note VALUES("210","472","7.0","Uber from station to city cycle hire £6-8; cycle hire to Barton Close 0.5 mi w bike path")^^
INSERT INTO note VALUES("211","471","2.0","GNR ref # 84RR56WC; Eurostar ref # SBRVUF")^^
INSERT INTO note VALUES("214","475","2.0","Iceland Air Fl 853 dep 16:45; arr CHI 6:20PM term 5")^^
INSERT INTO note VALUES("216","472","6.0","Jubilee (Stanmore or Willesden Green) to Green Park; Victoria (Walthamstow Central)</li></ul>")^^
INSERT INTO note VALUES("217","471","3.0","Pick up CBG to London ticket at station w CC and ref code 84RR56WC")^^
INSERT INTO note VALUES("218","475","3.0","Icelandair ref LV6HLW ticket no's 108-7417028556 and 108-7417028557")^^
INSERT INTO note VALUES("219","483","1.0","SW Chief Trinidad to Raton: 9:50 to 10:56; drive DEN to TRI dep 6:10 + 30 min, DEN to RAT 6:56 +30min")^^
INSERT INTO note VALUES("220","477","1.0",NULL)^^
INSERT INTO note VALUES("221","481","1.0","DUS Gate B17 FF1 dep 8:19;  change to AB1 at Broadway & Euclid Ave 9:21; Downt  Boulder Sta  Gate 3 BOLT dep 9:37, arr 8th & Coffman 10:17")^^
INSERT INTO note VALUES("222","481","2.0","FF1 dep 9:19; change Downtown Boulder Station Gate 3 dep 10:37 arr 11:17")^^
INSERT INTO note VALUES("223","481","3.0","FF1 dep 10:18; change Downtown Boulder Station Gate 3 dep 11:37 arr 12:17")^^
INSERT INTO note VALUES("224","500","1.0","Pedmont 76 dep CLT 3:15PM arr RAL 6:26PM res # 44D16A")^^
INSERT INTO note VALUES("225","499","1.0","LSL ")^^
INSERT INTO note VALUES("227","519","1.0","CLT-RAL #44D16A Train 76 dep 3:15 arr 6:26,  $54.00")^^
INSERT INTO note VALUES("226","501","1.0","dep RAL 8:45 AM arr NYP 6:50 PM, res # 44CE4F")^^
INSERT INTO note VALUES("228","520","1.0","RAL-NYP #44CE4F dep 8:45AM arr 6:50, $168.00")^^
INSERT INTO note VALUES("229","520","2.0","Bid up to roomette; should receive notice 36 hours before departure")^^
INSERT INTO note VALUES("238","525","1.0","Ride from bus station,  john Holmeyer 727-475-8337 or 727-244-7663	")^^
INSERT INTO note VALUES("239","525","2.0","PSTA (Gateway Mall Bus Stop), 793 77th Avenue N., St. Petersburg, FL 33702Amtrak STP location: ")^^
INSERT INTO note VALUES("232","516","1.0","Bus FF1 Gate B17 and BOLT to ith & Coffman, half hour.  Also LD1 gate B18 4:19 and 5:19")^^
INSERT INTO note VALUES("240","524","1.0","New STP location:  PSTA (Gateway Mall Bus Stop), 793 77th Avenue N., St. Petersburg, FL 33702 ")^^
INSERT INTO note VALUES("241","525","3.0"," from bus stop: Uber est 31.36, Lyft 24-28; from TPA Uber $40.21; Lyft 32-36")^^
INSERT INTO note VALUES("242","525","5.0","Rent a used car, 2300 State Rd 580, $179.95, economy $197.95/ wk. 727-796-2886")^^
INSERT INTO note VALUES("243","525","4.0","call uber/lift from Millers Ale House, 0.2 mi from Ambus stop")^^
INSERT INTO note VALUES("244","527","3.0","Dep STP 3:00PM, arr TPA 3:45, dep TPA 5:20PM ")^^
INSERT INTO note VALUES("245","528","1.0","SS Arr Cary 8:11AM, #75 Piedmont dep Cary 10:12AM, arr CLT 1:10PM")^^
INSERT INTO note VALUES("246","529","1.0","Star dep Cary 8:08AM, RGH 8:45AM, arr NYP 6:50PM")^^
INSERT INTO note VALUES("248","530","1.0","#76 Piedmont dep CLT 3:15, arr Cary 6:08, RGH 6:26")^^
INSERT INTO note VALUES("249","531","1.0","LSL dep 3:40PM")^^
INSERT INTO note VALUES("250","532","1.0","LSL arr 10:12")^^
INSERT INTO note VALUES("251","529","2.0","bus #6 7:11-7:22 from, Walnut St at Nottingham(0.4 miles walk);")^^
INSERT INTO note VALUES("252","529","3.0","bus #1 7:34-7:50 from Walnut St at Meeting St (0.4 mile walk)")^^
INSERT INTO note VALUES("253","527","2.0","sched Uber; arr 2:30, drive time 1:00 pickup 1:30")^^
INSERT INTO note VALUES("254","527","1.0","PSTA Gateway Mall Bus Terminal 793 77th Avenue N St. Petersburg, FL 33702")^^
INSERT INTO note VALUES("255","529","4.0","Waterfront Bicycle Shop FCFS 1 hr $10, addl hr $2.50, all day $20, 391 West Street. CALL 212 414 2453")^^
INSERT INTO note VALUES("256","528","2.0","If miss #75 then #77 dep 3:12p arr  6:10p")^^
INSERT INTO note VALUES("257","527","4.0","Canceled STP-TPA segment; driver will pick us up at 3:00 for 5:20 Tpa departure")^^
INSERT INTO note VALUES("258","533","1.0","Immaculate Heart 510 E 1st St. Mass Sat 5:00, Sun 8:30 & 10:30")^^
INSERT INTO note VALUES("259","533","2.0",NULL)^^
INSERT INTO note VALUES("260","544","1.0",NULL)^^
INSERT INTO note VALUES("261","550","1.0","Nov 25 gbb-den $703; nyp-tpa $644 = 1347")^^
INSERT INTO note VALUES("262","553","1.0","dep 5:20 PM. arr 7:10 PM")^^
INSERT INTO note VALUES("263","553","2.0","plan to ship bike in box to CHI")^^
INSERT INTO note VALUES("265","560","1.0","Sh central to victoria 10:13-12:45 6.00GBP, nat rail; 12 min subway (going to  Walthamstow Central) to  St Pancras")^^
INSERT INTO note VALUES("267","561","1.0","FRA-Passau 10:01-2:25; bus from Hauptbahnhof or ZOB platform 1 A/B (0.3 mi from HBF) to Lindau dock")^^
INSERT INTO note VALUES("268","561","4.0","from HBF 3:50-4:01, bus 6101 to Rathaus, Wegscheid")^^
INSERT INTO note VALUES("286","560","3.0","Eurostar dep 3:04PM, arrive at station 90 min early (1:34)")^^
INSERT INTO note VALUES("273","560","5.0","Hotel Directions: follow signs to Gate 33 with hotel symbol. In CargoCity Süd turn right after the underpass, then right again and you will see the hotel with driveway on the right side.")^^
INSERT INTO note VALUES("272","559","1.0",NULL)^^
INSERT INTO note VALUES("274","562","1.0","disembark Passau 11:30; about 11 min bus to HBF")^^
INSERT INTO note VALUES("276","562","7.0","ICE 26, Passau, change Nuernburg to Frankfurt fernbhf; 13:37 to 19:20")^^
INSERT INTO note VALUES("277","563","1.0","quality inn 2 dbl $89 + 13 tax. ohare inn queen $84 + ?")^^
INSERT INTO note VALUES("278","561","3.0","From ZOB  bus 1 ( Zahnradfabrik Werk 1) to Lindau: 3:00-3:19; 4:00-4:19")^^
INSERT INTO note VALUES("279","563","2.0","AA carry on size 22 x 14 x 9 inches (including handles and wheels)")^^
INSERT INTO note VALUES("281","558","1.0","0.6 mi to herald Sq subway (take LI RR 34th st exit); Train D or N no change; 0.3 mi to hotel")^^
INSERT INTO note VALUES("282","558","2.0","get subway tickets at machine w tapable CC")^^
INSERT INTO note VALUES("285","560","2.0","subway £2.70 off peak. Use contactless CC at ticket machine.")^^
INSERT INTO note VALUES("287","560","4.0","Eurostar arrives track 1 or 2,ICE depart track 9")^^
INSERT INTO note VALUES("288","561","2.0","From ZOB bus 3 (Bäckerholz) to Lindau 2:45-2:56")^^
INSERT INTO note VALUES("289","562","2.0","to ZOB 1C Bus 1 (Kohlbruck/Erlebnisbad, Passau) 11:29-11:54 ")^^
INSERT INTO note VALUES("290","562","3.0","to ZOB 1D Bus 3 (Achleiten, Passau) 11:43-11:55")^^
INSERT INTO note VALUES("291","562","4.0","to HBF bus 6103 (Hauptbahnhof, ) 12:35-12:48")^^
INSERT INTO note VALUES("292","562","5.0","to Reisebüro Niedermayer (close to HBF) Bus 7599 (Reisebüro Niedermayer ) 12:38-12:50")^^
INSERT INTO note VALUES("293","562","6.0","to HBF bus 6101 (Hauptbahnhof,) 12:52-13:08")^^
INSERT INTO note VALUES("296","338","1.0","jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj")^^




CREATE TABLE `notes` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `condo` mediumint DEFAULT NULL,
  `who` char(1) DEFAULT NULL,
  `positive` mediumtext,
  `negative` mediumtext,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb3^^

INSERT INTO notes VALUES("1","1","P","big brhj hjjj KJ hhhhh
Hhhhh","little hgf more and")^^
INSERT INTO notes VALUES("2","2","P","notes 2 gone","2neg kikl")^^
INSERT INTO notes VALUES("13","1","J","No pos","All neg")^^
INSERT INTO notes VALUES("14","2","J",NULL,"Mkt 54 days")^^
INSERT INTO notes VALUES("25","15","P",NULL,"No tub?")^^
INSERT INTO notes VALUES("26","15","J",NULL,NULL)^^
INSERT INTO notes VALUES("27","16","P",NULL,NULL)^^
INSERT INTO notes VALUES("28","16","J",NULL,NULL)^^
INSERT INTO notes VALUES("29","17","P",NULL,NULL)^^
INSERT INTO notes VALUES("30","17","J",NULL,NULL)^^
INSERT INTO notes VALUES("33","19","P",NULL,NULL)^^
INSERT INTO notes VALUES("34","19","J",NULL,NULL)^^
INSERT INTO notes VALUES("35","20","P",NULL,NULL)^^
INSERT INTO notes VALUES("36","20","J",NULL,NULL)^^
INSERT INTO notes VALUES("37","21","P",NULL,NULL)^^
INSERT INTO notes VALUES("38","21","J",NULL,NULL)^^
INSERT INTO notes VALUES("39","22","P",NULL,NULL)^^
INSERT INTO notes VALUES("40","22","J",NULL,NULL)^^
INSERT INTO notes VALUES("43","24","P",NULL,NULL)^^
INSERT INTO notes VALUES("44","24","J",NULL,NULL)^^




CREATE TABLE `pmt` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `mort` mediumint DEFAULT NULL,
  `type` char(1) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `rate` decimal(5,2) DEFAULT NULL,
  `amt` decimal(8,2) DEFAULT NULL,
  `note` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=585 DEFAULT CHARSET=utf8mb3^^

INSERT INTO pmt VALUES("28","1","M","2014-10-23","3.00","767.25","oct")^^
INSERT INTO pmt VALUES("29","1","M","2014-09-24","3.00","767.25","1st")^^
INSERT INTO pmt VALUES("196","3","P","2013-05-06","3.50","250.55","May")^^
INSERT INTO pmt VALUES("197","3","P","2013-04-16","3.50","258.99","Apr")^^
INSERT INTO pmt VALUES("198","3","P","2013-02-25","3.50","233.94","MAR")^^
INSERT INTO pmt VALUES("199","3","P","2013-02-04","3.50","518.00","Jan & Feb")^^
INSERT INTO pmt VALUES("200","3","P","2013-02-04","3.50","18.00","date not exact")^^
INSERT INTO pmt VALUES("201","3","P","2012-12-25","3.50","5000.00","CHRISTMAS")^^
INSERT INTO pmt VALUES("202","3","P","2012-12-03","3.50","259.00","Dec")^^
INSERT INTO pmt VALUES("203","3","P","2012-11-05","3.50","259.00","DEC")^^
INSERT INTO pmt VALUES("204","3","P","2012-10-12","3.50","250.64","OCT")^^
INSERT INTO pmt VALUES("205","3","P","2012-09-23","3.50","210.40","SEPT")^^
INSERT INTO pmt VALUES("206","3","P","2012-08-12","3.50","2000.00","KITCHEN")^^
INSERT INTO pmt VALUES("207","3","P","2012-08-10","3.50","572.62","2 months")^^
INSERT INTO pmt VALUES("208","3","P","2012-06-07","3.50","299.93",NULL)^^
INSERT INTO pmt VALUES("209","3","P","2012-05-21","3.50","293.64",NULL)^^
INSERT INTO pmt VALUES("210","3","P","2012-04-10","3.50","303.43",NULL)^^
INSERT INTO pmt VALUES("211","3","P","2012-03-22","3.50","283.86","March")^^
INSERT INTO pmt VALUES("212","3","P","2012-02-10","3.50","156.61",NULL)^^
INSERT INTO pmt VALUES("213","3","P","2012-01-20","3.50","523.66",NULL)^^
INSERT INTO pmt VALUES("214","3","P","2011-12-08","3.50","367.06","dec")^^
INSERT INTO pmt VALUES("215","3","P","2011-11-22","3.50","379.29",NULL)^^
INSERT INTO pmt VALUES("216","3","P","2011-10-06","3.50","367.05",NULL)^^
INSERT INTO pmt VALUES("217","3","P","2011-09-16","3.50","379.29","Sept")^^
INSERT INTO pmt VALUES("218","3","P","2011-08-27","3.50","379.29",NULL)^^
INSERT INTO pmt VALUES("219","3","P","2011-06-30","3.50","1113.40","?")^^
INSERT INTO pmt VALUES("220","3","P","2011-04-18","3.50","379.29",NULL)^^
INSERT INTO pmt VALUES("221","3","P","2011-03-10","3.50","433.17","March")^^
INSERT INTO pmt VALUES("222","3","P","2011-02-16","3.50","479.59","Feb")^^
INSERT INTO pmt VALUES("223","3","P","2011-01-11","3.50","479.59","Jan")^^
INSERT INTO pmt VALUES("224","3","P","2010-12-06","3.50","464.12","Dec")^^
INSERT INTO pmt VALUES("225","3","P","2010-11-08","3.50","479.59","Nov")^^
INSERT INTO pmt VALUES("226","3","P","2010-10-08","3.50","464.12","Oct")^^
INSERT INTO pmt VALUES("227","3","P","2010-09-02","3.50","479.59","Sept")^^
INSERT INTO pmt VALUES("228","3","P","2010-08-06","3.50","273.52",NULL)^^
INSERT INTO pmt VALUES("229","3","P","2010-07-25","3.50","654.72","?")^^
INSERT INTO pmt VALUES("230","3","P","2010-06-08","3.50","1600.00","REPAYMENT")^^
INSERT INTO pmt VALUES("231","3","P","2010-05-20","3.50","1500.00","REPAYMENT")^^
INSERT INTO pmt VALUES("232","3","L","2010-04-20","3.50","24000.00","3RD DISBURSEMENT")^^
INSERT INTO pmt VALUES("233","3","L","2010-04-14","3.50","6000.00","2ND DISBURSEMENT")^^
INSERT INTO pmt VALUES("234","3","L","2010-04-06","3.50","62500.00","1ST DISBURSEMENT")^^
INSERT INTO pmt VALUES("237","3","P","2013-07-01","3.50","258.99","JUNE")^^
INSERT INTO pmt VALUES("238","3","P","2013-09-04","3.50","768.63","JUL, AUG,SEP")^^
INSERT INTO pmt VALUES("239","3","P","2013-10-24","3.50","509.64","OCT, NOV")^^
INSERT INTO pmt VALUES("240","3","P","2014-01-23","3.50","246.20","EVOUCHER REDEMPTION")^^
INSERT INTO pmt VALUES("241","3","P","2014-01-03","3.50","94.54","JAN")^^
INSERT INTO pmt VALUES("242","3","P","2014-02-24","3.50","259.00","FEB")^^
INSERT INTO pmt VALUES("243","3","P","2014-04-04","3.50","492.93","MAR, APR")^^
INSERT INTO pmt VALUES("244","3","P","2014-05-27","3.50","492.93","MAY, JUNE")^^
INSERT INTO pmt VALUES("245","3","P","2014-04-20","3.50","95.20","E-VOUCHER  REDEMPTION")^^
INSERT INTO pmt VALUES("246","3","P","2014-07-10","3.50","372.10","E-VOUCHER REDEMPTION")^^
INSERT INTO pmt VALUES("247","3","P","2014-07-11","3.50","760.28","JUL, AUG")^^
INSERT INTO pmt VALUES("248","3","P","2013-12-25","3.50","5000.00","CHRISTMAS")^^
INSERT INTO pmt VALUES("249","3","P","2014-10-04","3.50","768.63","SEP, OCT")^^
INSERT INTO pmt VALUES("280","1","M","2014-11-23","3.00","767.25","nov")^^
INSERT INTO pmt VALUES("281","3","P","2014-12-04","3.50","509.64","?")^^
INSERT INTO pmt VALUES("282","1","M","2014-12-23","3.00","767.25","dec")^^
INSERT INTO pmt VALUES("283","2","M","2015-01-07","4.00","600.00","first pmt")^^
INSERT INTO pmt VALUES("284","1","M","2015-01-23","3.00","767.25","jan")^^
INSERT INTO pmt VALUES("285","1","M","2015-02-21","3.00","767.25","feb")^^
INSERT INTO pmt VALUES("286","2","M","2015-02-05","4.00","600.00","Feb")^^
INSERT INTO pmt VALUES("287","2","M","2015-03-09","4.00","600.00","Mar")^^
INSERT INTO pmt VALUES("289","3","P","2015-02-18","3.50","750.00","Jan, Feb?")^^
INSERT INTO pmt VALUES("290","1","M","2015-03-20","3.00","767.25","mar")^^
INSERT INTO pmt VALUES("291","2","M","2015-04-07","4.00","600.00","Apr")^^
INSERT INTO pmt VALUES("292","1","M","2015-04-22","3.00","767.25","apr")^^
INSERT INTO pmt VALUES("293","3","P","2015-05-07","3.50","750.00","mar, apr?")^^
INSERT INTO pmt VALUES("295","1","M","2015-05-20","3.00","767.25","may, last")^^
INSERT INTO pmt VALUES("296","2","M","2015-05-10","4.00","600.00","May")^^
INSERT INTO pmt VALUES("297","3","P","2015-05-15","3.50","10000.00","Inca bonus")^^
INSERT INTO pmt VALUES("298","4","M","2015-06-22","3.00","1387.58","1st pmt on new loan")^^
INSERT INTO pmt VALUES("299","2","M","2015-06-05","4.00","600.00","June (chk included 244 for RE ")^^
INSERT INTO pmt VALUES("300","4","M","2015-07-20","3.00","1387.58","July")^^
INSERT INTO pmt VALUES("301","4","M","2015-08-21","3.00","1387.58","Aug")^^
INSERT INTO pmt VALUES("302","2","M","2015-07-01","4.00","600.00","July; crd by Merc 7/21")^^
INSERT INTO pmt VALUES("303","2","M","2015-08-28","4.00","600.00","Sept, US mail")^^
INSERT INTO pmt VALUES("304","2","M","2015-08-01","4.00","600.00","aug mail")^^
INSERT INTO pmt VALUES("305","4","M","2015-09-18","3.00","1387.58","Sept")^^
INSERT INTO pmt VALUES("306","2","M","2015-10-03","4.00","600.00","Oct")^^
INSERT INTO pmt VALUES("307","3","P","2015-09-22","3.50","67000.00","Pay pff")^^
INSERT INTO pmt VALUES("308","4","M","2015-10-21","3.00","1387.58","Oct")^^
INSERT INTO pmt VALUES("309","4","M","2015-11-18","3.00","1387.58","nov")^^
INSERT INTO pmt VALUES("310","2","M","2015-11-18","4.00","600.00","nov")^^
INSERT INTO pmt VALUES("313","2","M","2015-12-19","4.00","600.00","Dec; deposited electronically to Fido")^^
INSERT INTO pmt VALUES("314","4","M","2015-12-23","3.00","1387.58","dec")^^
INSERT INTO pmt VALUES("315","4","M","2016-01-19","3.00","1387.58","jan")^^
INSERT INTO pmt VALUES("316","2","M","2016-01-06","4.00","1200.00","Jan, Feb")^^
INSERT INTO pmt VALUES("317","4","M","2016-02-23","3.00","1387.58","Feb")^^
INSERT INTO pmt VALUES("318","2","M","2016-03-15","4.00","625.00","Mar, 25 for late")^^
INSERT INTO pmt VALUES("319","4","M","2016-03-23","3.00","1387.58","mar")^^
INSERT INTO pmt VALUES("320","4","M","2016-04-18","3.00","1387.58","apr")^^
INSERT INTO pmt VALUES("321","4","M","2016-05-18","3.00","1387.58","May")^^
INSERT INTO pmt VALUES("322","2","M","2016-04-15","4.00","600.00","apr")^^
INSERT INTO pmt VALUES("323","2","M","2016-05-15","4.00","600.00","may")^^
INSERT INTO pmt VALUES("324","2","M","2016-06-15","4.00","600.00","june")^^
INSERT INTO pmt VALUES("325","4","M","2016-06-23","3.00","1387.58","june")^^
INSERT INTO pmt VALUES("326","2","M","2016-07-15","4.00","600.00","July")^^
INSERT INTO pmt VALUES("327","4","M","2016-07-20","3.00","1387.58","July")^^
INSERT INTO pmt VALUES("328","2","M","2016-08-16","4.00","600.00","Aug")^^
INSERT INTO pmt VALUES("329","4","M","2016-08-20","3.00","1387.58","Aug")^^
INSERT INTO pmt VALUES("330","2","M","2016-09-15","4.00","600.00","sep")^^
INSERT INTO pmt VALUES("331","4","M","2016-09-19","3.00","1387.58","sep")^^
INSERT INTO pmt VALUES("332","2","M","2016-10-16","4.00","600.00","less 130 RE tax penalty + fee")^^
INSERT INTO pmt VALUES("333","4","M","2016-10-20","3.00","1387.58","oct")^^
INSERT INTO pmt VALUES("334","2","M","2016-11-16","4.00","600.00","Nov")^^
INSERT INTO pmt VALUES("335","4","M","2016-11-21","3.00","1387.58","Nov")^^
INSERT INTO pmt VALUES("336","2","M","2016-12-17","4.00","600.00","Dec")^^
INSERT INTO pmt VALUES("337","4","M","2016-12-22","3.00","1387.58","Dec")^^
INSERT INTO pmt VALUES("338","2","M","2017-01-16","4.00","600.00","Jan")^^
INSERT INTO pmt VALUES("339","4","M","2017-01-22","3.00","1387.58","Jan")^^
INSERT INTO pmt VALUES("340","2","M","2017-02-14","4.00","600.00","Feb")^^
INSERT INTO pmt VALUES("341","4","M","2017-02-24","3.00","1387.58","Feb")^^
INSERT INTO pmt VALUES("342","0","M","2017-03-10",NULL,"767.25",NULL)^^
INSERT INTO pmt VALUES("344","2","M","2017-03-19","4.00","600.00","mar")^^
INSERT INTO pmt VALUES("345","4","M","2017-03-23","3.00","1387.58","Mar")^^
INSERT INTO pmt VALUES("346","2","M","2017-04-17","4.00","600.00","Apr")^^
INSERT INTO pmt VALUES("348","4","M","2017-04-20","3.00","1387.58","Apr")^^
INSERT INTO pmt VALUES("349","4","M","2017-05-23","3.00","1387.58","May")^^
INSERT INTO pmt VALUES("350","2","M","2017-06-20","4.00","600.00","June, cash")^^
INSERT INTO pmt VALUES("352","2","M","2017-05-15","4.00","600.00","May")^^
INSERT INTO pmt VALUES("353","4","M","2017-06-22","3.00","1387.58","June")^^
INSERT INTO pmt VALUES("354","4","M","2017-07-21","3.00","1387.58","July")^^
INSERT INTO pmt VALUES("355","2","M","2017-07-21","4.00","600.00","July, plus 25$ late fee")^^
INSERT INTO pmt VALUES("356","2","M","2017-08-17","4.00","620.00","Aug: 600 check, + 20 bill")^^
INSERT INTO pmt VALUES("357","4","M","2017-08-23","3.00","1387.58","aug")^^
INSERT INTO pmt VALUES("358","2","M","2017-09-18","4.00","597.00","sept")^^
INSERT INTO pmt VALUES("359","4","M","2017-09-20","3.00","1387.58","Sept")^^
INSERT INTO pmt VALUES("360","2","M","2017-10-17","4.00","600.00","Oct")^^
INSERT INTO pmt VALUES("361","4","M","2017-10-22","3.00","1387.58","Oct")^^
INSERT INTO pmt VALUES("362","2","M","2017-11-15","4.00","600.00","Nov")^^
INSERT INTO pmt VALUES("363","4","M","2017-11-23","3.00","1387.58","Nov")^^
INSERT INTO pmt VALUES("364","2","M","2017-12-16","4.00","600.00","Dec")^^
INSERT INTO pmt VALUES("365","4","M","2017-12-20","3.00","1387.58","Dec")^^
INSERT INTO pmt VALUES("366","4","M","2018-01-23","3.00","1387.58","jan")^^
INSERT INTO pmt VALUES("367","2","M","2018-01-15","4.00","600.00","Jan")^^
INSERT INTO pmt VALUES("369","2","M","2018-02-16","4.00","600.00","Feb")^^
INSERT INTO pmt VALUES("370","4","M","2018-02-22","3.00","1387.58","feb")^^
INSERT INTO pmt VALUES("371","4","M","2018-03-22","3.00","1387.58","March")^^
INSERT INTO pmt VALUES("372","2","M","2018-03-15","4.00","600.00","Mar")^^
INSERT INTO pmt VALUES("373","2","M","2018-04-16","4.00","600.00","Apr")^^
INSERT INTO pmt VALUES("374","4","M","2018-04-23","3.00","1387.58","apr")^^
INSERT INTO pmt VALUES("375","2","M","2018-05-16","4.00","600.00","May")^^
INSERT INTO pmt VALUES("376","4","M","2018-05-22","3.00","1387.58","May")^^
INSERT INTO pmt VALUES("379","4","M","2018-06-20","3.00","1387.58","June")^^
INSERT INTO pmt VALUES("380","2","M","2018-06-02","4.00","117701.12","Payoff")^^
INSERT INTO pmt VALUES("381","4","M","2018-07-23","3.00","1387.58","July")^^
INSERT INTO pmt VALUES("382","4","M","2018-08-22","3.00","1387.58","Aug")^^
INSERT INTO pmt VALUES("383","4","M","2018-09-21","3.00","1387.58","Sept")^^
INSERT INTO pmt VALUES("384","4","M","2018-10-22","3.00","1387.58","Oct")^^
INSERT INTO pmt VALUES("385","4","M","2018-11-21","3.00","1387.58","Nov")^^
INSERT INTO pmt VALUES("386","4","M","2018-12-20","3.00","1387.58","Dec")^^
INSERT INTO pmt VALUES("387","4","M","2019-01-21","3.00","1387.58","Jan")^^
INSERT INTO pmt VALUES("388","4","M","2019-02-19","3.00","1387.58","feb")^^
INSERT INTO pmt VALUES("389","4","M","2019-03-20","3.00","1387.58","Mar")^^
INSERT INTO pmt VALUES("390","4","M","2019-04-22","3.00","1387.58","apr")^^
INSERT INTO pmt VALUES("391","4","M","2019-05-22","3.00","1387.58","May")^^
INSERT INTO pmt VALUES("392","4","M","2019-06-20","3.00","1387.58","June")^^
INSERT INTO pmt VALUES("393","4","M","2019-07-20","3.00","1387.58","jul")^^
INSERT INTO pmt VALUES("394","4","M","2019-08-21","3.00","1387.58","Aug")^^
INSERT INTO pmt VALUES("395","4","M","2019-09-21","3.00","1387.58","Sep")^^
INSERT INTO pmt VALUES("396","4","M","2019-10-22","3.00","1387.58","oct")^^
INSERT INTO pmt VALUES("397","4","M","2019-11-20","3.00","1387.58","nov")^^
INSERT INTO pmt VALUES("398","4","M","2019-12-20","3.00","1387.58","dec")^^
INSERT INTO pmt VALUES("399","4","M","2020-01-23","3.00","1387.58","jan 20")^^
INSERT INTO pmt VALUES("400","4","M","2020-02-22","3.00","1387.58","feb")^^
INSERT INTO pmt VALUES("401","4","M","2020-03-20","3.00","1387.58","Mar")^^
INSERT INTO pmt VALUES("402","4","M","2020-04-22","3.00","1387.58","Apr")^^
INSERT INTO pmt VALUES("403","4","M","2020-05-20","3.00","1387.58","May")^^
INSERT INTO pmt VALUES("405","4","M","2020-06-22","3.00","1387.58","Jun")^^
INSERT INTO pmt VALUES("412","7","L","2020-07-10","2.50","40000.00","via wire transfer from Fido")^^
INSERT INTO pmt VALUES("417","4","M","2020-07-22","2.50","1387.58","July, 1st pmt at 2.5%")^^
INSERT INTO pmt VALUES("418","7","L","2020-08-13","2.50","50000.00","via fido bill pay")^^
INSERT INTO pmt VALUES("419","4","M","2020-08-20","2.50","1387.58","Aug")^^
INSERT INTO pmt VALUES("420","7","L","2020-08-31","2.50","50000.00","from Fido bill pay")^^
INSERT INTO pmt VALUES("421","4","M","2020-09-21","2.50","1387.58","sept")^^
INSERT INTO pmt VALUES("422","7","L","2020-10-16","2.50","50000.00","via Fido Bill pay")^^
INSERT INTO pmt VALUES("423","4","M","2020-10-21","2.50","1387.58","Oct")^^
INSERT INTO pmt VALUES("426","4","M","2020-11-20","2.50","1387.58","nov")^^
INSERT INTO pmt VALUES("427","4","M","2020-12-22","2.50","1387.58","dec")^^
INSERT INTO pmt VALUES("428","4","M","2021-01-22","2.50","1387.58","Jan 21")^^
INSERT INTO pmt VALUES("429","4","M","2021-02-22","2.50","1387.58","Feb")^^
INSERT INTO pmt VALUES("430","4","M","2021-03-22","2.50","1387.58","Mar")^^
INSERT INTO pmt VALUES("431","4","M","2021-04-21","2.50","1387.58","Apr")^^
INSERT INTO pmt VALUES("433","7","P","2021-05-11","2.50","190000.00",NULL)^^
INSERT INTO pmt VALUES("434","4","M","2021-05-22","2.50","1387.58","May")^^
INSERT INTO pmt VALUES("435","4","M","2021-06-22","2.50","1387.58","June")^^
INSERT INTO pmt VALUES("436","8","M","2021-06-30","2.50","600.00","1st pmt, 1st deposit")^^
INSERT INTO pmt VALUES("437","8","M","2021-07-02","2.50","666.90","1st pmt, 2nd deposit")^^
INSERT INTO pmt VALUES("438","4","M","2021-07-21","2.50","1387.58","July")^^
INSERT INTO pmt VALUES("439","8","M","2021-08-04","2.50","1266.90","Aug")^^
INSERT INTO pmt VALUES("445","3","I","2010-04-05","3.50","3.50","inital rate")^^
INSERT INTO pmt VALUES("446","4","M","2021-08-20","2.50","1387.58","Aug")^^
INSERT INTO pmt VALUES("447","8","M","2021-09-03","2.50","1266.90","Sep")^^
INSERT INTO pmt VALUES("448","4","M","2021-09-22","2.50","1387.58","Sep")^^
INSERT INTO pmt VALUES("449","8","M","2021-10-05","2.50","1266.90","Oct")^^
INSERT INTO pmt VALUES("450","4","M","2021-10-28","2.50","1000.00","Oct 1st part")^^
INSERT INTO pmt VALUES("451","4","M","2021-11-01","2.50","387.58","Oct 2nd Part")^^
INSERT INTO pmt VALUES("452","8","M","2021-11-03","2.50","1266.90","Nov")^^
INSERT INTO pmt VALUES("453","4","M","2021-11-15","2.50","1387.58","Nov dep to Fido")^^
INSERT INTO pmt VALUES("454","8","M","2021-12-03","2.50","1266.90","Dec")^^
INSERT INTO pmt VALUES("456","4","M","2021-12-24","2.50","1000.00","Dec 1st dep to Merc")^^
INSERT INTO pmt VALUES("457","4","M","2021-12-27","2.50","387.58","Dec 2nd dep to Merc")^^
INSERT INTO pmt VALUES("458","8","M","2022-01-06","2.50","1266.90","jan")^^
INSERT INTO pmt VALUES("459","4","M","2022-01-20","2.50","1387.58","Jan (2 payments: 1000 + 387.58)")^^
INSERT INTO pmt VALUES("460","8","M","2022-02-03","2.50","1266.90","Feb")^^
INSERT INTO pmt VALUES("461","4","M","2022-02-18","2.50","1000.00","Feb (1)")^^
INSERT INTO pmt VALUES("462","4","M","2022-02-22","2.50","387.58","fEB (2)")^^
INSERT INTO pmt VALUES("463","8","M","2022-03-05","2.50","1266.90","Mar")^^
INSERT INTO pmt VALUES("464","4","M","2022-03-23","2.50","1387.58","Mar - 1ST installment 3/21")^^
INSERT INTO pmt VALUES("465","8","M","2022-04-05","2.50","1266.90","Apr")^^
INSERT INTO pmt VALUES("466","8","M","2022-05-04","2.50","1266.90","May")^^
INSERT INTO pmt VALUES("467","4","M","2022-04-20","2.50","1387.58","Apr, 2 deposits")^^
INSERT INTO pmt VALUES("469","4","M","2022-05-18","2.50","1387.58","387.50 followed May 19")^^
INSERT INTO pmt VALUES("470","8","M","2022-06-03","2.50","1266.90","June")^^
INSERT INTO pmt VALUES("472","4","M","2022-06-22","2.50","1387.58","June")^^
INSERT INTO pmt VALUES("473","4","P","2022-06-27","2.50","1236.99","check from CD")^^
INSERT INTO pmt VALUES("523","32","I","2021-08-23","2.50","2.50","Initial interest rate")^^
INSERT INTO pmt VALUES("546","8","M","2022-07-06","3.50","1266.90","July, new rate")^^
INSERT INTO pmt VALUES("547","8","I","2021-06-29","2.50","2.50","initial interest rate")^^
INSERT INTO pmt VALUES("549","8","I","2022-07-01","3.50","3.50","rate change as of July 1")^^
INSERT INTO pmt VALUES("552","4","I","2015-05-22","3.00","3.00","initial interest rate")^^
INSERT INTO pmt VALUES("553","4","I","2020-06-29","2.50","2.50","rate change as 6/29/20")^^
INSERT INTO pmt VALUES("554","4","I","2022-07-01","3.50","3.50","rate change as of July 1")^^
INSERT INTO pmt VALUES("557","32","I","2022-07-01","3.00","3.00","rate change as of July 1")^^
INSERT INTO pmt VALUES("560","4","M","2022-07-20","3.50","1443.04","July, 1st pmt at 3.5,")^^
INSERT INTO pmt VALUES("561","8","M","2022-08-03","3.50","1266.90","Aug")^^
INSERT INTO pmt VALUES("564","4","M","2022-08-18","3.50","1443.04","Aug")^^
INSERT INTO pmt VALUES("565","8","M","2022-09-06","3.50","1266.90","Sep")^^
INSERT INTO pmt VALUES("566","4","M","2022-09-21","3.50","1443.04","Sep")^^
INSERT INTO pmt VALUES("567","8","M","2022-10-05","3.50","1266.90","Oct")^^
INSERT INTO pmt VALUES("568","4","M","2022-10-20","3.50","1443.04","Oct")^^
INSERT INTO pmt VALUES("569","8","M","2022-11-03","3.50","1266.90","Nov")^^
INSERT INTO pmt VALUES("570","4","M","2022-11-18","3.50","1443.04","Nov")^^
INSERT INTO pmt VALUES("571","4","M","2022-12-20","3.50","1443.04","Dec")^^
INSERT INTO pmt VALUES("572","4","M","2023-01-19","3.50","1443.04","Jan 23")^^
INSERT INTO pmt VALUES("576","8","M","2022-11-15","3.50","175234.63","Paid off")^^
INSERT INTO pmt VALUES("579","33","I","2023-01-21","3.50","3.50","initial interest rate")^^
INSERT INTO pmt VALUES("581","4","M","2023-02-21","3.50","1443.04","feb")^^
INSERT INTO pmt VALUES("582","33","M","2023-03-03","3.50","1122.61","Mar - 1ST installment ")^^
INSERT INTO pmt VALUES("583","4","M","2023-03-21","3.50","1443.04","Mar")^^
INSERT INTO pmt VALUES("584","33","M","2023-03-22","3.50","1122.61","2nd Mar pmt")^^




CREATE TABLE `service` (
  `service` int NOT NULL AUTO_INCREMENT,
  `trip` int DEFAULT NULL,
  `sort` decimal(5,1) DEFAULT NULL,
  `caption` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`service`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1^^

INSERT INTO service VALUES("44","55","4.0","NY hotels")^^
INSERT INTO service VALUES("41","66","1.0","munich hotels")^^
INSERT INTO service VALUES("42","66","2.0","Landshut hotels")^^
INSERT INTO service VALUES("43","66","3.0","Munich bike rentals")^^




CREATE TABLE `setup` (
  `Id` int DEFAULT NULL,
  `user` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `email` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `locPassword` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `password` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `trip` int DEFAULT NULL,
  `overview` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `type` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `alt` tinyint DEFAULT NULL,
  UNIQUE KEY `Id` (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci^^

INSERT INTO setup VALUES("1","jack","marlinpg1@gmail.com","jack","5tlqxh0$OAobHW","29","gap.jpg","M","1")^^




CREATE TABLE `svcdetail` (
  `hrs` varchar(30) DEFAULT '?',
  `svcdetail` int NOT NULL AUTO_INCREMENT,
  `service` int DEFAULT NULL,
  `sort` decimal(5,2) DEFAULT NULL,
  `town` int DEFAULT NULL COMMENT 'FK to town',
  `name` varchar(100) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `addr` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT '.',
  `type` char(2) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `comment` varchar(100) DEFAULT '.',
  PRIMARY KEY (`svcdetail`)
) ENGINE=MyISAM AUTO_INCREMENT=406 DEFAULT CHARSET=latin1^^

INSERT INTO svcdetail VALUES(NULL,"401","44","59.00","311","Hampton Inn Madison Square Garden Area H",NULL,"L",NULL,"$135 nR brkft, hotel.com")^^
INSERT INTO svcdetail VALUES(NULL,"400","44","58.00","311","Hampton Inn Manhattan/Times Square South",NULL,"L",NULL,"$95 nRf hotel.com")^^
INSERT INTO svcdetail VALUES(NULL,"384","41","42.00","332","LetoMotel Munchen City Nord","short Ubahn from sbahn","R","https://www.letomotel.com/l03/en/motelinfo","$64 double, $54 single, adv pmt, can cancel, AC")^^
INSERT INTO svcdetail VALUES("Centerroom Zwilling REV","385","41","43.00","332","SKIP","amaro LOC,Empress LOC, Perlach REV","L","Mercure aufkirken LOC,Deutsches Theater AC, bockmaier LOC","Vadi ac, Köberl wc, Rivol AC, Novum Seidlhof loc, Novum BHF AC")^^
INSERT INTO svcdetail VALUES(NULL,"386","41","44.00","332","Bavaria Motel","close to s8, 21 min to HB","L",NULL,"$80 double bed + single")^^
INSERT INTO svcdetail VALUES(NULL,"387","41","45.00","332","GHOTEL hotel & living München-City","900 m from hbf","L",NULL,"$94 1db, 2 twin")^^
INSERT INTO svcdetail VALUES(NULL,"388","41","46.00","332","SKIP","Fresh LOC, NH Sud LOC, GHOTEL AC","L",NULL,NULL)^^
INSERT INTO svcdetail VALUES(NULL,"389","41","47.00","332","Golden Tulip Olymp","Eching, 0.7 mi from SB 28 min from airpo","L",NULL,"$103 for apt 1Q 1D sofa")^^
INSERT INTO svcdetail VALUES("?","390","41","48.00",NULL,NULL,".",NULL,NULL,".")^^
INSERT INTO svcdetail VALUES(NULL,"391","41","49.00","332","Alfa City Centre",NULL,"L",NULL,"near HBF")^^
INSERT INTO svcdetail VALUES(NULL,"392","42","50.00","334","SKIP Neumaier min,",NULL,"L",NULL,NULL)^^
INSERT INTO svcdetail VALUES(NULL,"393","43","51.00","0","Mikes bike tours",NULL,"S","https://www.mikesbiketours.com/munich/bike-rentals/mikes-bike-rentals-muenchen-fahrradverleih.html",NULL)^^
INSERT INTO svcdetail VALUES(NULL,"394","43","52.00","332","Mikes bike tours",NULL,"S","https://www.mikesbiketours.com/munich/bike-rentals/mikes-bike-rentals-muenchen-fahrradverleih.html",NULL)^^
INSERT INTO svcdetail VALUES("10-8","395","43","53.00","332","Munich Bike Rental","Heiliggeiststr. 1 (ice cream shop)","S","https://www.munichbikerental.com/","info@munichbikerental.com, E16 / day")^^
INSERT INTO svcdetail VALUES("9:30 to 18:00, closed Thursday","396","43","54.00","332","Die Pedalhelden","Marsstr. 11","S","https://pedalhelden.de/fahrradverleih/","E15 4 hours")^^
INSERT INTO svcdetail VALUES(NULL,"397","43","55.00","332","BIKEBRINGER","Schachnerstraße 4","S","info@bikebringer.de  ","E18 / 24 hr incl pickup")^^
INSERT INTO svcdetail VALUES(NULL,"398","43","56.00","332","Call a Bike (DB)",NULL,"S","https://www.callabike-interaktiv.de/en/cities/muenchen",NULL)^^
INSERT INTO svcdetail VALUES("8:30 am - 8 pm","399","43","57.00","332","Radius Tours & Bike Rental","HBF","S","https://www.radiustours.com/en/bike-rental/information-and-prices.html","E4/hr max E16 til close")^^
INSERT INTO svcdetail VALUES(NULL,"402","44","60.00","311","DoubleTree - Times Square South",NULL,"L",NULL,"$107 nR hotel.com")^^
INSERT INTO svcdetail VALUES(NULL,"403","44","61.00","311","DoubleTree - Chelsea",NULL,"L",NULL,"$127 nR, closer than TS location")^^
INSERT INTO svcdetail VALUES(NULL,"404","44","62.00","311","Holiday Inn - Times Square",NULL,"L",NULL,"$120 nR")^^
INSERT INTO svcdetail VALUES(NULL,"405","44","63.00","311","Holiday Inn Express","like","L",NULL,"$111 nR bkfst")^^




CREATE TABLE `tip` (
  `tip` int NOT NULL AUTO_INCREMENT,
  `trip` int DEFAULT NULL,
  `tiptext` longtext,
  `sort` decimal(6,2) DEFAULT NULL,
  PRIMARY KEY (`tip`)
) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=latin1^^

INSERT INTO tip VALUES("102","70","2nd Cambridge airbnb installment of $92.77 due may 5","3.00")^^
INSERT INTO tip VALUES("104","29","Cuyahoga Valley<br>
LSL arr CLV 5:38 AM<br>
Amtrak station to CSVRR rockside station 12.2 mi<br>
CSVRR dep rockside 9:00AM, 1:00PM; sat only 5:00PM<br>
Courtyard by Marriott Akron Downtown $132<br>
bike south to Barberton 10 mi one way<br>
Marriot<br>
Marriot to motel I271 & OH 8 20.8 mi<br>
motel to amtrak CLV 23.5 mi<br>
LSL dep 3:45AM, CL dep 2:59AM","2.00")^^
INSERT INTO tip VALUES("105","29",NULL,"3.00")^^
INSERT INTO tip VALUES("101","70","Verizon pay-as-you-go plan incl UK, Netherlands, & Germany:talk $1.79/min, send text $0.50, receive text $0.05, data $2.05/MB","2.00")^^
INSERT INTO tip VALUES("100","70","call Cunard (800) 728 6273 re<br>
early disembarkation with luggage: YES, ON BOARD<br>
motor coach group transfer to RR: NO ONLY TO VIC, need conf# to book <br>
distance to station: ?","1.00")^^
INSERT INTO tip VALUES("103","29","bustang:<br>
  SWC La Junta arr from SF: 7:31PM
  La Junta senior center - CS park & ride: 8:38 AM - 1:32PM
  CS - Den US: 5:10 PM - 7:25PM
  Den US - CS: 11:15AM - 1:35PM (weekday only) 
  CS - La Junta: 2:11 pM - 5:27PM
  SWC dep La Junta: 8:30AM","1.00")^^
INSERT INTO tip VALUES("97","57","Tom Tucker 856 Oxford Ct.<br>
punka1949@gmail.com<br>
phone: (727) 692-3997","1.00")^^
INSERT INTO tip VALUES("98","6","Bike Flachau to Werfen, train to Berlin","2.00")^^
INSERT INTO tip VALUES("99","6","Rent bikes in salzburg","1.00")^^
INSERT INTO tip VALUES("95","57","Duke Enegy 727-443-2641","3.00")^^
INSERT INTO tip VALUES("94","57","Security Title Co<br>
Receiving bank: CenterState Bank of Florida, N.A.<br>
Address: 1101 First Street South<br>
Winter Haven, Fl 33880<br>
Routing Number: 063114030<br>
Beneficiary: Acct Name: Security Title Company,<br>
  Acct No: 1100017753<br>
  Address: 791A San Christopher Dr.<br>
  City: Dunedin, Fl 34698<br>
Phone #: 727-733-0466","2.00")^^
INSERT INTO tip VALUES("77","54","check sent 6/14 to Janelle for 983.16","4.00")^^
INSERT INTO tip VALUES("75","54","Janelle & Marcia:
Cruise deposit: 500 for both, Janelle's check 11/20 $500","2.00")^^
INSERT INTO tip VALUES("76","54","booked Dorit Amsterdam approx $79; received check for $79.04 Dec 1","3.00")^^
INSERT INTO tip VALUES("87","66","To Do<br>
get pp no & exp date for airline<br>
book train tickets <br>
--> Strassburg to Munich
--> Vishofen-Regensburg
--> Regensburg-MUC 
call amawaterways (800) 626-0126.re bed type, Bratslava dep time, wachau bike tour, Salzkamergut bus & bike
email Paula and terry re tour registration<br>
Book<br>
-->Taste of Slovakia<br>
-->CurSalon?<br>
-->pochlarn-Ybb bike tour<br>
-->Grein reception<br>
-->Passau bike tour<br>
-->Octoberfest<br>
Airline checkin","1.00")^^
INSERT INTO tip VALUES("85","66","Train<br>
Vilshofen->Munich 2:00<br>
Villhofen->Regensburg dep 9:34 ICE 59 min #19,90, dep 8:41 & 10:41 1:09, E23 <br>
Regensburg->MUC 1:15 hourly E25<br>
Bavaria Ticket e43 for 4 persons","2.00")^^
INSERT INTO tip VALUES("78","54","PP #'s P 516629402 24 apr 2024, J 519212848 25 apr 2024","5.00")^^
INSERT INTO tip VALUES("80","54",'?''s for Kevin (866.755.8581): (1) bike tools, pump, water bottle (plastic bottles avail?), (2) "Electricity on board in Treasure of Galápagos is 110v. Electricity on board the Delfin III is 220v. The bathrooms have a dual 220v/110-120v plug for shavers and small appliances". (3) What is a "french balcony? (4) What PW is needed when boarding?',"1.00")^^
INSERT INTO tip VALUES("91","55","call or email La Quinta Airport shuttle 407-857-9215","1.00")^^
INSERT INTO tip VALUES("106","70",NULL,"4.00")^^
INSERT INTO tip VALUES("107","89","call AGR re BC upgrade
","1.00")^^
INSERT INTO tip VALUES("108","89","Call Paula","2.00")^^




CREATE TABLE `town` (
  `town` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `sort` decimal(10,2) DEFAULT NULL,
  `trip` int DEFAULT NULL,
  PRIMARY KEY (`town`)
) ENGINE=MyISAM AUTO_INCREMENT=344 DEFAULT CHARSET=latin1^^

INSERT INTO town VALUES("1","MILWAUKE","1.00","0")^^
INSERT INTO town VALUES("4","FLIGHT","1.00","6")^^
INSERT INTO town VALUES("231","SCHMALKALDEN ","51.00","31")^^
INSERT INTO town VALUES("7","ZELL AM ZILLER","5.00","6")^^
INSERT INTO town VALUES("14","BUCH BEI JENBACH","4.00","6")^^
INSERT INTO town VALUES("15","KARRES (NEAR IMST)","3.00","6")^^
INSERT INTO town VALUES("16","KRIML","6.00","6")^^
INSERT INTO town VALUES("17","ZELL AM SEE","8.00","6")^^
INSERT INTO town VALUES("129","WINTER HAVEN","20.00","6")^^
INSERT INTO town VALUES("19","NEUKIRCHEN AM GROSS VENEDIGER","7.00","6")^^
INSERT INTO town VALUES("20","SALZBURG","9.00","6")^^
INSERT INTO town VALUES("21","SPITTAL AN DER DRAU","10.00","6")^^
INSERT INTO town VALUES("163","ROCKWOOD","1.00","25")^^
INSERT INTO town VALUES("138","KEWANEE","23.00","6")^^
INSERT INTO town VALUES("137","CRYSTAL LAKE","22.00","6")^^
INSERT INTO town VALUES("134","RACINE, WI","21.00","6")^^
INSERT INTO town VALUES("162","CONNELSVILLE","2.00","25")^^
INSERT INTO town VALUES("84","BERLIN","16.00","6")^^
INSERT INTO town VALUES("74","HOME","11.00","6")^^
INSERT INTO town VALUES("75","PARIS","12.00","6")^^
INSERT INTO town VALUES("76","BREGENZ","2.00","6")^^
INSERT INTO town VALUES("80","OSSIACHER SEE","13.00","6")^^
INSERT INTO town VALUES("81","ROTHENTHURN","14.00","6")^^
INSERT INTO town VALUES("82","CHICAGO","15.00","6")^^
INSERT INTO town VALUES("85","WIENER NEUSTADT","17.00","6")^^
INSERT INTO town VALUES("86","UNKNOWN","18.00","6")^^
INSERT INTO town VALUES("87","FLACHAU","19.00","6")^^
INSERT INTO town VALUES("161","BOSTON","3.00","25")^^
INSERT INTO town VALUES("278","FORT PLAIN","82.00",NULL)^^
INSERT INTO town VALUES("194","BUENA VISTA","6.00","25")^^
INSERT INTO town VALUES("193","MEYERSDALE","5.00","25")^^
INSERT INTO town VALUES("192","CONFLUENCE","4.00","25")^^
INSERT INTO town VALUES("277","TRAIN","10.00","42")^^
INSERT INTO town VALUES("213","PASSAU","3.00","31")^^
INSERT INTO town VALUES("212","VARIOUS","2.00","31")^^
INSERT INTO town VALUES("211","OBERNFELD","1.00","31")^^
INSERT INTO town VALUES("214","REGENSBURG","4.00","31")^^
INSERT INTO town VALUES("230","GERSTUNGEN","50.00","31")^^
INSERT INTO town VALUES("217","SCHäRDING","5.00","31")^^
INSERT INTO town VALUES("232","HILDBURGHAUSEN","52.00","31")^^
INSERT INTO town VALUES("261","NEWARK","1.00","42")^^
INSERT INTO town VALUES("262","ELBRIDGE","2.00","42")^^
INSERT INTO town VALUES("263","CANASTOTA","3.00","42")^^
INSERT INTO town VALUES("264","UTICA","4.00","42")^^
INSERT INTO town VALUES("265","PALATINE BRIDGE","5.00","42")^^
INSERT INTO town VALUES("266","MEDINA","6.00","42")^^
INSERT INTO town VALUES("267","ROCHESTER","11.00","42")^^
INSERT INTO town VALUES("268","LYONS","7.00","42")^^
INSERT INTO town VALUES("269","CAMILLUS","8.00","42")^^
INSERT INTO town VALUES("270","PHELPS","9.00","42")^^
INSERT INTO town VALUES("279","FAYETTEVILLE","83.00",NULL)^^
INSERT INTO town VALUES("280","SPENCERPORT","83.00",NULL)^^
INSERT INTO town VALUES("281","BROCKPORT","85.00",NULL)^^
INSERT INTO town VALUES("282","CLARENCE","86.00",NULL)^^
INSERT INTO town VALUES("283","PITTSFORD","87.00",NULL)^^
INSERT INTO town VALUES("284","FAIRPORT","88.00",NULL)^^
INSERT INTO town VALUES("285","SYRACUSE","89.00",NULL)^^
INSERT INTO town VALUES("286","MOHAWK","90.00",NULL)^^
INSERT INTO town VALUES("287","ALBION","91.00",NULL)^^
INSERT INTO town VALUES("288","HOLLEY","92.00",NULL)^^
INSERT INTO town VALUES("289","PALMYRA","93.00",NULL)^^
INSERT INTO town VALUES("290","JORDAN","94.00",NULL)^^
INSERT INTO town VALUES("291","CHITTENANGO","95.00",NULL)^^
INSERT INTO town VALUES("292","SCHNECTADY","96.00",NULL)^^
INSERT INTO town VALUES("293","DEARFIELD BREACH","97.00",NULL)^^
INSERT INTO town VALUES("294","DENVER","98.00",NULL)^^
INSERT INTO town VALUES("295","HOLLYWOOD","99.00",NULL)^^
INSERT INTO town VALUES("296","DELAND","100.00",NULL)^^
INSERT INTO town VALUES("297","LAKELAND","101.00",NULL)^^
INSERT INTO town VALUES("298","WALLINGFORD, ENGLAND","102.00",NULL)^^
INSERT INTO town VALUES("299","MAINZ","103.00",NULL)^^
INSERT INTO town VALUES("300","BIKE & BARGE","104.00",NULL)^^
INSERT INTO town VALUES("301","RüDESHEIM","105.00",NULL)^^
INSERT INTO town VALUES("302","READING","106.00",NULL)^^
INSERT INTO town VALUES("303","SHIP","107.00",NULL)^^
INSERT INTO town VALUES("304","FRANKFURT","108.00",NULL)^^
INSERT INTO town VALUES("305","LONDON","109.00",NULL)^^
INSERT INTO town VALUES("306","BRUGES","110.00",NULL)^^
INSERT INTO town VALUES("307","WEST NEWTON","111.00",NULL)^^
INSERT INTO town VALUES("308","FROSTBURG","112.00",NULL)^^
INSERT INTO town VALUES("309","BRUSSELS","113.00",NULL)^^
INSERT INTO town VALUES("310","AMSTERDAM","114.00",NULL)^^
INSERT INTO town VALUES("311","NEW YORK","115.00",NULL)^^
INSERT INTO town VALUES("312","LEESBURG","116.00",NULL)^^
INSERT INTO town VALUES("313","SEBRING","117.00",NULL)^^
INSERT INTO town VALUES("314","ST. PETERSBURG","118.00",NULL)^^
INSERT INTO town VALUES("315","VIENNA","119.00",NULL)^^
INSERT INTO town VALUES("316","DAVIS","120.00",NULL)^^
INSERT INTO town VALUES("317","SAN LUIS OBISPO","121.00",NULL)^^
INSERT INTO town VALUES("318","SANTA BARBARA","122.00",NULL)^^
INSERT INTO town VALUES("319","SAN DIEGO","123.00",NULL)^^
INSERT INTO town VALUES("320","SANTA FE","124.00",NULL)^^
INSERT INTO town VALUES("321","EL PASO","125.00",NULL)^^
INSERT INTO town VALUES("322","CRUISE","126.00",NULL)^^
INSERT INTO town VALUES("323","COLOGNE","127.00",NULL)^^
INSERT INTO town VALUES("324","KALISPELL","128.00",NULL)^^
INSERT INTO town VALUES("325","KELLOGG","129.00",NULL)^^
INSERT INTO town VALUES("326","SEDALIA","130.00",NULL)^^
INSERT INTO town VALUES("327","WINDSOR","131.00",NULL)^^
INSERT INTO town VALUES("328","WINTER PARK","132.00",NULL)^^
INSERT INTO town VALUES("329","DUNEDIN","133.00",NULL)^^
INSERT INTO town VALUES("330","ORLANDO","134.00",NULL)^^
INSERT INTO town VALUES("331","WUERTZBURG","135.00",NULL)^^
INSERT INTO town VALUES("332","MUNICH","136.00",NULL)^^
INSERT INTO town VALUES("333","DUMMY","137.00",NULL)^^
INSERT INTO town VALUES("334","LANDSHUT","138.00",NULL)^^
INSERT INTO town VALUES("335","LILLE","139.00",NULL)^^
INSERT INTO town VALUES("336","KOBLENZ","140.00",NULL)^^
INSERT INTO town VALUES("337","CAMBRIDGE, UK","141.00",NULL)^^
INSERT INTO town VALUES("338","RALEIGH","142.00",NULL)^^
INSERT INTO town VALUES("339","CHARLOTTE","143.00",NULL)^^
INSERT INTO town VALUES("340","CARY","144.00",NULL)^^
INSERT INTO town VALUES("341","LONGMONT","145.00",NULL)^^
INSERT INTO town VALUES("342","BELMONT","146.00",NULL)^^
INSERT INTO town VALUES("343","ANKENY","147.00",NULL)^^




CREATE TABLE `trip` (
  `trip` int NOT NULL AUTO_INCREMENT,
  `descr` varchar(50) DEFAULT NULL,
  `startDate` date DEFAULT NULL,
  `svcFile` varchar(255) DEFAULT NULL COMMENT 'file containing htlm services list',
  `currency` char(1) DEFAULT NULL,
  `map` mediumint DEFAULT NULL,
  PRIMARY KEY (`trip`)
) ENGINE=MyISAM AUTO_INCREMENT=91 DEFAULT CHARSET=latin1^^

INSERT INTO trip VALUES("6","Austria & Berlin - Aug 2011","2011-07-31",NULL,"E",NULL)^^
INSERT INTO trip VALUES("29","Misc info","2013-11-07",NULL,"$","467")^^
INSERT INTO trip VALUES("25","Great Allegheny Passage 10/15","2015-10-02",NULL,"$",NULL)^^
INSERT INTO trip VALUES("31","Werratal + Danube July 14,2014","2014-07-20",NULL,"E",NULL)^^
INSERT INTO trip VALUES("42","Erie Canal 2015","2015-08-01",NULL,"$",NULL)^^
INSERT INTO trip VALUES("45","Florida 2016","2016-01-05",NULL,"$",NULL)^^
INSERT INTO trip VALUES("47","Europe 2016","2016-07-26",NULL,"$",NULL)^^
INSERT INTO trip VALUES("49","GAP July 2016","2016-07-06",NULL,"$",NULL)^^
INSERT INTO trip VALUES("57","Dunedin Search","2019-08-18",NULL,"$",NULL)^^
INSERT INTO trip VALUES("54","2018 European River Cruise","2018-07-30",NULL,"E",NULL)^^
INSERT INTO trip VALUES("53","WINTER 2017","2017-01-31",NULL,"$",NULL)^^
INSERT INTO trip VALUES("55","Winter 2019","2019-01-15",NULL,"$",NULL)^^
INSERT INTO trip VALUES("66","2019 Bike & Barge, Cruise","2019-06-25",NULL,"$","405")^^
INSERT INTO trip VALUES("70","2020 Atlantic Crossing + BnB","2020-05-11",NULL,"$","474")^^
INSERT INTO trip VALUES("78","Dunedin to Qcy Apr 22","2022-04-22",NULL,"$","523")^^
INSERT INTO trip VALUES("77","QCY to Dunedin Nov 21","2021-11-15",NULL,"$","522")^^
INSERT INTO trip VALUES("76","Sep 2021: Colorado,  Santa Fe, Belmont","2021-09-07",NULL,"$",NULL)^^
INSERT INTO trip VALUES("80","Iowa biking","2022-07-08",NULL,"$","530")^^
INSERT INTO trip VALUES("88","TPA-QCY 2023","2023-04-30",NULL,"$",NULL)^^
INSERT INTO trip VALUES("85","Qcy-Den-Dunedin Nov 22","2022-11-19",NULL,"$","569")^^
INSERT INTO trip VALUES("89","Transatlantic Crossing, Bike & Barge Danube","2023-07-19",NULL,"$","1538")^^



