Getting ERROR 000840 from arcpy.SelectLayerByAttribute_management? Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Listing Elements or Datasets of Layer gives ERROR 000840 value is not Feature Layer?ERROR 000840: The value is not a Raster|Raster Catalog|Mosaic Layer from arcpy.AddJoin_management()?Select By Atribute using python script on .Shp file getting error 000840 the value is not a raster layerExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Layer Name or Table View: Dataset L does not existUsing arcpy.MakeFeatureLayer_management on Shapefile and Feature ClassArcpy Network analyst - Perform OD Matrix Cost in loopArcpy.AddJoin errorSelect By Attributes Based on Unique Value in Shapefile gives ERROR 000840?ExecuteError: Failed to execute. Parameters are not valid error when SelectLayerByAttribute run in Python 2.7Cannot find results of MakeFeatureLayer, cannot use SelectFeatureByAttribute
Fit odd number of triplets in a measure?
What did Turing mean when saying that "machines cannot give rise to surprises" is due to a fallacy?
How can I prevent/balance waiting and turtling as a response to cooldown mechanics
Why did Bronn offer to be Tyrion Lannister's champion in trial by combat?
3D Masyu - A Die
calculator's angle answer for trig ratios that can work in more than 1 quadrant on the unit circle
Why do C and C++ allow the expression (int) + 4*5;
Is this Kuo-toa homebrew race balanced?
How to ask rejected full-time candidates to apply to teach individual courses?
Twin's vs. Twins'
What does 丫 mean? 丫是什么意思？
Did John Wesley plagiarize Matthew Henry...?
Vertical ranges of Column Plots in 12
Short story about astronauts fertilizing soil with their own bodies
Can gravitational waves pass through a black hole?
The Nth Gryphon Number
Improvising over quartal voicings
What is "Lambda" in Heston's original paper on stochastic volatility models?
Was the pager message from Nick Fury to Captain Marvel unnecessary?
The test team as an enemy of development? And how can this be avoided?
Marquee sign letters
Any stored/leased 737s that could substitute for grounded MAXs?
Why are two-digit numbers in Jonathan Swift's "Gulliver's Travels" (1726) written in "German style"?
Does the main washing effect of soap come from foam?
Getting ERROR 000840 from arcpy.SelectLayerByAttribute_management?
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?Listing Elements or Datasets of Layer gives ERROR 000840 value is not Feature Layer?ERROR 000840: The value is not a Raster|Raster Catalog|Mosaic Layer from arcpy.AddJoin_management()?Select By Atribute using python script on .Shp file getting error 000840 the value is not a raster layerExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Layer Name or Table View: Dataset L does not existUsing arcpy.MakeFeatureLayer_management on Shapefile and Feature ClassArcpy Network analyst - Perform OD Matrix Cost in loopArcpy.AddJoin errorSelect By Attributes Based on Unique Value in Shapefile gives ERROR 000840?ExecuteError: Failed to execute. Parameters are not valid error when SelectLayerByAttribute run in Python 2.7Cannot find results of MakeFeatureLayer, cannot use SelectFeatureByAttribute
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I am trying to select layer by attribute and for that, I am using arcpy.SelectLayerByAttribute_management function . My command is as follows:
arcpy.SelectLayerByAttribute_management(union, 'NEW_SELECTION', '"gridcode" =1 AND "area" >=25000000*0.4')
Here, union is the shapefile, from which I need to select layers by attribute. My SQL query is "gridcode" =1 AND "area" >=25000000*0.4
I am getting the following error:
ExecuteError: Failed to execute. Parameters are not valid. The value
cannot be a feature class ERROR 000840: The value is not a Raster
Layer. ERROR 000840: The value is not a Mosaic Layer. Failed to
execute (SelectLayerByAttribute).`
arcpy select-by-attribute error-000840
edited Mar 13 at 12:29
artwork21
31.1k555120
asked Mar 13 at 11:26
lsr729lsr729
294
|
show 4 more comments
I am trying to select layer by attribute and for that, I am using arcpy.SelectLayerByAttribute_management function . My command is as follows:
arcpy.SelectLayerByAttribute_management(union, 'NEW_SELECTION', '"gridcode" =1 AND "area" >=25000000*0.4')
Here, union is the shapefile, from which I need to select layers by attribute. My SQL query is "gridcode" =1 AND "area" >=25000000*0.4
I am getting the following error:
ExecuteError: Failed to execute. Parameters are not valid. The value
cannot be a feature class ERROR 000840: The value is not a Raster
Layer. ERROR 000840: The value is not a Mosaic Layer. Failed to
execute (SelectLayerByAttribute).`
arcpy select-by-attribute error-000840
edited Mar 13 at 12:29
artwork21
31.1k555120
asked Mar 13 at 11:26
lsr729lsr729
294
couldn't you test"area" >= 10000000?
– Vince
Mar 13 at 11:34
yes i just changed it but still it gives error
– lsr729
Mar 13 at 11:35
1
Try creating a feature layer using MakeFeatureLayer, and pass this to SelectLayerByAttributes.
– BERA
Mar 13 at 12:02
We'd need to see more of your script to know. Whateverunionis appears to be the problem. It's not a layer that the tool wants.
– KHibma
Mar 13 at 12:22
1
Yes it worked after making a layer first. Thank
– lsr729
Mar 13 at 12:47
|
show 4 more comments
I am trying to select layer by attribute and for that, I am using arcpy.SelectLayerByAttribute_management function . My command is as follows:
arcpy.SelectLayerByAttribute_management(union, 'NEW_SELECTION', '"gridcode" =1 AND "area" >=25000000*0.4')
Here, union is the shapefile, from which I need to select layers by attribute. My SQL query is "gridcode" =1 AND "area" >=25000000*0.4
I am getting the following error:
ExecuteError: Failed to execute. Parameters are not valid. The value
cannot be a feature class ERROR 000840: The value is not a Raster
Layer. ERROR 000840: The value is not a Mosaic Layer. Failed to
execute (SelectLayerByAttribute).`
arcpy select-by-attribute error-000840
edited Mar 13 at 12:29
artwork21
31.1k555120
asked Mar 13 at 11:26
lsr729lsr729
294
I am trying to select layer by attribute and for that, I am using arcpy.SelectLayerByAttribute_management function . My command is as follows:
arcpy.SelectLayerByAttribute_management(union, 'NEW_SELECTION', '"gridcode" =1 AND "area" >=25000000*0.4')
Here, union is the shapefile, from which I need to select layers by attribute. My SQL query is "gridcode" =1 AND "area" >=25000000*0.4
I am getting the following error:
ExecuteError: Failed to execute. Parameters are not valid. The value
cannot be a feature class ERROR 000840: The value is not a Raster
Layer. ERROR 000840: The value is not a Mosaic Layer. Failed to
execute (SelectLayerByAttribute).`
arcpy select-by-attribute error-000840
arcpy select-by-attribute error-000840
edited Mar 13 at 12:29
artwork21
31.1k555120
asked Mar 13 at 11:26
lsr729lsr729
294
edited Mar 13 at 12:29
artwork21
31.1k555120
asked Mar 13 at 11:26
lsr729lsr729
294
edited Mar 13 at 12:29
artwork21
31.1k555120
edited Mar 13 at 12:29
artwork21
31.1k555120
edited Mar 13 at 12:29
artwork21
31.1k555120
31.1k555120
asked Mar 13 at 11:26
lsr729lsr729
294
asked Mar 13 at 11:26
lsr729lsr729
294
asked Mar 13 at 11:26
lsr729lsr729
294
294
couldn't you test"area" >= 10000000?
– Vince
Mar 13 at 11:34
yes i just changed it but still it gives error
– lsr729
Mar 13 at 11:35
1
Try creating a feature layer using MakeFeatureLayer, and pass this to SelectLayerByAttributes.
– BERA
Mar 13 at 12:02
We'd need to see more of your script to know. Whateverunionis appears to be the problem. It's not a layer that the tool wants.
– KHibma
Mar 13 at 12:22
1
Yes it worked after making a layer first. Thank
– lsr729
Mar 13 at 12:47
|
show 4 more comments
couldn't you test"area" >= 10000000?
– Vince
Mar 13 at 11:34
yes i just changed it but still it gives error
– lsr729
Mar 13 at 11:35
1
Try creating a feature layer using MakeFeatureLayer, and pass this to SelectLayerByAttributes.
– BERA
Mar 13 at 12:02
We'd need to see more of your script to know. Whateverunionis appears to be the problem. It's not a layer that the tool wants.
– KHibma
Mar 13 at 12:22
1
Yes it worked after making a layer first. Thank
– lsr729
Mar 13 at 12:47
couldn't you test
"area" >= 10000000?– Vince
Mar 13 at 11:34
couldn't you test
"area" >= 10000000?– Vince
Mar 13 at 11:34
yes i just changed it but still it gives error
– lsr729
Mar 13 at 11:35
yes i just changed it but still it gives error
– lsr729
Mar 13 at 11:35
1
1
Try creating a feature layer using MakeFeatureLayer, and pass this to SelectLayerByAttributes.
– BERA
Mar 13 at 12:02
Try creating a feature layer using MakeFeatureLayer, and pass this to SelectLayerByAttributes.
– BERA
Mar 13 at 12:02
We'd need to see more of your script to know. Whatever
union is appears to be the problem. It's not a layer that the tool wants.– KHibma
Mar 13 at 12:22
We'd need to see more of your script to know. Whatever
union is appears to be the problem. It's not a layer that the tool wants.– KHibma
Mar 13 at 12:22
1
1
Yes it worked after making a layer first. Thank
– lsr729
Mar 13 at 12:47
Yes it worked after making a layer first. Thank
– lsr729
Mar 13 at 12:47
|
show 4 more comments
1 Answer
1
active
oldest
votes
You are trying to select on a feature class when it should be a feature layer. Use MakeFeatureLayer to create a layer then pass this to SelectLayerByAttributes:
Creates a feature layer from an input feature class or layer file
(It is also possible to use a where_clause in MakeFeatureLayer and then there is no need for SelectLayerByAttributes.)
answered Mar 13 at 13:53
BERABERA
17.4k62044
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
);
);
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f315347%2fgetting-error-000840-from-arcpy-selectlayerbyattribute-management%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You are trying to select on a feature class when it should be a feature layer. Use MakeFeatureLayer to create a layer then pass this to SelectLayerByAttributes:
Creates a feature layer from an input feature class or layer file
(It is also possible to use a where_clause in MakeFeatureLayer and then there is no need for SelectLayerByAttributes.)
answered Mar 13 at 13:53
BERABERA
17.4k62044
add a comment |
You are trying to select on a feature class when it should be a feature layer. Use MakeFeatureLayer to create a layer then pass this to SelectLayerByAttributes:
Creates a feature layer from an input feature class or layer file
(It is also possible to use a where_clause in MakeFeatureLayer and then there is no need for SelectLayerByAttributes.)
answered Mar 13 at 13:53
BERABERA
17.4k62044
add a comment |
You are trying to select on a feature class when it should be a feature layer. Use MakeFeatureLayer to create a layer then pass this to SelectLayerByAttributes:
Creates a feature layer from an input feature class or layer file
(It is also possible to use a where_clause in MakeFeatureLayer and then there is no need for SelectLayerByAttributes.)
answered Mar 13 at 13:53
BERABERA
17.4k62044
You are trying to select on a feature class when it should be a feature layer. Use MakeFeatureLayer to create a layer then pass this to SelectLayerByAttributes:
Creates a feature layer from an input feature class or layer file
(It is also possible to use a where_clause in MakeFeatureLayer and then there is no need for SelectLayerByAttributes.)
answered Mar 13 at 13:53
BERABERA
17.4k62044
edited Mar 13 at 13:59
answered Mar 13 at 13:53
BERABERA
17.4k62044
answered Mar 13 at 13:53
BERABERA
17.4k62044
answered Mar 13 at 13:53
BERABERA
17.4k62044
17.4k62044
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f315347%2fgetting-error-000840-from-arcpy-selectlayerbyattribute-management%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
couldn't you test
"area" >= 10000000?– Vince
Mar 13 at 11:34
yes i just changed it but still it gives error
– lsr729
Mar 13 at 11:35
1
Try creating a feature layer using MakeFeatureLayer, and pass this to SelectLayerByAttributes.
– BERA
Mar 13 at 12:02
We'd need to see more of your script to know. Whatever
unionis appears to be the problem. It's not a layer that the tool wants.– KHibma
Mar 13 at 12:22
1
Yes it worked after making a layer first. Thank
– lsr729
Mar 13 at 12:47