I was interested in re-purposing this example on using PostGIS from within R. It assumes that “an ODBC connector has been set up”. It did take me a while to set up the connection from R on a Mac (OS 10.5.8), and I did not find a coherent documentation about this.
So for the record, below is how I did it. Continue reading
For an experimental spatial PostGIS database I needed to set up Drupal to manage the data entry. Drupal by default installs with mySQL, so to run it with PostgreSQL, which allows me to add the PostGIS language I needed to take a longer route.
Here is how it worked. Continue reading
scrapbook for code, software, data, and more