2023年11月23日发(作者:)
删除GIS数据属性值空格(GDB,MDB,Shp)
批量删除GIS数据属性值空格
# -*- coding: utf-8 -*-
# ---------------------------------------------------------------------------
#
# Created on: 2015-05-04 10:25:22.00000
# (generated by WangLin_TJCH)
# Description:
# ---------------------------------------------------------------------------
# Import arcpy module
import arcpy
import
import time
import random
from arcpy import env
FCDBDir = "D:aaa"
dicAllFC={}
fcall=[]
GDBAllPath=[]
if not isinstance(FCDBDir,unicode):
FCDBDir = ('utf-8')
#Get Dataset and FeatureClass,Store in dicAllFC,Key =fc value= ds
if (FCDBDir):
for dirpath,dirnames,filenames in (FCDBDir):
# 遍历GDB⽂件夹 获取GDB
for dirname in dirnames:
if ".gdb" in dirname:
gdbfilepath = (dirpath,dirname)
if not gdbfilepath in GDBAllPath:
(gdbfilepath)
# 遍历MDB⽂件夹 获取MDB
fields = elds(singlefc)
stringfields = []
for everyfield in fields:
if == "String":
if not in stringfields:
()
if len(stringfields)>0:
with Cursor(singlefc, stringfields) as cursor:
for row in cursor:
for i in range(0,len(stringfields)):
#表明属性值有左右有空格
if not isinstance(row[i],unicode):
tempunicodestr = str(row[i])
instunicode = ('utf-8')
else:
instunicode = row[i]
if(instunicode!= ()):
row[i] = ()
Row(row)
print "Delete Space"+fcfullpath+"@"+instunicode+"->"+()+"@Succeed At "+me("%Y-%m-%d %X",ime())
datasetlist = tasets("","Feature")
for dataset in datasetlist:
发布评论