bluewave

You can use dense rank sorting so there are no gaps between ranks. https://docs.microsoft.com/en-us/sql/t-sql/functions/dense-rank-transact-sql?view=sql-server-ver15 If two or more rows have the same rank value in the same partition, each of those rows will receive the same rank. For example, if the two top salespeople have the same SalesYTD value, they will both have a rank value of one. The salesperson with the next highest SalesYTD will have a rank value of two. This exceeds the number of distinct rows that come before the row in question by one. Therefore, the numbers returned by the DENSE_RANK function do not have gaps, and always have consecutive rank values.

Following a brief break, the 70s dew points will return by Tuesday or Wednesday.

The strongest heat was west of the Hudson this summer. Newark is currently at the 8th warmest summer position. LGA is currently at the 11th warmest summer temperature. ISP is similar to the LGA ranking at 12 warmest. The much warmer climate allowed a place like ISP to still rank this high even with only a+1.6…June….-0.4…July….-0.7…August. Last summer was an east of the Hudson heat pattern with LGA and ISP top 3 warmest through August 13th and Newark in 6th place. Time Series Summary for NEWARK LIBERTY INTL AP, NJ Click column heading to sort ascending, click again to sort descending. Rank Ending Date Mean Avg Temperature Jun 1 to Aug 13 Missing Count 1 2010-08-13 79.5 0 2 1994-08-13 79.3 0 3 1993-08-13 79.1 0 4 2011-08-13 78.8 0 5 1988-08-13 78.2 0 6 2020-08-13 78.0 0 7 1999-08-13 77.9 0 8 2021-08-13 77.8 0 9 2005-08-13 77.7 0 10 1973-08-13 77.4 0 Time Series Summary for New York-LGA Area, NY (ThreadEx) Click column heading to sort ascending, click again to sort descending. Rank Ending Date Mean Avg Temperature Jun 1 to Aug 13 Missing Count 1 2020-08-13 79.8 0 2 2010-08-13 79.7 0 3 1999-08-13 78.3 0 4 2016-08-13 78.1 0 5 2006-08-13 77.9 0 - 2005-08-13 77.9 0 - 1994-08-13 77.9 0 6 2019-08-13 77.5 0 - 2018-08-13 77.5 0 - 2012-08-13 77.5 0 - 2008-08-13 77.5 0 - 1966-08-13 77.5 0 7 2013-08-13 77.4 0 8 1952-08-13 77.2 0 9 1991-08-13 77.1 0 - 1949-08-13 77.1 0 10 2011-08-13 77.0 0 11 2021-08-13 76.9 0 - 2002-08-13 76.9 0 - 1995-08-13 76.9 0 - 1988-08-13 76.9 0 Time Series Summary for ISLIP-LI MACARTHUR AP, NY Click column heading to sort ascending, click again to sort descending. Rank Ending Date Mean Avg Temperature Jun 1 to Aug 13 Missing Count 1 2010-08-13 75.2 0 - 1999-08-13 75.2 0 2 2020-08-13 74.8 0 3 2011-08-13 74.4 0 4 2019-08-13 74.1 0 5 2013-08-13 73.8 0 - 1994-08-13 73.8 0 6 2016-08-13 73.6 0 - 2008-08-13 73.6 0 7 2012-08-13 73.4 0 8 2006-08-13 73.3 0 - 1966-08-13 73.3 0 9 2005-08-13 73.2 0 10 2018-08-13 73.1 0 11 2014-08-13 73.0 0 - 1991-08-13 73.0 0 - 1988-08-13 73.0 0 12 2021-08-13 72.9 0

99° at Newark and 97° at LGA.

Don’t feel so bad. This has been a well known issue for a long time. Since the NWS left Rockefeller Center in the early 90s, the quality of the Central Park weather observations has declined.

Nothing happens when I clicked on the link that you provided. But you can see how the weather station is hidden under the trees when fully leafed out. No other official weather observing station has this much dense tree cover so close to the thermometer. Prior to the 1990s, the tree growth was much more modest around the site. So the warm season highs weren’t that much different from LGA and EWR. JFK has seen a similar rise in JJA temperatures as the other stations. You can see the big giveaway that the NYC ASOS went from the sun to deep shade. Notice how the average minimum JJA temperature rose in line with the other stations since 1951-1980. But the average high from 1951-1980 to 2011-2020 is virtually unchanged. JJA 1950-1981 to 2011-2020 temperature change NYC max….83.0…83.2….+0.2 min…..66.0…68.2….+2.2 EWR max…83.4…85.3…..+1.9 min….65.8….67.8…..+2.0 LGA max…82.0….84.4…..+2.4 min….66.8….69.9…..+3.1 JFK max….80.5….82.5…..+2.0 min…..65.4….67.7……+2.3

It won’t open. But the most recent summer photos in 2013 had the thermometer in the deep shade. Winter isn’t a good time for photos since the strongest cooling effect occurs after spring leaf out. The proximity of the vegetation to the thermometer violates the sitting rules for official temperature measurements.

While it may seem that way, Newark has actually had less summer warming than the rest of the forum since 1981.

It all depends on what the dominant summer pattern is. This year the regime is favoring NE NJ for the most heat. Last summer it was east of the Hudson with LGA and Hartford recording more 90° days. Also remember that Newark just ended its longest no 100° day streak this summer. June had the first 100° day since 2013. But LGA and New England had several 100° readings in recent years. 2020 days reaching 90° Newark…..31 LGA………..34 Hartford….39

Northeast NJ has been able to avoid the cooler onshore influence that has affected the rest of the area. Caldwell is +1.2 and Newark is lower at +0.5. Follows the theme of this being a hotter summer west of the Hudson away from the cooling seabreezes.

There are two main differences between this summer and last for extent. May 2020 featured record preconditioning of the ice for the second lowest extent last September. Last summer also had very strong high pressure. This June and July had the second lowest Arctic pressure on record behind 1989. While the tweet below was focused on the record lack of sunny days near Alaska, you can see how the extreme low pressure pattern kept the Arctic very cloudy.

This is only the 8th year that Newark reached 30 days of 90° following a 40 inch snowfall season. This feat only occurred three times up to 1994. But a record breaking five years since 2005. So we are getting an unusual combination of stronger winter blocking followed by summer heat. Newark 40 inch snowfall followed by 30 days reaching 90° 2021….45.7…..31 2015….46.4….35 2011…..68.2…..31 2010….47.9……54 2005….43.4…..37 1994…..64.5….39 1961…..73.5…..34 1949….41.2……36

A gust to 69 mph with that storm.

The highest dew points went to our north today.

High of 97° at EWR and 95° at LGA through 2pm.

Temperatures are off to the races with Newark jumping from 85° to 90° in one hour. 12 Aug 10:51 am 90 73 58 SW 9 10.00 FEW250 29.99 1016.3 30.01 12 Aug 9:51 am 85 72 65 W 6 10.00 CLR 29.99 1016.3 30.01

The record at JFK is 115 and 129 at Newark.

The NWS really needs to address the situation with the trees blocking the sensor. They didn’t seem to take it into account with the official forecast for today. Notice how the forecast did very well for all the other stations. But it was 4° too high for NYC.

Miami dew points across the region. MIAMI PTSUNNY 91 75 59 E10G22 30.09F HX 101 Poughkeepsie MOSUNNY 90 76 63 S7 29.94 HX 101 Newark/Liberty MOSUNNY 93 75 55 SW14 29.96 HX 104 Somerville MOSUNNY 91 77 63 VRB3 29.96 HX 104 Kennedy Intl MOSUNNY 83 75 77 S10 30.00 HX 90

84° is the highest on record at JFK and EWR. The JFK record was set in 2016 and Newark in 1995. While the Sussex County records only go back to 2000, your record is 79°set in 2016. You can see how many hourly records there have been at our stations in the last 6 years.

Newark just jumped up to 91° Making it to 30 days reaching 90° again. Time Series Summary for NEWARK LIBERTY INTL AP, NJ - Jan through Dec Click column heading to sort ascending, click again to sort descending. Rank Year Number of Days Max Temperature >= 90 Missing Count 1 2010 54 0 2 1993 49 0 3 1988 43 0 4 2002 41 0 - 1991 41 0 5 2016 40 0 - 1983 40 0 - 1959 40 0 6 1994 39 0 - 1944 39 0 7 2005 37 0 - 1987 37 0 8 2018 36 0 - 1949 36 0 9 2015 35 0 10 1961 34 0 11 2012 33 0 - 1999 33 0 - 1995 33 0 - 1966 33 0 12 1955 32 0 - 1953 32 0 - 1943 32 0 13 2020 31 0 - 2011 31 0 - 1973 31 0 - 1952 31 0 14 2021 30 142

It’s a tropical airmass with PWATS and dew points near the higher end of the range for this time of year,

2019 to 2021 has been the most active through August 10th on record for NJ severe thunderstorm and tornado warnings. https://mesonet.agron.iastate.edu/plotting/auto/?_wait=no&q=44&plot=line&opt=state&station=DMX&state=NJ&limit=yes&c=svrtor&phenomena=TO&significance=W&syear=1986&eyear=2021&dpi=100&_fmt=png

The max 850 mb temperatures from Thursday into Friday around +22c should approach the August monthly highs since 1979. So the surface highs will come down to the timing of the daily convection potential. Best chances to reach 100° will probably be the usual NE NJ warm spots around Newark. Maybe even around LGA or other warm parts of Queens.