Spatial Manager™ for BricsCAD - FAQs: Databases

Introduction

• Objective of this section
  • To access spatial information tables included in spatial databases

• Topics in this section
  • Accessing spatial databases: UDSs definition using connection and setting parameters
  • Schemas and classes: structures of tables contained in databases

How can I access a data Table from a spatial database or data store? ("Standard" edition only)

To access spatial databases or data stores in Spatial Manager™ for BricsCAD, you need first to have defined a User Data Source (UDS) including all the parameters to connect with (to learn more about UDSs, see: Data sources page)

You can access a data Table from a spatial database or data store using the right-click menu over the Table item itself inside a container of the UDS (usually a Schema), in the "SpatialManager" palette, to import its content into a new or the current BricsCAD drawing. You can also double-click over the Table item itself, in the "SpatialManager" palette, to access and import its content into a new or the current BricsCAD drawing (this behaviour may be configured in the "Options" window of BricsCAD by running the SPMOPTIONS command)

File:Options Spatial Manager for BricsCAD.png

To perform the import process of the data Table, see: Import

Are there any other functions for the Tables? ("Standard" edition only)

Yes, you can Delete or Rename the Tables in Spatial Manager™ for BricsCAD using the right-click menu over the Table item itself. This is valid for Tables in spatial databases but not for Tables in data stores

How can I create a Schema in a spatial database? ("Standard" edition only)

You can create a Schema in a spatial database in Spatial Manager™ for BricsCAD using the right-click menu over the UDS. When creating, you can assign a name to the New Schema

Are there any other functions for the Schemas? ("Standard" edition only)

Yes, you can Delete or Rename the Schemas and Refresh the Schema contents in Spatial Manager™ for BricsCAD using the right-click menu over the Schema item itself. Be careful when you Delete a Schema because all the Tables that it contains will also be deleted. This is valid for Schemas in spatial databases but not for Schemas in data stores

Are there any other kind of data sources using Schemas or Tables? ("Standard" edition only)

Yes, you can find some Providers using Schemas or Tables in Spatial Manager™ for BricsCAD, besides spatial databases or data stores, like some types of files, such as SDF and more, or special connections, such as ODBC and more. Everything said here for Schemas and Tables is valid for these types of data sources

How can I see the Properties of Schemas or Tables? ("Standard" edition only)

You can see the Properties of Schemas or Tables in the "Properties" area of the "SpatialManager" palette in Spatial Manager™ for BricsCAD when you select any of those items in the "Data sources" area of this palette

Related links

• See "Data sources" also
• PostGIS or SQL Spatial data to basic AutoCAD? Sure (also applicable in Spatial Manager™ for BricsCAD) ("Standard" edition only)

• Go to FAQS