Latest Contributions by JaredPilbeam2

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

It's a bit late for Kathleen's question, but for future reference you can clip to layers in the data frame. For example, I'm always dealing with street labels hanging over the edges of a county boundary. One of two ways I found to clean these up are converting them to annotation in the map (as mentioned above), but this is way too time consuming with so many features. The other way is to 'clip to shape'. You can do this by double clicking the data frame you're working with --> Data Frame tab --> Clip to Shape --> and then there are a few options to clip to. I clipped to a polygon that doesn't cover anything within the county, only outside it-- Surrounding Counties. ... View more

Is there still no transparency setting? I'm having trouble finding it if there is. ... View more