From: | Mike Charles <gamemusicmaker(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Storing data on a regular lat/lon grid |
Date: | 2010-03-26 19:25:58 |
Message-ID: | bced44b41003261225i627e2c90q1bbf28064d1f1a48@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I have temperature data that has been interpolated to a regular lat/lon
grid. I have one grid per day.
I want to be able to select points within a certain region, and within a
certain time period.
Now, I could store each grid point as a separate record (a new row for every
single point/time, with columns lat, lon, time, temperature), but since my
grid is constant, there's a lot of redundancy there, no? Disk space is
somewhat of a constraint, since there are a lot of files.
Basically, has anyone done any work with storing gridded spatial data? I see
lot's of info on Geospatial data, but it's usually cities, stations, etc.,
not a regular grid that doesn't change...
I also noticed that PostGIS does not support raster data...
Thanks a lot,
--
Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2010-03-26 19:27:25 | Re: Solid State Drives with PG |
Previous Message | Gaietti, Mauro (SELEX GALILEO Guest, Italy) | 2010-03-26 19:17:38 | R: round(x) function |