Spatial Database

Oracle's spatial database is included in Oracle's converged database, allowing developers and analysts to get started easily with location intelligence analytics and mapping services. It enables Geographic Information System (GIS) professionals to successfully deploy advanced geospatial applications. Organizations can manage different types of geospatial data, perform hundreds of spatial analytic operations, and use interactive map visualization tools with the spatial features in Oracle Autonomous Database and Oracle Database.

Oracle’s location and spatial platform delivers enterprise scalability, security, and performance to power the most demanding applications in Oracle Cloud Infrastructure and on-premises.

How NIBIO is fostering more sustainable forests using innovative sensors, Oracle Cloud Infrastructure, and AI (3:20)
Oracle Database 23ai 正式推出:為資料注入 AI 技術

聽 Larry Ellison 和 Juan Loaiza 分享 Oracle Database 23ai 的 GenAI 策略。

Overview of Oracle’s spatial database

See how location intelligence data helps build smarter businesses.

Get started with spatial—without coding

Explore geospatial data and integrate location intelligence into your apps with a no-code mapping tool, Spatial Studio.

New built-in geocoding API in Autonomous Database

Adding location intelligence to your apps and analytics just got easier with the new geocoding API in Autonomous Database. It converts your address data into geographic coordinates without purchasing separate reference data.

Spatial vector tiles and H3 support in Oracle Database 23ai

Generate vector tiles via an in-database function and stream them for scalable, flexible maps within your apps. In addition, create compelling, easy-to-use visuals via hexagonal hierarchical spatial indexing (H3).

Spatial database and geospatial technologies

Comprehensive spatial, mapping, and location analytics platform that addresses business-critical requirements across industries, including transportation, utilities, retail, energy, public sector, defense, construction, and more. Learn more about Oracle Spatial features in Oracle Database (PDF).

2D spatial data

Store and query 2D spatial geometries in Oracle Database, such as points of interest, streets, administrative boundaries. Perform queries based on proximity (how far is it?) and containment (is it inside a region?). Access hundreds of functions to filter data, measure distance relationships, and combine/transform geometries.

3D Point Cloud data and Light Detection and Ranging (LiDAR)

Manage spatial sensor data from laser scanning or photogrammetry, for use in enterprise 3D geographic information system (GIS) and Smart City applications. The 3D support is optimized for point cloud and CityGML workflows.

Raster data

Store and process geo-referenced raster data, such as orthophotos, satellite imagery, and gridded data for energy, natural resource management, or national security applications. Perform powerful raster analytics and on-the-fly image processing, with virtual mosaics and an easy-to-use loading tool supporting popular data formats.

Network data

Model road transportation, telco, utility, energy, and other networks and analyze this complex data for shortest path, nearest neighbor, within cost, and reachability.

Topology data

Manage topology data used by mapping and land management organizations with fine-grained feature editing and data integrity across maps and map layers for very large land parcel datasets with high consistency and accuracy.

Streaming point data

Track millions of moving objects against thousands of regions of interest, for logistics and IoT applications. Analyze locations of moving people for the purpose of contact tracing using a scalable, automatic API.

Spatial Studio application

Use Oracle Spatial Studio, a self-service application, to create interactive maps and perform spatial analysis on business data quickly and easily. Users can visualize, explore, and analyze geospatial data stored in and managed by Oracle in the cloud or on-premises.

Analyst support

Easy access to spatial analysis operations with minimal coding. Users can create projects with datasets from multiple sources, create and configure visualizations, perform spatial analysis operations, and publish results.

Developer support

Users can access Spatial Studio features via REST API, embed visualizations in other applications such as Oracle Analytics Cloud, and access spatial analysis SQL.

Data integration and enrichment

Access content from Oracle Database, including uploaded data from spreadsheets, GeoJSON, and shapefiles. This data can be enriched through geocoding and creating latitude/longitude indexes. In-addition they also have access to background mapping services.

Popular languages and frameworks

Use SQL, PL/SQL, Java, Python, JavaScript, Oracle Jet, Node.js, JSON, or REST to add spatial analysis and maps to applications. Develop applications using environment of choice – without having to learn new languages.

Oracle developer tools

Use spatial and location features directly from popular tools available with Oracle Database and Autonomous Database —such as APEX, SQL Developer, SQL Developer Web, and Visual Builder for faster development cycles.

Enrich data

Enhance data with spatial attributes such as address geocoding and place names for downstream analytics. Unlock the location component hidden in less structured data, to combine with other data, and perform spatial and text analysis.

Enable modern map data delivery with vector tiles and H3

Add maps to web clients directly from Oracle Database using vector tiles. Efficiently stream large amounts of spatial data from the database to the client with a simple SQL call. Vector tiles enable dynamic styling, fast performance, smooth map interactions, and dynamic map queries.

For large amounts of dense point data, hexagons are useful for map visualization, data summarization, and pattern discovery. Use hexagonal hierarchical spatial indexing (H3) to create hexagonal cells and data aggregation within the database, then use vector tiles for data streaming and map visualizations.

Contact tracing APIs

Easily analyze location of moving objects for pair-wise interactions in contact tracing applications using a scalable, automatic API in Oracle Database.

Support GIS and open-source tools

Use Oracle’s spatial data management layer with popular GIS software, open-source tools, and map visualization components providing users with a wide choice of applications.

Map visualization of geographic data

Use WebGL and HTML5 JavaScript APIs to add highly interactive maps and spatial analysis into business applications. Combine application content with maps and data from a variety of web services and data formats to create richer mapping applications.

Geocoding and reverse geocoding

Enrich existing address and location information from relational tables (customer addresses, site locations) with latitude/longitude as the first step for building location intelligence applications. Use geocoding API in Autonomous Database to convert address data into geocoding coordinates without obtaining separate reference data.

Routing engine

Generate driving distances, times, and directions between locations and perform calculations such as fastest or shortest routes or traveling salesperson for logistics, delivery, and retail applications.

Open Geospatial Consortium web services

Publish spatial data and interoperate with a wide range of commercial, open source, or custom data sources and applications, with support for standard OGC Web Feature Services, Web Coverage Service, and Catalog Services to deploy and administer distributed spatial services.

Scalability and performance

Power the most demanding, large scale spatial applications and location intelligence workloads in the cloud and on-premises with dramatically fast spatial index and query performance, Oracle Exadata integration, and support for database features such as partitioning, distributed transactions, and sharding.

Secure spatial data reliably

Gain enterprise grade sophisticated, multilevel access control for fine-grained end-to-end security of spatial data.

Autonomous capabilities

Reduce operational costs while providing workload-optimization with Oracle Autonomous Database self-driving, self-securing, and self-repairing capabilities.

Align with global standards

Alignment with applicable ISO and OGC standards for spatial data and mapping services for interoperability.

SATLOG modernizes fleet management with Oracle Spatial

SATLOG provides near real-time vehicle location, tour planning, and route optimization with Oracle Spatial, increasing fleet productivity.

Certegy fights payment fraud using Oracle’s geospatial database

Certegy uses maps to visually track fraudulent behavior patterns and location of an individual across cities and states using Oracle Spatial.

Propre speeds big data insights for growth with Oracle Spatial

Spatial analysis integrates geographic and location data so Propre can enhance real estate insights and deploy new services faster across industries.

Finland’s COVID-19 app uses Oracle Spatial to support local community

Finland’s COVID-19 exposure-tracking application uses Oracle Spatial to monitor exposures and control spread by contact tracing.

Archeological Park of Pompeii successfully reopens after COVID, enabled by spatial analytics in Oracle Database

Visitors touring the park can view a real-time heat map enabled by spatial analytics in Oracle Database showing the number of other visitors present along any route.

Neustar improves customer engagement with Oracle in-database spatial features

Neustar’s ElementOne platform uses Oracle Spatial to provide its retailer clients with sophisticated analytics and predictive modeling capabilities. This gives retailers real-time insights into the effectiveness of their marketing programs and store siting plans, resulting in improved consumer satisfaction.

Aegea speeds data analytics with Oracle Spatial

Aegea has a faster billing environment with Oracle Spatial for georeferencing and network mapping.

Oracle helps Toyota Mapmaster to accelerate digital transformation in map production

Geospatial intelligence use cases

  • Public sector

    Governing entities can analyze national or local datasets for digital battlefield and surveillance, contact tracing, crime mapping, predictive policing, and emergency services.

    Countries and cities gain efficiency by managing large and complex land registry and mapping, agricultural, 3D city modeling and planning, hydrographic map production, and meteorological data.

    Read customer use case

  • Telco and utilities

    Companies increase competitiveness by efficiently analyzing outages and effectively planning field services.

    Help in mobile network planning, utilities facilities management to optimize cell tower placement, maintenance workflows, and reduce costs.

  • Transportation and logistics

    Improve operational efficiency by processing large volumes of complex heterogenous spatial data for maintaining railway assets, airport assets, air traffic, long-haul trucking, and parcel delivery.

    Watch customer story (1:48)

  • Engineering and construction

    Companies can combine GIS and CAD systems for building information modeling (BIM) and facilities management, connecting workflows, eliminating data silos, and providing location context.

  • Retail

    Enhance customer experience with targeted marketing, site planning, indoor customer flow with location intelligence.

    Read customer use case

  • Financial and insurance services

    Discover risk zones and other patterns based on customer location data analysis and customize offers based on this intelligence.

    Read customer use case

  • Healthcare

    Improve planning care while tracking disease outbreak patterns, epicenters, exposures, and environmental impact based on location.

    Read the customer story

February 13, 2024

Make better Machine Learning predictions with spatial algorithms

David Lapp, Senior Principal Product Manager, Oracle

Including spatial algorithms in your machine learning (ML) workflow provides advantages for detecting patterns and predicting outcomes, leading to better decision-making for the business. Discover why incorporating location in your ML model is important and get an overview of an enhancement to Oracle Machine Learning for Python that leverages the native spatial features of Autonomous Database.

Featured Oracle Spatial Database blogs

View all

Spatial related products and solutions

Oracle Autonomous Database

Self-driving database

Oracle Database

World’s leading database management system

Oracle Analytics Cloud

Comprehensive Analytics in the cloud

Oracle Machine Learning

Build machine learning models in the database

Get started with Oracle Spatial Database

Try Spatial Studio

Install and get started today.

Try Oracle Cloud Free Tier

Oracle’s Spatial technology is included free of charge.