Exploring data from CKAN
Viewing tabular data
If structured data is uploaded or linked to CKAN as a .csv or Excel table, the DataStore loads it into a database, allowing Recline to give a powerful range of ways to view and process the data. Initially it is displayed as a table. The user can sort the data on particular columns, filter or facet by values, or hide columns entirely.
Recline can also show data on a graph, allowing you to choose the variables on the axes. If they exist in the same spreadsheet, you can also graph multiple variables on the y-axis.
Depending on the data, a bar chart may be more useful:
If the table has columns that Recline recognises as latitude and longitude, it can also show you the data points on a map, with mapping data from OpenStreetMap. The map can be panned (dragged) and zoomed, and selecting a data point displays all the field values for that point.
Every graph or map view has an ‘Embed’ button, enabling it to be included as a link in an external web page such as a blog. The embedded view will remember the variables, ranges, scale etc – so it will display just as you viewed it from CKAN.
CKAN’s previewing is not restricted to tabular data. For example, if a resource is a web page, it will preview the page. A new feature is the ability to preview image files.
All the new functionality is included in the recent CKAN 1.7 release. It’s also live on the DataHub, so feel free to have a play. As usual, requests and suggestions for improvements can be sent to the CKAN discussion e-mail list.