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

From XMS Wiki
Jump to navigationJump to search
 
(82 intermediate revisions by 7 users not shown)
Line 1: Line 1:
The [[GMS:Text_Import_Wizard|Text Import Wizard]] can import various types of data as described in the tables below.
{{TOCright}}<!--moved to right because of customer complaints that the article can't be read until after scrolling past the TOC-->
The [[GMS:File Import Wizard|''File Import Wizard'']] can import various types of data as described in the tables below.


== 2D scatter points ==
== 2D UGrid Points ==
This will create new scatter points in a new [[GMS:2D_Scatter_Point_Module|2D scatter set]]. Optionally the imported points can be filtered using the filter options available by selecting the Filter Options button.
This will create new points in a new [[GMS:UGrid_Module|UGrid]]. Optionally the imported points can be filtered using the filter options available by selecting the '''Filter Options''' button.
 
{|class="wikitable"
!Field
!Type
!Required
!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.
|}
 
===Examples===
These examples can be copied and pasted into GMS.
 
====Steady State====
<pre>
"x" "y" "xylene" "toluene1" "toluene2"
32.4 74.3 300 999 999
93.4 32.3 84 398 401
83.3 48.2 89 47 52
46.8 29.1 207 147 134
</pre>
 
====Transient====
<pre>
"x" "y" "xylene|01/01/2000 00:00" "xylene|01/01/2000 12:00" "xylene|01/02/2000 00:00"
32.4 74.3 300 87 276
93.4 32.3 84 310 187
83.3 48.2 89 148 198
46.8 29.1 207 147 134
40.3 50.1 158 213 32
60.7 52.0 27 41 300
78.7 72.9 264 275 206
</pre>
 
== 3D UGrid Points ==
 
This will create new points in a new [[GMS:UGrid_Module|UGrid]].
{|class="wikitable"
!Field
!Type
!Required
!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>yes</center>||
|-
|<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.
|}
 
===Examples===
These examples can be copied and pasted into GMS.
 
====Steady State====
<pre>
"x" "y" "z" "xylene" "toluene|0.0" "toluene|2.0"
32.4 74.3 10.1 300 87 999
93.4 32.3 25.7 84 310 187
83.3 48.2 5.3 89 148 198
46.8 29.1 -42.2 207 147 134
</pre>
 
====Transient====
<pre>
"x" "y" "z" "xylene|01/01/2000 00:00" "xylene|01/01/2000 12:00" "xylene|01/02/2000 00:00"
32.4 74.3 10.1 300 387 276
93.4 32.3 25.7 84 310 187
83.3 48.2 5.3 89 148 198
46.8 29.1 -42.2 207 147 134
</pre>
 
== 2D Scatter Points ==
This will create new scatter points in a new [[GMS:2D_Scatter_Point_Module|2D scatter set]]. Optionally the imported points can be filtered using the filter options available by selecting the '''Filter Options''' button.


{|class="wikitable"
{|class="wikitable"
Line 16: Line 98:
|<center>Label</center>||<center>Text</center>||<center>no</center>||
|<center>Label</center>||<center>Text</center>||<center>no</center>||
|-
|-
|<center>Data Set</center>||<center>Number</center>||<center>no</center>||Any number of steady-state or transient data sets can be imported.  When importing transient data sets, a data set 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 data set should be given the same name.
|<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 22: Line 104:
These examples can be copied and pasted into GMS.
These examples can be copied and pasted into GMS.


====Steady state====
====Steady State====
<pre>
<pre>
"id" "x" "y" "xylene" "toluene 0.0" "toluene 2.0"
"id" "x" "y" "xylene" "toluene|0.0" "toluene|2.0"
"OW-21" 32.4 5234.3 300 999 999
"OW-21" 32.4 74.3 300 999 999
"OW-22" 93.4 5832.3 84 398 401
"OW-22" 93.4 32.3 84 398 401
"OW-23" 83.3 8438.2 89 47 52
"OW-23" 83.3 48.2 89 47 52
"OW-24" 46.8 7829.1 207 147 134
"OW-24" 46.8 29.1 207 147 134
</pre>
</pre>


Line 34: Line 116:
<pre>
<pre>
"id" "x" "y" "xylene|01/01/2000 00:00" "xylene|01/01/2000 12:00" "xylene|01/02/2000 00:00"
"id" "x" "y" "xylene|01/01/2000 00:00" "xylene|01/01/2000 12:00" "xylene|01/02/2000 00:00"
"OW-21" 32.4 5234.3 300 310 312
"OW-21" 32.4 74.3 300 87 276
"OW-22" 93.4 5832.3 84 87 93
"OW-22" 93.4 32.3 84 310 187
"OW-23" 83.3 8438.2 89 93 93
"OW-23" 83.3 48.2 89 148 198
"OW-24" 46.8 7829.1 207 147 134
"OW-24" 46.8 29.1 207 147 134
"OW-25" 40.3 50.1 158 213 32
"OW-26" 60.7 52.0 27 41 300
"OW-27" 78.7 72.9 264 275 206
</pre>
</pre>


== 3D scatter points ==
== 3D Scatter Points ==
This will create new scatter points in a new [[GMS:3D_Scatter_Point_Module|3D scatter set]].  
This will create new scatter points in a new [[GMS:3D_Scatter_Point_Module|3D scatter set]].  
{|class="wikitable"
{|class="wikitable"
Line 58: Line 143:
|<center>Material ID</center>||<center>Number</center>||<center>no</center>||
|<center>Material ID</center>||<center>Number</center>||<center>no</center>||
|-
|-
|<center>Data Set</center>||<center>Number</center>||<center>no</center>||Any number of steady-state or transient data sets can be imported.  When importing transient data sets, a data set 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 data set should be given the same name.
|<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 64: Line 149:
These examples can be copied and pasted into GMS.
These examples can be copied and pasted into GMS.


====Steady state====
====Steady State====
<pre>
<pre>
"id" "x" "y" "z" "xylene" "toluene 0.0" "toluene 2.0"
"id" "x" "y" "z" "xylene" "toluene|0.0" "toluene|2.0"
"OW-21" 32.4 5234.3 10.1 300 999 999
"OW-21" 32.4 74.3 10.1 300 87 999
"OW-22" 93.4 5832.3 25.7 84 398 401
"OW-22" 93.4 32.3 25.7 84 310 187
"OW-23" 83.3 8438.2 5.3 89 47 52
"OW-23" 83.3 48.2 5.3 89 148 198
"OW-24" 46.8 7829.1 -42.2 207 147 134
"OW-24" 46.8 29.1 -42.2 207 147 134
</pre>
</pre>


Line 76: Line 161:
<pre>
<pre>
"id" "x" "y" "z" "xylene|01/01/2000 00:00" "xylene|01/01/2000 12:00" "xylene|01/02/2000 00:00"
"id" "x" "y" "z" "xylene|01/01/2000 00:00" "xylene|01/01/2000 12:00" "xylene|01/02/2000 00:00"
"OW-21" 32.4 5234.3 10.1 300 310 312
"OW-21" 32.4 74.3 10.1 300 387 276
"OW-22" 93.4 5832.3 25.7 84 87 93
"OW-22" 93.4 32.3 25.7 84 310 187
"OW-23" 83.3 8438.2 5.3 89 93 93
"OW-23" 83.3 48.2 5.3 89 148 198
"OW-24" 46.8 7829.1 -42.2 207 147 134
"OW-24" 46.8 29.1 -42.2 207 147 134
</pre>
</pre>


== Observation data ==
== Observation Data ==
This creates new [[GMS:Feature_Objects#Points|feature points]] in the existing, active [[GMS:Feature_Objects#Coverages|coverage]]. The active coverage must exist and have a steady state [[GMS:Observations|observation]] attribute (like "Head") defined.
This creates new [[GMS:Feature_Objects#Points|feature points]] in the existing, active [[GMS:Feature_Objects#Coverages|coverage]]. The active coverage must exist and have a steady state [[GMS:Observations|observation]] attribute (such as "Head") defined.
{| class="wikitable"  
{| class="wikitable"  
!Field
!Field
Line 117: Line 202:
</pre>
</pre>


== Transient observation data ==
== Transient Observation Data ==
This adds time series [[XY_Series_Editor|curves]] to existing [[GMS:Feature_Objects#Points|points]] in an existing [[GMS:Observations|observation]] [[GMS:Feature_Objects#Coverages|coverage]]. The targeted coverage must be the active coverage. The existing points and the data being imported are matched by name.
This adds time series [[XY_Series_Editor|curves]] to existing [[GMS:Feature_Objects#Points|points]] in an existing [[GMS:Observations|observation]] [[GMS:Feature_Objects#Coverages|coverage]]. The targeted coverage must be the active coverage.
 
The existing points and the data being imported are matched by ''Name'' or ''ID''. If both ''Name'' and ''ID'' are specified then ''ID'' will take precedence.
 
Both ''Date'' and ''Time'' can be specified although data can be imported with only ''Date'' or only ''Time'' specified (at least one of these fields must be specified). If only the ''Date'' is specified then the time is set to 12:00:00 AM. If only ''Time'' is specified then it is assumed that date/time format is not being used and the time is treated as a relative time.


{| class="wikitable"  
{| class="wikitable"  
Line 126: Line 215:
!Comments
!Comments
|-
|-
|<center>Point Name</center>||<center>Text</center>||<center>yes</center>||
|<center>Name</center>||<center>Text</center>||<center>no</center>|| Either Name or ID must be specified
|-
|<center>ID</center>||<center>Text</center>||<center>no</center>|| Either Name or ID must be specified
|-
|-
|<center>Date (MM/DD/YYYY)</center>||<center>Date</center>||<center>yes</center>||
|<center>Date</center>||<center>Date</center>||<center>no</center>|| Either Date or Time or both must be specified
|-
|-
|<center>Time (HH:MM:SS)</center>||<center>Time</center>||<center>yes</center>||
|<center>Time</center>||<center>Time</center>||<center>no</center>|| Either Date or Time or both must be specified
|}
|}


Line 142: Line 233:
</pre>
</pre>


== Well data ==
== Well Data ==
This creates new [[GMS:Feature_Objects#Points|feature points]] in an existing [[GMS:Feature_Objects#Coverages|coverage]]. The point types are set to "well" and the flow rate and other data are assigned to the points. A coverage with the "Wells" attribute must already exist and be the active coverage.
This creates new [[GMS:Feature_Objects#Points|feature points]] in an existing [[GMS:Feature_Objects#Coverages|coverage]]. The point types are set to "well" and the flow rate and other data are assigned to the points. A coverage with the ''Wells'' attribute must already exist and be the active coverage.


{| class="wikitable"  
{| class="wikitable"  
Line 174: Line 265:
</pre>
</pre>


== Pumping data ==
== MODFLOW Well Package Data ==
This text file creates new well boundary conditions in an existing MODFLOW simulation. Both steady state (one flow rate per well) or transient data (multiple flow rates at different times per well) can be imported. With transient data, multiple rows are used to list flow rates at different times (or date/times) and the ''Well Name'' field is used to associate the flow rates with the correct well. The times for changes in flow rate do not need to match the model stress period times. Flow rate curves are treated as stair step data and the rate for each stress period is found by temporal (time) interpolation. A prompt will ask if wanting to use the average flow rate for each stress period, or use the flow rate at the beginning of each stress period. Select the option that is best suited for the project.
 
{| class="wikitable"
!Field
!Type
!Required
!Comments
|-
|<center>Layer</center>||<center>Number</center>||<center>yes</center>||
|-
|<center>Row</center>||<center>Number</center>||<center>yes</center>||
|-
|<center>Column</center>||<center>Number</center>||<center>yes</center>||
|-
|<center>Well Name</center>||<center>Text</center>||<center>yes</center>||<center>Any text used as the well identifier.</center>
|-
|<center>Flow Rate</center>||<center>Number</center>||<center>no</center>||<center>Positive for injection, negative for extraction.</center>
|-
|<center>Date</center>||<center>Date</center>||<center>no</center>||<center>If neither Date nor Time is specified, all stress periods will have the same Q.</center>
|-
|<center>Time</center>||<center>Time</center>||<center>no</center>||<center>Use this field for relative times (starting from 0.0), or if specifying an actual time of day (5:00) to go with the Date field. If neither Date nor Time is specified, all stress periods will have the same Q.</center>
|}
 
===Example===
<pre>
"Layer" "Row" "Column" "Rate" "Well Name" "Date" "Time"
1 2 2 -502 City Well #1 Jan 1, 1940 5:00
1 2 2 -431 City Well #1 July 1, 1940 5:00
1 4 4 0 W5088341 July 1, 1940 5:00
1 4 4 -1000 W5088341 July 1, 1941 6:00
</pre>
 
== Pumping Data ==
This adds time series [[XY_Series_Editor|curves]] to existing [[GMS:Feature_Objects#Points|points]] in an existing [[GMS:Feature_Objects#Coverages|coverage]] containing wells. The targeted coverage must be the active coverage. The existing points and the data being imported are matched by name.  
This adds time series [[XY_Series_Editor|curves]] to existing [[GMS:Feature_Objects#Points|points]] in an existing [[GMS:Feature_Objects#Coverages|coverage]] containing wells. The targeted coverage must be the active coverage. The existing points and the data being imported are matched by name.  


Line 186: Line 310:
</center>
</center>
|-
|-
|<center>Date(MM/DD/YYYY)</center>||<center>Number</center>||<center>yes</center>||
|<center>Date</center>||<center>Date</center>||<center>No</center>|| Either Date or Time or both must be specified.
|-
|-
|<center>Time(HH:MM:SS)</center>||<center>Number</center>||<center>yes</center>||
|<center>Time</center>||<center>Time</center>||<center>No</center>|| Either Date or Time or both must be specified.
|-
|-
|<center>Flow Rate</center>||<center>Number</center>||<center>yes</center>||
|<center>Flow Rate</center>||<center>Number</center>||<center>yes</center>||<center>Positive for injection, negative for extraction.</center>
|-
|-
|<center>Depth</center>||<center>Number</center>||<center>no</center>||<center>Depth to top of screen.</center>
|<center>Depth</center>||<center>Number</center>||<center>no</center>||<center>Depth to top of screen.</center>
|-
|-
|<center>Screen Length</center>||<center>Number</center>||<center>no</center>||
|<center>Screen Length</center>||<center>Number</center>||<center>no</center>||
|-
|<center>Flow Rate</center>||<center>Number</center>||<center>no</center>||<center>Positive for injection, negative for extraction.</center>
|}
|}


Line 208: Line 330:
</pre>
</pre>


''This next table is a old copy of the above table. (check the dates)''
== Borehole Data ==
{| class="wikitable"
|+<center>'''EXAMPLE'''</center>
!"name"
!"date"
!"time"
!"Q"
 
|-
|"well_1"||12/3/1999||18:00:00||625.0
|-
|"well_1"||1/30/2000||7:38:25||0
|-
|"well_2"||13/3/1999||18:00:00||0
|-
|"well_2"||15/5/1999||14:48:32||100.0
|}
 
== Borehole data ==
This creates new [[GMS:Boreholes|boreholes]]. Optionally, a borehole folder name can be specified to organize the imported boreholes.
This creates new [[GMS:Boreholes|boreholes]]. Optionally, a borehole folder name can be specified to organize the imported boreholes.
{| class="wikitable"  
{| class="wikitable"  
Line 249: Line 353:
|-
|-
|<center>Horizon ID</center>||<center>Number</center>||<center>no</center>||
|<center>Horizon ID</center>||<center>Number</center>||<center>no</center>||
|-
|<center>Description</center>||<center>Text</center>||<center>no</center>||<center>Description of the material (usually from drilling report).
|}
|}


Line 260: Line 366:
</pre>
</pre>


== Borehole sample data ==
== Borehole Sample Data ==
This creates new [[GMS:Boreholes#Sample_Data|sample data]] on existing [[GMS:Boreholes|boreholes]], or new sample data on new boreholes if no boreholes with matching names exist. All existing sample data is replaced with that being imported.
This creates new [[GMS:Boreholes#Sample_Data|sample data]] on existing [[GMS:Boreholes|boreholes]], or new sample data on new boreholes if no boreholes with matching names exist. All existing sample data is replaced with that being imported.
{| class="wikitable"  
{| class="wikitable"  
Line 274: Line 380:
|<center>Y</center>||<center>Number</center>||<center>yes</center>||<center>Y location of the borehole.</center>
|<center>Y</center>||<center>Number</center>||<center>yes</center>||<center>Y location of the borehole.</center>
|-
|-
|<center>Z</center>||<center>Number</center>||<center>yes</center>||<center>Z location of the borehole.</center>
|<center>Z</center>||<center>Number</center>||<center>yes</center>||<center>Z location of the borehole, in descending order, top to bottom.</center>
|-
|-
|<center>Data Set</center>||<center>Number</center>||<center>yes</center>||
|<center>Dataset</center>||<center>Number</center>||<center>yes</center>||
|-
|-
|}
|}
Line 282: Line 388:
<pre>
<pre>
"id" "x" "y" "z" "data"
"id" "x" "y" "z" "data"
"borehole_1" 0.0 0.0 0.0 495
"borehole_1" 0.0 0.0 20.0 495
"borehole_1" 0.0 0.0 10.0 484
"borehole_1" 0.0 0.0 15.0 484
"borehole_1" 0.0 0.0 15.0 454
"borehole_1" 0.0 0.0 10.0 454
"borehole_2" 5.0 0.0 1.0 259
"borehole_2" 5.0 0.0 6.0 259
"borehole_2" 5.0 0.0 6.0 248
"borehole_2" 5.0 0.0 1.0 248
</pre>
</pre>


== Transient point data ==
== Transient Point Data ==
This creates new time series [[XY_Series_Editor|curve]] data on existing [[GMS:Feature_Objects#Points|feature points]] similar to the [[#Pumping data|Pumping data]] option above. This option is more generic than the [[#Pumping data|Pumping data]] option, however, because it will work with feature points of any type and any attribute (that can be transient) of that feature point. The imported data is matched to the existing points by name or by XY location. Data for more than one attribute can be imported at the same time. The attributes of the active coverage are listed as available fields that can be mapped.
This creates new time series [[XY_Series_Editor|curve]] data on existing [[GMS:Feature_Objects#Points|feature points]] similar to the [[GMS:File Import Wizard Supported File Formats#Pumping data|"Pumping data"]] option above. This option is more generic than the [[GMS:File Import Wizard Supported File Formats#Pumping data|"Pumping data"]] option, however, because it will work with feature points of any type and any attribute (that can be transient) of that feature point.
 
The existing points and the data being imported are matched by ''Name'' or ''ID'' or ''X'' and ''Y''. The order of precedence for these fields is ''ID'', ''Name'', then ''X'' and ''Y''.
 
Beginning with GMS version 10.1, if multiple multiple points in the coverage have the same name and the imported data are matched by ''Name'' then a new time series will be created for all of the points with that name.
 
Both ''Date'' and ''Time'' can be specified although data can be imported with only ''Date'' or only ''Time'' specified (at least one of these fields must be specified). If only the ''Date'' is specified then the time is set to 12:00:00 AM. If only ''Time'' is specified then it is assumed that date/time format is not being used and the time is treated as a relative time.
 
Data for more than one attribute can be imported at the same time. The attributes of the active coverage are listed as available fields that can be mapped.


{| class="wikitable"  
{| class="wikitable"  
Line 298: Line 412:
!Comments
!Comments
|-
|-
|<center>Name</center>||<center>Text</center>||<center>no</center>|| Either this or X and Y must be mapped.
|<center>Name</center>||<center>Text</center>||<center>No</center>|| Name or ID or X and Y must be specified.
|-
|<center>ID</center>||<center>Number</center>||<center>No</center>|| Name or ID or X and Y must be specified.
|-
|-
|<center>Date (MM/DD/YYYY)</center>||<center>Date</center>||<center>yes</center>||
|<center>Date</center>||<center>Date</center>||<center>No</center>|| Either Date or Time or both must be specified.
|-
|-
|<center>Time (HH:MM:SS)</center>||<center>Time</center>||<center>yes</center>||
|<center>Time</center>||<center>Time</center>||<center>No</center>|| Either Date or Time or both must be specified.
|-
|-
|<center>X</center>||<center>Number</center>||<center>no</center>|| Either this or Name must be mapped.
|<center>X</center>||<center>Number</center>||<center>No</center>|| Name or ID or X and Y must be specified.
|-
|-
|<center>Y</center>||<center>Number</center>||<center>no</center>|| Either this or Name must be mapped.
|<center>Y</center>||<center>Number</center>||<center>No</center>|| Name or ID or X and Y must be specified.
|-
|-
|<center>[Attribute1...]</center>||<center>Number</center>||<center>No</center>|| The value of the selected attribute at the given date/time.
|<center>[Attribute1...]</center>||<center>Number</center>||<center>No</center>|| The value of the selected attribute at the given date/time.
Line 313: Line 429:
|}
|}


{| class="wikitable"
<pre>
|+<center>'''EXAMPLE'''</center>
"id" "date" "time" "x" "y" "Flow rate"
!"name"
"well_1" 12/3/1999 18:00:00 123.5 843.2 625
!"date"
"well_1" 1/30/2000 07:38:25 123.5 843.2 0
!"time"
"well_2" 3/27/2000 18:00:00 134.2 789.4 0
!"X"
"well_2" 12/3/1999 18:00:00 134.2 789.4 100.0
!"Y"
</pre>
!"Flow rate"
|-
|"well_1"||12/3/1999||18:00:00||123.5||843.2||625
|-
|"well_1"||1/30/2000||7:38:25||123.5||843.2||0
|-
|"well_2"||3/27/2000||18:00:00||134.2||789.4||0
|-
|"well_2"||12/3/1999||18:00:00||134.2||789.4||100.0
|}


== Transient node data ==
== Transient Node Data ==
Similar to [[#Transient point data|Transient point data]] but for [[GMS:Feature_Objects#Nodes|nodes]]. Since nodes don't have names they must be matched by XY location.
Similar to [[GMS:File Import Wizard Supported File Formats#Transient point data|transient point data]] but for [[GMS:Feature Objects#Nodes|nodes]]. Since nodes don't have names they must be matched by ID or XY location.


{| class="wikitable"  
{| class="wikitable"  
Line 340: Line 446:
!Comments
!Comments
|-
|-
|<center>Date (MM/DD/YYYY)</center>||<center>Date</center>||<center>yes</center>||
|<center>ID</center>||<center>Number</center>||<center>No</center>|| Either ID or X and Y must be specified.
|-
|<center>Date</center>||<center>Date</center>||<center>No</center>|| Either Date or Time or both must be specified.
|-
|-
|<center>Time (HH:MM:SS)</center>||<center>Time</center>||<center>yes</center>||
|<center>Time</center>||<center>Time</center>||<center>No</center>|| Either Date or Time or both must be specified.
|-
|-
|<center>X</center>||<center>Number</center>||<center>yes</center>||
|<center>X</center>||<center>Number</center>||<center>No</center>|| Either ID or X and Y must be specified.
|-
|-
|<center>Y</center>||<center>Number</center>||<center>yes</center>||
|<center>Y</center>||<center>Number</center>||<center>No</center>|| Either ID or X and Y must be specified.
|-
|-
|<center>[Attribute1...]</center>||<center>Number</center>||<center>No</center>|| The value of the selected attribute at the given date/time.
|<center>[Attribute1...]</center>||<center>Number</center>||<center>No</center>|| The value of the selected attribute at the given date/time.
Line 353: Line 461:
|}
|}


== Transient arc data ==
== Transient Arc Data ==
Similar to [[#Transient point data|Transient point data]] but for [[GMS:Feature_Objects#Arcs|arcs]]. Since arcs don't have a single XY location they must be matched by name.
Similar to [[GMS:File Import Wizard Supported File Formats#Transient point data|transient point data]] but for [[GMS:Feature Objects#Arcs|arcs]]. Since arcs don't have a single XY location they must be matched by ID or name.


{| class="wikitable"  
{| class="wikitable"  
Line 362: Line 470:
!Comments
!Comments
|-
|-
|<center>Name</center>||<center>Text</center>||<center>yes</center>||
|<center>Name</center>||<center>Text</center>||<center>No</center>|| Either Name or ID must be specified.
|-
|-
|<center>Date (MM/DD/YYYY)</center>||<center>Date</center>||<center>yes</center>||
|<center>ID</center>||<center>Number</center>||<center>No</center>|| Either Name or ID must be specified.
|-
|-
|<center>Time (HH:MM:SS)</center>||<center>Time</center>||<center>yes</center>||
|<center>Date</center>||<center>Date</center>||<center>No</center>|| Either Date or Time or both must be specified.
|-
|<center>Time</center>||<center>Time</center>||<center>No</center>|| Either Date or Time or both must be specified.
|-
|-
|<center>[Attribute1...]</center>||<center>Number</center>||<center>No</center>|| The value of the selected attribute at the given date/time.
|<center>[Attribute1...]</center>||<center>Number</center>||<center>No</center>|| The value of the selected attribute at the given date/time.
Line 373: Line 483:
|}
|}


== Transient polygon data ==
== Transient Polygon Data ==
Similar to [[#Transient point data|Transient point data]] but for [[GMS:Feature_Objects#Polygons|polygons]]. Since polygons don't have a single XY location they must be matched by name.
Similar to [[GMS:File Import Wizard Supported File Formats#Transient point data|transient point data]] but for [[GMS:Feature Objects#Polygons|polygons]]. Since polygons don't have a single XY location they must be matched by ID or name.


{| class="wikitable"  
{| class="wikitable"  
Line 382: Line 492:
!Comments
!Comments
|-
|-
|<center>Name</center>||<center>Text</center>||<center>yes</center>||
|<center>Name</center>||<center>Text</center>||<center>No</center>|| Name or ID must be specified.
|-
|<center>ID</center>||<center>Number</center>||<center>No</center>|| Name or ID must be specified.
|-
|-
|<center>Date (MM/DD/YYYY)</center>||<center>Date</center>||<center>yes</center>||
|<center>Date</center>||<center>Date</center>||<center>No</center>|| Either Date or Time or both must be specified.
|-
|-
|<center>Time (HH:MM:SS)</center>||<center>Time</center>||<center>yes</center>||
|<center>Time</center>||<center>Time</center>||<center>No</center>|| Either Date or Time or both must be specified.
|-
|-
|<center>[Attribute1...]</center>||<center>Number</center>||<center>No</center>|| The value of the selected attribute at the given date/time.
|<center>[Attribute1...]</center>||<center>Number</center>||<center>No</center>|| The value of the selected attribute at the given date/time.
Line 393: Line 505:
|}
|}


== Dataset ==
Datasets can be imported from columnar text files and added to geometric objects (TINs, UGrids etc.). However text files containing datasets are not imported via the ''File'' | '''Open''' command (or pasting into the GMS window), but via the '''Import Dataset''' command found in the right-click menu of objects in the Project Explorer (objects that can have datasets). The format is similar as that of 2D or 3D scatter points as described above, but with only the dataset columns. The number of dataset values in the file must match the number of locations (points or cells) on the geometric object.
{|class="wikitable"
!Field
!Type
!Required
!Comments
|-
|<center>Dataset</center>||<center>Number</center>||<center>yes</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.
|}
===Steady State Example===
<pre>
"xylene" "toluene 0.0" "toluene 2.0"
300 999 999
84 398 401
89 47 52
207 147 134
</pre>
===Transient Example===
<pre>
"xylene|01/01/2000 00:00" "xylene|01/01/2000 12:00" "xylene|01/02/2000 00:00"
300 87 276
84 310 187
89 148 198
207 147 134
158 213 32
27 41 300
264 275 206
</pre>


{{Navbox GMS}}
{{Navbox GMS}}
[[Category:GMS General Information]]
[[Category:GMS General Information]]
[[Category:Importing Data]]
[[Category:Importing Data]]
[[Category:2D Scatter]]
[[Category:2D Scatter Point]]
[[Category:3D Scatter]]
[[Category:Boreholes]]
[[Category:MODFLOW]]

Latest revision as of 14:08, 14 May 2019


The File Import Wizard can import various types of data as described in the tables below.

2D UGrid Points

This will create new points in a new UGrid. Optionally the imported points can be filtered using the filter options available by selecting the Filter Options button.

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.

Examples

These examples can be copied and pasted into GMS.

Steady State

"x"	"y"	"xylene"	"toluene1"	"toluene2"
32.4	74.3	300	999	999
93.4	32.3	84	398	401
83.3	48.2	89	47	52
46.8	29.1	207	147	134

Transient

"x"	"y"	"xylene|01/01/2000 00:00"	"xylene|01/01/2000 12:00"	"xylene|01/02/2000 00:00"
32.4	74.3	300	87	276
93.4	32.3	84	310	187
83.3	48.2	89	148	198
46.8	29.1	207	147	134
40.3	50.1	158	213	32
60.7	52.0	27	41	300
78.7	72.9	264	275	206

3D UGrid Points

This will create new points in a new UGrid.

Field Type Required Comments
X
Number
yes
Y
Number
yes
Z
Number
yes
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.

Examples

These examples can be copied and pasted into GMS.

Steady State

"x"	"y"	"z"	"xylene"	"toluene|0.0"	"toluene|2.0"
32.4	74.3	10.1	300	87	999
93.4	32.3	25.7	84	310	187
83.3	48.2	5.3	89	148	198
46.8	29.1	-42.2	207	147	134

Transient

"x"	"y"	"z"	"xylene|01/01/2000 00:00"	"xylene|01/01/2000 12:00"	"xylene|01/02/2000 00:00"
32.4	74.3	10.1	300	387	276
93.4	32.3	25.7	84	310	187
83.3	48.2	5.3	89	148	198
46.8	29.1	-42.2	207	147	134

2D Scatter Points

This will create new scatter points in a new 2D scatter set. Optionally the imported points can be filtered using the filter options available by selecting the Filter Options button.

Field Type Required Comments
X
Number
yes
Y
Number
yes
Label
Text
no
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.

Examples

These examples can be copied and pasted into GMS.

Steady State

"id"	"x"	"y"	"xylene"	"toluene|0.0"	"toluene|2.0"
"OW-21"	32.4	74.3	300	999	999
"OW-22"	93.4	32.3	84	398	401
"OW-23"	83.3	48.2	89	47	52
"OW-24"	46.8	29.1	207	147	134

Transient

"id"	"x"	"y"	"xylene|01/01/2000 00:00"	"xylene|01/01/2000 12:00"	"xylene|01/02/2000 00:00"
"OW-21"	32.4	74.3	300	87	276
"OW-22"	93.4	32.3	84	310	187
"OW-23"	83.3	48.2	89	148	198
"OW-24"	46.8	29.1	207	147	134
"OW-25"	40.3	50.1	158	213	32
"OW-26"	60.7	52.0	27	41	300
"OW-27"	78.7	72.9	264	275	206

3D Scatter Points

This will create new scatter points in a new 3D scatter set.

Field Type Required Comments
X
Number
yes
Y
Number
yes
Z
Number
yes
Label
Text
no
Material ID
Number
no
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.

Examples

These examples can be copied and pasted into GMS.

Steady State

"id"	"x"	"y"	"z"	"xylene"	"toluene|0.0"	"toluene|2.0"
"OW-21"	32.4	74.3	10.1	300	87	999
"OW-22"	93.4	32.3	25.7	84	310	187
"OW-23"	83.3	48.2	5.3	89	148	198
"OW-24"	46.8	29.1	-42.2	207	147	134

Transient

"id"	"x"	"y"	"z"	"xylene|01/01/2000 00:00"	"xylene|01/01/2000 12:00"	"xylene|01/02/2000 00:00"
"OW-21"	32.4	74.3	10.1	300	387	276
"OW-22"	93.4	32.3	25.7	84	310	187
"OW-23"	83.3	48.2	5.3	89	148	198
"OW-24"	46.8	29.1	-42.2	207	147	134

Observation Data

This creates new feature points in the existing, active coverage. The active coverage must exist and have a steady state observation attribute (such as "Head") defined.

Field Type Required Comments
Point Name
Text
no
X
Number
yes
Y
Number
yes
Z
Number
no
Layer
Number
no
The 3D grid layer the point is associated with.
Measurement
Text
no
Measurement name. Multiple measurements allowed.
Interval
Number
no
Use Interval and Confidence, or Std. Dev. but not both.
Confidence
Number
no
Use Interval and Confidence, or Std. Dev. but not both.
Standard Deviation
Number
no
Use Interval and Confidence, or Std. Dev. but not both.

Example

"id"	"x"	"y"	"z"	"lay"	"hd"	"int"	"conf"
"OBS_Q5"	23.3	44.2	32.2	1	567.5	1.2	95
"OBS_Q6"	83.3	84.3	32.2	1	555.3	1.4	90
"OBS_Q7"	85.3	39.3	33.2	1	999	0	0

Transient Observation Data

This adds time series curves to existing points in an existing observation coverage. The targeted coverage must be the active coverage.

The existing points and the data being imported are matched by Name or ID. If both Name and ID are specified then ID will take precedence.

Both Date and Time can be specified although data can be imported with only Date or only Time specified (at least one of these fields must be specified). If only the Date is specified then the time is set to 12:00:00 AM. If only Time is specified then it is assumed that date/time format is not being used and the time is treated as a relative time.

Field Type Required Comments
Name
Text
no
Either Name or ID must be specified
ID
Text
no
Either Name or ID must be specified
Date
Date
no
Either Date or Time or both must be specified
Time
Time
no
Either Date or Time or both must be specified

Example

"id"	"date"	"time"	"head"	
"OBS_Q5"	12/3/1999	18:00:00	238.5
"OBS_Q5"	1/30/2000	07:38:25	834.7
"OBS_Q6"	3/27/2000	18:00:00	878.3
"OBS_Q6"	12/3/1999	18:00:00	733.2

Well Data

This creates new feature points in an existing coverage. The point types are set to "well" and the flow rate and other data are assigned to the points. A coverage with the Wells attribute must already exist and be the active coverage.

Field Type Required Comments
Name
Text
no
X
Number
yes
Y
Number
yes
Z
Number
no
Elevation of top of well.
Depth
Number
no
Depth to top of screen.
Screen Length
Number
no
Flow Rate
Number
no
Positive for injection, negative for extraction.

Example

"id"	"x"	"y"	"z"	"depth"	"len"	"Q"
"well_1"	123.5	843.2	62.0	51.4	6.0	120.5
"well_2"	134.2	789.4	62.8	60.7	5.4	100.3
"well_3"	147.2	678.1	61.4	110	10.0	300.5

MODFLOW Well Package Data

This text file creates new well boundary conditions in an existing MODFLOW simulation. Both steady state (one flow rate per well) or transient data (multiple flow rates at different times per well) can be imported. With transient data, multiple rows are used to list flow rates at different times (or date/times) and the Well Name field is used to associate the flow rates with the correct well. The times for changes in flow rate do not need to match the model stress period times. Flow rate curves are treated as stair step data and the rate for each stress period is found by temporal (time) interpolation. A prompt will ask if wanting to use the average flow rate for each stress period, or use the flow rate at the beginning of each stress period. Select the option that is best suited for the project.

Field Type Required Comments
Layer
Number
yes
Row
Number
yes
Column
Number
yes
Well Name
Text
yes
Any text used as the well identifier.
Flow Rate
Number
no
Positive for injection, negative for extraction.
Date
Date
no
If neither Date nor Time is specified, all stress periods will have the same Q.
Time
Time
no
Use this field for relative times (starting from 0.0), or if specifying an actual time of day (5:00) to go with the Date field. If neither Date nor Time is specified, all stress periods will have the same Q.

Example

"Layer"	"Row"	"Column"	"Rate"	"Well Name"	"Date"	"Time"
1	2	2	-502	City Well #1	Jan 1, 1940	5:00
1	2	2	-431	City Well #1	July 1, 1940	5:00
1	4	4	0	W5088341	July 1, 1940	5:00
1	4	4	-1000	W5088341	July 1, 1941	6:00

Pumping Data

This adds time series curves to existing points in an existing coverage containing wells. The targeted coverage must be the active coverage. The existing points and the data being imported are matched by name.

Field Type Required Comments
Well Name
Text
yes
Must match an existing well, or else data is ignored.
Date
Date
No
Either Date or Time or both must be specified.
Time
Time
No
Either Date or Time or both must be specified.
Flow Rate
Number
yes
Positive for injection, negative for extraction.
Depth
Number
no
Depth to top of screen.
Screen Length
Number
no

Example

"id"	"date"	"time"	"Q"	
"well_1"	12/3/1999	18:00:00	625.0
"well_1"	1/30/2000	07:38:25	0
"well_2"	12/3/1999	18:00:00	0
"well_2"	3/3/2000	14:48:32	100.0

Borehole Data

This creates new boreholes. Optionally, a borehole folder name can be specified to organize the imported boreholes.

Field Type Required Comments
Borehole Name
Text
yes
X
Number
yes
X location of the contact.
Y
Number
yes
Y location of the contact.
Z
Number
yes
Z location of the contact.
HGU ID
Number
yes
HGU Material below the contact
Material ID
Number
no
Material below the contact.
Horizon ID
Number
no
Description
Text
no
Description of the material (usually from drilling report).
"id"	"x"	"y"	"z"	"material"	"horizon"
"borehole_1"	0.0	0.0	0.0	3	1
"borehole_1"	0.0	0.0	10.0	1	2
"borehole_1"	0.0	0.0	15.0	6	4
"borehole_2"	5.0	0.0	1.0	2	3
"borehole_2"	5.0	0.0	6.0	2	4

Borehole Sample Data

This creates new sample data on existing boreholes, or new sample data on new boreholes if no boreholes with matching names exist. All existing sample data is replaced with that being imported.

Field Type Required Comments
Name
Text
yes
New Borehole Name
X
Number
yes
X location of the borehole.
Y
Number
yes
Y location of the borehole.
Z
Number
yes
Z location of the borehole, in descending order, top to bottom.
Dataset
Number
yes
"id"	"x"	"y"	"z"	"data"
"borehole_1"	0.0	0.0	20.0	495
"borehole_1"	0.0	0.0	15.0	484
"borehole_1"	0.0	0.0	10.0	454
"borehole_2"	5.0	0.0	6.0	259
"borehole_2"	5.0	0.0	1.0	248

Transient Point Data

This creates new time series curve data on existing feature points similar to the "Pumping data" option above. This option is more generic than the "Pumping data" option, however, because it will work with feature points of any type and any attribute (that can be transient) of that feature point.

The existing points and the data being imported are matched by Name or ID or X and Y. The order of precedence for these fields is ID, Name, then X and Y.

Beginning with GMS version 10.1, if multiple multiple points in the coverage have the same name and the imported data are matched by Name then a new time series will be created for all of the points with that name.

Both Date and Time can be specified although data can be imported with only Date or only Time specified (at least one of these fields must be specified). If only the Date is specified then the time is set to 12:00:00 AM. If only Time is specified then it is assumed that date/time format is not being used and the time is treated as a relative time.

Data for more than one attribute can be imported at the same time. The attributes of the active coverage are listed as available fields that can be mapped.

Field Type Required Comments
Name
Text
No
Name or ID or X and Y must be specified.
ID
Number
No
Name or ID or X and Y must be specified.
Date
Date
No
Either Date or Time or both must be specified.
Time
Time
No
Either Date or Time or both must be specified.
X
Number
No
Name or ID or X and Y must be specified.
Y
Number
No
Name or ID or X and Y must be specified.
[Attribute1...]
Number
No
The value of the selected attribute at the given date/time.
[AttributeN]
Number
No
The value of the selected attribute at the given date/time.
"id"	"date"	"time"	"x"	"y"	"Flow rate"
"well_1"	12/3/1999	18:00:00	123.5	843.2	625
"well_1"	1/30/2000	07:38:25	123.5	843.2	0
"well_2"	3/27/2000	18:00:00	134.2	789.4	0
"well_2"	12/3/1999	18:00:00	134.2	789.4	100.0

Transient Node Data

Similar to transient point data but for nodes. Since nodes don't have names they must be matched by ID or XY location.

Field Type Required Comments
ID
Number
No
Either ID or X and Y must be specified.
Date
Date
No
Either Date or Time or both must be specified.
Time
Time
No
Either Date or Time or both must be specified.
X
Number
No
Either ID or X and Y must be specified.
Y
Number
No
Either ID or X and Y must be specified.
[Attribute1...]
Number
No
The value of the selected attribute at the given date/time.
[AttributeN]
Number
No
The value of the selected attribute at the given date/time.

Transient Arc Data

Similar to transient point data but for arcs. Since arcs don't have a single XY location they must be matched by ID or name.

Field Type Required Comments
Name
Text
No
Either Name or ID must be specified.
ID
Number
No
Either Name or ID must be specified.
Date
Date
No
Either Date or Time or both must be specified.
Time
Time
No
Either Date or Time or both must be specified.
[Attribute1...]
Number
No
The value of the selected attribute at the given date/time.
[AttributeN]
Number
No
The value of the selected attribute at the given date/time.

Transient Polygon Data

Similar to transient point data but for polygons. Since polygons don't have a single XY location they must be matched by ID or name.

Field Type Required Comments
Name
Text
No
Name or ID must be specified.
ID
Number
No
Name or ID must be specified.
Date
Date
No
Either Date or Time or both must be specified.
Time
Time
No
Either Date or Time or both must be specified.
[Attribute1...]
Number
No
The value of the selected attribute at the given date/time.
[AttributeN]
Number
No
The value of the selected attribute at the given date/time.

Dataset

Datasets can be imported from columnar text files and added to geometric objects (TINs, UGrids etc.). However text files containing datasets are not imported via the File | Open command (or pasting into the GMS window), but via the Import Dataset command found in the right-click menu of objects in the Project Explorer (objects that can have datasets). The format is similar as that of 2D or 3D scatter points as described above, but with only the dataset columns. The number of dataset values in the file must match the number of locations (points or cells) on the geometric object.

Field Type Required Comments
Dataset
Number
yes
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.

Steady State Example

"xylene"	"toluene 0.0"	"toluene 2.0"
300	999	999
84	398	401
89	47	52
207	147	134

Transient Example

"xylene|01/01/2000 00:00"	"xylene|01/01/2000 12:00"	"xylene|01/02/2000 00:00"
300	87	276
84	310	187
89	148	198
207	147	134
158	213	32
27	41	300
264	275	206