What's new

Welcome to the GSA Community!

This is the Official User Community for GE's GeoSpatial Analysis products. By registering with us, you'll be able to discuss, share and private message with other members of our Community.
Registration is currently only allowed with a personalized invitation code, which you might have received previously. If you haven't got one:
please get in touch with your GE contact person or your regional moderator(s): see FAQ.

SignUp Now!

MS SQL Warehouse: Preventing mapped geometry fan out


New member
Confirmed GSA Customer
Oct 20, 2023
Just discovered the resource and hoping to find some help with a new venture we are undertaking, exporting from our Smallword 5.1.8 to an SQL instance, using GSA Ultimate 5.2.11

In our GIS we are using mapped geometries, 'centreline' mapped on "Operating Voltage" in this example, obviously the user only ever see's the single 'centreline' geometry.

When I add the table into GSA, it is showing the single geometry in the Business Collection Designer (good!), but when I goto the Warehouse Target Model Mapping section, the geometry has been split out. This, then transfers to the SQL instance and is adding great confusion to the end user.

Is there a simple way to prevent this? or should I be instead creating a generic centreline and using an expression to merge them all back to a single geom feature?

I've attached a sample of our setup, which I hope helps!


  • 2023-11-17_12-40-52.jpg
    168 KB · Views: 0
  • 2023-11-17_11-55-45.jpg
    628.3 KB · Views: 0
  • 2023-11-17_11-54-57.jpg
    78 KB · Views: 0
  • 2023-11-17_11-54-28.jpg
    225.5 KB · Views: 0