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)
Mapping surface area of a ruptured pipe in Oracle Spatial
I gave a talk last year entitled Automated Layer Management – Experiences At Mid Coast Water which was about mapping the area that would be affected by a mains pipe bursting in either a sewer or water network. (Yes it was a not very exciting title.) The mapping was all done in 2D as Oracle 10gR2 and before does not have any 3D capabilities that would help do the work in 3D.
The work also had many other aspects, the main one being that because the problem was clearly defined, described and attributed (eg invert levels below surface level), the solution could be fully automated via the use of very efficient trigger based processing.
The customer asked me to look at whether it would be possible to redo the solution such that it fitted seamlessly into the same framework as the current solution, but extend it to model the area that would be affected in 3D.
This involves modelling the pipe burst as a 3D solid and then calculating the intersection between it and a 3D model of the ground surface.
Since my customer is on 10gR2 I had to design a solution based on the lack of internal support for 3D solids, triangulated irregular networks etc. Also, the customer wants me to “look forward” to what is in 11gR1 and R2 that may help when an upgrade of the database software occurs.
Well, I came up with a solution that will actually run on SQL Server 2008 and PostgreSQL/PostGIS as both support linear and polygonal data with Z and M values.
The solution was presented at the Australia Oracle User Group (AUSOUG) annual conference Melbourne 16 – 17 November 2009. The title of the paper was – yes another bad title – Extending a 2D Zone of Influence to 3D using Oracle 10g and 11g SDO_TIN. (I changed the name of the PDF to make the document more descriptive of its contents.)
If anyone would like me to implement this solution for them in Oracle, PostGIS or SQL Server 2008 please feel free to email me.
Documentation
- MySQL Spatial General Functions
- Oracle LRS Objects
- Oracle Spatial Exporter (Java + pl/SQL)
- Oracle Spatial Object Functions
- Oracle Spatial Object Functions (Multi Page)
- PostGIS pl/pgSQL Functions
- SC4O Oracle Java Topology Suite (Java + pl/SQL)
- SQL Server Spatial General TSQL Functions
- SQL Server Spatial LRS TSQL Functions