LISTSERV 16.5 - QSERV-L Archives

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.

On Feb 23, 2015, at 7:32 PM, Jacek Becla <[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