Difference between revisions of "Spatial Manager Desktop™ - FAQs: Data use"

From Spatial Manager Wiki
Jump to navigation Jump to search
(Created page with "*'''Objective of this section''' **To exploit graphics and alphanumeric data from the application into other applications and print maps or feature selections *'''Topics in t...")
 
m
 
(84 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
[[image:SPM Desktop Wiki to Website.png|150px|link=https://www.spatialmanager.com/spm-desktop/ |Spatial Manager Desktop™ product page]] [[image:SPM Desktop Wiki to Download.png|150px|link=https://www.spatialmanager.com/download/spatial-manager-desktop/ |Download Spatial Manager Desktop™]]
 +
 +
 +
 +
''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_Desktop%E2%84%A2_-_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_Desktop%E2%84%A2_-_FAQs:_Interface#Options|Service Provider API Keys settings through the application options]]''
 +
 +
 +
 +
===Introduction===
 
*'''Objective of this section'''
 
*'''Objective of this section'''
 
**To exploit graphics and alphanumeric data from the application into other applications and print maps or feature selections
 
**To exploit graphics and alphanumeric data from the application into other applications and print maps or feature selections
Line 4: Line 16:
 
*'''Topics in this section'''
 
*'''Topics in this section'''
 
**Exporting data: from the data grid
 
**Exporting data: from the data grid
**Copying to clipboard: feature selections or whole map. Vector or raster copies
+
**Copying to clipboard: Feature Selections or whole Map. Vector or raster copies
 
**Working in other applications: office applications and others
 
**Working in other applications: office applications and others
**Printing: current view, whole map, a map area or a features selection
+
**Printing: current view, whole Map, a Map area or a Features Selection
 +
 
 +
 
 +
 
 +
===How can I export alphanumeric data?===
 +
In Spatial Manager Desktop™ you can export alphanumeric data of the Features in the selected Layer to a CSV file (comma-separated values or character-separated values), by using the right-click menu over any place on the Data grid or by click on the button in the left bottom of the Data grid. When the export process is finished, you can use the CSV file in other applications, such as office or CAD applications
 +
 
 +
You can choose any extension in the name of the outgoing CSV file, but the application will suggest *.txt, *.csv, *.tab and *.asc, because they are the most commonly used extensions
 +
 
 +
 
 +
<span title="Export Data values from the 'Data grid'">[[Image:Export_data_function.png|border|Export Data values from the 'Data grid'|link=]]</span>
 +
 
 +
 
 +
<span title="Use the Data in Excel">[[Image:ExportData4.png|border|Use the Data in Excel|link=]]</span>
 +
 
 +
''Sample: open an exported CSV file in Microsoft Excel''
 +
 
 +
 
 +
You can export the data for the whole Layer or only for the selected Features in the Layer, if any. You can also choose the values separator and, if you want, you can add a first row in the outgoing CSV file including the names of the data table Fields
 +
 
 +
 
 +
<span title="'Export Data' options">[[Image:ExportData2.png|border|'Export Data' options|link=]]</span>
 +
 
 +
 
 +
As you can choose which Fields will be displayed in the Data grid, the exported CSV file will only include the data in these Fields. And, as you can also sort the Field columns in the Data grid by dragging the name of the Field to sort, the contents into the exported CSV file will also respect the columns order in the grid
 +
 
 +
 
 +
<span title="Show/Hide Fields in the 'Data grid' to choose what export">[[Image:ExportData3.png|border|Show/Hide Fields in the 'Data grid' to choose what export|link=]]</span>
 +
 
 +
 
 +
 
 +
===Can I copy data to the Windows Clipboard?===
 +
Yes, you can Copy data to the Windows Clipboard in Spatial Manager Desktop™ in several ways:
 +
*Copy the current view of a Map as an image, using the "Copy Bitmap" function in the "Start" ribbon
 +
*Copy all the Features included in the current view of a Map, if any, as vector objects, using the "Copy Vector" function in the "Start" ribbon
 +
*Copy the selected Features in a Map, if any, as vector objects, using the "Copy" function in the "Selection\Tools" ribbon
 +
*Copy the alphanumeric data of the selected Features in the Data grid, if any, by pressing CTRL+C. You can also copy the data using "Copy" from the Data grid right-click menu
 +
**The selected row(s) and header(s) (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, only the value of this field will be copied to the clipboard
 +
*Copy any data in the Properties panel, by placing the cursor over this data and pressing CTRL+C
 +
 
 +
After Copying the data to the Windows Clipboard in Spatial Manager Desktop™, you can Paste it into another Windows application that supports image, vector or text data in this operation
 +
 
 +
 
 +
<span title="'Copy to Clipboard' function (whole Map)">[[Image:ExportData5.png|border|'Copy to Clipboard' function (whole Map)|link=]]</span>
 +
 
 +
 
 +
<span title="'Copy to Clipboard' function (Selected Features)">[[Image:ExportData6.png|border|'Copy to Clipboard' function (Selected Features)|link=]]</span>
 +
 
 +
 
 +
<span title="'Copy to Clipboard' from the Data grid (Selected Features)">[[Image:SPM_Copy_DataGrid.png|border|'Copy to Clipboard' from the Data grid (Selected Features)|link=]]</span>
 +
 
 +
 
 +
Paste samples:
 +
 
 +
 
 +
<span title="Using the vector or the bitmap data in Word">[[Image:FileExportData7.png|border|Using the vector or the bitmap data in Word|link=]]</span>
 +
 
 +
''Sample 1: MS Word as vector objects. Ungroup them after Pasting and you can edit the objects in MS Word''
 +
 
 +
 
 +
<span title="Using the bitmap data in Excel">[[Image:FileExportData8.png|border|Using the bitmap data in Excel|link=]]</span>
 +
 
 +
''Sample 2: MS Excel as an image''
 +
 
 +
 
 +
<span title="Using the vector objects in AutoCAD">[[Image:FileExportData9.png|border|Using the vector objects in AutoCAD|link=]]</span>
 +
 
 +
''Sample 3: AutoCAD as vector objects. You will get Polylines, Points, etc., if you Paste them as AutoCAD objects''
 +
 
 +
 
 +
 
 +
===How can I Print?===
 +
You can print several views of a Map in Spatial Manager Desktop™ by using the "Print" drop-down button in the "Start" ribbon. The functions included in this button are the following:
 +
*Print the current view of the Map
 +
*Print the extents of the Map
 +
*Print an area of the Map defined by a window
 +
*Print the extents of the current selected Features of a Map (if any). You can also find this function in the "Selection\Tools" ribbon
 +
When you run any of these functions, you will get a "Print Preview" window to check the area to be printed. Furthermore, in this window, you can adjust the basic "Page Settings" and the horizontal and vertical alignments of the printed area inside the page
 +
 
 +
Note that, if you have chosen a Base Map as background, it will also be printed, if not, the "Background color" configured for the Map will be the printed color for any empty zone inside the selected area to print
 +
 
 +
 
 +
<span title="'Print' fucntion">[[Image:Print1.png|border|'Print' fucntion|link=]]</span>
 +
 
 +
 
 +
<span title="Printing Page setup">[[Image:PrintView.PNG|border|Printing Page setup|link=]]</span>
 +
 
 +
''Printing the current view of a Map''
 +
 
 +
 
 +
<span title="Printing Preview">[[Image:PrintSelected.PNG|border|Printing Preview|link=]]</span>
 +
 
 +
''Printing a set of selected Features of a Map''
 +
 
 +
 
  
 
==Related links==
 
==Related links==
 +
*Blog posts
 +
**[https://www.spatialmanager.com/export-alphanumeric-data-spatial-tables/ Export alphanumeric data from spatial tables]
 +
**[https://www.spatialmanager.com/exporting-points-data-coordinates/ Exporting Points (Data & Coordinates)]
 +
**[https://www.spatialmanager.com/trick-spatial-manager-desktop-copy-data-grid/ Trick – Spatial Manager Desktop. Copy from Data grid]
 +
 +
 +
*[[Spatial Manager Desktop™#FAQs|Go to FAQS]]
 +
 +
 +
 +
[[image:SPM Desktop Wiki to Website.png|150px|link=https://www.spatialmanager.com/spm-desktop/ |Spatial Manager Desktop™ product page]] [[image:SPM Desktop Wiki to Download.png|150px|link=https://www.spatialmanager.com/download/spatial-manager-desktop/ |Download Spatial Manager Desktop™]]

Latest revision as of 11:50, 16 June 2022

Spatial Manager Desktop™ product page Download Spatial Manager Desktop™


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 exploit graphics and alphanumeric data from the application into other applications and print maps or feature selections
  • Topics in this section
    • Exporting data: from the data grid
    • Copying to clipboard: Feature Selections or whole Map. Vector or raster copies
    • Working in other applications: office applications and others
    • Printing: current view, whole Map, a Map area or a Features Selection


How can I export alphanumeric data?

In Spatial Manager Desktop™ you can export alphanumeric data of the Features in the selected Layer to a CSV file (comma-separated values or character-separated values), by using the right-click menu over any place on the Data grid or by click on the button in the left bottom of the Data grid. When the export process is finished, you can use the CSV file in other applications, such as office or CAD applications

You can choose any extension in the name of the outgoing CSV file, but the application will suggest *.txt, *.csv, *.tab and *.asc, because they are the most commonly used extensions


Export Data values from the 'Data grid'


Use the Data in Excel

Sample: open an exported CSV file in Microsoft Excel


You can export the data for the whole Layer or only for the selected Features in the Layer, if any. You can also choose the values separator and, if you want, you can add a first row in the outgoing CSV file including the names of the data table Fields


'Export Data' options


As you can choose which Fields will be displayed in the Data grid, the exported CSV file will only include the data in these Fields. And, as you can also sort the Field columns in the Data grid by dragging the name of the Field to sort, the contents into the exported CSV file will also respect the columns order in the grid


Show/Hide Fields in the 'Data grid' to choose what export


Can I copy data to the Windows Clipboard?

Yes, you can Copy data to the Windows Clipboard in Spatial Manager Desktop™ in several ways:

  • Copy the current view of a Map as an image, using the "Copy Bitmap" function in the "Start" ribbon
  • Copy all the Features included in the current view of a Map, if any, as vector objects, using the "Copy Vector" function in the "Start" ribbon
  • Copy the selected Features in a Map, if any, as vector objects, using the "Copy" function in the "Selection\Tools" ribbon
  • Copy the alphanumeric data of the selected Features in the Data grid, if any, by pressing CTRL+C. You can also copy the data using "Copy" from the Data grid right-click menu
    • The selected row(s) and header(s) (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, only the value of this field will be copied to the clipboard
  • Copy any data in the Properties panel, by placing the cursor over this data and pressing CTRL+C

After Copying the data to the Windows Clipboard in Spatial Manager Desktop™, you can Paste it into another Windows application that supports image, vector or text data in this operation


'Copy to Clipboard' function (whole Map)


'Copy to Clipboard' function (Selected Features)


'Copy to Clipboard' from the Data grid (Selected Features)


Paste samples:


Using the vector or the bitmap data in Word

Sample 1: MS Word as vector objects. Ungroup them after Pasting and you can edit the objects in MS Word


Using the bitmap data in Excel

Sample 2: MS Excel as an image


Using the vector objects in AutoCAD

Sample 3: AutoCAD as vector objects. You will get Polylines, Points, etc., if you Paste them as AutoCAD objects


How can I Print?

You can print several views of a Map in Spatial Manager Desktop™ by using the "Print" drop-down button in the "Start" ribbon. The functions included in this button are the following:

  • Print the current view of the Map
  • Print the extents of the Map
  • Print an area of the Map defined by a window
  • Print the extents of the current selected Features of a Map (if any). You can also find this function in the "Selection\Tools" ribbon

When you run any of these functions, you will get a "Print Preview" window to check the area to be printed. Furthermore, in this window, you can adjust the basic "Page Settings" and the horizontal and vertical alignments of the printed area inside the page

Note that, if you have chosen a Base Map as background, it will also be printed, if not, the "Background color" configured for the Map will be the printed color for any empty zone inside the selected area to print


'Print' fucntion


Printing Page setup

Printing the current view of a Map


Printing Preview

Printing a set of selected Features of a Map


Related links



Spatial Manager Desktop™ product page Download Spatial Manager Desktop™