Storing data on a regular lat/lon grid

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

Responses

Browse pgsql-general by date

  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