Latest Contributions by Kathleen_Crombez

I am running a tool in arcpy to remove a feature class from topology... arcpy.RemoveFeatureClassFromTopology_management(topo, fc) here is the error message... File "T:\ArcSDE\Fabric\FabricQC.py", line 274, in buildTopo     arcpy.RemoveFeatureClassFromTopology_management(topo, fc) File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\management.py", line 18028, in RemoveFeatureClassFromTopology     raise e ExecuteError: ERROR 999999: Error executing function. Cannot register as versioned on this database. Cannot register as versioned on this database. Failed to execute (RemoveFeatureClassFromTopology). umm... what does this tool have to do with registering as versioned? Does anyone have any experience with this error from this tool? How do I get around it? I am using ArcDesktop version 10.5.1 ... View more

We work in a versioned environment using SQL server back end. Whenever you 'register a table as versioned' a versioned view is created that sees everything the default version sees. These views in SQL Server will either have _VW or _evw at the end of the table name depending on the release of the ArcGIS Enterprise database. My question is why these views do not exist for the Parcel Fabric? Is there any way to perform a direct SQL Query on the default version without doing some sort of elaborate join with the business table and the add and delete tables? I am mostly concerned with the parcels table. I realize that a compress will update the business table. But it seems that some nights even though my reconcile, post, compress, index and analyze script runs without failure, the edits are not always visible in the business table the next morning. Thanks, Kathleen ... View more

I would like to be able to add a spatial view inside of a feature dataset using ArcCatalog tools. The only way to currently do this at version 10.5.1 is to alter the GDB_ITEMRELATIONSHIPS on the back end.   It seems this was possible at 9.3.1 and at 10.0 but is no longer possible now that the command line tools are gone. The new register view with the database command must be different than the old tools because you can no longer drag and drop the view to a feature dataset. ... View more

I have a quality control script that recreates features from a line work layer to ensure all our taxing districts are following the tax parcel boundaries. We have been running this script every year since version 10.0 We recently upgraded to 10.5 and ran into a scenario where the union tool was creating features (in a file geodatabase featureclass) that have a shape_length value but the shape_area was zero. These features are tiny slivers (usually on curves) that appear to be lines (but are really polygons). The script copies the fallout features from the union layer to a quality control featuredataset in SDE using arpy.da cursors (search and insert). where these areas are zero we started getting the following error: SystemError: error return without exception set running a quick test, I tried to use the getArea() method to put in an exception for areas equaling zero. layer = r"\\path\to\featureclass" with arcpy.da.SearchCursor(layer, ["SHAPE@"]) as cursor:    for row in cursor:       if row[0].getArea() == 0.0:          # do something what I ran into was sometimes it worked and sometimes it through an error: AttributeError: '_passthrough' object has no attribute 'getArea' so then I decided to just print row[0] and my results have mixed geometries... <arcpy.arcobjects.mixins._passthrough object at 0x1585D610> <geoprocessing describe geometry object object at 0x0297E0C0> <arcpy.arcobjects.mixins._passthrough object at 0x1585D610> <geoprocessing describe geometry object object at 0x0297E0C0> <arcpy.arcobjects.mixins._passthrough object at 0x1585D610> <geoprocessing describe geometry object object at 0x0297E0C0> what is this all about? I have never seen these arcpy.arcobjects.mixins._passthrough objects. can someone please explain the difference between these geometry types? and was this just introduced in version 10.5? Any insight would be helpful. Thanks, Kathleen ... View more