Skip to main content
Solved

PointOnAreaOverlayer Transformer rejecting with INVALID_POINT_GEOMETRY_TYPE error

  • October 4, 2021
  • 5 replies
  • 62 views
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

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

redgeographics
Celebrity
Forum|alt.badge.img+59
  • redgeographicsCelebrity
  • Celebrity
  • 3700 replies
  • October 4, 2021

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.

FME rocks! \m/
chris_acc
Contributor
Forum|alt.badge.img+5
  • chris_accContributor
  • Author
  • Contributor
  • 29 replies
  • October 4, 2021

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+59
  • redgeographicsCelebrity
  • Celebrity
  • 3700 replies
  • Best Answer
  • October 4, 2021

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.

FME rocks! \m/
M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • October 4, 2021

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
  • 29 replies
  • October 5, 2021

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.

Community Stats

32,070
Posts
121,771
Replies
39,696
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.