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

[Narock, Thomas]

Hi Lewis,

Sorry for the delayed feedback. Trying to catch up the last few weeks and just now getting a chance to dig into your work. Great job. This looks really interesting and I’m looking forward to playing with your code more and seeing where this goes.

Yesterday, the W3C Semantic Sensor Network group released some updates to their sensor ontology: http://w3c.github.io/sdw/ssn/  Might be interesting to see how/if this could be connected to describing drone data. There’s also the semantic GeoNames databases that you might connect to through the latitude and longitude values: http://www.geonames.org/  Just a couple of ideas that the group may want to look at in the future.

Tom


On Apr 13, 2017, at 1:28 PM, Mcgibbney, Lewis J (398M) via esip-semanticweb <esip-semanticweb at lists.esipfed.org<mailto:esip-semanticweb at lists.esipfed.org>> wrote:

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<mailto:lewis.j.mcgibbney at jpl.nasa.gov>

           <image001.png>

 Dare Mighty Things

From: Jane Wyngaard <jane at wyngaard.co.za<mailto: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<mailto:Lewis.J.Mcgibbney at jpl.nasa.gov>>
Cc: "esip-semanticweb at lists.esipfed.org<mailto:esip-semanticweb at lists.esipfed.org>" <esip-semanticweb at lists.esipfed.org<mailto:esip-semanticweb at lists.esipfed.org>>, "esip-drone at lists.esipfed.org<mailto:esip-drone at lists.esipfed.org>" <esip-drone at lists.esipfed.org<mailto: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>

           <image002.png>

 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

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.deltaforce.net/pipermail/esip-semanticweb/attachments/20170427/830d59b2/attachment-0001.html>