Day: July 26, 2025πŸ’Ύ

πŸ—ΊοΈ Maps πŸ–ΌοΈ Photos πŸ“½οΈ Videos

Buck Settlement Lean-to

Been years since I've been back to this Lean-to and it's still in beautiful shape, maintained perfectly looking like new. And it's such a beautiful open canopy forest near the Glen Creek. 

Friday July 30, 2021 — Sugar Hill State Forest
Map: Red Horse Trail
Thematic Map: The fertile lands of the Black River Valley are Surounded by Tug Hill and Adirondacks

Excel is not a data cleaning tool πŸ’Ύ

I keep seeing Facebook posts that have tips and tricks for data cleaning and processing with Microsoft Excel. Honestly I don’t recommend it.

Excel is fine for reviewing outputted data and very light weight data work, but you are much better off to use R and tidyverse or Python and PANDAS for all but the simplest data work. Often storing data is best done using a Parquet but don’t assume most people even know what one is.

Spreadsheets are not databases or for processing data. They’re excellent for reviewing data and transferring it between people in a format nearly anybody can understand but don’t try to get cute with Excel formulas and try to do things in Excel you really should use a data library to process and a database to store in.

SVGZ Graphic: Agriculture, forestry, and fishing, value added (% of GDP)
Map: Sand Lake
Thematic Map: Onondoga County Executive 2023 - Bill Kinne vs. Ryan McMahon