Linear referencing events in PostGIS
Points snapped to lines, describing linear conditions along the lines
This will be a growing post on my exploration of linear referencing in PostGIS.
[Read More]
-
-
Youngstown, NY to Me
Words that describe my hometown to me
Intro [Read More] -
Organizing spatial data (or just data) for organizations
My approach for keeping data from spawling like basket of socks
This is a living post. Check back for updates as I learned more. [Read More] -
Rapid QGIS reinstalls - Portable settings and profiles
Moving or reinstalling Qgis just got easier for me
This is a living post. Check back for updates as I learned more. [Read More] -
Sample blog post
Each post also has a subtitle
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] -
Handy database documenter/profiler for mysql, cont.
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
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
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
Just wearing untucked plaid shirts, that you clearly paid too much for, does not make you cool. -
Postgres database from itis.gov
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]