geography::Point() should accept Elevation and Measure - by jezemine

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 781512 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 3/16/2013 10:46:56 PM
Access Restriction Public


Currently the only way (as far as I can tell) to create a geography::Point() that has elevation and measure defined is to use STPointFromText like this:

-- here elevation is 1082, and measure is 66
select geography::STPointFromText('POINT(43.00000 -115.00000 1082 66)', 4326)

You should also be able to create one like this directly from the Point() constructor and not having to pass WKT (which is slow because it involves string parsing).  But this doesn't work because the ctor only takes Lat,Lon.  That is, you can only do this:

select geography::Point(-115.00000,43.00000,4326)

What I want MS to do is to add a Point() ctor that allows you to specify elevation and measure like this:

select geography::PointWithElevationAndMeasure(-115.00000,43.00000,1082,66,4326)

While I'm at it, there's a doc bug on the page describing Point() ctor:

that page says that latitude is the x-coordinate. any map maker can tell you that's false.  lat=y, lon=x, assuming x runs east-west and y runs north-south.
Sign in to post a comment.
Posted by Microsoft on 4/17/2013 at 3:21 AM
Thank you for submitting this feedback. The first part related to the constructor accepting elevation and measure working around WKT will be filed as a design change and will be considered for the following release. The documentation defect will be filed separately and checked.
Posted by jezemine on 3/16/2013 at 10:52 PM
is there any way to format text to at least include linebreaks on this site? the description is impossible to read because all my linebreaks are ignored... ugly!