POST
|
SUCCESS!! Thank you both! When I entered the single quotes everything worked! mzcoyle: ref "copy copy" Since I am new to python I know I am going to screw up my dataset. Making one backup wasn't enough, I had to backup the backup 🙂 Thank you again! I was stuck on this for longer than I would like to admit (days, not hours...ugh). You are a lifesaver!
... View more
04-23-2014
10:12 AM
|
0
|
0
|
424
|
POST
|
Have you tried this tool? http://resources.arcgis.com/gallery/file/geoprocessing/details?entryID=37AEB018-1422-2418-A036-CA6D9920F808 I have--but I need to use the Python script because this is just one of many steps I am programming 😕 the python script for that specific tool is VERY long and complicated. I am new to python, so the script that Chris posted is perfect for what I am doing. I just cannot format the expression correctly. Python is so frustrating! The string substitution isn't working for me, but I could be entering it wrong. I will keep trying 🙂 thank you for the suggestion!
... View more
04-23-2014
09:49 AM
|
0
|
0
|
424
|
POST
|
How about something like: storeIdSet = set([r[0] for r in arcpy.da.SearchCursor(myFC, ["STORE_ID"])])
for storeId in storeIdSet:
outFC = r"C:\temp\test.gdb\store_" + str(storeId)
arcpy.Select_analysis(myFC, outFC, "STORE_ID = " + str(storeId)) Chris, I am getting an error message when I use this script indicating the SQL expression used in the select_analysis tool is invalid. I know how to set the expression to select a specific crime type, but I do not understand how to write an expression that will iterate through each crime type and make a new .shp file for each crime type. How do you write a SQL expression that will iterate through values of a field? This is how I have modified your code to fit my dataset: AllCrimes = "CopyCopySample2011_2013.shp"
CrimeTypeSet = set([r[0] for r in arcpy.da.SearchCursor(AllCrimes, ["CrimeType"])])
for CrimeType in CrimeTypeSet:
out_FC = "H:\\PythonOutput\\" + str(CrimeType)
arcpy.Select_analysis(AllCrimes, out_FC, "CrimeType = " + str(CrimeType)) the error message reads: "Executing: Select "H:\Sample Data\CopyCopySample2011_2013.shp" H:\PythonOutput\AgAssault.shp "CrimeType = AgAssault" Start Time: Wed Apr 23 13:23:04 2014 ERROR 000358: Invalid expression CrimeType = AgAssault A column was specified that does not exist. A column was specified that does not exist. Failed to execute (Select). Failed at Wed Apr 23 13:23:05 2014 (Elapsed Time: 1.00 seconds)" I have tried so many things and I am about to throw my computer out the window!! What am I doing wrong?
... View more
04-23-2014
09:41 AM
|
0
|
0
|
1179
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|