In the new, fantastic, InlineQuerier (2023 beta), a geometry column can be selected. Is there a way to call directly the geometry of the feature without geometryextractor? On the same topic, is there a way to define the ouptput geometry without using an ST_asText followed by a GeometryReplacer?
Solved
Is it possible to access directly geometry in new InlineQuerier (FME2023)?
Best answer by markatsafe
@antoine Version 2 of the InlineQuerier (FME 2023 betas) allows you to set the geometry column as shown here:
Then you can use the geometry in your SQL query:
SELECT C.*, B.* FROM "CellSignals" as C, "local-area-boundary" as B
WHERE
ST_Intersects(B."_geom",C."_geom") ;
I've attached an example workspace (FME 2023 beta Build 23197)
SpatiaLite spatial queries can be pretty slow apparently.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.