![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
load_synonym_list make_existing_catalog load_csv_ent
@{ $Lfilelist{ "observation" } };
の縮小版となっている。
~/public_html/Tools$ ./clear_session.pl mysqlsump -u suda -p --all-databases -> saga_all20240924.sql
select * from abn_old as o left outer join abn_new as n on o.Entry = n.Entry and o.Object = n.Object and o.Quantity = n.Quantity where n.Entry is null order by o.Quantity;
> ./clean_log.pl > webalizer access_log_mod
saga-logo05p.pdf/home/suda/public_html/Log2/
%> webalizer [access_logファイル名]
/var/log/httpd/access_log
Position/create_position.pl
Position/bk_Position/
$SAGA_HOME/Data/starlist.html
/var/www/html/Data/starlist.html
$SAGA_HOME/[検索システム開発用ディレクトリ]/Data[_LG]/
$SAGA_HOME/Data[_LG]/
/var/www/html/Data/ /var/www/html/Data_LG/
$SAGA_HOME/Data/txt_table[2].tsv /var/www/html/Data/txt_table[2].tsv
/home/dbworker/public_html/Editor/CSVfile/check_position.pl
(1) /home/dbworker/public_html/Editor/CSVfile (2) /home/matsuno/public_html/Editor/CSVfile(1)はSAGAの最新版データで、(2)は松野君が入力したデータで
/home/dbworker/public_html/Editor/CSVfile_Matsunoに変更。
A0191 CD-45_1317 -> CD-45_13178 (2018/01/12) A0191 BD-40_1175 -> CD-40_11755 (2018/01/12) A0191 BD-65_253 -> CD-65_253 (2018/01/12) A0137 の25天体 BD-XXX -> CD_XXXX, BD-27_666 -> CPD -27_666 (2017/10/31) BD-35_360 BD-61_282 BD-68_74 BD-69_109 BD-60_545 BD-47_1087 BD-26_1453 BD-57_806 BD-65_253 BD-59_1024 BD-33_3337 BD-57_1633 BD-45_3283 BD-25_9024 BD-37_8363 BD-38_8457 BD-56_5169 BD-45_8786 BD-57_6303 BD-59_6824 BD-45_13178 BD-28_17381 BD-39_7674 BD-48_4818 BD-27_666 A0126 HDSAO134948 -> BD-01_1792 (2017/10/31) A0135 BD-80_328 -> CD-80_328 (2017/10/31) C0003 II47 -> IV47, II72 -> IV72 (2018/01/12)
HD113083[A,B] CS22876-032[A,B] CS22873-139[A,B] HD219617[A,B] G166-45[A,B] CS22949-008[a,b] HD106516[A] HD114710[A] HD115383[A] HD142860[A] HD170153[A] HD19373[A] HD208906[A] HD212029[A] HD219623[A] HD33632[A] HD34411[A] HD35296[A] HD59984[A] HD89125[A] HD91889[A] G95-57[B]
A0108 (Sivarani+06): 論文中Table 1にはJ2000と表記されているが、座標の値がSIMBADのものと大きくずれている。原因不明。 A0191 (Charbonnel+Primas05): VizieRのRA, Dec (degree)から採録していた。 A0259 (Gehren+06): J2000のデータがTable 1に与えられているが、SIMBADの値と少しずれている。 A0273 (Ishigaki+12): Table 3に座標データが与えられているが、J2000かどうかは不明。SIMBADの値と少しずれている。 C0011 (Venn+04): 座標データをどこから取得したのか不明。wiki、メール、Editorに記録が残っていない。採録担当者は山田さん。
select * from misc where Resolution is null and Facility is null;
mysql> update abundance_A09 set Object = REPLACE( Object, "SegII", "Seg2" ); Query OK, 89 rows affected (1.24 sec) Rows matched: 318149 Changed: 89 Warnings: 0
mysql> update atmosphere set Object = REPLACE( Object, "SegI", "Seg1" ); Query OK, 56 rows affected (0.18 sec) Rows matched: 47941 Changed: 56 Warnings: 0
mysql> update star_A09 set Population = REPLACE( Population, "SEGUEII", "SEGUE2" ); Query OK, 10 rows affected (0.02 sec) Rows matched: 17553 Changed: 10 Warnings: 0
https://blog.fedecarg.com/2009/02/22/mysql-split-string-function/
---------- [ 411] ---------- distance = 2.637, d( V ) = 0.109 B0001 UMiBel20103 150957.55 +670927.7 18.301E.N.Kirby+,ApJS, 191, 352, 2010 B0107 UMi20103 150958 +670928 18.41 E.N.Kirby+,AJ, 144, 168, 2012 ---------- [1267] ---------- distance = 1.115, d( V ) = 0.009 B0006 ET0107 024019.29 -343611.5 18.625 G.Battaglia+,, 459, 423, 2006 B0048 Fornax-805 024019.25 -343612.50 18.634 F.Pont+,AJ, 127, 840, 2004 ---------- [1282] ---------- distance = 1.026, d( V ) = 0.040 B0006 ET0126 024000.68 -343804.5 18.68 G.Battaglia+,, 459, 423, 2006 B0048 Fornax-816 024000.72 -343805.40 18.72 F.Pont+,AJ, 127, 840, 2004 ---------- [1318] ---------- distance = 2.836, d( V ) = 0.040 B0037 LG04a_001556 064217 -505555 17.82 A.Koch+,AJ, 135, 1580, 2008 B0102 Car-705 064217.3 -505555 17.78 K.A.Venn+,ApJ, 751, 102, 2012
[205] ## Not Identical ## # Same Entry, distance = 0.0000：【同一座標、同一論文】 Entry: B0057, Population: CANESVENATICI, Object: CVnI-123, V = --- arcsec = 0.0800106694299995 Entry: B0057, Population: CANESVENATICI Object: CVnI-179, V = --- arcsec = --- Entry Object RA Decl V Reference B0057 CVnI-123 132811.71 +333407.8 ---N.F.Martin+,MNRAS, 380, 281, 2007 B0057 CVnI-179 132811.71 +333407.8 ---N.F.Martin+,MNRAS, 380, 281, 2007 [213] ## Not Identical ## # Same Entry, distance = 0.0000：【同一座標、同一論文】 Entry: B0057, Population: CANESVENATICI, Object: CVnI-118, V = --- arcsec = 0.0800165394743684 Entry: B0057, Population: CANESVENATICI Object: CVnI-164, V = --- arcsec = --- Entry Object RA Decl V Reference B0057 CVnI-118 132734.95 +333430.6 ---N.F.Martin+,MNRAS, 380, 281, 2007 B0057 CVnI-164 132734.95 +333430.6 ---N.F.Martin+,MNRAS, 380, 281, 2007 [697] ## Not Identical ## # V mag is not available, distance = 2.385 > 1.000, distance = 2.3852 Entry: B0029, Population: SCULPTOR, Object: 162, V = --- arcsec = 0.0801067257127197 Entry: B0001, Population: SCULPTOR Object: Scl1010568, V = 17.967 arcsec = --- Entry Object RA Decl V Reference B0029 162 010002.4 -334020 ---E.N.Kirby+,ApJ, 705, 328, 2009 B0001 Scl1010568 010002.22 -334020.8 17.967E.N.Kirby+,ApJS, 191, 352, 2010 [1092] ## Not Identical ## # V mag is not available, distance = 2.427 > 1.000, distance = 2.4270 Entry: B0123, Population: FORNAX, Object: Fornax-61318, V = --- arcsec = 0.0807948127802151 Entry: B0001, Population: FORNAX Object: For61117, V = --- arcsec = --- Entry Object RA Decl V Reference B0123 Fornax-61318 023952.73 -342352.0 ---E.N.Kirby+,ApJ, 801, 125, 2015 B0001 For61117 023952.54 -342352.6 ---E.N.Kirby+,ApJS, 191, 352, 2010 [1098] ## Not Identical ## # V mag is not available, distance = 1.161 > 1.000, distance = 1.1610 Entry: B0009, Population: FORNAX, Object: BL081, V = --- arcsec = 0.0807997747971416 Entry: B0048, Population: FORNAX Object: Fornax-218, V = --- arcsec = --- Entry Object RA Decl V Reference B0009 BL081 023956.01 -342410.5 ---B.Letarte+,AAP, 523, A17, 2010 B0048 Fornax-218 023956.04 -342411.60 --- F.Pont+,AJ, 127, 840, 2004 [1154] ## Not Identical ## # V mag is not available, distance = 1.117 > 1.000, distance = 1.1174 Entry: B0048, Population: FORNAX, Object: Fornax-409, V = 18.882 arcsec = 0.0808713407352789 Entry: B0001, Population: FORNAX Object: For61505, V = --- arcsec = --- Entry Object RA Decl V Reference B0048 Fornax-409 023952.80 -342836.80 18.882 F.Pont+,AJ, 127, 840, 2004 B0001 For61505 023952.89 -342836.9 ---E.N.Kirby+,ApJS, 191, 352, 2010 [1269] ## Not Identical ## # V mag is not available, distance = 1.027 > 1.000, distance = 1.0266 Entry: B0123, Population: FORNAX, Object: Fornax-91907, V = --- arcsec = 0.080980439897913 Entry: B0048, Population: FORNAX Object: Fornax-803, V = 18.796 arcsec = --- Entry Object RA Decl V Reference B0123 Fornax-91907 024021.49 -343520.9 ---E.N.Kirby+,ApJ, 801, 125, 2015 B0048 Fornax-803 024021.45 -343521.80 18.796 F.Pont+,AJ, 127, 840, 2004 [1282] ## Not Identical ## # V mag is not available, distance = 1.100 > 1.000, distance = 1.1000 Entry: B0001, Population: FORNAX, Object: For74388, V = --- arcsec = 0.0809999420561094 Entry: B0048, Population: FORNAX Object: Fornax-812, V = 18.484 arcsec = --- Entry Object RA Decl V Reference B0001 For74388 024004.99 -343632.9 ---E.N.Kirby+,ApJS, 191, 352, 2010 B0048 Fornax-812 024004.99 -343634.00 18.484 F.Pont+,AJ, 127, 840, 2004 [1328] ## Not Identical ## # V mag is not available, distance = 1.045 > 1.000, distance = 1.0447 Entry: B0102, Population: Carina, Object: Car-524, V = 17.63 arcsec = 0.105599630417345 Entry: B0127, Population: Carina Object: Carina-Car25, V = --- arcsec = --- Entry Object RA Decl V Reference B0102 Car-524 064114.6 -505110 17.63 K.A.Venn+,ApJ, 751, 102, 2012 B0127 Carina-Car25 064114.71 -505110.08 ---M.Fabrizio+,AAP, 580, A18, 2015 [1331] ## Not Identical ## # |V(1) - V(2)| = 0.840 > 0.400 mag, distance = 0.3531 Entry: B0043, Population: Carina, Object: LG04a_001875, V = 18.9 arcsec = 0.105675921113339 Entry: B0065, Population: Carina Object: MKV0596, V = 18.06 arcsec = --- Entry Object RA Decl V Reference B0043 LG04a_001875 064118.01 -505311.19 18.9 A.Koch+,AJ, 131, 895, 2006 B0065 MKV0596 064118.04 -505311.40 18.06B.Lemasle+,AAP, 538, A100, 2012 [1333] ## Not Identical ## # V mag is not available, distance = 1.423 > 1.000, distance = 1.4230 Entry: B0102, Population: Carina, Object: Car-612, V = 17.82 arcsec = 0.1056909270686 Entry: B0127, Population: Carina Object: Carina-Car19, V = --- arcsec = --- Entry Object RA Decl V Reference B0102 Car-612 064058.6 -505335 17.82 K.A.Venn+,ApJ, 751, 102, 2012 B0127 Carina-Car19 064058.46 -505335.52 ---M.Fabrizio+,AAP, 580, A18, 2015
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-63053414-1', 'auto');
ga('send', 'pageview');
</script>mysql --enable-local-infile saga_debug -u suda -p < List_Object.sql
Number of data >= 20: 1374, >= 50: 758, >=100: 355
%> $SAGA_HOME/Registration_LG/rewrite_population_B0001.pl
%> mv $SAGA_HOME/Registration_LG/B0001_observation_rev.csv $SAGA_HOME/CSVfile_LG/B0001/B0001_observation.csv
%> $SAGA_HOME/Registration_LG/registration.pl
saga:/home/suda/public_html/Data_Mining/
Dear Barry,
I would like you to update the SAGA database by running the following commands on forum.
% mysql -u root -p < /home/html/saga/backup/bak120806_saga20120806.sql % mysql -u root -p < /home/html/saga/backup/bak101104_saga20101031.sql
% mysql -u root -p
mysql> grant select, insert, update, delete, create, drop, references, index, alter on `saga20101031`.* to suda@localhost;
mysql> grant select on `saga20101031`.* to saga_user@localhost; mysql> flush privileges;
Thank you very much in advance for your help.
Regards, Takuma
tar -xzvf dokuwiki-xxxx-xx-xx.tgz
/home/dbworker/public_html/tmp> unalias cp /home/dbworker/public_html/tmp> cp -rf dokuwiki-xxxx-xx-xx/* ../wiki/ 1. 新バージョンでは使われないファイルを削除する（下のリストを参照）。 2. 必要であれば、 パーミッション を変更する。data/ ディレクトリの下の index/ や tmp/ は比較的新しいので該当する可能性あり。
* {DOCUMENT_ROOT}/wiki/conf/ is not writable by DokuWiki. You need to fix the permission settings of this directory!
* {DOCUMENT_ROOT}/wiki/data is not writable by DokuWiki. You need to fix the permission settings of this directory!
* {DOCUMENT_ROOT}/wiki/data/pages is not writable by DokuWiki. You need to fix the permission settings of this directory!
* {DOCUMENT_ROOT}/wiki/data/attic is not writable by DokuWiki. You need to fix the permission settings of this directory!
* {DOCUMENT_ROOT}/wiki/data/media is not writable by DokuWiki. You need to fix the permission settings of this directory!
* {DOCUMENT_ROOT}/wiki/data/meta is not writable by DokuWiki. You need to fix the permission settings of this directory!
* {DOCUMENT_ROOT}/wiki/data/cache is not writable by DokuWiki. You need to fix the permission settings of this directory!
* {DOCUMENT_ROOT}/wiki/data/locks is not writable by DokuWiki. You need to fix the permission settings of this directory!
* {DOCUMENT_ROOT}/wiki/data/index is not writable by DokuWiki. You need to fix the permission settings of this directory!
* {DOCUMENT_ROOT}/wiki/data/tmp is not writable by DokuWiki. You need to fix the permission settings of this directory!
> cd /home/dbworker/public_html/wiki/ > chmod 777 conf > chmod 777 data > chmod 777 data/* > chmod 644 data/_dummy
3. 必要であれば .htaccess ファイルに変更を加える（ステップ 1 を参照）。 4. プラグインの新バージョンを入れる。
%> svnadmin create /home/dbworker/svn
%> su #> /usr/sbin/groupadd sagateam #> /usr/sbin/usermod -g sagateam suda usermod: sudaは /etc/passwd中に見付かりません !!! ユーザー情報は、astro1:/var/yp/src/passwdにある。
saga.sci.hokudai.ac.jp[106][Retrieval]% cvs up dbworker@astro3's password: ? Data_Axis2.pm ? Doxyfile ? Plot_Candidate.pm ? Query_Mode2.pm ? debug ? del_log ? doxygen ? images ? log ? tmp cvs update: Updating . cvs update: Updating css cvs update: failed to create lock directory for `/var/cvs/astrodb/Retrieval/css' (/var/cvs/astrodb/Retrieval/css/#cvs.lock): Permission denied cvs update: failed to obtain dir lock in repository `/var/cvs/astrodb/Retrieval/css' cvs [update aborted]: read lock failed - giving up dbworker@astro3's password: Permission denied, please try again. dbworker@astro3's password: ? javascript/query_list2.js cvs update: Updating javascript
2000 3389 2001 1329 2002 2837 2003 2056 2004 3185 2005 5339 2006 1482 2007 1357 2008 1234 2009 174
DBD::mysql::st execute failed: BLOB/TEXT column 'Author' used in key specification without a key length at list2sql.pl line 360, <SQL> line 9. DBD::mysql::st execute failed: Table 'saga.authors' doesn't exist at list2sql.pl line 360, <SQL> line 12.
http://www.jp.redhat.com/support/manuals/rhl-rg-ja-7.0/x7345.html http://fedorasrv.com/apache.shtml http://www.rfs.jp/sb/perl/08/07.html
http://simbad.u-strasbg.fr/simbad/sim-ref?bibcode=2008ApJ...678.1351A&simbo=on&submit=submit%20bibcode
> cd ~/public_html/DB/tmp/ > cvs checkout -D 11/23/08 CSVfile > mv CSVfile ../CSVfile_112308
> cd ~/public_html/DB/tmp/
> cvs checkout -D 11/23/08 Retrieval
> mv Retrieval ../Retrieval_112308
> cd Retrieval_112308/
> mv Query_Mode.pm Query_Mode20081123.pm
> mv Search_Mode.pm Search_Mode20081123.pm
> mv Temporary_Table.pm Temporary_Table20081123.pm
> vi db.cgi ("use Module;"部分を変更）> cd ~/public_html/DB/Registration/ > cvs update -r 1.23 list2sql.pl > cvs update -D 11/23/08 > cvs tag -b before20081123 > cvs updae -r before20081123
> ./regist.sh
cvs -d /var/cvs/astrodb/ export -D date_spec Retrieval
1 month ago
2 hours ago
400000 seconds ago
last year
last Monday
yesterday
a fortnight ago
3/31/92 10:00:07 PST
January 23, 1987 10:05pm
22:00 GMT異なる論文での同一天体の観測に対する系統誤差の比較
