[ArcGIS micro-class 1000 cases] 0001: Add XY data (Add XY data) to generate shp

Anyone who has used CASS knows that the point data (plane coordinates) obtained from field digital mapping can be directly displayed in CASS to further draw topographic maps. So, can data with coordinates be used to generate point layers in ArcGIS? The answer is a must!

This article takes the generation of Excel data from meteorological stations as an example, and introduces in detail the process of importing X and Y coordinates in ArcGIS 10.2 to generate Shapefile point data.

Article Directory

data preparation

Link: https://pan.baidu.com/s/1eaulWklowfB-Qd5S-7wnkA
Extraction code: 4ugl


In the coordinate data, multiple fields (attributes) can be included, and headers are required, and the order of the fields is not required. The most important are the coordinate fields Lat (latitude) and Lng (longitude), the coordinate format is degrees (°), used to generate points.

The coordinates can be 经纬度坐标, or 平面坐标etc.


ArcGIS supports the XY coordinate data format mainly .xls(.xlsx), .dbf(表), .csv, .txtetc., weather station data as .xlsx used herein, the preview data as follows:

Insert picture description here

Add XY data

You can add the prepared data to the content list box by adding data first, and then add XY data.

Insert picture description here

You can also directly add XY data.

Insert picture description here

Select the sheet "Meteorological Station" in "Meteorological Station.xlsx", the X field is the longitude, the Y field is the latitude, the Z field is the elevation (not here), and the geographic coordinate system CGCS2000 is selected.

Insert picture description here
Note: Since this data is latitude and longitude, only geographic coordinate system can be selected as the coordinate system, not projected coordinate system! ! !
Insert picture description here


Insert picture description here

Export as shp

Right-click on the generated layer and export the data.

Insert picture description here

Determine the location and name. The default export type is shp.

Insert picture description here

Follow-up operation

After exporting shp, you can connect attribute data such as temperature, precipitation, elevation, projection conversion, spatial interpolation, spatial analysis, etc. in the attribute table.