Skip to main content
  • EN

Hello,

I am trying to populate a value into "_overlaps" using the PointOnAreaOverlayer Transformer but all the data keeps being Rejected.

This works fine when both Readers are consuming Oracle Spatial but I think the issue may be because my Point data is non-spatial?

Tried the 'Reprojector' Transformer but had no effect. The View with the Point data contains a SHAPE field therefore should contain geometry but the FME non-spatial reader does not contain the field and I cannot pick up the data using a spatial reader.

I may be pursuing the wrong process here?!

Thanks in advance.

 

I'm a bit confused: if they should be points and you're using the Oracle non-spatial reader you won't get points, in that case, try the Oracle spatial reader.

I'm a bit confused: if they should be points and you're using the Oracle non-spatial reader you won't get points, in that case, try the Oracle spatial reader.

The Oracle spatial reader does not pick up the View in the DB when you add into the workbench.

I can add coordinate fields into the View, I assume if I did that I would have to then use a 'VertexCreator' Transformer?

The Oracle spatial reader does not pick up the View in the DB when you add into the workbench.

I can add coordinate fields into the View, I assume if I did that I would have to then use a 'VertexCreator' Transformer?

Gotcha. Yes, if you have the x and y coordinates available in the view as fields you can use the VertexCreator to build points.

The Oracle spatial reader does not pick up the View in the DB when you add into the workbench.

I can add coordinate fields into the View, I assume if I did that I would have to then use a 'VertexCreator' Transformer?

@chris_acc​ The Oracle Spatial reader might not see a view in the table list, but if you just type name of the view in the text field it might pick it up

The Oracle spatial reader does not pick up the View in the DB when you add into the workbench.

I can add coordinate fields into the View, I assume if I did that I would have to then use a 'VertexCreator' Transformer?

Unfortunately @Mark Stoakes​ that did not work (on this occasion) but that is good to know for the future.

Reply


Community Stats

30,176
Posts
114,543
Replies
37,835
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.