So Steve could you fix this problem? Any update? Pierre
> -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@postgis.refractions.net] On Behalf Of Stephen Crawford > Sent: Tuesday, February 21, 2012 3:11 PM > To: postgis-users@postgis.refractions.net > Subject: Re: [postgis-users] Transform > > Spoke too soon. Now the new table is in the correct projection, but almost > all > of the data have been changed to "0" (should be a % such as > 93.25 etc). The original raster is tiled; do I need to do a Union first, or > something else I'm missing? > > Thanks, > Steve > > On 2/21/2012 2:20 PM, Bborie Park wrote: > > Steve, > > > > Are you running Windows? If so, I believe there is a known issue with > > GDAL not finding the proj.4 DLL. You'll need to set the env variable > > PROJSO to the full path to the DLL. > > > > http://trac.osgeo.org/gdal/wiki/ConfigOptions > > > > -bborie > > > > On 02/21/2012 11:06 AM, Stephen Crawford wrote: > >> Hi All, > >> > >> I'm trying to transform as raster set in this way: > >> > >> SELECT rid, observation_date, ST_Transform(rast, 4326) AS rast INTO > >> risk_wgs84 > >> FROM spring_ms > >> WHERE observation_date = '2012-02-20'; > >> > >> I would expect the target table "risk_wgs84" to be in lat/lon, but if > >> I > >> run: > >> > >> ST_Extent(rast) from risk_wgs84 I get values in meters (same as the > >> original table "spring_ms"): > >> > >> any ideas? > >> > >> Thanks, > >> Steve > >> > >> Stephen Crawford > >> Center for Environmental Informatics > >> The Pennsylvania State University > >> > >> > >> > >> _______________________________________________ > >> postgis-users mailing list > >> postgis-users@postgis.refractions.net > >> http://postgis.refractions.net/mailman/listinfo/postgis-users > >> > > > > -- > Stephen Crawford > Center for Environmental Informatics > The Pennsylvania State University > src...@psu.edu > 814.865.9905 > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users