Schema for stored functions,
procedures, and ancillary
tables in the WFCAM Science Archive.
Contains sql script to create all stored functions and procedures.
based on: sp_HTML
Pure HTM functions (working off HTM table) V1 June 2002,
based on SkyServer design of Alex Szalay and Jim Gray;
Jim Gray's performance monitoring stuff from
SkyServer_MyTimeX
| 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. |
| 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. |
| fHtmLookupEq | Returns 20-deep HTMid of a given Equatorial point (@ra,@dec). |
| Latest Revision: | 5056, 2008-08-22 17:58:12 (Fri, 22 Aug 2008) |
|
|