NAME: sc_region PURPOSE: Extract a region of a star catalog about some location. DESCRIPTION: Generates a temporary table in the database of stars that are in a region of the sky centered on the input coordinates. Also generates a new field tangsep in the table that is the distance in radians from the point specified by ra/dec to the object in the given record. CATEGORY: Database CALLING SEQUENCE: sc_region, db, ra, dec, radius, tmptbl INPUTS: db - handle to an open mysql ddatabase ra - ra of serach location (radians) dec - dec of serach location (radians) radius - maximum disance from ra/dec to look (radians) OPTIONAL INPUT PARAMETERS: KEYWORD INPUT PARAMETERS: MAG_MIN - faint limit of star magnitude to return (eg. 12.0) MAG_MAX - bright limit of star magnitude to return (eg. -3.0) SCLASS - Spectral classification, as a regexp (eg. [ab]0 for a0 and b0 class) default is to return all types. TBLNAME - Name of table to query in the DB, default='ppm_catalog' OUTPUTS: tmptbl - name of temporary table that was created KEYWORD OUTPUT PARAMETERS: COMMON BLOCKS: SIDE EFFECTS: RESTRICTIONS: PROCEDURE: Send 'DROP TABLE '+tmptbl+';' to mysql to close the table when you are done with it. The temporary table will disappear once the handle to the database is droped. MODIFICATION HISTORY: 2002/02/07, Writen by David Tucker 2002/02/19, DT, expanded to sc_region and sc_nearest 2014/02/18, MWB, fixed a long-standing problem with a small number of inputs