Skip to content

Example: Farmers Markets in the United States

Timothy Lebo edited this page Feb 14, 2012 · 26 revisions
csv2rdf4lod-automation is licensed under the [Apache License, Version 2.0](https://github.com/timrdf/csv2rdf4lod-automation/wiki/License)

See Examples.

tweets @difrad @alvarograves
tweet @alvarograves

What farmers markets are in Alabama? (results from http://logd.tw.rpi.edu/sparql):

PREFIX con:          <http://www.w3.org/2000/10/swap/pim/contact#>
PREFIX dcterms:      <http://purl.org/dc/terms/>
PREFIX owl:          <http://www.w3.org/2002/07/owl#>
PREFIX wgs:          <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX dbpedia:      <http://dbpedia.org/resource/> 
PREFIX conversion:   <http://purl.org/twc/vocab/conversion/>
PREFIX ds4383_vocab: <http://logd.tw.rpi.edu/source/data-gov/dataset/4383/vocab/>

SELECT *
WHERE {
  GRAPH <http://logd.tw.rpi.edu/source/data-gov/dataset/4383/version/2010-Oct-22> {
    ?market a ds4383_vocab:FarmersMarket .
    ?market dcterms:title ?title .
    ?market con:address   ?address .
    ?market wgs:lat       ?lat .
    ?market wgs:long      ?long .

    ?address a con:Address .
    ?address con:stateOrProvince [ owl:sameAs dbpedia:Alabama ] .
    ?address con:street ?street . 
    ?address con:city   ?city .
    ?address con:zip    ?zip .
  }
}

The enhanced layer 1 TTL dump file via csv2rdf4lod's enhancement parameters.

Provenance for the xsl, csv, and rdf.

Query the provenance to show how long it took to do this.

(still need to stitch this together)

2011-04-05 02:44:00 - 2011-04-05T02:22:48-04:00 = less than 22 minutes.

Publishing full dataset (with enhancement layer 1):

PREFIX dcterms:    <http://purl.org/dc/terms/>
PREFIX sd:         <http://www.w3.org/ns/sparql-service-description#>
PREFIX sioc:       <http://rdfs.org/sioc/ns#>
PREFIX pmlj:       <http://inference-web.org/2.0/pml-justification.owl#>
PREFIX hartigprov: <http://purl.org/net/provenance/ns#>
PREFIX conversion: <http://purl.org/twc/vocab/conversion/>
SELECT ?person ?when
WHERE {
  GRAPH <http://logd.tw.rpi.edu/source/data-gov/dataset/4383/version/2010-Oct-22> {
    [] pmlj:hasConclusion [ sd:name <http://logd.tw.rpi.edu/source/data-gov/dataset/4383/version/2010-Oct-22> ];
       pmlj:isConsequentOf ?infstep .
    OPTIONAL { ?infstep hartigprov:involvedActor ?user   }
    OPTIONAL { ?infstep dcterms:date             ?when   }
    OPTIONAL { ?user    sioc:account_of          ?person }
  }
} ORDER BY DESC(?when)

File retrieval:

<sourceUsage_d7c1aa8c-3162-4b7d-a76e-a39804ba5e85_content>
   a pmlp:SourceUsage;   
   pmlp:hasSource        <http://www.ams.usda.gov/AMSv1.0/getfile?dDocName=STELPRDC5087258>;
   pmlp:hasUsageDateTime "2011-04-05T02:22:48-04:00"^^xsd:dateTime;
.

<wasControlledBy_d7c1aa8c-3162-4b7d-a76e-a39804ba5e85_content>
   a oprov:WasControlledBy;
   oprov:cause  <http://tw.rpi.edu/web/inside/machine/sam#lebot>;
   oprov:effect <inferenceStep_d7c1aa8c-3162-4b7d-a76e-a39804ba5e85_content>;
   oprov:endTime "2011-04-05T02:22:48-04:00"^^xsd:dateTime;
Clone this wiki locally