Importing Data from File Geodatabase
The ESRI File Geodatabase (FileGDB) is a file-based database for vector and raster data. It can be identified as folder with the suffix .gdb. For example, myDatabase.gdb
The import dialog consists of several options, as shown below. As usual, presets can be saved and applied.
Pressto open a dialog and browse to the .gdb directory you want to import.
If the file entry contains a valid gdb path, the upper part of the wizard page shows the layers available for import. These are the available columns in the FileGDB inspector:
- Name of the Layer. The checkbox will decide if the layer is actually imported.
- If the layer is a feature class, its geometry type will be displayed. Else, the layer type will be displayed.See below for a list.
- If a feature class or a table, the number of rows will be displayed.
- A layer is readable (= importable), if it is a feature class with non-zero row count and has a supported coordinate system. If you hover the mouse pointer over the sign, a tooltip will tell you the reason for the layer not being readable.
- CS Authority
- The "CS Authority" column displays the coordinate system EPSG authority ID.
- CS Description
- This displays the coordinate system description.
The following layer types are supported:
- Multipatch (with textures)
- Table (indirectly, if connected via relationship classes)
- Relationship Classes (indirectly)
Each FileGDB layer with geometry (= also called a "Feature Class") is imported as a separate CityEngine layer. Layer types that are not supported are marked with the sign, and will not be imported.
If a FileGDB is imported into a new scene without any coordinate system yet, the scene will inherit the coordinate system of the first imported layer. All following layers with differing coordinate systems will be reprojected.
Please make sure that the input feature classes use the same coordinate units in the planar and up directions. CityEngine does not support separate units for the planar and up directions.
Street Graph Settings
Note: The graph settings are only of interest when importing "Polyline" feature classes for graph networks.
Run Generate Bridges Tool after ImportIf enabled, the Generate Bridges Tool is executed on a following wizard page.
Run Simplify Graph Tool after ImportIf enabled, the Simplify Graph Tool is executed on a following wizard page.
Run Graph Cleanup Tool after ImportDepending on the OSM data it may be necessary to cleanup the graph segments after import. If enabled, the graph cleanup tool is executed on a following wizard page.
Create Street/Intersection Shapes from GraphIf enabled, the shape creation parameter of the graph nodes and segments will be enabled and street shapes are created.
Create Block/Lot Shapes from GraphIf enabled, the shape creation parameter of potentially created street blocks will be enabled and shapes are created.
Feature Attribute Settings
Import and map attributes
If enabled, all non-geometry attributes of a feature will also be imported. Polyline/graph layers will additionally contain the following layer attribute code:
This mapping controls the width of the street shapes generated from the graph center lines. In the default behaviour, the object attribute width is used to determine the resulting street width, and defaults to 8 if no object attribute is found.
The function code can be edited after import in the inspector when selecting the imported layer.
Advanced users can edit the default mapping code by changing the cga code in the file shp.ceattr, located in /ce.lib/rules/.
Import database scheme and relationships
If enabled, attributes from tables that are connected to a selected feature class by relationship class(es) are also imported and assigned to the imported shapes as object attributes.
Each object attribute will keep information about its FileGDB data type (including "Domain") and original related table. This information can be used in the FileGDB exporter to recreate feature classes, relationship classes and tables.
If the feature class is of type "Multipatch", its textures will also be imported and assigned to the scene shapes. Each texture will be extracted from the feature class and saved as a jpg or png (in case of transparency). These new texture files will be placed in a new project folder named 'data/[FileGDB name without extension]-data'.
Selection Query and Spatial Envelope Settings
Use selection query and spatial envelope
If enabled, an attribute selection query and envelope can be used to reduce the number of imported features from each selected feature class.
SELECT * WHERE
A list with all layer fields can be obtained by hovering the mouse
over the layer name. Use these names to build a SQL query for
filtering the imported shapes.
For example: SELECT * WHERE edits = 'yes'
Set the size (Width, Height) and reference point (X-Offset, Y-Offset) of the selection envelope.
Working with FileGDB object attributes
Attributes of features are imported along with the feature itself. After a successful import, these attributes appear in the Inspector in the Object Attributes tab.
Feature attributes imported via related tables are prefixed with the name of the related table followed by an underscore.
Useto edit array attributes of one or more shapes in one place.
Once a CGA rule file with matching attributes is assigned to this shape, the matching object attributes are connected to the rule file and will control the generation of models. See also Mapping attributes.
Copyright ©2008-2018 Esri R&D Center Zurich. All rights reserved.