Latest Contributions by ChristianWells

Hi Anthony, it sounds like you have both ArcMap and the 64-bit background Geoprocessing patch installed. If my assumption is correct you have both 32-bit and 64-bit Python already installed. It may just take some coding updates to call the 32-bit libraries.  Here is a very good source of information about identifying and calling the right Python bit level:  https://community.esri.com/groups/technical-support/blog/2013/07/29/64-bit-vs-32-bit-python-explained/  The article below explains how you can call 32-bit directly: https://support.esri.com/en/technical-article/000011711 Note: it says Server and Desktop but the same rationale should apply here ... View more

Hi Todd, we're happy to help you out getting started, I left some questions below to start with: Do you have a specific project or goal in mind using Collector for ArcGIS? Will you be using Collector with ArcGIS Online or ArcGIS Enterprise? Are you using Collector by yourself or are you preparing a team of people to use Collector in your organization? What type of data are you planning to capture? Do you plan to capture new features, edit existing features, or both? Some helpful content to get started with: Field Data Collection using ArcGIS (Web Course) Make your first Collector map (Tutorial) ... View more

From your description, it sounds like the client to server distance may be the primary factor. How far is the data center relative to your client machines? A set of tools to get you started would be an SDEIntercept (client-side) and SQL Server Trace (server-side). SDEIntercept https://support.esri.com/en/technical-article/000014807 SQL Server Extended Events https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/quick-start-extended-events-in-sql-server?view=sql-server-2017 Here is a good resource to get started understanding performance within the context of the SDEIntercept: https://support.esri.com/en/technical-article/000010355 ... View more

If you have the original data, the Check Geometry tool should offer some more details on the specifics of each feature flagged, which would be captured in an output table when the tool runs. We built a reference document that explains the value of the output table here: https://pro.arcgis.com/en/pro-app/tool-reference/data-management/check-geometry.htm To your question on necessity: When geometry data has non-simple features or topological errors, it can create unexpected behavior or errors in geographical software when viewing, analyzing, or editing data.  With that said, non-simple features may not need a fix to work with ArcGIS or other software. However, the tool is used to make features topologically valid under OGC or Esri standards, which helps to ensure high-quality spatial data which can be read by software using these standards thereby reducing the potential for geometry issues to arise later.  ... View more

That helps to clarify, however, I don't know of a way to make it automatically update domain without running a script to check for new values and update the domain as needed. Once the 'Table to Domain' tool is ran, the Geodatabase stores the values as metadata and is no longer connected to the original table/feature class used to create the domain.  If you're looking for an automated method, one way could be to set up a Python file through Windows Task Scheduler. You could have it run during off hours to avoid creating Geodatabase locks. Here's a breakdown of how you could do this via Python: Connect to the Geodatabase and query the domain using the 'Domain to Table' tool Domain To Table—Data Management toolbox | ArcGIS Desktop  Find all of the current values in the domain and store as a Python list or iterate through the rows SearchCursor—Help | ArcGIS Desktop  Connect to the polyline table and query the field used by the domain Find all of the current values in the field and store as a Python list SearchCursor—Help | ArcGIS Desktop  Compare the lists via Python and find the new values from the polyline Use the appropriate (Coded Value vs Range) geoprocessing tool to update the domain values Add Coded Value To Domain—Data Management toolbox | ArcGIS Desktop  Set Value For Range Domain—Data Management toolbox | ArcGIS Desktop  I hope you find this helpful. ... View more

Charles Quadrini‌ this should be possible through the field settings if you are looking for the fields to automatically populate upon creation. Associating default values and domains with tables and feature classes—ArcGIS Help | ArcGIS Desktop  After re-reading your question, I wasn't sure if you are looking for the field to be updated automatically or the domain list to be updated automatically? ... View more

So if we are sending this to Oracle and we need to change the string to a time field, then CONVERT cannot be used.  Instead for Oracle, we must use CAST or a TO_TIMESTAMP function.  Can you clarify what "time" and "actiondttime" datatypes are in Oracle? In addition, which field are you attempting to convert, time or actiondttime? ... View more

Hi Geoffrey, what is your goal of the convert? Your inputs look like your inputting two field names, based on the SQL above. Oracle uses convert character strings from one character set to another.  CONVERT  ... View more

If you print ticket_sql with the formatted text, does that SQL run in Oracle? I've noticed this error happening on occasion when there is an error in the text string.  ... View more

What table are you editing via ArcSDESQLExecute? The base table or the versioned view? If you are editing the versioned view, are you setting a version prior? ... View more

Have you tried created the GIS object without the username or password? The doc here for IWA points to not using a username or password: Working with different authentication schemes | ArcGIS for Developers  It looks like there are some additional requirements for using IWA and the ArcGIS Python API: "If your portal is configured to pick up your Windows credeintials using NTLM or Kerberos, you can omit passing in the username and password. The ArcGIS Python API is able to figure out when the GIS is using Windows authentication and picks the login credentials from the currently running process providing a seamless and secure login experience. Windows authentication only works on the Windows OS and requires pywin32 and kerberos-sspi python packages." ... View more

Another option would be ArcGIS Pro, which would install side-by-side with ArcGIS Desktop and comes with Python 3.4 Also, is there anything preventing you from using urllib or urllib2 as native modules for http/s requests? ... View more

Some additional notes to your comments on: "including arcpy scripts for redeploying server instances, publishing services, ingesting data to RDBMS" Publishing Services: Assuming you are using REST to publish and manage services to ArcGIS GIS Server, your workflows would still need to be done via arcpy.  ArcGIS Python API only supports publishing services to Portal for ArcGIS or ArcGIS Online publishing SDs shapefiles and CSVs | ArcGIS for Developers  publishing web maps and web scenes | ArcGIS for Developers  Redeploying Server Instances: If you are referring to managing services or perform administrative processes of ArcGIS GIS Server, that functionality does not exist in the ArcGIS Python API The main use of the ArcGIS Python API is for Portal for ArcGIS and ArcGIS Online  Ingesting Data to RDBMS: ArcGIS Python API has no DBMS capabilities ... View more

Hi Jay, just to clarify the standard arcpy site package shipped with ArcGIS Desktop and ArcGIS Enterprise is unrelated to the ArcGIS Python API.  The arcpy site package still holds its purpose in both Python 2 (ArcGIS Desktop/Enterprise) and Python 3 (ArcGIS Pro) for mapping, data management, analysis, etc.  The ArcGIS Python API, however, is designed for web GIS such ArcGIS Online/Portal for ArcGIS administration, analysis, content creation, etc.  ArcGIS API for Python | ArcGIS for Developers  "The ArcGIS Python API lets ArcGIS Online and ArcGIS Enterprise users, analysts, developers and administrators script and automate tasks ranging from performing big data analysis to content management and administration of their web GIS. The API integrates well with the Jupyter Notebook and the SciPy stack and enables academics, data scientists, and GIS analysts to share programs and reproducible research with others" Simply put: arcpy is for Desktop GIS application ArcGIS Python API is for Web GIS application ... View more

Two simple workarounds that you could try: 1. Create a query layer and use and alias for the field name: select reallyreallyreallylongfieldname as shorterfieldname from table Creating a query layer—Help | ArcGIS for Desktop  2. Create a view in the DBMS and consume the view in ArcMap: Create view table_vw as select reallyreallyreallylongfieldname as shorterfieldname from table ... View more