Recently I went over the page kindly maintained by jeffschuler to get a sense of the status of the Drupal Geospatial Modules. If I consider investing in developing a Drupal Webmapping, how much can I rely on modules to exist in the future?
The graph below shows that many more geospatial modules exist in versions for Drupal 6 than Drupal 7 — Drupal 7 looking more similar to Drupal 5. However, there are two new modules that exist only for Drupal 7, Geofield (alpha release, seeking co-maintainers) and Address field (beta release, actively maintained).
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