On Saturday Feb 23 the City of Albany participated in the
A group of about 10 Open Data Enthusiasts gathered in a room
at the Science Library building of the State University of New York at Albany.
The event followed the open agenda of a hackathon.
- We started with scouting a variety of Open Data sites.
- We put some emphasis on data in RDF format available through SPARQL endpoints.
After scouting, participants dived into dataset of their particular interest.
Here are three examples of notable activities.
New York City has a system in place to track Graffiti locations, this information is crowdsourced via phone calls to the 311 number. If you are walking around New York City and see a Graffiti that you would prefer to be removed, you can call this number and enter the graffiti in that database. On the other hand, if you have an appreciation for the Art of Graffiti, or are interested in their use for social and political expression, then you also have right there a Tourist guide for places where you will find graffitis to see (that is, until the City removes them…).
DJ. Deo and Alex Jurkat went after this dataset, downloaded it and massaged it, and developed a web application to display the locations of graffiti in a map. Given that the dataset includes dates information, their Web application also provides a slider to see the times when the graffiti appeared, and when they were removed.
Here is the link to the web application deployment:
DJ put the source code in Github at the site of the SUNY-Albany College of Computing and Information
(under Apache 2.0 License).
Using the SPARQL endpoint of DBLP, performed searches for articles authored by a particular person.
For example, placing the following SPARQL query in DBLP:
|PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX akt: <http://www.aktors.org/ontology/portal#>
PREFIX akts: <http://www.aktors.org/ontology/support#>
SELECT DISTINCT ?paper ?title ?coauthorname WHERE
We get back the list of papers and coauthors of Professor Seth Chaiken.
Open Science Course Sprint
Popular culture couldn’t be missing from the event. Sharon Wolff worked on exploring
data from the Dr. Who series by using the SPARQL endpoint of the BBC.
For example, using the following SPARQL query:
|SELECT DISTINCT ?title WHERE
<http://www.bbc.co.uk/programmes/b006q2x0#programme> <http://purl.org/ontology/po/episode> ?o .
?o <http://purl.org/dc/elements/1.1/title> ?title .
We get back the list of episodes from the new Dr. Who series.
While this SPARQL query:
|SELECT DISTINCT ?r WHERE
<http://rdf.freebase.com/ns/guid.9202a8c04000641f8000000004fb2c3c> ?r ?e .
Will open to your the graph of the Classic Dr. Who series.
…this led to a discussion on the merits of the Dalek’s invasion planning strategies…
With activities happening in more than 100 Cities around the World,
The Open Data Day Hackathon was a true celebration of what can be achieved
when Data is made available in usable forms for all to access.