摘要:
--创建表 CREATE TABLE geotable ( id int, shape geometry )--判断某表是否已经存在,若存在,则删除已有数据表IF OBJECT_ID ( 'dbo.SpatialTable', 'U' ) IS NOT NULL DROP TABLE dbo.SpatialTable; --复制表结构,创建新表 --select * into junctionunion from FLOOR2_NET_JUNCTIONS where 1=2--数据类型转换declare @i intset @i=11select CAST(.. 阅读全文
摘要:
# 例:遍历d盘下的所有文件夹及文件import osimport arcgisscriptinggp = arcgisscripting.create()# 遍历d盘下的所有文件夹及文件for root, dirs, files in os.walk('F:\shp'): for name in files: inText=os.path.join(root,name) inSep="." shpname=name.replace('.txt','.shp') onlyname=name.replace('.txt& 阅读全文
摘要:
# Create geoprocessing dispatch objectimport arcgisscriptinggp = arcgisscripting.create() # Set up inputs to toolinTxt = r"F:\shp\ELE_V1_1.txt"inSep = "."strms = r"F:\shapefile\ELE_V1_1.shp" # Run toolgp.CreateFeaturesFromTextFile(inTxt, inSep, strms, "#") #pr 阅读全文