< EclipseLink | Examples
- 1 Application
- 1.1 Requirements
- 1.1.1 R1: Determine layered GIS data for rainfall distribution at 1km resolution @ 200 km range
- 1.1.2 R2: Provide historical data
- 1.1.3 R3: Provide 30 min prediction window
- 1.1.4 R4: Provide present status per GPS position
- 1.1.5 R10: Provide live consolidated view
- 1.1.6 R11: Provide query interface
- 1.2 Design Issues
- 1.2.1 DI1: Database: Derby or Oracle GIS/SDO aware?
- 1.2.2 DI2: Database Expected Volume
- 1.2.3 DI10: Determine color codes for Radar
- 1.2.4 DI11: Determine color codes for Satellite
- 1.2.5 DI12: Determine color codes for Lightning
- 1.2.6 DI21: Filter and Preprocess Radar Images
- 1.2.7 DI22: Filter and Preprocess Satellite Images
- 1.2.8 DI23: Filter and Preprocess Lightning Images
- 1.3 References
- 1.1 Requirements
R1: Determine layered GIS data for rainfall distribution at 1km resolution @ 200 km range
R2: Provide historical data
R2.1: Provide volumentric data per GPS position
R3: Provide 30 min prediction window
R3.1 Extend prediction window by including surrounding area weather
R4: Provide present status per GPS position
R10: Provide live consolidated view
R11: Provide query interface
DI1: Database: Derby or Oracle GIS/SDO aware?
DI2: Database Expected Volume
- There are 14 levels of rainfall represented by color bands from purple to light blue. If we include the ground color (green-grey), rivers (navy) and borders (black) we have 17 levels. We also want to encode (null/unset/no-data) as white or -1 - this gives us 18 levels which fits in a single 8 bit byte.
- There are approximately 500x480 pixels at 1km resolution which works to 234Kb decoded.
- We expect 24 x 6 = 144 images / site / day, which comes to 234Kb x 144 = 34Mb / day / site.
- We therefore need 12 Gb storage / year / site. A standard 2Tb drive which is around the effective limit of most databases will hold 169 years of data (disregarding compression gains and error handling losses). We should be able to hold our goal of 10 years of radar data for 16 sites comfortably.
- This assumes we store raw data without gps coordinates, we may want to only store colored pixels in data or gif format.
DI10: Determine color codes for Radar
DI11: Determine color codes for Satellite
DI12: Determine color codes for Lightning
DI21: Filter and Preprocess Radar Images
DI22: Filter and Preprocess Satellite Images
DI23: Filter and Preprocess Lightning Images