andrewxhill / MOL

The Map of Life
mol.colorado.edu/
19 stars 4 forks source link

Spatial database for faster tiling #90

Open eightysteele opened 12 years ago

eightysteele commented 12 years ago

Start prototyping, keep open to using other dbs.

eightysteele commented 12 years ago

@robgur,@tucotuco

Good to find something that integrates with Mapnik, like PostGIS: http://trac.mapnik.org/wiki/OptimizeRenderingWithPostGIS

But I'm also looking at some NoSQL options too. CouchDB has some spatial support (http://vmx.cx/cgi-bin/blog/index.cgi/category/CouchDB), as does Cassandra (http://www.readwriteweb.com/cloud/2011/02/video-simplegeo-cassandra.php) and also MongoDb (http://gissolved.blogspot.com/2009/06/spatial-indexing-mongodb-with-rtree.html).

Changing issue label to Status-Started.

gaurav commented 12 years ago

I remember we were discussing setting up PostGIS a few weeks ago in the phone conversations. Does anybody know what the status of that is? One of my labmates here has some experience with PostGIS, so he might be helpful when we need to do this.