SpatialDB Advisor

Current Oracle Spatial Blogs

Converting distances and units of measure in Oracle Locator

(read more..)

Generating multi-points from single point records in Oracle Spatial

(read more..)

Multi-Centroid Shootout

(read more..)

Oracle Locator vs Oracle Spatial: A Reflection on Oracle Licensing of the SDO_GEOM Package

(read more..)

Oracle Spatial Centroid Shootout

(read more..)

Oracle Spatial Forum - Melbourne April 2007

(read more..)

Oracle Spatial Mapping and Map Rendering Performance Tips

(read more..)

Oracle's SQL/MM Compliant Types

(read more..)

Spatial Pipelining

(read more..)

Split Sdo_Geometry Linestring at a known point

(read more..)

The significance of sdo_lb/sdo_ub in USER_SDO_GEOM_METDATA: Do I need it?

(read more..)

Tip #2: layer_gtypes for spatial indexes

(read more..)

Tip #3: Generating sample (test) point data

(read more..)

Tip #4: Loading Shapefiles (SHP) into Oracle Spatial

(read more..)

Tip #5: FAST REFRESHing of Oracle Materialized Views containing Sdo_Geometry columns

(read more..)

Tip #6: Unpacking USER_SDO_GEOM_METADATA's DIMINFO structure

(read more..)

Tip #7: Forcing Sdo_Geometry to contain only points, lines or areas

(read more..)

Tips and Tricks

(read more..)

Trick #1: Australian MGA/AMG Zone Calculation from geographic (longitude/latitude) data

(read more..)

Trick #2: Object Tables of Sdo_Geometry

(read more..)

Using Oracle's SDO_NN Operator - Some examples

(read more..)

RSS / Atom

Email me

Oracle Spatial Forum - Melbourne April 2007 · Apr 28, 01:08 pm by Simon Greener

I was asked by Ross Caldow from Geomatic Technologies to give a presentation at an Oracle Spatial Forum held in Melbourne, Victoria on April 26th.

The talk I gave was a technical one called Oracle Spatial – inside the square. The idea behind the talk was to show how other Oracle components freely available in XE and all other editions can be, and should be used when constructing solutions for customers.

The talk was broken into 3 areas:

1. Generation of test data (points).
2. Use of Oracle’s XML-DB to load and process the Victorian Governments Incremental Update Format XML data.
3. Use of some SQL99 analytics coupled with hierarchical queries to conduct simple “network traces” of a hierarchically ordered pipe network.

(All three used or referenced function-based indexes.)

I said that all the data and worked examples would be available for download from my site.

Today I uploaded them.

You can download the package from here

Thanks for Mid Coast Water (node/pipe data) and Department of Sustainability and Environment (IUF XML) for the data which they have given permission to be used.

<<Tip #2: layer_gtypes for spatial indexes >>The significance of sdo_lb/sdo_ub in USER_SDO_GEOM_METDATA: Do I need it?