FW: [gdal-dev] OGR - Oracle problem

2009-03-09 Thread Clay, Bruce
06, 2009 3:52 PM To: gdal-dev@lists.osgeo.org Subject: [gdal-dev] OGR - Oracle problem When I issue the following SQL query through SqlPal I get 2 columns of what appears to be valid data select * from (select OBJECTID, sdo_nn_distance(1) Dist from GEONAMES_SDO a1 where DSG LIKE 'P

[gdal-dev] OGR - Oracle problem

2009-03-06 Thread Clay, Bruce
When I issue the following SQL query through SqlPal I get 2 columns of what appears to be valid data select * from (select OBJECTID, sdo_nn_distance(1) Dist from GEONAMES_SDO a1 where DSG LIKE 'PPL%' AND sdo_nn(a1.shape, sdo_geometry(2001, null, sdo_point_type(-84.4850,-21.9810,