Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (20)
- 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)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (35)
- Space Curves (9)
- Spatial Database Functions (108)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (15)
- 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
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
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
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
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
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
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
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
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
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
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