Skip to main content
Question

GeometryExtractor WKT geometry not the same as source data

  • April 2, 2025
  • 1 reply
  • 34 views

so_much_more
Supporter
Forum|alt.badge.img+6

I noticed that the WKT output from GeometryExtractor is not the same as the feature in the source data.

If i run Geometri_SPA.STAsText() on a feature from  in SQL Server Management Studio my return is 

CIRCULARSTRING Z (576285.5719837358 7034448.923522126 0,576284.6966432678 7034459.3191996245 0,576285.4981703878 7034469.720828624 0)

 

But i run the same feature through GeometryExtractor with Geometry Endocing OGC Well Known Text my return is

LINESTRING Z (576285.5719837358 7034448.923522126 0,576285.1277140373 7034452.078045797 0,576284.8387646212 7034455.250568986 0,576284.705831592 7034458.433448807 0,576284.729235197 7034461.619017426 0,576284.9089190548 7034464.799600528 0,576285.2444502913 7034467.967535808 0,576285.4981703878 7034469.720828624 0)

Why is the geometry type changed by the transformer?

I want to identify features of type compoundcurve, circularstring, curverpolygon etc and flatten dem to pure line og polygons. But as for now i am not sure how i can validate the results of the arcstroker because GeometryExtractor modify geometry type compared to whats in the database

EDIT: Updated with complete examples of WKT.

1 reply

natalieatsafe
Safer
Forum|alt.badge.img+11

@so_much_more Hi there, thanks for the question, and great catch on the geometry discrepancy. I have a hunch this discrepancy has something to do with how FME is reading in this circular arc feature. If the format used to read in the arc features does not support arcs, FME will tend to bring these features in as paths / polylines. According to the help documentation for the GeometryExtractor,

The OGC variants are useful if interaction with other OGC supporting systems is required. However, some characteristics of geometries may be lost in these modes; for instance, any path will be flattened into a single linestring.

 

The above help doc info is found by expanding the General section under Parameters, and then peeking through the Geometry Encoding information.

So, my first hunch on what is happening is FME is reading your circular arcs in as paths, and then the GeometryExtractor is flattening the paths into linestrings. That’s if I’m understanding the workflow correctly.

If you’re looking to check the geometry of your features, you could consider using the GeometryFilter set to Detailed Mode, instead of the GeometryExtractor. Then, for the GeometryFilter’s Output Ports, just Select All, and run your features through the GeometryFilter to see what type of geometry you have. Just note, if FME is indeed reading you circular arc features in as paths, they’ll be output via the IFMEPath output port of the GeometryFilter.

Let us know here if the GeometryFilter offers what you’re looking for!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings