ADQL example An SQL like string for ADQL might be as follows : Select a.* from Tab a where Region('Circle Cartesian 1.2 2.4 3.6 0.2') This would be represented in xml as follows <?xml version=""1.0"" encoding=""utf-16""?> <Select xmlns:xsd=""http://www.w3.org/2001/XMLSchema"" xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns=""http://www.ivoa.net/xml/ADQL/v0.7.4""> <SelectionList> <Item xsi:type=""columnReferenceType"" Table=""a"" Name=""*"" /> </SelectionList> <From> <Table xsi:type=""tableType"" Name=""Tab"" Alias=""a"" /> </From> <Where> <Condition xsi:type=""regionSearchType""> <Region xmlns:q1=""urn:nvo-region"" xsi:type=""q1:circleType"" coord_system_id=""""> <q1:Center ID="""" coord_system_id=""""> <Pos3Vector xmlns=""urn:nvo-coords""> <Name>X Y Z</Name> <CoordValue> <Value> <double>1.2</double> <double>2.4</double> <double>3.6</double> </Value> </CoordValue> </Pos3Vector> </q1:Center> <q1:Radius>0.2</q1:Radius> </Region> </Condition> </Where> </Select>
References:
Yasuda, N.; Mizumoto, Y.; Ohishi, M.; O'Mullane, W (2003) Yasuda, N.; Mizumoto, Y.; Ohishi, M.; O'Mullane, W.; Budavári, T.; Haridas, V.; Li, N.; Malik, T.; Szalay, A. S.; Hill, M.; Linde, T.; Mann, B.; Page, C. G. "Astronomical Data Query Language: Simple Query Protocol for the Virtual Observatory" Astronomical Data Analysis Software and Systems (ADASS) XIII, Proceedings of the conference held 12-15 October, 2003 in Strasbourg, France. Edited by Francois Ochsenbein, Mark G. Allen and Daniel Egret. ASP Conference Proceedings, Vol. 314. San Francisco: Astronomical Society of the Pacific, 2004., p.293
AbstractOnline copyExtract:
Astronomical Data Query Language (ADQL)
(2004) IVOA Astronomical Data Query Language Version 0.7.4 IVOA Working Draft 2004-05-17
AbstractExtract:
IntroductionExtract:
Astronomical Data Query Language (ADQL)
Yuji Shirasaki, Masatoshi Ohishi, Yoshihiko Mizumo (2005) Yuji Shirasaki, Masatoshi Ohishi, Yoshihiko Mizumoto, Masahiro Tanaka, Satoshi Honda, Masafumi Oe, Naoki Yasuda, Yoshifumi Masunaga
"Structured Query Language for Virtual Observatory" Astronomical Data Analysis Software and Systems XIV P1-1-23 ASP Conference Series, Vol. XXX, 2005 P. L. Shopbell, M. C. Britton, and R. Ebert, eds.
AbstractExtract:
Introduction Resources