[postgis-users] PostGIS Raster Decimal?

[Andreas Forø Tollefsen]

Hi. Again.

I have been working on some raster data in PostGIS lately.
However, i have some issues with the raster values become integer after
importing the sql to postgis.
For instance this procedure:

C:\prio_grid\source\gpw>c:\python26\python
c:\prio_grid\script\raster2pgsql.py -
r c:\prio_grid\source\gpw\lrc30p90\glp90ag30\w001001.adf -t gpw90 -s 4326 -o
gpw
90.sql -I -M

Then to database:
C:\prio_grid\source\gpw>psql -h 192.168.1.55 -d priogrid -f gpw90.sql

Querying this data:
SELECT gpw90.gid, ((gpw90.gpw90val).val) AS gpw90
INTO popgrid
FROM (SELECT priogrid_land.gid, ST_Intersection(gpw90.rast,
priogrid_land.centroid) AS gpw90val FROM gpw90, priogrid_land WHERE
ST_Intersects(priogrid_land.centroid, gpw90.rast)) AS gpw90
WHERE gpw90.gid = 139303
GROUP BY gid,((gpw90.gpw90val))
;

Gives:
gid; gpw90
139303;39849

The value in the original raster is:
39849.2

Question is then. How can i ensure that raster remain decimal and not
integer after this import and query process?

Thanks.
Andreas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110314/c635eac1/attachment.html>