GeoNotes Blog | GeoNotes

Downloading Ambient Weather Station Data into MariaDB/MySQL

A python script

Posted on May 29, 2025

I bought an Ambient Weather WS-2902 Home Wi-Fi Weather Station with Wi-Fi Remote Monitoring and Alerts as an entry level station that I could use to log my own data from. Unfortunately it seems the data has to go to the cloud before you can grab it. [Read More]
Tags:
- database
- data management
- python
- MariaDB
- MySQL
- Weather
Continuing the exploration of linear referencing in PostGIS

Consolidating code and text after AI ran too far

Posted on May 17, 2025

Post One of Two [Read More]
Tags:
- database
- postgresql
- GIS
- geodata
- spatial
- data management
- PostGIS
- Spatialite
Measuring my home network performance

To hard wire or not (wifi)

Posted on January 6, 2025

Measuring my home network performance [Read More]
Tags:
- linux
- windows
- networking
My Common and Not so Common Git Commands

Another note card for myself

Posted on December 28, 2024

This is mostly a log for myself of stuff I don’t do every day so I don’t have to Google it all the time. [Read More]
Tags:
- git
- data
Finding and Filling Gaps in Timeseries Data Using MariaDB

Utilities for fixing time series data

Posted on December 26, 2024

Utilities for finding and filling data gaps in timeseries data [Read More]
Tags:
- weather
- data
- timeseries
- database
Utilities for GIS data file discovery and documentation

GIS metadata stubbing scripts using OSgeo tools

Posted on March 20, 2024

Utilities for GIS data file discovery and documentation [Read More]
Tags:
- gis
Expand Linux VM Disk under Proxmox VE

Notes for myself as I need to keep looking this up

Posted on January 12, 2024

Updated: 12-Dec-2024 [Read More]
Tags:
- linux
Tools to Try in 2023

Tools I use and want to try to use for 2023

Posted on October 26, 2023

Most of the items below are from https://wiki.opensourceisawesome.com/shelves [Read More]
Tags:
- linux
Linear referencing events in PostGIS

Points snapped to lines, describing linear conditions along the lines

Posted on February 2, 2023

Updated on May 15, 2025 [Read More]
Tags:
- database
- postgresql
- GIS
- geodata
- spatial
- data management
- PostGIS
- Spatialite
Youngstown, NY to Me

Words that describe my hometown to me

Posted on December 7, 2022

Intro [Read More]
Tags:
- Youngstown
- NY
- family

Older Posts

Downloading Ambient Weather Station Data into MariaDB/MySQL

A python script

Continuing the exploration of linear referencing in PostGIS

Consolidating code and text after AI ran too far

Measuring my home network performance

To hard wire or not (wifi)

My Common and Not so Common Git Commands

Another note card for myself

Finding and Filling Gaps in Timeseries Data Using MariaDB

Utilities for fixing time series data

Utilities for GIS data file discovery and documentation

GIS metadata stubbing scripts using OSgeo tools

Expand Linux VM Disk under Proxmox VE

Notes for myself as I need to keep looking this up

Tools to Try in 2023

Tools I use and want to try to use for 2023

Linear referencing events in PostGIS

Points snapped to lines, describing linear conditions along the lines

Youngstown, NY to Me

Words that describe my hometown to me