Questions tagged [oracle-spatial]

Use for questions about the Spatial or Locator extensions to the Oracle DBMS

Filter by
Sorted by
Tagged with
2
votes
1answer
1k 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
3answers
1k 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 ...
1
vote
3answers
9k views

Loading shapefile in Oracle Spatial?

I am new 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 http://docs.oracle.com/cd/E11882_01/appdev....
1
vote
2answers
962 views

Why using multiversioned views?

I don't see the reason why multiversioned views exist. It's not possible to use joins like in normal views. And editing versions is possible by directly using the feature class itself. So when am I ...
1
vote
1answer
3k views

ST_GEOMETRY to SDO_GEOMETRY

Is it possible for QGIS to read ESRI ST_GEOMETRY in an Oracle database? The ESRI geometry type looks like this: SDE.ST_GEOMETRY(260,61,491455.9942,5456922.8891,492388.3189,5457507.9101,NULL,NULL,NULL,...
1
vote
1answer
1k 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
1answer
105 views

What is mapinfo precision on coordinates

I have some roads on Mapinfo and looks OK, all nodes seem connected at 0.01 m Zoom. If you try to export it to mid/mif you can see the same coordinates (-63.869036 11.039044)on all 3 lines. Line -63....
1
vote
2answers
726 views

SDO_GEOMETRY view in ArcGIS Desktop

I have an sdo_geometry table that I created using ArcGIS Desktop (by converting an esri.st_geometry table to sdo_geometry). I'm using Oracle Spatial's sdo_geometry datatype because it has linear ...
1
vote
1answer
853 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
372 views

How can I load sqlite file into oracle 11g?

I have SQLite file which I have taken it from Sptialite DB. I need to convert this file into SDO. Plz help me
1
vote
1answer
713 views

Editing ArcSDE Oracle spatial view

Can you 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 ...
1
vote
1answer
48 views

How to find nearest neighbor in Oracle's ST_GEOMETRY?

I am trying to find nearest road segment to a point in Oracle. I can do this with SDO_GEOMETRY type i.e select /*+ LEADING(pois) INDEX(route ALL_ROUTES_SPTAIL_INDEX) */ route.* from DEVICE_STATUS ...
1
vote
1answer
80 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
127 views

SDO Oracle Table not recognized as Geometry in QGIS

I can connect to the Oracle Database with QGIS but spatial table/layers are not recognized as such. I have read the following in the QGIS documentation: Normally, an Oracle Spatial layer is ...
1
vote
1answer
66 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
735 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
1k 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
478 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
154 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
78 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
2answers
299 views

Connecting QGIS to Esri Enterprise Geodatabase of type Oracle Spatial

I have an Esri Enterprise Geodatabase (ArcSDE 10.2.2; Oracle 10G). I am trying to connect it with QGIS 2.16. So I clicked "Add vector layer" button with "Database" Type : Oracle Spatial (I've tried ...
1
vote
1answer
1k views

Registering database Arcgis 10.2.2?

When I registered a database data store to ArcGIS Server in ArcCatalog, the following error occurs: Underlying DBMS error[ORA-12154: TNS:could not resolve the connect identifier specified No ...
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
632 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
460 views

Seeing basemap created by Oracle map builder in database

I am new in oracle, I tried to create a style, then different themes and then a base map. I saved all my work, but I can't see the base map in the database. Did I miss something? The interesting ...
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
778 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
3k views

ArcSDE - Creating new install on new database with existing SDE schema

I asked a question before, but was probably not specific enough, so didn't get the information I required. My fault completely. I am creating a new sde instance on a server. This needs to be pointed ...
1
vote
1answer
41 views

SDO_JOIN conversion to PostGIS

I make refactoring from Oracle to PostGIS and I found out that PostGIS doesn't support sdo_join. How should I correct the statement below? SELECT e.ID AS EDGE1_ID, u.NODE_ID AS ...
1
vote
1answer
74 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
229 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
2k 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
90 views

Reproject vector layer in oracle or PostGIS 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
234 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
157 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
2answers
346 views

CreateEnterpriseGeodatabase Oracle Error

Executing: CreateEnterpriseGeodatabase Oracle \localhost\orcl # DATABASE_AUTH sys ***** SDE_SCHEMA sde ***** # C:\Users\Med\Desktop\ags103.ecp Start Time: Wed Sep 21 09:45:00 2016 User does not ...
1
vote
1answer
297 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
251 views

Calculating all possible lat & long

I am new to GIA domain. I am trying to learn new concepts around mapping etc and this is my first app/implementation. I am trying to implement a store locator kind of function. I am thinking to ...
1
vote
1answer
178 views

Deleting features with arcpy on ArcGis SDE 10.0 SP5

I am new to ArcGIS and arcpy and am learning largely through trial and error. Anyway, the overall task is to delete, edit and add rows to feature classes. I thought it would be good to start with ...
1
vote
1answer
303 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
240 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
231 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
207 views

Esri ArcSDE 10.3.1 Query Inspire Metadata from Oracle (11g) Enterprise GeoDB via SQL

As the title says - I want to create a query in Oracle SQL which will read all dates from the geoprocessing history which can be found using ArcCatalog to show the "Description"-tab from a feature. (...
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 ...