RE: [Qgis-user] Best way to store temperature info
I think Jorge wants to store data just at a single point (not a full raster). Any QGIS datasource would do: sqlite, PostgreSQL, etc. sqlite is easier to exchange with other people, Postgis makes more sense in a centralized multiuser environment. Both have good performance and SQL capabilities, PostgreSQL is of course more powerful. Netcdf would definitely be overkill if one stores temperature values just at a single point. Andreas On Tue, 28 Jun 2011 16:28:41 +0100, M.E.Dodd wrote: I have tried to work with with this format and find it a nightmare to deal with unless you are a experienced programmer and work with this kind of information all the time, i.e. you spend ages learning then its ok, I did not manage to get there. Incidentally can qgis deal with it, think I asked this question a year or two ago and I suspect the answer was no although I may be wrong. -Original Message- From: Noli Sicad [mailto:nsi...@gmail.com] Sent: 28 June 2011 01:06 To: jorge.canel...@binarium.pt Cc: Qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Best way to store temperature info I think the best way is NetCDF. http://en.wikipedia.org/wiki/NetCDF http://www.mail-archive.com/search?q=GDAL+and+.nc+%28netCDF%29+and+qgisl=qgis-user%40lists.osgeo.org Noli On 6/28/11, jorge.canel...@binarium.pt jorge.canel...@binarium.pt wrote: Hi all what do you think is the best way to store temerature data in one poin? using attributes ? like Time, Date , Temp in a simgle point and keep repeating that point ? or can I have something like a relational DB on a shapefile ? or should I use postgis to achieve that ? Thanks Jorge ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
RE: [Qgis-user] Best way to store temperature info
Quite true, what I want to ultimately do is an animation of temerture variations in several areas I was thinking in making a related table to store temepratures for points and areas indexed by date. thanks On Tue, 28 Jun 2011 17:45:09 +0200, Andreas Neumann wrote: I think Jorge wants to store data just at a single point (not a full raster). Any QGIS datasource would do: sqlite, PostgreSQL, etc. sqlite is easier to exchange with other people, Postgis makes more sense in a centralized multiuser environment. Both have good performance and SQL capabilities, PostgreSQL is of course more powerful. Netcdf would definitely be overkill if one stores temperature values just at a single point. Andreas On Tue, 28 Jun 2011 16:28:41 +0100, M.E.Dodd wrote: I have tried to work with with this format and find it a nightmare to deal with unless you are a experienced programmer and work with this kind of information all the time, i.e. you spend ages learning then its ok, I did not manage to get there. Incidentally can qgis deal with it, think I asked this question a year or two ago and I suspect the answer was no although I may be wrong. -Original Message- From: Noli Sicad [mailto:nsi...@gmail.com] Sent: 28 June 2011 01:06 To: jorge.canel...@binarium.pt Cc: Qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Best way to store temperature info I think the best way is NetCDF. http://en.wikipedia.org/wiki/NetCDF http://www.mail-archive.com/search?q=GDAL+and+.nc+%28netCDF%29+and+qgisl=qgis-user%40lists.osgeo.org Noli On 6/28/11, jorge.canel...@binarium.pt jorge.canel...@binarium.pt wrote: Hi all what do you think is the best way to store temerature data in one poin? using attributes ? like Time, Date , Temp in a simgle point and keep repeating that point ? or can I have something like a relational DB on a shapefile ? or should I use postgis to achieve that ? Thanks Jorge ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Best way to store temperature info
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In that case I would propose to store the data in SpatiaLite or Postgis and use the time manager plugin for the animation: http://www.geofrogger.net/trac/wiki Andreas On 06/28/2011 09:52 PM, jorge.canel...@binarium.pt wrote: Quite true, what I want to ultimately do is an animation of temerture variations in several areas I was thinking in making a related table to store temepratures for points and areas indexed by date. thanks On Tue, 28 Jun 2011 17:45:09 +0200, Andreas Neumann wrote: I think Jorge wants to store data just at a single point (not a full raster). Any QGIS datasource would do: sqlite, PostgreSQL, etc. sqlite is easier to exchange with other people, Postgis makes more sense in a centralized multiuser environment. Both have good performance and SQL capabilities, PostgreSQL is of course more powerful. Netcdf would definitely be overkill if one stores temperature values just at a single point. Andreas On Tue, 28 Jun 2011 16:28:41 +0100, M.E.Dodd wrote: I have tried to work with with this format and find it a nightmare to deal with unless you are a experienced programmer and work with this kind of information all the time, i.e. you spend ages learning then its ok, I did not manage to get there. Incidentally can qgis deal with it, think I asked this question a year or two ago and I suspect the answer was no although I may be wrong. -Original Message- From: Noli Sicad [mailto:nsi...@gmail.com] Sent: 28 June 2011 01:06 To: jorge.canel...@binarium.pt Cc: Qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Best way to store temperature info I think the best way is NetCDF. http://en.wikipedia.org/wiki/NetCDF http://www.mail-archive.com/search?q=GDAL+and+.nc+%28netCDF%29+and+qgisl=qgis-user%40lists.osgeo.org Noli On 6/28/11, jorge.canel...@binarium.pt jorge.canel...@binarium.pt wrote: Hi all what do you think is the best way to store temerature data in one poin? using attributes ? like Time, Date , Temp in a simgle point and keep repeating that point ? or can I have something like a relational DB on a shapefile ? or should I use postgis to achieve that ? Thanks Jorge ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJOCjGMAAoJELiCsGDopvBCeEAH/32s1GCUI0soQiRZSLt0zyeW 2PploWqkz19dvepPtZs/LUOBrZDydxCFfMF9NUJdtIzx4kCeNg0lghmYFstAebGM eun+7FrBT29JsUqJZMNoCX5vMT0r4/cK6WRHhlouGkRBDM5nuiIXxYDlp71vDjSb p999/5loNqG/g74hylF1uQ52FpDrsCF2njzyLB6Wmbl7TP6vN4Y66iyGxvN1olcn qR0zb/stmfZOtrGX/nsmZKNtE+WbWxUCbFMdcoQux6dRAj3ZyoX4QjeQ8XklNBZy iq0Dw2QjqCnaEZ95tUt8cGI7+pF6jh8eJ9y4DJzDQwxZP7eM9o7pcnQPNfY+kxo= =T3z+ -END PGP SIGNATURE- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Best way to store temperature info
Jorge, I did a very similar thing with some air modeling data. The spatial features were vector 'grid' cells. I stored these in PostGIS. For each feature, there was one data measurement for each day of the year and some additional aggregated data values. I stored this data as related tables in the same database. To create animations, I used MapServer to create the individual image slices. I used a URL variable to pass each individual date in to MapServer. MapServer incorporated that value into a query where condition used to pull data from PostGIS, and then it built the associated image. David. On Tue, Jun 28, 2011 at 2:52 PM, jorge.canel...@binarium.pt wrote: Quite true, what I want to ultimately do is an animation of temerture variations in several areas I was thinking in making a related table to store temepratures for points and areas indexed by date. thanks On Tue, 28 Jun 2011 17:45:09 +0200, Andreas Neumann wrote: I think Jorge wants to store data just at a single point (not a full raster). Any QGIS datasource would do: sqlite, PostgreSQL, etc. sqlite is easier to exchange with other people, Postgis makes more sense in a centralized multiuser environment. Both have good performance and SQL capabilities, PostgreSQL is of course more powerful. Netcdf would definitely be overkill if one stores temperature values just at a single point. Andreas On Tue, 28 Jun 2011 16:28:41 +0100, M.E.Dodd wrote: I have tried to work with with this format and find it a nightmare to deal with unless you are a experienced programmer and work with this kind of information all the time, i.e. you spend ages learning then its ok, I did not manage to get there. Incidentally can qgis deal with it, think I asked this question a year or two ago and I suspect the answer was no although I may be wrong. -Original Message- From: Noli Sicad [mailto:nsi...@gmail.com] Sent: 28 June 2011 01:06 To: jorge.canel...@binarium.pt Cc: Qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Best way to store temperature info I think the best way is NetCDF. http://en.wikipedia.org/wiki/NetCDF http://www.mail-archive.com/search?q=GDAL+and+.nc+%28netCDF%29+and+qgisl=qgis-user%40lists.osgeo.org Noli On 6/28/11, jorge.canel...@binarium.pt jorge.canel...@binarium.pt wrote: Hi all what do you think is the best way to store temerature data in one poin? using attributes ? like Time, Date , Temp in a simgle point and keep repeating that point ? or can I have something like a relational DB on a shapefile ? or should I use postgis to achieve that ? Thanks Jorge ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Best way to store temperature info
Hi all what do you think is the best way to store temerature data in one poin? using attributes ? like Time, Date , Temp in a simgle point and keep repeating that point ? or can I have something like a relational DB on a shapefile ? or should I use postgis to achieve that ? Thanks Jorge ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user