We are currently working on introducing spatial functions to

SQS. These are functions that would operate on spatial

data, to allow some analysis of a column in your database.

The first one we will be implementing is SQSArea(). There

are many more functions we'll be working on; Area was the

easiest

Here's a sample of how it might be used:

create table areatest(v varchar(200), shape circle)

go

insert into areatest values ("ellipse equal radius 1 deg at

equator", ellipse(0N, 0E, 30 nm, 30 nm, 82))

go

insert into areatest values ("elilipse equal radius1 deg at

179.5", circle(0N, 179.5, 30 nm, 30 nm, 62))

go

insert into areatest values ("ellipse radius 1 deg at pole",

circle(90N, 0W, 30 nm, 30 nm, 172))

go

insert into areatest values ("ellipse 20x401 deg at pole",

circle(90N, 0W, 20 nm, 40 nm, 129))

go

select v, SQSArea(shape, "nautical miles") from areatest

where SQSArea(shape, "meters") > 2000

go

The SQSArea function take a spatial column as its first

argument, and units as its second argument (meters, nautical

miles, kilometers, etc -- see the manual for a full list)

Of course, SQSArea() can be used on any spatial data,

including circle, ellipse, gpolygon, gpolygon_set, llbox,

llbox_set, point, polygon, polygon_set, rectangel,

rectangle_set.

The new spatial function capability will be released in mid

2008, in SQS 3.8. It will also be possible to use it in CIS

as well, as long as you are running 15.0.2 ESD#2 or later.

If you wish, let me know of any other spatial functions you

might be interested in having us implement.

Thanks

Geoffrey Greene

SQS Technical Lead

Geoffrey.N.Greene@boeing.com

Some more possible functions

1. return the center point of a polygon

centerpoint( polygon (......)

2 Compute the sq meters of a spatial definition

3. return a polygon from a line and a width

Allen Conrell

yup, centerpoint is definitely on our list of things todo.

Square meters...Thats area, isn't it? If so, it will be in

the next major release 3.8 or 5.0; I don't know what we're

calling it. That release will also have spatial Joins, e.g.

column1 inside column2.

Returning a polygon from a line and a width, so like a

buffer. that is certainly doable, but is the hardest of the

three. I'll take a look at that.

--Geoff Greene

SQS Technical Lead