Search Results for: photo development in the albany area

Bulldozing Sand Dunes in Albany Pine Bush is Vulgur

Tearing Down a Sand Dune

Like Fuck.
Like Fuck You Guilderland.
Like Fuck You Wealthy Folk.

We’ve all probably uttered that word, sometimes more then we’d be proud of it. Yet, sometimes somethings are just truly vulgur like tearing down sand dunes to build McMansions.

New Mini-McMansions in Pine Bush

The first part of any housing development in the Albany Pine Bush appears to be the leveling of the land, and the carting off the sand to fill in other areas. To make the landscape flat and boring, so a suburban street grid, driveways, and foundations can be laid.

It involves tearing down tall beautiful pitch pines, removing habitat that might be restored if fire were to touch it once again, to sterlize the landscape for generations to come.

Welcome! To the Flattened Pine Bush.

People need places to live, places to farm, places to use. But do they really need to tear down magnificent sand dunes? If they had to build, couldn’t they have left more of the trees standing, and built on the dunes, and preserved the terrian?

Untitled

It might be easy and cheap to bulldoze sand. There is no rocks to blast away at. But making it all flat, just to stick tacky, plastic and plywood houses for the wealthy just seems so vulgur and awful.

Cue the music, the DIRE EMERGENCY SNOW STORM is upon us 🌨

Aldis in Colonie was so packed with people yesterday, picked over grocery wise with people stocking up for the winter storm that is supposedly approaching today, I just turned around and left. I look across the street at the Market32 with the packed parking lot, and tossed my hands up knowing chances were slim I’d get any whole-wheat flour or other needed groceries. Best to wait until today, when the stockers have been able to restore the shopping experience by morning. I’ll just do Walmart after I shower this morning.

Good morning! Happy Soon to be Wet and Sloppy Sunday. 🌧 It seems like it rains every Sunday lately. Without fail. Rain loves the weekend. Clouds and 35 degrees in Delmar, NY. ☁️ Calm wind. Temperatures will drop below freezing at tomorrow around 6 pm. ☃️

Decided I wanted pancakes today, 🍊 🥞 and I have a lot of oranges, so I decided to try out full-orange pancakes, milling both the orange and peal to make some rather zesty fully flavored pancakes with some lemon juice topped with some greek yogurt and honey. 🍯 Wow did they come out good — that orange flavor really shined, especially some ginger, vanilla in the mixture. Finished up the remaining oatmeal I had in the mixture, along with the whole wheat flour and had to fall back onto using some rye flour, but it worked out well.

Today will rain and snow. 🌧 High of 35 degrees at 7am. Two degrees above normal, which is similar to a typical day around February 9th. Calm wind becoming north 5 to 8 mph in the morning. Chance of precipitation is 90%. Total daytime snow accumulation of less than one inch possible. Not going to stick more A year ago, we had mostly sunny skies. The high last year was 45 degrees. The record high of 56 was set in 1916. 9.6 inches of snow fell back in 1897.❄

Riding trail in the Albany Pine Bush was great yesterday 🚵‍♀️ 🌲 though by mid-day I was starting to feel a bit worn out from all the trail riding. The section off of Kings Road was closed due to them logging and using a tub grinder to chop up the black locus, blackberries and invasive trees as part of the restoration effort. 🦋 Ended up riding my bike around Morris and Curry Road to see what I could spot from the road both ecologically and development wise, to further educate myself for Save the Pine Bush. 💭 In the afternoon, after shopping at Salvation Army I decided to head up Balltown Road to Aquaduct, as I wanted to check out the old Aquaduct that once carried the second Erie Canal across the Mohawk River and then NY 146 until the 1964 bridge was completed, and the aquaduct demolished to improve the river’s flow and prevent ice jamming. Seems odd these days when Mohawk River ice jams are rare, because the river rarely jams up with so much ice. ❄️ Climate change has changed a lot in our world. There was some ice on Mohawk River but not a lot. Then I rode my bike down the Erie Canalway to the ALCO Trail through that swanky new Mohawk Harbor development, then through the Stockade and Riverfront Park, then the Erie Canalway Trail to Lock 8 and ultimately out to I-890 – NY 5 Connector near Rotterdam Junction. 🛣

While Aldis was insane yesterday, 👔 I did luck out at the Salvation Army in Karner – Niskayuna – Lisha Kill or whatever the area off of Central Avenue and got two nice dressier shirts. The stuff you get there is nicer then anything you might find at Walmart and cheaper then going to a place like Macy’s or JC Pennies. Plus often much higher quality. Two really nice shirts for $9.60. Can’t beat prices like that. Not only are there wonderful deals at Salvation Army, you’re supporting their disaster and community development efforts. That place is a complete dump on the outside, with people leaving discarded furniture and trash all around it, but inside it really is the best thrift store to get really nice clothing, often for prices far below other thrift stores around. Not going to find anything that nice so cheap at Goodwill or one of the “high end” thrift store boutiques like in Delmar or Slingerlands. Also looked at lamps for my new office, 🛋 but I’m going to wait until I move into my permanent office before committing to buying a desk lap, assuming I can’t find one in a storage closet somewhere. Thrift shop’s the way to go for that — I am thinking I can put a 150 watt equivalent bulb 💡 in it as a bright desk lamp. I just hate the overhead florescent lighting.

Solar noon 🌞 is at 12:09 pm with sun having an altitude of 29.1° from the due south horizon (-41.7° vs. 6/21). A six foot person will cast a 10.8 foot shadow today compared to 2.2 feet on the first day of summer. The golden hour 🏅 starts at 4:21 pm with the sun in the west-southwest (238°). 📸 The sunset is in the west-southwest (246°) with the sun dropping below the horizon at 5:03 pm after setting for 3 minutes and 11 seconds with dusk around 5:33 pm, which is one minute and 18 seconds later than yesterday. 🌇 The best time to look at the stars is after 6:07 pm. At sunset, look for rain 🌧 and snow 🌨 and temperatures around 34 degrees. There will be a north breeze at 8 mph. Tomorrow will have 9 hours and 54 minutes of daytime, an increase of 2 minutes and 14 seconds over today.

Tonight will snow, mainly before 4am. 🌨 Low of 33 degrees at 5am. 18 degrees above normal, which is similar to a typical night around April 5th. North wind 9 to 13 mph. Chance of precipitation is 90%. New snow accumulation of 1 to 3 inches possible. Ain’t going to be much snow on the roads with that temperature, especially if they’re treated with the tons of deicing chemicals as they most certainly are. Maybe this week will be a good one to wash my truck. In 2023, we had mostly clear skies in the evening, which became mostly clear by the early hours of the morning. It got down to 22 degrees. The record low of -10 occurred back in 1925.

Looking ahead, there are 2 weeks until Don’t Cry over Spilled Milk Day 🥛 when the sun will be setting at 5:22 pm with dusk at 5:50 pm. I was totally getting teased the other day in my old office for being such a complainer. I know, I’m such a perfectionist. 💎 Cheap bastard too, but I’m saving all my money so I can blow it someday on land, 👩‍🌾 goats 🐐, hogs, 🐷 and cattle. 🐄 I’ve been told cattle are the fastest way to be broke forever, maybe except for horses. 🐴 Probably someday I’ll meet a girl who is as much a hillbilly as I’m and I’ll have to agree on horses in exchange for having a burn barrel and land. 🔥🛢 Actually, I think I complain about things, but it’s different from what others complain about. I don’t like working in suburbs, when so many others love the acres of parking for easy motoring and the convenience of avoiding crowded elevators, lol. 🤣 On that day in 2023, we had mostly sunny skies snow showers and temperatures between 38 and 23 degrees. I wouldn’t say that’s spilled milk, but a rather nice day. Maybe just a few drips of milk after the teats are stripped. 🐮 Typically, the high temperature is 35 degrees. Going to be in the forties during this up coming week. We hit a record high of 59 back in 1981.

Recharge

I Can Help You Make a Map

Geographic Information Services (GIS)MapsCartography 🗺

I am an amateur cartographer who designs maps and does a wide variety geospatial analysis using free and open-source geographic information software (GIS) and public sources of data to design quality maps, graphs, charts and datasets. I am looking for new and interesting projects to improve my skills, make connections and expand my portfolio.

Are you looking for my personal blog with it’s hiking, camping and outdoor recreation maps, along with a variety of charts, photos, and stories? Please visit andyarthur.org.

Mapping Avaliable

  • Tax/Property Mapping
  • High Resolution Aerial Photography
  • Recreational Maps – Hunting, Camping, Hiking
  • Georeference addresses using State Address Mapping service, plot them on a map
  • Wetlands, Topographic Contours, Land Cover
  • Compare historical aerial photos or maps to current photography
  • Web mapping using leaflet (HTML/Javascript file to embed on a website or use at home)

Example maps can found below.

Services Available

  • A list of property owners within 1,000 feet of a proposed development
  • How many cars per day pass a business?
  • How many people who live within 5 miles of a business or park?
  • How many African Americans and Hispanics live within 10 miles of Albany Pine Bush?
  • What are wealthiest election districts?
  • How many people ride public transit in a neighborhood?
  • How much of an area is wetland or farm field?
  • How big an interchange?
  • What is the average slope and elevation of an area or trail?

Example data can found below.

Pricing and Cost

For most projects, there is no fee. I am looking for experience, references, mentors and connections in the geospatial community.

If you have a large project, let’s talk about it. I might be willing to do it for free, if it’s something really interesting
or important like fighting suburban sprawl and pollution. I don’t a business or taxes set up, so I can’t really charge at this point.

How to get started?

Please send me an email describing the mapping or data project in as much detail as possible.

My email is andy@andyarthur.org

Data Avaliable

  • US Census – 2019 American Community Survey, 2020 US Census
  • NYS Tax and Assessment Rolls (2020)
  • NYSDOT Traffic Counts and Road Data
  • Historical Aerial Photography (primarily 1952, but earlier and later exist)
  • ArcGIS REST/Services and WMS Services from state and local agencies
  • LiDAR Elevation Profiles
  • USGS Topographic Maps, historic and modern – with overlays if requested
  • Data Repositories like CUGIR, DataNY.gov and NYSGIS
  • Recreation data from NYSDEC

Software Used

  • Quantum GIS (QGIS) including 3D Mapping
  • Geodata Abstraction Library (GDAL, ogr2ogr)
  • Python, including the data-science libraries PANDAS and GeoPANDAS
  • LeafletJS Web Mapping Services

Geographies Avaliable

  • Primary Capital Region and also much of New York State, also some for Pennsylvania, Vermont, West Virginia
  • State, county, municipal, school districts – Most data sets
  • Parks, highways, buffer (distance to) – Most data sets
  • Election districts – Roughly 75% of NYS counties
  • Census Tract or Blockgroup – 2019 American Community Survey
  • Tabulation Block – 2020 US Census

Are printed maps avaliable at this time?

Not currently. I can send you a file based on your specifications to print at your local print shop.

How long do mapping projects take?

Depends on complexity of the project. Many projects only take minutes, however if a project requires georeferencing, data cleaning, or custom shapes or layouts, it might take significantly longer. More revisions lead to better quality output.

Do you make maps professionally?

No! This is just a hobby. But I’m interested in expanding my skills. I do a lot of mapping for my blog and in support of community organizations like Save the Pine Bush.

Are my maps of good quality?

Thats for you to decide. I don’t have formal education in map making, and I don’t have professional tools. But do take a look at the work I’ve done below.

Examples of Maps


This shows a 3D rendering of the Buckville Canal north of Hamilton


This map shows the use of 2020 PL 94-171 data to calculate population density in City of Albany.


This 1985 aerial photo shows Crossgates Mall prior to it’s expansion.


This GIF image shows the change in unemployment during Coronavirus panademic.

This image shows hiking trails near Brooktrout, Falls Pond and Deep Lake.


Peebles Island, a Comparison 1952


3D Interactive of campsites at Moose River Plains.


Sample tax map in Albany.


Election results – 2020 Presidential Election, Onondoga County.


Map showing where sparklers are legally sold in New York.


Downtown Plattsburgh 1866 Beers (1866 Beers vs. 2020 OSM)


3D Rendering of Canandaigua Lake


Map showing Buffalo Mayoral Primary results and campaign donors.


Overlay of Proposed Retail Core in 1963 Plan for the Capital City.


Map showing Local Area Unemployment Statistics – April 2020.


Interactive tax map in Delmar


State Land in Stockholm, NY – Buckton State Forest.


Empire State Plaza take area, 1952


3D Rendering of the 1898 Watkins Glen Topographic Map

Examples of Data and Code

Properties in Albany Pine Bush Study Area,Excel Files: Various Tax Rolls,Find coordinates and political districts,Look Up State Tax Records and aScript for Processing RPTL 1520 PDFs.

Querying state property database, political enrollments, PL 94-171 Census files, calculating population statistics, what address is a district in, converting old districts to new districts.

Miles from Albany millions population
50 1.002
100 1.750
150 3.511
200 17.102
250 17.725
300 18.699
350 19.411
400 20.187
450 20.201
import pandas as pd
import geopandas as gpd
 
# path to overlay shapefile
overlayshp = r'/tmp/dis_to_albany.gpkg'
 
# summary level -- 750 is tabulation block, 150 is blockgroup
# large areas over about 50 miles much faster to use bg
summaryLevel = 150
#summaryLevel = 750
 
# path to block or blockgroup file
if summaryLevel == 150:
    blockshp = r'/home/andy/Documents/GIS.Data/census.tiger/36_New_York/tl_2020_36_bg20.shp.gpkg'
else:
    blockshp = r'/home/andy/Documents/GIS.Data/census.tiger/36_New_York/tl_2020_36_tabblock20.shp.gpkg'
 
# path to PL 94-171 redistricting geoheader file
pl94171File = '/home/andy/Desktop/nygeo2020.pl'
 
# field to categorize on (such as Ward -- required!)
catField = 'Name'
 
# geo header contains 2020 census population in column 90 
# per PL 94-171 documentation, low memory chunking disabled 
# as it causes issues with the geoid column being mixed types
df=pd.read_csv(pl94171File,delimiter='|',header=None, low_memory=False )
 
# column 2 is summary level 
population=df[(df.iloc[:,2] == summaryLevel)][[9,90]]
 
# load overlay
overlay = gpd.read_file(overlayshp).to_crs(epsg='3857')
 
# shapefile of nys 2020 blocks, IMPORTANT (!) mask by output file for speed
blocks = gpd.read_file(blockshp,mask=overlay).to_crs(epsg='3857')
 
# geoid for linking to shapefile is column 9
joinedBlocks=blocks.set_index('GEOID20').join(population.set_index(9))
 
# store the size of unbroken blocks
# in case overlay lines break blocks into two
joinedBlocks['area']=joinedBlocks.area
 
# run union
unionBlocks=gpd.overlay(overlay, joinedBlocks, how='union')
 
# drop blocks outside of overlay
unionBlocks=unionBlocks.dropna(subset=[catField])
 
# create population projection when a block crosses
# an overlay line -- avoid double counting -- this isn't perfect
# as we loose a 0.15 percent due to floating point errors
unionBlocks['sublock']=unionBlocks[90]*(unionBlocks.area/unionBlocks['area'])
 
# sum blocks in category
unionBlocks=pd.DataFrame(unionBlocks.groupby(catField).sum()['sublock'])
 
# rename columns
unionBlocks=unionBlocks.rename({'sublock': '2020 Census Population'},axis=1)
 
# calculate cumulative sum as you go out each ring
unionBlocks['millions']=unionBlocks.cumsum(axis=0)['2020 Census Population']/1000000
 
# each ring is 50 miles
unionBlocks['miles']=unionBlocks.index*50
 
# output
unionBlocks

Land use in town of Berne (from 2016 National Land Cover Dataset)

Most highly assessed properties in Albany County …

from arcgis.features import FeatureLayer
lyr_url = 'https://gisservices.its.ny.gov/arcgis/rest/services/NYS_Tax_Parcel_Centroid_Points/MapServer/0'
layer = FeatureLayer(lyr_url)
query_result1 = layer.query(where="COUNTY_NAME='Albany' AND FULL_MARKET_VAL > 100000000", 
                                    out_fields='PARCEL_ADDR,CITYTOWN_NAME,FULL_MARKET_VAL,OWNER_TYPE', out_sr='4326')

df=query_result1.sdf.sort_values(by='FULL_MARKET_VAL', ascending=False)
df['Full Market Value'] = df['FULL_MARKET_VAL'].map('${:,.0f}'.format)

df
 OBJECTIDPARCEL_ADDRCITYTOWN_NAMEFULL_MARKET_VALOWNER_TYPESHAPEFull Market Value
112665264 Eagle StAlbany12042549252{“x”: -73.75980312511581, “y”: 42.650469918250…$1,204,254,925
391501200 Washington AveAlbany8862987152{“x”: -73.81092293494828, “y”: 42.679257168282…$886,298,715
4102081400 Washington AveAlbany6423982872{“x”: -73.82369286130952, “y”: 42.685845700657…$642,398,287
0885251 Fuller RdAlbany4400428272{“x”: -73.83559002316825, “y”: 42.690208093507…$440,042,827
518164632 New Scotland AveAlbany3775682018{“x”: -73.80381341626146, “y”: 42.655758957669…$377,568,201
1906141 Fuller RdAlbany3211991432{“x”: -73.83323986150171, “y”: 42.693189748928…$321,199,143
19108087See Card 1067Watervliet2808988761{“x”: -73.70670724174552, “y”: 42.719628647232…$280,898,876
1565380737 Alb Shaker RdColonie2639161003{“x”: -73.80365248218001, “y”: 42.747956678125…$263,916,100
921923304 Madison AveAlbany2342654182{“x”: -73.76227373289564, “y”: 42.648000674457…$234,265,418
2907201 Fuller RdAlbany2034261242{“x”: -73.83362605353057, “y”: 42.692609131686…$203,426,124
1669999515 Loudon RdColonie1660656008{“x”: -73.74958475282632, “y”: 42.719321807666…$166,065,600
72059247 New Scotland AveAlbany1622763388{“x”: -73.77597163421673, “y”: 42.653565689693…$162,276,338
620574132 S Lake AveAlbany1462963602{“x”: -73.77970918544908, “y”: 42.654390366929…$146,296,360
820597113 Holland AveAlbany1434985012{“x”: -73.77306688593143, “y”: 42.650762742870…$143,498,501
1778203MannsvilleColonie1425704001{“x”: -73.71245452369443, “y”: 42.718124477080…$142,570,400
18955091 Crossgates Mall RdGuilderland1305547008{“x”: -73.84702700595471, “y”: 42.687699053797…$130,554,700
102452186 S Swan StAlbany1284364032{“x”: -73.75980563770365, “y”: 42.653931892804…$128,436,403
13468831916 US 9WCoeymans1100000008{“x”: -73.83388475575597, “y”: 42.488730743021…$110,000,000
1235152380 River RdBethlehem1052631588{“x”: -73.76445503554325, “y”: 42.595925419330…$105,263,158
146509715 Wolf RdColonie1019672138{“x”: -73.81423716588279, “y”: 42.709939498581…$101,967,213
Categories:

Site Map

🌲🌲 Our Public Lands 🌳🌲

Interactive maps with backcountry and roadside camping: New York, Pennsylvania, West Virginia & Vermont.
List of NYS DEC Lean-Tos with map coordinates. List of NYS DEC Firetowers with map coordinates and more information.
Google Spreadsheet with Roadside, Primitive and Pay Campsites

Explore the Finger Lakes Trail, Long Path, Northville-Placid Trail and Long Trail/Appalachian in Vermont.
Catskill Park Mountain Peaks, Hudson Valley & Long Island Peaks, Peaks Over 3000 ft Elevation, Highest Peaks in Adirondacks, Interactive Map of All Named Summits in NYS, Blaze Colors in Catskill Park, Trailhead Parking Coordinates and Addresses in the Catskills.

Browse USGS Topo Quads as PDF 🆕 by State Lands or County. You can Bulk Download New & Old USGS Topograpic Maps.

Links to various NY State Land Websites 🆕. Get latest GIS Data from state Web Services.

⛺🌲 Camp 🌲🏕

Moose River PlainsCampsite Listing, Maps and photos of state’s largest free camping area.
Piseco-Powley RoadCampsite Listing, Maps and photos of 15 mile dirt road with camping.
Catskill Park Primitive CampsitesAn overview of free camping locations in Catskill Park.
Burnt-Rossman Forest, Cattaraugus County, East Branch Sacandaga River, Finger Lakes National Forest, Madison County, Pennsylvania, Vermont and West Virigina.

Campsite Coordinates for Bog River Flow / Lows Lake, Hudson River SMA (Buttermilk Falls), Lake Lila, Oswegathie River, Nine-Corner Lake, Pharaoh Lake Wilderness, Saranac River Campsites, Stillwater Lake, Schoharie County, and Sugar Hill State Forest.

Overview of Camping Areas in the Catskills, Green Mountains, Southern Adirondacks, Central Adirondacks, Northern Adirondacks, Allegheny National Forest and Penna. DCNR Motorized Campsites and the Monongahela National Forest West Virginia.

Free Campsite Overview Maps: Adirondack – North Country, Catskills, Central NY, Finger Lakes, Western NY. Interactive Map.

Places I camped in 2023, 2022, 2021 and 2020.

🏞 🛹 Bicycle Trails and “Blackie” My Mountain Bike 🚲 🚶

Finally bought a mountain bike, after chewing over a mountain vs commuter bike. Really enjoying riding my bike to work and when it rains there is always a bike rack to safely take it back home. One way to get to adventures at Thacher Park is the Nature Bus.

Empire Trail – KMZ and Interactive Map. Parking along it.

More Trailways with KMZ files including the Albany County Rail Trail, Black Diamond Trail, Catharine Valley Trail, Catskill Scenic Trail, Fonda, Johnstown & Gloversville Rail Trail, Genesee Valley Trail, Link Trail.

🦌🌲 Hunt 🦃🐿

Wildlife Management Units (Deer)KMZ Map shows the WMU boundaries.

Summer 2019 Aerial Photographs of WMUs

KMZ Maps of Deer Harvest Density by Town: 2019, 2018, 2017, 2016. By WMU 2017, 2016, 2015.

KMZ Maps of Buck Harvest Density by Town: 2019, 2018, 2017, 2016. By WMU 2017, 2016

2016 -2019 Deer and Buck Harvest by TownKMZ Spreadsheet with FIPS codes for making your own calculations.

🎣🐡 Fish 🐟🐠

Parking and Access to Trout StreamsAn interactive, downloadable KMZ Map.
Lakes with DEC Contour MapsA KMZ Map links to Contour Maps for Fishing.

🌨🏔 Sled & Wheel 🚙❄

State Truck Trails Over A Half MileDirt roads to explore in the backcountry.
NYS Statewide Snowmobile Trail SystemState trails on public and private lands.

📉📊 Learn 💵📈

Interactive Maps of NY CensusExplore and download KML files.
Charts and Interactive DiagramsFrom population to pollution control.
Andy Arthur GitHubGit my R and Python scripts used to make maps and diagrams.
Use ArcPullR to Get Geospatial DataSuper easy way to connect to get GIS data in R from government servers.
GDAL Opens E00 FilesMost open source programs nowadays can open common geospatial formats.
NY Building FootprintsWhere to find on the internet for making maps.
WMS and ArcMap ServicesDownloadable CSV file listing services used on the blog.
2022 US Census Population EstimatesRed states, south continue to gain population.
2020 Cartogram of State Population

💳 🏛 Property Taxes 🏠💸

Properties in Albany Pine Bush Study Area, Excel Files: Various Tax Rolls, Find coordinates and political districts, Look Up State Tax Records and a Script for Processing RPTL 1520 PDFs. Match NY SWIS Codes to FIPS Codes and GEOID. How to Find MapServer Data and Load Into QGIS.

🚗🚗 Big Red 🚗🚗

Big RedPhotos and Videos of my lifted truck with its camper shell. Big Red’s Dual Battery Setup for Camp Power, Video Tour and Diagram. Big Red is getting old. What is next? I’ve thought about going carless for a while to save money and reduce pollution. Or maybe going bigger? Or smaller? Five dollar gas sucks.

🔥🌲 Off-Grid Living 🏠🤠

I am seriously thinking about building an off-grid house. I have a first draft. I need to learn CAD! I have a road map towards buying land and building. I concede might have to live with long commute and give up traveling and camping. I need to be strong.

Why off grid? Well, I’m not into contemporary society. I want to own land, but not be called a landowner, and a cabin, not hooked to electrical grid, farm, raise pigs for food and burn my own trash. I’m saving for a better tomorrow, hoping to make the leap to another freer state. Having acreage is important. Cornfields aren’t bad neighbors. Maybe though my vision has grown smaller and more local. More on off-grid living.

I am 16 years into my career and have made some significant progress in my life. I love my job. But I do wonder on all the things I’m missing out but saving sure makes me high. Maybe it will be different when I own my own land — the end of goal of all this saving.

2020 into 2021 during the pandemic was a year of remote work. It was a struggle not having internet at home, worked a lot out of my truck. But I worked remotely from Horseshoe Lake which was super cool.

Generally I like the idea of owning land in a red state, particularly Idaho, Iowa, Pennsylvania, West Virginia, Wisconsin — and Midwest more generally. But I may settle for New York – it’s all about the f-ing money!

💻👨‍💻 Open Source 🗺️📍

I use open source software and public sources of data for the blog. Quantum GIS (QGIS), GDAL/ogr2ogr, PyQGIS, GeoPANDAS, R Studio and Leaflet for map making, Arduino and ESP32 microprocessors, Ubuntu Linux and XFCE Window Manager. I’ve recently gotten interested in machine learning.

I avoid using commercial software like Microsoft Windows and do not have home internet or television. If you don’t use commercial software and use your brain, fears of computer viruses are overblown. I deleted most of my social media accounts.

Creating Digital Surface Models using LiDAR Point Clouds.

📊🗺 R Statistical Programming 📜👨‍🏫

The R programming language and RStudio are powerful tools for statistical analysis, making maps and charts. Many of the blog posts and analysis I do are in R, ggplot not only makes great charts but also maps using tidycensus. Generally, R is better then Python for geospatial work.

Use IDW Interpolation to fill in missing Census data, Zonal Histograms for land cover, load WMS Aerial Photography in R, find mountain peaks, save Census shapefiles using tigris quickly, pull NY Election Night Results using Selenium. Fast reverse Geocoding in PostGIS. Working with PDFs in R. Fix a common error starting rselenium/wdman. Make data-filled calendars. R is wonderful and weird, learn it!

🐼🔢 Python and Pandas 💻🐍

Querying state property database, political enrollments, PL 94-171 Census files, calculating population statistics, what address is a district in, converting old districts to new districts, Shapefiles missing Projection information in QGIS.

Learn to code for free modern HTML, Javascript, Python and SQL at freeCodeCamp and web development at the Odin Project.

🐴 🐘 Politics 🦁 🐍

Crunched Election Results with Turnout for Albany County: November 2023, 2022, 2021, 2020, 2019 and Primaries June 2019, Pres/June 2020, June 2021, June 2022, Aug 2022, June 2023.

Albany County Races converted to the new 2023 EDs using Super EDs and Code: 2022, 2021, 2020, 2019 and Primaries June 2019, Pres/June 2020, June 2021, June 2022, Aug 2022.

Above Election Results as zipped Excel files.

Albany County Legislature Districts 2024 Maps

Maps Comparing 2017 and 2023 Albany County Election Districts and a Crosswalk Table Showing the Proposition of Voting Age Population in New and Old EDs

Maps of 2022 NYC Assembly Races, NYS Assembly Races, NY Senate Races, Governor’s Race in Erie County and Statewide. Partisan shift in governor race between 2010 and 2018.

A comparison of Democratic Performance 2022 Assembly Districts to those proposed in 2023 by the IRC. Here is latest 4/20/23 IRC Maps, showing ADP and how they change from existing Assembly districts. Most towns upstate, outside of cities, are quite red. Using LATFOR data with R to calculate Average Democratic Performance.

You can scrape employee salary data from SeeThroughNY using R. Other useful investigative resources.

I often think politics is for losers. I’m into the politics of statistical analysis and reading history books.

I believe strongly in the first amendment, second amendment, oppose gun restrictions and I support de-funding the police in favor of lower-cost technology and civilian employees. Maybe use red flag laws for voting to stop dangerous voters? And the media should stop promoting mass-shootings, even if it’s super profitable for all involved. They should tax the media when it promotes violence. I think some people are much too paranoid in politics. How elections are rigged under law to benefit incumbents. But vote, it’s the best option and inexpensive.

Yeah for the third parties! I voted for Larry Sharpe for Governor and Jo Jergenson for President but my views are complicated and often vote for Democrats, after voting Jill Stein Green Party in 2016.

Some thoughts on Joe Biden not seeking re-election. Times change, but Biden was been a good change over DJT and glad the Trump era is over and are glad prosecutors and grand jurors are holding him responsible by indicting him for many serious felonies. I don’t think Trump can win in 2024, as nothing has changed politically from 2020.

I think rural people should be left alone and not worship government workers or have parades for them. I am no fan of Donald Trump, his speeches are bad, I don’t like Trump’s embrace of radical environmentalists, but do admire the homemade roadside monuments to DJT.

🌲🌳The Earth 🌎 🐸

Why I oppose wilderness areas and parks. It’s trendy to be green these days, but is eco-marketing good for the planet? I visited the Mount Storm Coal Plant and Corridor H.

I worry about a lot about overly-aggressive Climate Change Action, and Undermining Environment Laws for Climate Action. I think we should all admit we are Addicted to Fossil Fuels. These days, urban recycling has become a joke, when it’s still an option at all. It’s better to just buy less shit and avoid the alure of Costcos. I really don’t like how aging radicals have become industrial solar salespeople.

Big bucks are coming to state-designated disadvantaged communities under the CLCP. Which counties and political districts are in line for the the most pork? Interactive map.

I’m a big of farmers who are essentially Living Off the Earth and think Rednecks are Noble Savages. Dairy Farming are key to our rural landscape. I’d trust a farmer or a hunter in a pile of guts he’s butchered over any ivory-tower scientist.

🌎🔆 Industrial Solar 🌞 🏭

Hundreds of multi-acre industrial solar farms are being built in our state. How bad is solar for the environment? We should ask tough questions. Interactive of recently built solar farms, proposed facilities. List of proposed industrial solar facilities. See how the Greenville Solar Farm changed the landscape.

💳 💸Saving Money 💰 💷

I am not a fan of ESG Investing as it’s not well diversified. I prefer index-funds and other tax-advantaged ways of saving. Why I am concerned about saving enough for retirement, even though I’m in my late 30s. We as a nation should save more, consume less. I like the idea of carbon tax to replace capital gains taxes to discourage consumption.

🥦 🍎Mission Fifty, Smoking Grass & Being Healthier 🏠🧠

I am now officially in my 40s! I am building to a better life in my 50s, which means getting up early, walking a lot, saying no to cake and yes to more fruit. In many ways, the forties are an awesome time to be alive.

And eating healthy for less without losing sleep over arsenic. And I don’t think we should subsidize unhealthy habits. How I got started in eating healther. Meals are too focused on meat and carbs due to how we describe them, maybe I eat too many bananas in the office, what to eat while camping, worry more about salt then GMOs, eat more beans. Do spend extra for farmers market peaches, especially doughnut peaches and plums. Consider ethnic supermarkets. Thinking about how to make a healthier macaroni and cheese, spinach-mackeral-pasta salad, quick-cook biscuits and whole-wheat bread. That said, too many recipes are junk food crap. Okay in moderation is not okay. The fact that I’m thinner is not a sign I’m dying.

A few years back I decided to explore my mental illness with therapy, thinking about why I have so much anxiety and how many of my values are rational or just thinking too much rednecks’ burn barrels and how much of a throwaway society we live in. Do I want to change?

I’ve learned to care less about the world, and focus more on myself. Maybe I am happier as I am now, saving and investing a lot towards owning my own land, where I don’t have to deal with all the bullshit of modern life.

And smoke more grass, now that’s legal. Smoking pot is fascinating. Enjoying the rich colors. A map of licensed pot retailers in NYS. Yes, that stuff we used to think of as the smell of crime. Thoughts on Stoner Culture. Not that the blog advertisers like it.

Mission Fifty: Getting to the point where I own my own land. 🚜
Healthy Eating 🍎 / Growing My Wealth 💰
Healthy Thoughts 💭 / Enjoying Life 😃

Questions, comments? Feel free to email me at andy@andyarthur.org.

You do your thing, I’ll do mine.
I smoke pot and drink cheap beer, up in the wilderness. Yes it’s my right !

I use GNU open source software.
Plus I like buck goats,
because they’re real macho men
spraying their beards with goat urine.

I own guns, but not nearly enough. Some day when I live in a pro-2A state …
I can’t make everybody happy, so I’ll just be myself.” – Andy Arthur

Return to the Top

Laugh a bit and learn how your data is used on this blog: Privacy Policy

This blog is © Copyright 1997-2023 Andy Arthur.org, please share using the Creative Commons Attribution 3.0 License.

Categories:

What a week it’s been … 🔥📜 👨🏻‍🚒

Over the past week I’ve literally spent 17 plus hours sorting through wet, smokey and increasingly moldy papers trying to save whatever Albany history I can before it’s forever gone. While maybe John Wolcott will never be as famous as Erastus Corning or Nelson Rockeller, the truth is activists like him preserved some of the city’s most important history and lands, raised important questions made a difference again the Democratic machine, often at great personal cost.

While he did pretty well when “Republican” Theresa Cook (ala that time Rezsin Adams ran as a “Republican” for county legislature) was running the county clerk’s office, other times he was attacked tooth and nail for his performance as a title searcher for the county, even though he was probably the best title searcher and researcher of deeds and history the county ever had. I came across his lawsuit today drying out his papers along with the numerous exhibits on Albany County corruption and sneaky misdeeds or the Erastus Corning machine and by that time Jim Coyne’s county operations. The Corning machine was only really interested in punishing male dissidents, they couldn’t see in their minds that women could have any influence of politics. Ultimately it was the federal District Court that sided with him and had him reinstated but he fought for years to get the pension credit he deserved going back to the days when he was a consultant for Fort Orange 787 dig. The Fort Orange file got wetter than I thought but we got it apart drying. It will be saved. And while, maybe the history books write differently, certainly it was John Wolcott who helped to take down Jim Coyne through alerting the FBI to Coyne’s crooked deal over the Knickerbocker Arena, although like with Fort Orange and Paul Huey, the credit can’t necessarily be just his own.

And then as I was going through the papers, putting dried ones away I heard a screech and bang, and a car crashed into the traffic light pole at South Swan and Morton Avenue, causing the 100 plus lb traffic light to break free of the wire. The clearly fleeing car then took off leaking what appeared to be coolant. Police showed up, hauled the broken stop light off the road, talked to the neighbors and took off. Not sure what happened to the fleeting crashed car, I was too busy sorting papers. Albany is going downhill rapidly, things were looking up in the city not that long ago. I’m just glad I’ve been taking the bus there rather than driving especially with the neighborhoods getting so rough. I still remember that last time I walked down to Sheridan Hollow to visit John, a firearm rang out as somebody shot out a car window.

While working on John’s papers, I’ve been going through the EIS for a project in Troy and some Pine Bush issues in Guilderland with some tax data and GIS Mapping. People have gotten to know all the amazing things that I can do and I get more and more requests. It seems like everywhere I’m going I’m getting sucked into fights against City Hall everywhere, me with public records and free software, going up against million dollar reports with expensive professional software, internal only data and decades of training and experience. But if we don’t raise questions and fight development then who will? It’s tough as these professionals have big budgets and skills, but if house wife Jane Jacobs could stop Robert Moses, then so can ordinary people like myself. Not going to win every fight but it’s good to raise questions and stop bad development where we can. Even if it’s a pain to the local Bob Moses of today. It’s important we protect open space. Even if it involves some risk to myself and makes me not trust or respect most government workers.

Beyond all those wet and smokey papers and battling City Hall it’s been a crazy week for sure. The legislative session is wrapping up and I’ve been swamped with work, I was going through agendas for work well into the night on Saturday night. It’s been a crush at work and when I’m not in the office most of the time until late I’ve been drying out papers. I did get some bird watching in at Five Rivers Environmental Education Center this morning – saw a red tailed hawk being harassed by a few sparrows on the way out walking out there. I continue to back up, photograph and store important documents electronically in case of a disaster.

And then I’m also finally dealing with some of my own issues in my life. The counseling I’m getting is helping, it seems consistent with the advice I’m reading from trustworthy sources and publications on the internet. But change comes hard especially with bad habits of both negative thinking and repeated thoughts in thinking I’ve had ingrained for two decades now. I’m trying to change but it’s hard. I’m certainly learning a lot, becoming a better person because of counseling.

And I was doing better until the mixed emotions of Mr. Wolcott’s house fire – grief and sense of lostmy work sorting and carefully cataloging documents would be forever lost. But we saved a lot. But the shock and horror of it all, seeing that house in such disarray and burnt – that only a week ago before the fire when I was sorting and filing papers things looked so different. Plus all that stuff going to the Rensselaer landfill to be buried and forever viewed from my downtown office as a dirt and grass covered hill. Fire can be so bad, especially in the urban areas. Then I saw the other side tonight out in the country, the place I grew up. My parents neighbors, the ones who live in trailers and raise pigs and cows, were having a big ol bonfire, drinking beer burning an old couch, mattress and pallets with lots of black smoke. I’m so jealous of their homestead, even if they are what the government calls poor people who live in rundown trailers and barns. Kind of like that film about Appalachia I’ve been watching. But the country life is a life I’ll get to eventually, saving a bit each paycheck.

… Fire can destroy but it can cleanse too. That’s what my therapist reminds me.

February 15, 2020 Night

Good evening! Partly cloudy and 20 degrees in Delmar, NY. 🌃 There is a south breeze at 15 mph. 🍃. The current wind chill is 6. There are 2 inches of snow on the ground. ☃ Cold but reasonable. ️Things will start to thaw out at tomorrow around 9 am. 🌡️

Cold evening but not that bad. 🌃 It is reasonable for this time of year. Tomorrow is going to be pretty mild. Busy day today with Pine Bush things and the Reszin Adam’s documentary but at least was decent if cold. Didn’t get a lot of video 📹 of Rezin talking but some good b roll 📼 and a few discussions. The Pine Bush meeting was good 🌲🌲🌲as was lunch at Yonder Farms. 🍏 Always like the cookies 🍪 and sweets there. They are making good progress on fighting the Crossgates Maul development but they’re is much more to do.

I got a few hours put hiking and even climbed to the top of the long closed Greater Albany Landfill 🗻 to watch the sunset. I haven’t been up there in years. Eventually thought the Pine Bush commission is planning a trail over the landfill which will have great views of the Pine Bush Preserve and surrounding areas.🌄 It will be fascinating to see how things look when they plant Pine Bush grasses and maybe even Lupine on the landfill once it’s fully closed in a few years. Technically that area is off limits right tbut it’s not posted and it was five o’clock on a Saturday evening and nobody was at the landfill. 🚮All things said and done the landfill isn’t that big of a deal compared to something like the acres of parking 🅿 at Crossgates but still when I own my own land, I’ll probably use a burn barrel or maybe better yet a forced air homemade incinerator 🔥 so I only have to go to the recycling center ♻ less than once a year with a bag of cans and glass – which nowadays is less and less of the trash with plastics taking over. New formulations of PET have all but completely replaced glass 🍶 for everything but a few things like wine 🍷 and I don’t drink wine. That said, worrying much about landfills nowadays seems silly when they are proposing 10,000 acre solar farms everywhere. ⚡

I bought a four pound bag of broccoli and two pounds of frozen 🌽 so I should be good on vegetables for a while. Probably will go shopping on Tuesday night after work I’m thinking now as it’s going to wash the salt off the roads 🚗 with the rain and I am probably good for groceries in the meantime. I really try to minimize 🚫 the amount of driving I do especially in the winter. It’s kind of nice to stay home and save for a better tomorrow, especially with road trip and camping season not that far off. ⛺

Tonight will have a chance of snow showers, mainly between 1am and 4am. Mostly cloudy 🌧, with a low of 19 degrees at 10pm. Two degrees above normal, which is similar to a typical night around February 21st. Maximum wind chill around 6 at 9pm; South wind 13 to 16 mph. Chance of precipitation is 30%. Total nighttime snow accumulation of less than a half inch possible. In 2019, we had light rain in the evening, which became cloudy by the early hours of the morning. It got down to 22 degrees. The record low of -20 occurred back in 1943.

Tonight will have a Waining Crescent 🌘 Moon with 49% illuminated. The Worm 🐛 Moon is on Monday, March 2. The darkest hour is at 12:11 am, followed by dawn at 6:25 am, and sun starting to rise at 6:54 am in the east-southeast (107°) and last for 3 minutes and 2 seconds. Sunrise is one minute and 23 seconds earlier than yesterday. 🌄 The golden hour ends at 7:34 am with sun in the east-southeast (114°). Tonight will have 13 hours and 24 minutes of darkness, a decrease of 2 minutes and 42 seconds over last night.

Tomorrow will be mostly cloudy 🌥, with a high of 41 degrees at 3pm. Six degrees above normal, which is similar to a typical day around March 7th. South wind 5 to 9 mph becoming light in the afternoon. A year ago, we had mostly sunny skies in the morning, which became cloudy by afternoon. The high last year was 34 degrees. The record high of 61 was set in 2006. 17.3 inches of snow fell back in 1958.❄

This evening when I got home I got a $60 check from my dental insurance company saying that my dentist is out of network. 😷 I know I should be happy when they sent a check. Same dental hygienist and dental insurance, so I’m not sure the issue. Maybe a different dentist at the same office, they’re in and out in five minutes. Dentist hasn’t sent me a bill yet. 📄 I am hoping that I don’t get billed for the $177 that they billed the insurance for – there normally is no copay for normal cleanings. When I get the bill I’ll call 📞 and see if they will give me a better rate for paying in cash as I normally don’t pay with my insurance and it’s the same insurance policy I had with my new job as the old. An I will probably have to find a new dentist. The only other thing I can think of is maybe I visited the dentist one week short of six months ago – my insurance pays for twice a year cleanings but I’m not sure if they count days or two services per calendar year. Regardless! Frustrating 😤 though for somebody who is always trying to save money 💵 and run a tight budget.

Continuing to read Wiring Simplified by HP Ritcher et al. 🔌 While I’m not planning on any wiring projects in the near future, it’s a good skill to become more knowledgeable about and library books are free to read 📖. I want to be more knowledgeable about wiring and safety when I own my own land, as even if my house is off grid I’ll probably want some lights and wiring and off grid power systems are hardly maintenance free. Some of endless stuff about the code requiring outlets every so many feet in a kitchen seem kind of silly but on the other hand using robust equipment that is UL rated and safely installed, not drawing too much current over the wires is a big thing. ⚡ Arc fault sensors and GFIs have only become a bigger deal in the code lately, for good reason. Looking forward to the chapter about barnyard wiring 🐮 as barns have unique electrical challenges and safe wiring in barns is important with hay, water, rats 🐀 and livestock 🐮 chewing away at wires. The more I learn today the less to learn from scratch in the future. 🎓

In four weeks on March 14 the sun will be setting in the west (268°) at 7:01 pm (Daylight Savings Time),🌄 which is one hour, 34 minutes and 34 seconds later then tonight. In 2019 on that day, we had mostly cloudy, mild temperatures between 59 and 39 degrees. I definitely could use a day that warm again. Typically, you have temperatures between 43 and 25 degrees. The record high of 75 degrees was set back in 1946.

Looking ahead, Ides of March ✝ is a month away, Average High is 50 🌸 is in 6 weeks, Tax Day 💰 is in 2 months, Average High is 60 🌼 is in 9 weeks, Average High is 70 🐮 is in 13 weeks, Memorial Day Weekend Starts 🏕️ is in 14 weeks, Last Day of Session 🏛 is in 18 weeks and Summer ️⛱️ is in 18 weeks.

🇺🇸🦅Only 96 days remain until the start of Memorial Day Weekend!🦅🇺🇸

Stop Barrier Ahead

September 22, 2018 Night

Good evening! Happy Autumn. Partly cloudy and 50 degrees in Fayetteville. ⛅ Calm wind. Definitely feels like an autumn evening with a good chill in the air.🍂

Definitely a fantastic sunset tonight here in the Syracuse area. 🌄 Loads of color for sure and I had a great view from Green Lakes State Park overlooking Minoa and Fayetteville. The hills hide most of the development and the bird conservation area is fantastic for viewing wildlife without the crowds. 🐸

Tonight will be partly cloudy ☁, with a low of 42 degrees at 5am. Seven degrees below normal. Light and variable wind. Definitely an autumn night. In 2017, we had partly cloudy skies, clearing in the early hours of the next day. It got down to 53 degrees. The record low of 32 occurred back in 1963.

Tonight will have a Waxing Gibbous Moon 🌔 with 96% illuminated. The moon will set at 4:59 am. The Harvest Moon 🌕 will be tomorrow with a chance of showers. Shine on harvest moon! The sun will rise at 6:52 am with the first light at 6:23 am, which is one minute and 6 seconds later than yesterday. 🌄 Tonight will have 11 hours and 52 minutes of darkness, an increase of 2 minutes and 55 seconds over last night. Sometime next week we will start having more night than day time. Winter is coming! ❄

Tomorrow will be sunny 🌞, with a high of 66 degrees at 3pm. Three degrees below normal. Maximum dew point of 48 at 4pm. Light and variable wind. A year ago, we had partly cloudy skies. The high last year was 85 degrees. Pretty warm for sure that day when I was camping up at Moose River Plains. The record high of 97 was set in 1895.

Looks like a a nice day to do some hiking and enjoying of the day. 😎 It’s no going to be long before sunny days in the mid 60s are a rarity. I have stuff to do tomorrow so I can’t venture out too far but maybe I’ll follow up my evening hike today with a hike along the Erie Canal tomorrow. I also want to spend some time hiking along Onondaga Lake at the county park but I think I’ll hold off for later in the month. Syracuse downtown is pretty overlooking the lake especially when there is some fog on it during a nice crisp morning. 🏃

Yesterday when I was out hiking my digital camera battery went dead, so I don’t have much video and I couldn’t use my telephoto lens. 📷 Still it was a nice evening for a walk. The camera battery is charging now. I should have left it charging all day as the accessory battery in my truck remains really well charged even with the short trips for work due to the ample sun over the past few days hitting the solar panel.

I do miss being home and even more so camping ⛺ but I’m well paid for my work and enjoy the travel. Lots of nice people you meet along the way and it’s providing me with extra money to put away towards my long term savings goals of owning land and an off-grid cabin where I can finally have my own space that is more than just a temporary residence in the wilderness. 🌲 I do have some camping gear in my truck so I might be able to get away for a night but honestly I’m looking forward to those long November nights next to the campfire, using my camp oven and making delicious meals. 🍝 Right now where I’m working I lack a stove, oven and freezer, so while I can cook some things or get take out it’s nothing like a good meal cooked in the wilderness.

I have been working on uploading📤 some of the essays and other interactive content of developed for my blog over the summer and plan to be featuring more of it over the coming weeks. 💻 Last week moving to the new office and attending that wake back in Albany meant I didn’t have a lot of free time to post to the blog but I am good with stuff going forward – it’s more just a matter of getting the final tweaks done before it goes live. 📝

In four weeks on October 20 the sun will be setting at 6:12 pm,🌄 which is 47 minutes and 57 seconds earlier then tonight. In 2017 on that day, we had sunny skies and temperatures between 71 and 46 degrees. Typically, you have temperatures between 58 and 38 degrees. The record high of 80 degrees was set back in 1965.

Looking ahead, Average High is 60 🍂 is in 3 weeks, Northern Zone Regular Season 🦌 is in 4 weeks, Regular Deer Season in Southern Zone 🦌 is in 8 weeks and Thanksgiving 🦃 is in 2 months.