mapping.ttl 1.5 KB

1234567891011121314151617181920212223242526
  1. @prefix rr: <http://www.w3.org/ns/r2rml#> .
  2. @prefix odef: <http://adaptcentre.ie/ont/odef#> .
  3. @prefix csv: </Users/chrdebru/GITHUB/generate-mapping/test/resources/fccweatherstationsp201108292221.csv#> .
  4. <#TriplesMap> rr:logicalTable [ rr:sqlQuery "SELECT rownum() AS ROW_NUM, * FROM fccweatherstationsp201108292221;" ] ;
  5. rr:predicateObjectMap [ rr:objectMap [ rr:column "LONG" ] ;
  6. rr:predicate csv:LONG
  7. ] ;
  8. rr:predicateObjectMap [ rr:objectMap [ rr:column "LAT" ] ;
  9. rr:predicate csv:LAT
  10. ] ;
  11. rr:predicateObjectMap [ rr:objectMap [ rr:column "AGENCY" ] ;
  12. rr:predicate csv:AGENCY
  13. ] ;
  14. rr:predicateObjectMap [ rr:objectMap [ rr:column "WEATHER_READING" ] ;
  15. rr:predicate csv:WEATHER_READING
  16. ] ;
  17. rr:predicateObjectMap [ rr:objectMap [ rr:column "NAME" ] ;
  18. rr:predicate csv:NAME
  19. ] ;
  20. rr:predicateObjectMap [ rr:objectMap [ rr:column "ROW_NUM" ] ;
  21. rr:predicate csv:ROW_NUM
  22. ] ;
  23. rr:subjectMap [ rr:class odef:Record ;
  24. rr:template "http://www.example.org/record/{ROW_NUM}"
  25. ] .