ArcPy – Page 3 – GIS Courses | ArcGIS Pro | Online | Portal | ArcPy

Extend the Functionality of the Table to Excel tool in ArcGIS Pro with ArcPy

Table of Contents Introduction The Table to Excel tool from the Conversion toolbox is a stalwart amongst Geoprocessing tools but it does have its limitations, namely; you cannot subset the records directly with the tool itself, you cannot subset the columns to be exported and the order that you want them in the spreadsheet, and you cannot sort the […]

Extend the Functionality of the Table to Excel tool in ArcGIS Pro with ArcPy Read More »

Delete Records in ArcGIS Pro with Identical Geometries based on OID with ArcPy

Leave a Comment / ArcPy / Glen Bambrick

Table of Contents Introduction Every week I put time towards answering questions on three main platforms; GIS StackExchange, Esri Communities, and Reddit. I go under the alias Clubdebambos on each of them. This week I helped g3odood on Reddit who was looking to remove duplicate records based on geometry, but needed to keep the records from the duplicate groups that had the

Delete Records in ArcGIS Pro with Identical Geometries based on OID with ArcPy Read More »

The 5 Fundamental ArcPy Foundations You Need to Know!

Leave a Comment / ArcPy / Glen Bambrick

Table of Contents Introduction I remember being thrown into the deep end when it came to using ArcPy. The manual tasks were racking up, the human errors in a long-winded workflow were being compounded by fatigue, and let me tell you, it took about 60-90 hours to complete one of the workflows, waiting for the

The 5 Fundamental ArcPy Foundations You Need to Know! Read More »

Polygon-Polygon Overlap Percentage in ArcGIS Pro with Pairwise Intersect and ArcPy

Leave a Comment / ArcPy / Glen Bambrick

Table of Contents Introduction A common task is to calculate the percentage overlap between a polygon feature class overlaying another polygon feature class. One general workflow is to use the (Pairwise) Intersect tool with the Join Attributes parameter set to Only feature IDs, add a field to store the percentage overlap attributes, join the underlay polygons to the output based on Feature IDs, and

Polygon-Polygon Overlap Percentage in ArcGIS Pro with Pairwise Intersect and ArcPy Read More »

How to use Custom Tools in a Python Script with ArcPy

Leave a Comment / ArcPy / Glen Bambrick

Table of Contents Introduction If you head over to the this page you will find a couple of custom toolboxes that we have been creating. These are great, you can access via ArcGIS Pro and use to perform their intended tasks. But what if you want to add these to chained workflows in a Python script?

How to use Custom Tools in a Python Script with ArcPy Read More »

Sequentially Increment Numbered Values in ArcGIS Pro with ArcPy

Leave a Comment / ArcPy / Glen Bambrick

Table of Contents Introduction Many years ago I came across the How to Create Sequential Numbers in a Field in ArcMap using Python in the Field Calculator from Esri Technical Support and I have used this as the basis for more complex numbering throughout the years for various different projects. Our workflow for this blog post will

Sequentially Increment Numbered Values in ArcGIS Pro with ArcPy Read More »

Add Layer/Table Definition Query in ArcGIS Pro Based on Selection with ArcPy

Leave a Comment / ArcPy / Glen Bambrick

Table of Contents Introduction You have made a selection based on attributes or location in ArcGIS Pro (or via a script or tool) and you want to set a definition query that only shows the selected records. Let’s walk through making that tool in ArcGIS Pro with ArcPy Custom Tool Syntax The syntax for the Definition Query from Selection

Add Layer/Table Definition Query in ArcGIS Pro Based on Selection with ArcPy Read More »

Updating Single Symbology in ArcGIS Pro with Python CIM Access

Leave a Comment / ArcPy / Glen Bambrick

Table of Contents Introduction The Cartographic Information Model (CIM) is a map content specification for cartographic descriptions of GIS datasets and Project components in ArcGIS Pro. Essentially, it is the JSON that represents specifications for maps, scenes, layouts, layers, symbols, and styles in ArcGIS Pro. The best way to view these JSON specification is to save

Updating Single Symbology in ArcGIS Pro with Python CIM Access Read More »

Split Line at Point (Data Management) on a Basic License with ArcPy

2 Comments / Advanced Tools with a Basic License, ArcPy / Glen Bambrick

Table of Contents Introduction This one re-uses plenty of lines of code from the Split Line at Vertices tool. The Split Line at Point (Data Management) geoprocessing tool is only available in ArcGIS Pro with an Advanced license. Here’s how you can use ArcPy to achieve a similar output (if not the exact same for this one!).

Split Line at Point (Data Management) on a Basic License with ArcPy Read More »

Feature Vertices to Points (Data Management) on a Basic License with ArcPy

2 Comments / Advanced Tools with a Basic License, ArcPy / Glen Bambrick

Table of Contents Introduction This was a fun and challenging one to do! The Feature Vertices to Points (Data Management) geoprocessing tool is only available in ArcGIS Pro with an Advanced license. Here’s how you can use ArcPy to achieve a similar output. Check out the Esri documentation for more information on the tool here.

Feature Vertices to Points (Data Management) on a Basic License with ArcPy Read More »