[postgis-users] How can I optimize a raster in postgis 2 for display?

[Ivan Santiago]

Hello all:



I ran rtpostgis.sql to enable postgis raster to our gis db.

Thanks for the advice, Pierre.



Now...

Two rasters were added to the new database

but I have problems viewing them in QGIS using the available plugin.

plugin: Load Postgis Raster to QGIS Ver 0.0.5.4



Original size erdas img files: 32mb, and 379mb

raster_columns view:



[cid:image003.png at 01CE15AC.FE0D3640]

"gisogp";"ambiental_geologia_rasters_cuadrangulos";"o_6_ab_geol_20k";"rast";32161;6;-6;128;128;t;f;3;"{8BUI,8BUI,8BUI}";"{255,255,255}";"{f,f,f}";

"gisogp";"ambiental_topografia_rasters_mdt";"o_6_ab_ele";"rast";32161;6;-6;128;128;t;f;1;"{32BF}";"";"{f}"; "gisogp";"ambiental_topografia_rasters_mdt";"ab_ele";"rast";32161;1;-1;128;128;t;f;1;"{32BF}";"";"{f}"; "gisogp";"ambiental_geologia_rasters_cuadrangulos";"ab_geol_20k";"rast";32161;1;-1;128;128;t;f;3;"{8BUI,8BUI,8BUI}";"{255,255,255}";"{f,f,f}";



The main problem with these rasters is the extremely slow performance in QGIS.

Maybe the problem lies in QGIS and not in postgis raster.



gvSIG does not support postgis 2.0 as far as I know.



Then, how can I optimize a raster in postgis 2 for display?



OS: CentOS 5

PG version: 2.0.2

PSQL vers:  9.2

---------------------------

Iván Santiago

GIS Specialist

Information Technologies

Office of Management and Budget

787.725.9420 x 2378

Calle Cruz 254

PO Box 9023228

San Juan, PR 00902-3228



-----Original Message-----
From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Pierre Racine
Sent: Monday, February 25, 2013 5:51 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Postgis raster question: how to enable raster type in 2.0



rtpostgis.sql if for loading raster definition and function into the database. Not to upgrade.



http://postgis.net/docs/manual-dev/postgis_installation.html#create_new_db_extensions



http://postgis.net/docs/manual-dev/postgis_installation.html#upgrading



Pierre



> -----Original Message-----

> From: postgis-users-bounces at lists.osgeo.org<mailto:postgis-users-bounces at lists.osgeo.org> [mailto:postgis-users-

> bounces at lists.osgeo.org<mailto:bounces at lists.osgeo.org>] On Behalf Of Ivan Santiago

> Sent: Monday, February 25, 2013 3:22 PM

> To: PostGIS Users Discussion

> Subject: Re: [postgis-users] Postgis raster question: how to enable

> raster type in

> 2.0

>

>

>

> Turns out it raster support was installed.  I made another DB without

> enabling postgis extension which includes raster.

>

>

>

> I hope that solves the problem. Still need to load a raster to see if this worked.

>

>

>

> Did you load rtpostgis.sql?

>

>

>

> It looks like rtpostgis.sql is for upgrading postgis. would you

> recommend me to run it?

>

>

>

> we are on version 2.0.2

>

>

>

> ---------------------------

> Iván Santiago

> GIS Specialist

> Information Technologies

> Office of Management and Budget

> <https://mail.ogp.gobierno.pr/exchweb/bin/redir.asp?URL=https://mail.o

> gp.go bierno.pr/exchweb/bin/redir.asp?URL=http://www.ogp.gobierno.pr/>

> 787.725.9420 x 2378

> Calle Cruz 254

> PO Box 9023228

> San Juan, PR 00902-3228

>

>

>

> From: postgis-users-bounces at lists.osgeo.org<mailto:postgis-users-bounces at lists.osgeo.org> [mailto:postgis-users-

> bounces at lists.osgeo.org<mailto:bounces at lists.osgeo.org>] On Behalf Of Pierre Racine

> Sent: Monday, February 25, 2013 4:06 PM

> To: PostGIS Users Discussion

> Subject: Re: [postgis-users] Postgis raster question: how to enable

> raster type in

> 2.0

>

>

>

> Did you load rtpostgis.sql?

>

>

>

> Pierre

>

>

>

> From: postgis-users-bounces at lists.osgeo.org<mailto:postgis-users-bounces at lists.osgeo.org> [mailto:postgis-users-

> bounces at lists.osgeo.org<mailto:bounces at lists.osgeo.org>] On Behalf Of Ivan Santiago

> Sent: Monday, February 25, 2013 1:42 PM

> To: postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>

> Subject: [postgis-users] Postgis raster question: how to enable raster

> type in 2.0

>

>

>

> Hello all:

>

>

>

> We installed postgresql 9.2 and postgis 2.0 in a CentOS 5 virtual server.

>

>

>

> after running:

>

>  select postgis_full_version();

>

>

>

> I get the following:

>

>

>

>  "POSTGIS="2.0.2 r10789" GEOS="3.3.6-CAPI-1.7.6" PROJ="Rel. 4.8.0, 6

>

>  March 2012" LIBXML="2.7.6" LIBJSON="UNKNOWN""

>

>

>

> Raster does not appear.

>

>

>

> How can I enable raster data type?

>

>

>

> Thanks in advance.

>

> ---------------------------

> Iván Santiago

> GIS Specialist

> Information Technologies

> Office of Management and Budget

> <https://mail.ogp.gobierno.pr/exchweb/bin/redir.asp?URL=https://mail.o

> gp.go bierno.pr/exchweb/bin/redir.asp?URL=http://www.ogp.gobierno.pr/>

> 787.725.9420 x 2378

> Calle Cruz 254

> PO Box 9023228

> San Juan, PR 00902-3228

>

>



_______________________________________________

postgis-users mailing list

postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>

http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130228/fbc5cc98/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 15660 bytes
Desc: image003.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130228/fbc5cc98/attachment.png>