Ticket #402 (closed enhancement: fixed)

Opened 10 years ago

Last modified 7 years ago

Add centroids for photometry and astrometry to database schema

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 should add centroids for photometry and astrometry to the Source and DIASource tables:

  • x, y, ra, decl + errors for photometry
  • x, y, ra, decl + errors for astrometry

Also, "row" and "col" should be removed.

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

Change History

comment:1 Changed 10 years ago by jbecla

  • Summary changed from Add centroids for photometry and astriometry to database schema to Add centroids for photometry and astrometry to database schema

comment:2 Changed 10 years ago by TimAxelrod

  • Status changed from new to assigned

comment:3 Changed 10 years ago by TimAxelrod

I suggest three categories of positional measurement, to be named by appending these suffixes to x, y, ra, and decl:

_flux : the flux weighted position, calculated from the first moment of the pixel values within the FootPrint?.

_peak : the position of the pixel with the peak value in the FootPrint?

_astrom : the position measured for purposes of astrometry. The algorithm is TBD, but it could come from something akin to sextractor's "windowed" position.

Note that _flux and _astrom have associated errors, but _peak does not.

comment:4 Changed 10 years ago by TimAxelrod

  • Owner changed from Tim Axelrod to jbecla

comment:5 Changed 10 years ago by jbecla

Based on discussion at DataAccWG telecon 11/7/08, all of the above applies to DIASource, Source and Object tables.

comment:6 Changed 10 years ago by jbecla

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

Done in EA (schema version DC3-3.0.5)

comment:7 Changed 7 years ago by robyn

  • Milestone DC3b Apps DB Schema deleted

Milestone DC3b Apps DB Schema deleted

Note: See TracTickets for help on using tickets.