support for geometry

Jun 16, 2010 at 1:55 AM

Hi,

This is a nice little project - thanks for going to the effort.

A nice little addition if someone is so inclined would be to support both geometry and geography. Its not a particularly hard change but would increase the usefulness of the project.

 

A work around for users is to do some thing like this in your query

GEOGRAPHY::STGeomFromWKB(geometryField.STAsBinary(),4326)

Some checking of SRID might be good if your doing this to save doing something wacky.

Thanks again

Coordinator
Jun 16, 2010 at 3:16 PM

Sure, Art, I’ll be getting to that. I hadn’t thought of geometry support because KML is usually (AFAIK) used for representing places on the earth. But it should be pretty easy to do.

Cheers,

Bob

From: art79 [mailto:notifications@codeplex.com]
Sent: Tuesday, June 15, 2010 6:56 PM
To: bobb@sqlskills.com
Subject: support for geometry [sqlservertokml:216150]

From: art79

Hi,

This is a nice little project - thanks for going to the effort.

A nice little addition if someone is so inclined would be to support both geometry and geography. Its not a particularly hard change but would increase the usefulness of the project.

A work around for users is to do some thing like this in your query

GEOGRAPHY::STGeomFromWKB(geometryField.STAsBinary(),4326)

Some checking of SRID might be good if your doing this to save doing something wacky.

Thanks again

Read the full discussion online.

To add a post to this discussion, reply to this email (sqlservertokml@discussions.codeplex.com)

To start a new discussion for this project, email sqlservertokml@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

Jun 16, 2010 at 11:35 PM

your right that geography is the logical home for data that is being displayed on an earth but there is nothing to stop you storing long/lat coordinates as x/y coordinates in a geometry and there are benefits to using geometry over geography types in some cases.