mapping.ttl 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. @prefix rr: <http://www.w3.org/ns/r2rml#> .
  2. @prefix odef: <http://adaptcentre.ie/ont/odef#> .
  3. @prefix csv: </Users/chrdebru/Desktop/workspace_local/generate-mapping/test/resources/fccweatherstationsp201108292221.csv#> .
  4. @prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
  5. <#TriplesMap> rr:logicalTable [ rr:sqlQuery "SELECT rownum() AS ROW_NUM, * FROM fccweatherstationsp201108292221;" ] ;
  6. rr:predicateObjectMap [ odef:label "LONG" ;
  7. odef:order "5"^^xsd:int ;
  8. rr:objectMap [ rr:column "LONG" ] ;
  9. rr:predicate csv:LONG
  10. ] ;
  11. rr:predicateObjectMap [ odef:label "LAT" ;
  12. odef:order "4"^^xsd:int ;
  13. rr:objectMap [ rr:column "LAT" ] ;
  14. rr:predicate csv:LAT
  15. ] ;
  16. rr:predicateObjectMap [ odef:label "Agency" ;
  17. odef:order "3"^^xsd:int ;
  18. rr:objectMap [ rr:column "AGENCY" ] ;
  19. rr:predicate csv:AGENCY
  20. ] ;
  21. rr:predicateObjectMap [ odef:label "Weather_Reading" ;
  22. odef:order "2"^^xsd:int ;
  23. rr:objectMap [ rr:column "WEATHER_READING" ] ;
  24. rr:predicate csv:WEATHER_READING
  25. ] ;
  26. rr:predicateObjectMap [ odef:label "Name" ;
  27. odef:order "1"^^xsd:int ;
  28. rr:objectMap [ rr:column "NAME" ] ;
  29. rr:predicate csv:NAME
  30. ] ;
  31. rr:predicateObjectMap [ rr:objectMap [ rr:column "ROW_NUM" ] ;
  32. rr:predicate csv:ROW_NUM
  33. ] ;
  34. rr:subjectMap [ rr:class odef:Record ;
  35. rr:template "http://www.example.org/record/{ROW_NUM}"
  36. ] .