inohilog

/var/log/inohiro

memo



select
geonames_features.layer_1 as c0,
time_instance.year as c1,
time_instance.month as c2,
time_instance.day as c3,
time_instance.hour as c4,
time_instance.min as c5,
sum(neo_observation_instance_h.value) as m0,
neo_observation_instance_h.subject as m1
from
geonames_features as geonames_features,
neo_observation_instance_h as neo_observation_instance_h,
time_instance as time_instance
where
neo_observation_instance_h.geonames = geonames_features.subject and
geonames_features.layer_1 = 'Earth' and
neo_observation_instance_h.time = time_instance.subject and
time_instance.year = '2011' and
time_instance.month = '3' and
time_instance.day = '15' and
time_instance.hour = '8' and
time_instance.min = '0'
group by
geonames_features.layer_1 ,
time_instance.year ,
time_instance.month ,
time_instance.day ,
time_instance.hour ,
time_instance.min;


'Earth', '2011', '3', '15', '8', '0', '0', '4.230999999999999', 'http://www.kanzaki.com/works/2011/stat/ra/20110315/p01/t17 '


@prefix rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns# .
@prefix ev: http://purl.org/net/c4dm/event.owl# .
@prefix scv: http://purl.org/net/scovo# .
@prefix vcard: http://www.w3.org/2006/vcard/ns# .
@prefix geo: http://www.w3.org/2003/01/geo/wgs84_pos# .
@prefix rdfs: http://www.w3.org/2000/01/rdf-schema# .
@prefix tl: http://purl.org/net/c4dm/timeline.owl# .

http://www.kanzaki.com/works/2011/stat/ra/20110315/p01/t17 rdf:value "0.028"^^http://purl.org/net/ns/measure#microsv ;
ev:place http://sws.geonames.org/2128293/ ;
ev:time http://www.kanzaki.com/works/2011/stat/dim/d/20110315t17pt1h ;
scv:dataset http://www.kanzaki.com/works/2011/stat/ra/set/moe .

http://sws.geonames.org/2128293/ vcard:region "北海道"@ja ,
"Hokkaido"@en ;
vcard:locality "札幌市"@ja ,
"Sapporo"@en ;
geo:lat "42.99383" ;
geo:long "141.24935" .

http://www.kanzaki.com/works/2011/stat/dim/d/20110315t17pt1h rdfs:label "2011-03-15T17" ;
tl:at "2011-03-15T17:00:00+09:00"^^http://www.w3.org/2001/xmlschema#datetime ;
tl:duration "PT1H"^^http://www.w3.org/2001/xmlschema#duration .