Latest Contributions by HiteshJilka

‎10-03-2021

Update... I didn't find a direct solution, but I did find a workaround to get the selected map data. 1. Select features when time slider enabled for a particular date 2. Run tool "Table to Excel".. This tool when creating excel file will preserves GDB_ARCHIVE_OID which is unique for each record. 3. Join created excel data with Archive layer using OID field.

‎09-23-2021

Hello everyone, RDBMS: Oracle 12.1.0.2 ArcMAP: 10.8 I have archiving enabled on Enterprise GDB feature class and can see historical data using time slider. I would like to export history data showing on map for a particular date on time slider. Although the data updated date is different, but the time slider displays the cumulative records. I want to export those changes visible on map. I tried to select features from map, but in TOC, it shows extra records selected because Time Slider is hiding all other records. I tried export data for selected features and that exports all features and not based on what is shown on Time Slider. Another thing I noticed on Attribute table is that selected records count is same as of current map (data visible from Time Slider). This is what I want to export so I tried to export from Attribute table option thinking that later I can link it with Archive data but ARCHIVE OBJECTID is not preserved. Appreciate if anyone can help me to extract data based on time slider. Thanks

‎09-29-2020

hello, I have an oracle procedure which uses SDE ST Functions to get desired result. In SQLPLUS, we can directly refer ST functions without Package name but in PLSQL we need to specify package name or else it errors as explained in "Oracle Error PLS-00707 trying to compile a store procedure using a call to sde.st_intersects. " In SQLPLUS, When I use "sde.st_intersects" and INDEX hint for Domain Index, it is used by Optimizer BUT for PLSQL when I specify "sde.st_relation_operators.st_intersects_f " and INDEX hint, it is ignored by optimizer. below is my statement I am executing in PLSQL procedure. SELECT /*+ INDEX (a D_IX1) */ * FROM TABLE a WHERE sde.st_relation_operators.st_intersects_f (a.shape,(SELECT sde.st_geometry_operators.st_centroid_f(b.shape) FROM TABLE b WHERE condition) = 1; I would appreciate if anyone can help me with what changes can be done on above statement for INDEX to be used by optimizer in PLSQL. Thank you!

‎06-10-2020

I appreciate your feedback and i will go with Natural Neighbor because it fits with requirement to fill with linear change.

‎06-09-2020

Thank you so much for your valuable answer, it helped me to fulfill my requirement. But there are different tools for creating Interpolation surface.. IDW, SPLine, Natural Neighbor, Kriging, Which one is best suitable for my requirement ?. I tried all and found minor differences in results in each. Thanks again!

‎06-09-2020

Hello, I want to update ELEVATION data in GDB for all LAND parcels. Source data received as 2D DGN Annotation file and the Elevation values exist are at some random distance and not located on each Parcel (POLYGON) corner (vertex). Below steps I am trying to accomplish: 1. Create points from polygon vertex using Vertex to point tool. << Done! 2. Use NEAR tool to get nearest values to points and update Elevation attribute. << Done! 3. Measure and calculate missing Elevation data from aligned points (horizontal & vertical). << NEED HELP HERE!!! 4. Update POLYGON Z values with Attribute values from its vertex Points. << script is ready Attached image with requirement details: - Yellow Points (A and G) consist of Elevation values as Attribute, - Red Points (B to F) need to calculate Elevation values from Existing Yellow Points value difference (A and G) and increment it to Red points one by one .. - Values in red color below red points are real requirement to be calculated from neighbor Elevation data (Yellow Points). Manually calculated for your reference. Kindly let me know if there is any possibility to fulfill the requirements using some GP tools or scripts or using Fishnet. Thanks in advance!

‎07-02-2019

Yes it was because of arcpy logs geoprocessing history into GDB. You need to add either one of following line of code after "import arcpy" to turn off geoprocessing history.. arcpy.gp.logHistory = False OR arcpy.SetLogHistory(False)

‎11-30-2018

Thank you for helping in this query. In addition to this, I found that we can stop logging GP history into SDE_XML_DOC2 table by adding a line of code in standalone python script. I found it from thread "https://community.esri.com/thread/33846". arcpy.gp.logHistory = False

‎11-29-2018

Hello, RDBMS: Oracle 12c Parent Enterprise GDB : 10.3.1 Child Enterprise GDB : 10.4.1 Few weeks ago I raised a question related to standalone python script of synchronization which takes long time to complete but didnt received any solution on that. In addition to that, from database trace I found below statement taking more than 10 mins during synchronization process. --------------------------------------------------------------------------------------------------------------------------------------------------------------- UPDATE SDE.sde_xml_doc2 SET xml_doc = :xml_doc, doc_property = :doc_prop , xml_doc_val = :xml_doc_val WHERE SDE_XML_ID IN ( :xml_id1) --------------------------------------------------------------------------------------------------------------------------------------------------------------- When i saw the records in the "SDE.SDE_XML_DOC2" table, I found from one of column (XML_DOC_VAL) it stores logs for each synchronization process (runs as python script) and during synchronization it appends each day logs due to which the above statement takes longer than expected. It also stores XML_DOC in BLOB segment along with this. Few starting lines of column (XML_DOC_VAL) output from table "SDE.SDE_XML_DOC2" --------------------------------------------------------------------------------------------------------------------------------------------------------------- ; en ; 20171010 ; 07291500 ; 1.0 ; TRUE ; c:\program files (x86)\arcgis\desktop10.4\ArcToolbox\Toolboxes\Data Management Tools.tbx\SynchronizeChanges ; 20171010 ; 072915 ; SynchronizeChanges "Database Connections\gisdb_ARCDATA.sde" DTPS_KLDTPS_ARCDATA_ALL_FC_EXDATA "Database Connections\kldtps_ARCDATA.sde" BOTH_DIRECTIONS IN_FAVOR_OF_GDB1 BY_OBJECT DO_NOT_RECONCILE ; c:\program files (x86)\arcgis\desktop10.4\ArcToolbox\Toolboxes\Data Management Tools.tbx\SynchronizeChanges ; --------------------------------------------------------------------------------------------------------------------------------------------------------------- is there any possibility to do housekeeping for this table and other system tables relevant to Synchronize process to improve the performance. Thank you!

‎11-22-2018

Hello, Parent Enterprise GDB: 10.3.1 Child Enterprise GDB: 10.4.1 We have standalone python sync script which sync changes in both direction. We noticed that even for few changes the sync script takes more than 30 mins and if we sync in 1-Way direction, it takes appr 15 mins even if there are no any changes. But if we sync changes from ArcMAP (right click SDE connection --> Distributed geodatabase --> Synchronize changes), it takes less than 2 mins to complete (both 2-way and 1-way direction). As we are using Network license, I found from ESRI community that license might take some time to load but I tested and found it takes less than 30 seconds. Also, we have set "import arcpy" but result is same. Would anyone please help me on how we can speed up the process on standalone python script..

‎05-16-2018

Hello George, finally it has been resolved. There was an issue with configured Firewall, they reconfigured it and now ArcGIS and other applications are working fine.

‎05-01-2018

Hello George, from other client application also facing similar error, It has some firewall or network connectivity issue and not related to ArcGIS. I will inform concerned team to resolve the issue. Thank you!

‎04-30-2018

Hello George, thanks for looking into this matter. I am connecting using EzConnect. I tried changing SQLNET Authentication parameter at client and at server which is one of source for the error but it didn't help.

‎04-30-2018

Oracle DB: 12.1.0.2 ArcSDE : 10.4.1 We recently created a new database on new server which has firewall configured and only port opened is 1521 to connect to Oracle Database from source server. I am able to connect to database from SQL prompt from source server but while from ArcMAP 10.4.1 database connection, I am facing the error "ORA-12637 packet receive failed". For other DB on different servers, I am able to connect through ArcMAP from source server. For ArcMAP or ArcCatalog do we need some other ports to be opened for database connection? Thanks!

‎05-15-2017

Yeah I posted same query to get suggestion from other sources. I am working on relationship class between feature class and table. Created one to one composite relationship but now faced a new challenge. After adding a row to related table, I am still able to add extra rows to related table for the same feature. Attached snippet for Enabled option "Add New" even after existing of one row in one to one relationship. Any suggestion on how to prevent users from adding extra row?

Online Status	Offline
Date Last Visited	‎10-03-2021 11:31 PM

My Ideas

Latest Contributions by HiteshJilka

Re: Export selected Archive data when Time Slider is enabled

Export selected Archive data when Time Slider is enabled

Oracle optimizer ignores Index hint in PLSQL

Re: Calculate Elevation values from neighbor values

Re: Calculate Elevation values from neighbor values

Calculate Elevation values from neighbor values

Re: arcpy.SynchronizeChanges_management slow

Re: SDE_XML_DOC2 System Table Maintenance

SDE_XML_DOC2 System Table Maintenance

arcpy.SynchronizeChanges_management slow

Re: ORA-12637 packet receive failed

Re: ORA-12637 packet receive failed

Re: ORA-12637 packet receive failed

ORA-12637 packet receive failed

Re: share geometry shape between 2 feature class and have different attributes?

Re: SDE_XML_DOC2 System Table Maintenance

Re: arcpy.SynchronizeChanges_management slow