|
Philip van der Wel Administrator Posts: 145
8/7/2020
|
Philip van der WelAdministrator Posts: 145
This post is part of a series of posts titled Your Data in Your Database, guiding you through adding, viewing, updating, deleting, and exporting data tables and their data within your JunoViewer database. Click here to view an overview of the series.
As the name, JunoViewer, suggestions, your data can be viewed and exported in various formats from many of the pages throughout JunoViewer. In this help post we will focus on viewing and exporting your data in its basic tabular form
6.1 Data Export page
The Data Export page (located under the Manage < Data Export) enables you to export data from the tables in your database. You can export data from single section or an entire network; between a specific date range or with no date limits.
The image below highlights the main features of the page:
6.2 SQL View
The SQL View (located under the Analyse Menu) enables you to efficiently view and export data directly from your database using SQL queries. Extracting data through the SQL View (as opposed to the Data Export feature) is useful for a number of reasons, giving you the flexibility to:
Specify only the table columns containing the data you are interested in.
- e.g. SELECT sectionID, lane, locFrom, locTo, laneMeanRut FROM rutting
Use table joins to query data from multiple tables at one time and view the results in a single table.
- e.g. SELECT s.networkID, r.sectionID, r.lane, r.locFrom, r.locTo, r.measDate, r.laneMeanRut FROM tblSections s JOIN rutting r ON s.sectionID = r.sectionID
Extract data from multiple (and separate) locations across a network.
- e.g. SELECT * FROM rutting WHERE sectionID IN (1234, 2345, 3456, 4567)
Limit the returned records based on the value of one or more parameters.
- e.g. SELECT * FROM rutting WHERE measDate > '01-Jul-2015' AND (lwpMeanRut >= 20 OR rwpMeanRut >=20)
Save and retrieve up to ten frequently used queries for future use.
The first 2,000 records returned by the query will display within the view, and all returned records (up to a maximum of 800,000) can be download to your computer.
The image below highlights the main features of the page:
edited by Kiki on 9/6/2022
|