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
0answers
21 views

Get midpoint of SDE.ST_GEOMETRY polylines?

I have a polyline SDE.ST_GEOMETRY feature class in an Oracle 12c geodatabase (10.7.1). I want to create a view on the feature class that has X and Y columns that contain the coordinates of the ...
0
votes
0answers
5 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
25 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
11 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
362 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
99 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
346 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
40 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
117 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
120 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
89 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
137 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
299 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
223 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
944 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
111 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
286 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
909 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 ...
0
votes
0answers
64 views

Speeding up Oracle Spatial intersection query and indexes

I have about 300 000 records (worksites) in a table (S) with id (id_s), start_date, end_date (and in some cases an authorisation date - AUTH_START). I have a second table containing the id of 500 of ...
1
vote
0answers
312 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
648 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 ...
1
vote
1answer
1k views

Error ORA-00920: invalid relational operator

I am running this SQL in Oracle Spatial in postgis worked. In the Oracle error [Err] ORA-00920: invalid relational operator I need to select all geometries that touch on my streets layer, ie the ...
2
votes
2answers
4k views

Querying intersecting areas areas - Oracle Locator or Spatial?

My spatial database is Oracle. We are wondering if we can use basic Oracle Locator or need to get the more expensive, full, Oracle Spatial. My application's requirements include having to be able to ...
3
votes
0answers
275 views

Does QGIS Server support QGIS project with Oracle layers? [closed]

QGIS recently got native Oracle support. I was wondering if QGIS Server supports generating WMS and WFS from a QGIS project with Oracle Spatial layers. I just tested this but I did not succeed...
1
vote
1answer
221 views

Error concatenating lines in Oracle Spatial

The function SDO_AGGR_CONCAT_LINES is returning an error when concatenating lines from a table with simple line geometries (SDO_GTYPE - 2002): ORA-29400: erro do cartridge de dados ORA-06502: PL/...
3
votes
1answer
582 views

Oracle spatial: Point cluster vs MultiPoint?

I'm reading Oracle's documentation and i can't see the difference between Point cluster and MultiPoint element type. The following example code is from the documentation INSERT INTO t1 (i, d, g) ...
2
votes
0answers
355 views

Oracle Spatial: Error with SDO_UNION

I have a table which contains address-points. With following sql-statement i have created a 100-meter buffer around each address-point: CREATE TABLE BUFFERPOLYGONS AS SELECT a.OBJECTID, SDO_GEOM....
0
votes
0answers
54 views

Spatial intersection of features (Oracle Spatial) with a line stored in a local gml file?

Interesting sites are stored as polygon features are stored in an Oracle Spatial read only dB. I have a local GML file containing a line (EPSG:31370 - corresponding to a trajectory over a couple of ...
3
votes
1answer
231 views

Why is query to retrieve WKB on Oracle Spatial returning null?

I am beginner on GIS, and I have loaded a shapefile to MSSQL, PostGIS and Oracle Spatial (11g) On both MSSQL and PostGIS I could create a query to return me the WKB from the table (geometry field) ...
0
votes
2answers
244 views

Only last line of Oracle Spatial Multiline is drawn in QGIS

When I use QGIS to show Oracle spatial data, only the last line of an Multiline is shown. For instance, in this multiline geometry, only the segment from 20,10,0 to 30,10,0 is shown insert into rr....
0
votes
1answer
199 views

Storing raster data with Java into Oracle Spatial [closed]

I have a Java application that processes raster data. At the end of the process I plan to store the raster in oracle spatial. What is the best way to do this? I had a look at geotools but I did not ...
0
votes
1answer
280 views

QGIS and Oracle Spatial database - rule based system in future version?

I (a geographer not to familiar with IT stuff) want to start a pilot with QGIS at a municipality I work for. We store our data in Oracle databases. When trying to open these databases (QGIS 2.2) using ...
1
vote
0answers
354 views

Oracle Spatial support QGIS 1.9-0-Master (Ubuntu) [closed]

I just installed QGIS 1.9.0-Master (Build 480) on a Ubuntu virtual machine. I am running/compiled against GDAL/OGR 1.9.2. Why can't I add Oracle Spatial Layers as I am able to do using QGIS-Master ...
0
votes
1answer
694 views

Severe performance difference using deleteSearchedRows [closed]

The issue I am having involves two versioned tables. A function deletes 48 rows from Table A and and 48 rows from Table B using deleteSearchedRows. However, the delete from Table A takes roughly 4 ...
0
votes
2answers
1k views

Seeking st_multi equivalent in Oracle Spatial or converting polygon to multipolygon [closed]

Is there an equivalent to the PostGIS ST_MULTI available in Oracle Spatial? or How can I convert POLYGON to MULTIPOLYGON in Oracle spatial?