Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (23)
- All (399)
- Biography (1)
- Blog (45)
- Business Requirements (1)
- Commentary (1)
- Conversion (3)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- GPS (1)
- Image Processing (2)
- Import Export (9)
- Licensing (2)
- LiDAR (1)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (2)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (6)
- Open Source (18)
- Oracle Spatial and Locator (194)
- Partitioning (1)
- PostGIS (38)
- 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 (93)
- Standards (3)
- Stored Procedure (17)
- Tessellation or Gridding (11)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
STLineToCurve. A Function that Converts a LineString to a CircularString, CompoundCurve or CurvePolygon.
The STLineToCurve function analyses a LineString looking for CircularString elements among its vertices (often LineStrings are created from curve elements by “stroking” especially where the processing software does not support CircularStrings). Any constructed CircularStrings are combined with other LineStrings to create CompoundCurves or CurvePolygons.
15 October, 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
STFlipVectors: Normalize direction of linestring vectors
In the past I have found use for the ability to “flip” vectors in a polygon in order to provide an independent check on the
5 August, 2020
No Comments
STConvertToLineString: Extract LineStrings in GeometryCollection to create LineString
I had need today to create a function that extracts all linestring elements from a GeometryCollection and returns a LineString or a MultiLineString. The function
5 August, 2020
No Comments
STCogo2Line: Creating (Multi)LineStrings geometries from COGO XML instructions
Previously I wrote about a function that converted the segments of a (Multi)LineString into a COGO XML document that contains all the instructions (bearing, distances,
5 August, 2020
No Comments
STLine2Cogo: Converting LineStrings to COGO XML
I have just written a useful function for my new package of TSQL functions for SQL Server Spatial called STLine2Cogo which converts (exports) a (Multi)LineString
5 August, 2020
No Comments