Vjylku

How badly should I try to prevent a user from XSSing themselves?

What method can I use to design a dungeon difficult enough that the PCs can't make it through without killing them?

Dreadful Dastardly Diseases, or Always Atrocious Ailments

How seriously should I take size and weight limits of hand luggage?

Why do bosons tend to occupy the same state?

Why would the Red Woman birth a shadow if she worshipped the Lord of the Light?

Can my sorcerer use a spellbook only to collect spells and scribe scrolls, not cast?

Should I cover my bicycle overnight while bikepacking?

Why is this clock signal connected to a capacitor to gnd?

What do you call someone who asks many questions?

Different meanings of こわい

What mechanic is there to disable a threat instead of killing it?

Intersection Puzzle

What does “the session was packed” mean in this context?

In 'Revenger,' what does 'cove' come from?

Why can't we play rap on piano?

Why doesn't using multiple commands with a || or && conditional work?

How would I stat a creature to be immune to everything but the Magic Missile spell? (just for fun)

iPad being using in wall mount battery swollen

What does the expression "A Mann!" means

Why no variance term in Bayesian logistic regression?

One verb to replace 'be a member of' a club

Avoiding the "not like other girls" trope?

Why was the shrinking from 8″ made only to 5.25″ and not smaller (4″ or less)?

Save a selected row into a new shapefile with arcpy

Error 000865 when using arcpy.ASCIIToRaster_conversionraster to polygon conversionUsing FeatureClassToFeatureClass from list to concatenated list?Debugging FeatureClassToFeatureClass giving ERROR 000732?Export Query Layer to shapefile using arcpyArcpy connecting points with lines using coordinatesRun time error - arcpy.xytolinePerforming Project_management in batch using ArcPy?Removing GP History xsltFor loop to convert .lyr files to KML files gives ERROR 000814?

2

I have a shapefile with 100+ rows. What I like to do is to select each row and export all its data to a new shapefile. I tried using the arcpy.da.SearchCursor as follows:

with arcpy.da.SearchCursor(inputshape,"*",None) as cursor:

...     for row in cursor:

...         arcpy.FeatureClassToFeatureClass_conversion(row,pathToFolder,row[3] + ".shp")

Resulting in an error, arcpy displays following message:

Runtime error
Traceback (most recent call last):
File "", line 3, in
File "c:program files (x86)arcgisdesktop10.4arcpyarcpyconversion.py", line 1694, in
FeatureClassToFeatureClass
raise e
RuntimeError: Object: Error in executing tool

I think first parameter in the FeatureClassTofeatureClass_conversion method ist wrong. Other Examples show that there has to be the @Shape field. the workflow I would like to automate is very simple: 1) Open the attribute table 2) select a row 3) Export selected data to a new shapefile.

arcpy arcmap shapefile export cursor

share|improve this question

edited Oct 24 '17 at 13:06

artwork21

31.1k554120

asked Oct 24 '17 at 12:53

Andi90Andi90

383

add a comment | 

2

I have a shapefile with 100+ rows. What I like to do is to select each row and export all its data to a new shapefile. I tried using the arcpy.da.SearchCursor as follows:

with arcpy.da.SearchCursor(inputshape,"*",None) as cursor:

...     for row in cursor:

...         arcpy.FeatureClassToFeatureClass_conversion(row,pathToFolder,row[3] + ".shp")

Resulting in an error, arcpy displays following message:

Runtime error
Traceback (most recent call last):
File "", line 3, in
File "c:program files (x86)arcgisdesktop10.4arcpyarcpyconversion.py", line 1694, in
FeatureClassToFeatureClass
raise e
RuntimeError: Object: Error in executing tool

I think first parameter in the FeatureClassTofeatureClass_conversion method ist wrong. Other Examples show that there has to be the @Shape field. the workflow I would like to automate is very simple: 1) Open the attribute table 2) select a row 3) Export selected data to a new shapefile.

arcpy arcmap shapefile export cursor

share|improve this question

edited Oct 24 '17 at 13:06

artwork21

31.1k554120

asked Oct 24 '17 at 12:53

Andi90Andi90

383

add a comment | 

I have a shapefile with 100+ rows. What I like to do is to select each row and export all its data to a new shapefile. I tried using the arcpy.da.SearchCursor as follows:

with arcpy.da.SearchCursor(inputshape,"*",None) as cursor:

...     for row in cursor:

...         arcpy.FeatureClassToFeatureClass_conversion(row,pathToFolder,row[3] + ".shp")

Resulting in an error, arcpy displays following message:

Runtime error
Traceback (most recent call last):
File "", line 3, in
File "c:program files (x86)arcgisdesktop10.4arcpyarcpyconversion.py", line 1694, in
FeatureClassToFeatureClass
raise e
RuntimeError: Object: Error in executing tool

I think first parameter in the FeatureClassTofeatureClass_conversion method ist wrong. Other Examples show that there has to be the @Shape field. the workflow I would like to automate is very simple: 1) Open the attribute table 2) select a row 3) Export selected data to a new shapefile.

arcpy arcmap shapefile export cursor

share|improve this question

edited Oct 24 '17 at 13:06

artwork21

31.1k554120

asked Oct 24 '17 at 12:53

Andi90Andi90

383

with arcpy.da.SearchCursor(inputshape,"*",None) as cursor:

...     for row in cursor:

...         arcpy.FeatureClassToFeatureClass_conversion(row,pathToFolder,row[3] + ".shp")

share|improve this question

edited Oct 24 '17 at 13:06

artwork21

31.1k554120

asked Oct 24 '17 at 12:53

Andi90Andi90

383

share|improve this question

edited Oct 24 '17 at 13:06

artwork21

31.1k554120

asked Oct 24 '17 at 12:53

Andi90Andi90

383

edited Oct 24 '17 at 13:06

artwork21

31.1k554120

edited Oct 24 '17 at 13:06

artwork21

31.1k554120

asked Oct 24 '17 at 12:53

Andi90Andi90

383

asked Oct 24 '17 at 12:53

Andi90Andi90

383

2 Answers
2

active

oldest

votes

3

The cursor does not select anything, it is only returning a tuple. You can use the ObjectID returned by the cursor and pass this to Select:

Extracts features from an input feature class or input feature layer,
typically using a select or Structured Query Language (SQL) expression
and stores them in an output feature class.

Like this:

import arcpy,os



input_fc=r'C:TESTShape.shp'

outfolder=r'C:folder'



with arcpy.da.SearchCursor(input_fc,'OID@') as cursor:

    for row in cursor:

        sql="""{0} = {1}""".format(arcpy.AddFieldDelimiters(input_fc, arcpy.Describe(

            input_fc).OIDFieldName),row[0])

        arcpy.Select_analysis(in_features=input_fc, out_feature_class=os.path.join(outfolder,'Shapefile_{0}.shp'.format(row[0])), 

                             where_clause=sql)

But an easier option would be to use tool Split By Attributes with ObjectID field as split field:

Splits an input dataset by unique attributes.

share|improve this answer

edited 6 mins ago

answered Oct 24 '17 at 13:19

BERABERA

16.9k62044

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you so much! Your first provided option works brilliantly! Later on, I will have a look on your suggested second option!
  
  – Andi90
  Oct 24 '17 at 13:58
  

  
  
  
  

add a comment | 

0

To export each row/feature within the cursor you will need to nest a variable expression that queries the active cursor row FID or some other unique identifier field/value. Then you may use the Select method using the active row expression aka where clause to export out the active row to a new fc.

The pseudo logic would go something like this:

with arcpy.da.SearchCursor(inputshape,'FID') as cursor:

    for row in cursor:

        where_clause = # define expression here for active field/row

        # Execute Select

        arcpy.Select_analysis(inputshape, out_feature_class, where_clause) # you'll have to define the out_feature_class

share|improve this answer

edited Oct 24 '17 at 13:21

answered Oct 24 '17 at 13:04

artwork21artwork21

31.1k554120

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Andi90 updated answer
  
  – artwork21
  Oct 24 '17 at 13:14
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f259486%2fsave-a-selected-row-into-a-new-shapefile-with-arcpy%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

3

The cursor does not select anything, it is only returning a tuple. You can use the ObjectID returned by the cursor and pass this to Select:

Extracts features from an input feature class or input feature layer,
typically using a select or Structured Query Language (SQL) expression
and stores them in an output feature class.

Like this:

import arcpy,os



input_fc=r'C:TESTShape.shp'

outfolder=r'C:folder'



with arcpy.da.SearchCursor(input_fc,'OID@') as cursor:

    for row in cursor:

        sql="""{0} = {1}""".format(arcpy.AddFieldDelimiters(input_fc, arcpy.Describe(

            input_fc).OIDFieldName),row[0])

        arcpy.Select_analysis(in_features=input_fc, out_feature_class=os.path.join(outfolder,'Shapefile_{0}.shp'.format(row[0])), 

                             where_clause=sql)

But an easier option would be to use tool Split By Attributes with ObjectID field as split field:

Splits an input dataset by unique attributes.

share|improve this answer

edited 6 mins ago

answered Oct 24 '17 at 13:19

BERABERA

16.9k62044

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you so much! Your first provided option works brilliantly! Later on, I will have a look on your suggested second option!
  
  – Andi90
  Oct 24 '17 at 13:58
  

  
  
  
  

add a comment | 

3

The cursor does not select anything, it is only returning a tuple. You can use the ObjectID returned by the cursor and pass this to Select:

Extracts features from an input feature class or input feature layer,
typically using a select or Structured Query Language (SQL) expression
and stores them in an output feature class.

Like this:

import arcpy,os



input_fc=r'C:TESTShape.shp'

outfolder=r'C:folder'



with arcpy.da.SearchCursor(input_fc,'OID@') as cursor:

    for row in cursor:

        sql="""{0} = {1}""".format(arcpy.AddFieldDelimiters(input_fc, arcpy.Describe(

            input_fc).OIDFieldName),row[0])

        arcpy.Select_analysis(in_features=input_fc, out_feature_class=os.path.join(outfolder,'Shapefile_{0}.shp'.format(row[0])), 

                             where_clause=sql)

But an easier option would be to use tool Split By Attributes with ObjectID field as split field:

Splits an input dataset by unique attributes.

share|improve this answer

edited 6 mins ago

answered Oct 24 '17 at 13:19

BERABERA

16.9k62044

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you so much! Your first provided option works brilliantly! Later on, I will have a look on your suggested second option!
  
  – Andi90
  Oct 24 '17 at 13:58
  

  
  
  
  

add a comment | 

The cursor does not select anything, it is only returning a tuple. You can use the ObjectID returned by the cursor and pass this to Select:

Extracts features from an input feature class or input feature layer,
typically using a select or Structured Query Language (SQL) expression
and stores them in an output feature class.

Like this:

import arcpy,os



input_fc=r'C:TESTShape.shp'

outfolder=r'C:folder'



with arcpy.da.SearchCursor(input_fc,'OID@') as cursor:

    for row in cursor:

        sql="""{0} = {1}""".format(arcpy.AddFieldDelimiters(input_fc, arcpy.Describe(

            input_fc).OIDFieldName),row[0])

        arcpy.Select_analysis(in_features=input_fc, out_feature_class=os.path.join(outfolder,'Shapefile_{0}.shp'.format(row[0])), 

                             where_clause=sql)

But an easier option would be to use tool Split By Attributes with ObjectID field as split field:

Splits an input dataset by unique attributes.

share|improve this answer

edited 6 mins ago

answered Oct 24 '17 at 13:19

BERABERA

16.9k62044

import arcpy,os



input_fc=r'C:TESTShape.shp'

outfolder=r'C:folder'



with arcpy.da.SearchCursor(input_fc,'OID@') as cursor:

    for row in cursor:

        sql="""{0} = {1}""".format(arcpy.AddFieldDelimiters(input_fc, arcpy.Describe(

            input_fc).OIDFieldName),row[0])

        arcpy.Select_analysis(in_features=input_fc, out_feature_class=os.path.join(outfolder,'Shapefile_{0}.shp'.format(row[0])), 

                             where_clause=sql)

share|improve this answer

edited 6 mins ago

answered Oct 24 '17 at 13:19

BERABERA

16.9k62044

answered Oct 24 '17 at 13:19

BERABERA

16.9k62044

answered Oct 24 '17 at 13:19

BERABERA

16.9k62044

0

To export each row/feature within the cursor you will need to nest a variable expression that queries the active cursor row FID or some other unique identifier field/value. Then you may use the Select method using the active row expression aka where clause to export out the active row to a new fc.

The pseudo logic would go something like this:

with arcpy.da.SearchCursor(inputshape,'FID') as cursor:

    for row in cursor:

        where_clause = # define expression here for active field/row

        # Execute Select

        arcpy.Select_analysis(inputshape, out_feature_class, where_clause) # you'll have to define the out_feature_class

share|improve this answer

edited Oct 24 '17 at 13:21

answered Oct 24 '17 at 13:04

artwork21artwork21

31.1k554120

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Andi90 updated answer
  
  – artwork21
  Oct 24 '17 at 13:14
  

  
  
  
  

add a comment | 

0

To export each row/feature within the cursor you will need to nest a variable expression that queries the active cursor row FID or some other unique identifier field/value. Then you may use the Select method using the active row expression aka where clause to export out the active row to a new fc.

The pseudo logic would go something like this:

with arcpy.da.SearchCursor(inputshape,'FID') as cursor:

    for row in cursor:

        where_clause = # define expression here for active field/row

        # Execute Select

        arcpy.Select_analysis(inputshape, out_feature_class, where_clause) # you'll have to define the out_feature_class

share|improve this answer

edited Oct 24 '17 at 13:21

answered Oct 24 '17 at 13:04

artwork21artwork21

31.1k554120

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Andi90 updated answer
  
  – artwork21
  Oct 24 '17 at 13:14
  

  
  
  
  

add a comment | 

To export each row/feature within the cursor you will need to nest a variable expression that queries the active cursor row FID or some other unique identifier field/value. Then you may use the Select method using the active row expression aka where clause to export out the active row to a new fc.

The pseudo logic would go something like this:

with arcpy.da.SearchCursor(inputshape,'FID') as cursor:

    for row in cursor:

        where_clause = # define expression here for active field/row

        # Execute Select

        arcpy.Select_analysis(inputshape, out_feature_class, where_clause) # you'll have to define the out_feature_class

share|improve this answer

edited Oct 24 '17 at 13:21

answered Oct 24 '17 at 13:04

artwork21artwork21

31.1k554120

with arcpy.da.SearchCursor(inputshape,'FID') as cursor:

    for row in cursor:

        where_clause = # define expression here for active field/row

        # Execute Select

        arcpy.Select_analysis(inputshape, out_feature_class, where_clause) # you'll have to define the out_feature_class

share|improve this answer

edited Oct 24 '17 at 13:21

answered Oct 24 '17 at 13:04

artwork21artwork21

31.1k554120

answered Oct 24 '17 at 13:04

artwork21artwork21

31.1k554120

answered Oct 24 '17 at 13:04

artwork21artwork21

31.1k554120