Fix missing Layers if using an alternative name for your geometry column

Owned by Gavin Kelly, created
Last updated: 13 Oct, 2022 by Kim Stimpson
2 min read

Overview

If a Layer isn’t showing in iShare then the reason for this could be that the column name for the geometry data isn’t wkb_geometry. If this is the case then there is a simple way to configure this in iShare.

Step-by-step guide

  • First check in your database for the name of the column that holds the geometry data. It should look like this below. If the name is different that can cause an issue.

  • If you don’t have access to view the database you can open the developer tools in your browser of choice (usually with Ctrl-Shift-I) and open the Network tab.

  • Switch the Layer on in iShare Maps and locate the GetOWS.ashx?LAYERS request as highlighted above, right click it and open it in a new tab.

  • If it has the following error then the issue is with the geometry column name.

  • To fix this open iShare Studio and locate the Layer(s) in question and click on the Advanced button

  • Tick the Geometry checkbox and select the Field that contains the geometry data from the dropdown list.

  • Save your changes and the Layer should now display correctly.