Serge

Thanks! I guess this DeepForcedSource table is much reacher
that our baseline ForcedSource table, so indeed it should
not be too bad for their tests, let's go with that.

Thanks,
Jacek


On 02/23/2015 08:53 PM, Serge Monkewitz wrote:

Jacek,

    A level 20 HTM ID is absolutely minuscule compared to a calibrated
exposure (IIRC it has less than one millionth of the area), so it’s not
surprising that the HTM level 20 ID of a few random sources don’t match
the level 20 HTM ID of any exposure center (which is what you get from
Science_Ccd_Exposure.htmId20). In fact, I wouldn’t be shocked if the
exposure centers didn’t have any level 20 ids in common with the deep
sources.

Anyway, if you really want to go from DeepSource to Science_Ccd_Exposure
without going through DeepForcedSource.scienceCcdExposureId, i.e. using
the position of the DeepSource, then the current way to do that with
MySQL is documented under the “Regions-containing-point queries” section
of the sciSQL docs at
http://lsst-web.ncsa.illinois.edu/schema/sciSQL_0.3/#s2.

Cheers,
Serge
On Feb 23, 2015, at 7:32 PM, Jacek Becla <[log in to unmask]
<mailto:[log in to unmask]>> wrote:

What am I missing...


select database();
+-----------------+
| database()      |
+-----------------+
| DC_W13_Stripe82 |
+-----------------+


select coord_htmid20  from RunDeepSource limit 10;
+---------------+
| coord_htmid20 |
+---------------+
| 8796093023391 |
| 8796093023493 |
| 8796093023546 |
| 8796093026041 |
| 8796093028951 |
| 8796093029067 |
| 8796093031362 |
| 8796093031362 |
| 8796093031362 |
| 8796093031362 |
+---------------+
10 rows in set (0.08 sec)

select run,camcol FROM Science_Ccd_Exposure WHERE htmid20 in
(8796093023391,8796093023493,8796093023546,8796093026041,8796093028951,8796093029067,8796093031362);
Empty set (0.07 sec)


How do I go from RunDeepSource to exposure???

(I'm trying to figure it out for Tatiana / webserv tests for SUI)

Jacek

########################################################################
Use REPLY-ALL to reply to list

To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1

########################################################################
Use REPLY-ALL to reply to list

To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1