Re: UK Open Data data vignette

On 8/4/15 12:09 PM, Hugh Glaser wrote:
> Yeah, the Seme4 data ain't too good either :-)
>
> Try Tom (Tom Heath <tom.heath@theodi.org>) at the ODI.

Okay, Tom please take note.

In the meantime, I've cloned and published the original spreadsheet [1]. 
Naturally, I've also made a CSV dump then then used LOD Refine to knock 
up mappings [2], a project [3], and a Turtle doc [4], all of which I've 
published via Dropbox [5] (mounted to my person ODS-Briefcase) and 
slurped into URIBurner [6].

Here are some notes, using nanotation [7], that provide additional 
provenance while also using this post as a Linked Open Data source:

{
<>
    a foaf:Document, schema:WebPage ;
    rdfs:label "UK Open Data Vignette Discussion on LOD Mailing List" ;
    schema:about 
<https://docs.google.com/spreadsheets/d/15euLaQSgQfavuKisl2q7omRxsGtJQ4P4fiLVxz8ySuE/>, 

<http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/odi-company-directory-mappings.txt>,
<http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/ODI-Open-Data-Company-Directory.openrefine.tar>,
<http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/ODI-Open-Data-Company-Directory.ttl>,
<http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/>,
<http://linkeddata.uriburner.com/c/9DD72QAV> ;
    skos:related 
<https://docs.google.com/spreadsheets/d/1xwxNIaxXSEMLktb-oo1UoYTd5WMPFkRLytRVVBr5OMA>, 
<http://opendatacompanies.data.seme4.com> ;
    dcterms:created "2015-08-04"^^xsd:date ;
    schema:author 
<http://kingsley.idehen.net/dataspace/person/kidehen#this> .


<https://docs.google.com/spreadsheets/d/15euLaQSgQfavuKisl2q7omRxsGtJQ4P4fiLVxz8ySuE>
    a foaf:Document, schema:WebPage ;
    rdfs:label "Revised ODI Company Directory Spreadsheet (corrected 
OpenLink's entry)" .

<http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/odi-company-directory-mappings.txt>
    a foaf:Document, schema:WebPage;
    rdfs:label "LOD Refine RDF Skeleton (Mappings from Relational Tables 
to Relational Predicate Graphs)" .

<http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/ODI-Open-Data-Company-Directory.openrefine.tar>
    a foaf:Document ;
    rdfs:label "LOD Refine Project [TAR Archive]" .

<http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/ODI-Open-Data-Company-Directory.ttl> 

    a foaf:Document, schema:WebPage ;
    rdfs:label "Turtle Document Describing ODI Company Directory" ;
    rdfs:comment """Generated via LOD Refine using RDF Skeleton Mappings 
""";
    skos:related 
<http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/odi-company-directory-mappings.txt> 
.

<http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/>
    a ldp:BasicContainer, foaf:Document, sioc:Container, schema:WebPage ;
    rdfs:label "Dropbox Folder mounted to my ODS-Briefcase" ;
    rdfs:comment """Folder containing map of LOD Refine artifacts used 
to produce Turtle document. """ ;
    skos:related 
<http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/ODI-Open-Data-Company-Directory.ttl>, 
<http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/ODI-Open-Data-Company-Directory.openrefine.tar>,
<http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/odi-company-directory-mappings.txt> 
.

    <http://linkeddata.uriburner.com/c/9DD72QAV>
    a foaf:Document, schema:WebPage ;
    rdfs:label "5-Star Linked Data rendition of ODI Company Directory 
deployed via URIBurner" .
}


Links:

[1] 
https://docs.google.com/spreadsheets/d/15euLaQSgQfavuKisl2q7omRxsGtJQ4P4fiLVxz8ySuE 
-- Revised Spreadsheet (corrected OpenLink's entry)
[2] 
http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/odi-company-directory-mappings.txt
[3] 
http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/ODI-Open-Data-Company-Directory.openrefine.tar 
-- LOD Refine Project
[4] 
http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/ODI-Open-Data-Company-Directory.ttl 
-- use of hash based HTTP URIs for deployment
[5] 
http://kingsley.idehen.net/DAV/home/kidehen/Public/DropBox/Public/Linked%20Data%20Resources/LODRefine/ 
-- items 2-4 from Dropbox mounted to my ODS-Briefcase
[6] http://linkeddata.uriburner.com/c/9DD72QAV -- Linked Data rendition 
deployed via URIBurner
[7] http://kidehen.blogspot.com/2014/07/nanotation.html -- About 
Nanotation (embedding RDF statements wherever text is accepted, in a 
nutshell).

>
> On 04/08/2015 17:00, Kingsley Idehen wrote:
>> On 8/4/15 11:35 AM, Hugh Glaser wrote:
>>> The ODI (http://theodi.org) has published a research report, 
>>> "Research: Open data means business" 
>>> (http://theodi.org/open-data-means-business), along with a Google 
>>> sheet of Open Data Companies 
>>> (https://docs.google.com/spreadsheets/d/1xwxNIaxXSEMLktb-oo1UoYTd5WMPFkRLytRVVBr5OMA). 
>>>
>>>
>>> It seemed a nice idea to map the companies and make the data 
>>> accessible as 5 * Open Data at http://opendatacompanies.data.seme4.com
>>>
>>> So we have loaded the company data into a Linked Data store with a 
>>> SPARQL endpoint (http://opendatacompanies.data.seme4.com/sparql/), 
>>> and made the URIs resolve, such as 
>>> http://opendatacompanies.data.seme4.com/id/company/od001
>>>
>>> We have also used the UK postcodes (and OS services) to plot the 
>>> companies on a map: 
>>> http://opendatacompanies.data.seme4.com/services/map/
>>>
>>> There you go.
>>> This is all a little rough-and-ready, just to see what it looks 
>>> like, and see if anyone wants to use it. If you do, and want any 
>>> changes, please ask.
>>>
>>> Actually, if anyone wanted to produce a similar GSheet for other 
>>> places, we could suck that in too.
>>>
>>> Best
>>> Hugh
>>
>> Nice work!
>>
>> BTW -- how actually handles editing of the original spreadsheet? The 
>> information on OpenLink is really messed up. The ultimate 
>> demonstration of identity and identifiers gone very wrong. Half of 
>> the description is based on OpenLink Financials and the other half 
>> OpenLink Software :(
>>
>
>


-- 
Regards,

Kingsley Idehen 
Founder & CEO
OpenLink Software
Company Web: http://www.openlinksw.com
Personal Weblog 1: http://kidehen.blogspot.com
Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
Twitter Profile: https://twitter.com/kidehen
Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
LinkedIn Profile: http://www.linkedin.com/in/kidehen
Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this