Keywords: hnm 30048
- Report Name
- Report Type
- File Name
- Input Parameters
- DB Type
- DB Schema
- DB Version
- Data Requirements
- Report Requirements
- Output Type
- Example Output
Report Name: Google Earth Analytical Results (Aggregate) Pie Charts
This report prompts you to select a saved Analytical Results Report.
The output of this report shows pie charts illustrating the sum of each of the chemicals. If you choose to aggregate by group, then the pie charts will show the sum of each group.
Some previous versions of Google Earth do not display the Pie Charts correctly. If the Pie Charts do not display, please check your version of Google Earth.
The Google Earth output, which shows a table when clicking on a location, has been improved for readability by adding color to alternative rows.
Note: The charts displayed in this reported are created using Google Chart Tools. Google Earth will send data values (anything displayed on the chart image itself) to Google Chart Tools API to create the chart image. Coordinate information is not displayed on the chart image and is not sent to the API. The API is governed by Google APIs Terms of Service. If you do not agree with Google's Terms of Service, you should not use this report.
File Name: EarthSoft.Interfaces.Google
Input Parameters: A selection the user makes to customize the output of a report.
|Input Parameters||Input Parameter Screenshot||Output|
|Saved Analytical Results Report||Google Maps|
|Aggregate Results By|
|Aggregate Analytes By|
DB Type: SQL
DB Schema: Standard (no custom or add-on schemas required).
DB Version: Any 5.5 or later version.
Data Requirements: DT_LOCATION.LOC_DESC must be populated before locations are clickable.
Report Requirements: Google Earth
In order for locations to appear in this report:
1. DT_COORDINATE.COORD_TYPE_CODE must be like "*LAT*LONG*"
2. DT_COORDINATE.IDENTIFIER MUST be "Primary".
3. DT_LOCATION.LOC_TYPE must be populated.
4. DT_LOCATION.SYS_LOC_CODE must be populated.
Output Type: Google Earth or .kmz file
View the following example or download the attachment.