All Articles

  • Explainer: National Time Use Survey Data 2024

    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:
  • State of Under Construction Road Works in Bengaluru – 2025

    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:
  • State of Groundwater Usage in Indian Cities in 2024

    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:
  • Datajam on Lakes in Bengaluru

    Datajam on Lakes in Bengaluru

    Bengaluru is known as a city of lakes. Where once there were more than a thousand lakes, we now have under three hundred lakes, which is still unique when compared to other cities in India.… Continue reading

    Posted in:
  • Analysing the Multi-Indicator Survey for Indian Cities

    Analysing the Multi-Indicator Survey for Indian Cities

    The 78th round Multi-Indicator Survey (MIS) was conducted in 2020 starting in January 2020. The survey was conducted by the National Sample Surveys Office (NSSO) under the Ministry of Statistics and Programme Implementation (MoSPI), Government… Continue reading

    Posted in:
  • Explainer: Resources for Maharashtra Assembly Elections 2024

    Explainer: Resources for Maharashtra Assembly Elections 2024

    As with the general elections in June 2024, we have been putting together a set of resources to help you vote in the upcoming assembly elections to the Maharashtra Assembly. Finding your constituency If you… Continue reading

    Posted in:
  • Explainer: How to view and interact with KML files

    Explainer: How to view and interact with KML files

    KML stands for Keyhole Markup Language and it is an XML based format for map files. These files contain map related data which can be divided into three types. They are: The map data stored… Continue reading

    Posted in:
  • Analysing DGCA Passenger Data for Major Indian Cities

    Analysing DGCA Passenger Data for Major Indian Cities

    The Directorate General of Civil Aviation under the Ministry of Civil Aviation, Government of India, is the main regulating and governing body for Civil Aviation in India primarily dealing with safety issues. It is responsible… Continue reading

    Posted in:
  • Urban Street Design: Fixing Iblur Junction – Oct 2024

    Urban Street Design: Fixing Iblur Junction – Oct 2024

    On Saturday, 5th October 2024, an innovative action workshop titled “Urban Street Design: Fixing Iblur Junction” was held in Bengaluru, aiming to address the infamous traffic bottleneck at Iblur Junction. Organised by Oorvani’s Civic Learning… Continue reading

    Posted in:
  • Datajam on Urban Heat in Chennai – September 2024

    Datajam on Urban Heat in Chennai – September 2024

    In 2024 Chennai has recorded close to 120 days of the temperature crossing 35°C. That is four of the nine months of the year so far! If the high relative humidity is also factored in,… Continue reading

    Posted in:
  • Analysing UDISE+ 2021-22 Data – Part 2: Teachers and Enrollment in Major Cities

    Analysing UDISE+ 2021-22 Data – Part 2: Teachers and Enrollment in Major Cities

    In an earlier post we looked at the state of facilities in government schools as compared to private and aided schools in seven major cities in India based on the UDISE+ data from 2021-22. In… Continue reading

    Posted in:
  • Analysing School Facilities in Major Cities from UDISE+ Data from 2021-22: Part 1

    Analysing School Facilities in Major Cities from UDISE+ Data from 2021-22: Part 1

    The Unified District Information System for Education Plus(UDISE+) is a database on schools at state and district level maintained by the Department of School Education and Literacy, Ministry of Education, Government of India. The database… Continue reading

    Posted in:
  • Household Consumption and Expenditure in the Metros – 2022

    Household Consumption and Expenditure in the Metros – 2022

    The Ministry of Statistics and Programme Implementation (MoSPI), Government of India, released the data from the Household Consumption and Expenditure Survey, 2022. The purpose of this survey is to analyse the consumption and expenditure trends… Continue reading

    Posted in:
  • An ESG-based Approach for Sustainable Cities Through Public-Private Partnerships and Investments

    An ESG-based Approach for Sustainable Cities Through Public-Private Partnerships and Investments

    Cities, which house almost 60% of the world’s population are also responsible for two-thirds of the world’s energy consumption, and consequently emissions. Further, increased urbanisation trends means that the role of cities in tackling environmental… Continue reading

    Posted in:
  • Explainer: Understanding the HCES 2022 for Cities Dataset

    Explainer: Understanding the HCES 2022 for Cities Dataset

    The Ministry of Statistics and Programme Implementation (MoSPI), Government of India, released the data from the Household Consumption and Expenditure Survey, 2022. While the website contains the summarised data, the raw data from the survey… Continue reading

    Posted in: