All Articles
-

Explainer: National Time Use Survey Data 2024
The National Time Use Survey (TUS) is a periodic survey conducted across the country by the National Statistics and Surveys Office (NSSO), Ministry of Statistics and Program Implementation (MoSPI), Government of India. The most recent… Continue reading
Posted in: Explainers -

State of Under Construction Road Works in Bengaluru – 2025
A week back, OpenCity conducted a survey to crowd-source all the under construction road projects in Bengaluru. The goal was to first see how many such projects are lying around in the city and then… Continue reading
Posted in: Analysis -

State of Groundwater Usage in Indian Cities in 2024
The “National Compilation of Dynamic Ground Water Resources of India” is an annual report published by the Central Ground Water Board under the Ministry of Jal Shakti, Government of India. The latest report, for 2024… Continue reading
Posted in: Analysis -

What data says about BESCOM’s line conversion plans
Since December 2020 BESCOM has been converting its overhead (OH) lines to underground (UG) in the case of high-tension (HT) lines, and to Aerial Bundles(AB) in the case of low-tension (LT) lines. The data available… Continue reading
Posted in: Analysis -

How to extract maps from pdfs
Many public departments put out maps in the form of pdfs instead of map file formats (kml/kmz, shapefiles or geojsons). These maps are usually generated with Autocad and you can see layers on the map… Continue reading
Posted in: Explainers -

What data says about the Ground water situation in India, Karnataka and Tamil Nadu
The Ministry of Jal Shakti, Government of India, recently published the report – National Compilation of Dynamic Ground Water Resources of India – 2022. This report details the state of groundwater extraction across India at… Continue reading
Posted in: Analysis -

What data says about BMTC’s performance
BMTC has put out its operational performance and other data in its annual reports till the year 2019-20. This is just short of the pandemic, so the data doesn’t reflect what the pandemic did to… Continue reading
Posted in: Analysis -

What does Bengaluru’s traffic violations data say?
In June 2019, the Government of India raised the penalties for traffic violations. This was a move that was considered to be pending, and was expected to make our roads a lot safer. Surely, steeper… Continue reading
Posted in: Analysis -

Understanding the BMTC bus stops and routes data
Recently three Bengaluru techies got together to map the BMTC bus stops information. The information they managed to map wasn’t just bus stops, but also bus accessibility and other details at the booth level. A… Continue reading
Posted in: Explainers -

Bangalore Floods – A Call for Open Data
A few days of rains in the first week of September and India’s IT capital, Bangalore, got the attention of the international media. The Wall Street Journal headline read – India’s Silicon Valley Flooded by… Continue reading
Posted in: Analysis -

How to use maps to visualise your data
Maps are useful to visualise data that is geographical in nature. For e.g. health parameters like Infant mortality rate or Maternal mortality rate given for all states of India can be better visualised as a… Continue reading
Posted in: Explainers -

What does the rainfall data from KSNDMC say about Bengaluru rainfall patterns?
The Karnataka State Natural Disaster Management Centre (KSNDMC) has deployed a large network of Automated Weather Stations(AWSes) across the state as well as in Bengaluru. There is a total of 180 AWSes deployed in different… Continue reading
Posted in: Analysis -

What does the NCRB traffic accidents data say?
The National Crime Records Bureau (NCRB) published its report for the year 2021. This report includes– Crime statistics across India– Accidents statistics across India. This includes road accidents, railway accidents and railway crossing accidents. –… Continue reading
Posted in: Analysis -

Making Sense of Data behind data
” MetaData absolutely tells you everything about somebody’s life. If you have enough metadata you don’t really need content…[It’s] sort of embarrassing how predictable we are as human beings.” – Stewart Baker As David Weinberger… Continue reading
Posted in: Analysis -

Ideas from diverse lenses: Facilitating an ideation workshop for OpenCity
“Nothing is more dangerous than an idea, when it’s the only one we have .” — Émile Chartier Just like in many areas of life, this famous quote by French philosopher Émile Chartier holds a… Continue reading
Posted in: Analysis
