are running into
From: Regina Obe
Sent: Thursday, November 16, 2023 9:46 PM
To: 'Manaswini Ganjam'
Cc: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] Extracting variable information from netcdf,
imported as raster to a table
I don’t know much about netCDF but I would
:l...@pcorp.us> >
Sent: Wednesday, November 15, 2023 6:19 PM
To: 'PostGIS Users Discussion' mailto:postgis-users@lists.osgeo.org> >
Cc: 'Manaswini Ganjam' mailto:manu.gan...@gmail.com> >
Subject: RE: [postgis-users] Extracting variable information from netcdf,
imported as raster
et/docs/RT_ST_PixelAsPoints.html
>
>
>
> SELECT pp.x, pp.y, pp.val, ST_X(pp.geom) AS lon, ST_Y(pp.geom) AS lat
>
> FROM raster_record,
>
> ST_PixelAsPoints(raster_record.rast, 1) AS pp
>
>
>
>
>
>
>
>
> *From:* postgis-users *On Behalf
> Of *Manas
, 2023 6:19 PM
To: 'PostGIS Users Discussion'
Cc: 'Manaswini Ganjam'
Subject: RE: [postgis-users] Extracting variable information from netcdf,
imported as raster to a table
Just confirming some stuff, since I’m not completely following:
Raster_record.rast column is of type raster correct
: Manaswini Ganjam
Subject: [postgis-users] Extracting variable information from netcdf, imported
as raster to a table
Hi,
I have been trying to download s3 cloud stored gridded climate data and
generate tables with variables, lat, lon and timestamp (year, yearday). To
achieve this I used
Hi,
I have been trying to download s3 cloud stored gridded climate data and
generate tables with variables, lat, lon and timestamp (year, yearday). To
achieve this I used raster2pgsql and imported multiple netcdf files into a
database table.
Question: How to achieve the extraction of variables