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 — 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
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 — 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 — 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 — 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 — 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
STLineSubstring — Returns a substring of the providec linestring starting and ending at the given fractions (between 0 and 1) of total 2D length or measure range. Function Specification Description Given a start and end measure, this function extracts the line segment defined between them (a point if start=end). If a non-zero value is suppliedRead More
STLineInterpolatePoint is a PostGIS like function that returns point geometry at supplied fraction along linestring.
This function, given a point near a the supplied measure @p_linestring, returns the measure/Measure_Range or length/Total_Length ratio of the found position.