Questions tagged [oracle-spatial]

An extension that adds spatial operations to Oracle databases

Filter by
Sorted by
Tagged with
2
votes
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,...
15
votes
4answers
31k 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 ...
3
votes
1answer
3k 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
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 ...
3
votes
4answers
4k 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 ...
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
2answers
1k 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 ...
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 ...
4
votes
1answer
1k 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 ...
2
votes
1answer
2k views

Checking for overlapping polygons in Oracle Spatial?

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
3answers
1k 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
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 ...
2
votes
2answers
227 views

Persistence in QGIS under Oracle workspace

I'm using QGIS 2.18.9 to edit my spatial data, my data is saved in Oracle's database. When I'm editing a spatial layer I can create, edit and delete features without problems, but my database needs ...
2
votes
1answer
950 views

Loading Oracle Spatial Layers in standalone python qgis

I used below script to connect to postgres and load layers successfully.I want to aceive this using Oracle Spatial for both vector and raster loading.How can I achieve that?In other words what is the ...
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 ...
0
votes
0answers
136 views

Saving to database on OpenLayers map changes? [duplicate]

I have put a map on website using OpenLayers. This map is fetched from geoserver by using wms request. and in the same way, it is drawn some shapes such as point, line etc. using open layers library ...