Skip to content

The Spatial Database Advisor

Spatial Solutions Architect and Database Expert

0 $0.00
Primary Menu
  • Home
  • Articles
    • MySQL SpatialArticles about MySQL Spatial Functions.
    • Oracle Spatial and Locator
    • PostGIS
    • SQL Server Spatial
    • Software Change LogDescribes changes to packaged software.
    • Spatial Database Functions
  • About
  • Contact
  • Shop
0 $0.00
x
  • Login/Register
Home / SQL Server Spatial / Page 3

Top 5 Recent Articles

Delaunay Triangulation Function for TSQL and SQL Server Spatial

Creating linestring geometries from a table of ordinates (SQL Server)

Partition Spatial Data using SQL Server

Removing Spikes in SQL Server Spatial Linestrings

How to calculate cumulative length of a linestring, or the truck tonnage that accumulates across a set of roads

ARTICLES CATEGORIES
  • Algorithms (19)
  • 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)
  • Published Articles (1)
  • qGIS (1)
  • Recommendations (1)
  • Services (1)
  • Software Change Log (1)
  • Source Code (35)
  • Space Curves (9)
  • Spatial Database Functions (107)
  • Spatial DB comparison (1)
  • Spatial XML Processing (11)
  • SQL Server Spatial (91)
  • Standards (3)
  • Stored Procedure (15)
  • Tessellation or Gridding (10)
  • Tools (2)
  • Topological Relationships (1)
  • Training (2)
  • Triangulation (2)

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

Read More »
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

Read More »
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

Read More »
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

Read More »
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

Read More »
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

Read More »
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,

Read More »
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

Read More »
5 August, 2020 No Comments

STVectorize: Break Linestring/Polygon elements into 2 point vectors (or 3 point circular curves)

I demonstrated in this article the usefulness of having a vectorising function in one’s spatial database kitbag (there are Vectorize functions in my CENTROID and

Read More »
5 August, 2020 No Comments

STScale: Function to Scale a geometry object

Here is a simple scaling function for use with SQL Server Spatial’s geometry data type. Now some tests. Results sType geomWKT Scaled2D LINESTRING (0.5 1.5

Read More »
31 July, 2020 No Comments
Page1 Page2 Page3 Page4 Page5

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
© The Spatial Database Advisor 2019