Latest Contributions by KyleGonterwitz

Arcmap has layer properties specific to Route Feature classes (with measures) allowing the layer to support hatching symbology and labeling, as well as ability to show where measures do not increase as described here: Displaying route measure anomalies—Help | ArcGIS for Desktop  The idea is to incorporate the same functionality into ArcGIS Pro. ... View more

Have you ever compared the speed of a Data Access cursor update vs using the field calculator?  Using data access cursors is a rite of passage for developers using python for ArcGIS, surely.  Write a few more lines of code to save some processing time.  Next thing you know, your python code is getting complicated.   A few years ago I started using pymssql with SQL Servers and cx_Oracle with Oracle Databases in my python scripts. In ArcGIS Pro now, looks like pymssql is getting antiquated, because Conda cant install it - it's not easy to install with a wheel and its less easy to get that wheel to work in the propy conda environment.    The ArcGIS Pro Conda package manager has no problem installing pyodbc so I set up a system DSN and used that to call sql scripts with Update TABLE set FIELD = Expression WHERE 1=1 within python scripts as a cursor. Arcpy also gives you ArcSDESQLExecute—ArcPy classes | ArcGIS Desktop  to execute native SQL commands using a Geodatabase connection rather than a DSN, so I will have to try that next time. Native SQL can make the da cursor look slow, it gives much more control over join types and integrity, and it can be done in less characters of code, easily, from a python script.   ... View more

I use an excel workbook to keep track of things, including actions or to-do's, my server names and specs, software billing to departments, projects and status, communication plans, registration of risks and issues, training plans, staff duties, projects plans and pretty much anything else that has to do with GIS management.  I even learned how to create GANTT charts in Excel from the internet.   Sometimes after a long weekend it helps to get right back to productivity.  It also helps me to plan ahead - I would not some bigger to-do items late in the afternoon or on a Friday, I'd work on clearing out smaller to-do items and maybe cleaning up my office/desktop and start the bigger tasks that require more focus on Monday or Tuesday morning on a week when my calendar is relatively clear. That's my method - I copied it from another successful project manager and it works well for me.  What's your method for keeping up with the to-do list at work?  ... View more

I want to add on to these implemented ideas:   Pop-up Arcade Expressions in ArcGIS Pro  Add Hyperlink with a variable to Pop-Up in ArcGIS Pro    and propose the SHAPE field of the feature class get added to the Arcade expression builder and GEOMETRY functions added to the expression builder to act on the SHAPE in a manner similar to python shape tokens.     The overall result of the idea is to be able to use the SHAPE field to display tokens that can be used to link to other systems by using the lat/long coordinates.     Additionally, some geometry functions specific to coordinate reference system conversions should be added to functions so that dynamic lat/long coordinates can be used in hyperlinks when features are projected. ... View more

When I share a pro package to arcgis online using the "Share" menu to share the project, I can share the contents of the ArcGIS Pro project including basemaps and web services (like aerial photo web services) just fine. When I use python to package and share a pro project, it cannot be packaged when any of the maps is using a web service.   I reported this as a bug, the python PackageProject_management function will not work with a non-basemap map service, such as valtus imagery or an editable feature service from ArcGIS server. To accommodate this script, those layers have been removed from the project.  I wasn't getting the message across to Esri support, I developed my python in pydev for eclipse which they latched on to as the problem because its "outside the pro python environment" or something like that - I do not think that is the issue.  The wanted me to run it in idle, and I didn't want to waste any more time on it at that time. So the question is, do you get the same results?   If so, would you say this is a bug that needs to be fixed at some point?  code snippet: ''' Created on Mar 7, 2018 share the designated ArcGIS Pro project to ArcGIS online https://pro.arcgis.com/en/pro-app/tool-reference/data-management/share-package.htm This tool may have limited use in a Python script outside of ArcGIS applications when sharing a package to a portal that uses OAUTH2 authentication. The ArcGIS Online for example, uses this authentication method. To authenticate, you must connect directly to the portal from the application. You will only be able to use this tool in a Python script if the application is open and connected to the portal, or you're connecting to a portal which uses traditional authentication mechanisms and allow the user name and password to be passed in. reporting a bug, the python PackageProject_management function will not work with a non-basemap map service, such as valtus imagery or an editable feature service from ArcGIS server.  To accomodate this script, those layers have been removed from the project. @author: kyleg '''    def ShareProToOnline(onlinepassword):     import datetime     startDateTime = datetime.datetime.now()     print ("this script takes about 8 minutes")     from arcpy import PackageProject_management, SharePackage_management, os, env     env.overwriteOutput = True     #import getpass     from KhubCode25.KhubCode25Config import localProProjectPath, localProProjectName, AGOUser     localproject = os.path.join(localProProjectPath,localProProjectName)     print(localproject)     print ("logging in as"+AGOUser)     try:         username = AGOUser         password = onlinepassword         fileformatDateStr = startDateTime.strftime("%Y%m%d")         summary = "This project contains maps that link to KDOT SQL Server databases AR58 gdb_prod, AR68 gdb_Dev, and a local file geodatabase copied from DT00ar58 gdb_prod for use on Amazon Servers or otherwise outside the KDOT network. The schema presentation matches the schema for the 1spatial extension.  For the local geodatabse copy, there is one map displaying highway symbols based on the source LRS network route prefix and direction, and another map displaying highway symbols based on the target network classification and direction"             PackageProject_management(localproject, r"C:\temp\KhubDataCleanup25_"+fileformatDateStr+".ppkx", "INTERNAL", "PROJECT_PACKAGE", "DEFAULT", "ALL", None, summary, "Khub", "CURRENT", "NO_TOOLBOXES", "NO_HISTORY_ITEMS", "READ_WRITE")         #SharePackage_management(SharePackage_management (localProProjectName, "KanDOT", password, summary, "Khub, 1spatial, Roads, Centerlines, LRS, Highways", "KANSAS DOT Restricted Use - 23 U.S.C. 409", "MYGROUPS", "Data Quality Assurance and Quality Control Group", "MYORGANIZATION"))         print("package created, now sharing")         SharePackage_management(r"C:\temp\KhubDataCleanup25_"+fileformatDateStr+".ppkx", username, password, summary, r"Khub,Project Package,ppkx,2D,ArcGIS Pro", "KDOT", "MYGROUPS", "Data Quality Assurance and Quality Control Group", "MYORGANIZATION")     except:         import getpass         username = "kyle.gonterwitz_KSDOT"         password = getpass.getpass("Enter Password for "+str(username)+":")         print("logging in as "+username )         #p = mp.ArcGISProject(localproject)         fileformatDateStr = startDateTime.strftime("%Y%m%d")         summary = "This project contains maps that link to KDOT SQL Server databases AR58 gdb_prod, AR68 gdb_Dev, and a local file geodatabase copied from DT00ar58 gdb_prod for use on Amazon Servers or otherwise outside the KDOT network. The schema presentation matches the schema for the 1spatial extension.  For the local geodatabse copy, there is one map displaying highway symbols based on the source LRS network route prefix and direction, and another map displaying highway symbols based on the target network classification and direction"             PackageProject_management(localproject, r"C:\temp\KhubDataCleanup25_"+fileformatDateStr+".ppkx", "INTERNAL", "PROJECT_PACKAGE", "DEFAULT", "ALL", None, summary, "Khub", "CURRENT", "NO_TOOLBOXES", "NO_HISTORY_ITEMS", "READ_WRITE")         #SharePackage_management(SharePackage_management (localProProjectName, "KanDOT", password, summary, "Khub, 1spatial, Roads, Centerlines, LRS, Highways", "KANSAS DOT Restricted Use - 23 U.S.C. 409", "MYGROUPS", "Data Quality Assurance and Quality Control Group", "MYORGANIZATION"))         print("package created, now sharing")         SharePackage_management(r"C:\temp\KhubDataCleanup25_"+fileformatDateStr+".ppkx", username, password, summary, r"Khub,Project Package,ppkx,2D,ArcGIS Pro", "KDOT", "MYGROUPS", "Data Quality Assurance and Quality Control Group", "MYORGANIZATION") def main():     ShareProToOnline()     if __name__ == '__main__':     import datetime     startDateTime = datetime.datetime.now()     main()     print('project packaged and shared in {} hours, minutes, seconds.'.format(datetime.datetime.now()-startDateTime)) else:     print("functions from KhubShareProProject imported to main script")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more