[postgis-users] Transform

[Stephen Crawford]

OK, it seems ST_Transform is working for me, but I'm a bit confused 
about the "raster_columns" table. The original (pre-transform) raster 
table is a set of 187 tiles.  In raster_columns 'scale_x', 'scale_y', 
'blocksize_x', 'blocksize_y' are all defined, and 'same_alignment'=t.
Then when I run AddRasterConstraints(output_table, 'rast'), these value 
are either null or f.  Do I need to do anything else to use the 
reprojected data, like re-tile it or something?

Thanks,
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-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
> _______________________________________________
> 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