Hottest month places at a particular lattitude

[chicagogeorge]

Lot of work Glacierx. Well done!

[L.A.-Mex]

Originally Posted by nei

Is Florida hotter than everywhere in Mexico at the same latitude in the winter or did you not look at Mexican data

No Mexico is warmer.

Hermosillo Mexico (91/63), similar latitude to Daytona beach is much warmer than anything in Florida.

from San Felipe south to Culiacan (91/64) (similar latitude range of florida) mexico is much warmer.

[nei]

Originally Posted by Glacierx

I don't know where to download weather data for Excel other than for Canada and the USA. If I had more countries, I'd include them as well.

You went through how many stations in the US and Canada? I'm surprised it's available in a few files. And more that you managed to use Excel for processing the data.

[Bottletree]

Originally Posted by Glacierx

I don't know where to download weather data for Excel other than for Canada and the USA. If I had more countries, I'd include them as well.

So they also include latitude column or did you add one?

[Glacierx]

Originally Posted by JetsNHL

So they also include latitude column or did you add one?

I pasted the text file into Excel. Latitude is one of the columns. USA data is a little harder to work with because I had to merge a couple of files together. Environment Canada had a database file available online last year when they finally came out wih the new normals, but it disappeared shortly thereafter. Not before I saved it though.

[Glacierx]

Originally Posted by tenkier7

Are you manually searching climate data all these cities and stations? Awesome...!
This makes me wanna do cooler coldest month chart, then probably the Prairies dominates the rule lol

Are you sure you want to me to do this? Okay, let's do it! This is ONLY for the USA and Canada. A place on the list means that for the coldest month of the year there are no weather stations further south with a colder month!

NOTE: There are no places in either the American or Canadian prairies!!! We can get one spot in North Dakota if we ignore Mount Washington.

Starts in Hawaii...
NAALEHU 14, HI = 21.2°C (70.1°F) ….(19.06N, 155.59W)
SOUTH KONA 2 2.32, HI = 18.2°C (64.7°F) ….(19.1N, 155.79W)
HAWAII VOL NP HQ 54, HI = 14.8°C (58.6°F) ….(19.43N, 155.26W)
MAUNA LOA 5 NNE, HI = 5.9°C (42.7°F) ….(19.54N, 155.58W)

Moves to Texas...
MARFA 3W, TX = 4.9°C (40.9°F) ….(30.31N, 104.07W)
PORTAL 4 SW, AZ = 3.7°C (38.7°F) ….(31.88N, 109.21W)
WHITE SIGNAL, NM = 2.8°C (37°F) ….(32.56N, 108.37W)
ELK, NM = 2.6°C (36.6°F) ….(32.92N, 105.34W)
CLOUDCROFT, NM = -1°C (30.2°F) ….(32.95N, 105.74W)
ALPINE, AZ = -1.3°C (29.7°F) ….(33.85N, 109.15W)
GREER, AZ = -2.4°C (27.6°F) ….(34.02N, 109.45W)
FLAGSTAFF 4 SW, AZ = -2.8°C (27°F) ….(35.16N, 111.73W)
BELLEMONT WFO, AZ = -2.8°C (27°F) ….(35.23N, 111.82W)
FT VALLEY, AZ = -2.9°C (26.8°F) ….(35.27N, 111.74W)
THOREAU 12 SE, NM = -3.9°C (25°F) ….(35.3N, 108.15W)
LOS ALAMOS 13 W, NM = -5.6°C (22°F) ….(35.86N, 106.52W)
ANGEL FIRE 1S, NM = -5.6°C (21.9°F) ….(36.4N, 105.29W)
EAGLE NEST, NM = -6.7°C (19.9°F) ….(36.56N, 105.26W)
MANASSA, CO = -6.8°C (19.7°F) ….(37.17N, 105.94W)
WAVERLY 1W, CO = -8.9°C (15.9°F) ….(37.43N, 106.03W)
RIO GRANDE RSVR, CO = -9.7°C (14.6°F) ….(37.73N, 107.27W)
HERMIT 7 ESE, CO = -10.3°C (13.4°F) ….(37.77N, 107.11W)
COCHETOPA CREEK, CO = -10.7°C (12.8°F) ….(38.45N, 106.76W)
GUNNISON 3SW, CO = -12.7°C (9.1°F) ….(38.53N, 106.97W)

Mount Washington, New Hampshire...
MT WASHINGTON, NH = -15.2°C (4.7°F) ….(44.27N, 71.3W)

If we ignore Mount Washington, we can insert the following locations:

DIAMOND POND, NH = -12.9°C (8.8°F) ….(44.95N, 71.32W)
PETAWAWA NAT FORESTRY, ONT = -13.1°C (8.4°F) ….(45.98N, 77.43W)
STE AGATHE DES MONTS, QUE = -13.2°C (8.3°F) ….(46.05N, 74.28W)
MINNEWAUKAN, ND = -14°C (6.8°F) ….(46.08N, 99.27W)
NOTRE DAME DE LA MERCI, QUE = -14.8°C (5.3°F) ….(46.23N, 74.05W)
ST ZENON, QUE = -15°C (5°F) ….(46.62N, 73.87W)

Entering Canada:
ST JOSEPH DE MEKINAC, QUE = -15.9°C (3.4°F) ….(46.92N, 72.68W)
BELLETERRE, QUE = -16.1°C (3°F) ….(47.38N, 78.7W)
EMBARRASS, MN = -16.6°C (2.1°F) ….(47.66N, 92.2W)
VAL-D'OR A, QUE = -17.4°C (0.7°F) ….(48.06N, 77.79W)
FERLAND, QUE = -17.5°C (0.5°F) ….(48.2N, 70.83W)
RIVIERE KINOJEVIS, QUE = -17.5°C (0.5°F) ….(48.22N, 78.87W)
MONT BRUN, QUE = -17.9°C (-0.2°F) ….(48.42N, 78.73W)
MANNEVILLE, QUE = -18.2°C (-0.7°F) ….(48.55N, 78.48W)
TASCHEREAU, QUE = -18.4°C (-1.1°F) ….(48.67N, 78.7W)
VAL ST GILLES, QUE = -18.9°C (-2.1°F) ….(48.98N, 79.13W)
HEMON, QUE = -19.3°C (-2.8°F) ….(49.07N, 72.6W)
ISLAND FALLS, ONT = -19.4°C (-2.9°F) ….(49.58N, 81.38W)
BONNARD, QUE = -20.9°C (-5.6°F) ….(50.73N, 71.05W)
POSTE MONTAGNAIS, QUE = -23.6°C (-10.4°F) ….(51.88N, 65.73W)
SCHEFFERVILLE A, QUE = -24.6°C (-12.2°F) ….(54.8N, 66.82W)
KUUJJUAQ A, QUE = -24.7°C (-12.5°F) ….(58.1N, 68.42W)
INUKJUAK UA, QUE = -26.1°C (-14.9°F) ….(58.47N, 78.08W)
CHURCHILL A, MAN = -26.1°C (-14.9°F) ….(58.74N, 94.07W)

Entering northern Canada:
ARVIAT A, NU = -29.3°C (-20.7°F) ….(61.1N, 94.07W)
WHALE COVE A, NU = -30.6°C (-23.1°F) ….(62.24N, 92.6W)
RANKIN INLET A, NU = -30.8°C (-23.5°F) ….(62.82N, 92.12W)
CHESTERFIELD INLET A, NU = -30.9°C (-23.6°F) ….(63.35N, 90.73W)
BAKER LAKE A, NU = -31.3°C (-24.3°F) ….(64.3N, 96.08W)
REPULSE BAY A, NU = -31.3°C (-24.4°F) ….(66.52N, 86.22W)
KUGAARUK A, NU = -33.6°C (-28.4°F) ….(68.54N, 89.8W)
GJOA HAVEN A, NU = -34.1°C (-29.3°F) ….(68.64N, 95.85W)
SHEPHERD BAY A, NU = -35.7°C (-32.3°F) ….(68.82N, 93.43W)
EUREKA, NU = -37.4°C (-35.4°F) ….(79.98N, 85.93W)