Stack Overflow
Stack Overflow

Questions tagged [oracle-spatial]

Oracle Spatial is an extension to Oracle DB which provides support for location data.

Oracle Spatial defines a new data type SDO_GEOMETRY which can store multi-dimensional geometry data. There is a new index type for this column which is required for almost all of new operations.

There are several new operators which operate on the spatial data.

SDO_WITHIN_DISTANCE

This function determines if two geometries are within a given distance.

SDO_NN

This function finds geometries within a specified distance.

SDO_RELATE

This function determines what geometric relationship two geometries have. Some examples of relationships are: Disjoint, Overlapping, and Touching.

275 questions
11
votes
1 answer

How do I change the SRID's for Oracle SDO_GEOMETRY

I have spatial data that Oracle has assigned an SRID of 81989. I'd like to change it to 27700 - they're both the same coordinate system, its just Oracle uses its own SRID; so no re-projection is necessary (as such SDO_CS.TRANSFORM doesn't work as it…
GIS-Jonathan
  • 4,347
  • 11
  • 31
  • 45
10
votes
1 answer

Hibernate spatial index annotation

I am using jts geometry object to store my geometry objects as an Oracle SDO_Geometry. However when I want to use SDO_GEOM.RELATE methods they are not working properly,I realized that I need to create a spatial index but dont know how to do with…
Merve Kaya
  • 111
  • 7
10
votes
4 answers

How to get lat and long from sdo_geometry in oracle

How can I get lat and long from point in oracle? Like this: MDSYS.SDO_GEOMETRY(2001,4326,NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,1), MDSYS.SDO_ORDINATE_ARRAY(51.702814,32.624736))
Banafshe Alipour
  • 1,041
  • 4
  • 12
  • 27
7
votes
2 answers

Oracle - Converting SDO_GEOMETRY to WKT?

I am very new to oracle spatial. I have a spatial table with one SDO_GEOMETRY column. After inserting POINT data in this table, I want to retrieve data in WKT format. Here is what I did: Inserting data - INSERT INTO new_test (name, geom) VALUES…
user8143879
6
votes
1 answer

Distance between two Point with Latitude & Longitude in oracle DB

I need to calculate Distance between two location through Pl SQL Query. I had tried some Qry but not getting it. for this we are using Query in SQL is as follows SELECT ROUND(geography::Point(cast('19.2806118' as float),cast('72.8757395' as float) ,…
Kamleshwer Purohit
  • 357
  • 2
  • 16
6
votes
1 answer

Hibernate Spatial Create Geometry object

I am developing an location app with oracle spatial in Java. I am using hibernate 4.0 spatial for orm layer. I am new in spatial and i couldn't find best practise for hibernate spatial. My database model following; CREATE TABLE SYSTEM.POI ( …
mertaksu
  • 535
  • 1
  • 9
  • 26
6
votes
1 answer

Can not use ORDER BY when creating materialized view with SDO geometry in Oracle 11g

I am using Oracle 11g 2.0.1.0 with Spatial and Oracle SQL Developer on the client. I have a table Places with primary key ID and a view Coordinates with tw columns: ID referencing a post in Places, and the SDO geometry Point. I want to create a…
Anders
  • 8,307
  • 9
  • 56
  • 88
5
votes
2 answers

Oracle PGX on Yarn - 404 on WebService

I'm running Yarn on Oracle BDA X7-2, specs: Cloudera Enterprise 5.14.3 Java 1.8.0_171 PGX 2.7.1 I'm trying to run PGX on Yarn following this manual: https://docs.oracle.com/cd/E56133_01/2.5.0/tutorials/yarn.html Managed to run the installation…
Samamba
  • 113
  • 9
5
votes
2 answers

How to reliably list and drop all spatial indexes in Oracle?

In my open-source database migration project Flyway, I have a feature that cleans all objects in the current database schema, without dropping the schema itself. The typical implementation works as follows: List all objects Generate drop…
Axel Fontaine
  • 34,542
  • 16
  • 106
  • 137
5
votes
1 answer

can not update user_sdo_geom_metadata when creating spatial database in oracle

i was using the oracle 11g and try to create a spatial database, i just copied the sample code from oracle document but when it comes to update the metadata part, it gave a duplicate entry error, and i tried delete from user_sdo_geom_metadata and it…
user2810081
  • 589
  • 1
  • 8
  • 27
5
votes
3 answers

How to move spatial data from Oracle to Postgres

Does anyone have a clear document on how to move Oracle Spatial data to Postgres (both Community version and Enterprise DB... Thanks
user236827
4
votes
4 answers

Oracle spatial search within distance

I have the following table Cities: ID(int),City(char),latitude(float),longitude(float). Now based on a user`s longitude(ex:44.8) and latitude(ex:46.3) I want to search for all the cities near him within 100 miles/KM. I have found some examples but…
ka_lin
  • 9,329
  • 6
  • 35
  • 56
4
votes
2 answers

wk buffer error when running .get_WKT Oracle Spatial function on SDO_GEOMETRY objects

My company runs Oracle 19 and we recently (October 25) installed the October Oracle quarterly patch. Since the patch was applied, I have been unable to run the .Get_WKT function without frequently experiencing the following error Runtime…
SeanGaff
  • 93
  • 11
4
votes
2 answers

Calculate distance between two lat long points in Oracle

I'm trying to calculate the distance between two lat long points in Oracle using SDO_GEOM Package. Most of the solutions I read on the internet suggests below query: select sdo_geom.sdo_distance( sdo_geometry(2001, 4326, sdo_point_type(40.0, 10.0,…
Para Kan
  • 121
  • 3
  • 12
4
votes
2 answers

OraclePropertyGraphDataLoader loadData from HDFS

I'm using Spark+Hive to build graphs and relations and export flat OPV/OPE files to HDFS, one OPV/OPE CSV per reducer. All our graph database is ready to be loaded on OPG/PGX for analytics an that worked like a charm. Now, we want to load those…
Samamba
  • 113
  • 9
1
2 3
…
18 19