arcpy属性表添加字段，shp转csv

arcpy给点图层属性表添加经纬度字段

arcpy.env.workspace = r"C:\Users\test"
# 读取点图层
point_layer = "point.shp"
# 添加经度和纬度字段
arcpy.AddField_management(point_layer, "longitude", "DOUBLE")
arcpy.AddField_management(point_layer, "latitude", "DOUBLE")
# 更新经度和纬度字段值
with arcpy.da.UpdateCursor(point_layer, ["SHAPE@X", "SHAPE@Y", "longitude", "latitude"]) as cursor:
    for row in cursor:
        row[2] = row[0]
        row[3] = row[1]
        cursor.updateRow(row)
        print (row)
print("经纬度字段添加完成！")

arcpy添加字段，运用VB中的Mid（）获取第9-10字符

# ap.env.workspace = r"E:\test"
# list_name = []
# for file in os.listdir(ap.env.workspace):
#         file_path = os.path.join(file)
#         if os.path.splitext(file_path)[-1] == '.dbf':
#             ap.AddField_management(file, u'hour_loc', "TEXT")
#             ap.AddField_management(file, u'hour_gmt', "TEXT")
#             ap.CalculateField_management(file, "hour_loc", expression="Mid([Time_loc],9,2)",
#             expression_type="VB", code_block="")
#             ap.CalculateField_management(file, "hour_gmt", expression="Mid([Time_gmt],9,2)",
#             expression_type="VB", code_block="")
#             print (file)

shp转csv

import arcpy
# 设置工作空间
arcpy.env.workspace = r"D:\test"
# 定义输入和输出文件路径
filenames = os.listdir(arcpy.env.workspace)
for filename in filenames:
        if os.path.splitext(filename)[1] == '.shp':
            input_shp = filename
            print (filename)
            basename = os.path.splitext(filename)[0]
            output_csv =os.sep + basename + '.csv'
            # 使用arcpy中的TableToTable_conversion函数将shp文件转换为csv文件
            arcpy.TableToTable_conversion(input_shp, arcpy.env.workspace, output_csv)
            print (output_csv)