<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">thanx rb, that helped.</div><div class="">just a minor clarification i’m adding:</div><div class="">the problem is not having multiple bands but having multiple subdatasets.</div><div class="">anyway, thanx.</div><br class=""><div><blockquote type="cite" class=""><div class="">On Feb 20, 2016, at 5:34 AM, Robert Burgholzer <<a href="mailto:rburghol@vt.edu" class="">rburghol@vt.edu</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">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 class=""><br class="">File Name: <font color="#383838" face="Monaco, Courier, monospace" class=""><span style="font-size:14px;line-height:22px" class=""><a href="http://rtma2p5.2015120411.2dvaranl_ndfd.nc/" class="">rtma2p5.2015120411.2dvaranl_ndfd.nc</a></span></font><div class="">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" class="">RELH_2maboveground</span></div><div class="">Target PG Table: <span style="color:rgb(56,56,56);font-family:Monaco,Courier,monospace;font-size:14px;line-height:22px" class="">rh_tmp</span><span style="color:rgb(56,56,56);font-family:Monaco,Courier,monospace;font-size:14px;line-height:22px" class=""> </span></div><div class="">raster2pgsql cmd: <font color="#383838" face="Monaco, Courier, monospace" class=""><span style="font-size:14px;line-height:22px" class=""> raster2pgsql NETCDF:"<a href="http://rtma2p5.2015120411.2dvaranl_ndfd.nc/" class="">rtma2p5.2015120411.2dvaranl_ndfd.nc</a>":RELH_2maboveground rh_tmp > rh_tmp.sql</span></font><div class=""><br class=""></div><div class="">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/" class="">https://robertwb.wordpress.com/2016/02/20/netcdf-data-and-postgis/</a></div></div><br class=""><br class=""><div class="">HTH</div><div class="">/r/b</div><div class=""><br class=""></div></div><div class="gmail_extra"><br class=""><div class="gmail_quote">On Fri, Feb 19, 2016 at 1:47 PM, Severin Thaler <span dir="ltr" class=""><<a href="mailto:sev.thaler@gmail.com" target="_blank" class="">sev.thaler@gmail.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Dear all,<br class="">
<br class="">
i have been trying to use raster2pgsql to ingest a netcdf with multiple variables through:<br class="">
<br class="">
raster2pgsql -s 4326 -a -C -M -t 10x10 my_netcdf my_table<br class="">
<br class="">
but i get:<br class="">
<br class="">
Processing 1/1: my_netcdf<br class="">
ERROR: convert_raster: No bands found in raster: my_netcdf<br class="">
ERROR: process_rasters: Could not process raster: my_netcdf<br class="">
ERROR: Unable to process rasters<br class="">
<br class="">
i then extracted a single variable from the netcdf through ‘ncks’ and then tried to ingest<br class="">
the single variable netcdf with raster2pgsql and it worked. it also worked with another single variable,<br class="">
but as soon as i tried with 2 vars it again didn’t work with the same error.<br class="">
<br class="">
so it really seems to be that raster2pgsql can only handle a single variable is that true?<br class="">
<br class="">
to be precise, the variables i have are:<br class="">
lat(lat), lon(lon), time(time), and only one ‘real’ variable, e.g. temperature(time, lat, lon)<br class="">
<br class="">
also, does the dimensions the variable depends on need to be in a certain order, i.e.<br class="">
would e.g. temperature(time, lat, lon) not work? and are there any other possible conventions<br class="">
that the netcdf has to follow in order for raster2pgsql to work, thanks.<br class="">
<br class="">
_______________________________________________<br class="">
postgis-users mailing list<br class="">
<a href="mailto:postgis-users@lists.osgeo.org" class="">postgis-users@lists.osgeo.org</a><br class="">
<a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank" class="">http://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div><br class=""><br clear="all" class=""><div class=""><br class=""></div>-- <br class=""><div class="gmail_signature"><div dir="ltr" class="">--<br class="">Robert W. Burgholzer<br class=""> 'Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.' - Charles Mingus<div class="">Athletics: <a href="http://athleticalgorithm.wordpress.com/" target="_blank" class="">http://athleticalgorithm.wordpress.com/</a> <br class=""></div><div class="">Science: <a href="http://robertwb.wordpress.com/" target="_blank" class="">http://robertwb.wordpress.com/</a></div><div class="">Wine: <a href="http://reesvineyard.wordpress.com/" target="_blank" class="">http://reesvineyard.wordpress.com/</a></div></div></div>
</div>
_______________________________________________<br class="">postgis-users mailing list<br class=""><a href="mailto:postgis-users@lists.osgeo.org" class="">postgis-users@lists.osgeo.org</a><br class="">http://lists.osgeo.org/mailman/listinfo/postgis-users</div></blockquote></div><br class=""></body></html>