Hi

I'm trying to retrieve data from dr2.master using TAP through different methods (tapsh, topcat and aladin). Even the more simple query take a long time to answer. For example, this query:

SELECT * FROM dr2.master
WHERE CONTAINS(POINT('gal',glon,glat), BOX('gal', 287.0, -1.0, 0.5, 0.5)) = 1 AND (g_psf < 17)

Used more than 1.5 hs, getting about 5,000 sources. 

My plan is to ask in a large area, about 200 sq deg, but scaling the execution time, it will be infinite!

Please, help me!

All the best.

Rodolfo

Dear Rodolfo,

that table had not been indexed in the right way to support spatial queries in Galactic coordinates, but I'm building that index now. I'll post an update when that's ready.

Also, I found that the website's ADQL parser needed to have the coordinate system provided as 'GALACTIC' rather than 'gal', although I believe that the TAP service ignores the coordinate system altogether (and, importantly, doesn't automatically do a conversion if your POINT uses one system and your BOX uses another).

I'll post again soon.

Regards,

Christopher Onken

SkyMapper Team

Hi Rodolfo,

try again now. For your query, I get 3220 sources returned in less than 19 seconds.

Let us know if you have any further problems.

Regards,

Christopher Onken

SkyMapper Team