[esip-semantictech] [Esip-drone] Example Drone Data Available as RDF

[Mcgibbney, Lewis J (398M)]

Hi Jane,
I smartened up the entire project README’s
https://github.com/ESIPFed/ESIPDroneClusterSoftware
I also added a section on Serializing the Sample CSV Data as RDF
https://github.com/ESIPFed/ESIPDroneClusterSoftware/blob/master/README.md#serializing-the-sample-csv-data-as-rdf
and finally, Querying the Turtle Drone Data
https://github.com/ESIPFed/ESIPDroneClusterSoftware/blob/master/README.md#querying-the-turtle-drone-data
Ping me if you want to discuss further.
Thanks, have a great weekend.
Lewis

Dr. Lewis John McGibbney Ph.D., B.Sc.
Data Scientist II
Computer Science for Data Intensive Applications Group 398M
Jet Propulsion Laboratory
California Institute of Technology
4800 Oak Grove Drive
Pasadena, California 91109-8099
Mail Stop : 158-256C
Tel:  (+1) (818)-393-7402
Cell: (+1) (626)-487-3476
Fax:  (+1) (818)-393-1190
Email: lewis.j.mcgibbney at jpl.nasa.gov

           [cid:image001.png at 01D2B440.AC5405E0]

 Dare Mighty Things

From: Jane Wyngaard <jane at wyngaard.co.za>
Date: Thursday, April 13, 2017 at 7:42 AM
To: "Mcgibbney, Lewis J (398M)" <Lewis.J.Mcgibbney at jpl.nasa.gov>
Cc: "esip-semanticweb at lists.esipfed.org" <esip-semanticweb at lists.esipfed.org>, "esip-drone at lists.esipfed.org" <esip-drone at lists.esipfed.org>
Subject: Re: [Esip-drone] Example Drone Data Available as RDF

Lewis that's very cool, thanks!  Any chance of a readme, and/or I would like to learn how you got to the Turtle manifest!?
I also did not know about ESIP COR  - what is that, are they hosting data or did you just push ours in temporarily/?

Funny enough someone just asked me for exactly this kind of pipeline but for water quality rather than drone data.  I'll try replicate this weekend but maybe we could chat early next week?
Also, for what it's worth - we're currently thinking those CSVs should really be NetCDFs - interested to know your thoughts on that?

j

On 12 April 2017 at 20:00, Mcgibbney, Lewis J (398M) via Esip-drone <esip-drone at lists.esipfed.org<mailto:esip-drone at lists.esipfed.org>> wrote:
Hi Folks,
Andrea and Jane pointed me towards some example Drone data [0] which I started playing around with yesterday.
I converted the CSV CO2Meter profile logs (generated by the drone) to Turtle [1] using the Apache Any23 CSV extraction algorithm [2] and made it available in the ESIP COR [3]. This allows simple SPARQL [4] queries to be made using the GUI [5].
The simple sample query below gives us the first ten results from the dataset which have CO2 Concentrations (parts-per-million) of greater than 500 ppm

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#<http://www.w3.org/1999/02/22-rdf-syntax-ns>>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#<http://www.w3.org/2000/01/rdf-schema>>
PREFIX morning1: <file:/usr/local/ESIPDroneClusterSoftware/example/morning1.csv>
SELECT * WHERE {
  ?sub morning1:Co2Ppm ?value .
  FILTER (?value > 500) .
}
LIMIT 10

If anyone would like to learn how I created the Turtle manifestation of the CSV data then let me know and I can detail.
Lewis

[0] https://github.com/ESIPFed/ESIPDroneClusterSoftware/tree/master/example
[1] https://www.w3.org/TeamSubmission/turtle/
[2] http://any23.apache.org/dev-csv-extractor.html
[3] http://cor.esipfed.org/ont/~lmcgibbn/morning1v2
[4] https://www.w3.org/TR/sparql11-query/
[5] http://cor.esipfed.org/ont/sparql


Dr. Lewis John McGibbney Ph.D., B.Sc.
Data Scientist II
Computer Science for Data Intensive Applications Group 398M
Jet Propulsion Laboratory
California Institute of Technology
4800 Oak Grove Drive
Pasadena, California 91109-8099
Mail Stop : 158-256C
Tel:  (+1) (818)-393-7402<tel:+1%20818-393-7402>
Cell: (+1) (626)-487-3476<tel:+1%20626-487-3476>
Fax:  (+1) (818)-393-1190<tel:+1%20818-393-1190>
Email: lewis.j.mcgibbney at jpl.nasa.gov<mailto:lewis.j.mcgibbney at jpl.nasa.gov>

           [cid:image002.png at 01D2B440.AC5405E0]

 Dare Mighty Things

_______________________________________________
Esip-drone mailing list
Esip-drone at lists.esipfed.org<mailto:Esip-drone at lists.esipfed.org>
http://lists.deltaforce.net/mailman/listinfo/esip-drone

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.deltaforce.net/pipermail/esip-semanticweb/attachments/20170413/c5a5929a/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3425 bytes
Desc: image001.png
URL: <http://lists.deltaforce.net/pipermail/esip-semanticweb/attachments/20170413/c5a5929a/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 3426 bytes
Desc: image002.png
URL: <http://lists.deltaforce.net/pipermail/esip-semanticweb/attachments/20170413/c5a5929a/attachment-0003.png>