I’m guessing that sdo_geometry would allow me to calculate distance between two lat/long pairs - easy. But I have no idea how I would calculate the driving distance on roads. Have seen something in Spatial Studio. But wanted similar in OAS.
Hi Peacey,
We will introduce direct support for SDO.Geometry in OAS starting with the next release in OAS 2025. This means, you can visualize Geometry columns with SDO.Geometry datatype, and supports Spatial Calculations for a geometry column or between two geometry columns. It also comes with a specific Spatial function to calculate distance between two geometry columns.
Let me give you a glimpse of this feature, which is already available in preview mode for OAC now (and will be available in the next release of OAS in 2025)
The spatial function GeometryDistance calculates the distance between the columns StartPoint and EndPoint based on coordinates and it does not consider road networks or travel paths. (above Screenshot is from OAC 8.1 November release)
Now, today, If you are specifically looking for calculating the distance/time based on a shortest distance or shortest time, spatial studio will let you calculate it and capture it to the database.
In the above screenshot, we have used the 'Driving Route' analysis function within Spatial Studio to create the calculated spatial measurements for DRIVE_DISTANCE and DRIVE_TIME based on pin on the map (you can also directly input longitude and latitude for a specific location to use as input in the calculation)
You can create a dataset to the table that has calculated the distance and time through spatial studio, and expose the numbers in Oracle Analytics directly by connecting to it.
There are also new spatial functions available in Autonomous Database that can calculate the distance based on routing, as mentioned here : https://docs.oracle.com/en/database/oracle/oracle-database/23/spatl/sdo_gcdr-package-geocoding.html
(Refer the function SDO_GCDR.ELOC_ROUTE_DISTANCE , but this function is available only with an Autonomous Database Serverless deployments)
Note :
If you like to know more about direct geometry support in OAC now, see the following videos :
https://www.youtube.com/watch?v=8hiERGcx8vU (Visualizing Geometry Data Type)
https://www.youtube.com/watch?v=Lz4TGatf-mc (Spatial Calculations)
This feature will be part of OAS 2025.
Regards,
Gautam.
Many thanks for your reply. Fine with this - looking forward to OAS2025
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
Once I select that value from the list box Region I created, I want to filter the table by my selection. See the images
Hi, While using OAS or OAC latest version can we generate a report to view complete defition of semantic model/subject area. It helps to document and troubleshoot. thanks
