Recent Bookmarks

Archives

How to access a Postgres Database from R on Mac

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, [...]

Drupal 6 on Mac with PostGIS

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.

[...]