Get the neighbors to a list of @ra,@dec pairs in #upload |
The procedure is used in conjunction with a list upload service, where the (ra,dec) coordinates of an object list are put into a temporary table #upload by the web interface. This table name is hardcoded in the procedure. It then returns a matchup table, containing the up_id and the SDSS objId. The result of this is then joined with the PhotoTag table, to return the attributes of the photometric objects. create table #x (id int,objID bigint) insert into #x EXEC spGetNeighborsAll 2.5 |
name | type | length | inout | pnum |
@r | float | 8 | input | 1 |