Questions tagged [oracle-spatial]

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

Filter by
Sorted by
Tagged with
2
votes
1answer
482 views

How to use the Oracle Spatial functions inside ms4w MAPFILE DATA string?

How to use Oracle Spatial functions in the DATA queries of MapServer(ms4w 3.0.3)? I am getting the following error while trying to highlight selected features which lie inside a particular boundary : ...
2
votes
1answer
58 views

Can I use a join in Mapviewer

I've got two tables, parcels and permits. I'd like to display permits on a map without having to copy the geometry data from parcels. Is there a way to create a join in Mapviewer? Do I have to ...
2
votes
1answer
2k views

Publishing oracle spatial table in geoserver

I published oracle view in geoserver. using this link. But when I see this in layer preview I get following xml response: <?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE ...
2
votes
1answer
77 views

Geoserver feature type details duplicate Oracle DB users

I have two users in a Oracle DB user_1 and user_2. This issue occurs when I create a two tables by user_1 its show one table as user_1.table_1 and the second table as user_2.table_2. I'm not sure why ...
2
votes
1answer
588 views

Projection Problem on Oracle Spatial

I would like to transform SDO_GEOMETRY from WGS84 projection to my custom projection in Oracle Database. Details for custom projection is as follows: +proj=lcc +lat_1=40.5 +lat_2=37.5 +lat_0=25 +...
2
votes
1answer
996 views

Loading Oracle Spatial Layers in standalone python qgis

I used below script to connect to postgres and load layers successfully.I want to aceive this using Oracle Spatial for both vector and raster loading.How can I achieve that?In other words what is the ...
2
votes
2answers
845 views

Query to find all lines connected to other

I have problem with one spatial (Oracle) query. Simplified overview of the problem is: I have two tables: CREATE TABLE thin_lines ( id NUMBER PRIMARY KEY, geom SDO_GEOMETRY), color VARCHAR2(32)...
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*", "*...
2
votes
2answers
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 ...
2
votes
1answer
2k views

Load data to exists table with ogr2ogr

Could I load spatial data to Oracle when table structure was created before this step? Specifically I have problem with default name of attribute OGR_FID . If my primary key has different name, I can'...
2
votes
3answers
2k views

Calculate Area proportional

I have two tables both of them having polygon geometry. Lets consider Table 1 has bigger polygons which overlap over the smaller polygons in table 2.Now I know how to find how many polygons from table ...
2
votes
1answer
2k views

Checking for overlapping polygons in Oracle Spatial?

I have a table 1 which has a fields like store number and geometry and it just has one record in it. Now I want to check for this store number in table 2 and identify if there are any polygons ...
2
votes
2answers
462 views

Searching Open Source tool to load raster data into Oracle spatial

I'm looking for a tool to load raster data into oracle spatial. I found several commercial products but no open source tool. Is there anything available in the open source world?
2
votes
1answer
76 views

Load layer From Oracle using QgsDataSourceUri in QGIS3 always return Invalid Layer

I'm tring to load spatial layer from Oracle but when i called function QgsVectorLayer(uri.uri(), "LAYER" , 'oracle') it still inValid layer This is my code > def LoadFromOracle(tablename): > ...
2
votes
2answers
276 views

Persistence in QGIS under Oracle workspace

I'm using QGIS 2.18.9 to edit my spatial data, my data is saved in Oracle's database. When I'm editing a spatial layer I can create, edit and delete features without problems, but my database needs ...
2
votes
1answer
1k views

Line to polygon in Oracle Spatial

I have a table that contains buildings in a line geometry where a line starts and ends at the same point. Is there away to convert lines to polygons in Oracle Spatial?
2
votes
1answer
2k views

Efficient way to find geometries that intersect a given rectangle

It feels I'm missing something absolutely basic here OR there is something weird in the internals of Oracle's spatial indexing (I sincerely hope it is just me missing something basic or I am about to ...
2
votes
1answer
305 views

QGIS Oracle-Spatial-GeoRaster-Plugin not working [closed]

I am having trouble with Oracle-Spatial-GeoRaster-Plugin in QGIS (running on Windows 7 Professional N 64bit). The connection to my database on an external Oracle-Server obviously works as it shows the ...
2
votes
1answer
305 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 ...
2
votes
1answer
451 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 ...
2
votes
1answer
1k views

openlayers 3 (or oracle) convert 2d to 3d

We have an existing oracle gis which is being reworked. We're not really touching the oracle stored procedures or tables. In the table, the sdo_geometry appears to be a 3D line, with 0 as the z value. ...
2
votes
2answers
1k views

Slow connecting to Oracle Spatial database from QGIS client?

I am having trouble connecting to an Oracle Spatial data with QGIS client. I use QGIS Version 2.2 (Valmiera) to connect to a database schema in Oracle Spatial. I asked our DBA access to our database ...
2
votes
2answers
191 views

connect ArcGIS server with different instances of oracle database

Is it possible for a development team to have personal oracle database instances, for testing purposes, connected with the same GIS server? In other words I want every user to work with his own data, ...
2
votes
2answers
1k views

Finding Polygons which do not touch any other polygon in a single oracle database table

I currently have an oracle table of approximately 100,000 records - all of which are polygons. I want to find all the polygons which do not touch any other polygon within the same table. There are a ...
2
votes
1answer
1k views

How do you manage columns in an ArcSDE/Oracle feature class?

Our enterprise has a long history with Oracle and ArcSDE. And lots of tension between the Oracle people and GIS people. Oracle folk often don't like the requirement of using expensive 'nonstandard' ...
2
votes
2answers
292 views

How to mention multiple projections in MapServer MAPFILE?

Is there a way to mention multiple projection systems / spatial reference systems in MapServer's (ms4w 3.0.3) MAPFILE? For example for Malaysia - GIS data could lie across three spatial references WGS ...
2
votes
2answers
964 views

SQL Server STRelate equivalent of Oracles SDO_RELATE(…mask=anyinteract)

In Oracle Spatial, we are running checks on a graph. The Check should provide Nodes, which are marked as endnodes (Attribute "EDGEDEGREE" equals 1) but are in fact located somewhere along an edge. We ...
2
votes
1answer
812 views

Table doesn't match base table schema in Geodatabase Versioning?

ArcGIS 10.1 sp1 with Oracle 11g I've got a versioned feature class that I have discovered has a base table with a different schema than the corresponding A table. (A + registration_id from sde....
2
votes
1answer
3k views

How to set appropriate spatial index for a feature class in Oracle?

I wanted to ask is there any known method how to set spatial index for my feature class in Oracle. I am working with ESRI 10.1 and I have various feature classes covering the whole area of my country (...
2
votes
1answer
1k views

Best way to get the overlapping segment of two lines

Could anyone help me figure out the best way to get the overlapping line segment of 2 line sdo_geometry objects? my query looks like this: select SDO_GEOM.SDO_INTERSECTION(SHAPE, :SHAPE, 0.5) as ...
2
votes
2answers
1k views

Is ArcMap 10.0 Query Layer passing invalid SQL to Oracle 11gR2?

In two different environments I'm having trouble using ArcMap 10.0 Query Layers to view SDO_GEOMETRY (point) data in Oracle 11.2. This suggests I'm doing something wrong... Points are in Oracle ...
2
votes
0answers
44 views

ArcMap replication tool does not synchronize changes made in versioned view from SQL Developer!

I am trying to replicate a feature class from Oracle to MSSQL Server using one-way replication(parent-child) replication. The replication works when edits are made from ArcMap,since I have to insert ...
2
votes
0answers
55 views

Select events that represent the most recent work on roads

I have a question on Stack Overflow where I ask about Selecting events that represent the most recent work on roads. So far, I have been provided an answer that seems to work, although it is quite ...
2
votes
0answers
140 views

How to simplify line geometry and preserving topology in Oracle?

I have some polylines in an Oracle database which are topologically connected and I want to simplify these lines based on a tolerance directly in Oracle. I need something like ...
2
votes
0answers
280 views

JOIN on Oracle table and view with PyQGIS

I have a view v and table st with attributes and SDO_GEOMETRY columns in an oracle database. I want to do an LEFT OUTER JOIN a common value with data filtering on the v. SELECT ST.OBJECTID, V.ID_WS, ...
2
votes
0answers
43 views

No data found error when reconciling version in sde

I got an error when reconciling a version in the sde database and it seems sde cannot find the data in one table with a specific STATE_ID (for example STATE_ID = 12345 for table abc). In the delta ...
2
votes
0answers
362 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....
2
votes
0answers
249 views

QGIS Server 2.12.14 Errors with Oracle

We are using QGIS Server to serve Oracle SPatial (11.2.0.4) to a spatial viewer. There is 16Gb of RAM. The number of concurrent users is 100-150. QGIS Server is on Windows Server 2012 R2 with 16GB of ...
2
votes
0answers
191 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 ...
2
votes
0answers
107 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 ...
2
votes
0answers
69 views

Why are ellipse polygones simplified when used in a FeatureService?

I have polygons with ellipse shape in a SDE Oracle ST_GEOMETRY geodatabase. All those polygons are correctly displayed when in a MapService. But when displayed in a FeatureService, some polygons ...
2
votes
0answers
271 views

ODBC connection issue on 64bit architecture

I'm migrating an addin to a 64bit machine using Arcmap 9.3.1. Upon execution, it returns the following error - "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch ...
2
votes
2answers
2k views

Tuning Esri Geodatabase on Oracle Spatial (SDO_Geometry) performance? [closed]

We are storing data in a Geodatabase on Oracle 11g using Oracle Spatial with SDO_Geometry, and then consuming that using ArcGIS server 10.2.1. The performance is very slow, because we are talking ...
2
votes
0answers
69 views

Multiple Cursors

Below is the sql statement which I have explained below. Declare Cursor c1 is select store_number ,0 as total_area,0 as BG_ID ,0 as store_geom from table1 where CLIENT_ID= 1 and ORG_ID ...
2
votes
2answers
883 views

How to add map layers from Oracle database VIEWS in MapServer mapfile?

I am using MS4w v 3.0.3 (with Java mapscript) with Oracle Spatial 11g. Can we add layers to MapServer mapfile from oracle database views? If yes, is there any specific way to create views with spatial ...
2
votes
0answers
1k views

Migrating from PostGIS to Oracle Spatial

We are now using a solution based on PostGIS extension of Postgresql database for various spatial queries. But we are now thinking about data security. This is why we have a plan to migrate existing ...
2
votes
0answers
96 views

Can .Net version of ArcGIS Server expose Oracle spatial data without ArcSDE, or is this limited to Java version?

I'm planning a new deployment of ArcGIS Server and I want to avoid using ArcSDE if possible. My vendor requires that we store our spatial data in Oracle and we prefer to use Microsoft server ...
2
votes
0answers
278 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?
2
votes
1answer
2k views

How to move an Oracle spatial table to another db?

I have uploaded a polyline data (50 million rows) to oracle spatial 10g as sdo_geometry through arccatalog and arcsde in my TEST database. Now, I need to move this table to QA database, this table ...
2
votes
1answer
181 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 ...