Solved

Oracle Spatial Writer not creating geometry

chris_acc
Rank
Badge +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

icon

Best answer by ebygomm 27 July 2021, 13:59

View original

2 replies

ebygomm
Rank
Userlevel 1
Badge +21

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
Rank
Badge +5

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

28,699
Posts
109,450
Replies
36,548
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.