Latest Contributions by JaredPilbeam2

Joe, Same result. I put the question to stack exchange, where they often like to do a lot of nagging rather than helping. From what they were saying, though, I guess it's repeating because the outer loop loops once for each variable and then loops for each variable again for the inner loop. So, I guess that sort of draws out my main problem--I'm wondering how to use a list as a means to have one variable in the arcpy.FeatureClassToFeatureClass_conversion() function instead of repeating the block of code for each variable, basically. This wasn't ,my original question, so maybe I should post an additional one. ... View more

When I run it in regular mode both print statements are printed twice. I've attempted to use break after the for statements, but then it only runs the loop enough to print one of the two variables. I also tried to exit the loop with continue and pass, which didn't do anything. ... View more

That worked great, thanks. I adapted it to save two files as you can see in the variables, and it works fine. However, after running the debugger on it I noticed it's looping through the whole thing numerous times and taking longer than it should to complete. Maybe you can spot why that is? import arcpy arcpy.env.overwriteOutput = True # full path to connection file: infeatures = ([r'Database Connections\Jared to Plainfield.sde\gisedit.DBO.MGU_Will\gisedit.DBO.Street',                r'Database Connections\Jared to Plainfield.sde\gisedit.DBO.MGU_Will\gisedit.DBO.Address_Points']) outpath = r'\\gisfile\GISstaff\Jared\Test' outfeatures = ['WillCounty_Streets', 'WillCounty_AddressPoints'] for infs in infeatures:     print infs     for otfs in outfeatures:         arcpy.FeatureClassToFeatureClass_conversion(infs,outpath,otfs)         print otfs ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I have the same problem, basically. I gave a few feature services the same tag in AGOL. Then in our Open Data Editor, in the Tag Query box, I put the same tag. When viewing the website I only see one result when there should be a few? I made sure the tags were spelled correctly and the data is set to view publicly. Do the Data Categories in Open Data only allow you to tag certain data types? ... View more

Thanks everybody. While Matthew's renaming link was pretty much what I was looking for I decided to go with Blake's version as it was right here and works great. ... View more

Matthew, EDIT: You answered my question, and that worked to name it correctly, but I still have a problem. I wasn't very clear but I actually want a script to put the date on existing zipfiles, this one being one of them in a folder full of them. I'm not sure if the write method is even what I should be doing. ... View more

Thanks both Dan and Randy. That was the solution. Interestingly, what you have there works to order the fields in a descending order. On the other hand, the only way I got them to order in ascending order was not to have anything after ...ContestTitle: for rows in arcpy.da.SearchCursor(intable, field, sql_clause=(None, "ORDER BY ContestTitle")):‍ I tried "ORDER BY ContestTitle ASCE" and it threw an errror. ... View more

Randy, It works pretty flawlessly, thanks! Could you briefly explain how the dictionary works in this script? tbList = []‍ ... View more

Randy, Thanks for the help. All options are great. I went with the last one. I copied the script verbatim and it wrote new tables successfully except for one table, Results31. It's hung up. I did a few things to troubleshoot this: closed everything, used the 'ElectionResults_Nov2016' file in a different workspace, made sure the 'STATES ATTORNEY' record was even there... Traceback (most recent call last):   File "C:\Python27\ArcGIS10.4\Lib\site-packages\pythonwin\pywin\framework\scriptutils.py", line 326, in RunScript     exec codeObject in __main__.__dict__   File "\\gisfile\GISstaff\Jared\Python Scripts\Test2.py", line 22, in <module>     arcpy.TableSelect_analysis(intable, v, where_clause)   File "C:\Program Files (x86)\ArcGIS\Desktop10.4\ArcPy\arcpy\analysis.py", line 145, in TableSelect     raise e ExecuteError: ERROR 999999: Error executing function. An invalid SQL statement was used. An invalid SQL statement was used. [ElectionResults_Nov2016] An invalid SQL statement was used. [SELECT * FROM ElectionResults_Nov2016 WHERE ContestTitle = 'STATE'S ATTORNEY                                        '] The table was not found. [Results31] Failed to execute (TableSelect).‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ **EDIT: the 'STATE'S ATTORNEY' record is the only one with an apostrophe. So, I'm guessing this may be a format issue. I'm attempting to use the substitution function to get rid of it. import re re.sub() ‍‍‍‍ Also, instead of naming the new tables 'Results' how would you give them the table record's name? ... View more