GeoNotes
  • About Me
  • Resources
    Beautiful Jekyll Learn markdown
  • Author's home
  • Search
Navigation bar avatar
✕

    GeoNotes Blog


    Notes for myself and others
    • Linear referencing events in PostGIS

      Points snapped to lines, describing linear conditions along the lines

      Posted on February 2, 2023

      This will be a growing post on my exploration of linear referencing in PostGIS. [Read More]
      Tags:
      • geodata
      • gis
      • 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
    • Organizing spatial data (or just data) for organizations

      My approach for keeping data from spawling like basket of socks

      Posted on November 29, 2022

      This is a living post. Check back for updates as I learned more. [Read More]
      Tags:
      • geodata
      • gis
      • spatial
      • data management
    • Rapid QGIS reinstalls - Portable settings and profiles

      Moving or reinstalling Qgis just got easier for me

      Posted on November 28, 2022

      This is a living post. Check back for updates as I learned more. [Read More]
      Tags:
      • qgis
      • gis
    • Sample blog post

      Each post also has a subtitle

      Posted on February 28, 2020

      This is a demo post to show you how to write blog posts with markdown. I strongly encourage you to take 5 minutes to learn how to write in markdown - it’ll teach you how to transform regular text into bold/italics/headings/tables/etc. [Read More]
      Tags:
      • test
    • Handy database documenter/profiler for mysql, cont.

      Posted on September 6, 2016

      Some time ago I wrote down a little script to make a table from the MySQL information schema to describe your database. My eventual goal is to come close to reproducing a poor man’s database profiling script similar to this crude one ( http://www.ipcdesigns.com/data_profiling/), but perhaps less powerful and yet... [Read More]
    • Photo contact sheet from command line

      Posted on August 7, 2015

      Recently I needed to inventory a bunch of equipment at a client so I went armed with camera and took a bunch of pictures and notes and came home. Ultimately what I wanted was one or more files containing thumbnails of each image along with the filename below it to... [Read More]
    • ArcMap 10.2 slowness

      Posted on March 6, 2014

      We’ve been experiencing some a lot of slowness with ArcMap 10.2 across many Windows 7 (64-bit of course) Pro and Enterprise machines. So my colleague has done a lot of research, phone calling (with Esri), and troubleshooting to arrive at the following helpful information. If you having some weird and... [Read More]
    • Dear hipsters

      Posted on February 22, 2014

      Just wearing untucked plaid shirts, that you clearly paid too much for, does not make you cool.
    • Postgres database from itis.gov

      Posted on January 29, 2014

      This might save you some head aches. The postgresql database dump of the taxonomic universe (according to the USGS) from http://www.itis.gov/ is provided in a latin1 character encoding (specifically it tries to create a database as ENCODING = ‘LATIN1’ LC_COLLATE = ‘en_US.ISO8859-1’ LC_CTYPE = ‘en_US.ISO8859-1’ ). In order to bring... [Read More]
    • Older Posts →
    • RSS

    John Zastrow  •  2023  •  northredoubt.com

    Powered by