Spatial Manager™ for AutoCAD - FAQs: Import

From Spatial Manager Wiki
Revision as of 08:40, 9 October 2024 by Ignacio (talk | contribs)
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 import processes and their parameters and manage coordinate transformations
  • Topics in this section
    • Sources: data sources
    • Import parameters: AutoCAD objects parameters, Fills, Labels, AutoCAD properties, XDATA / Extended Entity Data (EED) ("Standard" and "Professional" editions only), etc.
    • Transforming the coordinates: source and target, last used coordinate systems, searching in the coordinate systems table and transformation parameters
    • Reviewing and editing objects data
    • Direct importing (SPMIMPORT)
    • Batch importing
    • Tasks: save and replay import processes, manage tasks
    • Importing from the Command Line


How can I Import spatial Features as AutoCAD Objects?

You can Import spatial Features as AutoCAD Objects into Spatial Manager™ for AutoCAD by using the contextual menu (mouse right-click) on any table or spatial file in the "Data sources" area of the "SpatialManager" palette. This will launch the "Import" wizard of the application. As you will see, you can import the table or the file in the current or a new drawing (see also "How to import directly into the current drawing?" below).


Import a file or a table into AutoCAD using the contextual menu


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


Import Parameters window


  • Points and Centroids options. Here you can define the options for point type Features and for centroids of Polygons (if you choose any option to draw centroids in the Polygons options). This area will be disabled if the application "knows" there are no points or centroids to draw
    • Import as AutoCAD Points
    • Import as Blocks. This item will be disabled if there are no Block definitions in the drawing
      • Select a Block definition. You can select:
        • A Block Name in the drawing or
        • Choose the option "Use Field values for Name...", allowing you to select the Block definition to use for the point Features or Centroids depending on the value of a Field in the data table. If this value do not match any Name among the Block Names in the drawing, the application will use AutoCAD Points to import the corresponding point Features or Centroids. If you choose this option, the "Block options" window (see next paragraph) will be automatically opened allowing you to select the Field for the Block Names
      • Block options. Here you can choose the Field for the Block Names (see the previous paragraph), the correspondence between Fields (if any in the data source) and Block Attributes (if any in the Block definition), the option to use or not LUPREC for decimal places (see Notes below) and the Block Insertion parameters, such as the Rotation and the Scales, from values of Fields in the data source. This item will be disabled if there are no Attributes in the Block definition and there are no numeric Fields in the data source
        • Notes:
          • When Inserting, the Rotation of the Block References will consider the positive angles direction defined according to the value of the System Variable ANGDIR (Please, take a look to ANGDIR and UNITS in the AutoCAD Help)
          • You can choose that the value of the LUPREC variable (Length precision) be used or not for the number of decimal places when writing Attributes to a numerical field (Please, take a look to LUPREC and UNITS in the AutoCAD Help). This option also affects the numeric field Labels and can also be changed there (See Label options below)
  • Lines and Borders options. Here you can define the options for linear type Features and for borders of Polygons (if you choose any option to draw borders in the Polygons options). This area will be disabled if the application "knows" there are no lines or borders to draw
    • Import as AutoCAD Polylines, Polylines 2D or Polylines 3D
    • Insert Nodes (of Polylines) as AutoCAD Points
  • Polygons options. Here you can define the options for polygonal type Features. This area will be disabled if the application "knows" there are no polygons to draw
    • Import Borders, Borders and Centroids, Centroids only, Polygons or Polygons and Centroids
      • There are two interesting options here (Polygons and Polygons and Centroids) which allow you to select MPolygons as the type of object to use. These options are available on all compatible Autodesk products (even on vanilla, plain or basic AutoCAD) (AutoCAD 2011 and upper). The MPolygons can be defined by multiple rings, even including holes, as a single AutoCAD object
    • Fill areas using Hatches. This item will be disabled if you have chosen the option to import as "Only Centroids"
      • Hatch options. Here you can define the options for the Hatches such as Pattern, Angle and Scale (except for "Solid" pattern), Apply Transparency to the Hatch (whenever AutoCAD supports the Transparency property) and if the Hatch is Associative or not. Some of these parameters can be taken from Fields in the data source
  • Label options
    • Label objects using field value. You can select any Field to create Text objects in AutoCAD in order to label the incoming objects by reading the text strings from this Field. Each Text object will go to the same layer of the labeled object. The Polygon labels will be placed at the Polygon Centroid position and the Polylines will be labeled according to a scheme that considers the lengths of the different segments ("smart" labeling")
      • Label options. You can define the Style, Height, Justification, Rotation and Rotation Units of the Text objects here. Some of these parameters can be taken from Fields in the data source. For linear objects you can also specify the separation in drawing units between labels to be repeated along the object, or if you want a single label for each object. As added parameters, you can set the option to use or not LUPREC for decimal places (see Notes below) and configure if you want to insert the imported geometry and its Label or the Label only. Be careful: if you check this box you will only get the Labels (Text objects) but not the imported objects. This option may be interesting to Label drawings which already have graphic information or Background maps. If the option Mask labels is checked, masks will be generated (Wipeout objects, grouped with the Labels) and they will "trim" the objects located behind the Labels in order to improve its reading
      • Notes:
        • When Labeling, the Rotation of the Texts will consider the positive angles direction defined according to the value of the System Variable ANGDIR (Please, take a look to ANGDIR and UNITS in the AutoCAD Help)
        • You can choose that the value of the LUPREC variable (Length precision) be used or not for the number of decimal places when labeling objects using a numerical field (Please, take a look to LUPREC and UNITS in the AutoCAD Help). This option also affects the Attributes to numerical fields options writing process and can also be changed there (See Block options above)
        • Object data (EED/XDATA) are not attached to the Labels, even when the option "Import Features data as objects Extended Entity Data (EED)" is checked (see below)
        • Label Masks may have some functional issues or may not be available in versions earlier than AutoCAD 2017
        • In addition to the labeling functionality when importing objects, the 'SPMLABEL' command is also available, which allows you to label data for imported or user-created objects
  • General options
    • Layer/Table name. This setting defines the target Layer name for the imported objects. You can select an existing Layer in the drawing or you can write the name to create a new Layer (the application will propose a suitable name that will depend on the data source)
      • Note that this is also the name of the data Table that will be used if you also import the objects data, which will be done if the source includes any data attached to the geometric elements and you select the option "Import Features data as objects Extended Entity Data (EED)" (see below)
      • If this setting is left blank, the target Layer will be the current Layer in the drawing. The used Table name (if any) will also be the name of the current Layer
      • As you can see in the next setting, the Layer name can be variable for each object but the Table name for the attached data will be unique for all the imported objects
    • Use Field values for Layer. Here you can select any Field to define its value as the name of the Layer for the imported objects. If this value is null for any object, or the setting is left blank, the object will be drawn in the Layer selected in the previous setting
      • Note that this setting is only for the name of the target Layer but not for the Table name, if any (read above)
    • Apply random colors to new Layers
    • Use Field values for Object Elevation and/or Thickness
      • Take advantage of the Elevation values and use a Field to get the Z-coordinate of Points, Polylines or Polygons. Think about 3D Points, Contours, etc., coming from 2D Geometries. Combined with the Thickness value you can define, for example, buildings raising from an elevation and with a specific height
    • Import as 2D Objects (Z coordinate of the geometry will be ignored). This option lets you "flatten" all the imported objects on the XY plane. Please note that if you have selected using the values in a field for the Elevations of the objects (see the previous paragraph), the XY plane will be placed at the corresponding object Elevation
    • Import Features data as Objects Extended Entity Data (EED) ("Standard" and "Professional" editions only). If you choose this option, when you select Objects in the drawing, you will see the Objects EEDs (or XDATA) in the "Properties" area of the "SpatialManager" palette
      • Notes:
        • The fields whose value starts with "http" are automatically converted into active links
        • If the option "Insert only the labels and omit the objects" is checked (see above), this option is disabled so that an empty data table is not created
    • Import only Features in the current view. This option lets you skip importing any objects outside the current drawing view
      • Notes:
        • "Outside" means that the whole bounding box of an object is outside the view
        • This option will be disabled when the importing process is performed using the palette contextual function "Import into a new drawing"


Entity data and "http" case


How can I define a Transformation of coordinates?

When you are Importing Features as AutoCAD Objects using Spatial Manager™ for AutoCAD, you will see that you can choose a Transformation of coordinates from the source Features to the objects in the drawing, in the "Import" 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 (incoming Features) and for the target (imported AutoCAD objects) 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 table you can:

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

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 (drawing) data, it 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 importing a table defined using a known CRS into a drawing without an assigned CRS, the CRS of the table is automatically assigned to the drawing
  • If you change the target CRS by choosing any CRS other than the drawing CRS, you will get a warning from the application but you can continue and perform the Transformation of coordinates if you want to


  • 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
    • If the incoming data is defined using the CRS "WGS84 (SRID 4326)" and the drawing has not assigned any CRS, the transformation to the CRS "WGS 84 / Pseudo-Mercator (SRID 3857)" is selected by default to get a projected map instead of a flat representation of geodesic coordinates
    • 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


How can I speed up the starting Import process?

Sometimes, depending on the characteristics of the source, the initial reading of the data Fields may take a long time or even block the Importing process. Spatial Manager™ for AutoCAD performs this startup reading to allow you to choose certain options relating to this data on the next wizard window, such as the use of the field values to define the target Layers for the imported Objects. However you have a button available to "Skip" this step, which does not affect the imported Objects themselves but only certain options that may not be available in the Importing process


Skip fields window


How can I speed up the Import wizard steps?

To speed up the process when you are importing, all the "Import" wizard windows in Spatial Manager™ for AutoCAD include the "Finish" button. By pressing this button, you will directly run the Import process. The wizard will assume the default values in each step to be omitted


Finish (skip steps) button


Can I see the data of the imported Features? ("Standard" and "Professional" editions only)

Yes, you can see the data of the imported Features in Spatial Manager™ for AutoCAD, because this data is also imported as EED (Extended Entity Data or XDATA) attached to the resulting Objects in the drawing. To see it, select an imported Object in AutoCAD and its data will be shown in the group "Data" of the "Properties" area in the "SpatialManager" palette

In addition to the XDATA / EED, you will see some other Object data, such as its Layer or its Bounding box, in other groups, such as "General" or "Geometry"


Objects data in the application palette


When selecting multiple Objects, you will see their common data here. All the data which is not equal for the selection, will be shown as "Various"

Note: Because of performance considerations, the number of objects selected for which their data are shown in the application palette is limited by the system variable PROPOBJLIMIT (AutoCAD 2012 and upper) or to 25000 (AutoCAD 2008 to 2011)


"Various" case in the object data display


Alternatively, you can use the Spatial Manager™ for AutoCAD 'Data Grid' palette ("Professional" edition only) in order to view, edit, select, export, etc. the objects data in a table form


'Data Grid' palette


Learn more about the 'Data Grid' and all its features and functions


Can I modify the field values of the objects data? ("Standard" and "Professional" editions only)

Yes, you can directly edit a field value (XDATA / EED Direct data edition) for one or more objects in Spatial Manager™ for AutoCAD by selecting the object(s) in the drawing and typing the new value for this field in the "Properties" area of the "SpatialManager" palette. You can also delete the field content to get a null value in this field. To validate any modification, you need to press Enter or click on a different field

Note: Because of performance considerations, the number of objects selected for which their data are shown in the application palette is limited by the system variable PROPOBJLIMIT (AutoCAD 2012 and upper) or to 25000 (AutoCAD 2008 to 2011)


Direct data edit in the Properties area


As you can read in the previous article, you can use the Spatial Manager™ for AutoCAD 'Data Grid' palette ("Professional" edition only) in order to view, edit, select, export, etc. the objects data in a table form

Learn more about the 'Data Grid' and all its features and functions


Can I modify the objects data structure? ("Standard" and "Professional" editions only)

Yes, you can Add, Modify or Delete fields in a table structure as well as Create, Restore, Edit, Rename and Delete data tables. Learn more about the "Data Structure Management"


Table definition window


How to import directly into the current drawing?

In addition to importing Features from the Palette, the 'SPMIMPORT' command of Spatial Manager™ for AutoCAD allows you to import the Features directly into the current drawing without having to open the application Palette. The displayed window is similar to the Data Sources section of the Palette and once the import source is selected, the "Import" wizard includes the same steps and parameters that have been detailed in the paragraphs above


Import directly window


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 direct Import 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 Import window


Is there any way to import in one go the content of all the files from a folder (batch import)

Yes, Spatial Manager™ for AutoCAD provides this functionality through the contextual menu of the folders in the application palette


Contextual function to Import in one go the content of all the files from a folder


When executing "Import all" you can define some basic parameters:

  • Create a layer for each File or Table
    • You may want to mark this option for example when the information contained in each file or table is not homogenous
    • You may want to unmark this option for example when you are importing the same class of objects split in a grid
    • When the "Table" option is selected and there are several files to import, the name of the Layers will be formed by the File name and the corresponding Table name
  • Fill areas using Hatches
    • This option will be applied to all the Polygonal objects imported from any file
  • Select a CRS for unreferenced sources
    • Since the "Import all" process will transform the coordinates between the sources and the drawing when needed, you can select a CRS for those sources without a defined CRS (if any). You will find the following options:
      • Drawing CRS (if defined)
      • CRS defined in another source that has been included in the current "Import-all" process (if any)
      • Other CRS, which can be selected using the same ways as when you run any Import process. Please, take a look at this article
  • Working path
    • Defines a location where the application will save any auxiliary files required throughout the Import-all process
      • For example, Raster image files created when importing images that need to be transformed (coordinate transformation, etc.)
      • If this parameter is left blank, the application will ask you where to save each auxiliary file when necessary


"Import all" basic options window


Note: When using this function, if the drawing is unreferenced the most suitable CRS will be automatically assigned to the drawing


Is there any way to import in one go the content of all schemas in a User Data Source (UDS) or all tables in a schema or file (advanced batch import)

Yes, Spatial Manager™ for AutoCAD provides a functionality similar to that of the previous section when it comes to batch importing all schemas from a data source or all tables in a schema or file


"Import all" schemas or tables in a schema


What are the Tasks? ("Professional" edition only)

The Tasks in Spatial Manager™ for AutoCAD are the way you can save any import process and its parameters, that have been designed to let you run, whenever you want, repetitive processes for import data tables in AutoCAD. You can access Tasks through the "Task manager" area in the "SpatialManager" palette

The processes of importing tables from files, servers or data stores in AutoCAD may be executed on a regular basis and sometimes these processes require the introduction of several more or less complex parameters of the source and the importing process itself, performing a coordinate transformation between the origin and target (drawing), etc. Spatial Manager™ for AutoCAD brings to you the concept of “Task”, that allows you to store all needed operations and parameters for any import process of spatial information. Once all necessary operations and parameters are saved as a Task, you can then run it from the Task Manager whenever you need


"Task manager" area in the application palette


How can I create a new Task? ("Professional" edition only)

You can create new Tasks in Spatial Manager™ for AutoCAD using the "New task" button in the "Task manager", but you can also create a new Task when you are defining an import process because you will then run the same application wizard. Any of these methods lets you run the process immediately and/or save it as a Task at the end of the wizard

In the same way as when you define the import processes, you will need to enter all the parameters to access the origin data table, the import process parameters, the coordinate system transformation parameters (if any), the name of the Task and a description of the Task (optional). All this data is saved into the "Task manager" as a new Task, until you want to delete it

Note: be careful if you select the option "Import only Features in the current view" because it will be also stored as a parameter in the Task and, when the Task be executed, the drawing view may be different from the current view


Creata a new Task


How can I execute one or more Tasks? ("Professional" edition only)

You can select one or more Tasks in the "Task manager" of Spatial Manager™ for AutoCAD using the CTRL and/or SHIFT keys. To execute the selected Tasks, use the right-click menu over any of the Task names and click on "Execute" or use the "Execute" button

All the executed Tasks will run one by one and import the incoming objects in the current drawing


Execute one or more Tasks


When executing the Task(s) you will see the window showing all the actions performed by the Task(s) and, if you want to, you can cancel any process before the end


Cancel a Task


Can I see the Properties of a Task? ("Professional" edition only)

Yes, you can see the Properties of the selected Task (only one) in the "Properties" area of the Spatial Manager™ for AutoCAD palette


Properties of a Task


Can I sort the Tasks in the "Task manager"? ("Professional" edition only)

You cannot change the relative positions of the Tasks in the "Task manager", but you can sort the Tasks in Spatial Manager™ for AutoCAD by selecting the "Sort" button as follows:

  • Group by source: you will see the Tasks grouped by their source data source
  • Plain list: you will see a list of all Tasks sorted by date of creation


Sort Tasks button


Are there any other functions for the Tasks? ("Professional" edition only)

Yes, you can Delete and Rename the Tasks in Spatial Manager™ for AutoCAD using the right-click menu over the Task item (only one), in the "Task manager". You can also "Refresh" the Task list, using the "Refresh" button in the "Task manager", if you make changes to your data sources in the current work session


Delete or rename a Task


Button for Refresh the Task list


Can I run Importing processes in the Command Line?

Yes, Spatial Manager™ for AutoCAD includes the command '-SPMIMPORT' that allows you to execute any saved Task in the Command Line

The command syntax is -SPMIMPORT [Task name]

Since the parameter "Task name" support wildcards, you can process multiple Tasks simultaneously (batch processing) and use it in "AutoCAD Scripts"


Sample script using '-SPMIMPORT'


Related links



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

Retrieved from "https://wiki.spatialmanager.com/index.php?title=Spatial_Manager™_for_AutoCAD_-_FAQs:_Import&oldid=12627"