John Boyd Thacher State Park

John Boyd Thacher State Park, is situated along the Helderberg Escarpment, one of the richest fossil-bearing formations in the world. Even as it safeguards six miles of limestone cliff-face, rock-strewn slopes, woodland and open fields, the park provides a marvelous panorama of the Hudson-Mohawk Valleys and the Adirondack and Green Mountains. The park has volleyball courts, playgrounds, ball fields and numerous picnic areas with nine reservable shelters. Interpretive programs are offered year-round, including guided tours of the famous Indian Ladder Trail. There are over 25 additional miles of trails for summer hiking and mountain biking, and winter cross-country skiing, snowshoeing, hiking, and snowmobiling.

http://nysparks.com/parks/128/

Show Only ...
Maps - Photos - Videos

How to create a shapefile with median age of buildings by block

How to create a shapefile with median age of buildings by block. Data is from NYSGIS which has been loaded into Postgres database.

library(RPostgreSQL)
library(tidyverse)
library(sf)
library(tigris)

rm(list=ls())
con <- DBI::dbConnect(RPostgres::Postgres(), dbname=’gis’, host=’localhost’,
                      port=5432, user=’postgres’, password=’XXXXXXXX’)

bb <- blocks(‘ny’) %>% st_transform(26918)

str_c(“select yr_blt, st_transform(shape, 26918) as geom FROM nytax_ctr_pt WHERE yr_blt>0”) -> sql
yrblt <- st_read(con, query=sql)
 
bb %>%
    st_intersection(yrblt) %>%
    st_drop_geometry() %>%
    group_by(GEOID20) %>%
    summarize(blockyr = median(yr_blt)) %>%
    inner_join(mb, bb) %>%
    write_sf(‘/tmp/median-block.gpkg’)

Weather Update – May 31, 2022

It looks like really just two days of the heat to kick off June. πŸ–

Then rain showers and much cooler for the weekend. Maybe by the following weekend things will be good and hot for heading out of town.

Today.
Hot !

Hot

Mostly sunny and hot.

Light west wind becoming northwest 5 to 10 mph in the morning. Winds could gust as high as 20 mph.

and

90 degrees , 64 max dew point, 8:27
sunset.
Tonight.
Feels like …
July 2nd.

Slight Chance of T-storms

A slight chance of showers and thunderstorms after 10pm. Partly cloudy.

North wind around 6 mph becoming calm after midnight. Chance of precipitation is 20%.

and

61 degrees , 62 max dew point, 5:18
sunrise.
Wednesday.
Feels like …
May 23rd.

Showers is likely

A chance of showers and thunderstorms, then showers likely and possibly a thunderstorm after 11am. Partly sunny.

South wind around 9 mph. Chance of precipitation is 70%. New rainfall amounts between a quarter and half of an inch possible.

and

73 degrees , 61 max dew point, 8:28
sunset.
Wednesday Night.
Feels like …
June 26th.

Showers is likely

Showers and thunderstorms likely before 2am, then a slight chance of showers after 4am. Mostly cloudy.

South wind around 6 mph becoming light and variable after midnight. Chance of precipitation is 70%. New precipitation amounts between a tenth and quarter of an inch, except higher amounts possible in thunderstorms.

and

60 degrees , 5:18
sunrise.
Thursday.
Feels like …
June 11th.

Partly Sunny then Slight Chance of Showers

A slight chance of showers after 2pm. Partly sunny.

Northwest wind around 6 mph. Chance of precipitation is 20%.

and

78 degrees , 58 max dew point, 8:28
sunset.
Thursday Night.
Feels like …
June 15th.

Chance of Showers

A chance of showers, mainly after 8pm. Mostly cloudy.

Chance of precipitation is 50%. New precipitation amounts between a tenth and quarter of an inch possible.

and

57 degrees , 5:17
sunrise.
Friday.
Feels like …
May 27th.

Chance of Showers

A chance of showers. Mostly sunny.

Chance of precipitation is 50%.

and

74 degrees , 55 max dew point, 8:29
sunset.
Friday Night.
Feels like …
May 29th.

Mostly Clear

Mostly clear.

and

52 degrees , 5:17
sunrise.
Saturday.
Feels like …
May 27th.

Sunny

Sunny.

and

74 degrees , 49 max dew point, 8:30
sunset.
Saturday Night.
Feels like …
May 16th.

Mostly Clear

Mostly clear.

and

48 degrees , 5:16
sunrise.
Sunday.
Feels like …
June 8th.

Mostly Sunny

Mostly sunny.

and

77 degrees , 48 max dew point, 8:31
sunset.
Sunday Night.
Feels like …
June 11th.

Partly Cloudy

Partly cloudy.

and

56 degrees , 5:16
sunrise.
Monday.
Feels like …
June 8th.

Partly Sunny then Chance of Showers

A chance of showers. Partly sunny.

Chance of precipitation is 30%.

and

77 degrees , 54 max dew point, 8:31
sunset.

Daily Update – May 31, 2022

Good morning! Happy Soon to Be Hot Tuesday.

As they say, Memorial Day Weekend is dead. Just history now. Time to dig through the shit known as the big final week and then onwards to summer. At least I’ll have an air conditioned office rather than working out of my hot truck this week and probably won’t get home until the heat breaks.

Partly cloudy and 69 degrees in Delmar, NY. β›… Calm wind. The dew point is 63 degrees. The muggers have returned.

Out walking 🚢 at six thirty and I can already feel the humidity, although it’s not so hot out at this point. You can smell the freshly cut hay 🌾 from Memorial Day Weekend. I don’t know the chances of rain β˜” today but they can certainly get it bailed before the rain comes later in the week.

Yesterday I finally had some work to do πŸ’» so I guess staying home this weekend wasn’t quite as much of a waste as I was starting to think πŸ€” with pretty nice weather. But I’m just waiting to get away and be off the phone grid for four days, laying in that truck intertube, floating down that lazy river.

Yesterday I won’t say was the busiest day πŸ” but I had a Memorial Day BBQ with the folks, did some cleaning and washed my clothes. πŸ‘•πŸ©³πŸ‘– Continued to study R and Spatial Correlation. It’s a fascinating topic as I’m trying to learn how to do more and automate more with R and GIS. There is so much to don’t know or understand I’m trying to learn. I wish they had more books πŸ“š on this at the library but there is some decent information on the internet and studying the source code.

Calculate Median Household Income for Albany Wards using R πŸ—Ί

Calculate Median Household Income for Albany Wards using R πŸ—Ί

A while back I posted similar code using Python, but with R the code is cleaner, simpler.

library(tidycensus)
library(tidyverse)
library(sf)

# shapefile of Albany Wards, project to web mercator 3857
# calculate area of each ward, load Ward field as numeric
# hide extra fields in shapefile
wards <- read_sf('/tmp/Albany Wards.gpkg') %>%
  st_transform(3857) %>%
  mutate(ward_area = st_area(.),
         Ward = as.numeric(Ward)) %>%
  dplyr::select(Ward, ward_area)

# get median household income, re-project
# to web mercator 3857
income<- get_acs(
  geography = "tract",
  state='ny',
  county='Albany',
  variables = "B19013_001",
  year = 2020,
  survey = "acs5",
  geometry = T
) %>%
  st_transform(3857)


# intersect income against wards
# calculate percent of ward's area in each census tract
# group back together as a single ward
# create a weighted-mean of median household inco
# rejoin back together with original ward shapefile
income %>%
  st_intersection(wards) %>%
  mutate(percent_of_ward = (st_area(.) / ward_area) %>% units::drop_units() ) %>%
  st_drop_geometry() %>%
  group_by(Ward) %>%
  summarise(estimate = weighted.mean(estimate, percent_of_ward, na.rm=T)) %>%
inner_join(wards, ., by=c('Ward'))

Here is what is produced, with geometry columns suppressed (exclude the last line above when you don’t need the other information for mapping).

    Ward estimate
<dbl> <dbl>
1 1 57500.
2 2 46544.
3 3 37274.
4 4 39713.
5 5 38127.
6 6 47070.
7 7 47915.
8 8 86490.
9 9 57688.
10 10 44964.
11 11 33290.
12 12 69262.
13 13 67333.
14 14 78489.
15 15 72368.

Weather Update – May 30, 2022

Sunny and hot the next few days β˜€

Then rain showers, cooler and very pleasant for next weekend.

Memorial Day.
Hot !

Mostly Sunny

Mostly sunny.

Calm wind becoming west around 6 mph in the afternoon.

and

89 degrees , 61 max dew point, 8:26
sunset.
Tonight.
Hot !

Partly Cloudy

Partly cloudy.

Light south wind.

and

67 degrees , 62 max dew point, 5:18
sunrise.
Tuesday.
Hot !

Hot

Mostly sunny and hot.

Northwest wind 5 to 10 mph, with gusts as high as 20 mph.

and

91 degrees , 64 max dew point, 8:27
sunset.
Tuesday Night.
Feels like …
July 10th.

Slight Chance of T-storms then Slight Chance of Showers

A slight chance of showers and thunderstorms before 2am, then a slight chance of showers after 3am. Partly cloudy.

Northwest wind around 6 mph becoming calm in the evening. Chance of precipitation is 20%.

and

62 degrees , 60 max dew point, 5:18
sunrise.
Wednesday.
Feels like …
June 8th.

Chance of Showers then Showers is likely

A chance of showers before 11am, then a chance of showers and thunderstorms between 11am and 2pm, then showers likely and possibly a thunderstorm after 2pm. Partly sunny.

South wind 6 to 8 mph. Chance of precipitation is 70%. New rainfall amounts between a tenth and quarter of an inch, except higher amounts possible in thunderstorms.

and

77 degrees , 61 max dew point, 8:28
sunset.
Wednesday Night.
Feels like …
June 15th.

Showers is likely

Showers likely and possibly a thunderstorm before 8pm, then a chance of showers and thunderstorms between 8pm and 2am, then a chance of showers after 2am. Mostly cloudy.

Chance of precipitation is 60%. New rainfall amounts of less than a tenth of an inch, except higher amounts possible in thunderstorms.

and

57 degrees , 5:18
sunrise.
Thursday.
Feels like …
May 31st.

Partly Sunny

Partly sunny.

and

75 degrees , 54 max dew point, 8:28
sunset.
Thursday Night.
Feels like …
June 8th.

Mostly Cloudy then Chance of Showers

A chance of showers after 2am. Mostly cloudy.

Chance of precipitation is 30%.

and

55 degrees , 5:17
sunrise.
Friday.
Feels like …
May 27th.

Chance of Showers

A chance of showers. Partly sunny.

Chance of precipitation is 30%.

and

74 degrees , 53 max dew point, 8:29
sunset.
Friday Night.
Feels like …
May 26th.

Partly Cloudy

Partly cloudy.

and

51 degrees , 5:17
sunrise.
Saturday.
Feels like …
June 8th.

Sunny

Sunny.

and

77 degrees , 49 max dew point, 8:30
sunset.
Saturday Night.
Feels like …
June 5th.

Partly Cloudy

Partly cloudy.

and

54 degrees , 5:16
sunrise.
Sunday.
Feels like …
June 11th.

Mostly Sunny

Mostly sunny.

and

78 degrees , 51 max dew point, 8:31
sunset.

Daily Update – May 30, 2022

Good morning! It’s Memorial Day πŸ‡ΊπŸ‡Έ

Unofficial start to summer and it’s going to be a hot one. The air smells like fresh cut hay 🌾 and already the sun is beating down.

Partly sunny and 61 degrees in Delmar, NY. β˜€ Calm wind. The dew point is 55 degrees.

Out for the morning walk 🚢 although later than many days as I slept in. Stayed up relatively late under the starry ✨ skies out and then woke up in the middle of the night. I got thinking a mapping algorithm I’m developing in R to impute election results down to the block level.

Yesterday after the morning walk πŸ’» I spent too many hours studying various algorithms related to mapping and aggregation and interpolation in R. I wanted to wait until 3 pm to start my paddle πŸ›Ά to Troy, as I would have the tide pushing me north on the way up there and then back to Albany.

It was a nice trip kayaking πŸ›Ά from Albany to Troy, first time I’ve done it since 2012. I think the river was cleaner, and by 6 o’clock there was very little traffic on the river. Water πŸ’¦ was very calm except for occasional boat πŸ›₯ wakes and at the end almost back to Corning Preserve a southerly breeze which against the current made things choppy. Arms are a bit sore this morning, haven’t done so much paddling in a long time. πŸ™‹

When the history books πŸ“š are written this wouldn’t have been a bad weekend to head out of town although I heard like usual that the black flies 🐜 were terrible up north. But long weekends come and go so quickly.

I am thinking the weekend of June 9-13 would be a nice weekend to do an extended vacation weekend up north, β›Ί depending on the weather. Evidence suggests either next weekend I will be working or dead tired after pulling too many all nighters at work. But maybe I’ll take the Thacher Park bus 🚍 there on Saturday. The following weekend is Juneteenth so Monday June 20th is a holiday too. I want to do some floating in the black rubber intertube, drink some beer have a big fire πŸ”₯.

Weather Update – May 29, 2022

Beautiful day today then hot … 😎

High tide on the river is 4:46 pm in Albany. So that’s good to know if I’m paddling. Still not sure if that’s the plan. πŸ›Ά

Tomorrow will certainly be hot. πŸ– Same thing with the first half of next week but then cool for the weekend. But I’m not sure if I will be able to get out of town this weekend as I tend to think I’ll be working next weekend.

Today.
Feels like …
June 15th.

Sunny

Sunny.

Light and variable wind.

and

79 degrees , 52 max dew point, 8:25
sunset.
Tonight.
Feels like …
June 15th.

Mostly Clear

Mostly clear.

Calm wind.

and

57 degrees , 5:19
sunrise.
Memorial Day.
Hot !

Mostly Sunny

Mostly sunny.

Calm wind becoming southwest around 6 mph in the afternoon.

and

88 degrees , 61 max dew point, 8:26
sunset.
Monday Night.
Hot !

Partly Cloudy

Partly cloudy.

Light southwest wind.

and

68 degrees , 62 max dew point, 5:18
sunrise.
Tuesday.
Hot !

Hot

Mostly sunny and hot.

Northwest wind 6 to 9 mph.

and

90 degrees , 64 max dew point, 8:27
sunset.
Tuesday Night.
Hot !

Slight Chance of Showers

A slight chance of showers. Partly cloudy.

Chance of precipitation is 20%.

and

64 degrees , 61 max dew point, 5:18
sunrise.
Wednesday.
Feels like …
July 15th.

Partly Sunny then Chance of T-storms

A chance of showers and thunderstorms after 2pm. Partly sunny.

Chance of precipitation is 40%.

and

84 degrees , 63 max dew point, 8:28
sunset.
Wednesday Night.
Feels like …
June 18th.

Chance of T-storms then Chance of Showers

A chance of showers and thunderstorms before 8pm, then a chance of showers between 8pm and 2am. Mostly cloudy.

Chance of precipitation is 40%.

and

58 degrees , 5:18
sunrise.
Thursday.
Feels like …
June 11th.

Partly Sunny then Chance of Showers

A chance of showers after 2pm. Partly sunny.

Chance of precipitation is 40%.

and

78 degrees , 54 max dew point, 8:28
sunset.
Thursday Night.
Feels like …
June 8th.

Chance of Showers

A chance of showers. Mostly cloudy.

Chance of precipitation is 40%.

and

55 degrees , 5:17
sunrise.
Friday.
Feels like …
June 4th.

Chance of Showers

A chance of showers. Mostly sunny.

Chance of precipitation is 40%.

and

76 degrees , 50 max dew point, 8:29
sunset.
Friday Night.
Feels like …
June 1st.

Partly Cloudy

Partly cloudy.

and

53 degrees , 5:17
sunrise.
Saturday.
Feels like …
June 4th.

Sunny

Sunny.

and

76 degrees , 50 max dew point, 8:30
sunset.