Creating SDE feature class from SQL view-generated geometry

Question

All,

I've got a sql view that joins SQL 2 tables together, one of which contains geometry for address points.

I want to take that view and write it to an SDE feature class using FME.

The problem is, when I choose SQL Server Spatial as the reader format, the shape (geometry) column isn't recognized.

When I chose SQL Server Non-Spatial, the shape column is recognized, but the output SDE feature class doesn't have a recognized spatial reference, and the points don't display at all on the map (ArcMap).

Is there any advice for trying to accomplish this?

Using SQL for geometry joins, spatial functions, etc. is what we're planning on doing for generating data for SDE feature classes...

Many thanks!

-m

Page 1 / 1

Hi,

An alternative is to cast the geometry column to WKB using STAsBinary (or, in a pinch, WKT using STAsText) in the view definition and pass it on to FME in a BLOB.

You can then use the GeometryReplacer on the BLOB value to re-create the geometry inside the workspace.

David

Reply

david_r · Accepted Answer

Hi,An alternative is to cast the geometry column to WKB using STAsBinary (or, in a pinch, WKT using STAsText) in the view definition and pass it on to FME in a BLOB.You can then use the GeometryReplacer on the BLOB value to re-create the geometry inside the workspace.David

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded