Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • how to convert (x And y) data table in oracle to shapefile and save it in the oracle database?

You can read the table using the Oracle Non-Spatial reader, then use the VertexCreator transformer to convert the X,Y values to a point geometry and send it to the Shape file writer.

Hi @eslamgis90,

How is the structure your information x and y in Oracle?

Thanks,

Danilo

You can read the table using the Oracle Non-Spatial reader, then use the VertexCreator transformer to convert the X,Y values to a point geometry and send it to the Shape file writer.

You might also want to set the coordinate system on the Writer or via CoordinateSystemSetter transformer.

 

 

Just to clarify... If I understand correctly, you want to read out some tabular data (Oracle Non-Spatial Reader) that contains x and y coordinate values, create a shape file (Shape Writer) and then create a new table in Oracle with the geometry (Oracle Spatial Writer)?

 

 

Hi @eslamgis90,

How is the structure your information x and y in Oracle?

Thanks,

Danilo

numbers format .

 

 

This is exactly what I want to do.

 

 

This is exactly what I want to do.

 

 

As @david_r suggested, the VertexCreator transformer can be used to add a point geometry based on (x, y) to each feature read by the Oracle Non-Spatial Reader. You can then write them into a Shepefile file (with Shapefile Writer) and an Oracle database table (with Oracle Spatial Object Writer) simultaneously.

 

Just be aware that the license for FME Desktop Database Edition is required to create a workspace that contains the Oracle Spatial Object Writer.

 

numbers format .

 

 

Good, could you share a example of your data?

 

 

Reply


Community Stats

30,102
Posts
114,259
Replies
37,732
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.