Questions tagged [oracle-spatial]

An extension that adds spatial operations to Oracle databases

Filter by
Sorted by
Tagged with
1
vote
2answers
1k 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?
1
vote
1answer
39 views

MapServer with Oracle-Spatial on Linux

On a SUSE System (SLES 15) I try to configure MapServer 7.4. with Oracle-Spatial support. Important: The Oracle Database is installed on another server. I wonder if I need also the Oracle ...
1
vote
1answer
50 views

Lines from Oracle Spatial Layer in QGIS are not completly visible

I connected a spatial layer from the Oracle database which contains lines (OracleDB objectclass typ is polyline) to be visible in QGIS. An example geometry is as follows: sdo_geometry(2002,2056,...
1
vote
2answers
538 views

Spatial index info does not appear in ALL_SDO_INDEX_INFO

I have a table with this definition: CREATE INDEX "MYSCHEMA"."MYTABLE_SX" ON "MYSCHEMA"."MYTABLE" ("GEOLOC") INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" PARALLEL 10 ; Geoloc It is a spatial column, but I ...
1
vote
2answers
993 views

Oracle SDO_UTIL.GETVERTICES returns more than 1 vertex

I'm using Oracle 12.1.0.2.0 and I am getting extrange results using sdo_util.getvertices. This query returns 2 "vertex" instead of one (as expected) SELECT T.x, T.y FROM TABLE( SDO_UTIL....
1
vote
1answer
415 views

Draw polygon from sdo.geometry with OpenLayers

I have some polygons in my oracle database, the column type is sdo.geometry, and I want to draw the polygon using OpenLayers. The problem is OpenLayers reads WKT type and I can't convert to this type,...
1
vote
1answer
140 views

sdo_aggr_union is not working

I have a table map_building_data and I create view all_incidents_unions CREATE OR REPLACE FORCE VIEW ALL_INCIDENTS_UNIONS ( ORA_GEOMETRY ) AS SELECT sdo_aggr_union (MDSYS.sdoaggrtype (ora_geometry,...
1
vote
3answers
3k views

Extracting Coordinates from Oracle Spatial Object Table using FME?

I've searched all available online sources but none appear to have this issue. I've added an Oracle Spatial Reader, connected to desired table and now want to extract x/y but I get this error when ...
1
vote
1answer
77 views

How to read oracle not spatial data using pyqgis

I'm working on a QGIS plugin. I'm trying to join a vector layer and a non-spatial table both in Oracle spatial. I add the vector layer to the map, but I can not add the table without geometry so i ...
1
vote
1answer
1k views

How to convert a compound geometry (Oracle) to a geometry made of straight line segments only?

I have an Oracle Spatial table containing compound geometries (i.e. geometries containing both straight lines segments and arcs) that I want to project in another reference system. Using SDO_CS....
1
vote
1answer
602 views

How geoserver calculates Native Bounding Box from Oracle Layer?

I need to know, how geoserver calculates Native Bounding Box & Lat/Lon Bounding Box. I am publishing a polygon layer from oracle spatial. In my case: Table Records: 7679477 Native Bounding Box:...
1
vote
2answers
1k views

SDE connection and multiple schema

I setup an sde connection for Oracle database, where multiple databases are sitting. All databases have same owner, sharing same password but identical user (e.g., BUI, EICU, FRNSW and LPI). While ...
1
vote
1answer
190 views

Best way to store raster data with Java into Oracle spatial

I have a Java application that processes raster data. At the end of the process I plan to store the raster in oracle spatial. What is the best way to do this? I had a look at geotools but I did not ...
1
vote
1answer
752 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 ...
1
vote
2answers
1k views

Plotting lat/long stored as text in Oracle DB using report builder/SSRS r2?

We use an Oracle 10g database. However we write reports using SSRS or report builder, using the Oracle connection type to the datbase. In oracle we have 2 text fields, one for lat and one for long. ...
1
vote
1answer
2k 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 (https://developers.arcgis.com/en/javascript/jssamples/#...
1
vote
2answers
3k 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 ...
1
vote
1answer
4k views

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

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

Is SDO_GEOM.RELATE returning erroneous results?

I believe I am getting some erroneous results when performing SDO_GEOM.RELATE with my spatial query. Given the following query: select SDO_GEOM.RELATE( MDSYS.SDO_GEOMETRY(2003, 4326, NULL, ...
1
vote
1answer
167 views

Error concatenating lines in Oracle Spatial

The function SDO_AGGR_CONCAT_LINES is returning an error when concatenating lines from a table with simple line geometries (SDO_GTYPE - 2002): ORA-29400: erro do cartridge de dados ORA-06502: PL/...
1
vote
4answers
1k views

Populating oracle sdo_geometry object using GeoJSON?

I have GeoJson data. I would like to convert this GeoJson data into sdo_geometry object type and insert Oracle spatial database. Which columns represent geojson data in oracle sdo_geometry object. ...
1
vote
1answer
76 views

Reproject vector layer in oracle or PosGIS without export!

I have some vector layers in Oracle and PostGIS, point, line and polygon, and i want to reproject those layer in a different projection but i don't want to export the projected layer, i want to do it ...
1
vote
1answer
208 views

MapInfo Styles in Oracle Spatial Database

I have geographic data in an Oracle database. The data was imported by EasyLoader, which is a MapInfo-Tool. I want to publish this data in a Web Map Service. I have tried to use MapServer, but I have ...
1
vote
1answer
143 views

request postgis to oracle sdo

My request in postgis : create table "schema1"."table1" as select p.field1 ,p.field2, l.field3, l.id from "schema1"."table2" p inner join "schema1"."table3" l on (p."GEOM" && l."GEOM" and ...
1
vote
1answer
291 views

QGIS doesn't display compound polygon (from a spatial oracle DB)

When I want to display the elements stored in a spatial oracle DB, the compound elements aren't display. There is no error message. The type of these compound elements is "1005". Are these elements ...
1
vote
1answer
265 views

SRIDs do not match for the two geometries in Oracle Spatial

I am trying to resolve where some points from Point Geometry lying outside the Polygon geometry. I want to filter those points which are lying outside the polygon geometry. I am getting error where ...
1
vote
1answer
231 views

Export Line Feature using ogr2ogr.

I am trying to export a line feature class from an oracle spatial database to a file geodatabase. I can export polygons with no problem, but cannot find the appropriate command '-nlt' for Line ...
1
vote
1answer
211 views

Edits in Oracle Spatial Layers

I have an Oracle spatial layer that is built on top of a multi table view. When I make a new feature in QGIS, I get an error when I attempt to the save the edit. When I look in the database and ...
1
vote
1answer
793 views

Add and edit Oracle Spatial Layer in QGIS

When I connect oracle layer are not enabled me all editing options. I can create and delete but not update. It is an issue of users? permissions or privileges? metadata? All works OK in AutoCADMap3D ...
1
vote
1answer
69 views

ArcMap 10.3.1 Editor Message: “A layer for PROJECT_LINES was not found…”

When editing a feature class stored in Oracle Spatial, I am receiving 3 warning messages upon stopping the edit session: There are 2 more after pressing OK - PROJECT_POINTS and PROJECT_POLYGONS. I ...
1
vote
1answer
226 views

Upgrading to ArcGIS 10.3 geodatabase on windows R2 SP2 and Oracle 10g (64 bit) 10.2.0.5?

We have Oracle 10g (64 bit) 10.2.0.5 on Windows Server 2008 Enterprise SP2, and we are planning to migrate our geodatabase from 9.3.1 to 10.3. As per Esri "Oracle database requirements for ArcGIS 10....
1
vote
1answer
4k views

Updating Oracle Spatial geometry column using SQL?

I am trying to update a table B geom column with the coordinates from table A. Table A having coordinates in two separate columns x and y. Table B to have the coordinates from Table A into Table B's ...
1
vote
1answer
638 views

How to disable spatial index creation by ArcSDE for Oracle Spatial

Working with ArcSDE 10.1 and Oracle spatial 11g. I set the feature class in load_only_io before loading shapefiles. I am using geoprocessing tool (append) in ArcGIS to load shapefile to geodatabase. ...
1
vote
1answer
93 views

Unable to read different kind of shapefiles

I have written the Java code to read the shapefile and insert it into the table. But the way I have written code it will accept only a multistring .shp file. It fails for other shapefile geometry ...
1
vote
1answer
61 views

Raster: how to locate cells having nodata [closed]

I am new to oracle spatial. I am using SDO_GEOR package's getNoData prcedure. the results are populated in following format. MDSYS.SDO_RANGE(MDSYS.SDO_RANGE(-32768,null)) My questions are: Is ...
1
vote
1answer
264 views

Connecting Oracle Linux database to AcGIS 10 on windows PC

I am wondering if anyone has tried to connect from ArcGIS 10, to an oracle database stored on a Linux server? I have no problems connecting to oracle from Arc when the data is stored on a windows box, ...
1
vote
1answer
541 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 ...
1
vote
1answer
96 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 ...
1
vote
1answer
1k 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 ...
1
vote
1answer
3k views

Merging non-contiguous polygons using Oracle Spatial union functions?

Is there any way of merging non contiguous polygons using the SDO_AGGR_UNION or a similar dissolve function? When i run the below query in oracle sql developer i managed to convert geometry type ...
1
vote
1answer
185 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 SDO_ORDINATE_ARRAY(6,...
1
vote
1answer
2k 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
3k views

Using Shapefile Converter in Oracle 12c to load 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 ...
1
vote
1answer
335 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 = @Earth.STArea()...
1
vote
1answer
99 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
699 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 ...
1
vote
1answer
539 views

Oracle MapViewer / Map Builder - Tile algorithm

Oracle MapBuilder generates three types of layers - theme, base and tiles. I try to create algorithm for tiled layers. Have you any idea how to decode this? I mean algorithm for width and height of ...
1
vote
1answer
250 views

Automating Mastermap update in Oracle Spatial?

I've been set a challenge which is a bit out of my comfort zone. I'm an esri developer trying to break into the open source world. I've been asked to automate the update of some oracle SDO datasets. ...
1
vote
1answer
35 views

ArcGIS Server Featurelayer: Error on adding features via JavaScript API after switch from Oracle db to PostGIS

We have a webapp which consumes services published on ArcGIS Server. All database relevant operations are done with ESRI ArcGIS abilities. We now switched from Oracle 11g to PostgreSQL 9.4 with ...
1
vote
0answers
20 views

Oracle to PostgreSQL migration with ogr2ogr only imports first geoloc column

I transfer Oracle tables to PostGIS using Oracle Wallet and ogr2ogr -f "PostgreSQL" PG:"host=<host> port=5432 user=<user> dbname=<dbname> password=<pwd>" OCI:<USERNAME>...