Database design

Major ports and types

1) Information about major ports (Table 6.1)

TABLE 6.1: Information about major ports

No.

Field name

Field description

Data type

Data length

1

xh

Number

NUM

10

2

ss

Fort province

VARCHAR2

50

3

gk

Port name

VARCHAR2

100

4

jd

Port longitude

NUM

7,4

5

wd

Port latitude

NUM

6,4

6

pjhpm

Mean sea level

NUM

9.5

7

cgjzm

Tidal datum plane

NUM

5,2

8

htss

Charted depth

NUM

10,5

9

NUM

5

10

jl

Distance

МШ

10,4

2) Draught information about major types of ships (Table 6.2)

TABLE 6.2: Draught information about major types of ships

No.

Field name

Field description

Data type

Data length

1

id

id

NUM

5

2

ShipType

Ship type

VARCHAR2

50

3

DWT

Ship tonnage

VARCHAR2

50

4

Need Water

bull load draught

NUM

5,1

Model basic data

Model basic data provide boundary conditions and basic data support for mathematic models. Real-time updates of the data via Internet access and download is required before each computation. Different mathematic models have different organization and storage methods of basic data. Model basic data of the project will be stored and managed in corresponding document formats.

1) Data of wind-field forecast model

The wind-field forecast model adopts various types of data, which are stored in the form of files. Such data include:

  • • Global spectrum model forecast data. American NCEP-GFS objective analysis field and forecast grid point field data [121, 122].
  • • Sea temperature data, sea temperature data from NEAR-GOOS [123, 124].
  • • Routine ground (observation data from the coastal observation station (point)) and raw insonde observation data.
  • • Other data required in the operation of WRF models, such as terrain and surface data.
  • 2) Data of wave forecast model
  • • Water-depth data, water-depth data of 1/30° x 1/30° is adopted for the large zones and that of 1/200° x 1/200° is adopted for the small zone; such data shall be rectified by referring to the latest nautical chart.
  • • Wind-field data, model wind field with a resolution of 1/30° x 1/30° for large zone and 1/200° x 1/200° for small zone is adopted as the drive wind field in the typhoon process; delayed forecast wind field of the forecast center with a resolution of 1/30° x 1/30° is adopted in the extratropical cyclone process. The wind field for the small zone is arrived at by the interpolation of such wind field.
  • • Wave spectrum data, 36 frequencies and 12 directions will be determined for each grid point.
  • • Coastline data, the latest coastline data is adopted; for major ports, such data will be updated by adopting remote-sensing image technology.
  • 3) Data of current and water-level forecast model
  • • Model grid data, irregular triangular grid which covers the entire coastal waters of China is adopted. The resolution of grid granularity reaches 70 nr in key areas and stands at around 50 km in open boundary of open sea. There are 451,507 triangular nodes in the computation domain.
  • • Water-depth data, water-depth data matching with the data model grid are generated on the basis of the latest nautical chart data and basic geographic data related to terrain provided by the National Marine Information Center and by referring to the result of water-depth measurement carried out in the site survey conducted for key regions. [1]
  • • Tidal harmonic constant, harmonic constants of six semi-tidal constituents (М2, S‘2. N2, К i. ОI .P). All tidal harmonic constants used are the simulation results of the global model.
  • • Wind field data, computation result data of WRF model are adopted.
  • • Shoreline data.
  • 4) Data of tide-bound water-level forecast model
  • • Meteorological observation data, historical observation data is adopted.
  • • Tide-bound water-level observation data, historical observation data is adopted.
  • • Wind-field data, numerical simulation result of the wind field forecast model is adopted.
  • • Water-level data, numerical simulation result of current and water level forecast model is adopted.
  • • Tidal data, tide forecast data is adopted.

Numerical simulation result data

Numerical simulation computing result is stored and managed in the form of file.

  • 1) Wind-field forecast data
  • • Wind-field data provided by the wind-field forecast system for future 48 hours on a daily basis and forecast result file generated by it every hour. The title of the document shall include such information as year, month, day and hour, for the convenience of retrieving and information service.
  • • Wind-field file in the format of ASCII ([2].sfc), which is provided for the use of current model.
  • • Wind-field file in the format of NetCDF ([2].nc), which is provided for the use of oil spill and other applications.
  • 3) Current and water-level forecast data
  • • Current field data (NetCDF format, *.nc), i.e., current field data forecast for future 48 hours. A file will be provided every hour. The title of the file shall include such information as year, month, day and hour.
  • 4) Tide-bound water-level forecast data
  • • Tide-bound water level data (NetCDF format, *.nc), i.e., tide-bound water-level data for future 48 hours. A file will be provided every hour. The title of the file shall include such information as year, month, day and hour.

Geographic data

  • 1) Remote-sensing image
  • • Satellite remote-sensing image, which covers all coastal areas of China and with a spatial resolution of 30 m and 15 m.
  • 2) Vector data
  • • Provincial capital layer, point layer in the format of ESRI slip, which includes the location and name of the provincial capital.
  • • Prefecture-level city layer, point layer in the format of ESRI slip, which includes the location and name of the prefecture-level city.
  • • County layer, point layer in the format of ESRI shp, which includes the location and name of the county.
  • • Port layer, point layer in the format of ESRI shp, which includes the location, province (municipality or autonomous region) and name of the port.
  • • Shoreline layer, line layer in the format of ESRI shp.

System function design

Various modules and functions are designed by referring to technical indicators for project assessment to achieve such functions as inquiry and graphical display of marine environment information (wind, wave and current), tide- bound water-level forecast and service and tide-bound water-level information release.

System function design is shown in Table 6.3.

Function

Sub-

module

Function

point

Description

Wind-field

information

inquiry

Wind-field information inquiry (01)

Inquiry time setting

Set the inquiry time; the default value is current time; select a prior time while making historical data inquiry; operates in an interactive manner by using date control

Spatial range setting

Set the minimum longitude, maximum longitude, minimum latitude and maximum latitude for the plotting area of the wind field via textbox

Wind-field information inquiry (02)

Graphical

plotting

Plot graphical information of the wind field

Symbol change

Change the color and size of graphic symbol of the wind field

Data thinning

Thin the dense grid, to avoid information overlapping arising from information overloading and facilitate information retrieval by the user

Data export

Export the current wind field data to Excel file

Dynamic display control

Display information on the change of wind field with time in a dynamic way; switch information by pressing Start, Stop, Previous, Next, Start Time and End Time buttons

View control

Realize the control on switching and selection of view and viewpoint and full screen display

Wave-

information

inquiry

Wave- information inquiry (03)

Inquiry time setting

The same as wind field

Spatial range setting

The same as wind Held

(Continued)

Function

Sub-

module

Function

point

Description

Significant wave height

Search significant wave-height information

Mean wave cycle

Search information about mean wave cycle

Wave- information display (04)

Graphical

plotting

Plot wave information

Plot

parameter

setting

Color gradient and other plotting relevant information

Data export

Export current wave information to Excel document

Current field

information

inquiry

Current field information inquiry (05)

Inquiry time setting

The same as wind field

Spatial range setting

The same as wind field

Significant current height

Search significant current height information

Wind-field information display (06)

Graphical

plotting

Plot graphical information of the current field

Plot

parameter

setting

Set symbol size and color, data thinning, etc.

Current field export

Export present current field to Excel document

Information service of tide-bound water level

Port spatial position and viewing (07)

Province and city setting

Set the province and city where the port is located; operate in an interactive manner by using the drop-down list

Port name setting

Set the name of the port to be viewed; operate in an interactive manner by using the drop-down list

Location skip

Automatic skipping to relevant region will be achieved in the map after the setting of province and city where the port is located is accomplished; automatic skipping to relevant port will be achieved in the map after the setting of the port is accomplished

Function

Sub-

module

Function

point

Description

Port information display

Display such information as mean sea level, tidal datum plane and charted depth

lime setting (08)

Information service data setting

Operate in an interactive manner by using date control

Ship and information setting (09)

Ship type

Operate in an interactive manner by using drop-down list

Ship tonnage

Operate in an interactive manner by using drop-down list

Full load draught

Display the draught ot the ship in full load (unit: m); non-editable textbox control

Water-depth

customization

If the water depth in the system database is different from the actual water depth, replace charted depth with customized water depth in the computation of tide-bound water level

Draught

customization

11 the draught ot ship in lull load in the database is different from the current ship draught, replace full load draught with customized draught in the computation of the time when the ship enters the port by taking the tide

i'ide-bound water-level curve plotting

Plot the curve ol change ol tide-bound water-level forecast value with time and ship draught line

Curve setting

Set attributes information of the curve, including the headline and the coordinate axis

Analysis on the time when the ship enters the port by taking the tide

Analyze the proper time tor the ship to enter the port by taking the tide and display such information in the form of text

Function

Sub-

module

Function

point

Description

Layer setting

Set whether to display background information layer (e.g., provincial capital) on the map

Tide-bound

water-level

information

publishing

Tide-bound

water-level

table

publishing

(10)

Tide-bound

water-level

table

publishing

Publish the table of forecast result of tide-bound water level to the users

  • [1] Temperature and salinity field data, namely, field of multi-year meantemperature and salinity obtained by referring to historical observationdata.
  • [2] 2 GIF wind-field image (1.gif, stored in designated folder), i.e., snapshotof wind field data. 2) Wave forecast data • Wave field data (NetCDF format, 1.nc), i.e., wave data forecast forfuture 48 hours. A file will be provided every hour. The title of thefile shall include such information as year, month, day and hour.
  • [3] 2 GIF wind-field image (1.gif, stored in designated folder), i.e., snapshotof wind field data. 2) Wave forecast data • Wave field data (NetCDF format, 1.nc), i.e., wave data forecast forfuture 48 hours. A file will be provided every hour. The title of thefile shall include such information as year, month, day and hour.
 
Source
< Prev   CONTENTS   Source   Next >