Thursday, February 11, 2010

How to get UTM/MGRS from Latitude/Longitude using Oracle

Oracle Spatial queries can be used to derive the UTM/MGRS from a given Latitude and Longitude.
The following sql provides an example on how to get the UTM/MGRS
Select SDO_CS.to_USNG( SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(41.98,33.23,NULL),NULL,NULL), 1) UTM_MGRS from dual;
 For more information on oracle spatial features, refer to http://www.oracle.com/technology/products/spatial/pdf/10gr2_collateral/locator_twp_10gr2.pdf

1 comment:

vaniawaclawski said...

Slot machine with jackpot - JtmHub
The jackpot prize is fixed at the best jackpot 과천 출장안마 casino online! You 김해 출장마사지 can bet without risking 안산 출장샵 your own money. This is the best of 광주 출장마사지 both worlds, 경주 출장마사지