Import GIS Data From ODBC database

This command use ODBC Connection to connect third party database and import database's GIS Data into Carlson drawing entities. It also optionally write the available attribute data to different format which defined in GIS Settings dialog.

After clicked on OK, the program will connect to the data source and display the following setup dialog.  This dialog will list all available features in the data source. The user can select import all features or one of the features in the list. Then select corresponding fields for the Point ID/Entity ID, Description, Elevation and Layer, etc when only one of the tables is selected. The selected fields would be used to fill Carlson internal fields. If no Point ID/Entity ID is selected, then it will use the table's primary key as the Point ID/Entity ID. If no field is selected for Description, then the description will leave blank. If no field is selected for Layer, then the table name will be used as layer name. If the table's geometry type is Point/MultiPoint and also "Enable Store/Read Point GIS Data to/from SQLite(CRDB) File" is selected in GIS Settings dialog, then it will allow user to select a name for the CRDB. The program then will also output points geometry and/or GIS Data to CRDB.

Currently, the program only supports the following geometry types, Points, LineStrings, Polygons, MultiPoint, MultiLineString and MultiPolygon.  Once the table is selected, Carlson detects the geometry types of the table and sets the dialog options for importing either points, linestrings, or polygons.  LineStrings/MultiLineString are brought into Carlson as open polylines and Polygons/ MultiPolygon are as closed polylines in the drawing.

Pulldown Menu Location: GIS Data->Import GIS Data-> Import ODBC
Keyboard Command:import_odbc
Prerequisite: need to specify GIS Feature File, GIS Data Format and ODBC data source.