Thejesh GN Blog

Love Bangalore 3

Introducing Bangalore Open Data Repository

Update: Bangalore Open Data Repository has a new home. Its called OpenBangalore.org. Please bookmark it, I have been collecting data about Bangalore for years. The collected data includes GIS, election, weather reports etc and were from different sources. I have been meaning to distribute it online for a while now. Two big reasons...

1

Securing your wordpress with self-signed SSL certificate

I have been wanting to do this for a long time now. At last thejeshgn.com is available through https. It’s mostly done for my own use than my readers. I wanted to protect the admin screen (basically wp-admin). Given that I use my own VPN on public wifi, it may seem less important....

SQLite – Open Format for Open Data 6

SQLite – Open Format for Open Data

I scraped Gujarat rainfall data recently. The end result was 6 lakh rows of structured data. I released the data as an SQLite file instead of say a bunch of CSV or excel files. It kind of surprised some of my friends. But I think it’s a great file format for releasing open...

Anil Kumble Circle – Time Lapse video 6

Anil Kumble Circle – Time Lapse video

BTIS.IN provides images from traffic cameras across Bangalore. I wrote a simple script to capture and store images from camera no 3 (Anil Kumble Circle). Code is very simple and is listed below. The camera AK circle is usually up from morning 6 to evening 7. I have about 1.3k valid pictures from...

Rajasthan Rainfall Data (1957 to 2011) 5

Rajasthan Rainfall Data (1957 to 2011)

The Rajashtan rainfall data was scraped as part of Scrapathon held in Bangalore 21st July 2011. Intially I used scraperwiki, but the huge amount of data made it to timeout all the time :) so I wrote a simple python script to do it. Data is in the SQLITE file data.sqlite, in a...