| scrollbar |
|---|
...
----
...
| Expand | ||||
|---|---|---|---|---|
| ||||
|
Within FEWS, and thus NGMS, locations are essential as they are the placeholder to all model inputs and output.
The locations concept and the application within NGMS is described in a seperate page.
One of the most time consuming and error prone parts of the system is setting up those locations and ensuring that the Ids of observation data and model data, as defined in the WEL and STR files, match the licences and or gauging stations. To assist in this process, a standard data template has been produced for specyfying the locations, as well as an locations-generator spreadsheet which automates the process of sorting, IdMapping and XML-file generation.
...
Step 5.1 Check table structure of all worksheets in Data spreadsheet handed over
Go to #Step 5.2. Grids_loc
The starting condition of this step is a populated DataTemplate, which contains all relevant information for the model.
When running the NGMS_Locations_Generator, it will pick up this spreadsheet, conduct a variety of checks and sorts all locations in the appropriate order. For this purpose, the Generator uses hard-coded references to named worksheets and specific columns within a worksheet. To prevent failure in this processing, the following checks the need to be conducted on the table structure of the populated DataTemplate.
The comparison is done against the Empty_DataTemplate spreadsheet.
- worksheet GWabs_org
- ensure that no more than 4 runs are listed (column A-D), as the IdMapping can currently handle 4 runs only
Note: If more than 4 runs are to be processed, use a second spreadsheet and fill column A-D with the line numbers of the wells in those runs. Please ensure that both spreadsheets contain the same locations. - ensure that LicenceNo starts in column F (i.e. C6)
- ensure that no more than 4 runs are listed (column A-D), as the IdMapping can currently handle 4 runs only
- worksheet SWlat_org
- See above: ensure that no more than 4 runs are listed (column A-D), as the IdMapping can currently handle 4 runs only
Note: If more than 4 runs are to be processed, use a second spreadsheet and fill column A-D with the line numbers of the wells in those runs. Please ensure that both spreadsheets contain the same locations. - ensure that ConsentNo/LicenceNo starts in column I (i.e. C9).
- See above: ensure that no more than 4 runs are listed (column A-D), as the IdMapping can currently handle 4 runs only
- worksheet Branches_org
- check if reachNr is in column C (C3); chainage is in column D (C4), OSRef is in column J (C10)
- if not, copy the worksheet from teh Empty_DataTemplate and popualte again
or - add column D and column J from the Empty_DataTemplate.xls
- worksheet GWabs_IDmap_hist; GWabs_IDmap_nat; GWabs_IDmap_recact; GWabs_IDmap_fullic
- if not available, copy all 4 from Empty_DataTemplate
- worksheet SWlat_IDmap_hist; SWlat_IDmap_nat; SWlat_IDmap_recact; SWlat_IDmap_fullic
- if not available, copy all 4 from Empty_DataTemplate
The DataTemplate contains one macro, called 'CheckData' which checks if the essential data is in place. While the details will be addressed in the various steps below, most errors are caused if abovementioned steps are not properly conducted or if the OSreference column is empty. An OSreference column with empty or 'na' is not acceptable as this column is the key for creating a unique locationId
| Anchor | ||||
|---|---|---|---|---|
|
Step 5.2 Create and populate worksheets for Grids: Grids_loc and Grids_locSets
Go to #Step 5.3. GW management units
The worksheets Grids_loc and Grids_locSets are manually prepared. They specify the grid geometry and associated location sets as used in the data processing.
| Anchor | ||||
|---|---|---|---|---|
|
Step 5.3 Create and populate worksheet for GW management units: GWunits_loc and GWunits_locSets
Go to #Step 5.4. GW abstractions
The worksheets GWunits_loc and GWunits_locSets are manually prepared. They specify the predefined GWMUs (groundwater management units) and associated location sets as used in the data processing.
| Anchor | ||||
|---|---|---|---|---|
|
Step 5.4 Populate and verify worksheet for groundwater abstractions: GWabs_org
Go to #Step 5.5. Observation boreholes
The worksheet GWabs_org is populated by the data provider.
Notes on the use of columns:
- The sorting macro contains hard-coded column references. It is therefore essential that column E is empty and column F holds the LicenceNo. One may not list more than 4 WEL files in the first 4 columns. If more WEL-files need to be accounted for, is recommended to create a second spreadsheet (see details #More than four runs provided).
- The XY-position of the NGR will be adopted as the XY-coordinate of the point location for this borehole. Taking this position over the actual NGR-coordinate ensures that the interpolation from grid cell to OBH - using the closest distance method - will be in line with the way the model has been set up.
- The NGR-coordinates are typically displayed in the tooltip.
- The OSreference will be used for the unique identifier of each abstraction. It is essential that this OSreference is based on the NGR coordinate.
Please conduct the following verification and preparation steps:
- Remove the example rows (if any) such that the row 40 is the first one containing the actual data
- Define concatenate functions for cell B16, B17, B18, B19, B21, B22. The actual contents depends on data availability.
Expand Expand recommended concatenations with max. 4 WEL files Expand recommended concatenations with max. 4 WEL files cell
item
used in
recommended content
recommended concatenate function
B16
LocationName
Explorer (map and filter)
licence code, purpose code (if any), site name, layer
=IF(O40<>"";F40&"
...
"&G40&"
...
-
...
"&S40&"
...
(L"&O40&")";F40&"
...
"&G40&"
...
-
...
"&S40)
...
B17
...
ShortName
...
Graph
...
legends
...
if
...
possible
...
shorter
...
version
...
of
...
above
Â
B18
LocationDescription
Description in Explorer-tooltip
...
location
...
type,
...
GW-unit,
...
Formation
...
=T40
...
&
...
"
...
in
...
GW-unit
...
"
...
&
...
W40
...
&
...
"
...
("&X40&")
...
from
...
"
...
&
...
Y40
...
&"
...
formation."
...
B19
...
Tooltip
...
on
...
map
...
free
...
text
...
Explorer-tooltip
...
licence
...
holder,
...
licence
...
details,
...
NGR,
...
model
...
coordinates
...
(XYZ
...
and
...
RC)
...
=IF(U40="";"";"Licence
...
holder:
...
"
...
&U40
...
&
...
"
...
("
...
&F40
...
&
...
"
...
-
...
"&G40&")\n
...
")&
...
"Easting:
...
"&K40&",
...
Northing:
...
"
...
&L40&
...
"
...
...
...
...
...
...
...
...
...
...
"
...
B21
...
Caption
...
Shortcuts
...
in
...
GraphDisplay
...
see
...
shortname
...
or
...
variations
...
see
...
shortname
...
or
...
variations
...
B22
Shortcut
Shortcuts in GraphDisplay
see shortname or variations
see shortname or variations
- Populate column I (OSreference) based on XY-coordinate of borehole (column K and L).
Go to: How to derive OSreference coordinate from kilometer based coordinates - Check that column A,B,C,D
...
- are
...
- populated
...
- in
...
- correspondence
...
- to
...
- the
...
- provided
...
- runs
...
- (ModuleDataSets)
...
- Check
...
- that
...
- the
...
- number
...
- of
...
- locations/licences
...
- as
...
- listed
...
- in
...
- the
...
- spreadsheet
...
- corresponds
...
- (at
...
- least)
...
- to
...
- the
...
- number
...
- of
...
- wells
...
- in
...
- each
...
- WEL-file
...
| Anchor | ||||
|---|---|---|---|---|
|
If the table accounts for more than 4 WEL files (i.e.
...
column
...
E
...
and
...
possibly
...
F
...
are
...
used
...
to
...
hold
...
line
...
numbers
...
as
...
well),
...
one
...
should
...
do
...
the
...
following
...
steps:
...
- create
...
- a
...
- copy
...
- of
...
- the
...
- spreadsheet
...
- remove
...
- the
...
- additional
...
- columns
...
- from
...
- the
...
- 'original'
...
- spreadsheet
...
| Anchor | ||
|---|---|---|
|
...
|
...
|
Step 5.5
...
Populate
...
and
...
verify
...
worksheet
...
for
...
observation
...
boreholes:
...
OBH_org
...
Go
...
to
...
...
...
...
The
...
worksheet
...
OBH_org
...
is
...
populated
...
by
...
the
...
data
...
provider.
...
Notes
...
on
...
the
...
use
...
of
...
columns:
...
- The
...
- XY-position
...
- of
...
- the
...
- grid
...
- cell
...
- will
...
- be
...
- adopted
...
- as
...
- the
...
- XY-coordinate
...
- of
...
- the
...
- point
...
- location
...
- for
...
- this
...
- borehole.
...
- Taking
...
- this
...
- position
...
- over
...
- the
...
- actual
...
- NGR-coordinate
...
- will
...
- ensures
...
- that
...
- the
...
- interpolation
...
- from
...
- gridcell
...
- to
...
- OBH
...
- -
...
- using
...
- the
...
- closest
...
- distance
...
- method
...
- -
...
- will
...
- be
...
- in
...
- line
...
- with
...
- the
...
- way
...
- that
...
- the
...
- model
...
- has
...
- been
...
- set
...
- up.
...
Note
...
- the
...
- difference
...
- with
...
- column
...
- usage
...
- for
...
- the
...
- GW
...
- abstraction
...
- points.
...
- The
...
- NGR-coordinates
...
- are
...
- typically
...
- displayed
...
- in
...
- the
...
- tooltip.
...
- The
...
- OSreference
...
- will
...
- be
...
- used
...
- for
...
- the
...
- unique
...
- identifier
...
- of
...
- each
...
- borehole.
...
- It
...
- is
...
- recommended,
...
- but
...
- not
...
- required,
...
- to
...
- convert
...
- the
...
- gridcell
...
- position
...
- to
...
- Osreference.
...
- In
...
- any
...
- case,
...
- please
...
- document
...
- properly
...
- what
...
- coordinate
...
- has
...
- been
...
- used
...
- for
...
- this
...
- purpose.
...
The
...
following
...
steps
...
should
...
be
...
conducted
...
to
...
prepare
...
and
...
verify
...
the
...
data
...
provided:
...
- ensure
...
- that
...
- the
...
- OSreference
...
- column
...
- is
...
- populated
...
- (how
...
- to)
...
- as
...
- this
...
- column
...
- will
...
- provide
...
- the
...
- key
...
- for
...
- unique
...
- identification
...
- ensure
...
- that
...
- the
...
- NGR-coordinates
...
- are
...
- given
...
- in
...
- kilometers
...
- as
...
- this
...
- determines
...
| Anchor |
|---|
...
|
...
|
...
|
Step 5.6
...
Populate
...
and
...
verify
...
worksheet
...
for
...
gauging
...
stations:
...
Gauges_org
...
Go
...
to
...
...
...
...
...
The
...
worksheet
...
Gauges_org
...
is
...
populated
...
by
...
the
...
data
...
provider.
...
| Anchor |
|---|
...
|
...
|
...
|
...
|
Step 5.7
...
Populate
...
and
...
verify
...
worksheet
...
for
...
SW
...
laterals
...
(discharges
...
and
...
abstractions):
...
SWlat_org
...
Go
...
to
...
...
...
...
The
...
worksheet
...
SWlats_org
...
is
...
populated
...
by
...
the
...
data
...
provider.
...
| Anchor |
|---|
...
|
...
|
...
|
Step 5.8
...
Populate
...
and
...
verify
...
worksheet
...
for
...
river
...
branches:
...
Branches_org
...
Go
...
to
...
...
...
...
...
...
...
The
...
worksheet
...
Branches_org
...
is
...
populated
...
by
...
the
...
data
...
provider.
...
| Anchor |
|---|
...
|
...
|
...
|
...
|
...
|
...
|
Step 5.9
...
Populate
...
and
...
verify
...
worksheets
...
with
...
IdMap
...
data
...
for
...
GW
...
abstractions:
...
GWabs_IDMap
...
(4
...
worksheets)
...
Go
...
to
...
...
...
...
...
...
...
The
...
worksheets
...
need
...
to
...
be
...
populated
...
with
...
results
...
from
...
step
...
4.
...
| Anchor |
|---|
...
|
...
|
...
|
...
|
...
|
...
|
Step 5.10
...
Populate
...
and
...
verify
...
worksheets
...
for
...
SW
...
laterals:
...
SWlat_IDMap
...
(4
...
worksheets)
...
Go
...
to
...
...
...
...
...
...
The
...
worksheets
...
need
...
to
...
be
...
populated
...
with
...
results
...
from
...
step
...
4.
...
| Anchor |
|---|
...
|
...
|
...
|
...
|
...
|
...
|
Step 5.11
...
Generate
...
Location
...
XML-files
...
Go
...
to
...
...
...
...
...
...
If
...
everything
...
is
...
ready,
...
- create
...
- a
...
- backup
...
- run
...
- macro
...
- x
...
- inspect
...
- results
...
- create
...
- XML
...
- files
...
| Anchor |
|---|
...
|
...
|
...
|
...
|
...
|
Step 5.12
...
Update
...
Grids.XML
...
file
...
the
...
Grids.xml
...
file
...
needs
...
to
...
be
...
update
...
with
...
some
...
data
...
from
...
step
...
4.