Questions tagged [oracle-spatial]

Use for questions about the Spatial or Locator extensions to the Oracle DBMS

Filter by
Sorted by
Tagged with
0
votes
2answers
1k views

Generate in oracle sql developer a point with specific SRID from two variables

I have created quite often (in posgis) points using two variables from the table (LAT,LON) and setting the desired SRID. I am trying to do something similar now with Oracle SQL developer but I keep ...
1
vote
1answer
904 views

Add and edit Oracle Spatial Layer in QGIS

When I connect oracle layer are not enabled me all editing options. I can create and delete but not update. It is an issue of users? permissions or privileges? metadata? All works OK in AutoCADMap3D ...
2
votes
0answers
194 views

Controlling precision of coordinates returned from ArcGIS for Server service?

I have a REST service that returns shapes as json. The shapes represent various natural features. The problem is the precision of the coordinates. Currently, 11 decimal places of precision are ...
0
votes
0answers
126 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 ...
1
vote
1answer
210 views

Esri ArcSDE 10.3.1 Query Inspire Metadata from Oracle (11g) Enterprise GeoDB via SQL

As the title says - I want to create a query in Oracle SQL which will read all dates from the geoprocessing history which can be found using ArcCatalog to show the "Description"-tab from a feature. (...
1
vote
1answer
70 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 ...
1
vote
0answers
120 views

GeoServer: Use oracle as raster store without spatial extension

Is it possible to store raster data (e.g. GeoTIFFs) in an oracle table and access it from geoserver without using the oracle spatial extension/GeoRaster? I would store the images as blobs, but I don't ...
0
votes
1answer
759 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 ...
4
votes
0answers
695 views

How to hide system tables of oracle in sde connection?

I connected to oracle 11g r2 with ArcGIS 10.2 using SDE connection. The connection is ok but in the connection i see system tables of APEX_030200 and other schemas. Same question is in the Geonet ...
5
votes
2answers
977 views

Why does pyQGIS QgsVectorLayer().isValid() return FALSE with Oracle views?

This works perfectly fine with an Oracle TABLE but not with a VIEW. Why? uri = QgsDataSourceURI() uri.setConnection(host, port, db, username, pw) uri.setWkbType(QGis.WKBPolygon) uri.setDataSource(...
1
vote
0answers
177 views

Data not showing in QGIS when connecting to Oracle

I have an Oracle XE 11g spatial database that is connected to a web map. All the layers of the web map are stored in the database and they work just fine. I sometime need to edit some of the layers in ...
3
votes
1answer
3k views

Update a table with values from coordinates on GEOMETRY in Oracle

I have 2 columns in a table that represent the X and Y coordinates. The values in those columns don't match the actual coordinates and I want to update them with the coordinates values that are ...
1
vote
0answers
783 views

Geoserver 2.7 - 'Bounding Box & Lat-Long Data' fetching problem from Oracle Locator database

I have installed Geoserver 2.7 & connected my Oracle (Locator) database with available 'gt-jdbc-oracle-13.2.jar' extension. During layer publishing containing fields like 'Geometry', it failed to ...
3
votes
1answer
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 ...
2
votes
1answer
312 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 ...
1
vote
1answer
231 views

Upgrading to ArcGIS 10.3 geodatabase on windows R2 SP2 and Oracle 10g (64 bit) 10.2.0.5?

We have Oracle 10g (64 bit) 10.2.0.5 on Windows Server 2008 Enterprise SP2, and we are planning to migrate our geodatabase from 9.3.1 to 10.3. As per Esri "Oracle database requirements for ArcGIS 10....
0
votes
1answer
2k views

Get WKT from polygon centroid

I have an Oracle Spatial table (in 12c) with a polygon geometry type. I added a text column to the table that I would like to populate with the well-known text of the polygon's centroid. In concept ...
1
vote
0answers
277 views

Tables not showing within schemas following Table retrieval in QGIS (Oracle Spatial)

When connecting to an Oracle Spatial database, QGIS is not consistently populating the list of tables under each schema. When I try to expand a schema (as I have tried to do with PARKING in the ...
3
votes
1answer
563 views

How are orphan gsrvr.exe processes created?

I just inherited a server running SDE application server 10.1 against an Oracle 11g database. I'm finding that many connections are not getting properly dropped and stay on as Orphans. Eventually the ...
0
votes
1answer
337 views

Using WFS-T when layer dimensions don't match with geometry dimensions

We are able to Delete features from OpenLayers and it is successfully deleting them from spatial table. However we are unsuccessful doing add/edit from OpenLayers and saving the features in the ...
1
vote
0answers
316 views

Oracle add layer and Oracle Connection icons are missing [closed]

I have recently installed QGIS 2.8 and Oracle 11.2 Client on Linux Red Hat 7. Everything was fine, I am able to access Oracle database, as well as running QGIS. Unlike QGIS 2.8 from WIndows, Linux ...
3
votes
1answer
505 views

What is the C# Arcobject I must use in order to set programatically the SQL Query of an LYR file?

I would like to change programatically the SQL Query of a LYR file. I'm developping in C# using ArcObject. Actually I'm able to get an instance of IWorkspaceFactory from an opened layer with this ...
1
vote
0answers
277 views

Migrating ArcSDE data to Oracle Spatial?

We've got all the geospatial information of our company within an ArcSDE Database (over oracle Server): points lines polygons We consume these data with ArcGIS Desktop and with ArcGIS Server. We ...
1
vote
1answer
5k views

Updating Oracle Spatial geometry column using SQL?

I am trying to update a table B geom column with the coordinates from table A. Table A having coordinates in two separate columns x and y. Table B to have the coordinates from Table A into Table B's ...
2
votes
1answer
461 views

Converting sqlite (spatialite) data to oracle sdo_geometry (using .NET)

Using .NET, I have a sqlite file that I have to import to oracle. The geometry needs to be converted from sqlite (spatialite) geometry column to a sdo_geometry column in oracle: // Loop through all ...
0
votes
1answer
257 views

It possible to query/convert LONG RAW (SDEBINARY) from SQL?

Curently we have ArcSDE 9.3/Oracle10, and layers in SDEBINARY. It is possible to make queries with SDE.ST_GEOMETRY or SDO_GEOMETRY commands ?
0
votes
1answer
372 views

MapServer with Oracle 12

I'm running MapServer on Windows (with the msplugin_oracle.dll plugin) to create some WMS layers from SDO geometry stored in Oracle 11 database. I take the binaries from this very nice site. The ...
0
votes
0answers
386 views

Adding Oracle Spatial Layer using Python Bindings of QGIS?

I want to load a layer from my Oracle Spatial Database using the Python bindings of QGIS. I have tried loading the layer by creating the uri as shown in some previous posts. I am using the python ...
1
vote
1answer
692 views

How to disable spatial index creation by ArcSDE for Oracle Spatial

Working with ArcSDE 10.1 and Oracle spatial 11g. I set the feature class in load_only_io before loading shapefiles. I am using geoprocessing tool (append) in ArcGIS to load shapefile to geodatabase. ...
1
vote
1answer
94 views

Unable to read different kind of shapefiles

I have written the Java code to read the shapefile and insert it into the table. But the way I have written code it will accept only a multistring .shp file. It fails for other shapefile geometry ...
0
votes
2answers
150 views

how to configuring geomajas wih oracle spatial db?

I have just done intial setup of the geomajas project and trying to config its data source with oracle database. I am following the given example for sqlserver and POSTGIS. My oracle layerroad xml ...
0
votes
0answers
39 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 ...
1
vote
0answers
783 views

Spatial query by ESRI ST_Geometry take too long

I am using ESRI ST_Geometry in my application, and I found that the spatial query is rather slow: The following sql is used for query pois inside a certain bounding_box: select * from ( select ...
1
vote
0answers
827 views

Need to connect ArcSDE dataset using QGIS Desktop and Oracle database

I am working in GIS domain using ESRI technology. I want to use QGIS desktop to access ArcSDE dataset from a local machine. I have already installed Oracle Client 10g and QGIS Desktop 2.8.1 through ...
0
votes
1answer
838 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 ...
0
votes
2answers
546 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. ...
0
votes
1answer
1k views

SDO_GEOMETRY uniqueness in Oracle

Is it feasible converting the spatial property (SDO_GEOMETRY) of a table in Oracle as an unique index or spatial constraint for avoiding spatial duplicates? I am working on point tables and I don't ...
1
vote
1answer
461 views

How do I insert a date string into the database as a date?

I'm using an InsertCursor to insert rows into a feature class. One of the fields in the source data may contain a NULL data value. The destination feature class requires a date - it is not nullable. ...
0
votes
0answers
114 views

Convert spatial table into non-spatial table in Oracle

I want to convert a spatial table, registered with Geodatabase (SDE), into a non-spatial table using SQL Developer, what would it be the most efficient/elegant way of doing it? Obviously, first I ...
0
votes
0answers
56 views

How do I synchronize field properties with the database properties?

I have a feature class with a property that is out of sync with the database table. The field property is "Allow NULL values" and it's currently set to "No". Earlier today, before I was aware of this ...
1
vote
0answers
317 views

Which version of the Oracle Client do i need to get Oracle support in QGIS 2.6.1?

I have just installed QGIS 2.6.1 and wish to connect to our Oracle Spatial 11g Database. Am I correct in thinking I will need the Oracle Client installed on my machine for this to work? If so which ...
1
vote
1answer
393 views

How can I load sqlite file into oracle 11g?

I have SQLite file which I have taken it from Sptialite DB. I need to convert this file into SDO. Plz help me
1
vote
1answer
127 views

QGIS Web Client Raster not visible

I have loaded rasters from PostGIS and Oracle Spatial 11g with below script. Both layers are visible in QGIS Dekstop. My OWS settings are correct but the Oracle raster layers are not visible in QGIS-...
0
votes
1answer
460 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 ...
1
vote
1answer
173 views

Load Oracle Spatial Raster using PyQGIS

Able to connect to Oracle Spatial 11g and print tables with SDO_GEORASTER attribute both in QGIS python console and standalone application.I get below error when loading rasters from oracle Table. ...
3
votes
1answer
632 views

Load PostGIS or Oracle Spatial Raster Layer using PyQGIS

How do we load Rasters stored in PostgreSQL-PostGIS or Oracle Spatial 11g into QGIS using PyQGIS? I am able to load vector layers from Oracle 11g with below code. What changes are necessary to add ...
1
vote
2answers
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 ...
0
votes
1answer
597 views

Oracle spatial index takes no effect

I am using hibernate spatial 4.0 with hibernate core 4.3, and we are using the oracle 11g with spatial extension. This is the entity and dao: @Entity public class Pts{ @Type(type = "org....
0
votes
0answers
134 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. ...
0
votes
1answer
955 views

Tools to export shps from Oracle database

What open source tools could be used to export shapefiles from an Oracle database. I have tried using QGIS but it does crash way too much.

1 2 3
4
5
8