<HTML>
<HEAD>
<TITLE>OGR2OGR PGeo reprojection with -sql</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>All,<BR>
<BR>
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.<BR>
<BR>
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<BR>
Warning 6: Normalized/laundered field name: 'Shape_Length' to 'Shape_Leng'<BR>
<BR>
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"<BR>
Can't transform coordinates, source layer has no coordinate system. Use -s_srs to set one.<BR>
<BR>
Mike<BR>
<BR>
<BR>
-- <BR>
Michael Smith<BR>
Remote Sensing/GIS Center<BR>
US Army Corps of Engineers<BR>
<BR>
<BR>
</SPAN></FONT>
</BODY>
</HTML>