288 questions
2
votes
1
answer
126
views
Create Function Based Oracle Spatial Index without Data
Summary
I need to create a function based spatial index on Oracle 19c.
The table contains no data, when the index should be created.
This fails with ORA-13199.
MRE
My code is:
-- create table
create ...
- 1,070
1
vote
1
answer
67
views
Puzzling behaviour with SDO_RELATE contains
While upgrading the Oracle CI stack for GeoTools (https://github.com/geotools/geotools/pull/5121) updating from 18.4.XE to 21.3 XE and 23.7 Free I've run into some puzzling behaviour with a testcase ...
- 105
0
votes
1
answer
70
views
How to find following lines in a bunch of lines?
I have a bunch of lines (type 2002) - some are crossing, some are "somewhere", some where touching another line somewhere, - and some are the continuation of another line.
So I have to find ...
0
votes
1
answer
172
views
HOW CONVERT NULL SDO_GEOMETRY field with SDO_UTIL.FROM_WKTGEOMETRY
I don't know If anyone has had this problem. I'm using Datastage sw to read an Oracle table with fields SDO_GEOMETRY and write another table with these fields.
I'm using the package SDO_UTIL and ...
0
votes
2
answers
204
views
How to save latitude and longitude into a string
how can i save latitude and longitude values in a string?
We have multiple latitude and longitude points in a table, like this
Latitude(Number) Longitude(Number)
row1 55.868615380148015 9....
- 9
1
vote
1
answer
148
views
I need my query to run faster, and I don't understand why it's doing a table scan
I'm struggling with how to improve my queries. Here's the scenario.
I have to report on bus promptness. I have bus positions, in the table bus_dynamic_history. I have bus journeys, in table ...
- 11
0
votes
1
answer
33
views
Oracle Spatial Studio, No Datasource from Data Base
Some know why i cant see my DB connection when i try tyo create a dataset from de DB
enter image description here exmaple
find someone with the same issue, i try to resintall evereything where i ...
0
votes
1
answer
79
views
gps lati and long with/without dot
i am new here and i try to find help. I have a big database with 80000 gps records.
BUT ther are 10000 with dot (50.1234) and 70000 without the dot in the latitude and longtitude, like this 501234.
I ...
- 9
0
votes
2
answers
320
views
Oracle throwing "too many arguments for function" when using Oracle Spatial DB (MDSYS.SDO_GEOMETRY)
I'm trying to insert some polygons using MDSYS.SDO_GEOMETRY, but I'm getting the error "too many arguments for function", I did a simple test, because I suspected there was a limit of ...
0
votes
1
answer
302
views
How to select an MDSYS. SDO_GEOMETRY with more than 1 polygon?
I have the following MDYS object. SDO_GEOMETRY with 2 polygons:
MDSYS.SDO_GEOMETRY(
2003,
32723,
NULL,
MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1,11,1003,1),
MDSYS.SDO_ORDINATE_ARRAY(
-47....
0
votes
1
answer
225
views
Oracle Spatial sdo_aggr_union filling inner rings
While trying to perform an aggregation over a number of shapes which include inner rings (i.e. holes; see example pictures) I used sdo_aggr_union() from Oracle Spatial (12c), and realized that this ...
- 93
0
votes
1
answer
306
views
Python dynamic processing of Oracle SDO_GEOMETRY objects
There are some situations where the WKT format does not work (3D,4D geometries, arc in a geodetic).
These are handled in Postgis EWKT format.
I have an out converter
def SDOOutConverter(DBobj):
...
- 1
0
votes
1
answer
106
views
Oracle Apex - Convert WKT geometries to Shapefile format
I wanted to add to my application using Oracle APEX, the functionality of downloading spatial geometries in files in the "KML, GeoJSON and Shapefile (.shp)" format. With Oracle properties I ...
- 27
0
votes
0
answers
1k
views
Unable to create spatial index due to ORA-29855 with nested ORA-13203:failed to read USER_SDO_GEOM_METADATA view
I'm new to Oracle Spatial and I've been having some issues with creating a spatial index in Oracle Database 19c. When trying to create the index I keep getting:
SQL Error [29855] [99999]: ORA-29855: ...
- 1
1
vote
1
answer
118
views
How to write a PGQL query that matches to vertices with an unknown number of hops between them?
I have a relation database schema like:
DDL
CREATE TABLE Persons
(
Name VARCHAR2(100) NOT NULL,
CONSTRAINT Persons_PK PRIMARY KEY (Name)
);
CREATE TABLE Groups
(
Name VARCHAR2(100),
CONSTRAINT ...
- 41