Latest Contributions by NathanBaylot1

This comes up with a error: name 'env' not defined import arcpy import sys import string import os Input = arcpy.GetParameterAsText(0) Attribute = arcpy.GetParameterAsText(1) sqlclause = arcpy.GetParameterAsText(2) env.workspace = arcpy.GetParameterAsText(3) for att in Attribute:   arcpy.TableSelect_analysis(Input, Input + att, sqlclause) [ATTACH=CONFIG]11665[/ATTACH] [ATTACH=CONFIG]11664[/ATTACH] ... View more

Thanks and that does help. I got the getparameterastext() part. It's essentially value = input() or value = rawinput(). I guess my problem is the creating the tool part. I have read all the help documents on it and can't make heads or tails on some of it. For instance, on the list portion of my code. I don't know what kind of data type it would be. I haven't been coding for long and haven't gotten the grasp of putting it all together yet. import arcpy import sys import string import os fcIn = arcpy.GetParameterAsText(0) fclist = arcpy.GetParameterAsText(1) sqlclause = arcpy.GetParameterAsText(2) fcOut = arcpy.GetParameterAsText(3) for att in fclist:   arcpy.TableSelect_analysis("fcin", fcin + att + ".dbf",sqlclause) This is my work in progress. The other question would be. On the sqlclause portion, how do I get it to loop through the list with a different parameter each time. I can do this in hardcoding with a tuple or list. But the tool is different and I can't seem to link them. ... View more

It finally worked! Thank you so much! import arcpy FIPS = "C:\\Users\\D2148\\Documents\\Maps\\FIPS" FIPSlist = ('001', '003', '005', '007', '009', '011', '013',         '015', '017', '019', '021', '023', '025', '027',         '029', '031', '033', '035', '037', '039', '041',         '043', '045', '047', '049', '051', '053', '055',         '057', '059', '061', '063', '065', '067', '069',         '071', '073', '075', '077', '079', '081', '083',         '085', '087', '089', '091', '093', '095', '097',         '099', '101', '103', '105', '107', '109', '111',         '113', '115', '117', '119', '121', '123', '125',         '127') for fip in FIPSlist:   query = "FIPS_PARIS ='" + fip + "'"   arcpy.TableSelect_analysis("Master_TAHI", FIPS + "\\FIPS" + fip + ".dbf",query) This worked great. The thing is... I tried this combo many times. I think it was the placement of the " or '. ... View more

import arcpy FIPS = "C:\\Users\\D2148\\Documents\\Maps\\FIPS" c = 0 # FIPSlist = ('001', '003', '005', '007', '009', '011', '013', #Try smaller list first         #'015', '017', '019', '021', '023', '025', '027',         #'029', '031', '033', '035', '037', '039', '041',         #'043', '045', '047', '049', '051', '053', '055',         #'057', '059', '061', '063', '065', '067', '069',         #'071', '073', '075', '077', '079', '081', '083',         #'085', '087', '089', '091', '093', '095', '097',         #'099', '101', '103', '105', '107', '109', '111',         #'113', '115', '117', '119', '121', '123', '125',         #'127') #FIPSnum = (001, 003, 005, 007, 009, 011, 013, #Try Smaller list first        # 015, 017, 019, 021, 023, 025, 027,        # 029, 031, 033, 035, 037, 039, 041,        # 043, 045, 047, 049, 051, 053, 055,        # 057, 059, 061, 063, 065, 067, 069,        # 071, 073, 075, 077, 079, 081, 083,        # 085, 087, 089, 091, 093, 095, 097,        # 099, 101, 103, 105, 107, 109, 111,        # 113, 115, 117, 119, 121, 123, 125,        # 127) FIPSlist = ('001', '003', '005') FIPSnum = (001, 003, 005) while c < len(FIPSlist):         for fip in FIPSlist:                 query = "FIPS_PARIS ='" + fip + "'"                # arcpy.TableToTable_conversion("TRIAL1",FIPS,"FIPS" + FIPSlist + ".dbf",query)                 arcpy.TableSelect_analysis("Master_TAHI", FIPS + "\\FIPS" + FIPSlist + ".dbf",query)         c = c + 1 I think this will work as it was trying to work and made the first file correct. However, it will not loop anymore ... View more

Still having problems with the where clause. The select features will not go through the list loop. It only wants to find the list name since it is in quotes. I just can't figure this out. ... View more

How about: inputTable = r"C:\temp\test\mytable.dbf" outputWorkspace = r"C:\temp\test" fipsLlist = ['001', '003', '005', '007', '009', '011', '013', '015', '017', '019', '021', '023', '025', '027', '029', '031', '033', '035', '037', '039', '041', '043', '045', '047', '049', '051', '053', '055', '057', '059', '061', '063', '065', '067', '069', '071', '073', '075', '077', '079', '081', '083', '085', '087', '089', '091', '093', '095', '097', '099', '101', '103', '105', '107', '109', '111', '113', '115', '117', '119', '121', '123', '125', '127'] for fip in fipsList:    arcpy.TableSelect_analysis(inputTable, outputWorkspace + "\\fips_" + str(fip) + ".dbf", ","FIPS_PARIS = " +  "'" + fip + "'")  arc doesn't recognize the last part as an expression, just as a string. ... View more

I ran my most recent code and got the correct outcome except the fact it did not select the attributes needed for each file. i just tried the code without the "FIPS_PARISH" = '', attribute selection. It created the files correctly. ... View more

I also tried your way bruce but it did not work ... View more

FIPS = "C:\\Users\\D2148\\Documents\\Maps\\FIPS"       # I changed the destination for a shorter path name c = 0 FIPSlist = ['001', '003', '005', '007', '009', '011', '013',         '015', '017', '019', '021', '023', '025', '027',         '029', '031', '033', '035', '037', '039', '041',         '043', '045', '047', '049', '051', '053', '055',         '057', '059', '061', '063', '065', '067', '069',         '071', '073', '075', '077', '079', '081', '083',         '085', '087', '089', '091', '093', '095', '097',         '099', '101', '103', '105', '107', '109', '111',         '113', '115', '117', '119', '121', '123', '125',         '127'] while c < len(FIPSlist):     arcpy.TableToTable_conversion("Master_TAHI",FIPS,"FIPS" + FIPSlist + ".dbf","FIPS_PARIS" = "'" + FIPSlist + "'" ) #I'm thinking this is the problem with to many ", but I need it to automate choosing the next number. I also think that it is a string and the program won't take it.     c = c + 1 This is what I came up with because the number part would not be correct because it needs the 001,003, 005 and so forth. This code comes up with Runtime error <type 'exceptions.SyntaxError'>: keyword can't be an expression (<string>, line 14) ... View more

This is used inside of arcmap, the master tahi file was selected in the python window from drop down and the output I changed to "FIPS001.dbf", This still did not work. So, what I did was run it through the toolbox command with the window pop up and did the same parameters. This still came up with the exceeded records error. ... View more

Well then.... That would be a good feature to have since I work for the DOTD in LA and we have a lot of features to look through. Thanks for replying quickly. ... View more

Other than a query, is there no other way to just type in an attribute and it be found? ... View more