Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (20)
- All (400)
- Biography (1)
- Blog (45)
- Business Requirements (1)
- Commentary (1)
- 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) (4)
- Open Source (18)
- Oracle Spatial and Locator (193)
- Partitioning (1)
- PostGIS (34)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (35)
- Space Curves (9)
- Spatial Database Functions (108)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (15)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
TESSELATE and CENTROID package updates
Today (25th February 2015) I uploaded the following changes to the following packages: 1. TESSELATE Reduce complexity of package interface. Removed all Quad_Tree Initialise procedures
Noding and building a polygon from single, overlapping linestrings
The Spatial Companion 4 Oracle (SC4O) package (built using Java Topology Suite components) contains a method called ST_PolygonBuilder that can then form polygons from linestrings.
Applying and Extending Oracle Spatial: Source Code Problem
Source Code The source code for the T_GEOMETRY object which was released with my book “Applying and Extending Oracle Spatial” (co-authored with Dr Siva Ravada)
PL/SQL Objects from “Applying and Extending Oracle Spatial”
In my book (co-authored with Dr Siva Ravada) I provide those who purchase it with a number of Oracle Objects that are a re-write of
CENTROID package use with ESRI’s sde.st_geometry
I have been emailed by someone who is using ESRI’s sde.st_geometry in preference to Oracle’s SDO_GEOMETRY or ST_GEOMETRY for their spatial data storage in Oracle,
Changes to CENTROID and TESSELATE packages
Changes to the CENTROID and TESSELATE packages, as well as a modification of the Windows install.cmd tool (improved error handling) and the method used to
CENTROID Package now returns centroid of multi-linestring
My original CENTROID package’s sdo_centroid() functions, when supplied with a multilinestring sdo_geometry, would “explode” the multilinestring into its component linestrings and calculate the centroid (mid-point)
New versions of PL/SQL packages uploaded
It has been a while (GeoRaptor took all my free/spare time) but I have uploaded a new version of the existing free PL/SQL packages to
Spatial Companion For Oracle (SC4O)
The following package requires the appropriate JAR files to be loaded into the Oracle database JVM. All the required files and installation instructions are available
NETWORK
Here’s a package with a few functions for getting the start/end point of an sdo_geometry. This package should be dropped and moved in to the
Documentation
- MySQL Spatial General Function Documentation
- Oracle LRS Object Documentation
- Oracle Spatial Exporter Package Documentation
- Oracle Spatial Object Function Documentation
- Oracle Spatial Object Function Documentation (Multi Page Version)
- PostGIS pl/pgSQL Function Documentation
- SC4O Oracle Java Topology Suite (Stored Procedures) Package Documentation
- SQL Server Spatial General TSQL Function Documentation
- SQL Server Spatial LRS TSQL Function Documentation