Esri Geodatabase (OpenFile Geodb) Reader/Writer

FME can store data in and retrieve data from Esri’s File Geodatabase, based on the OpenFile Geodatabase GDAL driver.

Note  This new format is recommended as a replacement for the deprecated Esri Geodatabase (File Geodb Open API) reader/writer.

You can use this format without an Esri license or special installed libraries.

Note  Using the OpenFile Geodb reader/writer can benefit workspace performance and speed, but it offers less functionality than with some other Esri Geodatabase formats. For example, this format supports only simple geometry types.

OpenFile Geodb supports 64-bit integers and the Date and Time types when the Target ArcGIS Version is set to ArgGIS Pro 3.2 or Later; otherwise, float64 and DateTime will be used.

Versions

This format supports File Geodatabases created with any version of ArcGIS Pro, as well as ArcGIS Desktop or ArcGIS Enterprise Version 10.0 or newer. Formats created with 9.x have read-only support.

For more information, see:

Product and System Requirements

Format

FME Platform

Operating System

Reader/Writer

FME Form

FME Flow

FME Flow Hosted

Windows 64-bit

Linux

macOS

Reader

Yes

Yes

Yes

Yes

- Linux Intel: Yes

- Linux ARM: No

- macOS Intel: Yes

- macOS ARM: Yes

Writer

Yes

Yes

Yes

Yes

- Linux Intel: Yes

- Linux ARM: No

- macOS Intel: Yes

- macOS ARM: Yes

Overview

The OpenFile Geodb reader and writer translates several different types of features:

  • reading and writing of point, line, polygon, and multipoint feature classes
  • partial reading of some of the other File Geodatabase types (for example, dimensions, parcel fabrics) exposed using the basic geometric types listed above
  • reading and writing of non-spatial tables
  • Programmatic Table Creation: Feature classes and tables need not be created before a data import operation. All table creation details are handled by FME.
  • When FME creates a feature class, it consults the first feature destined for the corresponding feature type to determine if Z and/or measure values should be included.
  • Index Creation: Attribute fields can be flagged as indexed. When the associated feature class or table is created, attribute indices are created as well.
  • Table Selection: A subset of tables and feature classes to read can be selected from a list. Feature classes within a feature dataset are listed together for easy selection.
  • Attribute Query Support: SQL “where” clauses can be specified to limit the data being exported.
  • Spatial Query Support: A bounding box can be specified to limit the data being exported. This can be configured in the reader settings or accessed via the FeatureReader transformer.
  • Fully Automatic Import and Export: FME supports fully automated import and export of data through its graphical interfaces, e.g. FME Quick Translator. This is ideal for quick data imports and exports.
  • Unicode Support: Geodatabase text columns are stored in the UTF-16 encoding on Windows platforms, and in UTF-32 encoding on Linux platforms. FME can read and write this data.
  • Feature Datasets: Feature datasets are read and written. On read, they are included in FME’s feature type names. On write, they are created as necessary.
  • Domains and Subtypes: Coded domain and subtype fields are read and written using descriptions, not coded values. For example, if a coded value Res has a description Residential, when writing to a field that contains a domain, ensure that you pass in the description. In the current release, FME does not support creating tables or feature classes with subtypes or domain restrictions, and does not include this metadata on the schema.
  • Coordinate Systems: Features are tagged with their spatial reference (coordinate system) on read. Feature classes are created with the spatial reference associated with incoming features. Note that the OpenFile Geodatabase supports a fixed list of coordinate systems. Data in other coordinate systems cannot be read or written.
  • Measures: In addition to reading and writing X, Y, and optional Z ordinates, measure values are supported as well. The writer will write measures if the feature contains the <default_measure> and the destination feature class includes measure values. The reader will automatically load the <default_measure> if there are measures on the source feature class.

Reader Overview

The reader extracts data from the selected File Geodatabase using the OpenFile Geodatabase.

ArcGIS feature classes and tables become FME feature types, and ArcGIS features and rows become FME features. For feature classes within a feature dataset, the FME feature type name is formed as follows: <feature dataset name>/<feature class name>.

As with other database readers in FME, the Format Parameters are used to determine which feature classes and tables to read. WHERE clauses and bounding box constraints can be used to further limit the data read.

Writer Overview

The writer exports data to a new or existing File Geodatabase using the OpenFile Geodatabase.

Note  Because tables are considered to have complex behavior, the writer does not support writing to tables that participate in a relationship.

Other tables/feature classes that are not supported:

  • Annotation and Dimension feature classes
  • Networks (GN and ND)
  • Parcel Fabrics
  • Relationship Classes
  • Representations
  • Terrains
  • Topologies

Writer Tips

When inserting data, if an attribute is missing, a null value will be written in its place.