Thanks Pierre,
I didn't know that array_agg didn't work with arrays, however on I do get a
3d array using array_agg (PG 9.4), what's wrong exactly with that array ?
It seems to load fine with st_setvalues (if I use a single band).
Still, I can't figure how to load an arbitrary number of bands
The two NOTICE are because there is actually two rasters created by in the
dummy_rast table and the first one has no bands.
Values are rounded by ST_MapAlgebra() because, by default, ST_MapAlgebra() will
try to produce a raster with the same pixel type as the input rasters. If you
want the
Tks Strk,
I think I got it.
Actually the correct sector_code - face pair is '29039040536' :
23157
So the correct code is:
UPDATE temp_geom_bahia2 SET tg_geom_dump_utm =
CreateTopoGeom('topo_bahia',3,1,'{{23157,3}}'::topology.topoelementarray)
WHERE cod_setor = '29039040536'
I'll try
Étienne,
The columnx and rowy ST_SetValues() parameters are not references to each pixel
values. They are the coordinates only of the first upperleft pixel to be set.
Other pixels coordinates are automatically derived from the size of the passed
two dimensional array (newvalueset). That means
Hi list,
I have raster data stored in a table row-col format as measure(rowy
integer, colx integer, band integer, value float).
I've tried loading a multidimensional array (row x col x bands) with no
success, however building a 2d array (row x col) works but it seems
contrived, especially once I
You may have to sanitize your function signatures so they are all only
pointing to a single postgis library. Because of the combination of
extension/legacy you've got a mixed set, which is leading to pain.
UPDATE pg_proc SET probin = '$libdir/postgis-2.2'
WHERE probin = '$libdir/postgis-2.1';
On Thu, Feb 25, 2016 at 09:15:32PM +, Lucas Ferreira Mation wrote:
> 2) In most test I did, I got an error when uploading one or two polygons
> (out of a 900 polygons in Acre state). How can I add these afterward?
> Assume all neighbor polygons have been added to the topogeometry. Thus the
>