Tool Location: Locations > Location Explorer
Two forms are used to work with location properties. The Location Explorer form is used to search and filter for specific locations in the database, and the Location Editor form which is used to view and edit information about monitoring locations and intervals. The Location Editor form can only be accessed through the Location Explorer form.
The first form (the search form) is used to find the location (or locations) for which you wish to do something with (e.g. view available chemistry). The left hand side of the form contains all the searchable criteria. The vertical scroll bar directly to the right of the Location Search Criteria can be used to view additional searching options (see screenshot below). One or more search criteria can be used simultaneously while searching.
The buttons in the lower left can be used to perform the search or reset the form. By default, only the top 500 records will be returned when searching. The user can change this at the bottom of the search criteria section (scroll to bottom).
The middle of the form shows the search results. The search results for locations can be sorted ascending or descending by double clicking anywhere in desired column. The results can be sorted by more than one column at a time by holding down the CTRL key while clicking on the 2nd, 3rd, etc column headings. The vertical scroll bar at the far right of the search results can be used to scroll through the results. Note that in the middle section there are 2 tabs. Users can choose to view Locations or Intervals that meet their search criteria.
Once one or more locations (or intervals) are selected, the options at the far right can be used.
All options selected under the Location Search Criteria can be saved so that they can be easily recalled in the future. Management of saved criteria is handled under the Options section at the far right of the form under the heading Saved Search Criteria.
Location Search Criteria
Allows user to search for locations and intervals using a variety of criteria. One or more criteria can be used simultaneously.
Displays the results of the search. Selecting one of these locations (by double clicking on it) will bring up the Location Editor.
Once search criteria are entered, pressing this button will begin the search.
Show All Button
Returns all locations in the linked data database to the Search Results list box.
Resets the form for a new search by removing all search criteria.
1. Enter one or more criteria button on the left side of the form (eg. in the Loc Name box). Or, if only a few locations exist, skip this step and don’t enter any criteria at all.
2. Press the Search button.
3. Sort the list by clicking the column heading of choice. Remember, additional columns can be sorted at the same time by holding the CTRL key down while clicking the 2nd, 3rd, etc column heading..
4. Bring up the Location Editor by double clicking on one of the locations from the list or by pressing the Location Editor button at the far right.
OPG REMP Notes
EarthFX has already pre-configured some custom views for REMP users. Please feel free to contact EarthFX directly for additional custom views or edits to existing custom views.
The Custom Views option is one of the sections under the search options at the far left of the Location Explorer. Custom Views allow you to show columns in the search results other than the ones shown by default. This portion of the form is shown below.
The checkboxes can be used to turn on or off some of the main columns used by SiteFX users. For user’s that are familiar with building database queries, the dropdown list expands the display capabilities endlessly. Users can create custom queries (with or without criteria) in their own database and SiteFX will use those queries to display the results.
In order to use custom queries you must use a special naming convention. For example, assume you wanted to show the coordinates for your locations in the Location Explorer. First, you could create the following query in your Access database.
Note – SQL Server users would create an Access database first that connects back to SQL Server (and connect SiteFX to that Access database). This allows users to use the Access query builder to develop queries. SiteFX will automatically pass the query through to SQL Server for optimal results.
The above query simple pulls out four columns from the main database table (called D_LOCATION). The four columns are LOC_ID, LOC_NAME, LOC_COORD_EASTING and LOC_COORD_NORTHING. Note that the query has been set up to use ‘user friendly’ words instead of the database field names. Also note that the Easting and Northing have been formatted so that no decimals are shown.
Next the query needs to be saved with a special name that can be recognized by SiteFX:
For Locations, use the prefix: SiteFX_SearchLoc_
For Intervals, use the prefix: SiteFX_SearchInt_
You can follow the prefix with any words you like and these words will show up in SiteFX. For example, the full query name for the above example is “SiteFX_SearchLoc_Eastings and Northings”. Note that spaces are allowed.
In order for the query to show up in SiteFX you must open the Location Explorer form. If it is already open, close it and then re-open it. SiteFX only checks for custom queries when the Location Explorer is opened. In the current example, the new query is shown in the drop down list below.
Finally, once the custom query name has been selected, the user can use the other search options on the form to further filter the results. See below for the end result.
· The custom query must have LOC_ID or INT_ID as the first field (depending on whether you are building or location or interval custom query)
· The prefix must be either ‘SiteFX_SearchLoc_’ or ‘SiteFX_SearchInt_’ but the suffix can be the same in the case that you want to have a common filter name that applies to both locations and intervals.
· You can specify custom criteria in your custom queries thereby creating a filter if you wish.
· For SQL Server users, the query can be a pass-through query if required. Note that SiteFX will attempt to automatically turn non-pass-through queries into pass-through queries.
· For SQL Server users, if you have a local Access table that is not part of your SQL Server database, and this table is part of your custom query, SiteFX will attempt to link SQL Server to your local database so that the custom query can be executed.
· Some very complex queries cannot be handled by this feature.
The Location Explorer can also be used to create groups of locations and/or intervals. Grouping by this method allows the same location (or interval) to be part of more than one group. Once groups have been created, you can use them throughout SiteFX to quickly jump to your desired group of locations or intervals.
For groups that have already been created, you can access them in the Location Explorer by selecting from the drop down lists on the left hand side of the form. See the screenshot below for the location of these lists.
In order to build groups, you must turn on grouping mode. The Build Group button is located on the right hand side of the Location Explorer. See the screenshot below for these functions.
When a checkmark is placed in the Build Group checkbox, the form enters group building mode. This mode allows you to add, delete and rename groups. When in this mode a separate data grid appears in the lower section of the form which lists all locations or intervals in the currently selected group. You can move locations or intervals into or out of the selected group by using the two buttons that appear directly above the lower grid. See screenshot below.
Note: when you have the Location tab active at the top of the Location Explorer, you will create a Location Group. When the Interval tab is active, you will create an Interval group.
The buttons in the Build Group area of the form provide the following functions:
Add – add group
Del – delete group
Ren – renamed group
Rev – review groups
When you are finished creating or editing your group, remove the checkmark from the Build Group checkbox. This returns the form to normal search mode. You can now use the dropdown lists from the left hand side of the form to quickly select your groups.