I had to walk away for another project but I'll be back at it this week and I'll let you know. Thanks for the help.

Steve

On 2/27/2012 8:50 AM, Pierre Racine wrote:
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

--
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

Reply via email to