Latest Contributions by leomonterol

Hello Shlesha, Can you provide me with a copy of your code or at least a code snippet showing how your UtilityNetworkValidateTopology widget is being initialized so I can take a look at it? Kind Regards, Leo ... View more

Hello Shlesha, Here's a link to a sample app showing how to use the Validate Network Topology widget using ArcGIS Maps SDK for JavaScript 4.27 (Credentials to access the app can be found inline).  https://codepen.io/lmontero_esri/pen/poQwwPP Even if your map already has a Utility Network, you need to explicitly set it in the widget's "utilityNetwork" property as shown below   // Initialize the custom widget and set its properties using the constructor const vntWidget = new UtilityNetworkValidateTopology({ view: myView, utilityNetwork: myUtilityNetwork });   To answer your questions: 1. To use the Validate Network Topology widget, you need to add the dirty areas layer as a FeatureLayer (The sample app shows how to do it. Hint: Look for the "addDirtyAreasLayer" function). Here's a link to the SDK documentation showing how to create a featureLayer from a feature service URL. https://developers.arcgis.com/javascript/latest/api-reference/esri-layers-FeatureLayer.html#constructors-summary 2. Here's a great answer I found in a page created by the Technical Support team (originally posted here) "A map service does not expose the editing capability and provides read-only access to feature and attribute content, while a feature service contains the information from feature layers that can be edited if editing is enabled. Clients can query and edit the feature geometry and attributes of a feature service." On the SDK side of things, the layer you choose dictates which capabilities will be available. Here's a link to a document showing info on data storage and capabilities for some layer classes. https://developers.arcgis.com/javascript/latest/layers/ I hope you find this information useful. Kind Regards, Leo ... View more

Hi Jose, You can use the X-Ray add-in for ArcCatalog. This add-in provides the functionality to reorder fields in a Feature Class. Regards, Leo ... View more

From ArcSDE Configuration and Tuning Guide for Oracle: "ESRI recommends that you create your indexes with NOLOGGING. Doing so will avoid logging the changes made to the indexes in the Oracle redo log files. Although the index cannot be recovered from the archive log in the event that you should lose the data file the index is stored in, you can easily re-create the index using the ALTER INDEX <index_name> REBUILD command. Therefore, ESRI believes that the ease at which an index may be regenerated outweighs the need to log the changes in the event of a disk failure." Since this is just a recommendation, if you don't see any significant impact on the Geodatabase's performance by setting the parameter to LOGGING (You may want to give this a try on a testing environment) and your redo log can accommodate that information, I believe you can do so. Regards, Leo ... View more

Hi Elias Thank you for sending that information. Just to confirm. Is that a SQL Server 2012 with no Service Pack? If yes, this may be a version compatibility issue. I've seen this behavior before and it is solved by upgrading the DBMS to a supported version.  If you are using an ArcGIS Desktop 10.7 client, the earliest version of SQL Server you can connect to is Microsoft SQL Server 2014 SP3 (64-bit). See all SQL Server supported versions for ArcGIS Desktop 10.7 here.   If you are using an ArcGIS Desktop 10.6.x client, the earliest version of SQL Server you can connect to is Microsoft SQL Server 2012 SP3 (64-bit). See all SQL Server supported versions for ArcGIS Desktop 10.6.x here.   Regards, Leo ... View more

Hi Elias What version of ArcGIS Desktop and SQL Server are you working with? Regards, Leo ... View more

Hi Doug Please try Micah's suggestion (place print statement before arcpy.AddField_management) to see the properties (name, type, length) of the field you're trying to add. Regards, Leo ... View more

Hi Doug Try this: shp01 = r'C:\tmp\New_Shapefile01.shp' shp02 = r'C:\tmp\New_Shapefile02.shp' fieldsShp01 = arcpy.ListFields(shp01) fieldsShp02 = arcpy.ListFields(shp02) newFields = [] for field01 in fieldsShp01: exists = False for field02 in fieldsShp02: if (field01.name == field02.name and field01.type == field02.type and field01.length == field02.length): exists = True # print("The {0} field with a type of {1} and a length of {2} exists in both shapefiles" # .format(field01.name, field01.type, field01.length)) if (exists == False): # print("The {0} field with a type of {1} and a length of {2} exists only in shp 01" # .format(field01.name, field01.type, field01.length)) newFields.append([field01.name, field01.type, field01.length]) for field in newFields: arcpy.AddField_management(shp02, field[0], field[1], "", "", field[2], "", "NON_NULLABLE","NON_REQUIRED","") print("The {0} field with a type of {1} and a length of {2} was added to shp 02" .format(field[0], field[1], field[2]))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ For documentation on the Add Field tool you can navigate here. Regards, Leo ... View more

Hi Jose You can use the script below in ArcCatalog's python window (Change fcName and pathToSDEConnectionFile) # Feature Class Name (E.g. TestDB.DBO.TestPolygonFeatureClass) fcName = 'TestGDB.DBO.TestPolygonFeatureClass' # Path to the sde connection file pathToSDEConnectionFile = r'C:\tmp\sdeConnections\localhost.sde' arcpy.env.workspace = pathToSDEConnectionFile datasets = arcpy.ListDatasets(feature_type='feature') datasets = [''] + datasets if datasets is not None else [] for ds in datasets: for fc in arcpy.ListFeatureClasses(feature_dataset=ds): if ( fc.upper() == fcName.upper()): print('Feature Class ' + fc + ' found in ' + ds + ' Dataset')‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Regards, Leo ... View more

Hi Jose Since you're already working with a Geodatabase, I'd probably suggest the first approach. This way every change made in the Feature class will be seen in the view. Also, with the second approach you will need to run the script every now and then to keep the table updated. ... View more

Be aware that user schema Geodatabase creation will be deprecated.  See the full document in the link below   http://downloads.esri.com/Support/downloads/other_/DEPRECATED%20FEATURES%20PLAN%20FOR%20ARCGIS%2010.7%20and%20ArcGIS%20Runtime%20SDK%20100.x%20Year%20Year%202018%20Final%20v1%2001082019.pdf ... View more

Actually, you can query the data using SQL (you must query the Feature Class' versioned view). Using this method you can even query a specific Geodatabase version. See links below: Oracle http://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/edit-versioned-data-using-sql-oracle.htm SQL Server http://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/edit-versioned-data-using-sql-sqlserver.htm ... View more