Category Archives: Data Works

Nepal Geo coded Data Working Group Meeting

My friend Dustin Homer invited me on Nepal Geo Coded Data Working Group Meeting. I was outside the valley when i got invitation so i shorten my trip to visit there.

Date : 9 Feb 2014
Location : School of Art, Kathmandu University Hattiban Lalitpur

Dustin Homer was talking about the AID Management platform that was implemented with partnership of Minister of finance in Nepal. Now Nepal government has public facing portal to show the AID Data. He gave quick demonstration of system. In the system, 3 stakeholder who can input the data, MOF, Line Ministries and Development Partner where Line Ministry can entry the progress report. If anyone want to input the data, they can contact ministry of finance where they will validate it before publishing. Ministry of Finance has certain mechanism to ensure the data publishing in system.
Is there any way to give feedback from end user? Not public at all but the people can contact the related person of project or even they can contact the ministry of finance for further query.
Till now MOF has more focusing the government servants of different district to use this system.

Dr, Sagar gave the example how data are presenting best today and where should we start to think. He raised the point that we should focus community and local people after all they are going to put concern it. We have to bring it to people. the system should be also for non technical people, non geo expert people. Kathmandu University together with other Development Agencies and stakeholder are more likely to train students and researcher to how to use. Intregate data to our development course. First Civil society has to own this, In Nepal more than 200 INGO and more than 35000 NGOs are working locally, regionally and nationally

Intra KC from USAID Nepal provide a glimpses of some case study/ implementation and some example of Free software. what ever we do, our target is to identify the partner and maximizing the impact
How we work? We download preliminary data from AMP and start to make it GEO enabled, it took 6 months to complete it but now you can get all these data in 5 mins. Different tools we can use easily:
AMP itself
Google Earth
Fusion table sites.google.com/site/nepalaidmaps
QGIS Quantum GIS
arcgis.com

Bhuban Karki from IECCD / MOF said we are not doing lot but starting to do some. We started to revised foreign aid policy with changed circumstances. We are started to improve development coperate reports. We are starting to identify the district where donars are mostly involve and where poverty is high rated. We are also producing technical assistance book(aid which is not included in Red book), mapping the doners.
For future we can use geo coded information for long term national planning. this will also useful for regional planning. While allocating budget in our budget formulation practice we can use to identify the need.

Kathmandu Metropolitan in City Spending Data Party

Kathmandu Metropolitan is largest city of Nepal, Most of the ministries, administrative office, country governing body, legislative entity, security force are in this city. So it is obvious to have the Kathmandu metropolitan in the highest interest of nation. Because of it, every year government has allocated big amount of budget for functioning it, beside it metropolitan is also one of the high revenue collector. For the first time, Open Knowledge Foundation Nepal has worked on the spending of Kathmandu metropolitan, in City Spending Data Party on July 19-21.

The total budget for 2013/14 allocated in Kathmandu Metropolitan is 2630894000, which is 0.509% of total budget of nation. As compare with last year, it seems 18.79% increment in total. The city has planned to expend that amount in four titles:budget

  • पूँजीगत सम्पत्ति खर्च (capital ),
  • तलब, पारिश्रमिक, सुविधा खर्च (Salary and Facilities),
  • कार्यालय सञ्चालन खर्च(Office Running)and
  • पूर्वाधार सुधार तथा अन्य विकास खर्च (Infrastructure and Development)

which we can see in diagram Total Budget for 2071. We can see the big portion of budget(more than 75%) is planning to expend in पूर्वाधार सुधार तथा अन्य विकास खर्च (Infrastructure and Development).

If we compare this with last year, we can see significant rises in पूर्वाधार सुधार तथा अन्य विकास खर्च (Infrastructure and Development) and also the increment in the salary of employees.

compare

Lets analysis each component.

कार्यालय सञ्चालन खर्च(Office Running)
Kathmandu Metropolitan has estimating to expend 162483000 for this year in office running. Where this money will be used in service and training, बित्तिय खर्च, maintenance, publication, communication, rents, vehicle, goods and many more. Most of the budget is planning to expend in service and training and बित्तिय खर्च.

office

पूँजीगत सम्पत्ति खर्च

pujigat
Metropolitan has allocated 138235000, which is the least portion in total for physical infrastructure and public construction, environment management, development on tourism and culture heritage, social development, city development international relation and many more. As per diagram above we can see the largest amount is distributed for physical infrastructure and public construction and environment management where lowest cost is spending for special program and other administrative tasks.

तलब, पारिश्रमिक, सुविधा खर्च (Salary and Facilities):
It is obvious, the government has to arrange for salary and facility for people who work for governemnt to work for it. So diagram itself shows, government has to spend it’s huge money in salary and payment, it have to allocated money for permanent workers, employee’s retirement spending. The total amount of these three title consist more than rest of all.

salary

पूर्वाधार सुधार तथा अन्य विकास खर्च (Infrastructure and Development)
From few years, government has prioritize the city development, so it shows it self 75.3% of total budget of metropolitian is spending for existing infrastructure maintenance and development, which is 22.34% increment than last year budget.

purvadhar

Open Knowledge Foundation Nepal has organized 3 days program with the support of Smart Samaj, that provide all the resource for program. As per plan, we organized data party on july 19 and 20, where data wranglers and civic coders were working. And Finally july 21 was for the public, where we invited different people to show what we made in 2 days.

The source of data was in official website of Kathmandu metropolitan http://www.kathmandu.gov.np/pdf/f29a0integrated%20budget%207071.PDF , With in 2 days, we convert those data in csv: http://bhetus.com/budget_data/                        https://github.com/prakashneupane/openspendingkathmandu/tree/master/data
From those data we have push it in openspending.org :http://openspending.org/kathmandu_data

The challenges what we faced :

  • The data was in PDF
  • The language is in nepali, not in nepali unicode
  • Lack of technical idea of platform

So it really challenges for us to scrap all the data from pdf, once it scrapped out next problem was in font, which is not displaying in most of the computer,
We were expecting the technical support from other people, but due to the program in other place, we couldn’t got people to assist. So we couldn’t proper manage the data in openspending specially dimension mapping.

Check out Slides:



<!– magazine.image =http://np.okfn.org/files/2013/07/compare.png –>

 

 

Failed States Index of Nepal and South Asia

Today Someone shared the post regarding The 25 Most Failed States on Earth, I wonder what is the position of Nepal, who is the most success on Earth, Who is worst in South Asian Region and many other question. The Failed States Index is based on the twelve primary social, economic and political indicators of the CAST methodology, developed by The Fund for Peace:

politicalindicatorssocialindicatorseconomicindicators

 

This is my first data work, just trying to explore the story from it.

First Top 15 failed state index 2013

top15

This is the alert region countries list which are in worst situations. In top 15, Somalia is in top position and Guinea Bissau is in 15th

Most Success Country on World

least

 

Least score country is most success country. From above figure, We can see Finland is least score country it scores 18.0 …..

What is the status of Nepal?

nepal

 

It shows social indication has great impact on nepal, above chart shows Group Grievance which include pressure and measures to Discrimination, Powerless, Ethnic Violence, Communal Violence and others.

South Asian Region

south AsiaCompare nepal with maximumcomparing with minimum