Oracle Spatial: What's New in Oracle Database 23c?

November 27, 2023 | 4 minute read
Ramu Murakami Gutierrez
Product Manager
Text Size 100%:

It has been a couple of months since we announced the new release of Oracle Database 23c, which brings innovative features that simplify the development of modern data-driven applications.

Oracle Spatial provides geospatial capabilities that are included in every Oracle Database on-premises and in the Cloud, including Autonomous Database. Whether you have analytics projects that you want to enhance with location intelligence and maps – or if you are working with geospatial data such as 3D LiDAR point clouds and satellite imagery, Oracle Spatial provides a comprehensive platform and tools for your spatial needs. 

Oracle has provided enterprise geospatial data management for decades, from transportation, mapping agencies, energy, construction, and engineering.

The new features in Oracle Spatial for Oracle Database 23c focus on three main areas.  

 

1. Ease of use – We’ve made the syntax more intuitive and simplified for spatial data. For example, now you can use human-readable constants instead of numeric codes for the most commonly used geometry types and coordinate systems. Using spatial indexes has also gotten easier. Previously, before creating an index, you had to insert the required metadata manually. Now, that metadata is created automatically. This makes it very convenient to operationalize the indexing processLearn more here.

 

Working with longitude/latitude geometries

Before 23c:

INSERT INTO lon_lat_points
VALUES(
    'sample geometry',
    SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE(-73.45, 45.2, null) null, null));

 

New in 23c:

INSERT INTO lon_lat_points
Values(
    'sample geometry',
    SDO_GEOMETRY(-73.45, 45.2));

 

Spatial index creation

Before 23c: 

INSERT INTO user_sdo_geom_metadata
VALUES(
    'lon_lat_points',
    'geometry',
    SDO_DIM_ARRAY(SDO_DIM_ELEMENT('lon', -180, 180, 0.05),
                  SDO_DIM_ELEMENT('lat', -90, 90, 0.05)), 4326);

CREATE INDEX lon_lat_sidx
ON lon_lat_points(geometry)
INDEXTYPE IS mdsys.spatial_index_v2;

 

New in 23c:

CREATE INDEX lon_lat_points_sidx
ON lon_lat_points(geometry)
INDEXTYPES IS mdsys.spatial_index_v2;

 

Define Geometries

Before 23c:

INSERT INTO my_data
VALUES(
    'sample_geometry',
    SDO_GEOMETRY(
     2002, 
     4326, 
     null, 
     SDO_ELEMENT_INFO_ARRAY(1, 2, 1),
     SDO_ORDINATE_ARRAY( -73.45, 45.2, -73.56, 45.42))
);

 

New in 23c:

INSERT INTO my_data
VALUES(
    'sample_geometry',
    SDO_GEOMETRY(
     SDO_LINESTRING2D, 
     SDO_LONLAT, 
     null, 
     SDO_ELEM_INFO_ARRAY(1, 2, 1),
     SDO_ORDINATE_ARRAY(-73.45, 45.2, -73.56, 45.42))
);

 

2. Developer features – We’ve added a REST API for raster data, supporting flexible, scalable web and cloud services development. Raster data includes georeferenced imagery and gridded data, and can be used to represent continuous features such as elevation and  temperature. We provide hundreds of algorithms in the database to process raw imagery data and produce raster data for use in applications and business processes. Previously, working with raster data required coding with PL/SQL or Java APIs. We now offer programmatic access to all this functionality through a REST interface. An OCI marketplace image is also available for easy deployment. Learn more here.

 

                                                         raster-data-spatial

 

3. Enhanced support for 3D data  – Using LiDAR technologies, vast amounts of 3D data are generated and used to create point clouds representing city models and detailed digital twins for engineering and planning projects. We have supported 3D point cloud data types in the database for many years. In Oracle Database 23c, we have added valuable functions for working with and analyzing point clouds. You can now detect changes between point clouds captured at different times and compute 2D cross-sections on point clouds to get outlines and measurements of objects like buildings, construction sites, roads, and waterways. And new 3D mesh support lets you create highly textured, accurate surfaces, useful for realistic visualizations of objects that have irregular characteristics. Learn more here.

                       point-cloud

In addition to Database 23c, the latest Spatial Studio release includes enhancements covering custom symbol imports, animation of historical data, and embedding maps in your web application. Learn more about these, and other, enhancements here.

Also, for developers, we recently added a geocoding API in Oracle Autonomous Database. ADB-Serverless now includes a SQL function for geocoding your business data – so you can visualize it on maps and perform location analysis. Geocoding converts your address information to longitude/latitude coordinates. Now, you can do this right from SQL as an operation in the database. You don’t need to deploy additional applications or manage a geocoding reference dataset. This is a powerful and easy way to seamlessly blend geocoding into your database applications. You can learn more about these capabilities using this link.

Some resources for you to learn more

We hope you enjoy the new Oracle Spatial features included in the latest release with Oracle Database 23c!

Ramu Murakami Gutierrez

Product Manager

I am a Product Manager for Spatial and Graph. In my free time I enjoy traveling, discovering new restaurants, and going to the beach!


Previous Post

Architecting Hyper-Scalable Infrastructure for AI and ML-Driven Fintech with Oracle’s Globally Distributed Database

Deeksha Sehgal | 9 min read

Next Post


Migrating to the Autonomous Database - Dedicated using Database Links

Tejus Subrahmanya | 4 min read