How can I make FME writing to postgis (line) and not geometry type

Hi,

 

 

PostGis:

 

 

GeometryType — Returns the type of the geometry as a string. Eg: 'LINESTRING', 'POLYGON', 'MULTIPOINT', etc.

 

 

Synopsis

 

text GeometryType(geometry geomA);

 

 

Description

 

Returns the type of the geometry as a string. Eg: 'LINESTRING', 'POLYGON', 'MULTIPOINT', etc.

 

 

 

http://postgis.net/docs/GeometryType.html

thanks.. what I mean it was possible at FME 2013 to find this linstring, polygon, etc. at the parameter of writer but in FME 2014 .. i can not fint them !!?

in the fme 2013 version. (im still on 2013 sp2 and sp4)

 

 you can set the "Create Generic Geometry Column" option. Then only on type of geometry is allowed. You have to filter the geometry using fme to select only the type you want to wirte.

 

So if u set this option and only feed it polygons, GeometryType would be 'POLYGON'.

 

 

Is this option not available in fme2014 anymore?

Hi,

 

 

There seems not to be such an option also in the PostGIS writer of FME 2014.

 

A table of PostGIS database can contain features having various geometry types simultaneously. If you have to avoid to write features other than lines, consider using the GeometryFilter before the writer, as Gio mentioned.

 

 

Takashi@Vancouver

Thanks Gio and Takashi for your answer...