Skip to main content
Question

writing features to a postgis database after using FeatureMerger

  • November 23, 2012
  • 3 replies
  • 7 views

I want to merge a shapefile and a dbf file joined by an attribute and write them to a postgis database. Is FeatureMerger the way to do this? How do I extract the merged feature information (i.e. all the merged attribute metadata) and provide it to the postgis writer so that the correct table structure is created for the merged feature type?

3 replies

sigtill
Supporter
Forum|alt.badge.img+24
  • Supporter
  • November 23, 2012
Just a general tips. If you RIGHT CLICK on a WRITER on the workbench you have the options:
  1. Copy attributes from Transformer (you can use this on your featuremerger)
  2. Copy attributes from Feature Type
This will give you a good start on which attributes to write as output.

fmelizard
Contributor
Forum|alt.badge.img+17
  • Contributor
  • November 23, 2012
Hi,

 

 

If the merge is between 2 datasets, then the featuremerger is the way to go, otherwise have a look at the inlinequerier.

 

Ss  SigTill mentioned copying the attributes from the featuremerger into the writer will provide you with resulting attributes, however if you are using the list option (1:N relationship) then mapping your list attributes (as mentioned in your previous post) should take place.

 

 


  • November 23, 2012
You are adding additional attributes - tabular data (DBF) onto spatial data (Shape). FeatureMerger will do it, but the best option is the Joiner.

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