SMS:File Import Wizard Supported File Formats

From XMS Wiki
Revision as of 16:55, 21 February 2019 by Jcreer (talk | contribs) (→‎Feature Points)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

The following types of data can be imported into SMS via the File Import Wizard.

  • 2D Scatter Set Vertices
  • 2D Mesh Nodes
  • UGrid
  • Feature Points
  • Observation Data
  • Wind, Wave, Water Level

A description of the fields (columns) that SMS recognizes when importing text files is provided in the tables below.

2D Scatter Vertices

Field Type Required Comments
X
Number
yes
X-location
Y
Number
yes
Y-location
Pt Name
Text
no
Vector X
Number
no
Used in conjunction with Vector Y Field
Vector Y
Number
no
Used in conjunction with Vector X Field
Vector Magnitude
Number
no
Used in conjunction with Vector Direction Field
Vector Direction
Number
no
Used in conjunction with Vector Magnitude Field
Scalar Data
Number
no
Breakline
Text or Number
no
See Scatter Breakline Options for a discussion of Breakline Delimeters
EXAMPLE
"id" "x" "y" "xylene" "toluene 0.0" "toluene 2.0"
"OW-21" 32.4 5234.3 300 999 999
"0W-22" 93.4 5832.3 84 398 401
"0W-23" 83.3 8438.2 89 47 52

2D Mesh Nodes

Field Type Required Comments
X
Number
yes
X-location
Y
Number
yes
Y-location
Z
Number
yes
Z-location
EXAMPLE
"x" "y" "z"
32.4 5234.3 12.34
93.4 5832.3 13.47
83.3 8438.2 21.54

UGrid Points

Field Type Required Comments
X
Number
yes
Y
Number
yes
Z
Number
no
Point Zs are set to 0.0 if omitted
Dataset
Number
no
Any number of steady-state or transient datasets can be imported. When importing transient datasets, a dataset name and a time step must be specified for each transient column. Names and time steps are entered into the header row, separated by a vertical slash using the following format: "Name|Timestep". For example, "Dataset1|January 1, 1900". All time steps of a transient dataset should be given the same name.
EXAMPLE
"x" "y" "z"
32.4 5234.3 12.34
93.4 5832.3 13.47
83.3 8438.2 21.54

Feature Points

Field Type Required Comments
Name
Text
no
X
Number
yes
X-location
Y
Number
yes
Y-location
Z
Number
yes
Z-location
EXAMPLE
"name" "x" "y" "z"
"Pt. 1" 32.4 5234.3 12.34
"Pt. 2" 93.4 5832.3 13.47
"Pt. 3" 83.3 8438.2 21.54

Observation Points

Field Type Required Comments
Point Name
Text
no
X
Number
yes
Y
Number
yes
Z
Number
no
Measurement
Text
no
Measurement name. Multiple measurements allowed.
Interval
Number
no
EXAMPLE
"name" "x" "y" "z" "hd" "int"
"OBS_Q5" 23.3 44.2 32.2 567.5 1.2
"OBS_Q6" 83.3 84.3 32.2 555.3 1.4
"OBS_Q7" 85.3 39.3 33.2 999 0

PTM Trap Output Data

Field Type Required Comments
Step
Number
no
Time step index of an entry event for a trap
Date
####/##/##
yes
Date of an entry event - must have a year, month and day
Time
##:##:##.####
yes
This column must have hour, minute and second of the entry event
Particle
Number
no
This column could be used to reference other PTM output files. Not used in import wizard
Trap
Number
yes
Defines which trap this parcel entered
Value column
Number
no
This is an optional column. There may be more than one.
Filter column
Number
no
This is an optional column. There may be more than one.

See PTM Trap Output for more information on reading PTM trap output files.

Wind, Wave, Water Level

Field Type Required Comments
Date/Time
Number/Number
yes
Date
Number
yes
Time
Number
yes
Primary Height
Number
yes
Used in conjunction with Primary Period & Direction Field
Primary Period
Number
yes
Used in conjunction with Primary Height & Direction Field
Primary Direction
Number
yes
Used in conjunction with Primary Height & Period Field
Secondary Height
Number
no
Used in conjunction with Secondary Period & Direction Field
Secondary Period
Number
no
Used in conjunction with Secondary Height & Direction Field
Secondary Direction
Number
no
Used in conjunction with Secondary Height & Period Field

Related Topics