Opendata Day Projects
From Opendataday
Here is a place to locate the apps/projects/visualizations that were started/completed or worked on during the Dec 4th Open Data Day.
Please give, your project name, an external link to the project, a link to the source code (if open), project status and next steps.
Bangalore, India
Project Name: Politicios Description: We created a website similar to openparliament.ca for Indian Parliament. We were able to scrape data of Member of Parliaments and their details from Government websites. Event hosted in : IIIT- Bangalore (www.iiitb.ac.in)
Youtube link : http://www.youtube.com/watch?v=-3hgEOwoQbA
Source code will be available on github.
For more info: https://sites.google.com/a/iiitb.net/opendayhackathon2010/
Bangkok, Thailand
Belém, Brasil
- We started to develop two projects:
- Deputados Analytics: Its a visualization about the congressman activities during 4 years, after the data extraction. Generating comparisons between congressmen - http://phppaidegua.wordpress.com/2010/12/04/thackday-projeto-deputados-analytics/ (@marcelioleal, @xl3onardo, @almeidamarcell, @luizleao, @cmbfilho)
- Linha Urbana: Its a project that extract public transport data from Belem and show where is good, where there are fails. - http://www.thackdaypa.org/forum-2/#/discussion/8/projeto-linhaurbana/ (@lucianosb, @rmauro, @brunouml)
Buenos Aires, Argentina
GarageLab hosted its 2nd Open Data hackathon on the ODHD. Some of the projects were:
- Visualization of budget execution for the National Government. Some code available: https://github.com/garagelab/presu
- "Elegi Legi": a game for finding the parliament member that best represents you
- Visualization and analysis of the presidential speeches. Examples here: http://www-958.ibm.com/software/data/cognos/manyeyes/users/ofwald
- A Usability study for a system for geolocating documents related to the ecologic issues on the Matanza-Riachuelo basin
Brasilia - Brasil
- We started to work with the data of the first Rest API for public data on Brazil that was published by Audit Court of the cities of Brazilian Ceara State (Tribunal de Contas dos Municipios do Estado do Ceará) with data covering cities revenues and expenses
- Parcial Graph (by @nitaibezerra @curado @brunot @cmoryah)
- Parcial map made with vis (by Augsuto Herrman)
São Paulo, Brasil
- We developed a manifest in favor of the Access to Information Law, and we are developing a website with information about the importance of this law, reports of successful cases of use of public data and following closely the approval process of the law. The monitoring should be extended to after sanctioned, observing the law enforcement. We are also working up the strategies of popular pressure, subscriptions, letters requesting commitment of senators, etc: [1]
- I have updated abrcrawl2 and generated the csv data of 2010 (February to early-December). Next steps: Now I'm cleaning the base and plan to release new version of the csv file with the data from the EXIF of the photos (I've copied all) on git soon. - Fczuardi 09:48, 9 December 2010 (EST)
- [update!] I've generated 2 videos from the 2010 pictures of this public images bank (all cc-by licensed):
Budapest, Hungary
We hacked a generic html to csv converter (ksh-scraper) for the hungarian national statistics office. (status: complete/beta) - lots of data awaiting to be liberated.
Charlotte, SC
Galway, Ireland
Some 17 people worked here in Galway:
- Richard did Galway City Planning on ScraperWiki and developed the Recent planning applications to Galway City Council app
- Jeremie and Jean-Paul did Dublin Bus schedule on ScraperWiki, see also Frequency and path of Dublin Bus from Dublin Bus Schedule
- Lorea, Jodi, Evangelos, Lukasz and Fadi worked on GDExpress, a bus schedule app for connections between Galway and Dublin. The data are on ie.ckan.net: citylink and gobus and Bus Eireann, the data in JSON is half-ready with an interface to search all the data.
- Tobias did multilingual terminology from Dutch government data: cpb.nl: ScraperWiki, GoogleDocs; slides
- Kevin, Lin, and Micah worked on scraping Ireland Arts Council funding information and visualizing it.
- Deirdre and Laura worked on ghost estates
- Myriam worked on linking fingal datasets about schools / leisure locations and roads with more accidents, in order to identify roads that more urgently need to become safer
- Michael and Gofran did an app: Galway Public Toilet Data Assistant (GPTD-Ass) (see also the underlying data: Galway Public Toilets Data (GPTD) and code).
Montreal, Canada
20 Developers got together in Montreal and pumped out some great apps.
- Patiner Montreal : http://www.patinermontreal.ca
- Resto-Net: http://www.resto-net.ca
- Municipal election results in machine readable format: http://www.openissues.ca/content/montreal-municipal-election-data
- A data catalogue for montreal data: http://www.datadotmontreal.ca
- A catalogue of Montreal Postal codes: http://devsoftweb.com/MontrealPostalCodes.txt
Full list, photos, videos and more here : http://montrealouvert.net/?p=444
New York, NY
Food+Tech Hackathon- For Full detail visit: http://foodhack.wikispaces.com/
- Garden Maps: An application and directory of resources for community gardens which also doubles as a searchable directory of community gardens for local residents.
- Milk Hack: Assessing Data Quality by using aggregate data to illustrate how the operating costs for milk producers vary regionally over time from 2006-2010.
- GROUPME.AT : Group Buying of Whole Animals From Farm To Table
- Scryve API Creating access to sustainability ratings for grocery products
- Wemakefood.com: An application and directory of resources for (small business, local food) producers which also doubles as a searchable directory of producers for consumers
- Community Supported Agriculture Tool: Helping you get a CSA started.
- Carrots 2 Carrots: Create a shopping list for your favorite grocery store, then we compare the cost to that of a nearby farmers market
- Cravin It: A service to help you find where you can find what you want to eat.
Ottawa, Canada
We put 50 citizens equipped with Sharpies around 30 feet of paper and put them on shuffle: every two minutes, we pushed everyone over to the left a few spots. Participants got to play, build on, and start new ideas every few minutes, taking advantage of everyone being in the same space.
Here’s a transcript of the 30 foot "speed idea dating" scroll, where ideas get down and dirty :)
Oxford, United Kingdom
- Robin Hood Tax Visualization - Demo site Exploring the impact of Robin Hood taxes - also Geodata Demo of RHT Data.
- Arts funding viz - Demo Site Tags demo site Stacks of cash demo site Using data about Arts Council funding, this team is visualizing where and to who the funding has been awarded.
- Twitter geo sentiment - Demo site Who is happy (or otherwise) on Twitter based upon where they are and comparing different locations.
- World Bank data - Using World Bank data so that someone can enter a location and find Word Bank projects or other projects if there is data for it, near them.
- Local transport - Tracking the location of Oxford buses using the data from Oxontime.
- dbpedia/Ordnance Survey Open Data - Demo site Using @gothwin's work for Ordnance survey and dbpedia to geolocate you with your postcode and finds something interesting nearby from dbpedia..."It makes Blue Plaques for you wherever you are"
- CKAN - Demo site Using the data.gov CKAN API to see the top 15 tags to see the relationships between the packages.
Portland, OR (2010)
- ScraperWiki for Oregon Registered Businesses by @selenamarie
- ScraperWiki for Chicago Inspected Restaurants by @maxogden
- ScraperWiki for Portland Cats up for adoption by @maxogden
- ScraperWiki for Portland Inspected Restaurants by @reidab
- ScraperWiki for http://plants.usda.gov by Thomas Burke
- CivicAPI: A free place to host open data for any city. In the planning stages by @maxogden
- CivicAPI DB for the National Registry of Historic Places by @wbruce and Mark Tabler. Scraper code at Github
- Elevation point data for the Portland area by @maxogden
- Fruit From Dirt - An attempt to port urban edibles data to location-aware apps Foursquare and Geoloqi @mathpunk
=== Oakland, CA (2011)
- 99ATMs.com: Fee-Free Credit Union ATM Finder by @maxogden and friends
Toronto, ON, Canada
Vancouver, BC, Canada
- Eatsure Vancouver (Github repository and a map of restaurants) worked on by @kumokasumi and @naoyamakino
- Election Finance visualization experiments (GitHub repo)
- Right now we are in the middle of scraping data from the Elections Canada website.
- Research on digitizing historical (analogue) maps and plans held at the City of Vancouver Archives so that they can be used in digital projects
- Visualizations of Vancouver's Business License data by @tylorsherman
- Two visualizations of Vancouver business license data: 1) Area neighbourhoods vs. total city take in business license fees and 2) Playing around with markers -- assigning markers to Parkades, Clubs, and Adult Entertainment by @rhiannoncoppin
Victoria, BC
We had over 30 attendees
- Eatsure Victoria (status: working demo)
- RideNow - crowd sourced transit stops/schedules application (status: semi-working prototype)
- OpenLegislature.ca - fork of openparliament.ca for provincial legislatures (status: instance running, data being compiled)
- Waterly.ca - (status: new watering jurisdictions KML files created to be added)
- Victoria instance of VanTrash (status: prototype)
- Rezoning Notifier - notifies residents of rezoning appications and displays on a map (status: data collected)
- MyRep - app that displays who represents you at every government level given a location (status: data partially collected)
- OpenDataBC Catalogue - completed list of BC public bodies for the catalogue (status: complete)
Winnipeg, Manitoba, Canada
- WinnipegElection.ca has released three datasets collected during the Winnipeg 2010 municipal election. Read our OpenData Day announcement: WinnipegElection.ca Open Data 2010
Helsinki, Finland
- The Open Day Hackathon in Helsinki was joined by 15 people and took place at the Forum Virium office. Organization was handled by Flo Apps Ltd. The participants represented multiple interest groups: local government, open data entrepreneurs, press, Capital region open data organizations and students. Presentations were given about the conversion of the aluesarjat.fi statistics into open data, a process that is ongoing and of which the first sets will be released shortly. The conversion was discussed from the viewpoints of the local government, the conversion team, the Helsinki Regional Infoshare team and the press. Additional presentations were given about the open data concerning Finnish elections.
- Main conclusions of the discussions were that:
* while Finland is a statistical wonderland (almost anything is available in statistics), these statistics are often poorly linked if at all * questions continue to be asked what (local) government information can be released as open data, taking privacy into account (can information about, for instance, minorities according to specific areas be released?). * Crime statistics are one of the few statistics poorly available in Finland * local and semi-governmental organizations should see the advantages of opening up data, rather then being obliged by the state to do so * similar to the above for NGOs: open data can provide additional transparency to their organizations * Data journalism is a rising trend, of which the organizations releasing data can benefit from - for instance through more accurate reporting * open data is still considered "scary" by many organizations due to the lack of knowledge about it - more needs to be done to inform about open data
- At the end of the day a 30 minute discussion and info sharing session was held with the Hackathon in Enschede, the Netherlands.
- Fotos:
http://www.flickr.com/photos/9184828@N06/sets/72157625401536537/
- Discussion (Finnish):
- Discussion Enschede (English)
Enschede, Netherlands
Good showing of people, and good mix of civil servants, entrepreneurs, students and other citizens. The city released 25 data sets for the event.
Two demo projects were build,
- A map of building permits, with clickthrough to underlying building plan drawings http://bouwplannen.heroku.com/
- A map of companies that filed for bankruptcy, searchable by postcode in the Netherlands, still to be matched with industrial zones to see if location is of relevance http://opendata.royvanderveen.nl/
