Data Export

Function Description

Data Export Application provides the export function of 20 data formats. For supported export formats, see Data Export Supported Data Formats in Type Conversion Supported Data Formats .

Function entrance

  • Start tab-> Data Processing drop-down menu-> Data Export.
  • Context Menu of Manager- > Dataset or Datasource- > Export Dataset in Workspace.

Operation steps

  1. Click the Home tab-> Data Processing drop-down menu-> Data Export button to bring up the Data Import dialog.
  2. Click the Add button in the toolbar, or double-click the Dataset cell in the list box. On the left side of the pop-up Select dialog, the All Data source of Current Workspace is listed. The list on the right side of the dialog box lists the name and type of the All Data set in the selected Datasource. You can select one or more Datasets and click the OK button to add the files to be exported from Current Workspace to the data list.
  3. All the added data will be displayed in the list box on the left side of the Data Export dialog, and you can add, remove, or collectively modify the attributes of the Export Dataset with the aid of the toolbar above the list box. The list box is described as follows:
    • Dataset: shows the name of the Dataset to be exported.
    • Export Type: The system will automatically identify the format of Export Type according to the selected Dataset Type. You can also click the Drop-down Button of the Export Type item to select other data formats in the drop-down list;
    • Result File: The name of the exported File, which is the same as the Dataset Name by default. You can also rename the Export File by double-clicking the column. Select the Dataset to be renamed. Click the Result File item or the F2 key on the keyboard, and the Result File becomes editable. You can enter a new File Name as the exported File Name.
    • Export Path: displays the default path of Data Export, and users can also Change the export path of Dataset: select the Dataset to modify the export path, and double-click the Export Path item. You can Change the Export Path of the Dataset in the pop-up Browse Folder window. Note: If the exported Unexisted path, the program will automatically create the Target File folder.
    • Overwrite: This check box is used to set whether to overwrite or not to overwrite an existing Dataset with the same name if a file with the same name already exists under the Export Path. If the check box is checked, the existing file with the same name will be overwritten; if the check box is not checked, the file will not be exported.
    • Status: Before the data is exported, the Status item is displayed as Not Exported; if the data is exported successfully, it is displayed as Succeeded; if the data is not exported successfully, it is displayed as Failed.
  4. You can select one or more files in the list box and set parameters for Export Data in the Parameter Settings area on the right side of the Data Export dialog. The parameter items that can be set in the Parameter Settings area on the right are different depending on the format of the selected data to be exported:
    • Export Vector Data: including exporting to SHP, CSV, DWG, Excel and other Vector Data, the parameters to be set are as follows (the parameters that can be set for exporting different Vector Data are different, and the details are subject to the actual operation):
      • Export Point As WKT: Available only when exporting to CSV, the check box is used to display or set whether to Export Point As WKT the field.
      • Export Header: Available only when exporting to CSV. This check box is used to display or set whether to export the header information of the File.
      • Export Extended Field: Available only when exporting as an AutoCAD file, the check box is used to display or set whether to export the extended field of the AutoCAD file.
      • Export Extension Records: Available only when exporting as an AutoCAD file, the check box is used to display or set whether to export extension records of the AutoCAD file.
      • Export Borders: Available only when exporting as an AutoCAD file, the check box is used to display or set whether to export the border data of the AutoCAD file.
      • Export Line Width: Available only when exporting as an AutoCAD file, the check box displays or sets whether to export the polyline width data in the AutoCAD file.
      • Object Color by Layer: Available only when exporting AutoCAD files. Check the Change check box. After export, the Uniform Settings of All Objects is bylayer, and the colors of All Objects in the same layer will be consistent. If the colors of objects in the same layer are inconsistent, The color of the same layer after export will be the same as that of the original layer First Object. If not checked, the color of the exported object follows the color of the current desktop map configuration.
      • CAD Version Available only when exporting to AutoCAD files, the version number of the exported AutoCAD DWG File (*.dwg) or AutoCAD DXF File (*.dxf) can be selected from the drop-down list to the right of the tab. Currently offering AutoCAD R12, AutoCAD R13, AutoCAD R14, AutoCAD 2000, AutoCAD 2004, AutoCAD 2007. The default export version is AutoCAD 2013.
      • Style comparison file: available only when exported as an AutoCAD file. You can select whether to export the style comparison file. For the description of the style comparison file, please refer to the relevant description in Importing CAD Data ;
      • character set: Encode Type of the character used by the Export Dataset. To ensure that the Dataset displays correctly, you need to use the appropriate character set. When exporting, the ASCII (Default) character set is used by default. The most commonly used ASCII character set is used to display Roman numerals and letters, utf-8 is used to display simplified Chinese characters, and Unicode character set is used to meet the needs of cross-language and cross-platform computer display. For a list of character sets supported by Application, see Character Set List .
      • Filter Expression: You can set Filter Expression to filter out objects that do not need to be exported, so that objects that meet the conditions can be exported. See SQL Expression .
    • Export China Standard Vector Exchange Format:
      • VCT version: Select VCT export version, and three options are available: CNSDTF _ VCT 1.0, LANDUSE _ VCT 2.0 and LANDUSE _ VCT 3.0;
      • VCT layer: Select a Dataset as the VCT layer, and provide Config File and Custom to configure the VCT layer:
        • Config File: Import the existing Config File to configure the Export Dataset.
        • User-defined: For different VCT versions, the configuration parameters provided are inconsistent. For details, please refer to the relevant description in Export VCT Data ;
      • Character Set: Character Encode Type used by Export Dataset. To ensure that the Dataset displays correctly, you need to use the appropriate character set. When exporting, the ASCII (Default) character set is used by default. The most commonly used ASCII character set is used to display Roman numerals and letters, utf-8 is used to display simplified Chinese characters, and Unicode character set is used to meet the needs of cross-language and cross-platform computer display. For a list of character sets supported by Application, see Character Set List .
    • Export Telecom File:
      • Dataset List: Select the Dataset of the corresponding type according to the exported Telecom File Type (point, line and surface). Multiple selections are allowed.
      • Field: available only when exported as Telecom Vector Text;
      • character set: Encode Type of the character used by the Export Dataset. To ensure that the Dataset displays correctly, you need to use the appropriate character set. When exporting, the ASCII (Default) character set is used by default. The most commonly used ASCII character set is used to display Roman numerals and letters, utf-8 is used to display simplified Chinese characters, and Unicode character set is used to meet the needs of cross-language and cross-platform computer display. For a list of character sets supported by Application, see Character Set List .
      • Filter Expression: You can set Filter Expression to filter out objects that do not need to be exported, so that objects that meet the conditions can be exported. See SQL Expression .
    • Export File GeoDatabase Vector File (File GDB):
      • Dataset List: Select Export Dataset. Multiple selections are allowed.
        • When exporting a Dataset group, because the FileGDB data structure does not support the sub-group, the sub-group and the Dataset in the sub-group are not exported by default, and only the Dataset under the parent group is displayed. A Dataset in a sub-group can be added to the list with the Add button above.
        • After
        • export, the child group will lose the hierarchical relationship with the parent group, which belongs to the parallel relationship.

      • Append: Through the append function, the currently selected exported data can be appended to the existing FileGDB file, and the appended Connection Field needs to be set;
      • character set: Encode Type of the character used by the Export Dataset. To ensure that the Dataset displays correctly, you need to use the appropriate character set. When exporting, the ASCII (Default) character set is used by default. The most commonly used ASCII character set is used to display Roman numerals and letters, utf-8 is used to display simplified Chinese characters, and Unicode character set is used to meet the needs of cross-language and cross-platform computer display. For a list of character sets supported by Application, see Character Set List .
      • Retention Group: Provide the Retention Group function. If this check box is checked, the Dataset Group will be reserved after the FileGDB file is exported; otherwise, it will not be reserved;
        Caution:

        Because There are limitations such as Dataset Type and coordinate system under the Feature Dataset of GDB, in order to ensure that the Dataset under the Dataset Group is completely exported, Dataset under Dataset Group shall meet the following conditions:

          Dataset Type
        • under Dataset Group is only 2D/3D point, line and Region Dataset. Text Dataset does not support exporting to FileGDB currently.
        • The coordinate system of the All Data set under
        • the Dataset Group is consistent.
        • The Dataset Group hierarchy under the
        • Current Data source has only one level except the root grouping, that is, there is no grouping nesting under the Dataset Group.
      • Keep Long Field Format: Specifies whether to keep the Long field format when exporting. If selected, the original format of the Long field will be retained, and the exported data needs to be used in ArcGIS Pro 3.2 and above; if not selected, the Long field will be exported as double precision.
      • Filter Expression: You can set Filter Expression to filter out objects that do not need to be exported, so that objects that meet the conditions can be exported. See SQL Expression .
    • Export Personal GDBVector file:
      • Dataset List: Select the Dataset to be exported; multiple selections are allowed;
      • Filter Expression: You can set Filter Expression to filter out objects that do not need to be exported, so that objects that meet the conditions can be exported. See SQL Expression .
    • Export GJB File:
      • Dataset List: Select Export Dataset, multiple selections are allowed;
      • character set: Encode Type of the character used by the Export Dataset. To ensure that the Dataset displays correctly, you need to use the appropriate character set. When exporting, the ASCII (Default) character set is used by default. The most commonly used ASCII character set is used to display Roman numerals and letters, utf-8 is used to display simplified Chinese characters, and Unicode character set is used to meet the needs of cross-language and cross-platform computer display. For a list of character sets supported by Application, see Character Set List .
      • Export Layer type: Layer Info supported to be selected includes Measurement Control Point, Industrial and agricultural social and cultural facilitiesResidential area and ancillary facilitiesLand Transportation, Pipeline, Water/land, Submarine Geomorphology and Geology, Reef/Wreck/Obstacle, etc. The default is Measurement Control Point.
      • Filter Expression: You can set Filter Expression to filter out objects that do not need to be exported, so that objects that meet the conditions can be exported. See SQL Expression .
    • Export to Raster、Image Dataset
        When
      • Compression method: Export Type is TIFF File, it is supported to set the compression method of Export File. Four Compression methods including none, LAW, JPEG and DEFLATE are provided.
        • None: No compression.
        • LZW: Lossless compression, using an advanced string table compression, so that the image file compression efficiency has been greatly improved.
        • JPEG: Lossy compression, compression algorithm based on DCT discrete cosine transform, with high compression rate. The JPEG compression algorithm can only be used with Unsigned 8- bit integerRaster Data (One or Multiband) and can be applied to the first 12 bits of Bit16 data.
        • DEFLATE: Lossless compression. DEFLATE is a lossless data compression algorithm that uses both the LZ77 algorithm and Huffman coding.
      • Compression Rate (%): This item is used to display or set the compression rate of Image Files. The default compression rate is 75%. Only if the Export File format is JPG File (*.jpg) The item is available.
      • Coordinate Reference File: Click the Select button on the right to pop up the Open dialog. The path of the Image DataCoordinate Reference File exported for the currently selected Raster Dataset SettingsDataset. This is available only if the Export File format is JPG File (*.jpg), PNG File (*.png), Bitmap File (*.bmp), and GIF File (*.gif).
      • Export affine information as tfw file: This check box is used to display or set whether to export the information of affine transformation (mapping of image coordinates and GCS) to an external file. This check box is available only if the Export File is in Tiff (*.tif) format. The default is to check this box to export the affine information to an external tfw file, otherwise the Projection will be exported to a Tiff file.
      Caution:
        When the
      • Image Dataset is exported as a JPG File (*.jpg), the JPG file cannot be wider or taller than 65,500 pixels. There is no such restriction when exporting to PNG File (*.png).
  5. Check the Auto Close Dialog Box after Export check box to control the Auto Close dialog box to be checked by default when Data Export is finished.
  6. Click the Export button to batch export the All Data set in the list box. The Export Progress window displays the total progress of all Data exports in the batch export list box and the Export Progress of the individual data currently being exported.
Caution:
    If the Datasource in the
  • Current Workspace are all image data engines, the Export button will be grayed out and unavailable.
  • If an image data engine exists in the Current Works pace, clicking the Add button on the Data Export window, the image data engine appears in the Datasource list on the left side of the Select dialog. But the image Dataset under that Datasource cannot be added.
  • When
  • exporting KML and KMZ format Dataset, it must be WGS _ 1984 Geographic Coordinate System, otherwise it will Failed OutPut.
  • .
  • When a vector is exported as a VCT file, the Layer type corresponding to the VCT must be set, or Failed OutPut.
  • will occur. When
  • Import Export Telecom Raster Data, please pay attention to the following two points:
    • The Telecom Grid format only supports DatasetImport Export of the Grid type.
    • The Telecom grid format only supports the import and export of Raster Data with a pixel bit depth of 16. When Export Data is a Grid Dataset with a pixel bit depth of less than 16, it will automatically convert the pixel bit depth to 16 bits.
  • When exporting
  • the Dataset Properties table to Microsoft Excel File, it is only supported to export a set of Is no more than 100,000 records at a time. If the number of Dataset records is 0, the Failed OutPut.
  • .
  • third-party Tif library currently supports a maximum of 4 gigabytes of Export as TIFF images. If the Export Data exceeds 4G, it is recommended that the user export the data in blocks or in the form of SIT Image File (outdated).
  • Limited
  • by third-party libraries, the maximum amount of data that can be exported as a SHP file is currently 4G. If the Export Data exceeds 4G, it is recommended that the user export the Data to a FileGDB file.

Related topics

Export.xModel File

Export VCT Data

Export EPS Data