STAsEWKT

STAsEWKT — Implements an method to create Extended Well Known Text (EWKT) strings from the input @p_geometry. Introduction/Description The Open Geospatial Consortium’s, Simple Features Specifications (SFS) 1.1 and 1.2, as well as the SQL/MM standard, define a Well Known Text (WKT) format for use in interchanging or processing geometry data. These specifications are 2D inRead More

STGeomFromEWKT

STGeomFromEWKT — Function that implements an import method for Extended Well Known Text including EWKT with SRID, Z and M ordinates.. Introduction/Description The Open Geospatial Consortium’s, Simple Features Specifications (SFS) 1.1 and 1.2, as well as the SQL/MM standard, define a Well Known Text (WKT) format for use in interchanging or processing geometry data. TheseRead More

Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 2)

In Part 1 were were introduced to the IUF data, its structure, and processing (for Locality elements). In Part 2 we will look at ways of reducing the data volume of the seed file, and look at issues when processing whole layers (LGA will be used instead of LOCALITY). In Part 3 we will lookRead More

STMulti

STMulti — Function that returns @p_geometry as a MULTI* geometry Function Specification Description In situations where a geometry column is constrained to hold only the multi version of a base geometry, storage of a single geometry eg LineString requires that geometry to be wrapped as a multi geometry eg MultiLineString. ALTER TABLE [dbo].[Colony] WITH CHECKRead More

STRound

STRound — Function which rounds the ordinates of the supplied geometry. Function Specification Description The result of many geoprocessing operations in any spatial type can be geometries whose ordinates (X, Y etc) have far more decimal digits of precision than the initial geometry. Additionally, some input GIS formats, such as shapefiles (which has no associatedRead More

STPointToCircularArc

STPointToCircularArc — Return a measured point by snapping provided point to the provided CircularString Function Specification Description This function snaps supplied point to @p_circularString, returning the snapped point. Computes Z and M values if exist on @p_circularString. If input @p_circularString is 2D, length from start of @p_circularString to point is returned in M ordinate ofRead More

STLocateBetweenElevations

STLocateBetweenElevations — Computes and returns elements that intersect the specified Z range. Function Specification Description Is implementation of PostGIS: Processes the supplied (3D, 3DM) (multi)linestring returning the elements that intersect the specified range of elevations inclusively. May return points and/or linestrings in the appropriate geometry type. Where a new xy position is to be computed,Read More