SourceLists/AssociateLists

• SourceList Class
  A SourceList is a DBObject,
  but all sources are stored in one table
  • Make SourceList from ScienceFrame (default)
    

    SL = SourceList( )
    SL.frame = ...  # some BaseFrame
    SL.make()
    SL.commit()
            

  • Make SourceList from (raw) FITS table
    

    SL = SourceList( pathname = ... )   # some sextractor output FITS file
    SL.make_sourcelist_from_catalog()
    SL.commit()
            

  • Need to access Columns and Rows
    

    SL = ( SourceList.SLID == 0 )[0]
    RA  = SL.sources.RA         # get list with all source R.A.'s
    DEC = SL.sources.DEC        # get list with all source Dec's
    ns = len(SL)                # number of sources in SourceList
    slast = SL.sources[-1]      # get all attributes of last source
            

• For fast ingesting, use sqlldr
• Coordinate Transformations

AssociateLists

• AssociateList class
  Simple Associations (i.e. simple pairing in SQL using a given distance)
  • Use Oracle
  • Use SLOAN's HTM code
  • Connecting htm-code with Oracle
  • Make AssociateList from two SourceLists:
    

    AL = AssociateList()
    AL.associate( search_distance=0.5, sourcelist1=5, sourcelist2=6 )
    AL.commit()
            

  • Retrieve the paired sources:
    

    AL = (AssociateList.ALID == 0)[0]
    np = AL.get_number_of_pairs()                   # return number of pairs
    ( ( SL1, S1 ), ( SL2, S2 ) ) = AL.get_pairs()   #