I'm trying to use FME to get shapefile to Postgres (postgis) but there is no option in the writer to choose point, or line, etc. .. What I get in postgis geom type geometry and not geom type point or lines, etc...
any help will be appreciated...
thanks
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
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?
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