Make feature layer & Select by attribute

Andreas_ForøTollefsen

Hi all.

I need to loop and split a polygon shapefile using a list of values that i want to incorporate into my query.
However, I cannot get the query to work properly.
How can i use variable x in the query?

Thanks.

# Import system modules
import sys, string, os, arcgisscripting

# Create the Geoprocessor object
gp = arcgisscripting.create()
gp.overwriteoutput = 1

# Load required toolboxes...
gp.AddToolbox("C:/Program Files/ArcGIS/ArcToolbox/Toolboxes/Data Management Tools.tbx")

# Set workspace
gp.workspace = "C:\\geodata\\PRIO_GRID\\Data_Sources\\cShapes0.24\\"

# Create list
yearlist = list(range(1946, 2009))

# Process: Select Layer By Attribute...
for x in yearlist:
    gp.MakeFeatureLayer("cshapes.shp","lyr")
    gp.SelectLayerByAttribute("lyr", "new_selection", "\"gwsyear\" <= x AND \"gweyear\" >= x")
    gp.CopyFeatures("lyr", "cshapes"+x)
    

Andreas_ForøTollefsen

Great. That worked.

Here is my code:

# Import system modules
import sys, string, os, arcgisscripting

# Create the Geoprocessor object
gp = arcgisscripting.create(9.3)
gp.overwriteoutput = 1

# Load required toolboxes...
gp.AddToolbox("C:/Program Files/ArcGIS/ArcToolbox/Toolboxes/Data Management Tools.tbx")

# Set workspace
gp.workspace = "C:\\geodata\\PRIO_GRID\\Data_Sources\\cShapes0.24\\"

# Create list
yearlist = list(range(1946, 2009))

# Define emptygrid
emptygrid = "C:\\geodata\\PRIO_GRID\\Data_Sources\\EmptyGrid\\emptygrid230610_WGS.shp"

# Select cShapes year and copy each year to new shapefile
for x in yearlist:
    query ="GWSYEAR <= " + str(x) + " " + "AND" + " " + "GWEYEAR >= " + str(x)
    gp.MakeFeatureLayer("cshapes.shp","lyr")
    gp.SelectLayerByAttribute("lyr", "new_selection", query)
    gp.CopyFeatures("lyr", "cshapes"+str(x))
    
del yearlist, query, x, emptygrid
print "completed"