Writer Feature Type Properties: Format Parameters

• No (default): If a dataset is not published, then it is a working copy. Working copy datasets can be freely modified by its creator and other authorized users.
• Yes: The dataset will be published. Published datasets cannot be edited: only appending and replacing is permitted.

This parameter has no effect on existing datasets.

Note that publishing will fail if Socrata has not finished geocoding addresses in the dataset’s location columns. The geocoding step happens after the import process.

• No (default): Only the dataset owner and authorized users may access the dataset.
• Yes: The dataset is made available for public read access.

This parameter has no effect on existing datasets.

• No (default): The dataset will not be truncated.
• Yes: The dataset will be truncated prior to writing. The effective writer mode will be INSERT, regardless of the value of socrata_writer_mode. The truncation and insertion operation is accomplished using a Publish Method of replace on the Socrata DataSync tool. This method is also known as SmartUpdate.

This parameter has no effect if the dataset does not already exist.

The Writer Mode determines which database command should be issued for each feature received. The writer mode is specified at the feature type level only.

Valid writer modes are UPSERT and DELETE.

UPSERT (default)

Features are either inserted or updated based on the value for the Row Identifier attribute. If no value is provided for the Row Identifier, or if the Socrata dataset does not have a Row Identifier, then UPSERT inserts a new row. If the feature type has only a subset of the columns on the corresponding Socrata dataset, updates of existing rows will only update those columns – columns not on the feature type will retain their existing values.

DELETE

Features are deleted according to the Row Identifier. The user attribute that corresponds to the Row Identifier must be present. All other user attributes are ignored. It is an error to use DELETE mode if the dataset does not have a Row Identifier. Rows on the Socrata dataset that do not have a Row Identifier value cannot be deleted.

Note: If a Row Identifier is set on the Socrata dataset, the Socrata DataSync tool will skip features that do not supply a value for the Row Identifier column. However, it is still possible to create rows/features with an empty Row Identifier value via the Socrata web interface.

Specifying the writer mode on a per-feature basis using the fme_db_operation attribute is not supported.

A comma-separated list of the geometry column names for writing.

Location columns will be created for each of the supplied geometry column names when creating a new table or matched against the existing geometry columns when writing to an existing table.

Note: If the column names listed here conflict with any user attributes, the columns listed here take precedence.

This parameter has no effect when the Writer Mode is DELETE.

• Yes (default): Uses geocoding for Location columns.
• No: This setting improves performance if addresses are not being written to Location columns.

This parameter corresponds to the useSocrataGeocoding option on the Socrata DataSync tool.