Spatial Manager™ for AutoCAD - FAQs: Export ("Professional" edition only)

From Spatial Manager Wiki
Jump to navigation Jump to search

Spatial Manager™ for AutoCAD product page Download Spatial Manager™ for AutoCAD


Notes:

  • Some components in the images on this page (providers, names, windows look, etc.) may be slightly different from those that will appear on your computer
  • Some application functions need to access the Internet from the application itself. If you experiment problems in any process, ask your network administrator if there is a Proxy server installed on your network. You can configure the Proxy settings through the application options
  • Some geographic data providers (Geocode, image Maps, etc.) may need a user account, which you can configure in the Service Provider API Keys settings through the application options


Introduction

  • Objective of this section
    • To learn how to define export processes and their parameters and manage coordinate transformations
  • Topics in this section
    • Targets: data sources
    • Export parameters (Fields, Texts data, Points coordinates, etc.), AutoCAD objects selection, objects report, treat closed Polylines as Polygons
    • One-click export to Google Earth ("Standard" and "Professional" editions)
    • Transforming the coordinates: source and target, last used coordinate systems, searching in the coordinate systems catalog and transformation parameters


How can I Export AutoCAD objects as spatial features?

You can export AutoCAD objects as spatial features into files or databases by executing the 'SPMEXPORT' command of Spatial Manager™ for AutoCAD, which you will find in the "Spatial Manager" AutoCAD ribbon. This will launch the "Export" wizard of the application, which shares some of the steps with the Import wizard. The command not only exports the selected objects but saves their Extended Entity Data (EED/XDATA) as data tables (see below). Upon completion of any export process to a file, you can directly open the file location. When exporting to a KML or KMZ file you can choose to open the file in Google Earth (if installed)


'SPMEXPORT' command in the Spatial Manager™ for AutoCAD ribbon


While running the "Export" wizard, you can select the export parameters that match your needs:


Export Parameters window


  • Export selection
    • Select all objects: all objects in the drawing will be exported
    • Only selected objects: only a selection of objects will be exported. You can select the objects before executing the Export function or by using the Selecting buttons in this window
      • Manual selection
      • Select by Query: select objects according to the result of a simplex or compound data query (See "Selecting by Query")
      • Select by Table: select objects which have been previously attached to a specific data table (See "Selecting by Table")
      • Note: As you can select the objects previously to execute this command, in addition to the use of the above included selection options or in combination with them, you can make use of some other Advanced selection application tools, select objects in the Data Grid or any other selection method available in AutoCAD (Quick Select, etc.). Also note that, as most of the advanced application or AutoCAD selection commands will let you apply the selection to the current selection, the number of possible combinations to select what you are interested in is almost unlimited
    • Select objects in a layer: only the objects included in an AutoCAD Layer will be exported. You can select this layer using the drop-down list in this window
      • Note: When choosing the option to export all objects in the drawing, those objects that are in locked, off or frozen layers will not be included. If the objects are selected by any means before exporting and the option to export the selected objects is chosen, they will be exported even if they are in locked, off or frozen layers
  • Export object data (options tree)
    • Unique key field: when checked, the data table will include an new Unique Key Field (numerical consecutive) ('AdSPMKey'). This Field will be defined as Primary Key, if the target data provider uses Keys (SQL Server Spatial, PostGIS, SQLite, etc.)
    • Extended Entity Data (EED): the exported data Table will include the objects data (EED/XDATA). You can choose which Tables and/or Fields will be exported
    • AutoCAD Map Data and AutoCAD Map Topologies: if there are AutoCAD Map Object Data or Topologies tables defined in the drawing, the exported data Table will include this data. You can choose which Object Data/Topologies Tables and/or Fields will be exported
    • General: when checked any of the following, the data Table will include new Fields for the corresponding AutoCAD object properties
      • Handle ('dwg_handle')
      • Color ('Color')
      • Layer ('Layer')
      • Line type ('Linetype')
      • Line weight ('Lineweight')
      • Hyperlink ('Hyperlink')
      • Thickness ('Thickness')
    • Blocks data: when checked any of the following, the data Table will include new Fields for the corresponding data of the Block References (if any)
      • Name and Attributes ('BlkName') ('Attribute Names')
      • Rotation ('BlkRotation')
      • Scales ('BlkXscale', 'BlkYscale', 'BlkZscale')
    • Texts data: when checked any of the following, the data Table will include new Fields for the corresponding data of the Text objects (if any)
      • Contents ('TxtString')
      • Rotation ('TxtRotation')
      • Height ('TxtHeight')
    • Hatches pattern data: when checked any of the following, the data Table will include new Fields for the corresponding data of the Hatch objects (if any)
      • Name ('HPatName')
      • Angle ('HPatAngle')
      • Scale (Spacing for User patterns) ('HPatScale')
      • Double (User patterns) ('HPatDouble')
    • Geometry
      • Elevation: when checked, the data Table will include a new Field ('Elevation') whose value will be the Elevation of the objects
        • Note: Regardless this option, the application will use the object Elevation as Z-coordinate when exporting any XY-only object (Circles, Polylines, etc.)
      • Point coordinates: when checked any of the following, the data Table will include new Fields for the corresponding X/Y/Z Coordinate values of the Point-type objects (if any)
        • X
        • Y
        • Z
        • Note: If the Coordinates are Transformed along the Exporting process (see this paragraph), the Transformed values will be exported instead of the original values
      • Length: when checked, the data Table will include a new Field ('Length') whose value will be the Length of the objects
      • Area: when checked, the data Table will include a new Field ('Area') whose value will be the Area of the objects
  • Other
    • Treat closed polylines as polygons: when checked (default value), all closed Polylines in the drawing will be exported to the target as Polygon features. Most of the time the closed polylines represent polygonal elements in the target data format and this conversion can be automatic
      • Note: Be aware that, in order to avoid forgetting objects, in this case and in any other case where polygonal objects are exported to a polyline-type target, the polygon contours will be exported as polylines
    • Also export fields with null values
      • If not checked (default value): when you export to a target table with uniform fields structure (such as Shapefiles SHP), the table will include any field which have a non-null value in at least one object of the export selection. When you export to a target table with non-uniform fields structure (such as KML), each object will only include the fields which have a non-null value for the object itself
      • If checked: in all cases, each object and thus the entire table, will include all the fields (null or non-null)
  • Objects report: the application shows here the total number of the objects which will be exported and any warnings prior to the export process, such as the total number of unsupported objects which will not be exported or others


When duplicate Fields will be automatically Renamed (by adding a correlative suffix) in the exported Tables?

  • When there are Fields that can be found in different Tables having the same Name but different Type. So that, those that can be found in different Tables but having the same Name and the same Type are considered as a single field
  • When a Field (for example "X") already exists for any object, and the export options force to add a Field with the same name (such as the "X" coordinate of the points)


"Back" button: As in the other application wizards, you will find the "Back" button in each step of the wizards in order to modify or add any previously introduced parameter. In the case of the "Export" wizard, this button is present even in the last step of the wizard and is applicable even after the export process is finished. Thus, if you detect that the export has failed or been incomplete due to some erroneous or partial parameter, you can comfortably repeat the process by modifying the wrong parameter(s) without having to modify any other

  • Tip: This tool can be an interesting time saver when you are exporting several types of objects to some target that only supports one particular type of object. For example, assume you want to export all the objects in the drawing (linear, polygonal, points) to Shapefiles. You can select to export "All objects" but when you define the type of feature that the Shapefile will contain you can only choose one type, since this is a limitation of Shapefiles. The application will filter the objects that can be exported to the chosen Shapefile type. But, once the export is finished, the "Back" button will allow you to choose another type of feature for the target Shapefile without modifying any other settings (object parameters, coordinate transformation, etc.) to quickly export the new type objects to another Shapefile
    • Note: The "Automatic" option that can be found when exporting to Shapefiles, also simplifies this task because the export process will automatically create a different Shapefile for each object type (Point, Polyline, etc.)


"Back" button on the last wizard step


How can I configure the spatial Target when exporting from AutoCAD?

When you export using Spatial Manager™ for AutoCAD you must to select the exporting destination. If needed, you also must to select the data provider and its parameters


Export destination

First, you select the destination for the exported data: a file or a table inside a file or a database (or inside a schema of a file or a database)


Export target file

Next, you select a file type (the data provider). This step is not required if you have selected a UDS-based destination which defines its own data provider and the provider parameters (such as a SQLite table, PostGIS table, a UDS for a simple file, etc.)


Data provider connection parameters

Then, you configure the export data provider connection parameters, if needed (Image: sample of the KML/KMZ files data provider)


Note: Although the application main palette (see Data sources) is the primary tool to manage resources and accesses, create/edit Shortcuts and User Data Sources (UDS), and other related functions, the context menus (righ-click) in this Export window, will also allow you to execute many of these functions "on the fly", without having to return to the main palette


Contextual options in the Export window


How can I define a Transformation of coordinates when exporting?

When you are Exporting AutoCAD objects as spatial Features using Spatial Manager™ for AutoCAD, you will see that you can choose a Transformation of coordinates from the source to the target, in the "Export" wizard. This means that the application will calculate a geometric transformation between the source and the target data, which will depend on the chosen CRS for the source (drawing) and for the target (outgoing Features) data. You can choose the appropriate CRSs by clicking on "CRS catalog...", in the CRS dropdown list for the source or for the target data. In the CRS Catalog you can:

  • Filter the CRSs by type (Geocentric, Projected, etc.)
  • Choose a CRS by clicking on its row in the Catalog
  • Search CRSs by typing the search criteria in the "Search" box. You can type as many words as you like here,separated by blanks. The application will find all the rows which include all these words in any column of the Catalog

After choosing a pair of valid CRS for a Transformation, you can choose the geographic Area to apply it to (the application will choose by default the most common Area for this Transformation)

If the application "knows", "guesses" or "can assume" the CRS of the source and/or the target data, they will be chosen by default. You will be able to modify this choice, except in cases where only one CRS is valid; for example, for a KML or a KMZ file the only valid choice is the CRS WGS84 (SRID 4326), because these types of file are always defined using this CRS

You can assign a CRS to the drawing, or modify it, using the command 'SPMSETCRS'. By executing this command, you will access the CRS Catalog of the application, described in the previous lines. In this case the Type "Projected" will be selected by default because is the most common choice

  • When exporting:
    • Those objects without assigned CRS will adopt the CRS of the drawing in the Transformation of coordinates
    • If all the objects to export have the same assigned CRS and the drawing has not an assigned CRS, the Transformation of coordinates will take the CRS of the objects as the source CRS by default

Note: To unassign (undefine) the Coordinate System of the drawing, choose "Undefined CRS" (EPSG 0)


  • Notes:
    • To unassign (undefine) the Coordinate System of the drawing, choose "Undefined CRS" (EPSG 0)
    • As you will see, the CRS dropdown lists will include more and more CRSs as they have been previously chosen in other Transformation operations, so that you can choose your "last-used" CRSs directly from the dropdown list without having to access the CRS Catalog all the time. In addition, the CRS Catalog window shown when you execute 'SPMSETCRS' to assign a CRS to the drawing, or modify it, also includes a list of the "last-used" CRSs (if any) in the upper zone
    • Coordinate Systems and Transformation details
    • Coordinate Systems objects available in the current version


Access to the CRS Catalog of the application


CRS Catalog of the application


'SPMSETCRS' command in the Spatial Manager™ for AutoCAD ribbon


Last used CRSs in the Catalog window


  • Notes about transformation Grid files:
    • Some coordinate transformations (NTv2, etc.) require one or more Grid files in order to be processed. Some of the most commonly used Grid files worldwide are included in the application, but you can see that some others instruct you on where to download Grid file(s) not included with the application (usually a download URL)
    • On the other hand, even if the required Grid file(s) already exists (included as standard in the application, or previously downloaded by the user), the application allows the user to choose an alternative Grid file(s) so that he can use more accurate or updated Grid transformations when more appropriated files are available. This custom choice for a Grid file is kept by default for a work session, but will not be memorized when exiting and re-entering the application


SPMSelGridCRSFile.png


Can I quickly Export the current drawing status (Publish) to Google Earth ("Standard" and "Professional" editions)

Yes, you can. Regardless of the advanced Export capabilities of Spatial Manager™ for AutoCAD which can be found in the "Professional" edition, the "Standard" and "Professional" editions of the application include a specific command (SPMCREATEKML) designed to Export all or part of the objects in the drawing and their data, to a KML or KMZ file (Google Earth) through a one-click operation. This exportation process considers the current Layers organization and the properties of the Layers and objects

  • The elements in the KML/KMZ file will assume the colors, line weights, etc. of the objects in the drawing. A subdivision based on the type(s) of the objects in the Layers will also be created for each Layer, allowing you a high level of visibility control in Google Earth
  • The values for the NAME and DESCRIPTION of the elements in the KML/KMZ file will be automatically taken from the data fields "Name" and "Description" if those exist
  • The Text objects will display their content as a Label in Google Earth (automatic Field "TxtString")


Export to Google Earth (KML/KMZ) command


The Exported (KML/KMZ) file can now be opened in Google Earth. As an extra, if Google Earth is installed on the computer where the Export process was performed you can even open it using a button in the Export report window. Nevertheless, upon completion of the Export process you can open the file location directly


Open file in Google Earth (if installed) or open file location


The file in Google Earth


You can export all the objects in a drawing, a selection of objects (Manual, by Query or by Table), or all the objects in a Layer

  • Notes:
    • Please take a look at the notes in the first article of this chapter in order to read more about many other advanced selection options
    • When choosing the option to export all objects in the drawing, those objects that are in locked, off or frozen layers will not be included. If the objects are selected by any means before exporting and the option to export the selected objects is chosen, they will be exported even if they are in locked, off or frozen layers


Publish to Google Earth (KML/KMZ) parameters window


You can choose whether, for objects with elevation or 3D values in their geometry, they are considered 2D (Flat, only their XY coordinates are taken) or 3D. In case Z-values are taken into account in the export, you can decide how the vertical relation of the objects with respect to the terrain (Altitude) is taken into consideration


Publish to Google Earth (KML/KMZ) parameters window


You can also specify a Fill Transparency for objects that can be opaque (Hatches, Faces, Polyfaces, ...)

As an additonal parameter, you can select the option to Fill the closed Polylines as if they were Polygons. Note that if you check this option, and a Polyline is already filled in the drawing (using a Hatch, for example) you will get two polygon elements for this Polyline in the exported KML/KMZ file


Filling closed Polylines in Google Earth


In addition, if the set of objects to be published includes any AutoCAD raster images, you can reduce their size by a percentage while processing. This can help you solve some of the problems in Google Earth concerning large images, which cause them to be missed or cropped


Reducing the size of images when publishing


The application needs to know the Coordinate System (CRS) of the drawing for Exporting, as in most cases this will be necessary to perform an automatic coordinate transformation to the CRS used in Google Earth. You will see a Warning window if the process cannot be carried out and you may need to assign a CRS to the drawing


'SPMSETCRS' command in the Spatial Manager™ for AutoCAD ribbon


You can read about CRSs, the CRS Catalog and the Transformation of coordinates in the previous article


Is there any limitation or modification in the original objects when exporting?

Yes, there are some limitations and there may also be automatic changes in the objects when they are exported using Spatial Manager™ for AutoCAD

  • Limitations:
    • Filtering of incompatible objects: there are a few object types not supported by the export processes (such as Texts, MTexts or complex 3D objects), which are automatically filtered. The filter result is displayed before exporting on the "Objects report" of the first exporting wizard window
  • Modifications
    • Some objects, such as Blocks or External References, are exported as Point Features (Insertion Points). In the case of the Blocks or XRef, you must Explode them before exporting if you want to export their internal objects. The "Objects report" in the first exporting wizard window also warns the user about the number of Blocks and XRef Insertions if any have been selected to export
    • Automatic complex geometric operations: the application will review and edit the selected objects in order to export geometries accommodated in the target format


Circle segmentation

Sample: segmentation of an AutoCAD Circle when exported to a Polygons Shapefile (SHP)


How are the Extended Entity Data (EED/XDATA) exported?

If the selected objects to be exported have attached data (XDATA / EEDs), this object data will also be exported as data tables linked to the outgoing Features, if the Target supports these data tables. The EED/XDATA can be attached when the objects are imported, by hand using the Data Structure Management tools or can be there by a combination of both cases. As you can see at the beginning of this chapter, you can choose which Tables and/or Fields will be exported


XDATA / EEDs to be exported


Can I export 'AutoCAD Architecture' (AEC) objects?

Yes, Spatial Manager™ for AutoCAD allows you to export 'AutoCAD Architecture' (AEC) objects. The main purpose of this functionality is exporting AEC "Spaces", which will be treated as closed Polylines in any exporting process

The export usefulness for these objects is limited because the AEC Properties are not exported


Exporting 'AutoCAD Architecture' (AEC) objects


Can I Export directly from a data source to another without first importing into AutoCAD?

Yes, you can directly Export/Convert from a data source to any supported data target by using the data sources contextual menu (righ-click) in the Main Spatial Manager™ for AutoCAD palette. This functionality allows you to run Export processes without having to previously import the elements from the source data table into an AutoCAD drawing, and you will find similar options (coordinate system transformation, etc.) to those you can find when exporting AutoCAD objects


Direct Export function


Direct Export parameters and options


Can I run Exporting processes in the Command Line?

Yes, Spatial Manager™ for AutoCAD includes the command '-SPMEXPORT' that allows you to execute parameters-driven Export processes in the Command Line

  • Command parameters:
    • Source (Mandatory)
      • All - All objects in drawing
      • Layer - Objects in a Layer (Layer name)
      • Selection - Selected objects
      • Table - Objects attached to a specific data Table (Table name)
    • Destination (Mandatory)
      • User datasource - UDS name, Schema, Feature class
      • File name - Full filename, including the file extension in order to select the data provider that must be used (Sample: C:\\Temp\\ExportLayer1.shp)
    • Geometry type (Optional. If not specified, all possible geometries will be exported - Same of "All")
      • All
      • Point
      • Line
      • Polygon
    • Run (Mandatory). To execute the command
  • This command allows you to automatize the Export processes by using it in "AutoCAD Scripts", Lisp routines, etc. Some samples of the use of this command and its parameters in Lisp:
    • (command "-SPMEXPORT" "_S" "_A" "_D" "_F" "D:\\SpmExport\\Test.shp" "_R")
    • (command "-SPMEXPORT" "_S" "_L" "Layer005" "_D" "_F" "D:\\ExportTarget\\005.shp" "_R")
    • (command "-SPMEXPORT" "_S" "_L" "Layer005" "_D" "_U" "SERVER112\\SQLSERVER2019 (SQL)" "EXPORT_TEST" "005_TABLE" "_R")
    • (setq LayerToExport (getvar "clayer")) (setq Path (strcat "D:\\ExportTarget\\" LayerToExport ".shp")) (command "-SPMEXPORT" "_S" "_L" LayerToExport "_D" "_F" Path "_G" "_L" "_R" )


Related links



Spatial Manager™ for AutoCAD product page Download Spatial Manager™ for AutoCAD