Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (22)
- All (399)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Conversion (2)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- GPS (1)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- LiDAR (1)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (5)
- Open Source (18)
- Oracle Spatial and Locator (194)
- Partitioning (1)
- PostGIS (36)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (37)
- Space Curves (9)
- Spatial Database Functions (109)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (17)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
Presentations given by myself at the Australian Oracle Spatial Forum, Sydney, Thursday 28th August 2008
I gave two presentations at the Australian Oracle Spatial Forum held at the Novotel Hotel, Sydney Olympic Park on Thursday 28th August 2008.
My two papers were:
- Automated Layer Management – Experiences At Mid Coast Water
- Gridding vs Simplification in Extracting Performance from High Density Data
The first was co-authored with Mr Brendan Soustal though the whole paper was written by myself. The work, however, was executed under his guidance and direction (along with his permission to publish this work) and for this I am grateful.
The first describes how triggers and a PL/SQL package are used to implement a fully automatic spatial layer that is “calculated” entirely from source spatial data that is undergoing transactional editing. As edits occur the dependent spatial layer is kept synchronised through use of triggers, the Oracle Scheduler and geoprocessing code implemented in a single SQL statement hosted within the PL/SQL package.
The second presentation looks at alternate techniques for improving the speed of Oracle’s geoprocessing functions (eg sdo_geom.sdo_intersection) when handling very large, dense polygons.