English

How To: Export lidar data to a CSV file and retain the x, y, and z values in ArcGIS Pro

Summary

ArcGIS Pro supports lidar data provided as LAS or Optimized LAS (.ZLAS) files and can be used in three different formats: LAS dataset, terrain dataset, and mosaic dataset. This article provides steps to export lidar data to a CSV file in ArcGIS Pro while retaining the x, y, and z values.

Procedure

  1. If necessary, convert the lidar data to a LAS dataset using the Create LAS Dataset tool. Refer to Create a LAS dataset using the Create LAS Dataset geoprocessing tool for steps to do this.
  2. Convert the LAS dataset to a raster dataset using the LAS Point Statistics As Raster tool.
    1. Select the LAS dataset to convert for Input LAS Dataset.
    2. Set a name and location for Output Raster.
    3. In the Method drop-down list, select the desired type of statistics collected for the LAS points in each cell of the output raster. Click Run.
  3. Convert the raster dataset to point features using the Raster to Point tool.
    1. Select the output raster dataset from Step 2 for Input raster.
    2. Select VALUE in the Field drop-down list.
    3. Set a name and location for Output point features, and click Run.
  4. Add the x-, y-, and z-coordinate values to the attribute table of the point shapefile or feature class using the Add Geometry Attributes tool.
    1. Select the point shapefile or feature class as Input Features.
    2. In the Geometry Properties drop-down list, select Point x-, y-, z-, and m-coordinates.
    3. Select the proper Length Unit, Area Unit, and Coordinate System for the input features, and click Run.
An image of the Add Geometry Attributes tool dialog box.
  1. Use the Add Surface Information tool to add z values to the attribute table.
    Note:
    The Add Surface Information tool is only available with a 3D Analyst extension.
    1. Select the point shapefile or feature class as Input Features.
    2. Select the lidar dataset as Input Surface.
    3. Check the Z check box under Output Property, and click Run.
An image of the Add Surface Information dialog box.
The attribute table is populated with the x, y, and z values.
An image of the attribute table.
  1. Export the attribute table to a CSV file using the Table To Table tool.
    1. Select the point shapefile or feature class containing the x, y, and z values for Input Rows.
    2. Select a folder for Output Location.
    3. Set a name and include the .csv extension for Output Name, and click Run.
An image of the Table To Table dialog box.
The exported CSV file containing the x, y, and z values of the lidar data is added to the project and in the specified folder.

Related Information

Last Published: 4/22/2020

Article ID: 000023109

Software: ArcGIS Pro 2.5, 2.4.3, 2.4.2, 2.4.1, 2.4, 2.3.3, 2.3.2, 2.3.1, 2.3, 2.2.4, 2.2.3, 2.2.2, 2.2.1, 2.2, 2.1.3, 2.1.2, 2.1.1, 2.1, 2.0.1, 2.0