A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

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
1answer
26 views

How to find closest point on a line from a point in Oracle Spatial?

I want to find the nearest point on a line from a point in Oracle Spatial. I know how to do in SQL Server and PostgreSQL but could not find anything about Oracle. I have used MDSYS.sdo_nn to find the ...
0
votes
0answers
32 views

Export a layer from QGIS to Oracle DB

I have a working connection to an Oracle database in QGIS (3.4). I am able to import and edit existing tables into my QGIS project out of the db. Unfortunately it is not possible to export any QGIS ...
0
votes
1answer
17 views

How to resolved ORA-12154: TNS:could not resolve the connect identifier specified..? [closed]

When application try to connect to an Oracle Service via Oracle Networking SQL*Net, it looks up the connect data for the service. When this lookup fails, Oracle client show an error message ORA-12154.
0
votes
0answers
32 views

Query result showing unsupported data type

When I use this code: SELECT SDO_GCDR.GEOCODE_AS_GEOMETRY ( 'SPATIAL', SDO_KEYWORDARRAY ( '3746 CONNECTICUT AVE NW', 'WASHINGTON, DC 20008' ), 'US' ) geom ...
0
votes
1answer
65 views

Projecting features to Enterprise Geodatabase in Oracle gives ERROR 000210: Cannot create output

I am trying to project features from a geodatabase and write into an enterprise geodatabase connection. I have permissions to create data and the name I am using also works, but I keep getting error: ...
0
votes
0answers
18 views

Oracle WMS GetFeatureInfo issue with points and lines

I am trying to do GetFeatureInfo request on MVDEMO sample data. When it comes to polygons, it is working fine: When I do the same type of requests on lines or points, I get an empty response: As you ...
0
votes
0answers
27 views

Set Valid Time for Oracle Workspace Manager in QGIS

I am trying to utilize the workspace functionality in QGIS. Entering a workspace via the connection parameters is not an issue. The issue is the valid time is always the current system time the edit ...
5
votes
2answers
802 views

Creating geodatabase (and st_geometry) in Oracle Express (XE) for home/personal use?

I'd like to set up a database environment at home that mimics what I have in the office (Oracle enterprise geodatabase/ESRI's st_geometry). I want to do this for spatial database training purposes in ...
1
vote
0answers
39 views

Unexpected result from Oracle SDO_AGGR_UNION

I'm getting a result that looks incorrect from the Oracle Spatial SDO_AGGR_UNION function. I'm hoping someone has seen this and can confirm it's a bug or explain why this is expected behavior. ...
1
vote
1answer
713 views

Editing ArcSDE Oracle spatial view

Can you edit an ArcSDE Oracle spatial view? By 'edit' I mean edit the geometry in the feature class, not any attributes in the joined table. Unversioned. I really had it in my head that you can, as ...
0
votes
1answer
82 views

ESRI oracle multi editor schemas

Solution: The limitations of the Esri + Oracle (per 12c) were the cause. 12c Oracle will allow for Multi-Tenant DB, allowing us to have multiple SDE GeoDB as we need. This will meeting the need for ...
0
votes
1answer
206 views

GDAL ogr2ogr OracleSpatial to Shape: Multipolygons with wholes/multiparts are missing

We're holding geodata in an Orcale database (11g) with spatial extension. I want to unload specific polygons and convert them into Shape for further local processing. The table where I'm unloading ...
4
votes
1answer
43 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
vote
1answer
50 views

How to find nearest neighbor in Oracle's ST_GEOMETRY?

I am trying to find nearest road segment to a point in Oracle. I can do this with SDO_GEOMETRY type i.e select /*+ LEADING(pois) INDEX(route ALL_ROUTES_SPTAIL_INDEX) */ route.* from DEVICE_STATUS ...
0
votes
1answer
25 views

Does SDO_WITHIN_DISTANCE also return points inside a polygon?

Using Oracle Spatial Database, just wondering if the SDO_WITHIN_DISTANCE returns points inside a polygon, not just within a certain number of metres from the boundary. I've already checked the ...
1
vote
0answers
14 views

SDO_GEOM.RELATE with EQUAL mask returns false for same WKT

I am trying to compare two geometries from two different tables and find all the different with the specified tolerance. I'm using WHERE sdo_geom.relate(gs.shape, 'mask=EQUAL',p.shape,0.002) = 'FALSE'...
0
votes
0answers
6 views

Can't initialize topology in Autodesk Industry Model 2017

Im facing difficulty trying to initiate my Industry model topology, i always get the error of cannot write _tisl with sql loader, i tried to clean the lines but no luck, i dont know what to do im ...
1
vote
0answers
139 views

Updating location field (geometry) in Oracle Spatial using asp.net web application [closed]

I want to update a geometry column in Oracle Spatial database via Asp.net web application, I couldn't find samples for update query or datatypes that can hold geometry data in asp.net. I use C# for ...
0
votes
0answers
27 views

Unsupported data type for column geoloc

I can open the layer on QGis but in MapInfo I got that error. I already have other layers I can open without any problem, is just with one I get this error.
1
vote
0answers
13 views

Is there a list of possible value for SDO_GEOM.VALIDATE_GEOMETRY

When the geometry is valid return 'TRUE' but when is invalid return an error code, You can google each one, but I want to have a system user-friendly where when I found a wrong geometry already said ...
1
vote
0answers
122 views

Draping vector data over DTM in Oracle? [closed]

I have ~100 million 2d vector topographic features (lines and polygons) in an Oracle 12c database. I have 20 billion xyz points in an Oracle database table as number types - the points cover the same ...
0
votes
1answer
367 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 ...
3
votes
2answers
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, ...
1
vote
1answer
107 views

What is mapinfo precision on coordinates

I have some roads on Mapinfo and looks OK, all nodes seem connected at 0.01 m Zoom. If you try to export it to mid/mif you can see the same coordinates (-63.869036 11.039044)on all 3 lines. Line -63....
-1
votes
1answer
312 views

Creating OVF file for connecting Oracle and QGIS [closed]

I'm trying to create an OGR file that can be opened in QGIS that pulls in vector data from an Oracle Database. I've tried a few combinations of things but can't seem to get anything to work. I've few ...
4
votes
2answers
2k views

Determining percentage of intersection between two shapes In Oracle Spatial

I have to query polygons that intersect with one another. Our polygons occasionally contain intersections that aren't intended (meaning just a few vertices cross boundaries). I want to filter out ...
0
votes
1answer
349 views

Importing QGIS layer to SpatiaLite table

I have a Spatialite database with a table called spatialite_objects, with spatial and non-spatial data. Another layer is an Oracle Spatial Layer (id, geom) with 2 table joins (based on 2 csv files) ...
6
votes
1answer
12k views

Oracle spatial SDO_RELATE: why better performance result from UNION ALL/INTERSECT combined individual specified mask

Initially I was trying to find out why it's so slow to do a spatial query with multiple SDO_REALTE in a single SELECT statement like this one: SELECT * FROM geom_table a WHERE SDO_RELATE(a....
1
vote
1answer
41 views

SDO_JOIN conversion to PostGIS

I make refactoring from Oracle to PostGIS and I found out that PostGIS doesn't support sdo_join. How should I correct the statement below? SELECT e.ID AS EDGE1_ID, u.NODE_ID AS ...
3
votes
4answers
1k views

Shapefile import with Oracle + GeoServer produces points instead of vector shapes

I have implemented the example at http://www.gistutor.com/openlayers/22-advanced-openlayers-tutorials/47-openlayers-wfs-t-using-a-geoserver-hosted-postgis-layer.html and got it working properly. Now ...
0
votes
0answers
122 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 ...
0
votes
1answer
127 views

Using Google Encoded Polyline Algorithm Format with Oracle Database

Google's Encoded Polyline Algorithm Format is implemented in several GI tools. PostGIS e.g. has ST_AsEncodedPolyline and ST_LineFromEncodedPolyline functions. In contrast, Oracle Database has no ...
1
vote
1answer
90 views

Reproject vector layer in oracle or PostGIS without export!

I have some vector layers in Oracle and PostGIS, point, line and polygon, and i want to reproject those layer in a different projection but i don't want to export the projected layer, i want to do it ...
1
vote
2answers
139 views

Loading and using 600k+ entities (from Oracle DB) in QGIS?

I'm new to QGis and working on some land register's datas. I tried to load an Oracle spatial layer, but with more than 600k rows, it took a very long time to process, when it didn't crash. After the ...
1
vote
0answers
303 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 ...
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 ...
0
votes
1answer
224 views

Cannot display Oracle raster images using QGIS

I am dealing with QGIS 2.2 and the plug-in Oracle spatial georaster. Apparently the connection to the database can be made, as the raster images are listed once you press 'Connect', but when try to ...
4
votes
1answer
1k views

Joining spatial and not spatial table in oracle

I have spatial table with rows of data representing polygon(A). I have another table that contains values for polygon field(B). Now I would like to join these two table and create a spatial table. I ...
3
votes
4answers
2k views

Converting oracle geometry to PostGIS with 3d data (wkt?) [closed]

I am converting Oracle spatial database to postgis. Most of of the spatial data is 2.5d. Meaning we have a Z-coordinate which indicates the depth/height of the element compared to soil level. Getting ...
2
votes
1answer
954 views

Transferring data from PostGIS to Oracle Spatial

I would like transfer spatial data from PostGIS to Oracle Spatial. I want to use Python's modules psycopg2 and cx_oracle. Transfer Oracle > PostGIS is OK, but in opposite version I have problem with a ...
1
vote
1answer
128 views

SDO Oracle Table not recognized as Geometry in QGIS

I can connect to the Oracle Database with QGIS but spatial table/layers are not recognized as such. I have read the following in the QGIS documentation: Normally, an Oracle Spatial layer is ...
1
vote
2answers
299 views

Connecting QGIS to Esri Enterprise Geodatabase of type Oracle Spatial

I have an Esri Enterprise Geodatabase (ArcSDE 10.2.2; Oracle 10G). I am trying to connect it with QGIS 2.16. So I clicked "Add vector layer" button with "Database" Type : Oracle Spatial (I've tried ...
5
votes
1answer
8k views

Setting up ArcSDE for Oracle Spatial connection parameters?

Just testing out the new QGIS2 install here and trying to connect it to our huge SDE/Oracle spatial database. Im struggling with the connection parameters. Here is the connection properties to the ...
4
votes
2answers
291 views

LRS schema error in Oracle SDO_NET when validating network

I have a problem with the Oracle Spatial Network package. I'm creating NODE, LINK and PATH based on LRS. When I try the call: SELECT SDO_NET.VALIDATE_NETWORK('network_tracking') FROM DUAL then I ...
5
votes
2answers
930 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
1answer
1k views

Error configuring Oracle datastore in GeoServer

I want to configure an Oracle datastore in Geoserver so I copied gt2-oracle-spatial-2.3.1.jar and ojdbc14.jar into GeoServer webapp (in WEB-IF/lib folder); then I restarted and try to create new data ...
1
vote
0answers
314 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 ...
2
votes
2answers
1k views

Reading Oracle data with PyQGIS gives “identifier is not long” error

Do you have any idea how load Oracle spatial data to QGIS with using the PyQGIS? Is it possible? I try: uri = QgsDataSourceURI() uri.setConnection("*host*", "1521", "*database*", "*username*", "*...
6
votes
3answers
2k views

Extracting data from Oracle Spatial and preserving spatial data

My table currently contains an SDO column that I want to export (along with the rest of the data) but all I have at my disposal is PL SQL Developer. Is there anything I can do to get at that data and ...
3
votes
2answers
653 views

Seeking common interface for ST_Geometry SDO_Geomtry

I've worked a fair bit with Oracle Spatial and I've had some requests to transition to PostgreSQL Spatial. Is there a common interface for SDO_Geometry and ST_Geometry? I'm working in Java with ...