Skip to main content
Solved

Oracle to shapefile

  • January 14, 2015
  • 2 replies
  • 23 views
J
Hello,

 

 

I have a csv file with columns as ID, NAME. I want to use ID to query Oracle table and create a shape file from that result.

 

 

Currently I am using CSV reader to read csv then querying database using FeatureReader (in where clause CODE=@value(ID)) and writing to shape file. My problem is I am not able to get attributes in shapefile.

 

 

How can I export attributes as well of selected features.

 

 

Cheers

Best answer by fmelizard

Hi,

 

Have you tried exposing the attributes (attributeExposer) ?
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.

2 replies

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • Best Answer
  • January 14, 2015
Hi,

 

Have you tried exposing the attributes (attributeExposer) ?
david_r
Celebrity
  • david_rCelebrity
  • January 14, 2015
Hi,

 

 

if you have the geometries in an Oracle table and want to add the attributes from the CSV file:
  • One reader for the CSV file
  • One reader for the Oracle (spatial or SDE) table
  • A FeatureMerger on the ID field, CSV features entering as REQUESTOR
  • MERGED output to SHAPE writer

 

David

Community Stats

32,154
Posts
122,043
Replies
39,812
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.