SQL Server Spatial TSQL Stored Procedures
$24.99 (inc. GST Australia)
This product is a collection of powerful TSQL functions for use with SQL Server Spatial.
Description
Spatial Companion For SQL Server Spatial 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 of Linear 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 package.
| routine_schema | routine_type | data_type | count_by_type |
|---|---|---|---|
| lrs | FUNCTION | TABLE | 2 |
| lrs | FUNCTION | SCALAR | 39` |
| lrs | PROCEDURE | SCALAR | 1 |
| dbo | FUNCTION | TABLE | 23 |
| dbo | FUNCTION | SCALAR | 130 |
| dbo | PROCEDURE | SCALAR | 5 |
| cogo | FUNCTION | TABLE | 1 |
| cogo | FUNCTION | SCALAR | 53 |
| TOTAL: | 254 |
A donation of $24.99 for my effort can be viewed as being $24.99/254 = 10 cents per function!
A description of each of the available functions is available in the online help (see above).
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.
The license under which this code is distributed is the MIT license. However, there are other requirements that are outline in the page on Software Philosophy.
1 review for SQL Server Spatial TSQL Stored Procedures
Related products
-
$750.00 (inc. GST Australia) -
$2.50 (inc. GST Australia)
Rayner (verified owner) –
I’ve been using Simon Greener’s spatial functions for close to a year now. They are powerful, reliable, well documented and Simon is always working to make them more useful. Plus, he’s written about most of them in his blog over the last 10 years. These spatial functions form the backbone of a web app I’ve been working on. Good stuff, highly recommended.