Difference between revisions of "Spatial Manager Desktop™ - FAQs: Data use"
m |
m |
||
(22 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=== | ===Introduction=== | ||
*'''Objective of this section''' | *'''Objective of this section''' | ||
Line 12: | Line 23: | ||
===How can I export alphanumeric data?=== | ===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 | 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 | ||
− | [[Image:Export_data_function.png|border]] | + | <span title="Export Data values from the 'Data grid'">[[Image:Export_data_function.png|border|Export Data values from the 'Data grid'|link=]]</span> |
− | [[Image:ExportData4.png|border]] | + | <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'' | ''Sample: open an exported CSV file in Microsoft Excel'' | ||
Line 28: | Line 39: | ||
− | [[Image:ExportData2.png|border]] | + | <span title="'Export Data' options">[[Image:ExportData2.png|border|'Export Data' options|link=]]</span> |
Line 34: | Line 45: | ||
− | [[Image:ExportData3.png|border]] | + | <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> |
Line 43: | Line 54: | ||
*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 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 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 | + | *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 | *Copy any data in the Properties panel, by placing the cursor over this data and pressing CTRL+C | ||
Line 49: | Line 62: | ||
− | [[Image:ExportData5.png|border]] | + | <span title="'Copy to Clipboard' function (whole Map)">[[Image:ExportData5.png|border|'Copy to Clipboard' function (whole Map)|link=]]</span> |
− | [[Image:ExportData6.png|border]] | + | <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> | ||
Line 58: | Line 74: | ||
− | [[Image:FileExportData7.png|border]] | + | <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'' | ''Sample 1: MS Word as vector objects. Ungroup them after Pasting and you can edit the objects in MS Word'' | ||
− | [[Image:FileExportData8.png|border]] | + | <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'' | ''Sample 2: MS Excel as an image'' | ||
− | [[Image:FileExportData9.png|border]] | + | <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 | + | ''Sample 3: AutoCAD as vector objects. You will get Polylines, Points, etc., if you Paste them as AutoCAD objects'' |
Line 85: | Line 101: | ||
− | [[Image:Print1.png|border]] | + | <span title="'Print' fucntion">[[Image:Print1.png|border|'Print' fucntion|link=]]</span> |
− | [[Image:PrintView.PNG|border]] | + | <span title="Printing Page setup">[[Image:PrintView.PNG|border|Printing Page setup|link=]]</span> |
''Printing the current view of a Map'' | ''Printing the current view of a Map'' | ||
− | [[Image:PrintSelected.PNG|border]] | + | <span title="Printing Preview">[[Image:PrintSelected.PNG|border|Printing Preview|link=]]</span> |
''Printing a set of selected Features of a Map'' | ''Printing a set of selected Features of a Map'' | ||
Line 100: | Line 116: | ||
==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]] | *[[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
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
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
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
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
Paste samples:
Sample 1: MS Word as vector objects. Ungroup them after Pasting and you can edit the objects in MS Word
Sample 2: MS Excel as an image
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
Printing the current view of a Map
Printing a set of selected Features of a Map
Related links
- Blog posts