Intelligent Geospatial Application with Oracle Spatial AI and Oracle APEX

-


%md
 # Import required libraries ( oraclesai )

%python

import pandas as pd
import matplotlib.pyplot as plt
from sklearn.preprocessing import StandardScaler
from oraclesai import (
    SpatialDataFrame,
    enable_geodataframes
)
from oraclesai.pipeline import SpatialPipeline
from oraclesai.clustering import AgglomerativeClustering
from oraclesai.weights import KNNWeightsDefinition
from oraclesai.vis import plot_clusters
enable_geodataframes(z)












Comments

Post a Comment

Popular posts from this blog

Installation of Oracle Database 23ai and APEX 24.2 and ORDS 24.4 on Windows Step-by-Step

-
Image
👀 Watch The below video in my YouTube channel about   Installation of Oracle Database 23ai and APEX 24.2 on Windows Step-by-Step  ✅ Before starting check the System Requirements: Operating System: Windows 10-11 or  Windows Server 19-22 Memory: At least 4 GB RAM (8 GB or more recommended). Disk Space: At least 20 GB of free space. Administrator Access: You need administrative privileges to install software.   Install  Oracle Database 23ai on Windows: 👀I suggest you watch this video on my YouTube channel about this article my_video step1: Download  Oracle Database 23ai from below Link https://www.oracle.com/database/free/get-started/ you can also see the Installation Guide for Microsoft Windows: https://docs.oracle.com/en/database/oracle/oracle-database/23/xeinw/index.html step 2: after unzipping downloaded files then click setup.exe step 3: This is mandatory to have at least one pluggable database in this step oracle start to configure LISTE...
Read more

Building an AI-Powered Resume Matching System Using Oracle APEX and 23ai Vector Search😎

-
Image
I am going to Develope an AI-powered Resume Match system using 23ai vector search in an Oracle APEX application to  to semantically compare project descriptions with personnel resumes. The system calculates and ranks the percentage of relevance between each project and candidate profile. During this process you will learn about Oracle AI Vector Search and Similarity Search   During this process, you'll gain hands-on experience with: Oracle AI Vector Search Semantic Similarity Search Integrating ONNX models Oracle APEX Interactive Reports and Charts 👀 In the video below on my YouTube  Channelhttps://www.youtube.com/@LidaGholizadeh_ORACLE_GIS , you can see the steps of Building an AI-Powered Resume Matching System Using Oracle APEX and 23ai Vector Search 🟎 Overview of Steps Before creating APEX app you need 2 steps as below : 1) Create an Oracle DB23ai on Oracle Cloud  Use Oracle Cloud Infrastructure (OCI) to create a 23ai-compatible Ora...
Read more

Configuration of ORDS: Standalone, Tomcat, and WebLogic on Windows Step-by-Step

-
Image
  If you did not install Oracle database 23ai and Apex24.2 you can first use the below link to install them and then back here to install and config ORDS. How we can Install APEX 24.2 and Oracle Database 23ai on Windows Step by Step: https://lidagholizadeh.blogspot.com/2025/03/install-oracle-database-23ai-and-apex.html 👀 Watch The below video in my YouTube channel about   Installation of Oracle Database 23ai and APEX 24.2 on Windows Step-by-Step  Why Do We Need ORDS for APEX? Oracle ORDS (Oracle REST Data Services) is a middle-tier application that enables RESTful web services for Oracle databases. It is essential for running Oracle APEX (Application Express) because APEX is a web-based application development platform that needs a web server to handle HTTP requests.We need it because APEX does not include a built-in web server.  It acts as a bridge between an Oracle Database and web applications, allowing developers to expose database objects  as RE...
Read more

Leveraging ONNX Models for AI Vector Search in Oracle Cloud Database 23ai

-
Image
Oracle 23ai supports ONNX LLM models.😘 In Oracle 23ai, one of the powerful features is  AI Vector Search , which enables semantic search on unstructured data such as text, images, and audio. Oracle supports using ONNX models to convert input data into dense vectors, which are then stored in  vector columns  for efficient similarity search. ❓ What is ONNX (Open Neural Network Exchange) ? It is an open format for representing machine learning and deep learning models. ❓ How Can we use ONNX model in Oracle Database? in the first step you should Import ONNX model in your Database. I am going to use Oracle Cloud and upload my ONNX model in the storage of my cloud. Step 1: Upload ONNX Model to Oracle Cloud Storage In Oracle Cloud storage>bucket Then Upload your onnx file you downloaded Step 2: Import the ONNX Model into Oracle Database Use the DBMS_VECTOR package to I mport the ONNX model: you need to create a credential and for this you need your username and password ...
Read more

Building a Fully Local AI-Powered Assistant with Oracle APEX and Vector Search #APEXCONN2025 #orclAPEX

-
Image
👩 : Falls Sie nicht müde sind  :-| 👨 : Ich bin immer müde, aber das ist okay :-) I recently attended the APEX Connect 2025 conference from Syntegris Company.  One of the presentations that strongly caught my attention focused on the development of a personal assistant powered by Artificial Intelligence (AI), which runs completely offline,  with no reliance on cloud services . This assistant was implemented using technologies such as Oracle Database 23ai , Vector Search , and the RAG (Retrieval-Augmented Generation) approach. It was designed to manage personal information, emails, calendar entries, and project data. 👀Watch this short Video about  #ApexConn2025    https://youtube.com/shorts/UQmwwTEsJuk?si=WJUXdJ4jvh1Nmsap The presenter highlighted the challenges of his life, such as: High volumes of daily emails  Multiple overlapping meetings Fragmented and scattered information He proposed a personal AI assistant that could : Filter emails and ext...
Read more

Create a Database in Oracle Cloud and Connect to it by Using SQL*Plus and SQL Developer

-
Image
How to Create a Database in Oracle Cloud and Connect to it by Using SQL*Plus and SQL Developer ❓ 👀 In the video below on my YouTube Channelhttps://www.youtube.com/@LidaGholizadeh_ORACLE_GIS , you can see the steps of creating a Database in Oracle Cloud and connecting using SQL*Plus and SQL Developer  👉Create an Autonomous Database in Oracle Cloud Login to http://cloud.oracle.com/         2. Navigate to Oracle Autonomous Database then  Click Create Autonomous Database .       3. Click Create Autonomous Database .        4. Download and Extract the Wallet In your Autonomous DB details page, click DB Connection . Select Instance Wallet . Click Download Wallet (you’ll need to enter a password for the zip file). Extract the contents to a known location,  C:\Wallet .          ✹ 5. unzip zip file and in sqlnet.ora and  change Directory to your wallet location ✹  Change ...
Read more

USING External REST API in Oracle APEX

-
Image
  In the previous article, I explained how to CREATE  a RESTful Web Services inside Oracle APEX. https://lidagholizadeh.blogspot.com/2025/08/all-about-restful-webservice-in-oracle.html In this article, we will focus on the opposite scenario: How to consume external REST APIs from Oracle APEX and PL/SQL. External API integration is one of the most common requirements in APEX applications. In this article I will explain all supported methods for calling external REST APIs in Oracle APEX: 1.  Calling REST APIs Using Web Source Modules 2.  Calling REST APIs  from PL/SQL Using APEX_WEB_SERVICE 3. Use Rest Data Sources in Our Application But first of all let me answer this question ❓ Where Can You Use Your Newly Created Web Source Module in Oracle APEX ❓ The short answer: Almost everywhere in APEX💖 As soon as you see the Source → Type property on a component and one of these options appears, you can directly plug in your external REST API (Web Source): Interactive...
Read more

BUILDING a RESTful Web Services in Oracle APEX

-
Image
❓What is a Web Service? A web service is a mechanism for sending and receiving data between two different systems over a network, commonly using HTTP. There are two main kinds of web services: RESTful : A lightweight, fast architectural style using HTTP verbs such as GET, POST, PUT, DELETE, typically exchanging JSON  or XML SOAP : An older and more formal standard-based web-service architecture, built on XML and often more complex in setup. *Tip: In the context of Oracle APEX we typically work with RESTful web services. ❓ API or REST Web Service? In everyday conversation, people sometimes use the terms API and REST web service interchangeably, but technically,  every REST Web Service is an API,but  not every API is REST Web Service. For example, a SOAP API or gRPC service uses a different architecture and may not revolve around HTTP or resources. they are not the same : API (Application Programming Interface) : A broad concept referring to a set of rule...
Read more

Oracle APEX Developers Are Saying Goodbye to the Old RESTful Services

-
Image
  Imagine you're deep in your Oracle APEX workspace, happily clicking away in SQL Workshop to tweak a REST API endpoint. Suddenly, a big red DEPRECATED banner stares back at you like an old friend who's overstayed their welcome !!! If you're still building or maintaining RESTful Services directly inside APEX's SQL Workshop, you're not alone ,but Oracle made it clear starting with ORDS 25.1: the classic RESTful Services interface in APEX is officially deprecated😐 SQL Developer Web 👀 , that's now the single source of truth for managing ORDS REST APIs. 👉 Creating the RESTful Service in SQL Developer  Web STEP1: STEP2: In SQL Developer Web, navigate to the "REST" .it is in hamburger menu and you can find it in below picture now you are here .look at below picture isn't familiar with you? we have all RESTFUL Service features now at the top of the page STEP3: let's create a restful webservice. Click on Module in the top menu and fill the propert...
Read more

JavaScript In Oracle APEX (Client Side)

-
Image
In this article, I want to discuss this question Where can  we use JavaScript in Oracle APEX  on the client side ? I recommend watching the video on my YouTube channel  ( www.youtube.com/@LidaGholizadeh_ORACLE_GIS )  for more details about this article! 1. Dynamic Actions Dynamic Actions in Oracle APEX support predefined JavaScript events, such as Click , Mouse Enter , and more.  You can also define Custom JavaScript Events for specialized use cases when you want to do something that predefined Events can not handle.To implement this type of Dynamic Action, you need to create  two separate Dynamic Actions : Defining the Custom Event Triggering the Custom Event  For Defining the Custom Event set the Event of DA to custom and   set a name for the Custom Event for example My_Custom_DA Here Selection Type  determines which elements or scope the custom event applies to and you have these option Item(s) : Triggered by one or more page it...
Read more