Using shp2geocouch to push OSM data into geocouch
Today I installed the utility shp2geocouch on Mac OS X 1.6. First I needed to update RubyGems… sudo gem update –system Then I could install shp2geocouch sudo gem install shp2geocouch Next I downloaded OSM data for Copenhagen, Denmark wget …
Installing spatial databases on EC2
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…
Good indian computer science videos on youtube
While browsing the web for for good videos to help me land a cool job at high profile tech firm, I came across this series from an Indian university. Lecture – 16 Disk Based Data Structures You should be…
How translate.google.com works
Actually, this is not about how translate.google.com works. It’s about loading HTML from a random URL, adding some extra Javascript and CSS and redisplaying the page on a different domain. A simple test page I’ve made a simple test web…
Building osm2pgsql on Mac OS X using homebrew
General instructions are here: 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: E.g. like this: $…
Using SQLite databases on different machines as a single virtual database
You can use separate SQLite database on different machines as a single virtual database by using the attach command in SQLite. I read about the technique here: For this example let’s use the simplest possible database. A contact database…
How to import OpenStreetMap data into PostgreSQL
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…
SOLR with JSONP with JQUERY
Update: The previous version of this howto was a bit unclear or even erroneous, and some people had problems getting it to work. I have now rewritten it and testet it with SOLR 3.5.0 and jQuery 1.7.1. Making SOLR return…
Google fusion tables cheat sheet
See below for commands using the Fusion Tables API. Example table is the oldschool message wall public table. Note that examples are shown first without the required url-encoding. Authenticating: Getting the auth token To authenticate you may use the following…