Skip to main content
Solved

PointOnAreaOverlayer Transformer rejecting with INVALID_POINT_GEOMETRY_TYPE error

chris_acc
Contributor
Forum|alt.badge.img+5

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.

 

Best answer by redgeographics

chris_acc wrote:

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.

View original
1 Attachments
Did this help you find an answer to your question?

5 replies

redgeographics
Celebrity
Forum|alt.badge.img+50

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.

chris_acc
Contributor
Forum|alt.badge.img+5
  • chris_accContributor
  • Author
  • Contributor
  • October 4, 2021
redgeographics wrote:

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?

redgeographics
Celebrity
Forum|alt.badge.img+50
  • redgeographicsCelebrity
  • Celebrity
  • Best Answer
  • October 4, 2021
chris_acc wrote:

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.

M
Forum|alt.badge.img+2
  • markatsafe
  • October 4, 2021
chris_acc wrote:

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

chris_acc
Contributor
Forum|alt.badge.img+5
  • chris_accContributor
  • Author
  • Contributor
  • October 5, 2021
chris_acc wrote:

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


Helpful Members This Week

Community Stats

31,624
Posts
119,839
Replies
39,258
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

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
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.