Difference between revisions of "Spatial Manager™ for GstarCAD - FAQs: Advanced Selection ("Standard" and "Professional" editions only)"

From Spatial Manager Wiki
Jump to navigation Jump to search
m
m
(11 intermediate revisions by the same user not shown)
Line 11: Line 11:
 
===Introduction===
 
===Introduction===
 
*'''Objective of this section'''
 
*'''Objective of this section'''
**To learn how to define data tables and how to attach the data to the entities in a GstarCAD drawing
+
**To learn how to select GstarCAD entities in a Data and/or Geometric relationship basis
  
 
*'''Topics in this section'''
 
*'''Topics in this section'''
**Data tables: create, restore, rename, edit or delete
+
**Select entities based on data queries
**Fields in data tables: create, edit or delete. Field types
+
**Select entities which are attached to a specific table
**Data grid
+
**Select entities based on spatial queries
**Attach data to entities
 
**Detach data from entities
 
**Select entities based on their data
 
**Select entities in the drawing which are attached to a specific table
 
 
**Zoom to the selection
 
**Zoom to the selection
  
  
  
*'''''NOTE for Imported entities''': keep in mind that in the [[Spatial Manager™ for GstarCAD - FAQs: Import | Importing processes]] the data tables may be automatically defined and the imported entities will be automatically attached to the data tables. All everything you read here applies to these cases''
+
*'''''NOTES:'''''
*'''''NOTE about the performance of the selections''': the selection of entities in GstarCAD may be a few slower when the "SpatialManager" palette is open, depending on the data of the entities''
+
**'''''Entities Data''': You can learn more about Tables and attached Data in the [[Spatial Manager™ for GstarCAD - FAQs: Data Structure Management ("Standard" and "Professional" editions only) | Data Structure Management]] chapter''
 
+
**'''''Selections performance''': The selection of entities in GstarCAD may be a few slower when the "SpatialManager" palette is open, depending on the data of the entities''
 
+
**'''''Complex and mixed selections''': In addition to the use of the below commands or in combination with them, you can make use of selecting entities in the [[Spatial_Manager%E2%84%A2_for_GstarCAD_-_FAQs:_Data_Structure_Management_(%22Standard%22_and_%22Professional%22_editions_only)#Can_I_view_and_edit_the_entities_data_in_a_table_form.3F_.28.22Professional.22_edition_only.29|Data Grid]] or by using any other selection method available in GstarCAD (Quick Select, etc.). Also note that, as most of the advanced application or GstarCAD 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''
 
 
===How can I define data tables in a drawing?===
 
The command 'SPMDATATABLEDEFINE' of Spatial Manager™ for GstarCAD lets you create new data tables in a drawing as well as modify them. Also use this command if you need to rename or delete data tables. You will find this command in the "Spatial Manager" ribbon, toolbar or drop-down menu
 
 
 
 
 
<span title="'SPMDATATABLEDEFINE' command in the Spatial Manager™ for GstarCAD Ribbon (Can also be found in the drop-down Menu and Toolbar of Spatial Manager)">[[Image:SpatialManagerforBricsCAD-DefineTable.png|border|'SPMDATATABLEDEFINE' command in the Spatial Manager™ for GstarCAD Ribbon (Can also be found in the drop-down Menu and Toolbar of Spatial Manager)|link=]]</span>
 
 
 
 
 
<span title="Table definition window">[[Image:SPMDefineTableWinACAD4.PNG|border|Table definition window|link=]]</span>
 
 
 
''Table definition window''
 
 
 
 
 
Click on the "New Table" button to create a new (empty) data table. Select a data table in the drop-down list to rename it ("Rename Table" button), delete it ("Delete Table" button) or to modify it:
 
*Add Field. To add a new field in the selected data table
 
**Name. The field name, unique in the selected data table
 
**Type. You can select the field type in the drop-down list: Text, Integer, Date, etc. The field type cannot be changed if you want to modify the field later
 
**Default value. The default value for this field when the corresponding data table is attached to one or more entities
 
*Modify Field. To edit the selected field of the selected data table (view "Add Field" above)
 
*Delete Fields. To delete the selected fields of the selected data table
 
 
 
''Note: In brackets the Length of the Field (and the number of decimal places, when applicable)''
 
 
 
 
 
<span title="Add / Modify field window">[[Image:SPMAddFieldACAD.PNG|border|Add / Modify field window|link=]]</span>
 
 
 
''Add / Modify field window''
 
 
 
 
 
The following is the behavior of the application when you modify a data table which is already attached to one or more entities in the drawing:
 
*Adding a field: the new field is added to all the attached entities. If a "Default value" has been defined for the field, this will be the value assigned to the field for these entities
 
*Modifying a field: only the name of the field (if modified) will be changed for all the attached entities
 
*Deleting a field: the field will be erased for all the attached entities
 
 
 
 
 
As you can see in the Tables selection dropdown, there is a "scan new tables..." option to retrieve data Table structures from the drawing entities. This is useful when "Copying/Cutting and Pasting" entities from one drawing to another, when saving drawings using WBLOCK, when inserting a drawing into another, etc.
 
 
 
 
 
 
 
===How to attach a data table to one or more entities?===
 
When you want to attach an existing data table to one or more entities in the drawing, you can execute the command 'SPMDATATABLEATTACH' of Spatial Manager™ for GstarCAD. You will find this command in the "Spatial Manager" GstarCAD ribbon, toolbar or drop-down menu
 
 
 
 
 
<span title="'SPMDATATABLEATTACH' command in the Spatial Manager™ for GstarCAD Ribbon (Can also be found in the drop-down Menu and Toolbar of Spatial Manager)">[[Image:SpatialManagerforBricsCAD-Attach.png|border|'SPMDATATABLEATTACH' command in the Spatial Manager™ for GstarCAD Ribbon (Can also be found in the drop-down Menu and Toolbar of Spatial Manager)|link=]]</span>
 
 
 
 
 
<span title="Attach a data table to entities window">[[Image:SPMAttachACADWindow.png|border|Attach a data table to entities window|link=]]</span>
 
 
 
 
 
First, choose a data table in the list of defined data tables in the command window. Then, the attach operation can be applied to the selected entities (if any) or to a new entities selection
 
 
 
'''WARNING''': An entity can be attached to one data table only, so if you attach it to a new data table the previously data attached to this entity (if any) WILL BE LOST
 
 
 
 
 
 
 
===How can I modify the entities data?===
 
You can directly edit a field value (XDATA / EED Direct data edition) for one or more entities in Spatial Manager™ for GstarCAD by selecting the entity (or entities) 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
 
 
 
 
 
<span title="Direct data edit in the Properties area">[[Image:EED-3.PNG|border|Direct data edit in the Properties area|link=]]</span>
 
 
 
 
 
''Notes:''
 
*''The fields whose value starts with "http" are automatically converted into active links''
 
*''Because of performance considerations, the number of entities selected for which their data are shown in the application palette is limited to 25000''
 
 
 
 
 
 
 
===Is there any way to detach the data from the entities?===
 
Yes, you can detach any data from one or more entities by executing the command 'SPMDATATABLEDETACH' of Spatial Manager™ for GstarCAD. You will find this command in the "Spatial Manager" GstarCAD ribbon, toolbar or drop-down menu
 
 
 
 
 
<span title="'SPMDATATABLEDETACH' command in the Spatial Manager™ for GstarCAD Ribbon (Can also be found in the drop-down Menu and Toolbar of Spatial Manager)">[[Image:SpatialManagerforBricsCAD-Detach.png|border|'SPMDATATABLEDETACH' command in the Spatial Manager™ for GstarCAD Ribbon (Can also be found in the drop-down Menu and Toolbar of Spatial Manager)|link=]]</span>
 
 
 
 
 
<span title="Detach the data window">[[Image:SPMDetachACADWindow.PNG|border|Detach the data window|link=]]</span>
 
 
 
 
 
The detach operation can be applied to the selected entities (if any) or to a new entities selection
 
 
 
'''WARNING''': All the current data attached to the entities (if any) WILL BE LOST
 
  
  
  
 
===Can I define a selection of entities based on the values of their data?===
 
===Can I define a selection of entities based on the values of their data?===
The command 'SPMSELECTBYQUERY' in 'Spatial Manager™ for GstarCAD' allows you select entities in the drawing according to the result of a simplex or compound data query
+
The command 'SPMSELECTBYQUERY' in 'Spatial Manager™ for GstarCAD' allows you select entities in the drawing according to the result of simple or compound data queries
  
  
Line 137: Line 52:
  
  
You can use the command 'SPMZOOMTOSELECTION' (see below) to quickly zoom into the selection extent
+
''Note: You can use the command 'SPMZOOMTOSELECTION' (see below) to quickly zoom to the selection extent''
  
  
Line 154: Line 69:
  
  
''Note: You can use the command 'SPMZOOMTOSELECTION' (see below) to quickly zoom to the selection extent''  
+
''Note: You can use the command 'SPMZOOMTOSELECTION' (see below) to quickly zoom to the selection extent''
 +
 
 +
 
  
 +
===Can I define a selection of entities based on their geometric relationship?===
 +
The command 'SPMSPATIALQUERY' in 'Spatial Manager™ for GstarCAD' allows you select entities in the drawing according to the result of advanced simple or compound spatial queries
  
  
===Is there any way to locate on the screen all the selected entities?===
+
<span title="'SPMSPATIALQUERY' command in the Spatial Manager™ for GstarCAD ribbon">[[Image:SPMSpatialQuery.png|'SPMSPATIALQUERY' command in the Spatial Manager™ for GstarCAD ribbon|link=]]</span>
Yes, the 'Spatial Manager™ for GstarCAD' 'SPMZOOMTOSELECTION' command, zooms to the current selection extent so you can locate all the selected entities in an optimal size view
 
  
  
<span title="'SPMZOOMTOSELECTION' command in the Spatial Manager™ for GstarCAD Ribbon (Can also be found in the drop-down Menu and Toolbar of Spatial Manager)">[[Image:SpatialManagerforBricsCAD-ZoomSelection.png|'SPMZOOMTOSELECTION' command in the Spatial Manager™ for GstarCAD Ribbon (Can also be found in the drop-down Menu and Toolbar of Spatial Manager)|link=]]</span>
+
[[image:SPMSpatialQueryGCAD.png|border|900px|Advanced selection by processing Spatial Queries|link={{filepath:SPMSpatialQueryGCAD.png}}]]
  
  
<span title="Zoom to the current selection extent">[[Image:ZoomToSelection.png|border|Zoom to the current selection extent|link=]]</span>
+
''Advanced selection by processing Spatial Queries''
  
  
''Note: This functionality can be very handy as a complement to the two previous selection commands, but also if it is used with other GstarCAD selection functions''
+
<span title="Spatial Query parameters window">[[image:SPMSpatialQueryGCADWin.png|border|link=]]</span>
  
  
 +
This function allows you to select entities in the drawing by performing "geometric operations" between two groups of entities: "Selection" (Group 1) and "Query with" (Group 2). For example, according to the chosen parameters in this image, all the Hydrants (points) that are located within a Parcel (polygons) would be selected
  
===Can I view and edit the entities data in a table form? ("Professional" edition only)===
 
Yes, the command 'SPMDATATABLEGRID' of Spatial Manager™ for GstarCAD opens the 'Data Grid' palette where you can view, edit, etc. the entities data in any table in the drawing. You can also select entities from the 'Data Grid', export the data from the tables and more
 
  
 +
*'''Parameters and options'''
 +
**Entities selection (Group 1 and Group 2)
 +
***''Only selected entities'': A set of entities will be selected. You can select the entities before executing this command (for one of the Groups) or by using the Selecting buttons in this window
 +
****Manual selection
 +
****Select by Query: Select entities according to the result of a simplex or compound data query [[#Can_I_define_a_selection_of_entities_based_on_the_values_of_their_data.3F|''(See "Selecting by Query")'']]
 +
****Select by Table: Select entities which have been previously attached to a specific data table [[#Can_I_select_all_the_entities_attached_to_the_same_data_table.3F|''(See "Selecting by Table")'']]
 +
***''Select entities in a layer'': All the entities in a GstarCAD Layer will be selected. You can select the layer using the drop-down list in this window
 +
**Spatial operation
 +
***''Intersects'': A geometry Intersects another one if they have at least a point in common. It is the opposite of 'Disjoint'. For example, combined with [[Spatial_Manager%E2%84%A2_for_GstarCAD_-_FAQs:_GIS_Analysis_(%22Professional%22_edition_only)#Buffer|''Buffers'']], entities that are located at a certain distance from other entities, which will normally be points or linear entities (such as buildings located at a certain distance from road or street axes, etc.)
 +
***''Touches'': A geometry Touches another one if they have common points only at their boundaries, without intersection and no one of them contains or is equal to the other. For example, buildings touching another building within a block of contiguous buildings (the drawing must be very precise because no intersections should occur)
 +
***''Within'': A geometry is Within another one if it is completely inside or they are equal. It is the inverse of 'Contains'. For example, to select points representing pharmacies within a neighborhood, polygons representing hospitals within a municipality or buildings within a parcel, etc.
 +
***''Contains'': A geometry Contains another one if the second one is completely inside of the first one or they are equal. Is is the inverse of 'Within'. For example, to select all the parcels in a municipality that contain one or more buildings
 +
***''Disjoint'': A geometry is Disjoint from another one if they do not have any points in common (that is, "out of": It does not intersect and does not touch). It is the opposite of 'Intersects'
 +
***''Overlaps'': A geometry Overlaps another one if they have areas in common, but no one of them is fully inside the other one and they are not equal. For example, polygons that intersect, but none of them are completely inside each other, i.e., " they cross". A practical case could be the selection of buildings in one municipality that are located partially within the boundary of the municipality and partially within the boundary of another adjacent municipality
 +
***''Crosses'': A geometry (linear entitiy) Crosses another one if it has at the same time parts inside and outside of the second one. For example, to select road sections that are partially located within the boundaries of two or more municipalities
  
<span title="'SPMDATATABLEGRID' command in the Spatial Manager™ for GstarCAD ribbon">[[Image:SPMDataGridCAD-AB.png|border|'SPMDATATABLEGRID' command in the Spatial Manager™ for GstarCAD ribbon|link=]]</span>
 
  
 +
''Note: You can use the command 'SPMZOOMTOSELECTION' (see below) to quickly zoom to the selection extent''
  
Like any GstarCAD palette, the 'Data Grid' palette can be arranged, docked, undocked, grouped, self-collapsed, etc., and resized, depending on the preferences and needs of each user or each job, by dragging its title bar, double-clicking on its title bar, etc.
 
  
  
<span title="'Data Grid' palette">[[Image:SPMDataTableGridCAD.png|border|'Data Grid' palette|link=]]</span>
+
===Is there any way to locate on the screen all the selected entities?===
 +
Yes, the 'Spatial Manager™ for GstarCAD' 'SPMZOOMTOSELECTION' command, zooms to the current selection extent so you can locate all the selected entities in an optimal size view
  
  
*To choose the drawing data table that you want to show in the 'Data Grid', you can use the drop-down list of available tables that can be found in the palette upper left area
+
<span title="'SPMZOOMTOSELECTION' command in the Spatial Manager™ for GstarCAD Ribbon (Can also be found in the drop-down Menu and Toolbar of Spatial Manager)">[[Image:SpatialManagerforBricsCAD-ZoomSelection.png|'SPMZOOMTOSELECTION' command in the Spatial Manager™ for GstarCAD Ribbon (Can also be found in the drop-down Menu and Toolbar of Spatial Manager)|link=]]</span>
**You can select which table fields you want to display in the 'Data Grid' by right-clicking on any grid area
 
**You can move the field separation lines in the table header to change the width of the corresponding column
 
***A double click on this vertical line (always in the table header) will automatically adjust the corresponding column width to the dimension of the longest value in that field
 
***If the value of a field in a given row cannot be seen as complete due to the width of the column, placing the cursor over the corresponding cell will display a tooltip displaying the full value in that cell. The same applies to the names of the fields in the table header
 
**To sort the values of a column alphabetically, click on the column name in the table header. A second click will invert the sorting
 
**To move and sort the fields (columns) in the table you can drag the field name itself in the table header to the left or right
 
***If you hover the cursor in the table header over the name of a field, a tooltip with information about the properties of that field (Name, Type, Length, etc.) will be displayed (except when the incomplete name of a field is displayed as a tooltip - see above)
 
*The 'Data Grid' is automatically synchronized with the current drawing
 
**You can select entities in the drawing in order to highlight the corresponding attached rows in the 'Data Grid'
 
***If the "Automatic scroll" option (palette upper right area) is activated, the rows will be automatically scrolled to show the selected entities
 
**You can also select rows in the 'Data Grid' in order to select the corresponding attached entities in the drawing. You can use the CTRL and SHIFT keys (alone or in combination) when you want to select multiple rows
 
***If the "Automatic zoom" option (palette upper right area) is activated, the drawing view will be adjusted to the selected entities extent
 
****Use "Zoom to selection" (right-click menu) at any time if you want to do the same thing by hand, or "Zoom to object" if you only want to zoom to the entity under the cursor in the grid when right-clicking
 
***If the "Automatic centering" option (palette upper right area) is activated, the drawing view will be centered on the selected entities without modifying the zoom level
 
****Use "Center selection" (right-click menu) at any time if you want to do the same thing by hand, or "Center object" if you only want to center the entity under the cursor in the grid when right-clicking
 
***As long as you are focused on the grid rows, you can use the keyboard (Up, Down, CTRL+Up, etc.) to navigate through the rows, and the SPACE key to select rows (you will see a small "tick" checked on the row header when you select it)
 
***Use the selection functions (buttons set on top of the palette / right-click menu) if you want to Select All entities attached to the current table, Invert the selected entities (see note below) or Deselect all selected entities
 
**Use "Delete" (buttons set on top of the palette / right-click menu) to delete selected entities and their data from the drawing  (see note below)
 
**You can find information about the number of selected entities and the total number of entities, as well as navigation buttons between the rows selected in the table, in the palette lower left area
 
**Under some circumstances, synchronization may be lost. To resynchronize drawing and 'Data Grid', use the "Refresh" button next to the tables dropdown (upper left area of the palette)
 
***For application performance reasons, sometimes a warning will be displayed to indicate that you need to manually refresh the 'Data Grid'. For example, this may happen when a very large number of entities are deleted in the drawing
 
***Also for performance reasons, the selection of entities may need to use the "Activate table of selected objects" button, located to the right of the previous one, in order to update the table shown in the data grid
 
****If this button is enabled, the table shown in the grid is not attached to any of the selected entities. Pressing it will display the table attached to the selected entity, or to one of the selected entities if there are more than one
 
****When the button is disabled, the table shown in the grid is the table attached to one of the selected entities, or none of the selected entities are attached to any table
 
*To edit the value in a cell, simply double-click on the cell. You can also click or press ENTER on the "active" cell to edit its value. To finish the edition, press the ENTER key or the TAB key (edit next field in the same row), or select any other cell or row in the table. To cancel editing, press the ESC key
 
**Pressing CTRL+ENTER will allow you to assign the current value in a cell to all cells in the same column for all selected rows
 
**Pressing SHIFT+ENTER will allow you to assign the current value in a cell to all cells in the same column for all rows
 
*You can export to an ASCII file the data in the whole table or in the selected rows only by running "Export" (buttons set on top of the palette / right-click menu)
 
**As you will see, you can include the field names in the export process and choose the field delimiter and the extension of the exported file
 
  
  
<span title="'Export data' options">[[Image:SPMExportGridCAD.png|border|'Export data' options|link=]]</span>
+
<span title="Zoom to the current selection extent">[[Image:ZoomToSelection.png|border|Zoom to the current selection extent|link=]]</span>
  
  
*Alternatively you can copy the table information to the Windows clipboard by using "Copy" (buttons set on top of the palette / right-click menu) or by pressing CTRL+C
+
''Note: This functionality can be very handy as a complement to the previous selection commands, but also if it is used with other GstarCAD selection functions''
**The selected rows and headers (field names) will be copied in a tab-separated format, suitable for pasting into a spreadsheet, ASCII editor, etc.
 
**As an exception, if a field is being edited (see above), only the value of this field will be copied to the clipboard
 
*From the buttons set on top of the palette you can also directly access the tables main management commands
 
**Select by query ([[#Can I define a selection of entities based on the values of their data?|SPMSELECTBYQUERY]])
 
**Select by table ([[#Can I select all the entities attached to the same data table?|SPMSELECTBYTABLE]])
 
**Define table ([[#How can I define data tables in a drawing?|SPMDATATABLEDEFINE]])
 
**Attach ([[#How to attach a data table to one or more entities?|SPMDATATABLEATTACH]])
 
**Detach ([[#Is there any way to detach the data from the entities?|SPMDATATABLEDETACH]])
 
*''Notes:''
 
**''When you use grid functions that affect selected entities (Invert, Delete, etc.), the selection refers only to those entities linked to the current table. For example when Deleting, the entities selected in the current table will be deleted but not other entities selected in the drawing (if any), which will be deselected before the deletion operation''
 
**''The "Feature_ID" column in the tables indicates the GstarCAD Handle of the entity (unique and unrepeatable for each entity in the drawing). These values cannot be edited''
 
**''If a table to which entities in the drawing are attached does not appear in the table drop-down list, try to [[Spatial Manager™ for GstarCAD - FAQs: Data Structure Management ("Standard" and "Professional" editions only)#How can I define data tables in a drawing?|"Restore" tables]] as these entities may be in the drawing after copying-pasting between drawings, inserting one drawing into another, etc.''
 
**''If closed, the application will automatically open the 'Data Grid' palette the first time you import any data source that includes a data table (EED/XDATA)''
 
  
  
  
 
==Related links==
 
==Related links==
*[https://www.spatialmanager.com/combine-quick-select-and-select-by-query/ Combine Quick select and Select by Query]
+
*Blog posts
*''Developed for other CAD applications prior to the release of Spatial Manager™ for GstarCAD but also applicable''
+
**[https://www.spatialmanager.com/combine-quick-select-and-select-by-query/ Combine Quick select and Select by Query]
**[https://www.spatialmanager.com/select-by-query-in-autocad-and-bricscad/ Select by query in GstarCAD]
+
**[https://www.spatialmanager.com/locating-polygons-crossed-by-specific-linear-objects/ Locating polygons crossed by specific linear entities]
**[https://www.spatialmanager.com/retrieve-existing-data-values-when-querying/ Retrieve existing data values when querying]
+
**''Developed for other CAD applications prior to the release of Spatial Manager™ for GstarCAD but also applicable''
**[https://www.spatialmanager.com/analysis-of-parcels-crossed-by-a-road/ Analysis of parcels crossed by a road]
+
***[https://www.spatialmanager.com/select-by-query-in-autocad-and-bricscad/ Select by query in GstarCAD]
 +
***[https://www.spatialmanager.com/retrieve-existing-data-values-when-querying/ Retrieve existing data values when querying]
 +
***[https://www.spatialmanager.com/analysis-of-parcels-crossed-by-a-road/ Analysis of parcels crossed by a road]
  
  

Revision as of 01:28, 25 August 2021

Spatial Manager™ for GstarCAD product page Download Spatial Manager™ for GstarCAD


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


Introduction

  • Objective of this section
    • To learn how to select GstarCAD entities in a Data and/or Geometric relationship basis
  • Topics in this section
    • Select entities based on data queries
    • Select entities which are attached to a specific table
    • Select entities based on spatial queries
    • Zoom to the selection


  • NOTES:
    • Entities Data: You can learn more about Tables and attached Data in the Data Structure Management chapter
    • Selections performance: The selection of entities in GstarCAD may be a few slower when the "SpatialManager" palette is open, depending on the data of the entities
    • Complex and mixed selections: In addition to the use of the below commands or in combination with them, you can make use of selecting entities in the Data Grid or by using any other selection method available in GstarCAD (Quick Select, etc.). Also note that, as most of the advanced application or GstarCAD 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


Can I define a selection of entities based on the values of their data?

The command 'SPMSELECTBYQUERY' in 'Spatial Manager™ for GstarCAD' allows you select entities in the drawing according to the result of simple or compound data queries


'SPMSELECTBYQUERY' command in the Spatial Manager™ for GstarCAD Ribbon (Can also be found in the drop-down Menu and Toolbar of Spatial Manager)


  • The query can be applied to one data table or to all the data tables defined in the drawing
  • Click on the "+" button to add at least one condition and so create a data query (a condition that stands for "Property & Comparator & Value")
  • When you are defining a compound query, you can add as many conditions as you want to the conditions list . Click on the "+" button each time you need to add a condition
    • You can select the logical operators "And" or "Or" when adding new conditions. "And" will be the default operator
  • In addition, if there is any entity selected when you run the command, you can:
    • Apply the query to the current selection, and not to the entire drawing, or,
    • Keep the current selection so the new "query selection" will be added to the current selection
  • Notes:
    • You can choose and search (...) among the available values for a Field
    • The command keeps the list of query conditions used the last time it was executed
    • If there are no results during a query, the command window is shown again and keeps the list of query conditions
    • You can use the "-" button every time you need to remove a condition from the conditions list in the query, or you can use the Clean button (the "broom") to remove all query conditions from the list


Define selection queries window


Note: You can use the command 'SPMZOOMTOSELECTION' (see below) to quickly zoom to the selection extent


Can I select all the entities attached to the same data table?

Yes, you can select all the entities which have been previously attached to a specific data table. To do that, execute the command 'SPMSELECTBYTABLE' of Spatial Manager™ for GstarCAD. You will find this command in the "Spatial Manager" GstarCAD ribbon, toolbar or drop-down menu


'SPMSELECTBYTABLE' command in the Spatial Manager™ for GstarCAD Ribbon (Can also be found in the drop-down Menu and Toolbar of Spatial Manager)


Select entities by table window


To choose the one you want, click on the data tables drop-down list


Note: You can use the command 'SPMZOOMTOSELECTION' (see below) to quickly zoom to the selection extent


Can I define a selection of entities based on their geometric relationship?

The command 'SPMSPATIALQUERY' in 'Spatial Manager™ for GstarCAD' allows you select entities in the drawing according to the result of advanced simple or compound spatial queries


'SPMSPATIALQUERY' command in the Spatial Manager™ for GstarCAD ribbon


Advanced selection by processing Spatial Queries


Advanced selection by processing Spatial Queries


SPMSpatialQueryGCADWin.png


This function allows you to select entities in the drawing by performing "geometric operations" between two groups of entities: "Selection" (Group 1) and "Query with" (Group 2). For example, according to the chosen parameters in this image, all the Hydrants (points) that are located within a Parcel (polygons) would be selected


  • Parameters and options
    • Entities selection (Group 1 and Group 2)
      • Only selected entities: A set of entities will be selected. You can select the entities before executing this command (for one of the Groups) or by using the Selecting buttons in this window
      • Select entities in a layer: All the entities in a GstarCAD Layer will be selected. You can select the layer using the drop-down list in this window
    • Spatial operation
      • Intersects: A geometry Intersects another one if they have at least a point in common. It is the opposite of 'Disjoint'. For example, combined with Buffers, entities that are located at a certain distance from other entities, which will normally be points or linear entities (such as buildings located at a certain distance from road or street axes, etc.)
      • Touches: A geometry Touches another one if they have common points only at their boundaries, without intersection and no one of them contains or is equal to the other. For example, buildings touching another building within a block of contiguous buildings (the drawing must be very precise because no intersections should occur)
      • Within: A geometry is Within another one if it is completely inside or they are equal. It is the inverse of 'Contains'. For example, to select points representing pharmacies within a neighborhood, polygons representing hospitals within a municipality or buildings within a parcel, etc.
      • Contains: A geometry Contains another one if the second one is completely inside of the first one or they are equal. Is is the inverse of 'Within'. For example, to select all the parcels in a municipality that contain one or more buildings
      • Disjoint: A geometry is Disjoint from another one if they do not have any points in common (that is, "out of": It does not intersect and does not touch). It is the opposite of 'Intersects'
      • Overlaps: A geometry Overlaps another one if they have areas in common, but no one of them is fully inside the other one and they are not equal. For example, polygons that intersect, but none of them are completely inside each other, i.e., " they cross". A practical case could be the selection of buildings in one municipality that are located partially within the boundary of the municipality and partially within the boundary of another adjacent municipality
      • Crosses: A geometry (linear entitiy) Crosses another one if it has at the same time parts inside and outside of the second one. For example, to select road sections that are partially located within the boundaries of two or more municipalities


Note: You can use the command 'SPMZOOMTOSELECTION' (see below) to quickly zoom to the selection extent


Is there any way to locate on the screen all the selected entities?

Yes, the 'Spatial Manager™ for GstarCAD' 'SPMZOOMTOSELECTION' command, zooms to the current selection extent so you can locate all the selected entities in an optimal size view


'SPMZOOMTOSELECTION' command in the Spatial Manager™ for GstarCAD Ribbon (Can also be found in the drop-down Menu and Toolbar of Spatial Manager)


Zoom to the current selection extent


Note: This functionality can be very handy as a complement to the previous selection commands, but also if it is used with other GstarCAD selection functions


Related links



Spatial Manager™ for GstarCAD product page Download Spatial Manager™ for GstarCAD