/usr/share/doc/stilts/sun256/sqlskymatch.html is in stilts-doc 3.1.2-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 | <html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="sun-style.css">
<title>sqlskymatch:
Crossmatches table on sky position against SQL table
</title>
</head>
<body>
<hr>
<a href="sqlskymatch-usage.html">Next</a> <a href="secB.17.2.html">Previous</a> <a href="cmdUsage.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="sqlskymatch-usage.html">Usage</a><br>
<b>Up: </b><a href="cmdUsage.html">Command Reference</a><br>
<b>Previous: </b><a href="secB.17.2.html">Examples</a><br>
<hr>
<hr>
<h2><a name="sqlskymatch">B.18 <code>sqlskymatch</code>:
Crossmatches table on sky position against SQL table</a></h2>
<p><code>sqlskymatch</code> resembles
<a href="coneskymatch.html"><code>coneskymatch</code></a>,
but instead
of sending an HTTP query to a remote cone search service for each
match (i.e. each row of the input table), it executes an SQL query
directly. The query is a SELECT statement with a WHERE clause which
makes restrictions on Right Ascension and Declination columns;
the names of these columns must be given as parameters.
The effect is that of a spatial join between a client-side table and
a table stored in the database.
</p>
<p>This command can only be used if you have access to an SQL
database via JDBC. The details of how to configure a JDBC connection
to a database are discussed in <a href="jdbcConfig.html">Section 3.4</a> - obviously
you will need a database to connect to and appropriate read permissions
on it as well as the relevant drivers.
</p>
<p><em>Note: this task was known as <code>sqlcone</code> in its experimental
form in STILTS v1.3.</em>
</p>
<ul>
<li><a href="sqlskymatch-usage.html">B.18.1 Usage</a></li>
<li><a href="secB.18.2.html">B.18.2 Examples</a></li>
</ul>
<hr><a href="sqlskymatch-usage.html">Next</a> <a href="secB.17.2.html">Previous</a> <a href="cmdUsage.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="sqlskymatch-usage.html">Usage</a><br>
<b>Up: </b><a href="cmdUsage.html">Command Reference</a><br>
<b>Previous: </b><a href="secB.17.2.html">Examples</a><br>
<hr><i>STILTS - Starlink Tables Infrastructure Library Tool Set<br>Starlink User Note256<br>STILTS web page:
<a href="http://www.starlink.ac.uk/stilts/">http://www.starlink.ac.uk/stilts/</a><br>Author email:
<a href="mailto:m.b.taylor@bristol.ac.uk">m.b.taylor@bristol.ac.uk</a><br>Mailing list:
<a href="mailto:topcat-user@jiscmail.ac.uk">topcat-user@jiscmail.ac.uk</a><br></i></body>
</html>
|