"작업노트"의 두 판 사이의 차이

aksphoto
이동: 둘러보기, 검색
(태실)
 
(같은 사용자의 중간 판 18개는 보이지 않습니다)
1번째 줄: 1번째 줄:
== 2020.10.19 중간보고 준비 ==
+
== 2020.11.15 업데이트 ==
* relation list
+
===태실===
<pre>
+
*[[경기전_예종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=경기전_예종_태실)
select distinct c.sclass, c.tclass, c.relation from(
+
*[[경종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=경종_태실)
select source, b.class as sclass, target, d.class as tclass, relation
+
*[[단종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=단종_태실)
from jp10Links a
+
*[[명종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=명종_태실)
inner join jp10Data b on a.source=b.id
+
*[[문종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=문종_태실)
inner join jp10Data d on a.target=d.id) c
+
*[[서삼릉_태실_집안지]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=서삼릉_태실_집안지)
order by sclass,tclass
+
*[[선조_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=선조_태실)
</pre>
+
*[[성종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=성종_태실)
 +
*[[세조_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=세조_태실)
 +
*[[세종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=세종_태실)
 +
*[[숙종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=숙종_태실)
 +
*[[순조_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=순조_태실)
 +
*[[영조_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=영조_태실)
 +
*[[예종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=예종_태실)
 +
*[[인성대군_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=인성대군_태실)
 +
*[[정조_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=정조_태실)
 +
*[[태조_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=태조_태실)
 +
*[[화령옹주_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=화령옹주_태실)
 +
*[[하마비-경종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=하마비-경종_태실)
 +
*[[화령옹주_태실_석함]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=화령옹주_태실_석함)
 +
*[[예산_대흥_동헌_및_아문]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=예산_대흥_동헌_및_아문)
 +
*[[부여_오덕사]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=부여_오덕사)
 +
*[[예천_명봉사]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=예천_명봉사)
 +
*[[전주_경기전]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=전주_경기전)
 +
*[[광평대군_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=광평대군_태실)
 +
*[[금성대군_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=금성대군_태실)
 +
*[[밀성군_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=밀성군_태실)
 +
*[[사천_단종태실지]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=사천_단종태실지)
 +
*[[세종대왕자_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=세종대왕자_태실)
 +
*[[의창군_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=의창군_태실)
 +
*[[임영대군_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=임영대군_태실)
 +
*[[화의군_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=화의군_태실)
 +
*[[경종대왕태실비]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=경종대왕태실비)
 +
*[[대군춘령아기씨태실비-명종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=대군춘령아기씨태실비-명종_태실)
 +
*[[명봉사사적비]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=명봉사사적비)
 +
*[[문종대왕태실비]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=문종대왕태실비)
 +
*[[선조대왕태실비]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=선조대왕태실비)
 +
*[[성종대왕태실비]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=성종대왕태실비)
 +
*[[세종대왕태실비]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=세종대왕태실비)
 +
*[[아기씨태실비-정조_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=아기씨태실비-정조_태실)
 +
*[[예종대왕태실비]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=예종대왕태실비)
 +
*[[왕자아기씨태실비-영조_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=왕자아기씨태실비-영조_태실)
 +
*[[원자아기씨태실비-경종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=원자아기씨태실비-경종_태실)
 +
*[[원자아기씨태실비-숙종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=원자아기씨태실비-숙종_태실)
 +
*[[정종대왕태실비]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=정종대왕태실비)
 +
*[[주상전하태실비-숙종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=주상전하태실비-숙종_태실)
 +
*[[주상전하태실비-순조_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=주상전하태실비-순조_태실)
 +
*[[주상전하태실비-영조_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=주상전하태실비-영조_태실)
 +
*[[주상전하태실비1546-명종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=주상전하태실비1546-명종_태실)
 +
*[[주상전하태실비1711-명종_태실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=주상전하태실비1711-명종_태실)
 +
*[[태조대왕태실비]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=태조대왕태실비)
 +
*[[화령옹주태실비]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=화령옹주태실비)
  
* 지정문화재별 목록
+
===왕릉===
<pre>
+
*[[박석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=박석)
select b.*, a.label, a.partName
+
*[[앙부일구]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=앙부일구)
from jp10Data a
+
*[[월대]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=월대)
inner join jp10Links b on a.id = b.target
+
*[[잡상]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=잡상)
where a.groupName='국가문화유산포털'
+
*[[하마비]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=하마비)
</pre>
+
*[[간의]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=간의)
 +
*[[강]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=강)
 +
*[[곡장]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=곡장)
 +
*[[관천대]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=관천대)
 +
*[[규표]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=규표)
 +
*[[금천교]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=금천교)
 +
*[[기린석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=기린석)
 +
*[[낙타석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=낙타석)
 +
*[[난간석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=난간석)
 +
*[[동자석인]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=동자석인)
 +
*[[망료위]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=망료위)
 +
*[[망주석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=망주석)
 +
*[[묘표]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=묘표)
 +
*[[무석인]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=무석인)
 +
*[[문석인]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=문석인)
 +
*[[병풍석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=병풍석)
 +
*[[봉분]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=봉분)
 +
*[[비각]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=비각)
 +
*[[사자석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=사자석)
 +
*[[산신석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=산신석)
 +
*[[서계]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=서계)
 +
*[[석마]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=석마)
 +
*[[석상]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=석상)
 +
*[[석양]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=석양)
 +
*[[석호]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=석호)
 +
*[[소간의]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=소간의)
 +
*[[소전대]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=소전대)
 +
*[[수라간]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=수라간)
 +
*[[수복방]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=수복방)
 +
*[[수표]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=수표)
 +
*[[신교]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=신교)
 +
*[[신도비]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=신도비)
 +
*[[신로]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=신로)
 +
*[[십이지신상]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=십이지신상)
 +
*[[안향청]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=안향청)
 +
*[[어로계]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=어로계)
 +
*[[어정]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=어정)
 +
*[[예감]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=예감)
 +
*[[오리나무]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=오리나무)
 +
*[[일시정시의]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=일시정시의)
 +
*[[잉]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=잉)
 +
*[[자격루]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=자격루)
 +
*[[장명등]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=장명등)
 +
*[[재실]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=재실)
 +
*[[적도의]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=적도의)
 +
*[[정남일구]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=정남일구)
 +
*[[정려비]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=정려비)
 +
*[[정자각]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=정자각)
 +
*[[정중석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=정중석)
 +
*[[제기고]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=제기고)
 +
*[[족석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=족석)
 +
*[[천상열차분야지도]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=천상열차분야지도)
 +
*[[천평일구]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=천평일구)
 +
*[[측우기]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=측우기)
 +
*[[코끼리석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=코끼리석)
 +
*[[판위]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=판위)
 +
*[[표석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=표석)
 +
*[[풍기대]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=풍기대)
 +
*[[해태석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=해태석)
 +
*[[행랑채]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=행랑채)
 +
*[[향로계]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=향로계)
 +
*[[향로석]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=향로석)
 +
*[[향어로]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=향어로)
 +
*[[현주일구]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=현주일구)
 +
*[[혼상]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=혼상)
 +
*[[혼천의]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=혼천의)
 +
*[[홍살문]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=홍살문)
 +
*[[회양목]] (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=회양목)
  
* 사진1개에 여러 domain 연결된 경우
+
== 2020.11.09 업데이트 ==
<pre>
+
*[[동구릉]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=동구릉)
select c.target, count(c.target) from
+
*[[건원릉]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=건원릉)
(select *
+
*[[정자각-건원릉]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=정자각-건원릉)
from jp10Links a
+
*[[숭릉-崇陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=숭릉-崇陵)
inner join jp10Data b on a.target=b.id
+
*[[현릉-顯陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=현릉-顯陵)
where a.relation='hasPhoto') c
+
*[[목릉-穆陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=목릉-穆陵)
group by c.target
+
*[[경릉-景陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=경릉-景陵)
order by count(c.target) desc
+
*[[원릉-元陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=원릉-元陵)
</pre>
+
*[[수릉-綏陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=수릉-綏陵)
 +
*[[휘릉-徽陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=휘릉-徽陵)
 +
*[[혜릉-惠陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=혜릉-惠陵)
 +
*[[서오릉]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=서오릉)
 +
*[[창릉-昌陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=창릉-昌陵)
 +
*[[명릉-明陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=명릉-明陵)
 +
*[[익릉-翼陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=익릉-翼陵)
 +
*[[홍릉-弘陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=홍릉-弘陵)
 +
*[[경릉-敬陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=경릉-敬陵)
 +
*[[대빈묘]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=대빈묘)
 +
*[[순창원]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=순창원)
 +
*[[수경원]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=수경원)
 +
*[[서삼릉]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=서삼릉)
 +
*[[효릉-孝陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=효릉-孝陵)
 +
*[[소경원]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=소경원)
 +
*[[회묘-懷墓]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=회묘-懷墓)
 +
*[[희릉-禧陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=희릉-禧陵)
 +
*[[예릉-睿陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=예릉-睿陵)
 +
*[[후궁묘]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=후궁묘)
 +
*[[왕자_왕녀_묘]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=왕자_왕녀_묘)
 +
*[[효창원]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=효창원)
 +
*[[의령원]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=의령원)
 +
*[[영릉-寧陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=영릉-寧陵)
 +
*[[헌릉-獻陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=헌릉-獻陵)
 +
*[[영릉-英陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=영릉-英陵)
 +
*[[강릉-康陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=강릉-康陵)
 +
*[[건릉-健陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=건릉-健陵)
 +
*[[의릉-懿陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=의릉-懿陵)
 +
*[[선릉-宣陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=선릉-宣陵)
 +
*[[장릉-莊陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=장릉-莊陵)
 +
*[[광릉-光陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=광릉-光陵)
 +
*[[정릉-靖陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=정릉-靖陵)
 +
*[[온릉-溫陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=온릉-溫陵)
 +
*[[융릉-隆陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=융릉-隆陵)
 +
*[[순강원]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=순강원)
 +
*[[장릉-長陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=장릉-長陵)
 +
*[[유릉-裕陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=유릉-裕陵)
 +
*[[삼릉]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=삼릉)
 +
*[[순릉-順陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=순릉-順陵)
 +
*[[공릉-恭陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=공릉-恭陵)
 +
*[[영릉-永陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=영릉-永陵)
 +
*[[홍릉-洪陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=홍릉-洪陵)
 +
*[[의창군묘]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=의창군묘)
 +
*[[인릉-仁陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=인릉-仁陵)
 +
*[[사릉-思陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=사릉-思陵)
 +
*[[소령원]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=소령원)
 +
*[[광해군묘]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=광해군묘)
 +
*[[태릉-泰陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=태릉-泰陵)
 +
*[[정릉-貞陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=정릉-貞陵)
 +
*[[조선왕릉전시관]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=조선왕릉전시관)
 +
*[[장릉-章陵]]  (http://dh.aks.ac.kr/~sandbox/cgi-bin/Story02.py?db=aksphoto&project=jp11&key=장릉-章陵)
 +
 
 +
== 2020.10.21 중간보고 ==
 +
* [http://dh.aks.ac.kr/~aksphoto/index.htm 민족문화대백과사전  시맨틱 사진 아카이브]
 +
* 사진 파일 목록
 +
** [[사진 파일 목록 - 궁궐]]
 +
** [[사진 파일 목록 - 왕릉]]
 +
** [[사진 파일 목록 - 태실]]
 +
* 외부 참조자원 연계 정보 목록
 +
** [[참조자원 연계 정보 목록]]
 +
 
 +
=== 한국문화재 사진 시맨틱 아카이브 온톨로지 ===
 +
{{NetworkGraph | title=한국문화재_사진_시맨틱_아카이브_온톨로지.lst}}
  
 
== 2020.09.24 업데이트 ==
 
== 2020.09.24 업데이트 ==

2020년 11월 15일 (일) 19:36 기준 최신판

2020.11.15 업데이트

태실

왕릉

2020.11.09 업데이트

2020.10.21 중간보고

한국문화재 사진 시맨틱 아카이브 온톨로지


2020.09.24 업데이트

요약

  • 반영 Domain: 경복궁, 경희궁, 덕수궁, 창경궁, 종묘, 창덕궁
  • 업데이트 DB정보:
    • aksphoto.dbo.testData: Node 데이터. 3,285건.
    • aksphoto.dbo.testLink: Link 데이터. 3,300건.

네트워크 그래프

2020.09.15 업데이트

요약

  • 반영 Domain: 경복궁, 경희궁, 덕수궁, 창경궁, 종묘
    • 창덕궁은 Domain-Object 설정 작업중. 캡션 수정 작업은 완료되어 Node(testData) 데이터에 반영함.
  • 업데이트 DB정보:
    • aksphoto.dbo.testData: Node 데이터. 3,150건.
    • aksphoto.dbo.testLink: Link 데이터. 3,084건.
  • 사진 파일:
    • dh.aks.ac.kr/~aksphoto/thumb/: 썸네일 이미지. 네트워크 그래프의 iconUrl용.
    • dh.aks.ac.kr/~aksphoto/photo/: 원본 이미지. 파일명은 Photo(class)의 id 값으로 적용함.
    • 결과물에서 제외할 사진은 따로 선별하여 체크함. aksphoto.dbo.node_photo 의 사진선별 컬럼 참고. 그러나 현재 최종 데이터(testData)에는 사진선별 데이터 반영하지 않고 모든 사진 파일 입력함.
  • 적용한 id 규칙:
    • 공백은 언더바(_)로 처리.
    • 중복이 있을 경우 하이픈(-)으로 구분. 예) 풍기대-경복궁, 풍기대-창경궁.
    • Photo class의 id(사진ID):
      • 🇦_🇧_🇨 예) S01GBG_JDJ_00001
      • 🇦:
        • 주제별 사진의 경우:
          • subject코드+domain코드. 예) S01GBG: S01(궁궐), GBG(경복궁)
        • 지역별 사진의 경우:(아직 적용해보지 않음)
          • province코드+region코드. 예) R03GAPYEONG: R03(경기도), GAPYEONG(가평)
      • 🇧: 컬렉션코드. 예) JDJ: 장득진 기증 사진.
      • 🇨: 일련번호.


온톨로지

  • Class:
    • Heritage: 건조물, 유물, 비석, 식물 등.
    • Event: 재현행사. 예)종묘제례, 회례연.
    • Concept: 관직 등. 예)수문장.
    • Photo: 사진
    • WebResource: 웹 정보. 예)민백기사, 문화재청.
  • Relation:
    • hasPart: Heritage -> Heritage
    • hasPhoto: Heritage/Event/Concept -> Photo
    • hasWebResource: Heritage/Event/Concept -> WebResource
    • isRelatedTo: Heritage/Event/Concept -> Heritage/Event/Concept


네트워크 그래프