Matching SIMBAD stars with pi-stars :


1. go to page http://simbad.u-strasbg.fr/sim-fsam.pl and select interesting stars
    save results to html file and convert it to text file using command :
        html2text -nobs -width 1000 -ascii -o var.txt sim-sam.pl.html
2. run command :
       parse_simbad! var.txt > var_parsed.txt
3. generate sql file to be loaded :
       load_simbad_list.pl -type=4 -run=5 -file=var_parsed.txt   
   this command generates simbad_flare.sql file which can be loaded to database :
       nohup psql 2004_2005 -U pidb_user < simbad_flare.sql  > simbad_flare.out 2>&1 &
   next step is to much these InterestingObjects to pi-stars , special sql procedure was written for this purpose call :
       nohup psql 2004_2005 -U pidb_user -c "select MatchIoToPiStars(4,5,120)" > match.out 2>&1 &
4. Types, runs ( 2004_2005@heplx49 ) :

TYPE
DESCRIPTION
0
Fl* - Flare Star, io_run=1
1
Fl* - Flare Star, io_run=2 - nie bardzo pamietam czym sie rozni od run=1
2
Erruptive, io_run=3
4
RR Lyrea , io_run=5
5
Ro* - Rotationally variable Star , io_run=6
6
** - double or multiple stars , io_run=7
7
suspected of variability , io_run=8
8
erruptive( ER*) , io_run=9
9
all variables ( V* in simbad , star# = 112004) , io_run=10
with selection possibility ( simbad star types )
10
GCVS : nsv - list of stars suspected of variability ( old version )
11
GCVS : nsv - suplement list of star suspected of variability

5. Matching procedure function MatchIoToPiStars matches stars only using (ra,dec) coordinates and does not use magnitudes. I created some
nice plots showing that magnitude information can be used and limit should be 0.5-1.0 magnitude on :
             ABS( mag_pi - mag_simbad(visual) ) < 0.5
This can be derived from these plots ( 1, 2 ).