OData Web Service

OData is an open consistent method for querying data over the web. Viking volumes suppport a read-only OData 4.0 interface under the http://<Volume>/OData/ path.

For example, the RC1 OData service is available here:
http://websvc1.connectomes.utah.edu/RC1/OData/

The power of OData is allowing external clients to access annotations over the web. OData can export either JSON or ATOM formats. Below are examples of using OData.

Excel

To use OData from Excel begin by installing the free Power Query plugin from Microsoft. Import OData by using the Power Query tab this adds to Excel:

../_images/Excel2010_ODataImport1.jpg

Enter the OData URL into the prompt provided by Excel:

../_images/Excel2010_ODataImport2.jpg

This provides access to the raw annotation data from the database.

Python

It is also easy to access data from Python scripts. I have begun a connectome analysis package which uses the OData service from Python to run some common queries and build datastructures. I plan to polish the connectome analysis package when time permits and complete the documentation. Feel free to contact the Marc Lab if you need assistance sooner.

The connectome analysis package also contains unit tests and examples which are instructive for how to access OData from Python:

The jsonwebclient sub-package converts OData JSON responses into Python objects https://github.com/jamesra/py-connectome-analysis/tree/master/connectome_analysis/webclient

Unit tests which perform simple queries https://github.com/jamesra/py-connectome-analysis/blob/master/test/test_jsonwebclient/test_jsonwebclient.py

Exporting SWC files for use in NEURON using the large connectomics analysis package. https://github.com/jamesra/py-connectome-analysis/blob/master/examples/CreateSWC.py