[gdal-dev] OGR2OGR PGeo reprojection with -sql

[Even Rouault]

Le lundi 11 avril 2011 18:47:16, Chaitanya kumar CH a écrit :
> Mike,
> 
> Can you provide the version number and perhaps a sample dataset that shows
> this problem?

No, need for it. This is the "expected" behaviour by looking at the code of 
the PGEO driver. It will be able to fetch the SRS only when working directly 
with layers, not with SQL requests. You could try specifying the -dialect 
OGRSQL option to ogr2ogr, in which case the SQL will be evaluated by OGR SQL 
engine and not by the ODBC engine. The OGRSQL engine should be able to 
retrieve the SRS from the layer.

> 
> On Mon, Apr 11, 2011 at 9:51 PM, Smith, Michael D ERDC-CRREL-NH <
> 
> michael.smith at usace.army.mil> wrote:
> >  All,
> > 
> > Using GDAL  trunk, I can read and reproject a personal geodatabase using
> > the internal projection as the source projection. However, when I use
> > –sql (as I need to add a new field to the output), the source projection
> > can no longer be read.
> > 
> > C:\temp>ogr2ogr -t_srs EPSG:4326 -f "ESRI Shapefile" temp1.shp
> > CL_01_LDS_20101201_A.mdb CL_01_LDS_20101201_A_Contour_Smoothed
> > Warning 6: Normalized/laundered field name: 'Shape_Length' to
> > 'Shape_Leng'
> > 
> > C:\temp>ogr2ogr -t_srs EPSG:4326 -f "ESRI Shapefile" temp1.shp
> > CL_01_LDS_20101201_A.mdb  -sql "select * from
> > CL_01_LDS_20101201_A_Contour_Smoothed"
> > Can't transform coordinates, source layer has no coordinate system.  Use
> > -s_srs to set one.
> > 
> > Mike
> > 
> > 
> > --
> > Michael Smith
> > Remote Sensing/GIS Center
> > US Army Corps of Engineers
> > 
> > 
> > 
> > _______________________________________________
> > gdal-dev mailing list
> > gdal-dev at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/gdal-dev