Skip to main content
Solved

Oracle to shapefile

  • January 14, 2015
  • 2 replies
  • 11 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) ?
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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+19
  • 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

Helpful Members This Week

Community Stats

31,501
Posts
119,418
Replies
39,118
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

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.