<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!-- p { margin-top: 0px; margin-bottom: 0px; }--></style>
</head>
<body dir="ltr" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p class="p1"><span class="s1">Apologies if this goes through multiple times... this internet is quite flaky.</span></p>
<p class="p1"><span class="s1"><br>
</span></p>
<p class="p1"><span class="s1"><br>
</span></p>
<p class="p1"><span class="s1">Hi all,</span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p1"><span class="s1">If you are interested in my presentation about LSST and TAP/ADQL, i've uploaded the PDF to dropbox right now (until I can get it on the wiki):</span></p>
<p class="p3"><span class="s2"><a href="https://www.dropbox.com/s/l89mpih9dmk2q3a/LSST_DAX_IVOA_Interop_May-2016.pdf?dl=0">https://www.dropbox.com/s/l89mpih9dmk2q3a/LSST_DAX_IVOA_Interop_May-2016.pdf?dl=0</a></span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p1"><span class="s1">Also, not sure if I'm going to make it to the meeting later, I need to take care of a few things for work as people in the US wake up and need a decent connection.</span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p1"><span class="s1">That said, if you end up talking about JSON, I was just going to post my example JSON response format for TAP and mention a few things about it:</span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p3"><span class="s2"><a href="https://gist.github.com/brianv0/07cf0acd83bde6f450a9">https://gist.github.com/brianv0/07cf0acd83bde6f450a9</a></span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p1"><span class="s1">From my perspective, there's two use cases of a JSON response for TAP. </span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p1"><span class="s1">1. A 1:1 (or near to it) alternative to VOTable.</span></p>
<p class="p1"><span class="s1">2. A simplified/minimal version intended to be very easy to use from Javascript.</span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p1"><span class="s1">For the first case, the output of something like that might look like the link above.</span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p1"><span class="s1">For the second case, a minimal representation might look like this:</span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p1"><span class="s1">{</span></p>
<p class="p1"><span class="s1"> "columns": [</span></p>
<p class="p1"><span class="s1"> {"name":"foo", "datatype":"int"},</span></p>
<p class="p1"><span class="s1"> {"name":"bar", "datatype":"long"}</span></p>
<p class="p1"><span class="s1"> {"name":"baz", "datatype":"double"}</span></p>
<p class="p1"><span class="s1"> ],</span></p>
<p class="p1"><span class="s1"> "data" : [</span></p>
<p class="p1"><span class="s1"> [ 1, "1.12", 2.123]</span></p>
<p class="p1"><span class="s1"> [ 2, "1.34", 2.345]</span></p>
<p class="p1"><span class="s1"> [ 3, "1.56", 2.678]</span></p>
<p class="p1"><span class="s1"> ]</span></p>
<p class="p1"><span class="s1">}</span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p1"><span class="s1">This is extremely easy to deal with via javascript. </span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p1"><span class="s1">i.e:</span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p1"><span class="s1">var table = $(/* call TAP here via jquery */);</span></p>
<p class="p1"><span class="s1">table.columns.forEach(function(i){ console.log(i.name)}); // log names</span></p>
<p class="p1"><span class="s1">table.rows.forEach( doSomethingWIthRow );</span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p1"><span class="s1">So, if you end up talking about a JSON format, please consider these two potential use cases.</span></p>
<p class="p2"><span class="s1"></span><br>
</p>
<p class="p1"><span class="s1">Thanks,</span></p>
<p class="p1"><span class="s1">Brian​</span></p>
<p><br>
</p>
</body>
</html>