topic Re: How to copy some rows in a featureclass to another feature? in Python Questions

How to copy some rows in a featureclass to another feature?

lmzh — Wed, 10 Aug 2011 07:38:44 GMT

I am new to Python and have started to create scripts for copyrows. I am wondering how to copy some rows in a featureclass to another featureclass
here is the code,"TERP","RFCP"is the name of featureclass in the code ,"GB" is the fieldname in TERP
import arcgisscripting

gp = arcgisscripting.create(9.3)

gp.workspace = "D:\data\test\1\H45G062061dlg.mdb"
#workspaceslists=gp.listworkspaces("*","access")
#for ws in workspaceslists:
# gp.workspace=ws
gp.toolbox = "management"

query = 'GB = "7201001"'
gp.maketableview(TERP," GB_view", query)

# Copy the table view to a new table

gp.copyrows("GB_view", RFCP)

Thanks in advance

Re: How to copy some rows in a featureclass to another feature?

RDHarles — Sun, 12 Dec 2021 00:20:38 GMT

Here's an example (and the tools you'd use) to copy rows from one table to another:

gp.MakeTableView_management("table1.dbf", "lyrtable")    
gp.SelectLayerByAttribute_management("lyrtable", "New_Selection", '"AREATYP" = 3136')
gp.CopyRows_management("lyrtable", "table2.dbf")

Re: How to copy some rows in a featureclass to another feature?

lmzh — Thu, 11 Aug 2011 08:28:37 GMT

"gp.workspace = "D:/data/test/1/H45G062061dlg.mdb" " instead of "gp.workspace = "D:\data\test\1\H45G062061dlg.mdb" and query = "GB = 7201001" instead of query = 'GB = "7201001"' run correctly,but copying rows did not append the featureclass but covered

Re: How to copy some rows in a featureclass to another feature?

RDHarles — Sun, 12 Dec 2021 00:20:41 GMT

What error message you getting?

I made a quick mdb and table and ran this script (similar to yours) and it worked fine.

import arcgisscripting
gp = arcgisscripting.create(9.3)

gp.workspace = "C:/junk/db1.mdb"
gp.maketableview("Table1", "t1", "temp = 4")
gp.copyrows("t1", "z1")

Re: How to copy some rows in a featureclass to another feature?

lmzh — Sun, 12 Dec 2021 00:20:44 GMT

What error message you getting?

I made a quick mdb and table and ran this script (similar to yours) and it worked fine.
import arcgisscripting
gp = arcgisscripting.create(9.3)

gp.workspace = "C:/junk/db1.mdb"
gp.maketableview("Table1", "t1", "temp = 4")
gp.copyrows("t1", "z1")

my script can run correctly,but I want to append features that selcleted into another featureclass ,how to do this ?

Re: How to copy some rows in a featureclass to another feature?

RDHarles — Fri, 12 Aug 2011 11:48:36 GMT

After you gp.copyrows the first time, you can the continue to add to the feature class by using the Append tool.

gp.Append_management("x1", "t1", "NO_TEST")