SDE Dataset does not exist or is not supported

Question

Hello,

I would appreciate help from the board.  This is a shortened version of a larger script but this is where the problem seems to lie.  I get the error below even though these layers exist in the mxd.  Ive also run these from arccatalog.  In that case, they usually work, but a couple of times they did not.  That leads me to believe its an SDE issue.  Im running 10, SV2.

ERROR 000732: Input Feature Layer: Dataset FLUM does not exist or is not supported
ERROR 000732: Selecting Features: Dataset ZoningCases does not exist or is not supported
Failed to execute (SelectLayerByLocation).
#--------------------------------------------------------------------------------------------
# Import system modules

import arcpy
from arcpy import env
import os
arcpy.env.overwriteOutput = True

#set workspace
arcpy.env.workspace = r"G:\NEIGHBOR PLAN\ArcView\Projects\Templates\"

#set mxd
mxd = arcpy.mapping.MapDocument(r"G:\NEIGHBOR PLAN\ArcView\Projects\Templates	est.mxd")

#set dataframe
df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]

#select features from FLUM within 2000 feet of ZoningCases
arcpy.SelectLayerByLocation_management("FLUM", "WITHIN_A_DISTANCE", "ZoningCases", "2000 feet", "NEW_SELECTION")

del mxd
#-----------------------------------------------

Thanks!!

Paul Frank
City of Austin

PaulFrank · Answer

Hello,

I was able to work through this using some of your suggestions.  I now run the script in ArcMap, which wasnt what i wanted originally, and used a tip about adding MakeFeatureLayer_management output to the display.  But I've run into other issues, namely the mxd is not saving with the output I generate, nor is the legend object adjusting as expected.  But I suppose I need to repost.

make_plan_amendment_map_test.py.zip

JakeSkinner · Answer

Hi Paul,

I believe you will need to make a feature layer before executing the SelectbyLocation function.  Example:arcpy.MakeFeatureLayer_management(addflumlayer, "FLUM")
arcpy.MakeFeatureLayer_management(addzcaselayer, "ZoningCases")
arcpy.SelectLayerByLocation_management("FLUM","WITHIN_A_DISTANCE","ZoningCases","2000 Feet","NEW_SELECTION")
arcpy.MakeFeatureLayer_management("FLUM", "FLUM_New")

PaulFrank · Answer

Patrick, Thanks for the reply.  I tried to wrap quotes around this post - and it says I cant post because its too short.  Maybe i need a couple of tutorials on this as well.

I do have the suggested ListDataFrames in my original .py file.  I should have attached that originally, but thought I had isolated the problem with my original post.  I would appreciate your looking at this file.

Thanks

make_plan_amendment_map.py.zip