Skip to main content
  • EN

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

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

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


Community Stats

30,176
Posts
114,544
Replies
37,837
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.