...
You may have data of mixed geometry that you wish to load into iShare and, as iShare basically only supports a single Geometry Type for a dataset i.e. not a mixture or Point, Line & Polygon, you PostGreSQL so you need to determine the best Geometry Type in order for all the records to load or else split the dataset by Geometry Type. For example if you had mixed Polygon and Multi Polygon data you would choose to import the data as Multi Polygon. If you don't force the Geometry Type and OGR detects that this dataset holds Polygon data, then all of the Multi Polygon entries will fail to import. It is also a good idea, with mixed geometry datasets in particular, to know if certain records in a dataset have not loaded properly.
As iShare basically only supports a single Geometry Type for a Layer so, if you had imported multiple Geometry Types into PostGreSQL, you would need to filter your Standard Layer by Geometry Type when adding the Layer in Studio.
Step-by-step guide
- In order to load the data you create a Workflow Spatial Data Transformation Task and under the Options there is the Force Geometry check box.
- This defaults to blank i.e. OGR checks the first record in the dataset and sets the Geometry Type accordingly. If this happens to be Polygon then all of the Multi Polygon entries will fail to import. If you tick the box you can then choose the best Geometry Type for your dataset, in this case Multi Polygon.
- If you want to receive email notification if records fail to load then you will need to untick the Skip Failures check box which is ticked by default.
- If you run the Job /Task and the data fails to load you can check the iShare logs where you will see something similar to:
...