Ticket #401 (closed enhancement: fixed)

Opened 10 years ago

Last modified 7 years ago

Decide what magnitudes are needed in database

Reported by: jbecla Owned by: jbecla
Priority: normal Milestone:
Component: dbSchema Keywords:
Cc: Blocked By:
Blocking: Project: LSST
Version Number:
How to repeat:

not applicable

Description

Based on discussion with Tim, we will need 2-3 additional psf-related magnitudes in Source and DIASource tables. Also, it would be useful to rename "mag", "apMag" and "psfMag".

Step 1: Tim should decide on names and provide description. Step 2: Jacek should make schema modifications in EA

Change History

comment:1 Changed 10 years ago by TimAxelrod

  • Status changed from new to assigned

comment:2 Changed 10 years ago by TimAxelrod

I think our needs are going to evolve rapidly over the next couple of years as we develop our photometry codes, especially for extended objects. So, I wonder if we should just have some number of magnitude columns, say mag1 - mag8, and store their definitions in our metadata tables.

If so, initial definitions for DC3:

mag1 - instrumental magnitude mag2 - instrumental magnitude corrected for non-gray extinction mag3 - instrumental magnitude corrected for both gray and non-gray extinction

comment:3 Changed 10 years ago by TimAxelrod

  • Owner changed from Tim Axelrod to jbecla

comment:4 Changed 10 years ago by jbecla

  • Owner changed from jbecla to Tim Axelrod

Based on discussion at DataAccWG telecon 11/7/08, we should use real names. Action item for Tim: propose the names.

comment:5 Changed 10 years ago by jbecla

  • Milestone changed from DC3b Apps DB Schema to DC3a Apps DB Schema

comment:6 Changed 10 years ago by Tim Axelrod

  • Owner changed from TimAxelrod to jbecla

Here are my suggestions for DC3a, though I think we will use only the first. All three will be used for DC3b, and we will want to supplement them with some additional columns:

InstMag? - instrumental magnitude NonGrayCorrMag? - instrumental magnitude corrected for non-gray extinction AtmCorrMag? - instrumental magnitude corrected for both gray and non-gray extinction

comment:7 Changed 10 years ago by jbecla

  • Status changed from assigned to closed
  • Resolution set to fixed

All done, in EA, svn, and schema browser.

comment:8 Changed 7 years ago by robyn

  • Milestone DC3a Apps DB Schema deleted

Milestone DC3a Apps DB Schema deleted

Note: See TracTickets for help on using tickets.