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
Concave Hull Geometries in Oracle 11gR2
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 Materialized View Containing SDO_GEOMETRY and SDO_GEOM.SDO_AREA function
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
GeoRaptor Development Team
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
Instantiating MDSYS.VERTEX_TYPE
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 PL/SQL Packages - Rotate oriented point
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 vs Pure Code
Projecting SDO_GEOM_METADATA DIMINFO XY ordinates
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
On the use of ROLLUP in Oracle SELECT statements
· Nov 4, 04:32 pm by Simon Greener
This article is not about Oracle Locator/Spatial but simply about the use of some of Oracle’s Relational On-Line Analytical Processing (ROLAP) functionality in building reports for publication with a range of software from Apex to Crystal Reports.
The context for this is that I regularly am hirecd to write ordinary financial reports for the Department of Treasury and Finance in Hobart. I am not just an Oracle Spatial specialist but someone with over 25 years use in relational and non-relational (eg ADABAS) databases.
This report is not published as a native blog article, rather it is published in a Adobe Acrobat PDF file.
I hope it is of use to someone out there.
