Latest Contributions by RobertBurke

Have you encountered data structured like the list of my favorite beaches below? Maybe you have a text file or spreadsheet that contains location and attribute information, and you want to display it on a map in ArcGIS Pro. My favorite beaches Avila, -120.7313, 35.17797 Coronado, -117.1944, 32.6864 Jalama, -120.50, 34.51 Newport, -117.9198, 33.6053 Santa Cruz, -122.01853, 36.963414 Esri’s Python site package (called arcpy) can help automate a process to read in location information, such as geographic coordinates, and turn each location into a feature in a geodatabase feature class table. The arcpy InsertCursor object adds new records into an attribute table. This post will guide you through the steps to do this. If you are new to Python programming, before reading through this post, it may be helpful to watch the live training seminar, Python 101 for ArcGIS, to enhance your understanding of the fundamentals. You can work your way through this post simply by reading or you can be hands-on by following the guided steps and start up ArcGIS Pro to try out and experiment with the code yourself. To get started, all you need is ArcGIS Pro. Get Started To set up for this process you open up ArcGIS Pro, create a map, and change its basemap. Start ArcGIS Pro without a template. From the Insert tab, Project group, insert a new map and change its name to California Beaches. From the Map tab, Layer group, change the basemap to Oceans and zoom in to California. Create a Geodatabase Notebooks are used to create, document, save, share, and test run Python code. In ArcGIS Pro, from the Insert tab, Project group, insert a new notebook. In the Catalog pane, change the notebook name to CreateBeaches.ipynb. The new Notebook has a blue outlined cell. Python code is written and organized into cells. Add the following code into the cell. If you copy and paste, use CTRL+V to paste the code into the cell.     arcpy.management.CreateFolder("C:/", "temp") arcpy.management.CreateMobileGDB("C:/temp", "Coastal")     Left of the cell you will see empty square brackets [ ], when you run the code you will see a star inside [*]. After the code successfully runs you will see a number inside [1]. The code above uses arcpy to run the CreateFolder and the CreateMobileGDB tools from the Management toolbox. The syntax arcpy.toolboxname.toolname can be used to run any of the over 1,600 tools in ArcGIS Pro. When your notebook matches the code in the one above, click the Run button to create the Coastal mobile geodatabase in your c:\temp folder. After a code cell runs it turns gray. Messages report run time or errors. Under the messages a new empty cell is ready for more code. Cells contain manageable blocks of Python code that you can write and run independently (or all together). When a cell has the blue outline, it is the active cell and its code will run if you click the Run button. Create a Feature Class Feature classes are geodatabase tables composed of records and fields. A feature class is different than a standalone table because it has a special and different field called Shape. It is where point, line, or polygon geometry is stored. Add the following code into the second cell.     sr = arcpy.SpatialReference(4326) arcpy.management.CreateFeatureclass("C:/temp/Coastal.geodatabase", "Beaches", "POINT", spatial_reference = sr)     The first line uses WKID 4326 to set up a spatial reference to the WGS84 geographic coordinate system. The beach Longitude and Latitude coordinates are WGS84. The second line creates the Beaches point feature class using the CreateFeatureclass tool. When your cell matches this example, click the Run button to create the Beaches feature class. When the cell finishes running, in the Catalog pane, navigate to the C:\Temp folder to confirm the geodatabase and feature class are both there. Coastal.geodatabase is stored as a single file. Mobile geodatabases use the open-source database format called SQLite. The main.Beaches feature class uses the SQLite naming convention. Look in the Contents pane to see the Beaches layer on the map. Add a Field to the Feature Class Table A table is made up of fields, sometimes called columns, attributes, headings, and even Attribute Fields. They each have a data type like number, text string, date, blob, ID, and geometry. Back in the notebook add the following code into the third cell.     arcpy.env.workspace = "C:/temp/Coastal.geodatabase" arcpy.management.AddField("Beaches", "BeachName", "TEXT", field_length = 10)     The first line sets the environment workspace to the Coastal mobile geodatabase. The next line runs the AddField tool to add a text field called BeachName to the Beaches feature class. The field is 10 characters wide. Click the Run button to add the BeachName field to the Beaches feature class. Add a Record to the Table In a table the rows are called records; in a feature class the rows are called features. The InsertCursor adds rows to a table. In the Notebook’s fourth cell add the following code.     cursor = arcpy.da.InsertCursor("Beaches", ["BeachName", "SHAPE@XY"]) row = ["Jalama", (-120.50, 34.51)] cursor.insertRow(row)     The first line of code creates an InsertCursor that will be used to insert a new beach. The row variable contains a list with Jalama beach and a tuple of its coordinate pair. Click the Run button to add Jalama Beach to the Beaches layer. Add Many Records to the Table The InsertCursor can add one record at a time as shown above, however when structured inside a looping routine many records can be added in one shot! In the Notebook’s fifth cell add the following code. Take notice of the for loop and how it has two indented lines. If you copy and paste that indent might be lost. Before you test run the cell ensure that your indenting looks that that shown below.     BeachList = [ ["Coronado", (-117.1944, 32.6864)], ["Avila", (-120.7313, 35.17797)], ["Santa Cruz", (-122.01853,36.963414)], ["Newport", (-117.9198, 33.6053)] ] for Beach in BeachList: row = Beach cursor.insertRow(row) del cursor     The first lines (1 to 6) represent a list of beaches where each beach has its own unique list containing a name and a tuple for the pair of the WGS84 coordinates. The for loop (lines 7 to 9) goes to each beach in the list and adds it into the Beaches feature class. When the cursor is done doing its job the best practice is to remove it from memory using the Python del statement. Click the Run button to add four more beaches. Bring the map to the front to see the beaches! If the beaches don’t appear zoom in and out on the map to refresh. The point symbols are small and hard to see. Size and color change is next. Back in the Notebook, in the next new cell, add the following code.     aprx = arcpy.mp.ArcGISProject("current") m = aprx.listMaps("California Beaches")[0] lyr = m.listLayers("main.Beaches")[0] lblClass = lyr.listLabelClasses()[0] lblClass.expression = "$feature.BeachName" lyr.showLabels = True     This code navigates to the current project, gets the map, gets the beaches layer, and changes label expression to the BeachName field, and finally turns on the layer's labels. Run the cell. Bring the California Beaches Map to the foreground to see labels on all five beaches! Back in the Notebook, in the next new cell, add the following code.     sym = lyr.symbology sym.renderer.symbol.color = {'RGB' : [255, 0, 0, 60]} sym.renderer.symbol.size = 12 lyr.symbology = sym     This code gets and sets the layer’s symbol renderer to change color to red, 60% transparent, and increase the point symbol size to 12. Run the cell. Bring the California Beaches Map to the foreground to see the color and size changes. Congratulations! You just added a feature to a feature class using an arcpy cursor. ArcGIS Pro cursors give you record-by-record access to your geospatial data. As you become more comfortable with Python, you will discover even more innovative ways to apply it. Cursors represent a powerful leap forward in how you customize your ArcGIS Pro experience. Whether you need to fine-tune existing data, generate entirely new features, or uncover insights through targeted analytics, cursors provide the precision and flexibility that standard tools sometimes lack. Embracing cursors unlocks a new level of problem-solving within your GIS workflows. Think of them as your key to turning good data into actionable intelligence. ___________________ Learn More For more information on cursors in ArcGIS Pro, check out these resources: For in-depth Python training, check out Esri's Creating Python Scripts for ArcGIS course. Read more about InsertCursor in the ArcGIS Pro documentation. ... View more

Lesson 1 - Foundations of the utility network  Benefits of a utility network https://pro.arcgis.com/en/pro-app/help/data/utility-network/benefits-of-the-utility-network.htm   Utility Network Tab https://pro.arcgis.com/en/pro-app/help/data/utility-network/utility-network-tab.htm   Utility Network Package Tools https://solutions.arcgis.com/utilities/help/utility-network-automation/   ArcGIS solutions http://solutions.arcgis.com/   Utility Network Configurations Electric http://solutions.arcgis.com/electric/help/electric-utility-network-configuration/ Get started with the Electric Utility Network Configuration http://solutions.arcgis.com/electric/help/electric-utility-network-configuration/get-started/get-started-overview.htm Top Ten things about the Utility Network for electric https://community.esri.com/people/pdemer-esristaff/blog/2017/12/14/top-ten-things-about-the-utility-network-for-electric   Gas http://solutions.arcgis.com/gas/help/gas-utility-network-configuration/ Get started with the Gas Utility Network Configuration http://solutions.arcgis.com/gas/help/gas-utility-network-configuration/get-started/get-started-overview.htm   Water http://solutions.arcgis.com/water/help/water-utility-network-configuration/ Get started with the Water Distribution Utility Network Configuration: http://solutions.arcgis.com/water/help/water-utility-network-configuration/get-started/get-started-overview.htm   Sewer Home: http://solutions.arcgis.com/water/help/sewer-utility-network-configuration/ Get started with the Sewer Utility Network Configuration https://solutions.arcgis.com/water/help/sewer-utility-network-configuration/get-started/get-started.htm   Utility network layer properties https://pro.arcgis.com/en/pro-app/help/data/utility-network/access-utility-network-layer-properties.htm#ESRI_SECTION2_609F07A437994BB6B0F02BCD14A0C6EB   Lesson 2 - Network Topology Management Network topology https://pro.arcgis.com/en/pro-app/help/data/utility-network/about-network-topology.htm   Branch versioning https://pro.arcgis.com/en/pro-app/help/data/geodatabases/overview/data-management-strategies.htm#ESRI_SECTION1_6FA2CFB5F9484FF096740D653C674B5D   Adds a rule to a utility network https://pro.arcgis.com/en/pro-app/tool-reference/utility-networks/add-rule.htm   Networks, graphs, edges, and junctions - older historical info  http://resources.esri.com/help/9.3/ArcGISengine/dotnet/e084da94-d4f7-4da7-86ed-7df684ff2144.htm     Lesson 3 - Managing Connectivity and Associations Help - Connectivity and associations https://pro.arcgis.com/en/pro-app/help/data/utility-network/about-connectivity-and-associations.htm   Lesson 4 - Network management Set Subnetwork Definition https://pro.arcgis.com/en/pro-app/tool-reference/utility-networks/set-subnetwork-definition.htm   Lesson 5 - Tracing analysis Trace utility networks https://pro.arcgis.com/en/pro-app/help/data/utility-network/about-tracing-utility-networks.htm   Utility network trace types https://pro.arcgis.com/en/pro-app/help/data/utility-network/utility-network-trace-types.htm   Configure a trace https://pro.arcgis.com/en/pro-app/help/data/utility-network/configure-a-trace.htm   Lesson 6 - Network diagrams About network diagrams https://pro.arcgis.com/en/pro-app/help/data/utility-network/about-network-diagrams.htm   Enable dynamic diagram mode https://pro.arcgis.com/en/pro-app/help/data/utility-network/enable-dynamic-diagram-mode-to-refine-diagram-content-or-check-network-connectivity.htm   Manage the rules and layouts definition on your templates https://pro.arcgis.com/en/pro-app/help/data/utility-network/manage-the-rules-and-layouts-definition-on-your-templates.htm   Lesson 7 - Creating a utility network Create a utility network https://pro.arcgis.com/en/pro-app/help/data/utility-network/create-a-utility-network.htm   ArcGIS Solutions Deployment Add-In installation http://solutions.arcgis.com/water/help/water-utility-network-configuration/get-started/install-the-arcgis-solutions-deployment-add-in.htm#GUID-BBF70D5E-7BDF-4999-B259-3DA25991321D   Download the ArcGIS Solutions Deployment Tool http://appsforms.esri.com/products/download/index.cfm?fuseaction=download.main&downloadid=2006   An overview of the Utility Network Package Tools toolbox https://solutions.arcgis.com/utilities/help/utility-network-automation/tool-reference/an-overview-of-the-utility-network-package-tools-toolbox.htm   Install the Utility Network Package Tools toolbox http://solutions.arcgis.com/water/help/water-utility-network-configuration/get-started/install-the-utility-network-package-tools-toolbox.htm   Apply Asset Package http://solutions.arcgis.com/utilities/help/utility-network-automation/tool-reference/apply-asset-package.htm   ArcGIS Pro 2.2 and working with Python environments and packages https://community.esri.com/docs/DOC-12021-python-at-arcgispro-22   Utility Network Package Tools FAQ http://solutions.arcgis.com/utilities/help/utility-network-automation/get-started/frequently-asked-questions.htm#anchor2   Introduction to Industry Configurations for the Utility Network http://proceedings.esri.com/library/userconf/proc18/tech-workshops/tw_1705-350.pdf   Other topics Video - Utility Network Management in ArcGIS: Migrating Your Data to the Utility Network https://www.esri.com/videos/watch?videoid=HLQc0WHJiaw&title=Utility%20Network%20Management%20in%20ArcGIS%3A%20Migrating%20Your%20Data%20to%20the%20Utility%20Network   Video - Esri's Utility Network - Understanding the Impact and Planning the Journey Electric slant from a Pasadena example, from 2017 and some beta stuff Some great demos start at 18:25 in this video with containment and diagrams https://www.esri.com/videos/watch?videoid=7PQ-layk1EE&title=Esri%27s%C2%A0Utility%C2%A0Network%C2%A0-%C2%A0Understanding%C2%A0the%C2%A0Impact%C2%A0and%C2%A0Planning%C2%A0the%C2%A0Journey Insight into the ArcGIS Utility Network Management Extension Erik and Tom – Overview of the product from 2018 develop summit https://www.esri.com/videos/watch?videoid=GX-HhYjbHL4&title=Insight%20into%20the%20ArcGIS%20Utility%20Network%20Management%20Extension ... View more