WSA_StoredProcsAndFuncs

Schema for stored functions,procedures, and ancillary tables in the WFCAM Science Archive.
Contains sql script to create all stored functions and procedures.
fDMS Convert declination in degrees to +dd:mm:ss.ss notation
fDMSbase Base function to convert declination in degrees to +dd:mm:ss.ss notation.
fGetNearbyObjEq Returns table of objects from @table within @r arcmins of an Equatorial point (@ra,@dec).
fGetNearestObjEq Returns table holding a record describing the closest object within @r arcminutes of (@ra,@dec).
fGetNearestObjIdEq Returns the objId of nearest @table object within @r arcmins.
fGreatCircleDist Returns float holding great circle distance between two points (ra1,dec1) & (ra2,dec2)
fHMS Convert right ascension in degrees to +hh:mm:ss.ss notation
fHMSbase Base function to convert right ascension in degrees to +hh:mm:ss.ss notation.
fHTM_Cover Returns a table of (HtmIdStart, HtmIdEnd) that covers the area.
fHtmLookupEq Returns 20-deep HTMid of a given Equatorial point (@ra,@dec).
Latest Revision: 2508 , 2006-07-06 12:24:33 +0100 (Thu, 06 Jul 2006)