Hi all,
Apologies for the size of this email, I hope all mapinfo-l listers understand. A
bit off topic but I'm looking for assistance to populate a table of sunrise and
sunset times for each day of the Torch Relay through Australia. The Torch Relay
is finally underway, currently travelling around Greece before SOCOG takes over
from Guam in the Pacific.
To all those people who offered their help before, thank you.
The following table shows the date, and coords of each of the final destinations
of the Torch Relay for each day. I know of one website that can calculate
sunrise and sunset (www.auslig.gov.au), but it is clunky to use when one has no
time. I'm sure someone out there in MapInfo land has a more efficient means of
obtaining the data. To calculate sunrise, we can use the coords of the previous
days final destination. Coordinates are AGD66 multiplied by 1,000,000. ie (
133862436,-23705209) is (133.86E, 23.70S)
I haven't made any allowance for Olympic Daylight Savings Time, where we put our
clocks forward by 1.5 hours (I kid you not) for the Games.
Any help mapinfo-l can provide is greatly appreciated! Again, sorry for the size
of the email
Ant Burnett
Sydney 2000 Olympic Torch Relay
Sydney Australia
DayID DayDate Town State XCoord YCoord GMT
1 08-Jun-00 Alice Springs
NT 133862436
-23705209 GMT+9.5
2 09-Jun-00 Mount Isa
QLD 139490137
-20729724 GMT+10
3 10-Jun-00 Toowoomba
QLD 151951146
-27570614 GMT+10
4 11-Jun-00 Coolangatta
QLD 153534530
-28171548 GMT+10
5 12-Jun-00 Woodridge
QLD 153101630
-27638740 GMT+10
6 13-Jun-00 Ipswich
QLD 152758187
-27615800 GMT+10
7 14-Jun-00 Brisbane
QLD 153021596
-27471368 GMT+10
8 15-Jun-00 Bokarina
QLD 153131535
-26736011 GMT+10
9 16-Jun-00 Tewantin
QLD 153021711
-26389730 GMT+10
10 17-Jun-00 Kingaroy
QLD 151834611
-26546397 GMT+10
11 18-Jun-00 Hervey Bay
QLD 152872240
-25285350 GMT+10
12 19-Jun-00 Bundaberg
QLD 152346560
-24872195 GMT+10
13 20-Jun-00 Rockhampton
QLD 150504978
-23379450 GMT+10
14 21-Jun-00 Emerald
QLD 148156734
-23527264 GMT+10
15 22-Jun-00 Mackay
QLD 149186440
-21144375 GMT+10
16 23-Jun-00 Airlie Beach
QLD 148711236
-20270198 GMT+10
17 24-Jun-00 Townsville
QLD 146814908
-19264480 GMT+10
18 25-Jun-00 Innisfail
QLD 146029419
-17527401 GMT+10
19 26-Jun-00 Cairns
QLD 145774020
-16923354 GMT+10
20 27-Jun-00 Port Douglas
QLD 145464176
-16483761 GMT+10
21 28-Jun-00 Katherine
NT 132262992
-14465092 GMT+9.5
22 29-Jun-00 The Gardens
NT 130835313
-12451924 GMT+9.5
23 30-Jun-00 Broome
WA 122231421
-17957006 GMT+8
24 01-Jul-00 Carnarvon
WA 113654378
-24886769 GMT+8
25 02-Jul-00 Albany
WA 117880777
-35024588 GMT+8
26 03-Jul-00 Manjimup
WA 116142062
-34243750 GMT+8
27 04-Jul-00 Bunbury
WA 115634310
-33327633 GMT+8
28 05-Jul-00 Mandurah
WA 115731709
-32536758 GMT+8
29 06-Jul-00 Fremantle
WA 115749570
-32057073 GMT+8
30 07-Jul-00 Joondalup
WA 115763754
-31746424 GMT+8
31 08-Jul-00 Burswood
WA 115891293
-31959119 GMT+8
32 09-Jul-00 Northam
WA 116666944
-31655000 GMT+8
33 10-Jul-00 Journey aboard Indian Pacific
SA 129195280 -30744960
GMT+9.5
34 11-Jul-00 Journey aboard Indian Pacific
SA 129195280 -30744960
GMT+9.5
35 12-Jul-00 Port Pirie
SA 138020187
-33186453 GMT+9.5
36 13-Jul-00 Tanunda
SA 138960000
-34523635 GMT+9.5
37 14-Jul-00 Modbury
SA 138681534
-34835239 GMT+9.5
38 15-Jul-00 Adelaide
SA 138600797
-34928504 GMT+9.5
39 16-Jul-00 Murray Bridge
SA 139272228
-35121396 GMT+9.5
40 17-Jul-00 Naracoorte
SA 140740196
-36957783 GMT+9.5
41 18-Jul-00 Mount Gambier
SA 140782230
-37824725 GMT+9.5
42 19-Jul-00 Portland
VIC 141611828
-38357169 GMT+10
43 20-Jul-00 Warrnambool
VIC 142486779
-38383198 GMT+10
44 21-Jul-00 Colac
VIC
143585722 -38341209 GMT+10
45 22-Jul-00 Ararat
VIC 142923801
-37279568 GMT+10
46 23-Jul-00 Horsham
VIC 142203702
-36718101 GMT+10
47 24-Jul-00 Swan Hill
VIC 143558113
-35340104 GMT+10
48 25-Jul-00 Echuca
VIC 144748611
-36127499 GMT+10
49 26-Jul-00 Shepparton
VIC 145398026
-36382604 GMT+10
50 27-Jul-00 Maryborough
VIC 143737910
-37047120 GMT+10
51 28-Jul-00 Ballarat
VIC 143858106
-37563945 GMT+10
52 29-Jul-00 Flemington
VIC 144911968
-37791910 GMT+10
53 30-Jul-00 Glen Waverley
VIC 145161641
-37881170 GMT+10
54 31-Jul-00 Journey aboard Spirit of Tasmania (Melbourne)
VIC 144931669 -37842503 GMT+10
55 01-Aug-00 Queenstown
TAS 145554991
-42081466 GMT+10
56 02-Aug-00 Glenorchy
TAS 147280323
-42839071 GMT+10
57 03-Aug-00 Hobart
TAS 147321392
-42883179 GMT+10
58 04-Aug-00 Launceston
TAS 147135589
-41440049 GMT+10
59 05-Aug-00 Journey aboard Spirit of Tasmania (Devonport)
TAS 146364661 -41181051 GMT+10
60 06-Aug-00 REST DAY
VIC 145038159
-38222221 GMT+10
61 07-Aug-00 Morwell
VIC 146393167
-38237234 GMT+10
62 08-Aug-00 Bairnsdale
VIC 147623085
-37828921 GMT+10
63 09-Aug-00 Warragul
VIC 145930620
-38158211 GMT+10
64 10-Aug-00 Healesville
VIC 145514960
-37655560 GMT+10
65 11-Aug-00 Seymour
VIC 145133950
-37027281 GMT+10
66 12-Aug-00 Wangaratta
VIC 146318831
-36359903 GMT+10
67 13-Aug-00 Mount Hotham
VIC 147120630
-36973950 GMT+10
68 14-Aug-00 Albury
NSW 146916552
-36084609 GMT+10
69 15-Aug-00 Griffith
NSW 146034177
-34287970 GMT+10
70 16-Aug-00 Wagga Wagga
NSW 147367683
-35120365 GMT+10
71 17-Aug-00 Cowra
NSW
148690175 -33836237 GMT+10
72 18-Aug-00 Parkes
NSW 148173162
-33137235 GMT+10
73 19-Aug-00 Broken Hill
NSW 141464331
-31959029 GMT+10
74 20-Aug-00 Moree
NSW
149840900 -29464806 GMT+10
75 21-Aug-00 Armidale
NSW 151663749
-30517458 GMT+10
76 22-Aug-00 Tenterfield
NSW 152018261
-29055048 GMT+10
77 23-Aug-00 Ballina
NSW 153556942
-28868990 GMT+10
78 24-Aug-00 Coffs Harbour
NSW 153112941
-30297805 GMT+10
79 25-Aug-00 Port Macquarie
NSW 152907648
-31438485 GMT+10
80 26-Aug-00 Forster
NSW 152513113
-32181537 GMT+10
81 27-Aug-00 Newcastle
NSW 151779162
-32928827 GMT+10
82 28-Aug-00 Gosford
NSW 151340619
-33428754 GMT+10
83 29-Aug-00 Cessnock
NSW 151355261
-32837091 GMT+10
84 30-Aug-00 Muswellbrook
NSW 150885743
-32269710 GMT+10
85 31-Aug-00 Tamworth
NSW 150928338
-31091773 GMT+10
86 01-Sep-00 Dubbo
NSW
148604464 -32255342 GMT+10
87 02-Sep-00 Bathurst
NSW 149573382
-33421527 GMT+10
88 03-Sep-00 Penrith
NSW 150694707
-33754000 GMT+10
89 04-Sep-00 Bowral
NSW 150416412
-34481784 GMT+10
90 05-Sep-00 Capital Hill
ACT 149121568
-35310008 GMT+10
91 06-Sep-00 Phillip
ACT 149085177
-35348342 GMT+10
92 07-Sep-00 Thredbo Village
NSW 148304403
-36506602 GMT+10
93 08-Sep-00 Bega
NSW
149842022 -36675823 GMT+10
94 09-Sep-00 Batemans Bay
NSW 150173511
-35709721 GMT+10
95 10-Sep-00 Kiama
NSW
150846835 -34673756 GMT+10
96 11-Sep-00 Cronulla
NSW 151152188
-34057436 GMT+10
97 12-Sep-00 Parramatta
NSW 151002878
-33815788 GMT+10
98 13-Sep-00 Gladesville
NSW 151127837
-33835123 GMT+10
99 14-Sep-00 Sydney
NSW 151206513
-33869620 GMT+10
100 15-Sep-00 Olympic Park
NSW 151062347
-33848711 GMT+10
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
