****************************************************************
インスタンストピックの問合せ
****************************************************************
----- すべてのトピック型のすべてのインスタンスを問合せ ---
instance-of($INSTANCE, $TOPIC)?
----- "塚" 型のすべてのインスタンスを問合せ ---
using psi1 for i"http://topicmaps-space.jp/psi/kuyo/"
instance-of($INSTANCE, psi1:tumulus)
order by $INSTANCE?
*************************************************************
関連を利用した問合せ
*************************************************************
----- 塚と写真の関係 ---
using psi1 for i"http://topicmaps-space.jp/psi/kuyo/"
psi1:take-photo($TUMULUS : psi1:photo-subject,
$PHOTO : psi1:taken-photo)
order by $TUMULUS, $PHOTO?
----- 市区町村ごとの塚の数 ---
using psi1 for i"http://topicmaps-space.jp/psi/kuyo/"
select $MUNICIPALITY, count($TUMULUS) from
psi1:locate-municipality($MUNICIPALITY : psi1:locating-municipality,
$TUMULUS : psi1:located-municipality)
order by $TUMULUS desc, $MUNICIPALITY?
----- 県ごとの塚の数 ---
using psi1 for i"http://topicmaps-space.jp/psi/kuyo/"
select $PREFECTURE, count($TUMULUS) from
psi1:locate-prefecture($PREFECTURE : psi1:locating-prefecture,
$TUMULUS : psi1:located-prefecture)
order by $TUMULUS desc, $PREFECTURE?
----- 対象ごとの塚の数 ---
using psi1 for i"http://topicmaps-space.jp/psi/kuyo/"
select $TARGET, count($TUMULUS) from
psi1:hold-a-mass($TARGET : psi1:targeting,
$TUMULUS : psi1:targeted)
order by $TUMULUS desc, $TARGET?
----- 建立年ごとの塚の数 (塚の数でsort) ---
using psi1 for i"http://topicmaps-space.jp/psi/kuyo/"
select $YEAR, count($TUMULUS) from
psi1:erect($YEAR : psi1:erecting-year,
$TUMULUS : psi1:erected-year-tumulus)
order by $TUMULUS desc, $YEAR?
----- 建立年ごとの塚の数 (建立年でsort) ---
using psi1 for i"http://topicmaps-space.jp/psi/kuyo/"
select $URI, $NAME, count($TUMULUS) from
psi1:erect($YEAR : psi1:erecting-year,
$TUMULUS : psi1:erected-year-tumulus),
subject-identifier($YEAR, $URI),
topic-name($YEAR, $TNAME),
scope($TNAME, psi1:en),
value($TNAME, $NAME)
order by $URI desc, $TUMULUS?
|