Latest Contributions by ChristianWells

Hi Pramod, Can you provide an XML schema dump of your feature class or a list of steps how you created the feature class? Also, do you have any patches on your ArcGIS 10.2.1 client? Thanks, Christian ... View more

Hi Gyeyoung, I can reproduce this in SQL Server but not Oracle. Any chance you can open a support ticket with Esri, so we can look into this issue further? I can help you out with this part if you send me a direct message. Thanks, Christian ... View more

Hi Chris, Unfortunately, Esri does not supported the GeometryCollection type yet: SQL Server data types supported in ArcGIS—Help | ArcGIS for Desktop ArcGIS does not support the following geometry subtypes: CircularString CompoundCurve CurvePolygon GeometryCollection ... View more

Can you please post the SQL query and DBMS you are using? I found the same error when running STAsText() from SQL Server. One option to work around this may be to turn your query into a Query layer and utilize the SearchCursor to loop through the rows. ... View more

Thanks Yves, with that response, I don't have anything to add to my statements above. I would mention that equivalent to creating a polygon in ArcCatalog would be "nac+" ... View more

Hi Yves, It sounds like in your DEV environment the data owner is AGRMGXD1, however, after the export you want to change the owner to AGRMGXL1 in the SDE repository tables. If the above is correct, editing the repository tables to change the owner of each table would not only be very difficult but also unsupported. The following tables, at minimum*, would need to be updated if you were going to change the owner: GDB_ITEMS COLUMN_REGISTRY GEOMETRY_COLUMNS LAYERS TABLE_REGISTRY *Depending on your environment, there may be other references to these objects some where else. However, the most difficult part of changing the owner is that you would need to update the XML Definition and Documentation for every feature class. This data can be read using the SDEXMLTOTEXT function, however, you won't be able to update these XMLs because they are stored as BLOBs. The only way I could see something like this working is if the the objects from "SIGMAI" was a perfect, identical match to "SIGMAD", with the exception of the owner. If that was the case, it may have been possible to retain the SDE schema in SIGMAI and during the datapump (IMPDP) operation, use the remap schemas flag. Another possible workflow would be to create an empty geodatabase on SIGMAI and then only import the AGRMGXD1 schema using the remap_schemas flag to change it to  AGRMGXL1. Once this datapump is done, register all the objects with the geodatabase, using the Register with Geodatabase tool, which is easily scripted in Python. EDIT: At the end of the day, the best, least stressful, and supported way to accomplish this it to either leave the schema owner name as AGRMGXD1 or export all the data via ArcGIS (sdexport/sdeimport, ArcCatalog/ArcMap, ArcPy, etc) ... View more

Thanks for checking Rachel. I am glad renaming allowed for the data to be displayed. It may be due to 'open' being a reserved keyword in SQL Server. Reserved Keywords (Transact-SQL) https://msdn.microsoft.com/en-us/library/ms189822.aspx I am going to test on my end as well to verify if its due to the keyword. ... View more

Hi Ivan, Where is your data stored? File geodatabase, personal geodatabase, shapefile, SDE? ... View more

Hi Jerry, It looks like this issue (or something similar) may be documented as a bug. BUG-000089019 - When running the ?Run Manual Change rules for sele.. Can you confirm which version of Attribute Assistant you have installed? This should be available from the Add-in Manager window. ... View more

Hi Edward, It looks like this error may be due to line 28 still referencing the row object from the arcpy.da.SearchCursor(). I was able to reproduce the same behavior. However, if I change the script to the following, the issue goes away. # Create the search cursor to iterate through table and sum spans and cost with arcpy.da.SearchCursor(fcdtest, ("FeedClass","SHAPE_Length","MGMTCOST",)) as cursor:     for row in cursor:         if row[0] == "ARS":             ARSSPAN += row[1]/55             ARSCOST += row[2]         elif row[0] == "ST":             STSPAN += row[1]/55             STCOST += row[2]         elif row[0] == "S":             SSPAN += row[1]/55             SCOST += row[2]         elif row[0] == "ARU":             ARUSPAN += row[1]/55             ARUCOST += row[2]         elif row[0] == "UT":             UTSPAN += row[1]/55             UTCOST += row[2]         elif row[0] == "U":             USPAN += row[1]/55             UCOST += row[2] fld = "YR2015" feedcls = ["ARS","ST","S","ARU","UT","U"] for cls in feedcls:     with arcpy.da.UpdateCursor(out_data, (fld,)) as cursor:         for row in cursor:             row[0] = cls + 'SPAN'             cursor.updateRow(row) ... View more

Hi Michelle, Does the sample I provided work for you in SQL Server Management Studio? If you want to share your data as a csv or dbf file, I can take a look at it. Christian ... View more