An extension that adds spatial operations to Oracle databases

learn more… | top users | synonyms

18
votes
3answers
2k views

When should you NOT use a spatial index?

I am asking this because I was mainly working with Oracle but for the past year I've been doubling with PostGIS and SQLServer 2008. Most spatial functions in Oracle won't work without a spatial index ...
12
votes
3answers
1k views

Future of spatial databases

It may be a bit off-topic. I am eager to know the industry specific importance of Spatial Databases. Is Spatial Database a very important part of any GIS system? Or will we use other technologies to ...
10
votes
4answers
4k views

What is the difference between geocoding and georeferencing?

After some googling around both seem to be interchangable words, where we speak of tying the spatial info of a real place and storing in database. But still I am not satisfied, there should be some ...
8
votes
7answers
4k views

Register SDE view and Layer

I'm building simple views against an ArcSDE Oracle RAC 10g. My SHAPE columns are of SDO_GEOMETRY datatype. ArcSDE 9.3.1. I have several point tables, with the following outline: ID (Guid) Name ...
5
votes
2answers
397 views

How can I extract data from Oracle Spatial and preserve the 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 ...
4
votes
1answer
519 views

How to get minx, miny, maxx and maxy of a geometry?

I'm new to Oracle Spatial. In MySQL or PostGIS, it's easy to get minx miny maxx maxy of a geometry, any and/or all of them. But how to do that in Oracle Spatial? Do I need to chain up several ...
4
votes
1answer
78 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 ...
4
votes
1answer
468 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 ...
4
votes
1answer
553 views

Oracle Spatial - How to calculate the point of intersection of 2 line geometries

How to calculate the point of intersection of 2 line geometries.
4
votes
1answer
152 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 ...
4
votes
1answer
127 views

Does Oracle MapViewer support PostGIS?

I use Oracle MapViewer to generate my mapping data and currently I'm using an Oracle database as my spatial back-end. I would like to move my data over the PostGIS but I can't find any references if ...
4
votes
1answer
228 views

Error in passing geometry column to SQL query

When I execute the following query with a static table name it's working fine: SELECT pe.structure_category_name,SDO_NN_DISTANCE(2),pe.bt_object_subid, pe.bt_owning_node_id INTO ...
4
votes
1answer
887 views

In Oracle Spatial, what is the fastest way to determine the percentage of intersection between two shapes?

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 ...
3
votes
1answer
598 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 ...
3
votes
2answers
315 views

Get Spatial Table Information Oracle Spatial

How can I get the tablename, Srid and GeometryType of all spatial tables in Oracle(I use 11g)? In postgis, I can do something like select f_table_name,srid,type from public.geometry_columns order by ...
3
votes
3answers
431 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 ...
3
votes
2answers
372 views

Oracle Linestrings and MultiLinestrings

We have a very complicated setup for a project we are doing, and it involves 40+ developers and two oracle databases, one with sde and one only with oracle spatial and it's quite big. We'll here are ...
3
votes
2answers
412 views

Is there a 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 ...
3
votes
1answer
443 views

Making calls the PostGIS functions with Java

We have Java stored procedure in Oracle that make calls to functions offered by Oracle Spatial to perform spatial analysis and return results. I am looking to the same in PostGIS, is this possible?
3
votes
1answer
411 views

Convert non-spatial Oracle table to spatial Oracle table in a different database

I'm trying to use ogr2ogr to convert data from a non-spatial table (has X & Y values) in an Oracle database (1) to a spatial format in a different Oracle database (2). This will be scheduled to ...
2
votes
3answers
87 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 ...
2
votes
1answer
36 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
575 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
3answers
2k views

How to convert geometry coordinates into Google lat/lons?

For storing geospatial data, the geometry field is used in SQL Server or Oracle Spatial. I want to know is there any way where we can convert this geometry field into a set of latitudes and ...
2
votes
3answers
322 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
2answers
104 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
2answers
107 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
414 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
767 views

Which one is better ?SQL server 2012 or Oracle 11g

I want to learn a database server, SQL server 2012 or Oracle 11g . I surf in the internet to compare SQL server and Oracle for spatial data and found good websites such as gisboston.it was very ...
2
votes
2answers
608 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
57 views

ESRI geodatabase, Oracle spatial 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 ...
2
votes
0answers
26 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
1answer
34 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
0answers
39 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 ...
2
votes
2answers
134 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
157 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
50 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
1answer
411 views

Why is Oracle Spatial Query Layer Not Displaying in ArcMap?

I am having an issue with an Oracle query layer using SDO_Geometry not displaying. I have created a polygon layer/table within oracle, registered the table with the SDO_GEOM_METADATA and created a ...
2
votes
0answers
256 views

Need Oracle spatial tutorials

I am working on Oracle spatial 11g and I am referring to Oracle docs as a learning resource. Does anyone know any more Oracle Spatial tutorials ? We want to integrate Oracle Spatial data with ...
2
votes
1answer
518 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
121 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 ...
2
votes
1answer
484 views

Oracle spatial - check polygon vertices counter clockwise

I need to import a huge number of polygons from a third party (as a csv file- array of x,y's). I have to check whether the polygon vertices are in clockwise or counter clockwise, finally i have to ...
2
votes
0answers
324 views

No primary key or unique index found?

I have a store created from oracle database in geoserver. Now after I create layer out of the store. And when I try to access the layer or try to preview the layer, I get the warning message in ...
1
vote
2answers
168 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 ...
1
vote
2answers
1k 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 ...
1
vote
1answer
45 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
53 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 : ...
1
vote
1answer
263 views

Connect ESRI Feature Service to Oracle Spatial database

I need to display some business and feature data from an Oracle Spatial database on a website. The website will use ESRI's HTML5 map components ...
1
vote
1answer
29 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 ...
1
vote
1answer
137 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 ...