Skip to main content
Solved

Oracle Spatial Writer not creating geometry

chris_acc
Contributor
Forum|alt.badge.img+5

Hi,

I am trying to read data Oracle non spatial data from a View and create an output in Oracle Spatial.

Although the process writes to the Oracle Spatial table and you can view the attribute data OK the data does not seem to be spatial and I can't see any data on a map.

 

FME_Parking_Oracle_IssueI have learned through passed experience that the Spatial Column must be

changed from GEOM to SHAPE

FME_Parking_Oracle_Issue_2Not sure if this is because i can't set the Eastings and Northings in the Reader to Types x_coordinate and y-coordinate?

You can set in a CSV Reader but not Oracle? (if this is the issue)

FME_Parking_Oracle_Issue_3 

 

Thanks

Best answer by ebygomm

I think points are probably not generated automatically from the Eastings and northings column with the Oracle non spatial reader as they are with some other formats. You can use a vertex creator to use the values to create points

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

2 replies

ebygomm
Influencer
Forum|alt.badge.img+38
  • ebygommInfluencer
  • Influencer
  • Best Answer
  • July 27, 2021

I think points are probably not generated automatically from the Eastings and northings column with the Oracle non spatial reader as they are with some other formats. You can use a vertex creator to use the values to create points

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

I think points are probably not generated automatically from the Eastings and northings column with the Oracle non spatial reader as they are with some other formats. You can use a vertex creator to use the values to create points

Perfect, thanks @ebygomm​ that worked 😉

Reply


Helpful Members This Week

Community Stats

31,341
Posts
118,854
Replies
38,930
Members

Latest FME

Terms & ConditionsCookie settings

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.