nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arcpy “Select” Returns Error 000732

Business_IntelligenceSoftware

I'm trying to use this "Select" script from https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fpro.arcgis.com%2Fen%2Fpro-app%2Ftool-reference%2Fanalysis…

but it keeps giving me the following error.

Traceback (most recent call last):

File "<string>", line 10, in <module>

File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\analysis.py", line 91, in Select

raise e

File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\analysis.py", line 88, in Select

retval = convertArcObjectToPythonObject(gp.Select_analysis(*gp_fixargs((in_features, out_feature_class, where_clause), True)))

File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 506, in <lambda>

return lambda *args: val(*gp_fixargs(args, True))

arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.ERROR 000732: Input Features: Dataset C:\arcGIS_Shared\Python\PythonTestScript.gdb\CAPatients does not exist or is not supportedFailed to execute (Select).

And Here is the script I'm using:

# Import system modules
import arcpy
# Set local variables
in_features = r"C:\arcGIS_Shared\Python\PythonTestScript.gdb\CAPatients"
out_feature_class = r"C:\arcGIS_Shared\Python\PythonTestScript.gdb\Geocoded2"
where_clause = '"Age" = \'62\''
# Execute Select
arcpy.Select_analysis(in_features, out_feature_class, where_clause)

In the script above, the datatype for "Age" is "long"; but I have also tried replacing "Age" with "Zip_Code", which is "text".

Anyone have any ideas what I'm doing wrong or missing?

Najděte více příspěvků označených jako

Accepted answers

DanPatterson_Retired

A table can originate from many sources... some of which don't have geometry, that is why I ask

From the help... so it is a table from a featureclass or a feature layer then...

Extracts features from an input feature class or input feature layer,

for tables http://desktop.arcgis.com/en/arcmap/latest/tools/analysis-toolbox/table-select.htm

All comments

DanPatterson_Retired

A table can originate from many sources... some of which don't have geometry, that is why I ask

From the help... so it is a table from a featureclass or a feature layer then...

Extracts features from an input feature class or input feature layer,

for tables http://desktop.arcgis.com/en/arcmap/latest/tools/analysis-toolbox/table-select.htm

JasonWhite

I would almost venture to say that it is an actual table. It would work with either the feature layer or feature class. If it were an actual feature class the error shouldn't have thrown that last line.

C:\arcGIS_Shared\Python\PythonTestScript.gdb\CAPatients does not exist or is not supportedFailed to execute (Select).

DanPatterson_Retired

Is it a featureclass ... ie is the table being queried just a table? or a featureclass table... they are not the same

JasonWhite

Two things. First, since I can't see the whole code, I presume you have set your arcpy.env.workspace to something?

Second, I ran into a very similar issue with that same tool yesterday actually. I spent a ton of time having to dig through SQL formatting for that where clause.

temp = arcpy.Select_analysis("All.shp", "NEW_SELECTION", "ReportingU = '{0}'".format(i)) arcpy.CopyFeatures_management(temp, '{0}.shp'.format(i))

The "i" is just iterating through a list of unit IDs which are strings. But that is the format for the where clause that worked for me with that tool.

JasonWhite

The trail bracket was included in the hyper link. It just went to the help page for the Select_analysis tool:

http://pro.arcgis.com/en/pro-app/tool-reference/analysis/select.htm#C_GUID-81DADC1A-506C-4C5F-B9F8-945132BB8DC0

Business_IntelligenceSoftware

The datatype for "Age" is "long"; but I have also tried replacing "Age" with "Zip_Code", which is "text".

And "CAPatients" is a table in my geodatabase. Not sure if that answers your question or not.

DanPatterson_Retired

it is a featureclass (your link doesn't work) and not some other type of data type?

Also your query, are the values in the field text or numeric?

where_clause <SPAN class="operator token">=</SPAN> <SPAN class="string token">'"Age" = \'62\''</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>where_clause<SPAN class="punctuation token">)</SPAN>
<SPAN class="string token">"Age"</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'62'</SPAN>

where_clause <SPAN class="operator token">=</SPAN> <SPAN class="string token">'"Age" = 62'</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>where_clause<SPAN class="punctuation token">)</SPAN>
<SPAN class="string token">"Age"</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">62</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.