SMS:File Import Wizard Supported File Formats: Difference between revisions

From XMS Wiki
Jump to navigationJump to search
No edit summary
 
(9 intermediate revisions by the same user not shown)
Line 2: Line 2:
* 2D Scatter Set Vertices
* 2D Scatter Set Vertices
* 2D Mesh Nodes
* 2D Mesh Nodes
* UGrid
* Feature Points
* Feature Points
* Observation Data
* Observation Data
* Wind, Wave, Water level
* Wind, Wave, Water Level


A description of the fields (columns) that SMS recognizes when importing text files is provided in the tables below.
A description of the fields (columns) that SMS recognizes when importing text files is provided in the tables below.
Line 61: Line 62:
|-
|-
|<center>Z</center>||<center>Number</center>||<center>yes</center>||Z-location
|<center>Z</center>||<center>Number</center>||<center>yes</center>||Z-location
|}
{|class="wikitable"
|+<center>'''EXAMPLE'''</center>
!width="166.66"|"x"
!width="166.66"|"y"
!width="166.66"|"z"
|-
|32.4||5234.3||12.34
|-
|93.4||5832.3||13.47
|-
|83.3||8438.2||21.54
|}
== UGrid Points ==
{|class="wikitable"
!width="200"|Field
!width="100"|Type
!width="100"|Required
!width="600"|Comments
|-
|<center>X</center>||<center>Number</center>||<center>yes</center>||
|-
|<center>Y</center>||<center>Number</center>||<center>yes</center>||
|-
|<center>Z</center>||<center>Number</center>||<center>no</center>|| Point Zs are set to 0.0 if omitted
|-
|<center>Dataset</center>||<center>Number</center>||<center>no</center>||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&#124;Timestep".  For example, "Dataset1&#124;January 1, 1900".  All time steps of a transient dataset should be given the same name.
|}
|}


Line 104: Line 134:
|-
|-
|"Pt. 3"||83.3||8438.2||21.54
|"Pt. 3"||83.3||8438.2||21.54
|}
<!--
== Feature Data ==
{| class="wikitable sortable"
!width="200"|Field
!width="100"|Type
!width="100"|Required
!width="600"|Comments
|-
|<center>Name</center>||<center>Text</center>||<center>no</center>||
|-
|<center>X</center>||<center>Number</center>||<center>yes</center>||X-location
|-
|<center>Y</center>||<center>Number</center>||<center>yes</center>||Y-location
|-
|<center>Z</center>||<center>Number</center>||<center>yes</center>||Z-location
|}
|}
{|class="wikitable"
|+<center>'''EXAMPLE'''</center>
!width="166.66"|"name"
!width="166.66"|"x"
!width="166.66"|"y"
!width="166.66"|"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
|}
By default the active coverage is selected, but the user the can click on the coverage button and change which coverage to place the imported data.
If the user maps the ''Arc'' column, SMS will read either arc ID's or tags (same as how SMS reads in breaklines) and create arcs from the points.
-->


== Observation Points ==
== Observation Points ==
Line 165: Line 229:
See [[SMS:PTM Trap Output|PTM Trap Output]] for more information on reading PTM trap output files.
See [[SMS:PTM Trap Output|PTM Trap Output]] for more information on reading PTM trap output files.


== Wind, Wave, Water level ==
== Wind, Wave, Water Level ==
{| class="wikitable sortable"
{| class="wikitable sortable"
!width="200"|Field
!width="200"|Field
Line 189: Line 253:
|-
|-
|<center>Secondary Direction</center>||<center>Number</center>||<center>no</center>||Used in conjunction with Secondary Height & Period Field
|<center>Secondary Direction</center>||<center>Number</center>||<center>no</center>||Used in conjunction with Secondary Height & Period Field
|}
<!--
==LIDAR==
This option will require saving a *.las file after completing the ''File Import Wizard''.
{|class="wikitable"
!width="200"|Field
!width="100"|Type
!width="100"|Required
!width="600"|Comments
|-
|<center>X</center>||<center>Number</center>||<center>yes</center>||
|-
|<center>Y</center>||<center>Number</center>||<center>yes</center>||
|-
|<center>Z</center>||<center>Number</center>||<center>no</center>|| Point Zs are set to 0.0 if omitted
|}
|}


{|class="wikitable"
|+<center>'''EXAMPLE'''</center>
!width="166.66"|"x"
!width="166.66"|"y"
!width="166.66"|"z"
|-
|32.4||5234.3||12.34
|-
|93.4||5832.3||13.47
|-
|83.3||8438.2||21.54
|}
-->


==Related Topics==
==Related Topics==
* [[SMS:File Import Wizard|File Import Wizard]]
* [[SMS:File Import Wizard|File Import Wizard]]
* [[Data Acquisition]]


{{Template:Navbox SMS}}
{{Template:Navbox SMS}}

Latest revision as of 16:55, 21 February 2019

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