topic Re: raw_input in Select_analysis? in Python Questions

raw_input in Select_analysis?

RyanCooper — Wed, 30 Mar 2011 17:03:24 GMT

I'm working on a simple suitability analysis project for my GIS programming class wherein raw_inputs iare used to define part of the where_clause in Select_analysis. Here is what I have so far:

import arcpy
arcpy.env.workspace=r"I:\GIS\Test.mdb"
EL1=raw_input('Enter name of elementary school')
arcpy.Select_analysis('SchoolDistrictsElementary',r'I:\GIS\Output.mdb\school'+'_'+'EL1','[NAME]=EL1')

When I run the script, I get the following error:
General function failure [SchoolDistrictsElementary]
Too few parameters. Expected 1.
Failed to execute (Select).

I've tried everything I could think of, although my Python-fu is pretty weak. Nonetheless, this seems like on of those cases when the answer is right under my nose. Any thoughts on how to fix this issue? Thanks!

Re: raw_input in Select_analysis?

StevenArebalo — Wed, 30 Mar 2011 17:21:35 GMT

import arcpy
arcpy.env.workspace=r"I:\GIS\Test.mdb"
EL1=raw_input('Enter name of elementary school')
outFeatureClass='I:\GIS\Output.mdb\school_'+EL1
whereString='[NAME]="'+EL1+'"'
arcpy.Select_analysis('SchoolDistrictsElementary',outFeatureClass,whereString)

In your original code, the variable EL1 was read as a string instead of it's value in your WHERE clause. I haven't ran the code, but this should work. Hope this helps.

edited due to misreading OP

Re: raw_input in Select_analysis?

RyanCooper — Thu, 31 Mar 2011 14:58:57 GMT

Thanks for your reply. I couldn't quite get that to work. It would return an error that there was a missing operator for:
whereString='I:\GIS\Output.mdb\school_'+EL1+',[NAME]="'+EL1+'"'

Anyway, I adjusted my project a little bit so it's not so important that I have this element to it. Nonetheless, thank you again for your help!