Create line from two Oracle sdo_geometry points in the same row

Hi,

 

 

it might be possible to read both geometries using FME, but I've never tried it myself. One alternative solution could be to use an SQLCreator and cast your point geometries into x,y coordinate pairs and then use the VertexCreator to join the two coordinates into a line.

 

 

Something like this might work (untested):

 

 

select

 

from_geom.sdo_point.x as from_x,

 

from_geom.sdo_point.y as from_y,

 

to_geom.sdo_point.x as to_x,

 

to_geom.sdo_point.y as to_y

 

from mytable

 

 

Remember to expose the attributes from_x, from_y, to_x and to_y.

 

 

David

Follow-up :

 

 

I will create a separate table containing only trail id and linegeometry.  As suggested, I will use SQL Creator and two vertex creators.

 

 

Query in SQL Creator is somewhat different from suggested: 

 SELECT  a.trail_obj_sid, f.x as FROM_X, f.y as FROM_Y, t.x as TO_X, t.y as TO_Y FROM    TOPO_ALL_TRAILS_MAPPED a,         table(sdo_util.getvertices(A.FROM_GEOM)) f,         table(sdo_util.getvertices(A.TO_GEOM)) t where   a.from_geom is not null and a.to_geom is not null;

 And of course you need two Vertex creators, first one to two create starting point and second one to append  ending point to create a lines.  

 

 

 

Thanks to David for pointing me to the right direction.

 

 

Br, Esko