Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Announcing the SQSArea function in SQS

3 posts in Spatial Query Server (SQS) Last posting was on 2007-12-10 22:06:49.0Z
Geoffrey Greene Posted on 2007-09-13 16:23:29.0Z
Sender: 77b4.46e7f812.1804289383@sybase.com
From: Geoffrey Greene
Newsgroups: sybase.public.sqs
Subject: Announcing the SQSArea function in SQS
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46e96401.1971.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Sep 2007 09:23:29 -0700
X-Trace: forums-1-dub 1189700609 10.22.241.41 (13 Sep 2007 09:23:29 -0700)
X-Original-Trace: 13 Sep 2007 09:23:29 -0700, 10.22.241.41
Lines: 48
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqs:4
Article PK: 1085069

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


A Cornell Posted on 2007-12-06 23:35:36.0Z
From: "A Cornell" <agcornellnospam@msn.com>
Newsgroups: sybase.public.sqs
References: <46e96401.1971.1681692777@sybase.com>
Subject: Re: Announcing the SQSArea function in SQS
Lines: 63
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: c-69-137-227-157.hsd1.va.comcast.net
X-Original-NNTP-Posting-Host: c-69-137-227-157.hsd1.va.comcast.net
Message-ID: <47588748$1@forums-1-dub>
Date: 6 Dec 2007 15:35:36 -0800
X-Trace: forums-1-dub 1196984136 69.137.227.157 (6 Dec 2007 15:35:36 -0800)
X-Original-Trace: 6 Dec 2007 15:35:36 -0800, c-69-137-227-157.hsd1.va.comcast.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqs:11
Article PK: 1085075

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

<Geoffrey Greene> wrote in message
news:46e96401.1971.1681692777@sybase.com...
> 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


Geoff Greene Posted on 2007-12-10 22:06:49.0Z
Sender: 540e.474aec45.1804289383@sybase.com
From: Geoff Greene
Newsgroups: sybase.public.sqs
Subject: Re: Announcing the SQSArea function in SQS
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <475db879.7b61.1681692777@sybase.com>
References: <47588748$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Dec 2007 14:06:49 -0800
X-Trace: forums-1-dub 1197324409 10.22.241.41 (10 Dec 2007 14:06:49 -0800)
X-Original-Trace: 10 Dec 2007 14:06:49 -0800, 10.22.241.41
Lines: 77
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqs:14
Article PK: 1085078

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

> 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
>
>
> <Geoffrey Greene> wrote in message
> news:46e96401.1971.1681692777@sybase.com...
> > 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
>
>