PostgreSQL (PostGIS) Spatial Views are not visible in Geospatial Administrator while registering features.

Sanket Butala

Explanation : If a View is not visible in Geospatial Administrator while registering the feature. The reason is View does not have Primary Key or Unique Constraint on a column. OpenCities Map requires a primary key or unique constraint on view. However…

- Creating Oracle Spatial Views

Dan Weston

The following may be helpful to create an Oracle view that can be registered and queried as a spatial feature. The PARCELS has a number of columns: Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production SQL> DESCRIBE PARCELS;…

PDF

Using Joins to Create Custom Searches in Bentley Map

Dan Weston

This article will present the details required to perform custom searches by creating a Join using Bentley Map. Two types are illustrated – Map Manager Joins using XFM Features, and SQL Server Spatial Joins using database Views and Tables.

- Oracle views in spatial feature definitions

Inga Morozoff

Purpose The purpose of this entry is to describe the design of Oracle Views for the definition of spatial features used by Bentley Geospatial products ( ie Bentley Map, Bentley Electric, Bentley Gas, Bentley Water, GeoWeb Publisher, and the Oracle…