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)
Functions to Convert Native PostgreSQL geometric types to PostGIS
A set of functions that enable the conversion of the native PostgreSQL geometric types to PostGIS geometry objects.
18 May, 2024
No Comments
Converting PostgreSQL Native Geometric Types to PostGIS
Introduction I comes as a surprise to some that PostgreSQL has it own native geometric type system. The geometric types are documented here but the
17 May, 2024
No Comments
Linear Referencing System (LRS) Functions for TSQL
This articles logically steps through all the functions in a complete package of Linear Referencing functions that I have written for TSQL. The article both demonstrates the power of SQL Server Spatial but what can be done with TSQL.
6 December, 2020
No Comments
Using a GeometryCollection as an Array for TSQL (Stored Procedure) Development.
The lack of an array datatype in TSQL can be overcome for geometry processing by use of a GeometryCollection as a data type and a set of methods to manipulate it.
6 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
STInsertN: Insert single vertex into a geometry
SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions: STAddPoint STUpdatePoint STDeletePoint These functions are not a
7 August, 2020
No Comments
STUpdateN: Update (replace) a single vertex within a geometry object.
SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions: STAddPoint STUpdatePoint STDeletePoint These functions are not a
7 August, 2020
No Comments
STUpdate: Replace all points equal to the supplied point with replacement point.
SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions: STAddPoint STUpdatePoint STDeletePoint These functions are not a
7 August, 2020
No Comments
STDeleteN: Delete single vertex from geometry
SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions: STAddPoint STUpdatePoint STDeletePoint These functions are not a
7 August, 2020
No Comments
STDelete: Deleting vertices in geometry objects
SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions: STAddPoint STUpdatePoint STDeletePoint These functions are not a
7 August, 2020
No Comments