An extension that adds spatial operations to Oracle databases

learn more… | top users | synonyms

1
vote
0answers
18 views

draw isoline from points

Is any spatial utility or methods are available for creating contour or isopleths on Oracle spatial? I want to create contour from point geometry show it on map (using mapserver) to site. Pleas share ...
0
votes
0answers
7 views

Connect mapserver with oracle spatial

I install mapserver using osgeo4w. Now, how can i set connection between mapserver and oracle spatial? sorry for bad english. help me.
0
votes
2answers
51 views

SQL filter to show one layer only if another layer is missing

I have two oracle tables that represent buildings in my town. The first table represent buildings that are surveyed and measured accurately but doesn't cover all the parts of the town while the second ...
2
votes
0answers
18 views

How to efficiently drape vector data over a DTM

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 ...
1
vote
0answers
27 views

Use Hibernate with Oracle and Esri St_geometry type

Can anyone tell me whether I could use Hibernate with esri ST_GEOMETRY type? I have found that Hibernate Spatial does support SDO_Geometry, but nothing for ST_Geometry. I am using oracle 11g and ...
0
votes
0answers
26 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
61 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
52 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
40 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
71 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
70 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
20 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
13 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
168 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
20 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
123 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
31 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
32 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
123 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
184 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
49 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
71 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
174 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
179 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
233 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 ...
2
votes
1answer
152 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
274 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
73 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
138 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
68 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
121 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
328 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
65 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
53 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
154 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
72 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
131 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
52 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
646 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
467 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
58 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
137 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
72 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
134 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
213 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
227 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
187 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 ...