-
Notifications
You must be signed in to change notification settings - Fork 0
/
sweetand_sour.sql
2724 lines (2704 loc) · 484 KB
/
sweetand_sour.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Mar 06, 2021 at 11:37 PM
-- Server version: 10.4.10-MariaDB
-- PHP Version: 7.3.12
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `sweetand_sour`
--
-- --------------------------------------------------------
--
-- Table structure for table `folders`
--
DROP TABLE IF EXISTS `folders`;
CREATE TABLE IF NOT EXISTS `folders` (
`folderID` int(11) NOT NULL DEFAULT 0,
`grandparentFolderID` int(11) DEFAULT NULL,
`folderName` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`folderID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `folders`
--
INSERT INTO `folders` (`folderID`, `grandparentFolderID`, `folderName`) VALUES
(1, NULL, 'home'),
(2, NULL, 'whoweare'),
(3, NULL, 'wherewelive'),
(4, NULL, 'letters'),
(5, NULL, 'greatkids'),
(6, NULL, 'technology'),
(7, NULL, 'artsandculture'),
(8, NULL, 'contactus'),
(9, NULL, 'timeforjustice'),
(10, NULL, 'photos'),
(11, 3, 'sydney'),
(12, 3, 'denver'),
(13, 4, 'blizzard'),
(14, 4, 'letter01'),
(15, 4, 'letter02'),
(16, 4, 'letter03'),
(17, 4, 'letter04'),
(18, 4, 'letter05'),
(19, 4, 'letter06'),
(20, 4, 'letter07'),
(21, 4, 'letter08'),
(22, 4, 'letter09'),
(23, 4, 'letter10'),
(24, 4, 'letter11'),
(25, 4, 'letter12'),
(26, 4, 'letter13'),
(27, 4, 'letter14'),
(28, 4, 'letter15'),
(29, 4, 'letter16'),
(30, 4, 'letter17'),
(45, 7, 'humor'),
(46, 10, 'panoramas'),
(50, 10, 'RenoRd'),
(51, 10, 'UtahTrip'),
(52, 10, 'Australia2005'),
(53, 10, 'GrandCanyon'),
(54, 10, 'cherryBlossoms'),
(55, 10, 'Canada2006'),
(56, 3, 'washington'),
(57, 10, 'LongwoodGardens'),
(31, 4, 'letter18'),
(58, 10, 'Australia2007'),
(60, NULL, 'madisonSt'),
(32, 4, 'letter19'),
(62, NULL, 'canoe'),
(59, 10, 'Maine2009'),
(63, 3, 'house'),
(64, 3, 'lisbon'),
(65, 4, 'letter20'),
(66, 4, 'letter21'),
(67, 4, 'letter22');
-- --------------------------------------------------------
--
-- Table structure for table `menus2`
--
DROP TABLE IF EXISTS `menus2`;
CREATE TABLE IF NOT EXISTS `menus2` (
`menuID` int(11) NOT NULL DEFAULT 0,
`displayText` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
`parentID` int(11) NOT NULL DEFAULT 0,
`folderID` int(11) NOT NULL DEFAULT 4,
`fuseAction` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
`orderInGroup` int(11) NOT NULL DEFAULT 0,
`enabled` tinyint(4) NOT NULL DEFAULT 1,
`menuLevel` tinyint(4) DEFAULT 1,
`displayOnPgOnly` tinyint(4) NOT NULL DEFAULT 0,
`lft` int(11) NOT NULL,
`rgt` int(11) NOT NULL,
PRIMARY KEY (`menuID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `menus2`
--
INSERT INTO `menus2` (`menuID`, `displayText`, `parentID`, `folderID`, `fuseAction`, `orderInGroup`, `enabled`, `menuLevel`, `displayOnPgOnly`, `lft`, `rgt`) VALUES
(1, 'Home', 0, 1, 'welcome', 1, 1, 1, 0, 2, 9),
(2, 'Who we are', 0, 2, 'whoWeAre', 2, 1, 1, 0, 10, 17),
(3, 'Where we live', 0, 3, 'lisbon', 3, 1, 1, 0, 18, 35),
(4, 'Newsletters', 0, 4, 'lettersOverview', 4, 1, 1, 0, 36, 219),
(5, 'Great kids', 0, 5, 'relatives', 5, 0, 1, 0, 220, 225),
(6, 'Technology', 0, 6, 'thisWebSite', 6, 1, 1, 0, 226, 241),
(7, 'Arts and Culture', 0, 7, 'books', 7, 1, 1, 0, 242, 271),
(8, 'Time for Justice', 0, 9, 'injustice', 8, 1, 1, 0, 272, 277),
(9, 'Photos', 0, 10, 'portsmouth2009', 9, 1, 1, 0, 278, 317),
(10, 'Contact us', 0, 8, 'contactUs', 10, 1, 1, 0, 318, 319),
(20, 'Welcome', 1, 1, 'welcome', 1, 1, 2, 0, 3, 4),
(21, 'Instagram links', 1, 1, 'instagram', 2, 1, 2, 0, 5, 6),
(25, 'About us', 2, 2, 'whoWeAre', 1, 1, 2, 0, 11, 12),
(26, 'Old photos – Lan', 2, 2, 'oldPhotosLan', 2, 1, 2, 0, 13, 14),
(27, 'Old photos – Peter', 2, 2, 'oldPhotosPeter', 3, 1, 2, 0, 15, 16),
(30, 'Lisbon', 3, 3, 'lisbon', 1, 1, 2, 0, 19, 20),
(31, 'Denver', 3, 3, 'denver', 3, 1, 2, 0, 31, 32),
(32, 'Sydney', 3, 3, 'sydney', 4, 1, 2, 0, 33, 34),
(40, 'Overview', 4, 4, 'lettersOverview', 1, 1, 2, 0, 37, 38),
(41, '1', 4, 4, 'letter1', 2, 1, 2, 0, 39, 40),
(42, '2', 4, 4, 'letter2a', 3, 1, 2, 0, 41, 46),
(43, '3', 4, 4, 'letter3a', 4, 1, 2, 0, 47, 60),
(44, '4', 4, 4, 'letter4a', 5, 1, 2, 0, 61, 70),
(45, '5', 4, 4, 'letter5a', 6, 1, 2, 0, 71, 82),
(46, '6', 4, 4, 'letter6a', 7, 1, 2, 0, 83, 92),
(47, '7', 4, 4, 'letter7a', 8, 1, 2, 0, 93, 100),
(48, '8', 4, 4, 'letter8a', 9, 1, 2, 0, 101, 108),
(49, 'Blizzard', 4, 4, 'blizzard97', 10, 1, 2, 0, 109, 110),
(50, '9', 4, 4, 'letter9a', 11, 1, 2, 0, 111, 118),
(51, '10', 4, 4, 'letter10a', 12, 1, 2, 0, 119, 126),
(52, '11', 4, 4, 'letter11', 13, 1, 2, 0, 127, 128),
(53, '12', 4, 4, 'letter12a', 14, 1, 2, 0, 129, 136),
(54, '13', 4, 4, 'letter13a', 15, 1, 2, 0, 137, 148),
(55, '14', 4, 4, 'letter14a', 16, 1, 2, 0, 149, 158),
(56, '15', 4, 4, 'letter15a', 17, 1, 2, 0, 159, 168),
(57, '16', 4, 4, 'letter16a', 18, 1, 2, 0, 169, 184),
(80, 'Relatives', 5, 5, 'relatives', 1, 0, 1, 0, 221, 222),
(81, 'Friends', 5, 5, 'friends', 2, 0, 1, 0, 223, 224),
(87, 'Sand box', 6, 6, 'sandbox', 5, 0, 2, 0, 239, 240),
(83, 'Computers', 6, 6, 'computers', 2, 0, 2, 0, 229, 230),
(84, 'Cars', 6, 6, 'cars1', 3, 1, 2, 0, 231, 236),
(82, 'This web site', 6, 6, 'thisWebSite', 1, 1, 2, 0, 227, 228),
(86, 'Alternative energy', 6, 6, 'altEnergy', 4, 0, 1, 0, 237, 238),
(101, 'Aussie rock & roll', 7, 7, 'rockAndRoll', 2, 1, 2, 0, 245, 246),
(102, 'Humor', 7, 7, 'humor1', 5, 1, 2, 0, 251, 260),
(103, 'Speeches', 7, 7, 'farnsworth', 6, 1, 2, 0, 261, 270),
(100, 'K-pop!', 7, 7, 'kpop', 1, 1, 2, 0, 243, 244),
(120, 'Page 1', 42, 4, 'letter2a', 1, 1, 3, 0, 42, 43),
(121, 'Page 2', 42, 4, 'letter2b', 2, 1, 3, 0, 44, 45),
(122, 'Page 1', 43, 4, 'letter3a', 1, 1, 3, 0, 48, 49),
(123, 'Page 2', 43, 4, 'letter3b', 2, 1, 3, 0, 50, 51),
(124, 'Page 3', 43, 4, 'letter3c', 3, 1, 3, 0, 52, 53),
(125, 'Page 4', 43, 4, 'letter3d', 4, 1, 3, 0, 54, 55),
(126, 'Page 5', 43, 4, 'letter3e', 5, 1, 3, 0, 56, 57),
(127, 'Page 6', 43, 4, 'letter3f', 6, 1, 3, 0, 58, 59),
(128, 'Page 1', 44, 4, 'letter4a', 1, 1, 3, 0, 62, 63),
(129, 'Page 2', 44, 4, 'letter4b', 2, 1, 3, 0, 64, 65),
(130, 'Page 3', 44, 4, 'letter4c', 3, 1, 3, 0, 66, 67),
(131, 'Page 4', 44, 4, 'letter4d', 4, 1, 3, 0, 68, 69),
(132, 'Page 1', 45, 4, 'letter5a', 1, 1, 3, 0, 72, 73),
(133, 'Page 2', 45, 4, 'letter5b', 2, 1, 3, 0, 74, 75),
(134, 'Page 3', 45, 4, 'letter5c', 3, 1, 3, 0, 76, 77),
(135, 'Page 4', 45, 4, 'letter5d', 4, 1, 3, 0, 78, 79),
(136, 'Page 5', 45, 4, 'letter5e', 5, 1, 3, 0, 80, 81),
(137, 'Page 1', 46, 4, 'letter6a', 1, 1, 3, 0, 84, 85),
(138, 'Page 2', 46, 4, 'letter6b', 2, 1, 3, 0, 86, 87),
(139, 'Page 3', 46, 4, 'letter6c', 3, 1, 3, 0, 88, 89),
(140, 'Page 4', 46, 4, 'letter6d', 4, 1, 3, 0, 90, 91),
(141, 'Page 1', 47, 4, 'letter7a', 1, 1, 3, 0, 94, 95),
(142, 'Page 2', 47, 4, 'letter7b', 2, 1, 3, 0, 96, 97),
(143, 'Page 3', 47, 4, 'letter7c', 3, 1, 3, 0, 98, 99),
(144, 'Page 1', 48, 4, 'letter8a', 1, 1, 3, 0, 102, 103),
(145, 'Page 2', 48, 4, 'letter8b', 2, 1, 3, 0, 104, 105),
(146, 'Page 3', 48, 4, 'letter8c', 3, 1, 3, 0, 106, 107),
(147, 'Page 1', 50, 4, 'letter9a', 1, 1, 3, 0, 112, 113),
(148, 'Page 2', 50, 4, 'letter9b', 2, 1, 3, 0, 114, 115),
(149, 'Page 3', 50, 4, 'letter9c', 3, 1, 3, 0, 116, 117),
(150, 'Page 1', 51, 4, 'letter10a', 1, 1, 3, 0, 120, 121),
(151, 'Page 2', 51, 4, 'letter10b', 2, 1, 3, 0, 122, 123),
(152, 'Page 3', 51, 4, 'letter10c', 3, 1, 3, 0, 124, 125),
(153, 'Page 1', 53, 4, 'letter12a', 1, 1, 3, 0, 130, 131),
(154, 'Page 2', 53, 4, 'letter12b', 2, 1, 3, 0, 132, 133),
(155, 'Page 3', 53, 4, 'letter12c', 3, 1, 3, 0, 134, 135),
(156, 'Page 1', 54, 4, 'letter13a', 1, 1, 3, 0, 138, 139),
(157, 'Page 2', 54, 4, 'letter13b', 2, 1, 3, 0, 140, 141),
(158, 'Page 3', 54, 4, 'letter13c', 3, 1, 3, 0, 142, 143),
(159, 'Page 4', 54, 4, 'letter13d', 4, 1, 3, 0, 144, 145),
(160, 'Page 5', 54, 4, 'letter13e', 5, 1, 3, 0, 146, 147),
(161, 'Page 1', 55, 4, 'letter14a', 1, 1, 3, 0, 150, 151),
(162, 'Page 2', 55, 4, 'letter14b', 2, 1, 3, 0, 152, 153),
(163, 'Page 3', 55, 4, 'letter14c', 3, 1, 3, 0, 154, 155),
(164, 'Page 4', 55, 4, 'letter14d', 4, 1, 3, 0, 156, 157),
(165, 'Page 1', 56, 4, 'letter15a', 1, 1, 3, 0, 160, 161),
(166, 'Page 2', 56, 4, 'letter15b', 2, 1, 3, 0, 162, 163),
(167, 'Page 3', 56, 4, 'letter15c', 3, 1, 3, 0, 164, 165),
(168, 'Page 4', 56, 4, 'letter15d', 4, 1, 3, 0, 166, 167),
(169, 'Page 1', 57, 4, 'letter16a', 1, 1, 3, 0, 170, 171),
(170, 'Page 2', 57, 4, 'letter16b', 2, 1, 3, 0, 172, 173),
(171, 'Page 3', 57, 4, 'letter16c', 3, 1, 3, 0, 174, 175),
(172, 'Page 4', 57, 4, 'letter16d', 4, 1, 3, 0, 176, 177),
(173, 'Page 5', 57, 4, 'letter16e', 5, 1, 3, 0, 178, 179),
(298, 'General Principles', 84, 6, 'cars1', 1, 1, 3, 0, 232, 233),
(299, 'Innovative Designs', 84, 6, 'cars2', 2, 1, 3, 0, 234, 235),
(190, '20', 4, 4, 'letter20', 22, 1, 2, 0, 213, 214),
(191, '21', 4, 4, 'letter21', 23, 1, 2, 0, 215, 216),
(304, 'British TV Comedies', 102, 7, 'humor1', 1, 1, 3, 0, 252, 253),
(305, 'Other TV', 102, 7, 'humor2', 2, 1, 3, 0, 254, 255),
(306, 'Men and Women', 102, 7, 'humor3', 3, 1, 3, 0, 256, 257),
(307, 'Random', 102, 7, 'humor4', 4, 1, 3, 0, 258, 259),
(316, 'The inventor of TV', 103, 7, 'farnsworth', 1, 1, 3, 0, 262, 263),
(317, 'Bumper stickers', 103, 7, 'bumperStickers', 2, 1, 3, 0, 264, 265),
(318, 'Palestine', 103, 7, 'palestine', 3, 1, 3, 0, 266, 267),
(319, 'Genocide', 103, 7, 'genocide', 4, 1, 3, 0, 268, 269),
(22, 'Search Results', 1, 1, 'searchResults', 2, 1, 2, 1, 7, 8),
(105, 'Reading plan', 7, 7, 'readingPlan', 4, 1, 2, 0, 249, 250),
(174, 'Page 6', 57, 4, 'letter16f', 6, 1, 3, 0, 180, 181),
(175, 'Page 7', 57, 4, 'letter16g', 7, 1, 3, 0, 182, 183),
(320, 'Panoramas', 9, 10, 'panorama', 20, 0, 2, 0, 315, 316),
(176, '17', 4, 4, 'letter17a', 19, 1, 2, 0, 185, 196),
(177, 'Page 1', 176, 4, 'letter17a', 1, 1, 3, 0, 186, 187),
(178, 'Page 2', 176, 4, 'letter17b', 2, 1, 3, 0, 188, 189),
(179, 'Page 3', 176, 4, 'letter17c', 3, 1, 3, 0, 190, 191),
(180, 'Page 4', 176, 4, 'letter17d', 4, 1, 3, 0, 192, 193),
(181, 'Page 5', 176, 4, 'letter17e', 5, 1, 3, 0, 194, 195),
(330, '4610 Reno Rd', 9, 10, 'renoRd', 16, 0, 1, 0, 313, 314),
(331, 'Utah', 9, 10, 'utah2005', 15, 1, 2, 0, 311, 312),
(332, 'Australia', 9, 10, 'aust2007', 9, 1, 2, 0, 289, 294),
(333, 'Grand Canyon', 9, 10, 'grandCanyon', 13, 1, 2, 0, 309, 310),
(334, 'Cherry blossoms', 9, 10, 'cherryBlossoms', 12, 1, 2, 0, 307, 308),
(335, 'Montréal', 340, 10, 'montreal2006', 1, 1, 3, 0, 296, 297),
(336, 'Trois-Rivières', 340, 10, 'troisRivieres2006', 2, 1, 3, 0, 298, 299),
(337, 'Québec City', 340, 10, 'quebec2006', 3, 1, 3, 0, 300, 301),
(338, 'Ottawa', 340, 10, 'ottawa2006', 4, 1, 3, 0, 302, 303),
(33, 'Washington', 3, 3, 'washington', 2, 1, 2, 0, 23, 30),
(339, 'Longwood Gardens', 9, 10, 'longwoodGardens', 11, 1, 2, 0, 305, 306),
(182, '18', 4, 4, 'letter18a', 20, 1, 2, 0, 197, 204),
(183, 'Page 1', 182, 4, 'letter18a', 1, 1, 3, 0, 198, 199),
(184, 'Page 2', 182, 4, 'letter18b', 2, 1, 3, 0, 200, 201),
(185, 'Page 3', 182, 4, 'letter18c', 3, 1, 3, 0, 202, 203),
(340, 'Canada', 9, 10, 'montreal2006', 10, 1, 2, 0, 295, 304),
(310, 'Books I\'ve read', 7, 7, 'books', 3, 1, 2, 0, 247, 248),
(341, 'Australia 2007', 332, 10, 'aust2007', 1, 1, 3, 0, 290, 291),
(0, 'Root', -1, 0, 'root', 0, 0, 1, 0, 1, 320),
(342, 'Australia 2005', 332, 10, 'aust2005', 2, 1, 3, 0, 292, 293),
(344, 'Palestine', 8, 9, 'injustice', 0, 1, 2, 0, 273, 274),
(345, 'Calls for Justice', 8, 9, 'callsForJustice', 0, 1, 2, 0, 275, 276),
(186, '19', 4, 4, 'letter19a', 21, 1, 2, 0, 205, 212),
(187, 'Page 1', 186, 4, 'letter19a', 1, 1, 3, 0, 206, 207),
(188, 'Page 2', 186, 4, 'letter19b', 2, 1, 3, 0, 208, 209),
(189, 'Page 3', 186, 4, 'letter19c', 3, 1, 3, 0, 210, 211),
(346, 'Maine', 9, 10, 'portsmouth2009', 8, 1, 2, 0, 279, 288),
(347, 'Portsmouth, NH', 346, 10, 'portsmouth2009', 1, 1, 3, 0, 280, 281),
(348, 'Acadia N.P. & points north', 346, 10, 'acadia2009', 2, 1, 3, 0, 282, 283),
(349, 'Maine Central Coast', 346, 10, 'centralCoastME', 3, 1, 3, 0, 284, 285),
(350, 'Portland', 346, 10, 'portland2009', 4, 1, 3, 0, 286, 287),
(34, 'The city', 33, 3, 'washington', 1, 1, 3, 0, 24, 25),
(35, 'House renovation', 33, 3, 'houserenovation', 2, 1, 3, 0, 26, 27),
(36, 'Instructions to builder', 33, 3, 'instructionstobuilder', 3, 1, 3, 0, 28, 29),
(37, 'Somewhere else', 3, 3, 'somewhere', 1, 0, 3, 0, 21, 22),
(192, '22', 4, 4, 'letter22', 24, 1, 2, 0, 217, 218);
-- --------------------------------------------------------
--
-- Table structure for table `photos`
--
DROP TABLE IF EXISTS `photos`;
CREATE TABLE IF NOT EXISTS `photos` (
`photoName` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`folderID` int(11) NOT NULL DEFAULT 0,
`caption` text COLLATE utf8_unicode_ci NOT NULL,
`linkedImg` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`linkToFullSize` enum('Y','N') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'N',
`version` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
`width` int(11) DEFAULT NULL,
`height` int(11) DEFAULT NULL,
PRIMARY KEY (`photoName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `photos`
--
INSERT INTO `photos` (`photoName`, `folderID`, `caption`, `linkedImg`, `linkToFullSize`, `version`, `width`, `height`) VALUES
('FishCreekFalls3.jpg', 1, '', 'FishCreekFalls2', 'N', NULL, NULL, NULL),
('7MileBridge2.jpg', 26, '<p>Parellel bridges link the Florida Keys. Note the gap in the old bridge on the left. See a close-up view of a <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=BridgeTooFar2.jpg\" target=\"_blank\" onclick=\"SweetAndSour.getPhoto(\'BridgeTooFar2.jpg\', \'Broken Bridge\'); return false;\">broken bridge</a>.</p>', '', 'N', '20000117', 750, 510),
('7MileBridge1.jpg', 26, 'The 7 Mile Bridge is one of many on the way to Key West.', '7MileBridge2.jpg', 'N', '20000126', 150, 102),
('UsEnteringShip1.jpg', 20, 'On entering the ship', 'UsEnteringShip2.jpg', 'N', '20050128', 148, 100),
('UsEnteringShip2.jpg', 20, '<p>This photo was taken as we entered the cruise ship Regal Princess. It seems that they expect the all the passengers to be American. The ship is registered in Liberia.</p>\r\n\r\n<p>Unfortunately, they didn\'t give us time to put our bags down so I have an odd posture because I\'m trying to hide the bags behind Lan.</p>', '', 'N', '19990510', 375, 255),
('2CVFront2.jpg', 6, '<a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=2CVSide2.jpg\" onclick=\"SweetAndSour.getPhoto(\'2CVSide2.jpg\', \'Citroën 2CV\'); return false;\"><< Back</a>', '', 'N', '19990517', 309, 255),
('2CVPrototype2.jpg', 6, '<p>2CV prototype (circa 1939). Note the single headlight, engine crank over the front bumper and "corrugated iron" front panels.</p>\r\n<p><a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=2CVSide2.jpg\" onclick=\"SweetAndSour.getPhoto(\'2CVSide2.jpg\', \'Citroën 2CV\'); return false;\"><< Back</a>', '', 'N', '19990517', 375, 230),
('2CVSide2.jpg', 6, '<p><b>Citroën 2CV</b></p>\r\n\r\n<p><a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=2CVFront2.jpg\" onclick=\"SweetAndSour.getPhoto(\'2CVFront2.jpg\', \'Front view of the 2CV\'); return false;\">Front view</a> and\r\npre-war <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=2CVPrototype2.jpg\"onclick=\"SweetAndSour.getPhoto(\'2CVPrototype2.jpg\', \'2CV Prototype\'); return false;\">prototype</a>\r\n</p>\r\n\r\n<p>Conceived in 1936 as an ultra-simple, ultra-lightweight, ultra-comfortable car for farmers and the masses, the 2CV concept also called for low running costs, low repair costs and the ability to carry four passengers. Pierre Boulanger\'s design brief envisioned \"4 wheels under an umbrella\" and the ability to \"... cross a ploughed field without breaking any eggs carried in a basket.\" Production of the car started on 2nd September 1939, only to be halted by a minor political disagreement the following day - World War II.</p>\r\n\r\n<p>Perhaps fortunately for Citroën, development of the car continued during the war, and radical changes were made before the car hit the public at the Paris Show, 1949. The 2CV went on to become one of the most enduring vehicles ever, continuing unabated until 1990, when production finished in Portugul.</p>\r\n\r\n<p>Early models had a 375cc engine developing - count them - nine horsepower (6.7 kW) but over the years, engine capacity and power gradually increased eventually reaching 602cc and 32 hp (24 kW).</p>\r\n<p><a onclick=\"SweetAndSour.getPhoto(\'CCVSideLg.jpg\', \'Chrysler CCV\'); return false;\" href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=CCVSideLg.jpg&altText=Chrysler+CCV\"><< Back</a></p>', '', 'N', '19990519', 300, 147),
('Aerial2.jpg', 12, '<p>[2020 update: Note that this photo was from 1999, six years before Google Maps launched and made aerial/satellite views commonplace. At the time this seemed remarkable. At the time I was considering <a class=\"external\" href=\"https://en.wikipedia.org/wiki/Kite_aerial_photography\">kite aerial photography</a> using a shutter release mechanism based on a melting ice cube! However I never got that far and it was soon apparent that it was aerial photography was available by other means.]</p>\r\n<p>This photo from the US Geological Survey was taken from a <a target=\"_blank\" href=\"http://www.terraserver.microsoft.com\">site</a> that has photographs of most of America and some places in other countries. The arrow marks where we live. It appears that this photo was taken from an aeroplane, not a satellite. Denver residents may be interested to see this picture of <a onclick=\"SweetAndSour.getPhoto(\'Downtown.jpg\', \'\'); return false;\" href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=downtown.jpg\">downtown</a> (95k).</p>\r\n<p>[Nov 2008 update: with aerial views available from Mapquest, Yahoo Maps and Google Maps, this isn\'t so special now. In fact, check out the "bird\'s eye" view on <a target=\"_blank\" href=\"http://maps.live.com\">maps.live.com</a>.]\r\n\r\n<p>For something really impressive, have a look at <a href=\"http://www.spaceimaging.com\">Space Imaging\'s web site</a> and look at samples from their IKONOS satellite that has a 1m resolution.</p>', '', 'N', '19991027', 400, 400),
('3sisters2.jpg', 11, '<p>The Blue Mountains to the west of Sydney take their name from the blue tinge in the air due to the eucalyptus oil from all the trees. </p>\r\n\r\n<p>Actually they are not really mountains at all but a deeply eroded plateau with sheer cliffs forming huge gorges. Indeed, the mountains were thought to be impenetrable and were not crossed until 1813, 25 years after the colony was founded. The \"mountains\" are not very high at about 1000 m (3300 ft). </p>\r\n\r\n<p>Seen here are the \"Three Sisters\" a trio of rocky outcrops just outside Katoomba.</p>', '', 'N', '19991114', 560, 554),
('Alligator2.jpg', 26, '<p>A 6 foot (2 m) alligator enjoys a rest on a boat ramp in the Everglades National Park. I thought Lan was too close.</p>', '', 'N', '20000117', 750, 510),
('LanChild1.jpg', 2, 'An early photo showing Lan\'s grandparent\'s family. Lan\'s grandmother had 18 children!.', 'LanChild2.jpg', 'N', '19990510', 148, 100),
('SegoviaAquaduct2.jpg', 18, '<p>This magnificent aquaduct in Segovia, Spain was built by the ancient Romans.</p>\r\n\r\n<p>Segovia is a small town only 100 km from Madrid but it has this aquaduct, a castle and a large cathedral. An excellent day trip.</p>', '', 'N', '19990530', 550, 384),
('AreYouA2.jpg', 7, '<p>Management with Captain Peacock, \"young\" Mr Grace (whose replacement wasn\'t nearly so good) and Mr Rumbold.</p>\r\n\r\n<p>Return to <a href=\"/artsandculture/index.php?fuseAction=humor1\">humor</a>.</p>\r\n', '', 'N', '19990519', 375, 250),
('AreYouB2.jpg', 7, '<p>The floor staff in Mr Rumbold\'s office.</p>\r\n\r\n<p><a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=AreYouC2.jpg\">Previous</a> photo.</p>\r\n<p><a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=AreYouA2.jpg\">Next</a> photo.</p>\r\n\r\n<p>Return to <a href=\"/artsandculture/index.php?fuseAction=humor1\">humor</a>.</p>', '', 'N', '19990519', 375, 281),
('AreYouC2.jpg', 7, '<p>From left: Miss Brahms, Mrs Slocumbe, Mr Grainger (who died and none of the three replacements were as good), Mr Humphries and Mr Lucas (later replaced by Mr Spooner who was just as good).</p>\r\n\r\n<p><a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=AreYouB2.jpg\">Next</a> photo.</p>\r\n\r\n<p>Return to <a href=\"/artsandculture/index.php?fuseAction=humor1\">humor</a>.</p>', '', 'N', '19990519', 375, 281),
('AustOnUS2.jpg', 11, '<p>Australia at 2.9 million sq. miles (7.7million sq. km) is approximately the same size as America 3.0 million sq. miles (7.8 million sq. km), not counting Alaska. Also see <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=AustOnEurope.jpg\">Australia compared to Europe</a> </p>', '', 'N', '19990510', 550, 374),
('BadlandsSDakota2.jpg', 19, '<p>Lan checks the Badlands for bargains. There weren\'t any. There was some spectacular scenery though</p>', '', 'N', '19990529', 550, 375),
('BeaverDam2.jpg', 16, '<p>This dam was built by beavers in the Rocky Mountain National Park. These small animals that have only their teeth to cut up branches and their claws to hold them. I have seen a tree trunk about 12\" (30 cm) in diameter that beavers were working on. As you can see, the dam holds back the water very successfully and there is about 3\' (1 m) height difference from the upstream to downstream sides.</p>', '', 'N', '19990529', 378, 257),
('BerthoudPass2.jpg', 16, '<p>Berthoud Pass has to be crossed on the way to the west entrance of Rocky Mountain National Park. Notice the altitude 11,307 ft (3446 m) is way above Mt Kosiosko in Australia.</p>\r\n\r\n<p>Rainfall on my side of the sign flows eventually to the Pacific Ocean; rainfall on the other side flows eventually to the Atlantic. There is a line along the Rocky Mountains where this occurs - hence the term \"Continental Divide\".</p>', '', 'N', '19990529', 550, 374),
('BighornSheep2.jpg', 16, '<p>Mountain goats (or are these bighorn sheep?) on the road up Mount Evans.</p>\r\n\r\n<p>People feed the animals despite signs that say not to. The hope of a free meal brings them down to the road but the food they get is normally \"junk food\" for them and in any case, they can become dependent on it and then starve in the winter when the road is closed.</p>', '', 'N', '19990529', 550, 375),
('BlackCanyon2.jpg', 17, '', '', 'N', '19990529', 256, 375),
('PeterBlizzard1.jpg', 13, 'Out the front of our place the following morning.', 'PeterBlizzard2.jpg', 'N', '19990510', 102, 150),
('SnowAngel1.jpg', 13, 'Lan makes a "snow angel".', 'SnowAngel2.jpg', 'N', '19990510', 150, 102),
('BackSteps1.jpg', 13, 'Our back steps.', 'BackSteps2.jpg', 'N', '19990510', 102, 150),
('PeterBlizzard2.jpg', 13, '', '', 'N', '19990510', 256, 375),
('SnowAngel2.jpg', 13, '<p>Although it produces a nice pattern in the snow, the downside is that you are likely to get snow inside your jacket and then down your trousers! The angel quickly loses interest in being outdoors at that point.</p>', '', 'N', '19990510', 375, 255),
('BackSteps2.jpg', 13, '', '', 'N', '19990510', 255, 375),
('WebSafeColors1.gif', 6, 'I\'ve tried to use only web-safe colors for the background and menu colors.', 'WebSafeColors2.gif', 'N', '19990518', 150, 130),
('WebSafeColors2.gif', 6, '', '', 'N', '19990518', 980, 849),
('MoirePattern1.jpg', 6, 'I had a problem early on with scanned postcards. Moire patterns occur when scanning printed photographs at insufficiently high resolution.', 'MoirePattern2.jpg', 'N', '19990510', 150, 102),
('MoirePattern2.jpg', 6, '<p>Yellow polka dots!</p>\r\n<p>We often buy postcards since the photograph is always taken on a nice day, with good equipment that often includes a helicopter. </p>', '', 'N', '19990510', 375, 255),
('PeterAtWork1.jpg', 6, 'Peter at work ~2002', 'PeterAtWork2.jpg', 'N', '20050128', 148, 100),
('PeterAtWork2.jpg', 6, '<p>At the office I used to work in. Note the map of Australia in front of my desk. Though not in the picture, there was map of America behind me and a map of the world to my right. I like to know where I am.</p>', '', 'N', '20020220', 640, 480),
('BMWZ13side2.jpg', 6, '<p>BMW Z13 show car. Notice the short distance between the front and rear seats since the two rear seat passengers actually sit to the side of the driver in the center.</p>', '', 'N', '19990518', 550, 238),
('BondiAerial2.jpg', 11, '<p>The coast looking south with Bondi Beach in the foreground.</p>', '', 'N', '19991114', 550, 435),
('BondiBeach2.jpg', 11, '<p>Just 10km east of the city, Bondi Beach is Sydney\'s most famous beach though there are beaches all along Sydney\'s coastal suburbs as you can see from this <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=BondiAerial2.jpg\">aerial view</a>. While they are pretty to look at and they are certainly popular with swimmers (between the flags where the life savers can rescue you), surfers and sunbathers, I\'ve never been keen on going there. I sunburn easily and find that the beaches are sandy and wet. Not a pleasant combination, especially in your swim shorts!</p>\r\n\r\n<p>Bondi Beach is the end of the 4 km (9 mile) City to Surf foot race, famous for its \"heartbreak hill\" rising up to Vaucluse. Tens of thousands take part. My father and I ran/walked in it for many years but his attitude was that training for such an event was equivalent to cheating, so we just went out there and ran. That was OK when I was at school and fit but by my late 20s, my knees didn\'t enjoy it and I was taking double the time I had when I was young.</p>', '', 'N', '19991114', 577, 282),
('BookCliffs2.jpg', 16, '<p>Book Cliffs near Grand Junction on the western side of Colorado. They look spectacular in the late afternoon when the colors really stand out. A storm was moving through when this photo was taken so the lighting wasn\'t so good.</p>', '', 'N', '19990529', 550, 375),
('BridgeTaos2.jpg', 16, '<p>This bridge over the Rio Grand Gorge is on route US 64 near Taos, New Mexico. The river is 650 ft (200 m) below.</p>', '', 'N', '19990529', 550, 374),
('BridgeTooFar2.jpg', 26, '<p>An old bridge a few miles south of Marathon. The new bridge is visible on the left.</p>', '', 'N', '20000117', 749, 510),
('BuckinghamFountain2.jpg', 14, '', '', 'N', '20000819', 750, 508),
('Buffalo2.jpg', 17, '<p>Buffalo (also called bison) weigh up to a ton and can run at 30 mph (50 km/h). A notice given to every car entering the park begins, <i>\"WARNING Many visitors have been gored by buffalo\"</i>.</p>', '', 'N', '19990529', 375, 244),
('ButchardGardens2.jpg', 20, '', '', 'N', '19990510', 550, 373),
('Cabbages2.jpg', 20, '', '', 'N', '19990510', 550, 374),
('CableCar2.jpg', 18, '<p>A cable car climbing Hyde Street. Fisherman\'s Wharf is a the bottom of the hill. The first cable car ran in 1873.</p>', '', 'N', '19990530', 550, 375),
('Camping2.jpg', 19, '<p>Camping in a borrowed tent at Custer, South Dakota. There was just enough room inside for us to set up our bed.</p>', '', 'N', '19990529', 378, 257),
('Z600View1.jpg', 6, '<p>See <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=Z600View2.jpg\">front view</a> and <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=Z600View3.jpg\">rear view</a> and <a href=\"http://my.reset.jp/~inu/ProductsDataBase/Products/HONDA/HONDA_Z/HONDA_Z.htm\" target=\"_blank\">sales brochure</a>!</p>\r\n<p><a href=\"/technology/index.php?fuseAction=cars1\">Return</a> to cars.</a>\r\n\r\n<p><b>Honda Z360/600 known in Australia as the \"Zot\"</b></p>\r\n\r\n<p>(Unfortunately, the site I copied this information does not seem to exist any more, but they get credit at the bottom.)</p>\r\n\r\n<p>In 1967 Honda introduced a new small car to the Japanese domestic market, the new vehicle was dubbed the N 360. Powered by a 354cc air-cooled engine with two cylinders and single overhead camshaft the car wore it\'s motorcycle heritage on it\'s sleeve. The engine was good for 31 hp at 8500 rpm with the 4 speed standard gearbox. Honda also offered a 3 speed automatic for those interested in such a convenience. The car was front wheel drive, which with the exception a few Citroëns and Mini\'s, was rather unusual at the time. </p>\r\n\r\n<p>The N 360\'s styling was less than revolutionary a simple two-box design with two doors and a rather small trunk The 10\" spare wheel/tire was put in the engine compartment as a safety feature. The new Honda looked like a hatchback but was not, just a plastic trunk lid. The hood was hinged at the windshield and had prop rod to hold it up. The hood was also the top of the fenders with bottom edge forming a straight contour line down the side of the vehicle. Overall the N 360 was 119 inches long with a 78.7 inch wheelbase, 45.3 inch track and weighed in at 1,114 pounds. Inside, the car had a simple interior, the doors featured vinyl panels that covered part of the door the rest was metal finished in the same color as the exterior. The front seats were individual bench type again covered in vinyl. The rear seat was simple bench type. The dash was flat and simple equipped with a speedometer, fuel gauge and radio. The heater relied on the little air-cooled engine and\r\nprovided barely adequate warmth in return. Unique features were interior door handles positioned in lower front corners of the doors and the thing most people are surprised by, the shifter came out of the lower portion of the dash instead of the floor. </p>\r\n\r\n<p>Honda continued to improve the N360 by increasing engine displacement to include a 400cc option which of course changed that models name to the N400. The 400cc engine produced 33hp at 8000 rpm. The new N400 was available for sale in the Japan home market in October 1968. Less than one year later in May of 1969 the N 600 was offered to Japanese consumers. The 598cc engine made 45 hp at 7000 rpm. Other than adding larger engines the cars stayed basically the same. </p>\r\n\r\n<p>In early 1969 an upgraded model was offered, the N 600G. The new variant featured fake wood on the dash, a tachometer and a console to absorb some of the vibration from the shift lever. The previously 2 spoke plastic steering wheel was replaced with sporty 3 spoke leather covered unit. There were also new door handles and front disc brakes and wow, carpet on the floor. The N 600G was only available to the Japanese and European markets. </p>\r\n\r\n<p>Importation to America came in late 1969 as a 1970 model. The US got a more conventional looking dash with separate gauges and glovebox, and still sporting the shifter jutting from the dash. There was a floor shift option initially but it was dropped after a short while due to some safety concerns. There was no automatic transmission offered due to sluggish performance not suitable for America\'s driving conditions. The car looked out of place on US highways that were still mostly populated by large 8 and 6 cylinder vehicles. Honda sold 3,770 N 600\'s during the first year. </p>\r\n\r\n<p>In 1971 yet another new derivative was launched. The new Z600 Coupe feature all new bodywork. While still a 2 door it was much more curvaceous and featured a lift up rear window that looked like a scuba mask to most people. The hatchback also had new exterior mirrors and bumper overriders. Inside there was a new overhead console that featured separate map and dome lights, variations on this console carried on as option for first generation Civics. A new location to store the spare was added under the rear deck and had it\'s own separate door accesible from the outside of the car. The Z 600 had the same engine and front wheel drive transmission that shared its oil with the engine. The new Coupe bore obvious styling similarities to the Civic that was about to hit US shores in 1973. Honda was rewarded for it\'s new design with sales of near 10,000 cars with that number doubling for the 1972 model run. But of course Honda could not have forseen the success that new Civic would bring... </p>\r\n\r\n<p>Our thanks go out to Jerry McDonald for developing this narrative for us:\r\nJerry can be reached at: [email protected] (work) or [email protected] (home)\r\nJerry also extends his thanks for helping to create this narrative to Frank Acevedo: </p>\r\n\r\n<p>[email protected] reachable at:<br>\r\nHonda Restoration<br>\r\nP.O. Box 17233, Long Beach, CA. 90807<br>\r\nPhone 310-423-0136<br>\r\nExclusive Repair/Restoration/Sales of Honda S 500 ~ S 800M </p>\r\n\r\n<p>This site created and maintained by C.J. Beck and Timothy M. Fee. Reach us both at [email protected].</p>\r\n\r\n<p>The following specifications are from the 1972 brochure (600 coupe):</p>\r\n<table border=0 cellpadding=2 cellspacing=1 width=375>\r\n<tr>\r\n<td width=100 bgcolor=\"#336699\"><p class=\"boldWhite\">Engine: Type:</p></td>\r\n<td width=274 bgcolor=\"#99CCFF\"><p>Air cooled. two cylinder, SOHC, 4 main bearings</p></td>\r\n</tr>\r\n<tr>\r\n<td bgcolor=\"#336699\"><p class=\"boldWhite\">Cylinder arrangement:</p></td>\r\n<td bgcolor=\"#99CCFF\"><p>Vertical, parallel and transversely mounted</p></td>\r\n</tr>\r\n<tr>\r\n<td bgcolor=\"#336699\"><p class=\"boldWhite\">Bore & Stroke</p></td>\r\n<td bgcolor=\"#99CCFF\"><p>2.91 x 2.74 inches (74mm x 69.6mm)</p></td>\r\n</tr>\r\n<tr>\r\n<td bgcolor=\"#336699\"><p class=\"boldWhite\">Displacement:</p></td>\r\n<td bgcolor=\"#99CCFF\"><p>36.4 cubic inches (598cc)</p></td>\r\n</tr>\r\n<tr>\r\n<td bgcolor=\"#336699\"><p class=\"boldWhite\">Compression ratio:</p></td>\r\n<td bgcolor=\"#99CCFF\"><p>8.5:1</p></td>\r\n</tr>\r\n<tr>\r\n<td bgcolor=\"#336699\"><p class=\"boldWhite\">Power:</p></td>\r\n<td bgcolor=\"#99CCFF\"><p>45hp(SAE)@ 7,000rpm</p></td>\r\n</tr>\r\n<tr>\r\n<td bgcolor=\"#336699\"><p class=\"boldWhite\">Torque:</p></td>\r\n<td bgcolor=\"#99CCFF\"><p>32lb-ft@ 4,000rpm</p></td>\r\n</tr>\r\n<tr>\r\n<td bgcolor=\"#336699\"><p class=\"boldWhite\">Carburetor:</p></td>\r\n<td bgcolor=\"#99CCFF\"><p>Keihin-Seiki side-draft variable venturi w/accelerator pump</p></td>\r\n</tr>\r\n<tr>\r\n<td bgcolor=\"#336699\"><p class=\"boldWhite\">Valve train:</p></td>\r\n<td bgcolor=\"#99CCFF\"><p>Single overhead camshaft</p></td>\r\n</tr>\r\n<tr>\r\n<td bgcolor=\"#336699\"><p class=\"boldWhite\">Cooling system</p></td>\r\n<td bgcolor=\"#99CCFF\"><p>Forced air cooling by high efficiency axial flow fan located behind engine.<p></td>\r\n</tr>\r\n</table>\r\n<br>', '', 'N', '19990518', 375, 207),
('Z600View2.jpg', 6, '<p>See the <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=Z600View3.jpg\">rear view</a></p>', '', 'N', '19990518', 375, 269),
('Z600View3.jpg', 6, '<p>Note the rear window, commonly compared with a television screen.</p>\r\n\r\n<p>See the <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=Z600View2.jpg\">front view</a></p>\r\n\r\n<p><a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=Z600View1.jpg&forceCapBelow=true\">Back</a> to Honda Zot main page.', '', 'N', '19990518', 375, 241),
('NissanPulsar2.jpg', 6, '<p>I came to like this car more and more as I fixed more and more. It was a really nice car by the time it was sold with 225,000 km.</p>\r\n\r\n<p>What it really needed was a modern fuel-injected engine. I used to find that on cold mornings I needed to start the car and then go back inside to brush my teeth before heading to work as it wouldn\'t make it up the driveway when completely cold.</p>', '', 'N', '19990510', 375, 255),
('EV1big.jpg', 6, '', '', 'N', '19990518', 375, 250),
('Prius2.jpg', 6, '<p>The original Toyota Prius sold reasonably well in the US and but has not been available as a hatchback. However, the <a href=\"http://www.toyota.com/prius/minisite/index.html\r\n\r\n\">2004 model</a> is which makes it perhaps the most desirable vehicle anywhere.</p>', '', 'N', '20070828', 583, 300),
('Necar4_1.jpg', 6, 'NeCar4', 'Necar4_2.jpg', 'N', '19990518', 150, 101),
('BMWZ13side1.jpg', 6, 'BMW Z13', 'BMWZ13side2.jpg', 'N', '19990518', 150, 65),
('EV1sm.jpg', 6, 'GM EV1', 'EV1big.jpg', 'N', '19990518', 150, 100),
('Prius1.jpg', 6, 'Toyota Prius', 'Prius2.jpg', 'N', '20070828', 150, 77),
('MUM500sm.jpg', 6, 'Mitsubishi MUM500', 'MUM500big.jpg', 'N', '19990518', 150, 107),
('CCVSideSm.jpg', 6, 'Chrysler CCV', 'CCVSideLg.jpg', 'N', '19990518', 150, 76),
('CCVFrontLg.jpg', 6, '<a onclick=\"SweetAndSour.getPhoto(\'CCVSideLg.jpg\', \'Chrysler CCV\'); return false;\" href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=CCVSideLg.jpg&altText=Chrysler+CCV\"><< Back</a>', '', 'N', '19990517', 375, 236),
('CCVSideLg.jpg', 6, '<p class=\"text\">Take a look at the <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=CCVFrontLg.jpg\" onclick=\"SweetAndSour.getPhoto(\'CCVFrontLg.jpg\', \'CCV front view\'); return false;\">front view</a> and compare with the <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=2CVSide2.jpg\" onclick=\"SweetAndSour.getPhoto(\'2CVSide2.jpg\', \'Citroën 2CV\'); return false;\">Citroën 2CV</a>.</p>\r\n\r\n<p class=\"text\">Cost Reductions:</p>\r\n<ul>\r\n <li>Requires 6.5 hours to build a car vs.19 hours to build a Neon \r\n <li>Plant investment is less than $300 million, about one-third typical investment for assembly, stamping and engine plants combined \r\n <li>Eliminates the need for a satellite stamping plant and engine plant \r\n <li>Minimum number of parts/components (1,100 compared to 4,000 in conventional car) \r\n <li>Eliminates $350 million in the cost of the paint shop, including regulatory costs \r\n <li>Tooling costs reduced by 33 percent \r\n <li>Cost of the composite is less than $3.30 per kilogram ($1.50 per pound). Other types of composites used in automotive are between $11 and $22 a kilogram ($5 and $10 a pound) \r\n</ul>\r\n\r\n<table cellspacing=\"1\" width=\"550\">\r\n<tr>\r\n<th scope=\"row\">Estimated Fuel Economy:</th>\r\n<td>4.7 L/100 km/50 mpg city</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">Engine:</thd>\r\n<td>0.8L 2-cylinder, overhead-valve, air-cooled</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">Transmission:</th>\r\n<td>Four-speed manual</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">Frame:</th>\r\n<td>Full-steel</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">Brakes:</th>\r\n<td>Manual disc/drum</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">Suspension:</th>\r\n<td>Independent front and rear</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">Ground Clearance:</th>\r\n<td>203-mm/8 inches</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">Turning:</th>\r\n<td>10-meters/33-feet</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">Payload:</th>\r\n<td>363 kg/800 pounds</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">Curb Weight:</th>\r\n<td>544 kg/1,200 pounds</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">Parts:</th>\r\n<td>1,100\r\n</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">0 - 30 mph:</th>\r\n<td>6 sec.</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">0 - 60 mph:</th>\r\n<td>25 sec.</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">Top Speed:</th>\r\n<td>115 kph/70 mph</td>\r\n</tr>\r\n<tr>\r\n<th scope=\"row\">Price:</th>\r\n<td>About 10,800 DM ($6,000 U.S. dollars)</td>\r\n</tr>\r\n</table>\r\n', '', 'N', '19990518', 550, 279),
('CCVPartsSm.gif', 6, 'Four plastic mouldings make up the body.', 'CCVPartsLg.gif', 'N', '19990518', 150, 122),
('CCVPartsLg.gif', 6, '', '', 'N', '19990518', 375, 305),
('MUM500big.jpg', 6, '<p><b>Mitsubishi MUM500</b></p>\r\n<p>This car is of similar size to the Mercedes Smart car but I think this one is much prettier.</p>\r\n\r\n<table cellspacing=\"0\" width=\"522\">\r\n<tr>\r\n<th>Year:</th>\r\n<td>1993</td>\r\n</tr>\r\n<tr>\r\n<th>Seating capacity:</th>\r\n<td>2</td>\r\n</tr>\r\n<tr>\r\n<th>Engine capacity:</th>\r\n<td>500 cc</td>\r\n</tr>\r\n<tr>\r\n<th>Power:</th>\r\n<td>30 hp (22 kW)</td>\r\n</tr>\r\n<tr>\r\n<th>Transmission:</th>\r\n<td>Automatic</td>\r\n</tr>\r\n<tr>\r\n<th>Length:</th>\r\n<td>2570 mm</td>\r\n</tr>\r\n<tr>\r\n<th>Width:</th>\r\n<td>1395 mm</td>\r\n</tr>\r\n<tr>\r\n<th>Height:</th>\r\n<td>1500 mm</td>\r\n</tr>\r\n<tr>\r\n<th>Weight:</th>\r\n<td>450 kg</td>\r\n</tr>\r\n</table><br>', '', 'N', '19990518', 522, 374),
('MokeGreen1.jpg', 6, 'Leyland Mini Moke, the minimal car.', 'MokeGreen2.jpg', 'N', '20081011', 148, 100),
('MokeGreen2.jpg', 6, '<p><b>Austin/British Leyland Mini Moke</b></p>\r\n\r\n<p>I looked at a few of these when I was about to buy my first car. It would have been heaps of fun even if not practical for taking groups on church camps. I ended up getting a Ford Telstar (Maxda 626) that had been owned by the company I worked for. I was taken for a ride in one and have to say it was very windy and noisy but when you are young, it is possible to overlook these points. Canvas tops were fitted as standard but a lockable fiberglass top was also available.</p>\r\n\r\n<p>(Information originally from http://4wdonline.com/ClassicCars/Moke.html but they seemed to have moved on.)</p>\r\n\r\n<p>The Mini Moke was motoring at its most basic - a box-sided tray on wheels with a windscreen and the simplest of seats. In a warm climate it was great fun for taking down to the beach, a sort of four wheeled motorbike, but it was very draughty in the cold and wet with the \"rag top\" up and it did not offer much protection when mixing it with semi-trailers on the freeway. </p>\r\n\r\n<p>The Moke was born in response to the British Army\'s search for air-transportable vehicles. It was certainly light and compact, particularly with the windscreen down, but the front wheel drive, small wheels and low ground clearance cannot have given sufficient mobility, although experimental four-wheel-drive mokes were built - with two engines and transmissions, power at each end! </p>\r\n\r\n<p>The big military orders fell through but the Moke went on to become a cult, a real classic car. If buying a Moke: Mechanical parts are shared with the Mini and are quite readily available. The body will probably suffer from rust because of the limited weather proofing, and the vehicle may have been used on or near the beach, but it is of simple slab-sided construction and easy to work on. </p>\r\n\r\n<p>1960<br>\r\nAustin investigate a light weight minimalist vehicle suitable for air transport for the British Army. </p>\r\n<p>1963<br>\r\nMini Moke prototype built but the Army abandons interest. </p>\r\n<p>1964 August<br>\r\nCivilian Mini Moke released, based on the front wheel drive Minicar with an 850cc engine transversely mounted. </p>\r\n<p>1966<br>\r\nMoke production transferred to Australia. </p>\r\n<p>1968<br>\r\nLarger 13\" wheels raise ground clearance to 8\", 1100c engine fitted. </p>\r\n<p>1972<br>\r\nCalifornian Mokes produced with 1275cc motor for the US market. </p>\r\n<p>1981<br>\r\nNovember, Leyland Australia stops building Mokes but production is transferred to Portugal. </p>\r\n<p>1992<br>\r\nMoke production stops in Portugal. Tooling sold to Cagiva of Italy who build 1500 Mokes</p>\r\n<p>More: <a href=\"http://en.wikipedia.org/wiki/Mini_Moke\" target=\"_blank\" class=\"external\">on Wikipedia</a></p>', '', 'N', '19990518', 375, 251),
('Tango.jpg', 6, 'Tango - less than 1m wide.', '', 'N', '20030514', 150, 150),
('IsettaOpen1.jpg', 6, 'BMW Isetta. Someone left the door open.', 'IsettaOpen2.jpg', 'N', '19990606', 150, 105),
('IsettaOpen2.jpg', 6, '<p>See also <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=IsettaLeft2.jpg\">front</a> and <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=IsettaRear2.jpg\">rear</a> view. <a href=\"/technology/index.php?fuseAction=cars2\">Return</a> to innovative cars.', '', 'N', '19990606', 375, 262),
('IsettaRear2.jpg', 6, '<p><a href=\"/technology/index.php?fuseAction=cars2\">Return</a> to innovative cars.</p>', '', 'N', '19990606', 375, 247),
('IsettaLeft2.jpg', 6, '<p>If it were not for the headlights, it would be difficult to tell that this is the front. <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=IsettaRear2.jpg\">Rear</a> view </p>', '', 'N', '19990606', 375, 257),
('SmartCar.jpg', 6, 'Smart Car', '', 'N', '20030515', 150, 104),
('Necar4_2.jpg', 6, '', '', 'N', '19990518', 375, 252),
('CastilloDeSanMarcos2.jpg', 26, '<p>Castillo de San Marcos is a remarkable piece of civil engineering. Still impressive three centuries later. Also see <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=FortMatanzas2.jpg\">Fort Matanzas</a>.</p>\r\n', '', 'N', '20000117', 750, 510),
('Cathedral2.jpg', 22, '<p>It looks old but it dates from only 1915.</p>', '', 'N', '19990510', 375, 375),
('ChilavertUpClose2.jpg', 24, '', '', 'N', '19990510', 278, 375),
('ChilavertInAction2.jpg', 24, '', '', 'N', '19990523', 550, 374),
('ChilkootPass2.jpg', 20, '<p>On the way to the Yukon gold fields, gold seekers faced many challenges. Getting a ton of supplies up over the pass was just one of them.</p>', '', 'N', '19990510', 269, 375),
('ChristmasLights2.jpg', 18, '<p>This house was featured on a local news broadcast because of the HUGE number of lights. No-one does this in Australia since Christmas falls in mid-summer when the sun sets late.</p>', '', 'N', '19990530', 550, 374),
('CityAndCouncilBldg2.jpg', 12, '<p>The Denver City and Council building faces the Colorado <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=StateCapitol2.jpg\">State Capitol</a>building.</p>', '', 'N', '19990510', 550, 373),
('StateCapitol2.jpg', 12, '<p>Lan in front of the Colorado State Capitol. The roof is covered with real gold, a reminder of the gold rush of 1859 that brought a flood of prospectors into the state, many of whom stayed when the gold ran out. The top step is supposed to be exactly one mile above sea level giving the city its nickname, the \"Mile High City\".</p>', '', 'N', '19990519', 550, 374),
('Cliffs2.jpg', 11, '<p>Waves of the Pacific Ocean crash on to the cliffs below Vaucluse.</p>\r\n\r\n<p>This photo is from <a href=\"\" target=\"_blank\">http://www.dramaqueen.addr.com/Sydney.htm</a>. Please visit their site and see all the other great photos they have of Sydney.</p>\r\n\r\n<p>(You may be wondering about the tower on the most distant headland. I believe it is a vent pipe from the sewer treatment works at Malabar!)</p>', '', 'N', '19991114', 550, 412),
('Cockatoo2.jpg', 11, '<p>Cockatoos are common in our area. You can see here it is sitting on the handrail for our balcony. Unfortunately, cockatoos will chew almost anything and I had to replace part of a window frame that they attacked.</p>\r\n\r\n<p>We also get brightly-coloured lorikeets, galahs which are pink and gray and kookaburras, the ones that makes the \"laughing\" noise.</p>', '', 'N', '19990510', 375, 255),
('ColoradoNM2.jpg', 16, '<p>Colorodo National Monument near Grand Junction, Colorado is a fine collection of eroded gorges. A mini-Grand Canyon.</p>', '', 'N', '19990529', 550, 373),
('Columbines2.jpg', 12, '<p>The Columbine is the State Flower of Colorado. It grows wild in the mountains but is fragile.</p>\r\n\r\n<p>Sadly, most Americans now associate Columbine with a deadly school shooting in Colorado because it happened at Columbine High School.</p>', '', 'N', '19990510', 255, 375),
('Complex2.jpg', 12, '<p>This is our building looking north-east. Although it looks like five townhouses, there are separate units upstairs and downstairs. We live in the one hidden by the tree near the other end.</p>', '', 'N', '19990510', 550, 374),
('CrazyHorse2.jpg', 19, '<p>A 1:34 scale model in the forground shows what the mountain in the background should eventually look like. It has taken decades to shape the mountain to the point where the outline of Crazy Horse can be seen. It will take decades more to finish the work.</p>', '', 'N', '19990529', 550, 375),
('CustomsHouse2.jpg', 11, '<p>Customs House sits adjacent to Circular Quay, where Captain Philip came ashore to establish what is now Sydney. Unfortunately, the view from the water is blocked by ugly supports for the Cahill Expressway and a rail line.</p>\r\n\r\n<p>As with most of the historic buildings in the city, it is built of beautiful Sydney sandstone, probably by convict (prison) labour. I highly recomment the City of Sydney\'s web site section on <a href=\"http://www.cityofsydney.nsw.gov.au/hs_historical_buildings.asp\">historic buildings</a> for a thorough background on all the major buildings including the Town Hall, General Post Office Building, Queen Victoria Building and Fort Denison as well as a href=\"http://www.cityofsydney.nsw.gov.au/hs_customs_house.asp\">Customs House</a></p>', '', 'N', '19991114', 550, 286),
('Dad2.jpg', 23, '<p>Dad giving a speech at the wedding.</p>', '', 'N', '19990510', 255, 375),
('DadsArmy2.jpg', 7, '<p>Dad\'s Army</p>\r\n\r\n<p>From left: Captain Manwaring, Seargent Wilson, Corporal Jones and Privates Fraser, Godfrey, Pike and Walker.</p>', '', 'N', '19990519', 550, 199),
('DFTower2.jpg', 12, '<p>I\'ve always liked towers but the D & F Tower in downtown Denver is especially attractive. It was once the corner of a large department store but the store was demolished. Fortunately the tower was saved and it is now a very thin office block.</p>\r\n\r\n<p>The tower sits on the 16th Street pedestrian mall. A free bus (shown) runs up and down the mall which makes it easy to get around and to/from the main city bus terminal which is at the southern end of the mall.</p>', '', 'N', '19990510', 255, 375),
('DelicateArch2.jpg', 21, '<p>Look carefully to see the person at the base of the left side of the arch to give an idea of scale. It\'s big. As you can see, it was a foggy day so the colors are weak. This arch appears on Utah car number/licence plates.</p>', '', 'N', '19990510', 550, 374),
('DenverAirport2.jpg', 12, '<p>Denver International Airport was opened just a few weeks before we arrived in 1995. The old airport was unable to operate at normal capacity when it snowed. A completely new airport was built out on the plains and the old one closed. It opened late and way over budget and even then the automated baggage handling system did not work properly.</p>\r\n\r\n<p>The main terminal has an unusual roof made of translucent canvas. The planes dock at separate concourses so arriving passengers must take a shuttle train to get to the main terminal to collect their luggage.</p>', '', 'N', '19990510', 550, 374),
('DenverMorning2.jpg', 12, '<p>Looking west across the city toward the Rocky Mountains early in the morning. The mountain in the center of the picture is Mt. Evans which is 14,260 ft (4346 m) tall. Remarkably, there is a sealed road virtually to the top though it is closed in winter.</p>', '', 'N', '19990510', 550, 374),
('DevilsTower2.jpg', 17, '<p>Devil\'s Tower, Wyoming.</p>', '', 'N', '19990529', 255, 375),
('Dino_NM2.jpg', 27, '<p>Harper\'s Corner at the Dinosaur National Monument. Keep scrolling right to get a sense of the sweep of the view. The lookout is not quite on the tip of the promontory, so the view is not continuous and the first and second photos do not join. The left photo looks west; the three on the right look north to south-east. The river is roughly 1km (3000 ft) down and enters on the join between the 3rd and 4th photos, swings off the right before reentering the bottom-left of fourth photo. </p>', '', 'N', '20010302', 1524, 550),
('Dino_NM_Us2.jpg', 27, '<p>Lan and Peter at the Dinosaur National Monument. See the <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=Dino_NMlg.jpg\">complete view</a>. One thing you can\'t tell from the photo is how hot it is: 34degC/93F the day we visited and since our car has no air conditioner, we were both exhausted by the end of the day.</p>', '', 'N', '20010302', 750, 508),
('Stratus2.jpg', 25, '<p>Dodge Status,/p>', '', 'N', '19990604', 375, 187),
('Doughboy2.jpg', 7, '<p>It is with great sadness in my heart that I pass on the following:</p>\r\n\r\n<p>Please join me in remembering a great icon - the veteran Pillsbury Spokesman. <b>The Pillsbury Doughboy</b> died yesterday of a yeast infection and complications from repeated pokes in the belly. He was 71.</p>\r\n\r\n<p>Doughboy was buried in a lightly greased coffin. Dozens of celebrities turned out to pay their respects, including Mrs. Butterworth, Hungry Jack, the California Raisins, Betty Crocker, the Hostess Twinkies, and Captain Crunch. The gravesite was piled high with flours.</p>\r\n\r\n<p>Longtime friend, Aunt Jemima, delivered the eulogy, describing Doughboy as a man who never knew how much he was kneaded. Doughboy rose quickly in show business, but his later life was filled with turnovers. He was not considered a very "smart" cookie, wasting much of his dough on half-baked schemes. Despite being a little flaky at times, he was, as a crusty old man, still considered a roll model for millions.</p>\r\n\r\n<p>Toward the end it was thought he would rise again, but alas, he was no tart.</p>\r\n\r\n<p>Doughboy is survived by his wife, Play Dough; two children, John and Jane Dough, plus one she has in the oven. Doughboy is also survived by his elderly father, Pop Tart.</p>\r\n\r\n<p>The funeral was held at 3:50 for 20 minutes.</p>', '', 'N', '19990510', 255, 375),
('Downtown.jpg', 12, '<p>Downtown Denver.</p>\r\n<p><a onclick=\"SweetAndSour.getPhoto(\'Aerial2.jpg\', \'\'); return false;\" href=\"javascript:void(0)\">\r\n<< Back\r\n</a></p>', '', 'N', '19991111', 1000, 1000),
('ElkStatue2.jpg', 16, '<p>An elk statue at Steamboat Springs. These magnificient creatures apparently roamed the praries as well as the mountains but human encroachment on their habitat means they are now found wild only in remote wilderness areas.</p>', '', 'N', '19990529', 375, 255),
('Epcot2.jpg', 26, '<p>At Disney\'s Epcot near Orlando.</p>', '', 'N', '20000117', 751, 510),
('BanyanTree2.jpg', 26, '<p>I believe this fine example was at the Miami Parrot Jungle.</p>', '', 'N', '20000107', 374, 550),
('BanyanTree1.jpg', 26, 'The remarkable Banyan tree. ', 'BanyanTree2.jpg', 'N', '20000107', 102, 150),
('GeorgetownLoop2.jpg', 12, '<p>Mining has played a big part in the development of Colorado. Many of the bigger mines were served by narrow-gage railways but all but a few have closed down. This one at Georgetown is a short drive from Denver and carries tourists during the summer. Our friend Steve works there on weekends which is handy as we can ride for free!</p>\r\n\r\n<p>The line is interesting because of the loop used to gain height (no room on the mountain to turn back and forth) and the locomotove is interesting because the steam cylinders are vertical with a drive shaft powering the wheels, much like a rear-wheel drive car.</p>', '', 'N', '19990510', 550, 373),
('Snow2.jpg', 12, '<p>The Colorado Rocky Mountains get a lot of snow such as this from some unidentified place. I believe the ski fields can get 30 ft (10 m) of snow in a season so it is not surprising that people come from everywhere to ski here.</p>\r\n\r\n<p>Despite the reputation, Denver itself gets much less. Normally we get a snow storm which may leave perhaps 2\" (5 cm) of snow but then within a few days, it has all melted and the roads are dry until the next storm.</p>', '', 'N', '19990510', 550, 374),
('I70Tunnel2.jpg', 12, '<p>Interstate 70 is the main road heading west out of Denver and it travels through the 1.5 mile (2.4 km) Eisenhower Tunnel at 11,013 ft (3356 m). Vehicles carrying hazardous loads must take the old road over Loveland Pass at 11.990 ft (3654 m). At these altitudes, cars are noticably less powerful since there is less oxygen in the air.</p>\r\n\r\n<p>This shot is remarkable because there are no vehicles in the picture. Normally it is carries heavy traffic and every attempt is made to keep it open in winter but once or twice each season a heavy snow closes it for a half-day or so.</p>', '', 'N', '19990510', 550, 374),
('UpstairsUnit2.jpg', 12, '<p>Ours is the upstairs unit, or <i>condominium</i> as Americans call it. You can see Lan on the balcony.</p>\r\n\r\n<p>It looks most impressive from the front but a walk around the back reveals that the building is actually largely wooden and poorly built. Actually, it\'s falling apart. When we moved in as renters, the ceiling was opened up to install some beams to stop the center of the building sagging. We now need to deal with the supports for the garage roofs which are sinking into the dirt because proper foundations were not built.</p>', '', 'N', '19990510', 550, 375),
('OperaBridge1.jpg', 11, 'The Sydney Opera House and Harbour Bridge. Follow this link to see two more panoramas.', 'OperaBridge2.jpg', 'N', '19991113', 150, 42),
('LanGoodWeekend2.jpg', 7, '<p>Lan, under the clothes line, reading the <i>Good Weekend</i> magazine supplement to the <i>Sydney Morning Herald</i>. Lan wanted to study outside but since it was hot, she moved her chair under the drying clothes so it was comfortably cool. She was supposed to be studying but I caught her doing some recreational reading!</p>', '', 'N', '20030524', 750, 501),
('OperaBridge2.jpg', 11, '<p>The Sydney Opera House and the Harbour Bridge looking west.</p>', '', 'N', '19991113', 500, 138),
('City2.jpg', 11, '<p>The view from the northern side of the harbour looking south toward the city. A four lane tunnel runs under the water here to supplement traffic flow on the Bridge.</p>', '', 'N', '19991113', 500, 136),
('NorthSydney2.jpg', 11, '<p>An aerial view of the Bridge looking north-west toward North Sydney & Waverton.</p>', '', 'N', '19991113', 500, 178),
('HarbourBridge2.jpg', 11, '<p>Completed in 1932, the Sydney Harbour Bridge is a magnificent piece of engineering and a thrill to travel over.</p>\r\n\r\n<p>Here are some great links:</p>\r\n<ul>\r\n<li><a href=http://www.sydney.com.au/bridge.htm target=\"_blank\">vital statistics</a></li>\r\n<li><a href=\"http://www2.eng.cam.ac.uk/~jbf26/sydney.html\" target=\"_blank\">photos during construction</a></li>\r\n\r\n</ul>\r\n\r\n<p>You can climb the south-east pylon for A$1.50 but those feeling brave (and rich - A$98) enough, can now climb to the top of the arch!</p>', '', 'N', '19991113', 228, 202),
('HarbourBridge1.jpg', 11, 'The Sydney Harbour Bridge spans the harbour.', 'HarbourBridge2.jpg', 'N', '19991113', 150, 133),
('HarbourNight2.jpg', 11, '<p>This stunning photo of the Bridge and city skyline is from <a href=\"http://www.dramaqueen.addr.com/Sydney.htm\" target=\"_blank\">http://www.dramaqueen.addr.com/Sydney.htm</a>. \r\nPlease visit their site too and see all the other great photos they have of Sydney.</p>', '', 'N', '19991113', 700, 458),
('HarbourNight1.jpg', 11, 'The bridge & harbour at night.', 'HarbourNight2.jpg', 'N', '19991113', 150, 98),
('Greenwich1.jpg', 11, 'An aerial view of the harbour looking east toward the Pacific..', 'Greenwich2.jpg', 'N', '19991113', 149, 102),
('Greenwich2.jpg', 11, '', '', 'N', '19991113', 354, 395),
('BondiBeach1.jpg', 11, 'Surfers, swimmers and sun- bathers enjoy Bondi Beach (topless at the southern end).', 'BondiBeach2.jpg', 'N', '19991114', 150, 73),
('Cliffs1.jpg', 11, 'Sydney\'s suburbs extend all the way to the cliffs and beaches on the ocean. ', 'Cliffs2.jpg', 'N', '19991113', 150, 103),
('OlympicLogo.gif', 11, 'Sydney hosted the 2000 Olympic Games. It was a huge success though the facilities are now get little use.', '', 'N', '19991114', 108, 102),
('CustomsHouse1.jpg', 11, 'Since Sydney is Australia\'s oldest city, there are many historic buildings such as this one, Customs House. Click on the photo to find out about some of the others.', 'CustomsHouse2.jpg', 'N', '19991114', 150, 78),
('Taronga1.jpg', 11, 'A \"hefalump\" at Taronga Zoo overlooking the harbour.', 'Taronga2.jpg', 'N', '19991113', 53, 150),
('GladesvilleBridge1.jpg', 11, 'Sydney has two other spectacular bridges as well as the Harbour Bridge. One is the Gladesville Bridge ...', 'GladesvilleBridge2.jpg', 'N', '19991114', 150, 98),
('GladesvilleBridge2.jpg', 11, '<p>At the time it was built in the middle 1960s, the Gladesville Bridge was the longest concrete in the world. It was built to allow oil tankers to pass underneath to reach a dock just upstream but the facility has since been closed.</p>\r\n\r\n<p>The Gladesville Bridge is the second major harbour crossing, the first, of course, being the Harbour Bridge which is about 10 km further east.</p>', '', 'N', '19991114', 438, 287),
('GlebeIslandConst.jpg', 11, '<p>This dramatic shot shows the Glebe Island Bridge during construction but fairly close to completion, at least on this, the western side. The main span of this \"cable stay\" bridge is 345 m (1130 ft).</p>', '', 'N', '19991114', 500, 254),
('GlebeIsland1.gif', 11, '... and this one, the fairly new Glebe Island Bridge.', 'GlebeIslandConst.jpg', 'N', '19991114', 150, 95),
('3sisters1.jpg', 11, 'The \"Three Sisters\", a trio of rocky outcrops in the Blue Mountains to the west of Sydney.', '3sisters2.jpg', 'N', '19991113', 150, 102),
('House1.jpg', 11, 'This is our house in Sydney as seen from the garden. The road is up a long, steep driveway behind the house. ', 'House2.jpg', 'N', '19990520', 150, 102),
('House2.jpg', 11, '<p>This is our house in Sydney. Keeping the garden under control is a constant battle, one that I don\'t enjoy fighting. When we bought the house, it had been neglected for several years and the \"garden\" featured chest-high weeds and piles of cut-up trees from a big storm that swept though in 1990 (?). We removed 6 tonnes of rubbish!</p>', '', 'N', '19990510', 375, 255),
('Cockatoo1.jpg', 11, 'We live in a part of Sydney with lots of big trees and there are lots of native birds such as this cockatoo. They are very noisy and chew timber window frames!', 'Cockatoo2.jpg', 'N', '19990520', 150, 102),
('Taronga2.jpg', 11, '<p>Taronga Park Zoo has a wonderful location on the northern side of the harbour overlooking the city. Feries are the best way to get to the zoo and many other places around the harbour. This \"hefalump\" (or elephant if you haven\'t read \r\n<i>Winnie the Pooh</i>) looks a little bored though.</p>', '', 'N', '19991114', 320, 905),
('Columbines1.jpg', 12, '', 'Columbines2.jpg', 'N', '19990510', 102, 150),
('DFTower1.jpg', 12, '', 'DFTower2.jpg', 'N', '19990510', 102, 150),
('Complex1.jpg', 12, '', 'Complex2.jpg', 'N', '19990510', 150, 102),
('UpstairsUnit1.jpg', 12, '', 'UpstairsUnit2.jpg', 'N', '19990510', 150, 102),
('Aerial1.jpg', 12, '', 'Aerial2.jpg', 'N', '19991027', 102, 102),
('StateCapitol1.jpg', 12, '', 'StateCapitol2.jpg', 'N', '19990520', 150, 102),
('CityAndCouncilBldg1.jpg', 12, '', 'CityAndCouncilBldg2.jpg', 'N', '19990510', 150, 102),
('I70Tunnel1.jpg', 12, '', 'I70Tunnel2.jpg', 'N', '19990510', 150, 102),
('Snow1.jpg', 12, '', 'Snow2.jpg', 'N', '19990510', 150, 102),
('GeorgetownLoop1.jpg', 12, '', 'GeorgetownLoop2.jpg', 'N', '19990510', 150, 102);
INSERT INTO `photos` (`photoName`, `folderID`, `caption`, `linkedImg`, `linkToFullSize`, `version`, `width`, `height`) VALUES
('DenverAirport1.jpg', 12, '', 'DenverAirport2.jpg', 'N', '19990510', 150, 102),
('KitchenViewA1.jpg', 11, 'Kitchen renovation. Looking NW - BEFORE', 'KitchenViewA2.jpg', 'N', '19990519', 150, 102),
('KitchenViewA2.jpg', 11, '<p>The biggest problem in the old kitchen was lack of bench space. You can see in this photo that the hole for the refrigerator is very wide, even allowing for our small \'fridge, a wall-oven is used instead of an underbench model and the microwave oven is on the bench because there is nowhere else to put it. Also, the sink has two full bowls and draining boards on both sides.</p>\r\n\r\n<p>The floor is covered by a disgusting green vinyl which obviously started lifting as the seam between the two rolls was nailed down every 1.5 cm or so, both sides. It was an awful job getting them all out. </p>', '', 'N', '19990510', 551, 374),
('KitchenViewAA1.jpg', 11, 'Looking NW - AFTER. The wall oven was removed to give a lot more benchspace.', 'KitchenViewAA2.jpg', 'N', '19990510', 102, 150),
('KitchenViewAA2.jpg', 11, '<p>The new kitchen features an underbench oven and a glass/ceramic cooktop which looks fabulous on the granite benchtop. The white bar over the oven is the slimline rangehood that turns the light and fan on when pulled out.</p>\r\n\r\n<p>I did some research on 500 liter refrigerators which is about as big as they go before going to the side-by-side style which is expensive and therefore uncommon in Australia. I made the hole wide enough and tall enough to handle all ten models that Choice magazine tested but the new tenants brought their \'fridge all the way from South Africa and it didn\'t fit! Bother.</p>\r\n\r\n<p>I was surprised how long it took to find a decent rangehood. All but this one had either controls that were hard to use (eg. tall people had to bend down to even see them) or the lights were pathetic. </p>', '', 'N', '19990510', 255, 375),
('KitchenViewB1.jpg', 11, 'Looking NE - BEFORE.', 'KitchenViewB2.jpg', 'N', '19990510', 150, 102),
('KitchenViewB2.jpg', 11, '<p>On this side ot the kitchen, an extra-wide cooktop was fitted but it only had 3 elements. Even more stupid, the exhaust fan was on the diagonally opposide of the kitchen.</p>\r\n\r\n<p>It\'s difficult to see but the cupboards are standing on \"legs\" about 20 cm (8\") off the floor making the area underneath hard to keep clean but great for cockroaches.</p>\r\n\r\n<p>There are no cupboards fitted on the wall above this bench.</p>', '', 'N', '19990510', 549, 374),
('KitchenViewBB1.jpg', 11, 'Looking NE - AFTER.', 'KitchenViewBB2.jpg', 'N', '19990510', 102, 150),
('KitchenViewBB2.jpg', 11, '<p>In the new kitchen, the area previously occupied by the cooktop is now open bench space, the floor cupboards go all the way to the floor and there is a new cupboard over the bench with glass doors. Since there is no room for storage in the dining area, this is the obvious place to store glasses and plates. The wall cupboard is 1000 mm tall (39\") which means the top shelf is too high for most people to reach but it will be good for vases and items used infrequently. A slimline fluorescent light is fitted under the cupboard so that you don\'t work in your own shadow when preparing food on the benchtop.</p>\r\n\r\n<p>The splashback looks fabulous and is a continuous sheet so there are no grout joins to gather grease as there would be if tiles had been used. It looks like glass but I was disappointed to find it scratches relatively easily. Since it is glued to the wall, replacing it will be a problem. </p>', '', 'N', '19990510', 256, 375),
('KitchenViewC1.jpg', 11, 'Looking SE - BEFORE..', 'KitchenViewC2.jpg', 'N', '19990510', 102, 150),
('KitchenViewC2.jpg', 11, '<p>The old pantry was behind the door. The shelves were of bare pineboard and so it was not surprising that after 27 years, they were sticky and falling apart.</p>\r\n\r\n<p>The open door to the left goes to the rest of the house; the laundry is visible through the door to the right of the pantry. </p>', '', 'N', '19990510', 255, 375),
('KitchenViewCC1.jpg', 11, 'Looking SE - AFTER..', 'KitchenViewCC2.jpg', 'N', '19990510', 102, 150),
('KitchenViewCC2.jpg', 11, '<p>This is a lousy photo but you can see that the pantry has been split in two with a hole made to fit the microwave oven, thus getting it off the kitchen bench. The pantry doors match the cupboard doors in the rest of the kitchen.</p>\r\n\r\n<p>I demolished the shelves and interior walls of the old pantry and installed a new pantry which is effectively free-standing though I did screw it back to the surrounding timber frame. I discovered that the wall to the left of the pantry was nowhere near vertical so filling the gap elegantly wasted a lot of time. I did all the work on the pantry but a kitchen company (slowly) installed the benchtops and other cabinets.</p>\r\n\r\n<p>Getting power to the microwave was also a problem as I didn\'t want to disturb the cement board walls in the laundry as I knew I\'d never be able to get them to look neat again. I ended up drilling through 15 cm (6\") of very hard concrete so the electrician could bring a cable up from under the floor.</p>', '', 'N', '19990510', 255, 375),
('Frame1.jpg', 11, 'I was quite proud of this frame I built above the cupboards to support the plasterboard and hide the exhaust ducting.', 'Frame2.jpg', 'N', '19990520', 150, 112),
('Frame2.jpg', 11, '<p>I installed the ductwork for the rangehood and used the hole for the existing exhaust fan. Ideally I would have gone directly through the wall but it is brick so making a neat hole would have been impossible unless I had paid someone to come along with a diamond saw.</p>\r\n\r\n<p>With ductwork as ugly as this, it was essential to hide it so I built a frame above the wall cupboards up to the ceiling and then covered it with plasterboard.</p>', '', 'N', '19990520', 550, 374),
('FarmingtonHills2.jpg', 14, '<p>Our first home in America after we left the hotel was this apartment complex in Farmington Hills, not far from Lan\'s office. It looks like townhouses but we just had downstairs.</p>', '', 'N', '19990529', 375, 255),
('Farnsworth2.gif', 7, '', '', 'N', '20010217', 239, 209),
('FawltyTowers.gif', 7, 'Fawlty Towers: \"Don\'t mention the war!\"', '', 'N', '19990519', 150, 173),
('FishCreekFalls2.jpg', 16, '<p>Fish Creek Falls near Steamboat Springs.</p>', '', 'N', '19990529', 255, 375),
('FortMatanzas2.jpg', 26, '<p>Fort Matanzas is 15 miles (25 km) south of St.Augustine and guards the inland waterway leading to the <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=CastilloDeSanMarcos2.jpg\">Castillo de San Marcos</a> and it did its job repelling a British force in 1742. Matanzas is Spanish for massacre for the French force that was captured and killed nearby in 1565. The watchtower seen in the other photograph is at the bottom right.</p>', '', 'N', '20000117', 750, 510),
('FortPulaski2.jpg', 26, '<p>The unexpected loss of Fort Pulaski in 1861 demonstrated the power of new rifled cannon. </p>', '', 'N', '20000117', 750, 510),
('FortMatanzasUs2.jpg', 26, '<p>Fort Matanzas is on an island and the boat driver, Mr Dick Osrini, has been bringing tourists here for 27 years. We were his only customers on the mid-morning trip, so he took this photo and explained the features of the fort. See an <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=FortMatanzas2.jpg\">aerial view</a>..</p>', '', 'N', '20000108', 750, 510),
('FriendsAtTNA2.jpg', 24, '<p>The sign says “To the quiet one ...”. There was another Peter at the company and he made everyone seem quiet by comparison.</p>\r\n\r\n<p>Ken taught me a wonderful comment that can be made about all workplaces but it has to be said with a straight face: <i>“It’s a good thing they pay us - I wouldn\'t come otherwise”</i>!</p>\r\n\r\n<p>Tony has some great advice for any computer problem: <i>“Turn it off. Turn it back on.”</i></p>\r\n<p>Also, an <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=ActionAtTNA.jpg\" onclick=\"SweetAndSour.getPhoto(\'ActionAtTNA.jpg\', \'Action at TNA\'); return false;\">action shot</a>.</p>', '', 'N', '19990609', 500, 375),
('IsraelMap.jpg', 7, 'Click for the current map from the CIA.', '', 'N', '20010217', 150, 323),
('Partition2.jpg', 7, '', '', 'N', '20010217', 780, 1530),
('Settlements.gif', 7, 'Settlements everywhere! Click to see the original <strong>1996</strong> document on the UN site.', '', 'N', '20010217', 150, 200),
('FrozenMist2.jpg', 4, '<p>Arches National Park was cold and misty the day we visited. This plant has been covered by tiny droplets of mist which have then frozen. It looked like a plant made of ice crystals. Pretty.</p>', '', 'N', '19990510', 550, 373),
('GeneralMotors2.jpg', 14, '<p>Detroit is of course the center of the American car industry.</p>', '', 'N', '19990529', 375, 255),
('GoldenGateFog2.jpg', 18, '<p>The Golden Gate bridge as we saw it - or didn\'t see it. You can see the roadway leading to the bridge on the left of the photo but the bridge itself is shrouded by fog.</p>', '', 'N', '19990530', 357, 255),
('GoldenGateSun2.jpg', 18, '<p>The Golden Gate bridge. The bridge builders made a special arch over the fort below as the original plan for the bridge called for the fort\'s demolition.</p>', '', 'N', '19990530', 550, 375),
('Goodies2.jpg', 7, '<p>The Goodies: Bill Oddie, Graham Garden and Tim Brook-Taylor who continued to use their real names in the show.</p>', '', 'N', '19990519', 550, 339),
('GrandCanyon2.jpg', 25, '', '', 'N', '19990510', 550, 374),
('MadridBack2.jpg', 18, '', '', 'N', '19990530', 550, 379),
('Poinsettia3.jpg', 26, '<p>The Queen Mary, now permanently moored at Long Beach, just south of Los Angeles. </p>', '', 'N', '20000117', 374, 550),
('RockyMtnNP2.jpg', 28, '<p>Rocky Mountain National Park with snow covered roads. Beautiful. Incidentally, our car is still running but it is getting tired, having recently passed 140,000 miles (or 225,000 km which sounds worse). It makes noises that worry me but I cant identify and has started blowing smoke. I considered converting it to electric but it would cost more than replacing the engine and transmission. Well have to get a new car very soon.</p>', '', 'N', '20020817', 745, 513),
('PetrifiedStump2.jpg', 26, '<p>My cousin Diana admires the petrified stump of an ancient redwood tree. Florissant Fossil Beds National Monument, CO.</p>', '', 'N', '20000117', 750, 510),
('PetrifiedLog2.jpg', 19, '<p>An old log. A really, really old log.</p>', '', 'N', '19990529', 254, 376),
('PeterMesaVerde2.jpg', 21, '<p>This photo shows how the buildings were constructed under overhangs in the cliff-face.</p>', '', 'N', '19990510', 550, 374),
('PeterGoldenGate2.jpg', 25, '<p>The sun is in my eyes. You might like to compare this <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=GoldenGateFog2.jpg\">earlier photo</a> with the on in the letter dated 2 Mar 96.</p>', '', 'N', '19990510', 375, 255),
('GreatSandDunes2.jpg', 16, '<p>The Great Sand Dunes National Monument was perhaps the biggest surprise in Colorado. It was like being at the beach except the nearest ocean is perhaps 1000 miles (1600 km) away.</p>', '', 'N', '19990529', 376, 256),
('GuardAtSolvang2.jpg', 18, '', '', 'N', '19990530', 254, 375),
('FloridaRoute2.jpg', 26, '<p>We drove 2979 miles (4795 km) in 19 days in a Dodge Neon. It was a super bargain at $94.99 per week with Dollar rent-a-car. Actually we only asked for an \"economy\" car which should have been a Hyundai Accent, the replacement for our car. When we arrived at the airport, we were offered an upgrade to this car, or something even bigger for $5 per day but we said no. However, when we got out to the lot, the gave us the Neon anyway and there were no Hyundais in the car park.</p>', '', 'N', '20000118', 264, 441),
('HollywoodStar2.jpg', 18, '', '', 'N', '19990530', 255, 375),
('HomeImprovementLg.jpg', 7, '<p>Wilson is behind the fence, Jill, Tim and Al are in front of the fence and (from left) Mark, Randy and Brad in front.</p>\r\n<p>We love Al.</p>', '', 'N', '19990519', 360, 450),
('HooverDam2.jpg', 25, '<p>In front of Hoover Dam. Notice how short Lan\'s hair was at that time.</p>', '', 'N', '19990510', 375, 256),
('Houseboats2.jpg', 25, '', '', 'N', '19990510', 550, 374),
('HeidiSm.jpg', 7, 'Heidi.', 'HeidiLg.jpg', 'N', '19990519', 98, 150),
('HeidiLg.jpg', 7, '<p>I had to include a separate photo of Heidi, whose real name is Debbie Dunning, as you will notice she was left out of the photo above. This is the only reason, it has nothing at all to do with her being attractive.</p>\r\n<p>[2020 update: This page was one of the first I created for the site and dates from May 1999, a time of 28 and 56k modems. At the time the only photo I could find of her was thumbnail size - and b so I found a new one.]</p>', '', 'N', '19990519', 736, 1124),
('FinancialSuccess.png', 7, '', '', 'N', NULL, NULL, NULL),
('Goodies1.jpg', 7, '"Goodie, goodie, yum, yum"', 'Goodies2.jpg', 'N', '19990519', 150, 92),
('AreYouA1.jpg', 7, 'Management.', 'AreYouA2.jpg', 'N', '19990519', 150, 100),
('AreYouC1.jpg', 7, 'The floor staff to ask \"Are you being served?\"', 'AreYouC2.jpg', 'N', '19990519', 150, 112),
('DadsArmy1.jpg', 7, 'A few brave men.', 'DadsArmy2.jpg', 'N', '19990519', 150, 54),
('HomeImprovementSm.jpg', 7, 'The Home Improvement team—with the exception of the ToolTime girl.', 'HomeImprovementLg.jpg', 'N', '19990519', 121, 150),
('Hyundai2.jpg', 15, '<p>Our little car, a 1991 Hyundai Excel, sitting at the back of townhouse we used to live in. It is our only car. Americans see this sort of car as being appropriate only for 16-year- olds and poor people but it\'s been a great car. We bought it with 26,000 miles on it and we passed 100,000 in October 99.</p>\r\n\r\n<p>We get 40 mpg (5.9 L/100 km) around the city, though about half of that is on urban freeways which helps. If only it had an air conditioner. </p>\r\n\r\n<p>May 2003 update: To my great surprise, it passed its emissions test. I was hoping it would fail so we could get rid of it. That meant we needed to fix the horrible squeaking noise in the front-right suspension. Unfortunately, I thought it was the strut so had them replaced but to my horror, the noise was still there. I took it back and had them diagnose the problem and they said it would cost $213 so I gave them approval to do it. Then when I went to get the car they said something else had to be replaced so the bill was $333 making a total of $520. Had I known it would cost this much, we would have given it away and bought something else. Now we are stuck with it a little longer. It really needs a new engine as it now blows smoke when you start it but even if that was fixed, it still has no air conditioner, a huge crack in the windscreen and needs new gas struts to hold up the rear hatch. It is almost up to 150,000 miles of which we have done 123,000 which isn\'t bad for a car that only cost a little more than $3000.</p>', '', 'N', '19990529', 375, 255),
('I40NewMexico2.jpg', 25, '', '', 'N', '19990510', 550, 374),
('IceFishing2.jpg', 14, '<p>The man in the background is ice fishing. People go out on to the frozen lakes with a drill perhaps 6\" (15 cm) in diameter, make a hole in the ice and then lower their line. This is a small lake connected to Lake St Claire.</p>', '', 'N', '19990529', 375, 255),
('Icicle2.jpg', 16, '<p>Lan shows off an icicle plucked off our own building.</p>', '', 'N', '19990529', 375, 255),
('Illuminate2.jpg', 25, '<p>This detail is from an Italian instead of Flemmish illuminated manuscript but you get the idea - hand drawn lettering complimented by colored illustrations.</p>', '', 'N', '19990524', 184, 374),
('InsideMall2.jpg', 22, '', '', 'N', '19990510', 550, 374),
('JapaneseGardens2.jpg', 18, '<p>An interesting bridge in the Japanese gardens but it\'s really difficult to actually get across it.</p>', '', 'N', '19990530', 356, 255),
('LadiesInWaiting2.jpg', 18, '<p>Lan makes a friend but makes it hard for the lady to read.</p>', '', 'N', '19990530', 255, 375),
('LakeStClair2.jpg', 14, '<p>Lake St Clair is not one of the \"Great Lakes\" but it is still big enough that you can\'t see the shore on the other side. We had a lot of difficulty finding a place to get to the water as it seemed the entire shoreline within suburbs of Detroit was privately-owned land with no parks or boat ramps.</p>', '', 'N', '19990529', 375, 255),
('LanAnchor2.jpg', 2, '<p>Lan suffered from a \"frozen shoulder\" in 1994 which delayed our departure to America. One of my co-workers noticed this photo on my desk and commented, <i>\"I know why your wife has a sore shoulder - she keeps lifting heavy objects\"</i>!</p>', '', 'N', '20000819', 750, 509),
('LanAndJeanP2.jpg', 2, '<p>Jean wanted to help some new migrants to Australia get settled and took Lan under her wing, helping her to integrate with society. She taught her conservative dress sense too!</p>', '', 'N', '20000819', 374, 550),
('LanAndXuan2.jpg', 27, '<p>Lan and cousin Xuan at the Chicago Botanical Gardens. You can see they are both wearing jackets and the pale green tree is swaying in the breeze. We saw a bridal party having their photos taken - the bridesmaids had bare arms and were doing their best to appear relaxed while not turning blue! See also Lan in a <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=LanInCarraige2.jpg\">horse-drawn carriage</a>.</p>', '', 'N', '20010303', 750, 510),
('LanAtCanyon2.jpg', 4, '', '', 'N', '19990509', 255, 375),
('LanAtDisney2.jpg', 2, '<p>When Lan was in the refugee camp, she desparately wanted to go to America since she had a distant relative there and knew no-one in Australia. Just two years after arriving in Australia, she set off to the US (seen here in Disneyland) to look around. . By then she was somewhat established in Australia working 2 jobs and studying and had bought a townhouse and with the need to get INS permission,it got too difficult and she stayed.</p>', '', 'N', '20000819', 750, 511),
('LanAtBGardens2.jpg', 20, '', '', 'N', '19990509', 375, 255),
('LanBlackCanyon2.jpg', 17, '', '', 'N', '19990529', 255, 375),
('LanCitizen2.jpg', 2, '<p>Are they in front of a bike shop?</p>', '', 'N', '20000819', 750, 511),
('LanCrocodile1.jpg', 2, 'As you probably know, the ability to wrestle crocodiles is an essential requirement of Australian citizenship. Here she is giving a demonstration in Thailand in 1991 after we had visited Vietnam.', 'LanCrocodile2.jpg', 'N', '20000820', 101, 150),
('LanCrocodile2.jpg', 2, '', '', 'N', '20000819', 509, 750),
('LandscapeArch2.jpg', 21, '<p>Landscape Arch spans 93m but it\'s hard to appreciate the scale from this photo. The trees underneath are \"full size\" though they look like bushes.</p>', '', 'N', '19990510', 550, 373),
('LanEighteen2.jpg', 2, '', '', 'N', '20000819', 511, 750),
('LanGlacier2.jpg', 20, '', '', 'N', '19990510', 550, 376),
('LanInCarraige2.jpg', 4, '', '', 'N', '20010302', 750, 509),
('LanIris2.jpg', 2, '', '', 'N', '20000819', 750, 511),
('LanLobster2.jpg', 2, '', '', 'N', '20000819', 750, 507),
('LanMesaVerde2.jpg', 21, '<p>Lan at the Mesa Verde ruins. The hole to Lan\'s right is a \"kiva\" or ceremonial room where they may have prayed for healing or a good crop. It would have been covered by a roof of wooden beams and mud and entrance was by ladder. Behind Lan are the residential rooms.</p>', '', 'N', '19990510', 550, 373),
('LanMtRushmore2.jpg', 19, '<p>Five important people in American history are shown here on Mount Rushmore.</p>', '', 'N', '19990529', 375, 235),
('LanAndJeanP1.jpg', 2, 'Lan with the late Jean Peacock. ', 'LanAndJeanP2.jpg', 'N', '20000820', 102, 150),
('LanSixteen2.jpg', 2, '<p>Back to <a href=\"/whoWeAre/index.php?fuseAction=oldPhotosLan\">historical photos</a>.</p>', '', 'N', '20000819', 507, 750),
('LanOnBike2.jpg', 19, '<p>Lan on her beautiful bike on the driveway of our townhouse. (Have you ever wondered why we park on a <i>driveway</i> and drive on a <i>parkway</i>?)</p>', '', 'N', '19990529', 356, 255),
('LanChild2.jpg', 2, '<p>Can you tell which one is Lan? If not, <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=Answer.jpg\">here she is</a>.</p>', '', 'N', '19990510', 550, 375),
('LansFamily1.jpg', 2, 'Lan\'s parent\'s family - with 11 children! And they wonder why they were poor.', 'LansFamily2.jpg', 'N', '20000820', 150, 101),
('LansFamily2.jpg', 2, '<p>Lan is on the left. See <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=LanSixteen2.jpg\">close up</a>.', '', 'N', '20000819', 750, 509),
('LanEighteen1.jpg', 2, 'Lan at eighteen.', 'LanEighteen2.jpg', 'N', '20000820', 102, 150),
('LanAtDisney1.jpg', 2, 'Lan visiting America in 1983.', 'LanAtDisney2.jpg', 'N', '20000819', 150, 102),
('LanCitizen1.jpg', 2, 'Lan became an Australian citizen, 24 September, 1984. Here she is after the ceremony with the Mayor of Ashfield.', 'LanCitizen2.jpg', 'N', '20000820', 150, 102),
('LanLobster1.jpg', 2, 'Lan bought a soft toy for a neice and discovered it made quite a dandy necklace. This photo was taken in the back garden of Lan\'s townhouse after we were married.', 'LanLobster2.jpg', 'N', '20000820', 150, 101),
('LanIris1.jpg', 2, 'Lan is a keen gardener but in our townhouse at Auburn in Sydney, most of the back garden was concrete so her plants were mainly in pots. Here is an iris she grew.', 'LanIris2.jpg', 'N', '20000820', 150, 102),
('LanAnchor1.jpg', 2, 'Lan at South Head, Sydney.', 'LanAnchor2.jpg', 'N', '20000820', 150, 101),
('Answer.jpg', 2, '<p>Don\'t you want to pick her up and hug her?</p>', '', 'N', '19990510', 127, 187),
('Zoro2.jpg', 16, '<p>Zoro says it was smelly inside the public toilets!</p>', '', 'N', '19990529', 375, 255),
('YosemiteFalls2.jpg', 25, '', '', 'N', '19990510', 550, 374),
('WeddingChurch1.jpg', 2, 'At the church.', 'WeddingChurch2.jpg', 'N', '20080511', 102, 150),
('VietnameseDress1.jpg', 2, 'At the reception.', 'VietnameseDress2.jpg', 'N', '19990510', 102, 150),
('WeddingCake1.jpg', 2, 'Our wedding cake.', 'WeddingCake2.jpg', 'N', '19990510', 102, 150),
('RenoRd1.jpg', 2, 'Snow clearing duties in Washington D.C.', 'RenoRd2.jpg', 'N', '20000819', 150, 101),
('Wetland2.jpg', 26, '<p>Sawgrass prarie in the Everglades National Park. </p>', '', 'N', '20000117', 750, 511),
('WeekiWatchie2.jpg', 26, '<p>There is something wrong with the picture of a mermaid and King Neptune but I\'m not sure what it is ...</p>', '', 'N', '20000117', 750, 510),
('Stilts1.jpg', 2, 'Not tall enough.', 'Stilts2.jpg', 'N', '20000819', 102, 150),
('RenoRd2.jpg', 2, '<p>I lived at 4610 Reno Rd. Washington DC in 1969 and 1970 when I was 5 and 6. Here I am shovelling snow on Christmas Day 1969. It appears that my younger sister wants to join in but I am not willing to share the shovel. </p>', '', 'N', '20000819', 749, 509),
('Stilts2.jpg', 2, '<p>The house had rear-lane access and here I am on stilts outside the garage. The shadow on the garage door doesn\'t appear to be me. Whenever it is that I get back to the city, I intend knocking on the door to see if I can have a look around again. One day.</p>', '', 'N', '20000819', 373, 550),
('VietnameseDress2.jpg', 2, '<p>This photo shows the Vietnamese wedding dress Lan wore at the wedding reception. The girl standing between us is Alanna who acted as an unofficial bridesmaid on the day.</p>\r\n\r\n<p>Here\'s another picture from the <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=WeddingRestaurant2.jpg\">reception.</p>', '', 'N', '19990510', 254, 375),
('WeddingRestaurant2.jpg', 2, '<p>For the reception at the Yum Sing Chinese Restaurant in Sydney\'s Chinatown, Lan changed into a traditional Vietnamese wedding dress. </p>\r\n\r\n<p>The other people in the photo are Tim J. plus Jane and Andrew L.</p>\r\n\r\n<p>Back to <a href=\"/whoweare/index.php\">who we are</a>,/p>', '', 'N', '19990510', 375, 255),
('WeddingCake2.jpg', 2, '<p>The cake is a French-style \"croquembouche\" made up of profiteroles and \"glued\" together with toffee. The whole thing was about 80 cm tall and looked most impressive. Actually, it was hollow so it wasn\'t quite as impressive as it appears but there is no way that even 130 people could have eaten it if it were solid.</p>', '', 'N', '19990510', 255, 375),
('WeddingChurch2.jpg', 2, '', '', 'N', '20080511', 398, 585),
('WallOfSnow2.jpg', 16, '<p>A wall of snow at Milner Pass (10,758 ft) on Trail Ridge Road in the Rocky Mountains National Park. This was impressive for us as it never snows at all in Sydney. The road actually goes as high as 12,183 ft (3713 m).</p>', '', 'N', '19990529', 378, 258),
('ViewPointNW2.jpg', 15, '', '', 'N', '20000117', 750, 511),
('ViewPointNE2.jpg', 15, '', '', 'N', '19991119', 750, 508),
('VietnamWall2b.jpg', 20, '', '', 'N', '19990510', 550, 356),
('VietnamWall1b.jpg', 20, 'Vietnam Veterans\' Memorial.', 'VietnamWall2b.jpg', 'N', '19990510', 150, 97),
('VictoriaBC2.jpg', 20, '', '', 'N', '19990510', 550, 373),
('UtahDesert2.jpg', 18, '<p>Interstate 70 passes through the desert in Utah. It\'s easy to see why virtually no-one lives here but it has its own rugged beauty.</p>', '', 'N', '19990530', 550, 375),
('UsInDiningRm1.jpg', 20, 'Posed shot in the dining room.', 'UsInDiningRm2.jpg', 'N', '19990510', 102, 150),
('UsInDiningRm2.jpg', 20, '', '', 'N', '19990510', 255, 375),
('UsAtDinner1.jpg', 20, 'Pretending to enjoy dinner', 'UsAtDinner2.jpg', 'N', '19990510', 150, 102),
('UsAtDinner2.jpg', 20, '<p>Pity about the old woman and her mother that were also at the table.</p>', '', 'N', '19990510', 378, 257),
('Poinsettia2.jpg', 26, '<p>The two of us at Cypress Gardens, December 1999. </p>', '', 'N', '20000117', 750, 510),
('US50Highway2.jpg', 18, '<p>Often spectacular for its wide-open spaces and harsh desert, US50 was a lonely road home. This photo was taken along the road in Nevada.</p>\r\n\r\n<p>Our car had an odd problem - it ran hotter as the temperature outside dropped. The needle on the gage rose close to maximum when it was well below freezing outside so we were concerned about breaking down literally \"in the middle of nowhere\". We made it home safely and simply replacing the thermostat fixed the problem.</p>', '', 'N', '19990530', 525, 375),
('UniversalStudios2.jpg', 18, '<p>The sign outside. We didn\'t get much further. The cost of living in the US is generally lower than Australia but Americans seem willing to pay almost anything for entertainment.</p>', '', 'N', '19990530', 359, 255),
('UnionBlvd2.jpg', 16, '<p>Union Blvd. on the way to Lan\'s office after a heavy snow.</p>', '', 'N', '19990529', 550, 374),
('TransAmerica2.jpg', 25, '<p>If it weren\'t for those power cables, this would be a great photo.</p>', '', 'N', '19990510', 255, 375),
('TotemAtDuncan2.jpg', 20, '<p>This totem pole stands at Duncan. We caught a ferry from Vancouver to Nanaimo and drove through the town on the way to Victoria.</p>', '', 'N', '19990510', 255, 375),
('TotemPole2.jpg', 20, '<p>I think this totem pole is in Stanley Park, Vancouver though I\'m happy to be corrected. If you look carefully, you will see I am sitting in a hollowed-out section at the bottom.</p>\r\n\r\n<p>See <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=TotemAtDuncan2.jpg\" onclick=\"SweetAndSour.getPhoto(\'TotemAtDuncan2.jpg\', \'Totem pole at Duncan.\'); return false;\">another totem pole</a>.</p>', '', 'N', '19990510', 255, 375),
('TaosPueblo2.jpg', 16, '<p>Access to the upper levels of the pueblo was originally only by ladders that could be easily removed if the pueblo was being attacked.</p>\r\n\r\n<p>It was depressing to see people still living here in what to my western eyes are very primitive conditions.</p>', '', 'N', '19990529', 375, 255),
('SwampGarden2.jpg', 26, '<p>The swamp garden next to the Magnolia Plantation supports abundant wildlife including turtles and alligators. A layer of algea floats on the water to give it the green color but apparantly it is natural, not a result of fertilizer run-off or other human activity. </p>', '', 'N', '20000117', 750, 510),
('SuspensionBridge2.jpg', 20, '<p>A suspension bridge in a park in suburban Vancouver.</p>\r\n\r\n<p>On a distantly related topic, the Inca\'s made similar bridges but using vines instead of steel cables and the bridges were considered so precious that the penalty for willful damage to a bridge was execution. Unfortunately, the fear of punishment aided the Spanish conquest of the Inca empire because the retreating Incas did not cut down their own bridges. Had they done so, they would have forced the Spanish to lower themselves into each canyon and then scale the walls.</p>', '', 'N', '19990510', 255, 375),
('VietnamWall2a.jpg', 20, '', '', 'N', '19990510', 550, 353),
('VietnamWall1a.jpg', 20, 'Visitors walk down into the Memorial.', 'VietnamWall2a.jpg', 'N', '19990510', 150, 96),
('Staircase2.jpg', 16, '<p>This spiral staircase in Our Lady of Light Chapel is remarkable for being constructed without nails or screws and without a central support. Originally it did not have handrails making it even more visually dramatic but the choir didn\'t like using it to get upstairs.</p>', '', 'N', '19990529', 255, 375),
('SplitRockLight2.jpg', 22, '', '', 'N', '19990510', 255, 375),
('SpanishMoss2.jpg', 26, '<p><i>Spanish moss</i> hangs from a tree in the Magnolia Plantation near Charleston. It is an \"air plant\" meaning that it uses the tree only for support and does not extract nutrients from it. Somehow it gets enough in the rain and wind. Actually, it\'s not Spanish and it isn\'t moss. </p>', '', 'N', '20000117', 750, 510),
('SpaceKennedy2.jpg', 26, '<p>Rockets grow in a small forest in the Center\'s back garden. From left Khanh, Tuyet and Lan. Sadly, Tuyet died of leukemia within a year of this photo being taken.</p>', '', 'N', '20000211', 550, 376),
('SnowTrain2.jpg', 20, '<p>This impressive machine sit sat the front of the train to cut a path through the snow.</p>', '', 'N', '19990510', 550, 375),
('SnowOnCar2.jpg', 16, '<p>This was quite a good snow storm as you can see from the accumulation on a neighbor\'s car.</p>', '', 'N', '19990529', 375, 255),
('SkylineBridge2.jpg', 26, '<p>The graceful Skyline Bridge crossing Tampa Bay.</p>', '', 'N', '20000117', 750, 510),
('ShovellingSnow2.jpg', 16, '<p>Shovelling snow so we can get the car out of the garage. A contractor clears the roads and footpaths in the complex but the driveway is our problem.</p>', '', 'N', '19990529', 375, 255),
('SegoviaCastle2.jpg', 18, '', '', 'N', '19990531', 550, 374),
('SeaWorld2.jpg', 25, '', '', 'N', '19990510', 550, 375),
('SeaLions2.jpg', 25, '', '', 'N', '19990510', 255, 375),
('SaturnV2.jpg', 26, '<p>The business end of a Saturn V rocket is huge! This is not a mock-up but an actual rocket that was never used when the Apollo program was terminated.</p>\r\n\r\n<p>Each of the rocket motors tilts to redirect the vehicle. Try balancing a broom handle on your hand and now imagine how quickly the tilt mechanisms must respond to balance a rocket 350 ft (100 m) tall. Eventually the rocket would be going fast enough that the aerodynamic fins would work but getting clear of the tower would be difficult. </p>', '', 'N', '20000117', 581, 550),
('Santafe2.jpg', 16, '<p>The old part of town in Santa Fe, New Mexico looking from the Plaza to the Cathedral.</p>\r\n\r\n<p>Newly appointed Spanish governor Don Pedro de Peralta chose this place as the provincial capital in 1609-10 but its full name was La Villa REal de Santa Fe de San Francisco de Asis (Royal City of the Holy Faith of St Francis of Assisi)! It is the oldest continuous seat of governement in the U.S.</p>\r\n\r\n<p>The Mission of San Miguel was also established in 1610 as local headquarters for Catholic church.</p>', '', 'N', '19990529', 550, 374),
('RegalPrincess2.jpg', 20, '<p>Technical information:</p>\r\n<ul>\r\n<li>Built in Italy, 1991\r\n<li>Gross tonnage: 69,845\r\n<li>Length: 245.1 m (845 ft)\r\n<li>Breadth 32.2 m (105 ft)\r\n<li>Height above keel: 56.0 m (183 ft)\r\n<li>Draught: 8.1 m (26ft)\r\n<li>Crew: 660\r\n<li>Propulsion: diesel-electric\r\n<li>Diesel engines: 4 engines, each 8 cyl. total 36,800 kW\r\n<li>Propulsion motors: 2 electric, each 12 MW at 145 rpm\r\n<li>Propellers: 2 fixed pitch, 6 blades 5.8 m (19 ft) diameter\r\n<li>Cruising speed: 20 knots\r\n<li>Top speed: 22.5 knots\r\n</ul>', '', 'N', '19990510', 550, 374),
('RedRocks2.jpg', 12, '<p>Red Rocks amphitheatre. The seating area is below the letter \"s\" and it holds five or ten thousand people. The huge rock formations either side keep the sound in.</p>', '', 'N', '19990529', 375, 255),
('RedRocks1.jpg', 12, '', 'RedRocks2.jpg', 'N', '19990529', 150, 102),
('RedRocksStars1.jpg', 12, '', 'RedRocksStars2.jpg', 'N', '20030519', 150, 100),
('RedRocksStars2.jpg', 12, '', '', 'N', '20030519', 1000, 668),
('QueenMary2.jpg', 18, '<p>The Queen Mary, now permanently moored at Long Beach, just south of Los Angeles.</p>', '', 'N', '19990530', 550, 374),
('PeterGlacier2.jpg', 20, '', '', 'N', '19990510', 550, 375),
('Pedestrians2.jpg', 26, '<p>Drivers, watch out for pedestrians in Savannah, GA. </p>', '', 'N', '20000117', 375, 255),
('Passport2.jpg', 27, '<p>Drivers, watch out for pedestrians in Savannah, GA. </p>', '', 'N', '20010303', 360, 374),
('OldFaithful2.jpg', 17, '<p>Old Faithful is not the largest geyser in Yellowstone National Park but it is very regular. This is handy if you are a tourist and don\'t want to sit around waiting for hours or even days.</p>', '', 'N', '19990529', 375, 255),
('OfficeTree2.jpg', 27, '<p>Probably the best picture I\'ve ever taken. Well, I like it.</p>', '', 'N', '20010303', 750, 510),
('NorthSouthArch2.jpg', 21, '', '', 'N', '19990510', 550, 374),
('Naples2.jpg', 26, '<p>Lan collecting sea shells at Naples. Note the small waves coming in from the Gulf of Mexico. While we walked along the beach, a man flew over us under a parachute with a motor/propellor backpack.</p>', '', 'N', '20000117', 750, 511),
('Nottaway2.jpg', 28, '<p>Just like in <i>Gone with the wind</i>.</p>', '', 'N', '20020817', 687, 406),
('MtRushmore2.jpg', 17, '<p>This is about as close as it is possible to get to Mount Rushmore - still a long way away. At this distance the presidents\' heads are not that impressive. From left, the Presidents are:</p>\r\n<ol>\r\n<li>Washington (the first President who led the revolution against the British)\r\n<li>Jefferson (the third President and one of the drafters of the Declaration of Independence)\r\n<li>Theodore Roosevelt (not to be confused with Franklin Roosevelt who was President during the Depression and WWII, Theodore probably doesn\'t quite match the stature of the others but he did fight in the Spanish-American war, break up oil and railway monopolies and greatly expand the National Park system)\r\n<li>Lincoln (President during the Civil War, freed the slaves)\r\n</ol>', '', 'N', '19990530', 255, 375),
('MtEvans2.jpg', 16, '<p>The view from the top of Mount Evans which is14,264 ft (4350 m) high. We are looking south-east over the carpark. Denver lies due east. Behind the carpark is a small astronomical observatory run by one of the universities.</p>', '', 'N', '19990529', 375, 255),
('MNStateCapitol2.jpg', 22, '', '', 'N', '19990510', 550, 374),
('MixedMarraige2.jpg', 19, '', '', 'N', '19990529', 244, 378),
('MissionStBarbara2.jpg', 18, '', '', 'N', '19990510', 550, 374),
('MenAtWork2.jpg', 19, '<p>The two men working on the face of Crazy Horse give some idea of the scale of the sculpture being carved from the mountain. There is one under the nose and another at the bottom right.</p>', '', 'N', '19990529', 255, 375),
('Mangroves2.jpg', 26, '<p>Mangrove trees extend the land out into the sea by colonizing tidal zones. </p>', '', 'N', '20000117', 750, 510),
('MallOfAmerica2.jpg', 22, '', '', 'N', '19990510', 375, 255),
('Madrid2.jpg', 18, '', '', 'N', '19990530', 550, 374),
('LuxorOutside2.jpg', 25, '', '', 'N', '19990510', 550, 374),
('LuxorInside2.jpg', 25, '<p>This photo was scanned from a brochure. It shows the difference between professional and ameteur photography as the one we took was almost all black.</p>', '', 'N', '19990510', 255, 375),
('LighthouseSteps2.jpg', 26, '<p>Looking down the center of the lighthouse. The lighthouse keeper had to carry 5 gallons (20 liters) of oil up the 219 steps. </p>', '', 'N', '20000117', 750, 524),
('Lighthouse2.jpg', 26, '<p>The lighthouse at St.Augustine. A common question is why it was built so far from the shoreline which is perhaps a mile away. The answer is it wasn\'t - the shore has been built up and been moving outwards. See the interesting <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=LighthouseSteps2.jpg\">inside view</a>.</p>', '', 'N', '20000117', 374, 550),
('GeneralMotors1.jpg', 14, 'General Motors buildings.', 'GeneralMotors2.jpg', 'N', '19990529', 150, 102),
('FarmingtonHills1.jpg', 14, 'Our first "home".', 'FarmingtonHills2.jpg', 'N', '19990529', 150, 102),
('LakeStClair1.jpg', 14, 'Lake St Clair', 'LakeStClair2.jpg', 'N', '19990529', 150, 102),
('IceFishing1.jpg', 14, 'Ice fishing', 'IceFishing2.jpg', 'N', '19990529', 150, 102),
('ViewPointNE1.jpg', 15, 'ViewPoint looking NE.', 'ViewPointNE2.jpg', 'N', '20000117', 150, 102),
('ViewPointNW1.jpg', 15, 'ViewPoint looking NW.', 'ViewPointNW2.jpg', 'N', '20000117', 150, 102),
('Hyundai1.jpg', 15, '1991 Hyundai Excel.', 'Hyundai2.jpg', 'N', '19990529', 150, 102),
('UnionBlvd1.jpg', 16, 'A nice introduction to Colorado', 'UnionBlvd2.jpg', 'N', '19990529', 150, 102),
('ShovellingSnow1.jpg', 16, 'Clearing the driveway', 'ShovellingSnow2.jpg', 'N', '19990529', 150, 102),
('SnowOnCar1.jpg', 16, 'Impaired driving visibility.', 'SnowOnCar2.jpg', 'N', '19990529', 150, 102),
('Icicle1.jpg', 16, 'Lan with an icicle', 'Icicle2.jpg', 'N', '19990529', 150, 102),
('ColoradoNM1.jpg', 16, 'Colorado National Monument', 'ColoradoNM2.jpg', 'N', '19990529', 150, 102),
('BookCliffs1.jpg', 16, 'Book Cliffs', 'BookCliffs2.jpg', 'N', '19990529', 150, 102),
('ElkStatue1.jpg', 16, 'A very large elk.', 'ElkStatue2.jpg', 'N', '19990529', 150, 102),
('FishCreekFalls1.jpg', 16, 'Fish Creek Falls', 'FishCreekFalls2.jpg', 'N', '19990529', 102, 150),
('Zoro1.jpg', 16, 'Zoro near Steamboat Springs', 'Zoro2.jpg', 'N', '19990529', 150, 102),
('BerthoudPass1.jpg', 16, 'Berthoud Pass', 'BerthoudPass2.jpg', 'N', '19990509', 150, 102),
('WallOfSnow1.jpg', 16, 'Snow at Milner Pass', 'WallOfSnow2.jpg', 'N', '19990529', 150, 102),
('BeaverDam1.jpg', 16, 'Beaver dam', 'BeaverDam2.jpg', 'N', '19990529', 150, 102),
('BighornSheep1.jpg', 16, 'Mountain goats at Mt. Evans', 'BighornSheep2.jpg', 'N', '19990529', 150, 102),
('MtEvans1.jpg', 16, 'On top of Mt. Evans', 'MtEvans2.jpg', 'N', '19990529', 150, 102),
('Santafe1.jpg', 16, 'Santa Fe, New Mexixo', 'Santafe2.jpg', 'N', '19990529', 150, 102),
('BridgeTaos1.jpg', 16, 'Bridge on US 64', 'BridgeTaos2.jpg', 'N', '19990529', 150, 102),
('Staircase1.jpg', 16, 'Unsupported staircase', 'Staircase2.jpg', 'N', '19990529', 102, 150),
('TaosPueblo1.jpg', 16, 'Native-American pueblo', 'TaosPueblo2.jpg', 'N', '19990529', 150, 102),
('GreatSandDunes1.jpg', 16, 'Great Sand Dunes', 'GreatSandDunes2.jpg', 'N', '19990529', 150, 102),
('LanBlackCanyon1.jpg', 17, 'Lan at the Black Canyon of the Gunnison.', 'LanBlackCanyon2.jpg', 'N', '19990601', 102, 150),
('Buffalo1.jpg', 17, 'Buffalo', 'Buffalo2.jpg', 'N', '19990529', 150, 98),
('OldFaithful1.jpg', 17, 'Old Faithful geyser at Yellowstone National Park.', 'OldFaithful2.jpg', 'N', '19990529', 150, 102),
('BlackCanyon1.jpg', 17, 'Postcard showing the sheer walls of the canyon.', 'BlackCanyon2.jpg', 'N', '19990601', 99, 150),
('MtRushmore1.jpg', 17, 'Mount Rushmore, South Dakota.', 'MtRushmore2.jpg', 'N', '19990530', 102, 150),
('DevilsTower1.jpg', 17, 'Devil\'s Tower, Wyoming.', 'DevilsTower2.jpg', 'N', '19990529', 102, 150),
('Madrid1.jpg', 18, 'Lan\'s postcard from Madrid ...', 'Madrid2.jpg', 'N', '19990531', 150, 102),
('MadridBack1.jpg', 18, '... and what she said.', 'MadridBack2.jpg', 'N', '19990531', 150, 103),
('LadiesInWaiting1.jpg', 18, 'Street sculpture.', 'LadiesInWaiting2.jpg', 'N', '19990531', 102, 150),
('SegoviaAquaduct1.jpg', 18, 'Aquaduct at Segovia.', 'SegoviaAquaduct2.jpg', 'N', '19990531', 150, 105),
('SegoviaCastle1.jpg', 18, 'Segovia Castle', 'SegoviaCastle2.jpg', 'N', '19990531', 150, 102),
('UtahDesert1.jpg', 18, 'Utah desert.', 'UtahDesert2.jpg', 'N', '19990531', 150, 102),
('QueenMary1.jpg', 18, '', 'QueenMary2.jpg', 'N', '19990531', 150, 102),
('UniversalStudios1.jpg', 18, '', 'UniversalStudios2.jpg', 'N', '19990531', 150, 107),
('HollywoodStar1.jpg', 18, '', 'HollywoodStar2.jpg', 'N', '19990531', 102, 150),
('MissionStBarbara1.jpg', 18, 'Mission Santa Barbara', 'MissionStBarbara2.jpg', 'N', '19990531', 150, 102),
('GuardAtSolvang1.jpg', 18, 'Guard at Solvang.', 'GuardAtSolvang2.jpg', 'N', '19990531', 102, 150),
('CableCar1.jpg', 18, '', 'CableCar2.jpg', 'N', '19990531', 150, 102),
('GoldenGateSun1.jpg', 18, '', 'GoldenGateSun2.jpg', 'N', '19990531', 150, 102),
('GoldenGateFog1.jpg', 18, '', 'GoldenGateFog2.jpg', 'N', '19990531', 150, 107),
('US50Highway1.jpg', 18, 'The loneliest road in America.', 'US50Highway2.jpg', 'N', '19990531', 150, 107),
('JapaneseGardens1.jpg', 18, '', 'JapaneseGardens2.jpg', 'N', '19990531', 150, 107),
('ChristmasLights1.jpg', 18, 'The best Christmas lights in town are on Xenobia St at about Ellsworth (00 block).', 'ChristmasLights2.jpg', 'N', '19990531', 150, 102),
('LanMtRushmore1.jpg', 19, 'Mount Rushmore', 'LanMtRushmore2.jpg', 'N', '19990529', 150, 94),
('CrazyHorse1.jpg', 19, 'Crazy Horse memorial.', 'CrazyHorse2.jpg', 'N', '19990529', 150, 102),
('MenAtWork1.jpg', 19, 'Men working on Crazy Horse.', 'MenAtWork2.jpg', 'N', '19990529', 102, 150),
('BadlandsSDakota1.jpg', 19, 'The Badlands', 'BadlandsSDakota2.jpg', 'N', '19990510', 150, 102),
('PetrifiedLog1.jpg', 19, '', 'PetrifiedLog2.jpg', 'N', '19990529', 101, 150),
('Camping1.jpg', 19, '', 'Camping2.jpg', 'N', '19990529', 150, 102),
('GooseCrossing.jpg', 19, 'Road sign near Lan\'s office.', '', 'N', '20030627', 150, 150),
('MixedMarraige1.jpg', 19, 'Rising mixed marraiges.', 'MixedMarraige2.jpg', 'N', '19990530', 97, 150),
('SpaceNeedle1.jpg', 20, 'The Seattle Space Needle.', 'SpaceNeedle2.jpg', 'N', '19990510', 70, 150),
('SpaceNeedle2.jpg', 20, '<p>On a clear day you can see Bill Gates.</p>', '', 'N', '19990510', 176, 375),
('Cabbages1.jpg', 20, 'Cabbages planted for their good looks in Anchorage, Alaska.', 'Cabbages2.jpg', 'N', '19990510', 150, 102),
('RegalPrincess1.jpg', 20, 'The Regal Princess', 'RegalPrincess2.jpg', 'N', '19990510', 150, 102),
('LanGlacier1.jpg', 20, 'The view from the ship.', 'LanGlacier2.jpg', 'N', '19990510', 150, 103),
('PeterGlacier1.jpg', 20, '', 'PeterGlacier2.jpg', 'N', '19990510', 150, 102),
('ChilkootPass1.jpg', 20, 'Prospectors struggling up Chilkoot Pass.', 'ChilkootPass2.jpg', 'N', '19990510', 108, 150),
('SnowTrain1.jpg', 20, 'Snow plough!', 'SnowTrain2.jpg', 'N', '19990510', 150, 102),
('VictoriaBC1.jpg', 20, 'The Empress Hotel in Victoria.', 'VictoriaBC2.jpg', 'N', '19990510', 150, 102),
('ButchardGardens1.jpg', 20, 'Even I was impressed.', 'ButchardGardens2.jpg', 'N', '19990510', 150, 102),
('LanAtBGardens1.jpg', 20, '', 'LanAtBGardens2.jpg', 'N', '19990509', 150, 102),
('TotemPole1.jpg', 20, 'Totem pole, Stanley Park', 'TotemPole2.jpg', 'N', '19990510', 102, 150),
('SuspensionBridge1.jpg', 20, '', 'SuspensionBridge2.jpg', 'N', '19990510', 102, 150),
('LanAtPiano1.jpg', 20, '', 'LanAtPiano2.jpg', 'N', '19990509', 150, 112),
('LanAtPiano2.jpg', 20, '', '', 'N', '19990509', 375, 281),
('DenverLocation.jpg', 15, '(This graphic not a link.)', '', 'N', '20030520', 80, 150),
('SeatBelt.jpg', 15, '(This graphic not a link.)', '', 'N', '20030520', 97, 150),
('AustOnEurope.jpg', 11, '<p>On the back of the post card it gives areas in square kilometers:</p>\r\n<p>Australia (total): 7,686,849 made up of:</p>\r\n<ul>\r\n<li>Western Australia: 2,57,632\r\n<li>Queensland: 1,727,530\r\n<li>Northern Territory: 1,347,525\r\n<li>South Australia: 984,381\r\n<li>New South Wales: 801,431\r\n<li>Victoria: 227,619\r\n<li>Tasmania: 68,331\r\n</ul>\r\n<p>By way of comparison, some counties in Europe:</p>\r\n<ul>\r\n<li>Austria: 83,849\r\n<li>England: 130,367\r\n<li>France: 547,028\r\n<li>Germany: 356,702\r\n<li>Greece: 131,944\r\n<li>Holland: 36,158\r\n<li>Italy: 301,224\r\n<li>Poland: 312,522\r\n<li>Spain: 504,746\r\n<li>Sweden: 499,792\r\n<li>Switzerland: 41,287\r\n</ul>', '', 'N', '20030520', 750, 503),
('LanMesaVerde1.jpg', 21, 'At Mesa Verde.', 'LanMesaVerde2.jpg', 'N', '19990510', 150, 102),
('LandscapeArch1.jpg', 21, 'Landscape Arch', 'LandscapeArch2.jpg', 'N', '19990510', 150, 102),
('DelicateArch1.jpg', 21, 'Delicate Arch.', 'DelicateArch2.jpg', 'N', '19990510', 150, 102),
('NorthSouthArch1.jpg', 21, 'North and South Windows.', 'NorthSouthArch2.jpg', 'N', '19990510', 150, 102),
('MNStateCapitol1.jpg', 22, 'Minnasota State Capitol', 'MNStateCapitol2.jpg', 'N', '19990510', 150, 102),
('Cathedral1.jpg', 22, 'Cathedral of St. Paul', 'Cathedral2.jpg', 'N', '19990510', 150, 150),
('TwoHarbors1.jpg', 22, 'Two Harbors', 'TwoHarbors2.jpg', 'N', '20030520', 150, 102),
('TwoHarbors2.jpg', 22, '<p>On the breakwater at Two Harbors on Lake Superior. Notice that there is no land visible on the horizon to the right.</p>', '', 'N', '20030520', 750, 537),
('SplitRockLight1.jpg', 22, 'Split Rock lighthouse', 'SplitRockLight2.jpg', 'N', '19990510', 102, 150),
('MallOfAmerica1.jpg', 22, 'Outside the Mall of America.', 'MallOfAmerica2.jpg', 'N', '19990510', 150, 102),
('InsideMall1.jpg', 22, 'Inside mall. Note the roller coaster in the background.', 'InsideMall2.jpg', 'N', '19990510', 150, 102),
('Dad1.jpg', 23, 'My late father.', 'Dad2.jpg', 'N', '19990510', 102, 150),
('PeterMesaVerde1.jpg', 21, 'The cliff dwellings are almost cave dwellings.', 'PeterMesaVerde2.jpg', 'N', '19990510', 150, 102),
('FriendsAtTNA1.jpg', 24, 'Friends at TNA', 'FriendsAtTNA2.jpg', 'N', '19990609', 150, 112),
('ChilavertInAction1.jpg', 24, 'Chilavert in action.', 'ChilavertInAction2.jpg', 'N', '19990523', 150, 102),
('ChilavertUpClose1.jpg', 24, 'Chilavert up close.', 'ChilavertUpClose2.jpg', 'N', '19990510', 111, 150),
('SeaLions1.jpg', 25, 'Sea lions - sunbathing for the tourists.', 'SeaLions2.jpg', 'N', '19990510', 102, 150),
('PeterGoldenGate1.jpg', 25, 'Golden Gate Bridge. ', 'PeterGoldenGate2.jpg', 'N', '19990510', 150, 102),
('TransAmerica1.jpg', 25, 'This bank building is not a perfect pyramid as the two lift shafts stick out near the top like shoulders.', 'TransAmerica2.jpg', 'N', '19990510', 102, 150),
('YosemiteFalls1.jpg', 25, 'Waterfall at Yosemite National Park, California drops 2,426 ft/740m.', 'YosemiteFalls2.jpg', 'N', '19990510', 150, 102),
('Stratus1.jpg', 25, 'Dodge Stratus. Nice!', 'Stratus2.jpg', 'N', '19990604', 150, 75),
('LuxorOutside1.jpg', 25, 'Our hotel. 6000 slaves built it in 18 months.', 'LuxorOutside2.jpg', 'N', '19990510', 150, 102),
('LuxorInside1.jpg', 25, 'Inside the pyramid.', 'LuxorInside2.jpg', 'N', '19990510', 102, 150),
('HooverDam1.jpg', 25, 'Hoover Dam. No bodies inside except live ones.', 'HooverDam2.jpg', 'N', '19990510', 150, 102),
('SeaWorld1.jpg', 25, '', 'SeaWorld2.jpg', 'N', '19990510', 150, 102),
('Illuminate1.jpg', 25, 'Illuminated manuscript.', 'Illuminate2.jpg', 'N', '19990526', 74, 150),
('GrandCanyon1.jpg', 25, 'The Grand Canyon at sunset. I wish we had arrived an hour earlier so we could see down into the canyon.', 'GrandCanyon2.jpg', 'N', '19990510', 150, 102),
('PetrifiedStump1.jpg', 26, 'Diana admires a very large, very old tree stump.', 'PetrifiedStump2.jpg', 'N', '20000124', 150, 102),
('FloridaRoute1.jpg', 26, 'We came, we saw, we got tired.', 'FloridaRoute2.jpg', 'N', '20000126', 89, 150),
('CastilloDeSanMarcos1.jpg', 26, 'Castillo de San Marcos', 'CastilloDeSanMarcos2.jpg', 'N', '20000126', 150, 102),
('Lighthouse1.jpg', 26, 'St Augustine lighthouse.', 'Lighthouse2.jpg', 'N', '20000126', 102, 150),
('LighthouseSteps1.jpg', 26, 'Looking down the steps.', 'LighthouseSteps2.jpg', 'N', '20000126', 150, 105),
('SpanishMoss1.jpg', 26, 'Spanish moss, an "air plant", grows on the trees.', 'SpanishMoss2.jpg', 'N', '20000126', 150, 102),
('SwampGarden1.jpg', 26, 'The "Swamp Garden".', 'SwampGarden2.jpg', 'N', '20000126', 150, 102),
('Pedestrians1.jpg', 26, 'Watch out for pedestrians in Savannah, Georgia!', 'Pedestrians2.jpg', 'N', '20000126', 150, 102),
('FortPulaski1.jpg', 26, 'Fort Pulaski guards Savannah ... or so it was thought.', 'FortPulaski2.jpg', 'N', '20000126', 150, 102),
('WeekiWatchie1.jpg', 26, 'King Neptune & mermaid at Weeki Wachee.', 'WeekiWatchie2.jpg', 'N', '20000126', 150, 102),
('SkylineBridge1.jpg', 26, 'Skyline Bridge over Tampa Bay.', 'SkylineBridge2.jpg', 'N', '20000126', 150, 102),
('Naples1.jpg', 26, 'Treasure hunting near Naples.', 'Naples2.jpg', 'N', '20000126', 150, 102),
('Wetland1.jpg', 26, 'Fields of saw grass are a haven for birds and small fish. ', 'Wetland2.jpg', 'N', '20000126', 150, 102),
('Mangroves1.jpg', 26, 'Fields of saw grass are a haven for birds and small fish. ', 'Mangroves2.jpg', 'N', '20000124', 150, 102),
('Alligator1.jpg', 26, 'An alligator taking a nap (in the background).', 'Alligator2.jpg', 'N', '20000126', 150, 102),
('BridgeTooFar1.jpg', 26, 'A bridge too far.', 'BridgeTooFar2.jpg', 'N', '20000126', 150, 102),
('Epcot1.jpg', 26, 'At Disney\'s Epcot center.', 'Epcot2.jpg', 'N', '20000126', 150, 102),
('SaturnV1.jpg', 26, 'Saturn V rocket at Kennedy Space Center.', 'SaturnV2.jpg', 'N', '20000126', 150, 102),
('SpaceKennedy1.jpg', 26, 'Big smiles for the camera - Khanh, Tuyet and Lan at KSC.', 'SpaceKennedy2.jpg', 'N', '20000203', 150, 102),
('Poinsettia1.jpg', 26, 'A rare picture with both of us, taken aat Cypress Gardens.', 'Poinsettia2.jpg', 'N', '20000118', 150, 102),
('AcrobatIcon_Ltr13.gif', 26, 'Printer-friendly version (PDF, 472kb). ', '', 'N', '20010304', 36, 35);
INSERT INTO `photos` (`photoName`, `folderID`, `caption`, `linkedImg`, `linkToFullSize`, `version`, `width`, `height`) VALUES
('Passport1.jpg', 27, 'A new stamp in Lan\'s passport.', 'Passport2.jpg', 'N', '20010304', 150, 155),
('LanAndXuan1.jpg', 27, 'Lan and Xuan in the gardens.', 'LanAndXuan2.jpg', 'N', '20010306', 150, 102),
('SearsTower1.jpg', 27, 'Sears Tower', '', 'N', '20010306', 150, 222),
('Dino_NM_Us1.jpg', 27, 'At the Dinosaur National Monument, NW Colorado. ', 'Dino_NM_Us2.jpg', 'N', '20010306', 150, 101),
('Dino_NM1.jpg', 27, 'Click to really see the incredible view. ', 'Dino_NM2.jpg', 'N', '20030521', 151, 54),
('OfficeTree1.jpg', 27, 'Fall colors at my office. ', 'OfficeTree2.jpg', 'N', '20010307', 150, 102),
('Thunderbirds1.jpg', 28, 'Air Force Thunderbirds display team.', 'Thunderbirds2.jpg', 'N', '20020724', 150, 79),
('Thunderbirds2.jpg', 28, 'LOUD!!!', '', 'N', '20020724', 525, 275),
('RockyMtnNP1.jpg', 28, 'Rocky Mountain National Park', 'RockyMtnNP2.jpg', 'N', '20020817', 150, 103),
('IceFountain1.jpg', 28, 'It was very cold for a week in February turning fountains into ice sculptures. The tallest mound is about 5m high.', 'IceFountain2.jpg', 'N', '20020817', 150, 104),
('IceFountain2.jpg', 28, '<p>COOL!</p>', '', 'N', '20020817', 750, 523),
('AcrobatIcon_Ltr14.gif', 27, 'Printer-friendly version (PDF, 167kb).', '', 'N', '20010304', 36, 35),
('AcrobatIcon_Ltr15.gif', 28, 'Printer-friendly version (PDF, 251kb).', '', 'N', '20010304', 36, 35),
('AcrobatIcon_Ltr16_A4.gif', 29, 'Printer-friendly version (PDF, 600kb).', '', 'N', '20010304', 36, 35),
('USMap1.gif', 28, 'Long way home.', 'USMap2.gif', 'N', '20020724', 150, 99),
('USMap2.gif', 28, '', '', 'N', '20020724', 500, 329),
('CathedralNO2.jpg', 28, '<p>St Louis cathedral was completed 1794 but the Spanish style was changed in the 1850s with the addition of steeples. The man on the horse is Andrew Jackson, leader of the American forces in the Battle of New Orleans and later, Americas seventh president.</p>', '', 'N', '20020817', 687, 872),
('CathedralNO1.jpg', 28, 'St Louis cathedral', 'CathedralNO2.jpg', 'N', '20020817', 118, 150),
('Nachez2.jpg', 28, '<p>We took a short trip on the steamboat Nachez which has a very fine functioning steam engine. Rain falling over nearly half the US ends up in the Mississippi River and flows under the bridge in the background.</p>', '', 'N', '20020817', 687, 458),
('Nachez1.jpg', 28, 'The Nachez.', 'Nachez2.jpg', 'N', '20020817', 150, 100),
('GardenDistrict2.jpg', 28, '<p>Wealthy merchants and landowners built elegant homes such as this one in the Garden District. I was amazed at the proximity of the rich and poor in the citythe Garden District is on one side of Jackson St. and there is a slum on the other. Cross the river from the CBD and tourist areas and there is another slum.</p>', '', 'N', '20020817', 687, 408),
('GardenDistrict1.jpg', 28, 'Garden District.', 'GardenDistrict2.jpg', 'N', '20020817', 150, 89),
('Nottaway1.jpg', 28, 'Nottaway Plantation.', 'Nottaway2.jpg', 'N', '20020817', 150, 88),
('InfiniteBridge2.jpg', 28, '<p>The <i>Lake Pontchartrain Causeway</i> might be called the <i>Bridge to infinity</i> since from the middle you can\'t see <i>either</i> shore as the surrounding land is flat and low. It is 24 miles/38km long!</p>', '', 'N', '20020817', 687, 304),
('InfiniteBridge1.jpg', 28, 'Very long bridge.', 'InfiniteBridge2.jpg', 'N', '20020817', 150, 66),
('PoliceFish1.jpg', 28, 'Something you don\'t see every day.', 'PoliceFish2.jpg', 'N', '20020817', 150, 106),
('PoliceFish2.jpg', 28, '<p>Sorry. I can\'t explain this except to say it is Lan standing in front of a plastic fish dressed as a policeman swallowing someone in convict attire.</p>', '', 'N', '20020817', 687, 486),
('FakePhoto2.jpg', 28, '<p>This photo did the rounds of the Internet in late September. The story was that it was from a camera recovered from the rubble and that the FBI had released the photo though not the identity of the tourist. There are many things wrong with the picture indicating it is a fake: <a href=\"http://www.blueartharts.com/uhoh.htm\" target=\"_blank\">http://www.blueartharts.com/uhoh.htm</a> and <a href=\"http://www.truthorfiction.com/rumors/lastpic.htm\" target=\"_blank\">http://www.truthorfiction.com/rumors/lastpic.htm</a>. If you can accept it as a joke (and that may be hard for some), you might be interested to know that the same man was in the car in Dallas with JFK, was at the crash of the Hindenburg and so on. There are hundreds of “photos”: <a href=\"http://www.touristofdeath.com\" target=\"_blank\">http://www.touristofdeath.com</a>, <a href=\"http://www.waldoconspiracy.com\" target=\"_blank\">http://www.waldoconspiracy.com/</a></p>\r\n\r\n<p>The thing that gave told me that this photo was a fake was the low railing. I expected it to be at least 6ft/2m high to stop anyone throwing themselves off and I expected it to have closer-spaced railings or even chain-mesh to prevent objects being dropped. In fact, i was wrong, the <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=WTC_Top2.jpg\" onclick=\"SweetAndSour.getPhoto(\'WTC_Top2.jpg\',\'Top of the World Trade Center\')\">observation area</a> does not go anywhere near the edge.</p>', '', 'N', '20020730', 550, 380),
('FakePhoto1.jpg', 28, 'An amazing photo of a tourist on the observation deck of the WTC just before it was hit by a plane—but it is fake!', 'FakePhoto2.jpg', 'N', '20020817', 150, 107),
('WTC_Top2.jpg', 28, '<p>Top of the World Trade Center. It appears that the observation area is actually a raised walkway that forms a square on the top of the building but set well back from the edge.</p>', '', 'N', '20030521', 400, 300),
('ActionAtTNA.jpg', 24, '<p><a onclick=\"SweetAndSour.getPhoto(\'FriendsAtTNA2.jpg\', \'Friends at TNA\'); return false;\" href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=FriendsAtTNA2.jpg&altText=Friends+at+TNA\"><< Back</a></p>', '', 'N', '19990609', 550, 374),
('Shuttle2.jpg', 4, '<p>Unfortunately we didn\'t get to see the real thing.</p>', '', 'N', '20000117', 375, 550),
('FriendsAtIsoTech1.jpg', 23, 'The engineers of IsoTech.', 'FriendsAtIsoTech2.jpg', 'N', '19990510', 150, 102),
('FriendsAtIsoTech2.jpg', 23, '<p>My friends from La Calhène on my last day. From left going around the table: Nate, Mike, me, Lan, Bruce, Justin, Torje and Claire. Steve took the picture.</p>', '', 'N', '19990510', 550, 375),
('Houseboats1.jpg', 25, 'Houseboats at Sausalito', 'Houseboats2.jpg', 'N', '19990510', 150, 102),
('FortMatanzasUs1.jpg', 26, 'Fort Matanzas', 'FortMatanzasUs2.jpg', 'N', '20000108', 150, 102),
('I40NewMexico1.jpg', 25, 'Lots of open space along I-40, New Mexico.', 'I40NewMexico2.jpg', 'N', '19990510', 150, 102),
('LanOnBike1.jpg', 19, 'Lan\'s new on her new toy. A garage sale bargain!', 'LanOnBike2.jpg', 'N', '20000121', 150, 107),
('LanAtWork2.jpg', 2, '<p>This was taken at a freeway reconstruction site in Los Angeles after the 1994 earthquake. Lan has a cousin that works for the California Department of Transportation who kindly showed us the damage and the speedy repair work.</p>', '', 'N', '19990510', 375, 255),
('LanAtWork1.jpg', 2, 'Lan looking good in a high-visibility vest.', 'LanAtWork2.jpg', 'N', '19990510', 150, 102),
('NeverTooYoungSm.jpg', 7, 'What will the little boy think of soldiers when he grows up?', 'NeverTooYoungLg.jpg', 'N', '20070921', 148, 100),
('PeterAndBasil1.jpg', 2, 'Peter and Basil.', 'PeterAndBasil2.jpg', 'N', '20030626', 101, 150),
('PeterAndBasil2.jpg', 2, '<p>Basil was my maternal grandfather but he died when I was only six or seven while we were living in America so I barely remember him. I think this picture was taken in my grandparents back garden in Ballarat, Victoria (Australia).</p>', '', 'N', '20030626', 406, 600),
('PeterBaby1.jpg', 2, 'Fat baby.', 'PeterBaby2.jpg', 'N', '20030626', 150, 101),
('PeterBaby2.jpg', 2, '<p>Given how thin I turned out, I was surprisingly fat as a baby. Seen here fighting a piece of paper. Not clear if I\'m winning.</p>', '', 'N', '20030626', 780, 527),
('PeterEggplant1.jpg', 2, 'Eggplant!', 'PeterEggplant2.jpg', 'N', '20030626', 150, 99),
('PeterEggplant2.jpg', 2, '<p>I was brought up to eat whatever was put on the plate, regardless of whether I liked it or not. If eggplant was involved, I might sit at the table for what seemed like hours hoping it would go away. Despite the best efforts of my parents to get me to like eggplant, I still find it repulsive.</p>\r\n<p>It is iinteresting how times have changed, presumably with increasing affluence. My experience appears to have been quite common with people my age and older but none of my friends and acquaintances who have children have said they would now apply such rules to their children. It seems inhumane now. Actually, it did at the time too though I would not have expressed it that way.</p>', '', 'N', '20030626', 780, 516),
('PeterInSabot1.jpg', 2, 'First real sailing boat.', 'PeterInSabot2.jpg', 'N', '20030626', 150, 103),
('PeterInSabot2.jpg', 2, '<p>In my Sabot (pronounced with a silent \"t\") class boat called Aquarius. Judging by the appearance of the Australian National Gallery in the background at the left, this photo was taken in Canberra on Lake Burley Griffen. I must therefore have been 11, 12 or 13. Sailing on the lake was easy compared with the area around Greenwich where we lived in Sydney since the surrounding area is largely flat making for more predictable winds, there were no concerns about sharks and rocks on the shore were smooth rather than being covered by shellfish that might cut you.</p>\r\n\r\n<p>Though a Sabot is just 2.4m/8 ft long and thus intended for children, this was not my first boat. My father built an even smaller boat out of discarded (liberated?) pieces of 1/2\" plywood from a construction site next door. It was shaped like a barge with a sloped front and a centerboard box. A 3m/10 ft aluminium tube was procured to hold a home-made sail and later a spinnaker. My father used to follow me around in his motor boat which was his commuter vehicle during the week. It met a sad end though when a wild storm blew a tree over and crushed it.</p>', '', 'N', '20030626', 779, 536),
('PeterMarineLand1.jpg', 2, 'At MarineLand. ', 'PeterMarineLand2.jpg', 'N', '20030626', 100, 150),
('PeterMarineLand2.jpg', 2, '<p>This is almost as cute and realistic as Lan\'s photo wrestling the crocodile. I think this picture was taken in America so I was 5 to 7 years old but I don\'t know where MarineLand is, or perhaps was.</p>', '', 'N', '20030626', 402, 598),
('AmiensCarvings1.jpg', 29, 'Carvings above main door.', 'AmiensCarvings2.jpg', 'N', '20030708', 150, 99),
('AmiensCarvings2.jpg', 29, '', '', 'N', '20030704', 780, 517),
('AmiensCathedral1.jpg', 29, 'Notre-Dame, Amiens', 'AmiensCathedral2.jpg', 'N', '20030708', 117, 150),
('AmiensCathedral2.jpg', 29, '<p>The town of Amiens appeared to be extremely neat with nice architecture everywhere. I could imagine liviing hear except that I don\'t speak French. We had some trouble finding the hotel and eventually we found a pollceman to ask but Lan had to wait for him to finish issuing a speeding ticket before she could speak to him!</p>', '', 'N', '20030703', 453, 580),
('ArchOrange1.jpg', 29, 'Triumphal arch, Orange', 'ArchOrange2.jpg', 'N', '20030708', 150, 104),
('ArchOrange2.jpg', 29, '', '', 'N', '20030703', 780, 539),
('AustMemorial1.jpg', 29, 'Australian Memorial', 'AustMemorial2.jpg', 'N', '20030708', 150, 90),
('AustMemorial2.jpg', 29, '', '', 'N', '20030703', 780, 466),
('AvignonBridge1.jpg', 29, 'The Bridge at Avignon', 'AvignonBridge2.jpg', 'N', '20030708', 150, 89),
('AvignonBridge2.jpg', 29, '<p>Just 4 of the original 22 arches remain (the first is over the road). The structure between the second and third arches is a chapel.</p>\r\n<p>The day we visited, the road lane closest to the water was fenced off because minor flooding had dumped silt all over it. It was cold and very windy on the bridge making it extremely uncomfortable to stand outside while listening to the commentary on the electronic guide.</p>\r\n<p>If I remember correctly, the guide said that in the Middle Ages, barges weighing as much as 600 tons were dragged up the river by huge teams of horses taking 26 days to reach Lyon from the Mediterranean but only 4 days to get back down again. I don\'t understand how the boats going downstream were controlled since allowing them to float with the current would send them scraping along the bank and they would get stuck on shallow sections. Passing other boats going the opposite way must have been tricky.</p>', '', 'N', '20030703', 780, 463),
('BayeuxTapestry1.jpg', 29, 'Bayeux Tapestry', 'BayeuxTapestry2.jpg', 'N', '20030708', 150, 102),
('BayeuxTapestry2.jpg', 29, '<p>Here, hapless Harold swears on the relics of saints that he will hand over the crown to William who bailed him out of trouble. </p>\r\n<p>The context was that the current king, Edward the Confessor, was old and ailing but left no children. Three men believed they had claim to it of which the two strongest were Harold, Edward\'s brother-in-law and advisor, and William the Duke of Normandy. Edward specified that Harold was to succeed him and told Harold to go tell William the news.</p>\r\n<p>Unfortunately, the boat Harold crossed the English Channel in was blown off-course by a storm and into unfriendly territory. Harold was taken prisoner. William heard the news and came to pay a ransom to win Harold\'s freedom but that meant that Harold was now in William\'s debt. Having limited options, Harold agrees to give up the crown allow William to become king.</p>\r\n<p>Edward dies but Harold, now back in England, ignores his earlier promises and becomes king. William hears the news and raises an army to sail to England to win it back. Harold\'s forces, just returning from repelling a Viking invasion led by the third claimant to the Crown are defeated at the Battle of Hastings in 1066 and William becomes William the Conqueror.</p>\r\n<p><a href=\"http://www.ibiscom.com/bayeux.htm\" target=\"_blank\" class=\"external\">Full details</a>. There is also a complete copy in Reading, England and the website for this piece gives a <a href=\"http://www.bayeuxtapestry.org.uk/BayeuxContents.htm\" target=\"_blank\" class=\"external\">scene-by-scene narrative</a>.</p>', '', 'N', '20030703', 780, 529),
('CanalDuMidi1.jpg', 29, 'Canal du Midi', 'CanalDuMidi2.jpg', 'N', '20030708', 150, 124),
('CanalDuMidi2.jpg', 29, '<p>The Canal du Midi as it passes over the River Orb. This photo is from a postcard as the canal is drained of water during winter. A series of 8 locks is nearby as is a modern innovation: an inclined trough with a moving \"dam\" at the downhill end that pushes a triangle of water uphill taking floating boats with it.</p>\r\n<p>I read somewhere on the internet that this aquaduct was not part of the original construction but the canal and river water were allowed to mix, in which case, there must have been one or two extra locks to raise and lower the boats to the level of the surrounding plain.</p>', '', 'N', '20030703', 780, 644),
('Carcassone1.jpg', 29, 'Carcassonne', 'Carcassone2.jpg', 'N', '20030708', 150, 103),
('Carcassone2.jpg', 29, '<p>The walled city of Carcassonne.</p>\r\n<p>Though the earlier defenses succeeded at holding back Charlamagne i the 9th Century, they did not stop the Albigensian Crusaders from capturing the town in the 13th. The greatest vulnerability of the city was that the water supply was outside the wall and the Crusaders were able to deny residents access. They did the same at nearby Minerve, another town thought to be impregnable, though its defences were natural rather than constructed.</p>', '', 'N', '20030703', 780, 534),
('CentralPark1.jpg', 29, 'At the lake in Central Park.', 'CentralPark2.jpg', 'N', '20030708', 150, 101),
('CentralPark2.jpg', 29, '', '', 'N', '20030702', 780, 524),
('Chenonceau1.jpg', 29, 'Chenonceau', 'Chenonceau2.jpg', 'N', '20030711', 150, 84),
('Chenonceau2.jpg', 29, '<p>During WW1, the owner converted it to a hospital at his own expense. During WW2, the chateau straddled the border between German-occupied territory and that controlled by the Vichy government so people and goods were smuggled through the building. During that war, an American bomb caused minor damage.</p>\r\n<p>See also:</p>\r\n<ul>\r\n<li><a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=ChenonceauGallery2.jpg\">Gallery</a>\r\n<li><a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=ChenonceauStudy2.jpg\">The Green Study</a>\r\n<li><a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=ChenonceauTapestry2.jpg\">Tapestry</a>\r\n<li><a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=ChenonceauFurniture2.jpg\">Furniture</a>\r\n<li><a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=ChenonceauTower2.jpg\">Marques Tower</a>\r\n</ul>', '', 'N', '20030711', 780, 436),
('Chambord1.jpg', 29, 'Chambord', 'Chambord2.jpg', 'N', '20030710', 150, 99),
('Chambord2.jpg', 29, '<p>At one point after construction started in 1519, there were 1800 men working on the project, a hunting lodge for the extravagant Francois I. He even suggested that the mighty Loire River be diverted to run in front of the building. He settled for the smaller Closson. The main staircase, possibly designed by Leonardo da Vinci, is a double-helix or spiral so two people can ascend at once and see each other but not meet.</p>', '', 'N', '20030710', 780, 514),
('ChenonceauFurniture2.jpg', 29, '<p>I wouldn\'t want one of these at my house but it was intersting to see. Black timber with ivory inlays.</p>', '', 'N', '20030710', 399, 580),
('ChenonceauGallery2.jpg', 29, '<p>The gallery that sits over the bridge is 60m/200 ft long. The black tiles are slate but the white is a softer stone that has worn considerably over the centuries so that the floor is now quite uneven.</p>', '', 'N', '20030710', 780, 541),
('ChenonceauStudy2.jpg', 29, '<p>The study of Catherine de Médici. Upon the death of her husband, King Henry II, she ruled France from this room.</p>', '', 'N', '20030713', 780, 541),
('ChenonceauTapestry2.jpg', 29, '<p>One of the tapestries hanging in the Green Study.</p>\r\n<p>From the brochure: \"The 16th Century Brussels tapestry known as \"Birthwort\", both Gothic and Renaissance, is exceptional with its original green color which has turned blue and with its subject, inspired by the discovery of the Americas, their fauna and flora: Peruvian silver, pheasants, pineapples, orchids, pomegranites and vegetables which until then were unknown in Europe.\"</p>\r\n<p>We saw many tapestries on this trip but the colors of many were so faded that they were of little interest. </p>', '', 'N', '20030710', 780, 541),
('ChenonceauTower2.jpg', 29, '<p>The only remaining defensive structure of what was once a fortified mill, the Marques Tower was transformed into Renaissance style, which presumably means replacing arrow slits with proper windows and adding decoration. I thought this would make a fine free-standing house. So much more interesting than anything commonly seen in the suburbs of our major cities.</p>', '', 'N', '20030710', 399, 580),
('FlatironBuilding1.jpg', 29, 'Flatiron Building', 'FlatironBuilding2.jpg', 'N', '20030708', 68, 150),
('FlatironBuilding2.jpg', 29, '<p>Completed in 1902, the elegant 21-storey Flatiron Building is shaped like a tall slice of cake. Like all tall buildings now, it has a steel frame and the external stonework functions mainly to keep out the weather rather than support the structure. </p>\r\n<p>I\'ve read that "the building created unusual eddies which would cause women\'s skirts to fly around as they walked on 23rd Street. This attracted throngs of young men who gathered to view the barelegged spectacle." It was calm the day we visited.</p>', '', 'N', '20030703', 263, 580),
('FormuleOne1.jpg', 29, 'Check-in at Hotel Formule 1.', 'FormuleOne2.jpg', 'N', '20030708', 100, 150),
('FormuleOne2.jpg', 29, '<p>Le hotel automatique. This is the check-in facility at <i>Hotel Formule 1</i>. It looks like an ATM because it takes your credit card, issuing you with a room number and a PIN hat you punch into a keypad next to the door. There is no key. A person is at the front desk only from 5-9pm.</p>', '', 'N', '20030703', 387, 580),
('Intrepid1.jpg', 29, 'The Intrepid.', 'Intrepid2.jpg', 'N', '20030708', 150, 85),
('Intrepid2.jpg', 29, '<p>At the <i>Intrepid</i> floating museum. Lan appears to be saluting to match the military theme but she is just brushing her hair away from her face. Though not carrier-based, an SR-71 spy plane can be seen on the deck.</p>', '', 'N', '20030702', 780, 441),
('DinnerWithFriends1.jpg', 29, 'Dinner with friends.', 'DinnerWithFriends2.jpg', 'N', '20030708', 150, 63),
('DinnerWithFriends2.jpg', 29, '<p>Fabulous dinner thanks to Dorien (far left). The others from left are daughter Willemjin and son Maarten (<a target=\"_blank\" href=\"http://localhost/sweetandsour/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=LanWithWAndM2.jpg\">compare with earlier</a>), Lan, Jaap, Jema and Roderick.</p>\r\n<p>At the end the evening, Jaap and Jema demonstrated the \"simplified kissing method\". When the Dutch greet each other, they kiss three times, first on one side, then the other, then back to the first. If in casual circumstances, kiss once on one side then twice on the other; if in a hurry, kiss three times at once! In France they kiss four times making the method an even bigger time saver.</p>', '', 'N', '20021219', 1000, 417),
('MontStMichel1.jpg', 29, 'Mont St. Michel.', 'MontStMichel2.jpg', 'N', '20030708', 150, 88),
('MontStMichel2.jpg', 29, '<p>Amongst the many interesting things inside was a treadmill, perhaps 5m/16 ft in diameter. Several men would be inside at once and a rope around the outside was used to drag a cart of supplies up a ramp to the top of the island.</p>\r\n<p>See <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=HighTideWarning2.jpg\">high tide warning</a></p>', '', 'N', '20030703', 780, 460),
('DangerUXB2.jpg', 29, '<p>Even after eight-five years, the fields are considered dangerous. I imagine that clearing the area for weapons would damage the trenches that are to be preserved as long as possible. The surrounding area is productive farmland so it presumably has been cleared.</p>\r\n<p>This section of the front was adjacent to a museum in memory of those who came from Newfoundland. It is now part of Canada but at that time it was an independant country within the British Empire, joining Canada in 1949, though Newfoundlanders see it the other way around: Canada joined them!</p>\r\n<p>Although it was sunny for the first time in about two weeks, it was windy and the temperature was slightly below freezing. Lan elected to stay in the car while I ran around the trenches. I was surprised how far it was from the trenches occupied by the opposing armies, perhaps 200m. It now seems utterly ridiculous that anyone would be told to run across no-mans-land in daylight into barbed wire barricades against machine gun fire. I believe the French army mutineed close to the end of the war. While they were willing to defend their country, they were not willing to commit suicide attempting to take the German-held ground.</p>', '', 'N', '20030710', 780, 524),
('DangerUXB1.jpg', 29, 'Danger, unexploded bombs!', 'DangerUXB2.jpg', 'N', '20030710', 150, 101),
('HighTideWarning2.jpg', 29, '<p>Get your car out of the car park by the stated time, or else. Time and tide wait for no man at Mont St. Michel.</p>', '', 'N', '20030710', 780, 522),
('MuidenCastle1.jpg', 29, 'Muiden Castle', 'MuidenCastle2.jpg', 'N', '20030708', 150, 96),
('MuidenCastle2.jpg', 29, '<p>I forgot to take our camera the day we visited and i didn\'t buy a postcard so I looked all over the internet and this is by far the best I found. Reproduced with the kind permission of Laurence Delderfield. check out his stunning photography at <a href=\"http://www.delderfield.nl\" target=\"_blank\">www.delderfield.nl</a>.</p>\r\n<p>Incidentally, when touring castles and grand houses alike, we didn\'t see any bathrooms. In the days before indoor plumbing, there weren\'t any. The solution at this castle was a seat mounted overhanging the moat in a stone tube which was open at the bottom. Lan suggested that the castle\'s defenders should have installed signs around the moat saying \"Swim across at your own risk\" to deter potential attackers.</p>', '', 'N', '20030704', 450, 289),
('OmahaBeach1.jpg', 29, 'Omaha Beach', 'OmahaBeach2.jpg', 'N', '20030708', 150, 86),
('OmahaBeach2.jpg', 29, '<p>The memorial at Omaha Beach.</p>\r\n<p>I was surprised by the relatively gentle slope of the land behind the beach. I can\'t see that ladders or ropes would have been required here. It was even flatter to the east where the British and Canadians landed. If you saw <i>Saving Private Ryan</i>, that was set on Utah Beach which is the next beach to the west and the ground behind the beach is apparently much steeper. Of course, the slope would not have been much of a concern were it not for the machine guns, mines and barbed wire.</p>', '', 'N', '20030703', 780, 445),
('PontDuGard1.jpg', 29, 'Pont du Gard', 'PontDuGard2.jpg', 'N', '20030708', 150, 103),
('PontDuGard2.jpg', 29, '<p>Compare this aquaduct in France with the one at <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=SegoviaAquaduct2.jpg\">Segovia</a> in Spain that Lan saw in 1996.</p>', '', 'N', '20030703', 780, 533),
('QuintaTheDog1.jpg', 29, 'Quinta the dog.', 'QuintaTheDog2.jpg', 'N', '20030708', 109, 150),
('QuintaTheDog2.jpg', 29, '<p>With Quinta, our favorite four-legged friend at Jaap and Dorien\'s house. Note the security blanket. I normally don\'t like domestic animals in general and dobs in particular but Quinta as indeed special.</p>\r\n<p>We went for a walk in the woods with Jaap and Quinta on the day we arrived and were amused to hear that when Jaap has company like us, Quinta will run well out of site and reappear after a minute or so but when Jaap is by himself, Quinta will stay close by. Quinta presumably figures that Jaap needs protection, or perhaps will get lost without someone or something to guide him home.</p>', '', 'N', '20030708', 423, 580),
('SommeTrenches1.jpg', 29, 'Trenches at the site of the Battle of the Somme.', 'SommeTrenches2.jpg', 'N', '20030708', 150, 81),
('SommeTrenches2.jpg', 29, '<p>While I found it very moving to walk through the trenches where a major battle had taken place, i had to recognize that what I see now is utterly benign. The trenches are covered in grasses now but during the Battle of the Somme, men would have been standing in the cold during winter, coping with mud in the spring and flies in the summer. Death, stench and disease all year round. One of the guides at the visitors center told there were no winter offensives in World War 1 since the troops first concern was attempting to keep warm.</p>\r\n<p>However, I was unable to find out if something I remember from my high school history had happened at the Somme. On Christmas Eve 1914, the fighting stopped and both sides sang carols, then on Christmas Day, soldiers went across no-mans-land to greet each other and in some sectors, games of soccer broke out! The generals were completely against this as they didn\'t want their soldiers to see that their enemies, demonized by propaganda, were actually normal human beings just like themselves. It is harder to shoot someone you\'ve met. It didn\'t happen again.</p>\r\n<p>If you haven\'t already, I highly recommend you see the film (or read the book) <i>All Quiet on the Western Front</i> which shows the war from the German side and <i>Gallipoli</i> which although not set on the Western Front, is also a good lesson in WW1 history.</p>\r\n<p>I also visited an excellent, though depressing museum in nearby Albert. It turns out that the British and Allied trenches were far worse than those of the Germans. The Germans had invaded and generally captured the higher ground so their trenches were well drained. They intended to stay for some time so they built extensive underground shelters and living space. in contrast, the British attitude was to advance all the time, no matter what the cost, in which case, there was no need arrange for any degree of comfort. In any case, since they had the lower ground, trenches and dugouts tended to flood. French trenches were somewhere between the two.</p>', '', 'N', '20030703', 780, 420),
('StatueOfLiberty1.jpg', 29, 'Artist\'s impression.', 'StatueOfLiberty2.jpg', 'N', '20030708', 100, 150),
('StatueOfLiberty2.jpg', 29, '<p>You already know what the Statue of Liberty looks like so there is no point in me showing you another standard view. This is an artist\'s impression of it as it might look if the Taliban had defeated America rather than the other way around.</p>', '', 'N', '20030520', 233, 350),
('TheaterOrange1.jpg', 29, 'Roman theater', 'TheaterOrange2.jpg', 'N', '20030708', 122, 150),
('TheaterOrange2.jpg', 29, '<p>The Roman theater in Orange seats 7000 and was built in the last decade before Christ. It is one of only 3 that retain the wall behind the stage, the others being in Turkey and Syria amking them rather less accessible. Events are still held there.</p>\r\n<p>In the letter, I mention that a statue of Caeser looks down on the audience to remind everyone where the real power lies. i didn\'t bother taking a photo of the statue as I assumed it to be a copy. In fact, the pieces of the original statue were discovered at the base of the wall and the statue was reassembled, though the heads were made to be removable making it easier to adjust to changes in Roman politics.</p>', '', 'N', '20030705', 471, 580),
('Turtle1.jpg', 29, 'The Turtle', 'Turtle2.jpg', 'N', '20030708', 150, 137),
('Turtle2.jpg', 29, '<p>Lan demonstrates a replica of the <i>Turtle</i> a one-man submarine powered by a hand-cranked propellor. In the first known submarine attack, the Turtle failed to sink a British warship that was blockading New York Harbor in 1776 during the Revolutionary War.</p>', '', 'N', '20030707', 780, 714),
('Twingo1.jpg', 29, 'Le Twingo fantastique!', 'Twingo2.jpg', 'N', '20030708', 150, 89),
('Twingo2.jpg', 29, '<p>Fantastic except for the metallic dark olive color. See also <a href=\"http://www.renault.com/renault_com/en/main/40_VEHICULES_ET_SERVICES/10_Vehicules/Catalogue/Twingo/index.aspx\" target=\"_blank\">Renault\'s site</a> and a <a href=\"http://www.twingo.net\" target=\"_blank\">private devotional site</a> with model history.</p>\r\n<p>Tom and Ray from the <i>Car Talk</i> radio show have suggested that <i>The French copy nobody ... and nobody copies the French!</i>. In this case, that\'s a pity as this is a fabulous car.\r\n', '', 'N', '20030703', 780, 463),
('USCemetary2.jpg', 29, '<p>This immaculate cemetry holds the bodies of 9286 Americans that died during the Normandy invasion.</p>', '', 'N', '20030713', 780, 513),
('USCemetary1.jpg', 29, 'US military cemetary near Caen.', 'USCemetary2.jpg', 'N', NULL, NULL, NULL),
('Usse1.jpg', 29, 'Ussé', 'Usse2.jpg', 'N', '20030710', 150, 85),
('Usse2.jpg', 29, '<p>Uss', '', 'N', '20030710', 780, 442),
('Vaucluse1.jpg', 29, 'Fontaine de Vaucluse', 'Vaucluse2.jpg', 'N', '20030708', 150, 99),
('Vaucluse2.jpg', 29, '<p>It had been raining for most of the two weeks prior to our arrival and so all the local rivers were close to flood level, including this one. Water had seeped through the rocks on the plateau and no surged out of the ground at this exit to form an instant river.</p>', '', 'N', '20030705', 780, 517),
('Villandry1.jpg', 29, 'Villandry', 'Villandry2.jpg', 'N', '20030711', 150, 92),
('Villandry2.jpg', 29, '<p>The nine square gardens in front of the house are planted with colored vegetables, particularly cabbages. Even at the start of winter, the garden was colorful.</p>\r\n<p><a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=VillandryHedges2.jpg\">Hedge garden</a>.<br>\r\n The prettiest <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=VillandryShed2.jpg\">toolshed</a> in Europe.</p>', '', 'N', '20030713', 780, 479),
('VillandryHedges2.jpg', 29, '<p>I read that there are 52km/32 miles of hedges on the grounds.</p>', '', 'N', '20030710', 780, 500),
('VillandryShed2.jpg', 29, '<p>In fact, this eleborate garden toolshed was in a terrible state of disrepair. You\'ll notice that only one shutter hangs over the false window to the right. Everything else on the property was beautifully cared for so this seemed a strange anomaly.</p>', '', 'N', '20030710', 780, 562),
('AcrobatIcon_Ltr16_Ltr.gif', 29, 'Printer-friendly version (PDF, 600kb).', '', 'N', '20010304', 36, 35),
('FranceMap1.gif', 29, 'Trip route.', '', 'N', '20030708', 131, 150),
('LanWithWAndM1.jpg', 2, 'Lan in 1981 with two special people.', 'LanWithWAndM2.jpg', 'N', '20030711', 102, 150),
('LanWithWAndM2.jpg', 2, '<p>Lan in 1981 with Willemjin and Maarten. Their mother Dorien came to the refugee camp in Singapore to teach English and French and took Lan home from time to time.</p>\r\n\r\n<p>Lan\'s clothes were provided by the United Nations High Commissioner for Refugees and you can see the trousers don\'t fit. She looks older here than she did when we were married ten years later.</p>', '', 'N', '20030711', 395, 580),
('AzayLeRideau1.jpg', 29, 'Azay le Rideau', 'AzayLeRideau2.jpg', 'N', '20030711', 150, 92),
('AzayLeRideau2.jpg', 29, '<p>This chateau sits adjacent to the River Cher and a weir just upstream diverts water through an artificial lake around the builing. Very pleasant though it must have been cold in winter if our experience is any guide.</p>', '', 'N', '20030711', 780, 479),
('City1.jpg', 11, 'Sydney city and the Opera House', 'City2.jpg', 'N', '20050225', 150, 41),
('NorthSydney1.jpg', 11, 'Harbour Bridge looking towards North Sydney.', 'NorthSydney2.jpg', 'N', '20050225', 150, 51),
('panoramaGrandLake1a.jpg', 46, 'Grand Lake, CO (28kb). Or <a target=\"_blank\" href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=panoramaGrandLake2b.jpg&panorama=true&panoWidth=640&panoHeight=400\">more detail</a> (240kb)', 'panoramaGrandLake2a.jpg', 'N', '20060109', 150, 112),
('panoramaOffice1a.jpg', 46, 'My office (39kb). Or <a target=\"_blank\" href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=panoramaOffice2b.jpg&panorama=true&panoWidth=700&panoHeight=470\">more detail</a> (169kb)', 'panoramaOffice2a.jpg', 'N', '20050313', 150, 80),
('panoramaSydney.jpg', 46, 'Sydney panorama! ', 'panoramaSydney199.jpg', 'N', '20060106', 150, 113),
('panoramaGrandLake2a.jpg', 46, '', '', 'N', '20050301', 2050, 200),
('panoramaGrandLake2b.jpg', 46, '', '', 'N', '20050228', 6909, 674),
('panoramaOffice2a.jpg', 46, '', '', 'N', '20050313', 2084, 200),
('panoramaOffice2b.jpg', 46, '', '', 'N', '20090613', 4347, 470),
('panoramaSydney199.jpg', 46, 'Or see <a target=\"_blank\" href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=panoramaSydney398.jpg&panorama=true&panoWidth=600&panoHeight=398\">large </a> (211kb), <a target=\"_blank\" href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=panoramaSydney796.jpg&panorama=true&panoWidth=1200&panoHeight=796\"> extra large </a> (785kb), <a target=\"_blank\" href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=panoramaSydney796.jpg&panorama=true&panoWidth=1200&panoHeight=796\"> extra large with more detail for zooming</a> (1.5MB).', '', 'N', '20051226', 2118, 199),
('panoramaSydney398.jpg', 46, '', '', 'N', '20051226', 4234, 398),
('panoramaSouthmoorPark1.jpg', 46, 'Southmoor Park (55kb). Or <a target=\"_blank\" href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=panoramaSouthmoorPark2b.jpg&panorama=true&panoWidth=640&panoHeight=400\">more detail</a> (198kb)', 'panoramaSouthmoorPark2a.jpg', 'N', '20060109', 150, 112),
('panoramaSouthmoorPark2b.jpg', 46, '', '', 'N', '20050319', 4038, 400),
('panoramaSouthmoorPark2a.jpg', 46, '', '', 'N', '20050319', 2019, 200),
('saguaroCactus1.jpg', 30, 'Often seen in the background of Western films, saguaro (pronounced sah-wah-roh) cacti cope with the desert climate by growing very slowly and storing water. ', 'saguaroCactus2.jpg', 'N', '20050329', 99, 150),
('saguaroCactus2.jpg', 30, '<a href=\"http://en.wikipedia.org/wiki/Saguaro\" target=\"_blank\" class=\"external\">More from Wikipedia …</a>', '', 'N', '20050327', 526, 800),
('PhoenixBotanical1.jpg', 30, 'At the Phoenix Botanical Gardens. Note Lan at the lower-left.', 'PhoenixBotanical2.jpg', 'N', '20050329', 103, 150),
('PhoenixBotanical2.jpg', 30, '<p>Unfortunately the photo does not convey how hot it is!</p>', '', 'N', '20050327', 549, 800),
('archStLouis1.jpg', 30, 'St. Louis, Missouri—the only city in the world with its own carry handle. The shape suggests corporate sponsorship by McDonalds.', 'archStLouis2.jpg', 'N', '20050329', 150, 98),
('archStLouis2.jpg', 30, '', '', 'N', '20050327', 980, 638),
('I-70Trucking1.jpg', 30, 'Headed east across the mid-West on I-70. What better way to represent this exciting piece of America than a combine harvester on the back of a flatbed overtaking an Air Force semi-trailer?', 'I-70Trucking2.jpg', 'N', '20050329', 150, 80),
('I-70Trucking2.jpg', 30, '', '', 'N', '20050329', 980, 522),
('baptism1.jpg', 30, 'With Lan’s sister Loan and family after the baptism. I find it hard to blend in among any group of Vietnamese. The older son Duy (pronounced Yee) is lovely.', 'baptism2.jpg', 'N', '20050329', 150, 80),
('baptism2.jpg', 30, '', '', 'N', '20050329', 980, 522),
('WashingtonMonument1.jpg', 30, 'On the Mall looking towards the Washington Monument. Various national institutions are scattered around this strip including the Capitol (where Congress meets), the Smithsonian museums, and memorials for President Lincoln, WW2 and the wars in Vietnam and Korea.', 'WashingtonMonument2.jpg', 'N', '20050329', 99, 150),
('WashingtonMonument2.jpg', 30, '', '', 'N', '20050327', 527, 800),
('RenoRdAngle1.jpg', 30, 'The rather grand house at 4610 Reno Rd. I once tried digging a tunnel from the front garden to a friend', 'RenoRdAngle2.jpg', 'N', '20050329', 150, 101),
('RenoRdAngle2.jpg', 30, '', '', 'N', '20050327', 980, 658),
('boneShip1.jpg', 30, 'Model ship made by French prisoners captured by the English during the Nepoleonic wars (early 1800s). The hull is perhaps 50cm/20" long. Targeting their market, the models were generally based on English ships rather than French.', 'boneShip2.jpg', 'N', '20050329', 114, 150),
('boneShip2.jpg', 30, '', '', 'N', '20050327', 607, 800),
('99Escort1.jpg', 30, '99 Ford Escort. Loaded. There was still room for several toothpicks if carefully placed.', '99Escort2.jpg', 'N', '20050329', 150, 80),
('99Escort2.jpg', 30, '', '', 'N', '20050329', 980, 522),
('debateBulge1.jpg', 30, '"Hey Karl, what’s the frequency?"', 'debateBulge2.jpg', 'N', '20050329', 100, 150),
('debateBulge2.jpg', 30, '<p>There is reasonably compelling evidence that Mr Bush was coached during the first two debates with Mr Kerry. If so, what the American public saw was a fraud. There is <i>something</i> under his jacket and the best explanation the White House could manage was a poorly tailored suit. Here are the <a href=\"http://www.theregister.co.uk/2004/10/12/bush_wireless_coaching/\" target=\"_blank\" class=\"external\">details</a>.</p>', '', 'N', '20050327', 184, 275),
('electionMap1.jpg', 30, 'Although created as a joke, this map reflects the painful reality that states that voted Democrat are perhaps culturally closer to Canada than to the states that went Republican. ', 'electionMap2.jpg', 'N', '20050329', 150, 130),
('electionMap2.jpg', 30, '<p>The map of <a target=\"_blank\" href=\"http://www.nytimes.com/packages/html/politics/2004_ELECTIONRESULTS_GRAPHIC/\">election results</a> has an interesting correlation with the map of <a target=\"_blank\" href=\"http://www.learner.org/biographyofamerica/prog10/maps/\">"free states" and "slave states"</a> before the Civil War. Make your own judgement of what this means, if anything.</p>', '', 'N', '20050327', 427, 369),
('CharlotteEleanor1.jpg', 30, 'Charlotte and Eleanor. I can’t recall if Charlotte was pretending to be a monster or if she was just desperate to get away from us.', 'CharlotteEleanor2.jpg', 'N', '20050329', 150, 80),
('CharlotteEleanor2.jpg', 30, '', '', 'N', '20050329', 978, 522),
('PeterBowling1.jpg', 30, 'Still trying to find the correct way to position my tongue when releasing the ball. Nice shoes! Photo credit to Nam.', 'PeterBowling2.jpg', 'N', '20050402', 150, 113),
('PeterBowling2.JPG', 30, '', '', 'N', '20050402', 980, 738),
('AcrobatIcon_Ltr17.gif', 30, 'Printer-friendly version (PDF, 686kb).', '', 'N', '20010304', 36, 35),
('basement.jpg', 60, 'The basement. The ancient furnace will be replaced in mid-November. The washer and drier connections are in the corner behind the furnace. The furnace installation requires wall penetrations to supply combustion air so while they are at it, they will install a proper drier exhaust vent.', '', 'N', '20051029', 760, 570),
('bathroom1.jpg', 60, 'The bathroom. The rack over the toilet was left by the previous tenant in 2721 and is not in the others.', '', 'N', '20051029', 570, 760),
('bathroom2.jpg', 60, 'Washbasin and mirror.', '', 'N', '20051029', 570, 760),
('closet1stBed_1.jpg', 60, 'Smaller closet in first bedroom.', '', 'N', '20051029', 760, 570),
('closet1stBed_2.jpg', 60, 'Larger closet in first bedroom (over stairs). Note the cement block wall separating you from your neighbor.', '', 'N', '20051029', 760, 570),
('closet2ndBed.jpg', 60, 'Closet second bedroom. Sorry it’s blurry.', '', 'N', '20051029', 760, 570),
('kitchen1.jpg', 60, 'Kitchen. Back door on the left.', '', 'N', '20051029', 760, 570),
('kitchen2.jpg', 60, 'Kitchen. Box above rangehood is not a cupboard. Empty space below countertop to right of stoveis a bit of a mystery. It’s the right size for a dishwasher but there is one on the opposite wall. ', '', 'N', '20051029', 570, 760),
('linenCloset.jpg', 60, 'Linen closet.', '', 'N', '20051029', 570, 760),
('lookingNW.jpg', 60, 'Outside view looking northwest. 2721 is at the far left; 2729 at the far right. The building is an L-shape but the corner of the L is open so 2725 (third from left) doesn\'t share any more than a yard of common wall with 2729 (fourth from left).', '', 'N', '20051029', 760, 570),
('lookingSW.jpg', 60, 'Outside view looking southwest. Note that 2729 has an extra set of windows facing the street. In the next few months, we intend erecting some fences at the back of each townhouse so that everyone has a private spot to have a barbeque etc. 2721-2725 will also get some proper paths out to the carpark at rear.', '', 'N', '20051029', 760, 570),
('basement_sm.jpg', 60, 'Basement.', 'basement.jpg', 'N', '20051029', 150, 113),
('bathroom1_sm.jpg', 60, 'Bathroom.', 'bathroom1.jpg', 'N', '20051029', 113, 151),
('bathroom2_sm.jpg', 60, 'Bathroom.', 'bathroom2.jpg', 'N', '20051029', 113, 151),
('closet1stBed_1_sm.jpg', 60, 'Smaller closet main bedroom.<br /> <br /> <br /> <br /> ', 'closet1stBed_1.jpg', 'N', '20051029', 150, 113),
('closet1stBed_2_sm.jpg', 60, 'Larger closet main bedroom.', 'closet1stBed_2.jpg', 'N', '20051029', 150, 113),
('closet2ndBed_sm.jpg', 60, 'Closet second bedroom.', 'closet2ndBed.jpg', 'N', '20051029', 150, 113),
('floorplan.gif', 60, 'Floorplan (PDF - 17kb)', '', 'N', '20051029', 150, 120),
('kitchen1_sm.jpg', 60, 'Kitchen - dishwasher, sink, refrigerator.', 'kitchen1.jpg', 'N', '20051029', 150, 113),
('kitchen2_sm.jpg', 60, 'Kitchen - stove.', 'kitchen2.jpg', 'N', '20051029', 113, 151),
('linenCloset_sm.jpg', 60, 'Linen closet.', 'linenCloset.jpg', 'N', '20051029', 113, 151),
('lookingNW_sm.jpg', 60, 'Looking NW from street.', 'lookingNW.jpg', 'N', '20051029', 150, 113),
('lookingSW_sm.jpg', 60, 'Looking SW from street.', 'lookingSW.jpg', 'N', '20051029', 150, 113),
('bewareoftrainssm.jpg', 52, 'I just thought it was odd since there are no rails in sight.', 'bewareoftrainslg.jpg', 'N', '20051231', 150, 113),
('bewareoftrainslg.jpg', 52, '', '', 'N', '20051230', 760, 570),
('birdatseamanstsm.jpg', 52, 'Curious little bird on the fence.', 'birdatseamanstlg.jpg', 'N', '20051231', 150, 113),
('birdatseamanstlg.jpg', 52, '', '', 'N', '20051230', 760, 570),
('bowling2005_1sm.jpg', 52, 'Eleanor strikes a pose.', 'bowling2005_1lg.jpg', 'N', '20051231', 150, 113),
('bowling2005_1lg.jpg', 52, '', '', 'N', '20051230', 760, 570),
('bowling2005_2sm.jpg', 52, 'Viet waiting on results.', 'bowling2005_2lg.jpg', 'N', '20051231', 150, 113),
('bowling2005_2lg.jpg', 52, '', '', 'N', '20051230', 760, 570),
('bowling2005_3sm.jpg', 52, 'Nam lets another missile loose.', 'bowling2005_3lg.jpg', 'N', '20051231', 150, 113),
('bowling2005_3lg.jpg', 52, '<p>The boys playing in the far lane started without the barriers to prevent the ball falling into the side channels but found that our scores suffered accordingly so we asked the attendant to put them back up.</p>', '', 'N', '20051230', 760, 570),
('bowling2005_4sm.jpg', 52, 'Catherine', 'bowling2005_4lg.jpg', 'N', '20051231', 150, 113),
('bowling2005_4lg.jpg', 52, '', '', 'N', '20051230', 760, 570),
('bowling2005_5sm.jpg', 52, 'Nam displaying concentration.', 'bowling2005_5lg.jpg', 'N', '20051231', 150, 113),
('bowling2005_5lg.jpg', 52, '<p>Nice shoes!</p>', '', 'N', '20051230', 760, 570),
('bowling2005_6sm.jpg', 52, 'Charlotte demonstrating the technique that had her beating all of us till the last few rounds.', 'bowling2005_6lg.jpg', 'N', '20051231', 150, 113),
('bowling2005_6lg.jpg', 52, '', '', 'N', '20051230', 760, 570),
('bowling2005_7sm.jpg', 52, 'Grace, poise and elegance; it must be Catherine.', 'bowling2005_7lg.jpg', 'N', '20051231', 150, 113),
('bowling2005_7lg.jpg', 52, '', '', 'N', '20051230', 760, 570),
('centerpointtowersm.jpg', 52, '<a href=\"http://en.wikipedia.org/wiki/Sydney_Tower\" target=\"_blank\" class=\"external\">Sydney Tower</a> taken from Hyde Park. ', 'centerpointtowerlg.jpg', 'N', '20051231', 150, 113),
('centerpointtowerlg.jpg', 52, '<p>Actually, it isn\'t that tall being just 5m taller than the <a href=\"http://en.wikipedia.org/wiki/Eiffel_Tower\" target=\"_blank\" class=\"external\">Eiffel Tower</a> which is 90 years older and thus only a little more than half the height of the <a href=\"http://en.wikipedia.org/wiki/CN_Tower\" target=\"_blank\" class=\"external\">CN Tower</a> which was built at about the same time.</p>', '', 'N', '20051230', 760, 570),
('charlotteexhaustedsm.jpg', 52, 'This is what happens if you take a 5 year old out bowling, then to lunch, then swimming.', 'charlotteexhaustedlg.jpg', 'N', '20060101', 150, 112),
('charlotteexhaustedlg.jpg', 52, '<p>Dignity retained thanks to Uncle Peter. Actually, she had her swimmers on.</p>', '', 'N', '20060101', 760, 570),
('coledalebeachsm.jpg', 52, 'On the beach at tiny Coledale between Sydney and Wollongong.', 'coledalebeachlg.jpg', 'N', '20051231', 150, 113),
('coledalebeachlg.jpg', 52, '<p>The beach babes catching some rays are Lan and Catherine. The flag marks the edge of the area watched by the Life Guards.</p>', '', 'N', '20051230', 760, 570),
('easyafternoonattonssm.jpg', 52, 'An easy afternoon with sister Le and niece Catherine.', 'easyafternoonattonslg.jpg', 'N', '20051231', 150, 113),
('easyafternoonattonslg.jpg', 52, '', '', 'N', '20051230', 760, 570),
('fatheroflansm.jpg', 52, 'Lan\'s father\'s resting place.', 'fatheroflanlg.jpg', 'N', '20051231', 150, 113),
('fatheroflanlg.jpg', 52, '<p>I questioned whether is was OK to smile for a photo at a cemetary but Lan said it was OK. In any case, smiles and cameras are inseparable in Lan’s case.</p>', '', 'N', '20051230', 760, 570),
('grogansworthsm.jpg', 52, 'Flock of sheep on cousin Kim\'s farm where we visited my great aunt Nicole.', 'grogansworthlg.jpg', 'N', '20060102', 150, 113),
('grogansworthlg.jpg', 52, '<p>While we were sharing a cup of tea with Nicole, Kim was busy herding sheep. He is on the ATV above the second fence post from the left.</p>', '', 'N', '20060102', 760, 570),
('harbourbridgefromrockssm.jpg', 52, 'The Harbour Bridge in the background towers over the Rocks historical district.', 'harbourbridgefromrockslg.jpg', 'N', '20051231', 150, 113),
('harbourbridgefromrockslg.jpg', 52, '<p>The entrance to the Bridge Climb is noted by the flags on the left.</p>', 'harbourbridgefromrockslg.jpg', 'N', '20051230', 760, 570),
('harbourbridgenorthboundsm.jpg', 52, 'A view of the Harbour Bridge notable for the lack of traffic', 'harbourbridgenorthboundlg.jpg', 'N', '20051231', 150, 113),
('harbourbridgenorthboundlg.jpg', 52, '<p>Yes, snapping (pictures) and driving is probably dangerous and maybe against the law but it would have been even riskier to stand at this location and take the photo. </p>\r\n<p>On the way south at about 6am, I was confused by lane closures and unfamiliar signs and at arrival at the toll booths, found myself in a lane exclusively for vehicles carrying electronic passes. I had to back up and get to another booth four lanes over that accepted cash ($3) which caused some amusement for the toll collector and would have been nearly impossible at any other time.', '', 'N', '20051230', 760, 570),
('panoramaBoulder.jpg', 46, 'Boulder lookout on US36.', 'panoramaBoulder200.jpg', 'N', '20060203', 150, 113),
('holmesstdrivewaysm.jpg', 52, 'The driveway, apparently through the jungle, to our house. ', 'holmesstdrivewaylg.jpg', 'N', '20051231', 150, 113);
INSERT INTO `photos` (`photoName`, `folderID`, `caption`, `linkedImg`, `linkToFullSize`, `version`, `width`, `height`) VALUES
('holmesstdrivewaylg.jpg', 52, '<p>Unfortunately, the photo doesn\'t convey that the driveway is best suited to mountain goats. My <a href=\"/imagemgt/index.php?fuseAction=showPhotoAndCaption&photoName=NissanPulsar2.jpg\">Nissan Pulsar</a> was unable to get up the hill on cold mornings (10°C/50°F) until warmed up.</p>', '', 'N', '20051230', 760, 570),
('holmesstgardensm.jpg', 52, 'The garden.', 'holmesstgardenlg.jpg', 'N', '20051231', 150, 113),
('holmesstgardenlg.jpg', 52, '<p>While it is nice to have trees in and around the property, it does mean that most of the garden is in the shade most of the time. When we bought the house in 1991, the weeds were waist high (chest high on Lan) and concealed some fallen trees, a broken swing set and a crushed shed. We took 6 tons of rubbish to the tip!</p>', '', 'N', '20051230', 760, 570),
('holmessthousesm.jpg', 52, 'Our house. We bought it in 1991 but have only lived in it together for 1 year and I lived in it for 8 months in 1998. It has been rented out for the remainder.', 'holmessthouselg.jpg', 'N', '20051231', 150, 113),
('holmessthouselg.jpg', 52, '<p>Our house is <a href=\"http://www.whereis.com/whereis/mapping/geocodeAddress.do?advertiserId=&streetNumber=6&streetName=holmes+st&poiType=&suburb=turramurra&state=New+South+Wales&x=31&y=2\" target=\"_blank\" class=\"external\">here</a> and is about 1km horizonally from Turramurra railway station. It feels like 0.5km vertically when walking there.</p>', '', 'N', '20051230', 760, 570),
('holmesstlorikeet1sm.jpg', 52, 'A lorikeet in a tree be beside our driveway.', 'holmesstlorikeet1lg.jpg', 'N', '20051231', 150, 113),
('holmesstlorikeet1lg.jpg', 52, '', '', 'N', '20051230', 760, 570),
('holmesstlorikeet2sm.jpg', 52, '', 'holmesstlorikeet2lg.jpg', 'N', '20051231', 150, 113),
('holmesstlorikeet2lg.jpg', 52, '', '', 'N', '20051230', 760, 570),
('holmessttree1sm.jpg', 52, 'One of the eucalyptus trees beside the driveway. ', 'holmessttree1lg.jpg', 'N', '20051231', 150, 113),
('holmessttree1lg.jpg', 52, '<p>We are in a bit of a valley so the trees are relatively protected and able to grow tall.</p>', '', 'N', '20051230', 760, 570),
('holmessttree2sm.jpg', 52, 'Lan beside said tree.', 'holmessttree2lg.jpg', 'N', '20051231', 150, 113),
('holmessttree2lg.jpg', 52, '<p>Either that is a big tree or a small wife—or both.</p>', '', 'N', '20051230', 760, 570),
('hornsbyfountainsm.jpg', 52, 'The Hornsby Water Clock.', 'hornsbyfountainlg.jpg', 'N', '20051231', 150, 113),
('hornsbyfountainlg.jpg', 52, '<p>Sorry. Lousy photo with the top chopped off. The sun was on the preview screen and people kept walking past so I had to wait for a moment where I could actually get it in the picture. I was surprised that I couldn\'t find anything significant on the internet about it.</p>', '', 'N', '20051230', 760, 570),
('kookaburrabathsm.jpg', 52, 'Kookaburra about to splash down.', 'kookaburrabathlg.jpg', 'N', '20051231', 150, 113),
('kookaburrabathlg.jpg', 52, '<p>Yes, the pool really was that color. :-( I was surprised that mother would even consider a house with a pool but by the end of our visit, I had worked out the unmarked plumbing, forced the random cleaning device to actually cover the whole pool, cleaned out the jacuzzi and dumped in some chlorine so it was looking nice. :-) I even swam in it (though the first time was mainly to retrieve something that fell in).</p>', '', 'N', '20051230', 760, 570),
('kookaburraonfencesm.jpg', 52, 'A <a href=\"http://en.wikipedia.org/wiki/Kookaburra\" target=\"_blank\" class=\"external\">kookaburra</a> sitting on the fence contemplating a bath.', 'kookaburraonfencelg.jpg', 'N', '20051231', 150, 113),
('kookaburraonfencelg.jpg', 52, '<p>I added the yellow ring. It is not a child’s hoop mounted on the fence.</p>', '', 'N', '20051230', 760, 570),
('laneleanorcharlottesm.jpg', 52, 'Lan with my sister’s daughters, Eleanor (left) and Charlotte.', 'laneleanorcharlottelg.jpg', 'N', '20051231', 150, 113),
('laneleanorcharlottelg.jpg', 52, '<p>Lan said to Charlotte that \"You are so small!\" to which Charlotte replied, \"But I', '', 'N', '20051230', 760, 570),
('leavingadelaidesm.jpg', 52, 'Adelaide, a city of a million residents, doesn\'t have jetbridges at the airport to board the plane out of the weather!', 'leavingadelaidelg.jpg', 'N', '20051231', 150, 113),
('leavingadelaidelg.jpg', 52, '<p>However, it was a beautiful day when we arrived and a beautiful day when we left. Incidentally, boarding the plane through the rear door as well as the front made loading and unloading very quick. At Sydney the jetbridge was used for those in the front half of the cabin while those of us at the back went on to the tarmac to board through the rear. Turnaround on leaving Adelaide was an impressive 28 minutes.</p>', '', 'N', '20051230', 760, 570),
('newcastlefreeway1sm.jpg', 52, 'On the F3 freeway, approaching the bridge over the engagingly-named Kangy Angy Creek. ', 'newcastlefreeway1lg.jpg', 'N', '20051231', 150, 113),
('newcastlefreeway1lg.jpg', 52, '<p>(Can someone confirm the location?) I assume the name is aboriginal.</p>', '', 'N', '20051230', 760, 570),
('newcastlefreeway2sm.jpg', 52, 'On the rise after crossing the Kangy Angy. ', 'newcastlefreeway2lg.jpg', 'N', '20051231', 150, 113),
('newcastlefreeway2lg.jpg', 52, '<p>Incidentally, that car on the right is a Holden Commodore which American readers might be interested to know shares some genes with the discontinued Cadillac Catera, both being derived from the European <a href=\"http://en.wikipedia.org/wiki/General_Motors_Omega\" target=\"_blank\" class=external\">Omega</a>.</p>', '', 'N', '20051230', 760, 570),
('newmarkethotelsm.jpg', 52, 'Old "pub" at the downtown end of Port Road, Adelaide.', 'newmarkethotellg.jpg', 'N', '20051231', 150, 113),