

Within the XY folder, double-click the XY.aprx project file to open the project in ArcGIS Pro. An output record will not be created and a warning message will be included in the tool messages to indicate the invalid record ID. Now that you have examined the tabular data in Excel, it is time to display the XY data of city locations on a map. X Field and Y Field parameter field values in a geographic coordinate system are considered invalid if they are less than -400 and greater than 400. Coordinates of 0 will have output point features placed at that location, while coordinates that are null will have an empty geometry.

X Field and Y Field parameter field values of 0 or Null are considered valid and will be included in the output. If the z-values are not in meters, modify the coordinate system to use the correct elevation unit. I’ve put the column names in the 1 st row and from the 2 nd the calculation will go through. We start from the second row with values, so we should keep our calculations within the same rows. When the Z Field parameter is specified, the default coordinate system also includes the WGS 1984 vertical coordinate system. 9 One of the way of the coordinates transformation between WGS 84 Lat/Lon and OSGB 36 XY in Excel. If the Output Coordinate System environment has been set, the output feature class will be reprojected to this coordinate system from the coordinate system specified in the Coordinate System parameter. If the x- and y-coordinates in the input table contain projected coordinates, specify the appropriate projected coordinate system.

As this tool is commonly used with tables that contain longitude and latitude values, the default coordinate system is the WGS 1984 geographic coordinate system. This coordinate system determines how the x-, y-, and z-coordinates in the input table are interpreted. The coordinate system specified in the Coordinate System parameter will be applied to the output. To use an input table with a nonstandard delimiter, you must first specify the correct delimiter used in the table using a schema.ini file.Īttribute fields from the Input Table parameter value will be transferred to the Output Feature Class parameter value. The standard delimiter for tabular text files with extensions.
