Re: Accuracy with computing UTM from decimal degrees

Hi Ian,

Thanks for the reply. This is on an 11.1.0.6 database. When I run the same query on this version,
select cs_name,srid from mdsys.sdo_cs_srs where cs_name like 'NAD 27%17N%';

I get back 'NAD 27 / UTM zone 17N' and 2032617.

If I change the query to:
select cs_name,srid from mdsys.sdo_cs_srs where srid = 2032614;

Then I recieve 'NAD 27 / UTM zone 14N' and 2032614. So that's at least interesting to note the differences between the versions, for something that you'd think would be the same (though maybe some slight differences within the WKTEXT field). Right off hand, that looks like something that may bite a bunch of Spatial users in the butt when they upgrade to this version of Oracle.

The Oracle Forums finally came back up yesterday, and I was finally able to post the question over there as well, but so far no answers on there.

I'll give it a few more hours and see if somebody notices any glaring errors or something else before I try the SR route. It seems like if this is a real problem with the routines or internal code Oracle uses, somebody else would have noticed it by now, but who knows? This is primarily why I'm starting down the path that I coded something wrong first. I guess I'll also update that post on the forums as well with this new information, and see if maybe somebody will finally reply.

Thanks again for your reply.

--

• Bill Ferguson -- http://www.freelists.org/webpage/oracle-l