From: | Osahon Oduware <osahon(dot)gis(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | ST_CreateOverview Function Generating Overview-Rasters With Black Grids |
Date: | 2017-06-02 13:51:09 |
Message-ID: | CAGpiUSiQ0pJ9hiO9eCMN2djJPOWBHMq=0tNTnyMqUnZBt3wp0Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All,
I used the ST_CreateOverview function to create overviews for a sample
raster (256 x 256 pixels; 14,400 rows) as follows:
SELECT ST_CreateOverview('<raster_table>'::regclass,'rast_column'::name,
<factor>);
where <factor> used is 2,3,4,5,6,7,8
When I try to view the raster in QGIS I notice some black grids appear at
higher-levels of zoom which would obviously be from the overview table (*see
attached image*), but there are no black grids at lower-levels of zoom
which would obviously be from the actual raster table (*see attached image*
).
I can see that someone complained of a similar problem for the same
function in the link below, but there was no solution:
http://osgeo-org.1560.x6.nabble.com/st-createoverview-td5261112.html
Could someone explain the likely cause for this and how to avoid having the
black grids from the overviews.
Attachment | Content-Type | Size |
---|---|---|
Higher_Zoom_With_Grids.JPG | image/jpeg | 169.3 KB |
Lower_Zoom_With_No_Grids.JPG | image/jpeg | 103.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Neyman | 2017-06-02 13:52:46 | Re: Oracle database into PostgreSQL using Ora2PG tool. |
Previous Message | Igor Neyman | 2017-06-02 13:45:13 | Re: Oracle database into PostgreSQL using Ora2PG tool. |