Foursquare Studio Data Writer Feature Type Parameters

To access feature type parameters, click the gear icon on a feature type in the workspace. This opens the Feature Type Parameter Editor.

Tip  To always display the editor in FME Workbench, you can select View > Windows > Parameter Editor.

General

All feature types share similar General parameters, which may include Feature Type Name, Reader or Writer information, and Geometry.

In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept Table or Index Qualifier prefixes on the output table feature type.

Dataset

Dataset Handling

This parameter controls how the feature type handles Foursquare Studio dataset creation/update behavior.

Note  Foursquare Studio datasets do not support partial updates. To edit the contents of an existing dataset, the entire dataset must be replaced. Supported modes are:
  • Create If Needed (default) – If the feature type contains a valid dataset ID, the write operation will replace the contents of the existing dataset. Otherwise, a new dataset will be created with the name of the feature type.
  • Use Existing – If the feature type contains a valid dataset ID, the write operation will replace the contents of the existing dataset. Otherwise, the write will fail.

Geometry Column Name

Enter the name of a column in the dataset to use for geometry output. Feature geometry on features input to the writer will be written to this column. (For a description, see Geometry Column Name.)

  • geometry (default)
  • geom
  • custom value

The geometry data will be written as JSON syntax that Foursquare Studio will recognize as a geo column. The geometry JSON will use the same syntax which is used to specify geometry on GeoJSON features. For example:

`{“type”: “LineString”, “coordinates”: [[0.0,0.0],[1.0,1.0],[2.0,2.0]}`

Note  If the Geometry Column Name value matches a user attribute on the schema, all values for that user attribute will be overwritten by the FME geometry values. A warning will be logged when this occurs.