Re: UK Open Data data vignette

Tue, 04 Aug 2015 11:33:10 -0700 

On 8/4/15 12:09 PM, Hugh Glaser wrote:

Yeah, the Seme4 data ain't too good either :-)

Try Tom (Tom Heath <[email protected]>) 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

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

Reply via email to