Systems

In this installment of How To Stick Anything In CouchDB, I’ll take some bicycle path data released by the municipality of Copenhagen and stick them in CouchDB. As always I’m working in Terminal under Mac OS X. Bicycle paths in Copenhagen, served live by CouchDB: Your browser does not support IFRAME The data is in

http://guide.couchdb.org/

The spatial databases covered are PostGIS, MySQL spatial and MongoDB, Apache Cassandra. UPDATE: I’ll change this post or create a page to give the actual linux commands to run on the remote server. PostGIS on EC2 I have found a nice tutorial that describes setting up Postgres on EC2 on an Ubuntu instance with all

General instructions are here: http://wiki.openstreetmap.org/wiki/Osm2pgsql#Mac_OS_X Note: I’m running Snow Leopard (10.6.6 ) 1. Install homebrew Check that you don’t have it already: $ which brew If you don’t have <a href="http://mxcl.github.com/homebrew/">homebrew</a> install it from here: https://github.com/mxcl/homebrew/wiki/installation E.g. like this: $ ruby -e “$(curl -fsSLk https://gist.github.com/raw/323731/install_homebrew.rb)” 2. Install proj $ brew install proj $ which proj

1. Download data and software The instructions are fairly generic, so should work for both Windows, Linux and Mac OS X. I wrote them for Windows, but I’ve since then switched to Mac OS X. PostgreSQL+PostGIS I assume that you do not already have Postgres/PostGIS installed on your system. Download PostgreSQL+PostGIS for all platforms here: http://www.postgresql.org/download/