SpatialDB Advisor
Simon Greener, Independent GeoSpatial Solutions Architect
Home
Current Oracle Spatial Blogs
-
Australian MGA/AMG Zone Calculation from geographic (longitude/latitude) data
Calling the Oracle Spatial shapefile loader from within the Oracle database itself
Convert GML to SDO_Geometry in Oracle 10gR2
Converting distances and units of measure in Oracle Locator
Converting Google Earth Formatted Longitude/Latitude points to decimal degrees
Detecting sdo_geometries with compound (3-point arc'd) segments
Elem_Info_Array Processing: An alternative to SDO_UTIL.GetNumRings and querying SDO_ELEM_INFO itself
ESRI ArcSDE Exverted and Inverted Polygons and Oracle Spatial
Extend (Reduce/Contract/Skrink) Function for Oracle
Extract Polygons from Compound Polygon
FAST REFRESHing of Oracle Materialized Views containing Sdo_Geometry columns
Filtering Rings (Oracle Spatial)
Fixing failed spatial indexes after import using data pump
Forcing an Sdo_Geometry object to contain only points, lines or areas
Funky Fix Ordinates By Formula
generate_series: an Oracle implementation in light of SQL Design Patterns
Generating multi-points from single point records in Oracle Spatial
Generating random point data
GEOMETRY_COLUMNS for Oracle Spatial
How to extract elements from the result of an sdo_intersection of two polygons.
How to restart a database after failed parameter change
Implementing a Parallel/ST_Parallel function for linestring data for Oracle Spatial
Implementing a Rotate/ST_Rotate function for Oracle Spatial
Implementing a Scale/ST_Scale function for Oracle Spatial
Implementing a SetPoint/ST_SetPoint function in Oracle
Implementing a Translate/ST_Translate/Move function for Oracle Spatial
Implementing an Affine/ST_Affine function for Oracle Spatial
Implementing an ST_SnapToGrid (PostGIS) function for Oracle Spatial
Implementing SDO_AddPoint/ST_AddPoint for Oracle
Implementing SDO_RemovePoint/ST_RemovePoint for Oracle
Implementing SDO_VertexUpdate/ST_VertexUpdate for Oracle
Implementing the BEST VicGrid Projection in Oracle 10gR2
Layer_GTypes for spatial indexes
Limiting table list returned when connecting to Oracle Database using ODBC
Loading and Processing GPX 1.1 files using Oracle XMLDB
Loading Shapefiles (SHP) into Oracle Spatial
Loading Spatial Data from an external CSV file in Oracle
Making Sdo Geometry Metadata Update Generic Code
Minumum Bounding Rectangle (MBR) Object Type for Oracle
Multi-Centroid Shootout
New To_3D Function
Object Tables of Sdo_Geometry
ORA-13011 errors when using SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT()
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
Performance of PL/SQL Functions using SQL or not
Spatial Pipelining
Spatial Sorting of Data via Morton Key
Split Sdo_Geometry Linestring at a known point
ST_Azimuth for Oracle: AKA Cogo.Bearing
Surrounding Parcels
Swapping Ordinates in an SDO_GEOMETRY object
The significance of sdo_lb/sdo_ub in USER_SDO_GEOM_METDATA: Do I need it?
Tips and Tricks
Unpacking USER_SDO_GEOM_METADATA's DIMINFO structure using SQL
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 is closed for this article.