[Qgis-user] Best way to store temperature info

David Fawcett david.fawcett at gmail.com
Tue Jun 28 13:41:46 PDT 2011


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.canelhas at 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:nsicad at gmail.com]
>>> Sent: 28 June 2011 01:06
>>> To: jorge.canelhas at binarium.pt
>>> Cc: Qgis-user at 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+qgis&l=qgis-user%40lists.osgeo.org
>>>
>>> Noli
>>>
>>> On 6/28/11, jorge.canelhas at binarium.pt <jorge.canelhas at 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 at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>



More information about the Qgis-user mailing list