[postgis-users] GDAL Netcdf point data to PostGIS?

Peter Baumann p.baumann at jacobs-university.de
Wed Aug 5 10:35:59 PDT 2015


wise words, Gerry! A good thing today is that we have choice.
cheers,
Peter


On 2015-08-04 19:03, Gerry Creager - NOAA Affiliate wrote:
> Hi, Peter
>
> There are times where WCS is appropriate, and times when WMS is more than
> satisfactory. In fact, when I was doing this before, the WFS point
> presentation also maintained semantics, and facilitated postprocessing. The
> sparse nature of surface and upper air observations don't lend themselves, as
> easily, to a coverage.
>
> Thanks!
> gerry
>
> On Tue, Aug 4, 2015 at 6:36 AM, Peter Baumann <p.baumann at jacobs-university.de
> <mailto:p.baumann at jacobs-university.de>> wrote:
>
>     hm, when it is about data analysis in addition to display, did you
>     consider OGC WCS [1] ? As opposed to WMS (which delivers color imagery for
>     human consumption), a WCS retains original semantics of values useful for
>     further processing.
>     Its Core Reference Implementation allows you to store georeferenced NetCDF
>     data in PostgreSQL.
>     -Peter
>
>     [1] http://en.wikipedia.org/wiki/Web_Coverage_Service
>
>
>     On 2015-08-04 01:05, Gerry Creager - NOAA Affiliate wrote:
>>     Georeferenced point data. Each site, in each netcdf, has the coordinates
>>     for the site, as well as the observations (temp, dew point, humidity,
>>     pressure, wind variables, etc.).
>>
>>     I'm looking for a faster interface to postGis than the sloppy code I
>>     originally wrote to take it to a csv and then drive it into the database.
>>     I use it for a variety of purposes, ranging from a web display of weather
>>     obs, to a misued OGC WMS and WFS output, to a potential input for data
>>     assimilation for weather models.
>>
>>     gerry
>>
>>     On Mon, Aug 3, 2015 at 7:44 PM, Andy Colson <andy at squeakycode.net
>>     <mailto:andy at squeakycode.net>> wrote:
>>
>>         On 08/03/2015 01:27 PM, Gerry Creager - NOAA Affiliate wrote:
>>
>>             I might be posting to the wrong forum but... would this work? We
>>             aggregate meteorological surface data in netcdf form, and I'd
>>             like to populate a database with it..
>>             Thanks
>>             gerry
>>             --
>>             Gerry Creager
>>             NSSL/CIMMS
>>             405.325.6371 <tel:405.325.6371>
>>             ++++++++++++++++++++++
>>             “Big whorls have little whorls,
>>             That feed on their velocity;
>>             And little whorls have lesser whorls,
>>             And so on to viscosity.”
>>             Lewis Fry Richardson (1881-1953)
>>
>>
>>         Is it gis data (latitude/longitude type stuff)?  Or is it something
>>         else (like temperature)?
>>
>>         How would you like to use it in Postgres?  What kind of sum()'s and
>>         where's are you going to write?
>>
>>         -Andy
>>         _______________________________________________
>>         postgis-users mailing list
>>         postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
>>         http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>>
>>
>>
>>     -- 
>>     Gerry Creager
>>     NSSL/CIMMS
>>     405.325.6371 <tel:405.325.6371>
>>     ++++++++++++++++++++++
>>     “Big whorls have little whorls,
>>     That feed on their velocity; 
>>     And little whorls have lesser whorls, 
>>     And so on to viscosity.” 
>>     Lewis Fry Richardson (1881-1953)
>>
>>
>>     _______________________________________________
>>     postgis-users mailing list
>>     postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
>>     http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>     -- 
>     Dr. Peter Baumann
>      - Professor of Computer Science, Jacobs University Bremen
>        www.faculty.jacobs-university.de/pbaumann <http://www.faculty.jacobs-university.de/pbaumann>
>        mail: p.baumann at jacobs-university.de <mailto:p.baumann at jacobs-university.de>
>        tel: +49-421-200-3178 <tel:%2B49-421-200-3178>, fax: +49-421-200-493178 <tel:%2B49-421-200-493178>
>      - Executive Director, rasdaman GmbH Bremen (HRB 26793)
>        www.rasdaman.com <http://www.rasdaman.com>, mail: baumann at rasdaman.com <mailto:baumann at rasdaman.com>
>        tel: 0800-rasdaman, fax: 0800-rasdafax, mobile: +49-173-5837882 <tel:%2B49-173-5837882>
>     "Si forte in alienas manus oberraverit hec peregrina epistola incertis ventis dimissa, sed Deo commendata, precamur ut ei reddatur cui soli destinata, nec preripiat quisquam non sibi parata." (mail disclaimer, AD 1083)
>
>
>
>     _______________________________________________
>     postgis-users mailing list
>     postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
>     http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
>
>
> -- 
> Gerry Creager
> NSSL/CIMMS
> 405.325.6371
> ++++++++++++++++++++++
> “Big whorls have little whorls,
> That feed on their velocity; 
> And little whorls have lesser whorls, 
> And so on to viscosity.” 
> Lewis Fry Richardson (1881-1953)
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

-- 
Dr. Peter Baumann
 - Professor of Computer Science, Jacobs University Bremen
   www.faculty.jacobs-university.de/pbaumann
   mail: p.baumann at jacobs-university.de
   tel: +49-421-200-3178, fax: +49-421-200-493178
 - Executive Director, rasdaman GmbH Bremen (HRB 26793)
   www.rasdaman.com, mail: baumann at rasdaman.com
   tel: 0800-rasdaman, fax: 0800-rasdafax, mobile: +49-173-5837882
"Si forte in alienas manus oberraverit hec peregrina epistola incertis ventis dimissa, sed Deo commendata, precamur ut ei reddatur cui soli destinata, nec preripiat quisquam non sibi parata." (mail disclaimer, AD 1083)


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150805/56fa5ef6/attachment.html>


More information about the postgis-users mailing list