Select * from tblOpportunities WHERE pkOpportunityID <=20

1, '', 'Contra Costa Visioning', '', 349, 3013, 1196, , '', '1/22/2001', '', 'call from prime.', '', 0, '0', 5, '', 'Lost - No Interview', '01013', 28, '', ''
2, '', 'Anchorage Transit Route Service Update', '', 135, 139, , , '', '11/1/2000', '2/23/2001', 'direct from client', '', 45000, '45000', 5, '', '6/26 - LOSER', '01014', 15, 'City of Anchorage, AK', ''
3, '', 'Treasure Island EIR', '', 260, 270, , , '', '1/22/2000', '', 'EDAW', '', 0, '0', 5, '', 'We are not sorry we lost this one, given the absurd politics around development on the island.', '01015', 28, 'City of San Francisco, CA', ''
4, '', 'San Jose Planning', '', 264, 1100, 735, , '', '', '', '', '', 2000, '2000', 5, '', '', '01016', 5, '', ''
5, '', 'San Marino Parking as Needed', '', 269, 279, , , '', '1/29/2001', '', 'call from prime', '', 0, '0', 5, '', 'quick-turnaround letter proposal if we have time to do it.', '01017', 10, '', ''
6, '', 'Presidio Trust Environmental As Need SOQ', '', 736, 761, , , '', '10/26/2000', '11/7/2000', 'call from prime', '', 0, '0', 5, '', '9-18 LOSER. Presidio Trust selected three firms for their list including EPI, Jones & Stokes, & URS. Karen Frye at TetraTech, the prime, was really surprised and has yet to get an explanation from the Trust.', '01018', 6, 'Presidio Trust, SF, CA', ''
7, '', 'Sacramento 65th Street Facility Study', '', 254, 264, 57, , '', '', '2/12/2001', '', '', 0, '9552', 5, '', '', '01019', 6, '', ''
8, '', 'Foothill Transit/Cal Poly Transit Center Study', '', 426, 440, 659, , '', '', '', '', '', 20000, '20000', 5, '', '', '01020', , '', ''
9, '', 'Reno RTP Transit Element', 'Project Add-On from 00124', 758, 784, 239, , '', '', '', '', '', 0, '0', 5, '', '', '01021', 25, '', ''
10, '', 'East Bay Senior Transportation', 'Replicate Portland, Maine, senior transportation model using volunteer drivers', 493, 505, 1102, , '', '', '2/1/2001', '', '', 7500, '7500', 5, '', '', '01022', 87, '', ''
11, '', 'San Rafael Downtown Shuttle Feasibility Study', '', 271, 281, 866, , '', '', '', '', '', 35000, '35000', 5, '', '', '01023', 36, '', ''
12, '', 'Monrovia Shuttle', 'Verify shuttle route and develop bus spec and patronage est.', 223, 231, 15, , '', '2/1/2001', '', 'from client', '', 16000, '8000', 5, '', 'BN submitted scope material to Patti.', '01024', 6, '', ''
13, '', 'Evaluation of Menlo Park Midday Shuttle', '', 216, 224, 260, , '', '2/10/2001', '3/1/2001', 'Mail from client', '', , '0', 5, '', 'Lost to Cliff Chambers on cost and extra add-ons', '01025', 28, '', ''
14, '', 'Santa Fe Trails Comprehensive Operations Analysis', 'COA?', 850, 878, , , '', '2/10/2001', '3/10/2001', 'Passenger Transport', '', 0, '0', 5, '', '5/7 - Apparent winner. Staff is recommedning N\N.  We barely beat out Urbitran..', '01026', 25, 'Santa Fe Trails, NM', ''
15, '', 'State Route 4 Corridor Transit Study', '', 1056, , , , '', '2/1/2000', '3/16/2001', 'call from Cambridge', '', 800000, '0', 5, '', 'Lost to Wilbur Smith.  Team did terrible job at interview.', '01027', 6, '', ''
16, '', 'Ohio - On Call Planning Work', '', 913, 941, , , '', '', '', '', '', , '', 4, '', '', '01028', , '', ''
17, '', 'Plumas County TPA', '', 723, 748, , , '', '2/5/2001', '5/4/2001', 'Call from client', '', 20000, '20000', 5, '', '5/4/01 - CL is writing proposal', '01029', 10, 'Plumas County, CA', ''
18, '', 'BART to Livermore I-580 Corridor Study', 'Do bus system planning as an "interim" solution to BART expansion?where the interim may become permanent.', 20, 1102, 480, , '', '', '', '', '', 150000, '40000', 5, '', '', '01030', 6, '', ''
19, '', 'Minnesota Department of Transportation', '', 479, 3049, , , '', '', '', '', '', , '', , '', '', '01031', , '', ''
20, '', 'San Francisco Environmental As Needed', '', 810, 1109, , , '', '', '', '', '', 0, '0', 5, '', 'DT got a message from Ellen Cross saying we won the contract and that EDAW  is now in contract negociations.  Jeffrey Tumlin to follow up.', '01032', 6, 'San Francisco Planning Dept./SF, CA', ''


Select * from tblProposals WHERE pkProposalID <=20

1, 766, '', 'Prime - Fehr & Peers', '', 3, '2005-06-30 00:00:00', '', '', ''
2, 767, '', '', '', 3, '1899-12-30 00:00:00', '', '', ''
3, 769, '', '', '', 3, '1899-12-30 00:00:00', '', '', ''
4, 772, '', 'Prime - MIG', '12/16/02', 4, '1899-12-30 00:00:00', '', '', ''
5, 775, '', 'Westat', '', 3, '1899-12-30 00:00:00', '', 'Westat', ''
6, 776, '', '', '', 4, '1899-12-30 00:00:00', '', '', ''
7, 777, '', 'Subs: Kaku, System Metrics and Roanoke', '', 3, '1899-12-30 00:00:00', '', '', ''
8, 780, '', 'Prime:  Sam Schwarz.', '', 3, '1899-12-30 00:00:00', '', '', ''
9, 781, '', 'Prime: Kittelson', '', 3, '1899-12-30 00:00:00', '', '', ''
10, 786, '', 'PRIME:  WRT', '', 4, '1899-12-30 00:00:00', '', '', ''
11, 790, '', 'PRIME:  BFJ', '', 4, '1899-12-30 00:00:00', '', '', ''
12, 793, '', 'Primes: Team #1 Torti Gallas, Team #2 WRT and Team #3 DPZ', '3/26', 4, '1899-12-30 00:00:00', '', '', ''
13, 794, '', '', '', 3, '1899-12-30 00:00:00', '', '', ''
14, 797, '', 'PRIME:  Westat', '', 4, '1899-12-30 00:00:00', '', '', ''
15, 800, '', '', '', 4, '1899-12-30 00:00:00', '', '', ''
16, 803, '', 'PRIME:  Torti Gallas', '', 4, '1899-12-30 00:00:00', '', '', ''
17, 805, '', '', '', 3, '1899-12-30 00:00:00', 'NN', '', ''
18, 806, '', '', '', 4, '1899-12-30 00:00:00', '', '', ''
19, 807, '', 'Subs - Debbie Alpers, WESTAT(Health Care expert)', '', 4, '1899-12-30 00:00:00', '', '', ''
20, 808, '', '', '', 3, '1899-12-30 00:00:00', '', '', ''



Select * from tblProjects WHERE pkProjectID <=20

1, 1, 6, 0, '', '', '', '', '', '', '', 2, ''
2, 2, 6, 0, '', '', '', '', '', '', '', 2, ''
3, 3, 45, 1, '2002', 'Nelson\Nygaard completed a "windshield survey" of the cars parked within a half mile of the BART Balboa station.', '2002-05-01 00:00:00', '2002-08-01 00:00:00', '', '2002', '', 2, ''
4, 5, 1, 1, '2002', 'Car-sharing is one of the newest additions to the transportation toolbox, and has great potential to reduce parking demand and vehicle travel, and improve mobility for low-income communities.', '2003-10-14 00:00:00', '', '', '', '', 1, ''
5, 7, 45, 1, '2003', 'Nelson\Nygaard is under contract to Caltrans to develop a Master Plan and Program of Projects that will lead to an increase in the use of HOV and Park & Ride facilities (both existing and planned) ', '2003-05-01 00:00:00', '2004-09-01 00:00:00', '', '', '', 1, ''
6, 8, 53, 0, '', '', '', '', '', '', '', 1, ''
7, 9, 59, 0, '', '', '', '', '', '', '', 2, ''
8, 13, 5, 0, '2002', 'See 01318
', '2002-12-05 00:00:00', '2003-12-01 00:00:00', '', '', '', 1, ''
9, 17, 28, 1, '2002', 'Nelson\Nygaard is assisting the Port of San Francisco to develop parking strategies. .', '2002-10-01 00:00:00', '2003-02-01 00:00:00', '', '', '', 1, ''
10, 20, 15, 1, '2002', '', '2003-02-14 00:00:00', '', '', '', '', 2, ''
11, 21, 36, 0, '', '', '', '', '', '', '', 2, ''
12, 22, 6, 1, '2002', 'Marin County Transit District operates in an unusual arrangement with the visible public transit provider, Golden Gate Transit.', '', '', '', '', '', 2, ''
13, 23, 6, 0, '', 'Golden Gate Transit has historically provided both transbay transit service over the Golden Gate Bridge and local transit service within Marin County.', '', '', '', '', '', 2, ''
14, 25, 44, 0, '', 'The Riverfront Project will consist of a mixed-use development in downtown Napa, CA. Nelson\Nygaard conducted a shared parking analysis for the development. The project has been approved by the City.', '', '', '', '', '', 2, ''
15, 30, 5, 1, '2001', 'Nelson\Nygaard conducted a comprehensive review of the trip reduction impacts of various employer and non-employer based transportation demand management strategies.', '', '', '', '', '', 2, ''
16, 31, 10, 0, '2001', '', '', '', '', '', '', 2, ''
17, 33, 6, 1, '2001', 'Nelson\Nygaard participated in this multidisciplinary team.', '', '2001-10-01 00:00:00', '', '', '', 2, ''
18, 34, 25, 0, '2001', 'In response to growing traffic concerns by the California Polytechnic University-Pomona, university officials considered banning Foothill Transit buses from using their parking facilities as a transit center.  ', '2001-02-01 00:00:00', '2001-05-01 00:00:00', '', '', '', 2, ''
19, 38, 6, 1, '2001', 'Nelson\Nygaard is part of a multi-disciplinary team assembled to provide as needed assistance to the San Francisco MUNI as they develop capital and operating projects affecting transit service in the City.', '', '', '', '', '', 2, ''
20, 39, 36, 1, '2001', 'The study  analyzed the organizational structures of the local operators in the Arroyo Verdugo area  determine opportunities for coordinating and/or combining services.    ', '2002-03-15 00:00:00', '', '01 Public Transportation Strategy Final Report', '', '', 2, ''