GeoCitiX is a project that demonstrates the usage of Oracle Database, PL/SQL, and spatial data to store and calculate distances between cities using GPS coordinates.
This project showcases how to store and work with city coordinates in an Oracle Database using PL/SQL. It provides a table structure to store city names and their corresponding GPS coordinates. Additionally, it includes a PL/SQL procedure to calculate the distances between cities using the spatial capabilities of Oracle Database.
To use this project, you need the following prerequisites:
- Oracle Database (version 21.3.0.0.0 or higher)
- Oracle SQLDeveloper or another SQL client
- Clone the repository:
git clone https://github.com/McRafee/GeoCitiX.git
Connect to your Oracle Database using SQLDeveloper or another SQL client.
Execute the city_coordinates.sql file to create the necessary table and insert sample data.
To calculate the distances between cities, you can execute the CalculateCityDistance procedure. Here's an example of how to use it:
BEGIN
CalculateCityDistance('Valletta');
END;
Replace 'Valletta' with the name of the desired starting city.
This project is licensed under the MIT License.