Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Spatial data type geography: "simple" math

0 views
Skip to first unread message

Russ Loski

unread,
Dec 30, 2009, 5:17:05 PM12/30/09
to
I am trying to map a lot using the geography data type. I have a line and I
want to derive other shapes from the line. For example, I want to find the
rectangle that has the line as one of the sides and is x meters deep. I
want to create a line that completely intesects the first line but that
extends x meters to the right and y meters to the left.

The problem is that I can't easily find the angle of the line using the
geography object. Also, I would like to find the point that is x meters in
certain direction from the current point. Are there libraries to do this
with? I have written my own, but I still don't trust the math on it.

Michael Coles

unread,
Dec 30, 2009, 10:40:01 PM12/30/09
to
For what you're doing are you sure you want to use the geography data type
and not the geometry data type? I don't believe the items you've mentioned
below are built in functionality with the geography or geometry data types.
There is a .NET spatial tools library on CodePlex
http://sqlspatialtools.codeplex.com/ that may have some functionality that
will help you with these issues.

--
Thanks

Michael Coles
SQL Server MVP
Author, "Expert SQL Server 2008 Encryption"
(http://www.apress.com/book/view/1430224649)
----------------

"Russ Loski" <RLo...@NOSPAM.hotmail.com> wrote in message
news:ubjrY3Zi...@TK2MSFTNGP05.phx.gbl...

0 new messages