Reader Directives – Personal Geodatabase

The directives listed in this section are used when connecting to a Personal Geodatabase (.mdb or .accdb file).

DATASET

Required/Optional: Required

The file (Personal Geodatabase) or folder (File-based Geodatabase) from which data is to be read.

For Personal Geodatabases, an .mdb or .accdb file is specified when connecting to a Personal Geodatabase.

For File-based Geodatabases, a folder ending in .gdb is specified.

Personal Geodatabases Example:

GEODATABASE_MDB_DATASET ”C:\FME\personalGeodb.mdb”

File-based Geodatabases Example:

GEODATABASE_FILE_DATASET ”C:\FME\montgomery.gdb”

Workbench Parameter

Source Esri Geodatabase (File-based) File

SEARCH_ENVELOPE

Using the minimum and maximum x and y parameters, define a bounding box that will be used to filter the input features. Only features that interact with the bounding box are returned.

If all four coordinates of the search envelope are specified as 0, the search envelope will be disabled.

Mapping File Syntax

<ReaderKeyword>_SEARCH_ENVELOPE <minX> <minY> <maxX> <maxY>

Note: If all four coordinates of the search envelope are specified as zero, the search envelope will be disabled.

Required/Optional

Optional

Workbench Parameter

Minimum X, Minimum Y, Maximum X, Maximum Y

SEARCH_ENVELOPE_COORDINATE_SYSTEM

This directive specifies the coordinate system of the search envelope if it is different than the coordinate system of the data.

The COORDINATE_SYSTEM directive, which specifies the coordinate system associated with the data to be read, must always be set if the SEARCH_ENVELOPE_COORDINATE_SYSTEM directive is set.

If this directive is set, the minimum and maximum points of the search envelope are reprojected from the SEARCH_ENVELOPE_COORDINATE_SYSTEM to the reader COORDINATE_SYSTEM prior to applying the envelope.

Required/Optional

Optional

Mapping File Syntax

<ReaderKeyword>_SEARCH_ENVELOPE_COORDINATE_SYSTEM <coordinate system>

Workbench Parameter

Search Envelope Coordinate System

CLIP_TO_ENVELOPE

This directive specifies whether or not FME should clip features to the envelope specified in the SEARCH_ENVELOPE directive.

Values

YES | NO (default)

Mapping File Syntax

<ReaderKeyword>_CLIP_TO_ENVELOPE [yes | no]

Workbench Parameter

Clip To Envelope

ALIAS_MODE

This directive allows the user to specify what kind of alias handling should be performed. See the Workbench Reader Parameters for more details.

Required/Optional

Optional

Parameter

<alias_mode>

Values

NONE (default) | SCHEMA | ON_DATA_FEATURES

Workbench Parameter

Alias Mode