Hello. I have an animal track that wanders around on a landscape, and I want
to extract the pixel values for each location on the track. This kind of
operation is very common for animal studies. The landscape is represented by a
one-row raster map (“landforms4326”), and the GPS positions are
t XXX WHERE ST_Intersects(rast,point);$$
You would then call your function on all points:
SELECT update_one_point(hp.geom4326)
FROM hp
Cheers
Rémi-C
2017-02-04 6:44 GMT+01:00 J Payne :
Hello. I have an animal track that wanders around on a landscape, and I want
to extract the pixel valu
.
Now if you use it on a whole table instead of one tile,
you have to add intersect conditions and so.
By the way your update is not safe because a point may intersects several tiles.
Cheers
,Rémi-C
2017-02-04 20:00 GMT+01:00 J Payne :
Hi Rémi,
Thanks for the suggestion. I tiled t
I have been attempting to load a stack of rasters into PostGIS from a set of
netcdf files.
I can load the files *individually* perfectly well. This works:
raster2pgsql -s 4326 -I -C -F -t 256x256
NETCDF:”/myPath/myFile.nc”:var myTable | psql (etc.) #SUCCEEDS (“var” is t
Hi. I have a problem that is driving me nuts. I’ve got an out-of-db raster
table that contains a time series of images of the same area (one per date),
and it is tiled. I’m trying to clip a section of it with a polygon.
If I union the tiles for a particular date and then clip them, I get th
Hi. I am desperate for advice on a very simple problem.
I’ve got an out-of-db raster table that contains a time-series of images of a
large area (one image per date), and it is tiled. It’s about 20,000 rows in all
and I’m trying to clip it with a polygon so that I get back a smaller raster.
Hi Regina,
I'm an ecologist, and I do a lot of work with animal tracking. The niche
is small, but it's a very active area of work. Typically, we are trying to
figure out why animals go where they do. That involves overlaying track data
with polygon and raster layers; the rasters ar
Hi,
I am a Mac user and have been a happy consumer of Kyngchaos PostgreSQL and
PostGIS builds for many years. However, there are a couple of extensions I’m
interested in trying that Mr. Kyngesburye doesn’t supply, including PLV8 (I
want to see if PLV8 will speed up some raster MapAlgebra pr
Hi all,
I recently discovered that my new version of raster2pgsql doesn't work for
importing netcdf files, but an older version I have on my computer does. I'm
wondering if netcdf handling has been dropped/deprecated in the later version.
With postgresql version 11.0 and postgis 2.5, this fa