| || |
Online BPL 2002 Census
|Microsoft platform /
MS-SQL Server 2000
National Informatics Centre, Rajasthan State Centre, & Departments of Rural Development & Panchayati Raj,
Government of Rajasthan
Census goes online
The BPL 2002 census was done to identify the rural families below poverty line. A door-to-door survey was done for over 92 lakh rural house holds and details of over 462 lakh people was collected along with their economic and social status. The database was been built at state level, and after analysis 17.36 lakh families were identified as BPL families.
According to the new guideline issued, the revision would be a continuous exercise so an application for online updation of BPL families was built. The main objectives of the project were, to carry out an online updation of BPL list for the state, maintain a centralised database of rural families in Rajasthan and the use of this data like for generation of ration cards, domicile certificates, BPL cards, health card for BPL Families and by other government departments.
The base data was gathered from the Rural Survey BPL Census – 2002. The NIC state unit along with 32 district units, extended technical support to the Rural Development department for data validation and collation work. The data was then used by district agencies of Rural Development department who leveraged the updation through this web application, which ensures proper authentication before enforcing changes in the master records. The application has been designed to generate logs for changes. It is possible to generate various statistical reports required by the user departments. This database is then used by the government to prepare ration cards, medical cards and job cards for NREGS.
The process involves merging the Access Database from districts to the central SQL Server Database using the SQL Data transformation services. There is extensive use of stored procedures for faster and secured access to SQL server data. The process uses triggers for maintaining a log of changes and the use AJAX Controls reduces the ‘response time’. The access to the process is role based.
The intended benefit of the project has been to reach a ‘cut-off’ i.e. poverty line. Getting it the distribution of 173.6 million families among various clusters of Panchayati Raj units has been done. The BPL lists were generated for each and every Panchayati Raj unit. This list acts as a baseline for extending benefits to rural households by various departments like Education, Medical and Health, Food and Civil Supplies, Social Welfare etc.
The application would be used as per the guidelines of Government of India, and updates would be done at regular interval. Since the data structure and coding schemes proposed by Ministry of Rural Development have been followed, the solution can be replicated in all states whereever the guidelines have been followed.