SpatialDB Advisor
Simon Greener, Independent GeoSpatial Solutions Architect
(ABN 90 970 658 939)
(ABN 90 970 658 939)
Current Oracle Spatial Blogs
Converting distances and units of measure in Oracle Locator
Generating multi-points from single point records in Oracle Spatial
Multi-Centroid Shootout
Oracle Locator vs Oracle Spatial: A Reflection on Oracle Licensing of the SDO_GEOM Package
Oracle Spatial Centroid Shootout
Oracle Spatial Forum - Melbourne April 2007
Oracle Spatial Mapping and Map Rendering Performance Tips
Oracle's SQL/MM Compliant Types
Spatial Pipelining
Split Sdo_Geometry Linestring at a known point
The significance of sdo_lb/sdo_ub in USER_SDO_GEOM_METDATA: Do I need it?
Tip #2: layer_gtypes for spatial indexes
Tip #3: Generating sample (test) point data
Tip #4: Loading Shapefiles (SHP) into Oracle Spatial
Tip #5: FAST REFRESHing of Oracle Materialized Views containing Sdo_Geometry columns
Tip #6: Unpacking USER_SDO_GEOM_METADATA's DIMINFO structure
Tip #7: Forcing Sdo_Geometry to contain only points, lines or areas
Tips and Tricks
Trick #1: Australian MGA/AMG Zone Calculation from geographic (longitude/latitude) data
Trick #2: Object Tables of Sdo_Geometry
Using Oracle's SDO_NN Operator - Some examples
Tips and Tricks · Oct 26, 07:46 pm by Simon Greener
I decided long ago that when I had my own website I would try and make it useful for all those technical people out there some of whom once I had the priviledge of managing.
This particular page is dedicated to Tips and Tricks in relation to Oracle Spatial, Locator (including Oracle XE). It will include general recommendations that I have found useful and well as pointers to “gotchas” for new players.
Thanks to Roger Merritt for pushing me to finally get this section up and running.
commenting closed for this article