An extension that adds spatial operations to Oracle databases

learn more… | top users | synonyms

0
votes
0answers
13 views

Storing 3D Oracle sdo_geometry objects with a 2D SRID

I'm trying to understand the implications of storing 3-dimensional sdo_geometry values in Oracle when the geometry's SRID is a 2-dimensional system. The database I'm studying uses SRID 4326 (WGS84 ...
2
votes
1answer
32 views

Why is too long 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
42 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, ...
0
votes
1answer
32 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
2answers
65 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 ...
3
votes
2answers
65 views

Buffer multiple roads to find points within and compare?

What I am trying to do is buffer a main st and a side street and get all of the points that intersect that buffer, however they need to be mutually exclusive. In the example below, my results would ...
0
votes
0answers
19 views

What is the workflow to add more records from CSV files to a point feature in Oracle Spatial?

We have some GPS data in CSVs to export to existing features in database schema. The CSVs have the same attributes columns, as that of the tables in ORACLE (missing objectIDs, geometry and globalID). ...
0
votes
0answers
12 views

Mapbuilder can't see nvarchar2 to use it in info columns

When I open mapbuilder and create a theme, I want to create ifo columns alias, like block name, block code, but the fields which datatypes are nvarchar2 does not apears in the list to add it to the ...
0
votes
0answers
28 views

Formula to know if LINE intersects with MBR

I have a table with four columns: SRC_X, SRC_Y, DST_X, DST_Y. (SRC_X,SRCY) have position of the start point of a LINE, (DST_X, DST_Y) have position of the end POINT of a LINE. I know there are ...
0
votes
2answers
122 views

How to improve performance of Oracle Spatial function sdo_aggr_mbr

I experienced bad performance when using the sdo_aggr_mbr function on a data set of more than 1 million rows, I had to terminate the operation after several minutes. The statement was: select ...
0
votes
1answer
18 views

How to identify a point on Oracle mapView?

I developed an application depend on Oracle Map JS api v1, my application have multilayer, when I click on the map view all FOIs attributes should posted on a div; i.e: I need to identify a point like ...
2
votes
3answers
104 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 ...
1
vote
0answers
30 views

Oracle spatial Table not displaying in Arcmap [closed]

I am having an issue with an Oracle query layer using not displaying. I have layer/table within oracle, Unfortunately, I am still unable to see the polygons display in an ArcMap query layer. I am ...
1
vote
1answer
29 views

Using IGeoProcessor2 to update Oracle Spatial

In the below example the input and out are shape files read from folders.Is it possible to read and write Oracle Spatial Geometry tables? I have ArcGIS,ArcSDE and Oracle Spatial 11g. How to set ...
2
votes
2answers
98 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 ...
1
vote
1answer
171 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 ...
0
votes
1answer
44 views

Integrate static database with spatial database

I have some questions about how to integrate static database with spatial databases. problematic: I have several static data bases on different platforms (Oracle, MySQL, SQL Server) I want to turn ...
0
votes
0answers
61 views

Load Data to Oracle View (ArcCatalog)

Is it possible to load data from a shapefile to an Oracle 11g R2 view (without ArcSDE) in ArcMap 10.2 using ArcCatalog? The shapefile (polygons) was imported from that view, and then edited, but when ...
0
votes
2answers
142 views

Adding Oracle Spatial View as Layer in QGIS?

Is it possible to add an Oracle Spatial View on QGIS MAP? My view is registered on MDSYS metadata but, when I connect with Oracle DB, it is disabled on the list. QGIS Desktop 2.2.0 Oracle Database ...
1
vote
0answers
136 views

How to use the same client for Oracle 8 and Oracle 11g?

I have a legacy system into Oracle 8, and spatial database in Oracle 11g. When I installed the Instant Client for Oracle Spatial access to Oracle 8 did not work. My question is how can I do to be able ...
1
vote
0answers
30 views

Is it possible to connect Maptitude 5 with Oracle Spatial?

I have a version of Maptitude 5, and I need to connect it to Oracle Spatial. I have the client installed on the machine, including the connection to the database using Qgis and gvSIG and this works ...
1
vote
1answer
183 views

Can I create an Oracle Spatial View from a non-spatial table?

Let's say I have an Oracle database table with latitudes and longitudes. I don't have access to modify the schema of this table, or even create tables. However, I can create views and indexes on those ...
1
vote
1answer
126 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 ...
3
votes
2answers
224 views

Tuning Esri Geodatabase on Oracle Spatial (SDO_Geometry) performance?

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 ...
0
votes
1answer
69 views

How to change a schema name within a MXD with ArcObject .NET?

I have a MXD file where all layers point to an Oracle Spatial database. Recently our DBA changed the schema name. So now my MXD file has broken links, each time I open it, all my layers have a ...
1
vote
0answers
124 views

How to compile QGIS with Oracle Spatial support for Linux?

I compiled it on Fedora and Ubuntu, but got error "Cannot get Oracle select dialog from provider." while trying to add Oracle layer. Packages in repositories don`t have oracle spatial support. Can ...
0
votes
0answers
62 views

How to bulk change the schema name of layer properties in ArcMap

I would like to change the data source location (schema) in layer property in ArcMap. Our data are stocked in an Oracle Spatial database. Recently, the DBA has changed the schema name and then I ...
0
votes
1answer
114 views

Does ora2pg support the SDO_GEOMETRY spatial type?

I've been searching the net up and down for days now and can't find a definite answer to this question, neither on google nor on the official page (http://ora2pg.darold.net/). Does ora2pg support ...
2
votes
3answers
289 views

What are the differences between 81989 and 27700 CRS for the British National Grid?

We are using applying Oracle Spatial to run point in polygon queries in Great Britain using Ordnance Survey MasterMap and point data. MasterMap is on British National Grid (BNG) and has the ...
1
vote
0answers
61 views

(ms4w) oracle spatilal problem of drawing compound polygon for Oracle 10g

When i draw a compound polygon SDO_GEOMETRY( 2003, -- two-dimensional polygon NULL, NULL, SDO_ELEM_INFO_ARRAY(1,1005,2, 1,2,1, 5,2,2), -- compound polygon ...
1
vote
0answers
52 views

How to implement subtype functionality in Oracle Spatial?

I am planning to shift my entire database from arcgis to oracle. I will not be using ArcSDE services also. I need subtitutes for ESRI's functionalities like domain, subtype, relationships in oracle. ...
0
votes
1answer
129 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 ...
0
votes
0answers
63 views

Multiple geometry in a cursor SQL

I have a cursor which I create from a table which has one geometry field only. But in my cursor I would be using two geometry fields as I need to calculate two different areas.Below is the sql ...
2
votes
0answers
34 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 ...
1
vote
1answer
123 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
51 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 ...
1
vote
2answers
544 views

How to load shapefile in Oracle Spatial

I am newbie to oracle spatial. I want to load shapefile into oracle spatial. I am using oracle 11g. I have already look at the following examples and answers ...
2
votes
3answers
445 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
0answers
57 views

Check for overlaps in polygons

I want to get a list of all the polygons from table 2 which overlap with one polygon from table 1. Following is the query which I am trying to use which doesnt give any result. Select b.bg_id from ...
1
vote
0answers
125 views

QGIS: How to reverse vertex ordering in polygons

I am working with an Oracle spatial connection in QGIS through which I am accessing and editing a vector layer. I find that when I edit a geometry, the vertex ordering is reversed (to clockwise in the ...
0
votes
2answers
70 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 ...
4
votes
1answer
124 views

Does ArcSDE require Oracle Spatial rather than Oracle Locator licensing for any functionality when working with SDO_GEOMETRY?

I'm looking for specific information on whether the ESRI suite requires Oracle Spatial for any of the functionality, or if Locator is always sufficient for working with SDO_GEOMETRY objects? Do you ...
0
votes
2answers
194 views

st_multi equivalent in Oracle spatial / how to convert polygon to multipolygon?

is there an equivalent to the PostGIS ST_MULTI available in Oracle Spatial? or - How can I convert POLYGON to MULTIPOLYGON in Oracle spatial? Regards, D
0
votes
1answer
195 views

Intersecting polygons in Oracle

Have a polygon in table 2 with its id, no and geometry. In table 1 I have polygons with the same fields. The polygon in table in intersects with a few polygons from table 1.What I am trying to do is ...
1
vote
1answer
174 views

How to check for overlapping polygons in Oracle?

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
193 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 ...
1
vote
1answer
561 views

How do use the Shapefile Converter in Oracle 12c to load a Shapefile?

Update: I resolved the service name issue. At some point I put in the right combo of parameters (or maybe I omitted some) and this message was displayed: The following key/value is missing: -s db_sid ...
0
votes
0answers
22 views

Oracle spatial routing engine on Jboss

Is it possible to run Oracle Spatial Routing Engine 11g on JBoss AS7?
4
votes
1answer
246 views

ArcGIS Server and Oracle SDO Geometry Interop - It Can't Be This Slow

I have an ArcGIS Map Server Map Service connecting to an Oracle 11G instance via Direct Connect. There is no need for ArcSDE since our application doesn't need versioning, replication, or any other ...
1
vote
2answers
379 views

Add Oracle Spatial Vector Layer with QGIS 2.0 on Mac OSx

I installed version 2.0 using the recommended mac installer (http://www.kyngchaos.com/software/qgis), and the installation went fine, but there is no option to add an oracle spatial layer (not in the ...