Skip to main content
  • EN

I am using a SchemaScanner to prepare a dataset for dynamic writing to a PostGISWriter. How do I write to the columns for PrimaryKey and Geometry in an dynamic environment?

If you configured the FeatureWriter to be dynamic, you can add attributes in the tab User Attributes. Add a row with Name = pkey, Type = serial and Index = PrimaryKey and it will add this to all tables.

 

The geometrytype is an issue. The mapping in the PostGIS writer is always to generic geometry type, no matter what input geometry. So it will become...

geom geometry(Geometry,28992)

...and not...

geom geometry(Point,28992)

...which you probably need.

 

If I needed this now, I would use the SchemaFeature from the SchemaScanner to create the table using a SQLExecutor before the data features enter the FeatureWriter.

Reply


Community Stats

30,108
Posts
114,295
Replies
37,745
Members
Terms & ConditionsCookie 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.