Spatial Companion For SQL Server Spatial (SC4SSS)

$45.00 (inc. GST Australia)

Description

Programmable Objects For SQL Server Spatial (SC4SSS) is a collection of TSQL functions and procedures for a developer using SQL Server Spatial (various editions).

PThe SC4SSS TSQL functions include 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 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

This amounts to $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

Linear Referencing System Functions

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.

Be the first to review “Spatial Companion For SQL Server Spatial (SC4SSS)”

Your email address will not be published. Required fields are marked *