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)
Oracle Spatial Vector Acceleration: Flick the Switch
Introduction A lot has been written, positive and negative, about the speed of Oracle Spatial over the years, a lot of ill informed (I mean
18 January, 2021
No Comments
Geometry object size when exchanging of WKT/WKB encoded geometries.
Introduction The ordinates stored in an geometry objects, across all spatial data types do not have any rounding applied to their values. This is one
12 December, 2020
No Comments
Geometry Validity and Method Access
This article demonstrates how an invalid polygon (and linestring) are handled by the different database spatial APIs with correction in TSQL.
6 December, 2020
No Comments
Oracle Spatial Mapping and Map Rendering Performance Tips
Comment: This article was written about 10 years ago. Most of what is written is still relevant though the comments about disk usage and access
23 November, 2020
No Comments
The Frontage Problem: Creating references from land parcel street frontage boundary to point in street
This article demonstrates the power of database-based spatial processing. The business requirement is to determine, dynamically, the side of a land parcel that faces the street (could be single 2 point straight line to something more complex), and then determine the clockface direction from either ends of the frontage or the middle, to a object in the roads reserve (eg telecommunications pit).
3 November, 2020
No Comments
Create GeoJSON Document from Selection of SDO_Geometry objects.
This article shows how to create a GeoJSON Document from Selection of SDO_Geometry objects.
30 October, 2020
No Comments
Using Oracle’s ST_GEOMETRY type hierarchy with SDO_GEOMETRY: ST_PointN and ST_NumPoints
Oracle Spatial has, for many versions, made available an implementation of the OpenGIS SFS type hierarchy. Today I will show how to use this type
7 August, 2020
No Comments
Scheduling the Export of Spatial Data in Oracle to a Shapefile each night
While there is always a need for software like Safe Software’s Awesome FME to automate import and export tasks from your database, the ability to
5 August, 2020
No Comments
ST_Densify for Object PLSQL
The Java Topology Suite (JTS) has a linestring densifier function that is available in my Spatial Companion for Oracle (SC4O) solution. See here for documentation.
5 August, 2020
No Comments
PLSQL ST_AsEWKT and ST_FromWKT Functions For Oracle (any version)
Previously I created the following Java stored procedures to enable the import/export of ZM aware WKT. ST_GeomFromText ST_GeomFromEWKT ST_AsText ST_AsEWKT These functions are necessary if
5 August, 2020
No Comments