Difference between revisions of "Spatial Manager™ for AutoCAD - FAQs: Databases"
Jump to navigation
Jump to search
m |
m |
||
| (30 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | [[image:SPM AutoCAD Wiki to Website.png|150px|link=https://www.spatialmanager.com/spm-forautocad/ |Spatial Manager™ for AutoCAD product page]] [[image:SPM AutoCAD Wiki to Download.png|150px|link=https://www.spatialmanager.com/download/spatial-manager-autocad/ |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 [[Spatial_Manager%E2%84%A2_for_AutoCAD_-_FAQs:_Interface#Options|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 [[Spatial_Manager%E2%84%A2_for_AutoCAD_-_FAQs:_Interface#Options|Service Provider API Keys settings through the application options]]'' | ||
| + | *''For most of Database providers, all the information that is applied in this chapter to '''"Tables" also applies to "Views"''''' | ||
| + | |||
| + | |||
| + | |||
===Introduction=== | ===Introduction=== | ||
*'''Objective of this section''' | *'''Objective of this section''' | ||
| Line 9: | Line 21: | ||
| − | ===How can I access a data Table from a spatial database or data store?=== | + | ===How can I access a data Table from a spatial database or data store? ("Standard" and "Professional" editions only)=== |
To access spatial databases or data stores in Spatial Manager™ for AutoCAD, you need first to have defined a User Data Source (UDS) including all the parameters to connect with (to learn more about UDSs, see: [[Spatial Manager™ for AutoCAD - FAQs: Data sources| Data sources page]]) | To access spatial databases or data stores in Spatial Manager™ for AutoCAD, you need first to have defined a User Data Source (UDS) including all the parameters to connect with (to learn more about UDSs, see: [[Spatial Manager™ for AutoCAD - FAQs: Data sources| 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" | + | 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 AutoCAD 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 AutoCAD drawing (this behaviour may be configured through the tab "Spatial Manager" in the "Options" window of AutoCAD or by running the SPMOPTIONS command) |
| − | [[Image:DBACAD-1.png|border]] | + | <span title="Import a table from a spatial database into AutoCAD">[[Image:DBACAD-1.png|border|Import a table from a spatial database into AutoCAD|link=]]</span> |
| − | [[Image: | + | <span title="Configure the double-click option">[[Image:Options_Spatial_Manager_for_AutoCAD3.png|border|Configure the double-click option|link=]]</span> |
| − | To perform the import process of the data Table, see: [[Spatial Manager™ for AutoCAD - FAQs: Import | Import]] | + | To perform the import process of the data Table, see: [[Spatial Manager™ for AutoCAD - FAQs: Import | Import]]</span> |
| − | ===Are there any other functions for the Tables?=== | + | ===Are there any other functions for the Tables? ("Professional" edition only)=== |
Yes, you can Delete or Rename the Tables in Spatial Manager™ for AutoCAD 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 | Yes, you can Delete or Rename the Tables in Spatial Manager™ for AutoCAD 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 | ||
| − | [[Image:DBACAD-2.png|border]] | + | <span title="Delete or rename a table in a spatial database">[[Image:DBACAD-2.png|border|Delete or rename a table in a spatial database|link=]]</span> |
| − | ===How can I create a Schema in a spatial database?=== | + | ===How can I create a Schema in a spatial database? ("Professional" edition only)=== |
You can create a Schema in a spatial database in Spatial Manager™ for AutoCAD using the right-click menu over the UDS. When creating, you can assign a name to the New Schema | You can create a Schema in a spatial database in Spatial Manager™ for AutoCAD using the right-click menu over the UDS. When creating, you can assign a name to the New Schema | ||
| − | [[Image:DBACAD-3.png|border]] | + | <span title="Create a schema in a spatial database">[[Image:DBACAD-3.png|border|Create a schema in a spatial database|link=]]</span> |
| − | ===Are there any other functions for the Schemas?=== | + | ===Are there any other functions for the Schemas? ("Professional" edition only)=== |
Yes, you can Delete or Rename the Schemas and Refresh the Schema contents in Spatial Manager™ for AutoCAD 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 | Yes, you can Delete or Rename the Schemas and Refresh the Schema contents in Spatial Manager™ for AutoCAD 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 | ||
| − | [[Image:DBACAD-4.png|border]] | + | <span title="Delete or rename a schema in a spatial database">[[Image:DBACAD-4.png|border|Delete or rename a schema in a spatial database|link=]]</span> |
===Are there any other kind of data sources using Schemas or Tables?=== | ===Are there any other kind of data sources using Schemas or Tables?=== | ||
| − | Yes, you can find some Providers using Schemas or Tables in Spatial Manager™ for AutoCAD, besides spatial databases or data stores, like some types of files, such as | + | Yes, you can find some Providers using Schemas or Tables in Spatial Manager™ for AutoCAD, besides spatial databases or data stores, like some types of files, such as SQLite and more, or special connections, such as ODBC ("Standard" and "Professional" editions only) and more. Everything said here for Schemas and Tables is valid for these types of data sources |
| − | [[Image:DBACAD-5.png|border]] | + | <span title="Import a table from a User Data Source (UDS) into AutoCAD">[[Image:DBACAD-5.png|border|Import a table from a User Data Source (UDS) into AutoCAD|link=]]</span> |
===How can I see the Properties of Schemas or Tables?=== | ===How can I see the Properties of Schemas or Tables?=== | ||
| − | You can see the Properties of Schemas or Tables in the "Properties" area of the "SpatialManager" | + | You can see the Properties of Schemas or Tables in the "Properties" area of the "SpatialManager" palette in Spatial Manager™ for AutoCAD when you select any of those items in the "Data sources" area of this palette |
| − | [[Image:DBACAD-6.png|border]] | + | <span title="Properties of schemas and tables in the application palette">[[Image:DBACAD-6.png|border|Properties of schemas and tables in the application palette|link=]]</span> |
| Line 67: | Line 79: | ||
==Related links== | ==Related links== | ||
*[[Spatial Manager™ for AutoCAD - FAQs: Data sources|See "Data sources" also]] | *[[Spatial Manager™ for AutoCAD - FAQs: Data sources|See "Data sources" also]] | ||
| − | *[ | + | *Blog posts |
| + | **[https://www.spatialmanager.com/postgis-sql-server-basic-autocad-yes/ PostGIS or SQL Spatial data to basic AutoCAD? Sure] ("Standard" and "Professional" editions only) | ||
| + | **[https://www.spatialmanager.com/spatial-filter-views-in-postgis-or-sql-server/ Spatial filter Views in PostGIS or SQL Server] ("Standard" and "Professional" editions only) | ||
*[[Spatial Manager™ for AutoCAD#FAQs|Go to FAQS]] | *[[Spatial Manager™ for AutoCAD#FAQs|Go to FAQS]] | ||
| + | |||
| + | |||
| + | |||
| + | [[image:SPM AutoCAD Wiki to Website.png|150px|link=https://www.spatialmanager.com/spm-forautocad/ |Spatial Manager™ for AutoCAD product page]] [[image:SPM AutoCAD Wiki to Download.png|150px|link=https://www.spatialmanager.com/download/spatial-manager-autocad/ |Download Spatial Manager™ for AutoCAD]] | ||
Latest revision as of 11:28, 16 June 2022
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
- For most of Database providers, all the information that is applied in this chapter to "Tables" also applies to "Views"
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" and "Professional" editions only)
To access spatial databases or data stores in Spatial Manager™ for AutoCAD, 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 AutoCAD 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 AutoCAD drawing (this behaviour may be configured through the tab "Spatial Manager" in the "Options" window of AutoCAD or by running the SPMOPTIONS command)
To perform the import process of the data Table, see: Import
Are there any other functions for the Tables? ("Professional" edition only)
Yes, you can Delete or Rename the Tables in Spatial Manager™ for AutoCAD 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? ("Professional" edition only)
You can create a Schema in a spatial database in Spatial Manager™ for AutoCAD 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? ("Professional" edition only)
Yes, you can Delete or Rename the Schemas and Refresh the Schema contents in Spatial Manager™ for AutoCAD 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?
Yes, you can find some Providers using Schemas or Tables in Spatial Manager™ for AutoCAD, besides spatial databases or data stores, like some types of files, such as SQLite and more, or special connections, such as ODBC ("Standard" and "Professional" editions only) 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?
You can see the Properties of Schemas or Tables in the "Properties" area of the "SpatialManager" palette in Spatial Manager™ for AutoCAD when you select any of those items in the "Data sources" area of this palette
Related links
- See "Data sources" also
- Blog posts
- PostGIS or SQL Spatial data to basic AutoCAD? Sure ("Standard" and "Professional" editions only)
- Spatial filter Views in PostGIS or SQL Server ("Standard" and "Professional" editions only)