[postgis-users] Transform

[Stephen Crawford]

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