Skip to content

conversion:delimits_object

Jump to bottom
timrdf edited this page Sep 29, 2011 · 27 revisions

See conversion:Enhancement.

Example

:dataset a void:Dataset;
conversion:base_uri           "http://logd.tw.rpi.edu"^^xsd:anyURI;
conversion:source_identifier  "epa-gov-mcmahon-ethan";
conversion:dataset_identifier "environmental-reports";
conversion:dataset_version    "2011-Jan-12";
conversion:conversion_process [
   a conversion:RawConversionProcess;
   conversion:enhancement_identifier "1";
   #conversion:subject_discriminator  "enviro-reports-and-indicators";
   conversion:interpret [
      conversion:symbol "";
      conversion:interpretation conversion:null;
   ];
   conversion:enhance [
      ov:csvRow 2;
      a conversion:HeaderRow;
   ];
   conversion:enhance [
      ov:csvCol         19;
      ov:csvHeader     "Environmental Indicator Scale";
      conversion:label "Environmental Indicator Scale";
      conversion:comment "";
      conversion:delimits_object ",\\s*";
      conversion:range  rdfs:Literal;
   ];

data:

http://logd.tw.rpi.edu/source/epa-gov-mcmahon-ethan/dataset/environmental-reports/enviro-reports-and-indicators/version/2011-Jan-12/ (not resolvable b/c this dataset is not published).

@prefix raw: <http://logd.tw.rpi.edu/source/epa-gov-mcmahon-ethan/dataset/environmental-reports/vocab/raw/> .
@prefix e1:  <http://logd.tw.rpi.edu/source/epa-gov-mcmahon-ethan/dataset/environmental-reports/vocab/enhancement/1/> .
     
environmental-reports-enviro-reports-and-indicators:report_206 
  dcterms:identifier "report_206" ;
  dcterms:isReferencedBy 
  <http://logd.tw.rpi.edu/source/epa-gov-mcmahon-ethan/dataset/environmental-reports/version/2011-Jan-12> ;
  a environmental-reports_vocab:Report , foaf:Document ;
  raw:environmental_indicator_scale "Municipality, County, State, Regional, Watershed" ;

becomes

environmental-reports-enviro-reports-and-indicators:report_206 
   dcterms:identifier "report_206" ;
   dcterms:isReferencedBy 
   <http://logd.tw.rpi.edu/source/epa-gov-mcmahon-ethan/dataset/environmental-reports/version/2011-Jan-12> ;
   a environmental-reports_vocab:Report , foaf:Document ;
   e1:environmental_indicator_scale "Municipality" , "County" , "State" , "Regional" , "Watershed";

Example - promoting delimited values to Resources

Input data:

"","normal","","http://a.twimg.stocktwits.com/p/233837225/1302189124/thumb.jpg","2011-05-16T04:18:27Z","Wow, 1 month ago I'd have been surprised to see $NKE my week's leader and $DD $DE and $CAT my greatest losers.","False","False","","233837225","2011-05-16T04:18:20Z","3796018","","","4656,4930,4940,6502","CAT,DD,DE,NKE"

One column of my dataset has cells which may contain multiple stock symbols such as "CAT,DD,DE,NKE", and during the conversion I'd like to promote each of these ticker symbol (separated by commas) as resources. Does the converter have such function?

The only change needed from the example above is to change the conversion:range:

           conversion:range  rdfs:Literal;

to:

          conversion:range  rdfs:Resource;

How many datasets use conversion:delimits_object?

two

prefix geonames:   <http://www.geonames.org/ontology#>
prefix conversion: <http://purl.org/twc/vocab/conversion/>

select ?dataset count(*) as ?count
where {
  graph <http://purl.org/twc/vocab/conversion/ConversionProcess> {
    ?dataset conversion:conversion_process [
      conversion:enhancement_identifier ?e;
      conversion:enhance [ 
        conversion:delimits_object ?delimiter
      ]
    ] 
  }
}
group by ?dataset ?e
order by ?count

See also

Clone this wiki locally