Latest Contributions by VinceAngelo

Yes, ArcMap 10.4.1 (32-bit ArcPy), in fact (and don't call me Shirley ) - V ... View more

An Enterprise geodatabase can only be configured without Esri SDE.ST_Geometry support when using RDS (Amazon PostgreSQL Database-as-a-Service).  If you just want PG-based support Query Layers (without any geodatabase functionality) then you don't need to create the sde login/schema or run Enable Enterprise Geodatabase. - V ... View more

I have to point out that shapefiles are not an acceptable substitute for users with numeric NULLs, fieldnames longer than 10 characters, UTF-16 strings, strings exceeding 254 charcters, BLOB data, datetime fields with higher than day resolution, topologies, feature datasets, domains,....  Establishing correct spatial reference metadata can sometimes be a challenge, but getting the values right is much easier than trying to get by with a data format, created in the early 1990s, which lacks so many modern features. - V ... View more

This is a different question, but no, there isn't a function to make arbitrary text into integer.  It is, however, simple to use a dictionary to assign an numeric lookup value for text values if you create a dictionary that performs the encoding for you: lookup1 = { 'Yes' : 1, 'No' : 0, 'DEFAULT' : -1 } for txt in ['Yes','No','YES','NO','Maybe']: alt = -1 if (txt in lookup1): alt = lookup1[txt] #else: # alt = lookup['DEFAULT'] print("{:>10s} : {:d}".format(txt,alt))‍‍‍‍‍‍‍‍‍ ... View more

You're using 'row' twice, for different objects. This cannot result in success. You're also attempting to use setValue on an array, which is wrong (DA cursors are very different creatures the the old , deprecated cursors) The canonical approach to this problem is to read the CVS once, into a dictionary by key column, then to loop the update cursor once, consulting the dictionary. Double-nested looping with cursors is exceeding slow, and should be avoided. - V ... View more

I have no advice for working with IWA. I suggest you ask a new question, with details of the steps you are using and the error you have received. - V ... View more

GetCount returns a result array, not a count.  You need to retrieve the first element of that result array. EIGAfeature_count = arcpy.GetCount_management(lyr)[0] or if EIGAfeature_count[0] > 0: - V ... View more

Updating Desktop itself is simple enough, but if you have any enterprise geodatabases stuck back at 10.1 the migration path is more convoluted (partially because many of the databases supported back at 10.1 are not supported in modern software). - V ... View more

Actually, ArcGIS Union splits polygons based on overlap from different layers.  The Dissolve command is used to merge geometries.  Unless you're using Python, in which case the Geometry.union() method is used to merge individual shapes. ... View more

Yes, of course multi-part polygons are supported by both Desktop and Server.  However, the geometries must be properly constructed to conform to topology rules: Any polygon (exterior ring) may contain one or more "holes" (interior rings) Multi-part polygons are composed of multiple exterior rings (which may contain interior rings) Interior rings may not exist outside the exterior ring to which they belong, and may not touch the exterior ring for greater than one vertex at a time (the geometry library will automatically repair "inversions" to the exterior ring) Exterior rings may not overlap or touch each other at more than one point. The Dissolve command is often the easiest way to merge multiple rows of polygon data into a single geometry in a new feature class. Though if you're comfortable with arcpy, then you can use the Geometry.union(other) method to merge individual shapes in memory. Once the geometry is constructed, it can be populated in a table and manipulated using SQL. You can also use SQL to union shapes, but there can be subtle differences in the geometry models which may result in invalid geometries. - V ... View more

On some (most?) databases, uppercase schema names are not permitted at all. - V ... View more

ANY write operation, if it fails, can corrupt a file geodatabase. Actual media failure is more likely the cause, especially when the FGDB is on a networked device. The instruction to rebuild the index after a high volume of inserts is more likely to prevent fragmentation in the index, not related to corruption. - V ... View more

Please place your code in the body of the question. Many will not download and unzip documents for computer security reasons, so you're shutting yourself out from assistance.  Be sure to specify what you are attempting to accomplish and what your actual result is, especially any errors (as text, not as an image) - V ... View more

Please remember to post code as ASCII text (formatted appropriately), so that those who would help you don't need to retype your code. - V ... View more