All Questions
Tagged with oracle-spatial arcgis-desktop
49 questions
0
votes
1
answer
60
views
Setting version of ArcMap
I am trying to set the version of SDE by using following code :
SET SERVEROUTPUT ON;
declare q varchar2(100);
ver varchar(10);
BEGIN
DBMS_OUTPUT.PUT_LINE('HI');
ver := 'PQ_358';
...
- 19
2
votes
2
answers
213
views
View has no records when viewed in ArcCatalog
I have created a database view in an Oracle-backed Enterprise Geodatabase. I can see data in both of them when I view them using SQL Developer. However, when I look at the view in ArcCatalog (version ...
- 22k
1
vote
1
answer
962
views
Unknow error connecting from ArcCatalog to Oracle
Currently I am running ArcMap 10.6.1 and try to connect with an Oracle 19c database. Unfortunately I only see "Unknown Error":
Underlying DBMS error[Unknown errorNo extended error.]
Yet I ...
- 2,677
0
votes
1
answer
584
views
Get ArcGIS Pro to show which feature is causing copy/paste to fail
I have an Enterprise geodatabase feature class in a feature dataset that I need to copy over to a gdb. I've tried
right click to copy and paste,
the copy tool in ArcGIS Pro,
copy management in ArcPy.
...
- 1
1
vote
1
answer
168
views
Data (type double) mismatch between ArcMap and ArcGIS Server 10.6.1
When I identify a feature which is having a double value as 0.00001 in ArcMap, it is showing what is expected. I have the layer published as a map service using ArcGIS Server. If I search for the same ...
- 11
0
votes
0
answers
638
views
ArcSDE - AutoIncrementing Object ID in table stored in ORACLE when doing INSERT or UPDATE or DELETE using FME SDE Writer
I have data in an Oracle table (11 million records) and would like to insert 2000
records approximately using the FME ArcSDE Writer to maintain ObjectID put on the Oracle table by ArcSDE via ArcGIS. ...
- 139
0
votes
0
answers
579
views
Connecting Oracle Database 11g in ArcMap?
I installed Oracle Database Enterprise Edition 11g(11.2.0.1) in my machine. And I installed ArcMap Desktop 10.3.1 on another machine. Whenever I am trying to create a direct connection of Oracle DB ...
- 1
4
votes
1
answer
378
views
Limit users' editing privileges by attribute and role
I have a feature class in an Oracle 12c geodatabase.
The feature class has a type column. The column has a coded domain.
I would like to limit user's ability to edit the features based on the type ...
- 1,272
0
votes
0
answers
235
views
Query Feature Class from Oracle table with no geometry column
Using ArcMap 10.4.1 I am trying to create a query layer from an Oracle table (Oracle info at bottom). The table has no geometry column, but has x and y coordinates as double and I am trying to create ...
- 855
0
votes
0
answers
142
views
Oracle 11g aliases that work in ArcMap 10.4
I am getting this error shown in the picture when I try to export a database view into a GDB table in ArcMap 10.4. I know what is causing the error, its the double quotes I use to create alias names ...
- 143
3
votes
1
answer
972
views
Directly edit features in non-SDE Oracle feature class?
In ArcMap, is it possible to directly open an edit session on a feature class in an Oracle database connection if that Oracle database is not managed in SDE?
It is of course easy to edit the features ...
- 55
0
votes
0
answers
129
views
How to Drop Indexes on a Table in ArcCatalog
I am using an Oracle 11g database . The code below doesnt allow me to drop indexes on a table.
import arcpy
# Remove indexes and statistics for gis feature class delta tables
COND=r'E:/...
- 46
1
vote
0
answers
138
views
Make Query Layer - field not available as unique identifier when using NVL [duplicate]
I need to create a spatial view with Make Query Layer. My query includes outer joins, so I must combine every table's ID field to create a unique identifier. Since there might not always be a child ...
- 9,684
-2
votes
1
answer
40
views
Can Oracle store contours? [closed]
I have contours generated in ArcGIS and now it is in a file geodatabase. We need to share it with another application in our company that is using Oracle. Can Oracle without SDE store contours?
And ...
- 11
1
vote
2
answers
2k
views
SDO_GEOMETRY view in ArcGIS Desktop
I have an sdo_geometry table that I created using ArcGIS Desktop (by converting an esri.st_geometry table to sdo_geometry). I'm using Oracle Spatial's sdo_geometry datatype because it has linear ...
- 1,272
0
votes
1
answer
109
views
Limiting search radius and improving performance of ArcSDE for Oracle?
I have a feature class with around 1 million polygon features. I'm using the following query to return features from the polygon feature class that intersect a specified point location (x, y not a ...
- 3,197
-3
votes
1
answer
89
views
Connecting ArcGIS for Desktop to Oracle without ArcGIS for Server? [duplicate]
Is it possible to connect ArcMap to Oracle without ArcGIS for Server?
- 781
0
votes
0
answers
65
views
ArcGIS export data in Shape from Oracle [duplicate]
I connected my Oracle database to ArcGIS and added one layer to map. This layer has points and polygons. I make a selection in this layer and get 9508 selected features, which I want to export as ...
- 371
2
votes
0
answers
154
views
Geodatabase configuration keywords
I am trying to insert a new polyline dataset within my Oracle server database. The dataset in question is located within a local GDB, and is currently c420mb in size. It is taking hours and hours to ...
- 2,291
0
votes
2
answers
1k
views
ArcGIS 10.1 crashes during connection with ArcSDE 10.2 in Oracle 11g database
I have been having this issues of ArcGIS (ArcMap and ArcCatalog) crashing on me every time I try to connect to the databases. I have updated both client and server patches for Oracle as suggested by ...
11
votes
3
answers
2k
views
Querying for underscore character in ArcMap?
For a standard LIKE query against an Oracle-based ArcSDE feature class, the underscore character represents a single character wildcard when used with a string.
I'm trying to impose a definition ...
- 759
3
votes
2
answers
265
views
Do I need to use ESRI's Create Spatial Type functionality
Does anyone know if I need to use ESRI's Create Spatial Type functionality when creating a field in a non ESRI / non geodatabase Oracle 11g database?
I have an older customer database in Oracle. ...
- 31
0
votes
0
answers
156
views
View With SDO_GEOM Function for ArcMap
I have a table of boundaries(polygons) which need to be served up through ArcGIS Server with their centroids(points). I'm using Oracle spatial and thought the most efficient way of doing this was to ...
- 251
1
vote
1
answer
75
views
ArcMap 10.3.1 Editor Message: "A layer for PROJECT_LINES was not found..."
When editing a feature class stored in Oracle Spatial, I am receiving 3 warning messages upon stopping the edit session:
There are 2 more after pressing OK - PROJECT_POINTS and PROJECT_POLYGONS.
I ...
- 76
0
votes
1
answer
2k
views
How do I create a point, buffer it, and intersect with polygon geometry?
The sql below is intended to create a point from a know X,Y. It should then buffer the point with a known distance. Last, the sql should intersect the buffer with an underlying polygon layer and ...
- 3,197
3
votes
1
answer
4k
views
Connecting to Oracle database with ArcGIS for Desktop?
I installed ArcGIS 10.2.2 ,oracle 11g R2 personal edition and it's client.I try to connect to the database using database connection in ArcMap but the error
Failed to connect to the specified ...
- 5,835
2
votes
1
answer
372
views
Select by attributes for Arabic fonts in SDE/ file geodatabases?
I have a layer with names of electrical substations in Arabic language. there is no any problem when searching any Field names in English language whether from the SDE of file goedatabase
I got the ...
- 21
0
votes
0
answers
44
views
How to model multiple topology classes in one query with ArcGIS
We have a lot of geographic data with different geometry type in our application, which are persisted in the Oracle 11g database with ST_Geometry supported by Arcgis SDE 10.
The features can be ...
- 803
0
votes
1
answer
1k
views
How to update extent via sql (st_geometry) from ArcGIS for Desktop?
how to update extent via sql (st_geometry) using arcgis 10.2
i've noticed that if one inserts a geometry, let's say a point, into a table via st_geometry, the corresponding table extent is not ...
- 429
0
votes
2
answers
814
views
Oracle Error 00936 in ArcMap
I am using ArcMap 10.2 and have connected to my Oracle database, and can see the tables in Catalog. However, when I try to add a layer I get "Could not add the specified data object to the map. ...
- 83
0
votes
1
answer
576
views
Create feature class with ArcCatalog in Oracle Spatial without ArcSDE error
I need to create a table/feature class with ArcCatalog 10.2 directly to a Oracle Spatial 11.2 database without ArcSDE, Is it possible? I can execute the create new feature class in ArcCatalog, but ...
- 33
1
vote
2
answers
2k
views
SDE connection and multiple schema
I setup an sde connection for Oracle database, where multiple databases are sitting. All databases have same owner, sharing same password but identical user (e.g., BUI, EICU, FRNSW and LPI). While ...
- 139
0
votes
0
answers
142
views
View Oracle GeoRaster in ArcMap
I have imported SRTM DEM into Oracle 11g using FME.The block size is set to 128X128.I am able to view the data in QGIS,Tatuk and play with it using GDAl command line.Unable to view the same in ArcMap. ...
- 1,304
2
votes
0
answers
117
views
SQL server in ArcGIS 10.2 Desktop
I am using ArcGIS 10.2, and previously using Oracle spatial as back end.
Now the data providers have shifted to SQL providing core data using FTP which is being staged at SQL server.
We need to ...
- 139
1
vote
1
answer
296
views
Connecting Oracle Linux database to AcGIS 10 on windows PC
I am wondering if anyone has tried to connect from ArcGIS 10, to an oracle database stored on a Linux server?
I have no problems connecting to oracle from Arc when the data is stored on a windows box, ...
- 11
0
votes
1
answer
824
views
Use Hibernate with Oracle and Esri St_geometry type
Can anyone tell me whether I could use Hibernate with esri ST_GEOMETRY type?
I have found that Hibernate Spatial does support SDO_Geometry, but nothing for ST_Geometry.
I am using oracle 11g and ...
- 776
2
votes
2
answers
2k
views
How to copy selected features from one sde feature class to another with different attributes using Arcpy?
I am new to ArcPy scripting, I need help on copying the features to SDE feature class.
My Scenario: We have two Geodatabases running on Oracle 11g ArcSDE 10.2. I have been asked to write the Python ...
- 163
5
votes
4
answers
8k
views
Converting arcs to straight line segments?
I have a large number of geometries, currently stored in Oracle, some of which contain arc segments.
I need to convert these geometries into LRS (Linear Referencing System) format so I would like to ...
- 98
4
votes
2
answers
2k
views
Failed to connect to the specified server, ArcGIS 10.1 connection using Oracle 11 g
I am trying to connect an Oracle 11g database to ArcGIS 10, but it's not working and gives the following error: "Failed to connect to the specified server. Operation Failed."
While I am sure about ...
- 293
5
votes
4
answers
3k
views
Exporting data from Oracle to Esri File Geodatabase grid size error
My specs: ArcInfo 10.1, Oracle 11g
I have a line dataset which is sat in Oracle 11g. I can read/query/symbolise this in ArcDesktop without any problems.
I now want to export a selection into a file ...
- 2,118
0
votes
1
answer
632
views
Creating a layer in arcmap by dragging a table from an OracleDB
I am working on a project for a client, they gave us some data from their oracleDB, and when I connect to it in arc map I can just drag and drop the tables from the catalog window into arcmap and they ...
- 177
0
votes
2
answers
99
views
database using arcgis [closed]
i want to know, can arcgis software do the database such as oracle or ms access?? for example, create own database and form?? and can the database in arcgis read the programmer program such as from ...
- 1
-1
votes
1
answer
248
views
Connecting Oracle and ArcGIS for Desktop? [closed]
How can I Connect between Oracle 64 bit 11g and Arcgis 10.1?
- 45
2
votes
0
answers
427
views
ArcMap vertex problem for Z-value
I have an Oracle Spatial dataset with z-coords. I can edit the dataset in ArcMap however the z-values are always rounded to the nearest integer.
Why does ArcMap round the z-values?
6
votes
2
answers
3k
views
Why is Oracle Spatial Query Layer Not Displaying in ArcMap?
I am having an issue with an Oracle query layer using SDO_Geometry not displaying.
I have created a polygon layer/table within oracle, registered the table with the SDO_GEOM_METADATA and created a ...
1
vote
1
answer
138
views
Are there any known issues with using database triggers for reacting to a WMX Job status change?
I'm looking to notify another system when a WMX job (of particular job type) has been closed. And I know this will be a call to an Oracle package. I'm considering a database trigger because it seems ...
- 14.7k
3
votes
2
answers
2k
views
ArcMap Query Layer passing invalid SQL to Oracle
In two different environments I'm having trouble using ArcMap 10.0 SP3 Query Layers to view SDO_GEOMETRY (point) data in Oracle 11.2 (11gR2).
Points are in Oracle stored under SDO_GEOMETRY, 2001 type (...
- 3,698
2
votes
1
answer
192
views
arcsde huge size file upload into Oracle spatial
I have 35million records (tomtom multinet) of file gdb file in my desktop machine. I need to upload this file into Oracle spatial as SDO_geometry file.
I already tested the connection with small ...
- 454
3
votes
2
answers
2k
views
Cannot spatially select from Oracle view based featurelayer in ArcMap
I'm hoping someone has seen this before and has a solution. I've exhausted all my ideas. I having problems with the selection and identify tool in ArcMap.
I have a point feature class, zlevels, ...
- 345