Latest Contributions by JaredPilbeam2

‎03-05-2018

https://community.esri.com/message/755067-arcpyfeatureclasstofeatureclassconversion

‎03-05-2018

I'm wondering how to have a single parameter in the arcpy.FeatureClassToFeatureClass_conversion() function instead of repeating the block of code for two variables (Address_Points and Street), basically. From what I understand, the way this script is set up now, the outer loop prints once for each variable. Then it prints once for each variable again in the inner loop. It runs as I expect, namely with no errors and saves the two feature classes as shapefiles in the Test folder. import arcpy arcpy.env.overwriteOutput = True # variables infeatures = [r'fullpath\gisedit.DBO.Street', r'fullpath\gisedit.DBO.Address_Points'] outpath = r'fullpath\GISstaff\Jared\Test' outfeatures = ['WillCounty_Streets', 'WillCounty_AddressPoints'] # loop and print feature classes for infs in infeatures: print infs for otfs in outfeatures: print otfs arcpy.FeatureClassToFeatureClass_conversion(infs,outpath,otfs)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Result: >>> fullpath\gisedit.DBO.Street WillCounty_Streets WillCounty_AddressPoints fullpath\gisedit.DBO.Address_Points WillCounty_Streets WillCounty_AddressPoints‍‍‍‍‍‍ How do I get the print out to look like this? WillCounty_Streets WillCounty_AddressPoints‍‍

‎03-05-2018

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.

‎03-05-2018

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.

‎03-05-2018

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 ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎03-02-2018

Is there a way using arcpy to grab feature classes directly from an SDE and copy to a folder? I have a real chunky way to do it, namely using these functions: arcpy.mapping.ListDataFrames() arcpy.mapping.ListLayers() arcpy.mapping.AddLayer() arcpy.FeatureClassToFeatureClass_conversion()‍‍ ‍‍‍‍ The script overall adds features from an SDE to an mxd then saves them as shapefiles in a folder. How can I avoid using the mxd as a sort of springboard?

‎03-01-2018

Found out Open Data supports the following file types: map services feature services image services CSVs PDFs & Word docs

‎02-28-2018

Are the Data Categories restricted to a certain data type when using the Tag Query? I've added the tag Transportation to a few feature services in AGOL. I then added the same tag here in the Tag Query box. But, after clicking on this Data Category link in the website for testing I only get one result. I was expecting all the feature services to be there. I'm not sure what's going on.

‎02-28-2018

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?

‎02-08-2018

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.

‎02-07-2018

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.

‎02-07-2018

Using PythonWin 2.7.10, I would like to append a date to a bunch of zipfiles in a folder. I've been using the time module which prints the current month, day and year. But, I'm not sure how to append this date to the end of my zipfiles' file name. In this case I've been running tests on the WillCounty_PLSS.zip file, which contains a shapefile. This script seems to work, but it creates an odd looking file with no content: import time import arcpy from arcpy import env ws = arcpy.env.workspace = r'\\gisfile\GISstaff\Jared' current_time = time.strftime("%m%d%Y") output_name = "WillCounty_PLSS.zip" + current_time output_file = open(ws + output_name, "w") print current_time‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Here's how the file was named: JaredWillCounty_PLSS.zip02072018 EDIT: What do I need to do to have the look like this: WillCounty_PLSS_02072018.zip?

‎01-31-2018

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.

‎01-31-2018

Using arcpy.da.SearchCursor, how do you sort data in either ascending or descending order? I noticed the old arcpy.SearchCursor had sort_fields. arcpy.SearchCursor(dataset, {where_clause}, {spatial_reference}, {fields}, {sort_fields})‍‍ I have a script that uses arcpy.da.SearchCursor to create a list of table fields. The "D" in the function of line 8 is meant to put it in descending order, but it does not. env.workspace = r'\\gisfile\GISstaff\Jared\ModelBuilder\TEST folder\TESTGDB.gdb' #variables intable = "ElectionResults_Nov2016" tbList = [] #create list #use cursor to get all unique values in field, and list them in ascending order for row in arcpy.da.SearchCursor(intable, "ContestTitle", "D"): if row[0] not in tbList: tbList.append(row[0])‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ EDIT: I've also been looking into sorted. It's a matter of placing it in the cursor, though. sorted()‍

‎01-29-2018

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

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by JaredPilbeam2

Re: arcpy: copy feature classes from sde to folder?

arcpy.FeatureClassToFeatureClass_conversion()

Re: arcpy: copy feature classes from sde to folder?

Re: arcpy: copy feature classes from sde to folder?

Re: arcpy: copy feature classes from sde to folder?

arcpy: copy feature classes from sde to folder?

Re: Open Data Site Editor | Data Editor Tags

Open Data Site Editor | Data Editor Tags

Re: How to Categorize Data Sets in ArcGIS Open Data

Re: Timestamp a Zipfile File Name?

Re: Timestamp a Zipfile File Name?

Timestamp a Zipfile File Name?

Re: Arcpy SearchCursor: list fields in ascending/descending order?

Arcpy SearchCursor: list fields in ascending/descending order?

Re: (arcpy) Multiple TableSelect_analysis?

Re: Update table so column one stores the value of...

Re: BUG-000103046: Unable to add a locator to a pr...

Re: Disable popup on web component feature search

Add Data Widget Upload Limit

Re: ArcPro Script Tool parameter for a variety of ...

Experience Builder Custom Widgets