<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body dir="auto">
I don’t know if it’s the ideal tool for the job, as it’s more flexible than you need, not being a regularized grid but a point cloud, but you might look to the pgPointCloud extension: <a href="https://github.com/pgpointcloud/pointcloud">https://github.com/pgpointcloud/pointcloud</a>
<div><br>
</div>
<div>Cheers,</div>
<div>Best,</div>
<div>Steve<br>
<br>
<div id="AppleMailSignature">
<div><br>
</div>
<img alt="http://sig.cmparks.net/cmp-ms-90x122.png" align="left" height="122" hspace="12" width="90" src="http://sig.cmparks.net/cmp-ms-90x122.png"><span style="background-color: rgba(255, 255, 255, 0);"><strong>Stephen V. Mather</strong><br>
GIS Manager<br>
<a dir="ltr" href="tel:(216)%20635-3243" x-apple-data-detectors="true" x-apple-data-detectors-type="telephone" x-apple-data-detectors-result="4/1">(216) 635-3243</a> (Work)</span>
<div>(216) 339-6347 (Cell)<br>
<div><span style="background-color: rgba(255, 255, 255, 0);">--sent from phone--</span></div>
<div><span style="background-color: rgba(255, 255, 255, 0);"><br>
</span></div>
<div><span style="background-color: rgba(255, 255, 255, 0);"><br>
</span></div>
</div>
</div>
<div><br>
On Oct 30, 2017, at 07:09, Antonio Rodriges <<a href="mailto:antonio.rrz@gmail.com">antonio.rrz@gmail.com</a>> wrote:<br>
<br>
</div>
<blockquote type="cite">
<div><span>Hello,</span><br>
<span></span><br>
<span>Thank you for the reply, however my data is slightly different. Sorry</span><br>
<span>that I did not make it clearer at the very beginning.</span><br>
<span></span><br>
<span>Actually I would like to import a dense, 3-d array of wind speed (a</span><br>
<span>time series of grids, each grid point contains the wind speed value)</span><br>
<span></span><br>
<span>The array is stored as a NetCDF file</span><br>
<span>FIles are here <a href="https://www.esrl.noaa.gov/psd/cgi-bin/db_search/DBListFiles.pl?did=61&tid=59909&vid=4298">
https://www.esrl.noaa.gov/psd/cgi-bin/db_search/DBListFiles.pl?did=61&tid=59909&vid=4298</a></span><br>
<span></span><br>
<span>The size of the array and its dimensions are below</span><br>
<span></span><br>
<span>dimensions:</span><br>
<span> lat = 94 ;</span><br>
<span> lon = 192 ;</span><br>
<span> time = 1460;</span><br>
<span></span><br>
<span>The array</span><br>
<span></span><br>
<span>short uwnd(time,lat,lon) ;</span><br>
<span> uwnd:long_name = "6-Hourly Forecast of U-wind at 10 m" ;</span><br>
<span> uwnd:valid_range = -32765s, -8765s ;</span><br>
<span> uwnd:unpacked_valid_range = -120.f, 120.f ;</span><br>
<span> uwnd:actual_range = -38.2f, 38.07f ;</span><br>
<span> uwnd:units = "m/s" ;</span><br>
<span> uwnd:add_offset = 207.65f ;</span><br>
<span> uwnd:scale_factor = 0.01f ;</span><br>
<span> uwnd:missing_value = 32766s ;</span><br>
<span> uwnd:_FillValue = -32767s ;</span><br>
<span> uwnd:precision = 2s ;</span><br>
<span> uwnd:least_significant_digit = 1s ;</span><br>
<span> uwnd:GRIB_id = 33s ;</span><br>
<span> uwnd:GRIB_name = "U GRD" ;</span><br>
<span> uwnd:var_desc = "u-wind" ;</span><br>
<span> uwnd:dataset = "NCEP/DOE AMIP-II Reanalysis (Reanalysis-2)" ;</span><br>
<span> uwnd:level_desc = "10 m" ;</span><br>
<span> uwnd:statistic = "Individual Obs" ;</span><br>
<span> uwnd:parent_stat = "Other" ;</span><br>
<span> uwnd:standard_name = "eastward_wind" ;</span><br>
<span></span><br>
<span>2017-10-30 11:04 GMT+03:00 Giuseppe Broccolo <<a href="mailto:g.broccolo.7@gmail.com">g.broccolo.7@gmail.com</a>>:</span><br>
<blockquote type="cite"><span>Hi Antonio,</span><br>
</blockquote>
<blockquote type="cite"><span></span><br>
</blockquote>
<blockquote type="cite"><span>2017-10-29 12:31 GMT+01:00 Antonio Rodriges <<a href="mailto:antonio.rrz@gmail.com">antonio.rrz@gmail.com</a>>:</span><br>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><span></span><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><span>Hello,</span><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><span></span><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><span>Whether PostGIS allow importing 3-d, 4-d, etc. arrays or only 2-d arrays?</span><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><span></span><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><span>Specifically, I have a 3-d array with axes (time, lat, lon).</span><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><span>Does this mean that I need to split it onto 2-d bands (lat, lon) and</span><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><span>import the number of bands that is equal to the number of time steps</span><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><span>in the 3-d array?</span><br>
</blockquote>
</blockquote>
<blockquote type="cite"><span></span><br>
</blockquote>
<blockquote type="cite"><span></span><br>
</blockquote>
<blockquote type="cite"><span>Which is the data source from which you import the data (e.g. textual,</span><br>
</blockquote>
<blockquote type="cite"><span>etc.)?</span><br>
</blockquote>
<blockquote type="cite"><span></span><br>
</blockquote>
<blockquote type="cite"><span>If I've correctly understood, you have arrays where geospatial and</span><br>
</blockquote>
<blockquote type="cite"><span>non-geospatial information</span><br>
</blockquote>
<blockquote type="cite"><span>is present, each one providing a "dimension" of the array.</span><br>
</blockquote>
<blockquote type="cite"><span></span><br>
</blockquote>
<blockquote type="cite"><span>Just FYI, in PostGIS is possible to define mixed, structured data with</span><br>
</blockquote>
<blockquote type="cite"><span>constructors like POINTM</span><br>
</blockquote>
<blockquote type="cite"><span>and POINT, that allow to add a further dimension to the 2D/3D (respectively)</span><br>
</blockquote>
<blockquote type="cite"><span>geospatial ones, that</span><br>
</blockquote>
<blockquote type="cite"><span>includes a scalar information.</span><br>
</blockquote>
<blockquote type="cite"><span></span><br>
</blockquote>
<blockquote type="cite"><span>Hope this can help in your import, otherwise provide more information about</span><br>
</blockquote>
<blockquote type="cite"><span>source data and how</span><br>
</blockquote>
<blockquote type="cite"><span>you'd like to import.</span><br>
</blockquote>
<blockquote type="cite"><span></span><br>
</blockquote>
<blockquote type="cite"><span>Giuseppe.</span><br>
</blockquote>
<blockquote type="cite"><span></span><br>
</blockquote>
<blockquote type="cite"><span></span><br>
</blockquote>
<blockquote type="cite"><span>_______________________________________________</span><br>
</blockquote>
<blockquote type="cite"><span>postgis-users mailing list</span><br>
</blockquote>
<blockquote type="cite"><span><a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a></span><br>
</blockquote>
<blockquote type="cite"><span><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></span><br>
</blockquote>
<span>_______________________________________________</span><br>
<span>postgis-users mailing list</span><br>
<span><a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a></span><br>
<span><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></span></div>
</blockquote>
</div>
</body>
</html>