POST
|
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.
... View more
10-03-2021
10:00 PM
|
0
|
0
|
864
|
POST
|
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
... View more
09-23-2021
12:02 AM
|
0
|
1
|
920
|
POST
|
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!
... View more
09-29-2020
12:37 AM
|
0
|
1
|
721
|
POST
|
I appreciate your feedback and i will go with Natural Neighbor because it fits with requirement to fill with linear change.
... View more
06-10-2020
07:16 AM
|
0
|
0
|
1636
|
POST
|
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!
... View more
06-09-2020
08:47 PM
|
0
|
2
|
1636
|
POST
|
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!
... View more
06-09-2020
03:09 AM
|
0
|
4
|
1768
|
POST
|
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)
... View more
07-02-2019
08:32 PM
|
2
|
1
|
1453
|
POST
|
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
... View more
11-30-2018
01:42 AM
|
1
|
0
|
1197
|
POST
|
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!
... View more
11-29-2018
01:31 AM
|
0
|
2
|
1483
|
POST
|
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..
... View more
11-22-2018
02:12 AM
|
0
|
3
|
1822
|
POST
|
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.
... View more
05-16-2018
11:23 PM
|
0
|
0
|
15423
|
POST
|
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!
... View more
05-01-2018
03:39 AM
|
0
|
2
|
15423
|
POST
|
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.
... View more
04-30-2018
06:21 AM
|
0
|
4
|
15423
|
POST
|
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!
... View more
04-30-2018
03:19 AM
|
0
|
6
|
21358
|
POST
|
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?
... View more
05-15-2017
11:55 PM
|
0
|
1
|
984
|
Title | Kudos | Posted |
---|---|---|
1 | 11-30-2018 01:42 AM | |
2 | 07-02-2019 08:32 PM |
Online Status |
Offline
|
Date Last Visited |
09-09-2024
11:19 AM
|