Vjylku

What exact color does ozone gas have?

How should I respond when I lied about my education and the company finds out through background check?

How could a planet have erratic days?

Why "had" in "[something] we would have made had we used [something]"?

Does the UK parliament need to pass secondary legislation to accept the Article 50 extension

Why does the Sun have different day lengths, but not the gas giants?

Can disgust be a key component of horror?

Quoting Keynes in a lecture

Is this toilet slogan correct usage of the English language?

It grows, but water kills it

This is why we puzzle

What if you are holding an Iron Flask with a demon inside and walk into Antimagic Field?

What is the highest possible scrabble score for placing a single tile

Pre-mixing cryogenic fuels and using only one fuel tank

Yosemite Fire Rings - What to Expect?

What is Cash Advance APR?

How do I delete all blank lines in a buffer?

Can a college of swords bard use blade flourish on an OA from dissonant whispers?

Plot of a tornado-shaped surface

What if a revenant (monster) gains fire resistance?

Add big quotation marks inside my colorbox

Are Captain Marvel's powers affected by Thanos' actions in Infinity War

Hero deduces identity of a killer

Extract more than nine arguments that occur periodically in a sentence to use in macros in order to typset

Error arcpy copy feature management problem when making join to shapefile

Intermediate Data in Python CodeSelect by Location and extract features using arcpyCopy query feature layer into a feature class - error 000732Cannot copy feature class to databaseMy program won't accept my output file pathError when exporting to new folder using ArcPyHow to convert multiple CSV Files to Shapefiles/Feature Classes using ModelBuilderArcGIS Exporting (ALL) layers from Table of ContentsCreating Python code when creating tool gives ERROR 000210?Why is SelectLayerByAttribute_management claiming “Column Does Not Exist”?

2

I am trying to join a csv file to a shapefile based on an ID field that keeps giving me this error:

ExecuteError: ERROR 000210: Cannot create output C:Usersgeo.gdb2010reg

Failed to execute (CopyFeatures).

Here is my code:

import arcpy

env.workspace = r"C:Usersgeo.gdb"

arcpy.env.qualifiedFieldNames = False



# Set local variables for join  

inFeatures = r'C:Usersshapefile1.shp'

layerName = "ID"

joinTable = r"C:Userscsv1.csv"

joinField = "ID"

outFeature = r"C:Usersgeo.gdbsuccessJoined.shp"



arcpy.MakeFeatureLayer_management (inFeatures,  layerName)



# Join the feature layer to a table

AddJoin_management(layerName, joinField, joinTable, joinField)



# Select desired features from veg_layer#

arcpy.SelectLayerByAttribute_management(layerName, "NEW_SELECTION")



# Copy the layer to a new permanent feature class

arcpy.CopyFeatures_management(layerName, outFeature)

I would like to copy all matched rows to a new output feature class. I do not want it to contain non-matching rows. The key "ID" is the same in both the csv and the shapefile. I am getting the error above that will not allow the final copy to work.

arcpy error-000210

share|improve this question

edited 10 mins ago

PolyGeo♦

53.7k1781244

asked Oct 13 '16 at 15:18

danddand

777

add a comment | 

2

I am trying to join a csv file to a shapefile based on an ID field that keeps giving me this error:

ExecuteError: ERROR 000210: Cannot create output C:Usersgeo.gdb2010reg

Failed to execute (CopyFeatures).

Here is my code:

import arcpy

env.workspace = r"C:Usersgeo.gdb"

arcpy.env.qualifiedFieldNames = False



# Set local variables for join  

inFeatures = r'C:Usersshapefile1.shp'

layerName = "ID"

joinTable = r"C:Userscsv1.csv"

joinField = "ID"

outFeature = r"C:Usersgeo.gdbsuccessJoined.shp"



arcpy.MakeFeatureLayer_management (inFeatures,  layerName)



# Join the feature layer to a table

AddJoin_management(layerName, joinField, joinTable, joinField)



# Select desired features from veg_layer#

arcpy.SelectLayerByAttribute_management(layerName, "NEW_SELECTION")



# Copy the layer to a new permanent feature class

arcpy.CopyFeatures_management(layerName, outFeature)

I would like to copy all matched rows to a new output feature class. I do not want it to contain non-matching rows. The key "ID" is the same in both the csv and the shapefile. I am getting the error above that will not allow the final copy to work.

arcpy error-000210

share|improve this question

edited 10 mins ago

PolyGeo♦

53.7k1781244

asked Oct 13 '16 at 15:18

danddand

777

add a comment | 

I am trying to join a csv file to a shapefile based on an ID field that keeps giving me this error:

ExecuteError: ERROR 000210: Cannot create output C:Usersgeo.gdb2010reg

Failed to execute (CopyFeatures).

Here is my code:

import arcpy

env.workspace = r"C:Usersgeo.gdb"

arcpy.env.qualifiedFieldNames = False



# Set local variables for join  

inFeatures = r'C:Usersshapefile1.shp'

layerName = "ID"

joinTable = r"C:Userscsv1.csv"

joinField = "ID"

outFeature = r"C:Usersgeo.gdbsuccessJoined.shp"



arcpy.MakeFeatureLayer_management (inFeatures,  layerName)



# Join the feature layer to a table

AddJoin_management(layerName, joinField, joinTable, joinField)



# Select desired features from veg_layer#

arcpy.SelectLayerByAttribute_management(layerName, "NEW_SELECTION")



# Copy the layer to a new permanent feature class

arcpy.CopyFeatures_management(layerName, outFeature)

I would like to copy all matched rows to a new output feature class. I do not want it to contain non-matching rows. The key "ID" is the same in both the csv and the shapefile. I am getting the error above that will not allow the final copy to work.

arcpy error-000210

share|improve this question

edited 10 mins ago

PolyGeo♦

53.7k1781244

asked Oct 13 '16 at 15:18

danddand

777

ExecuteError: ERROR 000210: Cannot create output C:Usersgeo.gdb2010reg

Failed to execute (CopyFeatures).

import arcpy

env.workspace = r"C:Usersgeo.gdb"

arcpy.env.qualifiedFieldNames = False



# Set local variables for join  

inFeatures = r'C:Usersshapefile1.shp'

layerName = "ID"

joinTable = r"C:Userscsv1.csv"

joinField = "ID"

outFeature = r"C:Usersgeo.gdbsuccessJoined.shp"



arcpy.MakeFeatureLayer_management (inFeatures,  layerName)



# Join the feature layer to a table

AddJoin_management(layerName, joinField, joinTable, joinField)



# Select desired features from veg_layer#

arcpy.SelectLayerByAttribute_management(layerName, "NEW_SELECTION")



# Copy the layer to a new permanent feature class

arcpy.CopyFeatures_management(layerName, outFeature)

share|improve this question

edited 10 mins ago

PolyGeo♦

53.7k1781244

asked Oct 13 '16 at 15:18

danddand

777

share|improve this question

edited 10 mins ago

PolyGeo♦

53.7k1781244

asked Oct 13 '16 at 15:18

danddand

777

edited 10 mins ago

PolyGeo♦

53.7k1781244

edited 10 mins ago

PolyGeo♦

53.7k1781244

asked Oct 13 '16 at 15:18

danddand

777

asked Oct 13 '16 at 15:18

danddand

777

1 Answer
1

active

oldest

votes

4

Within your Join function, you can set the join type to "Keep Common". This will only join features where ID = ID.

If you are trying to do a "Select By Attribute" function to find where ID = ID, this is not needed if you use the join type mentioned above.

The reason why the Copy Features tool doesn't work, is because you have set your workspace as a GDB, and then trying to export the final joined dataset as a shapefile. If you want the final output to be a shapefile, you need to set your workspace to a folder, rather than GDB.

If you want our output as a shapefile, use:

env.workspace = r"path/to/folder"



outFeature = r"C:Usersgeo.gdbsuccessJoined.shp"

If you want it to be a feature class, use:

env.workspace = r"C:Usersgeo.gdb"



outFeature = "successJoined"

Dependant on which output you want, you should input the above into:

import arcpy

env.workspace = 

arcpy.env.qualifiedFieldNames = False



# Set local variables for join  

inFeatures = r'C:Usersshapefile1.shp'

layerName = "ID"

joinTable = r"C:Userscsv1.csv"

joinField = "ID"

outFeature = 



arcpy.MakeFeatureLayer_management (inFeatures,  layerName)



# Join the feature layer to a table

AddJoin_management(layerName, joinField, joinTable, joinField, "KEEP_COMMON")



# Copy the layer to a new permanent feature class

arcpy.CopyFeatures_management(layerName, outFeature)

share|improve this answer

edited 9 mins ago

PolyGeo♦

53.7k1781244

answered Oct 13 '16 at 15:44

MacroZEDMacroZED

2,064519

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%2f214137%2ferror-arcpy-copy-feature-management-problem-when-making-join-to-shapefile%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

4

Within your Join function, you can set the join type to "Keep Common". This will only join features where ID = ID.

If you are trying to do a "Select By Attribute" function to find where ID = ID, this is not needed if you use the join type mentioned above.

The reason why the Copy Features tool doesn't work, is because you have set your workspace as a GDB, and then trying to export the final joined dataset as a shapefile. If you want the final output to be a shapefile, you need to set your workspace to a folder, rather than GDB.

If you want our output as a shapefile, use:

env.workspace = r"path/to/folder"



outFeature = r"C:Usersgeo.gdbsuccessJoined.shp"

If you want it to be a feature class, use:

env.workspace = r"C:Usersgeo.gdb"



outFeature = "successJoined"

Dependant on which output you want, you should input the above into:

import arcpy

env.workspace = 

arcpy.env.qualifiedFieldNames = False



# Set local variables for join  

inFeatures = r'C:Usersshapefile1.shp'

layerName = "ID"

joinTable = r"C:Userscsv1.csv"

joinField = "ID"

outFeature = 



arcpy.MakeFeatureLayer_management (inFeatures,  layerName)



# Join the feature layer to a table

AddJoin_management(layerName, joinField, joinTable, joinField, "KEEP_COMMON")



# Copy the layer to a new permanent feature class

arcpy.CopyFeatures_management(layerName, outFeature)

share|improve this answer

edited 9 mins ago

PolyGeo♦

53.7k1781244

answered Oct 13 '16 at 15:44

MacroZEDMacroZED

2,064519

add a comment | 

4

Within your Join function, you can set the join type to "Keep Common". This will only join features where ID = ID.

If you are trying to do a "Select By Attribute" function to find where ID = ID, this is not needed if you use the join type mentioned above.

The reason why the Copy Features tool doesn't work, is because you have set your workspace as a GDB, and then trying to export the final joined dataset as a shapefile. If you want the final output to be a shapefile, you need to set your workspace to a folder, rather than GDB.

If you want our output as a shapefile, use:

env.workspace = r"path/to/folder"



outFeature = r"C:Usersgeo.gdbsuccessJoined.shp"

If you want it to be a feature class, use:

env.workspace = r"C:Usersgeo.gdb"



outFeature = "successJoined"

Dependant on which output you want, you should input the above into:

import arcpy

env.workspace = 

arcpy.env.qualifiedFieldNames = False



# Set local variables for join  

inFeatures = r'C:Usersshapefile1.shp'

layerName = "ID"

joinTable = r"C:Userscsv1.csv"

joinField = "ID"

outFeature = 



arcpy.MakeFeatureLayer_management (inFeatures,  layerName)



# Join the feature layer to a table

AddJoin_management(layerName, joinField, joinTable, joinField, "KEEP_COMMON")



# Copy the layer to a new permanent feature class

arcpy.CopyFeatures_management(layerName, outFeature)

share|improve this answer

edited 9 mins ago

PolyGeo♦

53.7k1781244

answered Oct 13 '16 at 15:44

MacroZEDMacroZED

2,064519

add a comment | 

Within your Join function, you can set the join type to "Keep Common". This will only join features where ID = ID.

If you are trying to do a "Select By Attribute" function to find where ID = ID, this is not needed if you use the join type mentioned above.

The reason why the Copy Features tool doesn't work, is because you have set your workspace as a GDB, and then trying to export the final joined dataset as a shapefile. If you want the final output to be a shapefile, you need to set your workspace to a folder, rather than GDB.

If you want our output as a shapefile, use:

env.workspace = r"path/to/folder"



outFeature = r"C:Usersgeo.gdbsuccessJoined.shp"

If you want it to be a feature class, use:

env.workspace = r"C:Usersgeo.gdb"



outFeature = "successJoined"

Dependant on which output you want, you should input the above into:

import arcpy

env.workspace = 

arcpy.env.qualifiedFieldNames = False



# Set local variables for join  

inFeatures = r'C:Usersshapefile1.shp'

layerName = "ID"

joinTable = r"C:Userscsv1.csv"

joinField = "ID"

outFeature = 



arcpy.MakeFeatureLayer_management (inFeatures,  layerName)



# Join the feature layer to a table

AddJoin_management(layerName, joinField, joinTable, joinField, "KEEP_COMMON")



# Copy the layer to a new permanent feature class

arcpy.CopyFeatures_management(layerName, outFeature)

share|improve this answer

edited 9 mins ago

PolyGeo♦

53.7k1781244

answered Oct 13 '16 at 15:44

MacroZEDMacroZED

2,064519

env.workspace = r"path/to/folder"



outFeature = r"C:Usersgeo.gdbsuccessJoined.shp"

env.workspace = r"C:Usersgeo.gdb"



outFeature = "successJoined"

import arcpy

env.workspace = 

arcpy.env.qualifiedFieldNames = False



# Set local variables for join  

inFeatures = r'C:Usersshapefile1.shp'

layerName = "ID"

joinTable = r"C:Userscsv1.csv"

joinField = "ID"

outFeature = 



arcpy.MakeFeatureLayer_management (inFeatures,  layerName)



# Join the feature layer to a table

AddJoin_management(layerName, joinField, joinTable, joinField, "KEEP_COMMON")



# Copy the layer to a new permanent feature class

arcpy.CopyFeatures_management(layerName, outFeature)

share|improve this answer

edited 9 mins ago

PolyGeo♦

53.7k1781244

answered Oct 13 '16 at 15:44

MacroZEDMacroZED

2,064519

edited 9 mins ago

PolyGeo♦

53.7k1781244

edited 9 mins ago

PolyGeo♦

53.7k1781244

answered Oct 13 '16 at 15:44

MacroZEDMacroZED

2,064519

answered Oct 13 '16 at 15:44

MacroZEDMacroZED

2,064519