Phone : 0800 470 3410

GeoEnviron FAQs

    CONTAMINATED LAND INVESTIGATION (PART 2A) SUB-MODULE FAQs

CONTAMINATED LAND PLANNING (ENFORCEMENT) SUB-MODULE FAQs

DOCUMENT MANAGEMENT FAQs

ENVIRONMENTAL PERMITS MODULE FAQs

2

It’s another option to generate multiple inspections, as you do in the Risk Assessment tab.

3

Put your cursor in the CO field and enter the initials of the new CO or press Alt+L.

FLOOD ASSETS MODULE

1

  • Find your asset and then navigate to the Inspections tab
  • Click the Generate New button.
  • Enter Case Officer, Interval (i.e. frequency in months), Last Date and Inspection Type
  • Add any comments about the inspection
  • Click OK

Watch Video

2

  1. Go to Basetables > Common Basetable > Case Management or alternatively double click on the name part of the Asset Type field in the Flood Assets module.
  2. Select the Asset Types tab
  3. Click the insert button to add a new asset type record
  4. Enter the Structure Type - link, node or polygon
  5. Enter an ID for the type and then enter a name for the asset type
  6. Click update to save your edits.
  7. The new asset type should now be available for selection in the Flood Assets Module.
 

Watch Video

GENERAL FUNCTIONALITY FAQs

1

The Audit logger in GeoEnviron keeps a record of all SQL transactions undertaken in the database.

  1. First you need to turn on the Activity Logging feature. This is done in the "Common Settings tab" which is accessible via the main menu  - System Adm > Settings > Initialisation Settings". You will need to log on as the Import user or dbo to be able to access this tab.
  2. Once in the Common Settings tab,  click on "Log" and insert "yes" in the Logging Active and Show Log text fields and click Update.log
  3. Restart GeoEnviron. You should see a new tool on the toolbar called Audit Log. Click this to open the Audit Log window.
  4. You can filter the list of transactions using the date field.
 

2

Log into GeoEnviron as a user with system admin permissions. You can use the import account if in doubt. Navigate to the Case Officer Base Table via the main menu (Base Tables >  Common Base Tables > Main) and select the "Other" followed by the "Case Officer" tabs. Find the relevant Case Officer and  fill out the "Alias" field in the Case Officer basetable so that the system knows who he is. On the top left of the program title bar you will see the alias that the system allocates to the user . This needs to be entered into the "Alias" field as shown below. It would be a good idea to also do this for all the other case officers. Once you have done this you should tick the "Sys.mgr" checkbox and click update. The user will now be able to reopen cases. reopenCC    

3

When you do a mail merge in GeoEnviron, the system creates a DAT file which contains the information to be merged into the Word document. The DAT file is saved in same location as the merged documents with the name of the user that created it (i.e. dbo.DAT) The problem may be that you are not being allowed to overwrite the DAT file.

  1. Check that you have full permissions to the merge folder. You can find the path to the folder under “Basetables > Common Basetables > Case Management > Parameters”. The path will be in the Document Path field.
  2. Check to ensure that multiple users are not logging into the database using the same login credentials (i.e. as the import user) and then trying to mail merge. This could give read/write conflicts on the file.
  3. If none of the above are issues then call STM and we can try troubleshooting using web conferencing.

4

When the new website was launched in September 2016, all the online help files were moved to a new server. Therefore your links to the online help in GeoEnviron will need to be updated. Follow the instructions below in order to do this.

  1. Download the patch from the following  from here: https://www.stmenvironmental.co.uk/Downloads/app_settings_FixOnlineHelp.zip
  2. Extract the zip file
  3. Logon to GeoEnviron as Super User (Import)
  4. Navigate to System Admin>Import/Export Data>Import to Table
  5. Click on the “Execute SQL” and navigate to the location where you downloaded the file.
  6. Select the file and click “Open”.
  7. The patch should execute. If a dialog appears requesting you to select the file again, just click cancel.
  8. Check to see that the links to the manuals are working again.

5

This is to do with registry settings. to fix follow steps below (you will need admin permissions:

  • Go in under the following key: HKEY_CLASSES_ROOT\jpegfile\shell\open\command
  • Change the default path to the chosen image viewer program so that it is the actual path as shown in the image below (i.e. remove any “%SystemRoot%” and “%Programfiles”) and try it again.

14

You can find out the name of a field by right clicking in it and selecting "Properties" from the context menu. The "Column Name" tells you the name of the table and the name of the column you have clicked in.

GEOENVIRON ARCGIS INTEGRATION FAQs

1

The extension is trying to access the GeoDatabase and is unable to.

  1. In ArcGIS, on the GeoEnviron ArcGIS integration menu select 'GeoEnviron Database Administration'.
  2. Check the file location of the database.
  3. Check that the folder/location is accessible in File Explorer.
  4. Check that you have permission to access the file location (locate the folder containing the database, select 'properties' > 'security', and make sure that 'Full Control' is ticked).
  5. If you do not have 'Full Control' over the file location then you will need your system administrator to grant you access.

GEOMAP GIS FAQs

INSTALLATION TROUBLESHOOTING

1

Nothing happens when you try to retrieve a record in GeoEnviron  using the GeoEnviron Lookup (Retrieve) tool  in the GIS (i.e. MapEagle, ArcMap). The issue is likely to do with one of the GIS protocols (geoenvir_url.exe) not being registered correctly. Follow the steps below to resolve this.  

  • 1) Open the STM Installer
  • 2) Click on the "Additional Options" button.
  • 3) Select the "Register GeoEnviron GIS Protocol" button.
  • 4) Click "Yes" when asked if you wish to continue
  • 5)If the system is able to find the protocol, it will register it and let you know that the registration has been successful. You can then close the Installer and try using the Lookup tool again.
  • 6) If it is not able  find the protocol, it will request you to navigate to its location. It is normally located in the GeoEnviron program installation folder (i.e. C:\Program Files (x86)\GeoEnviron 9\ geoenvir_url.exe).
  • 7) Following successful registration, you can close the Installer  and try using the Lookup tool again.

2

Check the following on setting on the database:

  • Log into the database as the super user (import)
  • On the GeoEnviron menu navigate to “System Adm> Settings > Initialisation Settings”
  • In the “Common Settings” tab, under the Key column, find the “External GIS System” setting
  • Check the value field next is blank as in the image below. If it is not blank, delete the entry and click the Update button. Restart the application for the changes to take effect.

QGIS INTEGRATION FAQs

1

First you  have to add the tables you are interested in to the project. You can do this via the Layer > Add Layer > Add MSSQL Spatial Layer. Click the Connect  button if you already have a connection set up. If not set up a connection to the GeoEnviron database. Next tick the “Also list tables with no geometry” checkbox and under the “dbo” dropdown you should see a list of all the tables displayed. You can then select the table to add to the project either by double clicking on it or selecting it and clicking the Add button. Once the table has been added to the project, you can join to it in the same way as has been done for the site table. You can find out the name of the relevant table in GeoEnviron by right clicking in one of the fields within the relevant tab (i.e. Case Details) and selecting the Properties option on the dropdown list. This should display a Column Properties dialog . The Column Name field contains the table name and the field name.      

MapEagle (MapInfo) FAQs

1

The template is linked when you run the report. After it has done the buffer selections it brings up a dialog which allows you to browse to the location of the template and then it remembers the location thereafter. In order to invoke this functionality you just need to ensure the "Use Word Template" checkbox is ticked in the Data Output Settings dialog which is accessible via a right click on the map.

2

This usually occurs if you save an existing geoset which contains GeoEnviron layers under another name but choose not to copy the settings from the previous geoset into the new one. It can also occur if you load GeoEnviron layers that you created previously in another Geoset to a new geoset. Essentially you need to register meta data information about the layer (i.e. which module it is linked to, the SQL to be used for updating feature attributes, which mapsheet the coordinates are saved under etc) for each project. You can do this under the menu ”External Data>GeoEnviron>Register Layer”.

3

You can set up a new project by saving (Use the Save As option)the geoset under a different name. This will give you a new blank template. When saving you will be asked if you want to copy the settings from the previous geoset so you do not have to start setting up the template from scratch.

MapEagle (Arcmap) FAQs

    Functionality

Troubleshooting FAQs

1

NB. The project that you are importing the settings to needs to have the same name as the project that you exported the settings from.

Watch Video

2

It is a good idea to back up your settings for your projects just in case the unforseen happens. Again you may wish to transfer or copy the settings from one PC to another. See the attached video to find out how.

Watch Video