"The rendering of the raster in QGIS is slow because the GDAL PostGIS raster driver does not use pyramids in addition to several other inefficiencies (one query per row)
Is this something can be worked around or is being worked on? On Fri, Sep 7, 2012 at 12:47 PM, Bborie Park <bkp...@ucdavis.edu> wrote: > Brian, > > You should have raster2pgsql already since you compiled PostGIS from > source. There is no option in the build process to not compile > raster2pgsql. > > The rendering of the raster in QGIS is slow because the GDAL PostGIS > raster driver does not use pyramids in addition to several other > inefficiencies (one query per row). > > -bborie > > On 09/07/2012 09:09 AM, Brian Fitzgerald wrote: > > I've finally manged to get the following stack working > > > > - Linux Mint 13 Mate > > - Postgresql 9.1 > > - GDAL 1.9.1 built from source > > - GEOS 3.3.5 built from source > > - Postgis 2.0.1 built from source with GEOS and GDAL above > > - QGIS nightlies for ubuntu > > > > - I imported a digital ortho raster tiff (in SRID 2273) into Postgis > using > > the Database -> PostGIS Raster -> Load function > > - I then loaded this raster into QGIS using the Database -> Postgis > Raster > > -> Add function > > > > This works 'ok'... the 1mile x 1mile 1ft res image does finally display, > > but it takes like 2 minutes (presumably because there are no pyramids?) > > > > So I wanted to try and load a raster using the raster2pgsql tool... > > however, I've realized that I don't have it because I built from > source... > > so: > > > > Is there a place I can download the raster2pgsql tool source and also > build > > it from scratch? > > Is there an alternative? > > Is the reason the image is drawing sooooo slowly a lack of pyramids? > > > > Thanks!!! > > > > - Brian > > > > > > > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > -- > Bborie Park > Programmer > Center for Vectorborne Diseases > UC Davis > 530-752-8380 > bkp...@ucdavis.edu > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- -------------------------------------- Brian Fitzgerald, PMP, GISP bkf...@gmail.com 803.426.3469 ---------------------------------------
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
