 |
 |
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