{"id":17563,"date":"2017-03-05T10:36:33","date_gmt":"2017-03-05T10:36:33","guid":{"rendered":"http:\/\/www.ch.imperial.ac.uk\/rzepa\/blog\/?p=17563"},"modified":"2017-03-10T11:04:52","modified_gmt":"2017-03-10T11:04:52","slug":"a-nice-example-of-open-data-in-london","status":"publish","type":"post","link":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563","title":{"rendered":"A nice example of open data (in London)."},"content":{"rendered":"
\n

Living in London, travelling using public transport <\/a>is often the best way to get around. Before setting out on a journey one checks the status of the network. Doing so today I came across this page:\u00a0our open data<\/a> from Transport for London.\u00a0<\/p>\n

    \n
  1. I learnt that by making TFL travel data openly available, some 11,000 developers (sic!) have registered for access, out of which some 600 travel apps have emerged.<\/li>\n
  2. The data is in XML, which makes it readily inter-operable.[1]<\/a><\/span><\/li>\n
  3. This encourages crowd-sourced innovation.<\/li>\n
  4. They have taken the trouble to produce an API<\/a> (application programmable interface) which allows rich access to the data and information about e.g.<\/em>\u00a0AccidentStats<\/a>, AirQuality<\/a>, BikePoint<\/a>, Journey<\/a>, Line<\/a>, Mode<\/a>, Occupancy<\/a>, Place<\/a>, Road<\/a>, Search<\/a>, StopPoint<\/a>Vehicle<\/a>.<\/li>\n<\/ol>\n

    Chemists could learn some lessons here! Of course, there are quite a few chemical databases with APIs that are examples of open data, but the “ESI” (electronic supporting information) sources which almost all published articles rely upon to disseminate data are clearly struggling to cope. Take for example this recent article[2]<\/a><\/span>, where much of the data has been dropped into the inevitable PDF “coffin<\/em>” and which is a breathtaking 907<\/strong> pages long. To give the authors their due, they also provide 20 CIF files which ARE good sources of data. Rarely commented on, but clearly missing from the information associated with this (indeed most) articles is the metadata<\/strong> about the data. Thus the metadata for these CIF files amounts to just\u00a0e.g.<\/em> 229<\/strong>. To find out the context, one has to scour the article (or the 907 pages of the ESI) to identify compound\u00a0229<\/strong> (I strongly suspect it’s a molecule\u00a0because of the implied semantics of the term, not because its been explicitly declared).\u00a0You will not find the metadata at e.g.\u00a0data.datacite.org<\/a> which is one open aggregator and global search engine based on deposited metadata.<\/p>\n

    I have commented elsewhere<\/a> on this blog that other types of data could also be enhanced in the manner that CIF crystallographic files represent. For example the Mpublish NMR project,\u2021<\/sup> examples of which are shown here<\/a>, and for which typical data AND\u00a0its metadata<\/a> can be seen at DOI:\u00a010.14469\/hpc\/1053<\/a>. I fancy that if this method had been adopted,[2]<\/a><\/span> those 907 pages might have shrunk somewhat, although of course not entirely. But my hope is that gradually the innovative chemistry community will find ways of exhuming\u00a0more and more data from the PDF coffin and in the process reducing the paginated lengths of the PDF-based ESI further, perchance eventually even to zero?<\/p>\n

    If you are yourself preparing an article and sweating over the ESI at this very moment, do please take a look at the Mpublish method and how perhaps it can help make your NMR data at least more useful to others.<\/p>\n

    \n

    \u2021<\/sup>I understand an article describing this project is in preparation. If you cannot wait, this recent application of the Mpublish project has some details.[3]<\/a><\/span><\/p>\n

    References<\/h2>\n
    1. P. Murray-Rust, and H.S. Rzepa, \"Chemical Markup, XML, and the Worldwide Web. 1. Basic Principles\", Journal of Chemical Information and Computer Sciences<\/i>, vol. 39, pp. 928-942, 1999. https:\/\/doi.org\/10.1021\/ci990052b<\/a>\n\n<\/li>\n
    2. J.M. Lopchuk, K. Fjelbye, Y. Kawamata, L.R. Malins, C. Pan, R. Gianatassio, J. Wang, L. Prieto, J. Bradow, T.A. Brandt, M.R. Collins, J. Elleraas, J. Ewanicki, W. Farrell, O.O. Fadeyi, G.M. Gallego, J.J. Mousseau, R. Oliver, N.W. Sach, J.K. Smith, J.E. Spangler, H. Zhu, J. Zhu, and P.S. Baran, \"Strain-Release Heteroatom Functionalization: Development, Scope, and Stereospecificity\", Journal of the American Chemical Society<\/i>, vol. 139, pp. 3209-3226, 2017. https:\/\/doi.org\/10.1021\/jacs.6b13229<\/a>\n\n<\/li>\n
    3. M.J. Harvey, A. McLean, and H.S. Rzepa, \"A metadata-driven approach to data repository design\", Journal of Cheminformatics<\/i>, vol. 9, 2017. https:\/\/doi.org\/10.1186\/s13321-017-0190-6<\/a>\n\n<\/li>\n<\/ol>\n\n<\/div> ","protected":false},"excerpt":{"rendered":"

      Living in London, travelling using public transport is often the best way to get around. Before setting out on a journey one checks the status of the network. Doing so today I came across this page:\u00a0our open data from Transport for London.\u00a0 I learnt that by making TFL travel data openly available, some 11,000 developers […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"activitypub_content_warning":"","activitypub_content_visibility":"","activitypub_max_image_attachments":5,"activitypub_interaction_policy_quote":"anyone","activitypub_status":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[2],"tags":[805,689,2001,2002,1995,1996,1991,860,1998,327,1994,1997,1222,1990,1405,1993,1992,2000,1999,124],"ppma_author":[2661],"class_list":["post-17563","post","type-post","status-publish","format-standard","hentry","category-chemical-it","tag-api","tag-chemical-databases","tag-city-london","tag-company-tfl","tag-government","tag-greater-london","tag-local-government-in-london","tag-london","tag-passenger-transportation-ground-sea-nec","tag-pdf","tag-public-transport","tag-route-planning-software","tag-search-engine","tag-sustainable-transport","tag-technologyinternet","tag-transport","tag-transport-for-london","tag-travel-apps","tag-travel-data","tag-xml"],"yoast_head":"\nA nice example of open data (in London). - Henry Rzepa's Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A nice example of open data (in London). - Henry Rzepa's Blog\" \/>\n<meta property=\"og:description\" content=\"Living in London, travelling using public transport is often the best way to get around. Before setting out on a journey one checks the status of the network. Doing so today I came across this page:\u00a0our open data from Transport for London.\u00a0 I learnt that by making TFL travel data openly available, some 11,000 developers […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563\" \/>\n<meta property=\"og:site_name\" content=\"Henry Rzepa's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-05T10:36:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-03-10T11:04:52+00:00\" \/>\n<meta name=\"author\" content=\"Henry Rzepa\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Henry Rzepa\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A nice example of open data (in London). - Henry Rzepa's Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563","og_locale":"en_GB","og_type":"article","og_title":"A nice example of open data (in London). - Henry Rzepa's Blog","og_description":"Living in London, travelling using public transport is often the best way to get around. Before setting out on a journey one checks the status of the network. Doing so today I came across this page:\u00a0our open data from Transport for London.\u00a0 I learnt that by making TFL travel data openly available, some 11,000 developers […]","og_url":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563","og_site_name":"Henry Rzepa's Blog","article_published_time":"2017-03-05T10:36:33+00:00","article_modified_time":"2017-03-10T11:04:52+00:00","author":"Henry Rzepa","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Henry Rzepa","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563#article","isPartOf":{"@id":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563"},"author":{"name":"Henry Rzepa","@id":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/#\/schema\/person\/2b40f7b9c872a4dc1547e040a11b6281"},"headline":"A nice example of open data (in London).","datePublished":"2017-03-05T10:36:33+00:00","dateModified":"2017-03-10T11:04:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563"},"wordCount":507,"commentCount":0,"keywords":["API","chemical databases","City: London","Company: TfL","Government","Greater London","Local government in London","London","Passenger Transportation Ground & Sea - NEC","PDF","Public transport","Route planning software","search engine","Sustainable transport","Technology\/Internet","Transport","Transport for London","travel apps","travel data","XML"],"articleSection":["Chemical IT"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563","url":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563","name":"A nice example of open data (in London). - Henry Rzepa's Blog","isPartOf":{"@id":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/#website"},"datePublished":"2017-03-05T10:36:33+00:00","dateModified":"2017-03-10T11:04:52+00:00","author":{"@id":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/#\/schema\/person\/2b40f7b9c872a4dc1547e040a11b6281"},"breadcrumb":{"@id":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17563#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog"},{"@type":"ListItem","position":2,"name":"A nice example of open data (in London)."}]},{"@type":"WebSite","@id":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/#website","url":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/","name":"Henry Rzepa's Blog","description":"Chemistry with a twist","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/#\/schema\/person\/2b40f7b9c872a4dc1547e040a11b6281","name":"Henry Rzepa","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/897b6740f7f599bca7942cdf7d7914af5988937ae0e3869ab09aebb87f26a731?s=96&d=blank&r=g370be3a7397865e4fd161aefeb0a5a85","url":"https:\/\/secure.gravatar.com\/avatar\/897b6740f7f599bca7942cdf7d7914af5988937ae0e3869ab09aebb87f26a731?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/897b6740f7f599bca7942cdf7d7914af5988937ae0e3869ab09aebb87f26a731?s=96&d=blank&r=g","caption":"Henry Rzepa"},"description":"Henry Rzepa is Emeritus Professor of Computational Chemistry at Imperial College London.","sameAs":["https:\/\/orcid.org\/0000-0002-8635-8390"],"url":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?author=1"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pDef7-4zh","jetpack-related-posts":[{"id":19799,"url":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=19799","url_meta":{"origin":17563,"position":0},"title":"FAIR Data in Amsterdam – FAIR data points.","author":"Henry Rzepa","date":"July 18, 2018","format":false,"excerpt":"FAIR is one of those acronyms that spreads rapidly, acquires a life of its own and can mean many things to different groups. A two-day event has just been held in Amsterdam to bring some of those groups from the chemical sciences together to better understand FAIR. Here I note\u2026","rel":"","context":"In "Interesting chemistry"","block_context":{"text":"Interesting chemistry","link":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?cat=4"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.ch.ic.ac.uk\/rzepa\/blog\/wp-content\/uploads\/2018\/07\/Gibbs-1024x351.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":15907,"url":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=15907","url_meta":{"origin":17563,"position":1},"title":"Global initiatives in research data management and discovery: searching metadata.","author":"Henry Rzepa","date":"March 7, 2016","format":false,"excerpt":"The upcoming ACS national meeting in San Diego has a CINF\u00a0(chemical information division) session entitled \"Global initiatives in research data management and discovery\". I have highlighted here just one slide from my contribution to this session, which addresses the discovery aspect of the session. Data, if you think about it,\u2026","rel":"","context":"In "Chemical IT"","block_context":{"text":"Chemical IT","link":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?cat=2"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":18465,"url":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=18465","url_meta":{"origin":17563,"position":2},"title":"FAIR Research data: Gravitational waves as an example from the astrophysics community.","author":"Henry Rzepa","date":"June 2, 2017","format":false,"excerpt":"In 2016, the world heard that gravitational waves had been detected and\u00a0now a third instance is reported.\u2021 Given that the data associated with these detections are perhaps amongst the most important instances in recent times, I thought I might take a peek at how it was managed. The original report\u2026","rel":"","context":"In "Chemical IT"","block_context":{"text":"Chemical IT","link":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?cat=2"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.ch.ic.ac.uk\/rzepa\/blog\/wp-content\/uploads\/2017\/06\/117-1024x584.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":14515,"url":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=14515","url_meta":{"origin":17563,"position":3},"title":"A tourist trip around London Overground with a chemical theme.","author":"Henry Rzepa","date":"August 29, 2015","format":false,"excerpt":"Most visitors to London use the famous underground trains\u00a0(the \"tube\") or a\u00a0double-decker bus to see the city (one can also use rivers and canals).\u00a0So I thought, during the tourism month of August, I would show you an alternative overground circumnavigation of the city using the metaphor of benzene. Benzene you\u2026","rel":"","context":"In "General"","block_context":{"text":"General","link":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?cat=1"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":20634,"url":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=20634","url_meta":{"origin":17563,"position":4},"title":"Questions about the (metadata) components of a scientific article.","author":"Henry Rzepa","date":"April 8, 2019","format":false,"excerpt":"The conventional procedures for reporting analysis or new results in science is to compose an \"article\", augment that perhaps with \"supporting information\" or \"SI\", submit to a journal which undertakes peer review, with revision as necessary for acceptance and finally publication. If errors in the original are later identified, a\u2026","rel":"","context":"In "Chemical IT"","block_context":{"text":"Chemical IT","link":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?cat=2"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":17376,"url":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?p=17376","url_meta":{"origin":17563,"position":5},"title":"Revisiting (and maintaining) a twenty year old web page. Mauveine: The First Industrial Organic Fine-Chemical.","author":"Henry Rzepa","date":"February 2, 2017","format":false,"excerpt":"Almost exactly 20 years ago, I started what can be regarded as the precursor to this blog. As part of a celebration of this anniversary, I revisited the page to see whether any of it had withstood the test of time. Here I recount what I discovered. The site itself\u2026","rel":"","context":"In "Chemical IT"","block_context":{"text":"Chemical IT","link":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/?cat=2"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.ch.ic.ac.uk\/rzepa\/blog\/wp-content\/uploads\/2017\/02\/038-1024x419.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":false,"authors":[{"term_id":2661,"user_id":1,"is_guest":0,"slug":"admin","display_name":"Henry Rzepa","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/897b6740f7f599bca7942cdf7d7914af5988937ae0e3869ab09aebb87f26a731?s=96&d=blank&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/index.php?rest_route=\/wp\/v2\/posts\/17563","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17563"}],"version-history":[{"count":6,"href":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/index.php?rest_route=\/wp\/v2\/posts\/17563\/revisions"}],"predecessor-version":[{"id":17575,"href":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/index.php?rest_route=\/wp\/v2\/posts\/17563\/revisions\/17575"}],"wp:attachment":[{"href":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17563"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.ch.ic.ac.uk\/rzepa\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fppma_author&post=17563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}