Page History

----

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.

...

1. Remove the example rows (if any) such that the row 40 is the first one containing the actual data
2. Populate column I (OSreference) based on NGR (Easting, Northing) of borehole (column K and L).
3. Check that column A,B,C,D are populated in correspondence to the provided runs (ModuleDataSets)
4. Check that the number of locations/licences as listed in the spreadsheet corresponds (at least) to the number of wells in each WEL-file
5. Define concatenate functions for cell B16, B17, B18, B19, B21, B22. The actual contents depends on data availability.
6. Verify that the column(s) as used for the concatenate functions are properly populated with appropriate information (i.e. preferably no empty cells, 'unknowns, 'na' etc.). If necessary apply an 'IF-construction on the concatenate function. This verification is especially critical for columns being used in location names.

   Info

   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   <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="da2f4724f8217c6e-486aa1f9-492f4620-b4d9ae22-3760e9a844df0dc993d6d3d0"><ac:plain-text-body><![CDATA[ B18 LocationDescription Description in Explorer-tooltip location type, GW-unit, Formation =T40 & " modelled at ("&M40&", "&N40&") [R"&p40&", C"&q40&"] in GW-unit " & W40 & " ("&X40&") from " & Y40 &" formation." ]]></ac:plain-text-body></ac:structured-macro> 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&") located at NGR ("&K40&",  &L40& "), "&P40&", Column: "&Q40&", Layer: "&O40&" 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

...

1. Remove the example rows (if any) such that the row 36 is the first one containing the actual data
2. Populate column D (OSreference) based on XY-coordinate of the associated grid cell (column H and I).
3. Define concatenate functions for cell B14, B15, B16, B17, B19, B20. The actual contents depends on data availability.
4. Verify that the column(s) as used for the concatenate functions are properly populated with appropriate information (i.e. preferably no empty cells, 'unknowns, 'na' etc.). If necessary apply an 'IF-construction on the concatenate function. This verification is especially critical for columns being used in location names.
5. Verify that observation locations do not refer to layer numbers which are not supported by the model. Data mapping is done on a model layer basis. Hence, an observation in layer 0 will not receive information if the model contains layer 1-3.

   Info

   Expand Expand recommended concatenations Expand recommended concatenations cell item used in recommended content recommended concatenate function B14 LocationName Explorer (map and filter) site name & site code (optional layer) =N36&" - "&C36 B15 ShortName Graph legends if possible shorter version of above   <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="abdc2ece268e4c30-672691a3-4e764ed9-8009a215-2be0778e29798bccd7d44b48"><ac:plain-text-body><![CDATA[ B16 LocationDescription Description in Explorer-tooltip location type, GW-unit, Formation =O36 & " modelled at ("&H36&", "&I36&") [R"&K36&", C"&L36&") in GW-unit " & P36 & " ("&Q36&") from " & R36 &" formation." ]]></ac:plain-text-body></ac:structured-macro> B17 Tooltip on map free text Explorer-tooltip borehole details (if any), NGR, model coordinates (XYZ and RC) ="BH top: "&U36&" mAOD, base: "&V36&" mAOD, located at NGR ("&F36&", "&G36&"), "&K36&", Column: "&L36&", Layer: "&J36&" B19 Caption Shortcuts in GraphDisplay see shortname or variations see shortname or variations B20 Shortcut Shortcuts in GraphDisplay see shortname or variations see shortname or variations

...

1. Remove the example rows (if any) such that the row 37 is the first one containing the actual data
2. Populate column L (OSreference) based on the NGR-coordinate of the discharge or abstraction point (column N and O).
3. Define concatenate functions for cell B14, B15, B16, B17, B19, B20. The actual contents depends on data availability.
4. Verify that the column(s) as used for the concatenate functions are properly populated with appropriate information (i.e. preferably no empty cells, 'unknowns, 'na' etc.). If necessary apply an 'IF-construction on the concatenate function. This verification is especially critical for columns being used in location names. Image Modified

...