<div dir="ltr">I have converted NetCDF to postgres recently, and I recall the same error message,I was able to overcome it by specifying the Band in the import statement. There may be other aceptable syntaxes, but for my dataset, I successfully used the following (relative humidity band):<br><br>File Name: <font color="#383838" face="Monaco, Courier, monospace"><span style="font-size:14px;line-height:22px"><a href="http://rtma2p5.2015120411.2dvaranl_ndfd.nc">rtma2p5.2015120411.2dvaranl_ndfd.nc</a></span></font><div>Band (see below for ogrinfo list of bands): <span style="color:rgb(56,56,56);font-family:Monaco,Courier,monospace;font-size:14px;line-height:22px">RELH_2maboveground</span></div><div>Target PG Table: <span style="color:rgb(56,56,56);font-family:Monaco,Courier,monospace;font-size:14px;line-height:22px">rh_tmp</span><span style="color:rgb(56,56,56);font-family:Monaco,Courier,monospace;font-size:14px;line-height:22px"> </span></div><div>raster2pgsql cmd: <font color="#383838" face="Monaco, Courier, monospace"><span style="font-size:14px;line-height:22px"> raster2pgsql NETCDF:"<a href="http://rtma2p5.2015120411.2dvaranl_ndfd.nc">rtma2p5.2015120411.2dvaranl_ndfd.nc</a>":RELH_2maboveground rh_tmp > rh_tmp.sql</span></font><div><br></div><div>The function gdalinfo will tell you your band names. As to your other question, it is true that it can handle only one Band at a time, and therefore only one "variable". A note however, you listed lat/lon as one of your variables, and that is implicit in the raster cell, in essense, so you can derive lat/lon of the cell centroid if you like in PostgreSQL/PostGIS. I did a blog on extracting raster cell data as vector point here : <a href="https://robertwb.wordpress.com/2016/02/20/netcdf-data-and-postgis/">https://robertwb.wordpress.com/2016/02/20/netcdf-data-and-postgis/</a></div></div><br><br><div>HTH</div><div>/r/b</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Feb 19, 2016 at 1:47 PM, Severin Thaler <span dir="ltr"><<a href="mailto:sev.thaler@gmail.com" target="_blank">sev.thaler@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Dear all,<br>
<br>
i have been trying to use raster2pgsql to ingest a netcdf with multiple variables through:<br>
<br>
raster2pgsql -s 4326 -a -C -M -t 10x10 my_netcdf my_table<br>
<br>
but i get:<br>
<br>
Processing 1/1: my_netcdf<br>
ERROR: convert_raster: No bands found in raster: my_netcdf<br>
ERROR: process_rasters: Could not process raster: my_netcdf<br>
ERROR: Unable to process rasters<br>
<br>
i then extracted a single variable from the netcdf through ‘ncks’ and then tried to ingest<br>
the single variable netcdf with raster2pgsql and it worked. it also worked with another single variable,<br>
but as soon as i tried with 2 vars it again didn’t work with the same error.<br>
<br>
so it really seems to be that raster2pgsql can only handle a single variable is that true?<br>
<br>
to be precise, the variables i have are:<br>
lat(lat), lon(lon), time(time), and only one ‘real’ variable, e.g. temperature(time, lat, lon)<br>
<br>
also, does the dimensions the variable depends on need to be in a certain order, i.e.<br>
would e.g. temperature(time, lat, lon) not work? and are there any other possible conventions<br>
that the netcdf has to follow in order for raster2pgsql to work, thanks.<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr">--<br>Robert W. Burgholzer<br> 'Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.' - Charles Mingus<div>Athletics: <a href="http://athleticalgorithm.wordpress.com/" target="_blank">http://athleticalgorithm.wordpress.com/</a> <br></div><div>Science: <a href="http://robertwb.wordpress.com/" target="_blank">http://robertwb.wordpress.com/</a></div><div>Wine: <a href="http://reesvineyard.wordpress.com/" target="_blank">http://reesvineyard.wordpress.com/</a></div></div></div>
</div>