Skip to main content
Question

Problems using postgis reader/writer

S
Forum|alt.badge.img

So I'm having a bit of an issue using the fme postgis reader/writer combo. I have a big model that works perfectly using shapefiles (with some adaptations) or using esri gdb. The thing is that I'm trying to only use postgis as entry files and output files. The entry files arepolylines and the output files are polygons. The issue is with the ouput. The input of polylines from postgis seams to affect the ouput.

1. Shapefile reader: No problem

2. .gdb reader: No problem

3. postgis reader: polygons are converted to polylines

A few things to note:

1. When using the postgis reader I can still write the polygons in a shapefile

2. When using a shapefile or a gdb as input I can write the polygons in postgis format.

The issue to me seems that the spatial column is carried out from the entry data and I don't know how to get it to a blank slate.

Sorry for my bad english.

4 replies

S
Forum|alt.badge.img
  • simon_fb
  • Author
  • April 5, 2019

I've looked further into this issue and I'm pretty sure the error comes from the featureMerger. If I try writing to postgis before the featureMerger, it writes polygons and if I write after the transformer it writes Polylines. The suppliers are polylines and the requestor polygons. I've attached a snapshot of the transformer.

S
Forum|alt.badge.img
  • simon_fb
  • Author
  • April 5, 2019

Ok so I just found a solution. I find it kind of stupid though and I don't know why it works... I just buffered the polylines coming into the featureMerger. Now that the supplier are polygons it works. What I don't understand is how that makes a difference. I guess the geometry column is carried out form the supplier, but why is it since the featureMerge type is set to attributes only.

david_r
Celebrity
  • david_rCelebrity
  • April 5, 2019
simon_fb wrote:

I've looked further into this issue and I'm pretty sure the error comes from the featureMerger. If I try writing to postgis before the featureMerger, it writes polygons and if I write after the transformer it writes Polylines. The suppliers are polylines and the requestor polygons. I've attached a snapshot of the transformer.

If you don't need the supplier geometry (polylines), you can insert a GeometryRemover on the suppliers just before the FeatureMerger.

S
Forum|alt.badge.img
  • simon_fb
  • Author
  • April 5, 2019
david_r wrote:

If you don't need the supplier geometry (polylines), you can insert a GeometryRemover on the suppliers just before the FeatureMerger.

That works! Thanks, I just don't know why the geometry column of the supplier would be carried

Reply


Helpful Members This Week

Community Stats

31,292
Posts
118,679
Replies
38,878
Members

Latest FME

Terms & ConditionsCookie settings

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.