An extension that adds spatial operations to Oracle databases

learn more… | top users | synonyms

1
vote
0answers
32 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 ...
0
votes
1answer
59 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 ...
1
vote
1answer
210 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
0answers
86 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 ...
1
vote
1answer
370 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
224 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
117 views

Represent full globe in Oracle Spatial

In SQL Server 2012 I can do this: -- Construct a new FullGlobe object (a WGS84 ellipsoid) DECLARE @Earth geography = 'FULLGLOBE' -- Calculate the area of the earth SELECT PlanetArea = ...
1
vote
0answers
55 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
79 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 ...
2
votes
0answers
168 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
72 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
134 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
390 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
75 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 ...
2
votes
0answers
37 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
210 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
3answers
514 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 ...
1
vote
1answer
165 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
2answers
844 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
1answer
53 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
61 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
0answers
151 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
75 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
156 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
242 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
1
vote
1answer
83 views

Migrating Lines to ArcGIS polyline

I'm trying to import geometry lines from Oracle Spatial database to ArcGIS enterprise geodatabase. and some data will cause the error. Its says not enough points for feature class, but when I look ...
1
vote
1answer
200 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
242 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
728 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 ...
3
votes
1answer
2k 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 ...
1
vote
2answers
439 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 ...
2
votes
1answer
138 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 ...
4
votes
1answer
307 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 ...
2
votes
1answer
2k 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
167 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?
1
vote
1answer
613 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 ...
2
votes
0answers
325 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
70 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 ...
1
vote
1answer
339 views

Can one edit an ArcSDE Oracle spatial view?

By 'edit' I mean edit the geometry in the feature class, not any attributes in the joined table. Unversioned. I really had it in my head that you can, as long as the objectid column is included in ...
0
votes
2answers
456 views

How to find overlapping polygons within a multipolygon (oracle spatial)

I am working with Oracle spatial and have a table with MULTIPOLYGONS. How can I find the db entries where the polygons of a multipolygon overlap - within the same geometry? So, a function that checks ...
2
votes
1answer
924 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 ...
1
vote
2answers
1k views

How to use Geokettle to load shapefiles into oracle spatial

I'm looking for an example how to load a shapefile from the file system into an oracle spatial database. What I have so far is: I load the shapefile with the 'Shapefile File input' step I use the ...
2
votes
3answers
3k 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 ...
0
votes
1answer
172 views

geotools oracle spatial plugin samples / documentation

I plan to use geotools and I saw that there is an oracle plugin available, but the documentation is not very detailed. Are there any examples or documentations available to access the functionality of ...
1
vote
2answers
2k 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
0answers
70 views

Allocate places according to distance

I've asked this over on Stack Overflow but thought that someone may have a GI point of view that may help: As an over-simplified example I have a list of events that have a maximum attendance: ...
4
votes
1answer
183 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 ...
3
votes
2answers
588 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 ...
2
votes
1answer
39 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
2answers
852 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 ...