Latest Contributions by Thiru_P

Dear community, I have a weird issue and would appreciate your help if you can test and report if it occurs for you. I would need to find the ArcSDE, Portal Enterprise version where this does not occur. Setup: 10.7.1 ArcSDE PostgreSQL 11.16 + PostGIS 2.5.5 ArcGIS Enterprise Portal versions tested 10.7.1 and 10.9.1 ArcGIS Pro versions tested 2.7.3, 2.9.5 / 3.0.3 Background: Some of our editors who have been doing editing using editable feature services with version management reported they lost edits especially after using the Polygon Split tool. So, after lots of testing, we have narrowed down to this potential bug. Steps to reproduce the potential bug: Choose an Editable Feature Service from ArcGIS Enterprise Portal published from a Branch-versioned dataset. Switch to a user-created version  (not DEFAULT version) and start your edit session. Keep the attribute table open to observe record counts. Do not save the edits until you reach Step 5.  Step 1 - Perform one edit action - creating a new polygon or reshaping a polygon or splitting a polygon Step 2 - Select a polygon and select the Split tool . Step 3 - Make an invalid split action (e.g, draw the split line totally outside the selected polygon or draw the split line half way through the selected polygon and finish it) forcing ArcGIS Pro to show an error message.   Once the ArcGIS Pro throws an error, abort this split. Step 4 - Next, make one or more valid split actions. Step 5 – Note down the number of features with the attribute table. Save all edits. Step 6 – Switch to DEFAULT version and switch back to the user-created version. Observe the edit that you made just before the split error (Step 1 edit) has been Undone/Missing. The workaround is to remember to save after every edit action or turn on Auto-Save after every edit action. Of course, you lose the ability to Undo in case if you would need to go back. Thanks, Thiru ... View more

Hi all, TLDR; how do you create a list of data sets that lists everything in an enterprise geodatabase, schemawise?   I would like to generate a list of all the data sets (e.g, relationship classes, tables, feature classes, including the feature classes within Feature Datasets) in an enterprise database in each schema (.sde connection file) periodically. I have used the arcpy.da.Walk module with keyword "Any" and with each datatype mentioned; no success yet. Software used: Python 3.7.11 PostgresSQL 11.16 PostGIS 2.4.5 ArcSDE Geodatabase 10.7.1 This is the code that I tried so far.     # -*- coding: utf-8 -*- """ Lists the contents of Cloud Enterprise DataBase (CEDB) and writes into an MS Excel Sorts in an alphabetical ascending order Created on 09 May 2021 Last update 24 Nov 2022 @author: thiru """ #List the contents of CEDB UAT #import modules import arcpy import pandas as pd import re import openpyxl #assign maximum processing power arcpy.env.parallelProcessingFactor = "100%" ###List the folder where the sde connection files are sdeDir = r"C:/SDE/" ##CEDB schemas as sde connection files workspaceList = [ "alpha@cedb(uat).sde", "beta@cedb(uat).sde", "gamma@cedb(uat).sde", "theta@cedb(uat).sde" ] vardatatype = [ 'CadDrawing', 'CadastralFabric', 'Container', 'FeatureDataset', 'FeatureClass', 'GeometricNetwork', 'LasDataset', 'Layer', 'Locator', 'Map', 'MosaicDataset', 'NetworkDataset', 'PlanarGraph', 'RasterCatalog', 'RasterDataset', 'RelationshipClass', 'RepresentationClass', 'Style', 'Table', 'Terrain', 'Text', 'Tin', 'Tool', 'Toolbox', 'Topology' ] #create empty sets, this will remove duplicates files = [] schemas = [] #iterate through each schema and list contents for ws in workspaceList: workspace = sdeDir + ws da_owner= ws[:ws.index("@")] print (workspace) schemas.append(workspace) for dt in vardatatype: walk = arcpy.da.Walk(workspace, datatype=[dt]) for dirpath, dirnames, filenames in walk: for filename in filenames: filename.lower() filename = filename+"."+dt files.append(filename) print(filename) df = pd.DataFrame(files) print("Number of features", len(files)) print("Number of schemas", len(schemas)) #Check if dataframe is empty if df.empty: print('List is empty!') else: # dropping null value columns to avoid errors df.dropna(inplace = True) #Name the column name df.columns = ['LayerName'] df[['DbName', 'SchemaName', 'Layer', 'DataType']] = df['LayerName'].str.split('.', expand=True) #Remove the redundant column df = df.drop(columns=['LayerName']) #Sort the columns based on Schema, LayerName df.sort_values(by=['SchemaName', 'Layer'], ascending=(True, True), inplace=True, ignore_index=True) df.to_excel(r"C:/Temp/Lists/CEDB_alltypes_Listing.xlsx", index = False)           ... View more

Hi, We have published a web map from 10.41 ArcGIS Server (Oracle) for public use. When the service fails to load, users get an error message that shows the entire path to the Map Service Definition file is presented to  the user. Is there a way we can hide the file path in full or partial? This is the service Layer: Protected plants trigger map (ID: 201)  and below is the error message with filepath highlighted: dojo.js:310 [esri.layers.MapImageLayer] #load() Failed to load layer (title: 'Vegetation management', id: 'vma') e {name: "request:server", message: "Error handling service request :0x80070057 -  Can … inaccessible to Server. in 'esriCarto.MapServer'", details: {…}}details: {url: "https://gisservices.information.qld.gov.au/arcgis/rest/services/Biota/VegetationManagement/MapServer", requestOptions: {…}, getHeader: ƒ, httpStatus: 500, subCode: undefined, …}message: "Error handling service request :0x80070057 -  Can not open file F:\FAKESERVER-fs\arcgisserver1\directories\arcgissystem\arcgisinput\Biota/VegetationManagement.MapServer\extracted\v101\VegetationManagement.updated.msd. ↵ The system cannot find the file specified. ↵ Probable cause: The file is inaccessible to Server. in 'esriCarto.MapServer'"name: "request:server"__proto__: f Thanks in advance. Regards, Thiru ... View more

Dear Python experts, Using Python and cx_Oracle, I would like to query an Oracle SDE table (50 columns) and write the resulting data rows into a non-spatial File GDB feature class. Eventually, I will use this feature class and UpdateCursor  to update custom fields in a mosaic dataset.  Is there a way I can convert the SQL query directly into a File GDB feature class? Trying the numpy method (field mapping the 50 columns is going to be fun!) , I converted the query results to a numpy array and then wrote them to a feature class but the date fields get converted to datetime fields. I need dates only and I want to get it right before I proceed further. Here's the code I have so far: import arcpy import numpy as np import cx_Oracle out_tbl = r'C:\Temp\work.gdb\img_source_qry' connstr='username/password@port/service' con = cx_Oracle.connect(connstr) curs = con.cursor() sqlQry = """ SELECT n_frame, t_available, d_flying FROM db.table where ROWNUM < 10 """ curs.execute(sqlQry) datArray = [] cxRows = curs.fetchall() for cxRow in cxRows:     datArray.append(cxRow) # delete output feature class if it exists if arcpy.Exists(out_tbl):     arcpy.Delete_management(out_tbl) #define array and write fc numpyarr_out = np.array(datArray, np.dtype([('Frame','<f8'), ('Available', 'S2'), ('Date_Fly', 'M8[us]')])) arcpy.da.NumPyArrayToTable(numpyarr_out, out_tbl) #close the connections curs.close() del cxRows, curs print datArray con.close() ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ This is the output, I am getting Appreciate your advice. Thanks! ... View more