[open-government] Fw: (UN) Humanitarian Funding Data now available in XML

Wed Dec 22 16:59:04 UTC 2010

Thought this list might be interested in Andrej's post about opening up UN financial tracking data. 

Sj.

--- On Wed, 22/12/10, Andrej Verity <andrejverity at gmail.com> wrote:

From: Andrej Verity <andrejverity at gmail.com>
Subject: [CrisisMappers] Humanitarian Funding Data now available in XML
To: crisismappers at googlegroups.com
Date: Wednesday, 22 December, 2010, 14:03

Hello all,

Back in August, I asked the Crisis Mappers network help me find a way to pull data out of the Financial Tracking System (FTS - fts.unocha.org) in an automatic way to create dynamic charts.  The big challenge was how to get the data out --- FTS only provided PDF and XLS formats.  We eventually found a way to scrap the HTML page into a Google Doc and do some charting from there.

Before, during, and after my deployment to Pakistan, I was pushing the OCHA section, responsible for the FTS, to open up their data in a format that people could use.  A couple weeks ago, they launched the XML and RSS feeds on a staging environment. It is now available on their main site.

I believe that, with this data 'open', various entities should be able to do some very interesting things.  I am curious to see what comes out in the coming months.

If you have any feedback about the XML/RSS feeds, please let me know and I will feed that back to the the developer in a structured way.

Steps to reach to RSS feed page - 

Step 1 - click on the "Make a Custom Table" link - 

Step 2 - Create your query depending on the requirement - contribution or project based

Step 3 - Once the search results are shown, click on the "click here to login" link on the top of the search menu items   

Step 4 - After login SAVE the query and visit the " My financial page "   

Step 5 - Under financial page you will see the RSS feed and XML output link of the save query result. 

Cheers,

Andrej Verity
Information Management Officer
Information Services Section (ISS)
Communications and Information Services Branch (CISB)/OCHA
D-619, United Nations, Geneva

Email: verity at un.org
Skype: andrejverity         LinkedIn: andrejverity              Facebook: andrejverity          Twitter: andrejverity

http://ochaonline.un.org
http://www.reliefweb.int
http://www.irinnews.org

-- 
You received this message because you are subscribed to the Google Groups "CrisisMappers" group.
To post to this group, send email to crisismappers at googlegroups.com.
To unsubscribe from this group, send email to crisismappers+unsubscribe at googlegroups.com.
For more options, visit this group at http://groups.google.com/group/crisismappers?hl=en.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/open-government/attachments/20101222/0e139d19/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FTS1.JPG
Type: image/jpeg
Size: 10472 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/open-government/attachments/20101222/0e139d19/attachment.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FTS2.JPG
Type: image/jpeg
Size: 11330 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/open-government/attachments/20101222/0e139d19/attachment-0001.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FTS3.JPG
Type: image/jpeg
Size: 9972 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/open-government/attachments/20101222/0e139d19/attachment-0002.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FTS4.JPG
Type: image/jpeg
Size: 21389 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/open-government/attachments/20101222/0e139d19/attachment-0003.jpe>