Description
Spatial Companion For SQL Server Spatial (SC4SSS) is a complete collection of TSQL functions and procedures for a developer using SQL Server Spatial (various editions).
The TSQL functions include the all the base functions and a full set ofLinear Referencing System (LRS) functions.
The documentation for these functions is hosted on this website at the following two locations:
SQL Server Spatial Code Documentation
SQL Server Spatial LRS Code Documentation
Here is a summary of the number of functions in the SC4SSS package.
select f.category,f.routine_type,
ISNULL(f.data_type,'TOTAL:') as data_type,
f.count_by_type
from (select case when routine_schema = 'lrs' then 'LRS' else 'GENERAL' end category,
routine_type,
case when data_type = 'TABLE' then 'TABLE' else 'SCALAR' end as data_type,
count(*) as count_by_type
from [INFORMATION_SCHEMA].[ROUTINES]
where routine_schema in ('dbo','lrs','cogo')
and specific_name not like 'sp%'
and specific_name not like 'fn%'
group by ROLLUP(
case when routine_schema = 'lrs' then 'LRS' else 'GENERAL' end,
routine_type,
case when data_type = 'TABLE' then 'TABLE' else 'SCALAR' end
)
) as f
where f.category is null
or ( f.category is not null
and f.data_type is not null
)
order by f.category desc,f.count_by_type;
category | routine_type | data_type | count_by_type |
---|---|---|---|
LRS | FUNCTION | TABLE | 2 |
LRS | FUNCTION | SCALAR | 36 |
GENERAL | PROCEDURE | SCALAR | 1 |
GENERAL | FUNCTION | TABLE | 19 |
GENERAL | FUNCTION | SCALAR | 111 |
TOTAL: | 169 |
A donation of $45 for my effort can be viewed as being $45 / 196 = 23 cents per function!
A list of the available functions is summarised in the following list:
CATEGORY/FUNCTION (Minimum SQL Server Version)
General Functions
- AFFINE/STMove (2008)
- AFFINE/STRotate (2008)
- AFFINE/STScale (2008)
- COGO/DD2DMS (2008)
- COGO/DMS2DD (2008)
- COGO/DMSS2DD (2008)
- COGO/STAddSegmentByCOGO (2008)
- COGO/STArcToChordSeparation (2008)
- COGO/STAzimuth (2008)
- COGO/STBearing (2008)
- COGO/STBearingBetweenPoints (2008)
- COGO/STCircle2Polygon (2008)
- COGO/STCogo2Line (2008)
- COGO/STComputeArcLength (2008)
- COGO/STComputeChordLength (2008)
- COGO/STComputeLengthToMidPoint (2012)
- COGO/STComputeTangentPoint (2012)
- COGO/STCreateCircle (2012)
- COGO/STCrossProductLength (2008)
- COGO/STDotProduct (2008)
- COGO/STFindAngleBetween (2012)
- COGO/STFindCircle (2008)
- COGO/STFindCircleByPoint (2012)
- COGO/STFindCircleFromArc (2012)
- COGO/STFindDeflectionAngle (2012)
- COGO/STFindLineIntersection (2008)
- COGO/STFindLineIntersectionBySegment (2008)
- COGO/STFindLineIntersectionDetails (2008)
- COGO/STFindPointBisector (2012)
- COGO/STGreatCircleBearing (2008)
- COGO/STGreatCircleDistance (2008)
- COGO/STisClockwiseAngle (2008)
- COGO/STisClockwiseArc (2008)
- COGO/STLine2Cogo (2008)
- COGO/STLine2CogoAsTable (2008)
- COGO/STNormalizeBearing (2008)
- COGO/STOptimalCircleSegments (2008)
- COGO/STPointFromBearingAndDistance (2008)
- COGO/STPointFromCOGO (2008)
- COGO/STResection – Computes resection point using Tienstra’s Method from supplied parameters.
- COGO/STSubtendedAngle (2008)
- COGO/STSubtendedAngleByPoint (2008)
- COGO/STTileGeom (2008)
- COGO/STTiler (2012)
- COGO/STTileXY (2008)
- CONVERSION/STPointGeomAsText (2008)
- CONVERSION/STToGeography (2008)
- CONVERSION/STToGeometry (2012)
- EDITOR/STAppend (2012)
- EDITOR/STConvertToLineString (2008)
- EDITOR/STDelete (2008)
- EDITOR/STDeleteN (2008)
- EDITOR/STExtend (2008)
- EDITOR/STInsertN (2008)
- EDITOR/STInsertN (2012)
- EDITOR/STIsCompound (2012)
- EDITOR/STMakeCircularLine (2008)
- EDITOR/STMakeLine (2008)
- EDITOR/STMakeLineFromGeometryCollection (2008)
- EDITOR/STMakeLineFromMultiPoint (2008)
- EDITOR/STMakeLineWktFromGeographyCollection (2008)
- EDITOR/STMakeLineWktFromGeometryCollection (2008)
- EDITOR/STMakeLineXY (2008)
- EDITOR/STMakePoint (2008)
- EDITOR/STReduce (2008)
- EDITOR/STRemoveCollinearPoints (2012)
- EDITOR/STReverse (2012)
- EDITOR/STSetZ (2012)
- EDITOR/STSwapOrdinates (2008)
- EDITOR/STUpdate (2012)
- EDITOR/STUpdateN (2012)
- GEOPROCESSING/STCentroid
- GEOPROCESSING/STCentroid_A (2008)
- GEOPROCESSING/STCentroid_L (2008)
- GEOPROCESSING/STCentroid_P (2008)
- GEOPROCESSING/STDumpPoints (2008)
- GEOPROCESSING/STDumpRings (2012)
- GEOPROCESSING/STExplode (2012)
- GEOPROCESSING/STExtract (2008)
- GEOPROCESSING/STExtract (2012)
- GEOPROCESSING/STExtractPolygon (2012)
- GEOPROCESSING/STFilterRings (2008)
- GEOPROCESSING/STFlipVectors (2008)
- GEOPROCESSING/STOneSidedBuffer (2012)
- GEOPROCESSING/STParallel (2012)
- GEOPROCESSING/STParallelSegment (2012)
- GEOPROCESSING/STSegmentize (1.0)
- GEOPROCESSING/STSquareBuffer (2012)
- GEOPROCESSING/STVectorize (2008)
- GEOPROCESSING/STVertices (2008)
- INSPECT/STCoordDim (2008)
- INSPECT/STCoordDim (2012)
- INSPECT/STDetermine (2008)
- INSPECT/STEndPoint (2008)
- INSPECT/STEquals (2012)
- INSPECT/STNumDims (2012)
- INSPECT/STNumRings (2012)
- INSPECT/STStartPoint (2008)
- MBR/STGeography2MBR (2008)
- MBR/STGeometry2MBR (2008)
- MBR/STMBR2Geography (2008)
- MBR/STMBR2Geometry (2008)
- SORT/ST_Morton (2008)
- SORT/STMorton (2008)
- TOOLS/_STArray (2008)
- TOOLS/dhms (2008)
- TOOLS/Generate_Series (2008)
- TOOLS/STIsGeographicSrid (2012)
- TOOLS/STNumArray (2008)
- TOOLS/STPointAsText (2008)
- TOOLS/Tokenizer (2008)
- TOOLS/Tokenizer (2012)
Linear Referencing System Functions
- 1. LRS/STAddMeasure (2012)
- 2. LRS/STEndMeasure (2012)
- 3. LRS/STFilterLineSegmentByLength (2012)
- 4. LRS/STFilterLineSegmentByMeasure (2012)
- 5. LRS/STFindArcPointByMeasure (2012)
- 6. LRS/STFindMeasure (2012)
- 7. LRS/STFindMeasureByPoint (2012)
- 8. LRS/STFindOffset (2012)
- 9. LRS/STFindPointByLength (2012)
- 10. LRS/STFindPointByMeasure (2012)
- 11. LRS/STFindPointByRatio (2012)
- 12. LRS/STFindSegmentByLengthRange (2012)
- 13. LRS/STFindSegmentByMeasureRange (2012)
- 14. LRS/STFindSegmentByZRange (2012)
- 15. LRS/STInterpolatePoint (2012)
- 16. LRS/STIsMeasureDecreasing (2012)
- 17. LRS/STIsMeasureIncreasing (2012)
- 18. LRS/STLineInterpolatePoint (2012)
- 19. LRS/STLineLocatePoint (2012)
- 20. LRS/STLineSubstring (2012)
- 21. LRS/STLocateAlong (2012)
- 22. LRS/STLocateBetween (2012)
- 23. LRS/STLocateBetweenElevations (2008)
- 24. LRS/STMeasureRange (2012)
- 25. LRS/STMeasureToPercentage (2012)
- 26. LRS/STPercentageToMeasure (2012)
- 27. LRS/STPointToCircularArc (2012)
- 28. LRS/STProjectPoint (2012)
- 29. LRS/STRemoveMeasure (2012)
- 30. LRS/STResetMeasure (2012)
- 31. LRS/STReverseMeasure (2012)
- 32. LRS/STScaleMeasure (2012)
- 33. LRS/STSetM (2012)
- 34. LRS/STSetMeasure (2012)
- 35. LRS/STSplit (2012)
- 36. LRS/STSplitCircularStringByLength (2012)
- 37. LRS/STSplitCircularStringByMeasure (2012)
- 38. LRS/STSplitLineSegmentByLength (2012)
- 39. LRS/STSplitLineSegmentByMeasure (2012)
- 40. LRS/STSplitProcedure (2012)
- 41. LRS/STStartMeasure (2012)
- 42. LRS/STUpdateMeasure (2012)
- 43. LRS/STValidLrsGeometry (2012)
- 44. LRS/STValidLrsPoint (2012)
- 45. LRS/STValidMeasure (2012)
If a request for new function is received, and implemented, the function will be provided for the original purchaser and any future persons who download the package.
Reviews
There are no reviews yet.