Ticket #10450 (closed enhancement: fixed)

Opened 3 months ago

Last modified 3 months ago

New view of Buzzard v1.6 Y1 small truth 0 a

Reported by: aguena@… Owned by: carlosadean
Priority: normal Milestone: no milestone
Component: Operation/DataManagement Severity: normal
Keywords: Cc:
Estimated Number of Hours: 0.0 Add Hours to Ticket: 0
Deviation?: yes Total Hours: 0

Description

A new view of the catalog has to be made, removing the objects with
-infinity values in the magnitudes.
It can have the same name and replace the current view of the Buzzard v1.6
Y1 small truth 0 a catalog.

(related to #10119)

--
Michel Aguena da Silva
Laboratório Interinstitucional de e-Astronomia: LIneA
E-mail: aguena@… <aguena@…>

Change History

comment:1 Changed 3 months ago by guilherme.soares

  • Owner changed from guilherme.soares to carlosadean
  • Status changed from new to assigned

comment:2 Changed 3 months ago by ldacosta@…

Isto e prioritario e urgente

Em 03/04/2018 09:55, LIneA Ticket System escreveu:

#10450: New view of Buzzard v1.6 Y1 small truth 0 a


Reporter: | Owner:

aguena@… | guilherme.soares

Type: task | Status: new

Priority: normal | Milestone: no milestone

Component: Other | Severity: normal

Estimated Number of Hours: 0 | Add Hours to Ticket: 0

Deviation?: 1 | Total Hours: 0


A new view of the catalog has to be made, removing the objects with
-infinity values in the magnitudes.
It can have the same name and replace the current view of the Buzzard v1.6
Y1 small truth 0 a catalog.

(related to #10119)

--
Michel Aguena da Silva
Laboratório Interinstitucional de e-Astronomia: LIneA
E-mail: aguena@… <aguena@…>

---
Este e-mail foi verificado quanto a vírus pelo AVG.
 http://www.avg.com

comment:3 Changed 3 months ago by carlosadean

  • Status changed from assigned to accepted
  • Component changed from Other to Operation/DataManagement

Michel,

Could you give me more info on how to remove those objects?

--
Carlos Adean

comment:4 Changed 3 months ago by aguena@…

The easiest way is to require that the magnitudes be positive.

On Tue, Apr 3, 2018, 11:40 AM LIneA Ticket System <ticket@…>
wrote:

#10450: New view of Buzzard v1.6 Y1 small truth 0 a


Reporter: | Owner: carlosadean

aguena@… | Status: accepted

Type: task | Milestone: no milestone

Priority: normal | Severity: normal

Component: | Keywords:

Operation/DataManagement? | Add Hours to Ticket: 0

Resolution: | Total Hours: 0

Estimated Number of Hours: 0.0 |

Deviation?: 1 |


Changes (by carlosadean):

Comment:

Michel,

Could you give me more info on how to remove those objects?

--
Carlos Adean

--
Ticket URL: <http://ticket.linea.gov.br/ticket/10450#comment:3>
linea <http://ticket.linea.gov.br>
Sistema de Ticket do LIneA

comment:5 Changed 3 months ago by carlosadean

  • Status changed from accepted to closed
  • Type changed from task to enhancement
  • Resolution set to fixed

Finalizei há pouco a nova versão da view e o que fizemos foi incluir na query a exclusão dos objetos cujas magnitudes contém valor nulo em algum filtro.

CREATE VIEW bcc_v1_6.buzzard_y1_small_truth_0_a_des AS
  (SELECT ID AS COADD_OBJECTS_ID,
          INDEX,
          ECATID,
          COEFFS_G,
          COEFFS_R,
          COEFFS_I,
          COEFFS_Z,
          COEFFS_Y,
          TMAG_G,
          TMAG_R,
          TMAG_I,
          TMAG_Z,
          TMAG_Y,
          OMAG_G AS MAG_AUTO_G,
          OMAG_R AS MAG_AUTO_R,
          OMAG_I AS MAG_AUTO_I,
          OMAG_Z AS MAG_AUTO_Z,
          OMAG_Y AS MAG_AUTO_Y,
          FLUX_G,
          FLUX_R,
          FLUX_I,
          FLUX_Z,
          FLUX_Y,
          IVAR_G,
          IVAR_R,
          IVAR_I,
          IVAR_Z,
          IVAR_Y,
          OMAGERR_G AS MAGERR_AUTO_G,
          OMAGERR_R AS MAGERR_AUTO_R,
          OMAGERR_I AS MAGERR_AUTO_I,
          OMAGERR_Z AS MAGERR_AUTO_Z,
          OMAGERR_Y AS MAGERR_AUTO_Y,
          AMAG_G,
          AMAG_R,
          AMAG_I,
          AMAG_Z,
          AMAG_Y,
          Z,
          HALOID,
          RHALO,
          M200,
          NGALS,
          R200,
          CENTRAL,
          TRA AS RA,
          TDEC AS DEC,
          TRA,
          TDEC,
          EPSILON_1,
          EPSILON_2,
          GAMMA1,
          GAMMA2,
          KAPPA,
          MU,
          MAG_R,
          SIZE1,
          PX,
          PY,
          PZ,
          VX,
          VY,
          VZ,
          TE_1,
          TE_2,
          TSIZE,
          LMAG_G,
          LMAG_R,
          LMAG_I,
          LMAG_Z,
          LMAG_Y,
          W,
          DIST8,
          SIGMA5,
          SIGMA5P,
          PDIST8,
          DELTAM
   FROM bcc_v1_6.buzzard_y1_small_truth_0_a
   WHERE id NOT IN
       (SELECT id
        FROM bcc_v1_6.buzzard_y1_small_truth_0_a
        WHERE omag_g IS NULL
          OR omag_r IS NULL
          OR omag_i IS NULL
          OR omag_z IS NULL
          OR omag_y IS NULL))
Note: See TracTickets for help on using tickets.