AnsweredAssumed Answered

Why doesn't this WhereClause work?

Question asked by rralbritton on Oct 5, 2013
Latest reply on Oct 5, 2013 by rralbritton
Can someone please tell me why this where clause is invalid? I copied the format example in the 10.1 ESRI help  for Select by Attribute but it doesn't work. I've read through the forum and looked at a few others and tried reformatting this several ways with no luck. Thank You.

 import arcpy, os, shutil from arcpy import env from arcpy.sa import*  #set workspaces arcpy.env.workspace = "C:\\ArcGIS\\SurfCityData\\Data" #arcpy.GetParameterAsText(0) arcpy.env.overwriteOutput = True outputWorkspace = "C:\\ArcGIS\\SurfCityData\\Data\\Scratch" #arcpy.GetParameterAsText(1)  # Check out the ArcGIS 3D Analyst extension license arcpy.CheckOutExtension("3D") arcpy.CheckOutExtension("Spatial")  #Variables Year = "2005" Elevation = "C:\\ArcGIS\\SurfCityData\\Data\\LiDAR_DEM_2005\\2005_SP" #arcpy.GetParameterAsText(2) ObsPts = "C:\\ArcGIS\\SurfCityData\\Data\\Test_Points.shp" #arcpy.GetParameterAsText(3) footprint =  "C:\\ArcGIS\\SurfCityData\\Data\\Footprints\\BuildingFootprints_prj.shp" Ocean = "C:\\ArcGIS\\SurfCityData\\Data\\AtlanticOcean.shp" #arcpy.GetParameterAsText()  #Set analysis extent to elevation raster arcpy.env.extent = Elevation  #Create Featue Layers PointsFL = outName(ObsPts,"_Lyr") footprintFL = outName(footprint,"_Lyr") arcpy.MakeFeatureLayer_management(ObsPts, PointsFL) arcpy.MakeFeatureLayer_management(footprint,footprintFL)  FloorField = "FLOOR"  arcpy.SelectLayerByAttribute_management(PointsFL, "NEW_SELECTION", ' "FloorField" > 1 ' ) 

Outcomes