AERONET Web Data Access and Relational Database

1
AERONET Web Data Access and Relational Database

• David Giles
• Science Systems and Applications, Inc.
• NASA Goddard Space Flight Center

2
AERONET Web Site

• Adheres to One NASA Portal format
• Redesigned static and dynamic web pages
• Updated content and web links
• Complies with US accessibility standards
• http//aeronet.gsfc.nasa.gov

3
Overview

• AERONET Data Access
• Relational Database

4
Overview

• AERONET Data Access
• Database Design
• Data Interface and Download Tool
• Level 2.0 Climatology
• Relational Database

5
Database Design Acquisition
Measurements and Transmission
Relay Transmission to Receiving Station
AERONET Server
Transfer Data via Internet
Download and Transfer Data via Internet
Web Interface
Demonstrat
6
Database Design Processing
Main Database Demonstrat
Web Database

• Processed Hourly
• Stored in binary format
• (Raw and Processed)
• Indexed Hourly

• Transferred hourly
• Stored in text format
• (Raw and Processed)
• Indexed hourly

Processing Software
Processing Software

• Converts satellite data into raw data files
• Calculates AOT and sky retrievals data using
  solar and radiance calibration data
• Scans database files

• Converts binary files to text files
• Combines sky retrieval data into single files
• Scans database files

7
Display Interface

• Time Selection
• Site Selection
• Map Interface
• Text Interface
• Additional Options
• Site Type
• AOT Level

8
Display Interface

• Time Selection Menu
• Display Aerosol Optical Depth Plots
• Direct Data Download Links
• Additional Data Products
• Almucantar Retrieval Products (AERONET)
• Satellite Images (AQUA/TERRA-MODIS, GOES)
• MPLNET
• Back Trajectory Analyses

9
Download Tool

• Geographical Site Selection
• Map
• Region, Country/State, and AERONET Site

10
Download Tool

• Time Selection
• AOT Products
• Levels 1.0, 1.5, 2.0
• Instrument number and wavelength information
• Raw Radiance Data with calibration applied
• Almucantar, Principal Plane (Polar), BRDF
• Nakajima Almucantar Retrievals
• SKYRAD.PAK Code

11
Download Tool

• Almucantar Retrievals (Dubovik)
• Spherical, Spheroid
• Default Option
• Advanced Parameters
• Data Type Formats
• All Points
• Daily and Monthly Averages

12
Download Tool

• Wait for Data Processing
• Select Accept to download zip file

13
Level 2.0 Climatology

• Daily Average and Weighted Average
• Monthly
• Multi-Year Monthly
• Yearly
• Multi-Year Yearly

14
Level 2.0 Climatology
870-440nm Angstrom
AOT 500nm
15
Data Access Summary

• Update main database hourly transfer full
  database weekly
• Provide visualization of AOT and other related
  products
• Access to download all available AERONET products

16
Data Access Future Work

• Modify web database software to accommodate new
  AERONET retrieval products
• Integrate AERONET web site into BAMGOMAS
• Develop climatology of retrieval products
• Develop flux data web interface

17
Data Access Future Work

• Possible multi-site download tool based on a
  geographic and text interface
• Possible radiative forcing AERONET product

18
Overview

• AERONET Data Access
• Relational Database
• Background
• Design
• Example

19
Filemaker Pro A Relational Database

• Filemaker Pro (FMPro) 6 Unlimited
• Provides dependable data storage
• Interlinks databases to allow customizable data
  reports and forms
• Performs complex sort and search procedures

20
Background User Interface

• Supported Platforms
• PC (Preferred)
• Mac
• Unix
• Web Accessible
• Internet Explorer (Preferred)
• Netscape
• Mozilla
• FMPro 6 Software

21
BackgroundUser Privileges

• Browse Records
• Add/Modify/Delete Records
• Password Controlled
• Search
• Sort

22
Design
Aeronet Server
FileMaker Server
User Input
FTP
HTTP
PC
UNIX
Updated hourly
Updated instantly
WEB
23
Design

• Database Links
• Internal
• External
• Multi-link (Internal and External)

24
Design
Master Database
AERONET Inventory
Instrument Status Database
Internal Relational Links
AERONET Intercalibration Data
Instrument Locations
Contact Data
External Relational Links from AERONET Database
AERONET Locations
Location Data
25
ExampleInstrument Status Database
26
ExampleInstrument Status Database
27
Relational Database Summary

• Provides reliable monitoring, storage, and
  tracking of operational activities, inventory,
  and contact information
• Improves accuracy and timeliness of AERONET web
  site metadata
• Allows user interactivity from multiple
  platforms, web browsers, and locations

28
Relational Database Future Work

• Continue to integrate FMPro with AERONET database
  and web site
• Transfer legacy Excel intercalibration data to
  FMPro
• Integrate additional calibration facilities
  (e.g., Spain, Australia, Canada, China)