Difference between revisions of "Spatial Manager Desktop™ - FAQs: Databases"
m |
m |
||
| Line 1: | Line 1: | ||
===Introduction=== | ===Introduction=== | ||
*'''Objective of this section''' | *'''Objective of this section''' | ||
| − | **To load spatial information tables included in spatial databases | + | **To load spatial information tables included in spatial databases (not in Basic edition) |
*'''Topics in this section''' | *'''Topics in this section''' | ||
| − | **Accessing spatial databases: UDSs definition using connection and setting parameters | + | **Accessing spatial databases: UDSs definition using connection and setting parameters (not in Basic edition) |
| − | **Schemas and classes: structures of tables contained in databases | + | **Schemas and classes: structures of tables contained in databases (not in Basic edition) |
| − | **Other connections like ODBC, etc. | + | **Other connections like ODBC, etc. (not in Basic edition) |
| − | ===How can I load a data Table from a spatial database or data store into a Map?=== | + | ===How can I load a data Table from a spatial database or data store into a Map? (not in Basic edition)=== |
To access spatial databases or data stores in Spatial Manager Desktop™ you need first to have defined a User Data Source (UDS) including all the parameters to connect to (to learn more about UDSs, see: [[Spatial Manager Desktop™ - FAQs: Data sources| Data sources page]]) | To access spatial databases or data stores in Spatial Manager Desktop™ you need first to have defined a User Data Source (UDS) including all the parameters to connect to (to learn more about UDSs, see: [[Spatial Manager Desktop™ - FAQs: Data sources| Data sources page]]) | ||
| Line 23: | Line 23: | ||
| − | ===Are there any other functions for the Tables?=== | + | ===Are there any other functions for the Tables? (not in Basic edition)=== |
Yes, you can Delete or Rename the Tables in Spatial Manager Desktop™ 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 Desktop™ 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 | ||
| Line 31: | Line 31: | ||
| − | ===How can I create a Schema in a spatial database?=== | + | ===How can I create a Schema in a spatial database? (not in Basic edition)=== |
You can create a Schema in a spatial database in Spatial Manager Desktop™ 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 Desktop™ using the right-click menu over the UDS. When creating, you can assign a name to the New Schema | ||
| Line 39: | Line 39: | ||
| − | ===Are there any other functions for the Schemas?=== | + | ===Are there any other functions for the Schemas? (not in Basic edition)=== |
Yes, you can Delete or Rename the Schemas and Refresh the Schema contents in Spatial Manager Desktop™ 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 Desktop™ 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 | ||
| Line 47: | Line 47: | ||
| − | ===Are there any other kind of data sources using Schemas or Tables?=== | + | ===Are there any other kind of data sources using Schemas or Tables? (not in Basic edition)=== |
Yes, you can find some Providers using Schemas or Tables in Spatial Manager Desktop™, 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 | Yes, you can find some Providers using Schemas or Tables in Spatial Manager Desktop™, 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 | ||
| Line 55: | Line 55: | ||
| − | ===How can I see the Properties of Schemas or Tables?=== | + | ===How can I see the Properties of Schemas or Tables? (not in Basic edition)=== |
You can see the Properties of Schemas or Tables in the "Properties" panel of Spatial Manager Desktop™ when you select any of these items in the "Data sources" panel | You can see the Properties of Schemas or Tables in the "Properties" panel of Spatial Manager Desktop™ when you select any of these items in the "Data sources" panel | ||
| Line 64: | Line 64: | ||
==Related links== | ==Related links== | ||
| − | *[[Spatial Manager Desktop™ - FAQs: Data sources|See "Data sources" also]] | + | *[[Spatial Manager Desktop™ - FAQs: Data sources|See "Data sources" also]] (not in Basic edition) |
| − | *[http://www.spatialmanager.com/export-tables-from-postgis-or-sql-server-spatial/ Export tables from PostGIS or SQL Server Spatial] | + | *[http://www.spatialmanager.com/export-tables-from-postgis-or-sql-server-spatial/ Export tables from PostGIS or SQL Server Spatial] (not in Basic edition) |
| − | *[http://www.spatialmanager.com/from-wfs-servers-to-shp-files-easily/ From WFS servers to SHP files easily] | + | *[http://www.spatialmanager.com/from-wfs-servers-to-shp-files-easily/ From WFS servers to SHP files easily] (not in Basic edition) |
*[[Spatial Manager Desktop™#FAQs|Go to FAQS]] | *[[Spatial Manager Desktop™#FAQs|Go to FAQS]] | ||
Revision as of 05:49, 26 October 2014
Introduction
- Objective of this section
- To load spatial information tables included in spatial databases (not in Basic edition)
- Topics in this section
- Accessing spatial databases: UDSs definition using connection and setting parameters (not in Basic edition)
- Schemas and classes: structures of tables contained in databases (not in Basic edition)
- Other connections like ODBC, etc. (not in Basic edition)
How can I load a data Table from a spatial database or data store into a Map? (not in Basic edition)
To access spatial databases or data stores in Spatial Manager Desktop™ you need first to have defined a User Data Source (UDS) including all the parameters to connect to (to learn more about UDSs, see: Data sources page)
You can load 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 "Data sources" panel, to load its content into a new or existing Map. You can also double-click over the Table item itself, in the "Data sources" panel, to load its content into a new or existing Map (this behaviour may be configured in the application settings)
Are there any other functions for the Tables? (not in Basic edition)
Yes, you can Delete or Rename the Tables in Spatial Manager Desktop™ 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? (not in Basic edition)
You can create a Schema in a spatial database in Spatial Manager Desktop™ 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? (not in Basic edition)
Yes, you can Delete or Rename the Schemas and Refresh the Schema contents in Spatial Manager Desktop™ 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? (not in Basic edition)
Yes, you can find some Providers using Schemas or Tables in Spatial Manager Desktop™, 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? (not in Basic edition)
You can see the Properties of Schemas or Tables in the "Properties" panel of Spatial Manager Desktop™ when you select any of these items in the "Data sources" panel
Related links
- See "Data sources" also (not in Basic edition)
- Export tables from PostGIS or SQL Server Spatial (not in Basic edition)
- From WFS servers to SHP files easily (not in Basic edition)