[postgis-users] Transform

[Pierre Racine]

So Steve could you fix this problem? Any update?

Pierre

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Stephen Crawford
> Sent: Tuesday, February 21, 2012 3:11 PM
> To: postgis-users at 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 at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >
> 
> --
> Stephen Crawford
> Center for Environmental Informatics
> The Pennsylvania State University
> src176 at psu.edu
> 814.865.9905
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users