Directors' blog

Links, thoughts and updates from the directors of Dim Sum Digital.

Archive for the ‘spreadsheet’ tag

Testing the new spreadsheet n0tice tool with Manchester toilets data

one comment

Picture: Phil W Shirley

As announced in the n0tice newsletter earlier this week, there’s a new feature available in the open journalism toolkit to help data journalists – the ability to easily map data contained in a spreadsheet.

Still in beta, it provides an opportunity to play around a bit and see how it might fit into the whole suite of geo-tagging related tools being developed.

Being one of those involved in the team developing this I wanted to get straight onto trying it out so I’ve created a very simple spreadsheet of the locations and opening times of Manchester’s city centre toilets. The data comes from the Data GM store. Creating the spreadsheet took the longest time, the set up and ingestion into the noticeboard probably 10 mins at most. Quick and dirty toilets mapping as it were!

You can see the items and click on items to get a map view here, http://atyourconvenience.n0tice.com but, as n0tice is primarily a mobile experience, the worth of this type of information is more obvious when viewed via the app where users will encounter the information in a serendipitous way due to their proximity to the location. (Alternatively a feed of the info from the api could create something in a different platform or publication.)

If you fancy giving the new spreadsheet feature a go, the instructions on how to get started are here: http://n0tice.org/2013/01/15/how-to-add-spreadsheet-data-to-a-noticeboard the apps to experience the content in your location are free and can be downloaded here.

Written by sarahhartley

January 18th, 2013 at 7:29 am