Latest Contributions by MitchHolley1

‎06-20-2018

Joe, I also have ArcGIS Desktop 10.4 installed and Python 2.7. I can't figure out how to create/test code for Python3 using the packages/env installed by ArcGIS Pro.

‎06-20-2018

Thanks, Dan. So I'll need to download Anaconda and Spyder to interact with the Python3 packages Pro installed?

‎06-20-2018

I'm currently in the process of writing/testing scripts with Python3 to be used as Python Scripts Tools with ArcGIS Pro. I am confused with the Python stack installed with ArcGIS Pro 2.1. It seems like there is no IDLE- is this true? Also, if Anaconda comes installed with Pro- how can I create scripts with Python3 to be used in that environment? Do I need to download Python3 outside of the ArcGIS Pro stack? I have downloaded Sublime3 and downloaded Conda within it via the steps outlined here. But, I still do not know how to test scripts within it that point to the installed packages in the Pro directory. What is your process of creating/testing scripts to be used with the installed Python3 packages with ArcGIS Pro? I am very confused and any suggestions or documentation would be greatly appreciated.

‎05-22-2018

See here for reference: SQL reference for query expressions used in ArcGIS—ArcGIS Pro | ArcGIS Desktop Is the field you're trying to query a Date type? Have you tried just using ArcMap and 'Select By Attributes' tool to see what the unique values are.

‎05-02-2018

Nope, not that I can find. Could you try to replicate the error on some dummy data?

‎05-02-2018

We're in the process of moving from ArcGIS Desktop 10.4 to ArcGIS Pro, so the files were created with 10.4. The message above will pop up and then we'll refresh the directory and the shapefile will be gone.

‎05-01-2018

Has anyone else experienced accidentally dragging and dropping a shapefile on top of another shapefile (or the same shapefile) and having it be deleted? We have currently been experimenting with ArcGIS Pro 2.1.2 and this has been replicated throughout our organization. See error message below.

‎04-12-2018

This is a quick/dirty way to do it. I'm sure there is a more elegant way. lyr = "C:\Temp\Default.gdb\CurrntRoadNamesTableTest_1" preDir = ['N ','S ','E ','W '] #for field in arcpy.ListFields(lyr, "*", "String"): <- i don't know why you need this with arcpy.da.UpdateCursor(lyr, ['STREET']) as cursor: #since you're specifying field in cursor item for row in cursor: if row[0][:2] in preDir: row[0] = row[0][2:] cursor.updateRow(row) del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎04-04-2018

Change the inputDir path to the directory that houses your geodatabases...

‎04-03-2018

To add onto the concepts covered by @James, the following will take an input directory and loop over the gdbs and FCs for each one. import arcpy import os inputDir = r'path\to\directory\that\houses\geodatabases' ext = ['.mdb','.gdb'] gdbs = [x for x in os.listdir(inputDir) if x[-4:] in ext] for g in gdbs: fullpath = os.path.join(inputDir, g) arcpy.env.workspace = fullpath for fc in arcpy.ListFeatureClasses(): rowCount = arcpy.GetCount_management(fc)[0] if rowCount == '0': print "Deleting empty FC: {0}".format(os.path.join(g,fc)) arcpy.Delete_management(os.path.join(fullpath,fc)) else: print "{0} contains {1} records".format(os.path.join(g,fc), rowCount) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎03-29-2018

If you put something like this into the 'Pre-Logic Script Code' of the Field Calculator tool, it may work. def calc(field1, field2, field3): if len(str(field3)) == 1: return ("{0}{1}-00{2}".format(field1,field2,field3)) if len(str(field3)) == 2: return ("{0}{1}-0{2}".format(field1,field2,field3)) if len(str(field3)) == 3: return ("{0}{1}-{2}".format(field1,field2,field3))‍‍‍‍‍‍‍

‎03-15-2018

First - I had a syntax error in my original reply. It has been edited, please try that one. Second - Click the three eellipses when writing the response -> click 'More' -> 'Syntax Highlighter'

‎03-15-2018

You should use the in python function to see if the value of the row you're iterating over is found in the list. See below for an example. Note: make sure to convert the values to a string before comparing (row 10), since the values in the deletedValues list are strings. import arcpy dataset = r'path\to\dataset.shp' deleteValues = ['1','2','3'] cursor = arcpy.da.UpdateCursor(dataset, ['FIELD']) for count, d in enumerate(cursor): if str(d[0]) in deleteValues: cursor.deleteRow() del cursor print '{0} rows were deleted.'.format(count) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎03-01-2018

What happens if you export as a PDF?

‎02-21-2018

So it looks like 'version.name.split(".")[0]` is returning the [Owner] name and not the [Name]. That's strange... What happens it you tried printing the entire version.name? print "Target: {0}".format(versionName) for version in arcpy.da.ListVersions(sdeConnection): print "Found - {0}".format(version.name) ## if version.name.split(".")[0] == versionName: ## print(userVersion) ## versionFound = True ## break‍‍‍‍‍‍‍

Online Status	Offline
Date Last Visited	3 weeks ago

My Ideas

Latest Contributions by MitchHolley1

Re: ArcGIS Pro 2.1.3 and Python3

Re: ArcGIS Pro 2.1.3 and Python3

ArcGIS Pro 2.1.3 and Python3

Re: Query date range

Re: Shapefiles being deleted after dragging & dropping

Re: Shapefiles being deleted after dragging & dropping

Shapefiles being deleted after dragging & dropping

Re: Remove predirectional from attribute table

Re: how to delete multiple mdb or gdb empty feature class.

Re: how to delete multiple mdb or gdb empty feature class.

Re: How to convert single number into 3 digit code using Python and field calculator?

Re: Python - Remove rows in Shapefile Based on Criteria in a Field

Re: Python - Remove rows in Shapefile Based on Criteria in a Field

Re: Distortion in Text when exporting a map

Re: Using Arcpy Try Except statement

Re: Field Calculate 'Use the selected records' Doe...

Re: UNDO "Make this the only selectable layer"

Field Returning to Default Length When Editing

Re: Field Returning to Default Length When Editing

Re: Looking for a part time GIS job with no GIS wo...