Re: SDSS in Guide and N Cyg 007

duble.stars Mar 20, 2007

Not a problem.

by the way, I managed to totally forget to allow for namelist 78, thus
wrongly predicted n cyg 2007's moniker, it's V2467 Cyg (I think, folk
can go away and check it for themselves, too trusting sometimes, folk
are ;) )

The thing's fading a bit rapidly, I hear, in which context, using
VizieR and CMC14, down to about r' mag 15.5 and positive J-Ks < 1,
good V can be found via

V = r' + 0.6(J-Ks) - 0.03

cmc14 carries 2mass photometry (J and Ks) as well as r'.

Of course if folk recorded their differential measures for utilising
with any eventual valid calibration, instead of running around trying
to fit numbers to everything and reckoning they've got it right just
coz they've got a computer and a bit of software that can add up, thus
leading to increased scatter when multitudinous offsets are merged
into a whole, well, etc, &c.

;)

That's why I only really take the BAAVSS fractional method, and that
part of the archiving of measures, seriously, btw.

Cheers

John

--- In guide-user@yahoogroups.com, "Roger Pickard" <rdp@...> wrote:
>
> Hi John,
> Apologies for not saying "thanks" earlier but I've now got the tdf
> working in a form that suits me (although it is a rather tedious
> process as you say).
> Trouble has been we had quite a few clear nights just as I fixed the
> tdf and then I was away for a few days.
> Anyway, thought I should inform you you're efforts have been
> appreciated. (Ditto the latest novae in Cyg).
> Cheers,
> Roger
>
> ----- Original Message -----
> From: "duble.stars" <duble.stars@...>
> To: <guide-user@yahoogroups.com>
> Sent: Friday, March 09, 2007 7:16 PM
> Subject: [guide-user] SDSS in Guide - the alternative route
> (pronounced root)
>
>
> >
> >
> > Hiya again Roger
> >
> > Evidently you'd like to plot SDSS stuff in Guide, and there is an
> > alternative way of doing it, but it's a bit mulish.
> >
> > Some data has to be processed a bit, and I do that with a little
> > qbasic proggie, however it can be done in Excel, and I vaguely
> > remember sending Mike Simonsen a minitutorial on how to do that some
> > ages ago.
> >
> > Basically Guide TDF commands of the following nature
> >
> > ~r 4 6 do this that,
> > ~b 8 10 and the other
> >
> > are of a syntax such that the first number is the _start_ column
> > number of a field of data on a line, and the second number is the
> > length of the field, the total number of columns, so for instance
> with
> > data of this nature
> >
> > object1 17.5 22.6994 5.6
> > object2 22.8 01.4255 1.0
> >
> > to display the second set of figures would mean writing
> >
> > ~b 9 4 %s\n
> >
> > ie display in Both help and more info the value (returned by the %s
> > symbol) shown starting at column 9 and of length 4 columns, then
> start
> > a new line (that's what the \n does).
> >
> > So ~b 9 4 %s\n would return 17.5 for object1, and 22.8 for
> object2.
> >
> > Anyway, back to da sdss.
> >
> >
> http://cas.sdss.org/dr5/en/tools/search/x_radial.asp?ra=RDEG&dec=DDEG&
> radius=9&entries=all&format=csv
> >
> > is the basic url for fetching SDSS data. RDEG is replaced by any
> > value in decimal degrees, as is DDEG, within the sdss coverage.
> >
> > So
> >
> >
> http://cas.sdss.org/dr5/en/tools/search/x_radial.asp?ra=120.4&dec=+37.
> 8&radius=9&entries=all&format=csv
> >
> > returns data centred on RA 120.4 degrees declination +37.8 degrees,
> > for a radius (&radius=) of 9 arcminutes in this instance.
> >
> > You type that into your browser, it all goes away to sdss, and after
> a
> > while your browser tells you that you have a file called
> >
> > results.csv
> >
> > to download.
> >
> > This is a comma delimited file, with the first line as a header line
> > telling what the columns are, you save that to disk and the load it
> > into excel.
> >
> > Now, here's the TDF that this will need converting for :-
> >
> > file SDSS.dat
> > title SDSS dr5
> > RA H 3 9
> > units0 -2 # RA 'hours' are really decimal degrees
> > de d 13 9
> > mag 37 6
> > text 94 13
> > ~c 1 1 SDSS dr5
> > ~c 1 0 0 unknown\n
> > ~c 1 0 1 cosmic ray\n
> > ~c 1 0 3 galaxy\n
> > ~c 1 0 4 ghost\n
> > ~c 1 0 6 star\n
> > ~r 3 9 RA 2000 %R\n
> > ~r 13 9 Dec2000 %D\n\n
> > ~b 23 6 u' %s
> > ~b 58 6 err %s\n
> > ~b 30 6 g' %s
> > ~b 65 6 err %s\n
> > ~b 37 6 r' %s
> > ~b 72 6 err %s\n
> > ~b 44 6 i' %s
> > ~b 79 6 err %s\n
> > ~b 51 6 z' %s
> > ~b 86 6 err %s\n
> > ~b 94 5 V %s B-V
> > ~b101 5 %s\n
> > ~r 1 1
> >
> \n^DATA//xhttp://cas.sdss.org/dr5/en/tools/explore/obj.asp?ra=%[3,9]&d
> ec=%[13,9]^\n
> >
> > epoch 2000
> > type 6
> > field 0.00 2.00
> > mag lim 60
> > shown 7
> > end
> >
> > (The line starting ~r 1 1 followed by another line starting
> \n^DATA
> > is all one line that'll have been wordwrapped, fix it so it starts
> >
> > ~r 1 1 \n^DATA//xhttp://cas.sdss. and carries on to the
> end).
> >
> > So, you have to convert the comma delimited file such that this sdss
> > tdf file will work with it.
> >
> > Load results.csv into excel and change it as per the TDF, ie the RA
> > has to start at column 3 and be 9 columns long. This is standard
> > excel column widening and shortening practice, you may need to
> change
> > the number of decimals displayed too.
> >
> > You may be able to use record macro for this, not sure, but if so,
> > then once you've done it once it's just a matter of invoking the
> macro
> > on future occasions.
> >
> > When it's all lined up properly to fit the TDF, save it as a .prn
> > file, ie space delimited.
> >
> > It's likely that a coupla columns from the input data need to be
> > deleted, as you only need stuff like the mag etc.
> >
> > The SDSSdr5.tdf data file is called sdss.dat and needs to live in
> the
> > guide directory, using a text editor you append the new .prn files
> to
> > the main sdss.dat file... ...yeah, I know, tedious.
> >
> > But it works, and after a while you'll have quite a few SDSS fields,
> > I'm guessing for CVs in your case, all there ready.
> >
> > Oh, I've missed a bit, the V and B-V entries are added by adding
> > columns in Excel using the formulae
> >
> > V = r' + 0.44*(g'-r') - 0.02
> >
> > good to about +/- 0.05 V
> >
> > and
> >
> > B-V = 1.04*(g'-r') + 0.19
> >
> > good to about +/- 0.1 B-V (which is a bit ropy actually, but just
> > about usable).
> >
> > However, as these are the last values in the tdf it does not matter
> if
> > they are not generated, if they aren't there they'll simply not be
> > displayed.
> >
> > Someone who knew what they were doing could likely compile a bit of
> C
> > or perl or something that'd take as input RA and Dec and radius, go
> to
> > sdss, fetch the comma delimited data, expand it out to space
> delimited
> > that fits the above tdf column discipline, and even autogenerate the
> > arithmetically derived V and B-V, and append it to the sdss.dat
> file.
> >
> > I kind of do that with qbasic, but that's archaic, and don't work
> all
> > that cleanly, needing a coupla stages (the data has to be converted
> > from unix to dos line ending protocol for a start else qbasic thinks
> > it's all just one very long line) and few folk know how to run dos
> off
> > their PCs nowadays, let alone have access to qbasic.
> >
> > It's mulish, but it works, until SDSS became available in VizieR
> > that's how I did it, and still do sometimes, because the above route
> > uses full SDSS data release 5, whereas VizieR has only just upgraded
> > to SDSS data release 4.
> >
> > Cheers
> >
> > John
> >
> > --- In guide-user@yahoogroups.com, "Roger Pickard" <rdp@> wrote:
> > >
> > > Hi John,
> > > Well thanks for your kind efforts but . . . .
> > > I run UCAC2 from the hard drive so don't even have the toolbar for
> it
> > > at all. But . . . . .
> > > It still doesn't work even with the new s come gsc22 .exe so it
> must
> > > be something Bill has done.
> > > Oh well, interesting exorcise and at least I've learnt a tiny bit
> more
> > > about these things.
> > > Cheers,
> > > Roger
> >
> >
> >
> >
> > ------------------------ Yahoo! Groups
> Sponsor --------------------~-->
> > Yahoo! Groups gets a make over. See the new email design.
> > http://us.click.yahoo.com/hOt0.A/lOaOAA/yQLSAA/1.XolB/TM
> > --------------------------------------------------------------------
> ~->
> >
> > To unsubscribe from this group, send an empty email to:
> > guide-user-unsubscribe@egroups.com
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>