Jacek,
Yes it is definitely much richer, but doesn’t the baseline still contain ForcedSource.ccdVisitId? This is the same thing as scienceCcdExposureId (as far as I know).
Serge
On Feb 23, 2015, at 9:03 PM, Jacek Becla <[log in to unmask]> wrote:
> 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
########################################################################
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
