Skip to content

The Spatial Database Advisor

Spatial Solutions Architect and Database Expert

Popular Tags:
  • Oracle Spatial
  • Source Code
  • Linear Reference System
  • PL/SQL
  • MySQL Spatial
0 $0.00
Primary Menu
  • Home
  • Articles
    • Spatial Database Functions
    • SQL Server Spatial
    • Oracle Spatial and Locator
    • PostGIS
    • MySQL SpatialArticles about MySQL Spatial Functions.
    • Linear Referencing
    • Software Change LogDescribes changes to packaged software.
  • About
  • Contact
  • Shop
0 $0.00
x
Popular Tags:
  • Oracle Spatial
  • Source Code
  • Linear Reference System
  • PL/SQL
  • MySQL Spatial
  • Login
Home / SQL Server Spatial / Page 4

Top 5 Recent Articles

OptimoRoute

Functions to Convert Native PostgreSQL geometric types to PostGIS

Converting PostgreSQL Native Geometric Types to PostGIS

Fitting Bezier Polygon to Points

Fixing Geography Ring Orientation

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)

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

STGeometry2MBR/STGeography2MBR: Compute and return MBR ordinates

SQL Server Spatial’s STEnvelope() function returns the minimum bounding rectangle of a geometry object but as a 5 vertex polygon. To access the lower left

Read More »
31 July, 2020 No Comments

STExtractPolygon: Extract Polygons from result of STIntersection in SQL Server Spatial

Oracle customers have asked me for help in the past dealing with compound objects or collections that result from thinning or geoprocessing (intersection etc) of

Read More »
27 July, 2020 No Comments

STRound: Function to round ordinates of a SQL Server Spatial geometry object

The result of many geoprocessing operations in any spatial type can be geometries with ordinates (X, Y etc) that have far more decimal digits of

Read More »
27 July, 2020 No Comments

STExtract: Extract elements of a geometry object

Of the functions I have written for Oracle, those that allow me to extract (sub)elements of compound (objects consisting of linestrings and circular arcs) and

Read More »
27 July, 2020 No Comments

STNumRings: Counting number of polygon rings

Here is an “ease of use” function that allows you to count the number of rings of a polygon or multipolygon geometry object in SQL

Read More »
27 July, 2020 No Comments

STFilterRings: Removing rings from Polygon based on area.

A function that have found use in Oracle and PostGIS is one that allows a user to filter out the rings of a polygon or

Read More »
27 July, 2020 No Comments

STMove: Function to Move a geometry object in SQL Server Spatial

If you have need for a TSQL based function for moving geometry objects in SQL Server Spatial (Denali is required), here is a function you

Read More »
27 July, 2020 No Comments

STCentroid*: Alternate Functions for Compute a Centroid

The top download from my website is for my package of centroid algorithms for Oracle sdo_geometry. There is nothing wrong with the STCentroid function implemented

Read More »
27 July, 2020 No Comments

STRotate: Function to rotate a geometry object in SQL Server Spatial

If you have need for a TSQL based function for rotating geometry objects in SQL Server Spatial (Denali is required), here is a function you

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

Documentation

  • MySQL Spatial General Functions
  • Oracle LRS Objects
  • Oracle Spatial Exporter (Java + pl/SQL)
  • Oracle Spatial Object Functions
  • Oracle Spatial Object Functions (Multi Page)
  • PostGIS pl/pgSQL Functions
  • SC4O Oracle Java Topology Suite (Java + pl/SQL)
  • SQL Server Spatial General TSQL Functions
  • SQL Server Spatial LRS TSQL Functions
© The Spatial Database Advisor 2019 | Shopical by AF themes.