Question

writing features to a postgis database after using FeatureMerger

  • 23 November 2012
  • 3 replies
  • 1 view

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

Badge +21
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.
Userlevel 4
Badge +13
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.

 

 

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

Reply