GeoNotes Blog | GeoNotes

UPDATE_ON column in MySQL with trigger

By John C. Zastrow

Posted on September 19, 2008

I needed to update a column with the date and time whenever a record changed in my database. So here is the recipe for the trigger in MySQL 5.0. [Read More]

Auto File transfer/copying with SCP

By John C. Zastrow

Posted on September 19, 2008

Here is a [Read More]

Exporting and Importing in Oracle: A Quick Start

By John C. Zastrow

Posted on September 5, 2008

I do this about twice per year and every time I have to look back at my notes to remember how. Maybe you are in the same boat. So, to save us both some trouble I’m going to blog my notes on the subject here. [Read More]

EPA Supports WATERS Geospatial data through OGC WMS/WFS Services

By John C. Zastrow

Posted on August 5, 2008

EPA appears to be using ESRI's ArcIMS 9.2 OGC connectors to publish OGC WMS/WFS services of their WATERS data. [Read More]

When you need a sexy terrain relief map

By John C. Zastrow

Posted on August 4, 2008

If you’ve ever needed to make nice looking relief maps like I do now, have a look at these sites. http://www.reliefshading.com/ and http://www.shadedrelief.com/ [Read More]

Good review of Mapnik for generating online maps

By John C. Zastrow

Posted on July 25, 2008

In my opinion you can’t beat UMN Mapserver or Mapnik for making gorgeous online maps. Mapserver has installed and run for me flawlessly every time I’ve tried it — without days of arguing with it. Mapnik has taken me nearly a week to get running sometimes. But, just like you... [Read More]

History of Rasters in PostGIS and a glimpse into the mechanics of an Open Source Project

By John C. Zastrow

Posted on July 24, 2008

GWT Charting Kit

By John C. Zastrow

Posted on July 23, 2008

Here is a nice GWT-based charting kit. It looks like it might be a reasonable replacement for a lot of we normally use JfreeChart for. [Read More]

Open Source County – Impressive Geospatial Portal

By John C. Zastrow

Posted on July 22, 2008

I keep having to fish around for this URL so I’m just going to blog into this online note space that I maintain. One stop shopping. [Read More]

Putting your own content into a website with Google Maps

By John C. Zastrow

Posted on July 21, 2008

So I’m doing a little research tonight on some requirements for a client: [Read More]