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

Working PANDAS and American Community Survey Summary File

Want to be able to work with American Community Survey data offline using your own local copy of the ACS 5-year Summary File? It’s pretty easy to do with PANDAS. If you are planning a lot of Census queries, this can be a very fast way to extract data.

Before you can use this script, you will need to download some data:

import pandas as pd

path = '/home/andy/Desktop/acs-summary-file/'

# list of geography
geo = pd.read_excel(path+'5_year_Mini_Geo.xlsx', sheet_name='ny',index_col='Logical Record Number')

# load headers
header = pd.read_excel(path+'ACS_5yr_Seq_Table_Number_Lookup.xlsx')

# create a column with census variable headers
header['COL_NAME'] = header['Table ID'] + '_' + header['Line Number'].apply(lambda a: "{0:.0f}".format(a).zfill(3))

# segment id, along with ACS year and state
segId = 135
year = 2019
state = 'ny'

# create a list of headers for segment file
segHead = ['FILEID','FILETYPE','STUSAB','CHARITER','SEQUENCE','LOGRECNO'] \
    + header.query('`Sequence Number` == '+str(segId)).dropna(subset=['Line Number'])['COL_NAME'].to_list()

# read the segment file, including column names above    
seg = pd.read_csv(path+'e'+str(year)+'5'+state+(str(segId).zfill(4))+'000.txt',header=None, names=segHead, index_col=5)

# join the segment file to geography using Logical Record number
seg = geo.join(seg)

# calculate percentage of households with internet subscriptions -- codes from ACS_5yr_Seq_Table_Number_Lookup.xlsx
seg['Internet Subscription']=seg['B28011_002']/seg['B28011_001']*100

# output the percentage of households by county with internet subscriptions
seg[seg['Geography ID'].str.startswith('050')][['Geography Name','Internet Subscription']]

Geography NameInternet Subscription
Logical Record Number
13Albany County, New York83.888889
14Allegany County, New York76.248050
15Bronx County, New York75.917821
16Broome County, New York82.222562
17Cattaraugus County, New York72.431480
70Washington County, New York80.224036
71Wayne County, New York81.508715
72Westchester County, New York86.371288
73Wyoming County, New York78.387887
74Yates County, New York75.916583
# alternatively you can display human readable columns automatically
seg.rename(dict(zip(header['COL_NAME'],header['Table Title'])),axis=1)
StateGeography IDGeography NameFILEIDFILETYPESTUSABCHARITERSEQUENCETotal:Has one or more types of computing devices:
Logical Record Number
1NY04000US36New YorkACSSF201900000.0ny0.0135.07343234.06581493.0
2NY04001US36New York — UrbanACSSF201900000.0ny0.0135.06433524.05771681.0
3NY04043US36New York — RuralACSSF201900000.0ny0.0135.0909710.0809812.0
4NY040A0US36New York — In metropolitan or micropolitan st…ACSSF201900000.0ny0.0135.07189902.06449723.0
5NY040C0US36New York — In metropolitan statistical areaACSSF201900000.0ny0.0135.06796057.06109882.0
28400NY97000US3631920Yonkers City School District, New YorkACSSF201900000.0ny0.0135.074897.065767.0
28401NY97000US3631950York Central School District, New YorkACSSF201900000.0ny0.0135.02116.01964.0
28402NY97000US3631980Yorktown Central School District, New YorkACSSF201900000.0ny0.0135.07068.06751.0
28403NY97000US3632010Cuba-Rushford Central School District, New YorkACSSF201900000.0ny0.0135.02629.02186.0
28404NY97000US3699999Remainder of New York, New YorkACSSF201900000.0ny0.0135.079779.075425.0

Too much work or don’t want to download the summary file yourself? You can query the Census API directly using PyPI’s censusdata library from PIP. For infrequent queries where you are online, for those with Internet at home, you would be much better off just querying the API directly.

import pandas as pd
import censusdata as cd

# attributes to load
cdcol=['B28011_001','B28011_002']

cdf = cd.download('acs5', 2019,
           cd.censusgeo([('state', '36'),
                         ('county','*')]),
          cdcol)


# seperate out the geoid and geography name
geoid=[]
geoname=[]

for index in cdf.index.tolist():
    geopart=''
    for part in index.geo:
        geopart = geopart + part[1]
    geoid.append(geopart)
    geoname.append(index.name)

cdf['geoid']=geoid
cdf['geoname']=geoname

# calculate percentage with internet subscriptions
cdf['Internet Subscription']=cdf['B28011_002']/cdf['B28011_001']*100

# output a similar table as above
cdf

Learn how to load into PANDAS the PL 94-171 2020 Redistricting Data, a process that is similar but different then ACS data.

Also, calculate the population of an area and it’s average demographics, including areas that don’t have Census demographics such as Election Districts or County Legislative districts.

April 28, 2023 Morning

100 days of walking Five Miles or more a day ๐Ÿšถ

Probably by midday it will mark 100 days of walking a minimum of 5 miles a day or 10,000 steps. ๐Ÿ‘ฃ That said, lately I’ve been doing a lot more. Yesterday that worked out to be more like 11 1/2 miles. Feeling great, except for my lack of sleep last night!

Good morning! Yeah, it’s Friday! Partly cloudy with fog around and 41 degrees in Delmar for the morning walk. โ›… Calm wind.

For the first time in a long time I did not sleep well ๐Ÿ› last night. Part of it was I didn’t get to bed until later then usual as I walked until 7:45 then went to the grocery store. By the time I was in bed and lights off it was closer to quarter before ten. Then I woke up at 2 am and struggled to get back to sleep. ๐Ÿ˜ด

Worse thing about waking up during the night ๐ŸŒƒ is all the podcast ads magically become for Better Help, sleeping medications and mattress commercials. ๐Ÿ’Š Can’t sleep at night, our online therapists can help you 24-7. Talking to a shrink is exactly what I need in this middle of the night when I can’t sleep. Really, lol. No I just need to get up, take a piss and get back to bed listening to some boring ๐Ÿ’ค lecture of podcast.

Today will have increasing clouds ๐ŸŒฅ ๐Ÿ‘‰ โ˜, with a high of 65 degrees at 3pm. Typical for today. Light and variable wind becoming southeast 5 to 10 mph in the morning. A year ago, we had mostly sunny skies. The high last year was 54 degrees. The record high of 92 was set in 1990. There was a dusting of snow in 1966.โ„

Yesterday was a crickets day at work ๐Ÿฆ— it was dead quiet until it wasn’t. But then the project got sent back to the researcher and it was dead. I’ve been continuing to update R studio packages, and working on some interesting new maps. I like the quality of the simple maps I’m getting out of ggplot these days. Accidentally scheduled too many posts yesterday evening, but I’m moving them around and getting that fixed.

Got out walking after a quick dinner ๐Ÿƒ managing to get in 11 1/2 miles for the day. Then I went grocery shopping. ๐Ÿ›’ When I got done ringing up my items from shopping, I had a bit of sticker shock after shopping — my bill rang up to $113. ๐Ÿ˜ฎ I know, but then again I needed coffee, salmon, and some other more expensive things that will likely last a month or two as a dole out the servings over time. I buy in bulk, and these days bulk buying is expensive. โ˜• I expect my grocery bills to much closer to normal in coming weeks, but also I do expect they’ll run about $10-20 a week more then what they were before I started eating healthy. While in some ways healthy foods bought in bulk are less expensive, all the ingredients and variety just adds up. ๐Ÿ‘จ‍โš•๏ธ And it’s worth it if it keeps me healthy, as I noted last night.

Solar noon ๐ŸŒž is at 12:54 pm with sun having an altitude of 61.5° from the due south horizon (-9.3° vs. 6/21). A six foot person will cast a 3.3 foot shadow today compared to 2.2 feet on the first day of summer. The golden hour ๐Ÿ… starts at 7:13 pm with the sun in the west-northwest (284°). ๐Ÿ“ธ

The sunset is in the west-northwest (290°) with the sun dropping below the horizon at 7:52 pm after setting for 3 minutes and 5 seconds with dusk around 8:22 pm, which is one minute and 8 seconds later than yesterday. ๐ŸŒ‡ At dusk you’ll see the Waxing Gibbous ๐ŸŒ” Moon in the south (188°) at an altitude of 66° from the horizon, 252,101 miles away. ๐Ÿš€ The best time to look at the stars is after 9:00 pm. At sunset, look for cloudy skies โ˜ and temperatures around 59 degrees. There will be a south breeze at 9 mph. Today will have 14 hours of daytime, an increase of 2 minutes and 34 seconds over yesterday.

Tonight will have a chance of showers, mainly after 1am. Cloudy ๐ŸŒง, with a low of 45 degrees at 6am. Three degrees above normal, which is similar to a typical night around May 5th. Southeast wind 6 to 9 mph. Chance of precipitation is 40%. New precipitation amounts of less than a tenth of an inch possible. In 2022, we had mostly clear skies. It got down to 33 degrees. The record low of 27 occurred back in 1947.

Tomorrow will have showers. ๐ŸŒฆ High of 50 degrees at 2pm. 15 degrees below normal, which is similar to a typical day around March 30th. Maximum dew point of 43 at 1pm. ๐Ÿ–๏ธ Southeast wind 9 to 11 mph. Chance of precipitation is 80%. New precipitation amounts between a quarter and half of an inch possible. A year ago, we had mostly sunny skies. The high last year was 61 degrees. The record high of 88 was set in 1888. 1 inches of snow fell back in 1885.โ„

This weekend I want to work on the bicycle ๐Ÿšฒ rebuilding the wheel now that I have the gears off and spokes here. Once the wheel is trued, I will reinstall the tube. I’m not sure if I need a new rear tube, seems like it has a slow leak, I have rubber cement and rubber patches to fix it. Then I’ll order the remaining parts I need — a rear derailer cable and screw/adjuster plate. ๐Ÿ‘ฉ‍๐Ÿ”ง

Looking ahead to Sunday, showers, mainly after 2pm. High near 62. Southeast wind 6 to 13 mph. Chance of precipitation is 80%. New precipitation amounts between a tenth and quarter of an inch possible. Maximum dew point of 51 at 7pm. Typical average high for the weekend is 66 degrees.

Looking ahead, next Friday is Cinco de Mayo ๐Ÿค  when the sun will be setting at 8:01 pm with dusk at 8:30 pm. On that day in 2022, we had partly sunny and temperatures between 68 and 49 degrees. Right on target. Typically, the high temperature is 68 degrees. We hit a record high of 91 back in 1944. I am hoping to get out of town next week, maybe to the Adirondacks so I can get eaten alive by black flies. But a lot depends on the weather. Some forecasts call for sun, others for rain, but it’s 7 days out and that’s always a wild card. I guess the alternative could be going out to Schoharie or Rensselaerville.

 Across the Lake To Balm of Gilead

Milkweed and Monarchs ๐Ÿฆ‹โ˜  ๐Ÿฎ

Milkweed and Monarchs ๐Ÿฆ‹โ˜  ๐Ÿฎ

A few months back I posted several articles that I found in my research and reading about milkweed – how it’s wonderful for wildlife and really poisonous for livestock.

There are darn good reasons why farmers spray it and work to eradicate it from their farm fields. It can kill horses and cattle if mixed with their hay. That’s a big deal if you depend on your land for your livelihood that keeps you living the rural life. Seeing an animal die a painful death is traumatic to all involved.

But we need milkweed to support butterflies and our ecosystem. Like everything, there is a time and place. A noxious weed on the farm can also sustain life of other species, be part of a healthy ecosystem. The efficiency of clearing fields of noxious weeds is blamed for the decline of many common butterflies.

What is the solution? Probably a mix of both farming and places where milkweed can be planted and sustained in yards, nature preserves and land set aside by private owners for conservation purposes.

 Milkweed

Being watched as the sun set

 Butterfly

Wilderness

I often think many areas they call wilderness areas aren’t true wilderness. On the other hand, areas not called wilderness can be very much true wilderness.

I spent four or five hours hiking today back to Hilderbrandt Vly and Glasgow Lake and did not see another person. The snowmobile trail while soft and flooded in many low lying areas contains little evidence of overuse, indeed I suspect these lakes are little visited except by snowmobilers and a handful of hunters and fishermen. If anything Glasgow Lake shows the signs of the most use of the area but at least while I was there I didn’t see a single other person.

What I Like To Do Around Camp

People sometimes ask what I like to do while campingโ›บ Besides sitting by the fire and listening to the spring peepers and the birds,🐸 I also will often put on some music or a podcast, especially in the evening.

In the day time I like to cook – I actually like camp cooking better than at home as I’m not distracted by all the other things going on at home. 🍳I also spend a lot of time reading as camping often is a long distraction free time for me. Lately I’ve been spending more time writing, 📚as I’m trying to capture more of my thoughts and experiences in words.

 Camping At Camp Run

Camping in the wilderness is a chance to get away from all the noise and problems that are inherent in living in the city.

April 27, 2023 Morning

Miles from nowhere ๐Ÿ—ป

Lately I’ve gotten into Cat Stevens record lately. I think it’s because I have a lot more energy these days and feel great.

Good morning! Happy Arbor Day. ๐ŸŽ„ Trees are great. They keep it cool in the summer, are nice and warm when you burn them, great places to hang stuff off of and create good healthy oxygen.

Fog and 41 degrees in Delmar for the morning walk. ๐ŸŒซ Calm wind. More sun later with skies clearing around 8 am as the fog burns off.

Finally got up and walking ๐Ÿšถ closer to six 6โƒฃ this morning. Little achy from the dampness but it’s good to be alive. Barley and blueberries for breakfast ๐Ÿฅฃ when I get home. This evening after the walk I’ll refill my pantry so I have a wider variety of healthy choices in my pantry for next weekend going into next week. Variety is important for a good diet. ๐Ÿ ๐Ÿฅฆ

Today will have isolated showers between 10am and noon. Mostly sunny ๐ŸŒž, with a high of 61 degrees at 5pm. Four degrees below normal, which is similar to a typical day around April 19th. Calm wind becoming northwest around 6 mph in the afternoon. Chance of precipitation is 20%. A year ago, we had partly cloudy skies in the morning, remaining cloudy in the afternoon. The high last year was 51 degrees. The record high of 91 was set in 1962. There was a dusting of snow in 2020.โ„

Solar noon ๐ŸŒž is at 12:54 pm with sun having an altitude of 61.2ยฐ from the due south horizon (-9.7ยฐ vs. 6/21). A six foot person will cast a 3.3 foot shadow today compared to 2.2 feet on the first day of summer. The golden hour ๐Ÿ… starts at 7:12 pm with the sun in the west-northwest (283ยฐ). ๐Ÿ“ธ

Yesterday I got in 10.1 miles walked ๐Ÿšถ for the day which is good. The heavy rain held off until 8 pm, it was pouring by the time I was heading home from the park. Got dark quickly too. Tomorrow marks 100 days walking five miles or more a day some days far more. I can’t complain, I feel great.

The sunset is in the west-northwest (290ยฐ) with the sun dropping below the horizon at 7:51 pm after setting for 3 minutes and 4 seconds with dusk around 8:20 pm, which is one minute and 8 seconds later than yesterday. ๐ŸŒ‡ At dusk you’ll see the First Quarter ๐ŸŒ“ Moon in the southwest (215ยฐ) at an altitude of 67ยฐ from the horizon, 252,244 miles away. ๐Ÿš€ The best time to look at the stars is after 8:58 pm. At sunset, look for mostly clear skies ๐ŸŒ„ and temperatures around 57 degrees. There will be a calm wind. Today will have 13 hours and 58 minutes of daytime, an increase of 2 minutes and 35 seconds over yesterday.

Tonight will be partly cloudy ๐ŸŒค, with a low of 37 degrees at 5am. Five degrees below normal, which is similar to a typical night around April 16th. Light south wind. In 2022, we had cloudy skies in the evening, which became mostly clear by the early hours of the morning. It got down to 37 degrees. The record low of 25 occurred back in 1947.

Not a particularly nice weekend on tap. ๐Ÿ˜ž Saturday, showers, mainly after 8am. High near 54. Southeast wind 10 to 15 mph. Chance of precipitation is 80%. New precipitation amounts between a quarter and half of an inch possible. Sunday, showers likely, mainly after 2pm. Mostly cloudy, with a high near 65. Chance of precipitation is 70%. Maximum dew point of 51 at 1pm. Typical average high for the weekend is 66 degrees.

As previously noted, next Thursday is 8:30 PM Dusk ๐ŸŒ† when the sun will be setting at 7:59 pm with dusk at 8:29 pm. On that day in 2022, we had rain showers, mostly cloudy and temperatures between 57 and 50 degrees. Typically, the high temperature is 68 degrees. We hit a record high of 91 back in 1944.

Yellow Tulip

Don’t be stupid about wind turbines!

Don’t be stupid about wind turbines! ๐ŸŒ€

Wind turbines don’t run all of the time.

Wind turbines have to be started by the electric power in the grid just like a car needs a battery and a starter to start. It takes energy to get the blades moving then they coast along with the wind once they’re moving.

Wind turbines like a car can be shut off when their is no market for their power, wind speed is too low or strong, or maintenance is required. They have both braking using the motors and physical brakes like a car. Just because it’s windy doesn’t mean that a wind turbine will be turning or generating electricity.

Like running a car engine, running a wind turbine puts wear on the bearings and other equipment like the blades – you only want to run it when necessary. Plus you have to have somewhere to dump the power – if you loose the grid connection the turbine must stop or the wires or turbine motor will burn up as electricity must be consumed as soon as its produced.