POST
|
Hi, I am trying to read from one source and insert into SDE using Arcpy with cx_oracle. I am able to insert lines using sde.st_linestring if the string length is lessthan 4000. i got the same error as the string is too long. Did you solve the issue? Regards Kumar
... View more
02-22-2020
11:52 AM
|
0
|
1
|
4007
|
POST
|
Hi, I am trying to update the polyline layer using cx_oracle in python script. i read the feature details from another layer as sde.stastext and convert it as a below format string. When i insert the string value as bind value using sde.stgeomerty com ['LINESTRING ( 9291551.34660000 4187266.23730000, 9291554.47640000 4187256.33170000, 9291591.01820000 4187201.97960000, 9291608.79190000 4187176.35690000, 9291662.02290000 4187099.15550000, 9291816.12480000 4187073.98510000, 9291848.38680000 4187068.90750000, 9291884.79440000 4187062.83460000, 9291887.57330000 4187079.48540000, 9292095.47260000 4187047.47530000, 9292097.25390000 4187058.05110000)', u'S-16059'] then I inserted using the following sql statement and got the error. insert into SUGGESTION_LINE ( shape,SUGGESTION_ID, objectid) values ( sde.st_geometry(:1,3),:2,:3,sde.gdb_util.next_rowid('gis','SUGGESTION_LINE')) Error: DatabaseError: ORA-01461: can bind a LONG value only for insert into a LONG column but the same script worked fine with point layers. Thank you for your help
... View more
12-09-2019
03:29 AM
|
0
|
1
|
956
|
POST
|
yes. we compared the two databases and performed the trace. the query calls the extproc for each record which decreases the performance.
... View more
10-01-2019
05:39 AM
|
0
|
1
|
643
|
POST
|
Hi, We recently migrated arcsde 10.6.1 on oracle 11g to oracle 12c on #exadata. Exadata outperforms oracle 11g on normal queries but any queries with st_functions are very slow. We noticed that its due to extproc calls for shape lib. How could we avoid this or improve?
... View more
10-01-2019
05:10 AM
|
0
|
3
|
700
|
POST
|
we solved the issue by installing FME desktop software and configure the connection details in the FME desktop software. Please let me know if you need an additional details. Regards Kumar
... View more
09-14-2019
02:02 AM
|
0
|
0
|
942
|
IDEA
|
Until ESRI fix this bug, ArcGIS Pro is truly ArcGIS pro desktop only not enterprise version.
... View more
07-22-2019
04:09 PM
|
5
|
0
|
5667
|
POST
|
Hi, I refreshed the catalog but still the same result. Actually we migrated SDE database from Oracle 11g to Oracle 12c Exadata. it was migrated using data dump process. During the migration, we got error randomly that spatial index exist for some layers. After the migration, we found that many layers missing their spatial index using the Arccatalog. I used the above script to get the list instead of viewing each layer in Arccatalog. unfortunately the script provided wrong results. Also, in Arccatalog, the spatial index buttons (add,delete, rebuild) options are not enabled even though it displays the message that the layer has no spatial index.
... View more
07-18-2019
05:33 AM
|
0
|
1
|
1921
|
POST
|
Hi, I run python script using following code desc = arcpy.Describe(fc) sindex = str(desc.hasSpatialIndex) stype = desc.featureType print str(fc)+ "--"+sindex + "--"+stype it returns the feature class name and type correctly. but it doesnt return the correct value for hasSpatialIndex. It returns the values as true when the ArcCatelog show that the layer doesnt have spatial index. any idea
... View more
07-18-2019
12:44 AM
|
0
|
3
|
2060
|
POST
|
We solved the issue by change the settings in SAFE software.
... View more
07-15-2019
07:16 PM
|
0
|
1
|
942
|
POST
|
Hi All The issue is ArcGIS not passing the proxy values properly to FME. Earlier version of FME has facility to provide proxy server details while connecting to WFS layer. The workaround is 1. create new tool box and add spatial ETL tool 2. add all the parameters 3. Run the tool and it will open FME work bench 4. Abort the process and select Tools → FME Options→ Network Proxy→ Use System Proxy→ Ok update the proxy detail 5. run the tool again
... View more
05-28-2019
06:12 PM
|
0
|
0
|
942
|
POST
|
Hi, Our organisation has enforced new policy on our internet access and we are unable to see the proxy settings now as below image. When we try to access the WFS services through arc catelog, it gives error as unable to connect. But the same wfs services are accessible through QGIS. So, how could we configure proxy setup for arccatelog separately?
... View more
03-26-2019
05:53 PM
|
0
|
5
|
1116
|
POST
|
Hi, I am looking for the same option in ArcGIPro but couldn't find. any idea?
... View more
11-20-2018
11:52 PM
|
0
|
1
|
772
|
POST
|
Hi I am trying to edit unregistered ArcSDE in layer using ArcGIS pro. But it is automatically saving the edits. how can I enable the save confirm option for this layer?
... View more
11-20-2018
11:44 PM
|
0
|
1
|
525
|
Title | Kudos | Posted |
---|---|---|
5 | 07-22-2019 04:09 PM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:25 AM
|