Geometry on SQL server

[Theresa Dower]

Dave and Gerard,

While the state of the wiki page is mostly true (and I'll update it after responding to this email) ADQL geometry on SQL Server is actually in active development by a MAST developer, Sarah Weissman, and myself. We started with Dave Morris' SqlServer addition to Gregory Mantele's Java parser. We've already added RegTAP string search support, which is in testing. The geometry is still the holdup for ObsTAP.  

Brian McLean's spatial functions are closer to the Postgres model than the HTM-based functions we were previously using, and we're going to call those from the parser. Given how far this has drifted from Gregory's original code, and that it calls functions we've added to the database on top of the native SQL Server geometry, we're not quite sure how to share our work, or where, but we'd definitely like to collaborate as possible.

--Theresa

-----Original Message-----
From: dal-bounces at ivoa.net [mailto:dal-bounces at ivoa.net] On Behalf Of Dave Morris
Sent: Friday, January 22, 2016 12:07 PM
To: dal at ivoa.net
Subject: Geometry on SQL server

Hi Gerard,

On 2016-01-11 14:43, gerard.lemson at gmail.com wrote:
> For SQLServer-based implementations of ADQL (which unarguably would be 
> a good think to have, see SDSS, STScI, Millennium, others?) the main 
> stumbling block is I believe (still?) support for the spatial 
> extensions. Maybe this is a good forum as any to try to get some 
> support via mailing list iso ad hoc questions during interop meeting 
> to get a group of interested people together to work on this. If more 
> are interested we can post a more formal email to the list starting a 
> discussion.

We made a start back in 2014, but as far as I know, no one has had time or resources to take it further.

http://wiki.ivoa.net/twiki/bin/view/IVOA/ADQLGeomOnSQLServer

If anyone has any news on this please fee free to update the wiki page.

Thanks,
Dave

--------
Dave Morris
Software Developer
Wide Field Astronomy Unit
Institute for Astronomy
University of Edinburgh
--------