Download an FTEM Geodatabase and Join to Other Data

FTEM Administrators and Agency Administrators may download a Relational Database Backup and Geospatial Database Backup of FTEM monitoring data. The Geospatial Database Backup is an export of the key feature classes and associated tables in FTEM.

To download a Geodatabase backup:

  1. From any FTEM page, navigate to your profile in the top right and select System Admin.

    System admin is shown in the drop-down menu of the profile.

  2. Click the labeled Download File ftemgeodb.gdb.zip.

    the geodatabase button.

Joining Data

Once you've downloaded the geodatabase, you may join stand-alone attribute tables to feature class tables in ArcPro:

  1. Unzip the geodatabase file.

  2. Start an ArcPro session.

  3. Open the Catalog pane by selecting View and clicking Catalog Catalog.

    The View ribbon is visible and the mouse cursor is hovering over the catalog button.

  4. In the Catalog pane, make sure "Computer" is selected then locate and expand the unzipped geodatabase folder.

    Contents of the geodatabase file are expanded in the Catalog pane.

  5. Add the desired feature and table to the table of contents by dragging and dropping the desired feature and table onto the map or into the Contents pane.

    mouse cursor with arrows next to a feature and table, pointing toward the map.

  6. From the Contents pane, right click on the feature to view file options, select Joins and Relates and click Add Join to open the Add Join window.

  7. In the Add Join window, fill out the join fields and click OK when finished. In the example below:

    • Input Table is "Wildfire_Poly" indicating the Wildfire_Poly feature will have data joined to it.

    • Input Field and Join Field are both populated with "ftem_wildfire_id" indicating this is the common value in both tables that will be used to match and join the data.

    • Join Table is "wildfire." Data from the "wildfire" table will be added to the "Wildfire_Poly" attribute table.

    • Keep all input records and Index join fields are both checked in this example. To learn more about these options, hover over them with the mouse cursor and click the information icon Information that appears next to them.

    Add Join window with "Wildfire_Poly" selected as the input table and "ftem_wildfire_id" selected for both the input field and join field.

  8. To view the results of your join, right click the feature in the Contents pane and select Attribute table to open the table.