How to detect Spatial feature usage?
By using all_sdo_geom_metadata view.
column spatial format a10;
SELECT DECODE(COUNT(*), 0, 'No', 'Yes') Spatial
FROM
( SELECT 1 FROM all_sdo_geom_metadata WHERE rownum = 1
);
Sample Output:-
Showing posts with label Oracle Spatial. Show all posts
Showing posts with label Oracle Spatial. Show all posts
Oracle Spatial Vs Oracle Locator
Oracle Locator do:-
- All geometric objects
- – Points, lines, polygons
- – 2D, 3D, 4D
- Indexing (quadtrees and r-trees)
- Spatial queries
- Proximity queries
- Distances
- Projections
Oracle Spatial do:-
- All Locator functionality
- Geometric Transformations
- Spatial Aggregations
- Linear referenced features, LRS, e.g. roads which store the distance along the road
- Network Modeling, such as road networks, allowing rapid calculation of shortest paths
- Topological relationships can be stored, such as this property boundary touches this neighbouring boundary.
- GeoRaster Storage of images such as satellite and aerial photography
- Geocoder that translates address data to coordinate, a routing engine for street directions
- Spatial Data Mining
- 3D Types (LIDAR, TINS)
- Web Services (WFS, CSW, OpenLS)
- Explicit coordinate transformations
What is Oracle Spatial?
Spatial database is an database that can process spatial data.
Spatial data, also known as geospatial data, is information about the locations and shapes of geographic features.
Most spatial databases allow representing simple geometric objects such as points, lines and polygons.
Some spatial databases handle more complex structures such as 3D objects, topological coverages, linear networks, and TINs.
Oracle Spatial is an option of the Oracle database that allows users to store and retrieve spatial data.
Some examples: population by state, sales by state, sites per state, etc.
Popular Spatial RDBMS:-
- Oracle Spatial
- Microsoft SQL Server
- PostgreSQL with PostGIS
- IBM DB2 Spatial Extender
History and architecture
Licensing
Oracle locator is available with all Editions that provides core location functionality.Oracle Spatial is only available with Oracle Enterprise Edition as a separately licensed option that provides advanced spatial features to support high-end GIS and Location Based System solutions.
