Open Format
With Oracle Spatial, users through out your enterprise can benefit from location-based data without having to be GIS experts. Using Oracle Spatial, GIS data can be integrated with external data at a database level using standard views rather than having to create complicated services or applications to read the data from a proprietary storage format.
Softwhere Solutions can integrate your Oracle Spatial database with other databases to create new spatially-enabled views of your previously tabular data.
GIS Operations With SQL
Rather than performing multiple-step buffers and selection sets with your desktop GIS,
you can perform GIS operations directly in a single SQL statement. For example, to find the 5 customers nearest to a warehouse, you would execute the SQL statement.
SELECT /*+ORDERED*/
C.CUSTOMER_ID,
C.CUST_FIRST_NAME,
C.CUST_LAST_NAME,
SDO_NN_DISTANCE (1) DISTANCE
FROM WAREHOUSES W,
CUSTOMERS C
WHERE W.WAREHOUSE_ID = 2
AND SDO_NN (C.CUST_GEO_LOCATION, W.WH_GEO_LOCATION, 'SDO_NUM_RES=5', 1) = 'TRUE'
ORDER BY DISTANCE;
| CUSTOMER_ID |
CUST_FIRST_NAME |
CUST_LAST_NAME |
DISTANCE |
| ----------- |
------------------- |
------------------- |
---------- |
| 258 |
Ellen |
Palin |
2341418.86 |
| 255 |
Brooke |
Shepherd |
2353370.47 |
| 254 |
Bruce |
Bates |
2356071.22 |
| 140 |
Claudia |
Kurosawa |
2356686.58 |
| 169 |
Dheeraj |
Davis |
2502955.93 |
Softwhere Solutions has certified Oracle Database Professionals (ODP) on staff to assist with your Oracle Spatial databases.