Download
1 / 16
160 likes | 275 Views
Custom Query Tool. Uses of CQT. Access any data in the repository Meteorological observations Model data Hydrology Etc. Uses of CQT. Generate climatology reports Create model derived soundings Retrieve raw data with QC checks Anything else you want it to do. Running CQT.
E N D
Uses of CQT • Access any data in the repository • Meteorological observations • Model data • Hydrology • Etc...
Uses of CQT • Generate climatology reports • Create model derived soundings • Retrieve raw data with QC checks • Anything else you want it to do
Running CQT • CQT runs on JRE 1.3.1 or higher • Installed on DAC • Java WebStart-able • Near future plans: Web interface
Query List Section • Once a query is selected from the list, the parameter section will update to reflect the selected query.
Query Parameter Section • The parameter window is located in the upper right corner of CQT. You enter the query constraints in this window. • Each query has a list of parameters. Each parameter has a dialog window that will allow you to change its value. Parameter names highlighted in yellow are common to all queries.
Results Table • If the CQT Results Table is selected for the Output Location, the data will appear in a table in the bottom of the tool. This table can be copied into an Excel spreadsheet. • Not all queries allow result to be seen in this table.
Build A Query • Query list is built from an XML file • SQL Queries are very easy to build • Other Queries require writing Java code
SQL Query Example <query className=“edu.ucar.rap.cqt.SQLQuery” name=“DWRS:Retrieve MicroStep Data” > <parameter className=“edu.ucar.rap.cqt.Parameter” name=“sql” default=“SELECT * FROM mis_surface_data WHERE dt > ?” visible=“false” /> <parameter className=“edu.ucar.rap.cqt.DateParameter” fillsSqlQuestionMark=“true” name=“Start Date” default=“NOW” /> </query>
Custom Java Query • Must add query to the XML file • New query must extend the class edu.ucar.rap.cqt.Query • Demonstration with MicroStep data
Existing Queries • Model Derived Soundings (a.k.a. Virtual Soundings) • Lightning strike maps and diurnal distribution
Virtual Sounding • Model data is interpolated to an arbitrary latitude and longitude. • The Virtual Sounding query generates a skew-T plot, as well as a text file with wind and temperature values.
Lightning Strike Map • The map shows each individual lightning strike that was recorded.
